UIH051100.xrw 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628
  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[热轧作业>>钢卷库管理>>库存数据查询(UIH051100)]]>
  7. </xhtml:title>
  8. <model id="model1">
  9. <instance id="instance1">
  10. <root xmlns="">
  11. <formData>
  12. <COIL_NO/>
  13. <ORD_NO/>
  14. <ORD_FL/>
  15. <FROM_DATE/>
  16. <TO_DATE/>
  17. <CUR_LOAD_LOC/>
  18. <STL_GRD/>
  19. <COIL_WTH_MIN/>
  20. <COIL_THK_MIN/>
  21. <CUR_PROG_CD/>
  22. <COIL_THK_MAX/>
  23. <COIL_WTH_MAX/>
  24. <QK_YN/>
  25. <sql_ord_fl/>
  26. <YCYY/>
  27. <sql_ord_fl2/>
  28. <ORD_DEVLMT_DATE/>
  29. <DLIV_TP/>
  30. <COIL_DEFECTIVE/>
  31. <SMP_SEND_DTIME/>
  32. <XSQY/>
  33. <RCVORD_CLF/>
  34. <PROD_LINE/>
  35. <PRODNM_CD/>
  36. <DLIV_TP1/>
  37. <SPM_TYPE/>
  38. <ROLLFR/>
  39. <ROLLTO/>
  40. </formData>
  41. <reqData/>
  42. <resData/>
  43. <grid1/>
  44. <sumData>
  45. <SUM_COILRST_CNT/>
  46. <SUM_COILRST_WGT/>
  47. </sumData>
  48. <boolData>
  49. <qk_yn/>
  50. <ord_fl/>
  51. </boolData>
  52. </root>
  53. </instance>
  54. </model>
  55. <script type="javascript" src="../../js/boaMsg.js"/>
  56. <script type="javascript" src="../../js/boaCommon.js"/>
  57. <script type="javascript" src="../../js/bCommon.js"/>
  58. <script type="javascript" src="../../js/b01.js"/>
  59. <script type="javascript">
  60. <![CDATA[
  61. function excelExport(){
  62. return datagrid1;
  63. }
  64. function find()
  65. {
  66. datagrid1.rebuildStyle();
  67. commSendReq("/root/formData");
  68. commSubmit("UIH051100-service","find","glueAction.do");
  69. commAppendData("/root/grid1/UIH051100_RESULT_VO","/root/resData/UIH051100_RESULT_VO");
  70. model.refresh();
  71. var slabCnt = 0;
  72. var slabWgt = 0;
  73. for(var i = 1 ; i < datagrid1.rows-1 ; i++){
  74. datagrid1.valueMatrix(i+1,datagrid1.colRef("SEQ")) = i;
  75. slabCnt = slabCnt + 1;
  76. var slab_wgt = datagrid1.valueMatrix(i + 1,datagrid1.colRef("ACT_WGT"));
  77. if(slab_wgt == null || slab_wgt == ""){
  78. slab_wgt = "0";
  79. }
  80. slabWgt =slabWgt + parseFloat(slab_wgt);
  81. }
  82. model.setValue("/root/sumData/SUM_COILRST_CNT",slabCnt);
  83. model.setValue("/root/sumData/SUM_COILRST_WGT",slabWgt/1000);
  84. output1.refresh();output2.refresh();
  85. //综合判定不合格的,给于红颜色的提示.待判
  86. var nodeSet1 = datagrid1.nodeset;
  87. for(var i=1;i<datagrid1.rows;i++){
  88. var TOT_DEC_GRD = model.getValue(nodeSet1+"["+i+"]/TOT_DEC_GRD");
  89. var qk_yn = model.getValue(nodeSet1+"["+i+"]/QK_YN");
  90. if(TOT_DEC_GRD == "不合格"){
  91. datagrid1.rowstyle(i+1, "data", "background-color") = "#ff0000";
  92. }
  93. if(qk_yn == "清库卷"){
  94. datagrid1.rowstyle(i+1, "data", "background-color") = "#FFFF00";
  95. }
  96. }
  97. model.refresh();
  98. }
  99. ]]>
  100. </script>
  101. </xhtml:head>
  102. <xhtml:body>
  103. <caption id="caption10" class="cell" style="left:810px; top:90px; width:70px; height:20px; font-weight:bold; background-color:#ffcc00; border-color:#000000; ">重量合计</caption>
  104. <caption id="caption1" class="cell" style="left:631px; top:0px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">垛 位</caption>
  105. <caption id="caption11" style="left:775px; top:90px; width:30px; height:20px; font-weight:bold; ">卷</caption>
  106. <select1 id="combo1" ref="/root/formData/STL_GRD" appearance="minimal" editmode="inputsearch" style="left:239px; top:0px; width:91px; height:20px; text-align:left; ">
  107. <choices>
  108. <itemset nodeset="/root/initResult/resData/STL_GRD_SELECT_VO/STL_GRD_SELECT_Row">
  109. <label ref="FAC_STL_GRD"/>
  110. <value ref="FAC_CODE"/>
  111. </itemset>
  112. </choices>
  113. </select1>
  114. <caption id="caption2" class="cell" style="left:0px; top:0px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">钢 卷 号</caption>
  115. <caption id="caption12" style="left:960px; top:90px; width:20px; height:20px; font-weight:bold; ">吨</caption>
  116. <caption id="caption3" class="cell" style="left:167px; top:0px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">钢 号</caption>
  117. <caption id="caption13" class="cell" style="left:410px; top:25px; width:85px; height:20px; font-weight:bold; border-color:#000000; ">入库时间</caption>
  118. <caption id="caption4" class="cell" style="left:465px; top:0px; width:50px; height:20px; font-weight:bold; border-color:#000000; ">宽 度</caption>
  119. <caption id="caption5" class="cell" style="left:336px; top:0px; width:49px; height:20px; font-weight:bold; border-color:#000000; ">厚 度</caption>
  120. <line id="line2" style="x1:730px; y1:120px; x2:790px; y2:120px; "/>
  121. <select1 id="combo5" ref="/root/formData/ORD_FL" appearance="minimal" editmode="inputsearch" style="left:239px; top:25px; width:90px; height:20px; text-align:left; ">
  122. <choices>
  123. <item>
  124. <label>订单材</label>
  125. <value>1</value>
  126. </item>
  127. <item>
  128. <label>余材</label>
  129. <value>2</value>
  130. </item>
  131. <item>
  132. <label>二级库存</label>
  133. <value>3</value>
  134. </item>
  135. <item>
  136. <label/>
  137. <value/>
  138. </item>
  139. </choices>
  140. <script type="javascript" ev:event="xforms-value-changed">
  141. <![CDATA[
  142. model.setValue("/root/formData/sql_ord_fl2","");
  143. var sqlStr = "";
  144. if(model.getValue("/root/formData/ORD_FL") == "1"){
  145. combo3.disabled = true;
  146. combo3.refresh();
  147. sqlStr = "AND (A.ORD_FL = '1' AND (A.QK_YN IS NULL OR A.QK_YN <> 'Y'))".toString();
  148. }else if(model.getValue("/root/formData/ORD_FL") == "2"){
  149. combo3.disabled = false;
  150. combo3.refresh();
  151. sqlStr = " AND (A.ORD_FL = '2' AND (A.QK_YN IS NULL OR A.QK_YN <> 'Y'))".toString();
  152. }else if(model.getValue("/root/formData/ORD_FL") == "3"){
  153. combo3.disabled = true;
  154. combo3.refresh();
  155. sqlStr = " AND (A.QK_YN = 'Y')".toString();
  156. }
  157. model.setValue("/root/formData/sql_ord_fl2",sqlStr);
  158. model.setValue("/root/formData/sql_ord_fl",sqlStr);
  159. ]]>
  160. </script>
  161. </select1>
  162. <input id="input1" ref="/root/formData/COIL_NO" style="left:71px; top:0px; width:90px; height:20px; "/>
  163. <line id="line3" style="x1:880px; y1:120px; x2:960px; y2:120px; "/>
  164. <caption id="caption7" class="cell" style="left:-1px; top:25px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">合 同 号</caption>
  165. <input id="input2" ref="/root/formData/CUR_LOAD_LOC" style="left:702px; top:0px; width:83px; height:20px; "/>
  166. <line id="line4" style="x1:573px; y1:35px; x2:578px; y2:35px; "/>
  167. <caption id="caption8" class="cell" style="left:167px; top:25px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">订单区分</caption>
  168. <input id="input3" ref="/root/formData/ORD_NO" style="left:70px; top:25px; width:90px; height:20px; "/>
  169. <output id="output1" ref="/root/sumData/SUM_COILRST_CNT" style="left:715px; top:90px; width:60px; height:20px; text-align:center; "/>
  170. <caption id="caption9" class="cell" style="left:645px; top:90px; width:70px; height:20px; font-weight:bold; background-color:#ffcc00; border-color:#000000; ">卷数合计</caption>
  171. <input id="input4" ref="/root/formData/COIL_WTH_MIN" style="left:515px; top:0px; width:45px; height:20px; "/>
  172. <input id="input5" ref="/root/formData/FROM_DATE" class="input" inputtype="date" style="left:498px; top:25px; width:75px; height:20px; ">
  173. <script type="javascript" ev:event="xforms-value-changed">
  174. <![CDATA[
  175. if(model.getValue("/root/formData/TO_DATE") == null || model.getValue("/root/formData/TO_DATE") == ""||
  176. model.getValue("/root/formData/TO_DATE") < model.getValue("/root/formData/FROM_DATE")){
  177. model.setValue("/root/formData/TO_DATE",model.getValue("/root/formData/FROM_DATE"));
  178. input6.refresh();
  179. }
  180. ]]>
  181. </script>
  182. </input>
  183. <output id="output2" ref="/root/sumData/SUM_COILRST_WGT" style="left:880px; top:90px; width:80px; height:20px; text-align:center; "/>
  184. <input id="input6" ref="/root/formData/TO_DATE" class="input" inputtype="date" style="left:580px; top:25px; width:75px; height:20px; ">
  185. <script type="javascript" ev:event="xforms-value-changed">
  186. <![CDATA[
  187. if(model.getValue("/root/formData/FROM_DATE") == null || model.getValue("/root/formData/FROM_DATE") == ""||
  188. model.getValue("/root/formData/FROM_DATE") > model.getValue("/root/formData/TO_DATE")){
  189. model.setValue("/root/formData/FROM_DATE",model.getValue("/root/formData/TO_DATE"));
  190. input5.refresh();
  191. }
  192. ]]>
  193. </script>
  194. </input>
  195. <datagrid id="datagrid1" nodeset="/root/grid1/UIH051100_RESULT_VO/UIH051100_RESULT_Row" caption="序号^钢卷号^产品类型^钢种^改判前钢种^轧辊号^辊内顺序号^成品厚度^成品宽度^订单厚度^订单宽度^判定厚度^判定宽度^重量^堆放位置^热轧后去向^入库时间^入库操作时间^轧制时间^送样时间^取送时间^收样时间^检验时间^外观判定时间^综合判定时间^出样时间^预装时间^下达发运计划时间/下车方式^入库人^入库班次^入库组^二级库存^订单区分^订单预排期^交货期^合同号^订单号^综合判定^成份判定^材质判定^尺寸判定^外观判定^重量判定^^次品区分^清库前性能^清库前外观^冶炼炉号^收货单位^到站^运输方式^销售区域^合同类型^产线^是否封闭^封闭原因^余材备注^余材归属单位^备注^钢卷颜色备注^异常卷备注|序号^钢卷号^产品类型^钢种^改判前钢种^轧辊号^辊内顺序号^成品厚度^成品宽度^订单厚度^订单宽度^判定厚度^判定宽度^重量^堆放位置^热轧后去向^入库时间^入库操作时间^轧制时间^送样时间^取送时间^收样时间^检验时间^外观判定时间^综合判定时间^出样时间^预装时间^下达发运计划时间/下车方式^入库人^入库班次^入库组^二级库存^订单区分^订单预排期^交货期^合同号^订单号^综合判定^成份判定^材质判定^尺寸判定^外观判定^重量判定^^次品区分^清库前性能^清库前外观^冶炼炉号^收货单位^到站^运输方式^销售区域^合同类型^产线^是否封闭^封闭原因^余材备注^余材归属单位^备注^钢卷颜色备注^异常卷备注" colsep="^" colwidth="38, 100, 60, 100, 100, 65, 48, 40, 40, 40, 40, 40, 40, 50, 60, 72, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 35, 100, 100, 70, 30, 39, 40, 34, 39, 37, 33, 100, 100, 100, 100, 100, 100, 100, 60, 80, 80, 60, 31, 100, 100, 100, 50, 100, 100" explorerbar="sortshow" frozencols="2" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:120px; width:980px; height:490px; ">
  196. <col ref="SEQ" visibility="hidden"/>
  197. <col editable="false" ref="OLD_SAMPL_NO" type="input" style="text-align:left; "/>
  198. <col ref="PRD_TY" style="text-align:left; "/>
  199. <col editable="false" ref="SPEC_STL_GRD" type="input" style="text-align:left; "/>
  200. <col editable="false" ref="BEF_SPEC_STL_GRD" type="input" style="text-align:left; "/>
  201. <col editable="false" ref="ROLL_MANA_NO" type="input" style="text-align:left; "/>
  202. <col editable="false" ref="ROLL_SLAB_SEQ" type="input" style="text-align:left; "/>
  203. <col editable="false" ref="COIL_THK" type="input" style="text-align:right; "/>
  204. <col editable="false" ref="COIL_WTH" type="input" style="text-align:right; "/>
  205. <col editable="false" ref="INSTR_COIL_THK" type="input" style="text-align:right; "/>
  206. <col editable="false" ref="INSTR_COIL_WTH" type="input" style="text-align:right; "/>
  207. <col editable="false" ref="DCS_THK" type="input" style="text-align:right; "/>
  208. <col editable="false" ref="DCS_WTH" type="input" style="text-align:right; "/>
  209. <col editable="false" ref="ACT_WGT" type="input" style="text-align:right; "/>
  210. <col editable="false" ref="CUR_LOAD_LOC" type="input" style="text-align:left; "/>
  211. <col editable="false" ref="RZHQX" type="input" style="text-align:left; "/>
  212. <col editable="false" ref="YARD_ENTRY_DTIME" type="input" format="yyyy-mm-dd hh:nn:ss" style="text-align:left; "/>
  213. <col editable="false" ref="YARD_ENTRY_USE_TIME" type="input" format="yyyy-mm-dd hh:nn:ss" style="text-align:left; "/>
  214. <col editable="false" ref="MILL_DTIME" type="input" format="yyyy-mm-dd hh:nn:ss"/>
  215. <col editable="false" ref="SMP_SEND_DTIME" type="input" format="yyyy-mm-dd hh:nn:ss"/>
  216. <col ref="GET_SEND_DTIME" style="text-align:left; "/>
  217. <col editable="false" ref="SMP_INTO_DTIME" type="input" format="yyyy-mm-dd hh:nn:ss"/>
  218. <col editable="false" ref="SMP_WORK_DTIME" type="input" format="yyyy-mm-dd hh:nn:ss" style="text-align:left; "/>
  219. <col ref="EXTSHAPE_DEC_DTIME"/>
  220. <col editable="false" ref="QLTY_DCS_DTIME" type="input" format="yyyy-mm-dd hh:nn:ss" style="text-align:left; "/>
  221. <col ref="TO_YANG_DTIME" style="text-align:left; "/>
  222. <col ref="YZCS_DTIME" style="text-align:left; "/>
  223. <col ref="AFFIRMTIME" style="text-align:left; "/>
  224. <col explorerbar="sortshow" ref="YARD_ENTRY_REG" style="text-align:left; "/>
  225. <col disabled="true" ref="YARD_ENTRY_SHIFT" type="combo" style="text-align:left; ">
  226. <choices>
  227. <item>
  228. <label>早班</label>
  229. <value>1</value>
  230. </item>
  231. <item>
  232. <label>中班</label>
  233. <value>2</value>
  234. </item>
  235. <item>
  236. <label>晚班</label>
  237. <value>3</value>
  238. </item>
  239. </choices>
  240. </col>
  241. <col disabled="true" ref="YARD_ENTRY_GROUP" type="combo" style="text-align:left; ">
  242. <choices>
  243. <item>
  244. <label>甲班</label>
  245. <value>A</value>
  246. </item>
  247. <item>
  248. <label>乙班</label>
  249. <value>B</value>
  250. </item>
  251. <item>
  252. <label>丙班</label>
  253. <value>C</value>
  254. </item>
  255. <item>
  256. <label>丁班</label>
  257. <value>D</value>
  258. </item>
  259. </choices>
  260. </col>
  261. <col ref="QK_YN" style="text-align:left; "/>
  262. <col disabled="true" ref="ORD_FL" style="text-align:left; "/>
  263. <col ref="ORD_PLAN_DATA" style="text-align:left; "/>
  264. <col ref="ORD_DEVLMT_DATE" style="text-align:left; "/>
  265. <col editable="false" ref="ORD_NO" type="input" style="text-align:right; "/>
  266. <col editable="false" ref="ORD_SEQ" type="input" style="text-align:right; "/>
  267. <col ref="TOT_DEC_GRD" style="text-align:left; "/>
  268. <col ref="INGR_DEC_GRD" style="text-align:left; "/>
  269. <col ref="MATRL_END_CAUSE_CD" style="text-align:left; "/>
  270. <col ref="SIZE_DEC_RST" style="text-align:left; "/>
  271. <col ref="EXTSHAPE_DEC_GRD" style="text-align:left; "/>
  272. <col ref="WGT_DEC_RST" style="text-align:left; "/>
  273. <col editable="false" ref="TOT_DEC_DTIME" type="input" visibility="hidden" format="yyyy-mm-dd hh:nn" style="text-align:left; "/>
  274. <col ref="COIL_DEFECTIVE" style="text-align:left; "/>
  275. <col ref="BEF_MATRL_END_CAUSE_CD" style="text-align:left; "/>
  276. <col ref="BEF_EXTSHAPE_DEC_GRD" style="text-align:left; "/>
  277. <col ref="CHARGE_NO" style="text-align:left; "/>
  278. <col ref="ORDCUST_CD" style="text-align:left; "/>
  279. <col ref="STATIONCODE" style="text-align:left; "/>
  280. <col ref="DLIV_TP" style="text-align:left; "/>
  281. <col ref="XSQY" style="text-align:left; "/>
  282. <col ref="RCVORD_CLF" style="text-align:left; "/>
  283. <col ref="PROD_LINE" style="text-align:left; "/>
  284. <col ref="FB_YN" style="text-align:left; "/>
  285. <col ref="FB_REASON" style="text-align:left; "/>
  286. <col ref="YC_MEMO"/>
  287. <col ref="YC_GSDW"/>
  288. <col ref="REMARKS" type="input" style="text-align:left; "/>
  289. <col ref="HCOLOUR_REM" style="text-align:left; "/>
  290. <col ref="REM_YARD" style="text-align:left; "/>
  291. </datagrid>
  292. <input id="input7" ref="/root/formData/COIL_THK_MIN" style="left:385px; top:0px; width:30px; height:20px; "/>
  293. <select1 id="combo2" ref="/root/formData/CUR_PROG_CD" appearance="minimal" editmode="inputsearch" style="left:862px; top:0px; width:113px; height:20px; text-align:left; ">
  294. <choices>
  295. <item>
  296. <label>发货指示待机</label>
  297. <value>SFA</value>
  298. </item>
  299. <item>
  300. <label>综合判定待机</label>
  301. <value>SED</value>
  302. </item>
  303. <item>
  304. <label>充当待机</label>
  305. <value>SRC</value>
  306. </item>
  307. <item>
  308. <label>运送待机</label>
  309. <value>SFB</value>
  310. </item>
  311. <item>
  312. <label>平整指示待机</label>
  313. <value>SPA</value>
  314. </item>
  315. <item>
  316. <label>平整作业待机</label>
  317. <value>SPB</value>
  318. </item>
  319. <item>
  320. <label>冷轧运送待机</label>
  321. <value>SGB</value>
  322. </item>
  323. <item>
  324. <label/>
  325. <value/>
  326. </item>
  327. </choices>
  328. </select1>
  329. <caption id="caption6" class="cell" style="left:790px; top:0px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">进程状态</caption>
  330. <line id="line1" style="x1:415px; y1:10px; x2:430px; y2:10px; "/>
  331. <input id="input8" ref="/root/formData/COIL_THK_MAX" style="left:430px; top:0px; width:30px; height:20px; "/>
  332. <input id="input9" ref="/root/formData/COIL_WTH_MAX" style="left:575px; top:0px; width:45px; height:20px; "/>
  333. <line id="line5" style="x1:560px; y1:10px; x2:575px; y2:10px; "/>
  334. <select1 id="combo3" ref="/root/formData/YCYY" disabled="true" appearance="minimal" editmode="inputsearch" style="left:330px; top:25px; width:60px; height:20px; text-align:left; ">
  335. <choices>
  336. <item>
  337. <label>综合判定</label>
  338. <value>1</value>
  339. </item>
  340. <item>
  341. <label>成份</label>
  342. <value>2</value>
  343. </item>
  344. <item>
  345. <label>材质</label>
  346. <value>3</value>
  347. </item>
  348. <item>
  349. <label>尺寸</label>
  350. <value>4</value>
  351. </item>
  352. <item>
  353. <label>外观</label>
  354. <value>5</value>
  355. </item>
  356. </choices>
  357. <script type="javascript" ev:event="xforms-value-changed">
  358. <![CDATA[
  359. model.setValue("/root/formData/sql_ord_fl","");
  360. var sqlStr = model.getValue("/root/formData/sql_ord_fl2");
  361. if(model.getValue("/root/formData/YCYY") == "1"){
  362. sqlStr = sqlStr + " AND NVL(A.TOT_DEC_GRD,9) NOT IN ('1','9') ".toString();
  363. }else if(model.getValue("/root/formData/YCYY") == "2"){
  364. sqlStr = sqlStr + " AND NVL(A.INGR_DEC_GRD,9) NOT IN ('0','1','9') ".toString();
  365. }else if(model.getValue("/root/formData/YCYY") == "3"){
  366. sqlStr = sqlStr + " AND NVL(A.MATLQLTY_DEC_GRD,9) NOT IN ('0','1','9') ".toString();
  367. }else if(model.getValue("/root/formData/YCYY") == "4"){
  368. sqlStr = sqlStr + " AND NVL(A.SIZE_DEC_RST,9) NOT IN ('1','9') ".toString();
  369. }else if(model.getValue("/root/formData/YCYY") == "5"){
  370. sqlStr = sqlStr + " AND NVL(A.EXTSHAPE_DEC_GRD,9) NOT IN ('1','9')".toString();
  371. }
  372. model.setValue("/root/formData/sql_ord_fl",sqlStr);
  373. ]]>
  374. </script>
  375. </select1>
  376. <caption id="caption14" class="cell" style="left:660px; top:25px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">运输方式</caption>
  377. <select1 id="combo4" ref="/root/formData/DLIV_TP" appearance="minimal" editmode="inputsearch" style="left:730px; top:25px; width:50px; height:20px; text-align:left; ">
  378. <choices>
  379. <item>
  380. <label>火运</label>
  381. <value>T</value>
  382. </item>
  383. <item>
  384. <label>汽运</label>
  385. <value>C</value>
  386. </item>
  387. <item>
  388. <label/>
  389. <value/>
  390. </item>
  391. </choices>
  392. </select1>
  393. <caption id="caption15" class="cell" style="left:790px; top:25px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">交货期</caption>
  394. <input id="input10" ref="/root/formData/ORD_DEVLMT_DATE" class="input" inputtype="date" style="left:860px; top:25px; width:115px; height:20px; "/>
  395. <select1 id="combo6" ref="/root/formData/COIL_DEFECTIVE" appearance="minimal" style="left:860px; top:50px; width:115px; height:20px; ">
  396. <choices>
  397. <item>
  398. <label>成分不合格</label>
  399. <value>2A</value>
  400. </item>
  401. <item>
  402. <label>工序不合格</label>
  403. <value>2E</value>
  404. </item>
  405. <item>
  406. <label>尺寸不合格</label>
  407. <value>3B</value>
  408. </item>
  409. <item>
  410. <label>重量不合格</label>
  411. <value>3C</value>
  412. </item>
  413. <item>
  414. <label>外观不合格</label>
  415. <value>3D</value>
  416. </item>
  417. <item>
  418. <label>性能不合格</label>
  419. <value>4A</value>
  420. </item>
  421. <item>
  422. <label>--全部--</label>
  423. <value/>
  424. </item>
  425. </choices>
  426. </select1>
  427. <caption id="caption18" class="cell" style="left:790px; top:50px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">次品区分</caption>
  428. <caption id="caption16" class="cell" style="left:0px; top:50px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">送样时间</caption>
  429. <input id="input11" ref="/root/formData/SMP_SEND_DTIME" class="input" inputtype="date" style="left:70px; top:50px; width:90px; height:20px; "/>
  430. <caption id="caption24" class="cell" style="left:167px; top:50px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">销售区域</caption>
  431. <input id="input12" ref="/root/formData/XSQY" style="left:239px; top:50px; width:100px; height:20px; "/>
  432. <caption id="caption17" class="cell" style="left:170px; top:75px; width:70px; height:20px; font-weight:bold; vertical-align:middle; ">产品类型</caption>
  433. <select1 id="combo8" ref="/root/formData/DLIV_TP1" appearance="minimal" editmode="inputsearch" style="left:730px; top:50px; width:50px; height:20px; text-align:left; ">
  434. <choices>
  435. <item>
  436. <label>火运</label>
  437. <value>T</value>
  438. </item>
  439. <item>
  440. <label>汽运</label>
  441. <value>C</value>
  442. </item>
  443. <item>
  444. <label/>
  445. <value/>
  446. </item>
  447. </choices>
  448. </select1>
  449. <caption id="caption19" class="cell" style="left:660px; top:50px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">下车方式</caption>
  450. <caption id="caption20" class="cell" style="left:0px; top:75px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">合同类型</caption>
  451. <select1 id="combo9" ref="/root/formData/RCVORD_CLF" appearance="minimal" editmode="inputsearch" style="left:70px; top:75px; width:90px; height:20px; text-align:left; ">
  452. <choices>
  453. <item>
  454. <label>自用合同</label>
  455. <value>E</value>
  456. </item>
  457. <item>
  458. <label>现款合同</label>
  459. <value>K</value>
  460. </item>
  461. <item>
  462. <label>直销合同</label>
  463. <value>L</value>
  464. </item>
  465. <item>
  466. <label>清库合同</label>
  467. <value>M</value>
  468. </item>
  469. <item>
  470. <label>协议合同</label>
  471. <value>S</value>
  472. </item>
  473. <item>
  474. <label>厂内合同</label>
  475. <value>T</value>
  476. </item>
  477. <item>
  478. <label>外贸合同</label>
  479. <value>W</value>
  480. </item>
  481. <item>
  482. <label/>
  483. <value/>
  484. </item>
  485. </choices>
  486. </select1>
  487. <caption id="caption21" class="cell" style="left:350px; top:50px; width:45px; height:20px; font-weight:bold; border-color:#000000; ">产 线</caption>
  488. <select1 id="combo10" ref="/root/formData/PROD_LINE" appearance="minimal" editmode="inputsearch" style="left:395px; top:50px; width:75px; height:20px; text-align:left; ">
  489. <choices>
  490. <item>
  491. <label>冷轧厂</label>
  492. <value>C</value>
  493. </item>
  494. <item>
  495. <label>热轧厂</label>
  496. <value>H</value>
  497. </item>
  498. <item>
  499. <label>厚板厂</label>
  500. <value>P</value>
  501. </item>
  502. <item>
  503. <label>中板厂</label>
  504. <value>Z</value>
  505. </item>
  506. <item>
  507. <label/>
  508. <value/>
  509. </item>
  510. </choices>
  511. </select1>
  512. <caption id="caption22" class="cell" style="left:485px; top:50px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">SPM类型</caption>
  513. <select1 id="combo11" ref="/root/formData/SPM_TYPE" appearance="minimal" editmode="inputsearch" style="left:555px; top:50px; width:100px; height:20px; text-align:left; ">
  514. <choices>
  515. <item>
  516. <label>平整</label>
  517. <value>1</value>
  518. </item>
  519. <item>
  520. <label>分卷</label>
  521. <value>2</value>
  522. </item>
  523. <item>
  524. <label>平整分卷</label>
  525. <value>3</value>
  526. </item>
  527. <item>
  528. <label>重卷</label>
  529. <value>4</value>
  530. </item>
  531. <item>
  532. <label>开卷检查</label>
  533. <value>5</value>
  534. </item>
  535. <item>
  536. <label/>
  537. <value/>
  538. </item>
  539. </choices>
  540. </select1>
  541. <input id="combo105" ref="/root/formData/PRODNM_CD" inputtype="button" appearance="minimal" style="left:240px; top:75px; width:100px; height:20px; ">
  542. <script type="javascript" ev:event="onclick">
  543. <![CDATA[
  544. //修改订单类型,可以多选。TL 091125
  545. checkbox2.visible = (checkbox2.visible == false);
  546. ]]>
  547. </script>
  548. </input>
  549. <select id="checkbox2" ref="/root/formData/PRODNM_CD" visibility="hidden" overflow="visible" appearance="full" style="left:240px; top:95px; width:100px; height:20px; background-color:#ffff99; border-width:1px; border-style:none; ">
  550. <choices>
  551. <item>
  552. <label>全部</label>
  553. <value/>
  554. </item>
  555. <item>
  556. <label>热轧卷</label>
  557. <value>AR</value>
  558. </item>
  559. <item>
  560. <label>酸轧卷</label>
  561. <value>CR</value>
  562. </item>
  563. <item>
  564. <label>分卷板</label>
  565. <value>FJ</value>
  566. </item>
  567. <item>
  568. <label>花纹卷</label>
  569. <value>HW</value>
  570. </item>
  571. <item>
  572. <label>开平板</label>
  573. <value>KP</value>
  574. </item>
  575. <item>
  576. <label>平整卷</label>
  577. <value>PZ</value>
  578. </item>
  579. <item>
  580. <label>花纹开平</label>
  581. <value>HK</value>
  582. </item>
  583. <item>
  584. <label>连退卷</label>
  585. <value>LT</value>
  586. </item>
  587. <item>
  588. <label>酸洗卷</label>
  589. <value>SX</value>
  590. </item>
  591. </choices>
  592. </select>
  593. <button id="button1" visibility="hidden" style="left:790px; top:70px; width:100px; height:20px; ">
  594. <caption>button1</caption>
  595. <script type="javascript" ev:event="onclick">
  596. <![CDATA[
  597. find();
  598. ]]>
  599. </script>
  600. </button>
  601. <input id="input20" ref="/root/formData/ROLLTO" style="left:525px; top:75px; width:80px; height:20px; "/>
  602. <caption id="caption23" class="cell" style="left:350px; top:75px; width:95px; height:20px; font-weight:bold; border-color:#000000; ">轧制单元</caption>
  603. <input id="input19" ref="/root/formData/ROLLFR" style="left:445px; top:75px; width:80px; height:20px; "/>
  604. <button id="button2" style="left:570px; top:95px; width:60px; height:20px; font-family:黑体; color:#3366ff; background-color:#ffffff; ">
  605. <caption>导出</caption>
  606. <script type="javascript" ev:event="DOMActivate">
  607. <![CDATA[
  608. //saveExcelScript(datagrid1, "Sheet1");
  609. if(datagrid1.rows<=2){
  610. window.alert("无数据源,请先查询.", "提示");
  611. return;
  612. }
  613. var jsonMerges="[{'name':'y','x':0,'y':0,'cnt':1}]";
  614. var _cnt = datagrid1.selectedRows;
  615. commonOutExcel('KCCX',datagrid1.caption,'/root/grid1/UIH051100_RESULT_VO','UIH090060-service',jsonMerges,'xls');
  616. ]]>
  617. </script>
  618. </button>
  619. </xhtml:body>
  620. </xhtml:html>