XinYu_RZMES/WebContents/B/B03/UIB030070.xrw

<?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[统计管理>>现况分析>>炼钢产品质量月报表]]>
		</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<formData>
						<DATE/>
						<DATE_END/>
					</formData>
					<reqData/>
					<comboData>
						<seq/>
					</comboData>
					<datagrid1/>
					<resData/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[ 
	                  
				]]>
			</script>
		</model>
		<script type="javascript" src="../../js/boaCommon.js"/>
		<script type="javascript" src="../../js/boaMsg.js"/>
		<script type="javascript" src="../../js/bCommon.js"/>
		<script type="javascript">
			<![CDATA[	
				var l="[{";
				function find_ordNo()
				{
					model.removenode("/root/reqData");
					commSendReq("/root/formData");
					commSubmit("UIB015020-service", "success", "glueAction.do");
					model.copyNode("/root/comboData/seq","/root/resData/OrdSeqResult_VO/OrdSeqResult_Row");
					model.refresh();
				}
				
				function find()
				{
					model.removenode("/root/reqData");
					model.makeValue("/root/formData/cret",model.getValue("/root/formData/cretUI")+"%");
//					commSendReq("/root/formData");
					if(input1.value.Trim() == "")
					{
						model.makeValue("/root/reqData/DATE" , "20080101");
						model.makeValue("/root/reqData/DATE_END" , "30000101");
					}
					else
					{
						commSendReq("/root/formData");
					}
					commSubmit("UIB030070-service","success","glueAction.do");
					model.copyNode("/root/datagrid1","/root/resData/ListResult_0_VO");
					model.refresh();
					
					datagrid1.rebuildStyle();
					l=l+"\"STL_GRD\":\"转炉总计\",";
					
					datagrid1.subtotal("sum", -1, datagrid1.colRef("JYL"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"JYL\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("JYL"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("HGL"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"HGL\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("HGL"))+"\",";
					datagrid1.subtotal("average", -1, datagrid1.colRef("HGL_NK"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"HGL_NK\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("HGL_NK"))+"\",";
					datagrid1.subtotal("average", -1, datagrid1.colRef("HGL_ZH"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"HGL_ZH\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("HGL_ZH"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("FP"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"FP\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("FP"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("ZHFP"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"ZHFP\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("ZHFP"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("HXCF"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"HXCF\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("HXCF"))+"\",";
				   datagrid1.subtotal("sum", -1, datagrid1.colRef("LIEWEN"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"LIEWEN\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("LIEWEN"))+"\",";   
					datagrid1.subtotal("sum", -1, datagrid1.colRef("QIKONG"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"QIKONG\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("QIKONG"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("SUOKONG"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"SUOKONG\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("SUOKONG"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("DUANCHI"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"DUANCHI\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("DUANCHI"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("AOKENG"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"AOKENG\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("AOKENG"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("SHUANGJIAO"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"SHUANGJIAO\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("SHUANGJIAO"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("FENCENG"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"FENCENG\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("FENCENG"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("GUDU"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"GUDU\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("GUDU"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("WANQI"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"WANQI\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("WANQI"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("QIPAO"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"QIPAO\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("QIPAO"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("CHONGJIE"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"CHONGJIE\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("CHONGJIE"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("CHAOCHANG"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"CHAOCHANG\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("CHAOCHANG"))+"\",";
					datagrid1.subtotal("sum", -1, datagrid1.colRef("GESHANG"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					l=l+"\"GESHANG\":\""+datagrid1.valueMatrix(2 , datagrid1.colRef("GESHANG"))+"\"},";
					//datagrid1.subtotal("sum", -1, datagrid1.colRef("LIEWEN"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					//datagrid1.subtotal("sum", -1, datagrid1.colRef("LIEWEN"), "#,###", "background-color:#99ff99", 0, "转炉总计");
					
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body pagewidth="980" pageheight="620" guideline="1,2989;2,621;">
		<datagrid id="datagrid1" nodeset="/root/datagrid1/ListResult_0_Row" allowuserresize="true" backcoloralternate="#e4ecf5" caption="产品规格及名称^检验量^合格量^合格率^合格率^废品量^废品分类^废品分类^废品分类^废品分类^废品分类^废品分类^废品分类^废品分类^废品分类^废品分类^废品分类^废品分类^废品分类^废品分类^废品分类|产品规格及名称^检验量^合格量^内控^综合^废品量^轧后废品^化学成分^裂纹^气孔^缩孔^短尺^凹坑^双浇^弯曲^气泡^重接^分层^超长^鼓胀^割伤" colsep="^" colwidth="100, 100, 100, 100, 100, 100, 90, 90, 90, 90, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100" defaultrows="30" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:35px; width:979px; height:575px; border-color:#000000; border-style:solid; ">
			<col editable="false" ref="STL_GRD" style="text-align:left; background-color:#ffffff; "/>
			<col editable="false" ref="JYL" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="HGL" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="HGL_NK" style="background-color:#ffffff; "/>
			<col editable="false" ref="HGL_ZH" style="background-color:#ffffff; "/>
			<col editable="false" ref="FP" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="ZHFP" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="HXCF" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="LIEWEN" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="QIKONG" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="SUOKONG" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="DUANCHI" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="AOKENG" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="SHUANGJIAO" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="WANQI" visibility="visible" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="QIPAO" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="CHONGJIE" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="FENCENG" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="CHAOCHANG" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="GUDU" format="#,###" style="background-color:#ffffff; "/>
			<col editable="false" ref="GESHANG" format="#,###" style="background-color:#ffffff; "/>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
					datagrid1.editCell();
				]]>
			</script>
		</datagrid>
		<line id="line2" style="x1:0px; y1:0px; x2:980px; y2:0px; "/>
		<line id="line1" style="x1:0px; y1:30px; x2:980px; y2:30px; "/>
		<caption id="caption4" class="cell" style="left:0px; top:5px; width:80px; height:20px; border-color:#000000; border-style:solid; ">日期</caption>
		<input id="input1" ref="/root/formData/DATE" inputtype="date" format="yyyy-mm-dd" style="left:80px; top:5px; width:100px; height:20px; "/>
		<button id="button1" style="left:760px; top:5px; width:100px; height:20px; background-color:#ffcc00; border-color:#0000ff; ">
			<caption>FIND</caption>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
					find();
				]]>
			</script>
		</button>
		<button id="button2" style="left:870px; top:5px; width:100px; height:20px; background-color:#ffcc00; border-color:#0000ff; ">
			<caption>导出</caption>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
					if(datagrid1.rows<=2){
						window.alert("无数据源,请先查询.", "提示");
						return;
					}	
					window.load("../../G/G10/_out.xrw", "modal", "", "left:350; top:240; width:400; height:220; sysmenu:visible; min:visible; max:true; resize:true; caption:visible;");
					var jsonMerges="[{'name':'y','x':0,'y':0,'cnt':2},{'name':'y','x':1,'y':0,'cnt':2},{'name':'y','x':2,'y':0,'cnt':2},{'name':'x','x':3,'y':0,'cnt':2},{'name':'y','x':5,'y':0,'cnt':2},{'name':'x','x':6,'y':0,'cnt':15}]";	
					var colRef = getVoColrefs("/root/datagrid1");
					var list = parseVoToStr("/root/datagrid1");//数据集
					list=list.substring(1,list.length);
					list= l+list;
					commonOuterExcel('UIB030070',datagrid1.caption,colRef,list,'UIH090060-service',jsonMerges,input_outType.value);
					//var _cnt = datagrid1.selectedRows;
					//	if(_cnt <=0){
					//		commonOuterExcel('UIB030070',datagrid1.caption,colRef,list,'UIH090060-service',jsonMerges,input_outType.value);
					//	}else{
					//		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/ListResult_0_VO/ListResult_0_Row["+_idx+"]/"+refs[j]);
					//				_v =model.getValue("/root/datagrid1/ListResult_0_Row["+datagrid1.selectedRow(i)+"]/"+refs[j]);
					//				jsonDatas +="'"+refs[j]+"':'"+_v+"',";
					//			}
					//			jsonDatas = jsonDatas.substring(0,jsonDatas.length-1);
					//			jsonDatas += "},";
					//		}
					//		jsonDatas=jsonDatas.substring(0,jsonDatas.length-1);
					//		jsonDatas += "]";
					//		commonOuterExcel('UIB030070',datagrid1.caption,colRef,jsonDatas,'UIH090060-service',jsonMerges,input_outType.value);
					//	}	
				]]>
			</script>
		</button>
		<input id="input2" ref="/root/formData/DATE_END" inputtype="date" style="left:190px; top:5px; width:100px; height:20px; "/>
		<input id="input_outType" visibility="hidden" style="left:305px; top:5px; width:100px; height:20px; "/>
		<caption id="caption1" style="left:180px; top:10px; width:25px; height:20px; ">~</caption>
	</xhtml:body>
</xhtml:html>