XinYu_RZMES/.svn/pristine/36/36454c029ee9a6eff9b28a050fcaef659dad83a2.svn-base

package xin.glue.ui.H.H01;

/********
制作轧线物料统计报表，做一个类拼出需要的值
这里把三班和四班的情况分开来考虑。这个类用来处理三班的情况
************/

import java.math.BigDecimal;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.posdata.glue.biz.activity.PosActivity;
import com.posdata.glue.biz.constants.PosBizControlConstants;
import com.posdata.glue.component.layout.PosMessageLayoutIF;
import com.posdata.glue.context.PosContext;
import com.posdata.glue.dao.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRow;
import com.posdata.glue.dao.vo.PosRowSet;
import com.posdata.glue.msg.PosMESMessageImpl;
import com.posdata.glue.msg.PosMessageAttributeDefinition;
import com.posdata.glue.msg.PosMessageDefinition;
import com.posdata.glue.util.log.PosLog;
import com.posdata.glue.util.log.PosLogFactory;

public class UIH090066Report extends PosActivity{
	private final PosLog log = PosLogFactory.getLogger(getClass());
	
	public String runActivity(PosContext context){
		log.logInfo("======== UIH090060Report start " );
		
		//查询时间,来源。格式为yyyymmddhhmmss
		String[]  PRD_YYYYMM_F = (String[])context.get("SF");  
		//查询时间,去向.格式为yyyymmddhhmmss
		String[]  PRD_YYYYMM_T = (String[])context.get("ST"); 
		
		 log.logInfo("======== UIH090060Report 来源:"+PRD_YYYYMM_F[0] );
		 log.logInfo("======== UIH090060Report 去向时间:"+PRD_YYYYMM_T[0] );
		
		String[][]  EDIT_PROD = new String[35][22];
		
		int i = 0;int j = 0;
		//赋予初值，为空
		for ( i = 0 ; i < 35;i++) {
		    for ( j = 0 ; j < 22;j++) {
			  EDIT_PROD[i][j]= null;
		    }  
		}
		
		List list1 = new ArrayList();
		
		//早班产量统计，分各种各样的情况
		String RHF_DAY_CNT = null;
		
		
		//这里放入序号,第一列的数据
		EDIT_PROD[0][0] = "1";
		EDIT_PROD[1][0] = "2";
		EDIT_PROD[2][0] = "3";
		EDIT_PROD[3][0] = "4";
		EDIT_PROD[4][0] = "5";
		EDIT_PROD[5][0] = "6";
		EDIT_PROD[6][0] = "7";
		EDIT_PROD[7][0] = "8";
		EDIT_PROD[8][0] = "9";
		EDIT_PROD[9][0] = "10";
		EDIT_PROD[10][0] = "11";
		EDIT_PROD[11][0] = "12";
		EDIT_PROD[12][0] = "13";
		EDIT_PROD[13][0] = "14";
		EDIT_PROD[14][0] = "15";
		//非计划吨,6
		EDIT_PROD[15][0] = "16";
		EDIT_PROD[16][0] = "16";
		EDIT_PROD[17][0] = "16";
		EDIT_PROD[18][0] = "16";
		EDIT_PROD[19][0] = "16";
		//煤气
		EDIT_PROD[20][0] = "17";
		EDIT_PROD[21][0] = "18";
		EDIT_PROD[22][0] = "19";
		EDIT_PROD[23][0] = "20";
		EDIT_PROD[24][0] = "21";
		//停轧时间
		EDIT_PROD[25][0] = "22";
		EDIT_PROD[26][0] = "22";
		EDIT_PROD[27][0] = "22";
		EDIT_PROD[28][0] = "22";
		EDIT_PROD[29][0] = "22";
		EDIT_PROD[30][0] = "22";
		EDIT_PROD[31][0] = "22";
		EDIT_PROD[32][0] = "22";
		EDIT_PROD[33][0] = "23";
		
		//这里放入指标名称，第二列的数据
		EDIT_PROD[0][1] = "原料（块/吨）";
		EDIT_PROD[1][1] = "产量（卷/吨）";
		EDIT_PROD[2][1] = "合格品（卷/吨）";
		EDIT_PROD[3][1] = "次品（卷/吨）";
		EDIT_PROD[4][1] = "轧回（吨）";
		EDIT_PROD[5][1] = "废品（吨）";
		EDIT_PROD[6][1] = "中板(吨）";
		EDIT_PROD[7][1] = "合格率（%）";
		EDIT_PROD[8][1] = "成材率（%）";
		EDIT_PROD[9][1] = "日历时间（min)";
		EDIT_PROD[10][1] = "轧钢时间（min)";
		EDIT_PROD[11][1] = "日历作业率（%）";
		EDIT_PROD[12][1] = "设备运转率（%）";
		EDIT_PROD[13][1] = "电器运转率（%）";
		EDIT_PROD[14][1] = "机时产量（吨）";
		//非计划吨,6
		EDIT_PROD[15][1] = "非"+"  "+"尺寸";
		EDIT_PROD[16][1] = "计"+"  "+"表面";
		EDIT_PROD[17][1] = "划"+"  "+"钢制";
		EDIT_PROD[18][1] = "(吨)"+"  "+"性能";
		EDIT_PROD[19][1] = "    "+"合计";
		//煤气
		EDIT_PROD[20][1] = "煤气吨耗量(m3/t)";
		EDIT_PROD[21][1] = "电吨耗量(Kwh/t)";
		EDIT_PROD[22][1] = "水吨耗量(T/t)";
		EDIT_PROD[23][1] = "压缩空气(m3/t)";
		EDIT_PROD[24][1] = "辊耗(kg/t)";
		//停轧时间
		EDIT_PROD[25][1] = "    "+"机械";
		EDIT_PROD[26][1] = "停"+"  "+"电器";
		EDIT_PROD[27][1] = "轧"+"  "+"轧钢";
		EDIT_PROD[28][1] = "时"+"  "+"换辊";
		EDIT_PROD[29][1] = "间"+"  "+"检修";
		EDIT_PROD[30][1] = "(吨)"+" "+"外部";
		EDIT_PROD[31][1] = "    "+"原成";
		EDIT_PROD[32][1] = "    "+"合计";
		
		EDIT_PROD[33][1] = "有效作业率";
		
		//获取甲班的原料、产量、合格品、次品、待判定、中板、轧回、废品
		//原料  1
		String DAY_SLAB_CNT_A = null;
		String MON_SLAB_CNT_A = null;
		Number DAY_SLAB_WGT_A = null;
		Number MON_SLAB_WGT_A = null;
		//产品  2
		String DAY_COIL_CNT_A = null;
		String MON_COIL_CNT_A = null;
		Number DAY_COIL_WGT_A = null;
		Number MON_COIL_WGT_A = null;
		//合格品  3
		String DAY_GRD_1_CNT_A = null;
		String MON_GRD_1_CNT_A = null;
		Number DAY_GRD_1_WGT_A;
		Number MON_GRD_1_WGT_A;
		//次品  4
		String DAY_GRD_2_CNT_A = null;
		String MON_GRD_2_CNT_A = null;
		Number DAY_GRD_2_WGT_A;
		Number MON_GRD_2_WGT_A;
		//轧回  5
		String DAY_REJ_CNT_A = null;
		String MON_REJ_CNT_A = null;
		String DAY_REJ_WGT_A = null;
		String MON_REJ_WGT_A = null;
		//轧废  6
		String DAY_SCRAP_CNT_A = null;
		String MON_SCRAP_CNT_A = null;
		String DAY_SCRAP_WGT_A = null;
		String MON_SCRAP_WGT_A = null;
		//中板  7
		String DAY_MISSNO_CNT_A = null;
		String MON_MISSNO_CNT_A = null;
		String DAY_MISSNO_WGT_A = null;
		String MON_MISSNO_WGT_A = null;
		
		//合格率 8
		double DAY_GRD_L_WGT_A;
		double MON_GRD_L_WGT_A;
		
		//成材率
		double DAY_CS_L_WGT_A;
		double MON_CS_L_WGT_A;
		
		//非计划吨（尺寸）  16
		String DAY_SIZE_CNT_A = null;
		String MON_SIZE_CNT_A = null;
		Number DAY_SIZE_WGT_A = null;
		Number MON_SIZE_WGT_A = null;
		//非计划吨（表面）  17
		String DAY_EXTSHAPE_CNT_A = null;
		String MON_EXTSHAPE_CNT_A = null;
		Number DAY_EXTSHAPE_WGT_A = null;
		Number MON_EXTSHAPE_WGT_A = null;
		//非计划吨（性能）  18
		String DAY_MATLQLTY_CNT_A = null;
		String MON_MATLQLTY_CNT_A = null;
		Number DAY_MATLQLTY_WGT_A = null;
		Number MON_MATLQLTY_WGT_A = null;
		//非计划吨（钢质）  19
		String DAY_STL_CNT_A = null;
		String MON_STL_CNT_A = null;
		Number DAY_STL_WGT_A = null;
		Number MON_STL_WGT_A = null;
		
		//非计划（合计）  20
		double DAY_SUM_WGT_A;
		double MON_SUM_WGT_A;
		
		//获取乙班的原料、产量、合格品、次品、待判定、中板、轧回、废品相关变量
//		原料  1
		String DAY_SLAB_CNT_B = null;
		String MON_SLAB_CNT_B = null;
		Number DAY_SLAB_WGT_B = null;
		Number MON_SLAB_WGT_B = null;
		//产品  2
		String DAY_COIL_CNT_B = null;
		String MON_COIL_CNT_B = null;
		Number DAY_COIL_WGT_B = null;
		Number MON_COIL_WGT_B = null;
		//合格品  3
		String DAY_GRD_1_CNT_B = null;
		String MON_GRD_1_CNT_B = null;
		Number DAY_GRD_1_WGT_B;
		Number MON_GRD_1_WGT_B;
		//次品  4
		String DAY_GRD_2_CNT_B = null;
		String MON_GRD_2_CNT_B = null;
		Number DAY_GRD_2_WGT_B;
		Number MON_GRD_2_WGT_B;
		//轧回  5
		String DAY_REJ_CNT_B = null;
		String MON_REJ_CNT_B = null;
		String DAY_REJ_WGT_B = null;
		String MON_REJ_WGT_B = null;
		//轧废  6
		String DAY_SCRAP_CNT_B = null;
		String MON_SCRAP_CNT_B = null;
		String DAY_SCRAP_WGT_B = null;
		String MON_SCRAP_WGT_B = null;
		//中板  7
		String DAY_MISSNO_CNT_B = null;
		String MON_MISSNO_CNT_B = null;
		String DAY_MISSNO_WGT_B = null;
		String MON_MISSNO_WGT_B = null;
		
		//合格率 8
		double DAY_GRD_L_WGT_B;
		double MON_GRD_L_WGT_B;
		
		//成材率
		double DAY_CS_L_WGT_B;
		double MON_CS_L_WGT_B;
		
		//非计划吨（尺寸）  16
		String DAY_SIZE_CNT_B = null;
		String MON_SIZE_CNT_B = null;
		Number DAY_SIZE_WGT_B = null;
		Number MON_SIZE_WGT_B = null;
		//非计划吨（表面）  17
		String DAY_EXTSHAPE_CNT_B = null;
		String MON_EXTSHAPE_CNT_B = null;
		Number DAY_EXTSHAPE_WGT_B = null;
		Number MON_EXTSHAPE_WGT_B = null;
		//非计划吨（性能）  18
		String DAY_MATLQLTY_CNT_B = null;
		String MON_MATLQLTY_CNT_B = null;
		Number DAY_MATLQLTY_WGT_B = null;
		Number MON_MATLQLTY_WGT_B = null;
		//非计划吨（钢质）  19
		String DAY_STL_CNT_B = null;
		String MON_STL_CNT_B = null;
		Number DAY_STL_WGT_B = null;
		Number MON_STL_WGT_B = null;
		
		//非计划（合计）  20
		double DAY_SUM_WGT_B;
		double MON_SUM_WGT_B;
		
		//获取丙班的原料、产量、合格品、次品、待判定、中板、轧回、废品
		//原料  1
		String DAY_SLAB_CNT_C = null;
		String MON_SLAB_CNT_C = null;
		Number DAY_SLAB_WGT_C = null;
		Number MON_SLAB_WGT_C = null;
		//产品  2
		String DAY_COIL_CNT_C = null;
		String MON_COIL_CNT_C = null;
		Number DAY_COIL_WGT_C = null;
		Number MON_COIL_WGT_C = null;
		//合格品  3
		String DAY_GRD_1_CNT_C = null;
		String MON_GRD_1_CNT_C = null;
		Number DAY_GRD_1_WGT_C;
		Number MON_GRD_1_WGT_C;
		//次品  4
		String DAY_GRD_2_CNT_C = null;
		String MON_GRD_2_CNT_C = null;
		Number DAY_GRD_2_WGT_C;
		Number MON_GRD_2_WGT_C;
		//轧回  5
		String DAY_REJ_CNT_C = null;
		String MON_REJ_CNT_C = null;
		String DAY_REJ_WGT_C = null;
		String MON_REJ_WGT_C = null;
		//轧废  6
		String DAY_SCRAP_CNT_C = null;
		String MON_SCRAP_CNT_C = null;
		String DAY_SCRAP_WGT_C = null;
		String MON_SCRAP_WGT_C = null;
		//中板  7
		String DAY_MISSNO_CNT_C = null;
		String MON_MISSNO_CNT_C = null;
		String DAY_MISSNO_WGT_C = null;
		String MON_MISSNO_WGT_C = null;
		
		//合格率 8
		double DAY_GRD_L_WGT_C;
		double MON_GRD_L_WGT_C;
		
		//成材率
		double DAY_CS_L_WGT_C;
		double MON_CS_L_WGT_C;
		
		//非计划吨（尺寸）  16
		String DAY_SIZE_CNT_C = null;
		String MON_SIZE_CNT_C = null;
		Number DAY_SIZE_WGT_C = null;
		Number MON_SIZE_WGT_C = null;
		//非计划吨（表面）  17
		String DAY_EXTSHAPE_CNT_C = null;
		String MON_EXTSHAPE_CNT_C = null;
		Number DAY_EXTSHAPE_WGT_C = null;
		Number MON_EXTSHAPE_WGT_C = null;
		//非计划吨（性能）  18
		String DAY_MATLQLTY_CNT_C = null;
		String MON_MATLQLTY_CNT_C = null;
		Number DAY_MATLQLTY_WGT_C = null;
		Number MON_MATLQLTY_WGT_C = null;
		//非计划吨（钢质）  19
		String DAY_STL_CNT_C = null;
		String MON_STL_CNT_C = null;
		Number DAY_STL_WGT_C = null;
		Number MON_STL_WGT_C = null;
		
		//非计划（合计）  20
		double DAY_SUM_WGT_C;
		double MON_SUM_WGT_C;
		
		//获取丁班的原料、产量、合格品、次品、待判定、中板、轧回、废品
		//原料  1
		String DAY_SLAB_CNT_D = null;
		String MON_SLAB_CNT_D = null;
		Number DAY_SLAB_WGT_D = null;
		Number MON_SLAB_WGT_D = null;
		//产品  2
		String DAY_COIL_CNT_D = null;
		String MON_COIL_CNT_D = null;
		Number DAY_COIL_WGT_D = null;
		Number MON_COIL_WGT_D = null;
		//合格品  3
		String DAY_GRD_1_CNT_D = null;
		String MON_GRD_1_CNT_D = null;
		Number DAY_GRD_1_WGT_D;
		Number MON_GRD_1_WGT_D;
		//次品  4
		String DAY_GRD_2_CNT_D = null;
		String MON_GRD_2_CNT_D = null;
		Number DAY_GRD_2_WGT_D;
		Number MON_GRD_2_WGT_D;
		//轧回  5
		String DAY_REJ_CNT_D = null;
		String MON_REJ_CNT_D = null;
		String DAY_REJ_WGT_D = null;
		String MON_REJ_WGT_D = null;
		//轧废  6
		String DAY_SCRAP_CNT_D = null;
		String MON_SCRAP_CNT_D = null;
		String DAY_SCRAP_WGT_D = null;
		String MON_SCRAP_WGT_D = null;
		//中板  7
		String DAY_MISSNO_CNT_D = null;
		String MON_MISSNO_CNT_D = null;
		String DAY_MISSNO_WGT_D = null;
		String MON_MISSNO_WGT_D = null;
		
		//合格率 8
		double DAY_GRD_L_WGT_D;
		double MON_GRD_L_WGT_D;
		
		//成材率
		double DAY_CS_L_WGT_D;
		double MON_CS_L_WGT_D;
		
		//非计划吨（尺寸）  16
		String DAY_SIZE_CNT_D = null;
		String MON_SIZE_CNT_D = null;
		Number DAY_SIZE_WGT_D = null;
		Number MON_SIZE_WGT_D = null;
		//非计划吨（表面）  17
		String DAY_EXTSHAPE_CNT_D = null;
		String MON_EXTSHAPE_CNT_D = null;
		Number DAY_EXTSHAPE_WGT_D = null;
		Number MON_EXTSHAPE_WGT_D = null;
		//非计划吨（性能）  18
		String DAY_MATLQLTY_CNT_D = null;
		String MON_MATLQLTY_CNT_D = null;
		Number DAY_MATLQLTY_WGT_D = null;
		Number MON_MATLQLTY_WGT_D = null;
		//非计划吨（钢质）  19
		String DAY_STL_CNT_D = null;
		String MON_STL_CNT_D = null;
		Number DAY_STL_WGT_D = null;
		Number MON_STL_WGT_D = null;
		
		//非计划（合计）  20
		double DAY_SUM_WGT_D;
		double MON_SUM_WGT_D;

		//这里不需要考虑班次的情况，反正是取时间段内的4个班组的全部值
			//两班的情况，这里求甲的情况
			PosParameter param1 = new PosParameter();
			//这里统计的时候需要给出具体的时间，即统计的时间段精确的YYYYMMDDHHMMSS
			//1
			param1.setWhereClauseParameter(0, "A");
			param1.setWhereClauseParameter(1, PRD_YYYYMM_F[0]);
			param1.setWhereClauseParameter(2, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param1.setWhereClauseParameter(3, "A");
			param1.setWhereClauseParameter(4, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param1.setWhereClauseParameter(5, PRD_YYYYMM_T[0]);
			//2
			param1.setWhereClauseParameter(6, "A");
			param1.setWhereClauseParameter(7, PRD_YYYYMM_F[0]);
			param1.setWhereClauseParameter(8, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param1.setWhereClauseParameter(9, "A");
			param1.setWhereClauseParameter(10, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param1.setWhereClauseParameter(11, PRD_YYYYMM_T[0]);
			//3
			param1.setWhereClauseParameter(12, "A");
			param1.setWhereClauseParameter(13, PRD_YYYYMM_F[0]);
			param1.setWhereClauseParameter(14, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param1.setWhereClauseParameter(15, "A");
			param1.setWhereClauseParameter(16, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param1.setWhereClauseParameter(17, PRD_YYYYMM_T[0]);
			//4
			param1.setWhereClauseParameter(18, "A");
			param1.setWhereClauseParameter(19, PRD_YYYYMM_F[0]);
			param1.setWhereClauseParameter(20, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param1.setWhereClauseParameter(21, "A");
			param1.setWhereClauseParameter(22, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param1.setWhereClauseParameter(23, PRD_YYYYMM_T[0]);
			//5
			param1.setWhereClauseParameter(24, "A");
			param1.setWhereClauseParameter(25, PRD_YYYYMM_F[0]);
			param1.setWhereClauseParameter(26, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param1.setWhereClauseParameter(27, "A");
			param1.setWhereClauseParameter(28, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param1.setWhereClauseParameter(29, PRD_YYYYMM_T[0]);
			//6
			param1.setWhereClauseParameter(30, "A");
			param1.setWhereClauseParameter(31, PRD_YYYYMM_F[0]);
			param1.setWhereClauseParameter(32, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param1.setWhereClauseParameter(33, "A");
			param1.setWhereClauseParameter(34, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param1.setWhereClauseParameter(35, PRD_YYYYMM_T[0]);
			//7
			param1.setWhereClauseParameter(36, "A");
			param1.setWhereClauseParameter(37, PRD_YYYYMM_F[0]);
			param1.setWhereClauseParameter(38, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param1.setWhereClauseParameter(39, "A");
			param1.setWhereClauseParameter(40, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param1.setWhereClauseParameter(41, PRD_YYYYMM_T[0]);
			//8
			param1.setWhereClauseParameter(42, "A");
			param1.setWhereClauseParameter(43, PRD_YYYYMM_F[0]);
			param1.setWhereClauseParameter(44, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param1.setWhereClauseParameter(45, "A");
			param1.setWhereClauseParameter(46, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param1.setWhereClauseParameter(47, PRD_YYYYMM_T[0]);
			//9
			param1.setWhereClauseParameter(48, "A");
			param1.setWhereClauseParameter(49, PRD_YYYYMM_F[0]);
			param1.setWhereClauseParameter(50, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param1.setWhereClauseParameter(51, "A");
			param1.setWhereClauseParameter(52, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param1.setWhereClauseParameter(53, PRD_YYYYMM_T[0]);
			//10
			param1.setWhereClauseParameter(54, "A");
			param1.setWhereClauseParameter(55, PRD_YYYYMM_F[0]);
			param1.setWhereClauseParameter(56, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param1.setWhereClauseParameter(57, "A");
			param1.setWhereClauseParameter(58, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param1.setWhereClauseParameter(59, PRD_YYYYMM_T[0]);
			//11
			param1.setWhereClauseParameter(60, "A");
			param1.setWhereClauseParameter(61, PRD_YYYYMM_F[0]);
			param1.setWhereClauseParameter(62, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param1.setWhereClauseParameter(63, "A");
			param1.setWhereClauseParameter(64, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param1.setWhereClauseParameter(65, PRD_YYYYMM_T[0]);
			
			PosRowSet ARstVO = this.getDao("mesdao").find("UIH090060_06.select", param1);
			
			if(ARstVO.hasNext()){
//					把早班相应的数据赋予甲班
				PosRow ARstROW = ARstVO.next();
				
//					原料 1
				DAY_SLAB_CNT_A = (String)ARstROW.getAttribute("DAY_SLAB_CNT");
				MON_SLAB_CNT_A = (String)ARstROW.getAttribute("MON_SLAB_CNT");
				DAY_SLAB_WGT_A = (Number)ARstROW.getAttribute("DAY_SLAB_WGT");
				MON_SLAB_WGT_A = (Number)ARstROW.getAttribute("MON_SLAB_WGT");
				
				EDIT_PROD[0][2] = DAY_SLAB_CNT_A;
				EDIT_PROD[0][3] = MON_SLAB_CNT_A;
				EDIT_PROD[0][4] = String.valueOf(DAY_SLAB_WGT_A);
				EDIT_PROD[0][5] = String.valueOf(MON_SLAB_WGT_A);
				//产量  2
				DAY_COIL_CNT_A = (String)ARstROW.getAttribute("DAY_COIL_CNT");
				MON_COIL_CNT_A = (String)ARstROW.getAttribute("MON_COIL_CNT");
				DAY_COIL_WGT_A = (Number)ARstROW.getAttribute("DAY_COIL_WGT");
				MON_COIL_WGT_A = (Number)ARstROW.getAttribute("MON_COIL_WGT");
				
				EDIT_PROD[1][2] = DAY_COIL_CNT_A;
				EDIT_PROD[1][3] = MON_COIL_CNT_A;
				EDIT_PROD[1][4] = String.valueOf(DAY_COIL_WGT_A);
				EDIT_PROD[1][5] = String.valueOf(MON_COIL_WGT_A);
				//合格品  3
				DAY_GRD_1_CNT_A = (String)ARstROW.getAttribute("DAY_GRD_1_CNT");
				MON_GRD_1_CNT_A = (String)ARstROW.getAttribute("MON_GRD_1_CNT");
				DAY_GRD_1_WGT_A = (Number)ARstROW.getAttribute("DAY_GRD_1_WGT");
				MON_GRD_1_WGT_A = (Number)ARstROW.getAttribute("MON_GRD_1_WGT");
				
				EDIT_PROD[2][2] = DAY_GRD_1_CNT_A;
				EDIT_PROD[2][3] = MON_GRD_1_CNT_A;
				EDIT_PROD[2][4] = String.valueOf(DAY_GRD_1_WGT_A);
				EDIT_PROD[2][5] = String.valueOf(MON_GRD_1_WGT_A);
				//次品  4 
				DAY_GRD_2_CNT_A = (String)ARstROW.getAttribute("DAY_GRD_2_CNT");
				MON_GRD_2_CNT_A = (String)ARstROW.getAttribute("MON_GRD_2_CNT");
				DAY_GRD_2_WGT_A = (Number)ARstROW.getAttribute("DAY_GRD_2_WGT");
				MON_GRD_2_WGT_A = (Number)ARstROW.getAttribute("MON_GRD_2_WGT");
				
				EDIT_PROD[3][2] = DAY_GRD_2_CNT_A;
				EDIT_PROD[3][3] = MON_GRD_2_CNT_A;
				EDIT_PROD[3][4] = String.valueOf(DAY_GRD_2_WGT_A);
				EDIT_PROD[3][5] = String.valueOf(MON_GRD_2_WGT_A);
				
				//轧回  5
				DAY_REJ_CNT_A = (String)ARstROW.getAttribute("DAY_REJ_CNT");
				MON_REJ_CNT_A = (String)ARstROW.getAttribute("MON_REJ_CNT");
				DAY_REJ_WGT_A = (String)ARstROW.getAttribute("DAY_REJ_WGT");
				MON_REJ_WGT_A = (String)ARstROW.getAttribute("MON_REJ_WGT");
				
				EDIT_PROD[4][2] = DAY_REJ_CNT_A;
				EDIT_PROD[4][3] = MON_REJ_CNT_A;
				EDIT_PROD[4][4] = DAY_REJ_WGT_A;
				EDIT_PROD[4][5] = MON_REJ_WGT_A;
				//轧废  6 
				DAY_SCRAP_CNT_A = (String)ARstROW.getAttribute("DAY_SCRAP_CNT");
				MON_SCRAP_CNT_A = (String)ARstROW.getAttribute("MON_SCRAP_CNT");
				DAY_SCRAP_WGT_A = (String)ARstROW.getAttribute("DAY_SCRAP_WGT");
				MON_SCRAP_WGT_A = (String)ARstROW.getAttribute("MON_SCRAP_WGT");
				
				EDIT_PROD[5][2] = DAY_SCRAP_CNT_A;
				EDIT_PROD[5][3] = MON_SCRAP_CNT_A;
				EDIT_PROD[5][4] = DAY_SCRAP_WGT_A;
				EDIT_PROD[5][5] = MON_SCRAP_WGT_A;
				//中板  7 
				DAY_MISSNO_CNT_A = (String)ARstROW.getAttribute("DAY_MISSNO_CNT");
				MON_MISSNO_CNT_A = (String)ARstROW.getAttribute("MON_MISSNO_CNT");
				DAY_MISSNO_WGT_A = (String)ARstROW.getAttribute("DAY_MISSNO_WGT");
				MON_MISSNO_WGT_A = (String)ARstROW.getAttribute("MON_MISSNO_WGT");
				
				EDIT_PROD[6][2] = DAY_MISSNO_CNT_A;
				EDIT_PROD[6][3] = MON_MISSNO_CNT_A;
				EDIT_PROD[6][4] = DAY_MISSNO_WGT_A;
				EDIT_PROD[6][5] = MON_MISSNO_WGT_A;
				
				//合格率
				if((DAY_GRD_1_WGT_A.doubleValue()+DAY_GRD_2_WGT_A.doubleValue()) != 0){
					DAY_GRD_L_WGT_A = (DAY_GRD_1_WGT_A.doubleValue()/(DAY_GRD_1_WGT_A.doubleValue()+DAY_GRD_2_WGT_A.doubleValue()))*100;	
				}else{
					DAY_GRD_L_WGT_A = 0;
				}
				//保留两位精度
				Double DAY_GRD_L_WGT_A_1 = new Double(new DecimalFormat(".00").format(DAY_GRD_L_WGT_A));
				EDIT_PROD[7][2] = String.valueOf(DAY_GRD_L_WGT_A_1);
				
				
				if((MON_GRD_1_WGT_A.doubleValue()+MON_GRD_2_WGT_A.doubleValue()) != 0){
					MON_GRD_L_WGT_A = (MON_GRD_1_WGT_A.doubleValue()/(MON_GRD_1_WGT_A.doubleValue()+MON_GRD_2_WGT_A.doubleValue()))*100;
				}else{
					MON_GRD_L_WGT_A = 0;
				}
				//保留两位精度
				Double MON_GRD_L_WGT_A_1 = new Double(new DecimalFormat(".00").format(MON_GRD_L_WGT_A));
				EDIT_PROD[7][3] = String.valueOf(MON_GRD_L_WGT_A_1);
				
				//成材率
				if(DAY_SLAB_WGT_A.intValue() != 0){
					DAY_CS_L_WGT_A = (DAY_COIL_WGT_A.doubleValue()/DAY_SLAB_WGT_A.doubleValue())*100;
				}else{
					DAY_CS_L_WGT_A = 0;
				}
				//保留两位精度
				Double DAY_CS_L_WGT_A_1 = new Double(new DecimalFormat(".00").format(DAY_CS_L_WGT_A));
				EDIT_PROD[8][2] = String.valueOf(DAY_CS_L_WGT_A_1);
				
				if(MON_SLAB_WGT_A.intValue() != 0){
					MON_CS_L_WGT_A = (MON_COIL_WGT_A.doubleValue()/MON_SLAB_WGT_A.doubleValue())*100;
				}else{
					MON_CS_L_WGT_A = 0;
				}
				//保留两位精度
				Double MON_CS_L_WGT_A_1 = new Double(new DecimalFormat(".00").format(MON_CS_L_WGT_A));
				EDIT_PROD[8][3] = String.valueOf(MON_CS_L_WGT_A_1);
				
				//非计划（尺寸）  8 
				DAY_SIZE_CNT_A = (String)ARstROW.getAttribute("DAY_SIZE_CNT");
				MON_SIZE_CNT_A = (String)ARstROW.getAttribute("MON_SIZE_CNT");
				DAY_SIZE_WGT_A = (Number)ARstROW.getAttribute("DAY_SIZE_WGT");
				MON_SIZE_WGT_A = (Number)ARstROW.getAttribute("MON_SIZE_WGT");
				
				//第16行
				EDIT_PROD[15][2] = DAY_SIZE_CNT_A;
				EDIT_PROD[15][3] = MON_SIZE_CNT_A;
				EDIT_PROD[15][4] = String.valueOf(DAY_SIZE_WGT_A);
				EDIT_PROD[15][5] = String.valueOf(MON_SIZE_WGT_A);
				
				//非计划（表面）  9 
				DAY_EXTSHAPE_CNT_A = (String)ARstROW.getAttribute("DAY_EXTSHAPE_CNT");
				MON_EXTSHAPE_CNT_A = (String)ARstROW.getAttribute("MON_EXTSHAPE_CNT");
				DAY_EXTSHAPE_WGT_A = (Number)ARstROW.getAttribute("DAY_EXTSHAPE_WGT");
				MON_EXTSHAPE_WGT_A = (Number)ARstROW.getAttribute("MON_EXTSHAPE_WGT");
				
				//第17行
				EDIT_PROD[16][2] = DAY_EXTSHAPE_CNT_A;
				EDIT_PROD[16][3] = MON_EXTSHAPE_CNT_A;
				EDIT_PROD[16][4] = String.valueOf(DAY_EXTSHAPE_WGT_A);
				EDIT_PROD[16][5] = String.valueOf(MON_EXTSHAPE_WGT_A);
				
				//非计划（性能）  10 
				DAY_MATLQLTY_CNT_A = (String)ARstROW.getAttribute("DAY_MATLQLTY_CNT");
				MON_MATLQLTY_CNT_A = (String)ARstROW.getAttribute("MON_MATLQLTY_CNT");
				DAY_MATLQLTY_WGT_A = (Number)ARstROW.getAttribute("DAY_MATLQLTY_WGT");
				MON_MATLQLTY_WGT_A = (Number)ARstROW.getAttribute("MON_MATLQLTY_WGT");
				
				//第18行
				EDIT_PROD[17][2] = DAY_MATLQLTY_CNT_A;
				EDIT_PROD[17][3] = MON_MATLQLTY_CNT_A;
				EDIT_PROD[17][4] = String.valueOf(DAY_MATLQLTY_WGT_A);
				EDIT_PROD[17][5] = String.valueOf(MON_MATLQLTY_WGT_A);
				
				//非计划（钢质）  11 
				DAY_STL_CNT_A = (String)ARstROW.getAttribute("DAY_STL_CNT");
				MON_STL_CNT_A = (String)ARstROW.getAttribute("MON_STL_CNT");
				DAY_STL_WGT_A = (Number)ARstROW.getAttribute("DAY_STL_WGT");
				MON_STL_WGT_A = (Number)ARstROW.getAttribute("MON_STL_WGT");
				
				//第19行
				EDIT_PROD[18][2] = DAY_STL_CNT_A;
				EDIT_PROD[18][3] = MON_STL_CNT_A;
				EDIT_PROD[18][4] = String.valueOf(DAY_STL_WGT_A);
				EDIT_PROD[18][5] = String.valueOf(MON_STL_WGT_A);
				
				//非计划（合计） 12
				DAY_SUM_WGT_A = DAY_SIZE_WGT_A.doubleValue()+DAY_EXTSHAPE_WGT_A.doubleValue()+DAY_MATLQLTY_WGT_A.doubleValue()+DAY_STL_WGT_A.doubleValue();
			
				//保留两位精度
				Double DAY_SUM_WGT_A_1 = new Double(new DecimalFormat(".00").format(DAY_SUM_WGT_A));
				
				MON_SUM_WGT_A = MON_SIZE_WGT_A.doubleValue()+MON_EXTSHAPE_WGT_A.doubleValue()+MON_MATLQLTY_WGT_A.doubleValue()+MON_STL_WGT_A.doubleValue();
				
				//保留两位精度
				Double MON_SUM_WGT_A_1 = new Double(new DecimalFormat(".00").format(MON_SUM_WGT_A));
				
				EDIT_PROD[19][2] = String.valueOf(DAY_SUM_WGT_A_1);
				EDIT_PROD[19][3] = String.valueOf(MON_SUM_WGT_A_1);
			}
			
			//两班的情况，这里求乙的情况
			PosParameter param2 = new PosParameter();
			//这里统计的时候需要给出具体的时间，即统计的时间段精确的YYYYMMDDHHMMSS
			//1
			param2.setWhereClauseParameter(0, "B");
			param2.setWhereClauseParameter(1, PRD_YYYYMM_F[0]);
			param2.setWhereClauseParameter(2, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param2.setWhereClauseParameter(3, "B");
			param2.setWhereClauseParameter(4, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param2.setWhereClauseParameter(5, PRD_YYYYMM_T[0]);
			//2
			param2.setWhereClauseParameter(6, "B");
			param2.setWhereClauseParameter(7, PRD_YYYYMM_F[0]);
			param2.setWhereClauseParameter(8, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param2.setWhereClauseParameter(9, "B");
			param2.setWhereClauseParameter(10, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param2.setWhereClauseParameter(11, PRD_YYYYMM_T[0]);
			//3
			param2.setWhereClauseParameter(12, "B");
			param2.setWhereClauseParameter(13, PRD_YYYYMM_F[0]);
			param2.setWhereClauseParameter(14, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param2.setWhereClauseParameter(15, "B");
			param2.setWhereClauseParameter(16, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param2.setWhereClauseParameter(17, PRD_YYYYMM_T[0]);
			//4
			param2.setWhereClauseParameter(18, "B");
			param2.setWhereClauseParameter(19, PRD_YYYYMM_F[0]);
			param2.setWhereClauseParameter(20, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param2.setWhereClauseParameter(21, "B");
			param2.setWhereClauseParameter(22, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param2.setWhereClauseParameter(23, PRD_YYYYMM_T[0]);
			//5
			param2.setWhereClauseParameter(24, "B");
			param2.setWhereClauseParameter(25, PRD_YYYYMM_F[0]);
			param2.setWhereClauseParameter(26, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param2.setWhereClauseParameter(27, "B");
			param2.setWhereClauseParameter(28, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param2.setWhereClauseParameter(29, PRD_YYYYMM_T[0]);
			//6
			param2.setWhereClauseParameter(30, "B");
			param2.setWhereClauseParameter(31, PRD_YYYYMM_F[0]);
			param2.setWhereClauseParameter(32, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param2.setWhereClauseParameter(33, "B");
			param2.setWhereClauseParameter(34, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param2.setWhereClauseParameter(35, PRD_YYYYMM_T[0]);
			//7
			param2.setWhereClauseParameter(36, "B");
			param2.setWhereClauseParameter(37, PRD_YYYYMM_F[0]);
			param2.setWhereClauseParameter(38, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param2.setWhereClauseParameter(39, "B");
			param2.setWhereClauseParameter(40, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param2.setWhereClauseParameter(41, PRD_YYYYMM_T[0]);
			//8
			param2.setWhereClauseParameter(42, "B");
			param2.setWhereClauseParameter(43, PRD_YYYYMM_F[0]);
			param2.setWhereClauseParameter(44, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param2.setWhereClauseParameter(45, "B");
			param2.setWhereClauseParameter(46, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param2.setWhereClauseParameter(47, PRD_YYYYMM_T[0]);
			//9
			param2.setWhereClauseParameter(48, "B");
			param2.setWhereClauseParameter(49, PRD_YYYYMM_F[0]);
			param2.setWhereClauseParameter(50, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param2.setWhereClauseParameter(51, "B");
			param2.setWhereClauseParameter(52, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param2.setWhereClauseParameter(53, PRD_YYYYMM_T[0]);
			//10
			param2.setWhereClauseParameter(54, "B");
			param2.setWhereClauseParameter(55, PRD_YYYYMM_F[0]);
			param2.setWhereClauseParameter(56, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param2.setWhereClauseParameter(57, "B");
			param2.setWhereClauseParameter(58, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param2.setWhereClauseParameter(59, PRD_YYYYMM_T[0]);
			//11
			param2.setWhereClauseParameter(60, "B");
			param2.setWhereClauseParameter(61, PRD_YYYYMM_F[0]);
			param2.setWhereClauseParameter(62, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param2.setWhereClauseParameter(63, "B");
			param2.setWhereClauseParameter(64, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param2.setWhereClauseParameter(65, PRD_YYYYMM_T[0]);
			
			PosRowSet BRstVO = this.getDao("mesdao").find("UIH090060_06.select", param2);
			
			if(BRstVO.hasNext()){
//					把早班相应的数据赋予乙班
				PosRow BRstROW = BRstVO.next();
				//原料 1
				DAY_SLAB_CNT_B = (String)BRstROW.getAttribute("DAY_SLAB_CNT");
				MON_SLAB_CNT_B = (String)BRstROW.getAttribute("MON_SLAB_CNT");
				DAY_SLAB_WGT_B = (Number)BRstROW.getAttribute("DAY_SLAB_WGT");
				MON_SLAB_WGT_B = (Number)BRstROW.getAttribute("MON_SLAB_WGT");
				
				EDIT_PROD[0][6] = DAY_SLAB_CNT_B;
				EDIT_PROD[0][7] = MON_SLAB_CNT_B;
				EDIT_PROD[0][8] = String.valueOf(DAY_SLAB_WGT_B);
				EDIT_PROD[0][9] = String.valueOf(MON_SLAB_WGT_B);
				//产量  2
				DAY_COIL_CNT_B = (String)BRstROW.getAttribute("DAY_COIL_CNT");
				MON_COIL_CNT_B = (String)BRstROW.getAttribute("MON_COIL_CNT");
				DAY_COIL_WGT_B = (Number)BRstROW.getAttribute("DAY_COIL_WGT");
				MON_COIL_WGT_B = (Number)BRstROW.getAttribute("MON_COIL_WGT");
				
				EDIT_PROD[1][6] = DAY_COIL_CNT_B;
				EDIT_PROD[1][7] = MON_COIL_CNT_B;
				EDIT_PROD[1][8] = String.valueOf(DAY_COIL_WGT_B);
				EDIT_PROD[1][9] = String.valueOf(MON_COIL_WGT_B);
				//合格品  3
				DAY_GRD_1_CNT_B = (String)BRstROW.getAttribute("DAY_GRD_1_CNT");
				MON_GRD_1_CNT_B = (String)BRstROW.getAttribute("MON_GRD_1_CNT");
				DAY_GRD_1_WGT_B = (Number)BRstROW.getAttribute("DAY_GRD_1_WGT");
				MON_GRD_1_WGT_B = (Number)BRstROW.getAttribute("MON_GRD_1_WGT");
				
				EDIT_PROD[2][6] = DAY_GRD_1_CNT_B;
				EDIT_PROD[2][7] = MON_GRD_1_CNT_B;
				EDIT_PROD[2][8] = String.valueOf(DAY_GRD_1_WGT_B);
				EDIT_PROD[2][9] = String.valueOf(MON_GRD_1_WGT_B);
				//次品  4 
				DAY_GRD_2_CNT_B = (String)BRstROW.getAttribute("DAY_GRD_2_CNT");
				MON_GRD_2_CNT_B = (String)BRstROW.getAttribute("MON_GRD_2_CNT");
				DAY_GRD_2_WGT_B = (Number)BRstROW.getAttribute("DAY_GRD_2_WGT");
				MON_GRD_2_WGT_B = (Number)BRstROW.getAttribute("MON_GRD_2_WGT");
				
				EDIT_PROD[3][6] = DAY_GRD_2_CNT_B;
				EDIT_PROD[3][7] = MON_GRD_2_CNT_B;
				EDIT_PROD[3][8] = String.valueOf(DAY_GRD_2_WGT_B);
				EDIT_PROD[3][9] = String.valueOf(MON_GRD_2_WGT_B);
				
				//轧回  5
				DAY_REJ_CNT_B = (String)BRstROW.getAttribute("DAY_REJ_CNT");
				MON_REJ_CNT_B = (String)BRstROW.getAttribute("MON_REJ_CNT");
				DAY_REJ_WGT_B = (String)BRstROW.getAttribute("DAY_REJ_WGT");
				MON_REJ_WGT_B = (String)BRstROW.getAttribute("MON_REJ_WGT");
				
				EDIT_PROD[4][6] = DAY_REJ_CNT_B;
				EDIT_PROD[4][7] = MON_REJ_CNT_B;
				EDIT_PROD[4][8] = DAY_REJ_WGT_B;
				EDIT_PROD[4][9] = MON_REJ_WGT_B;
				//轧废  6 
				DAY_SCRAP_CNT_B = (String)BRstROW.getAttribute("DAY_SCRAP_CNT");
				MON_SCRAP_CNT_B = (String)BRstROW.getAttribute("MON_SCRAP_CNT");
				DAY_SCRAP_WGT_B = (String)BRstROW.getAttribute("DAY_SCRAP_WGT");
				MON_SCRAP_WGT_B = (String)BRstROW.getAttribute("MON_SCRAP_WGT");
				
				EDIT_PROD[5][6] = DAY_SCRAP_CNT_B;
				EDIT_PROD[5][7] = MON_SCRAP_CNT_B;
				EDIT_PROD[5][8] = DAY_SCRAP_WGT_B;
				EDIT_PROD[5][9] = MON_SCRAP_WGT_B;
				//中板  7 
				DAY_MISSNO_CNT_B = (String)BRstROW.getAttribute("DAY_MISSNO_CNT");
				MON_MISSNO_CNT_B = (String)BRstROW.getAttribute("MON_MISSNO_CNT");
				DAY_MISSNO_WGT_B = (String)BRstROW.getAttribute("DAY_MISSNO_WGT");
				MON_MISSNO_WGT_B = (String)BRstROW.getAttribute("MON_MISSNO_WGT");
				
				EDIT_PROD[6][6] = DAY_MISSNO_CNT_B;
				EDIT_PROD[6][7] = MON_MISSNO_CNT_B;
				EDIT_PROD[6][8] = DAY_MISSNO_WGT_B;
				EDIT_PROD[6][9] = MON_MISSNO_WGT_B;
				
				//合格率
				if((DAY_GRD_1_WGT_B.doubleValue()+DAY_GRD_2_WGT_B.doubleValue()) != 0){
					DAY_GRD_L_WGT_B = (DAY_GRD_1_WGT_B.doubleValue()/(DAY_GRD_1_WGT_B.doubleValue()+DAY_GRD_2_WGT_B.doubleValue()))*100;	
				}else{
					DAY_GRD_L_WGT_B = 0;
				}
				//保留两位精度
				Double DAY_GRD_L_WGT_B_1 = new Double(new DecimalFormat(".00").format(DAY_GRD_L_WGT_B));
				EDIT_PROD[7][6] = String.valueOf(DAY_GRD_L_WGT_B_1);
				
				
				if((MON_GRD_1_WGT_B.doubleValue()+MON_GRD_2_WGT_B.doubleValue()) != 0){
					MON_GRD_L_WGT_B = (MON_GRD_1_WGT_B.doubleValue()/(MON_GRD_1_WGT_B.doubleValue()+MON_GRD_2_WGT_B.doubleValue()))*100;
				}else{
					MON_GRD_L_WGT_B = 0;
				}
				//保留两位精度
				Double MON_GRD_L_WGT_B_1 = new Double(new DecimalFormat(".00").format(MON_GRD_L_WGT_B));
				EDIT_PROD[7][7] = String.valueOf(MON_GRD_L_WGT_B_1);
				
				//成材率
				if(DAY_SLAB_WGT_B.intValue() != 0){
					DAY_CS_L_WGT_B = (DAY_COIL_WGT_B.doubleValue()/DAY_SLAB_WGT_B.doubleValue())*100;
				}else{
					DAY_CS_L_WGT_B = 0;
				}
				//保留两位精度
				Double DAY_CS_L_WGT_B_1 = new Double(new DecimalFormat(".00").format(DAY_CS_L_WGT_B));
				EDIT_PROD[8][6] = String.valueOf(DAY_CS_L_WGT_B_1);
				
				if(MON_SLAB_WGT_B.intValue() != 0){
					MON_CS_L_WGT_B = (MON_COIL_WGT_B.doubleValue()/MON_SLAB_WGT_B.doubleValue())*100;
				}else{
					MON_CS_L_WGT_B = 0;
				}
				//保留两位精度
				Double MON_CS_L_WGT_B_1 = new Double(new DecimalFormat(".00").format(MON_CS_L_WGT_B));
				EDIT_PROD[8][7] = String.valueOf(MON_CS_L_WGT_B_1);
				
				//非计划（尺寸）  8 
				DAY_SIZE_CNT_B = (String)BRstROW.getAttribute("DAY_SIZE_CNT");
				MON_SIZE_CNT_B = (String)BRstROW.getAttribute("MON_SIZE_CNT");
				DAY_SIZE_WGT_B = (Number)BRstROW.getAttribute("DAY_SIZE_WGT");
				MON_SIZE_WGT_B = (Number)BRstROW.getAttribute("MON_SIZE_WGT");
				
				//第16行
				EDIT_PROD[15][6] = DAY_SIZE_CNT_B;
				EDIT_PROD[15][7] = MON_SIZE_CNT_B;
				EDIT_PROD[15][8] = String.valueOf(DAY_SIZE_WGT_B);
				EDIT_PROD[15][9] = String.valueOf(MON_SIZE_WGT_B);
				
				//非计划（表面）  9 
				DAY_EXTSHAPE_CNT_B = (String)BRstROW.getAttribute("DAY_EXTSHAPE_CNT");
				MON_EXTSHAPE_CNT_B = (String)BRstROW.getAttribute("MON_EXTSHAPE_CNT");
				DAY_EXTSHAPE_WGT_B = (Number)BRstROW.getAttribute("DAY_EXTSHAPE_WGT");
				MON_EXTSHAPE_WGT_B = (Number)BRstROW.getAttribute("MON_EXTSHAPE_WGT");
				
				//第17行
				EDIT_PROD[16][6] = DAY_EXTSHAPE_CNT_B;
				EDIT_PROD[16][7] = MON_EXTSHAPE_CNT_B;
				EDIT_PROD[16][8] = String.valueOf(DAY_EXTSHAPE_WGT_B);
				EDIT_PROD[16][9] = String.valueOf(MON_EXTSHAPE_WGT_B);
				
				//非计划（性能）  10 
				DAY_MATLQLTY_CNT_B = (String)BRstROW.getAttribute("DAY_MATLQLTY_CNT");
				MON_MATLQLTY_CNT_B = (String)BRstROW.getAttribute("MON_MATLQLTY_CNT");
				DAY_MATLQLTY_WGT_B = (Number)BRstROW.getAttribute("DAY_MATLQLTY_WGT");
				MON_MATLQLTY_WGT_B = (Number)BRstROW.getAttribute("MON_MATLQLTY_WGT");
				
				//第18行
				EDIT_PROD[17][6] = DAY_MATLQLTY_CNT_B;
				EDIT_PROD[17][7] = MON_MATLQLTY_CNT_B;
				EDIT_PROD[17][8] = String.valueOf(DAY_MATLQLTY_WGT_B);
				EDIT_PROD[17][9] = String.valueOf(MON_MATLQLTY_WGT_B);
				
				//非计划（钢质）  11 
				DAY_STL_CNT_B = (String)BRstROW.getAttribute("DAY_STL_CNT");
				MON_STL_CNT_B = (String)BRstROW.getAttribute("MON_STL_CNT");
				DAY_STL_WGT_B = (Number)BRstROW.getAttribute("DAY_STL_WGT");
				MON_STL_WGT_B = (Number)BRstROW.getAttribute("MON_STL_WGT");
				
				//第19行
				EDIT_PROD[18][6] = DAY_STL_CNT_B;
				EDIT_PROD[18][7] = MON_STL_CNT_B;
				EDIT_PROD[18][8] = String.valueOf(DAY_STL_WGT_B);
				EDIT_PROD[18][9] = String.valueOf(MON_STL_WGT_B);
				
				//非计划（合计） 12
				DAY_SUM_WGT_B = DAY_SIZE_WGT_B.doubleValue()+DAY_EXTSHAPE_WGT_B.doubleValue()+DAY_MATLQLTY_WGT_B.doubleValue()+DAY_STL_WGT_B.doubleValue();
			
				//保留两位精度
				Double DAY_SUM_WGT_B_1 = new Double(new DecimalFormat(".00").format(DAY_SUM_WGT_B));
				
				MON_SUM_WGT_B = MON_SIZE_WGT_B.doubleValue()+MON_EXTSHAPE_WGT_B.doubleValue()+MON_MATLQLTY_WGT_B.doubleValue()+MON_STL_WGT_B.doubleValue();
				
				//保留两位精度
				Double MON_SUM_WGT_B_1 = new Double(new DecimalFormat(".00").format(MON_SUM_WGT_B));
				
				EDIT_PROD[19][6] = String.valueOf(DAY_SUM_WGT_B_1);
				EDIT_PROD[19][7] = String.valueOf(MON_SUM_WGT_B_1);
			}
			
			//两班的情况，这里求丙的情况
			PosParameter param3 = new PosParameter();
			//这里统计的时候需要给出具体的时间，即统计的时间段精确的YYYYMMDDHHMMSS
			//1
			param3.setWhereClauseParameter(0, "C");
			param3.setWhereClauseParameter(1, PRD_YYYYMM_F[0]);
			param3.setWhereClauseParameter(2, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param3.setWhereClauseParameter(3, "C");
			param3.setWhereClauseParameter(4, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param3.setWhereClauseParameter(5, PRD_YYYYMM_T[0]);
			//2
			param3.setWhereClauseParameter(6, "C");
			param3.setWhereClauseParameter(7, PRD_YYYYMM_F[0]);
			param3.setWhereClauseParameter(8, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param3.setWhereClauseParameter(9, "C");
			param3.setWhereClauseParameter(10, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param3.setWhereClauseParameter(11, PRD_YYYYMM_T[0]);
			//3
			param3.setWhereClauseParameter(12, "C");
			param3.setWhereClauseParameter(13, PRD_YYYYMM_F[0]);
			param3.setWhereClauseParameter(14, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param3.setWhereClauseParameter(15, "C");
			param3.setWhereClauseParameter(16, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param3.setWhereClauseParameter(17, PRD_YYYYMM_T[0]);
			//4
			param3.setWhereClauseParameter(18, "C");
			param3.setWhereClauseParameter(19, PRD_YYYYMM_F[0]);
			param3.setWhereClauseParameter(20, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param3.setWhereClauseParameter(21, "C");
			param3.setWhereClauseParameter(22, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param3.setWhereClauseParameter(23, PRD_YYYYMM_T[0]);
			//5
			param3.setWhereClauseParameter(24, "C");
			param3.setWhereClauseParameter(25, PRD_YYYYMM_F[0]);
			param3.setWhereClauseParameter(26, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param3.setWhereClauseParameter(27, "C");
			param3.setWhereClauseParameter(28, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param3.setWhereClauseParameter(29, PRD_YYYYMM_T[0]);
			//6
			param3.setWhereClauseParameter(30, "C");
			param3.setWhereClauseParameter(31, PRD_YYYYMM_F[0]);
			param3.setWhereClauseParameter(32, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param3.setWhereClauseParameter(33, "C");
			param3.setWhereClauseParameter(34, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param3.setWhereClauseParameter(35, PRD_YYYYMM_T[0]);
			//7
			param3.setWhereClauseParameter(36, "C");
			param3.setWhereClauseParameter(37, PRD_YYYYMM_F[0]);
			param3.setWhereClauseParameter(38, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param3.setWhereClauseParameter(39, "C");
			param3.setWhereClauseParameter(40, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param3.setWhereClauseParameter(41, PRD_YYYYMM_T[0]);
			//8
			param3.setWhereClauseParameter(42, "C");
			param3.setWhereClauseParameter(43, PRD_YYYYMM_F[0]);
			param3.setWhereClauseParameter(44, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param3.setWhereClauseParameter(45, "C");
			param3.setWhereClauseParameter(46, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param3.setWhereClauseParameter(47, PRD_YYYYMM_T[0]);
			//9
			param3.setWhereClauseParameter(48, "C");
			param3.setWhereClauseParameter(49, PRD_YYYYMM_F[0]);
			param3.setWhereClauseParameter(50, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param3.setWhereClauseParameter(51, "C");
			param3.setWhereClauseParameter(52, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param3.setWhereClauseParameter(53, PRD_YYYYMM_T[0]);
			//10
			param3.setWhereClauseParameter(54, "C");
			param3.setWhereClauseParameter(55, PRD_YYYYMM_F[0]);
			param3.setWhereClauseParameter(56, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param3.setWhereClauseParameter(57, "C");
			param3.setWhereClauseParameter(58, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param3.setWhereClauseParameter(59, PRD_YYYYMM_T[0]);
			//11
			param3.setWhereClauseParameter(60, "C");
			param3.setWhereClauseParameter(61, PRD_YYYYMM_F[0]);
			param3.setWhereClauseParameter(62, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param3.setWhereClauseParameter(63, "C");
			param3.setWhereClauseParameter(64, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param3.setWhereClauseParameter(65, PRD_YYYYMM_T[0]);
			
			PosRowSet CRstVO = this.getDao("mesdao").find("UIH090060_06.select", param3);
			
			if(CRstVO.hasNext()){
//					把早班相应的数据赋予丙班
				PosRow CRstROW = CRstVO.next();
				//原料 1
				DAY_SLAB_CNT_C = (String)CRstROW.getAttribute("DAY_SLAB_CNT");
				MON_SLAB_CNT_C = (String)CRstROW.getAttribute("MON_SLAB_CNT");
				DAY_SLAB_WGT_C = (Number)CRstROW.getAttribute("DAY_SLAB_WGT");
				MON_SLAB_WGT_C = (Number)CRstROW.getAttribute("MON_SLAB_WGT");
				
				EDIT_PROD[0][10] = DAY_SLAB_CNT_C;
				EDIT_PROD[0][11] = MON_SLAB_CNT_C;
				EDIT_PROD[0][12] = String.valueOf(DAY_SLAB_WGT_C);
				EDIT_PROD[0][13] = String.valueOf(MON_SLAB_WGT_C);
				//产量  2
				DAY_COIL_CNT_C = (String)CRstROW.getAttribute("DAY_COIL_CNT");
				MON_COIL_CNT_C = (String)CRstROW.getAttribute("MON_COIL_CNT");
				DAY_COIL_WGT_C = (Number)CRstROW.getAttribute("DAY_COIL_WGT");
				MON_COIL_WGT_C = (Number)CRstROW.getAttribute("MON_COIL_WGT");
				
				EDIT_PROD[1][10] = DAY_COIL_CNT_C;
				EDIT_PROD[1][11] = MON_COIL_CNT_C;
				EDIT_PROD[1][12] = String.valueOf(DAY_COIL_WGT_C);
				EDIT_PROD[1][13] = String.valueOf(MON_COIL_WGT_C);
				//合格品  3
				DAY_GRD_1_CNT_C = (String)CRstROW.getAttribute("DAY_GRD_1_CNT");
				MON_GRD_1_CNT_C = (String)CRstROW.getAttribute("MON_GRD_1_CNT");
				DAY_GRD_1_WGT_C = (Number)CRstROW.getAttribute("DAY_GRD_1_WGT");
				MON_GRD_1_WGT_C = (Number)CRstROW.getAttribute("MON_GRD_1_WGT");
				
				EDIT_PROD[2][10] = DAY_GRD_1_CNT_C;
				EDIT_PROD[2][11] = MON_GRD_1_CNT_C;
				EDIT_PROD[2][12] = String.valueOf(DAY_GRD_1_WGT_C);
				EDIT_PROD[2][13] = String.valueOf(MON_GRD_1_WGT_C);
				//次品  4 
				DAY_GRD_2_CNT_C = (String)CRstROW.getAttribute("DAY_GRD_2_CNT");
				MON_GRD_2_CNT_C = (String)CRstROW.getAttribute("MON_GRD_2_CNT");
				DAY_GRD_2_WGT_C = (Number)CRstROW.getAttribute("DAY_GRD_2_WGT");
				MON_GRD_2_WGT_C = (Number)CRstROW.getAttribute("MON_GRD_2_WGT");
				
				EDIT_PROD[3][10] = DAY_GRD_2_CNT_C;
				EDIT_PROD[3][11] = MON_GRD_2_CNT_C;
				EDIT_PROD[3][12] = String.valueOf(DAY_GRD_2_WGT_C);
				EDIT_PROD[3][13] = String.valueOf(MON_GRD_2_WGT_C);
				
				//轧回  5
				DAY_REJ_CNT_C = (String)CRstROW.getAttribute("DAY_REJ_CNT");
				MON_REJ_CNT_C = (String)CRstROW.getAttribute("MON_REJ_CNT");
				DAY_REJ_WGT_C = (String)CRstROW.getAttribute("DAY_REJ_WGT");
				MON_REJ_WGT_C = (String)CRstROW.getAttribute("MON_REJ_WGT");
				
				EDIT_PROD[4][10] = DAY_REJ_CNT_C;
				EDIT_PROD[4][11] = MON_REJ_CNT_C;
				EDIT_PROD[4][12] = DAY_REJ_WGT_C;
				EDIT_PROD[4][13] = MON_REJ_WGT_C;
				//轧废  6 
				DAY_SCRAP_CNT_C = (String)CRstROW.getAttribute("DAY_SCRAP_CNT");
				MON_SCRAP_CNT_C = (String)CRstROW.getAttribute("MON_SCRAP_CNT");
				DAY_SCRAP_WGT_C = (String)CRstROW.getAttribute("DAY_SCRAP_WGT");
				MON_SCRAP_WGT_C = (String)CRstROW.getAttribute("MON_SCRAP_WGT");
				
				EDIT_PROD[5][10] = DAY_SCRAP_CNT_C;
				EDIT_PROD[5][11] = MON_SCRAP_CNT_C;
				EDIT_PROD[5][12] = DAY_SCRAP_WGT_C;
				EDIT_PROD[5][13] = MON_SCRAP_WGT_C;
				//中板  7 
				DAY_MISSNO_CNT_C = (String)CRstROW.getAttribute("DAY_MISSNO_CNT");
				MON_MISSNO_CNT_C = (String)CRstROW.getAttribute("MON_MISSNO_CNT");
				DAY_MISSNO_WGT_C = (String)CRstROW.getAttribute("DAY_MISSNO_WGT");
				MON_MISSNO_WGT_C = (String)CRstROW.getAttribute("MON_MISSNO_WGT");
				
				EDIT_PROD[6][10] = DAY_MISSNO_CNT_C;
				EDIT_PROD[6][11] = MON_MISSNO_CNT_C;
				EDIT_PROD[6][12] = DAY_MISSNO_WGT_C;
				EDIT_PROD[6][13] = MON_MISSNO_WGT_C;
				
				//合格率
				if((DAY_GRD_1_WGT_C.doubleValue()+DAY_GRD_2_WGT_C.doubleValue()) != 0){
					DAY_GRD_L_WGT_C = (DAY_GRD_1_WGT_C.doubleValue()/(DAY_GRD_1_WGT_C.doubleValue()+DAY_GRD_2_WGT_C.doubleValue()))*100;	
				}else{
					DAY_GRD_L_WGT_C = 0;
				}
				//保留两位精度
				Double DAY_GRD_L_WGT_C_1 = new Double(new DecimalFormat(".00").format(DAY_GRD_L_WGT_C));
				EDIT_PROD[7][10] = String.valueOf(DAY_GRD_L_WGT_C_1);
				
				
				if((MON_GRD_1_WGT_C.doubleValue()+MON_GRD_2_WGT_C.doubleValue()) != 0){
					MON_GRD_L_WGT_C = (MON_GRD_1_WGT_C.doubleValue()/(MON_GRD_1_WGT_C.doubleValue()+MON_GRD_2_WGT_C.doubleValue()))*100;
				}else{
					MON_GRD_L_WGT_C = 0;
				}
				//保留两位精度
				Double MON_GRD_L_WGT_C_1 = new Double(new DecimalFormat(".00").format(MON_GRD_L_WGT_C));
				EDIT_PROD[7][11] = String.valueOf(MON_GRD_L_WGT_C_1);
				
				//成材率
				if(DAY_SLAB_WGT_C.intValue() != 0){
					DAY_CS_L_WGT_C = (DAY_COIL_WGT_C.doubleValue()/DAY_SLAB_WGT_C.doubleValue())*100;
				}else{
					DAY_CS_L_WGT_C = 0;
				}
				//保留两位精度
				Double DAY_CS_L_WGT_C_1 = new Double(new DecimalFormat(".00").format(DAY_CS_L_WGT_C));
				EDIT_PROD[8][10] = String.valueOf(DAY_CS_L_WGT_C_1);
				
				if(MON_SLAB_WGT_C.intValue() != 0){
					MON_CS_L_WGT_C = (MON_COIL_WGT_C.doubleValue()/MON_SLAB_WGT_C.doubleValue())*100;
				}else{
					MON_CS_L_WGT_C = 0;
				}
				//保留两位精度
				Double MON_CS_L_WGT_C_1 = new Double(new DecimalFormat(".00").format(MON_CS_L_WGT_C));
				EDIT_PROD[8][11] = String.valueOf(MON_CS_L_WGT_C_1);
				
				//非计划（尺寸）  8 
				DAY_SIZE_CNT_C = (String)CRstROW.getAttribute("DAY_SIZE_CNT");
				MON_SIZE_CNT_C = (String)CRstROW.getAttribute("MON_SIZE_CNT");
				DAY_SIZE_WGT_C = (Number)CRstROW.getAttribute("DAY_SIZE_WGT");
				MON_SIZE_WGT_C = (Number)CRstROW.getAttribute("MON_SIZE_WGT");
				
				//第16行
				EDIT_PROD[15][10] = DAY_SIZE_CNT_C;
				EDIT_PROD[15][11] = MON_SIZE_CNT_C;
				EDIT_PROD[15][12] = String.valueOf(DAY_SIZE_WGT_C);
				EDIT_PROD[15][13] = String.valueOf(MON_SIZE_WGT_C);
				
				//非计划（表面）  9 
				DAY_EXTSHAPE_CNT_C = (String)CRstROW.getAttribute("DAY_EXTSHAPE_CNT");
				MON_EXTSHAPE_CNT_C = (String)CRstROW.getAttribute("MON_EXTSHAPE_CNT");
				DAY_EXTSHAPE_WGT_C = (Number)CRstROW.getAttribute("DAY_EXTSHAPE_WGT");
				MON_EXTSHAPE_WGT_C = (Number)CRstROW.getAttribute("MON_EXTSHAPE_WGT");
				
				//第17行
				EDIT_PROD[16][10] = DAY_EXTSHAPE_CNT_C;
				EDIT_PROD[16][11] = MON_EXTSHAPE_CNT_C;
				EDIT_PROD[16][12] = String.valueOf(DAY_EXTSHAPE_WGT_C);
				EDIT_PROD[16][13] = String.valueOf(MON_EXTSHAPE_WGT_C);
				
				//非计划（性能）  10 
				DAY_MATLQLTY_CNT_C = (String)CRstROW.getAttribute("DAY_MATLQLTY_CNT");
				MON_MATLQLTY_CNT_C = (String)CRstROW.getAttribute("MON_MATLQLTY_CNT");
				DAY_MATLQLTY_WGT_C = (Number)CRstROW.getAttribute("DAY_MATLQLTY_WGT");
				MON_MATLQLTY_WGT_C = (Number)CRstROW.getAttribute("MON_MATLQLTY_WGT");
				
				//第18行
				EDIT_PROD[17][10] = DAY_MATLQLTY_CNT_C;
				EDIT_PROD[17][11] = MON_MATLQLTY_CNT_C;
				EDIT_PROD[17][12] = String.valueOf(DAY_MATLQLTY_WGT_C);
				EDIT_PROD[17][13] = String.valueOf(MON_MATLQLTY_WGT_C);
				
				//非计划（钢质）  11 
				DAY_STL_CNT_C = (String)CRstROW.getAttribute("DAY_STL_CNT");
				MON_STL_CNT_C = (String)CRstROW.getAttribute("MON_STL_CNT");
				DAY_STL_WGT_C = (Number)CRstROW.getAttribute("DAY_STL_WGT");
				MON_STL_WGT_C = (Number)CRstROW.getAttribute("MON_STL_WGT");
				
				//第19行
				EDIT_PROD[18][10] = DAY_STL_CNT_C;
				EDIT_PROD[18][11] = MON_STL_CNT_C;
				EDIT_PROD[18][12] = String.valueOf(DAY_STL_WGT_C);
				EDIT_PROD[18][13] = String.valueOf(MON_STL_WGT_C);
				
				//非计划（合计） 12
				DAY_SUM_WGT_C = DAY_SIZE_WGT_C.doubleValue()+DAY_EXTSHAPE_WGT_C.doubleValue()+DAY_MATLQLTY_WGT_C.doubleValue()+DAY_STL_WGT_C.doubleValue();
			
				//保留两位精度
				Double DAY_SUM_WGT_C_1 = new Double(new DecimalFormat(".00").format(DAY_SUM_WGT_C));
				
				MON_SUM_WGT_C = MON_SIZE_WGT_C.doubleValue()+MON_EXTSHAPE_WGT_C.doubleValue()+MON_MATLQLTY_WGT_C.doubleValue()+MON_STL_WGT_C.doubleValue();
				
				//保留两位精度
				Double MON_SUM_WGT_C_1 = new Double(new DecimalFormat(".00").format(MON_SUM_WGT_C));
				
				EDIT_PROD[19][10] = String.valueOf(DAY_SUM_WGT_C_1);
				EDIT_PROD[19][11] = String.valueOf(MON_SUM_WGT_C_1);
			}
			
			//这里是早班为丁班的情况
			PosParameter param5 = new PosParameter();
			//这里统计的时候需要给出具体的时间，即统计的时间段精确的YYYYMMDDHHMMSS
			//1
			param5.setWhereClauseParameter(0, "D");
			param5.setWhereClauseParameter(1, PRD_YYYYMM_F[0]);
			param5.setWhereClauseParameter(2, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param5.setWhereClauseParameter(3, "D");
			param5.setWhereClauseParameter(4, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param5.setWhereClauseParameter(5, PRD_YYYYMM_T[0]);
			//2
			param5.setWhereClauseParameter(6, "D");
			param5.setWhereClauseParameter(7, PRD_YYYYMM_F[0]);
			param5.setWhereClauseParameter(8, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param5.setWhereClauseParameter(9, "D");
			param5.setWhereClauseParameter(10, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param5.setWhereClauseParameter(11, PRD_YYYYMM_T[0]);
			//3
			param5.setWhereClauseParameter(12, "D");
			param5.setWhereClauseParameter(13, PRD_YYYYMM_F[0]);
			param5.setWhereClauseParameter(14, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param5.setWhereClauseParameter(15, "D");
			param5.setWhereClauseParameter(16, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param5.setWhereClauseParameter(17, PRD_YYYYMM_T[0]);
			//4
			param5.setWhereClauseParameter(18, "D");
			param5.setWhereClauseParameter(19, PRD_YYYYMM_F[0]);
			param5.setWhereClauseParameter(20, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param5.setWhereClauseParameter(21, "D");
			param5.setWhereClauseParameter(22, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param5.setWhereClauseParameter(23, PRD_YYYYMM_T[0]);
			//5
			param5.setWhereClauseParameter(24, "D");
			param5.setWhereClauseParameter(25, PRD_YYYYMM_F[0]);
			param5.setWhereClauseParameter(26, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param5.setWhereClauseParameter(27, "D");
			param5.setWhereClauseParameter(28, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param5.setWhereClauseParameter(29, PRD_YYYYMM_T[0]);
			//6
			param5.setWhereClauseParameter(30, "D");
			param5.setWhereClauseParameter(31, PRD_YYYYMM_F[0]);
			param5.setWhereClauseParameter(32, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param5.setWhereClauseParameter(33, "D");
			param5.setWhereClauseParameter(34, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param5.setWhereClauseParameter(35, PRD_YYYYMM_T[0]);
			//7
			param5.setWhereClauseParameter(36, "D");
			param5.setWhereClauseParameter(37, PRD_YYYYMM_F[0]);
			param5.setWhereClauseParameter(38, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param5.setWhereClauseParameter(39, "D");
			param5.setWhereClauseParameter(40, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param5.setWhereClauseParameter(41, PRD_YYYYMM_T[0]);
			//8
			param5.setWhereClauseParameter(42, "D");
			param5.setWhereClauseParameter(43, PRD_YYYYMM_F[0]);
			param5.setWhereClauseParameter(44, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param5.setWhereClauseParameter(45, "D");
			param5.setWhereClauseParameter(46, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param5.setWhereClauseParameter(47, PRD_YYYYMM_T[0]);
			//9
			param5.setWhereClauseParameter(48, "D");
			param5.setWhereClauseParameter(49, PRD_YYYYMM_F[0]);
			param5.setWhereClauseParameter(50, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param5.setWhereClauseParameter(51, "D");
			param5.setWhereClauseParameter(52, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param5.setWhereClauseParameter(53, PRD_YYYYMM_T[0]);
			//10
			param5.setWhereClauseParameter(54, "D");
			param5.setWhereClauseParameter(55, PRD_YYYYMM_F[0]);
			param5.setWhereClauseParameter(56, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param5.setWhereClauseParameter(57, "D");
			param5.setWhereClauseParameter(58, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param5.setWhereClauseParameter(59, PRD_YYYYMM_T[0]);
			//11
			param5.setWhereClauseParameter(60, "D");
			param5.setWhereClauseParameter(61, PRD_YYYYMM_F[0]);
			param5.setWhereClauseParameter(62, PRD_YYYYMM_T[0]);
			
			//每个月的开始那天
			param5.setWhereClauseParameter(63, "D");
			param5.setWhereClauseParameter(64, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param5.setWhereClauseParameter(65, PRD_YYYYMM_T[0]);
			
			PosRowSet DRstVO = this.getDao("mesdao").find("UIH090060_06.select", param5);
			
			if(DRstVO.hasNext()){
//				把早班相应的数据赋予丁班
				PosRow DRstROW = DRstVO.next();
				//原料 1
				DAY_SLAB_CNT_D = (String)DRstROW.getAttribute("DAY_SLAB_CNT");
				MON_SLAB_CNT_D = (String)DRstROW.getAttribute("MON_SLAB_CNT");
				DAY_SLAB_WGT_D = (Number)DRstROW.getAttribute("DAY_SLAB_WGT");
				MON_SLAB_WGT_D = (Number)DRstROW.getAttribute("MON_SLAB_WGT");
				
				EDIT_PROD[0][14] = DAY_SLAB_CNT_D;
				EDIT_PROD[0][15] = MON_SLAB_CNT_D;
				EDIT_PROD[0][16] = String.valueOf(DAY_SLAB_WGT_D);
				EDIT_PROD[0][17] = String.valueOf(MON_SLAB_WGT_D);
				//产量  2
				DAY_COIL_CNT_D = (String)DRstROW.getAttribute("DAY_COIL_CNT");
				MON_COIL_CNT_D = (String)DRstROW.getAttribute("MON_COIL_CNT");
				DAY_COIL_WGT_D = (Number)DRstROW.getAttribute("DAY_COIL_WGT");
				MON_COIL_WGT_D = (Number)DRstROW.getAttribute("MON_COIL_WGT");
				
				EDIT_PROD[1][14] = DAY_COIL_CNT_D;
				EDIT_PROD[1][15] = MON_COIL_CNT_D;
				EDIT_PROD[1][16] = String.valueOf(DAY_COIL_WGT_D);
				EDIT_PROD[1][17] = String.valueOf(MON_COIL_WGT_D);
				//合格品  3
				DAY_GRD_1_CNT_D = (String)DRstROW.getAttribute("DAY_GRD_1_CNT");
				MON_GRD_1_CNT_D = (String)DRstROW.getAttribute("MON_GRD_1_CNT");
				DAY_GRD_1_WGT_D = (Number)DRstROW.getAttribute("DAY_GRD_1_WGT");
				MON_GRD_1_WGT_D = (Number)DRstROW.getAttribute("MON_GRD_1_WGT");
				
				EDIT_PROD[2][14] = DAY_GRD_1_CNT_D;
				EDIT_PROD[2][15] = MON_GRD_1_CNT_D;
				EDIT_PROD[2][16] = String.valueOf(DAY_GRD_1_WGT_D);
				EDIT_PROD[2][17] = String.valueOf(MON_GRD_1_WGT_D);
				//次品  4 
				DAY_GRD_2_CNT_D = (String)DRstROW.getAttribute("DAY_GRD_2_CNT");
				MON_GRD_2_CNT_D = (String)DRstROW.getAttribute("MON_GRD_2_CNT");
				DAY_GRD_2_WGT_D = (Number)DRstROW.getAttribute("DAY_GRD_2_WGT");
				MON_GRD_2_WGT_D = (Number)DRstROW.getAttribute("MON_GRD_2_WGT");
				
				EDIT_PROD[3][14] = DAY_GRD_2_CNT_D;
				EDIT_PROD[3][15] = MON_GRD_2_CNT_D;
				EDIT_PROD[3][16] = String.valueOf(DAY_GRD_2_WGT_D);
				EDIT_PROD[3][17] = String.valueOf(MON_GRD_2_WGT_D);
				
				//轧回  5
				DAY_REJ_CNT_D = (String)DRstROW.getAttribute("DAY_REJ_CNT");
				MON_REJ_CNT_D = (String)DRstROW.getAttribute("MON_REJ_CNT");
				DAY_REJ_WGT_D = (String)DRstROW.getAttribute("DAY_REJ_WGT");
				MON_REJ_WGT_D = (String)DRstROW.getAttribute("MON_REJ_WGT");
				
				EDIT_PROD[4][14] = DAY_REJ_CNT_D;
				EDIT_PROD[4][15] = MON_REJ_CNT_D;
				EDIT_PROD[4][16] = DAY_REJ_WGT_D;
				EDIT_PROD[4][17] = MON_REJ_WGT_D;
				//轧废  6 
				DAY_SCRAP_CNT_D = (String)DRstROW.getAttribute("DAY_SCRAP_CNT");
				MON_SCRAP_CNT_D = (String)DRstROW.getAttribute("MON_SCRAP_CNT");
				DAY_SCRAP_WGT_D = (String)DRstROW.getAttribute("DAY_SCRAP_WGT");
				MON_SCRAP_WGT_D = (String)DRstROW.getAttribute("MON_SCRAP_WGT");
				
				EDIT_PROD[5][14] = DAY_SCRAP_CNT_D;
				EDIT_PROD[5][15] = MON_SCRAP_CNT_D;
				EDIT_PROD[5][16] = DAY_SCRAP_WGT_D;
				EDIT_PROD[5][17] = MON_SCRAP_WGT_D;
				//中板  7 
				DAY_MISSNO_CNT_D = (String)DRstROW.getAttribute("DAY_MISSNO_CNT");
				MON_MISSNO_CNT_D = (String)DRstROW.getAttribute("MON_MISSNO_CNT");
				DAY_MISSNO_WGT_D = (String)DRstROW.getAttribute("DAY_MISSNO_WGT");
				MON_MISSNO_WGT_D = (String)DRstROW.getAttribute("MON_MISSNO_WGT");
				
				EDIT_PROD[6][14] = DAY_MISSNO_CNT_D;
				EDIT_PROD[6][15] = MON_MISSNO_CNT_D;
				EDIT_PROD[6][16] = DAY_MISSNO_WGT_D;
				EDIT_PROD[6][17] = MON_MISSNO_WGT_D;
				
				//合格率
				if((DAY_GRD_1_WGT_D.doubleValue()+DAY_GRD_2_WGT_D.doubleValue()) != 0){
					DAY_GRD_L_WGT_D = (DAY_GRD_1_WGT_D.doubleValue()/(DAY_GRD_1_WGT_D.doubleValue()+DAY_GRD_2_WGT_D.doubleValue()))*100;	
				}else{
					DAY_GRD_L_WGT_D = 0;
				}
				//保留两位精度
				Double DAY_GRD_L_WGT_D_1 = new Double(new DecimalFormat(".00").format(DAY_GRD_L_WGT_D));
				EDIT_PROD[7][14] = String.valueOf(DAY_GRD_L_WGT_D_1);
				
				
				if((MON_GRD_1_WGT_D.doubleValue()+MON_GRD_2_WGT_D.doubleValue()) != 0){
					MON_GRD_L_WGT_D = (MON_GRD_1_WGT_D.doubleValue()/(MON_GRD_1_WGT_D.doubleValue()+MON_GRD_2_WGT_D.doubleValue()))*100;
				}else{
					MON_GRD_L_WGT_D = 0;
				}
				//保留两位精度
				Double MON_GRD_L_WGT_D_1 = new Double(new DecimalFormat(".00").format(MON_GRD_L_WGT_D));
				EDIT_PROD[7][15] = String.valueOf(MON_GRD_L_WGT_D_1);
				
				//成材率
				if(DAY_SLAB_WGT_D.intValue() != 0){
					DAY_CS_L_WGT_D = (DAY_COIL_WGT_D.doubleValue()/DAY_SLAB_WGT_D.doubleValue())*100;
				}else{
					DAY_CS_L_WGT_D = 0;
				}
				//保留两位精度
				Double DAY_CS_L_WGT_D_1 = new Double(new DecimalFormat(".00").format(DAY_CS_L_WGT_D));
				EDIT_PROD[8][14] = String.valueOf(DAY_CS_L_WGT_D_1);
				
				if(MON_SLAB_WGT_D.intValue() != 0){
					MON_CS_L_WGT_D = (MON_COIL_WGT_D.doubleValue()/MON_SLAB_WGT_D.doubleValue())*100;
				}else{
					MON_CS_L_WGT_D = 0;
				}
				//保留两位精度
				Double MON_CS_L_WGT_D_1 = new Double(new DecimalFormat(".00").format(MON_CS_L_WGT_D));
				EDIT_PROD[8][15] = String.valueOf(MON_CS_L_WGT_D_1);
				
				//非计划（尺寸）  8 
				DAY_SIZE_CNT_D = (String)DRstROW.getAttribute("DAY_SIZE_CNT");
				MON_SIZE_CNT_D = (String)DRstROW.getAttribute("MON_SIZE_CNT");
				DAY_SIZE_WGT_D = (Number)DRstROW.getAttribute("DAY_SIZE_WGT");
				MON_SIZE_WGT_D = (Number)DRstROW.getAttribute("MON_SIZE_WGT");
				
				//第16行
				EDIT_PROD[15][14] = DAY_SIZE_CNT_D;
				EDIT_PROD[15][15] = MON_SIZE_CNT_D;
				EDIT_PROD[15][16] = String.valueOf(DAY_SIZE_WGT_D);
				EDIT_PROD[15][17] = String.valueOf(MON_SIZE_WGT_D);
				
				//非计划（表面）  9 
				DAY_EXTSHAPE_CNT_D = (String)DRstROW.getAttribute("DAY_EXTSHAPE_CNT");
				MON_EXTSHAPE_CNT_D = (String)DRstROW.getAttribute("MON_EXTSHAPE_CNT");
				DAY_EXTSHAPE_WGT_D = (Number)DRstROW.getAttribute("DAY_EXTSHAPE_WGT");
				MON_EXTSHAPE_WGT_D = (Number)DRstROW.getAttribute("MON_EXTSHAPE_WGT");
				
				//第17行
				EDIT_PROD[16][14] = DAY_EXTSHAPE_CNT_D;
				EDIT_PROD[16][15] = MON_EXTSHAPE_CNT_D;
				EDIT_PROD[16][16] = String.valueOf(DAY_EXTSHAPE_WGT_D);
				EDIT_PROD[16][17] = String.valueOf(MON_EXTSHAPE_WGT_D);
				
				//非计划（性能）  10 
				DAY_MATLQLTY_CNT_D = (String)DRstROW.getAttribute("DAY_MATLQLTY_CNT");
				MON_MATLQLTY_CNT_D = (String)DRstROW.getAttribute("MON_MATLQLTY_CNT");
				DAY_MATLQLTY_WGT_D = (Number)DRstROW.getAttribute("DAY_MATLQLTY_WGT");
				MON_MATLQLTY_WGT_D = (Number)DRstROW.getAttribute("MON_MATLQLTY_WGT");
				
				//第18行
				EDIT_PROD[17][14] = DAY_MATLQLTY_CNT_D;
				EDIT_PROD[17][15] = MON_MATLQLTY_CNT_D;
				EDIT_PROD[17][16] = String.valueOf(DAY_MATLQLTY_WGT_D);
				EDIT_PROD[17][17] = String.valueOf(MON_MATLQLTY_WGT_D);
				
				//非计划（钢质）  11 
				DAY_STL_CNT_D = (String)DRstROW.getAttribute("DAY_STL_CNT");
				MON_STL_CNT_D = (String)DRstROW.getAttribute("MON_STL_CNT");
				DAY_STL_WGT_D = (Number)DRstROW.getAttribute("DAY_STL_WGT");
				MON_STL_WGT_D = (Number)DRstROW.getAttribute("MON_STL_WGT");
				
				//第19行
				EDIT_PROD[18][14] = DAY_STL_CNT_D;
				EDIT_PROD[18][15] = MON_STL_CNT_D;
				EDIT_PROD[18][16] = String.valueOf(DAY_STL_WGT_D);
				EDIT_PROD[18][17] = String.valueOf(MON_STL_WGT_D);
				
				//非计划（合计） 12
				DAY_SUM_WGT_D = DAY_SIZE_WGT_D.doubleValue()+DAY_EXTSHAPE_WGT_D.doubleValue()+DAY_MATLQLTY_WGT_D.doubleValue()+DAY_STL_WGT_D.doubleValue();
			
				//保留两位精度
				Double DAY_SUM_WGT_D_1 = new Double(new DecimalFormat(".00").format(DAY_SUM_WGT_D));
				
				MON_SUM_WGT_D = MON_SIZE_WGT_D.doubleValue()+MON_EXTSHAPE_WGT_D.doubleValue()+MON_MATLQLTY_WGT_D.doubleValue()+MON_STL_WGT_D.doubleValue();
				
				//保留两位精度
				Double MON_SUM_WGT_D_1 = new Double(new DecimalFormat(".00").format(MON_SUM_WGT_D));
				
				EDIT_PROD[19][14] = String.valueOf(DAY_SUM_WGT_D_1);
				EDIT_PROD[19][15] = String.valueOf(MON_SUM_WGT_D_1);
			}
			
		    //这里三班，今天的产量是昨天晚班的开始到今天早班的结束
			//这里是三班的情况，中班为空,对于全天产量的统计是昨天的晚班开始时间到今天早班的结束时间
			//获取全天原料、产量、合格品、次品、待判定、中板、轧回、废品
			//原料  1
			String DAY_SLAB_CNT = null;
			String MON_SLAB_CNT = null;
			Number DAY_SLAB_WGT = null;
			Number MON_SLAB_WGT = null;
			//产品  2
			String DAY_COIL_CNT = null;
			String MON_COIL_CNT = null;
			Number DAY_COIL_WGT = null;
			Number MON_COIL_WGT = null;
			//合格品  3
			String DAY_GRD_1_CNT = null;
			String MON_GRD_1_CNT = null;
			Number DAY_GRD_1_WGT;
			Number MON_GRD_1_WGT;
			//次品  4
			String DAY_GRD_2_CNT = null;
			String MON_GRD_2_CNT = null;
			Number DAY_GRD_2_WGT;
			Number MON_GRD_2_WGT;
			//轧回  5
			String DAY_REJ_CNT = null;
			String MON_REJ_CNT = null;
			String DAY_REJ_WGT = null;
			String MON_REJ_WGT = null;
			//轧废  6
			String DAY_SCRAP_CNT = null;
			String MON_SCRAP_CNT = null;
			String DAY_SCRAP_WGT = null;
			String MON_SCRAP_WGT = null;
			//中板  7
			String DAY_MISSNO_CNT = null;
			String MON_MISSNO_CNT = null;
			String DAY_MISSNO_WGT = null;
			String MON_MISSNO_WGT = null;
			
			//合格率 8
			double DAY_GRD_L_WGT;
			double MON_GRD_L_WGT;
			
			//成材率
			double DAYS_L_WGT;
			double MONS_L_WGT;
			
			//非计划吨（尺寸）  16
			String DAY_SIZE_CNT = null;
			String MON_SIZE_CNT = null;
			Number DAY_SIZE_WGT = null;
			Number MON_SIZE_WGT = null;
			//非计划吨（表面）  17
			String DAY_EXTSHAPE_CNT = null;
			String MON_EXTSHAPE_CNT = null;
			Number DAY_EXTSHAPE_WGT = null;
			Number MON_EXTSHAPE_WGT = null;
			//非计划吨（性能）  18
			String DAY_MATLQLTY_CNT = null;
			String MON_MATLQLTY_CNT = null;
			Number DAY_MATLQLTY_WGT = null;
			Number MON_MATLQLTY_WGT = null;
			//非计划吨（钢质）  19
			String DAY_STL_CNT = null;
			String MON_STL_CNT = null;
			Number DAY_STL_WGT = null;
			Number MON_STL_WGT = null;
			
			//非计划（合计）  20
			double DAY_SUM_WGT;
			double MON_SUM_WGT;	
	
	
			
			//通过查询语句，获取所需要的相关数据
			PosParameter param4 = new PosParameter();
			//1
			param4.setWhereClauseParameter(0, PRD_YYYYMM_F[0]);
			param4.setWhereClauseParameter(1, PRD_YYYYMM_T[0]);
			
			param4.setWhereClauseParameter(2, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param4.setWhereClauseParameter(3, PRD_YYYYMM_T[0]);
	
			//2
			param4.setWhereClauseParameter(4, PRD_YYYYMM_F[0]);
			param4.setWhereClauseParameter(5, PRD_YYYYMM_T[0]);
			
			param4.setWhereClauseParameter(6, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param4.setWhereClauseParameter(7, PRD_YYYYMM_T[0]);
			//3
			param4.setWhereClauseParameter(8, PRD_YYYYMM_F[0]);
			param4.setWhereClauseParameter(9, PRD_YYYYMM_T[0]);
			
			param4.setWhereClauseParameter(10, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param4.setWhereClauseParameter(11, PRD_YYYYMM_T[0]);
			//4
			param4.setWhereClauseParameter(12, PRD_YYYYMM_F[0]);
			param4.setWhereClauseParameter(13, PRD_YYYYMM_T[0]);
			
			param4.setWhereClauseParameter(14, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param4.setWhereClauseParameter(15, PRD_YYYYMM_T[0]);
			//5
			param4.setWhereClauseParameter(16, PRD_YYYYMM_F[0]);
			param4.setWhereClauseParameter(17, PRD_YYYYMM_T[0]);
			
			param4.setWhereClauseParameter(18, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param4.setWhereClauseParameter(19, PRD_YYYYMM_T[0]);
			//6
			param4.setWhereClauseParameter(20, PRD_YYYYMM_F[0]);
			param4.setWhereClauseParameter(21, PRD_YYYYMM_T[0]);
			
			param4.setWhereClauseParameter(22, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param4.setWhereClauseParameter(23, PRD_YYYYMM_T[0]);
			//7
			param4.setWhereClauseParameter(24, PRD_YYYYMM_F[0]);
			param4.setWhereClauseParameter(25, PRD_YYYYMM_T[0]);
			
			param4.setWhereClauseParameter(26, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param4.setWhereClauseParameter(27, PRD_YYYYMM_T[0]);
			//8
			param4.setWhereClauseParameter(28, PRD_YYYYMM_F[0]);
			param4.setWhereClauseParameter(29, PRD_YYYYMM_T[0]);
			
			param4.setWhereClauseParameter(30, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param4.setWhereClauseParameter(31, PRD_YYYYMM_T[0]);
			//9
			param4.setWhereClauseParameter(32, PRD_YYYYMM_F[0]);
			param4.setWhereClauseParameter(33, PRD_YYYYMM_T[0]);
			
			param4.setWhereClauseParameter(34, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param4.setWhereClauseParameter(35, PRD_YYYYMM_T[0]);
			//10
			param4.setWhereClauseParameter(36, PRD_YYYYMM_F[0]);
			param4.setWhereClauseParameter(37, PRD_YYYYMM_T[0]);
			
			param4.setWhereClauseParameter(38, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param4.setWhereClauseParameter(39, PRD_YYYYMM_T[0]);
			//11
			param4.setWhereClauseParameter(40, PRD_YYYYMM_F[0]);
			param4.setWhereClauseParameter(41, PRD_YYYYMM_T[0]);
			
			param4.setWhereClauseParameter(42, PRD_YYYYMM_T[0].substring(0, 6)+"01000000");
			param4.setWhereClauseParameter(43, PRD_YYYYMM_T[0]);
	
			PosRowSet RstVO = this.getDao("mesdao").find("UIH090060_05.select", param4);
			
			if(RstVO.hasNext()){
				//获取全天的相应数据
				PosRow RstROW = RstVO.next();
				//原料 1
				DAY_SLAB_CNT = (String)RstROW.getAttribute("DAY_SLAB_CNT");
				MON_SLAB_CNT = (String)RstROW.getAttribute("MON_SLAB_CNT");
				DAY_SLAB_WGT = (Number)RstROW.getAttribute("DAY_SLAB_WGT");
				MON_SLAB_WGT = (Number)RstROW.getAttribute("MON_SLAB_WGT");
				
				EDIT_PROD[0][18] = DAY_SLAB_CNT;
				EDIT_PROD[0][19] = MON_SLAB_CNT;
				EDIT_PROD[0][20] = String.valueOf(DAY_SLAB_WGT);
				EDIT_PROD[0][21] = String.valueOf(MON_SLAB_WGT);
				//产量  2
				DAY_COIL_CNT = (String)RstROW.getAttribute("DAY_COIL_CNT");
				MON_COIL_CNT = (String)RstROW.getAttribute("MON_COIL_CNT");
				DAY_COIL_WGT = (Number)RstROW.getAttribute("DAY_COIL_WGT");
				MON_COIL_WGT = (Number)RstROW.getAttribute("MON_COIL_WGT");
				
				EDIT_PROD[1][18] = DAY_COIL_CNT;
				EDIT_PROD[1][19] = MON_COIL_CNT;
				EDIT_PROD[1][20] = String.valueOf(DAY_COIL_WGT);
				EDIT_PROD[1][21] = String.valueOf(MON_COIL_WGT);
				//合格品  3
				DAY_GRD_1_CNT = (String)RstROW.getAttribute("DAY_GRD_1_CNT");
				MON_GRD_1_CNT = (String)RstROW.getAttribute("MON_GRD_1_CNT");
				DAY_GRD_1_WGT = (Number)RstROW.getAttribute("DAY_GRD_1_WGT");
				MON_GRD_1_WGT = (Number)RstROW.getAttribute("MON_GRD_1_WGT");
				
				EDIT_PROD[2][18] = DAY_GRD_1_CNT;
				EDIT_PROD[2][19] = MON_GRD_1_CNT;
				EDIT_PROD[2][20] = String.valueOf(DAY_GRD_1_WGT);
				EDIT_PROD[2][21] = String.valueOf(MON_GRD_1_WGT);
				//次品  4 
				DAY_GRD_2_CNT = (String)RstROW.getAttribute("DAY_GRD_2_CNT");
				MON_GRD_2_CNT = (String)RstROW.getAttribute("MON_GRD_2_CNT");
				DAY_GRD_2_WGT = (Number)RstROW.getAttribute("DAY_GRD_2_WGT");
				MON_GRD_2_WGT = (Number)RstROW.getAttribute("MON_GRD_2_WGT");
				
				EDIT_PROD[3][18] = DAY_GRD_2_CNT;
				EDIT_PROD[3][19] = MON_GRD_2_CNT;
				EDIT_PROD[3][20] = String.valueOf(DAY_GRD_2_WGT);
				EDIT_PROD[3][21] = String.valueOf(MON_GRD_2_WGT);
				
				//轧回  5
				DAY_REJ_CNT = (String)RstROW.getAttribute("DAY_REJ_CNT");
				MON_REJ_CNT = (String)RstROW.getAttribute("MON_REJ_CNT");
				DAY_REJ_WGT = (String)RstROW.getAttribute("DAY_REJ_WGT");
				MON_REJ_WGT = (String)RstROW.getAttribute("MON_REJ_WGT");
				
				EDIT_PROD[4][18] = DAY_REJ_CNT;
				EDIT_PROD[4][19] = MON_REJ_CNT;
				EDIT_PROD[4][20] = DAY_REJ_WGT;
				EDIT_PROD[4][21] = MON_REJ_WGT;
				//轧废  6 
				DAY_SCRAP_CNT = (String)RstROW.getAttribute("DAY_SCRAP_CNT");
				MON_SCRAP_CNT = (String)RstROW.getAttribute("MON_SCRAP_CNT");
				DAY_SCRAP_WGT = (String)RstROW.getAttribute("DAY_SCRAP_WGT");
				MON_SCRAP_WGT = (String)RstROW.getAttribute("MON_SCRAP_WGT");
				
				EDIT_PROD[5][18] = DAY_SCRAP_CNT;
				EDIT_PROD[5][19] = MON_SCRAP_CNT;
				EDIT_PROD[5][20] = DAY_SCRAP_WGT;
				EDIT_PROD[5][21] = MON_SCRAP_WGT;
				//中板  7 
				DAY_MISSNO_CNT = (String)RstROW.getAttribute("DAY_MISSNO_CNT");
				MON_MISSNO_CNT = (String)RstROW.getAttribute("MON_MISSNO_CNT");
				DAY_MISSNO_WGT = (String)RstROW.getAttribute("DAY_MISSNO_WGT");
				MON_MISSNO_WGT = (String)RstROW.getAttribute("MON_MISSNO_WGT");
				
				EDIT_PROD[6][18] = DAY_MISSNO_CNT;
				EDIT_PROD[6][19] = MON_MISSNO_CNT;
				EDIT_PROD[6][20] = DAY_MISSNO_WGT;
				EDIT_PROD[6][21] = MON_MISSNO_WGT;
				
				//合格率
				if((DAY_GRD_1_WGT.doubleValue()+DAY_GRD_2_WGT.doubleValue()) != 0){
					DAY_GRD_L_WGT = (DAY_GRD_1_WGT.doubleValue()/(DAY_GRD_1_WGT.doubleValue()+DAY_GRD_2_WGT.doubleValue()))*100;	
				}else{
					DAY_GRD_L_WGT = 0;
				}
				//保留两位精度
				Double DAY_GRD_L_WGT_1 = new Double(new DecimalFormat(".00").format(DAY_GRD_L_WGT));
				EDIT_PROD[7][18] = String.valueOf(DAY_GRD_L_WGT_1);
				
				
				if((MON_GRD_1_WGT.doubleValue()+MON_GRD_2_WGT.doubleValue()) != 0){
					MON_GRD_L_WGT = (MON_GRD_1_WGT.doubleValue()/(MON_GRD_1_WGT.doubleValue()+MON_GRD_2_WGT.doubleValue()))*100;
				}else{
					MON_GRD_L_WGT = 0;
				}
				//保留两位精度
				Double MON_GRD_L_WGT_1 = new Double(new DecimalFormat(".00").format(MON_GRD_L_WGT));
				EDIT_PROD[7][19] = String.valueOf(MON_GRD_L_WGT_1);
				
				//成材率
				if(DAY_SLAB_WGT.intValue() != 0){
					DAYS_L_WGT = (DAY_COIL_WGT.doubleValue()/DAY_SLAB_WGT.doubleValue())*100;
				}else{
					DAYS_L_WGT = 0;
				}
				//保留两位精度
				Double DAYS_L_WGT_1 = new Double(new DecimalFormat(".00").format(DAYS_L_WGT));
				EDIT_PROD[8][18] = String.valueOf(DAYS_L_WGT_1);
				
				if(MON_SLAB_WGT.intValue() != 0){
					MONS_L_WGT = (MON_COIL_WGT.doubleValue()/MON_SLAB_WGT.doubleValue())*100;
				}else{
					MONS_L_WGT = 0;
				}
				//保留两位精度
				Double MONS_L_WGT_1 = new Double(new DecimalFormat(".00").format(MONS_L_WGT));
				EDIT_PROD[8][19] = String.valueOf(MONS_L_WGT_1);
				
				//非计划（尺寸）  8 
				DAY_SIZE_CNT = (String)RstROW.getAttribute("DAY_SIZE_CNT");
				MON_SIZE_CNT = (String)RstROW.getAttribute("MON_SIZE_CNT");
				DAY_SIZE_WGT = (Number)RstROW.getAttribute("DAY_SIZE_WGT");
				MON_SIZE_WGT = (Number)RstROW.getAttribute("MON_SIZE_WGT");
				
				//第16行
				EDIT_PROD[15][18] = DAY_SIZE_CNT;
				EDIT_PROD[15][19] = MON_SIZE_CNT;
				EDIT_PROD[15][20] = String.valueOf(DAY_SIZE_WGT);
				EDIT_PROD[15][21] = String.valueOf(MON_SIZE_WGT);
				
				//非计划（表面）  9 
				DAY_EXTSHAPE_CNT = (String)RstROW.getAttribute("DAY_EXTSHAPE_CNT");
				MON_EXTSHAPE_CNT = (String)RstROW.getAttribute("MON_EXTSHAPE_CNT");
				DAY_EXTSHAPE_WGT = (Number)RstROW.getAttribute("DAY_EXTSHAPE_WGT");
				MON_EXTSHAPE_WGT = (Number)RstROW.getAttribute("MON_EXTSHAPE_WGT");
				
				//第17行
				EDIT_PROD[16][18] = DAY_EXTSHAPE_CNT;
				EDIT_PROD[16][19] = MON_EXTSHAPE_CNT;
				EDIT_PROD[16][20] = String.valueOf(DAY_EXTSHAPE_WGT);
				EDIT_PROD[16][21] = String.valueOf(MON_EXTSHAPE_WGT);
				
				//非计划（性能）  10 
				DAY_MATLQLTY_CNT = (String)RstROW.getAttribute("DAY_MATLQLTY_CNT");
				MON_MATLQLTY_CNT = (String)RstROW.getAttribute("MON_MATLQLTY_CNT");
				DAY_MATLQLTY_WGT = (Number)RstROW.getAttribute("DAY_MATLQLTY_WGT");
				MON_MATLQLTY_WGT = (Number)RstROW.getAttribute("MON_MATLQLTY_WGT");
				
				//第18行
				EDIT_PROD[17][18] = DAY_MATLQLTY_CNT;
				EDIT_PROD[17][19] = MON_MATLQLTY_CNT;
				EDIT_PROD[17][20] = String.valueOf(DAY_MATLQLTY_WGT);
				EDIT_PROD[17][21] = String.valueOf(MON_MATLQLTY_WGT);
				
				//非计划（钢质）  11 
				DAY_STL_CNT = (String)RstROW.getAttribute("DAY_STL_CNT");
				MON_STL_CNT = (String)RstROW.getAttribute("MON_STL_CNT");
				DAY_STL_WGT = (Number)RstROW.getAttribute("DAY_STL_WGT");
				MON_STL_WGT = (Number)RstROW.getAttribute("MON_STL_WGT");
				
				//第19行
				EDIT_PROD[18][18] = DAY_STL_CNT;
				EDIT_PROD[18][19] = MON_STL_CNT;
				EDIT_PROD[18][20] = String.valueOf(DAY_STL_WGT);
				EDIT_PROD[18][21] = String.valueOf(MON_STL_WGT);
				
				//非计划（合计） 12
				DAY_SUM_WGT = DAY_SIZE_WGT.doubleValue()+DAY_EXTSHAPE_WGT.doubleValue()+DAY_MATLQLTY_WGT.doubleValue()+DAY_STL_WGT.doubleValue();
			
				//保留两位精度
				Double DAY_SUM_WGT_1 = new Double(new DecimalFormat(".00").format(DAY_SUM_WGT));
				
				MON_SUM_WGT = MON_SIZE_WGT.doubleValue()+MON_EXTSHAPE_WGT.doubleValue()+MON_MATLQLTY_WGT.doubleValue()+MON_STL_WGT.doubleValue();
				
				//保留两位精度
				Double MON_SUM_WGT_1 = new Double(new DecimalFormat(".00").format(MON_SUM_WGT));
				
				EDIT_PROD[19][18] = String.valueOf(DAY_SUM_WGT_1);
				EDIT_PROD[19][19] = String.valueOf(MON_SUM_WGT_1);
	
	
			}
			
			//对于能耗时间和停轧时间，这里求出4个班在时间段内的值。只取日期不取后面的时、分、秒
			//这里加入对能耗和停轧时间的统计
			//煤气耗量    21
			BigDecimal MQ_A = null;
			BigDecimal MON_MQ_A = null;
			
			//电耗量    22
			BigDecimal DIAN_A = null;
			BigDecimal MON_DIAN_A = null;
			
			//水耗量    23
			BigDecimal SHUI_A = null;
			BigDecimal MON_SHUI_A = null;
			
			//压缩空气耗量    24
			BigDecimal KQ_A = null;
			BigDecimal MON_KQ_A = null;
			
			//辊耗耗量    25
			BigDecimal GH_A = null;
			BigDecimal MON_GH_A = null;
			
			//停轧时间 机械  26
			BigDecimal JIXIE_A = null;
			BigDecimal MON_JIXIE_A = null;
			
			//停轧时间 电器  27
			BigDecimal DQ_A = null;
			BigDecimal MON_DQ_A = null;
			
			//停轧时间 轧钢  28
			BigDecimal ZG_A = null;
			BigDecimal MON_ZG_A = null;
			
			//停轧时间 换辊  29
			BigDecimal HG_A = null;
			BigDecimal MON_HG_A = null;
			
			//停轧时间 检修  30
			BigDecimal JIANXIU_A = null;
			BigDecimal MON_JIANXIU_A = null;
			
			//停轧时间 外部  31
			BigDecimal WB_A = null;
			BigDecimal MON_WB_A = null;
			
			//停轧时间 原成  32
			BigDecimal YC_A = null;
			BigDecimal MON_YC_A = null;
			
			//日历时间  33
			BigDecimal RL_A = null;
			BigDecimal MON_RL_A = null;
			
			//停轧时间  34
			BigDecimal TZZ_A = null;
			BigDecimal MON_TZZ_A = null;
			
			//停轧时间合计
			double TZ_A;
			double MON_TZ_A;
			
			//煤气耗量    21
			BigDecimal MQ_B = null;
			BigDecimal MON_MQ_B = null;
			
			//电耗量    22
			BigDecimal DIAN_B = null;
			BigDecimal MON_DIAN_B = null;
			
			//水耗量    23
			BigDecimal SHUI_B = null;
			BigDecimal MON_SHUI_B = null;
			
			//压缩空气耗量    24
			BigDecimal KQ_B = null;
			BigDecimal MON_KQ_B = null;
			
			//辊耗耗量    25
			BigDecimal GH_B = null;
			BigDecimal MON_GH_B = null;
			
			//停轧时间 机械  26
			BigDecimal JIXIE_B = null;
			BigDecimal MON_JIXIE_B = null;
			
			//停轧时间 电器  27
			BigDecimal DQ_B = null;
			BigDecimal MON_DQ_B = null;
			
			//停轧时间 轧钢  28
			BigDecimal ZG_B = null;
			BigDecimal MON_ZG_B = null;
			
			//停轧时间 换辊  29
			BigDecimal HG_B = null;
			BigDecimal MON_HG_B = null;
			
			//停轧时间 检修  30
			BigDecimal JIANXIU_B = null;
			BigDecimal MON_JIANXIU_B = null;
			
			//停轧时间 外部  31
			BigDecimal WB_B = null;
			BigDecimal MON_WB_B = null;
			
			//停轧时间 原成  32
			BigDecimal YC_B = null;
			BigDecimal MON_YC_B = null;
			
			//日历时间  33
			BigDecimal RL_B = null;
			BigDecimal MON_RL_B = null;
			
			//停轧时间  34
			BigDecimal TZZ_B = null;
			BigDecimal MON_TZZ_B = null;
			
			//停轧合计
			double TZ_B;
			double MON_TZ_B;
			
			
			//煤气耗量    21
			BigDecimal MQ_C = null;
			BigDecimal MON_MQ_C = null;
			
			//电耗量    22
			BigDecimal DIAN_C = null;
			BigDecimal MON_DIAN_C = null;
			
			//水耗量    23
			BigDecimal SHUI_C = null;
			BigDecimal MON_SHUI_C = null;
			
			//压缩空气耗量    24
			BigDecimal KQ_C = null;
			BigDecimal MON_KQ_C = null;
			
			//辊耗耗量    25
			BigDecimal GH_C = null;
			BigDecimal MON_GH_C = null;
			
			//停轧时间 机械  26
			BigDecimal JIXIE_C = null;
			BigDecimal MON_JIXIE_C = null;
			
			//停轧时间 电器  27
			BigDecimal DQ_C = null;
			BigDecimal MON_DQ_C = null;
			
			//停轧时间 轧钢  28
			BigDecimal ZG_C = null;
			BigDecimal MON_ZG_C = null;
			
			//停轧时间 换辊  29
			BigDecimal HG_C = null;
			BigDecimal MON_HG_C = null;
			
			//停轧时间 检修  30
			BigDecimal JIANXIU_C = null;
			BigDecimal MON_JIANXIU_C = null;
			
			//停轧时间 外部  31
			BigDecimal WB_C = null;
			BigDecimal MON_WB_C = null;
			
			//停轧时间 原成  32
			BigDecimal YC_C = null;
			BigDecimal MON_YC_C = null;
			
			//日历时间  33
			BigDecimal RL_C = null;
			BigDecimal MON_RL_C = null;
			
			//停轧时间  34
			BigDecimal TZZ_C = null;
			BigDecimal MON_TZZ_C = null;
			
			//停轧合计
			double TZ_C;
			double MON_TZ_C;
			
			//丁班的停轧和能耗
			//煤气耗量    21
			BigDecimal MQ_D = null;
			BigDecimal MON_MQ_D = null;
			
			//电耗量    22
			BigDecimal DIAN_D = null;
			BigDecimal MON_DIAN_D = null;
			
			//水耗量    23
			BigDecimal SHUI_D = null;
			BigDecimal MON_SHUI_D = null;
			
			//压缩空气耗量    24
			BigDecimal KQ_D = null;
			BigDecimal MON_KQ_D = null;
			
			//辊耗耗量    25
			BigDecimal GH_D = null;
			BigDecimal MON_GH_D = null;
			
			//停轧时间 机械  26
			BigDecimal JIXIE_D = null;
			BigDecimal MON_JIXIE_D = null;
			
			//停轧时间 电器  27
			BigDecimal DQ_D = null;
			BigDecimal MON_DQ_D = null;
			
			//停轧时间 轧钢  28
			BigDecimal ZG_D = null;
			BigDecimal MON_ZG_D = null;
			
			//停轧时间 换辊  29
			BigDecimal HG_D = null;
			BigDecimal MON_HG_D = null;
			
			//停轧时间 检修  30
			BigDecimal JIANXIU_D = null;
			BigDecimal MON_JIANXIU_D = null;
			
			//停轧时间 外部  31
			BigDecimal WB_D = null;
			BigDecimal MON_WB_D = null;
			
			//停轧时间 原成  32
			BigDecimal YC_D = null;
			BigDecimal MON_YC_D = null;
			
			//日历时间  33
			BigDecimal RL_D = null;
			BigDecimal MON_RL_D = null;
			
			//停轧时间  34
			BigDecimal TZZ_D = null;
			BigDecimal MON_TZZ_D = null;
			
			//停轧合计
			double TZ_D;
			double MON_TZ_D;
			
			PosParameter param11 = new PosParameter();
			//这里开始要获取能耗和停轧时间等信息 甲班的信息
			//煤气
			param11.setWhereClauseParameter(0, "A");
			param11.setWhereClauseParameter(1, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(2, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(3, "A");
			param11.setWhereClauseParameter(4, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(5, PRD_YYYYMM_T[0].substring(0, 8));
			
			//电
			param11.setWhereClauseParameter(6, "A");
			param11.setWhereClauseParameter(7, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(8, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(9, "A");
			param11.setWhereClauseParameter(10, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(11, PRD_YYYYMM_T[0].substring(0, 8));
			
			//水
			param11.setWhereClauseParameter(12, "A");
			param11.setWhereClauseParameter(13, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(14, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(15, "A");
			param11.setWhereClauseParameter(16, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(17, PRD_YYYYMM_T[0].substring(0, 8));
			
			//空气
			param11.setWhereClauseParameter(18, "A");
			param11.setWhereClauseParameter(19, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(20, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(21, "A");
			param11.setWhereClauseParameter(22, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(23, PRD_YYYYMM_T[0].substring(0, 8));
			
			//辊耗
			param11.setWhereClauseParameter(24, "A");
			param11.setWhereClauseParameter(25, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(26, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(27, "A");
			param11.setWhereClauseParameter(28, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(29, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  机械
			param11.setWhereClauseParameter(30, "A");
			param11.setWhereClauseParameter(31, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(32, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(33, "A");
			param11.setWhereClauseParameter(34, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(35, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  电器
			param11.setWhereClauseParameter(36, "A");
			param11.setWhereClauseParameter(37, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(38, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(39, "A");
			param11.setWhereClauseParameter(40, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(41, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  轧钢
			param11.setWhereClauseParameter(42, "A");
			param11.setWhereClauseParameter(43, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(44, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(45, "A");
			param11.setWhereClauseParameter(46, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(47, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  换辊
			param11.setWhereClauseParameter(48, "A");
			param11.setWhereClauseParameter(49, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(50, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(51, "A");
			param11.setWhereClauseParameter(52, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(53, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  检修
			param11.setWhereClauseParameter(54, "A");
			param11.setWhereClauseParameter(55, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(56, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(57, "A");
			param11.setWhereClauseParameter(58, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(59, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  外部
			param11.setWhereClauseParameter(60, "A");
			param11.setWhereClauseParameter(61, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(62, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(63, "A");
			param11.setWhereClauseParameter(64, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(65, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  原成
			param11.setWhereClauseParameter(66, "A");
			param11.setWhereClauseParameter(67, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(68, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(69, "A");
			param11.setWhereClauseParameter(70, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(71, PRD_YYYYMM_T[0].substring(0, 8));
			
			//日历时间
			param11.setWhereClauseParameter(72, "A");
			param11.setWhereClauseParameter(73, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(74, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(75, "A");
			param11.setWhereClauseParameter(76, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(77, PRD_YYYYMM_T[0].substring(0, 8));
			
			//日历时间
			param11.setWhereClauseParameter(78, "A");
			param11.setWhereClauseParameter(79, PRD_YYYYMM_F[0].substring(0, 8));
			param11.setWhereClauseParameter(80, PRD_YYYYMM_T[0].substring(0, 8));
			
			param11.setWhereClauseParameter(81, "A");
			param11.setWhereClauseParameter(82, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param11.setWhereClauseParameter(83, PRD_YYYYMM_T[0].substring(0, 8));
			
			PosRowSet AARstVO = this.getDao("mesdao").find("UIH090060_09.select", param11);
			
			if(AARstVO.hasNext()){
				PosRow AARstROW = AARstVO.next();
				//煤气耗量    21
				MQ_A = (BigDecimal)AARstROW.getAttribute("MQ");
				MON_MQ_A = (BigDecimal)AARstROW.getAttribute("MON_MQ");
				
				EDIT_PROD[20][2] = String.valueOf(MQ_A);
				EDIT_PROD[20][3] = String.valueOf(MON_MQ_A);
				
				//电耗量    22
				DIAN_A = (BigDecimal)AARstROW.getAttribute("DIAN");
				MON_DIAN_A = (BigDecimal)AARstROW.getAttribute("MON_DIAN");
				
				EDIT_PROD[21][2] = String.valueOf(DIAN_A);
				EDIT_PROD[21][3] = String.valueOf(MON_DIAN_A);
				
				//水耗量    23
				SHUI_A = (BigDecimal)AARstROW.getAttribute("SHUI");
				MON_SHUI_A = (BigDecimal)AARstROW.getAttribute("MON_SHUI");
				
				EDIT_PROD[22][2] = String.valueOf(SHUI_A);
				EDIT_PROD[22][3] = String.valueOf(MON_SHUI_A);
				
				//压缩空气耗量    24
				KQ_A = (BigDecimal)AARstROW.getAttribute("KQ");
				MON_KQ_A = (BigDecimal)AARstROW.getAttribute("MON_KQ");
				
				EDIT_PROD[23][2] = String.valueOf(KQ_A);
				EDIT_PROD[23][3] = String.valueOf(MON_KQ_A);
				
				//辊耗耗量    25
				GH_A = (BigDecimal)AARstROW.getAttribute("GH");
				MON_GH_A = (BigDecimal)AARstROW.getAttribute("MON_GH");
				
				EDIT_PROD[24][2] = String.valueOf(GH_A);
				EDIT_PROD[24][3] = String.valueOf(MON_GH_A);
				
				//停轧时间 机械  26
				JIXIE_A = (BigDecimal)AARstROW.getAttribute("JIXIE");
				MON_JIXIE_A = (BigDecimal)AARstROW.getAttribute("MON_JIXIE");
				
				EDIT_PROD[25][2] = String.valueOf(JIXIE_A);
				EDIT_PROD[25][3] = String.valueOf(MON_JIXIE_A);
				
				//停轧时间 电器  27
				DQ_A = (BigDecimal)AARstROW.getAttribute("DQ");
				MON_DQ_A = (BigDecimal)AARstROW.getAttribute("MON_DQ");
				
				EDIT_PROD[26][2] = String.valueOf(DQ_A);
				EDIT_PROD[26][3] = String.valueOf(MON_DQ_A);
				
				//停轧时间 轧钢  28
				ZG_A = (BigDecimal)AARstROW.getAttribute("ZG");
				MON_ZG_A = (BigDecimal)AARstROW.getAttribute("MON_ZG");
				
				EDIT_PROD[27][2] = String.valueOf(ZG_A);
				EDIT_PROD[27][3] = String.valueOf(MON_ZG_A);
				
				//停轧时间 换辊  29
				HG_A = (BigDecimal)AARstROW.getAttribute("HG");
				MON_HG_A = (BigDecimal)AARstROW.getAttribute("MON_HG");
				
				EDIT_PROD[28][2] = String.valueOf(HG_A);
				EDIT_PROD[28][3] = String.valueOf(MON_HG_A);
				
				//停轧时间 检修  30
				JIANXIU_A = (BigDecimal)AARstROW.getAttribute("JIANXIU");
				MON_JIANXIU_A = (BigDecimal)AARstROW.getAttribute("MON_JIANXIU");
				
				EDIT_PROD[29][2] = String.valueOf(JIANXIU_A);
				EDIT_PROD[29][3] = String.valueOf(MON_JIANXIU_A);
				
				//停轧时间 外部  31
				WB_A = (BigDecimal)AARstROW.getAttribute("WB");
				MON_WB_A = (BigDecimal)AARstROW.getAttribute("MON_WB");
				
				EDIT_PROD[30][2] = String.valueOf(WB_A);
				EDIT_PROD[30][3] = String.valueOf(MON_WB_A);
				
				//停轧时间 原成  32
				YC_A = (BigDecimal)AARstROW.getAttribute("YC");
				MON_YC_A = (BigDecimal)AARstROW.getAttribute("MON_YC");
				
				EDIT_PROD[31][2] = String.valueOf(YC_A);
				EDIT_PROD[31][3] = String.valueOf(MON_YC_A);
				
				//日历时间
				RL_A = (BigDecimal)AARstROW.getAttribute("RL");
				MON_RL_A = (BigDecimal)AARstROW.getAttribute("MON_RL");
				
				if(RL_A == null && MON_RL_A == null){
					EDIT_PROD[9][2] = "0";
					EDIT_PROD[9][3] = "0";
				}else{
					EDIT_PROD[9][2] = String.valueOf(RL_A);
					EDIT_PROD[9][3] = String.valueOf(MON_RL_A);
				}

				//轧钢时间
				TZZ_A = (BigDecimal)AARstROW.getAttribute("TZ");
				MON_TZZ_A = (BigDecimal)AARstROW.getAttribute("MON_TZ");
				
				if(TZZ_A == null && MON_TZZ_A == null){
					EDIT_PROD[10][2] = "0";
					EDIT_PROD[10][3] = "0";
				}else{
					EDIT_PROD[10][2] = String.valueOf(TZZ_A);
					EDIT_PROD[10][3] = String.valueOf(MON_TZZ_A);
				}

				
				//这里要进行空值处理，为空就默认为0
				if(JIXIE_A == null && DQ_A == null && ZG_A == null && HG_A == null && JIANXIU_A == null && WB_A == null && YC_A == null){
					EDIT_PROD[32][2] = "0";
					EDIT_PROD[32][3] = "0";
				}else{
//					停轧时间合计
					TZ_A = JIXIE_A.doubleValue()+DQ_A.doubleValue()+ZG_A.doubleValue()+HG_A.doubleValue()+JIANXIU_A.doubleValue()+WB_A.doubleValue()+YC_A.doubleValue();
					MON_TZ_A = MON_JIXIE_A.doubleValue()+MON_DQ_A.doubleValue()+MON_ZG_A.doubleValue()+MON_HG_A.doubleValue()+MON_JIANXIU_A.doubleValue()+MON_WB_A.doubleValue()+MON_YC_A.doubleValue();
					
					//保留两位精度
					Double TZ_A_1 = new Double(new DecimalFormat(".00").format(TZ_A));
					Double MON_TZ_A_1 = new Double(new DecimalFormat(".00").format(MON_TZ_A));
					
					EDIT_PROD[32][2] = String.valueOf(TZ_A_1);
					EDIT_PROD[32][3] = String.valueOf(MON_TZ_A_1);
				}
			}
			
			PosParameter param22 = new PosParameter();
			//这里开始要获取能耗和停轧时间等信息 乙班的信息
			//煤气
			param22.setWhereClauseParameter(0, "B");
			param22.setWhereClauseParameter(1, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(2, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(3, "B");
			param22.setWhereClauseParameter(4, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(5, PRD_YYYYMM_T[0].substring(0, 8));
			
			//电
			param22.setWhereClauseParameter(6, "B");
			param22.setWhereClauseParameter(7, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(8, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(9, "B");
			param22.setWhereClauseParameter(10, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(11, PRD_YYYYMM_T[0].substring(0, 8));
			
			//水
			param22.setWhereClauseParameter(12, "B");
			param22.setWhereClauseParameter(13, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(14, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(15, "B");
			param22.setWhereClauseParameter(16, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(17, PRD_YYYYMM_T[0].substring(0, 8));
			
			//空气
			param22.setWhereClauseParameter(18, "B");
			param22.setWhereClauseParameter(19, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(20, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(21, "B");
			param22.setWhereClauseParameter(22, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(23, PRD_YYYYMM_T[0].substring(0, 8));
			
			//辊耗
			param22.setWhereClauseParameter(24, "B");
			param22.setWhereClauseParameter(25, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(26, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(27, "B");
			param22.setWhereClauseParameter(28, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(29, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  机械
			param22.setWhereClauseParameter(30, "B");
			param22.setWhereClauseParameter(31, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(32, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(33, "B");
			param22.setWhereClauseParameter(34, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(35, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  电器
			param22.setWhereClauseParameter(36, "B");
			param22.setWhereClauseParameter(37, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(38, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(39, "B");
			param22.setWhereClauseParameter(40, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(41, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  轧钢
			param22.setWhereClauseParameter(42, "B");
			param22.setWhereClauseParameter(43, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(44, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(45, "B");
			param22.setWhereClauseParameter(46, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(47, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  换辊
			param22.setWhereClauseParameter(48, "B");
			param22.setWhereClauseParameter(49, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(50, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(51, "B");
			param22.setWhereClauseParameter(52, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(53, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  检修
			param22.setWhereClauseParameter(54, "B");
			param22.setWhereClauseParameter(55, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(56, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(57, "B");
			param22.setWhereClauseParameter(58, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(59, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  外部
			param22.setWhereClauseParameter(60, "B");
			param22.setWhereClauseParameter(61, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(62, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(63, "B");
			param22.setWhereClauseParameter(64, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(65, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  原成
			param22.setWhereClauseParameter(66, "B");
			param22.setWhereClauseParameter(67, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(68, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(69, "B");
			param22.setWhereClauseParameter(70, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(71, PRD_YYYYMM_T[0].substring(0, 8));
			
			//日历时间
			param22.setWhereClauseParameter(72, "B");
			param22.setWhereClauseParameter(73, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(74, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(75, "B");
			param22.setWhereClauseParameter(76, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(77, PRD_YYYYMM_T[0].substring(0, 8));
			
			//日历时间
			param22.setWhereClauseParameter(78, "B");
			param22.setWhereClauseParameter(79, PRD_YYYYMM_F[0].substring(0, 8));
			param22.setWhereClauseParameter(80, PRD_YYYYMM_T[0].substring(0, 8));
			
			param22.setWhereClauseParameter(81, "B");
			param22.setWhereClauseParameter(82, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param22.setWhereClauseParameter(83, PRD_YYYYMM_T[0].substring(0, 8));
			
			PosRowSet BBRstVO = this.getDao("mesdao").find("UIH090060_09.select", param22);
			
			if(BBRstVO.hasNext()){
				PosRow BBRstROW = BBRstVO.next();
				//煤气耗量    21
				MQ_B = (BigDecimal)BBRstROW.getAttribute("MQ");
				MON_MQ_B = (BigDecimal)BBRstROW.getAttribute("MON_MQ");
				
				EDIT_PROD[20][6] = String.valueOf(MQ_B);
				EDIT_PROD[20][7] = String.valueOf(MON_MQ_B);
				
				//电耗量    22
				DIAN_B = (BigDecimal)BBRstROW.getAttribute("DIAN");
				MON_DIAN_B = (BigDecimal)BBRstROW.getAttribute("MON_DIAN");
				
				EDIT_PROD[21][6] = String.valueOf(DIAN_B);
				EDIT_PROD[21][7] = String.valueOf(MON_DIAN_B);
				
				//水耗量    23
				SHUI_B = (BigDecimal)BBRstROW.getAttribute("SHUI");
				MON_SHUI_B = (BigDecimal)BBRstROW.getAttribute("MON_SHUI");
				
				EDIT_PROD[22][6] = String.valueOf(SHUI_B);
				EDIT_PROD[22][7] = String.valueOf(MON_SHUI_B);
				
				//压缩空气耗量    24
				KQ_B = (BigDecimal)BBRstROW.getAttribute("KQ");
				MON_KQ_B = (BigDecimal)BBRstROW.getAttribute("MON_KQ");
				
				EDIT_PROD[23][6] = String.valueOf(KQ_B);
				EDIT_PROD[23][7] = String.valueOf(MON_KQ_B);
				
				//辊耗耗量    25
				GH_B = (BigDecimal)BBRstROW.getAttribute("GH");
				MON_GH_B = (BigDecimal)BBRstROW.getAttribute("MON_GH");
				
				EDIT_PROD[24][6] = String.valueOf(GH_B);
				EDIT_PROD[24][7] = String.valueOf(MON_GH_B);
				
				//停轧时间 机械  26
				JIXIE_B = (BigDecimal)BBRstROW.getAttribute("JIXIE");
				MON_JIXIE_B = (BigDecimal)BBRstROW.getAttribute("MON_JIXIE");
				
				EDIT_PROD[25][6] = String.valueOf(JIXIE_B);
				EDIT_PROD[25][7] = String.valueOf(MON_JIXIE_B);
				
				//停轧时间 电器  27
				DQ_B = (BigDecimal)BBRstROW.getAttribute("DQ");
				MON_DQ_B = (BigDecimal)BBRstROW.getAttribute("MON_DQ");
				
				EDIT_PROD[26][6] = String.valueOf(DQ_B);
				EDIT_PROD[26][7] = String.valueOf(MON_DQ_B);
				
				//停轧时间 轧钢  28
				ZG_B = (BigDecimal)BBRstROW.getAttribute("ZG");
				MON_ZG_B = (BigDecimal)BBRstROW.getAttribute("MON_ZG");
				
				EDIT_PROD[27][6] = String.valueOf(ZG_B);
				EDIT_PROD[27][7] = String.valueOf(MON_ZG_B);
				
				//停轧时间 换辊  29
				HG_B = (BigDecimal)BBRstROW.getAttribute("HG");
				MON_HG_B = (BigDecimal)BBRstROW.getAttribute("MON_HG");
				
				EDIT_PROD[28][6] = String.valueOf(HG_B);
				EDIT_PROD[28][7] = String.valueOf(MON_HG_B);
				
				//停轧时间 检修  30
				JIANXIU_B = (BigDecimal)BBRstROW.getAttribute("JIANXIU");
				MON_JIANXIU_B = (BigDecimal)BBRstROW.getAttribute("MON_JIANXIU");
				
				EDIT_PROD[29][6] = String.valueOf(JIANXIU_B);
				EDIT_PROD[29][7] = String.valueOf(MON_JIANXIU_B);
				
				//停轧时间 外部  31
				WB_B = (BigDecimal)BBRstROW.getAttribute("WB");
				MON_WB_B = (BigDecimal)BBRstROW.getAttribute("MON_WB");
				
				EDIT_PROD[30][6] = String.valueOf(WB_B);
				EDIT_PROD[30][7] = String.valueOf(MON_WB_B);
				
				//停轧时间 原成  32
				YC_B = (BigDecimal)BBRstROW.getAttribute("YC");
				MON_YC_B = (BigDecimal)BBRstROW.getAttribute("MON_YC");
				
				EDIT_PROD[31][6] = String.valueOf(YC_B);
				EDIT_PROD[31][7] = String.valueOf(MON_YC_B);
				
				//日历时间
				RL_B = (BigDecimal)BBRstROW.getAttribute("RL");
				MON_RL_B = (BigDecimal)BBRstROW.getAttribute("MON_RL");
				
				EDIT_PROD[9][6] = String.valueOf(RL_B);
				EDIT_PROD[9][7] = String.valueOf(MON_RL_B);
				
				//轧钢时间
				TZZ_B = (BigDecimal)BBRstROW.getAttribute("TZ");
				MON_TZZ_B = (BigDecimal)BBRstROW.getAttribute("MON_TZ");
				
				EDIT_PROD[10][6] = String.valueOf(TZZ_B);
				EDIT_PROD[10][7] = String.valueOf(MON_TZZ_B);
				
				if(JIXIE_B == null && DQ_B == null && ZG_B == null && HG_B == null && JIANXIU_B == null && WB_B == null && YC_B == null){
					EDIT_PROD[32][6] = "0";
					EDIT_PROD[32][7] = "0";
				}else{
					//停轧时间合计
					TZ_B = JIXIE_B.doubleValue()+DQ_B.doubleValue()+ZG_B.doubleValue()+HG_B.doubleValue()+JIANXIU_B.doubleValue()+WB_B.doubleValue()+YC_B.doubleValue();
					MON_TZ_B = MON_JIXIE_B.doubleValue()+MON_DQ_B.doubleValue()+MON_ZG_B.doubleValue()+MON_HG_B.doubleValue()+MON_JIANXIU_B.doubleValue()+MON_WB_B.doubleValue()+MON_YC_B.doubleValue();
				
					//保留两位精度
					Double TZ_B_1 = new Double(new DecimalFormat(".00").format(TZ_B));
					Double MON_TZ_B_1 = new Double(new DecimalFormat(".00").format(MON_TZ_B));
					
					EDIT_PROD[32][6] = String.valueOf(TZ_B_1);
					EDIT_PROD[32][7] = String.valueOf(MON_TZ_B_1);
				}
			}
			
			PosParameter param33 = new PosParameter();
			//这里开始要获取能耗和停轧时间等信息 丙班的信息
			//煤气
			param33.setWhereClauseParameter(0, "C");
			param33.setWhereClauseParameter(1, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(2, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(3, "C");
			param33.setWhereClauseParameter(4, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(5, PRD_YYYYMM_T[0].substring(0, 8));
			
			//电
			param33.setWhereClauseParameter(6, "C");
			param33.setWhereClauseParameter(7, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(8, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(9, "C");
			param33.setWhereClauseParameter(10, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(11, PRD_YYYYMM_T[0].substring(0, 8));
			
			//水
			param33.setWhereClauseParameter(12, "C");
			param33.setWhereClauseParameter(13, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(14, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(15, "C");
			param33.setWhereClauseParameter(16, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(17, PRD_YYYYMM_T[0].substring(0, 8));
			
			//空气
			param33.setWhereClauseParameter(18, "C");
			param33.setWhereClauseParameter(19, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(20, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(21, "C");
			param33.setWhereClauseParameter(22, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(23, PRD_YYYYMM_T[0].substring(0, 8));
			
			//辊耗
			param33.setWhereClauseParameter(24, "C");
			param33.setWhereClauseParameter(25, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(26, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(27, "C");
			param33.setWhereClauseParameter(28, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(29, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  机械
			param33.setWhereClauseParameter(30, "C");
			param33.setWhereClauseParameter(31, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(32, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(33, "C");
			param33.setWhereClauseParameter(34, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(35, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  电器
			param33.setWhereClauseParameter(36, "C");
			param33.setWhereClauseParameter(37, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(38, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(39, "C");
			param33.setWhereClauseParameter(40, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(41, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  轧钢
			param33.setWhereClauseParameter(42, "C");
			param33.setWhereClauseParameter(43, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(44, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(45, "C");
			param33.setWhereClauseParameter(46, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(47, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  换辊
			param33.setWhereClauseParameter(48, "C");
			param33.setWhereClauseParameter(49, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(50, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(51, "C");
			param33.setWhereClauseParameter(52, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(53, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  检修
			param33.setWhereClauseParameter(54, "C");
			param33.setWhereClauseParameter(55, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(56, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(57, "C");
			param33.setWhereClauseParameter(58, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(59, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  外部
			param33.setWhereClauseParameter(60, "C");
			param33.setWhereClauseParameter(61, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(62, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(63, "C");
			param33.setWhereClauseParameter(64, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(65, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  原成
			param33.setWhereClauseParameter(66, "C");
			param33.setWhereClauseParameter(67, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(68, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(69, "C");
			param33.setWhereClauseParameter(70, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(71, PRD_YYYYMM_T[0].substring(0, 8));
			
			//日历时间
			param33.setWhereClauseParameter(72, "C");
			param33.setWhereClauseParameter(73, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(74, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(75, "C");
			param33.setWhereClauseParameter(76, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(77, PRD_YYYYMM_T[0].substring(0, 8));
			
			//日历时间
			param33.setWhereClauseParameter(78, "C");
			param33.setWhereClauseParameter(79, PRD_YYYYMM_F[0].substring(0, 8));
			param33.setWhereClauseParameter(80, PRD_YYYYMM_T[0].substring(0, 8));
			
			param33.setWhereClauseParameter(81, "C");
			param33.setWhereClauseParameter(82, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param33.setWhereClauseParameter(83, PRD_YYYYMM_T[0].substring(0, 8));
			
			PosRowSet CCRstVO = this.getDao("mesdao").find("UIH090060_09.select", param33);
			
			if(CCRstVO.hasNext()){
				PosRow CCRstROW = CCRstVO.next();
				//煤气耗量    21
				MQ_C = (BigDecimal)CCRstROW.getAttribute("MQ");
				MON_MQ_C = (BigDecimal)CCRstROW.getAttribute("MON_MQ");
				
				EDIT_PROD[20][10] = String.valueOf(MQ_C);
				EDIT_PROD[20][11] = String.valueOf(MON_MQ_C);
				
				//电耗量    22
				DIAN_C = (BigDecimal)CCRstROW.getAttribute("DIAN");
				MON_DIAN_C = (BigDecimal)CCRstROW.getAttribute("MON_DIAN");
				
				EDIT_PROD[21][10] = String.valueOf(DIAN_C);
				EDIT_PROD[21][11] = String.valueOf(MON_DIAN_C);
				
				//水耗量    23
				SHUI_C = (BigDecimal)CCRstROW.getAttribute("SHUI");
				MON_SHUI_C = (BigDecimal)CCRstROW.getAttribute("MON_SHUI");
				
				EDIT_PROD[22][10] = String.valueOf(SHUI_C);
				EDIT_PROD[22][11] = String.valueOf(MON_SHUI_C);
				
				//压缩空气耗量    24
				KQ_C = (BigDecimal)CCRstROW.getAttribute("KQ");
				MON_KQ_C = (BigDecimal)CCRstROW.getAttribute("MON_KQ");
				
				EDIT_PROD[23][10] = String.valueOf(KQ_C);
				EDIT_PROD[23][11] = String.valueOf(MON_KQ_C);
				
				//辊耗耗量    25
				GH_C = (BigDecimal)CCRstROW.getAttribute("GH");
				MON_GH_C = (BigDecimal)CCRstROW.getAttribute("MON_GH");
				
				EDIT_PROD[24][10] = String.valueOf(GH_C);
				EDIT_PROD[24][11] = String.valueOf(MON_GH_C);
				
				//停轧时间 机械  26
				JIXIE_C = (BigDecimal)CCRstROW.getAttribute("JIXIE");
				MON_JIXIE_C = (BigDecimal)CCRstROW.getAttribute("MON_JIXIE");
				
				EDIT_PROD[25][10] = String.valueOf(JIXIE_C);
				EDIT_PROD[25][11] = String.valueOf(MON_JIXIE_C);
				
				//停轧时间 电器  27
				DQ_C = (BigDecimal)CCRstROW.getAttribute("DQ");
				MON_DQ_C = (BigDecimal)CCRstROW.getAttribute("MON_DQ");
				
				EDIT_PROD[26][10] = String.valueOf(DQ_C);
				EDIT_PROD[26][11] = String.valueOf(MON_DQ_C);
				
				//停轧时间 轧钢  28
				ZG_C = (BigDecimal)CCRstROW.getAttribute("ZG");
				MON_ZG_C = (BigDecimal)CCRstROW.getAttribute("MON_ZG");
				
				EDIT_PROD[27][10] = String.valueOf(ZG_C);
				EDIT_PROD[27][11] = String.valueOf(MON_ZG_C);
				
				//停轧时间 换辊  29
				HG_C = (BigDecimal)CCRstROW.getAttribute("HG");
				MON_HG_C = (BigDecimal)CCRstROW.getAttribute("MON_HG");
				
				EDIT_PROD[28][10] = String.valueOf(HG_C);
				EDIT_PROD[28][11] = String.valueOf(MON_HG_C);
				
				//停轧时间 检修  30
				JIANXIU_C = (BigDecimal)CCRstROW.getAttribute("JIANXIU");
				MON_JIANXIU_C = (BigDecimal)CCRstROW.getAttribute("MON_JIANXIU");
				
				EDIT_PROD[29][10] = String.valueOf(JIANXIU_C);
				EDIT_PROD[29][11] = String.valueOf(MON_JIANXIU_C);
				
				//停轧时间 外部  31
				WB_C = (BigDecimal)CCRstROW.getAttribute("WB");
				MON_WB_C = (BigDecimal)CCRstROW.getAttribute("MON_WB");
				
				EDIT_PROD[30][10] = String.valueOf(WB_C);
				EDIT_PROD[30][11] = String.valueOf(MON_WB_C);
				
				//停轧时间 原成  32
				YC_C = (BigDecimal)CCRstROW.getAttribute("YC");
				MON_YC_C = (BigDecimal)CCRstROW.getAttribute("MON_YC");
				
				EDIT_PROD[31][10] = String.valueOf(YC_C);
				EDIT_PROD[31][11] = String.valueOf(MON_YC_C);
				
				//日历时间
				RL_C = (BigDecimal)CCRstROW.getAttribute("RL");
				MON_RL_C = (BigDecimal)CCRstROW.getAttribute("MON_RL");
				
				EDIT_PROD[9][10] = String.valueOf(RL_C);
				EDIT_PROD[9][11] = String.valueOf(MON_RL_C);
				
				//轧钢时间
				TZZ_C = (BigDecimal)CCRstROW.getAttribute("TZ");
				MON_TZZ_C = (BigDecimal)CCRstROW.getAttribute("MON_TZ");
				
				EDIT_PROD[10][10] = String.valueOf(TZZ_C);
				EDIT_PROD[10][11] = String.valueOf(MON_TZZ_C);
				
				if(JIXIE_C == null && DQ_C == null && ZG_C == null && HG_C == null && JIANXIU_C == null && WB_C == null && YC_C == null){
					EDIT_PROD[32][10] = "0";
					EDIT_PROD[32][11] = "0";
				}else{
					//停轧时间合计
					TZ_C = JIXIE_C.doubleValue()+DQ_C.doubleValue()+ZG_C.doubleValue()+HG_C.doubleValue()+JIANXIU_C.doubleValue()+WB_C.doubleValue()+YC_C.doubleValue();
					MON_TZ_C = MON_JIXIE_C.doubleValue()+MON_DQ_C.doubleValue()+MON_ZG_C.doubleValue()+MON_HG_C.doubleValue()+MON_JIANXIU_C.doubleValue()+MON_WB_C.doubleValue()+MON_YC_C.doubleValue();
					
					//保留两位精度
					Double TZ_C_1 = new Double(new DecimalFormat(".00").format(TZ_C));
					Double MON_TZ_C_1 = new Double(new DecimalFormat(".00").format(MON_TZ_C));
					
					EDIT_PROD[32][10] = String.valueOf(TZ_C_1);
					EDIT_PROD[32][11] = String.valueOf(MON_TZ_C_1);
				}
			}
			
			PosParameter param44 = new PosParameter();

			//这里开始要获取能耗和停轧时间等信息 丁班的信息
			//煤气
			param44.setWhereClauseParameter(0, "D");
			param44.setWhereClauseParameter(1, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(2, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(3, "D");
			param44.setWhereClauseParameter(4, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(5, PRD_YYYYMM_T[0].substring(0, 8));
			
			//电
			param44.setWhereClauseParameter(6, "D");
			param44.setWhereClauseParameter(7, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(8, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(9, "D");
			param44.setWhereClauseParameter(10, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(11, PRD_YYYYMM_T[0].substring(0, 8));
			
			//水
			param44.setWhereClauseParameter(12, "D");
			param44.setWhereClauseParameter(13, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(14, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(15, "D");
			param44.setWhereClauseParameter(16, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(17, PRD_YYYYMM_T[0].substring(0, 8));
			
			//空气
			param44.setWhereClauseParameter(18, "D");
			param44.setWhereClauseParameter(19, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(20, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(21, "D");
			param44.setWhereClauseParameter(22, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(23, PRD_YYYYMM_T[0].substring(0, 8));
			
			//辊耗
			param44.setWhereClauseParameter(24, "D");
			param44.setWhereClauseParameter(25, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(26, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(27, "D");
			param44.setWhereClauseParameter(28, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(29, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  机械
			param44.setWhereClauseParameter(30, "D");
			param44.setWhereClauseParameter(31, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(32, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(33, "D");
			param44.setWhereClauseParameter(34, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(35, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  电器
			param44.setWhereClauseParameter(36, "D");
			param44.setWhereClauseParameter(37, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(38, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(39, "D");
			param44.setWhereClauseParameter(40, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(41, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  轧钢
			param44.setWhereClauseParameter(42, "D");
			param44.setWhereClauseParameter(43, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(44, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(45, "D");
			param44.setWhereClauseParameter(46, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(47, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  换辊
			param44.setWhereClauseParameter(48, "D");
			param44.setWhereClauseParameter(49, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(50, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(51, "D");
			param44.setWhereClauseParameter(52, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(53, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  检修
			param44.setWhereClauseParameter(54, "D");
			param44.setWhereClauseParameter(55, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(56, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(57, "D");
			param44.setWhereClauseParameter(58, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(59, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  外部
			param44.setWhereClauseParameter(60, "D");
			param44.setWhereClauseParameter(61, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(62, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(63, "D");
			param44.setWhereClauseParameter(64, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(65, PRD_YYYYMM_T[0].substring(0, 8));
			
			//停轧时间  原成
			param44.setWhereClauseParameter(66, "D");
			param44.setWhereClauseParameter(67, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(68, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(69, "D");
			param44.setWhereClauseParameter(70, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(71, PRD_YYYYMM_T[0].substring(0, 8));
			
			//日历时间
			param44.setWhereClauseParameter(72, "D");
			param44.setWhereClauseParameter(73, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(74, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(75, "D");
			param44.setWhereClauseParameter(76, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(77, PRD_YYYYMM_T[0].substring(0, 8));
			
			//日历时间
			param44.setWhereClauseParameter(78, "D");
			param44.setWhereClauseParameter(79, PRD_YYYYMM_F[0].substring(0, 8));
			param44.setWhereClauseParameter(80, PRD_YYYYMM_T[0].substring(0, 8));
			
			param44.setWhereClauseParameter(81, "D");
			param44.setWhereClauseParameter(82, PRD_YYYYMM_F[0].substring(0, 6)+"01");
			param44.setWhereClauseParameter(83, PRD_YYYYMM_T[0].substring(0, 8));
			
			PosRowSet DDRstVO = this.getDao("mesdao").find("UIH090060_09.select", param44);
			
			if(DDRstVO.hasNext()){
				PosRow DDRstROW = DDRstVO.next();
				//煤气耗量    21
				MQ_D = (BigDecimal)DDRstROW.getAttribute("MQ");
				MON_MQ_D = (BigDecimal)DDRstROW.getAttribute("MON_MQ");
				
				EDIT_PROD[20][14] = String.valueOf(MQ_D);
				EDIT_PROD[20][15] = String.valueOf(MON_MQ_D);
				
				//电耗量    22
				DIAN_D = (BigDecimal)DDRstROW.getAttribute("DIAN");
				MON_DIAN_D = (BigDecimal)DDRstROW.getAttribute("MON_DIAN");
				
				EDIT_PROD[21][14] = String.valueOf(DIAN_D);
				EDIT_PROD[21][15] = String.valueOf(MON_DIAN_D);
				
				//水耗量    23
				SHUI_D = (BigDecimal)DDRstROW.getAttribute("SHUI");
				MON_SHUI_D = (BigDecimal)DDRstROW.getAttribute("MON_SHUI");
				
				EDIT_PROD[22][14] = String.valueOf(SHUI_D);
				EDIT_PROD[22][15] = String.valueOf(MON_SHUI_D);
				
				//压缩空气耗量    24
				KQ_D = (BigDecimal)DDRstROW.getAttribute("KQ");
				MON_KQ_D = (BigDecimal)DDRstROW.getAttribute("MON_KQ");
				
				EDIT_PROD[23][14] = String.valueOf(KQ_D);
				EDIT_PROD[23][15] = String.valueOf(MON_KQ_D);
				
				//辊耗耗量    25
				GH_D = (BigDecimal)DDRstROW.getAttribute("GH");
				MON_GH_D = (BigDecimal)DDRstROW.getAttribute("MON_GH");
				
				EDIT_PROD[24][14] = String.valueOf(GH_D);
				EDIT_PROD[24][15] = String.valueOf(MON_GH_D);
				
				//停轧时间 机械  26
				JIXIE_D = (BigDecimal)DDRstROW.getAttribute("JIXIE");
				MON_JIXIE_D = (BigDecimal)DDRstROW.getAttribute("MON_JIXIE");
				
				EDIT_PROD[25][14] = String.valueOf(JIXIE_D);
				EDIT_PROD[25][15] = String.valueOf(MON_JIXIE_D);
				
				//停轧时间 电器  27
				DQ_D = (BigDecimal)DDRstROW.getAttribute("DQ");
				MON_DQ_D = (BigDecimal)DDRstROW.getAttribute("MON_DQ");
				
				EDIT_PROD[26][14] = String.valueOf(DQ_D);
				EDIT_PROD[26][15] = String.valueOf(MON_DQ_D);
				
				//停轧时间 轧钢  28
				ZG_D = (BigDecimal)DDRstROW.getAttribute("ZG");
				MON_ZG_D = (BigDecimal)DDRstROW.getAttribute("MON_ZG");
				
				EDIT_PROD[27][14] = String.valueOf(ZG_D);
				EDIT_PROD[27][15] = String.valueOf(MON_ZG_D);
				
				//停轧时间 换辊  29
				HG_D = (BigDecimal)DDRstROW.getAttribute("HG");
				MON_HG_D = (BigDecimal)DDRstROW.getAttribute("MON_HG");
				
				EDIT_PROD[28][14] = String.valueOf(HG_D);
				EDIT_PROD[28][15] = String.valueOf(MON_HG_D);
				
				//停轧时间 检修  30
				JIANXIU_D = (BigDecimal)DDRstROW.getAttribute("JIANXIU");
				MON_JIANXIU_D = (BigDecimal)DDRstROW.getAttribute("MON_JIANXIU");
				
				EDIT_PROD[29][14] = String.valueOf(JIANXIU_D);
				EDIT_PROD[29][15] = String.valueOf(MON_JIANXIU_D);
				
				//停轧时间 外部  31
				WB_D = (BigDecimal)DDRstROW.getAttribute("WB");
				MON_WB_D = (BigDecimal)DDRstROW.getAttribute("MON_WB");
				
				EDIT_PROD[30][14] = String.valueOf(WB_D);
				EDIT_PROD[30][15] = String.valueOf(MON_WB_D);
				
				//停轧时间 原成  32
				YC_D = (BigDecimal)DDRstROW.getAttribute("YC");
				MON_YC_D = (BigDecimal)DDRstROW.getAttribute("MON_YC");
				
				EDIT_PROD[31][14] = String.valueOf(YC_D);
				EDIT_PROD[31][15] = String.valueOf(MON_YC_D);
				
				//日历时间
				RL_D = (BigDecimal)DDRstROW.getAttribute("RL");
				MON_RL_D = (BigDecimal)DDRstROW.getAttribute("MON_RL");
				
				EDIT_PROD[9][14] = String.valueOf(RL_D);
				EDIT_PROD[9][15] = String.valueOf(MON_RL_D);
				
				//轧钢时间
				TZZ_D = (BigDecimal)DDRstROW.getAttribute("TZ");
				MON_TZZ_D = (BigDecimal)DDRstROW.getAttribute("MON_TZ");
				
				EDIT_PROD[10][14] = String.valueOf(TZZ_A);
				EDIT_PROD[10][15] = String.valueOf(MON_TZZ_A);
				
				if(JIXIE_D == null && DQ_D == null && ZG_D == null && HG_D == null && JIANXIU_D == null && WB_D == null && YC_D == null){
					EDIT_PROD[32][14] = "0";
					EDIT_PROD[32][15] = "0";
				}else{
					//停轧时间合计
					TZ_D = JIXIE_D.doubleValue()+DQ_D.doubleValue()+ZG_D.doubleValue()+HG_D.doubleValue()+JIANXIU_D.doubleValue()+WB_D.doubleValue()+YC_D.doubleValue();
					MON_TZ_D = MON_JIXIE_D.doubleValue()+MON_DQ_D.doubleValue()+MON_ZG_D.doubleValue()+MON_HG_D.doubleValue()+MON_JIANXIU_D.doubleValue()+MON_WB_D.doubleValue()+MON_YC_D.doubleValue();
					
					//保留两位精度
					Double TZ_D_1 = new Double(new DecimalFormat(".00").format(TZ_D));
					Double MON_TZ_D_1 = new Double(new DecimalFormat(".00").format(MON_TZ_D));
					
					EDIT_PROD[32][14] = String.valueOf(TZ_D_1);
					EDIT_PROD[32][15] = String.valueOf(MON_TZ_D_1);
				}
			}
			
		 //把指定的值返回的前台页面
		 for(int m=0;m < 35;m++) {                                      
	    	  HashMap   map1 =  new HashMap() ;                                                          
	           list1.add(map1);  
	           //序号
	           map1.put("PROD_SEQ"      , EDIT_PROD[m][0]    );    
	           //指标名称1
	           map1.put("PROD_GUIDE"      , EDIT_PROD[m][1]    );  
	           //甲班当日块
	           map1.put("DAY_CNT_A"       , EDIT_PROD[m][2]    );
	           map1.put("MON_CNT_A"      , EDIT_PROD[m][3]    );     
	           map1.put("DAY_WGT_A"    , EDIT_PROD[m][4]    );     
	           map1.put("MON_WGT_A"     , EDIT_PROD[m][5]    );     
	           map1.put("DAY_CNT_B"   , EDIT_PROD[m][6]    );     
	           map1.put("MON_CNT_B"     , EDIT_PROD[m][7]    );     
	           map1.put("DAY_WGT_B"   , EDIT_PROD[m][8]    );     
	           map1.put("MON_WGT_B"    , EDIT_PROD[m][9]    );     
	           map1.put("DAY_CNT_C"  , EDIT_PROD[m][10]    );     
	           map1.put("MON_CNT_C"    , EDIT_PROD[m][11]    );     
	           map1.put("DAY_WGT_C"  , EDIT_PROD[m][12]    );     
	           map1.put("MON_WGT_C"    , EDIT_PROD[m][13]    );     
	           map1.put("DAY_CNT_D"  , EDIT_PROD[m][14]    );     
	           map1.put("MON_CNT_D"    , EDIT_PROD[m][15]    );     
	           map1.put("DAY_WGT_D"  , EDIT_PROD[m][16]    );     
	           map1.put("MON_WGT_D"    , EDIT_PROD[m][17]    ); 
	           map1.put("DAY_CNT"  , EDIT_PROD[m][18]    );     
	           map1.put("MON_CNT"    , EDIT_PROD[m][19]    );     
	           map1.put("DAY_WGT"  , EDIT_PROD[m][20]    );     
	           map1.put("MON_WGT"     , EDIT_PROD[m][21]    );	           	        	                                             
	      }	                                                           

	        
	      
	       
	      context.put("ProdEdit",list1);
		
		return PosBizControlConstants.SUCCESS;
	}
	
	public static String AddDateFunc(String sDate, int iDteCnt) {

		int iLoopCnt = 1;
		int iYear = Integer.parseInt(sDate.substring(0, 4));
		int iMonth = Integer.parseInt(sDate.substring(4, 6));
		int iDay = Integer.parseInt(sDate.substring(6, 8));
		String sYear = null;
		String sMonth = null;
		String sDay = null;
		String sTmpDate = null;
		if (iDteCnt == 0)
			return sDate;
		if (iDteCnt > 0) {
			iLoopCnt = 1;
			while (iLoopCnt <= iDteCnt) {
				iDay++;
				sYear = Integer.toString(iYear);
				sMonth = Integer.toString(iMonth);
				sDay = Integer.toString(iDay);
				if (sMonth.length() == 1)
					sMonth = "0" + Integer.toString(iMonth);
				if (sDay.length() == 1)
					sDay = "0" + Integer.toString(iDay);
				sTmpDate = sYear + sMonth + sDay;
				if (dateValid(sTmpDate) == false) {
					iDay = 1;
					iMonth++;
					if (iMonth > 12) {
						iMonth = 1;
						iYear++;
					}
				}
				sYear = Integer.toString(iYear);
				sMonth = Integer.toString(iMonth);
				sDay = Integer.toString(iDay);
				if (sMonth.length() == 1)
					sMonth = "0" + Integer.toString(iMonth);
				if (sDay.length() == 1)
					sDay = "0" + Integer.toString(iDay);
				sTmpDate = sYear + sMonth + sDay;
				iLoopCnt++;
			}
		} else {
			iLoopCnt = 1;
			iDteCnt = iDteCnt * -1;
			while (iLoopCnt <= iDteCnt) {
				iDay--;
				sYear = Integer.toString(iYear);
				sMonth = Integer.toString(iMonth);
				sDay = Integer.toString(iDay);
				if (sMonth.length() == 1)
					sMonth = "0" + Integer.toString(iMonth);
				if (sDay.length() == 1)
					sDay = "0" + Integer.toString(iDay);

				if (iDay == 0) {
					iMonth--;
					if (iMonth == 0) {
						iMonth = 12;
						iYear--;
					}
					for (int il = 27; il <= 32; il++) {
						sYear = Integer.toString(iYear);
						sMonth = Integer.toString(iMonth);
						sDay = Integer.toString(il);
						if (sMonth.length() == 1)
							sMonth = "0" + Integer.toString(iMonth);
						if (sDay.length() == 1)
							sDay = "0" + Integer.toString(il);
						sTmpDate = sYear + sMonth + sDay;
						if (dateValid(sTmpDate) == false) {
							iDay = il - 1;
							sDay = Integer.toString(iDay);
							if (sDay.length() == 1)
								sDay = "0" + Integer.toString(il);
							break;
						}
					}
				}
				sTmpDate = sYear + sMonth + sDay;
				iLoopCnt++;
			}
		}
		return sTmpDate;
	}
	static public boolean dateValid(String src) {
		int year = 0;
		int month = 0;
		int day = 0;

		if (src.length() != 8)
			return false;

		try {
			year = Integer.parseInt(src.substring(0, 4));
			month = Integer.parseInt(src.substring(4, 6));
			day = Integer.parseInt(src.substring(6));
		} catch (Exception e) {
			return false;
		}

		// 辣斥 Flag
		boolean flag = false;

		// 涝仿罐篮 斥档 辣斥牢瘤 眉农
		if (year % 4 == 0) {
			flag = true;
			if (year % 100 == 0) {
				flag = false;
				if (year % 400 == 0) {
					flag = true;
				}
			}
		}

		int dayArray[] = new int[12];
		{
			dayArray[0] = 31;
			dayArray[1] = (flag) ? 29 : 28;
			dayArray[2] = 31;
			dayArray[3] = 30;
			dayArray[4] = 31;
			dayArray[5] = 30;
			dayArray[6] = 31;
			dayArray[7] = 31;
			dayArray[8] = 30;
			dayArray[9] = 31;
			dayArray[10] = 30;
			dayArray[11] = 31;
		}
		if (month < 1 || month > 12)
			return false;
		if (day < 1 || day > dayArray[month - 1])
			return false;

		return true;
	}
}