使用dhtmlxGrid出现的问题，每次选择一行的时候都是最后一行的数据，而且选择的时候选择下一行时，上一行不会变回色，样子像多选一样，但不是多选

q80480305 2010-08-26 11:00:02 


<%@ page language="java" pageEncoding="UTF-8"%>

<%@ include file="/taglibs.jsp" %>

<%

	String path = request.getContextPath();

 %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

    

    <title>调账页面</title>

    

	<meta http-equiv="pragma" content="no-cache">

	<meta http-equiv="cache-control" content="no-cache">

	<meta http-equiv="expires" content="0">    

	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

	<meta http-equiv="description" content="This is my page">

	<!--

	<link rel="stylesheet" type="text/css" href="styles.css">

	-->

	<link type="text/css" rel="stylesheet" href="css/btn.css" />

	<link rel="stylesheet" type="text/css" href="css/pubdefault.css">

	<link rel=stylesheet type="text/css" href="css/dhtmlxgrid.css">

	

	<script type='text/javascript' src="dwr/engine.js"></script>

    <script type='text/javascript' src="dwr/util.js"></script>   

    <script type='text/javascript' src="dwr/interface/RectifyServiceSupport.js"></script> 

	

	<script type='text/javascript' src="<%=path %>/js/dhtmlxcommon.js"></script>  

    <script type='text/javascript' src="<%=path %>/js/dhtmlxgrid.js"></script>  

    <script type='text/javascript' src="<%=path %>/js/dhtmlxgridcell.js"></script>  

    

	<script type="text/javascript" src="<%=path %>/js/jquery.js"></script>

	<script type="text/javascript" src="<%=path %>/js/rectify.js"></script>

	<script type="text/javascript" src="js/collapse.js"></script> 

	

	<style type="text/css">

		.step1-title, .step1-data {

			width:95%;

		    border-collapse:collapse;

			line-height:25px;

		}

		.step1-title {

			height:25px;

		}

		.step1-title tr, .step1-title td, .step1-data tr, .step1-data td {

		    border-collapse:collapse;

			border-bottom:2px solid #C1DAD7;

			background:#ECF7F7;

		}

		.step1-title tr, .step1-title td {

			background-image:url(images/jian.jpg);

			color:#FFFFFF;

			font-weight:bold;

			border-top:#00CC00 1px solid;

			border-bottom:#00CC00 1px solid;

		}

		button{

			height:25px;

		}

	</style>

	

  </head>

  

  <body>

	<div id="t1">

		<table width="100%">

			<tr>

				<td>

					<div id="gridboxMain" width="100%"  style="filter:alpha(opacity=60);"></div>

				</td>

			</tr>

			<tr>

				<td>

					<input type="hidden" id="hflduserid">

					<input type="hidden" id="hfldid">

				</td>

			</tr>

		</table>

		

		<table width="100%">

			<td>

				<button type="button" id="btn1" disabled="disabled" onclick="cancel()">反销帐</button>  

			    <button type="button" id="btn2" disabled="disabled" onclick="defaults()">呆坏账</button>

			    <button type="button" id="btn3" onClick="disuse()">置废</button>

			</td>

		    <td style="text-align:right">

		         第<span id="pageNo"></span>页 <span id="jupePage" style="cursor:pointer;text-decoration:underline;" onclick="jupePage()">上一页</span> 

		        <span id="nextPage" style="cursor:pointer;text-decoration:underline;" onclick="nextPage()">下一页</span>  

		         转到第<input type="text" name="edtgoPage" style="width:25;height:18;" onkeypress="return (/[\d.]/.test(String.fromCharCode(event.keyCode)))"/>页 

		         <span id="goPage" style="cursor:pointer;text-decoration:underline;" onclick="goPage()">go</span> 

		            

		         每页<input type="text" value="10" name="edtpaginalPage" style="width:25;height:18;" onkeypress="return (/[\d.]/.test(String.fromCharCode(event.keyCode)))"/>条 

		         <span id="paginalPage" style="cursor:pointer;text-decoration:underline;" onclick="paginalPage()">确定</span>  

		          共<span id="totalRecords"></span>条 

		          共<span id="totalPages"></span>页

		        <span  id="nosharePage" style="cursor:pointer;text-decoration:underline;" onclick="nosharePage()">不分页</span> 

		     </td>	  	     	 	

  	     </table>	     

	</div>

	<script type="text/javascript">

		<%String opType = request.getSession().getAttribute("opType").toString(); %>

		<%String edtUserId = request.getSession().getAttribute("edtUserId").toString(); %>

		<%String usercode = request.getSession().getAttribute("usercode").toString(); %>

		

		var usercode = "<%=usercode %>";

		var edtUserId = "<%=edtUserId %>";

		var opType = "<%=opType %>";

		var totalRecords;

		var totalPages ;

		var pageNo = 1;

		var pageSize = parseInt($("[name='edtpaginalPage']").val());//一页显示数目

		if(pageSize == ""){

		pageSize = 10;

		}

		

	    var hight_div = document.body.offsetHeight;

	

	    var gridboxMain_div = document.getElementById("gridboxMain");

	    gridboxMain_div.style.height=hight_div*0.42;

	   

	    mygridMain = new dhtmlXGridObject('gridboxMain');

	    mygridMain.setImagePath("images/"); 

	 	

	 	var titleMain ;

	 	var typesMain ;

	 	var initWidthsMain;

	 	var typesCol ;

	 	

		if(opType == "rec_userpay"){//业务收费

		

		    titleMain="用户编号,FLDID,费用类型,费用金额,实收金额,备注,收费操作员,收费时间,收费批次,状态标志,状态时间,状态操作员";

			

			typesMain="ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro";

			

			initWidthsMain="100,100,100,100,100,100,100,100,100,100,100,100";

			

			typesCol="str,str,str,str,str,str,str,str,str,str,str,str";

			

			mygridMain.setHeader(titleMain);

			mygridMain.setColTypes(typesMain);

			mygridMain.setInitWidths(initWidthsMain);

			mygridMain.setColSorting(typesCol);

			mygridMain.setStyle("background-color:#1D7101;color:white; font-weight:bold;", "","", "");

			

	//		mygridMain.setColumnHidden(1,true);//隐藏一列

			mygridMain.setSkin("modern");

			mygridMain.init();

			mygridMain.attachEvent("onRowSelect",mainRowSelectedtest1);

			

			function mainRowSelectedtest1(id){

				$("#hflduserid").val(mygridMain.cells(id,0).getValue());

				$("#hfldid").val(mygridMain.cells(id,1).getValue());

				var hfldstate = mygridMain.cells(id,9).getValue();

				if(hfldstate == 1 || hfldstate == 3){//FLDSTATE  in (1, 3)的记录才可以置废操作

					$("#btn3").attr("disabled","");

				}else{

					$("#btn3").attr("disabled","disabled");

				}

			}

			

		}else if(opType == "rec_monthpay"){//欠费账单

		

			titleMain="用户编号,FLDID,开始帐期,结束帐期,资费标准,使用时长,使用流量,基本月租,使用费用,储值结余,上月结余";

			

			typesMain="ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro";

			

			initWidthsMain="100,100,100,100,100,100,100,100,100,100,100";

			

			typesCol="str,str,str,str,str,str,str,str,str,str,str";

			

			mygridMain.setHeader(titleMain);

			mygridMain.setColTypes(typesMain);

			mygridMain.setInitWidths(initWidthsMain);

			mygridMain.setColSorting(typesCol);

			mygridMain.setStyle("background-color:#1D7101;color:white; font-weight:bold;", "","", "");

			

			mygridMain.setSkin("modern");

			mygridMain.init();

		//	mygridMain.setColumnHidden(1,true);//隐藏一列

			mygridMain.attachEvent("onRowSelect",mainRowSelectedtest2);

			

			function mainRowSelectedtest2(id){

				$("#hflduserid").val(mygridMain.cells(id,0).getValue());

				$("#hfldid").val(mygridMain.cells(id,1).getValue());

			}

		}else if(opType == "rec_monthpayhistory"){//销帐账单（反销账处理）

		

			titleMain="用户编号,FLDID,开始帐期,结束帐期,资费标准,使用时长,使用流量,基本月租,使用费用,销账时间,销账操作员,储值结余,免费标志,银行划款,收费批次";

			

			typesMain="ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro";

			

			initWidthsMain="100,100,100,100,100,100,100,100,100,100,100,100,100,100,100";

			

			typesCol="str,str,str,str,str,str,str,str,str,str,str,str,str,str,str";

			

			mygridMain.setHeader(titleMain);

			mygridMain.setColTypes(typesMain);

			mygridMain.setInitWidths(initWidthsMain);

			mygridMain.setColSorting(typesCol);

			mygridMain.setStyle("background-color:#1D7101;color:white; font-weight:bold;", "","", "");

			

			mygridMain.setSkin("modern");

			mygridMain.init();

		//	mygridMain.setColumnHidden(1,true);//隐藏一列

			mygridMain.attachEvent("onRowSelect",mainRowSelectedtest3);

			

			function mainRowSelectedtest3(id){

				$("#hflduserid").val(mygridMain.cells(id,0).getValue());

				$("#hfldid").val(mygridMain.cells(id,1).getValue());

			}

		

		}else if(opType == "rec_monthpaybak"){//呆坏账单（查询）

			

			titleMain="用户编号,FLDID,开始帐期,结束帐期,资费标准,使用时长,使用流量,基本月租,使用费用,储值结余,上月结余";

			

			typesMain="ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro";

			

			initWidthsMain="100,100,100,100,100,100,100,100,100,100,100";

			

			typesCol="str,str,str,str,str,str,str,str,str,str,str";

			

			mygridMain.setHeader(titleMain);

			mygridMain.setColTypes(typesMain);

			mygridMain.setInitWidths(initWidthsMain);

			mygridMain.setColSorting(typesCol);

			mygridMain.setStyle("background-color:#1D7101;color:white; font-weight:bold;", "","", "");

			

			mygridMain.setSkin("modern");

			mygridMain.init();

		//	mygridMain.setColumnHidden(1,true);//隐藏一列

			mygridMain.attachEvent("onRowSelect",mainRowSelectedtest4);

			

			function mainRowSelectedtest4(id){

				$("#hflduserid").val(mygridMain.cells(id,0).getValue());

				$("#hfldid").val(mygridMain.cells(id,1).getValue());

			}
...全文
462 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
q80480305 2010-08-26
  • 打赏
  • 举报
 回复 


}else if(opType == "rec_usermonthstatfreeinfo"){

			

			RectifyServiceSupport.rec_usermonthstatfreeinfo(data,callbackrec_usermonthstatfreeinfo);

			

			function callbackrec_usermonthstatfreeinfo(data){

				mygridMain.clearAll();//清除表格内容

				

				totalRecords = data[data.length-1];//总记录数

				if(totalRecords % pageSize == 0){//总页数

					totalPages = totalRecords / pageSize;

				

				}else{

					totalPages = totalRecords / pageSize + 1;

				}

				$("#totalRecords").html(parseInt(totalRecords));

				$("#totalPages").html(parseInt(totalPages));

				$("#pageNo").html(pageNo);

				for(var i=0;i<data.length-1;i++){

					 FLDUSERID = data[i].FLDUSERID; // 

					 FLDID = data[i].FLDID;  

				     FLDFREEMONTHS = data[i].FLDFREEMONTHS;            

				     FLDMEMO = data[i].FLDMEMO;           

				     FLDALLMONTHS = data[i].FLDALLMONTHS;       

				     FLDCREATEADMINID = data[i].FLDCREATEADMINID;       

				     FLDCREATEDATE = data[i].FLDCREATEDATE;          

				     FLDSTATE = data[i].FLDSTATE;       

				     FLDSTATEADMINID = data[i].FLDSTATEADMINID;        

				     FLDSTATEDATE = data[i].FLDSTATEDATE;    

				     FLDUSERPAYID = data[i].FLDUSERPAYID; 

				     FLDSTATEADMINID = data[i].FLDSTATEADMINID;

				     

				     mygridMain.addRow(FLDUSERID,[FLDUSERID,FLDID,FLDFREEMONTHS,

				     FLDMEMO,FLDALLMONTHS,FLDCREATEADMINID,FLDCREATEDATE,FLDSTATE,

				     FLDSTATEADMINID,FLDSTATEDATE,FLDUSERPAYID]);        

				}

			}

		}else if(opType == "rec_userbasediscount"){

			

			RectifyServiceSupport.rec_userbasediscount(data,callbackrec_userbasediscount);

			

			function callbackrec_userbasediscount(data){

				mygridMain.clearAll();//清除表格内容

				

				totalRecords = data[data.length-1];//总记录数

				if(totalRecords % pageSize == 0){//总页数

					totalPages = totalRecords / pageSize;

				

				}else{

					totalPages = totalRecords / pageSize + 1;

				}

				$("#totalRecords").html(parseInt(totalRecords));

				$("#totalPages").html(parseInt(totalPages));

				$("#pageNo").html(pageNo);

				for(var i=0;i<data.length-1;i++){

					 FLDUSERID = data[i].FLDUSERID; // 

					 FLDID = data[i].FLDID;  

				     FLDDISCOUNT = data[i].FLDDISCOUNT;            

				     FLDMEMO = data[i].FLDMEMO;           

				     FLDALLMONTHS = data[i].FLDALLMONTHS;       

				     FLDCREATEADMINID = data[i].FLDCREATEADMINID;       

				     FLDCREATEDATE = data[i].FLDCREATEDATE;          

				     FLDSTATE = data[i].FLDSTATE;       

				     FLDSTATEDATE = data[i].FLDSTATEDATE;        

				     FLDSTATEADMINID = data[i].FLDSTATEADMINID;    

				     FLDUSERPAYID = data[i].FLDUSERPAYID; 

				     

				     mygridMain.addRow(FLDUSERID,[FLDUSERID,FLDID,FLDDISCOUNT,

				     FLDMEMO,FLDALLMONTHS,FLDCREATEADMINID,FLDCREATEDATE,FLDSTATE,

				     FLDSTATEDATE,FLDSTATEADMINID,FLDUSERPAYID]);        

				}

			}

		}else if(opType == "rec_usermonthstatinfo"){

			

			RectifyServiceSupport.rec_usermonthstatinfo(data,callbackrec_usermonthstatinfo);

			

			function callbackrec_usermonthstatinfo(data){

				mygridMain.clearAll();//清除表格内容

				

				totalRecords = data[data.length-1];//总记录数

				if(totalRecords % pageSize == 0){//总页数

					totalPages = totalRecords / pageSize;

				

				}else{

					totalPages = totalRecords / pageSize + 1;

				}

				$("#totalRecords").html(parseInt(totalRecords));

				$("#totalPages").html(parseInt(totalPages));

				$("#pageNo").html(pageNo);

				for(var i=0;i<data.length-1;i++){

					 FLDUSERID = data[i].FLDUSERID; // 

					 FLDID = data[i].FLDID;  

				     FLDMONTHSTATDATE = data[i].FLDMONTHSTATDATE;            

				     FLDEXTEND = data[i].FLDEXTEND;           

				     FLDCREATEADMINID = data[i].FLDCREATEADMINID;       

				     FLDCREATEDATE = data[i].FLDCREATEDATE;       

				     FLDSTATE = data[i].FLDSTATE;          

				     FLDSTATEDATE = data[i].FLDSTATEDATE;       

				     FLDSTATEADMINID = data[i].FLDSTATEADMINID;        

				     

				     mygridMain.addRow(FLDUSERID,[FLDUSERID,FLDID,FLDMONTHSTATDATE,

				     FLDEXTEND,FLDCREATEADMINID,FLDCREATEDATE,FLDSTATE,FLDSTATEDATE,

				     FLDSTATEADMINID]);        

				}

			}

		}else if(opType == "rec_changegroup"){

			

			RectifyServiceSupport.rec_changegroup(data,callbackrec_changegroup);

			

			function callbackrec_changegroup(data){

				mygridMain.clearAll();//清除表格内容

				

				totalRecords = data[data.length-1];//总记录数

				if(totalRecords % pageSize == 0){//总页数

					totalPages = totalRecords / pageSize;

				

				}else{

					totalPages = totalRecords / pageSize + 1;

				}

				$("#totalRecords").html(parseInt(totalRecords));

				$("#totalPages").html(parseInt(totalPages));

				$("#pageNo").html(pageNo);

				for(var i=0;i<data.length-1;i++){

					 FLDUSERID = data[i].FLDUSERID; // 

					 FLDID = data[i].FLDID;  

				     FLDOLDGROUPID = data[i].FLDOLDGROUPID;            

				     FLDNEWGROUPID = data[i].FLDNEWGROUPID;           

				     FLDOLDMULTIGROUPID = data[i].FLDOLDMULTIGROUPID;       

				     FLDNEWMULTIGROUPID = data[i].FLDNEWMULTIGROUPID;       

				     FLDOLDSERVICESTRING = data[i].FLDOLDSERVICESTRING;          

				     FLDNEWSERVICESTRING = data[i].FLDNEWSERVICESTRING;       

				     FLDOLDLOCALID = data[i].FLDOLDLOCALID;        

				     FLDNEWLOCALID = data[i].FLDNEWLOCALID;    

				     FLDCHANGEDATE = data[i].FLDCHANGEDATE; 

				     FLDEXCUTEDATE = data[i].FLDEXCUTEDATE;

				     FLDEXTEND = data[i].FLDEXTEND;

				     FLDSTATE = data[i].FLDSTATE;

				     FLDSTATEDATE = data[i].FLDSTATEDATE;

				     FLDSTATEADMINID = data[i].FLDSTATEADMINID;

				     

				     mygridMain.addRow(FLDUSERID,[FLDUSERID,FLDID,FLDOLDGROUPID,

				     FLDNEWGROUPID,FLDOLDMULTIGROUPID,FLDNEWMULTIGROUPID,

				     FLDOLDSERVICESTRING,FLDNEWSERVICESTRING,

				     FLDOLDLOCALID,FLDNEWLOCALID,FLDCHANGEDATE,FLDEXCUTEDATE,

				     FLDEXTEND,FLDSTATE,FLDSTATEDATE,FLDSTATEADMINID]);        

				}

			}

		}else if(opType == "rec_prestoplog"){

			

			RectifyServiceSupport.rec_prestoplog(data,callbackrec_prestoplog);

			

			function callbackrec_prestoplog(data){

				mygridMain.clearAll();//清除表格内容

				

				totalRecords = data[data.length-1];//总记录数

				if(totalRecords % pageSize == 0){//总页数

					totalPages = totalRecords / pageSize;

				

				}else{

					totalPages = totalRecords / pageSize + 1;

				}

				$("#totalRecords").html(parseInt(totalRecords));

				$("#totalPages").html(parseInt(totalPages));

				$("#pageNo").html(pageNo);

				for(var i=0;i<data.length-1;i++){

					 FLDUSERID = data[i].FLDUSERID; // 

					 FLDID = data[i].FLDID;  

				     FLDUSERNAME = data[i].FLDUSERNAME;            

				     FLDCREATEDATE = data[i].FLDCREATEDATE;           

				     FLDEXECUTEDATE = data[i].FLDEXECUTEDATE;       

				     FLDEXTEND = data[i].FLDEXTEND;          

				     FLDSTATE = data[i].FLDSTATE;       

				     FLDSTATEDATE = data[i].FLDSTATEDATE;        

				     FLDSTATEADMINID = data[i].FLDSTATEADMINID;    

				     

				     mygridMain.addRow(FLDUSERID,[FLDUSERID,FLDID,FLDUSERNAME,

				     FLDCREATEDATE,FLDEXECUTEDATE,FLDEXTEND,FLDSTATE,FLDSTATEDATE,

				     FLDSTATEADMINID]);        

				}

			}

		}else if(opType == "rec_prereopenlog"){

			

			RectifyServiceSupport.rec_prereopenlog(data,callbackrec_prereopenlog);

			

			function callbackrec_prereopenlog(data){

				mygridMain.clearAll();//清除表格内容

				

				totalRecords = data[data.length-1];//总记录数

				if(totalRecords % pageSize == 0){//总页数

					totalPages = totalRecords / pageSize;

				

				}else{

					totalPages = totalRecords / pageSize + 1;

				}

				$("#totalRecords").html(parseInt(totalRecords));

				$("#totalPages").html(parseInt(totalPages));

				$("#pageNo").html(pageNo);

				for(var i=0;i<data.length-1;i++){

					 FLDUSERID = data[i].FLDUSERID;  

					 FLDID = data[i].FLDID;  

				     FLDUSERNAME = data[i].FLDUSERNAME;            

				     FLDCREATEDATE = data[i].FLDCREATEDATE;           

				     FLDEXECUTEDATE = data[i].FLDEXECUTEDATE;       

				     FLDEXTEND = data[i].FLDEXTEND;          

				     FLDSTATE = data[i].FLDSTATE;       

				     FLDSTATEDATE = data[i].FLDSTATEDATE;        

				     FLDSTATEADMINID = data[i].FLDSTATEADMINID;

				     

				     mygridMain.addRow(FLDUSERID,[FLDUSERID,FLDID,FLDUSERNAME,

				     FLDCREATEDATE,FLDEXECUTEDATE,FLDEXTEND,FLDSTATE,FLDSTATEDATE,

				     FLDSTATEADMINID]);        

				}

			}

		}

}
q80480305 2010-08-26
  • 打赏
  • 举报
 回复
