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.biz.control.PosBizProvider;
import com.posdata.glue.context.PosContext;
import com.posdata.glue.dao.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRowSet;
import com.posdata.glue.msg.PosMESMessageImpl;
import com.posdata.glue.msg.PosMessage;
import com.posdata.glue.transaction.PosDataSourceTransactionManager;
import com.posdata.glue.transaction.PosTransactionManager;

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

		String[] P_REG_ID = (String[]) ctx.get("USER_NAME");
		String P_RTN_MSG = "";
		// tx.clearTransactionStatus();
		CallableStatement cStmt = null;
		try {
			cStmt = this.getDao("mesdao").getCallableStatement("callCCR_SLAB_ORD_REP");
			cStmt.setString(1, P_REG_ID[0]);		
			cStmt.registerOutParameter(2, Types.VARCHAR);
			cStmt.execute();
			P_RTN_MSG = cStmt.getString(2);
		} 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);
		}
		NIE012080_CALL();
		return PosBizControlConstants.SUCCESS;
	}
	
	public PosContext NIE012080_CALL()
	{
		PosContext context = new PosContext();
		PosMessage message = new PosMESMessageImpl();
		
		//OrdStsMain
		String TcId = "NIE012080";
		message.setTCID(TcId);
		message.setObject("MSG_ID", TcId);
		message.setObject("AA",     ""); 
		context.setMessage(message);		
		message.setTCID(TcId);
		
		String SERVICE_POSTFIX = "-service";
		context.put(PosBizControlConstants.SERVICE_NAME, TcId + SERVICE_POSTFIX);
		PosBizProvider.getController().doSubController(context, false);
		
		String SERVICE_ERR_MSG = (String) context.get("SERVICE_ERR_MSG");
		
		if (SERVICE_ERR_MSG != null)
		{
			throw new PosException(SERVICE_ERR_MSG);
		}
		
		return context; 
	}

}