package xin.glue.ui.F.F02;

import java.sql.CallableStatement;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

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

public class  SaveEditedCCR extends PosActivity {

    public String runActivity(PosContext ctx) {
    	//INSERT INTO TBF02_SCH_MILL
    	String[] SLAB_NO = (String[]) ctx.get("SLAB_NO");
    	int cntI  = 0;
    	for (int i = 0;i < SLAB_NO.length;i++) {
    		PosParameter paramI = new PosParameter();
   		    paramI.setValueParamter(0, SLAB_NO[i]);
   		    cntI = this.getDao("mesdao").insert("UIF023010.insertSCH_MILL", paramI);   		
    	}

    	//INSERT INTO TBF02_SCH_MILL_D
    	CallableStatement cStmt = null;
 
	    	cStmt = this.getDao("mesdao").getCallableStatement("callCCREdit");
			try {
				if(cStmt != null) {
					cStmt.execute();
				}				
			} catch (SQLException e) {
				throw new PosException(e.getMessage());
			}finally
			{
				if (cStmt != null)
				{
					try
					{
						cStmt.close();
					}
					catch (SQLException e)
					{
						logger.logWarn(e.getMessage(), e);
					}
				}
			}
    	return PosBizControlConstants.SUCCESS;
    }

}