<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>自来水用户信息列表</title> <!--框架必需start--> <script type="text/javascript" src="${ctx}/qui/libs/js/jquery.js"></script> <script type="text/javascript" src="${ctx}/qui/libs/js/framework.js"></script> <link href="${ctx}/qui/libs/css/import_basic.css" rel="stylesheet" type="text/css" /> <link rel="stylesheet" type="text/css" id="skin" prePath="${ctx}/qui/" /> <link rel="stylesheet" type="text/css" id="customSkin" /> <!--框架必需end--> <!--数据表格start--> <script src="${ctx}/qui/libs/js/table/quiGrid.js" type="text/javascript"></script> <!--数据表格end--> <!--箭头分页start--> <script type="text/javascript" src="${ctx}/qui/libs/js/nav/pageArrow.js"></script> <!--箭头分页end--> <!--表单异步提交start--> <script src="${ctx}/qui/libs/js/form/form.js" type="text/javascript"></script> <!--表单异步提交end--> <!-- 日期选择框start --> <script type="text/javascript" src="${ctx}/qui/libs/js/form/datePicker/WdatePicker.js"></script> <!-- 日期选择框end --> <script type="text/javascript"> var g_pageNo = 1; var g_pageSize = 10; var total_rows=0; //刷新记忆 var checkedArray = []; //数据表格使用 var g; var gridData; function initComplete(){ g = $("#maingrid").quiGrid({ columns: [ { display: '单位编号', name: 'orgNumber', align: 'center', width: "5%"}, { display: '单位名称', name: 'orgName', align: 'center', width: "12%", render:function(rowdata, rowindex, value, column){ return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>"; } }, { display: '单位地址', name: 'address', align: 'center', width: "15%", render:function(rowdata, rowindex, value, column){ return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>"; } }, { display: '年度', name: 'year', align: 'center', width: "4%"}, { display: '是否计划户', name: 'isPlanUser', align: 'center', width: "6%", render:function(rowdata, rowindex, value, column){ if(value == "no"){ return "<font color=green>非计划户</font>"; }else if(value == "yes"){ return "<font color=red>计划户</font>"; }else{ return ""; } } }, { display: '客户号', name: 'busOrgCustomerNumber', align: 'center', width: "8%", render:function(rowdata, rowindex, value, column){ return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>"; } }, { display: '水表编号', name: 'busOrgMeterNumber', align: 'center', width: "8%"}, { display: '单位类别', name: 'baseOrgType', align: 'center', width: "6%"}, { display: '分片区管理', name: 'area', align: 'center', width: "6%"}, { display: '备注', name: 'remark', align: 'center', width: "8%", render:function(rowdata, rowindex, value, column){ if(value == null){ return ""; }else{ return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>"; } } }, { display: '操作', isAllowHide: false, align: 'center', width:"15%", render: function (rowdata, rowindex, value, column){ return '<div class="padding_top4 padding_left20">' <@pop_perm url="/org/viewTapWaterUserDetail.do"> + '<a href="#" onclick="onView('+ rowdata.orgId+')"><span class="icon_view">查看详情</span></a>' </@pop_perm> <@pop_perm url="/org/editTapWaterUser.do"> + '<a href="#" onclick="onEdit('+ rowdata.orgId+')"><span class="icon_edit">修改</span></a>' </@pop_perm> <@pop_perm url="/org/deleteTapWaterUser.do"> + '<a href="#" onclick="onDelete('+ rowdata.orgId+')"><span class="icon_delete">删除</span></a>' </@pop_perm> + '</div>'; } }], toolbar:{ items:[ <@pop_perm url="/org/editTapWaterUser.do"> {text:'新增',click:addTapWaterUser,iconClass:'icon_add'}, </@pop_perm> <@pop_perm url="/org/exportTapWaterUserExcel.do"> {line:true}, {text:'导出',click:exportTapWaterUserExcel, iconClass:'icon_export'}, </@pop_perm> {line:true} ] }, data:[], sortName: 'orgId',rownumbers:true,checkbox:true,usePager: false,height: '100%', width:"100%",heightDiff:-40,pageSize:g_pageSize, onChangeSort : function(){ getData(g.options.sortName,g.options.sortOrder,g_pageNo,g_pageSize); return false; },isChecked:checkedHandler,onCheckRow: checkRowHandler, onCheckAllRow: checkAllRowHandler }); //点击分页触发 } $(function(){ getData(g_pageNo,g_pageSize); }) /**初始时通过向后台传递排序id、排序顺序、初始页码、每页条数**/ function getData(pageNo,pageSize){ jQuery.post("${ctx}/org/listTapWaterUserPage.do", getFormParams(pageNo,pageSize), function(result){ gridData = result; //刷新表格 g.loadData(gridData); total_rows=gridData["pager.totalRows"]; //设置左边内容页 var content ="共有" + gridData["pager.totalRows"] + "条记录"; $("#letfContent").html(""); $("#letfContent").html(content); //取得分页组件 var pager=$("#pager"); //设置总页页数 pager.attr("total",gridData["pager.totalRows"]); pager.render(); //绑定翻页事件 pager.unbind("pageChange"); pager.bind("pageChange",function(e,index){ g_pageNo = index + 1; getData(g_pageNo,g_pageSize); }); //绑定选择每页显示记录数事件 pager.bind("sizeChange",function(e,num){ g_pageSize = num; getData(g_pageNo,g_pageSize); }); },"json"); } //查询 function searchHandler(){ //清空数组 clearArray(); //重新加载数据,设置当前页面为1 getData(1,g_pageSize); } /**获得查询表单的提交查询的值**/ function getFormParams(pageNo,pageSize){ $("#pageNo").val(pageNo); $("#pageSize").val(pageSize); return $("#searchForm").formToArray(); } /**重置于查询表单,然后重新加载表格数据**/ function resetSearch(){ //清空数组 clearArray(); $("#searchForm")[0].reset(); //重新加载数据,设置当前页面为1 getData(1,g_pageSize); } //新增 function addTapWaterUser() { top.Dialog.open({ ID:'a1', URL : "${ctx}/org/editTapWaterUser.do", Title : "新增自来水用户信息", Width : 850, Height : 350 }); } //修改 function onEdit(orgId) { top.Dialog.open({ ID:'a1', URL : "${ctx}/org/editTapWaterUser.do?orgId="+orgId, Title : "修改自来水用户信息", Width : 850, Height : 350 }); } //单条记录删除 function onDelete(rowid){ top.Dialog.confirm("确定要删除该记录吗?",function(){ //删除记录 jQuery.post("${ctx}/org/deleteTapWaterUser.do", {"orgId":rowid}, function(responseText){ if(responseText.status=="y"){ top.Dialog.alert(responseText.info); resetSearch(); }else{ top.Dialog.alert(responseText.info); } }, "json"); }); } var checkedArray = []; function findCheckedArray(id){ for(var i =0;i<checkedArray.length;i++){ if(checkedArray[i] == id) return i; } return -1; } function addCheckedArray(id,name){ if(findCheckedArray(id) == -1){ checkedArray.push(id); } } function removeCheckedArray(id){ var i = findCheckedArray(id); if(i==-1) return; checkedArray.splice(i,1); } function checkedHandler(rowdata){ if (findCheckedArray(rowdata.orgId) == -1) return false; return true; } function checkRowHandler(checked, data){ if (checked) addCheckedArray(data.orgId,data.orgName); else removeCheckedArray(data.orgId,data.orgName); } function checkAllRowHandler(checked){ for (var rowid in this.records){ if(checked) addCheckedArray(this.records[rowid]['orgId'],this.records[rowid]['orgName']); else removeCheckedArray(this.records[rowid]['orgId'],this.records[rowid]['orgName']); } } //导出自来水用户信息 function exportTapWaterUserExcel() { var rows = g.getSelectedRows(); var rowsLength = rows.length; var ids=getCheckedHandler(); if(rowsLength == 0 && ids=='') { exportTotalData(); return; } window.location.href="${ctx}/org/exportTapWaterUserExcel.do?ids="+ids+"&flag=selected"; return; } //导出处理 function exportTotalData(){ var orgNumber=$("#orgNumber").val(); var orgName=$("#orgName").val(); var busOrgCustomerNumber=$("#busOrgCustomerNumber").val(); var busOrgMeterNumber=$("#busOrgMeterNumber").val(); var year=$("#year").val(); var isPlanUser=$("#isPlanUser").val(); var url="${ctx}/org/exportTapWaterUserExcel.do?"; url +="orgNumber="+orgNumber; url +="&orgName="+orgName; url +="&busOrgCustomerNumber="+busOrgCustomerNumber; url +="&busOrgMeterNumber="+busOrgMeterNumber; url +="&year="+year; url +="&isPlanUser="+isPlanUser; url +="&flag=query"; url +="&pageNo=1"; url +="&pageSize="+total_rows; window.location =url; return false; } function getCheckedHandler() { return checkedArray.join(','); } //清空数组 function clearArray(){ checkedArray.length=0; } </script> </head> <body> <div class="box2" panelTitle="自来水用户信息列表"> <form action="" id="searchForm" method="post"> <input type="hidden" id="pageNo" name="pageNo" value="1" /> <input type="hidden" id="pageSize" name="pageSize" value="10" /> <table> <tr> <td>单位编号:</td> <td><input type="text" id="orgNumber" name="orgNumber" /></td> <td>单位名称:</td> <td><input type="text" id="orgName" name="orgName" /></td> <td>年度:</td> <td><input type="text" id="year" name="year" class="date" dateFmt="yyyy" value="${year!''}" /></td> </tr> <tr> <td align="right">客户号:</td> <td><input type="text" id="busOrgCustomerNumber" name="busOrgCustomerNumber" /></td> <td>水表编号:</td> <td><input type="text" id="busOrgMeterNumber" name="busOrgMeterNumber" /></td> <td>是否计划户:</td> <td><select prompt="请选择" id="isPlanUser" data='{"list":[{"value":"yes","key":"计划户"},{"value":"no","key":"非计划户"}]}' name="isPlanUser"></select></td> <td> <button type="button" onclick="searchHandler()"> <span class="icon_find">查询</span> </button> <button type="button" onclick="resetSearch()"> <span class="icon_reload">重置</span> </button> </td> </tr> </table> </form> </div> <div id="scrollContent"> <div class="padding_right5"> <div id="maingrid"></div> </div> </div> <!-- 分页组件 --> <div style="height: 35px;"> <div id="letfContent" class="float_left padding5"></div> <div class="float_right padding5"> <div id="pager" total="0" class="pageArrow" showSelect="true" inputPosition="right"></div> </div> <div class="clear"></div> </div> </body> </html>