UIG040200.xrw 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <?xml-stylesheet type="text/css" href="../../css/body.css" ?>
  3. <xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
  4. <xhtml:head>
  5. <xhtml:title>
  6. <![CDATA[炼钢作业 >> 板坯库管理 >> 热轧原料库入库明细查询(UIG040200)]]>
  7. </xhtml:title>
  8. <model id="model1">
  9. <instance id="instance1">
  10. <root xmlns="">
  11. <formData>
  12. <SLAB_NO/>
  13. <REG_FROM_TIME/>
  14. <STL_GRD/>
  15. <REG_END_TIME/>
  16. <FROM_DATE/>
  17. <FROM_TIME>000000</FROM_TIME>
  18. <END_DATE/>
  19. <END_TIME>235959</END_TIME>
  20. <SLAB_FAC/>
  21. <SLAB_STOCK_TYPE/>
  22. <SLAB_MIN_LEN>0</SLAB_MIN_LEN>
  23. <SLAB_MAX_LEN>100000</SLAB_MAX_LEN>
  24. <SLAB_MIN_WTH>0</SLAB_MIN_WTH>
  25. <SLAB_MAX_WTH>100000</SLAB_MAX_WTH>
  26. <IGR_LAG_FROM_DTIME>-999999999</IGR_LAG_FROM_DTIME>
  27. <IGR_LAG_TO_DTIME>999999999</IGR_LAG_TO_DTIME>
  28. <CUT_LAG_FROM_DTIME>-999999999</CUT_LAG_FROM_DTIME>
  29. <CUT_LAG_TO_DTIME>999999999</CUT_LAG_TO_DTIME>
  30. <ORD_NO/>
  31. <ORD_SEQ/>
  32. </formData>
  33. <grid/>
  34. <reqData/>
  35. <resData/>
  36. <initResult/>
  37. <totalData>
  38. <slabCnt/>
  39. <slabWgt/>
  40. </totalData>
  41. <initData>
  42. <LG_CD>D01003,D01001,G04001</LG_CD>
  43. </initData>
  44. <codeData>
  45. <ORD_SEQ/>
  46. </codeData>
  47. </root>
  48. </instance>
  49. <script type="javascript" src="../../js/boaCommon.js"/>
  50. <script type="javascript" src="../../js/G02.js"/>
  51. <script type="javascript" src="../../js/mesCommon.js"/>
  52. <script type="javascript" src="../../js/b01.js"/>
  53. <script type="javascript" src="../../js/boaMsg.js"/>
  54. <script type="javascript" src="../../js/bCommon.js"/>
  55. <script type="javascript" ev:event="xforms-ready">
  56. <![CDATA[
  57. initPage();
  58. ]]>
  59. </script>
  60. </model>
  61. <script type="javascript" src="../../js/boaCommon.js"/>
  62. <script type="javascript" src="../../js/G02.js"/>
  63. <script type="javascript" src="../../js/mesCommon.js"/>
  64. <script type="javascript" src="../../js/b01.js"/>
  65. <script type="javascript" src="../../js/boaMsg.js"/>
  66. <script type="javascript" src="../../js/bCommon.js"/>
  67. <script type="javascript">
  68. <![CDATA[
  69. function excelExport(){
  70. return datagrid1;
  71. }
  72. function initPage(){
  73. commSendReq("/root/initData");
  74. commSubmit("UIGCOMMCODE-service","find","glueAction.do");
  75. model.copyNode("/root/codeData","/root/resData");
  76. commSendReq("root/reqData");
  77. commSubmit("UIG04COMBOX-service","stlSch","glueAction.do");//提交服务
  78. model.duplicate("/root/initResult","/root/resData");//复制结点
  79. model.refresh();
  80. }
  81. function find(){
  82. if(input4.value == "")
  83. {
  84. if(commDiffDay(input5.value,input6.value)>10)
  85. {
  86. window.alert("查询时间不能超过10天");
  87. return;
  88. }
  89. }
  90. if(model.getValue("/root/formData/END_DATE") == null || model.getValue("/root/formData/END_DATE") == "" || model.getValue("/root/formData/REG_FROM_TIME") == null || model.getValue("/root/formData/REG_FROM_TIME") == ""){
  91. var curDate = CurentDate();
  92. model.setValue("/root/formData/END_DATE",curDate);
  93. model.setValue("/root/formData/FROM_DATE",curDate);
  94. }
  95. model.setValue("/root/formData/REG_END_TIME",model.getValue("/root/formData/END_DATE") + model.getValue("/root/formData/END_TIME"));
  96. model.setValue("/root/formData/REG_FROM_TIME",model.getValue("/root/formData/FROM_DATE") + model.getValue("/root/formData/FROM_TIME"));
  97. commSendReq("/root/formData");
  98. commSubmit("UIG040200-service","find","glueAction.do");
  99. commAppendData("/root/grid/SLAB_TAKEIN_RESULT_VO","/root/resData/SLAB_TAKEIN_RESULT_VO");
  100. datagrid1.refresh();
  101. var slabCnt = 0;
  102. var slabWgt = 0;
  103. datagrid1.refresh();
  104. for(var i = 1 ; i < datagrid1.rows-1 ; i++){
  105. datagrid1.valueMatrix(i+1,datagrid1.colRef("SEQ")) = i;
  106. slabCnt = slabCnt + 1;
  107. slabWgt = slabWgt + parseFloat(datagrid1.valueMatrix(i+1,datagrid1.colRef("SLAB_WGT")));
  108. }
  109. model.setValue("/root/totalData/slabCnt",slabCnt);
  110. model.setValue("/root/totalData/slabWgt",slabWgt/1000);
  111. output1.refresh();
  112. output2.refresh();
  113. }
  114. ]]>
  115. </script>
  116. </xhtml:head>
  117. <xhtml:body>
  118. <datagrid id="datagrid1" nodeset="/root/grid/SLAB_TAKEIN_RESULT_VO/SLAB_TAKEIN_RESULT_Row" caption="序号^板坯号^计划钢种^钢种^厚^宽^长^重量^磅重^堆垛位置^入库时间^入库滞后时间^合同号^订单号^开浇时间^浇铸结束时间^判定时间^判定滞后时间(小时)^切割时间^切割滞后时间(小时)^备注|序号^板坯号^计划钢种^钢种^厚^宽^长^重量^磅重^堆垛位置^入库时间^入库滞后时间^合同号^订单号^开浇时间^浇铸结束时间^判定时间^判定滞后时间(小时)^切割时间^切割滞后时间(小时)^备注" colsep="^" colwidth="38, 100, 100, 100, 50, 50, 50, 70, 66, 100, 120, 100, 100, 100, 100, 100, 100, 100, 100, 100, 264" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:75px; width:980px; height:525px; ">
  119. <col ref="SEQ" visibility="hidden"/>
  120. <col editable="false" ref="SLAB_NO" type="input"/>
  121. <col ref="STL"/>
  122. <col editable="false" ref="STL_GRD" type="input"/>
  123. <col editable="false" ref="SLAB_THK" type="input"/>
  124. <col editable="false" ref="SLAB_WTH" type="input"/>
  125. <col editable="false" ref="SLAB_LEN" type="input"/>
  126. <col editable="false" ref="SLAB_WGT" type="input"/>
  127. <col editable="false" ref="WEIGHT_WGT" type="input"/>
  128. <col editable="false" ref="CUR_LOAD_LOC" type="input"/>
  129. <col editable="false" ref="SLAB_STOCK_ENT_DTIME" type="input" format="yyyy-mm-dd hh:nn"/>
  130. <col ref="STOCK_LAG_DTIME"/>
  131. <col ref="ORD_NO"/>
  132. <col ref="ORD_SEQ"/>
  133. <col ref="CASTING_STA_DTIME" format="yyyy-mm-dd hh:nn"/>
  134. <col ref="CASTING_END_DTIME" format="yyyy-mm-dd hh:nn"/>
  135. <col ref="INGR_DEC_DTIME" format="yyyy-mm-dd hh:nn"/>
  136. <col ref="CUT_LAG_DTIME"/>
  137. <col ref="SLAB_CUT_DTIME" format="yyyy-mm-dd hh:nn"/>
  138. <col ref="CUT_LAG_DTIME"/>
  139. <col ref="REMARKS" type="input"/>
  140. </datagrid>
  141. <caption id="caption10" class="cell" style="left:835px; top:5px; width:60px; height:20px; font-weight:bold; background-color:#ffcc00; border-color:#000000; ">重量合计</caption>
  142. <caption id="caption11" style="left:820px; top:6px; width:20px; height:20px; font-weight:bold; ">块</caption>
  143. <caption id="caption12" style="left:960px; top:5px; width:20px; height:20px; font-weight:bold; ">吨</caption>
  144. <line id="line2" style="x1:730px; y1:25px; x2:790px; y2:25px; "/>
  145. <line id="line3" style="x1:880px; y1:25px; x2:960px; y2:25px; "/>
  146. <caption id="caption9" class="cell" style="left:720px; top:5px; width:60px; height:20px; font-weight:bold; background-color:#ffcc00; border-color:#000000; ">块数合计</caption>
  147. <output id="output1" ref="/root/totalData/slabCnt" style="left:780px; top:5px; width:40px; height:20px; text-align:center; "/>
  148. <output id="output2" ref="/root/totalData/slabWgt" style="left:895px; top:5px; width:65px; height:20px; text-align:center; "/>
  149. <caption id="caption1" class="cell" style="left:0px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">板坯号</caption>
  150. <select1 id="combo1" ref="/root/formData/STL_GRD" appearance="minimal" editmode="inputsearch" style="left:489px; top:0px; width:90px; height:20px; text-align:left; ">
  151. <choices>
  152. <itemset nodeset="/root/initResult/resData/STL_GRD_SELECT_VO/STL_GRD_SELECT_Row">
  153. <label ref="FAC_STL_GRD"/>
  154. <value ref="FAC_CODE"/>
  155. </itemset>
  156. </choices>
  157. </select1>
  158. <select1 id="combo2" ref="/root/formData/SLAB_FAC" appearance="minimal" editmode="inputsearch" style="left:215px; top:25px; width:90px; height:20px; text-align:left; ">
  159. <choices>
  160. <item>
  161. <label>一钢厂</label>
  162. <value>一钢</value>
  163. </item>
  164. <item>
  165. <label>二钢厂</label>
  166. <value>二钢</value>
  167. </item>
  168. <item>
  169. <label>三钢厂</label>
  170. <value>三钢</value>
  171. </item>
  172. <item>
  173. <label>全部</label>
  174. <value/>
  175. </item>
  176. </choices>
  177. </select1>
  178. <caption id="caption3" class="cell" style="left:155px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">产 地</caption>
  179. <caption id="caption13" class="cell" style="left:0px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">入库时间</caption>
  180. <caption id="caption4" class="cell" style="left:429px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">钢 种</caption>
  181. <input id="input2" ref="/root/formData/FROM_TIME" class="input" format="hh:nn:ss" style="left:150px; top:0px; width:90px; height:20px; ">
  182. <script type="javascript" ev:event="xforms-value-changed">
  183. <![CDATA[
  184. if(model.getValue("/root/formData/REG_END_TIME") == null || model.getValue("/root/formData/REG_END_TIME") == ""||
  185. model.getValue("/root/formData/REG_FROM_TIME") > model.getValue("/root/formData/REG_END_TIME")){
  186. model.setValue("/root/formData/REG_END_TIME",model.getValue("/root/formData/REG_FROM_TIME"));
  187. input6.refresh();
  188. }
  189. ]]>
  190. </script>
  191. </input>
  192. <input id="input3" ref="/root/formData/END_TIME" class="input" format="hh:nn:ss" style="left:334px; top:0px; width:90px; height:20px; ">
  193. <script type="javascript" ev:event="xforms-value-changed">
  194. <![CDATA[
  195. if(model.getValue("/root/formData/REG_FROM_TIME") == null || model.getValue("/root/formData/REG_FROM_TIME") == ""||
  196. model.getValue("/root/formData/REG_FROM_TIME") > model.getValue("/root/formData/REG_END_TIME")){
  197. model.setValue("/root/formData/REG_FROM_TIME",model.getValue("/root/formData/REG_END_TIME"));
  198. input5.refresh();
  199. }
  200. ]]>
  201. </script>
  202. </input>
  203. <line id="line4" style="x1:239px; y1:10px; x2:244px; y2:10px; "/>
  204. <input id="input4" ref="/root/formData/SLAB_NO" style="left:60px; top:25px; width:90px; height:20px; "/>
  205. <input id="input5" ref="/root/formData/FROM_DATE" class="input" inputtype="date" format="yyyy-mm-dd" style="left:60px; top:0px; width:90px; height:20px; ">
  206. <script type="javascript" ev:event="xforms-value-changed">
  207. <![CDATA[
  208. if(model.getValue("/root/formData/END_DATE") == null || model.getValue("/root/formData/END_DATE") == ""||
  209. model.getValue("/root/formData/FROM_DATE") > model.getValue("/root/formData/END_DATE")){
  210. model.setValue("/root/formData/END_DATE",model.getValue("/root/formData/FROM_DATE"));
  211. input6.refresh();
  212. }
  213. ]]>
  214. </script>
  215. </input>
  216. <input id="input6" ref="/root/formData/END_DATE" class="input" inputtype="date" format="yyyy-mm-dd" style="left:244px; top:0px; width:90px; height:20px; ">
  217. <script type="javascript" ev:event="xforms-value-changed">
  218. <![CDATA[
  219. if(model.getValue("/root/formData/FROM_DATE") == null || model.getValue("/root/formData/FROM_DATE") == ""||
  220. model.getValue("/root/formData/FROM_DATE") > model.getValue("/root/formData/END_DATE")){
  221. model.setValue("/root/formData/FROM_DATE",model.getValue("/root/formData/END_DATE"));
  222. input5.refresh();
  223. }
  224. ]]>
  225. </script>
  226. </input>
  227. <caption id="caption2" class="cell" style="left:584px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">入库类型</caption>
  228. <select1 id="combo8" ref="/root/formData/SLAB_STOCK_TYPE" appearance="minimal" style="left:644px; top:0px; width:60px; height:20px; ">
  229. <choices>
  230. <itemset nodeset="/root/codeData/COMM_CODE_RESULT_VO/COMM_CODE_RESULT_Row[LG_CD = 'G04001' or LG_CD = 'A']">
  231. <label ref="SM_CFNM"/>
  232. <value ref="SM_CD"/>
  233. </itemset>
  234. </choices>
  235. </select1>
  236. <select1 id="combo3" ref="/root/formData/SLAB_MIN_LEN" appearance="minimal" editmode="input" style="left:370px; top:25px; width:60px; height:20px; text-align:left; ">
  237. <choices>
  238. <itemset nodeset="/root/codeData/COMM_CODE_RESULT_VO/COMM_CODE_RESULT_Row[LG_CD = 'D01003']">
  239. <label ref="SM_CD"/>
  240. <value ref="SM_CD"/>
  241. </itemset>
  242. </choices>
  243. </select1>
  244. <select1 id="combo4" ref="/root/formData/SLAB_MAX_LEN" appearance="minimal" editmode="input" style="left:437px; top:25px; width:65px; height:20px; text-align:left; ">
  245. <choices>
  246. <itemset nodeset="/root/codeData/COMM_CODE_RESULT_VO/COMM_CODE_RESULT_Row[LG_CD = 'D01003']">
  247. <label ref="SM_CD"/>
  248. <value ref="SM_CD"/>
  249. </itemset>
  250. </choices>
  251. </select1>
  252. <caption id="caption5" class="cell" style="left:310px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">长度范围</caption>
  253. <line id="line1" style="x1:431px; y1:35px; x2:436px; y2:35px; "/>
  254. <caption id="caption15" class="cell" style="left:507px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">宽度范围</caption>
  255. <select1 id="combo11" ref="/root/formData/SLAB_MIN_WTH" appearance="minimal" editmode="input" style="left:567px; top:25px; width:60px; height:20px; text-align:left; ">
  256. <choices>
  257. <itemset nodeset="/root/codeData/COMM_CODE_RESULT_VO/COMM_CODE_RESULT_Row[LG_CD = 'D01001']">
  258. <label ref="SM_CD"/>
  259. <value ref="SM_CD"/>
  260. </itemset>
  261. </choices>
  262. </select1>
  263. <select1 id="combo12" ref="/root/formData/SLAB_MAX_WTH" appearance="minimal" editmode="input" style="left:634px; top:25px; width:65px; height:20px; text-align:left; ">
  264. <choices>
  265. <itemset nodeset="/root/codeData/COMM_CODE_RESULT_VO/COMM_CODE_RESULT_Row[LG_CD = 'D01001']">
  266. <label ref="SM_CD"/>
  267. <value ref="SM_CD"/>
  268. </itemset>
  269. </choices>
  270. </select1>
  271. <line id="line6" style="x1:628px; y1:35px; x2:633px; y2:35px; "/>
  272. <input id="input7" ref="/root/formData/CUT_LAG_FROM_DTIME" visibility="visible" style="left:541px; top:50px; width:63px; height:20px; "/>
  273. <input id="input8" ref="/root/formData/IGR_LAG_TO_DTIME" visibility="visible" style="left:371px; top:50px; width:63px; height:20px; "/>
  274. <input id="input9" ref="/root/formData/CUT_LAG_TO_DTIME" visibility="visible" style="left:605px; top:50px; width:58px; height:20px; "/>
  275. <caption id="caption26" class="cell" visibility="visible" style="left:225px; top:50px; width:91px; height:20px; font-weight:bold; border-color:#000000; ">切割滞后时间</caption>
  276. <caption id="caption27" class="cell" visibility="visible" style="left:435px; top:50px; width:105px; height:20px; font-weight:bold; border-color:#000000; ">判定滞后时间</caption>
  277. <input id="input1" ref="/root/formData/IGR_LAG_FROM_DTIME" visibility="visible" style="left:307px; top:50px; width:63px; height:20px; "/>
  278. <caption id="caption6" class="cell" style="left:0px; top:50px; width:90px; height:20px; vertical-align:middle; ">合同号</caption>
  279. <select1 id="combo5" ref="/root/formData/ORD_SEQ" appearance="minimal" editmode="search" style="left:174px; top:50px; width:45px; height:20px; ">
  280. <choices>
  281. <itemset nodeset="/root/codeData/ORD_SEQ/rs_VO/rs_Row">
  282. <label ref="ORD_SEQ"/>
  283. <value ref="ORD_SEQ"/>
  284. </itemset>
  285. </choices>
  286. </select1>
  287. <input id="input10" ref="/root/formData/ORD_NO" maxlength="12" style="left:92px; top:50px; width:80px; height:20px; ">
  288. <script type="javascript" ev:event="xforms-value-changed">
  289. <![CDATA[
  290. model.setValue("/root/formData/ORD_SEQ", "");
  291. commSendReq("/root/formData");
  292. commSubmit("UIG040200-service","seq","glueAction.do");
  293. //model.setValue("/root/formData/searchInfo/ORD_SEQ", model.getValue("/root/codeData/ORD_SEQ/ListResult_0_VO/ListResult_0_Row[ORD_SEQ != '']/ORD_SEQ"));
  294. model.copyNode("/root/codeData/ORD_SEQ","/root/resData");
  295. ]]>
  296. </script>
  297. </input>
  298. <button id="button1" style="left:670px; top:50px; width:100px; height:20px; ">
  299. <caption>button1</caption>
  300. <script type="javascript" ev:event="DOMActivate">
  301. <![CDATA[
  302. find();
  303. ]]>
  304. </script>
  305. </button>
  306. <button id="button7" visibility="visible" style="left:900px; top:45px; width:60px; height:20px; font-family:黑体; color:#3366ff; background-color:#ffffff; ">
  307. <caption>导出EXCEL</caption>
  308. <script type="javascript" ev:event="DOMActivate">
  309. <![CDATA[
  310. //saveExcelScript(datagrid1, "Sheet1");
  311. if(datagrid1.rows<= 2){
  312. window.alert("无数据源,请先查询.", "提示");
  313. return;
  314. }
  315. var jsonMerges="[{'name':'y','x':0,'y':0,'cnt':1}]";
  316. var _cnt = datagrid1.selectedRows;
  317. commonOutExcel('dataRKMX',datagrid1.caption,'/root/grid/SLAB_TAKEIN_RESULT_VO','UIH090060-service',jsonMerges,'xls');
  318. ]]>
  319. </script>
  320. </button>
  321. </xhtml:body>
  322. </xhtml:html>