package xin.glue.ui.H.H02; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import com.posdata.glue.biz.activity.PosActivity; import com.posdata.glue.biz.constants.PosBizControlConstants; import com.posdata.glue.component.layout.PosMessageLayoutIF; import com.posdata.glue.context.PosContext; import com.posdata.glue.dao.vo.PosParameter; import com.posdata.glue.dao.vo.PosRow; import com.posdata.glue.dao.vo.PosRowSet; import com.posdata.glue.msg.PosMESMessageImpl; import com.posdata.glue.msg.PosMessageAttributeDefinition; import com.posdata.glue.msg.PosMessageDefinition; import com.posdata.glue.util.log.PosLog; import com.posdata.glue.util.log.PosLogFactory; public class PosMillReportEdit extends PosActivity { private final PosLog log = PosLogFactory.getLogger(getClass()); public String runActivity(PosContext context) { log.logInfo("======== PosMillReportEdit start " ); String[] PRD_YYYYMM = (String[])context.get("PRD_YYYYMM"); String[][] EDIT_PROD = new String[2][21]; String[] EDIT_SHIP = new String[10] ; String[][] EDIT_YARD = new String[2][10] ; String[] EDIT_YC = new String[8] ; int i = 0;int j = 0; for ( i = 0 ; i < 2;i++) { for ( j = 0 ; j < 21;j++) { EDIT_PROD[i][j]= null; } } for ( i = 0 ; i < 9;i++) { EDIT_SHIP[i] = null; } for ( i = 0 ; i < 2;i++) { for ( j = 0 ; j < 9;j++) { EDIT_YARD[i][j] = null; } } for(i=0;i<7;i++){ EDIT_YC[i] = null; } List list1 = new ArrayList(); List list2 = new ArrayList(); List list3 = new ArrayList(); List list4 = new ArrayList(); String SLAB_RT = null; String RHF_DAY_CNT = null; String RHF_DAY_WGT = null; String RHF_MON_CNT = null; String RHF_MON_WGT = null; String MILL_DAY_CNT = null; String MILL_DAY_WGT = null; String MILL_MON_CNT = null; String MILL_MON_WGT = null; log.logInfo("======== PosMillReportEdit PRD_YYYYMM:"+PRD_YYYYMM[0] ); PosParameter param1 = new PosParameter(); param1.setWhereClauseParameter(0, PRD_YYYYMM[0]); param1.setWhereClauseParameter(1, PRD_YYYYMM[0]); param1.setWhereClauseParameter(2, PRD_YYYYMM[0]); PosRowSet rhfRstVO = this.getDao("mesdao").find("UIH020210_RHF_EXT.select", param1); while(rhfRstVO.hasNext()) { PosRow rhfRstROW = rhfRstVO.next(); SLAB_RT = (String)rhfRstROW.getAttribute("SLAB_RT"); RHF_DAY_CNT = (String)rhfRstROW.getAttribute("RHF_DAY_CNT"); RHF_DAY_WGT = (String)rhfRstROW.getAttribute("RHF_DAY_WGT"); RHF_MON_CNT = (String)rhfRstROW.getAttribute("RHF_MON_CNT"); RHF_MON_WGT = (String)rhfRstROW.getAttribute("RHF_MON_WGT"); EDIT_PROD[0][0] = "ÈÈÔþ²Ä"; EDIT_PROD[1][0] = "ÀäÔþ²Ä"; if (SLAB_RT != null && SLAB_RT.equals("H")) { EDIT_PROD[0][1] = RHF_DAY_CNT; EDIT_PROD[0][2] = RHF_MON_CNT; EDIT_PROD[0][3] = RHF_DAY_WGT; EDIT_PROD[0][4] = RHF_MON_WGT; } else if (SLAB_RT != null && SLAB_RT.equals("C")) { EDIT_PROD[1][1] = RHF_DAY_CNT; EDIT_PROD[1][2] = RHF_MON_CNT; EDIT_PROD[1][3] = RHF_DAY_WGT; EDIT_PROD[1][4] = RHF_MON_WGT; } } PosParameter param2 = new PosParameter(); param2.setWhereClauseParameter(0, PRD_YYYYMM[0]); param2.setWhereClauseParameter(1, PRD_YYYYMM[0]); param2.setWhereClauseParameter(2, PRD_YYYYMM[0]); PosRowSet MillRstVO = this.getDao("mesdao").find("UIH020210_COIL_RST.select", param2); while(MillRstVO.hasNext()) { PosRow MillRstROW = MillRstVO.next(); SLAB_RT = (String)MillRstROW.getAttribute("COIL_RT"); MILL_DAY_CNT = (String)MillRstROW.getAttribute("MILL_DAY_CNT"); MILL_DAY_WGT = (String)MillRstROW.getAttribute("MILL_DAY_WGT"); MILL_MON_CNT = (String)MillRstROW.getAttribute("MILL_MON_CNT"); MILL_MON_WGT = (String)MillRstROW.getAttribute("MILL_MON_WGT"); EDIT_PROD[0][0] = "ÈÈÔþ²Ä"; EDIT_PROD[1][0] = "ÀäÔþ²Ä"; if (SLAB_RT != null && SLAB_RT.equals("H")) { EDIT_PROD[0][5] = MILL_DAY_CNT; EDIT_PROD[0][6] = MILL_MON_CNT; EDIT_PROD[0][7] = MILL_DAY_WGT; EDIT_PROD[0][8] = MILL_MON_WGT; } else if (SLAB_RT != null && SLAB_RT.equals("C")) { EDIT_PROD[1][5] = MILL_DAY_CNT; EDIT_PROD[1][6] = MILL_MON_CNT; EDIT_PROD[1][7] = MILL_DAY_WGT; EDIT_PROD[1][8] = MILL_MON_WGT; } } String ENT_DAY_CNT = null; String ENT_MON_CNT = null; String ENT_DAY_WGT = null; String ENT_MON_WGT = null; String EXT_DAY_CNT = null; String EXT_MON_CNT = null; String EXT_DAY_WGT = null; String EXT_MON_WGT = null; PosParameter param3 = new PosParameter(); param3.setWhereClauseParameter(0, PRD_YYYYMM[0]); param3.setWhereClauseParameter(1, PRD_YYYYMM[0]); param3.setWhereClauseParameter(2, PRD_YYYYMM[0]); PosRowSet SlabRejVO = this.getDao("mesdao").find("UIH020210_SLAB_REJ.select", param3); while(SlabRejVO.hasNext()) { PosRow SlabRejROW = SlabRejVO.next(); SLAB_RT = (String)SlabRejROW.getAttribute("SLAB_RT"); ENT_DAY_CNT = (String)SlabRejROW.getAttribute("ENT_DAY_CNT"); ENT_MON_CNT = (String)SlabRejROW.getAttribute("ENT_MON_CNT"); ENT_DAY_WGT = (String)SlabRejROW.getAttribute("ENT_DAY_WGT"); ENT_MON_WGT = (String)SlabRejROW.getAttribute("ENT_MON_WGT"); EXT_DAY_CNT = (String)SlabRejROW.getAttribute("EXT_DAY_CNT"); EXT_MON_CNT = (String)SlabRejROW.getAttribute("EXT_MON_CNT"); EXT_DAY_WGT = (String)SlabRejROW.getAttribute("EXT_DAY_WGT"); EXT_MON_WGT = (String)SlabRejROW.getAttribute("EXT_MON_WGT"); EDIT_PROD[0][0] = "ÈÈÔþ²Ä"; EDIT_PROD[1][0] = "ÀäÔþ²Ä"; if (SLAB_RT != null && SLAB_RT.equals("H")) { EDIT_PROD[0][9] = ENT_DAY_CNT; EDIT_PROD[0][10] = ENT_MON_CNT; EDIT_PROD[0][11] = ENT_DAY_WGT; EDIT_PROD[0][12] = ENT_MON_WGT; EDIT_PROD[0][13] = EXT_DAY_CNT; EDIT_PROD[0][14] = EXT_MON_CNT; EDIT_PROD[0][15] = EXT_DAY_WGT; EDIT_PROD[0][16] = EXT_MON_WGT; } else if (SLAB_RT != null && SLAB_RT.equals("C")) { EDIT_PROD[1][9] = ENT_DAY_CNT; EDIT_PROD[1][10] = ENT_MON_CNT; EDIT_PROD[1][11] = ENT_DAY_WGT; EDIT_PROD[1][12] = ENT_MON_WGT; EDIT_PROD[1][13] = EXT_DAY_CNT; EDIT_PROD[1][14] = EXT_MON_CNT; EDIT_PROD[1][15] = EXT_DAY_WGT; EDIT_PROD[1][16] = EXT_MON_WGT; } } String DAY_CNT = null; String DAY_WGT = null; String MON_CNT = null; String MON_WGT = null; PosParameter param4 = new PosParameter(); param4.setWhereClauseParameter(0, PRD_YYYYMM[0]); param4.setWhereClauseParameter(1, PRD_YYYYMM[0]); param4.setWhereClauseParameter(2, PRD_YYYYMM[0]); PosRowSet CoilRejVO = this.getDao("mesdao").find("UIH020210_COIL_REJ.select", param4); while(CoilRejVO.hasNext()) { PosRow CoilRejROW = CoilRejVO.next(); SLAB_RT = (String)CoilRejROW.getAttribute("SLAB_RT"); DAY_CNT = (String)CoilRejROW.getAttribute("DAY_CNT"); DAY_WGT = (String)CoilRejROW.getAttribute("DAY_WGT"); MON_CNT = (String)CoilRejROW.getAttribute("MON_CNT"); MON_WGT = (String)CoilRejROW.getAttribute("MON_WGT"); EDIT_PROD[0][0] = "ÈÈÔþ²Ä"; EDIT_PROD[1][0] = "ÀäÔþ²Ä"; if (SLAB_RT != null && SLAB_RT.equals("H")) { EDIT_PROD[0][17] = DAY_CNT; EDIT_PROD[0][18] = MON_CNT; EDIT_PROD[0][19] = DAY_WGT; EDIT_PROD[0][20] = MON_WGT; } else if (SLAB_RT != null && SLAB_RT.equals("C")) { EDIT_PROD[1][17] = DAY_CNT; EDIT_PROD[1][18] = MON_CNT; EDIT_PROD[1][19] = DAY_WGT; EDIT_PROD[1][20] = MON_WGT; } } for(int m=0;m < 2;m++) { HashMap map1 = new HashMap(30,6) ; list1.add(map1); map1.put("REP_MTL_CLF" , EDIT_PROD[m][0] ); map1.put("RST_RHF_CNT" , EDIT_PROD[m][1] ); map1.put("RST_RHF_T_CNT" , EDIT_PROD[m][2] ); map1.put("RST_RHF_WGT" , EDIT_PROD[m][3] ); map1.put("RST_RHF_T_WGT" , EDIT_PROD[m][4] ); map1.put("RST_COIL_CNT" , EDIT_PROD[m][5] ); map1.put("RST_COIL_T_CNT" , EDIT_PROD[m][6] ); map1.put("RST_COIL_WGT" , EDIT_PROD[m][7] ); map1.put("RST_COIL_T_WGT" , EDIT_PROD[m][8] ); map1.put("RHF_B_REJ_CNT" , EDIT_PROD[m][9] ); map1.put("RHF_B_REJ_T_CNT" , EDIT_PROD[m][10] ); map1.put("RHF_B_REJ_WGT" , EDIT_PROD[m][11] ); map1.put("RHF_B_REJ_T_WGT" , EDIT_PROD[m][12] ); map1.put("RHF_A_REJ_CNT" , EDIT_PROD[m][13] ); map1.put("RHF_A_REJ_T_CNT" , EDIT_PROD[m][14] ); map1.put("RHF_A_REJ_WGT" , EDIT_PROD[m][15] ); map1.put("RHF_A_REJ_T_WGT" , EDIT_PROD[m][16] ); map1.put("MILL_REJ_CNT" , EDIT_PROD[m][17] ); map1.put("MILL_REJ_T_CNT" , EDIT_PROD[m][18] ); map1.put("MILL_REJ_WGT" , EDIT_PROD[m][19] ); map1.put("MILL_REJ_T_WGT" , EDIT_PROD[m][20] ); } context.put("ProdEdit",list1); String SHIP_DAY_CNT = null; String SHIP_DAY_WGT = null; String SHIP_MON_CNT = null; String SHIP_MON_WGT = null; String COLD_DAY_CNT = null; String COLD_DAY_WGT = null; String COLD_MON_CNT = null; String COLD_MON_WGT = null; PosParameter param5 = new PosParameter(); param5.setWhereClauseParameter(0, PRD_YYYYMM[0]); param5.setWhereClauseParameter(1, PRD_YYYYMM[0]); param5.setWhereClauseParameter(2, PRD_YYYYMM[0]); param5.setWhereClauseParameter(3, PRD_YYYYMM[0]); param5.setWhereClauseParameter(4, PRD_YYYYMM[0]); param5.setWhereClauseParameter(5, PRD_YYYYMM[0]); PosRowSet ShipColdVO = this.getDao("mesdao").find("UIH020210_SHIP.select", param5); while(ShipColdVO.hasNext()) { PosRow ShipColdROW = ShipColdVO.next(); SHIP_DAY_CNT = (String)ShipColdROW.getAttribute("SHIP_DAY_CNT"); SHIP_DAY_WGT = (String)ShipColdROW.getAttribute("SHIP_DAY_WGT"); SHIP_MON_CNT = (String)ShipColdROW.getAttribute("SHIP_MON_CNT"); SHIP_MON_WGT = (String)ShipColdROW.getAttribute("SHIP_MON_WGT"); COLD_DAY_CNT = (String)ShipColdROW.getAttribute("COLD_DAY_CNT"); COLD_DAY_WGT = (String)ShipColdROW.getAttribute("COLD_DAY_WGT"); COLD_MON_CNT = (String)ShipColdROW.getAttribute("COLD_MON_CNT"); COLD_MON_WGT = (String)ShipColdROW.getAttribute("COLD_MON_WGT"); EDIT_SHIP[0] = " "; EDIT_SHIP[1] = SHIP_DAY_CNT; EDIT_SHIP[2] = SHIP_MON_CNT; EDIT_SHIP[3] = SHIP_DAY_WGT; EDIT_SHIP[4] = SHIP_MON_WGT; EDIT_SHIP[5] = COLD_DAY_CNT; EDIT_SHIP[6] = COLD_MON_CNT; EDIT_SHIP[7] = COLD_DAY_WGT; EDIT_SHIP[8] = COLD_MON_WGT; } HashMap map2 = new HashMap(10,1) ; list2.add(map2); map2.put("REP_MTL_CLF" , EDIT_SHIP[0] ); map2.put("SHIP_CNT" , EDIT_SHIP[1] ); map2.put("SHIP_T_CNT" , EDIT_SHIP[2] ); map2.put("SHIP_WGT" , EDIT_SHIP[3] ); map2.put("SHIP_T_WGT" , EDIT_SHIP[4] ); map2.put("COLD_CNT" , EDIT_SHIP[5] ); map2.put("COLD_T_CNT" , EDIT_SHIP[6] ); map2.put("COLD_WGT" , EDIT_SHIP[7] ); map2.put("COLD_T_WGT" , EDIT_SHIP[8] ); context.put("ShipEdit",list2); //ÕâÀïͳ¼ÆÓà²ÄÁ¿ String YC_DAY_CNT = null; String YC_DAY_WGT = null; String YC_MON_CNT = null; String YC_MON_WGT = null; String YC_DAY_WGT_T = null; String YC_MON_WGT_T = null; PosParameter param55 = new PosParameter(); param55.setWhereClauseParameter(0, PRD_YYYYMM[0]); param55.setWhereClauseParameter(1, PRD_YYYYMM[0]); param55.setWhereClauseParameter(2, PRD_YYYYMM[0]); param55.setWhereClauseParameter(3, PRD_YYYYMM[0]); param55.setWhereClauseParameter(4, PRD_YYYYMM[0]); param55.setWhereClauseParameter(5, PRD_YYYYMM[0]); PosRowSet YCColdVO = this.getDao("mesdao").find("UIH020210_YC.select", param55); while(YCColdVO.hasNext()) { PosRow YCColdROW = YCColdVO.next(); YC_DAY_CNT = (String)YCColdROW.getAttribute("YC_DAY_CNT"); YC_DAY_WGT = (String)YCColdROW.getAttribute("YC_DAY_WGT"); YC_MON_CNT = (String)YCColdROW.getAttribute("YC_MON_CNT"); YC_MON_WGT = (String)YCColdROW.getAttribute("YC_MON_WGT"); YC_DAY_WGT_T = (String)YCColdROW.getAttribute("YC_DAY_WGT_T"); YC_MON_WGT_T = (String)YCColdROW.getAttribute("YC_MON_WGT_T"); EDIT_YC[0] = " "; EDIT_YC[1] = YC_DAY_CNT; EDIT_YC[2] = YC_DAY_WGT; EDIT_YC[3] = YC_MON_CNT; EDIT_YC[4] = YC_MON_WGT; EDIT_YC[5] = YC_DAY_WGT_T; EDIT_YC[6] = YC_MON_WGT_T; } HashMap map4 = new HashMap(10,1) ; list4.add(map4); map4.put("MTL_CLF" , EDIT_YC[0] ); map4.put("CNT" , EDIT_YC[1] ); map4.put("T_CNT" , EDIT_YC[3] ); map4.put("WGT" , EDIT_YC[2] ); map4.put("T_WGT" , EDIT_YC[4] ); map4.put("LIB" , EDIT_YC[5] ); map4.put("T_LIB" , EDIT_YC[6] ); context.put("YCEdit",list4); String COIL_RT = null; String YARD1_COIL_CNT = null; String YARD1_COIL_WGT = null; String YARD2_COIL_CNT = null; String YARD2_COIL_WGT = null; String YARD3_COIL_CNT = null; String YARD3_COIL_WGT = null; String TOT_COIL_CNT = null; String TOT_COIL_WGT = null; PosRowSet YardCoilVO = this.getDao("mesdao").find("UIH020210_YARD.select" ); while(YardCoilVO.hasNext()) { PosRow YardCoilROW = YardCoilVO.next(); COIL_RT = (String)YardCoilROW.getAttribute("COIL_RT"); YARD1_COIL_CNT = (String)YardCoilROW.getAttribute("YARD1_COIL_CNT"); YARD1_COIL_WGT = (String)YardCoilROW.getAttribute("YARD1_COIL_WGT"); YARD2_COIL_CNT = (String)YardCoilROW.getAttribute("YARD2_COIL_CNT"); YARD2_COIL_WGT = (String)YardCoilROW.getAttribute("YARD2_COIL_WGT"); YARD3_COIL_CNT = (String)YardCoilROW.getAttribute("YARD3_COIL_CNT"); YARD3_COIL_WGT = (String)YardCoilROW.getAttribute("YARD3_COIL_WGT"); TOT_COIL_CNT = (String)YardCoilROW.getAttribute("TOT_COIL_CNT"); TOT_COIL_WGT = (String)YardCoilROW.getAttribute("TOT_COIL_WGT"); if (COIL_RT != null && COIL_RT.equals("H") ) { EDIT_YARD[0][0] = "ÈÈÔþ²Ä"; EDIT_YARD[0][1] = YARD1_COIL_CNT; EDIT_YARD[0][2] = YARD2_COIL_CNT; EDIT_YARD[0][3] = YARD3_COIL_CNT; EDIT_YARD[0][4] = TOT_COIL_CNT; EDIT_YARD[0][5] = YARD1_COIL_WGT; EDIT_YARD[0][6] = YARD2_COIL_WGT; EDIT_YARD[0][7] = YARD3_COIL_WGT; EDIT_YARD[0][8] = TOT_COIL_WGT; } else { EDIT_YARD[1][0] = "ÀäÔþ²Ä"; EDIT_YARD[1][1] = YARD1_COIL_CNT; EDIT_YARD[1][2] = YARD2_COIL_CNT; EDIT_YARD[1][3] = YARD3_COIL_CNT; EDIT_YARD[1][4] = TOT_COIL_CNT; EDIT_YARD[1][5] = YARD1_COIL_WGT; EDIT_YARD[1][6] = YARD2_COIL_WGT; EDIT_YARD[1][7] = YARD3_COIL_WGT; EDIT_YARD[1][8] = TOT_COIL_WGT; } } for (i = 0; i < 2; i++) { HashMap map3 = new HashMap(10,1) ; list3.add(map3); map3.put("REP_MTL_CLF" , EDIT_YARD[i][0] ); map3.put("STOCK_1_CNT" , EDIT_YARD[i][1] ); map3.put("STOCK_2_CNT" , EDIT_YARD[i][2] ); map3.put("STOCK_3_CNT" , EDIT_YARD[i][3] ); map3.put("STOCK_T_CNT" , EDIT_YARD[i][4] ); map3.put("STOCK_1_WGT" , EDIT_YARD[i][5] ); map3.put("STOCK_2_WGT" , EDIT_YARD[i][6] ); map3.put("STOCK_3_WGT" , EDIT_YARD[i][7] ); map3.put("STOCK_T_WGT" , EDIT_YARD[i][8] ); } context.put("YardEdit",list3); return PosBizControlConstants.SUCCESS; } }