dashboardplan_index.html 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8" />
  5. <meta name="keywords" content="dongke,mes,ibossmes">
  6. <meta name="description" content="制造企业生产过程执行管理系统">
  7. <meta name="author" content="xuwei">
  8. <title>东科软件</title>
  9. <script src="/plugins/xeasyui/xeasyui.min.js"></script>
  10. <link href="/plugins/xeasyui/toolbar.min.css" rel="stylesheet" />
  11. </head>
  12. <body>
  13. <!--工具条-->
  14. <div id="tb" class="i-toolbar">
  15. <a href="javascript:void(0)" style="display:none" id="btnInsert" title="添加" class="easyui-linkbutton" iconcls="icon-add" plain="true" onclick="tbAdd()">添加</a>
  16. <a href="javascript:void(0)" style="display:none" id="btnUpdate" title="编辑" class="easyui-linkbutton" iconcls="icon-edit" plain="true" onclick="tbEdit()">修改</a>
  17. <a href="javascript:void(0)" style="display:none" id="btnDelete" title="删除" class="easyui-linkbutton" iconcls="icon-remove" plain="true" onclick="tbDelete()">删除</a>
  18. <a href="javascript:void(0)" style="display:none" id="btnDetail" title="详细" class="easyui-linkbutton" iconcls="icon-detail" plain="true" onclick="tbDetail()">详细</a>
  19. <a href="javascript:void(0)" style="display:none" id="btnCheckbox" title="显示复选框" class="easyui-linkbutton" iconcls="icon-ok" plain="true" toggle="true" onclick="tbCheck()">复选</a>
  20. <a href="javascript:void(0)" style="display:none" id="btnSearch" title="搜索" class="easyui-linkbutton" iconcls="icon-search" plain="true" toggle="true" onclick="tbSearch()">搜索</a>
  21. <a href="javascript:void(0)" style="display:none" id="btnImportIE" title="导入" class="easyui-linkbutton" iconcls="icon-excel" plain="true" onclick="tbImportIE()">导入IE数据</a>
  22. <a href="javascript:void(0)" style="display:none" id="btnImportSK" title="导入" class="easyui-linkbutton" iconcls="icon-excel" plain="true" onclick="tbImportSK()">导入生控数据</a>
  23. <a href="javascript:void(0)" style="display:none" id="btnImportZL" title="导入" class="easyui-linkbutton" iconcls="icon-excel" plain="true" onclick="tbImportZL()">导入质量数据</a>
  24. <a href="javascript:void(0)" style="display:none" id="btnExport" title="导出" class="easyui-linkbutton" iconcls="icon-excel" plain="true" onclick="tbExport()">导出</a>
  25. <!--<a href="javascript:void(0)" id="btnColumn" class="easyui-menubutton" data-options="menu:'#btnColumnMenu',iconCls:'icon-undo'">列显示</a>
  26. <div id="btnColumnMenu" style="width:150px;"></div>-->
  27. <a href="javascript:void(0)" id="btnReload" title="刷新" class="easyui-linkbutton" iconcls="icon-reload" plain="true" onclick="tbReload()">刷新</a>
  28. <a href="javascript:void(0)" id="btnHelp" title="帮助" class="easyui-linkbutton" iconcls="icon-help" plain="true" onclick="tbHelp()">帮助</a>
  29. <div id="tbSearchDiv" style="display:none;padding:10px;">
  30. <form id="ff">
  31. <div>
  32. 看板ID:
  33. <input class="easyui-textbox" id="DASHBOARDID" name="DASHBOARDID" data-options="required:false,prompt:'',tipPosition:'top'" style="width:80px;height:32px;">
  34. 计划类型:
  35. <input class="easyui-textbox" id="PLANTYPE" name="PLANTYPE" data-options="required:false,prompt:'',tipPosition:'top'" style="width:80px;height:32px;">
  36. 计划名称:
  37. <input class="easyui-textbox" id="PLANNAME" name="PLANNAME" data-options="required:false,prompt:'',tipPosition:'top'" style="width:80px;height:32px;">
  38. 计划年:
  39. <input class="easyui-textbox" id="PLANYEAR" name="PLANYEAR" data-options="required:false,prompt:'',tipPosition:'top'" style="width:80px;height:32px;">
  40. 计划月:
  41. <input class="easyui-textbox" id="PLANMONTH" name="PLANMONTH" data-options="required:false,prompt:'',tipPosition:'top'" style="width:80px;height:32px;">
  42. 计划日:
  43. <input class="easyui-textbox" id="PLANDAY" name="PLANDAY" data-options="required:false,prompt:'',tipPosition:'top'" style="width:80px;height:32px;">
  44. 计划小时:
  45. <input class="easyui-textbox" id="PLANHOUR" name="PLANHOUR" data-options="required:false,prompt:'',tipPosition:'top'" style="width:80px;height:32px;">
  46. <a href="javascript:void(0)" id="btnSearchSubmit" title="清空" class="easyui-linkbutton" plain="false" onclick="$('#ff').form('clear')">清空</a>
  47. <a href="javascript:void(0)" id="btnSearchSubmit" title="搜索" class="easyui-linkbutton" plain="false" onclick="tbSearchSubmit()">搜索</a>
  48. </div>
  49. </form>
  50. </div>
  51. </div>
  52. <!--表格-->
  53. <table id="dg" data-options="toolbar: '#tb',onDblClickRow: dgDblclickrow,showFooter:false">
  54. <!--
  55. <thead data-options="frozen:true">
  56. <tr>
  57. <th data-options="field:'标识',align:'left',sortable:true">标识</th>
  58. </tr>
  59. </thead>
  60. -->
  61. <thead>
  62. <tr>
  63. <th data-options="field:'SID',title:'SID',width:220,align:'left',checkbox:true,hidden:true">SID</th>
  64. <!--<th data-options="field:'PLANID',title:'计划ID',align:'left',sortable:true"></th>-->
  65. <th data-options="field:'DASHBOARDNAME',title:'看板',align:'left',sortable:true"></th>
  66. <th data-options="field:'PLANTYPENAME',title:'计划类型',align:'left',sortable:true"></th>
  67. <th data-options="field:'PLANNAME',title:'计划名称',align:'left',sortable:true"></th>
  68. <th data-options="field:'PLANYEAR',title:'计划年',align:'left',sortable:true"></th>
  69. <th data-options="field:'PLANMONTH',title:'计划月',align:'left',sortable:true"></th>
  70. <th data-options="field:'PLANDAY',title:'计划日',align:'left',sortable:true"></th>
  71. <th data-options="field:'PLANHOUR',title:'计划小时',align:'left',sortable:true"></th>
  72. <th data-options="field:'PLANNUM',title:'计划产量',align:'left',sortable:true"></th>
  73. <th data-options="field:'PLANUPPH',title:'计划UPPH',align:'left',sortable:true"></th>
  74. </tr>
  75. </thead>
  76. </table>
  77. <script type="text/javascript">
  78. //加载完成
  79. $(function () {
  80. //加载按钮
  81. $('#tb').buttonLoad({
  82. url:'dashboardplan.ashx?m=b'
  83. });
  84. //加载表格数据
  85. tbSearchSubmit()
  86. });
  87. //添加按钮
  88. function tbAdd() {
  89. $('#dg').datagridDialog({
  90. title: '添加数据',
  91. width: 640,
  92. height: 480,
  93. url: 'dashboardplan_add.html'
  94. });
  95. }
  96. //修改按钮
  97. function tbEdit() {
  98. $('#dg').datagridDialog({
  99. title: '修改数据',
  100. width: 640,
  101. height: 480,
  102. url: 'dashboardplan_edit.html',
  103. requireSelect: true
  104. });
  105. }
  106. //删除按钮
  107. function tbDelete() {
  108. $('#dg').datagridPost({
  109. title:'删除操作',
  110. url: 'dashboardplan.ashx?m=d',
  111. onValidate: function (r) { return true; }
  112. });
  113. }
  114. //详细按钮
  115. function tbDetail() {
  116. $('#dg').datagridDialog({
  117. title: '详细数据',
  118. width: 640,
  119. height: 480,
  120. url: 'dashboardplan_detail.html',
  121. requireSelect: true
  122. });
  123. }
  124. //复选按钮
  125. function tbCheck() {
  126. $('#dg').datagridCheckbox({
  127. buttonid: 'btnCheckbox',
  128. valuefield: 'SID'
  129. });
  130. }
  131. //搜索按钮
  132. function tbSearch() {
  133. $('#tbSearchDiv').toggle();
  134. $('#dg').datagrid('resize');
  135. }
  136. //搜索提交
  137. function tbSearchSubmit() {
  138. $('#dg').datagridLoad({
  139. title: '看板计划',
  140. idField: 'SID',
  141. queryParams: $('#ff').serializeJson(),
  142. url: 'dashboardplan.ashx?m=s',
  143. columnMenu: '#btnColumnMenu',
  144. columnMoving: false
  145. });
  146. }
  147. //导入IE
  148. function tbImportIE() {
  149. $('#dg').datagridDialog({
  150. title: '导入数据',
  151. width: 640,
  152. height: 380,
  153. url: 'dashboardplan_importIE.html'
  154. });
  155. }
  156. //导入生控
  157. function tbImportSK() {
  158. $('#dg').datagridDialog({
  159. title: '导入数据',
  160. width: 640,
  161. height: 380,
  162. url: 'dashboardplan_importSK.html'
  163. });
  164. }
  165. //导入质量
  166. function tbImportZL() {
  167. $('#dg').datagridDialog({
  168. title: '导入数据',
  169. width: 640,
  170. height: 380,
  171. url: 'dashboardplan_importZL.html'
  172. });
  173. }
  174. //导出
  175. function tbExport() {
  176. //加载表头
  177. var fields = $('#dg').datagrid('getColumnFields');
  178. var headers = [];
  179. for (var i = 0; i < fields.length; i++) {
  180. headers.push($('#dg').datagrid('getColumnOption', fields[i])['title']);
  181. //headers.push(fields[i]);
  182. }
  183. $('#dg').datagridExport({
  184. headers: headers,
  185. fileName: '导出数据(TP_MST_DASHBOARD_PLAN).xls',
  186. workSheet: '导出数据(TP_MST_DASHBOARD_PLAN)'
  187. });
  188. }
  189. //刷新
  190. function tbReload() {
  191. tbSearchSubmit();
  192. }
  193. //帮助事件
  194. function tbHelp() {
  195. $('#dg').datagridDialog({
  196. title: '帮助',
  197. width: 640,
  198. height: 480,
  199. url: 'rpt_help.html'
  200. });
  201. }
  202. //表格双击
  203. function dgDblclickrow(rowIndex, rowData) {
  204. tbDetail();
  205. }
  206. function formatterTrueFalse(value, row, index) { return value == 'True' ? '是' : '否'; }
  207. function stylerTrueFalse(value, row, index) { return value == 'True' ? 'color:black' : 'color:red'; }
  208. </script>
  209. </body>
  210. </html>