package xin.glue.ui.H.H01; /******** 制作轧线物料统计报表，做一个类拼出需要的值 这里把三班和四班的情况分开来考虑。这个类用来处理三班的情况 ************/ import java.math.BigDecimal; import java.text.DecimalFormat; import java.util.ArrayList; import java.util.LinkedHashMap; import java.util.List; 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 UIH090060Report extends PosActivity{ private final PosLog log = PosLogFactory.getLogger(getClass()); public String runActivity(PosContext context){ log.logInfo("======== UIH090060Report start " ); //查询时间 String[] PRD_YYYYMM = (String[])context.get("searchTime"); log.logInfo("======== UIH090060Report PRD_YYYYMM:"+PRD_YYYYMM[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; //这里需要从基础表中获取班次信息，并且根据相应的班次信息来获得班组。 //最后把每个班组的数据显示在页面上 // 这里的班次的时间段就由基础表维护。可能存在2班或者3班的情况，那么就是有值的就进行判断没有的就是没有设定的。 PosParameter paramSA = new PosParameter(); PosParameter paramSB = new PosParameter(); PosParameter paramSC = new PosParameter(); //这里获取三个班次相应的时间 String sqlA = "SELECT to_char(A.SM_EFNM) SM_EFNM,to_char(A.SM_ESNM) SM_ESNM FROM TBZ00_COMMCD A WHERE A.LG_CD = 'H07001' AND A.SM_CD = '1'"; String sqlB = "SELECT to_char(A.SM_EFNM) SM_EFNM,to_char(A.SM_ESNM) SM_ESNM,A.SHRXM FROM TBZ00_COMMCD A WHERE A.LG_CD = 'H07001' AND A.SM_CD = '2'"; String sqlC = "SELECT to_char(A.SM_EFNM) SM_EFNM,to_char(A.SM_ESNM) SM_ESNM FROM TBZ00_COMMCD A WHERE A.LG_CD = 'H07001' AND A.SM_CD = '3'"; PosRowSet ShiftA = getDao("mesdao").findByQueryStatement(sqlA, paramSA); PosRowSet ShiftB = getDao("mesdao").findByQueryStatement(sqlB, paramSB); PosRowSet ShiftC = getDao("mesdao").findByQueryStatement(sqlC, paramSC); String SM_EFNMA = null; String SM_ESNMA = null; String SM_EFNMB = null; String SM_ESNMB = null; //这里是中班是否超过0点指标。如果超过0点就判断早班和晚班的情况，其它为中班。如果不超过0点就判断早班和中班的情况，其它为晚班 String SHRXM = null; String SM_EFNMC = null; String SM_ESNMC = null; if(ShiftA.hasNext()){ PosRow ShiftAA = ShiftA.next(); SM_EFNMA = (String) ShiftAA.getAttribute("SM_EFNM"); SM_ESNMA = (String) ShiftAA.getAttribute("SM_ESNM"); } if(ShiftB.hasNext()){ PosRow ShiftBB = ShiftB.next(); SM_EFNMB = (String) ShiftBB.getAttribute("SM_EFNM"); SM_ESNMB = (String) ShiftBB.getAttribute("SM_ESNM"); SHRXM = (String) ShiftBB.getAttribute("SHRXM"); } if(ShiftC.hasNext()){ PosRow ShiftCC = ShiftC.next(); SM_EFNMC = (String) ShiftCC.getAttribute("SM_EFNM"); SM_ESNMC = (String) ShiftCC.getAttribute("SM_ESNM"); } //这里需要获取昨天和明天的时间 String ZDate = null; String MDate = null; //当前时间加一天 MDate = AddDateFunc(PRD_YYYYMM[0],1); //当前时间减一天 ZDate = AddDateFunc(PRD_YYYYMM[0],-1); //这里必须通过班次班组的维护定位到今天的班组来统计班组的月累计。并且两班的情况是昨天的晚班加今天的早班，三班的情况是昨天的晚班加今天的早班和中班 //在TBG02_SHIFT_GROUP中的对应关系是1对应早班,2对应中班,3对应晚班，4为休息 //早班班组 String GR_GROUP_CD_1 = null; //中班 String GR_GROUP_CD_2 = null; //晚班 String GR_GROUP_CD_3 = null; //两班的情况，获取相应的班组信息。今天的早班和昨天的晚班 String GR_SHIFT_1 = "1"; PosParameter paramG = new PosParameter(); paramG.setWhereClauseParameter(0, PRD_YYYYMM[0].substring(0, 6)); paramG.setWhereClauseParameter(1, PRD_YYYYMM[0].substring(6, PRD_YYYYMM[0].length())); paramG.setWhereClauseParameter(2, GR_SHIFT_1); PosRowSet GroupRstVO = this.getDao("mesdao").find("UIH090060_02.select", paramG); if(GroupRstVO.hasNext()){ PosRow GroupRstRow = GroupRstVO.next(); //班组 GR_GROUP_CD_1 = (String)GroupRstRow.getAttribute("GR_GROUP_CD"); } //晚班 String GR_SHIFT_3 = "3"; PosParameter paramGG = new PosParameter(); paramGG.setWhereClauseParameter(0, ZDate.substring(0, 6)); paramGG.setWhereClauseParameter(1, ZDate.substring(6, PRD_YYYYMM[0].length())); paramGG.setWhereClauseParameter(2, GR_SHIFT_3); PosRowSet GroupRstVO1 = this.getDao("mesdao").find("UIH090060_02.select", paramGG); if(GroupRstVO1.hasNext()){ PosRow GroupRstRow1 = GroupRstVO1.next(); //班组 GR_GROUP_CD_3 = (String)GroupRstRow1.getAttribute("GR_GROUP_CD"); } //这里还需要判断是两班还是三班的情况，并且根据是否过零点来取相应的时间段 if(SM_EFNMB == null || SM_ESNMB == null){ //两班的情况 //在指导班组的情况下，就根据班组来获取各个班的信息 //这里的结果肯定使用早班的时间段来计算 if(null != GR_GROUP_CD_1 && GR_GROUP_CD_1.equals("A")){ //这里是早班为甲班的情况 PosParameter param1 = new PosParameter(); //这里统计的时候需要给出具体的时间，即统计的时间段精确的YYYYMMDDHHMMSS //1 param1.setWhereClauseParameter(0, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(1, PRD_YYYYMM[0]+SM_ESNMA+"00"); //每个月的开始那天 param1.setWhereClauseParameter(2, "A"); param1.setWhereClauseParameter(3, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(4, PRD_YYYYMM[0]+SM_ESNMA+"00"); //2 param1.setWhereClauseParameter(5, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(6, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(7, "A"); param1.setWhereClauseParameter(8, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(9, PRD_YYYYMM[0]+SM_ESNMA+"00"); //3 param1.setWhereClauseParameter(10, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(11, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(12, "A"); param1.setWhereClauseParameter(13, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(14, PRD_YYYYMM[0]+SM_ESNMA+"00"); //4 param1.setWhereClauseParameter(15, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(16, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(17, "A"); param1.setWhereClauseParameter(18, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(19, PRD_YYYYMM[0]+SM_ESNMA+"00"); //5 param1.setWhereClauseParameter(20, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(21, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(22, "A"); param1.setWhereClauseParameter(23, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(24, PRD_YYYYMM[0]+SM_ESNMA+"00"); //6 param1.setWhereClauseParameter(25, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(26, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(27, "A"); param1.setWhereClauseParameter(28, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(29, PRD_YYYYMM[0]+SM_ESNMA+"00"); //7 param1.setWhereClauseParameter(30, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(31, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(32, "A"); param1.setWhereClauseParameter(33, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(34, PRD_YYYYMM[0]+SM_ESNMA+"00"); //8 param1.setWhereClauseParameter(35, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(36, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(37, "A"); param1.setWhereClauseParameter(38, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(39, PRD_YYYYMM[0]+SM_ESNMA+"00"); //9 param1.setWhereClauseParameter(40, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(41, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(42, "A"); param1.setWhereClauseParameter(43, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(44, PRD_YYYYMM[0]+SM_ESNMA+"00"); //10 param1.setWhereClauseParameter(45, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(46, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(47, "A"); param1.setWhereClauseParameter(48, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(49, PRD_YYYYMM[0]+SM_ESNMA+"00"); //11 param1.setWhereClauseParameter(50, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(51, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(52, "A"); param1.setWhereClauseParameter(53, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(54, PRD_YYYYMM[0]+SM_ESNMA+"00"); PosRowSet ARstVO = this.getDao("mesdao").find("UIH090060_04.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); } }else if(null != GR_GROUP_CD_1 && GR_GROUP_CD_1.equals("B")){ //这里是早班为乙班的情况 PosParameter param1 = new PosParameter(); //这里统计的时候需要给出具体的时间，即统计的时间段精确的YYYYMMDDHHMMSS //1 param1.setWhereClauseParameter(0, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(1, PRD_YYYYMM[0]+SM_ESNMA+"00"); //每个月的开始那天 param1.setWhereClauseParameter(2, "B"); param1.setWhereClauseParameter(3, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(4, PRD_YYYYMM[0]+SM_ESNMA+"00"); //2 param1.setWhereClauseParameter(5, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(6, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(7, "B"); param1.setWhereClauseParameter(8, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(9, PRD_YYYYMM[0]+SM_ESNMA+"00"); //3 param1.setWhereClauseParameter(10, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(11, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(12, "B"); param1.setWhereClauseParameter(13, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(14, PRD_YYYYMM[0]+SM_ESNMA+"00"); //4 param1.setWhereClauseParameter(15, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(16, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(17, "B"); param1.setWhereClauseParameter(18, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(19, PRD_YYYYMM[0]+SM_ESNMA+"00"); //5 param1.setWhereClauseParameter(20, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(21, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(22, "B"); param1.setWhereClauseParameter(23, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(24, PRD_YYYYMM[0]+SM_ESNMA+"00"); //6 param1.setWhereClauseParameter(25, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(26, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(27, "B"); param1.setWhereClauseParameter(28, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(29, PRD_YYYYMM[0]+SM_ESNMA+"00"); //7 param1.setWhereClauseParameter(30, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(31, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(32, "B"); param1.setWhereClauseParameter(33, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(34, PRD_YYYYMM[0]+SM_ESNMA+"00"); //8 param1.setWhereClauseParameter(35, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(36, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(37, "B"); param1.setWhereClauseParameter(38, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(39, PRD_YYYYMM[0]+SM_ESNMA+"00"); //9 param1.setWhereClauseParameter(40, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(41, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(42, "B"); param1.setWhereClauseParameter(43, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(44, PRD_YYYYMM[0]+SM_ESNMA+"00"); //10 param1.setWhereClauseParameter(45, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(46, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(47, "B"); param1.setWhereClauseParameter(48, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(49, PRD_YYYYMM[0]+SM_ESNMA+"00"); //11 param1.setWhereClauseParameter(50, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(51, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(52, "B"); param1.setWhereClauseParameter(53, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(54, PRD_YYYYMM[0]+SM_ESNMA+"00"); PosRowSet ARstVO = this.getDao("mesdao").find("UIH090060_04.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][6] = DAY_SLAB_CNT_A; EDIT_PROD[0][7] = MON_SLAB_CNT_A; EDIT_PROD[0][8] = String.valueOf(DAY_SLAB_WGT_A); EDIT_PROD[0][9] = 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][6] = DAY_COIL_CNT_A; EDIT_PROD[1][7] = MON_COIL_CNT_A; EDIT_PROD[1][8] = String.valueOf(DAY_COIL_WGT_A); EDIT_PROD[1][9] = 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][6] = DAY_GRD_1_CNT_A; EDIT_PROD[2][7] = MON_GRD_1_CNT_A; EDIT_PROD[2][8] = String.valueOf(DAY_GRD_1_WGT_A); EDIT_PROD[2][9] = 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][6] = DAY_GRD_2_CNT_A; EDIT_PROD[3][7] = MON_GRD_2_CNT_A; EDIT_PROD[3][8] = String.valueOf(DAY_GRD_2_WGT_A); EDIT_PROD[3][9] = 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][6] = DAY_REJ_CNT_A; EDIT_PROD[4][7] = MON_REJ_CNT_A; EDIT_PROD[4][8] = DAY_REJ_WGT_A; EDIT_PROD[4][9] = 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][6] = DAY_SCRAP_CNT_A; EDIT_PROD[5][7] = MON_SCRAP_CNT_A; EDIT_PROD[5][8] = DAY_SCRAP_WGT_A; EDIT_PROD[5][9] = 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][6] = DAY_MISSNO_CNT_A; EDIT_PROD[6][7] = MON_MISSNO_CNT_A; EDIT_PROD[6][8] = DAY_MISSNO_WGT_A; EDIT_PROD[6][9] = 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][6] = 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][7] = 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][6] = 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][7] = 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][6] = DAY_SIZE_CNT_A; EDIT_PROD[15][7] = MON_SIZE_CNT_A; EDIT_PROD[15][8] = String.valueOf(DAY_SIZE_WGT_A); EDIT_PROD[15][9] = 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][6] = DAY_EXTSHAPE_CNT_A; EDIT_PROD[16][7] = MON_EXTSHAPE_CNT_A; EDIT_PROD[16][8] = String.valueOf(DAY_EXTSHAPE_WGT_A); EDIT_PROD[16][9] = 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][6] = DAY_MATLQLTY_CNT_A; EDIT_PROD[17][7] = MON_MATLQLTY_CNT_A; EDIT_PROD[17][8] = String.valueOf(DAY_MATLQLTY_WGT_A); EDIT_PROD[17][9] = 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][6] = DAY_STL_CNT_A; EDIT_PROD[18][7] = MON_STL_CNT_A; EDIT_PROD[18][8] = String.valueOf(DAY_STL_WGT_A); EDIT_PROD[18][9] = 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][6] = String.valueOf(DAY_SUM_WGT_A_1); EDIT_PROD[19][7] = String.valueOf(MON_SUM_WGT_A_1); } }else if(null != GR_GROUP_CD_1 && GR_GROUP_CD_1.equals("C")){ //这里是早班为丙班的情况 PosParameter param1 = new PosParameter(); //这里统计的时候需要给出具体的时间，即统计的时间段精确的YYYYMMDDHHMMSS //1 param1.setWhereClauseParameter(0, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(1, PRD_YYYYMM[0]+SM_ESNMA+"00"); //每个月的开始那天 param1.setWhereClauseParameter(2, "C"); param1.setWhereClauseParameter(3, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(4, PRD_YYYYMM[0]+SM_ESNMA+"00"); //2 param1.setWhereClauseParameter(5, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(6, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(7, "C"); param1.setWhereClauseParameter(8, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(9, PRD_YYYYMM[0]+SM_ESNMA+"00"); //3 param1.setWhereClauseParameter(10, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(11, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(12, "C"); param1.setWhereClauseParameter(13, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(14, PRD_YYYYMM[0]+SM_ESNMA+"00"); //4 param1.setWhereClauseParameter(15, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(16, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(17, "C"); param1.setWhereClauseParameter(18, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(19, PRD_YYYYMM[0]+SM_ESNMA+"00"); //5 param1.setWhereClauseParameter(20, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(21, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(22, "C"); param1.setWhereClauseParameter(23, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(24, PRD_YYYYMM[0]+SM_ESNMA+"00"); //6 param1.setWhereClauseParameter(25, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(26, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(27, "C"); param1.setWhereClauseParameter(28, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(29, PRD_YYYYMM[0]+SM_ESNMA+"00"); //7 param1.setWhereClauseParameter(30, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(31, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(32, "C"); param1.setWhereClauseParameter(33, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(34, PRD_YYYYMM[0]+SM_ESNMA+"00"); //8 param1.setWhereClauseParameter(35, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(36, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(37, "C"); param1.setWhereClauseParameter(38, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(39, PRD_YYYYMM[0]+SM_ESNMA+"00"); //9 param1.setWhereClauseParameter(40, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(41, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(42, "C"); param1.setWhereClauseParameter(43, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(44, PRD_YYYYMM[0]+SM_ESNMA+"00"); //10 param1.setWhereClauseParameter(45, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(46, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(47, "C"); param1.setWhereClauseParameter(48, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(49, PRD_YYYYMM[0]+SM_ESNMA+"00"); //11 param1.setWhereClauseParameter(50, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(51, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(52, "C"); param1.setWhereClauseParameter(53, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(54, PRD_YYYYMM[0]+SM_ESNMA+"00"); PosRowSet ARstVO = this.getDao("mesdao").find("UIH090060_04.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][10] = DAY_SLAB_CNT_A; EDIT_PROD[0][11] = MON_SLAB_CNT_A; EDIT_PROD[0][12] = String.valueOf(DAY_SLAB_WGT_A); EDIT_PROD[0][13] = 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][10] = DAY_COIL_CNT_A; EDIT_PROD[1][11] = MON_COIL_CNT_A; EDIT_PROD[1][12] = String.valueOf(DAY_COIL_WGT_A); EDIT_PROD[1][13] = 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][10] = DAY_GRD_1_CNT_A; EDIT_PROD[2][11] = MON_GRD_1_CNT_A; EDIT_PROD[2][12] = String.valueOf(DAY_GRD_1_WGT_A); EDIT_PROD[2][13] = 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][10] = DAY_GRD_2_CNT_A; EDIT_PROD[3][11] = MON_GRD_2_CNT_A; EDIT_PROD[3][12] = String.valueOf(DAY_GRD_2_WGT_A); EDIT_PROD[3][13] = 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][10] = DAY_REJ_CNT_A; EDIT_PROD[4][11] = MON_REJ_CNT_A; EDIT_PROD[4][12] = DAY_REJ_WGT_A; EDIT_PROD[4][13] = 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][10] = DAY_SCRAP_CNT_A; EDIT_PROD[5][11] = MON_SCRAP_CNT_A; EDIT_PROD[5][12] = DAY_SCRAP_WGT_A; EDIT_PROD[5][13] = 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][10] = DAY_MISSNO_CNT_A; EDIT_PROD[6][11] = MON_MISSNO_CNT_A; EDIT_PROD[6][12] = DAY_MISSNO_WGT_A; EDIT_PROD[6][13] = 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][10] = 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][11] = 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][10] = 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][11] = 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][10] = DAY_SIZE_CNT_A; EDIT_PROD[15][11] = MON_SIZE_CNT_A; EDIT_PROD[15][12] = String.valueOf(DAY_SIZE_WGT_A); EDIT_PROD[15][13] = 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][10] = DAY_EXTSHAPE_CNT_A; EDIT_PROD[16][11] = MON_EXTSHAPE_CNT_A; EDIT_PROD[16][12] = String.valueOf(DAY_EXTSHAPE_WGT_A); EDIT_PROD[16][13] = 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][10] = DAY_MATLQLTY_CNT_A; EDIT_PROD[17][11] = MON_MATLQLTY_CNT_A; EDIT_PROD[17][12] = String.valueOf(DAY_MATLQLTY_WGT_A); EDIT_PROD[17][13] = 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][10] = DAY_STL_CNT_A; EDIT_PROD[18][11] = MON_STL_CNT_A; EDIT_PROD[18][12] = String.valueOf(DAY_STL_WGT_A); EDIT_PROD[18][13] = 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][10] = String.valueOf(DAY_SUM_WGT_A_1); EDIT_PROD[19][11] = String.valueOf(MON_SUM_WGT_A_1); } }else if(null != GR_GROUP_CD_1 && GR_GROUP_CD_1.equals("D")){ //这里是早班为丁班的情况 PosParameter param1 = new PosParameter(); //这里统计的时候需要给出具体的时间，即统计的时间段精确的YYYYMMDDHHMMSS //1 param1.setWhereClauseParameter(0, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(1, PRD_YYYYMM[0]+SM_ESNMA+"00"); //每个月的开始那天 param1.setWhereClauseParameter(2, "D"); param1.setWhereClauseParameter(3, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(4, PRD_YYYYMM[0]+SM_ESNMA+"00"); //2 param1.setWhereClauseParameter(5, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(6, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(7, "D"); param1.setWhereClauseParameter(8, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(9, PRD_YYYYMM[0]+SM_ESNMA+"00"); //3 param1.setWhereClauseParameter(10, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(11, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(12, "D"); param1.setWhereClauseParameter(13, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(14, PRD_YYYYMM[0]+SM_ESNMA+"00"); //4 param1.setWhereClauseParameter(15, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(16, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(17, "D"); param1.setWhereClauseParameter(18, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(19, PRD_YYYYMM[0]+SM_ESNMA+"00"); //5 param1.setWhereClauseParameter(20, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(21, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(22, "D"); param1.setWhereClauseParameter(23, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(24, PRD_YYYYMM[0]+SM_ESNMA+"00"); //6 param1.setWhereClauseParameter(25, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(26, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(27, "D"); param1.setWhereClauseParameter(28, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(29, PRD_YYYYMM[0]+SM_ESNMA+"00"); //7 param1.setWhereClauseParameter(30, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(31, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(32, "D"); param1.setWhereClauseParameter(33, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(34, PRD_YYYYMM[0]+SM_ESNMA+"00"); //8 param1.setWhereClauseParameter(35, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(36, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(37, "D"); param1.setWhereClauseParameter(38, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(39, PRD_YYYYMM[0]+SM_ESNMA+"00"); //9 param1.setWhereClauseParameter(40, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(41, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(42, "D"); param1.setWhereClauseParameter(43, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(44, PRD_YYYYMM[0]+SM_ESNMA+"00"); //10 param1.setWhereClauseParameter(45, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(46, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(47, "D"); param1.setWhereClauseParameter(48, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(49, PRD_YYYYMM[0]+SM_ESNMA+"00"); //11 param1.setWhereClauseParameter(50, PRD_YYYYMM[0]+SM_EFNMA+"00"); param1.setWhereClauseParameter(51, PRD_YYYYMM[0]+SM_ESNMA+"00"); param1.setWhereClauseParameter(52, "D"); param1.setWhereClauseParameter(53, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param1.setWhereClauseParameter(54, PRD_YYYYMM[0]+SM_ESNMA+"00"); PosRowSet ARstVO = this.getDao("mesdao").find("UIH090060_04.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][14] = DAY_SLAB_CNT_A; EDIT_PROD[0][15] = MON_SLAB_CNT_A; EDIT_PROD[0][16] = String.valueOf(DAY_SLAB_WGT_A); EDIT_PROD[0][17] = 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][14] = DAY_COIL_CNT_A; EDIT_PROD[1][15] = MON_COIL_CNT_A; EDIT_PROD[1][16] = String.valueOf(DAY_COIL_WGT_A); EDIT_PROD[1][17] = 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][14] = DAY_GRD_1_CNT_A; EDIT_PROD[2][15] = MON_GRD_1_CNT_A; EDIT_PROD[2][16] = String.valueOf(DAY_GRD_1_WGT_A); EDIT_PROD[2][17] = 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][14] = DAY_GRD_2_CNT_A; EDIT_PROD[3][15] = MON_GRD_2_CNT_A; EDIT_PROD[3][16] = String.valueOf(DAY_GRD_2_WGT_A); EDIT_PROD[3][17] = 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][14] = DAY_REJ_CNT_A; EDIT_PROD[4][15] = MON_REJ_CNT_A; EDIT_PROD[4][16] = DAY_REJ_WGT_A; EDIT_PROD[4][17] = 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][14] = DAY_SCRAP_CNT_A; EDIT_PROD[5][15] = MON_SCRAP_CNT_A; EDIT_PROD[5][16] = DAY_SCRAP_WGT_A; EDIT_PROD[5][17] = 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][14] = DAY_MISSNO_CNT_A; EDIT_PROD[6][15] = MON_MISSNO_CNT_A; EDIT_PROD[6][16] = DAY_MISSNO_WGT_A; EDIT_PROD[6][17] = 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][14] = 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][15] = 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][14] = 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][15] = 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][14] = DAY_SIZE_CNT_A; EDIT_PROD[15][15] = MON_SIZE_CNT_A; EDIT_PROD[15][16] = String.valueOf(DAY_SIZE_WGT_A); EDIT_PROD[15][17] = 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][14] = DAY_EXTSHAPE_CNT_A; EDIT_PROD[16][15] = MON_EXTSHAPE_CNT_A; EDIT_PROD[16][16] = String.valueOf(DAY_EXTSHAPE_WGT_A); EDIT_PROD[16][17] = 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][14] = DAY_MATLQLTY_CNT_A; EDIT_PROD[17][15] = MON_MATLQLTY_CNT_A; EDIT_PROD[17][16] = String.valueOf(DAY_MATLQLTY_WGT_A); EDIT_PROD[17][17] = 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][14] = DAY_STL_CNT_A; EDIT_PROD[18][15] = MON_STL_CNT_A; EDIT_PROD[18][16] = String.valueOf(DAY_STL_WGT_A); EDIT_PROD[18][17] = 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][14] = String.valueOf(DAY_SUM_WGT_A_1); EDIT_PROD[19][15] = String.valueOf(MON_SUM_WGT_A_1); } } //两班对晚班的处理 if(null != GR_GROUP_CD_3 && GR_GROUP_CD_3.equals("A")){ //这里统计晚班的相关产量，晚班是从昨天晚上到今天早上。日产量从昨天开始。月累计到今天结束 //通过查询语句，获取所需要的相关数据 PosParameter param2 = new PosParameter(); //1 param2.setWhereClauseParameter(0, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(1, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(2, "A"); param2.setWhereClauseParameter(3, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(4, PRD_YYYYMM[0]+SM_ESNMC+"00"); //2 param2.setWhereClauseParameter(5, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(6, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(7, "A"); param2.setWhereClauseParameter(8, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(9, PRD_YYYYMM[0]+SM_ESNMC+"00"); //3 param2.setWhereClauseParameter(10, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(11, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(12, "A"); param2.setWhereClauseParameter(13, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(14, PRD_YYYYMM[0]+SM_ESNMC+"00"); //4 param2.setWhereClauseParameter(15, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(16, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(17, "A"); param2.setWhereClauseParameter(18, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(19, PRD_YYYYMM[0]+SM_ESNMC+"00"); //5 param2.setWhereClauseParameter(20, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(21, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(22, "A"); param2.setWhereClauseParameter(23, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(24, PRD_YYYYMM[0]+SM_ESNMC+"00"); //6 param2.setWhereClauseParameter(25, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(26, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(27, "A"); param2.setWhereClauseParameter(28, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(29, PRD_YYYYMM[0]+SM_ESNMC+"00"); //7 param2.setWhereClauseParameter(30, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(31, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(32, "A"); param2.setWhereClauseParameter(33, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(34, PRD_YYYYMM[0]+SM_ESNMC+"00"); //8 param2.setWhereClauseParameter(35, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(36, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(37, "A"); param2.setWhereClauseParameter(38, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(39, PRD_YYYYMM[0]+SM_ESNMC+"00"); //9 param2.setWhereClauseParameter(40, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(41, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(42, "A"); param2.setWhereClauseParameter(43, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(44, PRD_YYYYMM[0]+SM_ESNMC+"00"); //10 param2.setWhereClauseParameter(45, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(46, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(47, "A"); param2.setWhereClauseParameter(48, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(49, PRD_YYYYMM[0]+SM_ESNMC+"00"); //11 param2.setWhereClauseParameter(50, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(51, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(52, "A"); param2.setWhereClauseParameter(53, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(54, PRD_YYYYMM[0]+SM_ESNMC+"00"); PosRowSet BRstVO = this.getDao("mesdao").find("UIH090060_04.select", param2); if(BRstVO.hasNext()){ // 获取中班的相应数据 PosRow BRstROW = BRstVO.next(); //原料 1 DAY_SLAB_CNT_C = (String)BRstROW.getAttribute("DAY_SLAB_CNT"); MON_SLAB_CNT_C = (String)BRstROW.getAttribute("MON_SLAB_CNT"); DAY_SLAB_WGT_C = (Number)BRstROW.getAttribute("DAY_SLAB_WGT"); MON_SLAB_WGT_C = (Number)BRstROW.getAttribute("MON_SLAB_WGT"); EDIT_PROD[0][2] = DAY_SLAB_CNT_C; EDIT_PROD[0][3] = MON_SLAB_CNT_C; EDIT_PROD[0][4] = String.valueOf(DAY_SLAB_WGT_C); EDIT_PROD[0][5] = String.valueOf(MON_SLAB_WGT_C); //产量 2 DAY_COIL_CNT_C = (String)BRstROW.getAttribute("DAY_COIL_CNT"); MON_COIL_CNT_C = (String)BRstROW.getAttribute("MON_COIL_CNT"); DAY_COIL_WGT_C = (Number)BRstROW.getAttribute("DAY_COIL_WGT"); MON_COIL_WGT_C = (Number)BRstROW.getAttribute("MON_COIL_WGT"); EDIT_PROD[1][2] = DAY_COIL_CNT_C; EDIT_PROD[1][3] = MON_COIL_CNT_C; EDIT_PROD[1][4] = String.valueOf(DAY_COIL_WGT_C); EDIT_PROD[1][5] = String.valueOf(MON_COIL_WGT_C); //合格品 3 DAY_GRD_1_CNT_C = (String)BRstROW.getAttribute("DAY_GRD_1_CNT"); MON_GRD_1_CNT_C = (String)BRstROW.getAttribute("MON_GRD_1_CNT"); DAY_GRD_1_WGT_C = (Number)BRstROW.getAttribute("DAY_GRD_1_WGT"); MON_GRD_1_WGT_C = (Number)BRstROW.getAttribute("MON_GRD_1_WGT"); EDIT_PROD[2][2] = DAY_GRD_1_CNT_C; EDIT_PROD[2][3] = MON_GRD_1_CNT_C; EDIT_PROD[2][4] = String.valueOf(DAY_GRD_1_WGT_C); EDIT_PROD[2][5] = String.valueOf(MON_GRD_1_WGT_C); //次品 4 DAY_GRD_2_CNT_C = (String)BRstROW.getAttribute("DAY_GRD_2_CNT"); MON_GRD_2_CNT_C = (String)BRstROW.getAttribute("MON_GRD_2_CNT"); DAY_GRD_2_WGT_C = (Number)BRstROW.getAttribute("DAY_GRD_2_WGT"); MON_GRD_2_WGT_C = (Number)BRstROW.getAttribute("MON_GRD_2_WGT"); EDIT_PROD[3][2] = DAY_GRD_2_CNT_C; EDIT_PROD[3][3] = MON_GRD_2_CNT_C; EDIT_PROD[3][4] = String.valueOf(DAY_GRD_2_WGT_C); EDIT_PROD[3][5] = String.valueOf(MON_GRD_2_WGT_C); //轧回 5 DAY_REJ_CNT_C = (String)BRstROW.getAttribute("DAY_REJ_CNT"); MON_REJ_CNT_C = (String)BRstROW.getAttribute("MON_REJ_CNT"); DAY_REJ_WGT_C = (String)BRstROW.getAttribute("DAY_REJ_WGT"); MON_REJ_WGT_C = (String)BRstROW.getAttribute("MON_REJ_WGT"); EDIT_PROD[4][2] = DAY_REJ_CNT_C; EDIT_PROD[4][3] = MON_REJ_CNT_C; EDIT_PROD[4][4] = DAY_REJ_WGT_C; EDIT_PROD[4][5] = MON_REJ_WGT_C; //轧废 6 DAY_SCRAP_CNT_C = (String)BRstROW.getAttribute("DAY_SCRAP_CNT"); MON_SCRAP_CNT_C = (String)BRstROW.getAttribute("MON_SCRAP_CNT"); DAY_SCRAP_WGT_C = (String)BRstROW.getAttribute("DAY_SCRAP_WGT"); MON_SCRAP_WGT_C = (String)BRstROW.getAttribute("MON_SCRAP_WGT"); EDIT_PROD[5][2] = DAY_SCRAP_CNT_C; EDIT_PROD[5][3] = MON_SCRAP_CNT_C; EDIT_PROD[5][4] = DAY_SCRAP_WGT_C; EDIT_PROD[5][5] = MON_SCRAP_WGT_C; //中板 7 DAY_MISSNO_CNT_C = (String)BRstROW.getAttribute("DAY_MISSNO_CNT"); MON_MISSNO_CNT_C = (String)BRstROW.getAttribute("MON_MISSNO_CNT"); DAY_MISSNO_WGT_C = (String)BRstROW.getAttribute("DAY_MISSNO_WGT"); MON_MISSNO_WGT_C = (String)BRstROW.getAttribute("MON_MISSNO_WGT"); EDIT_PROD[6][2] = DAY_MISSNO_CNT_C; EDIT_PROD[6][3] = MON_MISSNO_CNT_C; EDIT_PROD[6][4] = DAY_MISSNO_WGT_C; EDIT_PROD[6][5] = 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][2] = 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][3] = 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][2] = 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][3] = String.valueOf(MON_CS_L_WGT_C_1); //非计划（尺寸） 8 DAY_SIZE_CNT_C = (String)BRstROW.getAttribute("DAY_SIZE_CNT"); MON_SIZE_CNT_C = (String)BRstROW.getAttribute("MON_SIZE_CNT"); DAY_SIZE_WGT_C = (Number)BRstROW.getAttribute("DAY_SIZE_WGT"); MON_SIZE_WGT_C = (Number)BRstROW.getAttribute("MON_SIZE_WGT"); //第16行 EDIT_PROD[15][2] = DAY_SIZE_CNT_C; EDIT_PROD[15][3] = MON_SIZE_CNT_C; EDIT_PROD[15][4] = String.valueOf(DAY_SIZE_WGT_C); EDIT_PROD[15][5] = String.valueOf(MON_SIZE_WGT_C); //非计划（表面） 9 DAY_EXTSHAPE_CNT_C = (String)BRstROW.getAttribute("DAY_EXTSHAPE_CNT"); MON_EXTSHAPE_CNT_C = (String)BRstROW.getAttribute("MON_EXTSHAPE_CNT"); DAY_EXTSHAPE_WGT_C = (Number)BRstROW.getAttribute("DAY_EXTSHAPE_WGT"); MON_EXTSHAPE_WGT_C = (Number)BRstROW.getAttribute("MON_EXTSHAPE_WGT"); //第17行 EDIT_PROD[16][2] = DAY_EXTSHAPE_CNT_C; EDIT_PROD[16][3] = MON_EXTSHAPE_CNT_C; EDIT_PROD[16][4] = String.valueOf(DAY_EXTSHAPE_WGT_C); EDIT_PROD[16][5] = String.valueOf(MON_EXTSHAPE_WGT_C); //非计划（性能） 10 DAY_MATLQLTY_CNT_C = (String)BRstROW.getAttribute("DAY_MATLQLTY_CNT"); MON_MATLQLTY_CNT_C = (String)BRstROW.getAttribute("MON_MATLQLTY_CNT"); DAY_MATLQLTY_WGT_C = (Number)BRstROW.getAttribute("DAY_MATLQLTY_WGT"); MON_MATLQLTY_WGT_C = (Number)BRstROW.getAttribute("MON_MATLQLTY_WGT"); //第18行 EDIT_PROD[17][2] = DAY_MATLQLTY_CNT_C; EDIT_PROD[17][3] = MON_MATLQLTY_CNT_C; EDIT_PROD[17][4] = String.valueOf(DAY_MATLQLTY_WGT_C); EDIT_PROD[17][5] = String.valueOf(MON_MATLQLTY_WGT_C); //非计划（钢质） 11 DAY_STL_CNT_C = (String)BRstROW.getAttribute("DAY_STL_CNT"); MON_STL_CNT_C = (String)BRstROW.getAttribute("MON_STL_CNT"); DAY_STL_WGT_C = (Number)BRstROW.getAttribute("DAY_STL_WGT"); MON_STL_WGT_C = (Number)BRstROW.getAttribute("MON_STL_WGT"); //第19行 EDIT_PROD[18][2] = DAY_STL_CNT_C; EDIT_PROD[18][3] = MON_STL_CNT_C; EDIT_PROD[18][4] = String.valueOf(DAY_STL_WGT_C); EDIT_PROD[18][5] = 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][2] = String.valueOf(DAY_SUM_WGT_C_1); EDIT_PROD[19][3] = String.valueOf(MON_SUM_WGT_C_1); } }else if(null != GR_GROUP_CD_3 && GR_GROUP_CD_3.equals("B")){ // 这里统计晚班的相关产量，晚班是从昨天晚上到今天早上。日产量从昨天开始。月累计到今天结束 //通过查询语句，获取所需要的相关数据 PosParameter param2 = new PosParameter(); //1 param2.setWhereClauseParameter(0, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(1, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(2, "B"); param2.setWhereClauseParameter(3, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(4, PRD_YYYYMM[0]+SM_ESNMC+"00"); //2 param2.setWhereClauseParameter(5, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(6, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(7, "B"); param2.setWhereClauseParameter(8, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(9, PRD_YYYYMM[0]+SM_ESNMC+"00"); //3 param2.setWhereClauseParameter(10, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(11, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(12, "B"); param2.setWhereClauseParameter(13, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(14, PRD_YYYYMM[0]+SM_ESNMC+"00"); //4 param2.setWhereClauseParameter(15, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(16, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(17, "B"); param2.setWhereClauseParameter(18, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(19, PRD_YYYYMM[0]+SM_ESNMC+"00"); //5 param2.setWhereClauseParameter(20, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(21, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(22, "B"); param2.setWhereClauseParameter(23, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(24, PRD_YYYYMM[0]+SM_ESNMC+"00"); //6 param2.setWhereClauseParameter(25, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(26, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(27, "B"); param2.setWhereClauseParameter(28, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(29, PRD_YYYYMM[0]+SM_ESNMC+"00"); //7 param2.setWhereClauseParameter(30, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(31, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(32, "B"); param2.setWhereClauseParameter(33, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(34, PRD_YYYYMM[0]+SM_ESNMC+"00"); //8 param2.setWhereClauseParameter(35, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(36, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(37, "B"); param2.setWhereClauseParameter(38, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(39, PRD_YYYYMM[0]+SM_ESNMC+"00"); //9 param2.setWhereClauseParameter(40, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(41, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(42, "B"); param2.setWhereClauseParameter(43, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(44, PRD_YYYYMM[0]+SM_ESNMC+"00"); //10 param2.setWhereClauseParameter(45, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(46, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(47, "B"); param2.setWhereClauseParameter(48, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(49, PRD_YYYYMM[0]+SM_ESNMC+"00"); //11 param2.setWhereClauseParameter(50, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(51, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(52, "B"); param2.setWhereClauseParameter(53, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(54, PRD_YYYYMM[0]+SM_ESNMC+"00"); PosRowSet BRstVO = this.getDao("mesdao").find("UIH090060_04.select", param2); if(BRstVO.hasNext()){ //获取中班的相应数据 PosRow BRstROW = BRstVO.next(); //原料 1 DAY_SLAB_CNT_C = (String)BRstROW.getAttribute("DAY_SLAB_CNT"); MON_SLAB_CNT_C = (String)BRstROW.getAttribute("MON_SLAB_CNT"); DAY_SLAB_WGT_C = (Number)BRstROW.getAttribute("DAY_SLAB_WGT"); MON_SLAB_WGT_C = (Number)BRstROW.getAttribute("MON_SLAB_WGT"); EDIT_PROD[0][6] = DAY_SLAB_CNT_C; EDIT_PROD[0][7] = MON_SLAB_CNT_C; EDIT_PROD[0][8] = String.valueOf(DAY_SLAB_WGT_C); EDIT_PROD[0][9] = String.valueOf(MON_SLAB_WGT_C); //产量 2 DAY_COIL_CNT_C = (String)BRstROW.getAttribute("DAY_COIL_CNT"); MON_COIL_CNT_C = (String)BRstROW.getAttribute("MON_COIL_CNT"); DAY_COIL_WGT_C = (Number)BRstROW.getAttribute("DAY_COIL_WGT"); MON_COIL_WGT_C = (Number)BRstROW.getAttribute("MON_COIL_WGT"); EDIT_PROD[1][6] = DAY_COIL_CNT_C; EDIT_PROD[1][7] = MON_COIL_CNT_C; EDIT_PROD[1][8] = String.valueOf(DAY_COIL_WGT_C); EDIT_PROD[1][9] = String.valueOf(MON_COIL_WGT_C); //合格品 3 DAY_GRD_1_CNT_C = (String)BRstROW.getAttribute("DAY_GRD_1_CNT"); MON_GRD_1_CNT_C = (String)BRstROW.getAttribute("MON_GRD_1_CNT"); DAY_GRD_1_WGT_C = (Number)BRstROW.getAttribute("DAY_GRD_1_WGT"); MON_GRD_1_WGT_C = (Number)BRstROW.getAttribute("MON_GRD_1_WGT"); EDIT_PROD[2][6] = DAY_GRD_1_CNT_C; EDIT_PROD[2][7] = MON_GRD_1_CNT_C; EDIT_PROD[2][8] = String.valueOf(DAY_GRD_1_WGT_C); EDIT_PROD[2][9] = String.valueOf(MON_GRD_1_WGT_C); //次品 4 DAY_GRD_2_CNT_C = (String)BRstROW.getAttribute("DAY_GRD_2_CNT"); MON_GRD_2_CNT_C = (String)BRstROW.getAttribute("MON_GRD_2_CNT"); DAY_GRD_2_WGT_C = (Number)BRstROW.getAttribute("DAY_GRD_2_WGT"); MON_GRD_2_WGT_C = (Number)BRstROW.getAttribute("MON_GRD_2_WGT"); EDIT_PROD[3][6] = DAY_GRD_2_CNT_C; EDIT_PROD[3][7] = MON_GRD_2_CNT_C; EDIT_PROD[3][8] = String.valueOf(DAY_GRD_2_WGT_C); EDIT_PROD[3][9] = String.valueOf(MON_GRD_2_WGT_C); //轧回 5 DAY_REJ_CNT_C = (String)BRstROW.getAttribute("DAY_REJ_CNT"); MON_REJ_CNT_C = (String)BRstROW.getAttribute("MON_REJ_CNT"); DAY_REJ_WGT_C = (String)BRstROW.getAttribute("DAY_REJ_WGT"); MON_REJ_WGT_C = (String)BRstROW.getAttribute("MON_REJ_WGT"); EDIT_PROD[4][6] = DAY_REJ_CNT_C; EDIT_PROD[4][7] = MON_REJ_CNT_C; EDIT_PROD[4][8] = DAY_REJ_WGT_C; EDIT_PROD[4][9] = MON_REJ_WGT_C; //轧废 6 DAY_SCRAP_CNT_C = (String)BRstROW.getAttribute("DAY_SCRAP_CNT"); MON_SCRAP_CNT_C = (String)BRstROW.getAttribute("MON_SCRAP_CNT"); DAY_SCRAP_WGT_C = (String)BRstROW.getAttribute("DAY_SCRAP_WGT"); MON_SCRAP_WGT_C = (String)BRstROW.getAttribute("MON_SCRAP_WGT"); EDIT_PROD[5][6] = DAY_SCRAP_CNT_C; EDIT_PROD[5][7] = MON_SCRAP_CNT_C; EDIT_PROD[5][8] = DAY_SCRAP_WGT_C; EDIT_PROD[5][9] = MON_SCRAP_WGT_C; //中板 7 DAY_MISSNO_CNT_C = (String)BRstROW.getAttribute("DAY_MISSNO_CNT"); MON_MISSNO_CNT_C = (String)BRstROW.getAttribute("MON_MISSNO_CNT"); DAY_MISSNO_WGT_C = (String)BRstROW.getAttribute("DAY_MISSNO_WGT"); MON_MISSNO_WGT_C = (String)BRstROW.getAttribute("MON_MISSNO_WGT"); EDIT_PROD[6][6] = DAY_MISSNO_CNT_C; EDIT_PROD[6][7] = MON_MISSNO_CNT_C; EDIT_PROD[6][8] = DAY_MISSNO_WGT_C; EDIT_PROD[6][9] = 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][6] = 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][7] = 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][6] = 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][7] = String.valueOf(MON_CS_L_WGT_C_1); //非计划（尺寸） 8 DAY_SIZE_CNT_C = (String)BRstROW.getAttribute("DAY_SIZE_CNT"); MON_SIZE_CNT_C = (String)BRstROW.getAttribute("MON_SIZE_CNT"); DAY_SIZE_WGT_C = (Number)BRstROW.getAttribute("DAY_SIZE_WGT"); MON_SIZE_WGT_C = (Number)BRstROW.getAttribute("MON_SIZE_WGT"); //第16行 EDIT_PROD[15][6] = DAY_SIZE_CNT_C; EDIT_PROD[15][7] = MON_SIZE_CNT_C; EDIT_PROD[15][8] = String.valueOf(DAY_SIZE_WGT_C); EDIT_PROD[15][9] = String.valueOf(MON_SIZE_WGT_C); //非计划（表面） 9 DAY_EXTSHAPE_CNT_C = (String)BRstROW.getAttribute("DAY_EXTSHAPE_CNT"); MON_EXTSHAPE_CNT_C = (String)BRstROW.getAttribute("MON_EXTSHAPE_CNT"); DAY_EXTSHAPE_WGT_C = (Number)BRstROW.getAttribute("DAY_EXTSHAPE_WGT"); MON_EXTSHAPE_WGT_C = (Number)BRstROW.getAttribute("MON_EXTSHAPE_WGT"); //第17行 EDIT_PROD[16][6] = DAY_EXTSHAPE_CNT_C; EDIT_PROD[16][7] = MON_EXTSHAPE_CNT_C; EDIT_PROD[16][8] = String.valueOf(DAY_EXTSHAPE_WGT_C); EDIT_PROD[16][9] = String.valueOf(MON_EXTSHAPE_WGT_C); //非计划（性能） 10 DAY_MATLQLTY_CNT_C = (String)BRstROW.getAttribute("DAY_MATLQLTY_CNT"); MON_MATLQLTY_CNT_C = (String)BRstROW.getAttribute("MON_MATLQLTY_CNT"); DAY_MATLQLTY_WGT_C = (Number)BRstROW.getAttribute("DAY_MATLQLTY_WGT"); MON_MATLQLTY_WGT_C = (Number)BRstROW.getAttribute("MON_MATLQLTY_WGT"); //第18行 EDIT_PROD[17][6] = DAY_MATLQLTY_CNT_C; EDIT_PROD[17][7] = MON_MATLQLTY_CNT_C; EDIT_PROD[17][8] = String.valueOf(DAY_MATLQLTY_WGT_C); EDIT_PROD[17][9] = String.valueOf(MON_MATLQLTY_WGT_C); //非计划（钢质） 11 DAY_STL_CNT_C = (String)BRstROW.getAttribute("DAY_STL_CNT"); MON_STL_CNT_C = (String)BRstROW.getAttribute("MON_STL_CNT"); DAY_STL_WGT_C = (Number)BRstROW.getAttribute("DAY_STL_WGT"); MON_STL_WGT_C = (Number)BRstROW.getAttribute("MON_STL_WGT"); //第19行 EDIT_PROD[18][6] = DAY_STL_CNT_C; EDIT_PROD[18][7] = MON_STL_CNT_C; EDIT_PROD[18][8] = String.valueOf(DAY_STL_WGT_C); EDIT_PROD[18][9] = 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][6] = String.valueOf(DAY_SUM_WGT_C_1); EDIT_PROD[19][7] = String.valueOf(MON_SUM_WGT_C_1); } }else if(null != GR_GROUP_CD_3 && GR_GROUP_CD_3.equals("C")){ // 这里统计晚班的相关产量，晚班是从昨天晚上到今天早上。日产量从昨天开始。月累计到今天结束 //通过查询语句，获取所需要的相关数据 PosParameter param2 = new PosParameter(); //1 param2.setWhereClauseParameter(0, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(1, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(2, "C"); param2.setWhereClauseParameter(3, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(4, PRD_YYYYMM[0]+SM_ESNMC+"00"); //2 param2.setWhereClauseParameter(5, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(6, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(7, "C"); param2.setWhereClauseParameter(8, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(9, PRD_YYYYMM[0]+SM_ESNMC+"00"); //3 param2.setWhereClauseParameter(10, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(11, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(12, "C"); param2.setWhereClauseParameter(13, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(14, PRD_YYYYMM[0]+SM_ESNMC+"00"); //4 param2.setWhereClauseParameter(15, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(16, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(17, "C"); param2.setWhereClauseParameter(18, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(19, PRD_YYYYMM[0]+SM_ESNMC+"00"); //5 param2.setWhereClauseParameter(20, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(21, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(22, "C"); param2.setWhereClauseParameter(23, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(24, PRD_YYYYMM[0]+SM_ESNMC+"00"); //6 param2.setWhereClauseParameter(25, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(26, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(27, "C"); param2.setWhereClauseParameter(28, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(29, PRD_YYYYMM[0]+SM_ESNMC+"00"); //7 param2.setWhereClauseParameter(30, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(31, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(32, "C"); param2.setWhereClauseParameter(33, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(34, PRD_YYYYMM[0]+SM_ESNMC+"00"); //8 param2.setWhereClauseParameter(35, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(36, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(37, "C"); param2.setWhereClauseParameter(38, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(39, PRD_YYYYMM[0]+SM_ESNMC+"00"); //9 param2.setWhereClauseParameter(40, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(41, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(42, "C"); param2.setWhereClauseParameter(43, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(44, PRD_YYYYMM[0]+SM_ESNMC+"00"); //10 param2.setWhereClauseParameter(45, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(46, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(47, "C"); param2.setWhereClauseParameter(48, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(49, PRD_YYYYMM[0]+SM_ESNMC+"00"); //11 param2.setWhereClauseParameter(50, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(51, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(52, "C"); param2.setWhereClauseParameter(53, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(54, PRD_YYYYMM[0]+SM_ESNMC+"00"); PosRowSet BRstVO = this.getDao("mesdao").find("UIH090060_04.select", param2); if(BRstVO.hasNext()){ //获取中班的相应数据 PosRow BRstROW = BRstVO.next(); //原料 1 DAY_SLAB_CNT_C = (String)BRstROW.getAttribute("DAY_SLAB_CNT"); MON_SLAB_CNT_C = (String)BRstROW.getAttribute("MON_SLAB_CNT"); DAY_SLAB_WGT_C = (Number)BRstROW.getAttribute("DAY_SLAB_WGT"); MON_SLAB_WGT_C = (Number)BRstROW.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)BRstROW.getAttribute("DAY_COIL_CNT"); MON_COIL_CNT_C = (String)BRstROW.getAttribute("MON_COIL_CNT"); DAY_COIL_WGT_C = (Number)BRstROW.getAttribute("DAY_COIL_WGT"); MON_COIL_WGT_C = (Number)BRstROW.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)BRstROW.getAttribute("DAY_GRD_1_CNT"); MON_GRD_1_CNT_C = (String)BRstROW.getAttribute("MON_GRD_1_CNT"); DAY_GRD_1_WGT_C = (Number)BRstROW.getAttribute("DAY_GRD_1_WGT"); MON_GRD_1_WGT_C = (Number)BRstROW.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)BRstROW.getAttribute("DAY_GRD_2_CNT"); MON_GRD_2_CNT_C = (String)BRstROW.getAttribute("MON_GRD_2_CNT"); DAY_GRD_2_WGT_C = (Number)BRstROW.getAttribute("DAY_GRD_2_WGT"); MON_GRD_2_WGT_C = (Number)BRstROW.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)BRstROW.getAttribute("DAY_REJ_CNT"); MON_REJ_CNT_C = (String)BRstROW.getAttribute("MON_REJ_CNT"); DAY_REJ_WGT_C = (String)BRstROW.getAttribute("DAY_REJ_WGT"); MON_REJ_WGT_C = (String)BRstROW.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)BRstROW.getAttribute("DAY_SCRAP_CNT"); MON_SCRAP_CNT_C = (String)BRstROW.getAttribute("MON_SCRAP_CNT"); DAY_SCRAP_WGT_C = (String)BRstROW.getAttribute("DAY_SCRAP_WGT"); MON_SCRAP_WGT_C = (String)BRstROW.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)BRstROW.getAttribute("DAY_MISSNO_CNT"); MON_MISSNO_CNT_C = (String)BRstROW.getAttribute("MON_MISSNO_CNT"); DAY_MISSNO_WGT_C = (String)BRstROW.getAttribute("DAY_MISSNO_WGT"); MON_MISSNO_WGT_C = (String)BRstROW.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)BRstROW.getAttribute("DAY_SIZE_CNT"); MON_SIZE_CNT_C = (String)BRstROW.getAttribute("MON_SIZE_CNT"); DAY_SIZE_WGT_C = (Number)BRstROW.getAttribute("DAY_SIZE_WGT"); MON_SIZE_WGT_C = (Number)BRstROW.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)BRstROW.getAttribute("DAY_EXTSHAPE_CNT"); MON_EXTSHAPE_CNT_C = (String)BRstROW.getAttribute("MON_EXTSHAPE_CNT"); DAY_EXTSHAPE_WGT_C = (Number)BRstROW.getAttribute("DAY_EXTSHAPE_WGT"); MON_EXTSHAPE_WGT_C = (Number)BRstROW.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)BRstROW.getAttribute("DAY_MATLQLTY_CNT"); MON_MATLQLTY_CNT_C = (String)BRstROW.getAttribute("MON_MATLQLTY_CNT"); DAY_MATLQLTY_WGT_C = (Number)BRstROW.getAttribute("DAY_MATLQLTY_WGT"); MON_MATLQLTY_WGT_C = (Number)BRstROW.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)BRstROW.getAttribute("DAY_STL_CNT"); MON_STL_CNT_C = (String)BRstROW.getAttribute("MON_STL_CNT"); DAY_STL_WGT_C = (Number)BRstROW.getAttribute("DAY_STL_WGT"); MON_STL_WGT_C = (Number)BRstROW.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); } }else if(null != GR_GROUP_CD_3 && GR_GROUP_CD_3.equals("D")){ // 这里统计晚班的相关产量，晚班是从昨天晚上到今天早上。日产量从昨天开始。月累计到今天结束 //通过查询语句，获取所需要的相关数据 PosParameter param2 = new PosParameter(); //1 param2.setWhereClauseParameter(0, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(1, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(2, "D"); param2.setWhereClauseParameter(3, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(4, PRD_YYYYMM[0]+SM_ESNMC+"00"); //2 param2.setWhereClauseParameter(5, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(6, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(7, "D"); param2.setWhereClauseParameter(8, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(9, PRD_YYYYMM[0]+SM_ESNMC+"00"); //3 param2.setWhereClauseParameter(10, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(11, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(12, "D"); param2.setWhereClauseParameter(13, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(14, PRD_YYYYMM[0]+SM_ESNMC+"00"); //4 param2.setWhereClauseParameter(15, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(16, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(17, "D"); param2.setWhereClauseParameter(18, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(19, PRD_YYYYMM[0]+SM_ESNMC+"00"); //5 param2.setWhereClauseParameter(20, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(21, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(22, "D"); param2.setWhereClauseParameter(23, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(24, PRD_YYYYMM[0]+SM_ESNMC+"00"); //6 param2.setWhereClauseParameter(25, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(26, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(27, "D"); param2.setWhereClauseParameter(28, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(29, PRD_YYYYMM[0]+SM_ESNMC+"00"); //7 param2.setWhereClauseParameter(30, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(31, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(32, "D"); param2.setWhereClauseParameter(33, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(34, PRD_YYYYMM[0]+SM_ESNMC+"00"); //8 param2.setWhereClauseParameter(35, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(36, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(37, "D"); param2.setWhereClauseParameter(38, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(39, PRD_YYYYMM[0]+SM_ESNMC+"00"); //9 param2.setWhereClauseParameter(40, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(41, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(42, "D"); param2.setWhereClauseParameter(43, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(44, PRD_YYYYMM[0]+SM_ESNMC+"00"); //10 param2.setWhereClauseParameter(45, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(46, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(47, "D"); param2.setWhereClauseParameter(48, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(49, PRD_YYYYMM[0]+SM_ESNMC+"00"); //11 param2.setWhereClauseParameter(50, ZDate+SM_EFNMC+"00"); param2.setWhereClauseParameter(51, PRD_YYYYMM[0]+SM_ESNMC+"00"); param2.setWhereClauseParameter(52, "D"); param2.setWhereClauseParameter(53, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param2.setWhereClauseParameter(54, PRD_YYYYMM[0]+SM_ESNMC+"00"); PosRowSet BRstVO = this.getDao("mesdao").find("UIH090060_04.select", param2); if(BRstVO.hasNext()){ //获取中班的相应数据 PosRow BRstROW = BRstVO.next(); //原料 1 DAY_SLAB_CNT_C = (String)BRstROW.getAttribute("DAY_SLAB_CNT"); MON_SLAB_CNT_C = (String)BRstROW.getAttribute("MON_SLAB_CNT"); DAY_SLAB_WGT_C = (Number)BRstROW.getAttribute("DAY_SLAB_WGT"); MON_SLAB_WGT_C = (Number)BRstROW.getAttribute("MON_SLAB_WGT"); EDIT_PROD[0][14] = DAY_SLAB_CNT_C; EDIT_PROD[0][15] = MON_SLAB_CNT_C; EDIT_PROD[0][16] = String.valueOf(DAY_SLAB_WGT_C); EDIT_PROD[0][17] = String.valueOf(MON_SLAB_WGT_C); //产量 2 DAY_COIL_CNT_C = (String)BRstROW.getAttribute("DAY_COIL_CNT"); MON_COIL_CNT_C = (String)BRstROW.getAttribute("MON_COIL_CNT"); DAY_COIL_WGT_C = (Number)BRstROW.getAttribute("DAY_COIL_WGT"); MON_COIL_WGT_C = (Number)BRstROW.getAttribute("MON_COIL_WGT"); EDIT_PROD[1][14] = DAY_COIL_CNT_C; EDIT_PROD[1][15] = MON_COIL_CNT_C; EDIT_PROD[1][16] = String.valueOf(DAY_COIL_WGT_C); EDIT_PROD[1][17] = String.valueOf(MON_COIL_WGT_C); //合格品 3 DAY_GRD_1_CNT_C = (String)BRstROW.getAttribute("DAY_GRD_1_CNT"); MON_GRD_1_CNT_C = (String)BRstROW.getAttribute("MON_GRD_1_CNT"); DAY_GRD_1_WGT_C = (Number)BRstROW.getAttribute("DAY_GRD_1_WGT"); MON_GRD_1_WGT_C = (Number)BRstROW.getAttribute("MON_GRD_1_WGT"); EDIT_PROD[2][14] = DAY_GRD_1_CNT_C; EDIT_PROD[2][15] = MON_GRD_1_CNT_C; EDIT_PROD[2][16] = String.valueOf(DAY_GRD_1_WGT_C); EDIT_PROD[2][17] = String.valueOf(MON_GRD_1_WGT_C); //次品 4 DAY_GRD_2_CNT_C = (String)BRstROW.getAttribute("DAY_GRD_2_CNT"); MON_GRD_2_CNT_C = (String)BRstROW.getAttribute("MON_GRD_2_CNT"); DAY_GRD_2_WGT_C = (Number)BRstROW.getAttribute("DAY_GRD_2_WGT"); MON_GRD_2_WGT_C = (Number)BRstROW.getAttribute("MON_GRD_2_WGT"); EDIT_PROD[3][14] = DAY_GRD_2_CNT_C; EDIT_PROD[3][15] = MON_GRD_2_CNT_C; EDIT_PROD[3][16] = String.valueOf(DAY_GRD_2_WGT_C); EDIT_PROD[3][17] = String.valueOf(MON_GRD_2_WGT_C); //轧回 5 DAY_REJ_CNT_C = (String)BRstROW.getAttribute("DAY_REJ_CNT"); MON_REJ_CNT_C = (String)BRstROW.getAttribute("MON_REJ_CNT"); DAY_REJ_WGT_C = (String)BRstROW.getAttribute("DAY_REJ_WGT"); MON_REJ_WGT_C = (String)BRstROW.getAttribute("MON_REJ_WGT"); EDIT_PROD[4][14] = DAY_REJ_CNT_C; EDIT_PROD[4][15] = MON_REJ_CNT_C; EDIT_PROD[4][16] = DAY_REJ_WGT_C; EDIT_PROD[4][17] = MON_REJ_WGT_C; //轧废 6 DAY_SCRAP_CNT_C = (String)BRstROW.getAttribute("DAY_SCRAP_CNT"); MON_SCRAP_CNT_C = (String)BRstROW.getAttribute("MON_SCRAP_CNT"); DAY_SCRAP_WGT_C = (String)BRstROW.getAttribute("DAY_SCRAP_WGT"); MON_SCRAP_WGT_C = (String)BRstROW.getAttribute("MON_SCRAP_WGT"); EDIT_PROD[5][14] = DAY_SCRAP_CNT_C; EDIT_PROD[5][15] = MON_SCRAP_CNT_C; EDIT_PROD[5][16] = DAY_SCRAP_WGT_C; EDIT_PROD[5][17] = MON_SCRAP_WGT_C; //中板 7 DAY_MISSNO_CNT_C = (String)BRstROW.getAttribute("DAY_MISSNO_CNT"); MON_MISSNO_CNT_C = (String)BRstROW.getAttribute("MON_MISSNO_CNT"); DAY_MISSNO_WGT_C = (String)BRstROW.getAttribute("DAY_MISSNO_WGT"); MON_MISSNO_WGT_C = (String)BRstROW.getAttribute("MON_MISSNO_WGT"); EDIT_PROD[6][14] = DAY_MISSNO_CNT_C; EDIT_PROD[6][15] = MON_MISSNO_CNT_C; EDIT_PROD[6][16] = DAY_MISSNO_WGT_C; EDIT_PROD[6][17] = 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][14] = 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][15] = 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][14] = 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][15] = String.valueOf(MON_CS_L_WGT_C_1); //非计划（尺寸） 8 DAY_SIZE_CNT_C = (String)BRstROW.getAttribute("DAY_SIZE_CNT"); MON_SIZE_CNT_C = (String)BRstROW.getAttribute("MON_SIZE_CNT"); DAY_SIZE_WGT_C = (Number)BRstROW.getAttribute("DAY_SIZE_WGT"); MON_SIZE_WGT_C = (Number)BRstROW.getAttribute("MON_SIZE_WGT"); //第16行 EDIT_PROD[15][14] = DAY_SIZE_CNT_C; EDIT_PROD[15][15] = MON_SIZE_CNT_C; EDIT_PROD[15][16] = String.valueOf(DAY_SIZE_WGT_C); EDIT_PROD[15][17] = String.valueOf(MON_SIZE_WGT_C); //非计划（表面） 9 DAY_EXTSHAPE_CNT_C = (String)BRstROW.getAttribute("DAY_EXTSHAPE_CNT"); MON_EXTSHAPE_CNT_C = (String)BRstROW.getAttribute("MON_EXTSHAPE_CNT"); DAY_EXTSHAPE_WGT_C = (Number)BRstROW.getAttribute("DAY_EXTSHAPE_WGT"); MON_EXTSHAPE_WGT_C = (Number)BRstROW.getAttribute("MON_EXTSHAPE_WGT"); //第17行 EDIT_PROD[16][14] = DAY_EXTSHAPE_CNT_C; EDIT_PROD[16][15] = MON_EXTSHAPE_CNT_C; EDIT_PROD[16][16] = String.valueOf(DAY_EXTSHAPE_WGT_C); EDIT_PROD[16][17] = String.valueOf(MON_EXTSHAPE_WGT_C); //非计划（性能） 10 DAY_MATLQLTY_CNT_C = (String)BRstROW.getAttribute("DAY_MATLQLTY_CNT"); MON_MATLQLTY_CNT_C = (String)BRstROW.getAttribute("MON_MATLQLTY_CNT"); DAY_MATLQLTY_WGT_C = (Number)BRstROW.getAttribute("DAY_MATLQLTY_WGT"); MON_MATLQLTY_WGT_C = (Number)BRstROW.getAttribute("MON_MATLQLTY_WGT"); //第18行 EDIT_PROD[17][14] = DAY_MATLQLTY_CNT_C; EDIT_PROD[17][15] = MON_MATLQLTY_CNT_C; EDIT_PROD[17][16] = String.valueOf(DAY_MATLQLTY_WGT_C); EDIT_PROD[17][17] = String.valueOf(MON_MATLQLTY_WGT_C); //非计划（钢质） 11 DAY_STL_CNT_C = (String)BRstROW.getAttribute("DAY_STL_CNT"); MON_STL_CNT_C = (String)BRstROW.getAttribute("MON_STL_CNT"); DAY_STL_WGT_C = (Number)BRstROW.getAttribute("DAY_STL_WGT"); MON_STL_WGT_C = (Number)BRstROW.getAttribute("MON_STL_WGT"); //第19行 EDIT_PROD[18][14] = DAY_STL_CNT_C; EDIT_PROD[18][15] = MON_STL_CNT_C; EDIT_PROD[18][16] = String.valueOf(DAY_STL_WGT_C); EDIT_PROD[18][17] = 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][14] = String.valueOf(DAY_SUM_WGT_C_1); EDIT_PROD[19][15] = String.valueOf(MON_SUM_WGT_C_1); } } } //这里加入对能耗和停轧时间的统计 //煤气耗量 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; //停轧合计 Number TZ_D = null; Number MON_TZ_D = null; //这里获取能耗和停轧时间数据，各个班组分开取。并把相应的值放入班组中 PosParameter param11 = new PosParameter(); //这里开始要获取能耗和停轧时间等信息 甲班的信息 //煤气 param11.setWhereClauseParameter(0, "A"); param11.setWhereClauseParameter(1, PRD_YYYYMM[0]); param11.setWhereClauseParameter(2, "A"); param11.setWhereClauseParameter(3, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(4, PRD_YYYYMM[0]); //电 param11.setWhereClauseParameter(5, "A"); param11.setWhereClauseParameter(6, PRD_YYYYMM[0]); param11.setWhereClauseParameter(7, "A"); param11.setWhereClauseParameter(8, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(9, PRD_YYYYMM[0]); //水 param11.setWhereClauseParameter(10, "A"); param11.setWhereClauseParameter(11, PRD_YYYYMM[0]); param11.setWhereClauseParameter(12, "A"); param11.setWhereClauseParameter(13, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(14, PRD_YYYYMM[0]); //空气 param11.setWhereClauseParameter(15, "A"); param11.setWhereClauseParameter(16, PRD_YYYYMM[0]); param11.setWhereClauseParameter(17, "A"); param11.setWhereClauseParameter(18, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(19, PRD_YYYYMM[0]); //辊耗 param11.setWhereClauseParameter(20, "A"); param11.setWhereClauseParameter(21, PRD_YYYYMM[0]); param11.setWhereClauseParameter(22, "A"); param11.setWhereClauseParameter(23, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(24, PRD_YYYYMM[0]); //停轧时间 机械 param11.setWhereClauseParameter(25, "A"); param11.setWhereClauseParameter(26, PRD_YYYYMM[0]); param11.setWhereClauseParameter(27, "A"); param11.setWhereClauseParameter(28, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(29, PRD_YYYYMM[0]); //停轧时间 电器 param11.setWhereClauseParameter(30, "A"); param11.setWhereClauseParameter(31, PRD_YYYYMM[0]); param11.setWhereClauseParameter(32, "A"); param11.setWhereClauseParameter(33, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(34, PRD_YYYYMM[0]); //停轧时间 轧钢 param11.setWhereClauseParameter(35, "A"); param11.setWhereClauseParameter(36, PRD_YYYYMM[0]); param11.setWhereClauseParameter(37, "A"); param11.setWhereClauseParameter(38, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(39, PRD_YYYYMM[0]); //停轧时间 换辊 param11.setWhereClauseParameter(40, "A"); param11.setWhereClauseParameter(41, PRD_YYYYMM[0]); param11.setWhereClauseParameter(42, "A"); param11.setWhereClauseParameter(43, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(44, PRD_YYYYMM[0]); //停轧时间 检修 param11.setWhereClauseParameter(45, "A"); param11.setWhereClauseParameter(46, PRD_YYYYMM[0]); param11.setWhereClauseParameter(47, "A"); param11.setWhereClauseParameter(48, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(49, PRD_YYYYMM[0]); //停轧时间 外部 param11.setWhereClauseParameter(50, "A"); param11.setWhereClauseParameter(51, PRD_YYYYMM[0]); param11.setWhereClauseParameter(52, "A"); param11.setWhereClauseParameter(53, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(54, PRD_YYYYMM[0]); //停轧时间 原成 param11.setWhereClauseParameter(55, "A"); param11.setWhereClauseParameter(56, PRD_YYYYMM[0]); param11.setWhereClauseParameter(57, "A"); param11.setWhereClauseParameter(58, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(59, PRD_YYYYMM[0]); //日历时间 param11.setWhereClauseParameter(60, "A"); param11.setWhereClauseParameter(61, PRD_YYYYMM[0]); param11.setWhereClauseParameter(62, "A"); param11.setWhereClauseParameter(63, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(64, PRD_YYYYMM[0]); //轧钢时间 param11.setWhereClauseParameter(65, "A"); param11.setWhereClauseParameter(66, PRD_YYYYMM[0]); param11.setWhereClauseParameter(67, "A"); param11.setWhereClauseParameter(68, PRD_YYYYMM[0].substring(0, 6)+"01"); param11.setWhereClauseParameter(69, PRD_YYYYMM[0]); PosRowSet AARstVO = this.getDao("mesdao").find("UIH090060_08.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"); 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"); EDIT_PROD[10][2] = String.valueOf(TZZ_A); EDIT_PROD[10][3] = String.valueOf(MON_TZZ_A); 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[0]); param22.setWhereClauseParameter(2, "B"); param22.setWhereClauseParameter(3, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(4, PRD_YYYYMM[0]); //电 param22.setWhereClauseParameter(5, "B"); param22.setWhereClauseParameter(6, PRD_YYYYMM[0]); param22.setWhereClauseParameter(7, "B"); param22.setWhereClauseParameter(8, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(9, PRD_YYYYMM[0]); //水 param22.setWhereClauseParameter(10, "B"); param22.setWhereClauseParameter(11, PRD_YYYYMM[0]); param22.setWhereClauseParameter(12, "B"); param22.setWhereClauseParameter(13, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(14, PRD_YYYYMM[0]); //空气 param22.setWhereClauseParameter(15, "B"); param22.setWhereClauseParameter(16, PRD_YYYYMM[0]); param22.setWhereClauseParameter(17, "B"); param22.setWhereClauseParameter(18, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(19, PRD_YYYYMM[0]); //辊耗 param22.setWhereClauseParameter(20, "B"); param22.setWhereClauseParameter(21, PRD_YYYYMM[0]); param22.setWhereClauseParameter(22, "B"); param22.setWhereClauseParameter(23, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(24, PRD_YYYYMM[0]); //停轧时间 机械 param22.setWhereClauseParameter(25, "B"); param22.setWhereClauseParameter(26, PRD_YYYYMM[0]); param22.setWhereClauseParameter(27, "B"); param22.setWhereClauseParameter(28, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(29, PRD_YYYYMM[0]); //停轧时间 电器 param22.setWhereClauseParameter(30, "B"); param22.setWhereClauseParameter(31, PRD_YYYYMM[0]); param22.setWhereClauseParameter(32, "B"); param22.setWhereClauseParameter(33, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(34, PRD_YYYYMM[0]); //停轧时间 轧钢 param22.setWhereClauseParameter(35, "B"); param22.setWhereClauseParameter(36, PRD_YYYYMM[0]); param22.setWhereClauseParameter(37, "B"); param22.setWhereClauseParameter(38, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(39, PRD_YYYYMM[0]); //停轧时间 换辊 param22.setWhereClauseParameter(40, "B"); param22.setWhereClauseParameter(41, PRD_YYYYMM[0]); param22.setWhereClauseParameter(42, "B"); param22.setWhereClauseParameter(43, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(44, PRD_YYYYMM[0]); //停轧时间 检修 param22.setWhereClauseParameter(45, "B"); param22.setWhereClauseParameter(46, PRD_YYYYMM[0]); param22.setWhereClauseParameter(47, "B"); param22.setWhereClauseParameter(48, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(49, PRD_YYYYMM[0]); //停轧时间 外部 param22.setWhereClauseParameter(50, "B"); param22.setWhereClauseParameter(51, PRD_YYYYMM[0]); param22.setWhereClauseParameter(52, "B"); param22.setWhereClauseParameter(53, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(54, PRD_YYYYMM[0]); //停轧时间 原成 param22.setWhereClauseParameter(55, "B"); param22.setWhereClauseParameter(56, PRD_YYYYMM[0]); param22.setWhereClauseParameter(57, "B"); param22.setWhereClauseParameter(58, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(59, PRD_YYYYMM[0]); //日历时间 param22.setWhereClauseParameter(60, "B"); param22.setWhereClauseParameter(61, PRD_YYYYMM[0]); param22.setWhereClauseParameter(62, "B"); param22.setWhereClauseParameter(63, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(64, PRD_YYYYMM[0]); //轧钢时间 param22.setWhereClauseParameter(65, "B"); param22.setWhereClauseParameter(66, PRD_YYYYMM[0]); param22.setWhereClauseParameter(67, "B"); param22.setWhereClauseParameter(68, PRD_YYYYMM[0].substring(0, 6)+"01"); param22.setWhereClauseParameter(69, PRD_YYYYMM[0]); PosRowSet BBRstVO = this.getDao("mesdao").find("UIH090060_08.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[0]); param33.setWhereClauseParameter(2, "C"); param33.setWhereClauseParameter(3, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(4, PRD_YYYYMM[0]); //电 param33.setWhereClauseParameter(5, "C"); param33.setWhereClauseParameter(6, PRD_YYYYMM[0]); param33.setWhereClauseParameter(7, "C"); param33.setWhereClauseParameter(8, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(9, PRD_YYYYMM[0]); //水 param33.setWhereClauseParameter(10, "C"); param33.setWhereClauseParameter(11, PRD_YYYYMM[0]); param33.setWhereClauseParameter(12, "C"); param33.setWhereClauseParameter(13, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(14, PRD_YYYYMM[0]); //空气 param33.setWhereClauseParameter(15, "C"); param33.setWhereClauseParameter(16, PRD_YYYYMM[0]); param33.setWhereClauseParameter(17, "C"); param33.setWhereClauseParameter(18, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(19, PRD_YYYYMM[0]); //辊耗 param33.setWhereClauseParameter(20, "C"); param33.setWhereClauseParameter(21, PRD_YYYYMM[0]); param33.setWhereClauseParameter(22, "C"); param33.setWhereClauseParameter(23, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(24, PRD_YYYYMM[0]); //停轧时间 机械 param33.setWhereClauseParameter(25, "C"); param33.setWhereClauseParameter(26, PRD_YYYYMM[0]); param33.setWhereClauseParameter(27, "C"); param33.setWhereClauseParameter(28, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(29, PRD_YYYYMM[0]); //停轧时间 电器 param33.setWhereClauseParameter(30, "C"); param33.setWhereClauseParameter(31, PRD_YYYYMM[0]); param33.setWhereClauseParameter(32, "C"); param33.setWhereClauseParameter(33, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(34, PRD_YYYYMM[0]); //停轧时间 轧钢 param33.setWhereClauseParameter(35, "C"); param33.setWhereClauseParameter(36, PRD_YYYYMM[0]); param33.setWhereClauseParameter(37, "C"); param33.setWhereClauseParameter(38, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(39, PRD_YYYYMM[0]); //停轧时间 换辊 param33.setWhereClauseParameter(40, "C"); param33.setWhereClauseParameter(41, PRD_YYYYMM[0]); param33.setWhereClauseParameter(42, "C"); param33.setWhereClauseParameter(43, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(44, PRD_YYYYMM[0]); //停轧时间 检修 param33.setWhereClauseParameter(45, "C"); param33.setWhereClauseParameter(46, PRD_YYYYMM[0]); param33.setWhereClauseParameter(47, "C"); param33.setWhereClauseParameter(48, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(49, PRD_YYYYMM[0]); //停轧时间 外部 param33.setWhereClauseParameter(50, "C"); param33.setWhereClauseParameter(51, PRD_YYYYMM[0]); param33.setWhereClauseParameter(52, "C"); param33.setWhereClauseParameter(53, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(54, PRD_YYYYMM[0]); //停轧时间 原成 param33.setWhereClauseParameter(55, "C"); param33.setWhereClauseParameter(56, PRD_YYYYMM[0]); param33.setWhereClauseParameter(57, "C"); param33.setWhereClauseParameter(58, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(59, PRD_YYYYMM[0]); //日历时间 param33.setWhereClauseParameter(60, "C"); param33.setWhereClauseParameter(61, PRD_YYYYMM[0]); param33.setWhereClauseParameter(62, "C"); param33.setWhereClauseParameter(63, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(64, PRD_YYYYMM[0]); //轧钢时间 param33.setWhereClauseParameter(65, "C"); param33.setWhereClauseParameter(66, PRD_YYYYMM[0]); param33.setWhereClauseParameter(67, "C"); param33.setWhereClauseParameter(68, PRD_YYYYMM[0].substring(0, 6)+"01"); param33.setWhereClauseParameter(69, PRD_YYYYMM[0]); PosRowSet CCRstVO = this.getDao("mesdao").find("UIH090060_08.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); } } //这里三班，今天的产量是昨天晚班的开始到今天早班的结束 //这里是三班的情况，中班为空,对于全天产量的统计是昨天的晚班开始时间到今天早班的结束时间 //获取全天原料、产量、合格品、次品、待判定、中板、轧回、废品 //原料 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, ZDate+SM_EFNMC+"00"); param4.setWhereClauseParameter(1, PRD_YYYYMM[0]+SM_ESNMA+"00"); param4.setWhereClauseParameter(2, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param4.setWhereClauseParameter(3, PRD_YYYYMM[0]+SM_ESNMA+"00"); //2 param4.setWhereClauseParameter(4, ZDate+SM_EFNMC+"00"); param4.setWhereClauseParameter(5, PRD_YYYYMM[0]+SM_ESNMA+"00"); param4.setWhereClauseParameter(6, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param4.setWhereClauseParameter(7, PRD_YYYYMM[0]+SM_ESNMA+"00"); //3 param4.setWhereClauseParameter(8, ZDate+SM_EFNMC+"00"); param4.setWhereClauseParameter(9, PRD_YYYYMM[0]+SM_ESNMA+"00"); param4.setWhereClauseParameter(10, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param4.setWhereClauseParameter(11, PRD_YYYYMM[0]+SM_ESNMA+"00"); //4 param4.setWhereClauseParameter(12, ZDate+SM_EFNMC+"00"); param4.setWhereClauseParameter(13, PRD_YYYYMM[0]+SM_ESNMA+"00"); param4.setWhereClauseParameter(14, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param4.setWhereClauseParameter(15, PRD_YYYYMM[0]+SM_ESNMA+"00"); //5 param4.setWhereClauseParameter(16, ZDate+SM_EFNMC+"00"); param4.setWhereClauseParameter(17, PRD_YYYYMM[0]+SM_ESNMA+"00"); param4.setWhereClauseParameter(18, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param4.setWhereClauseParameter(19, PRD_YYYYMM[0]+SM_ESNMA+"00"); //6 param4.setWhereClauseParameter(20, ZDate+SM_EFNMC+"00"); param4.setWhereClauseParameter(21, PRD_YYYYMM[0]+SM_ESNMA+"00"); param4.setWhereClauseParameter(22, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param4.setWhereClauseParameter(23, PRD_YYYYMM[0]+SM_ESNMA+"00"); //7 param4.setWhereClauseParameter(24, ZDate+SM_EFNMC+"00"); param4.setWhereClauseParameter(25, PRD_YYYYMM[0]+SM_ESNMA+"00"); param4.setWhereClauseParameter(26, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param4.setWhereClauseParameter(27, PRD_YYYYMM[0]+SM_ESNMA+"00"); //8 param4.setWhereClauseParameter(28, ZDate+SM_EFNMC+"00"); param4.setWhereClauseParameter(29, PRD_YYYYMM[0]+SM_ESNMA+"00"); param4.setWhereClauseParameter(30, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param4.setWhereClauseParameter(31, PRD_YYYYMM[0]+SM_ESNMA+"00"); //9 param4.setWhereClauseParameter(32, ZDate+SM_EFNMC+"00"); param4.setWhereClauseParameter(33, PRD_YYYYMM[0]+SM_ESNMA+"00"); param4.setWhereClauseParameter(34, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param4.setWhereClauseParameter(35, PRD_YYYYMM[0]+SM_ESNMA+"00"); //10 param4.setWhereClauseParameter(36, ZDate+SM_EFNMC+"00"); param4.setWhereClauseParameter(37, PRD_YYYYMM[0]+SM_ESNMA+"00"); param4.setWhereClauseParameter(38, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param4.setWhereClauseParameter(39, PRD_YYYYMM[0]+SM_ESNMA+"00"); //11 param4.setWhereClauseParameter(40, ZDate+SM_EFNMC+"00"); param4.setWhereClauseParameter(41, PRD_YYYYMM[0]+SM_ESNMA+"00"); param4.setWhereClauseParameter(42, PRD_YYYYMM[0].substring(0, 6)+"01000000"); param4.setWhereClauseParameter(43, PRD_YYYYMM[0]+SM_ESNMA+"00"); 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); } //把指定的值返回的前台页面 for(int m=0;m < 35;m++) { LinkedHashMap map1 = new LinkedHashMap() ; 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; } }