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