<!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>