package xin.glue.ui.H.H06;

import java.sql.CallableStatement;
import java.sql.SQLException;

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;

public class UIH060030_AddSPMPlan extends PosActivity
{
	public String runActivity(PosContext context)
	{
		PosGenericDao	dao		=	this.getDao("mesdao");
		CallableStatement	cstm=	null;
		String[] CoilNO = (String[])context.get("OLD_SAMPL_NO");
		String[] spmPlanSeq = (String[])context.get("SPM_PLAN_SEQ");
		String[] chk	= (String[])context.get("CHK");
		String HCoilNOS = "";
		int CoilNum = 0;
		String[] User = (String[])context.get("USER");
		try
		{
			int len = CoilNO.length;
			for(int i=0;i<len;i++)
			{
				if(chk[i].equals("Y")){
					HCoilNOS = HCoilNOS + spmPlanSeq[i] + ";";
					//HCoilNOS = HCoilNOS + CoilNO[i] + ";";
					CoilNum = CoilNum + 1;
				}
			}										  				
			cstm		=	dao.getCallableStatement("UIH060030.insert.SPMPlan");
			cstm.setString(1, HCoilNOS);
			cstm.setString(2, String.valueOf(CoilNum));
			cstm.setString(3, "AA");
			cstm.execute();
			return PosBizControlConstants.SUCCESS;
		}
		catch(Exception ex)
		{
			logger.logDebug(ex.getMessage());
			return PosBizControlConstants.FAILURE;
		}finally
		{
			if (cstm != null)
			{
				try
				{
					cstm.close();
				}
				catch (SQLException e)
				{
					logger.logWarn(e.getMessage(), e);
				}
			}
		}
	}
}