package xin.glue.ui.F.F02;

import java.sql.CallableStatement;
import java.sql.SQLException;
import java.sql.Types;

import kr.co.comsquare.rwXmlLib.RwXml;

import com.posdata.glue.PosException;
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.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRowSet;
import com.posdata.glue.transaction.PosDataSourceTransactionManager;
import com.posdata.glue.transaction.PosTransactionManager;

public class SaveMIllSch extends PosActivity {
	public String runActivity(PosContext ctx) {

		String[] OPERATE = (String[]) ctx.get("OPERATE");
		String[] FIRSTPOSITION = (String[]) ctx.get("FIRSTPOSITION");
		String[] AIMPOSITION = (String[]) ctx.get("AIMPOSITION");
		String[] LASTPOSITION = (String[]) ctx.get("LASTPOSITION");
		String[] POSITION = (String[]) ctx.get("POSITION");
		String P_RTN_MSG = "";
		// tx.clearTransactionStatus();
		CallableStatement cStmt = null;
		try {
			cStmt = this.getDao("mesdao").getCallableStatement("callUIF023020");
			cStmt.setString(1, FIRSTPOSITION[0]);
			cStmt.setString(2, LASTPOSITION[0]);
			cStmt.setString(3, AIMPOSITION[0]);
			cStmt.setString(4, POSITION[0]);
			cStmt.setString(5, OPERATE[0]);
			cStmt.registerOutParameter(6, Types.VARCHAR);
			cStmt.execute();
			P_RTN_MSG = cStmt.getString(6);
		} catch (SQLException e) {
			// e.printStackTrace();
			throw new PosException(e.getMessage());
		} finally {
			if (cStmt != null) {
				try {
					cStmt.close();
				} catch (SQLException e) {
					logger.logWarn(e.getMessage(), e);
				}
			}
		}

		if (P_RTN_MSG == null || "".equals(P_RTN_MSG)) {
		} else {
			throw new PosException(P_RTN_MSG);
		}
		return PosBizControlConstants.SUCCESS;
	}

}