package xin.glue.ui.B.B01;

import java.sql.CallableStatement;

import com.posdata.glue.biz.activity.PosActivity;
import com.posdata.glue.biz.constants.PosBizControlConstants;
import com.posdata.glue.biz.control.PosBizControlIF;
import com.posdata.glue.biz.control.PosBizController;
import com.posdata.glue.context.PosContext;
import com.posdata.glue.dao.PosGenericDao;
import com.posdata.glue.dao.vo.PosParameter;

public class SaveSpecIsUsed extends PosActivity
{

	public String runActivity(PosContext context)
	{
		
		String[] USED_YN	    =	(String[])context.get("USED_YN");//设置为无效
		String[] rowStatus	    =	(String[])context.get("rowStatus");//标记
		String[] SPEC_ABBSYM	=	(String[])context.get("SPEC_ABBSYM");//标准号
		String[] SPEC_STL_GRD	=	(String[])context.get("SPEC_STL_GRD");//标准钢号
		String[] PRDNM_CD		=	(String[])context.get("PRDNM_CD");//交货状态
		
		PosGenericDao	     dao =	this.getDao("mesdao");
		CallableStatement	cstm =	null;
		
		if(rowStatus != null)
		{
			try
			{
				cstm	=	dao.getCallableStatement("UIB016001_01.CALL");
				int len = rowStatus.length;
				for(int i = 0 ; i < len ; i++)
				{
					cstm.setString(1, PRDNM_CD[i]);
					cstm.setString(2, SPEC_ABBSYM[i]);
					cstm.setString(3, SPEC_STL_GRD[i]);
					cstm.setString(4, USED_YN[i]);
					cstm.registerOutParameter(5, java.sql.Types.VARBINARY);
					cstm.execute();
				}
			}catch(Exception ex)
			{
				ex.printStackTrace();
			}
			finally
			{
				if(cstm != null)
				{
					try
					{
						cstm.close();
					}
					catch(Exception e)
					{
						e.printStackTrace();
					}
				}
			}
		}
		return PosBizControlConstants.SUCCESS;
	}

}