查询JSP页面
<!doctype html>
<%@include file="/internet/common.jsp"%>
<!-- 新样式右侧菜单共用CSS和部分JS:在页面最前 -->
<%@include file="/ChangeFbrole/pageMain/Common_RightMenu.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>告警接单人查询</title>
<script src="/ChangeFbrole/pgYunWei/scripts/QueryStaff.js" type="text/javascript"></script> <script language="javascript">
var userID = '<bean:write property="SessionEntity/userID"/>';
var RegionID = '<bean:write property="SessionEntity/RegionID"/>';
// 查询条件
var search_input = '<bean:write property="search_input"/>';
// 工单调度条件
var dispatch = '';
</script>
</head>
<body scroll="no">
<!-- 告警方式-->
<html:hidden property="currentstate" value="1" />
<!--查询SQL-->
<html:hidden property="sToSelectSql" value="" />
<!--过长的查询SQL-->
<html:hidden property="sToSelectSql2" value="" />
<!--查询条件-->
<html:hidden property="queryCond/Entity" value="" />
<div class="autoheight"> <h2><b>告警接单人查询</b> <span> </span></h2> <div class="boxEdit" id='toolbar' style="padding-top: 10px;">
<div class="boxEditItem">
<p class="th_title">ITSM工号:</p>
<div class="textInputWrap w480"><input id='itsmno' class="textInput" type="text" value="请输入ITSM工号" onfocus="if(value=='请输入ITSM工号'){value=''}" onblur="if(value==''){value='请输入ITSM工号'}" /></div>
<div class="btnWrap"><a class="btn btnNormal" href="###" onclick="query()"><span></span><i>搜索</i></a></div>
<div class="btnWrap"><span class="tr_h">精简筛选条件</span></div>
</div> <div class="boxEditItem">
<p class="th_title">姓名:</p>
<div class="textInputWrap w190"><input id="staffname" class="textInput" type="text" value="请输入姓名" onfocus="if(value=='请输入姓名'){value=''}" onblur="if(value==''){value='请输入姓名'}" /></div>
<p class="th_title" id="bsn">BSN工号:</p>
<div class="textInputWrap w190" id="bsndiv"><input id="bsnid" class="textInput" type="text" value="请输入BSN工号" onfocus="if(value=='请输入BSN工号'){value=''}" onblur="if(value==''){value='请输入BSN工号'}" /></div>
</div> <div class="boxEditItem">
<p class="th_title">告警:</p>
<div>
<a class="tags active" href="####" onclick="stateClick('1',this)">BSN告警</a>
<a class="tags" href="####" onclick="stateClick('2',this)">IT基础设施告警</a>
</div>
</div> <div class="fn-clear"></div> </div>
<div id="datadiv1">
<table id='table1' style="width:799px; "></table>
</div>
<table id="ordertable" style="width:799px;" >
</table> <!-- BSN接单人增加窗口start -->
<div id="WinViewAdd" class="easyui-window" title="新增BSN接单人" data-options="iconCls:'icon-save',closed:true,minimizable:false,top:'0',right:'100'" style="width:500px;height:330px;padding:10px;">
<form id="viewaddform" name="viewaddform" style="padding:10px 20px 10px 40px;">
<div class="boxEditItem">
<p class="th_title"><span>*</span>BSN工号:</p>
<div class="textInputWrap w190"><input name="ITSM_BSN_STAFF/STAFF_ID" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> BSN工号不能为空</em></div>
</div> <div class="boxEditItem">
<p class="th_title"><span>*</span>姓名:</p>
<div class="textInputWrap w190"><input name="ITSM_BSN_STAFF/STAFF_NAME" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> 姓名不能为空</em></div>
</div> <div class="boxEditItem">
<p class="th_title"><span>*</span>联系电话:</p>
<div class="textInputWrap w190"><input name="ITSM_BSN_STAFF/STAFF_PHONE" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> 联系电话不能为空</em></div>
</div> <div class="boxEditItem">
<p class="th_title"><span>*</span>综服工号:</p>
<div class="textInputWrap w190"><input name="ITSM_BSN_STAFF/ITSM_STAFF_ID" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> 综服工号不能为空</em></div>
</div> <div class="boxEditItem">
<p class="th_title"><span>*</span>ITSM工号:</p>
<div class="textInputWrap w190"><input name="ITSM_BSN_STAFF/NEW_ITSM_STAFF_ID" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> ITSM工号不能为空</em></div>
</div> <div class="fn-clear h10"></div>
<div class="boxEditItem">
<p class="th_title"> </p>
<div>
<a class="btnLarge" href="####" onclick="addBsnStaffView()"><i>保 存</i></a>
<a class="btnLarge btnGray" href="####" onclick="$('#viewaddform')[0].reset()"><i>重 置</i></a>
</div>
</div>
</form>
</div>
<!-- BSN接单人增加窗口end --> <!-- BSN接单人修改窗口start -->
<div id="WinViewEdit" class="easyui-window" title="修改BSN接单人信息" data-options="iconCls:'icon-save',closed:true,minimizable:false,top:'0',right:'120'" style="width:500px;height:400px;padding:10px;">
<form id="vieweditform" name="vieweditform" style="padding:10px 20px 10px 40px;">
<input type="hidden" name="ITSM_BSN_STAFF/ID" />
<input type="hidden" name="updateChk" >
<div class="fn-clear h10"></div>
<div class="boxEdit">
<div class="boxEditItem">
<p class="th_title"><span>*</span>BSN工号:</p>
<div class="textInputWrap w190"><input name="ITSM_BSN_STAFF/STAFF_ID" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> BSN工号不能为空</em></div>
</div>
<div class="boxEditItem">
<p class="th_title"><span>*</span>姓名:</p>
<div class="textInputWrap w190"><input name="ITSM_BSN_STAFF/STAFF_NAME" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> 姓名不能为空</em></div>
</div>
<div class="boxEditItem">
<p class="th_title"><span>*</span>联系电话:</p>
<div class="textInputWrap w190"><input name="ITSM_BSN_STAFF/STAFF_PHONE" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> 联系电话不能为空</em></div>
</div>
<div class="boxEditItem">
<p class="th_title"><span>*</span>综服工号:</p>
<div class="textInputWrap w190"><input name="ITSM_BSN_STAFF/ITSM_STAFF_ID" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> 综服工号不能为空</em></div>
</div>
<div class="boxEditItem">
<p class="th_title"><span>*</span>ITSM工号:</p>
<div class="textInputWrap w190"><input name="ITSM_BSN_STAFF/NEW_ITSM_STAFF_ID" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> ITSM工号不能为空</em></div>
</div> <div class="fn-clear h10"></div> <div class="boxEditItem">
<p class="th_title"> </p>
<div>
<a class="btnLarge" href="####" onclick="UpdateBsnView()"><i>保 存</i></a>
</div>
</div>
</div>
<div class="fn-clear h5"></div>
</form>
</div>
<!-- BSN接单人修改窗口end --> <!-- IT基础设施告警接单人增加窗口start -->
<div id="WinViewAddIt" class="easyui-window" title="新增IT基础设施告警接单人" data-options="iconCls:'icon-save',closed:true,minimizable:false,top:'0',right:'100'" style="width:500px;height:330px;padding:10px;">
<form id="viewItaddform" name="viewItaddform" style="padding:10px 20px 10px 40px;">
<div class="boxEditItem">
<p class="th_title"><span>*</span>ITSM工号:</p>
<div class="textInputWrap w190"><input name="ITSM_C_ITJJSS_STAFF/STAFF_ID" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> ITSM工号不能为空</em></div>
</div> <div class="boxEditItem">
<p class="th_title"><span>*</span>姓名:</p>
<div class="textInputWrap w190"><input name="ITSM_C_ITJJSS_STAFF/STAFF_NAME" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> 姓名不能为空</em></div>
</div> <div class="boxEditItem">
<p class="th_title"><span>*</span>联系电话:</p>
<div class="textInputWrap w190"><input name="ITSM_C_ITJJSS_STAFF/STAFF_PHONE" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> 联系电话不能为空</em></div>
</div> <div class="fn-clear h10"></div>
<div class="boxEditItem">
<p class="th_title"> </p>
<div>
<a class="btnLarge" href="####" onclick="addItStaffView()"><i>保 存</i></a>
<a class="btnLarge btnGray" href="####" onclick="$('#viewItaddform')[0].reset()"><i>重 置</i></a>
</div>
</div>
</form>
</div>
<!-- IT基础设施告警接单人增加窗口end --> <!-- IT基础设施告警接单人修改窗口start -->
<div id="WinViewEditIt" class="easyui-window" title="修改IT基础设施告警接单人信息" data-options="iconCls:'icon-save',closed:true,minimizable:false,top:'0',right:'120'" style="width:500px;height:400px;padding:10px;">
<form id="vieweditItform" name="vieweditItform" style="padding:10px 20px 10px 40px;">
<input type="hidden" name="ITSM_C_ITJJSS_STAFF/ID" />
<input type="hidden" name="updateChk" >
<div class="fn-clear h10"></div>
<div class="boxEdit">
<div class="boxEditItem">
<p class="th_title"><span>*</span>ITSM工号:</p>
<div class="textInputWrap w190"><input name="ITSM_C_ITJJSS_STAFF/STAFF_ID" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> ITSM工号不能为空</em></div>
</div>
<div class="boxEditItem">
<p class="th_title"><span>*</span>姓名:</p>
<div class="textInputWrap w190"><input name="ITSM_C_ITJJSS_STAFF/STAFF_NAME" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> 姓名不能为空</em></div>
</div>
<div class="boxEditItem">
<p class="th_title"><span>*</span>联系电话:</p>
<div class="textInputWrap w190"><input name="ITSM_C_ITJJSS_STAFF/STAFF_PHONE" class="textInput" type="text"/></div>
<div class="edit_red" style="display: none;"><em class="col_red"> 联系电话不能为空</em></div>
</div> <div class="fn-clear h10"></div> <div class="boxEditItem">
<p class="th_title"> </p>
<div>
<a class="btnLarge" href="####" onclick="UpdateItView()"><i>保 存</i></a>
</div>
</div>
</div>
<div class="fn-clear h5"></div>
</form>
</div>
<!-- IT基础设施告警接单人修改窗口end --> <!-- 页面底部留白 -->
<div class="clearfix h10"></div>
</div>
</body>
</html>
query.jsp
增删改查js
// 获取查询列表json数据的链接
var queryUrl = "";
// 第一次加载标志位。
var loadState = 0;
$(document).ready(function(){
SERVICEDATAGRID = $('#ordertable');
CreateParam();
// 设置查询链接
joinUrl();
loadgrid(); });
/**
* 接单人查询
*/
function query(){
// 查询时设置按钮不可用,防止重复查询
// 创建查询语句和查询条件
CreateParam();
// 设置查询链接
joinUrl();
$("#ordertable").datagrid('options').url = queryUrl;
$("#ordertable").datagrid('load');
//alert($("input[name='currentstate']").val());
//当查询IT基础设施的时候隐藏BSN工号、综服工号列
if($("input[name='currentstate']").val()==2){
$('#ordertable').datagrid('hideColumn','STAFF_ID');
$('#ordertable').datagrid('hideColumn','ITSM_STAFF_ID');
document.getElementById("bsn").style.display="none";
document.getElementById("bsnid").style.display="none";
document.getElementById("bsndiv").style.display="none";
//$('#bsnid').hide();
}else{
$('#ordertable').datagrid('showColumn','STAFF_ID');
$('#ordertable').datagrid('showColumn','ITSM_STAFF_ID');
document.getElementById("bsn").style.display="";
document.getElementById("bsnid").style.display="";
document.getElementById("bsndiv").style.display="";
}
// 清空选中行
SERVICEDATAGRID.datagrid('clearSelections');
}
// 选择告警
function stateClick(status,Obj){
$(Obj).parent().find('a').removeClass().addClass("tags");
$(Obj).removeClass().addClass("tags active");
$("input[name='currentstate']").val(status);
query();
} /**
* 创建查询语句
*/
function CreateParam(){
// ITSM工号
var itsmBaseID = $('#itsmno').val();
if(itsmBaseID == '请输入ITSM工号'){
itsmBaseID = "";
}
// 工单类型
var StaffName = $('#staffname').val();
if(StaffName == '请输入姓名'){
StaffName = "";
}
// BSN工号
var BsnId = $('#bsnid').val();
if(BsnId == '请输入BSN工号'){
BsnId = "";
}
// 告警
var CURRENTSTATE= $("input[name='currentstate']").val(); // 忽略空格
itsmBaseID = itsmBaseID.replace(/\s/g,'');
StaffName = StaffName.replace(/\s/g,'');
BsnId = BsnId.replace(/\s/g,''); var i=0;
var dt=[];
var Sql="";
if(CURRENTSTATE==1){
Sql = "SELECT a.ID,a.STAFF_ID,a.STAFF_NAME,a.STAFF_PHONE,a.ITSM_STAFF_ID,a.NEW_ITSM_STAFF_ID,a.UPDATE_TIME FROM itsm.ITSM_BSN_STAFF a where 1=1 ";
}else{
Sql = "select a.ID,'' as STAFF_ID,a.STAFF_NAME,a.STAFF_PHONE,'' as ITSM_STAFF_ID,a.STAFF_ID as NEW_ITSM_STAFF_ID,a.UPDATE_TIME from itsm.ITSM_C_ITJJSS_STAFF a where 1=1 ";
}
var whereSql = "";
if(BsnId!=""){
if(CURRENTSTATE==1){
whereSql = whereSql +" and a.STAFF_ID like {eos_string}" ;
dt.push({name:'FormEntity/A'+i++,value: '¥'+BsnId+'¥'});
}
}
if(StaffName!=""){
whereSql = whereSql +" and a.STAFF_NAME like {eos_string}" ;
dt.push({name:'FormEntity/A'+i++,value: '¥'+StaffName+'¥'});
}
if(itsmBaseID!=""){
if(CURRENTSTATE==1){
whereSql = whereSql +" and a.NEW_ITSM_STAFF_ID like {eos_string}" ;
dt.push({name:'FormEntity/A'+i++,value: '¥'+itsmBaseID+'¥'});
}else{
whereSql = whereSql +" and a.STAFF_ID like {eos_string}" ;
dt.push({name:'FormEntity/A'+i++,value: '¥'+itsmBaseID+'¥'});
}
}
var Sql = Sql+whereSql;
var order = " order by a.ID desc";
var xmlSql="<FormEntity>";
for(var k=0;k<dt.length;k++){
var tempNode=dt[k].name;
xmlSql+="<"+tempNode.substring(tempNode.indexOf("/")+1)+">"+dt[k].value+"</"+tempNode.substring(tempNode.indexOf("/")+1)+">";
}
xmlSql+="</FormEntity>";
// 由于url字符串长度限制,所以当长度大于1800时则自动截取,sToSelectSql2中不能有中文!
if(Sql.length > 1800){
$("input[name='sToSelectSql']").val(Sql.substr(0,1500));
$("input[name='sToSelectSql2']").val(Sql.substr(1500));
}else{
$("input[name='sToSelectSql']").val(Sql);
$("input[name='sToSelectSql2']").val("");
}
$("input[name='queryCond/Entity']").val(xmlSql);
}
// 查询url
function joinUrl(){
queryUrl = 'ChangeFbrole.prYunWei.prStaffQueryAll.do?sToSelectSql='+$('input[name="sToSelectSql"]').val()+"&queryCond/Entity="+$('input[name="queryCond/Entity"]').val();
}
/*
* 创建列表
*/
function loadgrid(){ $('#ordertable').datagrid({
// 设置宽高
width:'799',
// 可折叠
collapsible:true,
// 查询条件
toolbar: toolbar,
// 标题
title:'告警接单人查询列表',
// 表格自适应当前页面大小
fit:false,
// 长度超出列宽时自动截取
nowrap: false,
// 列自适应表格大小
fitColumns:true,
// 是否只能选中一行
singleSelect:false,
// 选中一行时则选中当前行的复选框
selectOnCheck:true,
// 查询逻辑逻辑
url:queryUrl,
// 排序字段,传入后台
sortName: 'STAFF_ID',
// 排序方式,传入后台
sortOrder: 'desc',
// 返回行样式
rowStyler:function(index,row){
if(row.PROCESSTIMEOUT == "Y"){
if(row.ACTIVITYTIMEOUT == "N"){
return "background-color: orange;color:#fff;";
}else{
return "background-color: red;color:#fff;";
}
}
},
// 查询参数
queryParams:{
/* 查询条件
* 拼接查询字段传入后台。
* 注意:查询条件的中文会出现乱码,所以存在中文的条件放在url?之后。
* 必须使用存在中文的查询参数时,需要进行编码之后传入后台进行解码
*/
'SortOrder/order':function(){ var ordersql = ""; sortName = $('#ordertable').datagrid('options').sortName; sortOrder = $('#ordertable').datagrid('options').sortOrder; ordersql = " order by " + sortName + " " + sortOrder; return ordersql;
}, 'PageCond/begin':function (){
var begin = 0;
// 每页记录数
var size = $('#ordertable').datagrid('getPager').pagination('options').pageSize;
// 页码
var page = $('#ordertable').datagrid('getPager').pagination('options').pageNumber;
if(page > 1){
begin = size * (page - 1);
}
return begin;
}, 'PageCond/length':function (){return $('#ordertable').datagrid('getPager').pagination('options').pageSize;}, 'fresh':false, 'dispatch':'', 'ReplaceType':1, 'sToSelectSql2':function (){return $('input[name="sToSelectSql2"]').val();} },
// 是否从服务器获取数据进行排序
remoteSort: true,
// id字段
idField:'ID',
// 设置标题和对应列数据的id
columns:[[ /*
*field:必须。对应查询结果的字段名称。
*titile:必须。对应列显示标题。
*width:必须。按照比例显示列宽。
*sortable:可选。是否可以排序。
*formatter:可选。格式化。
*hidden:可选。是否隐藏列。
*/
{field:'ck',checkbox:true}, {field:'ID',title:'id',hidden:true}, {field:'STAFF_ID',title:'BSN工号',width:2.5*80,align:'center',sortable:true}, {field:'STAFF_NAME',title:'姓名',width:2*80,align:'center',sortable:true}, {field:'STAFF_PHONE',title:'联系电话',width:2*80,align:'center',sortable:true}, {field:'ITSM_STAFF_ID',title:'综服工号',width:2*80,align:'center',sortable:true,hidden:true}, {field:'NEW_ITSM_STAFF_ID',title:'ITSM工号',width:2*80,align:'center',sortable:true}, {field:'UPDATE_TIME',title:'更新时间',width:2*80,align:'center',sortable:true,formatter:formatUpdateTime}, ]],
// 是否可以分页
pagination:true,
// 从第几页开始显示
pageNumber:1,
// 每页显示记录数
pageSize:10,
// 可供选择的每页记录数
pageList:[10],
// 是否显示行数:这里的行是显示所有记录的行,总数太多时不建议使用,因为默认的行列无法自适应,总数超过4位数时就无法全部显示。
rownumbers:false,
// 在请求载入数据之前触发,如果返回false将取消载入。
onBeforeLoad:function(){
},
// 当数据载入成功时触发:列表查询完成时使查询按钮可用
onLoadSuccess:function(){
},
// 当载入远程数据发生错误时触发。
onLoadError:function(){
$.messager.alert("提示信息","数据载入失败!","error");
}
});
} // 表格按钮
var toolbar = [{
text:'增加',
iconCls:'icon-add',
handler:function(){
//alert($("input[name='currentstate']").val());
if($("input[name='currentstate']").val()==1){
$('#viewaddform')[0].reset(); // 重置表单元素
$('#WinViewAdd').window('open'); // 打开服务增加窗口
}else{
$('#viewItaddform')[0].reset(); // 重置表单元素
$('#WinViewAddIt').window('open'); // 打开服务增加窗口
}
}
},{
text:'删除',
iconCls:'icon-remove',
handler:function(){
var row = SERVICEDATAGRID.datagrid('getSelections');
if(row.length == 0){
$.messager.alert('提示信息','请先选中一行!','warning');
}else{
$.messager.confirm('提示信息', '是否确认删除选中接单人?', function(r){
if (r){
if($("input[name='currentstate']").val()==1){
delBsnStaffViews();
}else{
delItStaffViews();
}
}
});
}
}
},{
text:'修改',
iconCls:'icon-edit',
handler:function(){
var row = SERVICEDATAGRID.datagrid('getSelections');
if(row.length == 0){
$.messager.alert('提示信息','请先选中一行!','warning');
}else if(row.length > 1){
$.messager.alert('提示信息','修改时只能选中一行!','warning');
}else{
if($("input[name='currentstate']").val()==1){
// 打开修改界面
$('#WinViewEdit').window('open');
// 赋值
var editObj = $('#vieweditform');
editObj.find("input[name='ITSM_BSN_STAFF/STAFF_ID']").val(row[0]['STAFF_ID']);
editObj.find("input[name='ITSM_BSN_STAFF/STAFF_NAME']").val(row[0]['STAFF_NAME']);
editObj.find("input[name='ITSM_BSN_STAFF/STAFF_PHONE']").val(row[0]['STAFF_PHONE']);
editObj.find("input[name='ITSM_BSN_STAFF/ITSM_STAFF_ID']").val(row[0]['ITSM_STAFF_ID']);
editObj.find("input[name='ITSM_BSN_STAFF/NEW_ITSM_STAFF_ID']").val(row[0]['NEW_ITSM_STAFF_ID']);
editObj.find("input[name='ITSM_BSN_STAFF/ID']").val(row[0]['ID']);
}else{
// 打开修改界面
$('#WinViewEditIt').window('open');
// 赋值
var editObj = $('#vieweditItform');
editObj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_ID']").val(row[0]['NEW_ITSM_STAFF_ID']);
editObj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_NAME']").val(row[0]['STAFF_NAME']);
editObj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_PHONE']").val(row[0]['STAFF_PHONE']);
editObj.find("input[name='ITSM_C_ITJJSS_STAFF/ID']").val(row[0]['ID']);
}
}
}
}];
/**
保存新增BSN接单人
*/
function addBsnStaffView(){
// 定义所属form
var formobj = $('#viewaddform');
var staffId = formobj.find("input[name='ITSM_BSN_STAFF/STAFF_ID']").val();
var staffName = formobj.find("input[name='ITSM_BSN_STAFF/STAFF_NAME']").val();
var staffPhone = formobj.find("input[name='ITSM_BSN_STAFF/STAFF_PHONE']").val();
var issId = formobj.find("input[name='ITSM_BSN_STAFF/ITSM_STAFF_ID']").val();
var itsmId = formobj.find("input[name='ITSM_BSN_STAFF/NEW_ITSM_STAFF_ID']").val(); if(staffId == ""){
$.messager.alert('提示信息','BSN工号不能为空!','warning');
formobj.find("input[name='ITSM_BSN_STAFF/STAFF_ID']").parent().parent().find('.edit_red').show(); // 显示红字提示信息
return;
}else if(staffName == ""){
$.messager.alert('提示信息','姓名不能为空!','warning');
formobj.find("input[name='ITSM_BSN_STAFF/STAFF_NAME']").parent().parent().find('.edit_red').show();
return;
}else if(staffPhone == ""){
$.messager.alert('提示信息','联系电话不能为空!','warning');
formobj.find("input[name='ITSM_BSN_STAFF/STAFF_PHONE']").parent().parent().find('.edit_red').show();
return;
}else if(issId == ""){
$.messager.alert('提示信息','综服工号不能为空!','warning');
formobj.find("input[name='ITSM_BSN_STAFF/ITSM_STAFF_ID']").parent().parent().find('.edit_red').show();
return;
}else if(itsmId == ""){
$.messager.alert('提示信息','综服工号不能为空!','warning');
formobj.find("input[name='ITSM_BSN_STAFF/NEW_ITSM_STAFF_ID']").parent().parent().find('.edit_red').show();
return;
} var sub = new HiddenSubmit("ChangeFbrole.bizYunWei.bizSaveBsnStaff");
if(sub.submitForm(document.forms.viewaddform)){
// 保存成功提示信息,显示1秒
$.messager.show({
title:'提示信息',
msg:'增加成功.',
timeout:1000,
style:{
right:'',
top:'150'
}
});
//关闭增加窗口
$('#WinViewAdd').window('close');
//刷新表格
SERVICEDATAGRID.datagrid('load');
}else{
$.messager.alert('提示信息','保存失败!','error');
}
}
//删除BSN接单人
function delBsnStaffViews(){
var selects = SERVICEDATAGRID.datagrid('getSelections');
var sub = new HiddenSubmit('ChangeFbrole.bizYunWei.bizDelBsnStaffViews');
var xmlstr = ''
for(var i=0;i<selects.length;i++){
xmlstr = xmlstr + '<ITSM_BSN_STAFF><ID>' + selects[i]['ID'] + '</ID></ITSM_BSN_STAFF>'
}
sub.add('xmlstr',xmlstr);
if(sub.submit()){
// 删除成功提示信息,显示1秒
$.messager.show({
title:'提示信息',
msg:'删除成功.',
timeout:1000,
style:{
right:'',
top:'150'
}
});
//刷新表格
SERVICEDATAGRID.datagrid('load');
// 清空选中行
SERVICEDATAGRID.datagrid('clearSelections');
}else{
$.messager.alert('提示信息','删除失败!','error');
};
}
//修改Bsn接单人信息
function UpdateBsnView(){
// 定义所属form
var formobj = $('#vieweditform');
var staffId = formobj.find("input[name='ITSM_BSN_STAFF/STAFF_ID']").val();
var staffName = formobj.find("input[name='ITSM_BSN_STAFF/STAFF_NAME']").val();
var staffPhone = formobj.find("input[name='ITSM_BSN_STAFF/STAFF_PHONE']").val();
var issId=formobj.find("input[name='ITSM_BSN_STAFF/ITSM_STAFF_ID']").val();
var itsmId=formobj.find("input[name='ITSM_BSN_STAFF/NEW_ITSM_STAFF_ID']").val();
var sc_id=formobj.find("input[name='ITSM_BSN_STAFF/ID']").val(); if(staffId == ""){
$.messager.alert('提示信息','BSN工号不能为空!','warning');
formobj.find("input[name='ITSM_BSN_STAFF/STAFF_ID']").parent().parent().find('.edit_red').show();
return;
}else if(staffName == ""){
$.messager.alert('提示信息','姓名不能为空!','warning');
formobj.find("input[name='ITSM_BSN_STAFF/STAFF_NAME']").parent().parent().find('.edit_red').show();
return;
}else if(staffPhone == ""){
$.messager.alert('提示信息','联系电话不能为空!','warning');
formobj.find("input[name='ITSM_BSN_STAFF/STAFF_PHONE']").parent().parent().find('.edit_red').show();
return;
}else if(itsmId == ""){
$.messager.alert('提示信息','ITSM工号不能为空!','warning');
formobj.find("input[name='ITSM_BSN_STAFF/NEW_ITSM_STAFF_ID']").parent().parent().find('.edit_red').show();
return;
} var sub = new HiddenSubmit("ChangeFbrole.bizYunWei.bizUpdateBsnView");
if(sub.submitForm(document.forms.vieweditform)){
sub.add('ITSM_BSN_STAFF/ID',sc_id);
// 保存成功提示信息,显示1秒
$.messager.show({
title:'提示信息',
msg:'修改成功.',
timeout:1000,
style:{
right:'',
top:'150'
}
});
//关闭增加窗口
$('#WinViewEdit').window('close');
//刷新当前页
SERVICEDATAGRID.datagrid('reload');
}else{
$.messager.alert('提示信息','保存失败!','error');
};
} /**
保存新增IT基础设施接单人
*/
function addItStaffView(){
// 定义所属form
var formobj = $('#viewItaddform');
var staffId = formobj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_ID']").val();
var staffName = formobj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_NAME']").val();
var staffPhone = formobj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_PHONE']").val(); if(staffId == ""){
$.messager.alert('提示信息','ITSM工号不能为空!','warning');
formobj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_ID']").parent().parent().find('.edit_red').show(); // 显示红字提示信息
return;
}else if(staffName == ""){
$.messager.alert('提示信息','姓名不能为空!','warning');
formobj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_NAME']").parent().parent().find('.edit_red').show();
return;
}else if(staffPhone == ""){
$.messager.alert('提示信息','联系电话不能为空!','warning');
formobj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_PHONE']").parent().parent().find('.edit_red').show();
return;
}
//$("input[name='currentstate']").val()
var sub = new HiddenSubmit("ChangeFbrole.bizYunWei.bizSaveItStaff");
if(sub.submitForm(document.forms.viewItaddform)){
// 保存成功提示信息,显示1秒
$.messager.show({
title:'提示信息',
msg:'增加成功.',
timeout:1000,
style:{
right:'',
top:'150'
}
});
//关闭增加窗口
$('#WinViewAddIt').window('close');
//刷新表格
SERVICEDATAGRID.datagrid('load');
}else{
$.messager.alert('提示信息','保存失败!','error');
}
} //删除IT基础设施告警接单人
function delItStaffViews(){
var selects = SERVICEDATAGRID.datagrid('getSelections');
var sub = new HiddenSubmit('ChangeFbrole.bizYunWei.bizDelItStaffViews');
var xmlstr = ''
for(var i=0;i<selects.length;i++){
xmlstr = xmlstr + '<ITSM_C_ITJJSS_STAFF><ID>' + selects[i]['ID'] + '</ID></ITSM_C_ITJJSS_STAFF>'
}
sub.add('xmlstr',xmlstr);
if(sub.submit()){
// 删除成功提示信息,显示1秒
$.messager.show({
title:'提示信息',
msg:'删除成功.',
timeout:1000,
style:{
right:'',
top:'150'
}
});
//刷新表格
SERVICEDATAGRID.datagrid('load');
// 清空选中行
SERVICEDATAGRID.datagrid('clearSelections');
}else{
$.messager.alert('提示信息','删除失败!','error');
};
} //修改IT基础设施告警接单人信息
function UpdateItView(){
// 定义所属form
var formobj = $('#vieweditItform');
var staffId = formobj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_ID']").val();
var staffName = formobj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_NAME']").val();
var staffPhone = formobj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_PHONE']").val();
var sc_id=formobj.find("input[name='ITSM_C_ITJJSS_STAFF/ID']").val(); if(staffId == ""){
$.messager.alert('提示信息','ITSM工号不能为空!','warning');
formobj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_ID']").parent().parent().find('.edit_red').show();
return;
}else if(staffName == ""){
$.messager.alert('提示信息','姓名不能为空!','warning');
formobj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_NAME']").parent().parent().find('.edit_red').show();
return;
}else if(staffPhone == ""){
$.messager.alert('提示信息','联系电话不能为空!','warning');
formobj.find("input[name='ITSM_C_ITJJSS_STAFF/STAFF_PHONE']").parent().parent().find('.edit_red').show();
return;
} var sub = new HiddenSubmit("ChangeFbrole.bizYunWei.bizUpdateItView");
if(sub.submitForm(document.forms.vieweditItform)){
sub.add('ITSM_C_ITJJSS_STAFF/ID',sc_id);
// 保存成功提示信息,显示1秒
$.messager.show({
title:'提示信息',
msg:'修改成功.',
timeout:1000,
style:{
right:'',
top:'150'
}
});
//关闭增加窗口
$('#WinViewEditIt').window('close');
//刷新当前页
SERVICEDATAGRID.datagrid('reload');
}else{
$.messager.alert('提示信息','保存失败!','error');
};
} // 格式化时间
function formatUpdateTime(val,row){
var str
if(val != ""){
str= val.substr(0,4) + "-" + val.substr(4,2) + "-" + val.substr(6,2) + " " + val.substr(8,2) + ":" + val.substr(10,2) + ":" + val.substr(12,2);
}
return str
}
QueryStaff.js