UIB030080.xrw 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186
  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[统计管理>>现况分析>>不合格品统计报表]]>
  7. </xhtml:title>
  8. <model id="model1">
  9. <instance id="instance1">
  10. <root xmlns="">
  11. <formData>
  12. <SPECSTLGRD/>
  13. <NONORD_CAUSE_CD/>
  14. <BANCI/>
  15. <DATE1/>
  16. <DATE2/>
  17. </formData>
  18. <reqData/>
  19. <comboData>
  20. <seq/>
  21. </comboData>
  22. <datagrid1/>
  23. <resData/>
  24. <comboData>
  25. <FacStlGrd_VO>
  26. <FacStlGrd_Row>
  27. <LABEL/>
  28. <VALUE/>
  29. </FacStlGrd_Row>
  30. </FacStlGrd_VO>
  31. <NonCodeResult_VO>
  32. <NonCodeResult_Row>
  33. <LABEL/>
  34. <VALUE/>
  35. </NonCodeResult_Row>
  36. </NonCodeResult_VO>
  37. </comboData>
  38. </root>
  39. </instance>
  40. <script type="javascript" ev:event="xforms-ready">
  41. <![CDATA[
  42. if(window.parent==null) Init();
  43. ]]>
  44. </script>
  45. </model>
  46. <script type="javascript" src="../../js/boaCommon.js"/>
  47. <script type="javascript" src="../../js/b01.js"/>
  48. <script type="javascript" src="../../js/b.js"/>
  49. <script type="javascript">
  50. <![CDATA[
  51. function excelExport() {
  52. return datagrid1;
  53. }
  54. function Init(node)
  55. {
  56. InitParams(node);
  57. model.removenode("/root/reqData");
  58. model.makeNode("/root/reqData");
  59. input1.value = commCurDate();
  60. input2.value = commCurDate();
  61. commSubmit("UIB030080-service" , "success" , "glueAction.do");
  62. // model.duplicate("/root/comboData" , "/root/resData/NonCodeResult_VO");
  63. model.duplicate("/root/comboData" , "/root/resData/FacStlGrd_VO");
  64. model.refresh();
  65. }
  66. function find()
  67. {
  68. model.removenode("/root/reqData");
  69. commSendReq("/root/formData");
  70. if(input1.value.Trim()=="")
  71. {
  72. model.setValue("/root/reqData/DATE1" , "20090101000000");
  73. model.setValue("/root/reqData/DATE2" , "30000101000000");
  74. }
  75. commSubmit("UIB030080-service", "find1", "glueAction.do");
  76. model.copyNode("/root/datagrid1" , "/root/resData/ListResult_0_VO");
  77. model.refresh();
  78. datagrid1.rebuildStyle();
  79. datagrid1.subtotal("sum", -1, datagrid1.colRef("ACT_WGT"), "#,###", "background-color:#99ff99", 0, "统计");
  80. datagrid1.subtotal("count", -1, datagrid1.colRef("ROLL_MANA_NO"), "#,###", "background-color:#99ff99", 0, "统计");
  81. datagrid1.subtotal("sum", -1, datagrid1.colRef("DIAOXIAO"), "#,###", "background-color:#99ff99", 0, "统计");
  82. datagrid1.subtotal("sum", -1, datagrid1.colRef("JIAHUI"), "#,###", "background-color:#99ff99", 0, "统计");
  83. datagrid1.subtotal("sum", -1, datagrid1.colRef("ZHONGBAN"), "#,###", "background-color:#99ff99", 0, "统计");
  84. }
  85. ]]>
  86. </script>
  87. </xhtml:head>
  88. <xhtml:body pagewidth="980" pageheight="620" guideline="1,2989;2,621;">
  89. <line id="line2" style="x1:0px; y1:0px; x2:980px; y2:0px; "/>
  90. <line id="line1" style="x1:0px; y1:30px; x2:980px; y2:30px; "/>
  91. <caption id="caption4" class="cell" style="left:0px; top:5px; width:80px; height:20px; border-color:#000000; border-style:solid; ">日期</caption>
  92. <input id="input1" ref="/root/formData/DATE1" inputtype="date" format="yyyy-mm-dd" style="left:80px; top:5px; width:100px; height:20px; "/>
  93. <button id="button1" visibility="visible" style="left:920px; top:5px; width:50px; height:20px; background-color:#ffcc00; border-color:#0000ff; ">
  94. <caption>导出</caption>
  95. <script type="javascript" ev:event="onclick">
  96. <![CDATA[
  97. var x1 = window.fileDialog("save", ",", false, "", "xls", "Excel File(*.xls)|*.xls");
  98. datagrid1.saveExcel(x1, "sheetname:Transaction;colhiddenextend:true;exportfalserows:0;");
  99. window.alert("导出成功" + x1 + " !!!")
  100. ]]>
  101. </script>
  102. </button>
  103. <input id="input2" ref="/root/formData/DATE2" inputtype="date" style="left:190px; top:5px; width:100px; height:20px; "/>
  104. <caption id="caption1" style="left:180px; top:10px; width:25px; height:20px; ">~</caption>
  105. <datagrid id="datagrid1" nodeset="/root/datagrid1/ListResult_0_Row" caption="轧辊单元^钢卷号^钢种^规格^重量^判次原因^备注^中板^加回^吊销^生产日期^生产班组" colsep="^" colwidth="65, 100, 100, 57, 66, 57, 100, 72, 71, 60, 61, 84" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="30" rowsep="|" tooltip="label" style="left:0px; top:35px; width:979px; height:586px; ">
  106. <col ref="ROLL_MANA_NO"/>
  107. <col ref="OLD_SAMPL_NO"/>
  108. <col ref="SPEC_STL_GRD"/>
  109. <col ref="COIL_THK"/>
  110. <col ref="ACT_WGT"/>
  111. <col disabled="true" ref="NONORD_CAUSE_CD"/>
  112. <col ref="CRK_CD"/>
  113. <col ref="ZHONGBAN"/>
  114. <col ref="JIAHUI"/>
  115. <col ref="DIAOXIAO"/>
  116. <col ref="MILL_DTIME" format="yyyy-mm-dd hh:nn:ss"/>
  117. <col/>
  118. </datagrid>
  119. <caption id="caption2" class="cell" style="left:305px; top:5px; width:75px; height:20px; ">判次原因</caption>
  120. <select1 id="combo1" ref="/root/formData/NONORD_CAUSE_CD" appearance="minimal" style="left:380px; top:5px; width:100px; height:20px; ">
  121. <choices>
  122. <item>
  123. <label>全部</label>
  124. <value/>
  125. </item>
  126. <item>
  127. <label>成分不良</label>
  128. <value>2A</value>
  129. </item>
  130. <item>
  131. <label>材质不良</label>
  132. <value>4A</value>
  133. </item>
  134. <item>
  135. <label>尺寸不良</label>
  136. <value>3B</value>
  137. </item>
  138. <item>
  139. <label>外观异常</label>
  140. <value>3D</value>
  141. </item>
  142. <item>
  143. <label>重量不符</label>
  144. <value>3C</value>
  145. </item>
  146. </choices>
  147. </select1>
  148. <caption id="caption3" class="cell" style="left:490px; top:5px; width:100px; height:20px; ">钢种</caption>
  149. <select1 id="combo2" ref="/root/formData/SPECSTLGRD" appearance="minimal" editmode="input" style="left:590px; top:5px; width:100px; height:20px; ">
  150. <choices>
  151. <itemset nodeset="/root/comboData/FacStlGrd_VO/FacStlGrd_Row">
  152. <label ref="LABEL"/>
  153. <value ref="VALUE"/>
  154. </itemset>
  155. </choices>
  156. </select1>
  157. <select1 id="combo3" ref="/root/formData/BANCI" appearance="minimal" style="left:800px; top:5px; width:100px; height:20px; ">
  158. <choices>
  159. <item>
  160. <label/>
  161. <value/>
  162. </item>
  163. <item>
  164. <label>甲</label>
  165. <value>1</value>
  166. </item>
  167. <item>
  168. <label>乙</label>
  169. <value>2</value>
  170. </item>
  171. <item>
  172. <label>丙</label>
  173. <value>3</value>
  174. </item>
  175. <item>
  176. <label>丁</label>
  177. <value>4</value>
  178. </item>
  179. </choices>
  180. </select1>
  181. <caption id="caption5" class="cell" style="left:700px; top:5px; width:100px; height:20px; ">班次</caption>
  182. </xhtml:body>
  183. </xhtml:html>