UIH090120.xrw 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126
  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[热轧作业>>热轧作业实绩>>中废板统计(UIH090120)]]>
  7. </xhtml:title>
  8. <model id="model1">
  9. <instance id="instance1">
  10. <root xmlns="">
  11. <reqData/>
  12. <resData/>
  13. <searchData>
  14. <ORD_NO/>
  15. <ORD_SEQ/>
  16. </searchData>
  17. <datagrid1/>
  18. </root>
  19. </instance>
  20. </model>
  21. <script type="javascript" src="../../js/boaMsg.js"/>
  22. <script type="javascript" src="../../js/boaCommon.js"/>
  23. <script type="javascript" src="../../js/bCommon.js"/>
  24. <script type="javascript">
  25. <![CDATA[
  26. function InitParams(node) {
  27. if (typeof node == "undefined" && typeof node != "object") return;
  28. model.removenode("/root/initData/rcvInfo");
  29. model.makeNode("/root/initData/rcvInfo");
  30. var nodeList = node.childNodes;
  31. node = model.instances(0).selectSingleNode("/root/initData/rcvInfo");
  32. for (var i = 0; i < nodeList.length; i++)
  33. node.appendChild(nodeList.item(i));
  34. }
  35. function Init(node)
  36. {
  37. InitParams(node);
  38. }
  39. function excelExport(){
  40. return datagrid1;
  41. }
  42. function saveExcelScript(){
  43. if(datagrid1.rows<=2){
  44. window.alert("无数据源,请先查询.", "提示");
  45. return;
  46. }
  47. //window.load("../../G/G10/_out.xrw", "modal", "", "left:350; top:240; width:400; height:220; sysmenu:visible; min:visible; max:true; resize:true; caption:visible;");
  48. var jsonMerges="[{'name':'y','x':0,'y':0,'cnt':2},{'name':'y','x':1,'y':0,'cnt':2},{'name':'y','x':2,'y':0,'cnt':2},{'name':'y','x':3,'y':0,'cnt':2},{'name':'y','x':4,'y':0,'cnt':2},{'name':'y','x':5,'y':0,'cnt':2},{'name':'y','x':6,'y':0,'cnt':2},{'name':'y','x':7,'y':0,'cnt':2},{'name':'y','x':8,'y':0,'cnt':2},{'name':'y','x':9,'y':0,'cnt':2},{'name':'y','x':10,'y':0,'cnt':2},{'name':'x','x':11,'y':0,'cnt':11}]";
  49. var colRef = getVoColrefs("/root/datagrid1/XH_VO");
  50. var list = parseVoToStr("/root/datagrid1/XH_VO");//数据集
  51. commonOuterExcel('UIH090120',datagrid1.caption,colRef,list,'UIH090060-service',jsonMerges,'xls');
  52. }
  53. function find(){
  54. model.removenode("/root/reqData");
  55. model.makeNode("/root/reqData");
  56. model.removenode("/root/datagrid1");
  57. model.makeNode("/root/datagrid1");
  58. if(model.getValue("/root/searchData/ORD_NO") == ""){
  59. alert(" 合同号不能为空,请输入相应的合同号! ");
  60. return;
  61. }
  62. commSendReq("/root/searchData");
  63. commSubmit("UIH090120-service", "find", "glueAction.do");
  64. commAppendData("/root/datagrid1/XH_VO","/root/resData/XH_VO");
  65. model.refresh();
  66. }
  67. ]]>
  68. </script>
  69. </xhtml:head>
  70. <xhtml:body>
  71. <caption id="caption5" class="cell" style="left:0px; top:0px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">合同号</caption>
  72. <input id="input1" ref="/root/searchData/ORD_NO" style="left:70px; top:0px; width:120px; height:20px; background-color:#ffff00; "/>
  73. <datagrid id="datagrid1" nodeset="/root/datagrid1/XH_VO/XH_Row" caption="合同号^标准号^钢卷号^炉次号^订单厚度^订单宽度^实际钢卷重量^额定终轧温度^卷取温度平均值^钢卷内径^轧钢时间^成分^成分^成分^成分^成分^成分^成分^成分^成分^成分^成分|合同号^标准号^钢卷号^炉次号^订单厚度^订单宽度^实际钢卷重量^额定终轧温度^卷取温度平均值^钢卷内径^轧钢时间^C^Mn^S^P^Si^Cr^Ni^Cu^Alt^N^B" colsep="^" colwidth="100, 100, 100, 100, 100, 100, 110, 110, 100, 78, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:25px; width:980px; height:580px; ">
  74. <col ref="ORD_NO"/>
  75. <col ref="SPEC_STL_GRD"/>
  76. <col ref="OLD_SAMPL_NO"/>
  77. <col ref="CHARGE_NO"/>
  78. <col ref="INSTR_COIL_THK"/>
  79. <col ref="INSTR_COIL_WTH"/>
  80. <col ref="ACT_WGT"/>
  81. <col ref="FM_EXT_STRIP_TEMP"/>
  82. <col ref="DC_TEMP_AVG"/>
  83. <col ref="COIL_INDIA"/>
  84. <col ref="MILL_DTIME"/>
  85. <col ref="C"/>
  86. <col ref="MN"/>
  87. <col ref="S"/>
  88. <col ref="P"/>
  89. <col ref="SI"/>
  90. <col ref="CR"/>
  91. <col ref="NI"/>
  92. <col ref="CU"/>
  93. <col ref="ALT"/>
  94. <col ref="N"/>
  95. <col ref="B"/>
  96. </datagrid>
  97. <button id="button2" visibility="hidden" style="left:725px; top:0px; width:50px; height:20px; border-color:#000000; ">
  98. <caption>find</caption>
  99. <script type="javascript" ev:event="onclick">
  100. <![CDATA[
  101. find();
  102. ]]>
  103. </script>
  104. </button>
  105. <caption id="caption20" class="cell" visibility="hidden" style="left:925px; top:0px; width:50px; height:20px; vertical-align:middle; border-color:#000000; ">Export</caption>
  106. <button id="button1" visibility="hidden" style="left:925px; top:0px; width:50px; height:20px; border-color:#000000; ">
  107. <caption>Export</caption>
  108. <script type="javascript" ev:event="onclick">
  109. <![CDATA[
  110. saveExcelScript();
  111. ]]>
  112. </script>
  113. </button>
  114. <input id="input_outType" visibility="hidden" style="left:260px; top:0px; width:100px; height:20px; "/>
  115. </xhtml:body>
  116. </xhtml:html>