package xin.glue.ui.B.B02;


import java.sql.CallableStatement;

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:UIB020030}
 * @author       梅贵平{meiguiping}
 * @date         2009-1-5 下午09:37:38
 * @JDK Version  jdk1.4.2
 */
public class SaveChargeAchievement extends PosActivity
{

	public String runActivity(PosContext context)
	{
		///ready
		PosGenericDao	    dao	 =	this.getDao("mesdao");
		CallableStatement	cstm =	null;
		///获取请求参数
		String[]REG_NM		=	(String[])context.get("REG_NM");

		String[]CHARGE_NO	=	(String[])context.get("CHARGE_NO");//炉次号，插入时其作用
		String[]PROC_CD		=	(String[])context.get("PROC_CD");//成分，插入时其作用
		String[]CHEM_SEQ	=	(String[])context.get("CHEM_SEQ");//工序，插入时其作用
		String[]CHEM_L2_PROC_CD=(String[])context.get("CHEM_L2_PROC_CD");//L2对应的工序代码
		String[]MOD_RMK		=	(String[])context.get("MOD_RMK");//备注
		
		//表格2、3、4、5
		String[]rowStuts2	=	(String[])context.get("rowStuts2");//对应表格2、3、4、5修改的信息
		String[]CHEM_CD		=	(String[])context.get("CHEM_CD");//成分代码
		String[]CHEM_VAL	=	(String[])context.get("CHEM_VAL");//实绩值
		
		String[]rowStuts1	=	(String[])context.get("rowStuts1");//针对datagrid1
		String[]rowStatusD	=	(String[])context.get("rowStatusD");//删除
		try
		{
			if(rowStuts2 != null)
			{
				int		len		=		rowStuts2.length;
				cstm			=		dao.getCallableStatement("UIB020030_01.CALLSTATEMENT");
				int		j		=		1;
				
				for(int i = 0; i < len; i++)
				{
					j	=	1;
					cstm.setString(j++, CHARGE_NO[0]);
					cstm.setString(j++, PROC_CD[0]);
					cstm.setString(j++, CHEM_SEQ[0]);
					cstm.setString(j++, CHEM_CD[i]);
					cstm.setString(j++, CHEM_VAL[i]);
					cstm.setString(j++, CHEM_L2_PROC_CD[0]);
					cstm.setString(j++, REG_NM[0]);
					cstm.setString(j++, MOD_RMK[0]);//备注
					cstm.setString(j++, Integer.toString(i));
					cstm.registerOutParameter(j++, java.sql.Types.VARCHAR);
					cstm.execute();
				}
			}
			else if(rowStatusD != null)
			{
				cstm			=		dao.getCallableStatement("UIB020030_02.CALLSTATEMENT");
				cstm.setString(1, CHARGE_NO[0]);
				cstm.setString(2, PROC_CD[0]);
				cstm.setString(3, CHEM_SEQ[0]);
				cstm.registerOutParameter(4, java.sql.Types.VARCHAR);
				cstm.execute();
			}
			else if(rowStuts1 != null)
			{
//				if("u".equals(rowStuts1[0]))
//				{
//					PosParameter	param	=	new PosParameter();
//					param.setWhereClauseParameter(0, CHEM_L2_PROC_CD)
//				}
			}
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
		finally
		{
			try
			{
				if(cstm != null)
				{
					cstm.close();
				}
			}catch(Exception e)
			{
				e.printStackTrace();
			}
		}
		
		
		return PosBizControlConstants.SUCCESS;
	}
}