package xin.glue.ui.T.T01;

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

public class SynchronizeL2WithL3 extends PosActivity {

	public String runActivity(PosContext context) {

		//
		PosGenericDao		dao		=  (PosGenericDao)getDao("xetdao");

		PosRowSet   	rs    	=   (PosRowSet) context.get("ListResult_1");
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	sCoilNo	= ((String)map.get("COIL_NO")).toString() ;
			String  sSlabNo = ((String)map.get("SLAB_NO") == null ? "" : (String)map.get("SLAB_NO")).toString() ;
			
			logger.logInfo(iRows + " CoilNo = ["+ sCoilNo +"] SlabNo = ["+ sSlabNo +"]") ;

			PosParameter	param	=	new PosParameter();

			param.setValueParamter(  0, sCoilNo );
	        param.setValueParamter(  1, sSlabNo );
	        
	        dao.insert("SynchronizL2WithL3.InsertL2CoilComm.Insert", param);

			iRows++;
		}

		logger.logInfo("iTotal = ["+ iRows +"]");

		return PosBizControlConstants.SUCCESS;
	}

}