excellist.html 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181
  1. <!DOCTYPE HTML>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <meta name="renderer" content="webkit|ie-comp|ie-stand">
  6. <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  7. <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />
  8. <meta http-equiv="Cache-Control" content="no-siteapp" />
  9. <!--[if lt IE 9]>
  10. <script type="text/javascript" src="${ctx}/assets/lib/html5.js"></script>
  11. <script type="text/javascript" src="${ctx}/assets/lib/respond.min.js"></script>
  12. <script type="text/javascript" src="${ctx}/assets/lib/PIE_IE678.js"></script>
  13. <![endif]-->
  14. <link rel="stylesheet" type="text/css" href="${ctx}/assets/static/h-ui/css/H-ui.min.css" />
  15. <link rel="stylesheet" type="text/css" href="${ctx}/assets/static/h-ui.admin/css/H-ui.admin.css" />
  16. <link rel="stylesheet" type="text/css" href="${ctx}/assets/lib/Hui-iconfont/1.0.7/iconfont.css" />
  17. <link rel="stylesheet" type="text/css" href="${ctx}/assets/lib/icheck/icheck.css" />
  18. <link rel="stylesheet" type="text/css" href="${ctx}/assets/static/h-ui.admin/skin/default/skin.css" id="skin" />
  19. <link rel="stylesheet" type="text/css" href="${ctx}/assets/static/h-ui.admin/css/style.css" />
  20. <link rel="stylesheet" type="text/css" href="${ctx}/assets/lib/zTree/v3/css/zTreeStyle/zTreeStyle.css" >
  21. <script type="text/javascript" src="${ctx}/assets/lib/My97DatePicker/WdatePicker.js"></script>
  22. <script type="text/ecmascript" src="${ctx}/assets/lib/jquery/1.9.1/jquery.js"></script>
  23. <script type="text/javascript" src="${ctx}/assets/lib/jquery.form/jquery.form.min.js"></script>
  24. <script type="text/javascript" src="${ctx}/assets/lib/layer/3.0.3/layer.js"></script>
  25. <script type="text/javascript" src="${ctx}/assets/static/h-ui/js/H-ui.js"></script>
  26. <link rel="stylesheet" type="text/css" media="screen" href="${ctx}/assets/lib/jqueryui/jquery-ui.css" />
  27. <link rel="stylesheet" type="text/css" media="screen" href="${ctx}/assets/lib/jqgrid/css/ui.jqgrid.css" />
  28. <script type="text/ecmascript" src="${ctx}/assets/lib/jqueryui/jquery-ui.js"></script>
  29. <script type="text/ecmascript" src="${ctx}/assets/lib/jqgrid/js/i18n/grid.locale-cn.js"></script>
  30. <script type="text/ecmascript" src="${ctx}/assets/lib/jqgrid/js/jquery.jqGrid.min.js"></script>
  31. <script type="text/javascript" src="${ctx}/assets/js/base.js"></script>
  32. <script type="text/javascript" src="${ctx}/assets/lib/zTree/v3/js/jquery.ztree.all-3.5.min.js"></script>
  33. <!--[if IE 6]>
  34. <script type="text/javascript" src="${ctx}/assets/lib/DD_belatedPNG_0.0.8a-min.js" ></script>
  35. <script>DD_belatedPNG.fix('*');</script>
  36. <![endif]-->
  37. <script type="text/javascript">
  38. $(function() {
  39. $(window).resize(function(){
  40. $("#jqGrid").setGridWidth($(window).width()-41); 
  41. });
  42. $("#jqGrid").jqGrid({
  43. url : '${ctx}/myconsole/complaint/register/getExcelPage',
  44. editurl:"${ctx}/myconsole/complaint/register",
  45. mtype : "POST",
  46. datatype : "json",
  47. multiselect: false,
  48. caption1:'受理数据导入',
  49. prmNames : { //定义表单的主键 // Default valuesprmNames: {page:“page”,rows:“rows”, sort: “sidx”,order: “sord”, search:“_search”, nd:“nd”, npage:null} 当参数为null时不会被发到服务器端
  50. id: "keyid", 
  51. oper:"oper",    
  52. addoper:"add",
  53. editoper:"edit",
  54. deloper:"del" 
  55. },
  56. colModel : [ {
  57. label : '数据编号',
  58. name : 'keyid',
  59. key : true,
  60. editable: false,
  61. hidden:true
  62. },{
  63. label : '原文件名',
  64. name : 'filename',
  65. width : 50,
  66. },{
  67. label : '导入用户',
  68. name : 'recordusername',
  69. width : 50,
  70. }, {
  71. label : '导入时间',
  72. name : 'recordtime',
  73. width : 50,
  74. },{
  75. label : '操作',
  76. name:'operMod',
  77. index:'operMod',
  78. align:"center",
  79. width:"30",
  80. sortable:false,
  81. formatter: function (cellvalue, options, rowdata) {
  82. var html ="";
  83. html = "<button class='btn btn-primary radius size-S' onclick=deleteData('"+rowdata.keyid+"')>删除</button>";
  84. return html;
  85. }
  86. }],
  87. rownumbers : true,//添加左侧行号
  88. viewrecords : true,//是否在浏览导航栏显示记录总数
  89. rowNum : 10,//每页显示记录数
  90. rowList : [10,15,20,30,40,50 ],//用于改变显示行数的下拉列表框的元素数组。
  91. autowidth : true,
  92. sortname : 'RecordTime',
  93. sortorder : 'desc',
  94. height : 'auto',
  95. pager : "#jqGridPager",
  96. //屏蔽点击任意单元格选中checkbox的问题
  97. beforeSelectRow: function (rowid, e) {
  98. var $myGrid = $(this),
  99. i = $.jgrid.getCellIndex($(e.target).closest('td')[0]),
  100. cm = $myGrid.jqGrid('getGridParam', 'colModel');
  101. return (cm[i].name === 'cb');
  102. }
  103. });
  104. $('#jqGrid')
  105. .navGrid('#jqGridPager',{edit:false,add:false,del:false,search:false})
  106. .navButtonAdd("#jqGridPager",
  107. { caption:"新建",
  108. buttonicon:"ui-icon-excel",
  109. onClickButton: function(){
  110. location.href="${ctx}/myconsole/complaint/register/excelImport";
  111. }, position:"last" });
  112. });
  113. //删除数据 2021-10-13
  114. function deleteData(keyid){
  115. layer.confirm('确认要删除该批导入的数据吗?',{btn:['确定','取消']},function(){
  116. $('#form1').attr('action','${ctx}/myconsole/complaint/transact/delExcel?KeyID='+keyid);
  117. $('#form1').ajaxSubmit(setDelData);
  118. });
  119. }
  120. function setDelData(data){
  121. var res=eval('(' + data + ')');
  122. if(res.flag){
  123. layer.alert(res.message, {skin: 'layui-layer-molv',closeBtn: 1},
  124. function(){
  125. layer.closeAll('dialog');
  126. window.location.reload();
  127. });
  128. }else{
  129. if(res.flag == false)
  130. {
  131. layer.alert(res.message, {skin: 'layui-layer-molv',closeBtn: 0}, function(){layer.closeAll('dialog');});
  132. }
  133. }
  134. }
  135. function downFile(filePath,fileName)
  136. {
  137. window.open('${serverURL!}/downloadFile.do?FileDownloadPath='+filePath+'&FileDownloadName='+fileName,'Derek','resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no');
  138. }
  139. </script>
  140. <title>我的桌面</title>
  141. </head>
  142. <body>
  143. <div>
  144. <div class="page-container">
  145. <form id="form1" method="post" class="form-horizontal" role="form">
  146. </form>
  147. <table id="jqGrid"></table>
  148. <div id="jqGridPager"></div>
  149. </div>
  150. </div>
  151. </body>
  152. </html>