import-data-file-list.jsp 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363
  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" type="text/css"/>
  10. <link rel="stylesheet" type="text/css" id="skin" prePath="${ctx}/qui/"/>
  11. <link rel="stylesheet" type="text/css" id="customSkin"/>
  12. <!--框架必需end-->
  13. <!--数据表格start-->
  14. <script src="${ctx}/qui/libs/js/table/quiGrid.js" type="text/javascript"></script>
  15. <!--数据表格end-->
  16. <!--箭头分页start-->
  17. <script type="text/javascript" src="${ctx}/qui/libs/js/nav/pageArrow.js"></script>
  18. <!--箭头分页end-->
  19. <!--表单异步提交start-->
  20. <script src="${ctx}/qui/libs/js/form/form.js" type="text/javascript"></script>
  21. <!--表单异步提交end-->
  22. <script type="text/javascript">
  23. var g_pageNo = 1;
  24. var g_pageSize = 10;
  25. //刷新记忆
  26. var checkedArray = [];
  27. //定时刷新页面
  28. // var iID=setInterval("searchHandler()",5000);
  29. //数据表格使用
  30. var g;
  31. var gridData;
  32. function initComplete(){
  33. g = $("#maingrid").quiGrid({
  34. columns: [
  35. { display: '文件名', name: 'fileName', align: 'center', width: "16%"},
  36. { display: '文件大小', name: 'fileSize', align: 'center', width: "5%"},
  37. { display: '导入类型', name: 'showImportType', align: 'center', width: "8%"},
  38. { display: '上传时间', name: 'uploadTime', align: 'center', width: "5%"},
  39. { display: '数据年度信息', name: 'year', align: 'center', width: "8%"},
  40. { display: '数据状态', name: 'showImportStatus', align: 'center', width: "8%"},
  41. { display: '状态描述', name: 'statusDescription', align: 'center', width: "20%"
  42. ,render: function (rowdata, rowindex, value, column){
  43. if(rowdata.dataStatus=='in_import'){
  44. return '<span>'+value+'<img src="${ctx}/image/loading.gif" style="height:15px;width:15px;vertical-align:middel;"></span>';
  45. }else{
  46. return value;
  47. }
  48. }
  49. },
  50. { display: '创建人', name: 'showCreater', align: 'center', width: "5%"},
  51. { display: '创建时间', name: 'createTime', align: 'center', width: "8%"},
  52. { display: '操作', isAllowHide: false, align: 'center', width:"10%"
  53. ,render: function (rowdata, rowindex, value, column){
  54. var str =
  55. '<div class="padding_top4 padding_left20">'
  56. <@pop_perm url="/import/delete.do">
  57. + '<a href="#" onclick="onDelete('+ rowdata.importId+')"><span class="icon_remove">删除</span></a>'
  58. </@pop_perm>
  59. '</div>';
  60. if(rowdata.importType=='user_water_info'){
  61. str =
  62. '<div class="padding_top4 padding_left20">'
  63. <@pop_perm url="/import/delete.do">
  64. + '<a href="#" onclick="onDelete('+ rowdata.importId+')"><span class="icon_remove">删除</span></a>'
  65. </@pop_perm>
  66. <@pop_perm url="/import/delThisImport.do">
  67. + '<a href="#" onclick="delThisImport('+ rowdata.importId+')"><span class="icon_delete">删除数据</span></a>'
  68. </@pop_perm>
  69. '</div>';
  70. }
  71. return str;
  72. }
  73. }
  74. ],
  75. toolbar:{
  76. items:[
  77. <@pop_perm url="/import/importOrgInfo.do">
  78. {line:true},
  79. {text:'导入单位基本信息',click:importOrgInfo, iconClass:'icon_add'},
  80. </@pop_perm>
  81. <@pop_perm url="/import/importUserWaterInfo.do">
  82. {line:true},
  83. {text:'导入单位月用水量信息(mdb)',click:importUserWaterInfo, iconClass:'icon_add'},
  84. {line:true},
  85. {text:'导入单位月用水量信息(exce)',click:importExceWaterInfo, iconClass:'icon_add'},
  86. {line:true},
  87. {text:'同步oracle单位信息',click:importOracleOrgData, iconClass:'icon_add'},
  88. {line:true},
  89. {text:'同步oracle抄表',click:importOracleWaterData, iconClass:'icon_add'},
  90. </@pop_perm>
  91. <@pop_perm url="/import/delete.do">
  92. {line:true},
  93. {text:'批量删除',click:batchDelete, iconClass:'icon_delete'},
  94. </@pop_perm>
  95. {line:true}
  96. ]
  97. },
  98. data:[], sortName: 'importId',rownumbers:true,checkbox:true,usePager: false,height: '100%', width:"100%",heightDiff:-40,pageSize:g_pageSize,
  99. onChangeSort : function(){
  100. getData(g.options.sortName,g.options.sortOrder,g_pageNo,g_pageSize);
  101. return false;
  102. },isChecked:checkedHandler,onCheckRow: checkRowHandler, onCheckAllRow: checkAllRowHandler
  103. });
  104. //点击分页触发
  105. }
  106. $(function(){
  107. getData(g_pageNo,g_pageSize);
  108. })
  109. /**初始时通过向后台传递排序id、排序顺序、初始页码、每页条数**/
  110. function getData(pageNo,pageSize){
  111. jQuery.post("${ctx}/import/listPage.do",
  112. getFormParams(pageNo,pageSize),
  113. function(result){
  114. gridData = result;
  115. //刷新表格
  116. g.loadData(gridData);
  117. //设置左边内容页
  118. var content ="共有" + gridData["pager.totalRows"] + "条记录";
  119. $("#letfContent").html("");
  120. $("#letfContent").html(content);
  121. //取得分页组件
  122. var pager=$("#pager");
  123. //设置总页页数
  124. pager.attr("total",gridData["pager.totalRows"]);
  125. pager.render();
  126. //绑定翻页事件
  127. pager.unbind("pageChange");
  128. pager.bind("pageChange",function(e,index){
  129. g_pageNo = index + 1;
  130. getData(g_pageNo,g_pageSize);
  131. });
  132. //绑定选择每页显示记录数事件
  133. pager.bind("sizeChange",function(e,num){
  134. g_pageSize = num;
  135. getData(g_pageNo,g_pageSize);
  136. });
  137. },"json");
  138. }
  139. //查询
  140. function searchHandler(){
  141. // checkedArray.length = 0;
  142. //重新加载数据,设置当前页面为1
  143. getData(g_pageNo,g_pageSize);
  144. }
  145. /**获得查询表单的提交查询的值**/
  146. function getFormParams(pageNo,pageSize){
  147. $("#pageNo").val(pageNo);
  148. $("#pageSize").val(pageSize);
  149. return $("#searchForm").formToArray();
  150. }
  151. /**重置于查询表单,然后重新加载表格数据**/
  152. function resetSearch(){
  153. $("#searchForm")[0].reset();
  154. //重新加载数据,设置当前页面为1
  155. getData(g_pageNo,g_pageSize);
  156. }
  157. //单条记录删除
  158. function onDelete(rowid){
  159. top.Dialog.confirm("确定要删除该记录吗?",function(){
  160. //删除记录
  161. jQuery.post("${ctx}/import/delete.do",
  162. {"ids":rowid},
  163. function(responseText){
  164. if(responseText.status=="y"){
  165. top.Dialog.alert(responseText.info);
  166. resetSearch();
  167. }else{
  168. top.Dialog.alert(responseText.info);
  169. }
  170. },
  171. "json");
  172. });
  173. }
  174. //删除该批次下导入的数据
  175. function delThisImport(rowid){
  176. top.Dialog.confirm("确定要删除数据吗?",function(){
  177. //删除记录
  178. jQuery.post("${ctx}/import/delThisImport.do",
  179. {"ids":rowid},
  180. function(responseText){
  181. if(responseText.status=="y"){
  182. top.Dialog.alert(responseText.info);
  183. resetSearch();
  184. }else{
  185. top.Dialog.alert(responseText.info);
  186. }
  187. },
  188. "json");
  189. });
  190. }
  191. //批量删除
  192. function batchDelete() {
  193. var rows = g.getSelectedRows();
  194. var rowsLength = rows.length;
  195. if(rowsLength == 0) {
  196. top.Dialog.alert("请选中要删除的记录!");
  197. return;
  198. }
  199. top.Dialog.confirm("确定要删除吗?",function(){
  200. jQuery.post("${ctx}/import/delete.do",
  201. //获取所有选中行
  202. getSelectId(g),
  203. function(responseText){
  204. if(responseText.status=="y"){
  205. top.Dialog.alert(responseText.info);
  206. resetSearch();
  207. }else{
  208. top.Dialog.alert(responseText.info);
  209. return false;
  210. }
  211. },
  212. "json");
  213. });
  214. //获取所有选中行获取选中行的id 格式为 ids=1&ids=2
  215. function getSelectId(grid) {
  216. var selectedRows = grid.getSelectedRows();
  217. var selectedRowsLength = selectedRows.length;
  218. var ids = "";
  219. for(var i = 0;i<selectedRowsLength;i++) {
  220. ids += selectedRows[i].importId + ",";
  221. }
  222. return {"ids":ids};
  223. }
  224. }
  225. function importOrgInfo(){
  226. top.Dialog.open({
  227. URL:"${ctx}/import/importOrgInfo.do",
  228. Title:"导入单位基本信息",
  229. Width:750,
  230. Height:200
  231. });
  232. }
  233. function importOracleOrgData(){
  234. // alert("?");
  235. top.Dialog.open({
  236. URL:"${ctx}/import/importOracleOrgData.do",
  237. Title:"导入oracle单位信息",
  238. Width:750,
  239. Height:200
  240. });
  241. }
  242. function importOracleWaterData(){
  243. top.Dialog.open({
  244. URL:"${ctx}/import/importOracleWaterData.do",
  245. Title:"导入oracle抄表信息",
  246. Width:750,
  247. Height:200
  248. });
  249. }
  250. function importUserWaterInfo(){
  251. //alert("??");
  252. top.Dialog.open({
  253. URL:"${ctx}/import/importUserWaterInfo.do",
  254. Title:"导入单位月用水量信息",
  255. Width:750,
  256. Height:200
  257. });
  258. }
  259. function importExceWaterInfo(){
  260. //alert("??");
  261. top.Dialog.open({
  262. URL:"${ctx}/import/importExceWaterInfo.do",
  263. Title:"导入单位月用水量信息(exce)",
  264. Width:750,
  265. Height:200
  266. });
  267. }
  268. function findCheckedArray(id){
  269. for(var i =0;i<checkedArray.length;i++){
  270. if(checkedArray[i] == id) return i;
  271. }
  272. return -1;
  273. }
  274. function addCheckedArray(id,name){
  275. if(findCheckedArray(id) == -1){
  276. checkedArray.push(id);
  277. }
  278. }
  279. function removeCheckedArray(id){
  280. var i = findCheckedArray(id);
  281. if(i==-1) return;
  282. checkedArray.splice(i,1);
  283. }
  284. function checkedHandler(rowdata){
  285. if (findCheckedArray(rowdata.importId) == -1)
  286. return false;
  287. return true;
  288. }
  289. function checkRowHandler(checked, data){
  290. if (checked) addCheckedArray(data.importId,data.name);
  291. else removeCheckedArray(data.importId,data.name);
  292. }
  293. function checkAllRowHandler(checked){
  294. for (var rowid in this.records){
  295. if(checked){
  296. addCheckedArray(this.records[rowid]['importId'],this.records[rowid]['name']);
  297. }else{
  298. removeCheckedArray(this.records[rowid]['importId'],this.records[rowid]['name']);
  299. }
  300. }
  301. }
  302. </script>
  303. </head>
  304. <body>
  305. <div style="display:none;">
  306. <form action="" id="searchForm" method="post">
  307. <input type="hidden" id="pageNo" name="pageNo" value="1"/>
  308. <input type="hidden" id="pageSize" name="pageSize" value="10"/>
  309. </form>
  310. </div>
  311. <div id="scrollContent">
  312. <div class="padding_right5">
  313. <div id="maingrid"></div>
  314. </div>
  315. </div>
  316. <!-- 分页组件 -->
  317. <div style="height:35px;">
  318. <div id="letfContent" class="float_left padding5"></div>
  319. <div class="float_right padding5">
  320. <div id="pager" total="0" class="pageArrow" showSelect="true" inputPosition="right"></div>
  321. </div>
  322. <div class="clear"></div>
  323. </div>
  324. </body>
  325. </html>