package xin.glue.ui.G.G04;

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 SaveZHBslabDisrep extends PosActivity{
	public String runActivity(PosContext context)
	{
		PosGenericDao	dao		=	this.getDao("mesdao");
		CallableStatement	cstm=	null;
		String[] SlabNo = (String[])context.get("SLAB_NO");
		String[] User = (String[])context.get("USER");
		String[] CHK = (String[])context.get("CHK");
		if(SlabNo.length == 0){
			return PosBizControlConstants.FAILURE;
		}
		StringBuffer str = new StringBuffer();
		for(int i = 0 ; i < SlabNo.length;i++){
			if(!CHK[i].equals("Y"))continue;
			str.append("|").append(SlabNo[i]);
		}
		try
		{
			cstm		=	dao.getCallableStatement("UIH040120.zhb_slab_disrep");
			cstm.setString(1, str.toString());
			cstm.setString(2, User[0]);
			cstm.registerOutParameter(3, java.sql.Types.VARCHAR);
			cstm.execute();									  				
			String err1 = cstm.getString(3);
			
			
			/*财务数据上抛*/
			cstm	=	this.getDao("mesdao").getCallableStatement("UPLOAD_DATA.CAL");
			cstm.setString(1, SlabNo[0]);
			cstm.setString(2, "11AE");
			cstm.setString(3, "D");
			cstm.setString(4, "板坯挂单撤销");
			cstm.setString(5, User[0]);
			cstm.registerOutParameter(6, java.sql.Types.VARCHAR);
			cstm.execute();
			
			String err = cstm.getString(6);
			if(!org.apache.commons.lang.StringUtils.isBlank(cstm.getString(6))){
				context.put("MESSAGES","数据上传失败:" + err);
				return PosBizControlConstants.FAILURE;
			}
			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);
				}
			}
		}
	}
	
	

}