| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335 |
- <?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[炼钢作业 >> 板坯库管理 >> 热轧原料库出库明细查询(UIG040400)]]>
- </xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <formData>
- <SLAB_NO/>
- <STL_GRD/>
- <REG_FROM_TIME/>
- <REG_END_TIME/>
- <ROLL_MANA_NO/>
- <FROM_TIME>000000</FROM_TIME>
- <END_TIME>235959</END_TIME>
- <FROM_DATE/>
- <END_DATE/>
- <SLAB_FAC/>
- <SLAB_STOCK_TYPE/>
- <SLAB_MIN_LEN>0</SLAB_MIN_LEN>
- <SLAB_MAX_LEN>100000</SLAB_MAX_LEN>
- <SLAB_MIN_WTH>0</SLAB_MIN_WTH>
- <SLAB_MAX_WTH>100000</SLAB_MAX_WTH>
- <SLAB_STOCK_EXT_TYPE/>
- <LOWER_TIME>0</LOWER_TIME>
- <UPPER_TIME>9999999999</UPPER_TIME>
- <TEMP>0</TEMP>
- </formData>
- <grid/>
- <initResult/>
- <reqData/>
- <resData/>
- <totalData>
- <slabCnt/>
- <slabWgt/>
- </totalData>
- <initData>
- <LG_CD>D01003,D01001,G04002,G04001</LG_CD>
- </initData>
- <codeData/>
- </root>
- </instance>
- <script type="javascript" src="../../js/b01.js"/>
- <script type="javascript" src="../../js/boaCommon.js"/>
- <script type="javascript" src="../../js/G02.js"/>
- <script type="javascript" src="../../js/mesCommon.js"/>
- <script type="javascript" src="../../js/bCommon.js"/>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- initPage();
- ]]>
- </script>
- </model>
- <script type="javascript" src="../../js/b01.js"/>
- <script type="javascript" src="../../js/boaCommon.js"/>
- <script type="javascript" src="../../js/boaMsg.js"/>
- <script type="javascript" src="../../js/mesCommon.js"/>
- <script type="javascript" src="../../js/bCommon.js"/>
- <script type="javascript">
- <![CDATA[
- function excelExport(){
- return datagrid1;
- }
-
- function initPage(){
- commSendReq("/root/initData");
- commSubmit("UIGCOMMCODE-service","find","glueAction.do");
- model.copyNode("/root/codeData","/root/resData");
- commSendReq("root/reqData");
- commSubmit("UIG04COMBOX-service","stlSch","glueAction.do");//提交服务
- model.duplicate("/root/initResult","/root/resData");//复制结点
- model.refresh();
- }
- function strAppend(str,lenth){
- var strLen = str.length;
- if(strLen >= lenth)return str;
- if(strLen < lenth){
- for(var i = 0; i < (lenth - strLen); i++){
- str = str + "0";
- }
- }
- return str;
- }
- function find(){
- if(input4.value == "")
- {
- if(commDiffDay(input5.value,input6.value)>10)
- {
- window.alert("查询时间不能超过10天");
- return;
- }
- }
-
- if(model.getValue("/root/formData/END_DATE") == null || model.getValue("/root/formData/END_DATE") == "" || model.getValue("/root/formData/REG_FROM_TIME") == null || model.getValue("/root/formData/REG_FROM_TIME") == ""){
- var curDate = CurentDate();
- model.setValue("/root/formData/END_DATE",curDate);
- model.setValue("/root/formData/FROM_DATE",curDate);
- }
-
- model.setValue("/root/formData/REG_END_TIME",model.getValue("/root/formData/END_DATE") + model.getValue("/root/formData/END_TIME"));
- model.setValue("/root/formData/REG_FROM_TIME",model.getValue("/root/formData/FROM_DATE") + model.getValue("/root/formData/FROM_TIME"));
-
- commSendReq("/root/formData");
- commSubmit("UIG040400-service","find","glueAction.do");
-
- commAppendData("/root/grid/SLAB_TAKEIN_RESULT_VO","/root/resData/SLAB_TAKEIN_RESULT_VO");
-
-
- var slabCnt = 0;
- var slabWgt = 0;
- datagrid1.refresh();
- for(var i = 1 ; i < datagrid1.rows-1 ; i++){
- datagrid1.valueMatrix(i+1,datagrid1.colRef("SEQ")) = i;
- slabCnt = slabCnt + 1;
- slabWgt = slabWgt + parseFloat(datagrid1.valueMatrix(i+1,datagrid1.colRef("SLAB_WGT")));
- }
-
- model.setValue("/root/totalData/slabCnt",slabCnt);
- model.setValue("/root/totalData/slabWgt",slabWgt/1000);
- output1.refresh();
- output2.refresh();
-
- }
- ]]>
- </script>
- <script type="javascript" src="../../js/boaCommon.js"/>
- <script type="javascript" src="../../js/G02.js"/>
- </xhtml:head>
- <xhtml:body>
- <caption id="caption1" class="cell" style="left:0px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">板坯号</caption>
- <select1 id="combo1" ref="/root/formData/SLAB_STOCK_TYPE" appearance="minimal" editmode="inputsearch" style="left:489px; top:0px; width:90px; height:20px; text-align:left; ">
- <choices>
- <itemset nodeset="/root/codeData/COMM_CODE_RESULT_VO/COMM_CODE_RESULT_Row[LG_CD = 'G04001' or LG_CD = 'A']">
- <label ref="SM_CFNM"/>
- <value ref="SM_CD"/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption4" class="cell" style="left:429px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">入库类型</caption>
- <input id="input4" ref="/root/formData/SLAB_NO" style="left:60px; top:25px; width:90px; height:20px; "/>
- <datagrid id="datagrid1" nodeset="/root/grid/SLAB_TAKEIN_RESULT_VO/SLAB_TAKEIN_RESULT_Row" caption="轧辊号^轧辊序号^板坯号^钢种^厚^宽^长^重量^磅重^堆垛位置^切割时刻^出库时刻^出库时间(小时)^板坯入炉温度^出库类型^合同号^备注|轧辊号^轧辊序号^板坯号^钢种^厚^宽^长^重量^磅重^堆垛位置^切割时刻^出库时刻^出库时间(小时)^板坯入炉温度^出库类型^合同号^备注" colsep="^" colwidth="38, 70, 100, 100, 50, 50, 50, 70, 76, 100, 100, 120, 100, 100, 100, 100, 264" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:75px; width:975px; height:525px; ">
- <col disabled="false" ref="ROLL_MANA_NO" type="input"/>
- <col editable="false" ref="ROLL_SLAB_SEQ" type="input"/>
- <col editable="false" ref="SLAB_NO" type="input"/>
- <col editable="false" ref="STL_GRD" type="input"/>
- <col editable="false" ref="SLAB_THK" type="input"/>
- <col editable="false" ref="SLAB_WTH" type="input"/>
- <col editable="false" ref="SLAB_LEN" type="input"/>
- <col editable="false" ref="SLAB_WGT" type="input"/>
- <col editable="false" ref="WEIGHT_WGT" type="input"/>
- <col editable="false" ref="CUR_LOAD_LOC" type="input"/>
- <col editable="false" ref="SLAB_CUT_DTIME" type="input" format="yyyy-mm-dd hh:nn"/>
- <col editable="false" ref="SLAB_STOCK_EXT_DTIME" type="input" format="yyyy-mm-dd hh:nn"/>
- <col ref="TIMES"/>
- <col ref="CHRGING_BEF_TEMP"/>
- <col ref="SLAB_STOCK_EXT_TYPE"/>
- <col editable="false" ref="ORD_NO" type="input"/>
- <col ref="REMARKS" type="input"/>
- </datagrid>
- <caption id="caption13" class="cell" style="left:0px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">出库时间</caption>
- <line id="line4" style="x1:239px; y1:10px; x2:244px; y2:10px; "/>
- <input id="input5" ref="/root/formData/FROM_DATE" class="input" inputtype="date" format="yyyy-mm-dd" style="left:60px; top:0px; width:90px; height:20px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- if(model.getValue("/root/formData/END_DATE") == null || model.getValue("/root/formData/END_DATE") == ""||
- model.getValue("/root/formData/FROM_DATE") > model.getValue("/root/formData/END_DATE")){
- model.setValue("/root/formData/END_DATE",model.getValue("/root/formData/FROM_DATE"));
- input6.refresh();
- }
- ]]>
- </script>
- </input>
- <input id="input6" ref="/root/formData/END_DATE" class="input" inputtype="date" format="yyyy-mm-dd" style="left:244px; top:0px; width:90px; height:20px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- if(model.getValue("/root/formData/FROM_DATE") == null || model.getValue("/root/formData/FROM_DATE") == ""||
- model.getValue("/root/formData/FROM_DATE") > model.getValue("/root/formData/END_DATE")){
- model.setValue("/root/formData/FROM_DATE",model.getValue("/root/formData/END_DATE"));
- input5.refresh();
- }
- ]]>
- </script>
- </input>
- <caption id="caption10" class="cell" style="left:828px; top:0px; width:60px; height:20px; font-weight:bold; background-color:#ffcc00; border-color:#000000; ">重量合计</caption>
- <caption id="caption11" style="left:813px; top:1px; width:20px; height:20px; font-weight:bold; ">块</caption>
- <caption id="caption12" style="left:953px; top:0px; width:20px; height:20px; font-weight:bold; ">吨</caption>
- <line id="line2" style="x1:753px; y1:20px; x2:813px; y2:20px; "/>
- <line id="line3" style="x1:873px; y1:20px; x2:953px; y2:20px; "/>
- <output id="output1" ref="/root/totalData/slabCnt" style="left:773px; top:0px; width:40px; height:20px; text-align:center; "/>
- <caption id="caption9" class="cell" style="left:713px; top:0px; width:60px; height:20px; font-weight:bold; background-color:#ffcc00; border-color:#000000; ">块数合计</caption>
- <output id="output2" ref="/root/totalData/slabWgt" style="left:888px; top:0px; width:65px; height:20px; text-align:center; "/>
- <caption id="caption2" class="cell" style="left:155px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">轧 辊 号</caption>
- <input id="input1" ref="/root/formData/ROLL_MANA_NO" style="left:215px; top:25px; width:90px; height:20px; "/>
- <input id="input2" ref="/root/formData/FROM_TIME" class="input" format="hh:nn:ss" style="left:150px; top:0px; width:90px; height:20px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- if(model.getValue("/root/formData/REG_END_TIME") == null || model.getValue("/root/formData/REG_END_TIME") == ""||
- model.getValue("/root/formData/REG_FROM_TIME") > model.getValue("/root/formData/REG_END_TIME")){
- model.setValue("/root/formData/REG_END_TIME",model.getValue("/root/formData/REG_FROM_TIME"));
- input6.refresh();
- }
- ]]>
- </script>
- </input>
- <input id="input3" ref="/root/formData/END_TIME" class="input" format="hh:nn:ss" style="left:334px; top:0px; width:90px; height:20px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- if(model.getValue("/root/formData/REG_FROM_TIME") == null || model.getValue("/root/formData/REG_FROM_TIME") == ""||
- model.getValue("/root/formData/REG_FROM_TIME") > model.getValue("/root/formData/REG_END_TIME")){
- model.setValue("/root/formData/REG_FROM_TIME",model.getValue("/root/formData/REG_END_TIME"));
- input5.refresh();
- }
- ]]>
- </script>
- </input>
- <caption id="caption3" class="cell" style="left:310px; top:25px; width:32px; height:20px; font-weight:bold; border-color:#000000; ">产地</caption>
- <select1 id="combo2" ref="/root/formData/SLAB_FAC" appearance="minimal" editmode="inputsearch" style="left:342px; top:25px; width:75px; height:20px; text-align:left; ">
- <choices>
- <item>
- <label>一钢厂</label>
- <value>一钢</value>
- </item>
- <item>
- <label>二钢厂</label>
- <value>二钢</value>
- </item>
- <item>
- <label>三钢厂</label>
- <value>三钢</value>
- </item>
- <item>
- <label>全部</label>
- <value/>
- </item>
- </choices>
- </select1>
- <caption id="caption5" class="cell" style="left:584px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">出库类型</caption>
- <select1 id="combo8" ref="/root/formData/SLAB_STOCK_EXT_TYPE" appearance="minimal" style="left:644px; top:0px; width:60px; height:20px; ">
- <choices>
- <itemset nodeset="/root/codeData/COMM_CODE_RESULT_VO/COMM_CODE_RESULT_Row[LG_CD = 'G04002' or LG_CD = 'A']">
- <label ref="SM_EFNM"/>
- <value ref="SM_CD"/>
- </itemset>
- </choices>
- </select1>
- <select1 id="combo3" ref="/root/formData/SLAB_MIN_LEN" appearance="minimal" editmode="input" style="left:485px; top:25px; width:60px; height:20px; text-align:left; ">
- <choices>
- <itemset nodeset="/root/codeData/COMM_CODE_RESULT_VO/COMM_CODE_RESULT_Row[LG_CD = 'D01003']">
- <label ref="SM_CD"/>
- <value ref="SM_CD"/>
- </itemset>
- </choices>
- </select1>
- <line id="line1" style="x1:546px; y1:35px; x2:551px; y2:35px; "/>
- <caption id="caption6" class="cell" style="left:425px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">长度范围</caption>
- <select1 id="combo4" ref="/root/formData/SLAB_MAX_LEN" appearance="minimal" editmode="input" style="left:552px; top:25px; width:65px; height:20px; text-align:left; ">
- <choices>
- <itemset nodeset="/root/codeData/COMM_CODE_RESULT_VO/COMM_CODE_RESULT_Row[LG_CD = 'D01003']">
- <label ref="SM_CD"/>
- <value ref="SM_CD"/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption15" class="cell" style="left:622px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">宽度范围</caption>
- <select1 id="combo11" ref="/root/formData/SLAB_MIN_WTH" appearance="minimal" editmode="input" style="left:682px; top:25px; width:60px; height:20px; text-align:left; ">
- <choices>
- <itemset nodeset="/root/codeData/COMM_CODE_RESULT_VO/COMM_CODE_RESULT_Row[LG_CD = 'D01001']">
- <label ref="SM_CD"/>
- <value ref="SM_CD"/>
- </itemset>
- </choices>
- </select1>
- <select1 id="combo12" ref="/root/formData/SLAB_MAX_WTH" appearance="minimal" editmode="input" style="left:749px; top:25px; width:65px; height:20px; text-align:left; ">
- <choices>
- <itemset nodeset="/root/codeData/COMM_CODE_RESULT_VO/COMM_CODE_RESULT_Row[LG_CD = 'D01001']">
- <label ref="SM_CD"/>
- <value ref="SM_CD"/>
- </itemset>
- </choices>
- </select1>
- <line id="line6" style="x1:743px; y1:30px; x2:748px; y2:30px; "/>
- <select1 id="combo5" ref="/root/formData/STL_GRD" appearance="minimal" editmode="inputsearch" style="left:880px; top:25px; width:90px; height:20px; text-align:left; ">
- <choices>
- <itemset nodeset="/root/initResult/resData/STL_GRD_SELECT_VO/STL_GRD_SELECT_Row">
- <label ref="FAC_STL_GRD"/>
- <value ref="FAC_CODE"/>
- </itemset>
- </choices>
- </select1>
- <caption id="caption7" class="cell" style="left:820px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">钢 种</caption>
- <caption id="caption8" class="cell" visibility="hidden" style="left:525px; top:50px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">出库时间</caption>
- <input id="input7" ref="/root/formData/LOWER_TIME" visibility="hidden" style="left:590px; top:50px; width:70px; height:20px; "/>
- <input id="input8" ref="/root/formData/UPPER_TIME" visibility="hidden" style="left:660px; top:50px; width:75px; height:20px; "/>
- <caption id="caption14" class="cell" style="left:0px; top:50px; width:87px; height:20px; font-weight:bold; border-color:#000000; ">板坯入炉温度</caption>
- <select1 id="combo6" ref="/root/formData/TEMP" appearance="minimal" editmode="inputsearch" style="left:85px; top:50px; width:75px; height:20px; text-align:left; ">
- <choices>
- <item>
- <label>全部</label>
- <value>0</value>
- </item>
- <item>
- <label>大于等于400</label>
- <value>400</value>
- </item>
- </choices>
- </select1>
- <button id="button1" visibility="hidden" style="left:240px; top:50px; width:100px; height:20px; ">
- <caption>button1</caption>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- find();
- ]]>
- </script>
- </button>
- <button id="button7" visibility="visible" style="left:905px; top:50px; width:60px; height:20px; font-family:黑体; color:#3366ff; background-color:#ffffff; ">
- <caption>导出EXCEL</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- //saveExcelScript(datagrid1, "Sheet1");
- if(datagrid1.rows<= 0){
- window.alert("无数据源,请先查询.", "提示");
- return;
- }
-
- var jsonMerges="[{'name':'y','x':0,'y':0,'cnt':1}]";
- var _cnt = datagrid1.selectedRows;
- commonOutExcel('dataCKMX',datagrid1.caption.caption,'/root/grid/SLAB_TAKEIN_RESULT_VO','UIH090060-service',jsonMerges,'xls');
- ]]>
- </script>
- </button>
- </xhtml:body>
- </xhtml:html>
|