tap-water-user-list.jsp 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  2. <html>
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  5. <title>自来水用户信息列表</title>
  6. <!--框架必需start-->
  7. <script type="text/javascript" src="${ctx}/qui/libs/js/jquery.js"></script>
  8. <script type="text/javascript" src="${ctx}/qui/libs/js/framework.js"></script>
  9. <link href="${ctx}/qui/libs/css/import_basic.css" rel="stylesheet"
  10. type="text/css" />
  11. <link rel="stylesheet" type="text/css" id="skin" prePath="${ctx}/qui/" />
  12. <link rel="stylesheet" type="text/css" id="customSkin" />
  13. <!--框架必需end-->
  14. <!--数据表格start-->
  15. <script src="${ctx}/qui/libs/js/table/quiGrid.js" type="text/javascript"></script>
  16. <!--数据表格end-->
  17. <!--箭头分页start-->
  18. <script type="text/javascript" src="${ctx}/qui/libs/js/nav/pageArrow.js"></script>
  19. <!--箭头分页end-->
  20. <!--表单异步提交start-->
  21. <script src="${ctx}/qui/libs/js/form/form.js" type="text/javascript"></script>
  22. <!--表单异步提交end-->
  23. <!-- 日期选择框start -->
  24. <script type="text/javascript"
  25. src="${ctx}/qui/libs/js/form/datePicker/WdatePicker.js"></script>
  26. <!-- 日期选择框end -->
  27. <script type="text/javascript">
  28. var g_pageNo = 1;
  29. var g_pageSize = 10;
  30. var total_rows=0;
  31. //刷新记忆
  32. var checkedArray = [];
  33. //数据表格使用
  34. var g;
  35. var gridData;
  36. function initComplete(){
  37. g = $("#maingrid").quiGrid({
  38. columns: [
  39. { display: '单位编号', name: 'orgNumber', align: 'center', width: "5%"},
  40. { display: '单位名称', name: 'orgName', align: 'center', width: "12%",
  41. render:function(rowdata, rowindex, value, column){
  42. return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
  43. }
  44. },
  45. { display: '单位地址', name: 'address', align: 'center', width: "15%",
  46. render:function(rowdata, rowindex, value, column){
  47. return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
  48. }
  49. },
  50. { display: '年度', name: 'year', align: 'center', width: "4%"},
  51. { display: '是否计划户', name: 'isPlanUser', align: 'center', width: "6%",
  52. render:function(rowdata, rowindex, value, column){
  53. if(value == "no"){
  54. return "<font color=green>非计划户</font>";
  55. }else if(value == "yes"){
  56. return "<font color=red>计划户</font>";
  57. }else{
  58. return "";
  59. }
  60. }
  61. },
  62. { display: '客户号', name: 'busOrgCustomerNumber', align: 'center', width: "8%",
  63. render:function(rowdata, rowindex, value, column){
  64. return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
  65. }
  66. },
  67. { display: '水表编号', name: 'busOrgMeterNumber', align: 'center', width: "8%"},
  68. { display: '单位类别', name: 'baseOrgType', align: 'center', width: "6%"},
  69. { display: '分片区管理', name: 'area', align: 'center', width: "6%"},
  70. { display: '备注', name: 'remark', align: 'center', width: "8%",
  71. render:function(rowdata, rowindex, value, column){
  72. if(value == null){
  73. return "";
  74. }else{
  75. return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
  76. }
  77. }
  78. },
  79. { display: '操作', isAllowHide: false, align: 'center', width:"15%",
  80. render: function (rowdata, rowindex, value, column){
  81. return '<div class="padding_top4 padding_left20">'
  82. <@pop_perm url="/org/viewTapWaterUserDetail.do">
  83. + '<a href="#" onclick="onView('+ rowdata.orgId+')"><span class="icon_view">查看详情</span></a>'
  84. </@pop_perm>
  85. <@pop_perm url="/org/editTapWaterUser.do">
  86. + '<a href="#" onclick="onEdit('+ rowdata.orgId+')"><span class="icon_edit">修改</span></a>'
  87. </@pop_perm>
  88. <@pop_perm url="/org/deleteTapWaterUser.do">
  89. + '<a href="#" onclick="onDelete('+ rowdata.orgId+')"><span class="icon_delete">删除</span></a>'
  90. </@pop_perm>
  91. + '</div>';
  92. }
  93. }],
  94. toolbar:{
  95. items:[
  96. <@pop_perm url="/org/editTapWaterUser.do">
  97. {text:'新增',click:addTapWaterUser,iconClass:'icon_add'},
  98. </@pop_perm>
  99. <@pop_perm url="/org/exportTapWaterUserExcel.do">
  100. {line:true},
  101. {text:'导出',click:exportTapWaterUserExcel, iconClass:'icon_export'},
  102. </@pop_perm>
  103. {line:true}
  104. ]
  105. },
  106. data:[], sortName: 'orgId',rownumbers:true,checkbox:true,usePager: false,height: '100%', width:"100%",heightDiff:-40,pageSize:g_pageSize,
  107. onChangeSort : function(){
  108. getData(g.options.sortName,g.options.sortOrder,g_pageNo,g_pageSize);
  109. return false;
  110. },isChecked:checkedHandler,onCheckRow: checkRowHandler, onCheckAllRow: checkAllRowHandler
  111. });
  112. //点击分页触发
  113. }
  114. $(function(){
  115. getData(g_pageNo,g_pageSize);
  116. })
  117. /**初始时通过向后台传递排序id、排序顺序、初始页码、每页条数**/
  118. function getData(pageNo,pageSize){
  119. jQuery.post("${ctx}/org/listTapWaterUserPage.do",
  120. getFormParams(pageNo,pageSize),
  121. function(result){
  122. gridData = result;
  123. //刷新表格
  124. g.loadData(gridData);
  125. total_rows=gridData["pager.totalRows"];
  126. //设置左边内容页
  127. var content ="共有" + gridData["pager.totalRows"] + "条记录";
  128. $("#letfContent").html("");
  129. $("#letfContent").html(content);
  130. //取得分页组件
  131. var pager=$("#pager");
  132. //设置总页页数
  133. pager.attr("total",gridData["pager.totalRows"]);
  134. pager.render();
  135. //绑定翻页事件
  136. pager.unbind("pageChange");
  137. pager.bind("pageChange",function(e,index){
  138. g_pageNo = index + 1;
  139. getData(g_pageNo,g_pageSize);
  140. });
  141. //绑定选择每页显示记录数事件
  142. pager.bind("sizeChange",function(e,num){
  143. g_pageSize = num;
  144. getData(g_pageNo,g_pageSize);
  145. });
  146. },"json");
  147. }
  148. //查询
  149. function searchHandler(){
  150. //清空数组
  151. clearArray();
  152. //重新加载数据,设置当前页面为1
  153. getData(1,g_pageSize);
  154. }
  155. /**获得查询表单的提交查询的值**/
  156. function getFormParams(pageNo,pageSize){
  157. $("#pageNo").val(pageNo);
  158. $("#pageSize").val(pageSize);
  159. return $("#searchForm").formToArray();
  160. }
  161. /**重置于查询表单,然后重新加载表格数据**/
  162. function resetSearch(){
  163. //清空数组
  164. clearArray();
  165. $("#searchForm")[0].reset();
  166. //重新加载数据,设置当前页面为1
  167. getData(1,g_pageSize);
  168. }
  169. //新增
  170. function addTapWaterUser() {
  171. top.Dialog.open({
  172. ID:'a1',
  173. URL : "${ctx}/org/editTapWaterUser.do",
  174. Title : "新增自来水用户信息",
  175. Width : 850,
  176. Height : 350
  177. });
  178. }
  179. //修改
  180. function onEdit(orgId) {
  181. top.Dialog.open({
  182. ID:'a1',
  183. URL : "${ctx}/org/editTapWaterUser.do?orgId="+orgId,
  184. Title : "修改自来水用户信息",
  185. Width : 850,
  186. Height : 350
  187. });
  188. }
  189. //单条记录删除
  190. function onDelete(rowid){
  191. top.Dialog.confirm("确定要删除该记录吗?",function(){
  192. //删除记录
  193. jQuery.post("${ctx}/org/deleteTapWaterUser.do",
  194. {"orgId":rowid},
  195. function(responseText){
  196. if(responseText.status=="y"){
  197. top.Dialog.alert(responseText.info);
  198. resetSearch();
  199. }else{
  200. top.Dialog.alert(responseText.info);
  201. }
  202. },
  203. "json");
  204. });
  205. }
  206. var checkedArray = [];
  207. function findCheckedArray(id){
  208. for(var i =0;i<checkedArray.length;i++){
  209. if(checkedArray[i] == id) return i;
  210. }
  211. return -1;
  212. }
  213. function addCheckedArray(id,name){
  214. if(findCheckedArray(id) == -1){
  215. checkedArray.push(id);
  216. }
  217. }
  218. function removeCheckedArray(id){
  219. var i = findCheckedArray(id);
  220. if(i==-1) return;
  221. checkedArray.splice(i,1);
  222. }
  223. function checkedHandler(rowdata){
  224. if (findCheckedArray(rowdata.orgId) == -1)
  225. return false;
  226. return true;
  227. }
  228. function checkRowHandler(checked, data){
  229. if (checked) addCheckedArray(data.orgId,data.orgName);
  230. else removeCheckedArray(data.orgId,data.orgName);
  231. }
  232. function checkAllRowHandler(checked){
  233. for (var rowid in this.records){
  234. if(checked)
  235. addCheckedArray(this.records[rowid]['orgId'],this.records[rowid]['orgName']);
  236. else
  237. removeCheckedArray(this.records[rowid]['orgId'],this.records[rowid]['orgName']);
  238. }
  239. }
  240. //导出自来水用户信息
  241. function exportTapWaterUserExcel() {
  242. var rows = g.getSelectedRows();
  243. var rowsLength = rows.length;
  244. var ids=getCheckedHandler();
  245. if(rowsLength == 0 && ids=='') {
  246. exportTotalData();
  247. return;
  248. }
  249. window.location.href="${ctx}/org/exportTapWaterUserExcel.do?ids="+ids+"&flag=selected";
  250. return;
  251. }
  252. //导出处理
  253. function exportTotalData(){
  254. var orgNumber=$("#orgNumber").val();
  255. var orgName=$("#orgName").val();
  256. var busOrgCustomerNumber=$("#busOrgCustomerNumber").val();
  257. var busOrgMeterNumber=$("#busOrgMeterNumber").val();
  258. var year=$("#year").val();
  259. var isPlanUser=$("#isPlanUser").val();
  260. var url="${ctx}/org/exportTapWaterUserExcel.do?";
  261. url +="orgNumber="+orgNumber;
  262. url +="&orgName="+orgName;
  263. url +="&busOrgCustomerNumber="+busOrgCustomerNumber;
  264. url +="&busOrgMeterNumber="+busOrgMeterNumber;
  265. url +="&year="+year;
  266. url +="&isPlanUser="+isPlanUser;
  267. url +="&flag=query";
  268. url +="&pageNo=1";
  269. url +="&pageSize="+total_rows;
  270. window.location =url;
  271. return false;
  272. }
  273. function getCheckedHandler()
  274. {
  275. return checkedArray.join(',');
  276. }
  277. //清空数组
  278. function clearArray(){
  279. checkedArray.length=0;
  280. }
  281. </script>
  282. </head>
  283. <body>
  284. <div class="box2" panelTitle="自来水用户信息列表">
  285. <form action="" id="searchForm" method="post">
  286. <input type="hidden" id="pageNo" name="pageNo" value="1" /> <input
  287. type="hidden" id="pageSize" name="pageSize" value="10" />
  288. <table>
  289. <tr>
  290. <td>单位编号:</td>
  291. <td><input type="text" id="orgNumber" name="orgNumber" /></td>
  292. <td>单位名称:</td>
  293. <td><input type="text" id="orgName" name="orgName" /></td>
  294. <td>年度:</td>
  295. <td><input type="text" id="year" name="year" class="date"
  296. dateFmt="yyyy" value="${year!''}" /></td>
  297. </tr>
  298. <tr>
  299. <td align="right">客户号:</td>
  300. <td><input type="text" id="busOrgCustomerNumber"
  301. name="busOrgCustomerNumber" /></td>
  302. <td>水表编号:</td>
  303. <td><input type="text" id="busOrgMeterNumber"
  304. name="busOrgMeterNumber" /></td>
  305. <td>是否计划户:</td>
  306. <td><select prompt="请选择" id="isPlanUser"
  307. data='{"list":[{"value":"yes","key":"计划户"},{"value":"no","key":"非计划户"}]}'
  308. name="isPlanUser"></select></td>
  309. <td>
  310. <button type="button" onclick="searchHandler()">
  311. <span class="icon_find">查询</span>
  312. </button>
  313. <button type="button" onclick="resetSearch()">
  314. <span class="icon_reload">重置</span>
  315. </button>
  316. </td>
  317. </tr>
  318. </table>
  319. </form>
  320. </div>
  321. <div id="scrollContent">
  322. <div class="padding_right5">
  323. <div id="maingrid"></div>
  324. </div>
  325. </div>
  326. <!-- 分页组件 -->
  327. <div style="height: 35px;">
  328. <div id="letfContent" class="float_left padding5"></div>
  329. <div class="float_right padding5">
  330. <div id="pager" total="0" class="pageArrow" showSelect="true"
  331. inputPosition="right"></div>
  332. </div>
  333. <div class="clear"></div>
  334. </div>
  335. </body>
  336. </html>