Js页面:



function disuse(){//置废

	var hfldid = $("#hfldid").val();

	var hflduserid = $("#hflduserid").val();

	if(hflduserid == "" || hflduserid == null){

		alert("请先选中要置废的用户！");

	}else{

		if(confirm("确定将当前记录置废处理吗？")==false){

	         return false;

	    }

	    var data = new Array();

	    data[0] = hfldid;

	    data[1] = hflduserid;

	    data[2] = usercode;

	    data[3] = opType;

	    RectifyServiceSupport.disuse(data,callbackcancel);

	    function callbackcancel(data){

	    	query(pageNo,pageSize);

	    }

    }

}

function defaults(){//呆坏账

	var hfldid = $("#hfldid").val();

	var hflduserid = $("#hflduserid").val();

	if(hflduserid == "" || hflduserid == null){

		alert("请先选中要呆坏账操作的用户！");

	}else{

		if(confirm("确定将当前所选帐单作呆坏帐处理吗？")==false){

	         return false;

	    }

	    var data = new Array();

	    data[0] = hfldid;

	    data[1] = hflduserid;

	    data[2] = usercode;

	    RectifyServiceSupport.defaults(data,callbackdefaults);

	    function callbackdefaults(data){

	    	query(pageNo,pageSize);

	    }

    }

}

