dhtmlXGrid 同一个列表区,不同列显示

来源:互联网 发布:淘宝店一件代发可靠吗 编辑:程序博客网 时间:2024/06/07 04:40
document.write('<link type="text/css" rel="stylesheet" href="../../../../../script/grid/css/dhtmlXGrid.css">');document.write('<script language="javascript" type="text/javascript" src="../../../../../script/grid/js/dhtmlXCommon.js"></script>');document.write('<script language="javascript" type="text/javascript" src="../../../../../script/grid/js/dhtmlXGrid.js"></script>');document.write('<script language="javascript" type="text/javascript" src="../../../../../script/grid/js/dhtmlXGridCell.js"></script>');document.write('<script language="JavaScript" type="text/javascript" src="../../../../../script/public/pagecontrol.js"></script>');//====================================================================//通过top页jser的_import方法加载类库,以短名引用//====================================================================var getClass=function(sClass){top._import( sClass );return window[sClass.replace(/.*\./g,"")]=top.Class.forName( sClass);}getClass("cdmcs.Html.TextInput");getClass("cdmcs.Html.Textarea");getClass("cdmcs.runtime.Thread");getClass("cdmcs.UI.LoadingBar");getClass("com.homolo.commons.util.DateFormat");_import("cdmcs.Form.InputMask.InputDateTimeMask");_import("app.SysTimeManager");var progressbar;var thread_ListInfo = new Thread();   // 用于信息列表var dwData;           // 从数据库信息结果集var gsResultName = "P_RESULT";//======================================================================// 全局变量//======================================================================var gUserOBJ = new userObj();// 取登录用户ID号var giLoginUserID;var gridInfo;var gsRowMsg = '<span class="style1"> 记录数:0 条</span>';vargsSQLStr     = "";var gbFirstQuery = true;// 第一次检索数据标志var giPAGEROWS   = 22;// 每一页检索记录行数var giPAGE       = 1;  // 检索页号 (值大于1)var giTOTALROWS  = 0;  // 满足条件总记录数var giTOTALPAGES = 0;  // 满足条件总页数var gs_exportURLParm;var gsYWLX = "XH905";     // 临牌转出查询var gbQUERY = false;      // 是否已检索数据【true:已检索】var giExcelRecord = 10000;//======================================================================// 初始化函数//======================================================================function init(){  // 取工作区域的最大高度  var giWorkH = Math.max( document.documentElement.clientHeight , document.body.clientHeight);  // 重新计算每页检索记录条数  giPAGEROWS = Math.round((giWorkH - 60.5)/ 23.5);  // 取得用户信息  if (!gUserOBJ.getUserInfo()){    alert(gUserOBJ.C_MSG);    return;  }  giLoginUserID = gUserOBJ.N_USERID;   //初始化时 先new好对象 dhtmlXGridObject    gridInfo = new dhtmlXGridObject('infoGrid');gridInfo.setImagePath("../../../../../script/grid/imgs/");var tr_len = gridInfo.hdr.rows.length;for(var i = tr_len-1;i >= 0;i--){gridInfo.hdr.deleteRow(i); }init_Grid_0();  init_Event();    CXTYPE1_OnClick();}//======================================================================// 初始化显示表格   临牌号码查询//======================================================================function init_Grid_0(){//临牌号码 登记日期 临牌序列号 所有人 身份证明名称及号码 车辆识别代号 有效期 有效期止 转出时间 转出操作员 //gridInfo = new dhtmlXGridObject('infoGrid');//gridInfo.setImagePath("../../../../../script/grid/imgs/");gridInfo.setHeader("临牌号码,登记日期,临牌序列号,所有人,身份证明名称及号码,车辆识别代号,有效期,有效期止,转出时间,转出操作员");gridInfo.setInitWidthsP("8,10,10,10,18,12,10,10,15,10");gridInfo.setColAlign("left,center,left,left,left,left,center,center,center,left" );gridInfo.setColSorting("str,str,str,str,str,str,str,str,str,str");gridInfo.setColTypes("ro,ro,ro,ro,ro,ro,ro,ro,ro,ro");gridInfo.setEditable(false);gridInfo.init();gridInfo.enableAlterCss("GridRowColorEven","GridRowColorUnEven");gridInfo.enableKeyboardSupport(true);//  gridInfo.setOnRowSelectHandler(f_SelectRow);//  gridInfo.setDblClickHandler(f_ShowInfo);}//======================================================================//初始化显示表格   转出日期查询//======================================================================function init_Grid_1(){//转出时间,转出数//gridInfo = new dhtmlXGridObject('infoGrid');//gridInfo.setImagePath("../../../../../script/grid/imgs/");gridInfo.setHeader("转出时间,转出数");gridInfo.setInitWidthsP("50,50");gridInfo.setColAlign("center,right");gridInfo.setColSorting("str,str");gridInfo.setColTypes("ro,ro");gridInfo.setEditable(false);gridInfo.init();gridInfo.enableAlterCss("GridRowColorEven","GridRowColorUnEven");gridInfo.enableKeyboardSupport(true);//gridInfo.setOnRowSelectHandler(f_SelectRow);//gridInfo.setDblClickHandler(f_ShowInfo);}//======================================================================// 初始化输入域及按钮事件//======================================================================function init_Event(){  //==================================================================  // 创建检索进度条  //==================================================================  progressbar = new LoadingBar(document);  progressbar.hide();  //==================================================================// 翻页按键事件处理  //==================================================================document.getElementById("page_first").onclick = f_GetData_First;document.getElementById("page_prev").onclick  = f_GetData_Prev;document.getElementById("page_next").onclick  = f_GetData_Next;document.getElementById("page_last").onclick  = f_GetData_Last;document.getElementById("btnTOPAGE").onclick  = f_GetData_goPage;$("C_PAGENUM").onkeyup  = C_PAGENUM_EnterKey;  //==================================================================TextInput.applyTo($("C_LPHM"));$("C_LPHM").onkeyup  = C_LPHM_EnterKey;$("CXTYPE1").onclick  = CXTYPE1_OnClick;$("CXTYPE2").onclick  = CXTYPE2_OnClick;$("btnQuery").onclick = btnQuery_onClicked;$("btnDel").onclick = f_btnDel;}//======================================================================// 在检索 "临牌号码"按键事件控制//======================================================================function C_LPHM_EnterKey() {var sLPHM = $("C_LPHM").value;//临牌号码$("C_LPHM").value = sLPHM.toUpperCase().replace(/^\s+|\s+$/g,"");sLPHM = $("C_LPHM").value;if(sLPHM == null || sLPHM == ""){if(event.keyCode == 13){$("C_LPXH").focus();}return;}var reg = new RegExp("^[a-zA-Z0-9_]{0,}$");if(!reg.test(sLPHM)){$("C_LPHM").value = sLPHM.replace(/[^a-zA-Z0-9_]/g,"");//.substring(0,sHPHM.length-1);return;}if(event.keyCode == 13 || sLPHM.lenght == 6){$("btnQuery").focus();}}function CXTYPE1_OnClick(){$("CXTYPE1").checked = true;$("CXTYPE2").checked = false;$("C_LPHM").disabled = false;$("C_RQ1").disabled = true;$("C_RQ2").disabled = true;$("C_LPHM").className = "oneInput";$("C_RQ1").className = "oneInputDisable";$("C_RQ2").className = "oneInputDisable";$("btnDel").disabled = true;$("C_RQ1").value = "";$("C_RQ2").value = "";$("C_LPHM").focus();//变换列表时  需要做的操作  gridInfo.clearAll();gridInfo.hdr.rows[1].parentNode.removeChild(gridInfo.hdr.rows[1]);gridInfo.hdr.rows[0].parentNode.removeChild(gridInfo.hdr.rows[0]);$("PageRow").innerHTML = gsRowMsg;Show_PageNum_ddlb(0);// 初次置翻页按键属性var curPAGE = f_PageKey('1', 0, 0);init_Grid_0();}function CXTYPE2_OnClick(){$("CXTYPE1").checked = false;$("CXTYPE2").checked = true;$("C_LPHM").disabled = true;$("C_RQ1").disabled = false;$("C_RQ2").disabled = false;$("btnDel").disabled = true;$("C_LPHM").className = "oneInputDisable";$("C_RQ1").className = "oneInput";$("C_RQ2").className = "oneInput";var data = SysTimeManager.getDate();var dtformat = new DateFormat('yyyy-MM-dd');$("C_RQ1").value = dtformat.format(data);$("C_RQ2").value = dtformat.format(data);$("C_LPHM").value = "";$("C_RQ1").focus();//变换列表时  需要做的操作  gridInfo.clearAll();gridInfo.hdr.rows[1].parentNode.removeChild(gridInfo.hdr.rows[1]);gridInfo.hdr.rows[0].parentNode.removeChild(gridInfo.hdr.rows[0]);$("PageRow").innerHTML = gsRowMsg;Show_PageNum_ddlb(0);// 初次置翻页按键属性var curPAGE = f_PageKey('1', 0, 0);init_Grid_1();}//======================================================================//用途:查询机动车详细信息//======================================================================function btnQuery_onClicked() {gbFirstQuery = true; // 第一次检索数据giPAGE = 1; // 初始为第一页gsSQLStr = "";f_GetData(gsSQLStr, giPAGE);}//======================================================================// 调用存储过程检索数据//======================================================================function f_GetData(sStrData, nPage){var nCurPage = nPage * 1;if (gbFirstQuery){nCurPage = nCurPage * (-1);}  gbQUERY = true;    var sCXTYPE = "1";  var sLPHM;  var sRQ1 ;  var sRQ2 ;  //按临牌号码查询  if($("CXTYPE1").checked){  sCXTYPE = "1";  sLPHM = $("C_LPHM").value.replace(/^\s+|\s+$/g,"");  if(sLPHM == null || sLPHM == ""){  showMessage("请输入临牌号码!", "0");      $("C_LPHM").focus();      return false;  }  }  //按转出时间查询  if($("CXTYPE2").checked){  sCXTYPE = "2";  sRQ1 = $("C_RQ1").value;  sRQ2 = $("C_RQ2").value;  if (sRQ1 == null || sRQ1 == "" || sRQ1 == "0000-00-00"){    sRQ1 = "";  }if (sRQ2 == null || sRQ2 == "" || sRQ2 == "0000-00-00"){    sRQ2 = "";  }  if (sRQ1 != "" && sRQ2 != "") {    if (sRQ1 > sRQ2){      showMessage("本次查询的截止日期不能早于开始日期!", "0");      $("C_RQ2").focus();      return false;    }  }  }    progressbar.setMessage("正在检索...");  progressbar.show();  dwData = new AjaxProxy();  dwData.addParm("1", nCurPage);        // 检索页号 (值大于1)  dwData.addParm("2", giPAGEROWS);      // 每一页检索记录行数  dwData.addParm("3", sCXTYPE);          // 查询方式  1:按临牌号码查询   2:按转出时间查询  dwData.addParm("4", sLPHM);            // 临牌号码  dwData.addParm("5", sRQ1);            // 转出时间起[YYYY-MM-DD]  dwData.addParm("6", sRQ2);            // 转出时间止[YYYY-MM-DD]  dwData.invoke("HLWYY_WSCGS_ZZBHCX2013.PW_ZZBH_LPZCCX", true, f_ShowData, dwData);}//======================================================================// 使用线程方式显示违法列表//======================================================================function f_ShowData(dwObj) {gridInfo.clearAll();var thread = thread_ListInfo;thread.stop(); // 如果上列的操作未完成,必须先退出var nCnt = dwObj.getRowCount(gsResultName);// 有数据thread.command = ListInfo_Command; // 执行的命令thread.dmQryResult = dwObj;thread.rowCount = nCnt;thread.grid = gridInfo;thread.start();if (gbFirstQuery) {// 取满足条件总记录数giTOTALROWS = dwObj.getString("PN_TOTALROWS") * 1;// 取满足条件总页数giTOTALPAGES = dwObj.getString("PN_TOTALPAGES") * 1;Show_PageNum_ddlb(giTOTALPAGES);// 初次置翻页按键属性var curPAGE = f_PageKey('1', giTOTALPAGES, giPAGE);if (giTOTALROWS <= 0) {$("PageRow").innerHTML = gsRowMsg;} else {$("PageRow").innerHTML = '<span class="style1">记录数:' + giTOTALROWS+ ' 条   共 ' + giTOTALPAGES + ' 页</span>';}gbFirstQuery = false;}if (nCnt <= 0) {$("btnDel").disabled = true;} else {gridInfo.selectRow(0, true);$("btnDel").disabled = false;}}// 采用进程方式显示列表数据function ListInfo_Command(){if(this.count > this.rowCount){    //已经全部列出this.stop();  //终止线程progressbar.hide();return;       //立即退出}var dwObj = this.dmQryResult;var vRowID = this.count;//按临牌号码查询  if($("CXTYPE1").checked){  var N_BH       = dwObj.getString(gsResultName, vRowID, "N_BH");  var C_LPHM       = dwObj.getString(gsResultName, vRowID, "C_LPHM");  var C_DJRQ       = dwObj.getString(gsResultName, vRowID, "C_DJRQ");  var C_LPXH       = dwObj.getString(gsResultName, vRowID, "C_LPXH");  var C_SYR        = dwObj.getString(gsResultName, vRowID, "C_SYR");  var C_SFZMSM     = dwObj.getString(gsResultName, vRowID, "C_SFZMSM");  var C_CLSBDH     = dwObj.getString(gsResultName, vRowID, "C_CLSBDH");  var N_YXQ     = dwObj.getString(gsResultName, vRowID, "N_YXQ");  var C_YXQZ     = dwObj.getString(gsResultName, vRowID, "C_YXQZ");  var C_ZCSJ     = dwObj.getString(gsResultName, vRowID, "C_ZCSJ");  var C_ZCUSER     = dwObj.getString(gsResultName, vRowID, "C_ZCUSER");  var sdata = [ C_LPHM,                C_DJRQ,                C_LPXH,                C_SYR,                C_SFZMSM,                C_CLSBDH,                N_YXQ,                C_YXQZ,                C_ZCSJ,                C_ZCUSER              ];  gridInfo.addRow(vRowID, sdata);}//按转出时间查询if($("CXTYPE2").checked){  var C_ZCSJ     = dwObj.getString(gsResultName, vRowID, "C_ZCSJ");  var N_ZCSL     = dwObj.getString(gsResultName, vRowID, "N_ZCSL");  var sdata = [                 C_ZCSJ,                N_ZCSL              ];  gridInfo.addRow(vRowID, sdata);}  }// ======================================================================// 删除临牌//======================================================================function f_btnDel() {// 取当前选中的[结果集中的]记录行号var vRowID = gridInfo.getSelectedId();var sBH = "";var sZCSJ = "";var sTSXX = "";//按临牌号码查询if ($("CXTYPE1").checked) {sBH = dwData.getString(gsResultName, vRowID, "N_BH");sZCSJ = "";sLPHM = dwData.getString(gsResultName, vRowID, "C_LPHM");sTSXX = dwData.getString(gsResultName, vRowID, "C_ZCSJ");sTSXX = "临牌号码【" +sLPHM + "】转出时间【" + sTSXX + "】";}//按转出时间查询if ($("CXTYPE2").checked) {sZCSJ = dwData.getString(gsResultName, vRowID, "C_ZCSJ");sBH = "";sTSXX = "转出时间【" + sZCSJ + "】";}if((sBH == null || sBH == "") && (sZCSJ == null || sZCSJ == "")){showMessage("请选择需要删除的临牌记录!","0");return;}if (!showMessage("是否确信删除"+ sTSXX +"的临时号牌记录(确定/取消)?", "1")){return;}var progressbar1 = new LoadingBar(document);progressbar1.setMessage("正在删除...");progressbar1.show();//alert(progressbar1);return;$("btnDel").disabled = true;$("btnQuery").disabled = true;  var gcDel = new AjaxProxy();gcDel.addParm(1,sBH);gcDel.addParm(2,sZCSJ);gcDel.addParm(3,gUserOBJ.N_USERID);gcDel.invoke("HLWYY_WSCGS_ZZBHCX2013.PF_ZZBH_LPZC_DEL", true, function(gcDel){var flag = gcDel.getString("PN_RET")*1;var msg = gcDel.getString("PC_MSG");//progressbar1.hide();$("btnQuery").disabled = false;if(flag != 0){progressbar1.hide();progressbar1.dispose();if(msg != null && msg != ""){showMessage(msg,"0");}$("btnDel").disabled = false;return;}else{progressbar1.hide();progressbar1.dispose();showMessage("删除成功!","0");btnQuery_onClicked();}}, gcDel);  }//======================================================================//以下方法处理翻页按钮事件//======================================================================//======================================================================//改变选择检索页号//======================================================================function C_Page_onchange(){var curPAGE = f_CangePage(giTOTALPAGES, gsSQLStr, f_GetData);if (curPAGE > 0)giPAGE = curPAGE;}//======================================================================//改变选择检索页号//======================================================================function f_GetData_goPage(){var curPAGE = f_QueryData_goPage(giTOTALPAGES, gsSQLStr, f_GetData);if (curPAGE > 0)giPAGE = curPAGE;}//======================================================================//用途:检索页数输入域按键事件控制//======================================================================function C_PAGENUM_EnterKey(){var tt = $("C_PAGENUM").value.match(/[0-9]*/ig);$("C_PAGENUM").value = (null==tt?"":tt[0]);if (event.keyCode == 13){ event.cancelBubble = true; event.returnValue  = true;$("btnTOPAGE").focus(); f_GetData_goPage();}}//======================================================================//用途:处理翻页按键 ---> 翻页-到第一页//======================================================================function f_GetData_First(){var curPAGE = f_PageKey_First(giTOTALPAGES, giPAGE, gsSQLStr, f_GetData);if (curPAGE > 0)giPAGE = curPAGE;}//======================================================================//用途:处理翻页按键 ---> 翻页-向上翻一页//======================================================================function f_GetData_Prev(){var curPAGE = f_PageKey_Prev(giTOTALPAGES, giPAGE, gsSQLStr, f_GetData);if (curPAGE > 0)giPAGE = curPAGE;}//======================================================================//用途:处理翻页按键 ---> 翻页-向下翻一页//======================================================================function f_GetData_Next(){var curPAGE = f_PageKey_Next(giTOTALPAGES, giPAGE, gsSQLStr, f_GetData);if (curPAGE > 0)giPAGE = curPAGE;}//======================================================================//用途:处理翻页按键 ---> 翻页-到最后一页//======================================================================function f_GetData_Last(){var curPAGE = f_PageKey_Last(giTOTALPAGES, giPAGE, gsSQLStr, f_GetData);if (curPAGE > 0)giPAGE = curPAGE;}//======================================================================//以上方法处理翻页按钮事件//======================================================================function $(){return document.getElementById(arguments[0]);}


                                             
0 0
原创粉丝点击