bc74b6e0a0f3593f461435d7e7affa9f766bcf38.svn-base 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123
  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. <DATE1/>
  13. <DATE2/>
  14. <BANCI/>
  15. </formData>
  16. <reqData/>
  17. <comboData>
  18. <seq/>
  19. </comboData>
  20. <datagrid1/>
  21. <resData/>
  22. </root>
  23. </instance>
  24. <script type="javascript" ev:event="xforms-ready">
  25. <![CDATA[
  26. input1.value = commCurDate();
  27. input2.value = commCurDate();
  28. ]]>
  29. </script>
  30. </model>
  31. <script type="javascript" src="../../js/boaCommon.js"/>
  32. <script type="javascript" src="../../js/boaMsg.js"/>
  33. <script type="javascript">
  34. <![CDATA[
  35. function find()
  36. {
  37. datagrid1.rebuildStyle();
  38. model.removenode("/root/reqData");
  39. model.makeValue("/root/reqData/STIME" , input1.value.Trim()+"000000");
  40. model.makeValue("/root/reqData/ETIME" , input2.value.Trim()+"999999");
  41. commSubmit("UIB030060-service","success","glueAction.do");
  42. model.copyNode("/root/datagrid1","/root/resData/ListResult_0_VO");
  43. model.refresh();
  44. datagrid1.subtotal("sum", -1, datagrid1.colRef("YUANLIAO"), "#,###", "background-color:#99ff99", 0, "统计");
  45. datagrid1.subtotal("sum", -1, datagrid1.colRef("CHANLIANG"), "#,###", "background-color:#99ff99", 0, "统计");
  46. datagrid1.subtotal("sum", -1, datagrid1.colRef("HGL"), "#,###", "background-color:#99ff99", 0, "统计");
  47. datagrid1.subtotal("sum", -1, datagrid1.colRef("FJH"), "#,###", "background-color:#99ff99", 0, "统计");
  48. datagrid1.subtotal("sum", -1, datagrid1.colRef("JH"), "#,###", "background-color:#99ff99", 0, "统计");
  49. datagrid1.subtotal("sum", -1, datagrid1.colRef("ZH"), "#,###", "background-color:#99ff99", 0, "统计");
  50. datagrid1.subtotal("sum", -1, datagrid1.colRef("ZHONGBAN"), "#,###", "background-color:#99ff99", 0, "统计");
  51. datagrid1.subtotal("sum", -1, datagrid1.colRef("DAIPAN"), "#,###", "background-color:#99ff99", 0, "统计");
  52. datagrid1.subtotal("sum", -1, datagrid1.colRef("FGL"), "#,###", "background-color:#99ff99", 0, "统计");
  53. }
  54. ]]>
  55. </script>
  56. </xhtml:head>
  57. <xhtml:body pagewidth="980" pageheight="620" guideline="1,980;1,980;1,980;2,588;1,980;2,621;">
  58. <datagrid id="datagrid1" nodeset="/root/datagrid1/ListResult_0_Row" allowuserresize="true" backcoloralternate="#e4ecf5" caption="钢号^原料^产量^合格^非计划^成材率(%)^合格率(%)^非计划(%)^加回^轧回^待判^中板^轧废/废钢|钢号^原料^产量^合格^非计划^成材率(%)^合格率(%)^非计划(%)^加回^轧回^待判^中板^轧废/废钢" colsep="^" colwidth="100, 100, 100, 100, 100, 43, 45, 42, 75, 68, 72, 71, 90" defaultrows="30" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:35px; width:980px; height:586px; border-color:#000000; border-style:solid; ">
  59. <col editable="false" ref="SPEC_STL_GRD" type="input" style="background-color:#ffffff; "/>
  60. <col editable="false" ref="YUANLIAO" type="input" style="background-color:#ffffff; "/>
  61. <col editable="false" ref="CHANLIANG" type="input" style="background-color:#ffffff; "/>
  62. <col editable="false" ref="HGL" type="input" style="background-color:#ffffff; "/>
  63. <col editable="false" ref="FJH" type="input" style="background-color:#ffffff; "/>
  64. <col ref="CCLV"/>
  65. <col ref="HGLV"/>
  66. <col ref="FJLV"/>
  67. <col editable="false" ref="JH" type="input" style="background-color:#ffffff; "/>
  68. <col editable="false" ref="ZH" type="input" style="background-color:#ffffff; "/>
  69. <col editable="false" ref="DAIPAN" type="input" style="background-color:#ffffff; "/>
  70. <col editable="false" ref="ZHONGBAN" type="input" style="background-color:#ffffff; "/>
  71. <col editable="false" ref="FGL" type="input" style="background-color:#ffffff; "/>
  72. </datagrid>
  73. <line id="line2" style="x1:0px; y1:0px; x2:980px; y2:0px; "/>
  74. <line id="line1" style="x1:0px; y1:30px; x2:980px; y2:30px; "/>
  75. <caption id="caption4" class="cell" style="left:0px; top:5px; width:80px; height:20px; border-color:#000000; border-style:solid; ">日期</caption>
  76. <input id="input1" ref="/root/formData/DATE1" inputtype="date" format="yyyy-mm-dd" style="left:80px; top:5px; width:100px; height:20px; "/>
  77. <button id="button1" visibility="visible" style="left:560px; top:5px; width:100px; height:20px; background-color:#00ff00; border-style:solid; ">
  78. <caption>查询</caption>
  79. <script type="javascript" ev:event="onclick">
  80. <![CDATA[
  81. find();
  82. ]]>
  83. </script>
  84. </button>
  85. <input id="input2" ref="/root/formData/DATE2" inputtype="date" style="left:195px; top:5px; width:100px; height:20px; "/>
  86. <line id="line3" style="x1:180px; y1:15px; x2:195px; y2:15px; "/>
  87. <caption id="caption1" class="cell" style="left:315px; top:5px; width:100px; height:20px; ">班次</caption>
  88. <select1 id="combo1" ref="/root/formData/BANCI" appearance="minimal" style="left:415px; top:5px; width:100px; height:20px; ">
  89. <choices>
  90. <item>
  91. <label/>
  92. <value/>
  93. </item>
  94. <item>
  95. <label>甲</label>
  96. <value>1</value>
  97. </item>
  98. <item>
  99. <label>乙</label>
  100. <value>2</value>
  101. </item>
  102. <item>
  103. <label>丙</label>
  104. <value>3</value>
  105. </item>
  106. <item>
  107. <label>丁</label>
  108. <value>4</value>
  109. </item>
  110. </choices>
  111. </select1>
  112. <button id="button2" visibility="visible" style="left:680px; top:5px; width:100px; height:20px; background-color:#00ff00; border-style:solid; ">
  113. <caption>导出</caption>
  114. <script type="javascript" ev:event="onclick">
  115. <![CDATA[
  116. var x1 = window.fileDialog("save", ",", false, "", "xls", "Excel File(*.xls)|*.xls");
  117. datagrid1.saveExcel(x1, "sheetname:Transaction;colhiddenextend:true;exportfalserows:0;");
  118. window.alert("导出成功" + x1 + " !!!")
  119. ]]>
  120. </script>
  121. </button>
  122. </xhtml:body>
  123. </xhtml:html>