XinYu_RZMES/.svn/pristine/dc/dc4c5f3226d3d0cd559ceb69626840c37d005e17.svn-base

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