package xin.glue.ui.F.F02;


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

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;


public class  UpdateSchRoll extends PosActivity {

    public String runActivity(PosContext ctx) {
    	String[] V_isYH = (String[]) ctx.get("isYH");
        //DELETE FROM TBF02_SCH_ROLL
    	int cntD = this.getDao("mesdao").delete("UIF023010.deleteSchRoll");
    	
        //INSERT INEW CCR ROLL INFOMATION TO  TBF02_SCH_ROLL
	 	int cntI = this.getDao("mesdao").insert("UIF023010.insertSCH_ROLL");
	 
	 	//adjust the roll_slab_seq by wth and thk desc
	 	CallableStatement cStmt = null;
	 	if (V_isYH == null) V_isYH = new String[]{"N"};
	 	if("Y".equals(V_isYH[0]))  {
	 		cStmt = this.getDao("mesdao").getCallableStatement("callAdjustRollSlabSeqByWthDesc");
	 	}
	    
		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;
	    	
	}	
}