| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560 |
- <?xml version="1.0" encoding="UTF-8"?>
- <?xml-stylesheet href="../../css/body.css" type="text/css" ?>
- <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">
- <xhtml:head>
- <xhtml:title>
- <![CDATA[统计管理>>物料分析>>轧线统计报表(UIH090060)]]>
- </xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <reqData/>
- <resData/>
- <datagrid1/>
- <searchData>
- <searchTime/>
- <searchGroup>Y</searchGroup>
- </searchData>
- </root>
- </instance>
- </model>
- <script type="javascript" src="../../js/boaMsg.js"/>
- <script type="javascript" src="../../js/boaCommon.js"/>
- <script type="javascript" src="../../js/bCommon.js"/>
- <script type="javascript">
- <![CDATA[
- function InitParams(node) {
- if (typeof node == "undefined" && typeof node != "object") return;
- model.removenode("/root/initData/rcvInfo");
- model.makeNode("/root/initData/rcvInfo");
- var nodeList = node.childNodes;
- node = model.instances(0).selectSingleNode("/root/initData/rcvInfo");
- for (var i = 0; i < nodeList.length; i++)
- node.appendChild(nodeList.item(i));
- }
-
- function Init(node)
- {
- InitParams(node);
- }
-
- function find(){
- model.removenode("/root/reqData");
- model.makeNode("/root/reqData");
-
- model.removenode("/root/datagrid1");
- model.makeNode("/root/datagrid1");
-
- if(model.getValue("/root/searchData/searchTime") == ""){
- var cur_date;
- cur_date = commCurDate();
- model.setValue("/root/searchData/searchTime",cur_date);
- model.refresh();
- }
-
- var group = model.getValue("/root/searchData/searchGroup");
-
- if(group == "Y"){
- //为Y是四班的情况
- model.duplicate("/root/reqData","/root/searchData/searchTime");
-
- commSubmit("UIH090060-service", "find1", "glueAction.do");
-
- commAppendData("/root/datagrid1/ProdEdit_VO","/root/resData/ProdEdit_VO");
-
- model.refresh();
- }else if(group == "N"){
- //为N是三班的情况
- model.duplicate("/root/reqData","/root/searchData/searchTime");
-
- commSubmit("UIH090060-service", "find", "glueAction.do");
-
- commAppendData("/root/datagrid1/ProdEdit_VO","/root/resData/ProdEdit_VO");
-
- model.refresh();
- }
-
- //这里给出提示,特定的行可以输入
- //日历作业时间
- datagrid1.rowStyle(11, "data", "background-color") = "#ffff99";
- //轧钢时间
- datagrid1.rowStyle(12, "data", "background-color") = "#ffff99";
-
- //22
- datagrid1.rowStyle(22, "data", "background-color") = "#ffff99";
- datagrid1.rowStyle(23, "data", "background-color") = "#ffff99";
- datagrid1.rowStyle(24, "data", "background-color") = "#ffff99";
- datagrid1.rowStyle(25, "data", "background-color") = "#ffff99";
-
- datagrid1.rowStyle(26, "data", "background-color") = "#ffff99";
- datagrid1.rowStyle(27, "data", "background-color") = "#ffff99";
- datagrid1.rowStyle(28, "data", "background-color") = "#ffff99";
- datagrid1.rowStyle(29, "data", "background-color") = "#ffff99";
- datagrid1.rowStyle(30, "data", "background-color") = "#ffff99";
- datagrid1.rowStyle(31, "data", "background-color") = "#ffff99";
- datagrid1.rowStyle(32, "data", "background-color") = "#ffff99";
- datagrid1.rowStyle(33, "data", "background-color") = "#ffff99";
-
- }
-
- function saveExcelScript(sDGridName, sExcelSheetName, saveType) {
- var sExcelName = window.fileDialog( "save", "", false, "SaveFileName", "xls", "Excel Files(*.xls)|*.xls" );
- if ( sExcelName == "" ) {
- return;
- }
- //var sCSVName = "C:\\TFSmartUpdater\\" + sExcelName.lastIndexOf(".") +".csv";
- var sCSVName = sExcelName +".csv";
- //alert("sExcelName = ["+ sExcelName +"]\nsCSVName = ["+ sCSVName + "]");
- eval(sDGridName).saveText(sCSVName, "\n", ",", '\:', true); //DataGrid의 내용을 CSV파일로 생성
- ObjTFExcel.launchNewInstance(0); //Execute EXCEL
- ObjTFExcel.createWorkbook(); //Create new Workbook(for example:Sheet1,Sheet2,Sheet3) -- createWorkBook(Excel-TemplateFile)
- ObjTFExcel.loadCSV(sCSVName); //Loading Contents, from CSV to Excel
- //Setting up EXCEL Layout.
- var nRows = sDGridName.rows - sDGridName.fixedRows + 1; //Keep Careful !!!
- var nCols = sDGridName.cols;
-
- //Header
- //Line 1 : Sheet Title
- // ObjTFExcel.rowheight( 01 ) = 30 ;
- // ObjTFExcel.bold ( 01, 01, 01, nCols ) = true ;
- // ObjTFExcel.fontsize ( 01, 01, 01, nCols ) = 14 ;
- // ObjTFExcel.underline( 01, 01, 01, nCols ) = 3 ;
- // ObjTFExcel.halign ( 01, 01, 01, nCols ) ="center" ;
- // ObjTFExcel.valign ( 01, 01, 01, nCols ) ="top" ;
- // ObjTFExcel.mergeCell( 01, 01, 01, nCols ) ;
- //ObjTFExcel.colwidth ( 01 ) = 100 ;
-
- //All of the range
- ObjTFExcel.fontcolor ( 01, 01, nRows, nCols ) = "#000000" ;
- ObjTFExcel.font ( 01, 01, nRows, nCols ) = "SimSun" ;
- ObjTFExcel.setBorderColor( 01, 01, nRows, nCols, "#000000") ;
- ObjTFExcel.bold ( 01, 01, nRows, nCols ) = true ;
- ObjTFExcel.fontsize ( 01, 01, nRows, nCols ) = 12 ;
- ObjTFExcel.underline ( 01, 01, nRows, nCols ) = 0 ;
- ObjTFExcel.valign ( 01, 01, nRows, nCols ) ="middle" ;
- //字体居中
- ObjTFExcel.halign ( 01, 01, nRows, nCols ) ="center" ;
-
- ObjTFExcel.halign ( 01, 01, nRows, 02 ) ="left" ;
- //Query-Results Data
- var iRow = 1; // iRow = HeaderLine + 1;
- //这里设置字体的行宽
- // for(var i = iRow; i <= nRows; i++ ) {
- // if( (i%5) == 1 ) {
- // ObjTFExcel.rowHeight( i ) = 60;
- // ObjTFExcel.mergeCell( i, 01, i, nCols );
- // } else if( (i%5) == 0 ) {
- // ObjTFExcel.rowHeight( i ) = 45;
- // ObjTFExcel.mergeCell( i, 01, i, nCols );
- // } else {
- // ObjTFExcel.rowHeight( i ) = 40;
- // }
- // }
-
- //设置列的宽度
- ObjTFExcel.colwidth ( 01 ) = 10 ;
- ObjTFExcel.colwidth ( 02 ) = 20 ;
- ObjTFExcel.colwidth ( 03 ) = 10 ;
- ObjTFExcel.colwidth ( 04 ) = 10 ;
- ObjTFExcel.colwidth ( 05 ) = 10 ;
- ObjTFExcel.colwidth ( 06 ) = 10 ;
- ObjTFExcel.colwidth ( 07 ) = 10 ;
- ObjTFExcel.colwidth ( 08 ) = 10 ;
-
- // ObjTFExcel.setFormat(iRow, 14, nRows, 14, "yyyy\"-\"mm\"-\"dd\"\" hh\":\"mm\":\"ss\"\";@");
- ObjTFExcel.sheetName(1) = sExcelSheetName;
- ObjTFExcel.save(sExcelName); //Saving EXCEL
- ObjTFExcel.close(); //Closing EXCEL. (You must be closed EXCEL !!!)
- window.exec("EXCEL.EXE", sExcelName); //Openning EXCEL
- }
-
- function save(){
- //暂时不考虑
- model.removenode("/root/reqData");
- model.makeNode("/root/reqData");
-
- // //整个表格提交,这里需要改变行状态
- // for(var i=0;i<datagrid1.rows;i++){
- // datagrid1.rowStatus(i) = 3;
- // }
- // commMultiUpdate(datagrid1,"/root/reqData","A",true,"rowStuts1");
- //
- // //commSubmit("UIH090060-service", "save", "glueAction.do");
- //
- // model.refresh();
- }
- ]]>
- </script>
- </xhtml:head>
- <xhtml:body>
- <object id="ObjTFExcel" clsid="{fe8d1001-6a9d-424d-ae2a-301493bb12da}" style="left:335px; top:0px; width:155px; height:25px; "/>
- <caption id="caption1" class="cell" style="left:0px; top:5px; width:90px; height:20px; font-weight:bold; border-color:#000000; ">日期</caption>
- <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; "/>
- <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; ">
- <col ref="PROD_SEQ"/>
- <col ref="PROD_GUIDE"/>
- <col ref="DAY_CNT_A" type="input"/>
- <col ref="MON_CNT_A" type="input"/>
- <col ref="DAY_WGT_A"/>
- <col ref="MON_WGT_A"/>
- <col ref="DAY_CNT_B" type="input"/>
- <col ref="MON_CNT_B" type="input"/>
- <col ref="DAY_WGT_B"/>
- <col ref="MON_WGT_B" style="left:850px; top:41px; width:100px; height:21px; "/>
- <col ref="DAY_CNT_C" type="input"/>
- <col ref="MON_CNT_C" type="input"/>
- <col ref="DAY_WGT_C"/>
- <col ref="MON_WGT_C"/>
- <col ref="DAY_CNT_D" type="input"/>
- <col ref="MON_CNT_D" type="input"/>
- <col ref="DAY_WGT_D"/>
- <col ref="MON_WGT_D"/>
- <col ref="DAY_CNT" type="input"/>
- <col ref="MON_CNT" type="input"/>
- <col ref="DAY_WGT"/>
- <col ref="MON_WGT"/>
- </datagrid>
- <button id="button2" style="left:870px; top:5px; width:90px; height:20px; ">
- <caption>统计计算</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- //这里需要取出特定行列的值,并进行相应的计算
- var nodeSet1 = datagrid1.nodeset;
- //甲班的产量(吨)
- var DAY_2_A = null;
- //甲班的总产量(吨)
- var MON_2_A = null;
-
- //甲班的日历时间
- var DAY_10_A = null;
- //甲班日历总时间
- var MON_10_A = null;
-
- //甲班的轧钢时间
- var DAY_11_A = null;
- //甲班轧钢总时间
- var MON_11_A = null;
-
- //甲班的煤气耗量时间
- var DAY_21_A = null;
- //甲班的煤气耗量总时间
- var MON_21_A = null;
-
- //甲班的煤气能耗量计算 煤气/产量
- var DAY_21_A_JS = null;
- //甲班的煤气总能耗计算 总煤气/产量
- var MON_21_A_JS = null;
-
- //甲班的电耗量时间
- var DAY_22_A = null;
- //甲班的电耗量总时间
- var MON_22_A = null;
-
- //甲班的耗量计算 电/产量
- var DAY_22_A_JS = null;
- //甲班的电总耗量计算 电/产量
- var MON_22_A_JS = null;
-
- //甲班的水耗量时间
- var DAY_23_A = null;
- //甲班的水耗量总时间
- var MON_23_A = null;
-
- //甲班的水耗量计算 水/产量
- var DAY_23_A_JS = null;
- //甲班的水总耗量计算 水/产量
- var MON_23_A_JS = null;
-
- //甲班的压缩空气时间
- var DAY_24_A = null;
- //甲班的压缩空气总时间
- var MON_24_A = null;
-
- //甲班的压缩空气计算
- var DAY_24_A_JS = null;
- //甲班的压缩总空气 计算
- var MON_24_A_JS = null;
-
- //甲班的辊耗时间
- var DAY_25_A = null;
- //甲班的辊耗总时间
- var MON_25_A = null;
-
- //甲班的辊耗计算
- var DAY_25_A_JS = null;
- //甲班的辊耗总计算
- var MON_25_A_JS = null;
-
- //甲班的停轧机械时间
- var DAY_26_A = null;
- //甲班停轧机械总时间
- var MON_26_A = null;
-
- //甲班的停轧电器时间
- var DAY_27_A = null;
- //甲班停轧电器总时间
- var MON_27_A = null;
-
- //甲班的停轧轧钢时间
- var DAY_28_A = null;
- //甲班停轧轧钢总时间
- var MON_28_A = null;
-
- //甲班的停轧换辊时间
- var DAY_29_A = null;
- //甲班停轧换辊总时间
- var MON_29_A = null;
-
- //甲班的停轧检修时间
- var DAY_30_A = null;
- //甲班停轧检修总时间
- var MON_30_A = null;
-
- //甲班的停轧外部时间
- var DAY_31_A = null;
- //甲班停轧外部总时间
- var MON_31_A = null;
-
- //甲班的停轧原成时间
- var DAY_32_A = null;
- //甲班停轧原成总时间
- var MON_32_A = null;
-
- //甲班的停轧时间
- var DAY_33_A = null;
- //甲班停轧总时间
- var MON_33_A = null;
-
- for(var i=0;i<datagrid1.rows;i++){
- DAY_2_A = model.getValue(nodeSet1+"[2]/DAY_WGT_A");
- MON_2_A = model.getValue(nodeSet1+"[2]/MON_WGT_A");
-
- DAY_10_A = model.getValue(nodeSet1+"[10]/DAY_CNT_A");
- MON_10_A = model.getValue(nodeSet1+"[10]/MON_CNT_A");
- DAY_11_A = model.getValue(nodeSet1+"[11]/DAY_CNT_A");
- MON_11_A = model.getValue(nodeSet1+"[11]/MON_CNT_A");
-
- DAY_21_A = model.getValue(nodeSet1+"[21]/DAY_CNT_A");
- MON_21_A = model.getValue(nodeSet1+"[21]/MON_CNT_A");
-
- DAY_22_A = model.getValue(nodeSet1+"[22]/DAY_CNT_A");
- MON_22_A = model.getValue(nodeSet1+"[22]/MON_CNT_A");
-
- DAY_23_A = model.getValue(nodeSet1+"[23]/DAY_CNT_A");
- MON_23_A = model.getValue(nodeSet1+"[23]/MON_CNT_A");
-
- DAY_24_A = model.getValue(nodeSet1+"[24]/DAY_CNT_A");
- MON_24_A = model.getValue(nodeSet1+"[24]/MON_CNT_A");
-
- DAY_25_A = model.getValue(nodeSet1+"[25]/DAY_CNT_A");
- MON_25_A = model.getValue(nodeSet1+"[25]/MON_CNT_A");
-
- DAY_26_A = model.getValue(nodeSet1+"[26]/DAY_CNT_A");
- MON_26_A = model.getValue(nodeSet1+"[26]/MON_CNT_A");
- DAY_27_A = model.getValue(nodeSet1+"[27]/DAY_CNT_A");
- MON_27_A = model.getValue(nodeSet1+"[27]/MON_CNT_A");
- DAY_28_A = model.getValue(nodeSet1+"[28]/DAY_CNT_A");
- MON_28_A = model.getValue(nodeSet1+"[28]/MON_CNT_A");
- DAY_29_A = model.getValue(nodeSet1+"[29]/DAY_CNT_A");
- MON_29_A = model.getValue(nodeSet1+"[29]/MON_CNT_A");
-
- DAY_30_A = model.getValue(nodeSet1+"[30]/DAY_CNT_A");
- MON_30_A = model.getValue(nodeSet1+"[30]/MON_CNT_A");
-
- DAY_31_A = model.getValue(nodeSet1+"[31]/DAY_CNT_A");
- MON_31_A = model.getValue(nodeSet1+"[31]/MON_CNT_A");
-
- DAY_32_A = model.getValue(nodeSet1+"[32]/DAY_CNT_A");
- MON_32_A = model.getValue(nodeSet1+"[32]/MON_CNT_A");
- }
-
- //日历运转率
- var DAY_12_A = (Number(DAY_11_A)-Number(DAY_28_A))/Number(DAY_10_A);
-
- var MON_12_A = (Number(MON_11_A)-Number(MON_28_A))/Number(MON_10_A);
-
- model.setValue(nodeSet1+"[12]/DAY_CNT_A",Math.round(DAY_12_A*100)/100);
- model.setValue(nodeSet1+"[12]/MON_CNT_A",Math.round(MON_12_A*100)/100);
-
- //设备运转率
- var DAY_13_A = (Number(DAY_10_A)-Number(DAY_26_A))/Number(DAY_10_A);
-
- var MON_13_A = (Number(MON_10_A)-Number(MON_26_A))/Number(MON_10_A);
-
- model.setValue(nodeSet1+"[13]/DAY_CNT_A",Math.round(DAY_13_A*100)/100);
- model.setValue(nodeSet1+"[13]/MON_CNT_A",Math.round(MON_13_A*100)/100);
-
- //电器运转率
- var DAY_14_A = (Number(DAY_10_A)-Number(DAY_27_A))/Number(DAY_10_A);
-
- var MON_14_A = (Number(MON_10_A)-Number(MON_27_A))/Number(MON_10_A);
-
- model.setValue(nodeSet1+"[14]/DAY_CNT_A",Math.round(DAY_14_A*100)/100);
- model.setValue(nodeSet1+"[14]/MON_CNT_A",Math.round(MON_14_A*100)/100);
-
- //机时产量
- var DAY_15_A = (Number(DAY_2_A)/Number(DAY_11_A))*60;
-
- var MON_15_A = (Number(MON_2_A)/Number(MON_11_A))*60;
-
- model.setValue(nodeSet1+"[15]/DAY_CNT_A",Math.round(DAY_15_A*100)/100);
- model.setValue(nodeSet1+"[15]/MON_CNT_A",Math.round(MON_15_A*100)/100);
-
- //停轧时间的总计
- 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);
- 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);
-
- model.setValue(nodeSet1+"[33]/DAY_CNT_A",Math.round(DAY_33_A*100)/100);
- model.setValue(nodeSet1+"[33]/MON_CNT_A",Math.round(MON_33_A*100)/100);
-
- //甲班的煤气能耗量计算 煤气/产量
- DAY_21_A_JS = Number(DAY_21_A)/Number(DAY_2_A);
- //甲班的煤气总能耗计算 总煤气/产量
- MON_21_A_JS = Number(MON_21_A)/Number(MON_2_A);
-
- model.setValue(nodeSet1+"[21]/DAY_WGT_A",Math.round(DAY_21_A_JS*100)/100);
- model.setValue(nodeSet1+"[21]/MON_WGT_A",Math.round(MON_21_A_JS*100)/100);
-
- //甲班的电能耗量计算 电/产量
- DAY_22_A_JS = Number(DAY_22_A)/Number(DAY_2_A);
- //甲班的电总能耗计算 总电/产量
- MON_22_A_JS = Number(MON_22_A)/Number(MON_2_A);
-
- model.setValue(nodeSet1+"[22]/DAY_WGT_A",Math.round(DAY_22_A_JS*100)/100);
- model.setValue(nodeSet1+"[22]/MON_WGT_A",Math.round(MON_22_A_JS*100)/100);
-
- //甲班的水能耗量计算 水/产量
- DAY_23_A_JS = Number(DAY_23_A)/Number(DAY_2_A);
- //甲班的水总能耗计算 总水/产量
- MON_23_A_JS = Number(MON_23_A)/Number(MON_2_A);
-
- model.setValue(nodeSet1+"[23]/DAY_WGT_A",Math.round(DAY_23_A_JS*100)/100);
- model.setValue(nodeSet1+"[23]/MON_WGT_A",Math.round(MON_23_A_JS*100)/100);
-
- //甲班的空气能耗量计算 空气/产量
- DAY_24_A_JS = Number(DAY_24_A)/Number(DAY_2_A);
- //甲班的空气总能耗计算 总空气/产量
- MON_24_A_JS = Number(MON_24_A)/Number(MON_2_A);
-
- model.setValue(nodeSet1+"[24]/DAY_WGT_A",Math.round(DAY_24_A_JS*100)/100);
- model.setValue(nodeSet1+"[24]/MON_WGT_A",Math.round(MON_24_A_JS*100)/100);
-
- //甲班的辊能耗量计算 辊/产量
- DAY_25_A_JS = Number(DAY_25_A)/Number(DAY_2_A);
- //甲班的辊总能耗计算 总辊/产量
- MON_25_A_JS = Number(MON_25_A)/Number(MON_2_A);
-
- model.setValue(nodeSet1+"[25]/DAY_WGT_A",Math.round(DAY_25_A_JS*100)/100);
- model.setValue(nodeSet1+"[25]/MON_WGT_A",Math.round(MON_25_A_JS*100)/100);
-
- //甲班有效作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
- var DAY_34_A = (DAY_11_A-DAY_28_A)/(DAY_10_A-DAY_30_A-DAY_29_A);
- //甲班的总作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
- var MON_34_A = (MON_11_A-MON_28_A)/(MON_10_A-MON_30_A-MON_29_A);
-
- model.setValue(nodeSet1+"[34]/DAY_CNT_A",Math.round(DAY_34_A*100)/100);
- model.setValue(nodeSet1+"[34]/MON_CNT_A",Math.round(MON_34_A*100)/100);
- model.refresh();
-
- //////////////////////////////////////////////////////////////////////////////////
-
- //乙班的产量(吨)
- var DAY_2_B = null;
- //乙班的总产量(吨)
- var MON_2_B = null;
-
- //乙班的日历时间
- var DAY_10_B = null;
- //乙班日历总时间
- var MON_10_B = null;
-
- //乙班的轧钢时间
- var DAY_11_B = null;
- //乙班轧钢总时间
- var MON_11_B = null;
-
- //乙班的煤气耗量时间
- var DAY_21_B = null;
- //乙班的煤气耗量总时间
- var MON_21_B = null;
-
- //乙班的煤气耗量时间
- var DAY_21_B_JS = null;
- //乙班的煤气耗量总时间
- var MON_21_B_JS = null;
-
- //乙班的电耗量时间
- var DAY_22_B = null;
- //乙班的电耗量总时间
- var MON_22_B = null;
-
- //乙班的电耗量时间
- var DAY_22_B_JS = null;
- //乙班的电耗量总时间
- var MON_22_B_JS = null;
-
- //乙班的水耗量时间
- var DAY_23_B = null;
- //乙班的水耗量总时间
- var MON_23_B = null;
-
- //乙班的水耗量时间
- var DAY_23_B_JS = null;
- //乙班的水耗量总时间
- var MON_23_B_JS = null;
-
- //乙班的压缩空气时间
- var DAY_24_B = null;
- //乙班的压缩空气总时间
- var MON_24_B = null;
-
- //乙班的压缩空气时间
- var DAY_24_B_JS = null;
- //乙班的压缩空气总时间
- var MON_24_B_JS = null;
-
- //乙班的辊耗时间
- var DAY_25_B = null;
- //乙班的辊耗总时间
- var MON_25_B = null;
-
- //乙班的辊耗时间
- var DAY_25_B_JS = null;
- //乙班的辊耗总时间
- var MON_25_B_JS = null;
-
- //乙班的停轧机械时间
- var DAY_26_B = null;
- //乙班停轧机械总时间
- var MON_26_B = null;
-
- //乙班的停轧电器时间
- var DAY_27_B = null;
- //乙班停轧电器总时间
- var MON_27_B = null;
-
- //乙班的停轧轧钢时间
- var DAY_28_B = null;
- //乙班停轧轧钢总时间
- var MON_28_B = null;
-
- //乙班的停轧换辊时间
- var DAY_29_B = null;
- //乙班停轧换辊总时间
- var MON_29_B = null;
-
- //乙班的停轧检修时间
- var DAY_30_B = null;
- //乙班停轧检修总时间
- var MON_30_B = null;
-
- //乙班的停轧外部时间
- var DAY_31_B = null;
- //乙班停轧外部总时间
- var MON_31_B = null;
-
- //乙班的停轧原成时间
- var DAY_32_B = null;
- //乙班停轧原成总时间
- var MON_32_B = null;
-
- //乙班的停轧时间
- var DAY_33_B = null;
- //乙班停轧总时间
- var MON_33_B = null;
- for(var i=0;i<datagrid1.rows;i++){
- DAY_2_B = model.getValue(nodeSet1+"[2]/DAY_WGT_B");
- MON_2_B = model.getValue(nodeSet1+"[2]/MON_WGT_B");
-
- DAY_10_B = model.getValue(nodeSet1+"[10]/DAY_CNT_B");
- MON_10_B = model.getValue(nodeSet1+"[10]/MON_CNT_B");
- DAY_11_B = model.getValue(nodeSet1+"[11]/DAY_CNT_B");
- MON_11_B = model.getValue(nodeSet1+"[11]/MON_CNT_B");
-
- DAY_21_B = model.getValue(nodeSet1+"[21]/DAY_CNT_B");
- MON_21_B = model.getValue(nodeSet1+"[21]/MON_CNT_B");
-
- DAY_22_B = model.getValue(nodeSet1+"[22]/DAY_CNT_B");
- MON_22_B = model.getValue(nodeSet1+"[22]/MON_CNT_B");
-
- DAY_23_B = model.getValue(nodeSet1+"[23]/DAY_CNT_B");
- MON_23_B = model.getValue(nodeSet1+"[23]/MON_CNT_B");
-
- DAY_24_B = model.getValue(nodeSet1+"[24]/DAY_CNT_B");
- MON_24_B = model.getValue(nodeSet1+"[24]/MON_CNT_B");
-
- DAY_25_B = model.getValue(nodeSet1+"[25]/DAY_CNT_B");
- MON_25_B = model.getValue(nodeSet1+"[25]/MON_CNT_B");
-
- DAY_26_B = model.getValue(nodeSet1+"[26]/DAY_CNT_B");
- MON_26_B = model.getValue(nodeSet1+"[26]/MON_CNT_B");
- DAY_27_B = model.getValue(nodeSet1+"[27]/DAY_CNT_B");
- MON_27_B = model.getValue(nodeSet1+"[27]/MON_CNT_B");
- DAY_28_B = model.getValue(nodeSet1+"[28]/DAY_CNT_B");
- MON_28_B = model.getValue(nodeSet1+"[28]/MON_CNT_B");
- DAY_29_B = model.getValue(nodeSet1+"[29]/DAY_CNT_B");
- MON_29_B = model.getValue(nodeSet1+"[29]/MON_CNT_B");
-
- DAY_30_B = model.getValue(nodeSet1+"[30]/DAY_CNT_B");
- MON_30_B = model.getValue(nodeSet1+"[30]/MON_CNT_B");
-
- DAY_31_B = model.getValue(nodeSet1+"[31]/DAY_CNT_B");
- MON_31_B = model.getValue(nodeSet1+"[31]/MON_CNT_B");
-
- DAY_32_B = model.getValue(nodeSet1+"[32]/DAY_CNT_B");
- MON_32_B = model.getValue(nodeSet1+"[32]/MON_CNT_B");
- }
-
- //日历运转率
- var DAY_12_B = (Number(DAY_11_B)-Number(DAY_28_B))/Number(DAY_10_B);
-
- var MON_12_B = (Number(MON_11_B)-Number(MON_28_B))/Number(MON_10_B);
-
- model.setValue(nodeSet1+"[12]/DAY_CNT_B",Math.round(DAY_12_B*100)/100);
- model.setValue(nodeSet1+"[12]/MON_CNT_B",Math.round(MON_12_B*100)/100);
-
- //设备运转率
- var DAY_13_B = (Number(DAY_10_B)-Number(DAY_26_B))/Number(DAY_10_B);
-
- var MON_13_B = (Number(MON_10_B)-Number(MON_26_B))/Number(MON_10_B);
-
- model.setValue(nodeSet1+"[13]/DAY_CNT_B",Math.round(DAY_13_B*100)/100);
- model.setValue(nodeSet1+"[13]/MON_CNT_B",Math.round(MON_13_B*100)/100);
-
- //电器运转率
- var DAY_14_B = (Number(DAY_10_B)-Number(DAY_27_B))/Number(DAY_10_B);
-
- var MON_14_B = (Number(MON_10_B)-Number(MON_27_B))/Number(MON_10_B);
-
- model.setValue(nodeSet1+"[14]/DAY_CNT_B",Math.round(DAY_14_B*100)/100);
- model.setValue(nodeSet1+"[14]/MON_CNT_B",Math.round(MON_14_B*100)/100);
-
- //机时产量
- var DAY_15_B = (Number(DAY_2_B)/Number(DAY_11_B))*60;
-
- var MON_15_B = (Number(MON_2_B)/Number(MON_11_B))*60;
-
- model.setValue(nodeSet1+"[15]/DAY_CNT_B",Math.round(DAY_15_B*100)/100);
- model.setValue(nodeSet1+"[15]/MON_CNT_B",Math.round(MON_15_B*100)/100);
-
- //停轧时间的总计
- 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);
- 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);
-
- model.setValue(nodeSet1+"[33]/DAY_CNT_B",Math.round(DAY_33_B*100)/100);
- model.setValue(nodeSet1+"[33]/MON_CNT_B",Math.round(MON_33_B*100)/100);
-
- //乙班的煤气耗量时间
- DAY_21_B_JS = Number(DAY_21_B)/Number(DAY_2_B);
- //乙班的煤气耗量总时间
- MON_21_B_JS = Number(MON_21_B)/Number(MON_2_B);
-
- model.setValue(nodeSet1+"[21]/DAY_WGT_B",Math.round(DAY_21_B_JS*100)/100);
- model.setValue(nodeSet1+"[21]/MON_WGT_B",Math.round(MON_21_B_JS*100)/100);
-
- //乙班的电耗量计算
- DAY_22_B_JS = Number(DAY_22_B)/Number(DAY_2_B);
- //乙班的电耗量计算
- MON_22_B_JS = Number(MON_22_B)/Number(MON_2_B);
-
- model.setValue(nodeSet1+"[22]/DAY_WGT_B",Math.round(DAY_22_B_JS*100)/100);
- model.setValue(nodeSet1+"[22]/MON_WGT_B",Math.round(MON_22_B_JS*100)/100);
-
- //乙班的水耗量时间
- DAY_23_B_JS = Number(DAY_23_B)/Number(DAY_2_B);
- //乙班的水耗量总时间
- MON_23_B_JS = Number(MON_23_B)/Number(MON_2_B);
-
- model.setValue(nodeSet1+"[23]/DAY_WGT_B",Math.round(DAY_23_B_JS*100)/100);
- model.setValue(nodeSet1+"[23]/MON_WGT_B",Math.round(MON_23_B_JS*100)/100);
-
- //乙班的压缩空气时间
- DAY_24_B_JS = Number(DAY_24_B)/Number(DAY_2_B);
- //乙班的压缩空气总时间
- MON_24_B_JS = Number(MON_24_B)/Number(MON_2_B);
-
- model.setValue(nodeSet1+"[24]/DAY_WGT_B",Math.round(DAY_24_B_JS*100)/100);
- model.setValue(nodeSet1+"[24]/MON_WGT_B",Math.round(MON_24_B_JS*100)/100);
-
- //乙班的辊耗时间
- DAY_25_B_JS = Number(DAY_25_B)/Number(DAY_2_B);
- //乙班的辊耗总时间
- MON_25_B_JS = Number(MON_25_B)/Number(MON_2_B);
-
- model.setValue(nodeSet1+"[25]/DAY_WGT_B",Math.round(DAY_25_B_JS*100)/100);
- model.setValue(nodeSet1+"[25]/MON_WGT_B",Math.round(DAY_25_B_JS*100)/100);
-
- //乙班有效作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
- var DAY_34_B = (DAY_11_B-DAY_28_B)/(DAY_10_B-DAY_30_B-DAY_29_B);
- //乙班的总作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
- var MON_34_B = (MON_11_B-MON_28_B)/(MON_10_B-MON_30_B-MON_29_B);
-
- model.setValue(nodeSet1+"[34]/DAY_CNT_B",Math.round(DAY_34_B*100)/100);
- model.setValue(nodeSet1+"[34]/MON_CNT_B",Math.round(MON_34_B*100)/100);
- model.refresh();
-
- ////////////////////////////////////////////////////////////////////////////////
- //丙班的产量(吨)
- var DAY_2_C = null;
- //丙班的总产量(吨)
- var MON_2_C = null;
-
- //丙班的日历时间
- var DAY_10_C = null;
- //丙班日历总时间
- var MON_10_C = null;
-
- //丙班的轧钢时间
- var DAY_11_C = null;
- //丙班轧钢总时间
- var MON_11_C = null;
-
- //丙班的煤气耗量时间
- var DAY_21_C = null;
- //丙班的煤气耗量总时间
- var MON_21_C = null;
-
- //丙班的煤气耗量时间
- var DAY_21_C_JS = null;
- //丙班的煤气耗量总时间
- var MON_21_C_JS = null;
-
- //丙班的电耗量时间
- var DAY_22_C = null;
- //丙班的电耗量总时间
- var MON_22_C = null;
-
- //丙班的电耗量时间
- var DAY_22_C_JS = null;
- //丙班的电耗量总时间
- var MON_22_C_JS = null;
-
- //丙班的水耗量时间
- var DAY_23_C = null;
- //丙班的水耗量总时间
- var MON_23_C = null;
-
- //丙班的水耗量时间
- var DAY_23_C_JS = null;
- //丙班的水耗量总时间
- var MON_23_C_JS = null;
-
- //丙班的压缩空气时间
- var DAY_24_C = null;
- //丙班的压缩空气总时间
- var MON_24_C = null;
-
- //丙班的压缩空气时间
- var DAY_24_C_JS = null;
- //丙班的压缩空气总时间
- var MON_24_C_JS = null;
-
- //丙班的辊耗时间
- var DAY_25_C = null;
- //丙班的辊耗总时间
- var MON_25_C = null;
-
- //丙班的辊耗时间
- var DAY_25_C_JS = null;
- //丙班的辊耗总时间
- var MON_25_C_JS = null;
-
- //丙班的停轧机械时间
- var DAY_26_C = null;
- //丙班停轧机械总时间
- var MON_26_C = null;
-
- //丙班的停轧电器时间
- var DAY_27_C = null;
- //丙班停轧电器总时间
- var MON_27_C = null;
-
- //丙班的停轧轧钢时间
- var DAY_28_C = null;
- //丙班停轧轧钢总时间
- var MON_28_C = null;
-
- //丙班的停轧换辊时间
- var DAY_29_C = null;
- //丙班停轧换辊总时间
- var MON_29_C = null;
-
- //丙班的停轧检修时间
- var DAY_30_C = null;
- //丙班停轧检修总时间
- var MON_30_C = null;
-
- //丙班的停轧外部时间
- var DAY_31_C = null;
- //丙班停轧外部总时间
- var MON_31_C = null;
-
- //丙班的停轧原成时间
- var DAY_32_C = null;
- //丙班停轧原成总时间
- var MON_32_C = null;
-
- //丙班的停轧时间
- var DAY_33_C = null;
- //丙班停轧总时间
- var MON_33_C = null;
- for(var i=0;i<datagrid1.rows;i++){
- DAY_2_C = model.getValue(nodeSet1+"[2]/DAY_WGT_C");
- MON_2_C = model.getValue(nodeSet1+"[2]/MON_WGT_C");
-
- DAY_10_C = model.getValue(nodeSet1+"[10]/DAY_CNT_C");
- MON_10_C = model.getValue(nodeSet1+"[10]/MON_CNT_C");
- DAY_11_C = model.getValue(nodeSet1+"[11]/DAY_CNT_C");
- MON_11_C = model.getValue(nodeSet1+"[11]/MON_CNT_C");
-
- DAY_21_C = model.getValue(nodeSet1+"[21]/DAY_CNT_C");
- MON_21_C = model.getValue(nodeSet1+"[21]/MON_CNT_C");
-
- DAY_22_C = model.getValue(nodeSet1+"[22]/DAY_CNT_C");
- MON_22_C = model.getValue(nodeSet1+"[22]/MON_CNT_C");
-
- DAY_23_C = model.getValue(nodeSet1+"[23]/DAY_CNT_C");
- MON_23_C = model.getValue(nodeSet1+"[23]/MON_CNT_C");
-
- DAY_24_C = model.getValue(nodeSet1+"[24]/DAY_CNT_C");
- MON_24_C = model.getValue(nodeSet1+"[24]/MON_CNT_C");
-
- DAY_25_C = model.getValue(nodeSet1+"[25]/DAY_CNT_C");
- MON_25_C = model.getValue(nodeSet1+"[25]/MON_CNT_C");
-
- DAY_26_C = model.getValue(nodeSet1+"[26]/DAY_CNT_C");
- MON_26_C = model.getValue(nodeSet1+"[26]/MON_CNT_C");
- DAY_27_C = model.getValue(nodeSet1+"[27]/DAY_CNT_C");
- MON_27_C = model.getValue(nodeSet1+"[27]/MON_CNT_C");
- DAY_28_C = model.getValue(nodeSet1+"[28]/DAY_CNT_C");
- MON_28_C = model.getValue(nodeSet1+"[28]/MON_CNT_C");
- DAY_29_C = model.getValue(nodeSet1+"[29]/DAY_CNT_C");
- MON_29_C = model.getValue(nodeSet1+"[29]/MON_CNT_C");
-
- DAY_30_C = model.getValue(nodeSet1+"[30]/DAY_CNT_C");
- MON_30_C = model.getValue(nodeSet1+"[30]/MON_CNT_C");
-
- DAY_31_C = model.getValue(nodeSet1+"[31]/DAY_CNT_C");
- MON_31_C = model.getValue(nodeSet1+"[31]/MON_CNT_C");
-
- DAY_32_C = model.getValue(nodeSet1+"[32]/DAY_CNT_C");
- MON_32_C = model.getValue(nodeSet1+"[32]/MON_CNT_C");
- }
-
- //日历运转率
- var DAY_12_C = (Number(DAY_11_C)-Number(DAY_28_C))/Number(DAY_10_C);
-
- var MON_12_C = (Number(MON_11_C)-Number(MON_28_C))/Number(MON_10_C);
-
- model.setValue(nodeSet1+"[12]/DAY_CNT_C",Math.round(DAY_12_C*100)/100);
- model.setValue(nodeSet1+"[12]/MON_CNT_C",Math.round(MON_12_C*100)/100);
-
- //设备运转率
- var DAY_13_C = (Number(DAY_10_C)-Number(DAY_26_C))/Number(DAY_10_C);
-
- var MON_13_C = (Number(MON_10_C)-Number(MON_26_C))/Number(MON_10_C);
-
- model.setValue(nodeSet1+"[13]/DAY_CNT_C",Math.round(DAY_13_C*100)/100);
- model.setValue(nodeSet1+"[13]/MON_CNT_C",Math.round(MON_13_C*100)/100);
-
- //电器运转率
- var DAY_14_C = (Number(DAY_10_C)-Number(DAY_27_C))/Number(DAY_10_C);
-
- var MON_14_C = (Number(MON_10_C)-Number(MON_27_C))/Number(MON_10_C);
-
- model.setValue(nodeSet1+"[14]/DAY_CNT_C",Math.round(DAY_14_C*100)/100);
- model.setValue(nodeSet1+"[14]/MON_CNT_C",Math.round(MON_14_C*100)/100);
-
- //机时产量
- var DAY_15_C = (Number(DAY_2_C)/Number(DAY_11_C))*60;
-
- var MON_15_C = (Number(MON_2_C)/Number(MON_11_C))*60;
-
- model.setValue(nodeSet1+"[15]/DAY_CNT_C",Math.round(DAY_15_C*100)/100);
- model.setValue(nodeSet1+"[15]/MON_CNT_C",Math.round(MON_15_C*100)/100);
-
- //停轧时间的总计
- 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);
- 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);
-
- model.setValue(nodeSet1+"[33]/DAY_CNT_C",Math.round(DAY_33_C*100)/100);
- model.setValue(nodeSet1+"[33]/MON_CNT_C",Math.round(MON_33_C*100)/100);
-
- //丙班的煤气耗量时间
- DAY_21_C_JS = Number(DAY_21_C)/Number(DAY_2_C);
- //丙班的煤气耗量总时间
- MON_21_C_JS = Number(MON_21_C)/Number(MON_2_C);
-
- model.setValue(nodeSet1+"[21]/DAY_WGT_C",Math.round(DAY_21_C_JS*100)/100);
- model.setValue(nodeSet1+"[21]/MON_WGT_C",Math.round(MON_21_C_JS*100)/100);
-
- //丙班的电耗量时间
- DAY_22_C_JS = Number(DAY_22_C)/Number(DAY_2_C);
- //丙班的电耗量总时间
- MON_22_C_JS = Number(MON_22_C)/Number(MON_2_C);
-
- model.setValue(nodeSet1+"[22]/DAY_WGT_C",Math.round(DAY_22_C_JS*100)/100);
- model.setValue(nodeSet1+"[22]/MON_WGT_C",Math.round(MON_22_C_JS*100)/100);
-
- //丙班的水耗量时间
- DAY_23_C_JS = Number(DAY_23_C)/Number(DAY_2_C);
- //丙班的水耗量总时间
- MON_23_C_JS = Number(MON_23_C)/Number(MON_2_C);
-
- model.setValue(nodeSet1+"[23]/DAY_WGT_C",Math.round(DAY_23_C_JS*100)/100);
- model.setValue(nodeSet1+"[23]/MON_WGT_C",Math.round(MON_23_C_JS*100)/100);
-
- //丙班的压缩空气时间
- DAY_24_C_JS = Number(DAY_24_C)/Number(DAY_2_C);
- //丙班的压缩空气总时间
- MON_24_C_JS = Number(MON_24_C)/Number(MON_2_C);
-
- model.setValue(nodeSet1+"[24]/DAY_WGT_C",Math.round(DAY_24_C_JS*100)/100);
- model.setValue(nodeSet1+"[24]/MON_WGT_C",Math.round(MON_24_C_JS*100)/100);
-
- //丙班的辊耗时间
- DAY_25_C_JS = Number(DAY_25_C)/Number(DAY_2_C);
- //丙班的辊耗总时间
- MON_25_C_JS = Number(MON_25_C)/Number(MON_2_C);
-
- model.setValue(nodeSet1+"[25]/DAY_WGT_C",Math.round(DAY_25_C_JS*100)/100);
- model.setValue(nodeSet1+"[25]/MON_WGT_C",Math.round(MON_25_C_JS*100)/100);
-
- //丙班有效作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
- var DAY_34_C = (DAY_11_C-DAY_28_C)/(DAY_10_C-DAY_30_C-DAY_29_C);
- //丙班的总作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
- var MON_34_C = (MON_11_C-MON_28_C)/(MON_10_C-MON_30_C-MON_29_C);
-
- model.setValue(nodeSet1+"[34]/DAY_CNT_C",Math.round(DAY_34_C*100)/100);
- model.setValue(nodeSet1+"[34]/MON_CNT_C",Math.round(MON_34_C*100)/100);
- model.refresh();
- ////////////////////////////////////////////////////////////////////////////////
- //丁班的产量(吨)
- var DAY_2_D = null;
- //丁班的总产量(吨)
- var MON_2_D = null;
-
- //丁班的日历时间
- var DAY_10_D = null;
- //丁班日历总时间
- var MON_10_D = null;
-
- //丙班的轧钢时间
- var DAY_11_D = null;
- //丙班轧钢总时间
- var MON_11_D = null;
-
- //丙班的煤气耗量时间
- var DAY_21_D = null;
- //丙班的煤气耗量总时间
- var MON_21_D = null;
-
- //丙班的煤气耗量时间
- var DAY_21_D_JS = null;
- //丙班的煤气耗量总时间
- var MON_21_D_JS = null;
-
- //丙班的电耗量时间
- var DAY_22_D = null;
- //丙班的电耗量总时间
- var MON_22_D = null;
-
- //丙班的电耗量时间
- var DAY_22_D_JS = null;
- //丙班的电耗量总时间
- var MON_22_D_JS = null;
-
- //丙班的水耗量时间
- var DAY_23_D = null;
- //丙班的水耗量总时间
- var MON_23_D = null;
-
- //丙班的水耗量时间
- var DAY_23_D_JS = null;
- //丙班的水耗量总时间
- var MON_23_D_JS = null;
-
- //丙班的压缩空气时间
- var DAY_24_D = null;
- //丙班的压缩空气总时间
- var MON_24_D = null;
-
- //丙班的压缩空气时间
- var DAY_24_D_JS = null;
- //丙班的压缩空气总时间
- var MON_24_D_JS = null;
-
- //丙班的辊耗时间
- var DAY_25_D = null;
- //丙班的辊耗总时间
- var MON_25_D = null;
-
- //丙班的辊耗时间
- var DAY_25_D_JS = null;
- //丙班的辊耗总时间
- var MON_25_D_JS = null;
-
- //丙班的停轧机械时间
- var DAY_26_D = null;
- //丙班停轧机械总时间
- var MON_26_D = null;
-
- //丙班的停轧电器时间
- var DAY_27_D = null;
- //丙班停轧电器总时间
- var MON_27_D = null;
-
- //丙班的停轧轧钢时间
- var DAY_28_D = null;
- //丙班停轧轧钢总时间
- var MON_28_D = null;
-
- //丙班的停轧换辊时间
- var DAY_29_D = null;
- //丙班停轧换辊总时间
- var MON_29_D = null;
-
- //丙班的停轧检修时间
- var DAY_30_D = null;
- //丙班停轧检修总时间
- var MON_30_D = null;
-
- //丙班的停轧外部时间
- var DAY_31_D = null;
- //丙班停轧外部总时间
- var MON_31_D = null;
-
- //丙班的停轧原成时间
- var DAY_32_D = null;
- //丙班停轧原成总时间
- var MON_32_D = null;
-
- //丙班的停轧时间
- var DAY_33_D = null;
- //丙班停轧总时间
- var MON_33_D = null;
- for(var i=0;i<datagrid1.rows;i++){
- DAY_2_D = model.getValue(nodeSet1+"[2]/DAY_WGT_D");
- MON_2_D = model.getValue(nodeSet1+"[2]/MON_WGT_D");
-
- DAY_10_D = model.getValue(nodeSet1+"[10]/DAY_CNT_D");
- MON_10_D = model.getValue(nodeSet1+"[10]/MON_CNT_D");
- DAY_11_D = model.getValue(nodeSet1+"[11]/DAY_CNT_D");
- MON_11_D = model.getValue(nodeSet1+"[11]/MON_CNT_D");
-
- DAY_21_D = model.getValue(nodeSet1+"[21]/DAY_CNT_D");
- MON_21_D = model.getValue(nodeSet1+"[21]/MON_CNT_D");
-
- DAY_22_D = model.getValue(nodeSet1+"[22]/DAY_CNT_D");
- MON_22_D = model.getValue(nodeSet1+"[22]/MON_CNT_D");
-
- DAY_23_D = model.getValue(nodeSet1+"[23]/DAY_CNT_D");
- MON_23_D = model.getValue(nodeSet1+"[23]/MON_CNT_D");
-
- DAY_24_D = model.getValue(nodeSet1+"[24]/DAY_CNT_D");
- MON_24_D = model.getValue(nodeSet1+"[24]/MON_CNT_D");
-
- DAY_25_D = model.getValue(nodeSet1+"[25]/DAY_CNT_D");
- MON_25_D = model.getValue(nodeSet1+"[25]/MON_CNT_D");
-
- DAY_26_D = model.getValue(nodeSet1+"[26]/DAY_CNT_D");
- MON_26_D = model.getValue(nodeSet1+"[26]/MON_CNT_D");
- DAY_27_D = model.getValue(nodeSet1+"[27]/DAY_CNT_D");
- MON_27_D = model.getValue(nodeSet1+"[27]/MON_CNT_D");
- DAY_28_D = model.getValue(nodeSet1+"[28]/DAY_CNT_D");
- MON_28_D = model.getValue(nodeSet1+"[28]/MON_CNT_D");
- DAY_29_D = model.getValue(nodeSet1+"[29]/DAY_CNT_D");
- MON_29_D = model.getValue(nodeSet1+"[29]/MON_CNT_D");
-
- DAY_30_D = model.getValue(nodeSet1+"[30]/DAY_CNT_D");
- MON_30_D = model.getValue(nodeSet1+"[30]/MON_CNT_D");
-
- DAY_31_D = model.getValue(nodeSet1+"[31]/DAY_CNT_D");
- MON_31_D = model.getValue(nodeSet1+"[31]/MON_CNT_D");
-
- DAY_32_D = model.getValue(nodeSet1+"[32]/DAY_CNT_D");
- MON_32_D = model.getValue(nodeSet1+"[32]/MON_CNT_D");
- }
-
- //日历运转率
- var DAY_12_D = (Number(DAY_11_D)-Number(DAY_28_D))/Number(DAY_10_D);
-
- var MON_12_D = (Number(MON_11_D)-Number(MON_28_D))/Number(MON_10_D);
-
- model.setValue(nodeSet1+"[12]/DAY_CNT_D",Math.round(DAY_12_D*100)/100);
- model.setValue(nodeSet1+"[12]/MON_CNT_D",Math.round(MON_12_D*100)/100);
-
- //设备运转率
- var DAY_13_D = (Number(DAY_10_D)-Number(DAY_26_D))/Number(DAY_10_D);
-
- var MON_13_D = (Number(MON_10_D)-Number(MON_26_D))/Number(MON_10_D);
-
- model.setValue(nodeSet1+"[13]/DAY_CNT_D",Math.round(DAY_13_D*100)/100);
- model.setValue(nodeSet1+"[13]/MON_CNT_D",Math.round(MON_13_D*100)/100);
-
- //电器运转率
- var DAY_14_D = (Number(DAY_10_D)-Number(DAY_27_D))/Number(DAY_10_D);
-
- var MON_14_D = (Number(MON_10_D)-Number(MON_27_D))/Number(MON_10_D);
-
- model.setValue(nodeSet1+"[14]/DAY_CNT_D",Math.round(DAY_14_D*100)/100);
- model.setValue(nodeSet1+"[14]/MON_CNT_D",Math.round(MON_14_D*100)/100);
-
- //机时产量
- var DAY_15_D = (Number(DAY_2_D)/Number(DAY_11_D))*60;
-
- var MON_15_D = (Number(MON_2_D)/Number(MON_11_D))*60;
-
- model.setValue(nodeSet1+"[15]/DAY_CNT_D",Math.round(DAY_15_D*100)/100);
- model.setValue(nodeSet1+"[15]/MON_CNT_D",Math.round(MON_15_D*100)/100);
-
- //停轧时间的总计
- 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);
- 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);
-
- model.setValue(nodeSet1+"[33]/DAY_CNT_D",Math.round(DAY_33_D*100)/100);
- model.setValue(nodeSet1+"[33]/MON_CNT_D",Math.round(MON_33_D*100)/100);
-
- //丙班的煤气耗量时间
- DAY_21_D_JS = Number(DAY_21_D)/Number(DAY_2_D);
- //丙班的煤气耗量总时间
- MON_21_D_JS = Number(MON_21_D)/Number(MON_2_D);
-
- model.setValue(nodeSet1+"[21]/DAY_WGT_D",Math.round(DAY_21_D_JS*100)/100);
- model.setValue(nodeSet1+"[21]/MON_WGT_D",Math.round(MON_21_D_JS*100)/100);
-
- //丙班的电耗量时间
- DAY_22_D_JS = Number(DAY_22_D)/Number(DAY_2_D);
- //丙班的电耗量总时间
- MON_22_D_JS = Number(MON_22_D)/Number(MON_2_D);
-
- model.setValue(nodeSet1+"[22]/DAY_WGT_D",Math.round(DAY_22_D_JS*100)/100);
- model.setValue(nodeSet1+"[22]/MON_WGT_D",Math.round(MON_22_D_JS*100)/100);
-
- //丙班的水耗量时间
- DAY_23_D_JS = Number(DAY_23_D)/Number(DAY_2_D);
- //丙班的水耗量总时间
- MON_23_D_JS = Number(MON_23_D)/Number(MON_2_D);
-
- model.setValue(nodeSet1+"[23]/DAY_WGT_D",Math.round(DAY_23_D_JS*100)/100);
- model.setValue(nodeSet1+"[23]/MON_WGT_D",Math.round(MON_23_D_JS*100)/100);
-
- //丙班的压缩空气时间
- DAY_24_D_JS = Number(DAY_24_D)/Number(DAY_2_D);
- //丙班的压缩空气总时间
- MON_24_D_JS = Number(MON_24_D)/Number(MON_2_D);
-
- model.setValue(nodeSet1+"[24]/DAY_WGT_D",Math.round(DAY_24_D_JS*100)/100);
- model.setValue(nodeSet1+"[24]/MON_WGT_D",Math.round(MON_24_D_JS*100)/100);
-
- //丙班的辊耗时间
- DAY_25_D_JS = Number(DAY_25_D)/Number(DAY_2_D);
- //丙班的辊耗总时间
- MON_25_D_JS = Number(MON_25_D)/Number(MON_2_D);
-
- model.setValue(nodeSet1+"[25]/DAY_WGT_D",Math.round(DAY_25_D_JS*100)/100);
- model.setValue(nodeSet1+"[25]/MON_WGT_D",Math.round(MON_25_D_JS*100)/100);
-
- //丁班有效作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
- var DAY_34_D = (DAY_11_D-DAY_28_D)/(DAY_10_D-DAY_30_D-DAY_29_D);
- //丁班的总作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
- var MON_34_D = (MON_11_D-MON_28_D)/(MON_10_D-MON_30_D-MON_29_D);
-
- model.setValue(nodeSet1+"[34]/DAY_CNT_D",Math.round(DAY_34_D*100)/100);
- model.setValue(nodeSet1+"[34]/MON_CNT_D",Math.round(MON_34_D*100)/100);
- model.refresh();
- //////////////////////////////////////////////////////////////////////////////////////////
- //全天的产量(吨)
- var DAY_2 = null;
- //全天的总产量(吨)
- var MON_2 = null;
-
- //全天的日历时间
- var DAY_10 = null;
- //全天日历总时间
- var MON_10 = null;
-
- //全天的轧钢时间
- var DAY_11 = null;
- //全天轧钢总时间
- var MON_11 = null;
-
- //全天的煤气耗量时间
- var DAY_21 = null;
- //全天的煤气耗量总时间
- var MON_21 = null;
-
- //全天的煤气耗量时间
- var DAY_21_JS = null;
- //全天的煤气耗量总时间
- var MON_21_JS = null;
-
- //全天的电耗量时间
- var DAY_22 = null;
- //全天的电耗量总时间
- var MON_22 = null;
-
- //全天的电耗量时间
- var DAY_22_JS = null;
- //全天的电耗量总时间
- var MON_22_JS = null;
-
- //全天的水耗量时间
- var DAY_23 = null;
- //全天的水耗量总时间
- var MON_23 = null;
-
- //全天的水耗量时间
- var DAY_23_JS = null;
- //全天的水耗量总时间
- var MON_23_JS = null;
-
- //全天的压缩空气时间
- var DAY_24 = null;
- //全天的压缩空气总时间
- var MON_24 = null;
-
- //全天的压缩空气时间
- var DAY_24_JS = null;
- //全天的压缩空气总时间
- var MON_24_JS = null;
-
- //全天的辊耗时间
- var DAY_25 = null;
- //全天的辊耗总时间
- var MON_25 = null;
-
- //全天的辊耗时间
- var DAY_25_JS = null;
- //全天的辊耗总时间
- var MON_25_JS = null;
-
- //全天的停轧机械时间
- var DAY_26 = null;
- //全天停轧机械总时间
- var MON_26 = null;
-
- //全天的停轧电器时间
- var DAY_27 = null;
- //全天停轧电器总时间
- var MON_27 = null;
-
- //全天的停轧轧钢时间
- var DAY_28 = null;
- //全天停轧轧钢总时间
- var MON_28 = null;
-
- //全天的停轧换辊时间
- var DAY_29 = null;
- //全天停轧换辊总时间
- var MON_29 = null;
-
- //全天的停轧检修时间
- var DAY_30 = null;
- //全天停轧检修总时间
- var MON_30 = null;
-
- //全天的停轧外部时间
- var DAY_31 = null;
- //全天停轧外部总时间
- var MON_31 = null;
-
- //全天的停轧原成时间
- var DAY_32 = null;
- //全天停轧原成总时间
- var MON_32 = null;
-
- //全天的停轧时间
- var DAY_33 = null;
- //全天停轧总时间
- var MON_33 = null;
-
- //这里的全部数据都是3个班的总和,不能从表中取出而是要放入表中
- //日历时间、
- DAY_10 = Number(DAY_10_D)+Number(DAY_10_C)+Number(DAY_10_B)+Number(DAY_10_A);
- model.setValue(nodeSet1+"[10]/DAY_CNT",DAY_10);
-
- MON_10 = Number(MON_10_D)+Number(MON_10_C)+Number(MON_10_B)+Number(MON_10_A);
- model.setValue(nodeSet1+"[10]/MON_CNT",MON_10);
-
- //轧钢时间
- DAY_11 = Number(DAY_11_D)+Number(DAY_11_C)+Number(DAY_11_B)+Number(DAY_11_A);
- model.setValue(nodeSet1+"[11]/DAY_CNT",DAY_11);
-
- MON_11 = Number(MON_11_D)+Number(MON_11_C)+Number(MON_11_B)+Number(MON_11_A);
- model.setValue(nodeSet1+"[11]/MON_CNT",MON_11);
-
- //煤气消耗量
- DAY_21 = Number(DAY_21_D)+Number(DAY_21_C)+Number(DAY_21_B)+Number(DAY_21_A);
- model.setValue(nodeSet1+"[21]/DAY_CNT",DAY_21);
-
- MON_21 = Number(MON_21_D)+Number(MON_21_C)+Number(MON_21_B)+Number(MON_21_A);
- model.setValue(nodeSet1+"[21]/MON_CNT",MON_21);
-
- //电耗量
- DAY_22 = Number(DAY_22_D)+Number(DAY_22_C)+Number(DAY_22_B)+Number(DAY_22_A);
- model.setValue(nodeSet1+"[22]/DAY_CNT",DAY_22);
-
- MON_22 = Number(MON_22_D)+Number(MON_22_C)+Number(MON_22_B)+Number(MON_22_A);
- model.setValue(nodeSet1+"[22]/MON_CNT",MON_22);
-
- //水耗量
- DAY_23 = Number(DAY_23_D)+Number(DAY_23_C)+Number(DAY_23_B)+Number(DAY_23_A);
- model.setValue(nodeSet1+"[23]/DAY_CNT",DAY_23);
-
- MON_23 = Number(DAY_23_D)+Number(MON_23_C)+Number(MON_23_B)+Number(MON_23_A);
- model.setValue(nodeSet1+"[23]/MON_CNT",MON_23);
-
- //压缩空气
- DAY_24 = Number(DAY_24_D)+Number(DAY_24_C)+Number(DAY_24_B)+Number(DAY_24_A);
- model.setValue(nodeSet1+"[24]/DAY_CNT",DAY_24);
-
- MON_24 = Number(MON_24_D)+Number(MON_24_C)+Number(MON_24_B)+Number(MON_24_A);
- model.setValue(nodeSet1+"[24]/MON_CNT",MON_24);
-
- //辊耗
- DAY_25 = Number(DAY_25_D)+Number(DAY_25_C)+Number(DAY_25_B)+Number(DAY_25_A);
- model.setValue(nodeSet1+"[25]/DAY_CNT",DAY_25);
-
- MON_25 = Number(MON_25_D)+Number(MON_25_C)+Number(MON_25_B)+Number(MON_25_A);
- model.setValue(nodeSet1+"[25]/MON_CNT",MON_25);
-
- //停轧时间(机械)
- DAY_26 = Number(DAY_26_D)+Number(DAY_26_C)+Number(DAY_26_B)+Number(DAY_26_A);
- model.setValue(nodeSet1+"[26]/DAY_CNT",DAY_26);
-
- MON_26 = Number(MON_26_D)+Number(MON_26_C)+Number(MON_26_B)+Number(MON_26_A);
- model.setValue(nodeSet1+"[26]/MON_CNT",MON_26);
- //停轧时间(电器)
- DAY_27 = Number(DAY_27_D)+Number(DAY_27_C)+Number(DAY_27_B)+Number(DAY_27_A);
- model.setValue(nodeSet1+"[27]/DAY_CNT",DAY_27);
-
- MON_27 = Number(MON_27_D)+Number(MON_27_C)+Number(MON_27_B)+Number(MON_27_A);
- model.setValue(nodeSet1+"[27]/MON_CNT",MON_27);
- //停轧时间(轧钢)
- DAY_28 = Number(DAY_28_D)+Number(DAY_28_C)+Number(DAY_28_B)+Number(DAY_28_A);
- model.setValue(nodeSet1+"[28]/DAY_CNT",DAY_28);
-
- MON_28 = Number(MON_28_D)+Number(MON_28_C)+Number(MON_28_B)+Number(MON_28_A);
- model.setValue(nodeSet1+"[28]/MON_CNT",MON_28);
- //停轧时间(换辊)
- DAY_29 = Number(DAY_29_D)+Number(DAY_29_C)+Number(DAY_29_B)+Number(DAY_29_A);
- model.setValue(nodeSet1+"[29]/DAY_CNT",DAY_29);
-
- MON_29 = Number(MON_29_D)+Number(MON_29_C)+Number(MON_29_B)+Number(MON_29_A);
- model.setValue(nodeSet1+"[29]/MON_CNT",MON_29);
- //停轧时间(检修)
- DAY_30 = Number(DAY_30_D)+Number(DAY_30_C)+Number(DAY_30_B)+Number(DAY_30_A);
- model.setValue(nodeSet1+"[30]/DAY_CNT",DAY_30);
-
- MON_30 = Number(MON_30_D)+Number(MON_30_C)+Number(MON_30_B)+Number(MON_30_A);
- model.setValue(nodeSet1+"[30]/MON_CNT",MON_30);
- //停轧时间(外部)
- DAY_31 = Number(DAY_31_D)+Number(DAY_31_C)+Number(DAY_31_B)+Number(DAY_31_A);
- model.setValue(nodeSet1+"[31]/DAY_CNT",DAY_31);
-
- MON_31 = Number(MON_31_D)+Number(MON_31_C)+Number(MON_31_B)+Number(MON_31_A);
- model.setValue(nodeSet1+"[31]/MON_CNT",MON_31);
- //停轧时间(原成)
- DAY_32 = Number(DAY_32_D)+Number(DAY_32_C)+Number(DAY_32_B)+Number(DAY_32_A);
- model.setValue(nodeSet1+"[32]/DAY_CNT",DAY_32);
-
- MON_32 = Number(MON_32_D)+Number(MON_32_C)+Number(MON_32_B)+Number(MON_32_A);
- model.setValue(nodeSet1+"[32]/MON_CNT",MON_32);
- //停轧时间(合计)
- DAY_33 = Number(DAY_33_D)+Number(DAY_33_C)+Number(DAY_33_B)+Number(DAY_33_A);
- model.setValue(nodeSet1+"[33]/DAY_CNT",DAY_33);
-
- MON_33 = Number(MON_33_D)+Number(MON_33_C)+Number(MON_33_B)+Number(MON_33_A);
- model.setValue(nodeSet1+"[33]/MON_CNT",MON_33);
-
- model.refresh();
-
- //日历运转率
- var DAY_12 = (Number(DAY_11)-Number(DAY_28))/Number(DAY_10);
-
- var MON_12 = (Number(MON_11)-Number(MON_28))/Number(MON_10);
-
- model.setValue(nodeSet1+"[12]/DAY_CNT",Math.round(DAY_12*100)/100);
- model.setValue(nodeSet1+"[12]/MON_CNT",Math.round(MON_12*100)/100);
-
- //设备运转率
- var DAY_13 = (Number(DAY_10)-Number(DAY_26))/Number(DAY_10);
-
- var MON_13 = (Number(MON_10)-Number(MON_26))/Number(MON_10);
-
- model.setValue(nodeSet1+"[13]/DAY_CNT",Math.round(DAY_13*100)/100);
- model.setValue(nodeSet1+"[13]/MON_CNT",Math.round(MON_13*100)/100);
-
- //电器运转率
- var DAY_14 = (Number(DAY_10)-Number(DAY_27))/Number(DAY_10);
-
- var MON_14 = (Number(MON_10)-Number(MON_27))/Number(MON_10);
-
- model.setValue(nodeSet1+"[14]/DAY_CNT",Math.round(DAY_14*100)/100);
- model.setValue(nodeSet1+"[14]/MON_CNT",Math.round(MON_14*100)/100);
-
- //机时产量
- var DAY_15 = (Number(DAY_2)/Number(DAY_11))*60;
-
- var MON_15 = (Number(MON_2)/Number(MON_11))*60;
-
- model.setValue(nodeSet1+"[15]/DAY_CNT",Math.round(DAY_15*100)/100);
- model.setValue(nodeSet1+"[15]/MON_CNT",Math.round(MON_15*100)/100);
-
- //停轧时间的总计
- var DAY_33 = Number(DAY_26)+Number(DAY_27)+Number(DAY_28)+Number(DAY_29)+Number(DAY_30)+Number(DAY_31)+Number(DAY_32);
- var MON_33 = Number(MON_26)+Number(MON_27)+Number(MON_28)+Number(MON_29)+Number(MON_30)+Number(MON_31)+Number(MON_32);
-
- model.setValue(nodeSet1+"[33]/DAY_CNT",Math.round(DAY_33*100)/100);
- model.setValue(nodeSet1+"[33]/MON_CNT",Math.round(MON_33*100)/100);
-
- //求出全天重量和总重量
- DAY_2 = model.getValue(nodeSet1+"[2]/DAY_WGT");
- MON_2 = model.getValue(nodeSet1+"[2]/MON_WGT");
-
- //全天的煤气耗量时间
- DAY_21_JS = Number(DAY_21)/Number(DAY_2);
- //全天的煤气耗量总时间
- MON_21_JS = Number(MON_21)/Number(MON_2);
-
- model.setValue(nodeSet1+"[21]/DAY_WGT",Math.round(DAY_21_JS*100)/100);
- model.setValue(nodeSet1+"[21]/MON_WGT",Math.round(MON_21_JS*100)/100);
-
- //全天的电耗量时间
- DAY_22_JS = Number(DAY_22)/Number(DAY_2);
- //全天的电耗量总时间
- MON_22_JS = Number(MON_22)/Number(MON_2);
-
- model.setValue(nodeSet1+"[22]/DAY_WGT",Math.round(DAY_22_JS*100)/100);
- model.setValue(nodeSet1+"[22]/MON_WGT",Math.round(MON_22_JS*100)/100);
-
- //全天的水耗量时间
- DAY_23_JS = Number(DAY_23)/Number(DAY_2);
- //全天的水耗量总时间
- MON_23_JS = Number(MON_23)/Number(MON_2);
-
- model.setValue(nodeSet1+"[23]/DAY_WGT",Math.round(DAY_23_JS*100)/100);
- model.setValue(nodeSet1+"[23]/MON_WGT",Math.round(MON_23_JS*100)/100);
-
- //全天的压缩空气时间
- DAY_24_JS = Number(DAY_24)/Number(DAY_2);
- //全天的压缩空气总时间
- MON_24_JS = Number(MON_24)/Number(MON_2);
-
- model.setValue(nodeSet1+"[24]/DAY_WGT",Math.round(DAY_24_JS*100)/100);
- model.setValue(nodeSet1+"[24]/MON_WGT",Math.round(MON_24_JS*100)/100);
-
- //全天的辊耗时间
- DAY_25_JS = Number(DAY_25)/Number(DAY_2);
- //全天的辊耗总时间
- MON_25_JS = Number(MON_25)/Number(MON_2);
-
- model.setValue(nodeSet1+"[25]/DAY_WGT",Math.round(DAY_25_JS*100)/100);
- model.setValue(nodeSet1+"[25]/MON_WGT",Math.round(MON_25_JS*100)/100);
-
- //有效作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
- var DAY_34 = (DAY_11-DAY_28)/(DAY_10-DAY_30-DAY_29);
- //总作业率 公式为(轧钢时间-轧钢故障时间)/(日历时间-检修时间-换辊时间)
- var MON_34 = (MON_11-MON_28)/(MON_10-MON_30-MON_29);
-
- model.setValue(nodeSet1+"[34]/DAY_CNT",Math.round(DAY_34*100)/100);
- model.setValue(nodeSet1+"[34]/MON_CNT",Math.round(MON_34*100)/100);
- model.refresh();
- ]]>
- </script>
- </button>
- <button id="button1" style="left:800px; top:5px; width:70px; height:20px; ">
- <caption>导出EXCEL</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- //saveExcelScript(datagrid1, "Sheet1");
- if(datagrid1.rows<=2){
- window.alert("无数据源,请先查询.", "提示");
- return;
- }
- 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}]";
- var _cnt = datagrid1.selectedRows;
- if(_cnt <=0){
- commonOutExcel('轧线统计全表',datagrid1.caption,'/root/datagrid1/ProdEdit_VO','UIH090060-service',jsonMerges,'xls');
- }else{
- var colRef = getVoColrefs("/root/datagrid1/ProdEdit_VO");
- var refs = colRef.split("^");
- var jsonDatas = "[";
- var _v ="";
- var _idx=0;
- for(var i=0;i<_cnt;i++){
- jsonDatas +="{";
- _idx = parseInt(datagrid1.selectedRow(i));
- _idx = _idx -1 ;
- for(var j=0;j<refs.length;j++){
- _v =model.getValue("/root/datagrid1/ProdEdit_VO/ProdEdit_Row["+_idx+"]/"+refs[j]);
- jsonDatas +="'"+refs[j]+"':'"+_v+"',";
- }
- jsonDatas = jsonDatas.substring(0,jsonDatas.length-1);
- jsonDatas += "},";
- }
- jsonDatas=jsonDatas.substring(0,jsonDatas.length-1);
- jsonDatas += "]";
- commonOuterExcel('轧线统计表',datagrid1.caption,colRef,jsonDatas,'UIH090060-service',jsonMerges,'xls');
- }
- ]]>
- </script>
- </button>
- <select1 id="combo1" ref="/root/searchData/searchGroup" appearance="minimal" style="left:215px; top:5px; width:75px; height:20px; ">
- <choices>
- <item>
- <label>三班</label>
- <value>N</value>
- </item>
- <item>
- <label>四班</label>
- <value>Y</value>
- </item>
- </choices>
- </select1>
- <button id="button3" style="left:565px; top:5px; width:100px; height:20px; ">
- <caption>button3</caption>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- find();
- ]]>
- </script>
- </button>
- </xhtml:body>
- </xhtml:html>
|