package xin.glue.ui.G.G04;


import java.math.BigDecimal;
import java.sql.CallableStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;

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

public class XinCraneOrderCheck extends PosActivity {

	public String runActivity(PosContext context) {
		PosParameter param = null;
		PosRowSet rowSet = null;
		PosRow row = null;
		CallableStatement	cstm =	null;
		
		
		ArrayList list = new ArrayList();
		Map map = null;
		
		param = new PosParameter();
		rowSet = getDao("mesdao").find("UIG040047_UNEXICUTED_CRORD.select",param);
		while(rowSet.hasNext()){
			BigDecimal seqNo = null;
			String fromAddr = null;
			String toAddr = null;
			String slabNo = null;
			String rtnSlabNoYn = null;
			String rtnCd = null;
			String rtnMsg = null;
			
			row = rowSet.next();
			seqNo = (BigDecimal)row.getAttribute("SEQ_NO");
			fromAddr = (String)row.getAttribute("FROM_ADDR");
			toAddr = (String)row.getAttribute("TO_ADDR");
			slabNo = (String)row.getAttribute("ORD_SLAB_NO1");
			
			try{
				cstm	=	getDao("mesdao").getCallableStatement("NIG040047_01.CALLSTATEMENT");
				cstm.setBigDecimal(1, seqNo);
				cstm.setString(2, fromAddr);
				cstm.setString(3, toAddr);
				cstm.setString(4, slabNo);
				cstm.registerOutParameter(5, java.sql.Types.VARCHAR);
				cstm.registerOutParameter(6, java.sql.Types.VARCHAR);
				cstm.registerOutParameter(7, java.sql.Types.VARCHAR);
				cstm.execute();
				rtnSlabNoYn	=	cstm.getString(5);
				rtnCd			=	cstm.getString(6);
				rtnMsg			=	cstm.getString(7);
				
				if(rtnSlabNoYn.equals("Y")){
					map = new HashMap(20);
					map.put("SLAB_NO", slabNo);
					list.add(map);
				}
			}catch(Exception ex){
				ex.printStackTrace();
			}finally
			{

				if (cstm != null)
				{
					try
					{
						cstm.close();
					}
					catch (SQLException e)
					{
						logger.logWarn(e.getMessage(), e);
					}
				}

			}
		}
		context.put("CHECK_RESULT",list);
		return PosBizControlConstants.SUCCESS;
	}
}