XinYu_RZMES/.svn/pristine/db/db7963da8205dfbf6b3005335c152ffffafa4adb.svn-base

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 UIH060050_SendSPMPlan extends PosActivity 
{
	public String runActivity(PosContext context)
	{
		PosGenericDao	dao		=	this.getDao("mesdao");
		CallableStatement	cstm=	null;
		String[] CoilSEQ = (String[])context.get("COIL_EDT_SEQ");
		String[] chk	= (String[])context.get("CHK");
		String CoilSEQS = "";
		int    CoilNums = 0;
		String[] User = (String[])context.get("USER");
		try
		{
			int len = CoilSEQ.length;
			for(int i=0;i<len;i++)
			{
				if(chk[i].equals("Y")){
					CoilSEQS = CoilSEQS + CoilSEQ[i] + ";";
					CoilNums = CoilNums + 1;
				}
			}
			cstm		=	dao.getCallableStatement("UIH060050.send.SPMPlan");
			cstm.setString(1, CoilSEQS);
			cstm.setString(2, String.valueOf(CoilNums));
			cstm.setString(3, User[0]);
			cstm.registerOutParameter(4, java.sql.Types.VARCHAR);
			cstm.execute();
			
			String errorMsg = cstm.getString(4);
			context.put("ERROR_MSG", errorMsg);
			return PosBizControlConstants.SUCCESS;
		}
		catch(Exception ex)
		{
			return PosBizControlConstants.FAILURE;
		}finally
		{
			if (cstm != null)
			{
				try
				{
					cstm.close();
				}
				catch (SQLException e)
				{
					logger.logWarn(e.getMessage(), e);
				}
			}
		}
	}
}