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_AFMSPMPlan extends PosActivity 
{
	public String runActivity(PosContext context)
	{
		PosGenericDao	dao		=	this.getDao("mesdao");
		CallableStatement	cstm=	null;
		String[] SPMNO = (String[])context.get("SPMNO");
		String[] User = (String[])context.get("USER");
		try
		{
			cstm		=	dao.getCallableStatement("UIH060030.affirm.SPMPlan");
			cstm.setString(1, SPMNO[0]);
			cstm.setString(2, "AA");
			cstm.execute();
			return PosBizControlConstants.SUCCESS;
		}
		catch(Exception ex)
		{
			return PosBizControlConstants.FAILURE;
		}finally
		{
			if (cstm != null)
			{
				try
				{
					cstm.close();
				}
				catch (SQLException e)
				{
					logger.logWarn(e.getMessage(), e);
				}
			}
		}
	}
}