5d800f8bcce38bf2f7363307347eb8d5ca363487.svn-base 57 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560
  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[统计管理>>物料分析>>轧线统计报表(UIH090060)]]>
  7. </xhtml:title>
  8. <model id="model1">
  9. <instance id="instance1">
  10. <root xmlns="">
  11. <reqData/>
  12. <resData/>
  13. <datagrid1/>
  14. <searchData>
  15. <searchTime/>
  16. <searchGroup>Y</searchGroup>
  17. </searchData>
  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 find(){
  40. model.removenode("/root/reqData");
  41. model.makeNode("/root/reqData");
  42. model.removenode("/root/datagrid1");
  43. model.makeNode("/root/datagrid1");
  44. if(model.getValue("/root/searchData/searchTime") == ""){
  45. var cur_date;
  46. cur_date = commCurDate();
  47. model.setValue("/root/searchData/searchTime",cur_date);
  48. model.refresh();
  49. }
  50. var group = model.getValue("/root/searchData/searchGroup");
  51. if(group == "Y"){
  52. //为Y是四班的情况
  53. model.duplicate("/root/reqData","/root/searchData/searchTime");
  54. commSubmit("UIH090060-service", "find1", "glueAction.do");
  55. commAppendData("/root/datagrid1/ProdEdit_VO","/root/resData/ProdEdit_VO");
  56. model.refresh();
  57. }else if(group == "N"){
  58. //为N是三班的情况
  59. model.duplicate("/root/reqData","/root/searchData/searchTime");
  60. commSubmit("UIH090060-service", "find", "glueAction.do");
  61. commAppendData("/root/datagrid1/ProdEdit_VO","/root/resData/ProdEdit_VO");
  62. model.refresh();
  63. }
  64. //这里给出提示,特定的行可以输入
  65. //日历作业时间
  66. datagrid1.rowStyle(11, "data", "background-color") = "#ffff99";
  67. //轧钢时间
  68. datagrid1.rowStyle(12, "data", "background-color") = "#ffff99";
  69. //22
  70. datagrid1.rowStyle(22, "data", "background-color") = "#ffff99";
  71. datagrid1.rowStyle(23, "data", "background-color") = "#ffff99";
  72. datagrid1.rowStyle(24, "data", "background-color") = "#ffff99";
  73. datagrid1.rowStyle(25, "data", "background-color") = "#ffff99";
  74. datagrid1.rowStyle(26, "data", "background-color") = "#ffff99";
  75. datagrid1.rowStyle(27, "data", "background-color") = "#ffff99";
  76. datagrid1.rowStyle(28, "data", "background-color") = "#ffff99";
  77. datagrid1.rowStyle(29, "data", "background-color") = "#ffff99";
  78. datagrid1.rowStyle(30, "data", "background-color") = "#ffff99";
  79. datagrid1.rowStyle(31, "data", "background-color") = "#ffff99";
  80. datagrid1.rowStyle(32, "data", "background-color") = "#ffff99";
  81. datagrid1.rowStyle(33, "data", "background-color") = "#ffff99";
  82. }
  83. function saveExcelScript(sDGridName, sExcelSheetName, saveType) {
  84. var sExcelName = window.fileDialog( "save", "", false, "SaveFileName", "xls", "Excel Files(*.xls)|*.xls" );
  85. if ( sExcelName == "" ) {
  86. return;
  87. }
  88. //var sCSVName = "C:\\TFSmartUpdater\\" + sExcelName.lastIndexOf(".") +".csv";
  89. var sCSVName = sExcelName +".csv";
  90. //alert("sExcelName = ["+ sExcelName +"]\nsCSVName = ["+ sCSVName + "]");
  91. eval(sDGridName).saveText(sCSVName, "\n", ",", '\:', true); //DataGrid의 내용을 CSV파일로 생성
  92. ObjTFExcel.launchNewInstance(0); //Execute EXCEL
  93. ObjTFExcel.createWorkbook(); //Create new Workbook(for example:Sheet1,Sheet2,Sheet3) -- createWorkBook(Excel-TemplateFile)
  94. ObjTFExcel.loadCSV(sCSVName); //Loading Contents, from CSV to Excel
  95. //Setting up EXCEL Layout.
  96. var nRows = sDGridName.rows - sDGridName.fixedRows + 1; //Keep Careful !!!
  97. var nCols = sDGridName.cols;
  98. //Header
  99. //Line 1 : Sheet Title
  100. // ObjTFExcel.rowheight( 01 ) = 30 ;
  101. // ObjTFExcel.bold ( 01, 01, 01, nCols ) = true ;
  102. // ObjTFExcel.fontsize ( 01, 01, 01, nCols ) = 14 ;
  103. // ObjTFExcel.underline( 01, 01, 01, nCols ) = 3 ;
  104. // ObjTFExcel.halign ( 01, 01, 01, nCols ) ="center" ;
  105. // ObjTFExcel.valign ( 01, 01, 01, nCols ) ="top" ;
  106. // ObjTFExcel.mergeCell( 01, 01, 01, nCols ) ;
  107. //ObjTFExcel.colwidth ( 01 ) = 100 ;
  108. //All of the range
  109. ObjTFExcel.fontcolor ( 01, 01, nRows, nCols ) = "#000000" ;
  110. ObjTFExcel.font ( 01, 01, nRows, nCols ) = "SimSun" ;
  111. ObjTFExcel.setBorderColor( 01, 01, nRows, nCols, "#000000") ;
  112. ObjTFExcel.bold ( 01, 01, nRows, nCols ) = true ;
  113. ObjTFExcel.fontsize ( 01, 01, nRows, nCols ) = 12 ;
  114. ObjTFExcel.underline ( 01, 01, nRows, nCols ) = 0 ;
  115. ObjTFExcel.valign ( 01, 01, nRows, nCols ) ="middle" ;
  116. //字体居中
  117. ObjTFExcel.halign ( 01, 01, nRows, nCols ) ="center" ;
  118. ObjTFExcel.halign ( 01, 01, nRows, 02 ) ="left" ;
  119. //Query-Results Data
  120. var iRow = 1; // iRow = HeaderLine + 1;
  121. //这里设置字体的行宽
  122. // for(var i = iRow; i <= nRows; i++ ) {
  123. // if( (i%5) == 1 ) {
  124. // ObjTFExcel.rowHeight( i ) = 60;
  125. // ObjTFExcel.mergeCell( i, 01, i, nCols );
  126. // } else if( (i%5) == 0 ) {
  127. // ObjTFExcel.rowHeight( i ) = 45;
  128. // ObjTFExcel.mergeCell( i, 01, i, nCols );
  129. // } else {
  130. // ObjTFExcel.rowHeight( i ) = 40;
  131. // }
  132. // }
  133. //设置列的宽度
  134. ObjTFExcel.colwidth ( 01 ) = 10 ;
  135. ObjTFExcel.colwidth ( 02 ) = 20 ;
  136. ObjTFExcel.colwidth ( 03 ) = 10 ;
  137. ObjTFExcel.colwidth ( 04 ) = 10 ;
  138. ObjTFExcel.colwidth ( 05 ) = 10 ;
  139. ObjTFExcel.colwidth ( 06 ) = 10 ;
  140. ObjTFExcel.colwidth ( 07 ) = 10 ;
  141. ObjTFExcel.colwidth ( 08 ) = 10 ;
  142. // ObjTFExcel.setFormat(iRow, 14, nRows, 14, "yyyy\"-\"mm\"-\"dd\"\" hh\":\"mm\":\"ss\"\";@");
  143. ObjTFExcel.sheetName(1) = sExcelSheetName;
  144. ObjTFExcel.save(sExcelName); //Saving EXCEL
  145. ObjTFExcel.close(); //Closing EXCEL. (You must be closed EXCEL !!!)
  146. window.exec("EXCEL.EXE", sExcelName); //Openning EXCEL
  147. }
  148. function save(){
  149. //暂时不考虑
  150. model.removenode("/root/reqData");
  151. model.makeNode("/root/reqData");
  152. // //整个表格提交,这里需要改变行状态
  153. // for(var i=0;i<datagrid1.rows;i++){
  154. // datagrid1.rowStatus(i) = 3;
  155. // }
  156. // commMultiUpdate(datagrid1,"/root/reqData","A",true,"rowStuts1");
  157. //
  158. // //commSubmit("UIH090060-service", "save", "glueAction.do");
  159. //
  160. // model.refresh();
  161. }
  162. ]]>
  163. </script>
  164. </xhtml:head>
  165. <xhtml:body>
  166. <object id="ObjTFExcel" clsid="{fe8d1001-6a9d-424d-ae2a-301493bb12da}" style="left:335px; top:0px; width:155px; height:25px; "/>
  167. <caption id="caption1" class="cell" style="left:0px; top:5px; width:90px; height:20px; font-weight:bold; border-color:#000000; ">日期</caption>
  168. <input id="input1" ref="/root/searchData/searchTime" inputtype="date" format="yyyy-mm-dd" style="left:92px; top:5px; width:115px; height:20px; background-color:#ffff99; "/>
  169. <datagrid id="datagrid1" nodeset="/root/datagrid1/ProdEdit_VO/ProdEdit_Row" caption="序号^班组^甲班^甲班^甲班^甲班^乙班^乙班^乙班^乙班^丙班^丙班^丙班^丙班^丁班^丁班^丁班^丁班^全天^全天^全天^全天|序号^指标名称^当日(块)^月累(块)^当日(吨)^月累(吨)^当日(块)^月累(块)^当日(吨)^月累(吨)^当日(块)^月累(块)^当日(吨)^月累(吨)^当日(块)^月累(块)^当日(吨)^月累(吨)^当日(块)^月累(块)^当日(吨)^月累(吨)" colsep="^" colwidth="50, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" defaultrows="20" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:25px; width:960px; height:585px; ">
  170. <col ref="PROD_SEQ"/>
  171. <col ref="PROD_GUIDE"/>
  172. <col ref="DAY_CNT_A" type="input"/>
  173. <col ref="MON_CNT_A" type="input"/>
  174. <col ref="DAY_WGT_A"/>
  175. <col ref="MON_WGT_A"/>
  176. <col ref="DAY_CNT_B" type="input"/>
  177. <col ref="MON_CNT_B" type="input"/>
  178. <col ref="DAY_WGT_B"/>
  179. <col ref="MON_WGT_B" style="left:850px; top:41px; width:100px; height:21px; "/>
  180. <col ref="DAY_CNT_C" type="input"/>
  181. <col ref="MON_CNT_C" type="input"/>
  182. <col ref="DAY_WGT_C"/>
  183. <col ref="MON_WGT_C"/>
  184. <col ref="DAY_CNT_D" type="input"/>
  185. <col ref="MON_CNT_D" type="input"/>
  186. <col ref="DAY_WGT_D"/>
  187. <col ref="MON_WGT_D"/>
  188. <col ref="DAY_CNT" type="input"/>
  189. <col ref="MON_CNT" type="input"/>
  190. <col ref="DAY_WGT"/>
  191. <col ref="MON_WGT"/>
  192. </datagrid>
  193. <button id="button2" style="left:870px; top:5px; width:90px; height:20px; ">
  194. <caption>统计计算</caption>
  195. <script type="javascript" ev:event="DOMActivate">
  196. <![CDATA[
  197. //这里需要取出特定行列的值,并进行相应的计算
  198. var nodeSet1 = datagrid1.nodeset;
  199. //甲班的产量(吨)
  200. var DAY_2_A = null;
  201. //甲班的总产量(吨)
  202. var MON_2_A = null;
  203. //甲班的日历时间
  204. var DAY_10_A = null;
  205. //甲班日历总时间
  206. var MON_10_A = null;
  207. //甲班的轧钢时间
  208. var DAY_11_A = null;
  209. //甲班轧钢总时间
  210. var MON_11_A = null;
  211. //甲班的煤气耗量时间
  212. var DAY_21_A = null;
  213. //甲班的煤气耗量总时间
  214. var MON_21_A = null;
  215. //甲班的煤气能耗量计算 煤气/产量
  216. var DAY_21_A_JS = null;
  217. //甲班的煤气总能耗计算 总煤气/产量
  218. var MON_21_A_JS = null;
  219. //甲班的电耗量时间
  220. var DAY_22_A = null;
  221. //甲班的电耗量总时间
  222. var MON_22_A = null;
  223. //甲班的耗量计算 电/产量
  224. var DAY_22_A_JS = null;
  225. //甲班的电总耗量计算 电/产量
  226. var MON_22_A_JS = null;
  227. //甲班的水耗量时间
  228. var DAY_23_A = null;
  229. //甲班的水耗量总时间
  230. var MON_23_A = null;
  231. //甲班的水耗量计算 水/产量
  232. var DAY_23_A_JS = null;
  233. //甲班的水总耗量计算 水/产量
  234. var MON_23_A_JS = null;
  235. //甲班的压缩空气时间
  236. var DAY_24_A = null;
  237. //甲班的压缩空气总时间
  238. var MON_24_A = null;
  239. //甲班的压缩空气计算
  240. var DAY_24_A_JS = null;
  241. //甲班的压缩总空气 计算
  242. var MON_24_A_JS = null;
  243. //甲班的辊耗时间
  244. var DAY_25_A = null;
  245. //甲班的辊耗总时间
  246. var MON_25_A = null;
  247. //甲班的辊耗计算
  248. var DAY_25_A_JS = null;
  249. //甲班的辊耗总计算
  250. var MON_25_A_JS = null;
  251. //甲班的停轧机械时间
  252. var DAY_26_A = null;
  253. //甲班停轧机械总时间
  254. var MON_26_A = null;
  255. //甲班的停轧电器时间
  256. var DAY_27_A = null;
  257. //甲班停轧电器总时间
  258. var MON_27_A = null;
  259. //甲班的停轧轧钢时间
  260. var DAY_28_A = null;
  261. //甲班停轧轧钢总时间
  262. var MON_28_A = null;
  263. //甲班的停轧换辊时间
  264. var DAY_29_A = null;
  265. //甲班停轧换辊总时间
  266. var MON_29_A = null;
  267. //甲班的停轧检修时间
  268. var DAY_30_A = null;
  269. //甲班停轧检修总时间
  270. var MON_30_A = null;
  271. //甲班的停轧外部时间
  272. var DAY_31_A = null;
  273. //甲班停轧外部总时间
  274. var MON_31_A = null;
  275. //甲班的停轧原成时间
  276. var DAY_32_A = null;
  277. //甲班停轧原成总时间
  278. var MON_32_A = null;
  279. //甲班的停轧时间
  280. var DAY_33_A = null;
  281. //甲班停轧总时间
  282. var MON_33_A = null;
  283. for(var i=0;i<datagrid1.rows;i++){
  284. DAY_2_A = model.getValue(nodeSet1+"[2]/DAY_WGT_A");
  285. MON_2_A = model.getValue(nodeSet1+"[2]/MON_WGT_A");
  286. DAY_10_A = model.getValue(nodeSet1+"[10]/DAY_CNT_A");
  287. MON_10_A = model.getValue(nodeSet1+"[10]/MON_CNT_A");
  288. DAY_11_A = model.getValue(nodeSet1+"[11]/DAY_CNT_A");
  289. MON_11_A = model.getValue(nodeSet1+"[11]/MON_CNT_A");
  290. DAY_21_A = model.getValue(nodeSet1+"[21]/DAY_CNT_A");
  291. MON_21_A = model.getValue(nodeSet1+"[21]/MON_CNT_A");
  292. DAY_22_A = model.getValue(nodeSet1+"[22]/DAY_CNT_A");
  293. MON_22_A = model.getValue(nodeSet1+"[22]/MON_CNT_A");
  294. DAY_23_A = model.getValue(nodeSet1+"[23]/DAY_CNT_A");
  295. MON_23_A = model.getValue(nodeSet1+"[23]/MON_CNT_A");
  296. DAY_24_A = model.getValue(nodeSet1+"[24]/DAY_CNT_A");
  297. MON_24_A = model.getValue(nodeSet1+"[24]/MON_CNT_A");
  298. DAY_25_A = model.getValue(nodeSet1+"[25]/DAY_CNT_A");
  299. MON_25_A = model.getValue(nodeSet1+"[25]/MON_CNT_A");
  300. DAY_26_A = model.getValue(nodeSet1+"[26]/DAY_CNT_A");
  301. MON_26_A = model.getValue(nodeSet1+"[26]/MON_CNT_A");
  302. DAY_27_A = model.getValue(nodeSet1+"[27]/DAY_CNT_A");
  303. MON_27_A = model.getValue(nodeSet1+"[27]/MON_CNT_A");
  304. DAY_28_A = model.getValue(nodeSet1+"[28]/DAY_CNT_A");
  305. MON_28_A = model.getValue(nodeSet1+"[28]/MON_CNT_A");
  306. DAY_29_A = model.getValue(nodeSet1+"[29]/DAY_CNT_A");
  307. MON_29_A = model.getValue(nodeSet1+"[29]/MON_CNT_A");
  308. DAY_30_A = model.getValue(nodeSet1+"[30]/DAY_CNT_A");
  309. MON_30_A = model.getValue(nodeSet1+"[30]/MON_CNT_A");
  310. DAY_31_A = model.getValue(nodeSet1+"[31]/DAY_CNT_A");
  311. MON_31_A = model.getValue(nodeSet1+"[31]/MON_CNT_A");
  312. DAY_32_A = model.getValue(nodeSet1+"[32]/DAY_CNT_A");
  313. MON_32_A = model.getValue(nodeSet1+"[32]/MON_CNT_A");
  314. }
  315. //日历运转率
  316. var DAY_12_A = (Number(DAY_11_A)-Number(DAY_28_A))/Number(DAY_10_A);
  317. var MON_12_A = (Number(MON_11_A)-Number(MON_28_A))/Number(MON_10_A);
  318. model.setValue(nodeSet1+"[12]/DAY_CNT_A",Math.round(DAY_12_A*100)/100);
  319. model.setValue(nodeSet1+"[12]/MON_CNT_A",Math.round(MON_12_A*100)/100);
  320. //设备运转率
  321. var DAY_13_A = (Number(DAY_10_A)-Number(DAY_26_A))/Number(DAY_10_A);
  322. var MON_13_A = (Number(MON_10_A)-Number(MON_26_A))/Number(MON_10_A);
  323. model.setValue(nodeSet1+"[13]/DAY_CNT_A",Math.round(DAY_13_A*100)/100);
  324. model.setValue(nodeSet1+"[13]/MON_CNT_A",Math.round(MON_13_A*100)/100);
  325. //电器运转率
  326. var DAY_14_A = (Number(DAY_10_A)-Number(DAY_27_A))/Number(DAY_10_A);
  327. var MON_14_A = (Number(MON_10_A)-Number(MON_27_A))/Number(MON_10_A);
  328. model.setValue(nodeSet1+"[14]/DAY_CNT_A",Math.round(DAY_14_A*100)/100);
  329. model.setValue(nodeSet1+"[14]/MON_CNT_A",Math.round(MON_14_A*100)/100);
  330. //机时产量
  331. var DAY_15_A = (Number(DAY_2_A)/Number(DAY_11_A))*60;
  332. var MON_15_A = (Number(MON_2_A)/Number(MON_11_A))*60;
  333. model.setValue(nodeSet1+"[15]/DAY_CNT_A",Math.round(DAY_15_A*100)/100);
  334. model.setValue(nodeSet1+"[15]/MON_CNT_A",Math.round(MON_15_A*100)/100);
  335. //停轧时间的总计
  336. var DAY_33_A = Number(DAY_26_A)+Number(DAY_27_A)+Number(DAY_28_A)+Number(DAY_29_A)+Number(DAY_30_A)+Number(DAY_31_A)+Number(DAY_32_A);
  337. var MON_33_A = Number(MON_26_A)+Number(MON_27_A)+Number(MON_28_A)+Number(MON_29_A)+Number(MON_30_A)+Number(MON_31_A)+Number(MON_32_A);
  338. model.setValue(nodeSet1+"[33]/DAY_CNT_A",Math.round(DAY_33_A*100)/100);
  339. model.setValue(nodeSet1+"[33]/MON_CNT_A",Math.round(MON_33_A*100)/100);
  340. //甲班的煤气能耗量计算 煤气/产量
  341. DAY_21_A_JS = Number(DAY_21_A)/Number(DAY_2_A);
  342. //甲班的煤气总能耗计算 总煤气/产量
  343. MON_21_A_JS = Number(MON_21_A)/Number(MON_2_A);
  344. model.setValue(nodeSet1+"[21]/DAY_WGT_A",Math.round(DAY_21_A_JS*100)/100);
  345. model.setValue(nodeSet1+"[21]/MON_WGT_A",Math.round(MON_21_A_JS*100)/100);
  346. //甲班的电能耗量计算 电/产量
  347. DAY_22_A_JS = Number(DAY_22_A)/Number(DAY_2_A);
  348. //甲班的电总能耗计算 总电/产量
  349. MON_22_A_JS = Number(MON_22_A)/Number(MON_2_A);
  350. model.setValue(nodeSet1+"[22]/DAY_WGT_A",Math.round(DAY_22_A_JS*100)/100);
  351. model.setValue(nodeSet1+"[22]/MON_WGT_A",Math.round(MON_22_A_JS*100)/100);
  352. //甲班的水能耗量计算 水/产量
  353. DAY_23_A_JS = Number(DAY_23_A)/Number(DAY_2_A);
  354. //甲班的水总能耗计算 总水/产量
  355. MON_23_A_JS = Number(MON_23_A)/Number(MON_2_A);
  356. model.setValue(nodeSet1+"[23]/DAY_WGT_A",Math.round(DAY_23_A_JS*100)/100);
  357. model.setValue(nodeSet1+"[23]/MON_WGT_A",Math.round(MON_23_A_JS*100)/100);
  358. //甲班的空气能耗量计算 空气/产量
  359. DAY_24_A_JS = Number(DAY_24_A)/Number(DAY_2_A);
  360. //甲班的空气总能耗计算 总空气/产量
  361. MON_24_A_JS = Number(MON_24_A)/Number(MON_2_A);
  362. model.setValue(nodeSet1+"[24]/DAY_WGT_A",Math.round(DAY_24_A_JS*100)/100);
  363. model.setValue(nodeSet1+"[24]/MON_WGT_A",Math.round(MON_24_A_JS*100)/100);
  364. //甲班的辊能耗量计算 辊/产量
  365. DAY_25_A_JS = Number(DAY_25_A)/Number(DAY_2_A);
  366. //甲班的辊总能耗计算 总辊/产量
  367. MON_25_A_JS = Number(MON_25_A)/Number(MON_2_A);
  368. model.setValue(nodeSet1+"[25]/DAY_WGT_A",Math.round(DAY_25_A_JS*100)/100);
  369. model.setValue(nodeSet1+"[25]/MON_WGT_A",Math.round(MON_25_A_JS*100)/100);
  370. //甲班有效作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
  371. var DAY_34_A = (DAY_11_A-DAY_28_A)/(DAY_10_A-DAY_30_A-DAY_29_A);
  372. //甲班的总作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
  373. var MON_34_A = (MON_11_A-MON_28_A)/(MON_10_A-MON_30_A-MON_29_A);
  374. model.setValue(nodeSet1+"[34]/DAY_CNT_A",Math.round(DAY_34_A*100)/100);
  375. model.setValue(nodeSet1+"[34]/MON_CNT_A",Math.round(MON_34_A*100)/100);
  376. model.refresh();
  377. //////////////////////////////////////////////////////////////////////////////////
  378. //乙班的产量(吨)
  379. var DAY_2_B = null;
  380. //乙班的总产量(吨)
  381. var MON_2_B = null;
  382. //乙班的日历时间
  383. var DAY_10_B = null;
  384. //乙班日历总时间
  385. var MON_10_B = null;
  386. //乙班的轧钢时间
  387. var DAY_11_B = null;
  388. //乙班轧钢总时间
  389. var MON_11_B = null;
  390. //乙班的煤气耗量时间
  391. var DAY_21_B = null;
  392. //乙班的煤气耗量总时间
  393. var MON_21_B = null;
  394. //乙班的煤气耗量时间
  395. var DAY_21_B_JS = null;
  396. //乙班的煤气耗量总时间
  397. var MON_21_B_JS = null;
  398. //乙班的电耗量时间
  399. var DAY_22_B = null;
  400. //乙班的电耗量总时间
  401. var MON_22_B = null;
  402. //乙班的电耗量时间
  403. var DAY_22_B_JS = null;
  404. //乙班的电耗量总时间
  405. var MON_22_B_JS = null;
  406. //乙班的水耗量时间
  407. var DAY_23_B = null;
  408. //乙班的水耗量总时间
  409. var MON_23_B = null;
  410. //乙班的水耗量时间
  411. var DAY_23_B_JS = null;
  412. //乙班的水耗量总时间
  413. var MON_23_B_JS = null;
  414. //乙班的压缩空气时间
  415. var DAY_24_B = null;
  416. //乙班的压缩空气总时间
  417. var MON_24_B = null;
  418. //乙班的压缩空气时间
  419. var DAY_24_B_JS = null;
  420. //乙班的压缩空气总时间
  421. var MON_24_B_JS = null;
  422. //乙班的辊耗时间
  423. var DAY_25_B = null;
  424. //乙班的辊耗总时间
  425. var MON_25_B = null;
  426. //乙班的辊耗时间
  427. var DAY_25_B_JS = null;
  428. //乙班的辊耗总时间
  429. var MON_25_B_JS = null;
  430. //乙班的停轧机械时间
  431. var DAY_26_B = null;
  432. //乙班停轧机械总时间
  433. var MON_26_B = null;
  434. //乙班的停轧电器时间
  435. var DAY_27_B = null;
  436. //乙班停轧电器总时间
  437. var MON_27_B = null;
  438. //乙班的停轧轧钢时间
  439. var DAY_28_B = null;
  440. //乙班停轧轧钢总时间
  441. var MON_28_B = null;
  442. //乙班的停轧换辊时间
  443. var DAY_29_B = null;
  444. //乙班停轧换辊总时间
  445. var MON_29_B = null;
  446. //乙班的停轧检修时间
  447. var DAY_30_B = null;
  448. //乙班停轧检修总时间
  449. var MON_30_B = null;
  450. //乙班的停轧外部时间
  451. var DAY_31_B = null;
  452. //乙班停轧外部总时间
  453. var MON_31_B = null;
  454. //乙班的停轧原成时间
  455. var DAY_32_B = null;
  456. //乙班停轧原成总时间
  457. var MON_32_B = null;
  458. //乙班的停轧时间
  459. var DAY_33_B = null;
  460. //乙班停轧总时间
  461. var MON_33_B = null;
  462. for(var i=0;i<datagrid1.rows;i++){
  463. DAY_2_B = model.getValue(nodeSet1+"[2]/DAY_WGT_B");
  464. MON_2_B = model.getValue(nodeSet1+"[2]/MON_WGT_B");
  465. DAY_10_B = model.getValue(nodeSet1+"[10]/DAY_CNT_B");
  466. MON_10_B = model.getValue(nodeSet1+"[10]/MON_CNT_B");
  467. DAY_11_B = model.getValue(nodeSet1+"[11]/DAY_CNT_B");
  468. MON_11_B = model.getValue(nodeSet1+"[11]/MON_CNT_B");
  469. DAY_21_B = model.getValue(nodeSet1+"[21]/DAY_CNT_B");
  470. MON_21_B = model.getValue(nodeSet1+"[21]/MON_CNT_B");
  471. DAY_22_B = model.getValue(nodeSet1+"[22]/DAY_CNT_B");
  472. MON_22_B = model.getValue(nodeSet1+"[22]/MON_CNT_B");
  473. DAY_23_B = model.getValue(nodeSet1+"[23]/DAY_CNT_B");
  474. MON_23_B = model.getValue(nodeSet1+"[23]/MON_CNT_B");
  475. DAY_24_B = model.getValue(nodeSet1+"[24]/DAY_CNT_B");
  476. MON_24_B = model.getValue(nodeSet1+"[24]/MON_CNT_B");
  477. DAY_25_B = model.getValue(nodeSet1+"[25]/DAY_CNT_B");
  478. MON_25_B = model.getValue(nodeSet1+"[25]/MON_CNT_B");
  479. DAY_26_B = model.getValue(nodeSet1+"[26]/DAY_CNT_B");
  480. MON_26_B = model.getValue(nodeSet1+"[26]/MON_CNT_B");
  481. DAY_27_B = model.getValue(nodeSet1+"[27]/DAY_CNT_B");
  482. MON_27_B = model.getValue(nodeSet1+"[27]/MON_CNT_B");
  483. DAY_28_B = model.getValue(nodeSet1+"[28]/DAY_CNT_B");
  484. MON_28_B = model.getValue(nodeSet1+"[28]/MON_CNT_B");
  485. DAY_29_B = model.getValue(nodeSet1+"[29]/DAY_CNT_B");
  486. MON_29_B = model.getValue(nodeSet1+"[29]/MON_CNT_B");
  487. DAY_30_B = model.getValue(nodeSet1+"[30]/DAY_CNT_B");
  488. MON_30_B = model.getValue(nodeSet1+"[30]/MON_CNT_B");
  489. DAY_31_B = model.getValue(nodeSet1+"[31]/DAY_CNT_B");
  490. MON_31_B = model.getValue(nodeSet1+"[31]/MON_CNT_B");
  491. DAY_32_B = model.getValue(nodeSet1+"[32]/DAY_CNT_B");
  492. MON_32_B = model.getValue(nodeSet1+"[32]/MON_CNT_B");
  493. }
  494. //日历运转率
  495. var DAY_12_B = (Number(DAY_11_B)-Number(DAY_28_B))/Number(DAY_10_B);
  496. var MON_12_B = (Number(MON_11_B)-Number(MON_28_B))/Number(MON_10_B);
  497. model.setValue(nodeSet1+"[12]/DAY_CNT_B",Math.round(DAY_12_B*100)/100);
  498. model.setValue(nodeSet1+"[12]/MON_CNT_B",Math.round(MON_12_B*100)/100);
  499. //设备运转率
  500. var DAY_13_B = (Number(DAY_10_B)-Number(DAY_26_B))/Number(DAY_10_B);
  501. var MON_13_B = (Number(MON_10_B)-Number(MON_26_B))/Number(MON_10_B);
  502. model.setValue(nodeSet1+"[13]/DAY_CNT_B",Math.round(DAY_13_B*100)/100);
  503. model.setValue(nodeSet1+"[13]/MON_CNT_B",Math.round(MON_13_B*100)/100);
  504. //电器运转率
  505. var DAY_14_B = (Number(DAY_10_B)-Number(DAY_27_B))/Number(DAY_10_B);
  506. var MON_14_B = (Number(MON_10_B)-Number(MON_27_B))/Number(MON_10_B);
  507. model.setValue(nodeSet1+"[14]/DAY_CNT_B",Math.round(DAY_14_B*100)/100);
  508. model.setValue(nodeSet1+"[14]/MON_CNT_B",Math.round(MON_14_B*100)/100);
  509. //机时产量
  510. var DAY_15_B = (Number(DAY_2_B)/Number(DAY_11_B))*60;
  511. var MON_15_B = (Number(MON_2_B)/Number(MON_11_B))*60;
  512. model.setValue(nodeSet1+"[15]/DAY_CNT_B",Math.round(DAY_15_B*100)/100);
  513. model.setValue(nodeSet1+"[15]/MON_CNT_B",Math.round(MON_15_B*100)/100);
  514. //停轧时间的总计
  515. var DAY_33_B = Number(DAY_26_B)+Number(DAY_27_B)+Number(DAY_28_B)+Number(DAY_29_B)+Number(DAY_30_B)+Number(DAY_31_B)+Number(DAY_32_B);
  516. var MON_33_B = Number(MON_26_B)+Number(MON_27_B)+Number(MON_28_B)+Number(MON_29_B)+Number(MON_30_B)+Number(MON_31_B)+Number(MON_32_B);
  517. model.setValue(nodeSet1+"[33]/DAY_CNT_B",Math.round(DAY_33_B*100)/100);
  518. model.setValue(nodeSet1+"[33]/MON_CNT_B",Math.round(MON_33_B*100)/100);
  519. //乙班的煤气耗量时间
  520. DAY_21_B_JS = Number(DAY_21_B)/Number(DAY_2_B);
  521. //乙班的煤气耗量总时间
  522. MON_21_B_JS = Number(MON_21_B)/Number(MON_2_B);
  523. model.setValue(nodeSet1+"[21]/DAY_WGT_B",Math.round(DAY_21_B_JS*100)/100);
  524. model.setValue(nodeSet1+"[21]/MON_WGT_B",Math.round(MON_21_B_JS*100)/100);
  525. //乙班的电耗量计算
  526. DAY_22_B_JS = Number(DAY_22_B)/Number(DAY_2_B);
  527. //乙班的电耗量计算
  528. MON_22_B_JS = Number(MON_22_B)/Number(MON_2_B);
  529. model.setValue(nodeSet1+"[22]/DAY_WGT_B",Math.round(DAY_22_B_JS*100)/100);
  530. model.setValue(nodeSet1+"[22]/MON_WGT_B",Math.round(MON_22_B_JS*100)/100);
  531. //乙班的水耗量时间
  532. DAY_23_B_JS = Number(DAY_23_B)/Number(DAY_2_B);
  533. //乙班的水耗量总时间
  534. MON_23_B_JS = Number(MON_23_B)/Number(MON_2_B);
  535. model.setValue(nodeSet1+"[23]/DAY_WGT_B",Math.round(DAY_23_B_JS*100)/100);
  536. model.setValue(nodeSet1+"[23]/MON_WGT_B",Math.round(MON_23_B_JS*100)/100);
  537. //乙班的压缩空气时间
  538. DAY_24_B_JS = Number(DAY_24_B)/Number(DAY_2_B);
  539. //乙班的压缩空气总时间
  540. MON_24_B_JS = Number(MON_24_B)/Number(MON_2_B);
  541. model.setValue(nodeSet1+"[24]/DAY_WGT_B",Math.round(DAY_24_B_JS*100)/100);
  542. model.setValue(nodeSet1+"[24]/MON_WGT_B",Math.round(MON_24_B_JS*100)/100);
  543. //乙班的辊耗时间
  544. DAY_25_B_JS = Number(DAY_25_B)/Number(DAY_2_B);
  545. //乙班的辊耗总时间
  546. MON_25_B_JS = Number(MON_25_B)/Number(MON_2_B);
  547. model.setValue(nodeSet1+"[25]/DAY_WGT_B",Math.round(DAY_25_B_JS*100)/100);
  548. model.setValue(nodeSet1+"[25]/MON_WGT_B",Math.round(DAY_25_B_JS*100)/100);
  549. //乙班有效作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
  550. var DAY_34_B = (DAY_11_B-DAY_28_B)/(DAY_10_B-DAY_30_B-DAY_29_B);
  551. //乙班的总作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
  552. var MON_34_B = (MON_11_B-MON_28_B)/(MON_10_B-MON_30_B-MON_29_B);
  553. model.setValue(nodeSet1+"[34]/DAY_CNT_B",Math.round(DAY_34_B*100)/100);
  554. model.setValue(nodeSet1+"[34]/MON_CNT_B",Math.round(MON_34_B*100)/100);
  555. model.refresh();
  556. ////////////////////////////////////////////////////////////////////////////////
  557. //丙班的产量(吨)
  558. var DAY_2_C = null;
  559. //丙班的总产量(吨)
  560. var MON_2_C = null;
  561. //丙班的日历时间
  562. var DAY_10_C = null;
  563. //丙班日历总时间
  564. var MON_10_C = null;
  565. //丙班的轧钢时间
  566. var DAY_11_C = null;
  567. //丙班轧钢总时间
  568. var MON_11_C = null;
  569. //丙班的煤气耗量时间
  570. var DAY_21_C = null;
  571. //丙班的煤气耗量总时间
  572. var MON_21_C = null;
  573. //丙班的煤气耗量时间
  574. var DAY_21_C_JS = null;
  575. //丙班的煤气耗量总时间
  576. var MON_21_C_JS = null;
  577. //丙班的电耗量时间
  578. var DAY_22_C = null;
  579. //丙班的电耗量总时间
  580. var MON_22_C = null;
  581. //丙班的电耗量时间
  582. var DAY_22_C_JS = null;
  583. //丙班的电耗量总时间
  584. var MON_22_C_JS = null;
  585. //丙班的水耗量时间
  586. var DAY_23_C = null;
  587. //丙班的水耗量总时间
  588. var MON_23_C = null;
  589. //丙班的水耗量时间
  590. var DAY_23_C_JS = null;
  591. //丙班的水耗量总时间
  592. var MON_23_C_JS = null;
  593. //丙班的压缩空气时间
  594. var DAY_24_C = null;
  595. //丙班的压缩空气总时间
  596. var MON_24_C = null;
  597. //丙班的压缩空气时间
  598. var DAY_24_C_JS = null;
  599. //丙班的压缩空气总时间
  600. var MON_24_C_JS = null;
  601. //丙班的辊耗时间
  602. var DAY_25_C = null;
  603. //丙班的辊耗总时间
  604. var MON_25_C = null;
  605. //丙班的辊耗时间
  606. var DAY_25_C_JS = null;
  607. //丙班的辊耗总时间
  608. var MON_25_C_JS = null;
  609. //丙班的停轧机械时间
  610. var DAY_26_C = null;
  611. //丙班停轧机械总时间
  612. var MON_26_C = null;
  613. //丙班的停轧电器时间
  614. var DAY_27_C = null;
  615. //丙班停轧电器总时间
  616. var MON_27_C = null;
  617. //丙班的停轧轧钢时间
  618. var DAY_28_C = null;
  619. //丙班停轧轧钢总时间
  620. var MON_28_C = null;
  621. //丙班的停轧换辊时间
  622. var DAY_29_C = null;
  623. //丙班停轧换辊总时间
  624. var MON_29_C = null;
  625. //丙班的停轧检修时间
  626. var DAY_30_C = null;
  627. //丙班停轧检修总时间
  628. var MON_30_C = null;
  629. //丙班的停轧外部时间
  630. var DAY_31_C = null;
  631. //丙班停轧外部总时间
  632. var MON_31_C = null;
  633. //丙班的停轧原成时间
  634. var DAY_32_C = null;
  635. //丙班停轧原成总时间
  636. var MON_32_C = null;
  637. //丙班的停轧时间
  638. var DAY_33_C = null;
  639. //丙班停轧总时间
  640. var MON_33_C = null;
  641. for(var i=0;i<datagrid1.rows;i++){
  642. DAY_2_C = model.getValue(nodeSet1+"[2]/DAY_WGT_C");
  643. MON_2_C = model.getValue(nodeSet1+"[2]/MON_WGT_C");
  644. DAY_10_C = model.getValue(nodeSet1+"[10]/DAY_CNT_C");
  645. MON_10_C = model.getValue(nodeSet1+"[10]/MON_CNT_C");
  646. DAY_11_C = model.getValue(nodeSet1+"[11]/DAY_CNT_C");
  647. MON_11_C = model.getValue(nodeSet1+"[11]/MON_CNT_C");
  648. DAY_21_C = model.getValue(nodeSet1+"[21]/DAY_CNT_C");
  649. MON_21_C = model.getValue(nodeSet1+"[21]/MON_CNT_C");
  650. DAY_22_C = model.getValue(nodeSet1+"[22]/DAY_CNT_C");
  651. MON_22_C = model.getValue(nodeSet1+"[22]/MON_CNT_C");
  652. DAY_23_C = model.getValue(nodeSet1+"[23]/DAY_CNT_C");
  653. MON_23_C = model.getValue(nodeSet1+"[23]/MON_CNT_C");
  654. DAY_24_C = model.getValue(nodeSet1+"[24]/DAY_CNT_C");
  655. MON_24_C = model.getValue(nodeSet1+"[24]/MON_CNT_C");
  656. DAY_25_C = model.getValue(nodeSet1+"[25]/DAY_CNT_C");
  657. MON_25_C = model.getValue(nodeSet1+"[25]/MON_CNT_C");
  658. DAY_26_C = model.getValue(nodeSet1+"[26]/DAY_CNT_C");
  659. MON_26_C = model.getValue(nodeSet1+"[26]/MON_CNT_C");
  660. DAY_27_C = model.getValue(nodeSet1+"[27]/DAY_CNT_C");
  661. MON_27_C = model.getValue(nodeSet1+"[27]/MON_CNT_C");
  662. DAY_28_C = model.getValue(nodeSet1+"[28]/DAY_CNT_C");
  663. MON_28_C = model.getValue(nodeSet1+"[28]/MON_CNT_C");
  664. DAY_29_C = model.getValue(nodeSet1+"[29]/DAY_CNT_C");
  665. MON_29_C = model.getValue(nodeSet1+"[29]/MON_CNT_C");
  666. DAY_30_C = model.getValue(nodeSet1+"[30]/DAY_CNT_C");
  667. MON_30_C = model.getValue(nodeSet1+"[30]/MON_CNT_C");
  668. DAY_31_C = model.getValue(nodeSet1+"[31]/DAY_CNT_C");
  669. MON_31_C = model.getValue(nodeSet1+"[31]/MON_CNT_C");
  670. DAY_32_C = model.getValue(nodeSet1+"[32]/DAY_CNT_C");
  671. MON_32_C = model.getValue(nodeSet1+"[32]/MON_CNT_C");
  672. }
  673. //日历运转率
  674. var DAY_12_C = (Number(DAY_11_C)-Number(DAY_28_C))/Number(DAY_10_C);
  675. var MON_12_C = (Number(MON_11_C)-Number(MON_28_C))/Number(MON_10_C);
  676. model.setValue(nodeSet1+"[12]/DAY_CNT_C",Math.round(DAY_12_C*100)/100);
  677. model.setValue(nodeSet1+"[12]/MON_CNT_C",Math.round(MON_12_C*100)/100);
  678. //设备运转率
  679. var DAY_13_C = (Number(DAY_10_C)-Number(DAY_26_C))/Number(DAY_10_C);
  680. var MON_13_C = (Number(MON_10_C)-Number(MON_26_C))/Number(MON_10_C);
  681. model.setValue(nodeSet1+"[13]/DAY_CNT_C",Math.round(DAY_13_C*100)/100);
  682. model.setValue(nodeSet1+"[13]/MON_CNT_C",Math.round(MON_13_C*100)/100);
  683. //电器运转率
  684. var DAY_14_C = (Number(DAY_10_C)-Number(DAY_27_C))/Number(DAY_10_C);
  685. var MON_14_C = (Number(MON_10_C)-Number(MON_27_C))/Number(MON_10_C);
  686. model.setValue(nodeSet1+"[14]/DAY_CNT_C",Math.round(DAY_14_C*100)/100);
  687. model.setValue(nodeSet1+"[14]/MON_CNT_C",Math.round(MON_14_C*100)/100);
  688. //机时产量
  689. var DAY_15_C = (Number(DAY_2_C)/Number(DAY_11_C))*60;
  690. var MON_15_C = (Number(MON_2_C)/Number(MON_11_C))*60;
  691. model.setValue(nodeSet1+"[15]/DAY_CNT_C",Math.round(DAY_15_C*100)/100);
  692. model.setValue(nodeSet1+"[15]/MON_CNT_C",Math.round(MON_15_C*100)/100);
  693. //停轧时间的总计
  694. var DAY_33_C = Number(DAY_26_C)+Number(DAY_27_C)+Number(DAY_28_C)+Number(DAY_29_C)+Number(DAY_30_C)+Number(DAY_31_C)+Number(DAY_32_C);
  695. var MON_33_C = Number(MON_26_C)+Number(MON_27_C)+Number(MON_28_C)+Number(MON_29_C)+Number(MON_30_C)+Number(MON_31_C)+Number(MON_32_C);
  696. model.setValue(nodeSet1+"[33]/DAY_CNT_C",Math.round(DAY_33_C*100)/100);
  697. model.setValue(nodeSet1+"[33]/MON_CNT_C",Math.round(MON_33_C*100)/100);
  698. //丙班的煤气耗量时间
  699. DAY_21_C_JS = Number(DAY_21_C)/Number(DAY_2_C);
  700. //丙班的煤气耗量总时间
  701. MON_21_C_JS = Number(MON_21_C)/Number(MON_2_C);
  702. model.setValue(nodeSet1+"[21]/DAY_WGT_C",Math.round(DAY_21_C_JS*100)/100);
  703. model.setValue(nodeSet1+"[21]/MON_WGT_C",Math.round(MON_21_C_JS*100)/100);
  704. //丙班的电耗量时间
  705. DAY_22_C_JS = Number(DAY_22_C)/Number(DAY_2_C);
  706. //丙班的电耗量总时间
  707. MON_22_C_JS = Number(MON_22_C)/Number(MON_2_C);
  708. model.setValue(nodeSet1+"[22]/DAY_WGT_C",Math.round(DAY_22_C_JS*100)/100);
  709. model.setValue(nodeSet1+"[22]/MON_WGT_C",Math.round(MON_22_C_JS*100)/100);
  710. //丙班的水耗量时间
  711. DAY_23_C_JS = Number(DAY_23_C)/Number(DAY_2_C);
  712. //丙班的水耗量总时间
  713. MON_23_C_JS = Number(MON_23_C)/Number(MON_2_C);
  714. model.setValue(nodeSet1+"[23]/DAY_WGT_C",Math.round(DAY_23_C_JS*100)/100);
  715. model.setValue(nodeSet1+"[23]/MON_WGT_C",Math.round(MON_23_C_JS*100)/100);
  716. //丙班的压缩空气时间
  717. DAY_24_C_JS = Number(DAY_24_C)/Number(DAY_2_C);
  718. //丙班的压缩空气总时间
  719. MON_24_C_JS = Number(MON_24_C)/Number(MON_2_C);
  720. model.setValue(nodeSet1+"[24]/DAY_WGT_C",Math.round(DAY_24_C_JS*100)/100);
  721. model.setValue(nodeSet1+"[24]/MON_WGT_C",Math.round(MON_24_C_JS*100)/100);
  722. //丙班的辊耗时间
  723. DAY_25_C_JS = Number(DAY_25_C)/Number(DAY_2_C);
  724. //丙班的辊耗总时间
  725. MON_25_C_JS = Number(MON_25_C)/Number(MON_2_C);
  726. model.setValue(nodeSet1+"[25]/DAY_WGT_C",Math.round(DAY_25_C_JS*100)/100);
  727. model.setValue(nodeSet1+"[25]/MON_WGT_C",Math.round(MON_25_C_JS*100)/100);
  728. //丙班有效作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
  729. var DAY_34_C = (DAY_11_C-DAY_28_C)/(DAY_10_C-DAY_30_C-DAY_29_C);
  730. //丙班的总作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
  731. var MON_34_C = (MON_11_C-MON_28_C)/(MON_10_C-MON_30_C-MON_29_C);
  732. model.setValue(nodeSet1+"[34]/DAY_CNT_C",Math.round(DAY_34_C*100)/100);
  733. model.setValue(nodeSet1+"[34]/MON_CNT_C",Math.round(MON_34_C*100)/100);
  734. model.refresh();
  735. ////////////////////////////////////////////////////////////////////////////////
  736. //丁班的产量(吨)
  737. var DAY_2_D = null;
  738. //丁班的总产量(吨)
  739. var MON_2_D = null;
  740. //丁班的日历时间
  741. var DAY_10_D = null;
  742. //丁班日历总时间
  743. var MON_10_D = null;
  744. //丙班的轧钢时间
  745. var DAY_11_D = null;
  746. //丙班轧钢总时间
  747. var MON_11_D = null;
  748. //丙班的煤气耗量时间
  749. var DAY_21_D = null;
  750. //丙班的煤气耗量总时间
  751. var MON_21_D = null;
  752. //丙班的煤气耗量时间
  753. var DAY_21_D_JS = null;
  754. //丙班的煤气耗量总时间
  755. var MON_21_D_JS = null;
  756. //丙班的电耗量时间
  757. var DAY_22_D = null;
  758. //丙班的电耗量总时间
  759. var MON_22_D = null;
  760. //丙班的电耗量时间
  761. var DAY_22_D_JS = null;
  762. //丙班的电耗量总时间
  763. var MON_22_D_JS = null;
  764. //丙班的水耗量时间
  765. var DAY_23_D = null;
  766. //丙班的水耗量总时间
  767. var MON_23_D = null;
  768. //丙班的水耗量时间
  769. var DAY_23_D_JS = null;
  770. //丙班的水耗量总时间
  771. var MON_23_D_JS = null;
  772. //丙班的压缩空气时间
  773. var DAY_24_D = null;
  774. //丙班的压缩空气总时间
  775. var MON_24_D = null;
  776. //丙班的压缩空气时间
  777. var DAY_24_D_JS = null;
  778. //丙班的压缩空气总时间
  779. var MON_24_D_JS = null;
  780. //丙班的辊耗时间
  781. var DAY_25_D = null;
  782. //丙班的辊耗总时间
  783. var MON_25_D = null;
  784. //丙班的辊耗时间
  785. var DAY_25_D_JS = null;
  786. //丙班的辊耗总时间
  787. var MON_25_D_JS = null;
  788. //丙班的停轧机械时间
  789. var DAY_26_D = null;
  790. //丙班停轧机械总时间
  791. var MON_26_D = null;
  792. //丙班的停轧电器时间
  793. var DAY_27_D = null;
  794. //丙班停轧电器总时间
  795. var MON_27_D = null;
  796. //丙班的停轧轧钢时间
  797. var DAY_28_D = null;
  798. //丙班停轧轧钢总时间
  799. var MON_28_D = null;
  800. //丙班的停轧换辊时间
  801. var DAY_29_D = null;
  802. //丙班停轧换辊总时间
  803. var MON_29_D = null;
  804. //丙班的停轧检修时间
  805. var DAY_30_D = null;
  806. //丙班停轧检修总时间
  807. var MON_30_D = null;
  808. //丙班的停轧外部时间
  809. var DAY_31_D = null;
  810. //丙班停轧外部总时间
  811. var MON_31_D = null;
  812. //丙班的停轧原成时间
  813. var DAY_32_D = null;
  814. //丙班停轧原成总时间
  815. var MON_32_D = null;
  816. //丙班的停轧时间
  817. var DAY_33_D = null;
  818. //丙班停轧总时间
  819. var MON_33_D = null;
  820. for(var i=0;i<datagrid1.rows;i++){
  821. DAY_2_D = model.getValue(nodeSet1+"[2]/DAY_WGT_D");
  822. MON_2_D = model.getValue(nodeSet1+"[2]/MON_WGT_D");
  823. DAY_10_D = model.getValue(nodeSet1+"[10]/DAY_CNT_D");
  824. MON_10_D = model.getValue(nodeSet1+"[10]/MON_CNT_D");
  825. DAY_11_D = model.getValue(nodeSet1+"[11]/DAY_CNT_D");
  826. MON_11_D = model.getValue(nodeSet1+"[11]/MON_CNT_D");
  827. DAY_21_D = model.getValue(nodeSet1+"[21]/DAY_CNT_D");
  828. MON_21_D = model.getValue(nodeSet1+"[21]/MON_CNT_D");
  829. DAY_22_D = model.getValue(nodeSet1+"[22]/DAY_CNT_D");
  830. MON_22_D = model.getValue(nodeSet1+"[22]/MON_CNT_D");
  831. DAY_23_D = model.getValue(nodeSet1+"[23]/DAY_CNT_D");
  832. MON_23_D = model.getValue(nodeSet1+"[23]/MON_CNT_D");
  833. DAY_24_D = model.getValue(nodeSet1+"[24]/DAY_CNT_D");
  834. MON_24_D = model.getValue(nodeSet1+"[24]/MON_CNT_D");
  835. DAY_25_D = model.getValue(nodeSet1+"[25]/DAY_CNT_D");
  836. MON_25_D = model.getValue(nodeSet1+"[25]/MON_CNT_D");
  837. DAY_26_D = model.getValue(nodeSet1+"[26]/DAY_CNT_D");
  838. MON_26_D = model.getValue(nodeSet1+"[26]/MON_CNT_D");
  839. DAY_27_D = model.getValue(nodeSet1+"[27]/DAY_CNT_D");
  840. MON_27_D = model.getValue(nodeSet1+"[27]/MON_CNT_D");
  841. DAY_28_D = model.getValue(nodeSet1+"[28]/DAY_CNT_D");
  842. MON_28_D = model.getValue(nodeSet1+"[28]/MON_CNT_D");
  843. DAY_29_D = model.getValue(nodeSet1+"[29]/DAY_CNT_D");
  844. MON_29_D = model.getValue(nodeSet1+"[29]/MON_CNT_D");
  845. DAY_30_D = model.getValue(nodeSet1+"[30]/DAY_CNT_D");
  846. MON_30_D = model.getValue(nodeSet1+"[30]/MON_CNT_D");
  847. DAY_31_D = model.getValue(nodeSet1+"[31]/DAY_CNT_D");
  848. MON_31_D = model.getValue(nodeSet1+"[31]/MON_CNT_D");
  849. DAY_32_D = model.getValue(nodeSet1+"[32]/DAY_CNT_D");
  850. MON_32_D = model.getValue(nodeSet1+"[32]/MON_CNT_D");
  851. }
  852. //日历运转率
  853. var DAY_12_D = (Number(DAY_11_D)-Number(DAY_28_D))/Number(DAY_10_D);
  854. var MON_12_D = (Number(MON_11_D)-Number(MON_28_D))/Number(MON_10_D);
  855. model.setValue(nodeSet1+"[12]/DAY_CNT_D",Math.round(DAY_12_D*100)/100);
  856. model.setValue(nodeSet1+"[12]/MON_CNT_D",Math.round(MON_12_D*100)/100);
  857. //设备运转率
  858. var DAY_13_D = (Number(DAY_10_D)-Number(DAY_26_D))/Number(DAY_10_D);
  859. var MON_13_D = (Number(MON_10_D)-Number(MON_26_D))/Number(MON_10_D);
  860. model.setValue(nodeSet1+"[13]/DAY_CNT_D",Math.round(DAY_13_D*100)/100);
  861. model.setValue(nodeSet1+"[13]/MON_CNT_D",Math.round(MON_13_D*100)/100);
  862. //电器运转率
  863. var DAY_14_D = (Number(DAY_10_D)-Number(DAY_27_D))/Number(DAY_10_D);
  864. var MON_14_D = (Number(MON_10_D)-Number(MON_27_D))/Number(MON_10_D);
  865. model.setValue(nodeSet1+"[14]/DAY_CNT_D",Math.round(DAY_14_D*100)/100);
  866. model.setValue(nodeSet1+"[14]/MON_CNT_D",Math.round(MON_14_D*100)/100);
  867. //机时产量
  868. var DAY_15_D = (Number(DAY_2_D)/Number(DAY_11_D))*60;
  869. var MON_15_D = (Number(MON_2_D)/Number(MON_11_D))*60;
  870. model.setValue(nodeSet1+"[15]/DAY_CNT_D",Math.round(DAY_15_D*100)/100);
  871. model.setValue(nodeSet1+"[15]/MON_CNT_D",Math.round(MON_15_D*100)/100);
  872. //停轧时间的总计
  873. var DAY_33_D = Number(DAY_26_D)+Number(DAY_27_D)+Number(DAY_28_D)+Number(DAY_29_D)+Number(DAY_30_D)+Number(DAY_31_D)+Number(DAY_32_D);
  874. var MON_33_D = Number(MON_26_D)+Number(MON_27_D)+Number(MON_28_D)+Number(MON_29_D)+Number(MON_30_D)+Number(MON_31_D)+Number(MON_32_D);
  875. model.setValue(nodeSet1+"[33]/DAY_CNT_D",Math.round(DAY_33_D*100)/100);
  876. model.setValue(nodeSet1+"[33]/MON_CNT_D",Math.round(MON_33_D*100)/100);
  877. //丙班的煤气耗量时间
  878. DAY_21_D_JS = Number(DAY_21_D)/Number(DAY_2_D);
  879. //丙班的煤气耗量总时间
  880. MON_21_D_JS = Number(MON_21_D)/Number(MON_2_D);
  881. model.setValue(nodeSet1+"[21]/DAY_WGT_D",Math.round(DAY_21_D_JS*100)/100);
  882. model.setValue(nodeSet1+"[21]/MON_WGT_D",Math.round(MON_21_D_JS*100)/100);
  883. //丙班的电耗量时间
  884. DAY_22_D_JS = Number(DAY_22_D)/Number(DAY_2_D);
  885. //丙班的电耗量总时间
  886. MON_22_D_JS = Number(MON_22_D)/Number(MON_2_D);
  887. model.setValue(nodeSet1+"[22]/DAY_WGT_D",Math.round(DAY_22_D_JS*100)/100);
  888. model.setValue(nodeSet1+"[22]/MON_WGT_D",Math.round(MON_22_D_JS*100)/100);
  889. //丙班的水耗量时间
  890. DAY_23_D_JS = Number(DAY_23_D)/Number(DAY_2_D);
  891. //丙班的水耗量总时间
  892. MON_23_D_JS = Number(MON_23_D)/Number(MON_2_D);
  893. model.setValue(nodeSet1+"[23]/DAY_WGT_D",Math.round(DAY_23_D_JS*100)/100);
  894. model.setValue(nodeSet1+"[23]/MON_WGT_D",Math.round(MON_23_D_JS*100)/100);
  895. //丙班的压缩空气时间
  896. DAY_24_D_JS = Number(DAY_24_D)/Number(DAY_2_D);
  897. //丙班的压缩空气总时间
  898. MON_24_D_JS = Number(MON_24_D)/Number(MON_2_D);
  899. model.setValue(nodeSet1+"[24]/DAY_WGT_D",Math.round(DAY_24_D_JS*100)/100);
  900. model.setValue(nodeSet1+"[24]/MON_WGT_D",Math.round(MON_24_D_JS*100)/100);
  901. //丙班的辊耗时间
  902. DAY_25_D_JS = Number(DAY_25_D)/Number(DAY_2_D);
  903. //丙班的辊耗总时间
  904. MON_25_D_JS = Number(MON_25_D)/Number(MON_2_D);
  905. model.setValue(nodeSet1+"[25]/DAY_WGT_D",Math.round(DAY_25_D_JS*100)/100);
  906. model.setValue(nodeSet1+"[25]/MON_WGT_D",Math.round(MON_25_D_JS*100)/100);
  907. //丁班有效作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
  908. var DAY_34_D = (DAY_11_D-DAY_28_D)/(DAY_10_D-DAY_30_D-DAY_29_D);
  909. //丁班的总作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
  910. var MON_34_D = (MON_11_D-MON_28_D)/(MON_10_D-MON_30_D-MON_29_D);
  911. model.setValue(nodeSet1+"[34]/DAY_CNT_D",Math.round(DAY_34_D*100)/100);
  912. model.setValue(nodeSet1+"[34]/MON_CNT_D",Math.round(MON_34_D*100)/100);
  913. model.refresh();
  914. //////////////////////////////////////////////////////////////////////////////////////////
  915. //全天的产量(吨)
  916. var DAY_2 = null;
  917. //全天的总产量(吨)
  918. var MON_2 = null;
  919. //全天的日历时间
  920. var DAY_10 = null;
  921. //全天日历总时间
  922. var MON_10 = null;
  923. //全天的轧钢时间
  924. var DAY_11 = null;
  925. //全天轧钢总时间
  926. var MON_11 = null;
  927. //全天的煤气耗量时间
  928. var DAY_21 = null;
  929. //全天的煤气耗量总时间
  930. var MON_21 = null;
  931. //全天的煤气耗量时间
  932. var DAY_21_JS = null;
  933. //全天的煤气耗量总时间
  934. var MON_21_JS = null;
  935. //全天的电耗量时间
  936. var DAY_22 = null;
  937. //全天的电耗量总时间
  938. var MON_22 = null;
  939. //全天的电耗量时间
  940. var DAY_22_JS = null;
  941. //全天的电耗量总时间
  942. var MON_22_JS = null;
  943. //全天的水耗量时间
  944. var DAY_23 = null;
  945. //全天的水耗量总时间
  946. var MON_23 = null;
  947. //全天的水耗量时间
  948. var DAY_23_JS = null;
  949. //全天的水耗量总时间
  950. var MON_23_JS = null;
  951. //全天的压缩空气时间
  952. var DAY_24 = null;
  953. //全天的压缩空气总时间
  954. var MON_24 = null;
  955. //全天的压缩空气时间
  956. var DAY_24_JS = null;
  957. //全天的压缩空气总时间
  958. var MON_24_JS = null;
  959. //全天的辊耗时间
  960. var DAY_25 = null;
  961. //全天的辊耗总时间
  962. var MON_25 = null;
  963. //全天的辊耗时间
  964. var DAY_25_JS = null;
  965. //全天的辊耗总时间
  966. var MON_25_JS = null;
  967. //全天的停轧机械时间
  968. var DAY_26 = null;
  969. //全天停轧机械总时间
  970. var MON_26 = null;
  971. //全天的停轧电器时间
  972. var DAY_27 = null;
  973. //全天停轧电器总时间
  974. var MON_27 = null;
  975. //全天的停轧轧钢时间
  976. var DAY_28 = null;
  977. //全天停轧轧钢总时间
  978. var MON_28 = null;
  979. //全天的停轧换辊时间
  980. var DAY_29 = null;
  981. //全天停轧换辊总时间
  982. var MON_29 = null;
  983. //全天的停轧检修时间
  984. var DAY_30 = null;
  985. //全天停轧检修总时间
  986. var MON_30 = null;
  987. //全天的停轧外部时间
  988. var DAY_31 = null;
  989. //全天停轧外部总时间
  990. var MON_31 = null;
  991. //全天的停轧原成时间
  992. var DAY_32 = null;
  993. //全天停轧原成总时间
  994. var MON_32 = null;
  995. //全天的停轧时间
  996. var DAY_33 = null;
  997. //全天停轧总时间
  998. var MON_33 = null;
  999. //这里的全部数据都是3个班的总和,不能从表中取出而是要放入表中
  1000. //日历时间、
  1001. DAY_10 = Number(DAY_10_D)+Number(DAY_10_C)+Number(DAY_10_B)+Number(DAY_10_A);
  1002. model.setValue(nodeSet1+"[10]/DAY_CNT",DAY_10);
  1003. MON_10 = Number(MON_10_D)+Number(MON_10_C)+Number(MON_10_B)+Number(MON_10_A);
  1004. model.setValue(nodeSet1+"[10]/MON_CNT",MON_10);
  1005. //轧钢时间
  1006. DAY_11 = Number(DAY_11_D)+Number(DAY_11_C)+Number(DAY_11_B)+Number(DAY_11_A);
  1007. model.setValue(nodeSet1+"[11]/DAY_CNT",DAY_11);
  1008. MON_11 = Number(MON_11_D)+Number(MON_11_C)+Number(MON_11_B)+Number(MON_11_A);
  1009. model.setValue(nodeSet1+"[11]/MON_CNT",MON_11);
  1010. //煤气消耗量
  1011. DAY_21 = Number(DAY_21_D)+Number(DAY_21_C)+Number(DAY_21_B)+Number(DAY_21_A);
  1012. model.setValue(nodeSet1+"[21]/DAY_CNT",DAY_21);
  1013. MON_21 = Number(MON_21_D)+Number(MON_21_C)+Number(MON_21_B)+Number(MON_21_A);
  1014. model.setValue(nodeSet1+"[21]/MON_CNT",MON_21);
  1015. //电耗量
  1016. DAY_22 = Number(DAY_22_D)+Number(DAY_22_C)+Number(DAY_22_B)+Number(DAY_22_A);
  1017. model.setValue(nodeSet1+"[22]/DAY_CNT",DAY_22);
  1018. MON_22 = Number(MON_22_D)+Number(MON_22_C)+Number(MON_22_B)+Number(MON_22_A);
  1019. model.setValue(nodeSet1+"[22]/MON_CNT",MON_22);
  1020. //水耗量
  1021. DAY_23 = Number(DAY_23_D)+Number(DAY_23_C)+Number(DAY_23_B)+Number(DAY_23_A);
  1022. model.setValue(nodeSet1+"[23]/DAY_CNT",DAY_23);
  1023. MON_23 = Number(DAY_23_D)+Number(MON_23_C)+Number(MON_23_B)+Number(MON_23_A);
  1024. model.setValue(nodeSet1+"[23]/MON_CNT",MON_23);
  1025. //压缩空气
  1026. DAY_24 = Number(DAY_24_D)+Number(DAY_24_C)+Number(DAY_24_B)+Number(DAY_24_A);
  1027. model.setValue(nodeSet1+"[24]/DAY_CNT",DAY_24);
  1028. MON_24 = Number(MON_24_D)+Number(MON_24_C)+Number(MON_24_B)+Number(MON_24_A);
  1029. model.setValue(nodeSet1+"[24]/MON_CNT",MON_24);
  1030. //辊耗
  1031. DAY_25 = Number(DAY_25_D)+Number(DAY_25_C)+Number(DAY_25_B)+Number(DAY_25_A);
  1032. model.setValue(nodeSet1+"[25]/DAY_CNT",DAY_25);
  1033. MON_25 = Number(MON_25_D)+Number(MON_25_C)+Number(MON_25_B)+Number(MON_25_A);
  1034. model.setValue(nodeSet1+"[25]/MON_CNT",MON_25);
  1035. //停轧时间(机械)
  1036. DAY_26 = Number(DAY_26_D)+Number(DAY_26_C)+Number(DAY_26_B)+Number(DAY_26_A);
  1037. model.setValue(nodeSet1+"[26]/DAY_CNT",DAY_26);
  1038. MON_26 = Number(MON_26_D)+Number(MON_26_C)+Number(MON_26_B)+Number(MON_26_A);
  1039. model.setValue(nodeSet1+"[26]/MON_CNT",MON_26);
  1040. //停轧时间(电器)
  1041. DAY_27 = Number(DAY_27_D)+Number(DAY_27_C)+Number(DAY_27_B)+Number(DAY_27_A);
  1042. model.setValue(nodeSet1+"[27]/DAY_CNT",DAY_27);
  1043. MON_27 = Number(MON_27_D)+Number(MON_27_C)+Number(MON_27_B)+Number(MON_27_A);
  1044. model.setValue(nodeSet1+"[27]/MON_CNT",MON_27);
  1045. //停轧时间(轧钢)
  1046. DAY_28 = Number(DAY_28_D)+Number(DAY_28_C)+Number(DAY_28_B)+Number(DAY_28_A);
  1047. model.setValue(nodeSet1+"[28]/DAY_CNT",DAY_28);
  1048. MON_28 = Number(MON_28_D)+Number(MON_28_C)+Number(MON_28_B)+Number(MON_28_A);
  1049. model.setValue(nodeSet1+"[28]/MON_CNT",MON_28);
  1050. //停轧时间(换辊)
  1051. DAY_29 = Number(DAY_29_D)+Number(DAY_29_C)+Number(DAY_29_B)+Number(DAY_29_A);
  1052. model.setValue(nodeSet1+"[29]/DAY_CNT",DAY_29);
  1053. MON_29 = Number(MON_29_D)+Number(MON_29_C)+Number(MON_29_B)+Number(MON_29_A);
  1054. model.setValue(nodeSet1+"[29]/MON_CNT",MON_29);
  1055. //停轧时间(检修)
  1056. DAY_30 = Number(DAY_30_D)+Number(DAY_30_C)+Number(DAY_30_B)+Number(DAY_30_A);
  1057. model.setValue(nodeSet1+"[30]/DAY_CNT",DAY_30);
  1058. MON_30 = Number(MON_30_D)+Number(MON_30_C)+Number(MON_30_B)+Number(MON_30_A);
  1059. model.setValue(nodeSet1+"[30]/MON_CNT",MON_30);
  1060. //停轧时间(外部)
  1061. DAY_31 = Number(DAY_31_D)+Number(DAY_31_C)+Number(DAY_31_B)+Number(DAY_31_A);
  1062. model.setValue(nodeSet1+"[31]/DAY_CNT",DAY_31);
  1063. MON_31 = Number(MON_31_D)+Number(MON_31_C)+Number(MON_31_B)+Number(MON_31_A);
  1064. model.setValue(nodeSet1+"[31]/MON_CNT",MON_31);
  1065. //停轧时间(原成)
  1066. DAY_32 = Number(DAY_32_D)+Number(DAY_32_C)+Number(DAY_32_B)+Number(DAY_32_A);
  1067. model.setValue(nodeSet1+"[32]/DAY_CNT",DAY_32);
  1068. MON_32 = Number(MON_32_D)+Number(MON_32_C)+Number(MON_32_B)+Number(MON_32_A);
  1069. model.setValue(nodeSet1+"[32]/MON_CNT",MON_32);
  1070. //停轧时间(合计)
  1071. DAY_33 = Number(DAY_33_D)+Number(DAY_33_C)+Number(DAY_33_B)+Number(DAY_33_A);
  1072. model.setValue(nodeSet1+"[33]/DAY_CNT",DAY_33);
  1073. MON_33 = Number(MON_33_D)+Number(MON_33_C)+Number(MON_33_B)+Number(MON_33_A);
  1074. model.setValue(nodeSet1+"[33]/MON_CNT",MON_33);
  1075. model.refresh();
  1076. //日历运转率
  1077. var DAY_12 = (Number(DAY_11)-Number(DAY_28))/Number(DAY_10);
  1078. var MON_12 = (Number(MON_11)-Number(MON_28))/Number(MON_10);
  1079. model.setValue(nodeSet1+"[12]/DAY_CNT",Math.round(DAY_12*100)/100);
  1080. model.setValue(nodeSet1+"[12]/MON_CNT",Math.round(MON_12*100)/100);
  1081. //设备运转率
  1082. var DAY_13 = (Number(DAY_10)-Number(DAY_26))/Number(DAY_10);
  1083. var MON_13 = (Number(MON_10)-Number(MON_26))/Number(MON_10);
  1084. model.setValue(nodeSet1+"[13]/DAY_CNT",Math.round(DAY_13*100)/100);
  1085. model.setValue(nodeSet1+"[13]/MON_CNT",Math.round(MON_13*100)/100);
  1086. //电器运转率
  1087. var DAY_14 = (Number(DAY_10)-Number(DAY_27))/Number(DAY_10);
  1088. var MON_14 = (Number(MON_10)-Number(MON_27))/Number(MON_10);
  1089. model.setValue(nodeSet1+"[14]/DAY_CNT",Math.round(DAY_14*100)/100);
  1090. model.setValue(nodeSet1+"[14]/MON_CNT",Math.round(MON_14*100)/100);
  1091. //机时产量
  1092. var DAY_15 = (Number(DAY_2)/Number(DAY_11))*60;
  1093. var MON_15 = (Number(MON_2)/Number(MON_11))*60;
  1094. model.setValue(nodeSet1+"[15]/DAY_CNT",Math.round(DAY_15*100)/100);
  1095. model.setValue(nodeSet1+"[15]/MON_CNT",Math.round(MON_15*100)/100);
  1096. //停轧时间的总计
  1097. var DAY_33 = Number(DAY_26)+Number(DAY_27)+Number(DAY_28)+Number(DAY_29)+Number(DAY_30)+Number(DAY_31)+Number(DAY_32);
  1098. var MON_33 = Number(MON_26)+Number(MON_27)+Number(MON_28)+Number(MON_29)+Number(MON_30)+Number(MON_31)+Number(MON_32);
  1099. model.setValue(nodeSet1+"[33]/DAY_CNT",Math.round(DAY_33*100)/100);
  1100. model.setValue(nodeSet1+"[33]/MON_CNT",Math.round(MON_33*100)/100);
  1101. //求出全天重量和总重量
  1102. DAY_2 = model.getValue(nodeSet1+"[2]/DAY_WGT");
  1103. MON_2 = model.getValue(nodeSet1+"[2]/MON_WGT");
  1104. //全天的煤气耗量时间
  1105. DAY_21_JS = Number(DAY_21)/Number(DAY_2);
  1106. //全天的煤气耗量总时间
  1107. MON_21_JS = Number(MON_21)/Number(MON_2);
  1108. model.setValue(nodeSet1+"[21]/DAY_WGT",Math.round(DAY_21_JS*100)/100);
  1109. model.setValue(nodeSet1+"[21]/MON_WGT",Math.round(MON_21_JS*100)/100);
  1110. //全天的电耗量时间
  1111. DAY_22_JS = Number(DAY_22)/Number(DAY_2);
  1112. //全天的电耗量总时间
  1113. MON_22_JS = Number(MON_22)/Number(MON_2);
  1114. model.setValue(nodeSet1+"[22]/DAY_WGT",Math.round(DAY_22_JS*100)/100);
  1115. model.setValue(nodeSet1+"[22]/MON_WGT",Math.round(MON_22_JS*100)/100);
  1116. //全天的水耗量时间
  1117. DAY_23_JS = Number(DAY_23)/Number(DAY_2);
  1118. //全天的水耗量总时间
  1119. MON_23_JS = Number(MON_23)/Number(MON_2);
  1120. model.setValue(nodeSet1+"[23]/DAY_WGT",Math.round(DAY_23_JS*100)/100);
  1121. model.setValue(nodeSet1+"[23]/MON_WGT",Math.round(MON_23_JS*100)/100);
  1122. //全天的压缩空气时间
  1123. DAY_24_JS = Number(DAY_24)/Number(DAY_2);
  1124. //全天的压缩空气总时间
  1125. MON_24_JS = Number(MON_24)/Number(MON_2);
  1126. model.setValue(nodeSet1+"[24]/DAY_WGT",Math.round(DAY_24_JS*100)/100);
  1127. model.setValue(nodeSet1+"[24]/MON_WGT",Math.round(MON_24_JS*100)/100);
  1128. //全天的辊耗时间
  1129. DAY_25_JS = Number(DAY_25)/Number(DAY_2);
  1130. //全天的辊耗总时间
  1131. MON_25_JS = Number(MON_25)/Number(MON_2);
  1132. model.setValue(nodeSet1+"[25]/DAY_WGT",Math.round(DAY_25_JS*100)/100);
  1133. model.setValue(nodeSet1+"[25]/MON_WGT",Math.round(MON_25_JS*100)/100);
  1134. //有效作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
  1135. var DAY_34 = (DAY_11-DAY_28)/(DAY_10-DAY_30-DAY_29);
  1136. //总作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
  1137. var MON_34 = (MON_11-MON_28)/(MON_10-MON_30-MON_29);
  1138. model.setValue(nodeSet1+"[34]/DAY_CNT",Math.round(DAY_34*100)/100);
  1139. model.setValue(nodeSet1+"[34]/MON_CNT",Math.round(MON_34*100)/100);
  1140. model.refresh();
  1141. ]]>
  1142. </script>
  1143. </button>
  1144. <button id="button1" style="left:800px; top:5px; width:70px; height:20px; ">
  1145. <caption>导出EXCEL</caption>
  1146. <script type="javascript" ev:event="DOMActivate">
  1147. <![CDATA[
  1148. //saveExcelScript(datagrid1, "Sheet1");
  1149. if(datagrid1.rows<=2){
  1150. window.alert("无数据源,请先查询.", "提示");
  1151. return;
  1152. }
  1153. var jsonMerges="[{'name':'y','x':0,'y':0,'cnt':2},{'name':'x','x':2,'y':0,'cnt':4},{'name':'x','x':6,'y':0,'cnt':4},{'name':'x','x':10,'y':0,'cnt':4},{'name':'x','x':14,'y':0,'cnt':4},{'name':'x','x':18,'y':0,'cnt':4}]";
  1154. var _cnt = datagrid1.selectedRows;
  1155. if(_cnt <=0){
  1156. commonOutExcel('轧线统计全表',datagrid1.caption,'/root/datagrid1/ProdEdit_VO','UIH090060-service',jsonMerges,'xls');
  1157. }else{
  1158. var colRef = getVoColrefs("/root/datagrid1/ProdEdit_VO");
  1159. var refs = colRef.split("^");
  1160. var jsonDatas = "[";
  1161. var _v ="";
  1162. var _idx=0;
  1163. for(var i=0;i<_cnt;i++){
  1164. jsonDatas +="{";
  1165. _idx = parseInt(datagrid1.selectedRow(i));
  1166. _idx = _idx -1 ;
  1167. for(var j=0;j<refs.length;j++){
  1168. _v =model.getValue("/root/datagrid1/ProdEdit_VO/ProdEdit_Row["+_idx+"]/"+refs[j]);
  1169. jsonDatas +="'"+refs[j]+"':'"+_v+"',";
  1170. }
  1171. jsonDatas = jsonDatas.substring(0,jsonDatas.length-1);
  1172. jsonDatas += "},";
  1173. }
  1174. jsonDatas=jsonDatas.substring(0,jsonDatas.length-1);
  1175. jsonDatas += "]";
  1176. commonOuterExcel('轧线统计表',datagrid1.caption,colRef,jsonDatas,'UIH090060-service',jsonMerges,'xls');
  1177. }
  1178. ]]>
  1179. </script>
  1180. </button>
  1181. <select1 id="combo1" ref="/root/searchData/searchGroup" appearance="minimal" style="left:215px; top:5px; width:75px; height:20px; ">
  1182. <choices>
  1183. <item>
  1184. <label>三班</label>
  1185. <value>N</value>
  1186. </item>
  1187. <item>
  1188. <label>四班</label>
  1189. <value>Y</value>
  1190. </item>
  1191. </choices>
  1192. </select1>
  1193. <button id="button3" style="left:565px; top:5px; width:100px; height:20px; ">
  1194. <caption>button3</caption>
  1195. <script type="javascript" ev:event="onclick">
  1196. <![CDATA[
  1197. find();
  1198. ]]>
  1199. </script>
  1200. </button>
  1201. </xhtml:body>
  1202. </xhtml:html>