XinYu_RZMES/WebContents/B/B04/UIB040010.xrw

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/css" href="../../css/body.css" ?>
<xhtml:html xmlns:ex="http://www.comsquare.co.kr/xforms/excel" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:my="http://www.comsquare.co.kr/example" xmlns:ms="urn:schemas-microsoft-com:xslt" 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" xmlns:cs="http://www.comsquare.co.kr/xforms">
	<xhtml:head>
		<xhtml:title>
			<![CDATA[发货处理 >> 发货处理>>质保书发行（板加）]]>
		</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<datagrid1/>
					<formData>
						<ORD_NO/>
						<ACC_TP>N</ACC_TP>
						<SDATE/>
						<EDATE/>
						<CAR_GP/>
						<SHIP_DIRNO/>
						<INV_NO/>
						<ZE_TP>Z</ZE_TP>
					</formData>
					<searchInfo>
						<CRET_NO/>
						<class>xin.glue.ui.B.BjCertBookBuilder</class>
						<template>UIB040010</template>
						<cretList/>
						<user_id/>
						<PRINT_CNT/>
					</searchInfo>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					Init();
				]]>
			</script>
		</model>
		<script type="javascript" src="../../js/boaCommon.js"/>
		<script type="javascript" src="../../js/boaMsg.js"/>
		<script type="javascript" src="../../js/mesCommon.js"/>
		<script type="javascript">
			<![CDATA[
			function Init(node)
		    {
			 	InitParams(node);
			 		
				datagrid1.fixedcellcheckbox(0,datagrid1.colRef("CHK"))=true;//进行全选操作
				datagrid1.colStatus(datagrid1.colRef("PRINT"))=false;
				datagrid1.colStatus(datagrid1.colRef("CHK"))=false;
				input1.value	=	commCurDate();
				input2.value	=	commCurDate();
				find();
	   	    }
	   	    
	   	    function find()
	   	    {
	   	    	model.removenode("/root/reqData");
				model.makeNode("/root/reqData"); 
				commSendReq("/root/formData");
				commSubmit("UIB040010-service", "find", "glueAction.do");
				model.copyNode("/root/datagrid1","/root/resData/BjQltyBook_VO");
				model.refresh();
				setColor();
	   	    }
	   	    
	   	    function  shenHe()
	   	    {
	   	    	model.removenode("/root/reqData");
	   	    	model.makeNode("/root/reqData");
	   	    	var count = 1;
	   	    	for(var i = datagrid1.fixedRows; i < datagrid1.rows; i++)
	   	    	{
	   	    		if(datagrid1.valueMatrix( i , datagrid1.colRef("CHK"))== "Y")
	   	    		{
	   	    			datagrid1.addStatus(i , "update" );
						model.makeValue("/root/reqData["+(count++)+"]/REG_NM" ,model.getValue("/root/initData/rcvInfo/REG_NM"));
	   	    		}
	   	    	}
	   	    	commMultiUpdate(datagrid1,"/root/reqData","A",true,"rowStatus");
	   	    	commSubmit("UIB040010-service", "save", "glueAction.do");
	   	    	find();
	   	    }  	    
	   	    
	   	    function open()
	   	    {
				if(datagrid1.row < datagrid1.fixedRows)
				{
					window.alert("请选择需要打开的行！", "提示");
					return;
				}
				if(datagrid1.valueMatrix(datagrid1.row , datagrid1.colRef("ACC_TP")) == "Y")
				{
					model.removenode("root/reqData");
					model.makeNode("root/reqData");
					model.makeValue("/root/searchInfo/CRET_NO",datagrid1.valueMatrix(datagrid1.row , datagrid1.colRef("CRET_NO")));
					model.makeValue("/root/searchInfo/ZE_TP" , model.getValue("/root/formData/ZE_TP"));
					commSendReq("/root/searchInfo");
					excelSubmit("UIB040010-service", "find1");
				}
	   	    }
	   	    
	   	    function excelSubmit(submitID, serviceTag) 
			{
				var reqData = setReqData(model.instances(0).selectSingleNode("/root/reqData"));
				window.load(url + "etAction.jsp?ServiceName=" + submitID + "&" + serviceTag + "=1" + reqData, "html");
			}
			
			//未审核与已审核颜色区分
			function setColor()
			{
				datagrid1.rebuildStyle();
				for(var i = datagrid1.fixedRows; i < datagrid1.rows; i++)
				{
					if(datagrid1.valueMatrix(i , datagrid1.colRef("ACC_TP")) == "Y")//已审核
					{
						datagrid1.rowstyle(i, "data", "color") = "#000000";
					}
					else if(datagrid1.valueMatrix(i , datagrid1.colRef("ACC_TP")) == "N")//未审核
					{
						datagrid1.rowstyle(i, "data", "color") = "#ff0000";
					}
				}
			}
			
	   	    function print(cretNo)
	   	    {
	   	    	var submitID     =  "UIB040010-service";
	   	    	var serviceTag   =  "find1";
	   	    	model.makeValue("/root/searchInfo/CRET_NO",cretNo);
	   	    	model.makeValue("/root/searchInfo/ZE_TP" , model.getValue("/root/formData/ZE_TP"));
	   	    	commSendReq("/root/searchInfo");
	   	    	var reqData = setReqData(model.instances(0).selectSingleNode("/root/reqData"));
	   	    	model.download(url + "etAction.jsp?ServiceName=" 
	   	    				   + submitID + "&" + serviceTag + "=1" 
	   	    				   + reqData, "C:\\WINDOWS\\excel.xls", false);
	   	    	
	   	    	try
				{
					var xlApp = new ActiveXObject("Excel.Application");     
				}
				catch(e) 
				{
					window.alert("未安装Microsoft Office Excel 2003，请安装" , "提示");
				}			   
				
				try
				{
					xlApp.Visible = false;             
					xlApp.Workbooks.Add();         
					xlApp.Workbooks.Open("C:\\WINDOWS\\excel.xls");  
					var ExcelSheet = xlApp.Worksheets(1);  
					ExcelSheet.PrintOut();  
					xlApp.Quit();   
	    			xlApp=null;  
				}
				catch(e) 
				{
					window.alert("未安装打印机，请安装" , "提示");
				}
	   	    }
	   	    ]]>
		</script>
	</xhtml:head>
	<xhtml:body overflow="hidden" pagewidth="980" pageheight="620" style="font-family:宋体; ">
		<datagrid id="datagrid1" nodeset="/root/datagrid1/BjQltyBook_Row" caption="打印^选择^已审核^已发送^质保书号^发货指示号^明细号^标准号^标准钢号^合同号^订单号^产品名称^订货单位^收货单位^车号^总重量^总数量^审核人^审核时间^发货时间^交货日期^打印次数" colsep="^" colwidth="44, 44, 44, 48, 75, 100, 100, 127, 92, 82, 40, 116, 153, 133, 66, 68, 45, 54, 100, 100, 100, 61" explorerbar="sort" frozencols="5" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="30" rowsep="|" tooltip="label" style="left:0px; top:55px; width:978px; height:560px; border-style:solid; ">
			<col ref="PRINT" type="radio"/>
			<col checkvalue="Y,N" editable="false" ref="CHK" type="checkbox"/>
			<col ref="ACC_TP" visibility="hidden"/>
			<col ref="SEND_TP" visibility="visible" style="text-align:left; "/>
			<col editable="false" ref="CRET_NO" type="input" visibility="hidden" style="text-align:left; "/>
			<col editable="false" ref="SHIP_DIRNO" type="input" style="text-align:left; "/>
			<col editable="false" ref="INV_NO" type="input" style="text-align:left; "/>
			<col editable="false" ref="SPEC_ABBSYM" type="input" style="text-align:left; "/>
			<col editable="false" ref="SPEC_STL_GRD" type="input" style="text-align:left; "/>
			<col editable="false" ref="ORD_NO" type="input" style="text-align:left; "/>
			<col editable="false" ref="ORD_SEQ" type="input" style="text-align:left; "/>
			<col editable="false" ref="ORD_USE_TP" type="input" style="text-align:left; "/>
			<col editable="false" ref="CUST_CD" type="input" style="text-align:left; "/>
			<col editable="false" ref="ORDCUST_CD" type="input" style="text-align:left; "/>
			<col ref="CAR_GP" style="text-align:left; "/>
			<col ref="SUM_WGT" style="text-align:right; "/>
			<col ref="SUM_CNT" style="text-align:right; "/>
			<col editable="false" ref="MOD_ID" type="input" style="text-align:left; "/>
			<col editable="false" ref="MOD_DTIME" format="yyyy-mm-dd hh:nn:ss" style="text-align:left; "/>
			<col ref="TRNF_DTIME" format="yyyy-mm-dd hh:nn:ss" style="text-align:left; "/>
			<col ref="ORD_DEVLMT_DATE" format="yyyy-mm-dd hh:nn:ss" style="text-align:left; "/>
			<col editable="false" ref="PRT_NM" visibility="hidden" style="text-align:left; "/>
		</datagrid>
		<caption id="caption4" class="cell" style="left:210px; top:0px; width:100px; height:20px; border-style:solid; ">合同号</caption>
		<input id="input3" ref="/root/formData/ORD_NO" style="left:310px; top:0px; width:100px; height:20px; "/>
		<caption id="caption5" class="cell" style="left:640px; top:0px; width:90px; height:20px; border-style:solid; ">审核状态</caption>
		<select1 id="combo2" ref="/root/formData/ACC_TP" appearance="minimal" style="left:730px; top:0px; width:100px; height:20px; border-style:solid; ">
			<choices>
				<item>
					<label>全部</label>
					<value/>
				</item>
				<item>
					<label>已审核</label>
					<value>Y</value>
				</item>
				<item>
					<label>未审核</label>
					<value>N</value>
				</item>
			</choices>
		</select1>
		<caption id="caption15" class="cell" style="left:210px; top:25px; width:100px; height:20px; border-style:solid; ">
			<![CDATA[质保书编制时间]]>
			<hint>
				<![CDATA[板加发送给热连轧信息时间]]>
			</hint>
		</caption>
		<input id="input2" ref="/root/formData/SDATE" inputtype="date" style="left:310px; top:25px; width:100px; height:20px; border-color:#000000; border-style:solid; "/>
		<input id="input1" ref="/root/formData/EDATE" inputtype="date" style="left:425px; top:25px; width:100px; height:20px; border-color:#000000; border-style:solid; "/>
		<caption id="caption7" class="cell" style="left:425px; top:0px; width:100px; height:20px; border-style:solid; ">车号</caption>
		<input id="input4" ref="/root/formData/CAR_GP" disabled="true" style="left:525px; top:0px; width:100px; height:20px; "/>
		<caption id="caption8" class="cell" style="left:0px; top:0px; width:90px; height:20px; border-style:solid; ">发货指示号</caption>
		<input id="input5" ref="/root/formData/SHIP_DIRNO" style="left:90px; top:0px; width:100px; height:20px; "/>
		<caption id="caption9" class="cell" style="left:0px; top:25px; width:90px; height:20px; border-style:solid; ">中英文区分</caption>
		<line id="line1" style="x1:410px; y1:35px; x2:425px; y2:35px; "/>
		<line id="line2" style="x1:0px; y1:0px; x2:975px; y2:0px; "/>
		<line id="line3" style="x1:0px; y1:50px; x2:975px; y2:50px; "/>
		<button id="button1" style="left:535px; top:25px; width:55px; height:20px; background-image:..\..\images\sw_normal01.gif; ">
			<caption>查询</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
				find();
				]]>
			</script>
		</button>
		<button id="button2" style="left:605px; top:25px; width:55px; height:20px; background-image:..\..\images\sw_normal01.gif; ">
			<caption>打开</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					open();
				]]>
			</script>
		</button>
		<button id="button3" style="left:680px; top:25px; width:55px; height:20px; background-image:..\..\images\sw_normal01.gif; ">
			<caption>审核</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					shenHe();
				]]>
			</script>
		</button>
		<button id="button4" style="left:750px; top:25px; width:55px; height:20px; background-image:..\..\images\sw_normal01.gif; ">
			<caption>打印</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
				//若无审核，不允许打印
				if(datagrid1.valueMatrix(datagrid1.row , datagrid1.colRef("ACC_TP")) != "Y")
				{
					window.alert("未选择需要打印的行！" , "提示");
					return;
				}
				 var    cretNo = datagrid1.valueMatrix(datagrid1.row , datagrid1.colRef("CRET_NO"));
				print(cretNo);
				]]>
			</script>
		</button>
		<select1 id="combo1" ref="/root/formData/ZE_TP" appearance="minimal" style="left:90px; top:25px; width:100px; height:20px; ">
			<choices>
				<item>
					<label>中文</label>
					<value>Z</value>
				</item>
				<item>
					<label>英文</label>
					<value>E</value>
				</item>
			</choices>
		</select1>
		<button id="button5" style="left:820px; top:25px; width:55px; height:20px; background-image:..\..\images\sw_normal01.gif; ">
			<caption>发送</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
				   for(var i =  1; i < datagrid1.rows; i++)
				   {
				   	 	if(datagrid1.valueMatrix(i , datagrid1.colRef("ACC_TP")) == "Y" 
				   	 	&& datagrid1.valueMatrix(i , datagrid1.colRef("CHK")) == "Y"   )
				   	 	{
							model.removenode("/root/QQData");
							model.makeValue("/root/QQData/TMPL_NM" , "UIB040010");
							model.makeValue("/root/QQData/ZE_TP"   , model.getValue("/root/formData/ZE_TP"));
							model.makeValue("/root/QQData/CRET_NO" , datagrid1.valueMatrix( i , datagrid1.colRef("CRET_NO")));
model.makeValue("/root/QQData/INV_NO" , datagrid1.valueMatrix( i , datagrid1.colRef("INV_NO")));
model.makeValue("/root/QQData/ORD_NO"  , datagrid1.valueMatrix( i , datagrid1.colRef("ORD_NO")));
model.makeValue("/root/QQData/ORD_SEQ"  ,datagrid1.valueMatrix( i , datagrid1.colRef("ORD_SEQ")) );
model.makeValue("/root/QQData/CUST_CD"  ,datagrid1.valueMatrix( i , datagrid1.colRef("CUST_CD")) );
model.makeValue("/root/QQData/ORDCUST_CD"  , datagrid1.valueMatrix( i , datagrid1.colRef("ORDCUST_CD")));
model.makeValue("/root/QQData/ORD_USE_TP"  , datagrid1.valueMatrix( i , datagrid1.colRef("ORD_USE_TP")));
model.makeValue("/root/QQData/SPEC_ABBSYM"  , datagrid1.valueMatrix( i , datagrid1.colRef("SPEC_ABBSYM")));
model.makeValue("/root/QQData/CAR_GP"  , datagrid1.valueMatrix( i , datagrid1.colRef("CAR_GP")));
model.makeValue("/root/QQData/SUM_WGT"  , datagrid1.valueMatrix( i , datagrid1.colRef("SUM_WGT")));
model.makeValue("/root/QQData/SUM_CNT"  , datagrid1.valueMatrix( i , datagrid1.colRef("SUM_CNT")));	
model.makeValue("/root/QQData/TRNF_DTIME"  , datagrid1.valueMatrix( i , datagrid1.colRef("TRNF_DTIME")));	
model.makeValue("/root/QQData/ORD_DEVLMT_DATE"  , datagrid1.valueMatrix( i , datagrid1.colRef("ORD_DEVLMT_DATE")));	

						submitID = "NIB040010-service";
						exec("/root/QQData");
				   	 }
				   }
				]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>