package xin.glue.ui.G.G02; import java.util.ArrayList; import java.util.HashMap; import java.util.Map; import java.lang.Number; import com.posdata.glue.biz.activity.PosActivity; import com.posdata.glue.biz.constants.PosBizControlConstants; 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; /* * 工序管理修改工序 * @author 王小炎 * @date 2008.08.11 */ public class PosMatChargeNoEdit extends PosActivity { public String runActivity(PosContext context) { String[] PROC_CD = (String[])context.get("PROC_CD"); String[] FROM_DATE = (String[])context.get("FROM_DATE"); String[] TO_DATE = (String[])context.get("TO_DATE"); PosParameter param1 = new PosParameter(); param1.setWhereClauseParameter(0, FROM_DATE[0]); param1.setWhereClauseParameter(1, TO_DATE[0] ); PosRowSet matVO = null; if (PROC_CD[0].equals("JB")) { matVO = getDao("mesdao").find("UIG020220_BOF_CH.select", param1); } else if(PROC_CD[0].equals("JC")) { matVO = getDao("mesdao").find("UIG020220_CAS_CH.select", param1); } else if(PROC_CD[0].equals("JH")) { matVO = getDao("mesdao").find("UIG020220_RH_CH.select", param1); } else if(PROC_CD[0].equals("JL")) { matVO = getDao("mesdao").find("UIG020220_LF_CH.select", param1); } String CHARGE_NO = null; String STL_GRD = null; ArrayList list1 = new ArrayList(); ArrayList list2 = new ArrayList(); ArrayList list3 = new ArrayList(); ArrayList list4 = new ArrayList(); context.put("EditCharge" , list1); context.put("MainRawResult", list2); context.put("RawMatResult" , list3); context.put("SubRawResult" , list4); while(matVO.hasNext()) { PosRow matROW = matVO.next(); CHARGE_NO = (String)matROW.getAttribute("CHARGE_NO"); STL_GRD = (String)matROW.getAttribute("STL_GRD"); Map map1 = new HashMap(1000); map1.put("CHARGE_NO" , CHARGE_NO ); map1.put("STL_GRD" , STL_GRD ); list1.add(map1); Map map2 = new HashMap(1000 ); PosParameter param2 = new PosParameter(); param2.setWhereClauseParameter(0, PROC_CD[0]); param2.setWhereClauseParameter(1, CHARGE_NO ); PosRowSet MainRawVO = getDao("mesdao").find("UIG020220.select", param2); Number S01 = null; Number S02 = null; Number S03 = null; Number S04 = null; Number S05 = null; Number S06 = null; Number S07 = null; Number S08 = null; Number S09 = null; Number S10 = null; Number S11 = null; Number S12 = null; Number S13 = null; Number S14 = null; Number S15 = null; Number S16 = null; Number S17 = null; Number S18 = null; Number S19 = null; Number S20 = null; Number S21 = null; Number S22 = null; Number S23 = null; Number S24 = null; Number S25 = null; Number S26 = null; Number S27 = null; Number S28 = null; Number S29 = null; Number S30 = null; Number S31 = null; Number S32 = null; Number S33 = null; Number S34 = null; Number S35 = null; Number S36 = null; Number S37 = null; Number S38 = null; Number S39 = null; Number S40 = null; Number S41 = null; Number S42 = null; Number S43 = null; Number S44 = null; Number S45 = null; Number S46 = null; Number S47 = null; Number S48 = null; Number S49 = null; Number S50 = null; Number S51 = null; Number S52 = null; Number S53 = null; Number S54 = null; Number S55 = null; Number S56 = null; Number S57 = null; Number S58 = null; Number S59 = null; Number S60 = null; Number S61 = null; Number S62 = null; Number S63 = null; Number S64 = null; Number S65 = null; Number S66 = null; Number S67 = null; Number S68 = null; Number S69 = null; Number S70 = null; Number S71 = null; Number S72 = null; Number TOT_S = null; if(MainRawVO.hasNext()) { PosRow MainRawROW = MainRawVO.next(); S01 = (Number)MainRawROW.getAttribute("S01"); S02 = (Number)MainRawROW.getAttribute("S02"); S03 = (Number)MainRawROW.getAttribute("S03"); S04 = (Number)MainRawROW.getAttribute("S04"); S05 = (Number)MainRawROW.getAttribute("S05"); S06 = (Number)MainRawROW.getAttribute("S06"); S07 = (Number)MainRawROW.getAttribute("S07"); S08 = (Number)MainRawROW.getAttribute("S08"); S09 = (Number)MainRawROW.getAttribute("S09"); S10 = (Number)MainRawROW.getAttribute("S10"); S11 = (Number)MainRawROW.getAttribute("S11"); S12 = (Number)MainRawROW.getAttribute("S12"); S13 = (Number)MainRawROW.getAttribute("S13"); S14 = (Number)MainRawROW.getAttribute("S14"); S15 = (Number)MainRawROW.getAttribute("S15"); S16 = (Number)MainRawROW.getAttribute("S16"); S17 = (Number)MainRawROW.getAttribute("S17"); S18 = (Number)MainRawROW.getAttribute("S18"); S19 = (Number)MainRawROW.getAttribute("S19"); S20 = (Number)MainRawROW.getAttribute("S20"); S21 = (Number)MainRawROW.getAttribute("S21"); S22 = (Number)MainRawROW.getAttribute("S22"); S23 = (Number)MainRawROW.getAttribute("S23"); S24 = (Number)MainRawROW.getAttribute("S24"); S25 = (Number)MainRawROW.getAttribute("S25"); S26 = (Number)MainRawROW.getAttribute("S26"); S27 = (Number)MainRawROW.getAttribute("S27"); S28 = (Number)MainRawROW.getAttribute("S28"); S29 = (Number)MainRawROW.getAttribute("S29"); S30 = (Number)MainRawROW.getAttribute("S30"); S31 = (Number)MainRawROW.getAttribute("S31"); S32 = (Number)MainRawROW.getAttribute("S32"); S33 = (Number)MainRawROW.getAttribute("S33"); S34 = (Number)MainRawROW.getAttribute("S34"); S35 = (Number)MainRawROW.getAttribute("S35"); S36 = (Number)MainRawROW.getAttribute("S36"); S37 = (Number)MainRawROW.getAttribute("S37"); S38 = (Number)MainRawROW.getAttribute("S38"); S39 = (Number)MainRawROW.getAttribute("S39"); S40 = (Number)MainRawROW.getAttribute("S40"); S41 = (Number)MainRawROW.getAttribute("S41"); S42 = (Number)MainRawROW.getAttribute("S42"); S43 = (Number)MainRawROW.getAttribute("S43"); S44 = (Number)MainRawROW.getAttribute("S44"); S45 = (Number)MainRawROW.getAttribute("S45"); S46 = (Number)MainRawROW.getAttribute("S46"); S47 = (Number)MainRawROW.getAttribute("S47"); S48 = (Number)MainRawROW.getAttribute("S48"); S49 = (Number)MainRawROW.getAttribute("S49"); S50 = (Number)MainRawROW.getAttribute("S50"); S51 = (Number)MainRawROW.getAttribute("S51"); S52 = (Number)MainRawROW.getAttribute("S52"); S53 = (Number)MainRawROW.getAttribute("S53"); S54 = (Number)MainRawROW.getAttribute("S54"); S55 = (Number)MainRawROW.getAttribute("S55"); S56 = (Number)MainRawROW.getAttribute("S56"); S57 = (Number)MainRawROW.getAttribute("S57"); S58 = (Number)MainRawROW.getAttribute("S58"); S59 = (Number)MainRawROW.getAttribute("S59"); S60 = (Number)MainRawROW.getAttribute("S60"); S61 = (Number)MainRawROW.getAttribute("S61"); S62 = (Number)MainRawROW.getAttribute("S62"); S63 = (Number)MainRawROW.getAttribute("S63"); S64 = (Number)MainRawROW.getAttribute("S64"); S65 = (Number)MainRawROW.getAttribute("S65"); S66 = (Number)MainRawROW.getAttribute("S66"); S67 = (Number)MainRawROW.getAttribute("S67"); S68 = (Number)MainRawROW.getAttribute("S68"); S69 = (Number)MainRawROW.getAttribute("S69"); S70 = (Number)MainRawROW.getAttribute("S70"); S71 = (Number)MainRawROW.getAttribute("S71"); S72 = (Number)MainRawROW.getAttribute("S72"); TOT_S = (Number)MainRawROW.getAttribute("TOT_S"); map2.put("CHARGE_NO" , CHARGE_NO ); map2.put("STL_GRD" , STL_GRD ); map2.put("S01" , S01 ); map2.put("S02" , S02 ); map2.put("S03" , S03 ); map2.put("S04" , S04 ); map2.put("S05" , S05 ); map2.put("S06" , S06 ); map2.put("S07" , S07 ); map2.put("S08" , S08 ); map2.put("S09" , S09 ); map2.put("S10" , S10 ); map2.put("S11" , S11 ); map2.put("S12" , S12 ); map2.put("S13" , S13 ); map2.put("S14" , S14 ); map2.put("S15" , S15 ); map2.put("S16" , S16 ); map2.put("S17" , S17 ); map2.put("S18" , S18 ); map2.put("S19" , S19 ); map2.put("S20" , S20 ); map2.put("S21" , S21 ); map2.put("S22" , S22 ); map2.put("S23" , S23 ); map2.put("S24" , S24 ); map2.put("S25" , S25 ); map2.put("S26" , S26 ); map2.put("S27" , S27 ); map2.put("S28" , S28 ); map2.put("S29" , S29 ); map2.put("S30" , S30 ); map2.put("S31" , S31 ); map2.put("S32" , S32 ); map2.put("S33" , S33 ); map2.put("S34" , S34 ); map2.put("S35" , S35 ); map2.put("S36" , S36 ); map2.put("S37" , S37 ); map2.put("S38" , S38 ); map2.put("S39" , S39 ); map2.put("S40" , S40 ); map2.put("S41" , S41 ); map2.put("S42" , S42 ); map2.put("S43" , S43 ); map2.put("S44" , S44 ); map2.put("S45" , S45 ); map2.put("S46" , S46 ); map2.put("S47" , S47 ); map2.put("S48" , S48 ); map2.put("S49" , S49 ); map2.put("S50" , S50 ); map2.put("S51" , S51 ); map2.put("S52" , S52 ); map2.put("S53" , S53 ); map2.put("S54" , S54 ); map2.put("S55" , S55 ); map2.put("S56" , S56 ); map2.put("S57" , S57 ); map2.put("S58" , S58 ); map2.put("S59" , S59 ); map2.put("S60" , S60 ); map2.put("S61" , S61 ); map2.put("S62" , S62 ); map2.put("S63" , S63 ); map2.put("S64" , S64 ); map2.put("S65" , S65 ); map2.put("S66" , S66 ); map2.put("S67" , S67 ); map2.put("S68" , S68 ); map2.put("S69" , S69 ); map2.put("S70" , S70 ); map2.put("S71" , S71 ); map2.put("S72" , S72 ); map2.put("TOT_S" , TOT_S ); list2.add(map2); } /* else { map2.put("CHARGE_NO" , CHARGE_NO ); map2.put("STL_GRD" , STL_GRD ); map2.put("S01" , "0" ); map2.put("S02" , "0" ); map2.put("S03" , "0" ); map2.put("S04" , "0" ); map2.put("S05" , "0" ); map2.put("TOT_S" , "0" ); list2.add(map2); } Map map3 = new HashMap(1000 ); PosRowSet RawMatVO = getDao("mesdao").find("UIG020220_RAWMAT.select", param2); Number H01 = null; Number H02 = null; Number H03 = null; Number H04 = null; Number H05 = null; Number H06 = null; Number H07 = null; Number H08 = null; Number H09 = null; Number H10 = null; Number H11 = null; Number TOT_H = null; if(RawMatVO.hasNext()) { PosRow RawMatROW = RawMatVO.next(); H01 = (Number)RawMatROW.getAttribute("H01"); H02 = (Number)RawMatROW.getAttribute("H02"); H03 = (Number)RawMatROW.getAttribute("H03"); H04 = (Number)RawMatROW.getAttribute("H04"); H05 = (Number)RawMatROW.getAttribute("H05"); H06 = (Number)RawMatROW.getAttribute("H06"); H07 = (Number)RawMatROW.getAttribute("H07"); H08 = (Number)RawMatROW.getAttribute("H08"); H09 = (Number)RawMatROW.getAttribute("H09"); H10 = (Number)RawMatROW.getAttribute("H10"); H11 = (Number)RawMatROW.getAttribute("H11"); TOT_H = (Number)RawMatROW.getAttribute("TOT_H"); map3.put("CHARGE_NO" , CHARGE_NO ); map3.put("H01" , H01 ); map3.put("H02" , H02 ); map3.put("H03" , H03 ); map3.put("H04" , H04 ); map3.put("H05" , H05 ); map3.put("H06" , H06 ); map3.put("H07" , H07 ); map3.put("H08" , H08 ); map3.put("H09" , H09 ); map3.put("H10" , H10 ); map3.put("H11" , H11 ); map3.put("TOT_H" , TOT_H ); list3.add(map3); } else { map3.put("CHARGE_NO" , CHARGE_NO ); map3.put("H01" , "" ); map3.put("H02" , "" ); map3.put("H03" , "" ); map3.put("H04" , "" ); map3.put("H05" , "" ); map3.put("H06" , "" ); map3.put("H07" , "" ); map3.put("H08" , "" ); map3.put("H09" , "" ); map3.put("H10" , "" ); map3.put("H11" , "" ); map3.put("TOT_H" , "" ); list3.add(map3); } Map map4 = new HashMap(1000 ); PosRowSet SubMatVO = getDao("mesdao").find("UIG020220_SUBRAW.select", param2); Number B01 = null; Number B02 = null; Number B03 = null; Number B04 = null; Number B05 = null; Number B06 = null; Number B07 = null; Number B08 = null; Number B09 = null; Number B10 = null; Number B11 = null; Number B12 = null; Number B13 = null; Number B14 = null; Number TOT_B = null; if(SubMatVO.hasNext()) { PosRow SubMatROW = SubMatVO.next(); B01 = (Number)SubMatROW.getAttribute("B01"); B02 = (Number)SubMatROW.getAttribute("B02"); B03 = (Number)SubMatROW.getAttribute("B03"); B04 = (Number)SubMatROW.getAttribute("B04"); B05 = (Number)SubMatROW.getAttribute("B05"); B06 = (Number)SubMatROW.getAttribute("B06"); B07 = (Number)SubMatROW.getAttribute("B07"); B08 = (Number)SubMatROW.getAttribute("B08"); B09 = (Number)SubMatROW.getAttribute("B09"); B10 = (Number)SubMatROW.getAttribute("B10"); B11 = (Number)SubMatROW.getAttribute("B11"); B12 = (Number)SubMatROW.getAttribute("B12"); B13 = (Number)SubMatROW.getAttribute("B13"); B14 = (Number)SubMatROW.getAttribute("B14"); TOT_B = (Number)SubMatROW.getAttribute("TOT_B"); map4.put("CHARGE_NO" , CHARGE_NO ); map4.put("B01" , B01 ); map4.put("B02" , B02 ); map4.put("B03" , B03 ); map4.put("B04" , B04 ); map4.put("B05" , B05 ); map4.put("B06" , B06 ); map4.put("B07" , B07 ); map4.put("B08" , B08 ); map4.put("B09" , B09 ); map4.put("B10" , B10 ); map4.put("B11" , B11 ); map4.put("B12" , B12 ); map4.put("B13" , B13 ); map4.put("B14" , B14 ); map4.put("TOT_B" , TOT_B ); list4.add(map4); } else { map4.put("CHARGE_NO" , CHARGE_NO ); map4.put("B01" , "" ); map4.put("B02" , "" ); map4.put("B03" , "" ); map4.put("B04" , "" ); map4.put("B05" , "" ); map4.put("B06" , "" ); map4.put("B07" , "" ); map4.put("B08" , "" ); map4.put("B09" , "" ); map4.put("B10" , "" ); map4.put("B11" , "" ); map4.put("B12" , "" ); map4.put("B13" , "" ); map4.put("B14" , "" ); map4.put("TOT_B" , "" ); list4.add(map4); } */ } return PosBizControlConstants.SUCCESS; } }