XinYu_RZMES/.svn/pristine/35/357310e54a2efa32aad18088bf67771616f6f5ba.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/css" href="../../css/body.css" ?>
<?xml-stylesheet type="text/css" href="../css/bCommon.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>
						<STDATE/>
						<ENDDATE/>
					</formData>
					<reqData/>
					<resData/>
					<datagrid1/>
					<comboData>
						<Charge/>
						<StlGrd/>
					</comboData>
					<headLine>
						<SlabResult_VO>
							<SlabResult_Row>
								<ROWNUM>热连轧厂生产检验班报表</ROWNUM>
								<SLAB_NO/>
								<SLAB_THK/>
								<SLAB_WTH/>
								<SLAB_LEN/>
								<SLAB_WGT/>
								<STL_GRD/>
								<CRK_CD1/>
								<EXTSHAPE_DEC_DTIME/>
								<EXTSHAPE_DEC_EMP_ID/>
								<GR_SHIFT/>
								<GR_GROUP/>
							</SlabResult_Row>
							<SlabResult_Row>
								<ROWNUM>日期</ROWNUM>
								<SLAB_NO/>
								<SLAB_THK/>
								<SLAB_WTH/>
								<SLAB_LEN/>
								<SLAB_WGT/>
								<STL_GRD/>
								<CRK_CD1/>
								<EXTSHAPE_DEC_DTIME/>
								<EXTSHAPE_DEC_EMP_ID/>
								<GR_SHIFT/>
								<GR_GROUP>班组 &amp; 班次</GR_GROUP>
							</SlabResult_Row>
						</SlabResult_VO>
					</headLine>
					<subTitle>
						<SlabResult_VO>
							<SlabResult_Row>
								<ROWNUM>序号</ROWNUM>
								<SLAB_NO>板坯号</SLAB_NO>
								<SLAB_THK>厚度</SLAB_THK>
								<SLAB_WTH>宽度</SLAB_WTH>
								<SLAB_LEN>长度</SLAB_LEN>
								<SLAB_WGT>重量（吨）</SLAB_WGT>
								<STL_GRD>钢号</STL_GRD>
								<CRK_CD1>不合格类别</CRK_CD1>
								<EXTSHAPE_DEC_DTIME>板坯判定日</EXTSHAPE_DEC_DTIME>
								<EXTSHAPE_DEC_EMP_ID>板坯判定人</EXTSHAPE_DEC_EMP_ID>
								<GR_SHIFT>检验班次</GR_SHIFT>
								<GR_GROUP>检验班组</GR_GROUP>
							</SlabResult_Row>
						</SlabResult_VO>
					</subTitle>
					<CNT>
						<YL/>
						<JY/>
						<FY/>
						<HG/>
						<PZ/>
						<FJ/>
					</CNT>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
				 	if(window.parent==null) Init();
				]]>
			</script>
		</model>
		<script type="javascript" src="../../js/boaCommon.js"/>
		<script type="javascript" src="../../js/b01.js"/>
		<script type="javascript">
			<![CDATA[
				function Init(node)
				{
					
					
					input1.value	=	commCurDate();
					input2.value	=	commCurDate();
					/*model.removenode("/root/reqData");
					model.makeNode("/root/reqData");
					commSubmit("UIB020310-service", "findC", "glueAction.do");
					model.copyNode("/root/comboData/Charge","/root/resData/ChargeResult_VO");
					model.copyNode("/root/comboData/StlGrd","/root/resData/StlGrdResult_VO");
					model.makeValue("/root/formData/StDate",model.getValue("/root/resData/DateResult_VO/DateResult_Row/F_DATE"));
					model.makeValue("/root/formData/EndDate",model.getValue("/root/resData/DateResult_VO/DateResult_Row/T_DATE"));
					model.refresh();*/
					
				}
				
				function find()
				{
					model.removenode("/root/reqData");
					model.makeNode("/root/reqData");
					commSendReq("/root/formData");	
					commSubmit("UIB030040-service", "success", "glueAction.do");
					model.copyNode("/root/datagrid1" , "/root/resData/ListResult_0_VO");
					model.refresh();
					add();
				}
				
				function add()
				{
					var YL = 0;
					var JY = 0;
					var FY = 0;
					var HG = 0;
					var PZ = 0;
					var FJ = 0;
					for(var i = 2;i<datagrid1.rows;i++)
					{
						YL = YL + parseInt(datagrid1.valueMatrix(i,datagrid1.colRef("SLAB_WGT"))== null?0:datagrid1.valueMatrix(i,datagrid1.colRef("SLAB_WGT"))*1000);	
						JY = JY + parseInt(datagrid1.valueMatrix(i,datagrid1.colRef("JYL"))== null?0:datagrid1.valueMatrix(i,datagrid1.colRef("JYL"))*1000);
						FY = FY + parseInt(datagrid1.valueMatrix(i,datagrid1.colRef("FYL"))== null?0:datagrid1.valueMatrix(i,datagrid1.colRef("FYL"))*1000);
						HG = HG + parseInt(datagrid1.valueMatrix(i,datagrid1.colRef("HGL"))== null?0:datagrid1.valueMatrix(i,datagrid1.colRef("HGL"))*1000);
						PZ = PZ + parseInt(datagrid1.valueMatrix(i,datagrid1.colRef("PZL"))== null?0:datagrid1.valueMatrix(i,datagrid1.colRef("PZL"))*1000);
						FJ = FJ + parseInt(datagrid1.valueMatrix(i,datagrid1.colRef("FJH"))== null?0:datagrid1.valueMatrix(i,datagrid1.colRef("FJH"))*1000);					
					}
					
					//alert((YL/1000).toFixed(3));
					//alert((JY/1000).toFixed(3));
					//alert((FY/1000).toFixed(3));
					//alert((HG/1000).toFixed(3));
					//alert((PZ/1000).toFixed(3));
					model.makeValue("/root/CNT/YL",(YL/1000).toFixed(3));
					model.makeValue("/root/CNT/JY",(JY/1000).toFixed(3));
					model.makeValue("/root/CNT/FY",(FY/1000).toFixed(3));
					model.makeValue("/root/CNT/HG",(HG/1000).toFixed(3));
					model.makeValue("/root/CNT/PZ",(PZ/1000).toFixed(3));
					model.makeValue("/root/CNT/FJ",(FJ/1000).toFixed(3));
					model.refresh();
				}
				function excelExport()
				{
					saveExcelScript(datagrid1, "Sheet1");	
				}
				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);	

					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 - 1;
					var nCols = sDGridName.cols;

					//All of the range
					ObjTFExcel.fontcolor( 01, 01, nRows, nCols ) = "#000000"	;
					ObjTFExcel.font     ( 01, 01, nRows, nCols ) = "SimSun"		;

					//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		;

					//Line 2 : Date
					ObjTFExcel.rowheight( 02                ) = 18		;
					ObjTFExcel.bold     ( 02, 01, 02,    01 ) = true	;
					ObjTFExcel.fontsize	( 02, 01, 02,    01 ) = 9 		;
					ObjTFExcel.underline( 02, 01, 02,    01 ) = 0		;
					ObjTFExcel.halign   ( 02, 01, 02,    01 ) ="left"	;
					ObjTFExcel.valign   ( 02, 01, 02,    01 ) ="middle"	;
					ObjTFExcel.mergeCell( 02, 01, 02,    03 )			;
//					ObjTFExcel.colwidth ( 01                ) = 100		;

					//Line 2 : Work-Group & Work-Part
					ObjTFExcel.rowHeight( 02                       ) = 18		;
					ObjTFExcel.bold     ( 02, nCols - 2, 02, nCols ) = true	;
					ObjTFExcel.fontsize	( 02, nCols - 2, 02, nCols ) = 9		;
					ObjTFExcel.underline( 02, nCols - 2, 02, nCols ) = 0		;
					ObjTFExcel.halign   ( 02, nCols - 2, 02, nCols ) ="right"	;
					ObjTFExcel.valign   ( 02, nCols - 2, 02, nCols ) ="middle"	;
					ObjTFExcel.mergeCell( 02, nCols - 2, 02, nCols )			;
//					ObjTFExcel.colwidth ( 01                       ) = 100		;


					//Query-Results Data
					var iRow = 3;	// Header Line + 1;

//					ObjTFExcel.cellBgColor   (iRow, 01, iRow , nCols           ) = "#EEEEEE";	// Undefined...
					ObjTFExcel.setBorderColor(iRow, 01, nRows, nCols, "#000000");

					for(var i = 3; i <= nRows; i++ ) {
						ObjTFExcel.rowHeight( i ) = 18;
					}

					ObjTFExcel.bold     (iRow, 01, nRows, nCols ) = false	;
					ObjTFExcel.fontsize	(iRow, 01, nRows, nCols ) = 9		;
					ObjTFExcel.underline(iRow, 01, nRows, nCols ) = 0		;
					ObjTFExcel.valign   (iRow, 01, nRows, nCols ) ="middle"	;

					ObjTFExcel.halign   (iRow, 01, nRows,    01 ) ="center"	;	//序号
					ObjTFExcel.colwidth (      01               ) = 8		;

					ObjTFExcel.halign   (iRow, 02, nRows,    02 ) ="left"	;	//板坯号
					ObjTFExcel.colwidth (      02               ) = 20		;

					ObjTFExcel.halign   (iRow, 03, nRows,    03 ) ="left"	;	//厚度
					ObjTFExcel.colwidth (      03               ) = 20		;

					ObjTFExcel.halign   (iRow, 04, nRows,    04 ) ="left"	;	//宽度
					ObjTFExcel.colwidth (      04               ) = 20		;

					ObjTFExcel.halign   (iRow, 05, nRows,    05 ) ="left"	;	//长度
					ObjTFExcel.colwidth (      05               ) = 20		;

					ObjTFExcel.halign   (iRow, 06, nRows,    06 ) ="left"	;	//重量（吨）
					ObjTFExcel.colwidth (      06               ) = 20		;

					ObjTFExcel.halign   (iRow, 07, nRows,    07 ) ="left"	;	//钢号
					ObjTFExcel.colwidth (      07               ) = 20		;

					ObjTFExcel.halign   (iRow, 08, nRows,    08 ) ="center"	;	//不合格类别
					ObjTFExcel.colwidth (      08               ) = 12		;

					ObjTFExcel.halign   (iRow, 09, nRows,    09 ) ="right"	;	//板坯判定日
					ObjTFExcel.colwidth (      09               ) = 20	;
					ObjTFExcel.setFormat(iRow, 09, nRows,    09, "yyyy\"-\"mm\"-\"dd\"\" hh\":\"mm\":\"ss\"\";@");
					
					ObjTFExcel.halign   (iRow, 10, nRows,    10 ) ="center"	;	//板坯判定人
					ObjTFExcel.colwidth (      10              ) = 10		;

					ObjTFExcel.halign   (iRow, 11, nRows,    11 ) ="left"	;	//检验班次
					ObjTFExcel.colwidth (      11               ) = 8		;

					ObjTFExcel.halign   (iRow, 12, nRows,    12 ) ="right"	;	//检验班组
					ObjTFExcel.colwidth (      12               ) = 8		;

					/*ObjTFExcel.halign   (iRow, 13, nRows,    13 ) ="left"	;	//最终修改人
					ObjTFExcel.colwidth (      13               ) = 12		;

					ObjTFExcel.halign   (iRow, 14, nRows,    14 ) ="center"	;	//最终修改时间
					ObjTFExcel.colwidth (      14               ) = 20		;
					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

				}
			 ]]>
		</script>
	</xhtml:head>
	<xhtml:body pagewidth="980" pageheight="620">
		<caption id="caption4" class="cell" style="left:0px; top:5px; width:80px; height:20px; border-color:#000000; border-style:solid; ">日期</caption>
		<line id="line1" style="x1:0px; y1:0px; x2:980px; y2:0px; "/>
		<line id="line3" style="x1:0px; y1:30px; x2:980px; y2:30px; "/>
		<datagrid id="datagrid1" nodeset="/root/datagrid1/ListResult_0_Row" allowuserresize="true" caption="产地^规格^计划牌号^判定牌号^原料^检验量^复样量^成材率^合格量^品种量^非计划^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^工艺次^钢质次^钢质次^钢质次^钢质次^钢质次^钢质次^钢质次^钢质改判^钢质改判^钢质改判^钢质改判^钢质改判^钢质改判^钢质改判^钢质改判^钢质改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判^工艺改判|产地^规格^计划牌号^判定牌号^原料^检验量^复样量^成材率^合格量^品种量^非计划^凸度^浪形^辊印^压痕^划伤^凸块^异物压入^光亮带^重量不良^厚度不良^宽度不良^边损^楔形^麻点^卷形不良^折叠^塔形^不平度^性能次^废品^其他^累计^夹杂^裂纹^凹坑^分层^气泡^其它^累计^气泡^分层^夹杂^边裂^凹坑^横裂^纵裂^其它^累计^凸度^浪形^辊印^压痕^划伤^凸块^异物压入^光亮带^重量不良^厚度不良^宽度不良^边损^楔形^麻点^卷形不良^折叠^塔形^不平度^降级^废品^其他^累计" colsep="^" colwidth="70, 50, 64, 64, 50, 50, 62, 56, 50, 50, 50, 51, 50, 50, 50, 50, 59, 63, 61, 69, 78, 84, 51, 60, 50, 67, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 71, 66, 76, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50" defaultrows="30" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" selectionmode="free" style="left:0px; top:60px; width:980px; height:560px; border-color:#000000; border-style:solid; ">
			<col ref="CD"/>
			<col ref="COIL_THK"/>
			<col ref="SPEC_STL_GRD"/>
			<col ref="SPEC_STL_GRD1"/>
			<col ref="SLAB_WGT"/>
			<col ref="JYL" visibility="hidden"/>
			<col ref="FYL"/>
			<col ref="CCL" visibility="hidden"/>
			<col ref="HGL"/>
			<col ref="PZL"/>
			<col ref="FJH"/>
			<col ref="GYC_TUDU"/>
			<col ref="GYC_LANGXING"/>
			<col ref="GYC_GUNYIN"/>
			<col ref="GYC_YAHENG"/>
			<col ref="GYC_HUASHANG"/>
			<col ref="GYC_TUKUAI"/>
			<col ref="GYC_YIWU"/>
			<col ref="GYC_GUANGLIANG"/>
			<col ref="GYC_ZHONGLIANG"/>
			<col ref="GYC_HOUDU"/>
			<col ref="GYC_KUANDU"/>
			<col ref="GYC_BIANSUN"/>
			<col ref="GYC_XIEXING"/>
			<col ref="GYC_MADIAN"/>
			<col ref="GYC_JUANXING"/>
			<col ref="GYC_ZHEDIE"/>
			<col ref="GYC_TAXING"/>
			<col ref="GYC_BUPING"/>
			<col ref="GYC_XINGNENG"/>
			<col ref="GYC_FEIPIN"/>
			<col ref="GYC_QITA"/>
			<col ref="GYC_LEIJI"/>
			<col ref="GZC_JIAZA"/>
			<col ref="GZC_LIEHEN"/>
			<col ref="GZC_AOKENG"/>
			<col ref="GZC_FENCENG"/>
			<col ref="GZC_QIPAO"/>
			<col ref="GZC_QITA"/>
			<col ref="GZC_LEIJI"/>
			<col ref="GZGP_QIPAO"/>
			<col ref="GZGP_FENCENG"/>
			<col ref="GZGP_JIAZA"/>
			<col ref="GZGP_BIANLIE"/>
			<col ref="GZGP_AOKENG"/>
			<col ref="GZGP_HENGLIE"/>
			<col ref="GZGP_ZONGLIE"/>
			<col ref="GZGP_QITA"/>
			<col ref="GZGP_LEIJI"/>
			<col ref="GYGP_TUDU"/>
			<col ref="GYGP_LANGXING"/>
			<col ref="GYGP_GUNYIN"/>
			<col ref="GYGP_YAHENG"/>
			<col ref="GYGP_HUASHANG"/>
			<col ref="GYGP_TUKUAI"/>
			<col ref="GYGP_YIWU"/>
			<col ref="GYGP_GUANGLIANG"/>
			<col ref="GYGP_ZHONGLIANG"/>
			<col ref="GYGP_HOUDU"/>
			<col ref="GYGP_HOUDU"/>
			<col ref="GYGP_BIANSUN"/>
			<col ref="GYGP_XIEXING"/>
			<col ref="GYGP_MADIAN"/>
			<col ref="GYGP_JUANXING"/>
			<col ref="GYGP_ZHEDIE"/>
			<col ref="GYGP_TAXING"/>
			<col ref="GYGP_BUPING"/>
			<col ref="GYGP_XINGNENG"/>
			<col ref="GYGP_FEIPIN"/>
			<col ref="GYGP_QITA"/>
			<col ref="GYGP_LEIJI"/>
		</datagrid>
		<object id="ObjTFExcel" clsid="{fe8d1001-6a9d-424d-ae2a-301493bb12da}" style="left:820px; top:5px; width:1px; height:1px; "/>
		<input id="input1" ref="/root/formData/STDATE" inputtype="date" format="yyyy-mm-dd" style="left:90px; top:5px; width:100px; height:20px; "/>
		<button id="button1" visibility="hidden" style="left:400px; top:5px; width:100px; height:20px; ">
			<caption>find</caption>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
					find();
				]]>
			</script>
		</button>
		<caption id="caption2" style="left:250px; top:35px; width:70px; height:20px; text-align:center; background-color:#00ff00; ">原料:</caption>
		<output id="output1" ref="/root/CNT/YL" style="left:320px; top:35px; width:75px; height:20px; text-align:center; "/>
		<caption id="caption3" style="left:395px; top:35px; width:70px; height:20px; text-align:center; background-color:#00ff00; ">非计划:</caption>
		<output id="output2" ref="/root/CNT/FJ" style="left:465px; top:35px; width:75px; height:20px; text-align:left; "/>
		<caption id="caption5" style="left:540px; top:35px; width:70px; height:20px; text-align:center; background-color:#00ff00; ">复样量:</caption>
		<output id="output3" ref="/root/CNT/FY" style="left:610px; top:35px; width:75px; height:20px; text-align:left; "/>
		<caption id="caption6" style="left:685px; top:35px; width:70px; height:20px; text-align:center; background-color:#00ff00; ">合格量:</caption>
		<output id="output4" ref="/root/CNT/HG" style="left:755px; top:35px; width:75px; height:20px; text-align:center; "/>
		<output id="output5" ref="/root/CNT/PZ" style="left:900px; top:35px; width:75px; height:20px; text-align:center; "/>
		<caption id="caption7" style="left:830px; top:35px; width:70px; height:20px; text-align:center; background-color:#00ff00; ">品种量:</caption>
		<caption id="caption10" style="left:190px; top:10px; width:20px; height:20px; ">~</caption>
		<input id="input2" ref="/root/formData/ENDDATE" inputtype="date" format="yyyy-mm-dd" style="left:200px; top:5px; width:100px; height:20px; "/>
		<button id="button2" style="left:880px; top:5px; width:100px; height:20px; background-color:#ccffcc; border-style:solid; ">
			<caption>导出</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
				var x1	=	window.fileDialog("save", ",", false, "", "xls", "Excel File(*.xls)|*.xls");
				datagrid1.saveExcel(x1, "sheetname:Transaction;colhiddenextend:true;exportfalserows:0;");
				window.alert("导出成功" + x1 + " !!!")
				]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>