function cancel(){//反销帐

	var hfldid = $("#hfldid").val();

	var hflduserid = $("#hflduserid").val();

	if(hfldid == "" || hfldid == null){

		alert("请先选中要反销帐操作的用户！");

	}else{

		if(confirm("反销帐将把当前所选帐单转为用户的欠费帐单，确定反销帐吗？")==false){

	         return false;

	    }

	    var data = new Array();

	    data[0] = hfldid;

	    data[1] = hflduserid;

	    data[2] = usercode;

	    RectifyServiceSupport.cancel(data,callbackcancel);

	    function callbackcancel(data){

	    	query(pageNo,pageSize);

	    }

    }

}

function query(start,end){//查询数据

	var data = new Array();

	

	data[0] = parseInt(start);

	data[1] = parseInt(end);

	data[2] = edtUserId;

	if(opType == "rec_userpay"){

	

		RectifyServiceSupport.rec_userpay(data,callbackrec_userpay);

			

			function callbackrec_userpay(data){

				mygridMain.clearAll();//清除表格内容

				

				totalRecords = data[data.length-1];//总记录数

				if(totalRecords % pageSize == 0){//总页数

					totalPages = totalRecords / pageSize;

				

				}else{

					totalPages = totalRecords / pageSize + 1;

				}

				$("#totalRecords").html(parseInt(totalRecords));

				$("#totalPages").html(parseInt(totalPages));

				$("#pageNo").html(pageNo);

				for(var i=0;i<data.length-1;i++){

					 FLDUSERID = data[i].FLDUSERID; // 

				     FLDPAYSTYLE = data[i].FLDPAYSTYLE; 

				     if(FLDPAYSTYLE == 1){

				     	FLDPAYSTYLE = "开户费";

				     }else if(FLDPAYSTYLE == 2){

				     	FLDPAYSTYLE = "工程费";

				     }else if(FLDPAYSTYLE == 3){

				     	FLDPAYSTYLE = "设备费";

				     }else if(FLDPAYSTYLE == 4){

				     	FLDPAYSTYLE = "修改资料";

				     }else if(FLDPAYSTYLE == 5){

				     	FLDPAYSTYLE = "报停";

				     }else if(FLDPAYSTYLE == 6){

				     	FLDPAYSTYLE = "复通";

				     }else if(FLDPAYSTYLE == 7){

				     	FLDPAYSTYLE = "更名过户";

				     }else if(FLDPAYSTYLE == 8){

				     	FLDPAYSTYLE = "迁址移机";

				     }else if(FLDPAYSTYLE == 9){

				     	FLDPAYSTYLE = "增减储值";

				     }else if(FLDPAYSTYLE == 10){

				     	FLDPAYSTYLE = "变更资费";

				     }           

				     FLDMONEY = data[i].FLDMONEY;

				     FLDID = data[i].FLDID;           

				     FLDFACTMONEY = data[i].FLDFACTMONEY;       

				     FLDEXTEND = data[i].FLDEXTEND;       

				     FLDADMINID = data[i].FLDADMINID;          

				     FLDPAYDATE = data[i].FLDPAYDATE;       

				     FLDPAYID = data[i].FLDPAYID;        

				     FLDSTATE = data[i].FLDSTATE;    

				     FLDSTATEDATE = data[i].FLDSTATEDATE; 

				     FLDSTATEADMINID = data[i].FLDSTATEADMINID;

				     

				     mygridMain.addRow(FLDUSERID,[FLDUSERID,FLDID,FLDPAYSTYLE,

				     FLDMONEY,FLDFACTMONEY,FLDEXTEND,FLDADMINID,FLDPAYDATE,

				     FLDPAYID,FLDSTATE,FLDSTATEDATE,FLDSTATEADMINID]);        

				}

			}

		}else if(opType == "rec_monthpay"){

			

			RectifyServiceSupport.rec_monthpay(data,callbackrec_monthpay);

			

			function callbackrec_monthpay(data){

				mygridMain.clearAll();//清除表格内容

				

				totalRecords = data[data.length-1];//总记录数

				if(totalRecords % pageSize == 0){//总页数

					totalPages = totalRecords / pageSize;

				

				}else{

					totalPages = totalRecords / pageSize + 1;

				}

				$("#totalRecords").html(parseInt(totalRecords));

				$("#totalPages").html(parseInt(totalPages));

				$("#pageNo").html(pageNo);

				for(var i=0;i<data.length-1;i++){

					 FLDUSERID = data[i].FLDUSERID; // 

					 FLDID = data[i].FLDID;  

				     FLDSTARTDATE = data[i].FLDSTARTDATE;            

				     FLDENDDATE = data[i].FLDENDDATE;           

				     FLDUSERGROUPID = data[i].FLDUSERGROUPID;       

				     FLDUSETIME = data[i].FLDUSETIME;       

				     FLDUSEFLOW = data[i].FLDUSEFLOW;          

				     FLDUSEBASEMONEY = data[i].FLDUSEBASEMONEY;       

				     FLDUSEMONEY = data[i].FLDUSEMONEY;        

				     FLDLEFTMONEY = data[i].FLDLEFTMONEY;    

				     FLDORGINLEFTMONEY = data[i].FLDORGINLEFTMONEY; 

				     

				     mygridMain.addRow(FLDUSERID,[FLDUSERID,FLDID,FLDSTARTDATE,

				     FLDENDDATE,FLDUSERGROUPID,FLDUSETIME,FLDUSEFLOW,FLDUSEBASEMONEY,

				     FLDUSEMONEY,FLDLEFTMONEY,FLDORGINLEFTMONEY]);        

				}

			}

		}else if(opType == "rec_monthpayhistory"){

		

			RectifyServiceSupport.rec_monthpayhistory(data,callbackrec_monthpayhistory);

			

			function callbackrec_monthpayhistory(data){

				mygridMain.clearAll();//清除表格内容

				

				totalRecords = data[data.length-1];//总记录数

				if(totalRecords % pageSize == 0){//总页数

					totalPages = totalRecords / pageSize;

				

				}else{

					totalPages = totalRecords / pageSize + 1;

				}

				$("#totalRecords").html(parseInt(totalRecords));

				$("#totalPages").html(parseInt(totalPages));

				$("#pageNo").html(pageNo);

				for(var i=0;i<data.length-1;i++){

					 FLDUSERID = data[i].FLDUSERID; // 

					 FLDID = data[i].FLDID;  

				     FLDSTARTDATE = data[i].FLDSTARTDATE;            

				     FLDENDDATE = data[i].FLDENDDATE;           

				     FLDUSERGROUPID = data[i].FLDUSERGROUPID;       

				     FLDUSETIME = data[i].FLDUSETIME;       

				     FLDUSEFLOW = data[i].FLDUSEFLOW;          

				     FLDUSEBASEMONEY = data[i].FLDUSEBASEMONEY;       

				     FLDUSEMONEY = data[i].FLDUSEMONEY;        

				     FLDUSEMONEYDATE = data[i].FLDUSEMONEYDATE;    

				     FLDUSEMONEYID = data[i].FLDUSEMONEYID; 

				     FLDLEFTMONEY = data[i].FLDLEFTMONEY;

				     FLDORGINLEFTMONEY = data[i].FLDORGINLEFTMONEY;

				     FLDRECEIVEMONEY = data[i].FLDRECEIVEMONEY;

				     FLDBANKPAY = data[i].FLDBANKPAY;

				     FLDPAYID = data[i].FLDPAYID;

				     

				     mygridMain.addRow(FLDUSERID,[FLDUSERID,FLDID,FLDSTARTDATE,

				     FLDENDDATE,FLDUSERGROUPID,FLDUSETIME,FLDUSEBASEMONEY,FLDUSEMONEY,

				     FLDUSEMONEYDATE,FLDUSEMONEYID,FLDUSEMONEYID,FLDLEFTMONEY,

				     FLDORGINLEFTMONEY,FLDRECEIVEMONEY,FLDBANKPAY,FLDPAYID]);        

				}

			}

		

		}else if(opType == "rec_monthpaybak"){

		

			RectifyServiceSupport.rec_monthpaybak(data,callbackrec_monthpaybak);

			

			function callbackrec_monthpaybak(data){

				mygridMain.clearAll();//清除表格内容

				

				totalRecords = data[data.length-1];//总记录数

				if(totalRecords % pageSize == 0){//总页数

					totalPages = totalRecords / pageSize;

				

				}else{

					totalPages = totalRecords / pageSize + 1;

				}

				$("#totalRecords").html(parseInt(totalRecords));

				$("#totalPages").html(parseInt(totalPages));

				$("#pageNo").html(pageNo);

				for(var i=0;i<data.length-1;i++){

					 FLDUSERID = data[i].FLDUSERID; // 

					 FLDID = data[i].FLDID;  

				     FLDSTARTDATE = data[i].FLDSTARTDATE;            

				     FLDENDDATE = data[i].FLDENDDATE;           

				     FLDUSERGROUPID = data[i].FLDUSERGROUPID;       

				     FLDUSETIME = data[i].FLDUSETIME;       

				     FLDUSEFLOW = data[i].FLDUSEFLOW;          

				     FLDUSEBASEMONEY = data[i].FLDUSEBASEMONEY;       

				     FLDUSEMONEY = data[i].FLDUSEMONEY;        

				     FLDLEFTMONEY = data[i].FLDLEFTMONEY;    

				     FLDORGINLEFTMONEY = data[i].FLDORGINLEFTMONEY; 

				     

				     mygridMain.addRow(FLDUSERID,[FLDUSERID,FLDID,FLDSTARTDATE,

				     FLDENDDATE,FLDUSERGROUPID,FLDUSETIME,FLDUSEFLOW,FLDUSEBASEMONEY,

				     FLDUSEMONEY,FLDLEFTMONEY,FLDORGINLEFTMONEY]);        

				}

			}

		}else if(opType == "rec_userpriod"){

		

			RectifyServiceSupport.rec_userpriod(data,callbackrec_userpriod);

			

			function callbackrec_userpriod(data){

				mygridMain.clearAll();//清除表格内容

				

				totalRecords = data[data.length-1];//总记录数

				if(totalRecords % pageSize == 0){//总页数

					totalPages = totalRecords / pageSize;

				

				}else{

					totalPages = totalRecords / pageSize + 1;

				}

				$("#totalRecords").html(parseInt(totalRecords));

				$("#totalPages").html(parseInt(totalPages));

				$("#pageNo").html(pageNo);

				for(var i=0;i<data.length-1;i++){

					 FLDUSERID = data[i].FLDUSERID; // 

					 FLDID = data[i].FLDID;  

				     FLDSTARTDATE = data[i].FLDSTARTDATE;            

				     FLDENDDATE = data[i].FLDENDDATE;           

				     FLDRATE = data[i].FLDRATE;       

				     FLDMEMO = data[i].FLDMEMO;       

				     FLDADMINISTRATOR = data[i].FLDADMINISTRATOR;          

				     FLDCREATEDATE = data[i].FLDCREATEDATE;       

				     FLDSTATE = data[i].FLDSTATE;        

				     FLDSTATEADMINID = data[i].FLDSTATEADMINID;    

				     FLDSTATEDATE = data[i].FLDSTATEDATE; 

				     FLDPAYID = data[i].FLDPAYID;

				     

				     mygridMain.addRow(FLDUSERID,[FLDUSERID,FLDID,FLDSTARTDATE,

				     FLDENDDATE,FLDRATE,FLDMEMO,FLDADMINISTRATOR,FLDCREATEDATE,

				     FLDSTATE,FLDSTATEADMINID,FLDSTATEDATE,FLDPAYID]);        

				}

			}
q80480305 2010-08-26
  • 打赏
  • 举报
 回复 


}else if(opType == "rec_userpriod"){//优惠期限

			

			titleMain="用户编号,FLDID,开始日期,结束日期,优惠费率（元/月）,备注,创建操作员,创建时间,状态标志,状态操作员,状态时间,收费批次";

			

			typesMain="ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro";

			

			initWidthsMain="100,100,100,100,125,100,100,100,100,100,100,100";

			

			typesCol="str,str,str,str,str,str,str,str,str,str,str,str";

			

			mygridMain.setHeader(titleMain);

			mygridMain.setColTypes(typesMain);

			mygridMain.setInitWidths(initWidthsMain);

			mygridMain.setColSorting(typesCol);

			mygridMain.setStyle("background-color:#1D7101;color:white; font-weight:bold;", "","", "");

			

			mygridMain.setSkin("modern");

			mygridMain.init();

		//	mygridMain.setColumnHidden(1,true);//隐藏一列

			mygridMain.attachEvent("onRowSelect",mainRowSelectedtest5);

			

			function mainRowSelectedtest5(id){

				$("#hflduserid").val(mygridMain.cells(id,0).getValue());

				$("#hfldid").val(mygridMain.cells(id,1).getValue());

				var hfldstate = mygridMain.cells(id,8).getValue();

				if(hfldstate == 1 || hfldstate == 3){//FLDSTATE  in (1, 3)的记录才可以置废操作

					$("#btn3").attr("disabled","");

				}else{

					$("#btn3").attr("disabled","disabled");

				}

			}

			

		}else if(opType == "rec_usermonthstatfreeinfo"){//期限赠送（赠送记录调整）

			

			titleMain="用户编号,FLDID,有效月数,备注,原始月数,创建操作员,创建时间,状态标志,状态操作员,状态时间,收费批次";

			

			typesMain="ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro";

			

			initWidthsMain="100,100,100,100,100,100,100,100,100,100,100";

			

			typesCol="str,str,str,str,str,str,str,str,str,str,str";

			

			mygridMain.setHeader(titleMain);

			mygridMain.setColTypes(typesMain);

			mygridMain.setInitWidths(initWidthsMain);

			mygridMain.setColSorting(typesCol);

			mygridMain.setStyle("background-color:#1D7101;color:white; font-weight:bold;", "","", "");

			

			mygridMain.setSkin("modern");

			mygridMain.init();

		//	mygridMain.setColumnHidden(1,true);//隐藏一列

			mygridMain.attachEvent("onRowSelect",mainRowSelectedtest6);

			

			function mainRowSelectedtest6(id){

				$("#hflduserid").val(mygridMain.cells(id,0).getValue());

				$("#hfldid").val(mygridMain.cells(id,1).getValue());

				var hfldstate = mygridMain.cells(id,7).getValue();

				if(hfldstate == 1 || hfldstate == 3){//FLDSTATE  in (1, 3)的记录才可以置废操作

					$("#btn3").attr("disabled","");

				}else{

					$("#btn3").attr("disabled","disabled");

				}

			}

		}else if(opType == "rec_userbasediscount"){//优惠折扣(折扣记录调整)

		

			titleMain="用户编号,FLDID,月租折扣（%）,有效月数,备注,原始月数,创建操作员,创建时间,状态标志,状态时间,状态操作员,收费批次";

			

			typesMain="ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro";

			

			initWidthsMain="100,100,100,100,100,100,100,100,100,100,100,100";

			

			typesCol="str,str,str,str,str,str,str,str,str,str,str,str";

			

			mygridMain.setHeader(titleMain);

			mygridMain.setColTypes(typesMain);

			mygridMain.setInitWidths(initWidthsMain);

			mygridMain.setColSorting(typesCol);

			mygridMain.setStyle("background-color:#1D7101;color:white; font-weight:bold;", "","", "");

			

			mygridMain.setSkin("modern");

			mygridMain.init();

			mygridMain.setColumnHidden(1,true);//隐藏一列

			mygridMain.attachEvent("onRowSelect",mainRowSelectedtest7);

			

			function mainRowSelectedtest7(id){

				$("#hflduserid").val(mygridMain.cells(id,0).getValue());

				$("#hfldid").val(mygridMain.cells(id,1).getValue());

				var hfldstate = mygridMain.cells(id,8).getValue();

				if(hfldstate == 1 || hfldstate == 3){//FLDSTATE  in (1, 3)的记录才可以置废操作

					$("#btn3").attr("disabled","");

				}else{

					$("#btn3").attr("disabled","disabled");

				}

			}

		}else if(opType == "rec_usermonthstatinfo"){//期限结算日(扣费日期调整)

			

			titleMain="用户编号,FLDID,结算日期,备注,创建操作员,创建时间,状态标志,状态时间,状态操作员";

			

			typesMain="ro,ro,ro,ro,ro,ro,ro,ro,ro";

			

			initWidthsMain="100,100,100,100,100,100,100,100,100";

			

			typesCol="str,str,str,str,str,str,str,str,str";

			

			mygridMain.setHeader(titleMain);

			mygridMain.setColTypes(typesMain);

			mygridMain.setInitWidths(initWidthsMain);

			mygridMain.setColSorting(typesCol);

			mygridMain.setStyle("background-color:#1D7101;color:white; font-weight:bold;", "","", "");

			

			mygridMain.setSkin("modern");

			mygridMain.init();

		//	mygridMain.setColumnHidden(1,true);//隐藏一列

			mygridMain.attachEvent("onRowSelect",mainRowSelectedtest8);

			

			function mainRowSelectedtest8(id){

				$("#hflduserid").val(mygridMain.cells(id,0).getValue());

				$("#hfldid").val(mygridMain.cells(id,1).getValue());

				var hfldstate = mygridMain.cells(id,6).getValue();

				if(hfldstate == 1 || hfldstate == 3){//FLDSTATE  in (1, 3)的记录才可以置废操作

					$("#btn3").attr("disabled","");

				}else{

					$("#btn3").attr("disabled","disabled");

				}

			}

			

		}else if(opType == "rec_changegroup"){//预约套餐(预约资费调整)

			

			titleMain="用户编号,FLDID,原资费编号,新资费编号,原策略编号,新策略编号,原服务字串,新服务字串,原区域编号,新区域编号,操作时间,预约时间,备注,状态,状态时间,状态操作员";

			

			typesMain="ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro";

			

			initWidthsMain="100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100";

			

			typesCol="str,str,str,str,str,str,str,str,str,str,str,str,str,str,str,str";

			

			mygridMain.setHeader(titleMain);

			mygridMain.setColTypes(typesMain);

			mygridMain.setInitWidths(initWidthsMain);

			mygridMain.setColSorting(typesCol);

			mygridMain.setStyle("background-color:#1D7101;color:white; font-weight:bold;", "","", "");

			

			mygridMain.setSkin("modern");

			mygridMain.init();

		//	mygridMain.setColumnHidden(1,true);//隐藏一列

			mygridMain.attachEvent("onRowSelect",mainRowSelectedtest9);

			

			function mainRowSelectedtest9(id){

				$("#hflduserid").val(mygridMain.cells(id,0).getValue());

				$("#hfldid").val(mygridMain.cells(id,1).getValue());

				var hfldstate = mygridMain.cells(id,13).getValue();

				if(hfldstate == 1 || hfldstate == 3){//FLDSTATE  in (1, 3)的记录才可以置废操作

					$("#btn3").attr("disabled","");

				}else{

					$("#btn3").attr("disabled","disabled");

				}

			}

			

		}else if(opType == "rec_prestoplog"){//预约报停调整

			

			titleMain="用户编号,FLDID,用户帐号,操作时间,预约时间,备注,状态标志,状态时间,状态操作员";

			

			typesMain="ro,ro,ro,ro,ro,ro,ro,ro,ro";

			

			initWidthsMain="100,100,100,100,100,100,100,100,100";

			

			typesCol="str,str,str,str,str,str,str,str,str";

			

			mygridMain.setHeader(titleMain);

			mygridMain.setColTypes(typesMain);

			mygridMain.setInitWidths(initWidthsMain);

			mygridMain.setColSorting(typesCol);

			mygridMain.setStyle("background-color:#1D7101;color:white; font-weight:bold;", "","", "");

			

			mygridMain.setSkin("modern");

			mygridMain.init();

		//	mygridMain.setColumnHidden(1,true);//隐藏一列

			mygridMain.attachEvent("onRowSelect",mainRowSelectedtest10);

			

			function mainRowSelectedtest10(id){

				$("#hflduserid").val(mygridMain.cells(id,0).getValue());

				$("#hfldid").val(mygridMain.cells(id,1).getValue());

				var hfldstate = mygridMain.cells(id,6).getValue();

				if(hfldstate == 1 || hfldstate == 3){//FLDSTATE  in (1, 3)的记录才可以置废操作

					$("#btn3").attr("disabled","");

				}else{

					$("#btn3").attr("disabled","disabled");

				}

			}

			

		}else if(opType == "rec_prereopenlog"){//预约复通调整

			

			titleMain="用户编号,FLDID,用户帐号,操作时间,预约时间,备注,状态标志,状态时间,状态操作员";

			

			typesMain="ro,ro,ro,ro,ro,ro,ro,ro,ro";

			

			initWidthsMain="100,100,100,100,100,100,100,100,100";

			

			typesCol="str,str,str,str,str,str,str,str,str";

			

			mygridMain.setHeader(titleMain);

			mygridMain.setColTypes(typesMain);

			mygridMain.setInitWidths(initWidthsMain);

			mygridMain.setColSorting(typesCol);

			mygridMain.setStyle("background-color:#1D7101;color:white; font-weight:bold;", "","", "");

			

			mygridMain.setSkin("modern");

			mygridMain.init();

		//	mygridMain.setColumnHidden(1,true);//隐藏一列

			mygridMain.attachEvent("onRowSelect",mainRowSelectedtest11);

			

			function mainRowSelectedtest11(id){

				$("#hflduserid").val(mygridMain.cells(id,0).getValue());

				$("#hfldid").val(mygridMain.cells(id,1).getValue());

				var hfldstate = mygridMain.cells(id,6).getValue();

				if(hfldstate == 1 || hfldstate == 3){//FLDSTATE  in (1, 3)的记录才可以置废操作

					$("#btn3").attr("disabled","");

				}else{

					$("#btn3").attr("disabled","disabled");

				}

			}

		

		}

		

		//disabled 反销帐、呆坏账、置废功能按钮

		if(opType == "rec_monthpay"){//欠费账单

			$("#btn2").attr("disabled","");

			$("#btn3").attr("disabled","disabled");

		}else if(opType == "rec_monthpayhistory"){//销帐账单（反销账处理）

			$("#btn1").attr("disabled","");

			$("#btn3").attr("disabled","disabled");

		}

		

	</script>

	<script type="text/javascript">

  		 <%String map = (String)session.getAttribute("map");%>  

	    var map = '<%=map%>'; 

	    parent.frames.wtop.document.getElementById("map").innerText=map;

	    query(pageNo,pageSize);

  	</script>

  </body>

</html>
dhtmlxGrid介绍及使用手册（中文版）
文档主要对dhtmlxGrid 实现的功能进行介绍，以及API操作中文手册。 文档大致目录如下： 一、 dhtmlxGrid 介绍 7 1. 自定义XML: 7 2. 支持多行表头、表尾展现 7 3. 移动、添加、删除列 8 4. 处理大型数据集-支持分页 8 5. 处理大型数据集-智能渲染 9 6. 与数据库交互 9 7. 扩展单元格-EXCEL 10 8. 拆分模式（冻结栏） 10 9. 控制于一体的网络和树 11 二、 dhtmlxgrid 配置部分 12 2.1 表格操作API 12 2.2 表格样式API 19 三、 数据处理部分 30 3.1 dhtmlxgrid 数据加载部分 30 四、 Dhtmlxgrid操作 39 4.1 dhtmlxgrid 行操作 39 4.2 dhtmlxgrid 列操作 48 4.3 dhtmlxgrid 单元格操作 55 4.4 dhtmlxgrid 选择过滤操作 61
DhtmlxGrid 分页的自定义模板，DhtmlxGrid复选框多选整行 dhtmlxgrid自定义按钮
DhtmlxGrid的自定义的分页样式，不是他们内部的三种皮肤分页； 本篇还有dhtmlxgird没有的复选框选中整行的效果，dhtmlxgrid多行选中使用的是 [Ctrl+鼠标]、[Shift+鼠标],在国内大部分的体验操作都是第一列放复选框的操作，因此本篇已将其优化； 经测验基本需求符合，但是本篇还是存在一些小bug，比如：全选后会选择全部行（包括分页后面的），所以还是希望大家一起探讨修复，希望多多留言，评论，谢谢合作
dhtmlxgrid中文培训资料.ppt
优美的表格化数据显示，用户可用鼠标拖动方便地改变各列的宽度 支持客户端表格排序，只需单击要排序列的表头。并且支持设置列的数据类型（数字、字符串、日期），按类型排序 页面所有数据操作全部采用Ajax技术后台处理，整个页面只会加载一次，所有操作均仅更新页面相应区域，页面不会整体刷新。 支持原位编辑，双击要编辑的单元格即可进入编辑模式，编辑完成，按回车自动后台提交。并可在提交前设置客户端数据验证。 可以动态添加新行、删除选中行。 日期格式提供日历可供选择 支持分页。
dhtmlxgrid中如何实现在grid载入完毕后焦点位于最后一行
dhtmlxgrid中如何实现在grid载入完毕后焦点位于最后一行？最近有个网友写信问到这个问题，晚上查阅了一下文档，发现可以用如下方法解决： 首先，从文档中可以得知，在loadXML方法中，其实还有第二个参数，aftercall，它表示在grid载入完毕后可以调用aftercall这个方法。 至于如何把焦点移到最后一行，可以用selectCell方法来实现，具体的说明请大家查看说明文档，我这里不...
JavaScript

87,907

社区成员

224,614

社区内容

发帖
与我相关
我的任务
社区描述
Web 开发 JavaScript
社区管理员
  • JavaScript
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章