package xin.glue.ui.F.F01;

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

public class changeStlGrd extends PosActivity {

	public String runActivity(PosContext context) {
		PosGenericDao dao = getDao("mesdao");
		
		String[] sChargeManaNo = (String[])context.get("CHARGE_NO");
		String[] sTargetChargeNO  = (String[])context.get("TARGET_CHARGE_NO");
		
		CallableStatement	cstm =	null;
		try{
	    	cstm	=	dao.getCallableStatement("UIF012070_02.CALLSTATEMENT");
			cstm.setString(1, sChargeManaNo[0]);
			cstm.setString(2, sTargetChargeNO[0]);
			cstm.registerOutParameter(3, java.sql.Types.VARCHAR);
			cstm.execute();
	    }catch(Exception ex){
	    	logger.logError(ex.getMessage(), ex);
	    }finally
		{
			if (cstm != null)
			{
				try
				{
					cstm.close();
				}
				catch (SQLException e)
				{
					logger.logWarn(e.getMessage(), e);
				}
			}
		}
		
		context.put("messages", " ²Ù×÷³É¹¦£¡");
		return PosBizControlConstants.SUCCESS;
	}

}