package xin.glue.ui.G.G04;

import java.sql.CallableStatement;

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

public class SaveZhbSCHProcStat extends PosActivity
{

	public String runActivity(PosContext context)
	{
	
		PosGenericDao	     dao =	this.getDao("mesdao");
		CallableStatement	cstm =	null;
//		PosParameter	   param =	null;
		
		String[]    L2_SCH_NO 	=   (String[])context.get("L2_SCH_NO");
		String[]	DSN_SLAB_NO	=	(String[])context.get("DSN_SLAB_NO");
		String[]    REG_NM		=	(String[])context.get("REG_NM");
		String[]	rowStuts	=	(String[])context.get("rowStuts");
		
		try
		{
			cstm	       =	dao.getCallableStatement("UIG040130_01.CALL");
			for(int i=0; i < rowStuts.length; i++)
			{
				cstm.setString(1, L2_SCH_NO[i]);//×¢Ò⣬ÐòºÅ´Ó1¿ªÊ¼
				cstm.setString(2, DSN_SLAB_NO[i]);
				cstm.setString(3, REG_NM[0]);
				cstm.registerOutParameter(4, java.sql.Types.VARCHAR);
				cstm.execute();	
			}
			
//			PosRowSet	prs	=	dao.find("UIG040130_01.SELECT");
//			context.put("SCH_Result", prs);
		}catch(Exception ex)
		{
			logger.logError(ex.getMessage(), ex);
		}
		       
		return PosBizControlConstants.SUCCESS;
	}

}