package xin.glue.ui.T.T03;

import java.math.BigDecimal;
import java.util.HashMap;
import java.util.Map;

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.PosDaoException;
import com.posdata.glue.dao.PosGenericDao;
import com.posdata.glue.dao.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRow;
import com.posdata.glue.dao.vo.PosRowSet;

public class InsertL2Table02 extends PosActivity {

	public String runActivity(PosContext context) {

		try {
			logger.logInfo("InsertL2Table02");
			PosGenericDao	dao		=  (PosGenericDao)getDao("rundao");
			dao.delete("DeleteL2Table02.Delete");
			
			PosRowSet   	rs    	=   (PosRowSet) context.get("ListResult_2");
	logger.logInfo("rs.count() = ["+ rs.count() +"]");
	
			PosRow      	row   	=   null;
			Map         	map   	=   new HashMap();
	
			int				iRows	=	0;
	
			rs.reset();
			while( rs.hasNext() ) {
				row = rs.next();
				map = row.getAttributes();
	
				String  sDb_LgCd        =    ((String)map.get("LG_CD"   ) == null ? "" : (String)map.get("LG_CD"   )).toString() ; //LG_CD
				String  sDb_SmCd        =    ((String)map.get("SM_CD"   ) == null ? "" : (String)map.get("SM_CD"   )).toString() ; //SM_CD
				String  sDb_LgNm        =    ((String)map.get("LG_NM"   ) == null ? "" : (String)map.get("LG_NM"   )).toString() ; //LG_NM
				String  sDb_SmCfnm      =    ((String)map.get("SM_CFNM" ) == null ? "" : (String)map.get("SM_CFNM" )).toString() ; //SM_CFNM
				String  sDb_SmCsnm      =    ((String)map.get("SM_CSNM" ) == null ? "" : (String)map.get("SM_CSNM" )).toString() ; //SM_CSNM
				String  sDb_SmEfnm      =    ((String)map.get("SM_EFNM" ) == null ? "" : (String)map.get("SM_EFNM" )).toString() ; //SM_EFNM
				String  sDb_SmEsnm      =    ((String)map.get("SM_ESNM" ) == null ? "" : (String)map.get("SM_ESNM" )).toString() ; //SM_ESNM
				String  sDb_BizClf      =    ((String)map.get("BIZ_CLF" ) == null ? "" : (String)map.get("BIZ_CLF" )).toString() ; //BIZ_CLF
				String  sDb_CdSeq       =    ((BigDecimal)map.get("CD_SEQ")).toString() ; //CD_SEQ
				String  sDb_UsedYn      =    ((String)map.get("USED_YN" ) == null ? "" : (String)map.get("USED_YN" )).toString() ; //USED_YN
				String  sDb_CdDesc      =    ((String)map.get("CD_DESC" ) == null ? "" : (String)map.get("CD_DESC" )).toString() ; //CD_DESC
				String  sDb_CdLen       =    ((BigDecimal)map.get("CD_SEQ")).toString() ; //CD_LEN
				String  sDb_ModId       =    ((String)map.get("MOD_ID"  ) == null ? "" : (String)map.get("MOD_ID"  )).toString() ; //MOD_ID
				String  sDb_ModDate     =    ((String)map.get("MOD_DATE") == null ? "" : (String)map.get("MOD_DATE")).toString() ; //MOD_DATE
				
				logger.logInfo(iRows + " sDb_LgCd = ["+ sDb_LgCd +"] sDb_SmCd = ["+ sDb_SmCd +"]") ;
	
				PosParameter	param	=	new PosParameter();
	
				param.setValueParamter(  0, sDb_LgCd    );
				param.setValueParamter(  1, sDb_SmCd    );
				param.setValueParamter(  2, sDb_LgNm    );
				param.setValueParamter(  3, sDb_SmCfnm  );
				param.setValueParamter(  4, sDb_SmCsnm  );
				param.setValueParamter(  5, sDb_SmEfnm  );
				param.setValueParamter(  6, sDb_SmEsnm  );
				param.setValueParamter(  7, sDb_BizClf  );
				param.setValueParamter(  8, sDb_CdSeq   );
				param.setValueParamter(  9, sDb_UsedYn  );
				param.setValueParamter( 10, sDb_CdDesc  );
				param.setValueParamter( 11, sDb_CdLen   );
				param.setValueParamter( 12, sDb_ModId   );
				param.setValueParamter( 13, sDb_ModDate );
		        
		        dao.insert("InsertL2Table02.Insert", param);
	
				iRows++;
			}
	
			logger.logInfo("iTotal = ["+ iRows +"]");
			
			context.put("ResultCallSubService02", "02SubService-OK");

		} catch(Exception e) {

			context.put("ResultCallSubService02", "02SubService-ERROR");
			throw new PosDaoException( (new StringBuffer("Parameters initialize failed. detailMessage = ")).append(e.toString()).toString(), e );

		}

		return PosBizControlConstants.SUCCESS;
	}

}