XinYu_RZMES/WebContents/H/H05/UIH051000.xrw

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/css" href="../../css/body.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[热轧作业>>钢卷库管理>>入/出库数据查询(UIH051000)]]>
		</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<formData>
						<enterdate/>
						<exitdate/>
						<coilNo/>
						<coilWth_MIN/>
						<coilThk_MIN/>
						<curLoadLoc/>
						<SPEC_STL_GRD/>
						<COIL_STAT>2</COIL_STAT>
						<coilWth_MAX/>
						<coilThk_MAX/>
						<shift/>
						<group/>
						<reg_id/>
						<CAR_NO/>
						<ORD_NO/>
						<ORD_SEQ/>
						<DLIV_DIRNO/>
						<CUST/>
						<DLIV_TP/>
						<COIL_DEFECTIVE/>
						<QK/>
						<ORD_FL/>
						<ORD_QK/>
						<PRODNM_CD/>
						<XSQY/>
						<SPM_TYPE/>
						<deldatefr/>
						<dedateto/>
						<ROLLFR/>
						<ROLLTO/>
					</formData>
					<reqData/>
					<resData/>
					<grid1/>
					<sumData>
						<SUM_COILRST_CNT/>
						<SUM_COILRST_WGT/>
					</sumData>
					<CUST_NM/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					var dtime = commCurDate();
					if(model.getValue("/root/formData/enterdate") == null || model.getValue("/root/formData/enterdate") == ""){
						model.setValue("/root/formData/enterdate",dtime);
					}
					if(model.getValue("/root/formData/exitdate") == null || model.getValue("/root/formData/exitdate") == ""){
						model.setValue("/root/formData/exitdate",dtime);
					}
					
					input6.refresh();input9.refresh();
					
					model.removenode("/root/reqData");
					model.makeNode("/root/reqData");
					
					commSubmit("UIH051000-service","success","glueAction.do");
					
					commAppendData("/root/CUST_NM/CUSTLIST_VO","/root/resData/CUSTLIST_VO");
					
					model.refresh();
					
				]]>
			</script>
		</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 excelExport(){
					return datagrid1;
				}
				function find(){
					
					if(commDiffDay(input6.value,input9.value)>90)
					{
						alert(" 查询时间过长，请重新选择三个月内数据查询！！ ");
					    return;
					}
					
					if(model.getValue("/root/formData/COIL_STAT") == "2"){
						commSendReq("/root/formData");
						commSubmit("UIH051000-service","findIn","glueAction.do");
						
						commAppendData("/root/grid1/UIH051000_RESULT_VO","/root/resData/UIH051000_RESULT_VO");
						
						model.setValue("/root/sumData/SUM_COILRST_CNT",model.getValue("/root/resData/SumCoil_VO/SumCoil_Row/COIL_CNT"));
						model.setValue("/root/sumData/SUM_COILRST_WGT",model.getValue("/root/resData/SumCoil_VO/SumCoil_Row/COIL_WGT"));
						
						datagrid1.refresh();	
						model.refresh();
					}else if(model.getValue("/root/formData/COIL_STAT") == "3"){
						commSendReq("/root/formData");
						commSubmit("UIH051000-service","findOut","glueAction.do");
						
						commAppendData("/root/grid1/UIH051000_RESULT_VO","/root/resData/UIH051000_RESULT_VO");
						
						model.setValue("/root/sumData/SUM_COILRST_CNT",model.getValue("/root/resData/SumCoil_VO/SumCoil_Row/COIL_CNT"));
						model.setValue("/root/sumData/SUM_COILRST_WGT",model.getValue("/root/resData/SumCoil_VO/SumCoil_Row/COIL_WGT"));
						
						datagrid1.refresh();	
						model.refresh();
					}
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body>
		<datagrid id="datagrid1" nodeset="/root/grid1/UIH051000_RESULT_VO/UIH051000_RESULT_Row" visibility="visible" caption="入库时间^缓冷时间^轧制时间^出库时间^在库时间^清库操作在库时间^操作时间^预装时间^班次^班组^操作人^轧批号^钢卷号^轧辊号^辊内顺序号^产品类型^交货期^销售区域^钢种^改判前钢种^订单规格^订单规格^成品规格^成品规格^卷重^堆放位置^综合判定等级^成份判定等级^材质判定^尺寸判定^外观判定^重量判定^二级库存^次品区分^清库前性能^清库前外观^合同号^订单号^收货单位^到站^运输方式^冶炼炉号^炼钢钢种^车辆号^运输指示号|入库时间^缓冷时间^轧制时间^出库时间^在库时间^清库操作在库时间^操作时间^预装时间^班次^班组^操作人^轧批号^钢卷号^轧辊号^辊内顺序号^产品类型^交货期^销售区域^钢种^改判前钢种^厚度^宽度^厚度^宽度^卷重^堆放位置^综合判定等级^成份判定等级^材质判定^尺寸判定^外观判定^重量判定^二级库存^次品区分^清库前性能^清库前外观^合同号^订单号^收货单位^到站^运输方式^冶炼炉号^炼钢钢种^车辆号^运输指示号" colsep="^" colwidth="80, 37, 100, 80, 60, 65, 87, 100, 84, 71, 78, 70, 90, 51, 50, 60, 87, 78, 60, 80, 34, 40, 44, 46, 60, 80, 50, 50, 50, 50, 50, 50, 63, 80, 100, 100, 50, 69, 71, 100, 50, 50, 90, 90, 100" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:95px; width:980px; height:500px; ">
			<col ref="YARD_ENTRY_DTIME"/>
			<col ref="COLDTIME"/>
			<col ref="MILL_DTIME"/>
			<col ref="TRNF_DTIME"/>
			<col ref="ZKSJ"/>
			<col ref="ZKSJ1" visibility="hidden"/>
			<col ref="CZSJ" type="input" format="yyyy-mm-dd hh:nn:ss"/>
			<col ref="YZCS_DTIME"/>
			<col disabled="true" ref="SHIFT" type="combo">
				<choices>
					<item>
						<label>早班</label>
						<value>1</value>
					</item>
					<item>
						<label>中班</label>
						<value>2</value>
					</item>
					<item>
						<label>晚班</label>
						<value>3</value>
					</item>
				</choices>
			</col>
			<col disabled="true" ref="WKGROUP" type="combo">
				<choices>
					<item>
						<label>甲班</label>
						<value>A</value>
					</item>
					<item>
						<label>乙班</label>
						<value>B</value>
					</item>
					<item>
						<label>丙班</label>
						<value>C</value>
					</item>
					<item>
						<label>丁班</label>
						<value>D</value>
					</item>
				</choices>
			</col>
			<col ref="CZR"/>
			<col ref="ZPH"/>
			<col editable="false" ref="OLD_SAMPL_NO" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="ROLL_MANA_NO" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="ROLL_SLAB_SEQ" type="input" style="background-color:#ffffff; "/>
			<col ref="PRODNM_CD"/>
			<col editable="false" ref="ORD_DEVLMT_DATE" type="input" style="background-color:#ffffff; "/>
			<col ref="XSQY"/>
			<col editable="false" ref="SPEC_STL_GRD" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="BEF_SPEC_STL_GRD" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="ORD_THK" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="ORD_WTH" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="COIL_THK" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="COIL_WTH" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="ACT_WGT" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="CUR_LOAD_LOC" type="input" style="background-color:#ffffff; "/>
			<col ref="TOT_DEC_GRD"/>
			<col ref="INGR_DEC_GRD"/>
			<col ref="MATLQLTY_DEC_GRD"/>
			<col ref="SIZE_DEC_RST"/>
			<col ref="EXTSHAPE_DEC_GRD"/>
			<col ref="WGT_DEC_RST"/>
			<col ref="QK_YN"/>
			<col ref="COIL_DEFECTIVE"/>
			<col ref="BEF_MATRL_END_CAUSE_CD"/>
			<col ref="BEF_EXTSHAPE_DEC_GRD"/>
			<col editable="false" ref="ORD_NO" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="ORD_SEQ" type="input" style="background-color:#ffffff; "/>
			<col ref="ORDCUST_CD"/>
			<col ref="DEST_PCD"/>
			<col ref="DLIV_TP"/>
			<col editable="false" ref="CHARGE_NO" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="STL_GRD" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="TRANS_CAR_NO" type="input" style="background-color:#ffffff; "/>
			<col editable="false" ref="DLIV_DIRNO" type="input" style="background-color:#ffffff; "/>
		</datagrid>
		<caption id="caption1" class="cell" style="left:820px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">垛  位</caption>
		<caption id="caption2" class="cell" style="left:0px; top:0px; width:50px; height:20px; font-weight:bold; border-color:#000000; ">时 间</caption>
		<caption id="caption3" class="cell" style="left:0px; top:25px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">钢 卷 号</caption>
		<caption id="caption4" class="cell" style="left:505px; top:0px; width:45px; height:20px; font-weight:bold; border-color:#000000; ">宽 度</caption>
		<input id="input2" ref="/root/formData/curLoadLoc" style="left:882px; top:0px; width:85px; height:20px; "/>
		<input id="input4" ref="/root/formData/coilWth_MIN" format="999999-9999999" style="left:551px; top:0px; width:49px; height:20px; "/>
		<caption id="caption5" class="cell" style="left:665px; top:0px; width:43px; height:20px; font-weight:bold; border-color:#000000; ">厚 度</caption>
		<input id="input3" ref="/root/formData/coilThk_MIN" format="999999-9999999" style="left:710px; top:0px; width:45px; height:20px; "/>
		<input id="input5" ref="/root/formData/coilNo" style="left:68px; top:25px; width:95px; height:20px; "/>
		<input id="input6" ref="/root/formData/enterdate" inputtype="date" format="yyyy-mm-dd" style="left:52px; top:0px; width:100px; height:20px; "/>
		<caption id="caption6" class="cell" style="left:365px; top:0px; width:50px; height:20px; font-weight:bold; border-color:#000000; ">牌号</caption>
		<input id="input1" ref="/root/formData/SPEC_STL_GRD" style="left:418px; top:0px; width:82px; height:20px; "/>
		<output id="output5" ref="/root/sumData/SUM_COILRST_WGT" format="#,###" style="left:362px; top:596px; width:90px; height:20px; text-align:right; background-color:#ffffff; border-color:#000000; border-style:solid; "/>
		<output id="output6" ref="/root/sumData/SUM_COILRST_CNT" format="#,###" style="left:172px; top:596px; width:90px; height:20px; text-align:right; background-color:#ffffff; border-color:#000000; border-style:solid; "/>
		<caption id="caption10" class="cell" style="left:0px; top:595px; width:85px; height:20px; text-align:center; background-color:#ffcc99; border-color:#000000; border-style:solid; ">上表统计：</caption>
		<caption id="caption11" class="cell" style="left:90px; top:596px; width:80px; height:20px; text-align:center; border-color:#000000; border-style:solid; ">钢卷总块数</caption>
		<caption id="caption12" class="cell" style="left:265px; top:596px; width:95px; height:20px; text-align:center; border-color:#000000; border-style:solid; ">钢卷总重量(吨)</caption>
		<select1 id="combo1" ref="/root/formData/COIL_STAT" appearance="minimal" style="left:255px; top:0px; width:100px; height:20px; ">
			<choices>
				<item>
					<label>入库时间查询</label>
					<value>2</value>
				</item>
				<item>
					<label>出库时间查询</label>
					<value>3</value>
				</item>
			</choices>
		</select1>
		<input id="input7" ref="/root/formData/coilWth_MAX" format="999999-9999999" style="left:605px; top:0px; width:54px; height:20px; "/>
		<line id="line2" style="x1:640px; y1:35px; x2:645px; y2:35px; "/>
		<input id="input8" ref="/root/formData/coilThk_MAX" format="999999-9999999" style="left:760px; top:0px; width:55px; height:20px; "/>
		<input id="input9" ref="/root/formData/exitdate" inputtype="date" format="yyyy-mm-dd" style="left:153px; top:0px; width:100px; height:20px; "/>
		<caption id="caption7" class="cell" style="left:170px; top:25px; width:50px; height:20px; font-weight:bold; border-color:#000000; ">班次</caption>
		<caption id="caption8" class="cell" style="left:290px; top:25px; width:50px; height:20px; font-weight:bold; border-color:#000000; ">班组</caption>
		<input id="input12" ref="/root/formData/reg_id" style="left:465px; top:25px; width:70px; height:20px; "/>
		<caption id="caption9" class="cell" style="left:410px; top:25px; width:55px; height:20px; font-weight:bold; border-color:#000000; ">作业人</caption>
		<select1 id="combo2" ref="/root/formData/shift" appearance="minimal" style="left:220px; top:25px; width:60px; height:20px; ">
			<choices>
				<item>
					<label>早班</label>
					<value>1</value>
				</item>
				<item>
					<label>中班</label>
					<value>2</value>
				</item>
				<item>
					<label>晚班</label>
					<value>3</value>
				</item>
				<item>
					<label/>
					<value/>
				</item>
			</choices>
		</select1>
		<select1 id="combo3" ref="/root/formData/group" appearance="minimal" style="left:340px; top:25px; width:60px; height:20px; ">
			<choices>
				<item>
					<label>甲班</label>
					<value>A</value>
				</item>
				<item>
					<label>乙班</label>
					<value>B</value>
				</item>
				<item>
					<label>丙班</label>
					<value>C</value>
				</item>
				<item>
					<label>丁班</label>
					<value>D</value>
				</item>
				<item>
					<label/>
					<value/>
				</item>
			</choices>
		</select1>
		<input id="input10" ref="/root/formData/CAR_NO" style="left:238px; top:50px; width:87px; height:20px; "/>
		<caption id="caption13" class="cell" style="left:190px; top:50px; width:50px; height:20px; font-weight:bold; border-color:#000000; ">车辆号</caption>
		<input id="input11" ref="/root/formData/ORD_NO" style="left:415px; top:50px; width:78px; height:20px; "/>
		<caption id="caption14" class="cell" style="left:335px; top:50px; width:80px; height:20px; font-weight:bold; border-color:#000000; ">合同-订单号</caption>
		<input id="input13" ref="/root/formData/DLIV_DIRNO" style="left:610px; top:25px; width:90px; height:20px; "/>
		<caption id="caption15" class="cell" style="left:545px; top:25px; width:69px; height:20px; font-weight:bold; border-color:#000000; ">运输指示号</caption>
		<input id="input14" ref="/root/formData/ORD_SEQ" style="left:505px; top:50px; width:31px; height:20px; "/>
		<line id="line3" style="x1:505px; y1:60px; x2:490px; y2:60px; "/>
		<select1 id="combo4" ref="/root/formData/CUST" appearance="minimal" style="left:80px; top:50px; width:100px; height:20px; ">
			<choices>
				<itemset nodeset="/root/CUST_NM/CUSTLIST_VO/CUSTLIST_Row">
					<label ref="LABEL"/>
					<value ref="VALUE"/>
				</itemset>
			</choices>
		</select1>
		<caption id="caption16" class="cell" style="left:0px; top:50px; width:80px; height:20px; font-weight:bold; border-color:#000000; ">收货单位</caption>
		<select1 id="combo5" ref="/root/formData/DLIV_TP" appearance="minimal" style="left:770px; top:25px; width:65px; height:20px; ">
			<choices>
				<item>
					<label>火运</label>
					<value>T</value>
				</item>
				<item>
					<label>汽运</label>
					<value>C</value>
				</item>
				<item>
					<label>运输链</label>
					<value>L</value>
				</item>
				<item>
					<label/>
					<value/>
				</item>
			</choices>
		</select1>
		<caption id="caption17" class="cell" style="left:710px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">运输方式</caption>
		<select1 id="combo6" ref="/root/formData/COIL_DEFECTIVE" appearance="minimal" style="left:615px; top:50px; width:85px; height:20px; ">
			<choices>
				<item>
					<label>成分不合格</label>
					<value>2A</value>
				</item>
				<item>
					<label>工序不合格</label>
					<value>2E</value>
				</item>
				<item>
					<label>尺寸不合格</label>
					<value>3B</value>
				</item>
				<item>
					<label>重量不合格</label>
					<value>3C</value>
				</item>
				<item>
					<label>外观不合格</label>
					<value>3D</value>
				</item>
				<item>
					<label>性能不合格</label>
					<value>4A</value>
				</item>
				<item>
					<label>--全部--</label>
					<value/>
				</item>
			</choices>
		</select1>
		<caption id="caption18" class="cell" style="left:545px; top:50px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">次品区分</caption>
		<select1 id="combo8" ref="/root/formData/ORD_QK" appearance="minimal" editmode="inputsearch" style="left:770px; top:50px; width:65px; height:20px; text-align:left; ">
			<choices>
				<item>
					<label>订单材</label>
					<value>1</value>
				</item>
				<item>
					<label>二级库存</label>
					<value>Y</value>
				</item>
				<item>
					<label/>
					<value/>
				</item>
			</choices>
			<script type="javascript" ev:event="xforms-value-changed">
				<![CDATA[
					//这里需要给出选择，选择订单才的时候赋值为ORD_FL.选择清库的时候赋值给QK
					var ORD_QK  = model.getValue("/root/formData/ORD_QK");
					
					if(ORD_QK == "1"){
						model.setValue("/root/formData/ORD_FL","1");
						model.setValue("/root/formData/QK","");
					}else if(ORD_QK == "Y"){
						model.setValue("/root/formData/ORD_FL","");
						model.setValue("/root/formData/QK","Y");
					}else{
						model.setValue("/root/formData/ORD_FL","");
						model.setValue("/root/formData/QK","");
					}
					model.refresh();
				]]>
			</script>
		</select1>
		<caption id="caption19" class="cell" style="left:710px; top:50px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">订单区分</caption>
		<caption id="caption20" class="cell" style="left:185px; top:72px; width:65px; height:20px; font-weight:bold; vertical-align:middle; ">产品类型</caption>
		<input id="input15" ref="/root/formData/XSQY" style="left:900px; top:25px; width:80px; height:20px; "/>
		<caption id="caption21" class="cell" style="left:840px; top:25px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">销售区域</caption>
		<caption id="caption22" class="cell" style="left:0px; top:72px; width:70px; height:20px; font-weight:bold; border-color:#000000; ">SPM类型</caption>
		<select1 id="combo11" ref="/root/formData/SPM_TYPE" appearance="minimal" editmode="inputsearch" style="left:72px; top:72px; width:100px; height:20px; text-align:left; ">
			<choices>
				<item>
					<label>平整</label>
					<value>1</value>
				</item>
				<item>
					<label>分卷</label>
					<value>2</value>
				</item>
				<item>
					<label>平整分卷</label>
					<value>3</value>
				</item>
				<item>
					<label>重卷</label>
					<value>4</value>
				</item>
				<item>
					<label>开卷检查</label>
					<value>5</value>
				</item>
				<item>
					<label/>
					<value/>
				</item>
			</choices>
		</select1>
		<input id="input16" ref="/root/formData/PRODNM_CD" inputtype="button" style="left:250px; top:72px; width:80px; height:20px; ">
			<script type="javascript" ev:event="onclick">
				<![CDATA[
						//修改订单类型，可以多选。TL 091125
						checkbox2.visible = (checkbox2.visible == false);
					]]>
			</script>
		</input>
		<select id="checkbox2" ref="/root/formData/PRODNM_CD" visibility="hidden" overflow="visible" appearance="full" style="left:250px; top:90px; width:100px; height:20px; background-color:#ffff99; border-width:1px; border-style:none; ">
			<choices>
				<item>
					<label>全部</label>
					<value/>
				</item>
				<item>
					<label>热轧卷</label>
					<value>AR</value>
				</item>
				<item>
					<label>酸轧卷</label>
					<value>CR</value>
				</item>
				<item>
					<label>连退卷</label>
					<value>LT</value>
				</item>
				<item>
					<label>分卷板</label>
					<value>FJ</value>
				</item>
				<item>
					<label>花纹卷</label>
					<value>HW</value>
				</item>
				<item>
					<label>开平板</label>
					<value>KP</value>
				</item>
				<item>
					<label>平整卷</label>
					<value>PZ</value>
				</item>
				<item>
					<label>花纹开平</label>
					<value>HK</value>
				</item>
				<item>
					<label>酸洗卷</label>
					<value>SX</value>
				</item>
			</choices>
		</select>
		<button id="button1" visibility="visible" style="left:845px; top:50px; width:100px; height:20px; ">
			<caption>button1</caption>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
				find();
				]]>
			</script>
		</button>
		<button id="button2" visibility="hidden" style="left:210px; top:205px; width:100px; height:20px; ">
			<caption>button2</caption>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
				find();
				]]>
			</script>
		</button>
		<input id="input17" ref="/root/formData/deldatefr" inputtype="date" format="yyyy-mm-dd" style="left:430px; top:75px; width:100px; height:20px; "/>
		<input id="input18" ref="/root/formData/dedateto" inputtype="date" format="yyyy-mm-dd" style="left:530px; top:75px; width:100px; height:20px; "/>
		<caption id="caption23" class="cell" style="left:350px; top:75px; width:80px; height:20px; font-weight:bold; border-color:#000000; ">交货期</caption>
		<line id="line1" style="x1:650px; y1:45px; x2:655px; y2:45px; "/>
		<caption id="caption24" class="cell" style="left:640px; top:75px; width:95px; height:20px; font-weight:bold; border-color:#000000; ">轧制单元</caption>
		<input id="input19" ref="/root/formData/ROLLFR" style="left:735px; top:75px; width:80px; height:20px; "/>
		<input id="input20" ref="/root/formData/ROLLTO" style="left:810px; top:75px; width:80px; height:20px; "/>
		<button id="button3" style="left:905px; top:70px; width:60px; height:20px; font-family:黑体; color:#3366ff; ">
			<caption>导出</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':1}]";					
					var _cnt = datagrid1.selectedRows;
					commonOutExcel('CRKCX',datagrid1.caption,'/root/grid1/UIH051000_RESULT_VO','UIH090060-service',jsonMerges,'xls');
				]]>
			</script>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
				find();
				]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>