package xin.glue.ui.B.common;

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

/**
 * 
 * @Description  人工判定次品或者正常流转{界面ID:}
 * @author       梅贵平{meiguiping}
 * @date         2009-9-8 下午02:41:40
 * @JDK Version  jdk1.4.2
 */
public class SaveSlabPersonDcs extends PosActivity
{

	public String runActivity(PosContext context)
	{
		///ready
		PosGenericDao	dao		=	this.getDao("mesdao");
		CallableStatement	cstm=	dao.getCallableStatement("UIB030202_05.CALLSTATEMENT");
		
		///get request data
		String[]DCS_FLAG    	=	(String[])context.get("DCS_FLAG");
		String[]rowStatus		=	(String[])context.get("rowStatus");
		String[]DCS_DETAIL		=	(String[])context.get("DCS_DETAIL");
		String[]REG_NM			=	(String[])context.get("REG_NM");
		String[]SLAB_NO			=	(String[])context.get("SLAB_NO");
		
		if(rowStatus == null) 
			return PosBizControlConstants.SUCCESS; 
		int	len	=	rowStatus.length;
		 
		try
		{
			for(int i = 0; i < len; i++)
			{
				cstm.setString(1, SLAB_NO[i]);//板坯号
				cstm.setString(2, REG_NM[0]);//操作人
				cstm.setString(3, DCS_FLAG[0]);//为L或者为F，L为正常流转，F为判废
				cstm.setString(4, DCS_DETAIL[0]);//说明（备注）
				cstm.registerOutParameter(5, java.sql.Types.VARCHAR);
				cstm.execute();
			}
		}catch(Exception ex)
		{
			logger.logWarn(ex.getMessage(), ex);
		}
		finally
		{

			if (cstm != null)
			{
				try
				{
					cstm.close();
				}
				catch (SQLException e)
				{
					logger.logWarn(e.getMessage(), e);
				}
			}

		}
		return  PosBizControlConstants.SUCCESS;
	}

}