1aeaffee0ab90ae489091fc49239e4ec51a027a5.svn-base 16 KB

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