bd994656845d4d0482bd2c91035401a036610713.svn-base 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265
  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[品质判定>>综合判定>>钢卷成分及材质详细查询]]>
  7. </xhtml:title>
  8. <model id="model1">
  9. <instance id="instance1">
  10. <root xmlns="">
  11. <formData>
  12. <serachinfo>
  13. <SMP/>
  14. <startTime/>
  15. <endTime/>
  16. <PROGCD/>
  17. <coilNO1/>
  18. <coilNO2/>
  19. </serachinfo>
  20. </formData>
  21. <initChargeNo>
  22. <ChargeNo_VO>
  23. <ChargeNo_Row>
  24. <LABEL>---全部---</LABEL>
  25. <VALUE/>
  26. </ChargeNo_Row>
  27. </ChargeNo_VO>
  28. </initChargeNo>
  29. <datagrid1/>
  30. <datagrid2/>
  31. </root>
  32. </instance>
  33. <script type="javascript" ev:event="xforms-ready">
  34. <![CDATA[
  35. if(window.parent==null) Init();
  36. ]]>
  37. </script>
  38. </model>
  39. <script type="javascript" src="../../js/boaCommon.js"/>
  40. <script type="javascript" src="../../js/b01.js"/>
  41. <script type="javascript">
  42. <![CDATA[
  43. function excelExport() {
  44. return datagrid1;
  45. }
  46. function Init(node)
  47. {
  48. InitParams(node);
  49. input1.value = document.readIniFile("session1" , "UIB020241_COIL1" , "" , "c:\\WINDOWS\\xgmes3.ini"); ;
  50. input4.value = document.readIniFile("session1" , "UIB020241_COIL2" , "" , "c:\\WINDOWS\\xgmes3.ini");
  51. }
  52. function find()
  53. {
  54. ///生成请求参数
  55. model.removenode("/root/reqData");
  56. model.makeValue("/root/reqData/PORGCD" , "");//试样进程代码
  57. model.makeValue("/root/reqData/COILNO1" , input1.value.Trim());//炉次号
  58. model.makeValue("/root/reqData/STLGRD" , "");//钢种
  59. if(input1.value.Trim()=="")
  60. {
  61. window.alert("请输入轧批号查询!","提示");
  62. return;
  63. }
  64. if(input4.value.Trim() == "")
  65. {
  66. model.makeValue("/root/reqData/COILNO2" , input1.value.Trim());
  67. }
  68. else
  69. {
  70. model.makeValue("/root/reqData/COILNO2" , input4.value.Trim());
  71. }
  72. document.writeIniFile("session1" , "UIB020241_COIL1" , input1.value.Trim() , "c:\\WINDOWS\\xgmes3.ini");
  73. document.writeIniFile("session1" , "UIB020241_COIL2" , input4.value.Trim() , "c:\\WINDOWS\\xgmes3.ini");
  74. model.makeValue("/root/reqData/startTime" , "0000");//检验开始时间
  75. model.makeValue("/root/reqData/endTime" , "9999");//检验结束时间
  76. commSubmit("UIB020241-service" , "find" , "glueAction.do");
  77. ///还原表格到初始状态
  78. for(var i = datagrid1.cols; i > 6 ; i--)
  79. {
  80. datagrid1.deleteColumn(i , false);
  81. }
  82. for(var i = datagrid2.cols; i > 3 ; i--)
  83. {
  84. datagrid2.deleteColumn(i , false);
  85. }
  86. model.removenode("/root/datagrid1");//清除表格1的节点
  87. model.removenode("/root/datagrid2");//清除表格2的节点
  88. var caption1 = datagrid1.caption;
  89. var caption2 = datagrid2.caption;
  90. datagrid1.caption = caption1;
  91. datagrid2.caption = caption2;
  92. ///动态生成表格1和2
  93. //为了动态生成列后,可以改变列宽,所以表格1需要一个节点映射
  94. datagrid1.addRow(false);
  95. datagrid2.addRow(false);
  96. GridDynamicQlty(datagrid1 , "/root/resData/Grid1QltyNM_VO");
  97. GridDynamicQlty_2(datagrid2 , "/root/resData/ChemNM_VO");
  98. ///copy
  99. model.copyNode("/root/datagrid1" , "/root/resData/LotAchievementResult_VO" );
  100. model.copyNode("/root/datagrid2" , "/root/resData/ChargeAchievement_VO");
  101. model.refresh();
  102. // var decGrd = "";
  103. // for(var i = datagrid1.fixedRows; i < datagrid1.rows; i++)
  104. // {
  105. // decGrd = datagrid1.valueMatrix(i , datagrid1.colRef("MATLQLTY_DEC_GRD"));
  106. // if(decGrd == "2")
  107. // {
  108. // datagrid1.rowStyle(i , "data" , "color") = "#ff0000";
  109. // }
  110. // if(decGrd == "1")
  111. // {
  112. // datagrid1.rowStyle(i , "data" , "color") = "#0000ff";
  113. // }
  114. // }
  115. // datagrid1.rebuild();
  116. // exceptionReport();
  117. }
  118. ///表格的动态列生成
  119. //ref 为"/root/resData/Grid2QltyNM_VO"形式
  120. function GridDynamicQlty(grid , ref)
  121. {
  122. ///获得材质名
  123. var node = instance1.selectSingleNode(ref);
  124. if(node == null) return;
  125. var nodeList = node.childNodes;
  126. var nNode;
  127. var i = 1;
  128. var tempCaption1 = "";//第一列的caption
  129. var tempCaption2 = "";//第二列的caption
  130. while(nNode=nodeList.nextNode())
  131. {
  132. grid.addColumn("ref:QLTY_VAL_WK"+i , false);
  133. // grid.addColumn("ref:QLTY_UNIT_WK"+i , false);
  134. ///指定某一列的caption
  135. grid.colWidth(grid.colRef("QLTY_VAL_WK"+i)) = 50;
  136. // grid.colWidth(grid.colRef("QLTY_UNIT_WK"+i)) = 50;
  137. tempCaption1 = tempCaption1 +"^"+nNode.childNodes.item(0).nodeValue;
  138. // tempCaption2 = tempCaption2 +"^"+"实绩值^"+"单位";
  139. i++;
  140. }
  141. ///生成最终的caption
  142. var caption = grid.caption ;
  143. grid.caption = caption.split("|")[0]+tempCaption1+"|"+caption.split("|")[1]+tempCaption1;
  144. }
  145. function GridDynamicQlty_2(grid , ref)
  146. {
  147. ///获得材质名
  148. var node = instance1.selectSingleNode(ref);
  149. if(node == null) return;
  150. var nodeList = node.childNodes;
  151. var nNode;
  152. var i = 1;
  153. var tempCaption1 = "";//第一列的caption
  154. var tempCaption2 = "";//第二列的caption
  155. while(nNode=nodeList.nextNode())
  156. {
  157. grid.addColumn("ref:VALUE"+i , false);
  158. // grid.addColumn("ref:QLTY_UNIT_WK"+i , false);
  159. ///指定某一列的caption
  160. grid.colWidth(grid.colRef("VALUE"+i)) = 50;
  161. // grid.colWidth(grid.colRef("QLTY_UNIT_WK"+i)) = 50;
  162. tempCaption1 = tempCaption1 +"^"+nNode.childNodes.item(0).nodeValue;
  163. // tempCaption2 = tempCaption2 +"^"+"实绩值^"+"单位";
  164. i++;
  165. }
  166. ///生成最终的caption
  167. var caption = grid.caption ;
  168. grid.caption = caption.split("|")[0]+tempCaption1+"|"+caption.split("|")[1]+tempCaption1;
  169. }
  170. ]]>
  171. </script>
  172. </xhtml:head>
  173. <xhtml:body pagewidth="980" pageheight="620">
  174. <datagrid id="datagrid1" nodeset="/root/datagrid1/LotAchievementResult_Row" caption="序号^钢卷号^牌号^厚度^检验日期^判定日期^判定结果^外观备注^缺陷1^缺陷2^缺陷3^缺陷4^缺陷5|序号^钢卷号^牌号^厚度^检验日期^判定日期^判定结果^外观备注^缺陷1^缺陷2^缺陷3^缺陷4^缺陷5" colsep="^" colwidth="40, 100, 100, 50, 76, 76, 76, 100, 100, 80, 80, 80, 80" extendlastcol="false" frozencols="3" mergecellsfixedrows="bycolrec" rowsep="|" tooltip="label" style="left:0px; top:35px; width:976px; height:290px; ">
  175. <col editable="false" ref="ROWNUM" type="input" style="background-color:#ffffff; "/>
  176. <col editable="false" ref="OLD_SAMPL_NO" type="input" style="background-color:#ffffff; "/>
  177. <col ref="SPEC_STL_GRD"/>
  178. <col editable="false" ref="COIL_THK" type="input" style="background-color:#ffffff; "/>
  179. <col editable="false" ref="SMP_WORK_DTIME" type="input" format="yyyy-mm-dd hh:nn:ss" style="background-color:#ffffff; "/>
  180. <col editable="false" ref="QLTY_DCS_DTIME" type="input" format="yyyy-mm-dd hh:nn:ss" style="background-color:#ffffff; "/>
  181. <col editable="false" ref="MATLQLTY_DEC_GRD" type="input" format="yyyy-mm-dd" style="background-color:#ffffff; "/>
  182. <col ref="SPM_RMK"/>
  183. <col ref="CRK_CD1"/>
  184. <col ref="CRK_CD2"/>
  185. <col ref="CRK_CD3"/>
  186. <col ref="CRK_CD4"/>
  187. <col ref="CRK_CD5"/>
  188. </datagrid>
  189. <line id="line1" style="x1:0px; y1:30px; x2:975px; y2:30px; "/>
  190. <line id="line2" style="x1:0px; y1:0px; x2:975px; y2:0px; "/>
  191. <caption id="caption1" class="cell" style="left:0px; top:5px; width:100px; height:20px; ">轧批号:</caption>
  192. <input id="input1" ref="/root/formData/serachinfo/coilNO1" style="left:100px; top:5px; width:100px; height:20px; ">
  193. <script type="javascript" ev:event="onkeydown">
  194. <![CDATA[
  195. if(event.keyCode == 13)
  196. {
  197. model.setFocus("" , true);
  198. model.setFocus("input1" , true);
  199. find();
  200. }
  201. ]]>
  202. </script>
  203. </input>
  204. <line id="line3" style="x1:200px; y1:15px; x2:215px; y2:15px; "/>
  205. <input id="input4" ref="/root/formData/serachinfo/coilNO2" style="left:215px; top:5px; width:100px; height:20px; ">
  206. <script type="javascript" ev:event="onkeydown">
  207. <![CDATA[
  208. if(event.keyCode == 13)
  209. {
  210. model.setFocus("" , true);
  211. model.setFocus("input4" , true);
  212. find();
  213. }
  214. ]]>
  215. </script>
  216. </input>
  217. <button id="button2" style="left:875px; top:5px; width:100px; height:20px; background-color:#ccffcc; border-style:solid; ">
  218. <caption>材质导出</caption>
  219. <script type="javascript" ev:event="DOMActivate">
  220. <![CDATA[
  221. var x1 = window.fileDialog("save", ",", false, "", "xls", "Excel File(*.xls)|*.xls");
  222. if(x1 == "") return;
  223. datagrid1.saveExcel(x1, "sheetname:Transaction;colhiddenextend:true;exportfalserows:0;");
  224. window.alert("导出成功" + x1 + " !!!");
  225. ]]>
  226. </script>
  227. </button>
  228. <datagrid id="datagrid2" nodeset="/root/datagrid2/ChargeAchievement_Row" caption="序号^钢卷号^牌号^厚度|序号^钢卷号^牌号^厚度" colsep="^" colwidth="32, 100, 100, 100" extendlastcol="false" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:350px; width:975px; height:265px; ">
  229. <col ref="SEQ"/>
  230. <col ref="OLD_SAMPL_NO"/>
  231. <col ref="SPEC_STL_GRD"/>
  232. <col ref="DCS_THK"/>
  233. </datagrid>
  234. <caption id="caption2" class="cell" style="left:0px; top:330px; width:100px; height:20px; ">成分实绩</caption>
  235. <button id="button3" style="left:870px; top:330px; width:100px; height:20px; background-color:#ccffcc; border-style:solid; ">
  236. <caption>成分导出</caption>
  237. <script type="javascript" ev:event="DOMActivate">
  238. <![CDATA[
  239. var x2 = window.fileDialog("save", ",", false, "", "xls", "Excel File(*.xls)|*.xls");
  240. if(x2 == "") return;
  241. datagrid2.saveExcel(x2, "sheetname:Transaction;colhiddenextend:true;exportfalserows:0;");
  242. window.alert("导出成功" + x2 + " !!!");
  243. ]]>
  244. </script>
  245. </button>
  246. <button id="button1" visibility="hidden" style="left:355px; top:5px; width:100px; height:20px; ">
  247. <caption>button1</caption>
  248. <script type="javascript" ev:event="onclick">
  249. <![CDATA[
  250. find();
  251. ]]>
  252. </script>
  253. </button>
  254. </xhtml:body>
  255. </xhtml:html>