XinYu_RZMES/.svn/pristine/25/25e40af2ca9fd07ad65db8aad8b48d62df2654d0.svn-base

package xin.glue.nui.F.F02;

import java.math.BigDecimal;
import xin.glue.user.common.GlobalConstants;
import xin.glue.user.common.LogGpError;
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.PosRow;
import com.posdata.glue.dao.vo.PosRowSet;
import com.posdata.glue.msg.PosMESMessageImpl;
import com.posdata.glue.msg.PosMessage;

//import java.lang.Long;

/* Program Name  MILLLvlCan (NIF024060)
 * Description   MILL WORK INSTRUCTION LEVEL2 CANCEL 
 * Write By      KIM SUNG HO 
 * Date          2008-11-12
 */

public class MILLLvlCan extends PosActivity implements GlobalConstants {
		
	public String runActivity(PosContext context) {
		
		long V_ROLL_SLAB_SEQ_ST  = 0 ;
		long V_ROLL_SLAB_SEQ_EN  = 0 ;		
		long V_PRC_CNT           = 0 ;
		long V_CCR_CNT           = 0 ;
		long V_STATUS_CNT        = 0 ;
		long V_COIL_STAT_CNT     = 0 ;
		long V_SLAB_WGT          = 0 ;
		long V_ROLL_SLAB_CNT     = 0 ;
		long V_ROLL_SLAB_WGT     = 0 ;
		long V_HCR_CNT           = 0 ;
		long V_MILL_LEN          = 0 ;
		long V_SPM_CNT           = 0 ;
				
		String V_ROLL_MANA_NO    = "" ;
		String V_ROLL_MANA_ST    = "" ;
		String V_ROLL_MANA_EN    = "" ;
		String V_CHARGE_MANA_ST  = "" ;
		String V_CHARGE_MANA_EN  = "" ;
		String V_SLAB_NO         = "" ;
		String V_HCR_CLF         = "" ;
		String V_ORD_NO          = "" ;
		String V_ORD_SEQ         = "" ;
		String V_SEND_CLF        = "" ;
		String V_PGMID           = "" ;
		
		String V_TABLE_ID        = "" ;
		String V_TABLE_MODE      = "" ;
		String V_ERR_DESC        = "" ; 
		String V_RTN_NAME        = "" ;
	
		PosMessage message = context.getMessage();	
		
		//P_TYPE : "R" --> ROLL         (FROM/TO  ROLL NO)  轧辊指示取消
		//         "S" --> SLAB         (FROM/TO  SLAB NO)	板坯指示取消
		//         "C" --> RHT-OUT      (FROM/TO  SLAB NO)  板坯吊销
		//         "M" --> CCM CANCEL   (FROM/TO  SLAB NO)  成分异常指示取消
		//         "Z" --> SIZE DEC     (FROM/TO  SLAB NO)  尺寸异常取消
		//         "E" --> External DEC (FROM/TO  SLAB NO)  表面异常取消
		
		String P_TYPE    = (String)message.get("TYPE"); 
		String P_ST      = (String)message.get("FROM"); 
		String P_EN      = (String)message.get("TO"); 
		String P_REG_ID  = (String)message.get("REG_ID");
		
//		try {
		
			if (P_TYPE.equals("C")) {
				
				V_PGMID = "MILLLvlCanRHT" ;
				
			} else if (P_TYPE.equals("M")) {
				
				V_PGMID = "MILLLvlCanCcm";
				
			} else if (P_TYPE.equals("Z")) {
				
				V_PGMID = "MILLLvlCanSize";
				
			} else if (P_TYPE.equals("E")) {
				
				V_PGMID = "MILLLvlCanExternal";				
			
			} else  { //P_TYPE "R" --> ROLL, "S" --> SLAB
				
				V_PGMID = "MILLLvlCan";
				
			} //V_PGMID赋值
		
			if (P_TYPE.equals("R")) {
				
				if (P_ST.compareTo(P_EN) > 0) {
					
					//MESSAGE ERROR --> PROGRAM EXIT
					throw new PosException("MILLLvlCan..ROLL_MANA_NO ST > EN..");
				}
			} else  {
				
				if (P_ST.length() != 13 || P_EN.length() != 13) {
					
					//MESSAGE ERROR --> PROGRAM EXIT
					throw new PosException("MILLLvlCan..SLAB_NO ERROR..");
				}
			}//位置和长度检查
			
			if (P_TYPE.equals("R")) {   //ROLL UNIT
				
				//FIRST/LAST ROLL_MANA_NO FIRST/LAST ROLL_SLAB_SEQ CHECK 
			    PosParameter paramA = new PosParameter();
			    paramA.setWhereClauseParameter(0, P_ST); 
			    paramA.setWhereClauseParameter(1, P_EN); 
			    PosRowSet RollSlabVO = getDao("mesdao").find("NIF024060_RollSlab.select",paramA);
			    RollSlabVO.reset();
			    
				if (RollSlabVO.hasNext()) {
					
					PosRow RollSlabRow  = RollSlabVO.next();
					V_ROLL_MANA_ST      = P_ST;
					V_ROLL_MANA_EN      = P_EN;
					V_ROLL_SLAB_SEQ_ST  = Long.parseLong((RollSlabRow.getAttribute("ROLL_SLAB_SEQ_ST")==null? "0":RollSlabRow.getAttribute("ROLL_SLAB_SEQ_ST")).toString());
					V_ROLL_SLAB_SEQ_EN  = Long.parseLong((RollSlabRow.getAttribute("ROLL_SLAB_SEQ_EN")==null? "0":RollSlabRow.getAttribute("ROLL_SLAB_SEQ_EN")).toString());
					
				} else {
					
					V_ROLL_MANA_ST      = "";
					V_ROLL_MANA_EN      = "";
					V_ROLL_SLAB_SEQ_ST  = 0;
					V_ROLL_SLAB_SEQ_EN  = 0;
				}			
										
			} else {    //SLAB UNIT
				
				//ROLL_SLAB_SEQ CHECK 
			    PosParameter param0 = new PosParameter();
			    param0.setWhereClauseParameter(0, P_ST); 
			    param0.setWhereClauseParameter(1, P_EN);
			    PosRowSet RollSlabSeqVO = getDao("mesdao").find("NIF024060_RollSlabSeq.select",param0);
			    RollSlabSeqVO.reset();
			    
				if (RollSlabSeqVO.hasNext()) {
					
					PosRow RollSlabSeqRow  = RollSlabSeqVO.next();
					V_ROLL_MANA_ST      = (String)RollSlabSeqRow.getAttribute("ROLL_MANA_ST");
					V_ROLL_MANA_EN      = (String)RollSlabSeqRow.getAttribute("ROLL_MANA_EN");
					V_ROLL_SLAB_SEQ_ST  = Long.parseLong((RollSlabSeqRow.getAttribute("ROLL_SLAB_SEQ_ST")==null? "0":RollSlabSeqRow.getAttribute("ROLL_SLAB_SEQ_ST")).toString());
					V_ROLL_SLAB_SEQ_EN  = Long.parseLong((RollSlabSeqRow.getAttribute("ROLL_SLAB_SEQ_EN")==null? "0":RollSlabSeqRow.getAttribute("ROLL_SLAB_SEQ_EN")).toString());
				} else {
					
					V_ROLL_MANA_ST      = "";
					V_ROLL_MANA_EN      = "";
					V_ROLL_SLAB_SEQ_ST  = 0;
					V_ROLL_SLAB_SEQ_EN  = 0;
				}	
				
				if (!V_ROLL_MANA_ST.equals(V_ROLL_MANA_EN)) {

					//MESSAGE ERROR --> PROGRAM EXIT
					throw new PosException("MILLLvlCan..ROLL_MANA_NO ST/EN DIFFERENCE..");
				}
			}
			
			if (V_ROLL_SLAB_SEQ_ST == 0 || V_ROLL_SLAB_SEQ_EN == 0){
				
				//MESSAGE ERROR --> PROGRAM EXIT
				throw new PosException("MILLLvlCan..ROLL_SLAB_SEQ ST/EN IS ZERO..");				
			}

			//热装HCR 删除 HCR 由HCR_CCR  add by sunjiawang 090624
		//	this.updMillHCR(P_TYPE, P_ST, P_EN);
			
			//SELECT TBF02_SPEC_MILL JOB START CHECK
			if (!P_TYPE.equals("C")) {          // "C" --> RHT-OUT
			    PosParameter param1 = new PosParameter();
			    param1.setWhereClauseParameter(0, V_ROLL_MANA_ST); 
			    param1.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
			    param1.setWhereClauseParameter(2, V_ROLL_MANA_EN); 
			    param1.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
			    PosRowSet MILLStatusChkVO = getDao("mesdao").find("NIF024060_MILLStatusChk.select",param1);
			    MILLStatusChkVO.reset();
				
			    if (MILLStatusChkVO.hasNext()) {
					
					PosRow MILLStatusChkRow  = MILLStatusChkVO.next();
					V_STATUS_CNT  = Long.parseLong((MILLStatusChkRow.getAttribute("STATUS_CNT")==null? "0":MILLStatusChkRow.getAttribute("STATUS_CNT")).toString());
					V_COIL_STAT_CNT  = Long.parseLong((MILLStatusChkRow.getAttribute("COIL_STAT_CNT")==null? "0":MILLStatusChkRow.getAttribute("COIL_STAT_CNT")).toString());
				} 
			    
			    if (V_STATUS_CNT != 0){
					
					//MESSAGE ERROR --> PROGRAM EXIT
			    	throw new PosException("MILLLvlCan..STATUS_CD = 'B'..");			
				}
			    
				if  (V_COIL_STAT_CNT != 0) {
					
					//MESSAGE ERROR --> PROGRAM EXIT
					throw new PosException("板坯已上料 MILLLvlCan..COIL_STAT = '0'..");
					
				}
			}
			
		    //-------------------------------------------------------------------------------
		    //INSERT MILL INSTRUCTION LEVEL2 CANCEL PROCESS ---------------------------------
		    
			if (!P_TYPE.equals("C")) {    // "C" --> RHT-OUT
			    //TBH06_L2_RHT_INS CANCEL PROCESS
			    PosParameter paramC = new PosParameter();
			    paramC.setValueParamter(0, V_ROLL_MANA_ST); 
			    paramC.setValueParamter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
			    paramC.setValueParamter(2, V_ROLL_MANA_EN); 
			    paramC.setValueParamter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
			    int InsertC = getDao("mesdao").insert("NIF024060_L2RHTCancel.insert",paramC);
			    
			    if (InsertC == 0) {
					
					V_TABLE_ID    =  "TBH06_L2_RHT_INS";
					V_TABLE_MODE  =  "I";
					V_ERR_DESC    =  "TBH06_L2_RHT_INS INSERT COUNT IS ZERO";
					V_RTN_NAME    =  "MILLLvlCan TBH06_L2_RHT_INS INSERTC " + String.valueOf(V_ROLL_SLAB_SEQ_ST);
					
					LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					//throw new PosException(V_RTN_NAME);
				}
			}
		    
		    //TBH06_L2_MILL_INS CANCEL PROCESS
		    PosParameter paramD = new PosParameter();
		    paramD.setValueParamter(0, V_ROLL_MANA_ST); 
		    paramD.setValueParamter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
		    paramD.setValueParamter(2, V_ROLL_MANA_EN); 
		    paramD.setValueParamter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
		    int InsertD = getDao("mesdao").insert("NIF024060_L2MILLCancel.insert",paramD);
		    
		    if (InsertD == 0) {
				
				V_TABLE_ID    =  "TBH06_L2_MILL_INS";
				V_TABLE_MODE  =  "I";
				V_ERR_DESC    =  "TBH06_L2_MILL_INS INSERT COUNT IS ZERO";
				V_RTN_NAME    =  "MILLLvlCan TBH06_L2_MILL_INS INSERTD " + String.valueOf(V_ROLL_SLAB_SEQ_ST);
				
				LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
				//throw new PosException(V_RTN_NAME);
			}

		    //TBH06_L2_COIL_NO_INS CANCEL PROCESS
		    if (P_TYPE.equals("R")) {    //ROLL UNIT
		    	
			    PosParameter paramE = new PosParameter();
			    paramE.setWhereClauseParameter(0, V_ROLL_MANA_ST);  
			    paramE.setWhereClauseParameter(1, V_ROLL_MANA_EN);  
			    PosRowSet L2RollCoilVO = getDao("mesdao").find("NIF024060_L2RollCoil.select",paramE);
			    L2RollCoilVO.reset();
				
			    while (L2RollCoilVO.hasNext()) {
					
					PosRow L2RollCoilRow  = L2RollCoilVO.next();
					V_ROLL_MANA_NO  = (String)L2RollCoilRow.getAttribute("ROLL_MANA_NO");    
	
					//SELECT NXET SET SEQUEANCE
					String nextSeqQr = "SELECT L2_COIL_NO_SET_SEQ.NEXTVAL SET_SEQ FROM DUAL ";
					PosRowSet nextSeqVO = getDao("mesdao").findByQueryStatement(nextSeqQr);
					nextSeqVO.reset();
					PosRow nextSeqRow = nextSeqVO.next(); 
					Number V_SET_SEQ = (Number)nextSeqRow.getAttribute("SET_SEQ");

					PosParameter paramF = new PosParameter(); 
				    paramF.setValueParamter(0, V_SET_SEQ);    
				    paramF.setValueParamter(1, V_ROLL_MANA_NO); 
				    int InsertF = getDao("mesdao").insert("NIF024060_L2ROLLCOILCancel.insert",paramF);
				    
				    if (InsertF == 0) {
						
						V_TABLE_ID    =  "TBH06_L2_COIL_NO_INS";
						V_TABLE_MODE  =  "I";
						V_ERR_DESC    =  "TBH06_L2_COIL_NO_INS INSERT COUNT IS ZERO";
						V_RTN_NAME    =  "MILLLvlCan TBH06_L2_COIL_NO_INS INSERTF " + V_ROLL_MANA_NO;
						
						LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
						//throw new PosException(V_RTN_NAME);
					}
				    
			    } //L2RollCoilVO while END				    
					
			} else {                     //SLAB_UNIT
				
				//SELECT NXET SET SEQUEANCE
				String nextSeqQr = "SELECT L2_COIL_NO_SET_SEQ.NEXTVAL SET_SEQ FROM DUAL ";
				PosRowSet nextSeqVO = getDao("mesdao").findByQueryStatement(nextSeqQr);
				nextSeqVO.reset();
				PosRow nextSeqRow = nextSeqVO.next(); 
				Number V_SET_SEQ = (Number)nextSeqRow.getAttribute("SET_SEQ");

			    PosParameter paramG = new PosParameter();
			    paramG.setValueParamter(0, V_SET_SEQ);
			    paramG.setValueParamter(1, V_ROLL_MANA_ST); 
			    paramG.setValueParamter(2, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
			    paramG.setValueParamter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN));    
			    int InsertG = getDao("mesdao").insert("NIF024060_L2SLABCOILCancel.insert",paramG);
			    
			    if (InsertG == 0) {
					
					V_TABLE_ID    =  "TBH06_L2_COIL_NO_INS";
					V_TABLE_MODE  =  "I";
					V_ERR_DESC    =  "TBH06_L2_COIL_NO_INS INSERT COUNT IS ZERO";
					V_RTN_NAME    =  "MILLLvlCan TBH06_L2_COIL_NO_INS INSERTG " + V_ROLL_MANA_NO;
					
					LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					throw new PosException(V_RTN_NAME);
				}
			}			    

		    if (P_TYPE.equals("R") || P_TYPE.equals("S") || P_TYPE.equals("M")) {
		    	//HCR --> MILL INSTRUCTION CANCEL CHECK CHARGE_MANA_NO FROM/TO
		    	PosParameter paramH = new PosParameter();
		    	paramH.setWhereClauseParameter(0, V_ROLL_MANA_ST); 
		    	paramH.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
		    	paramH.setWhereClauseParameter(2, V_ROLL_MANA_EN); 
		    	paramH.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
			    PosRowSet ChargeManaNoVO = getDao("mesdao").find("NIF024060_ChargeManaNo.select",paramH);
			    ChargeManaNoVO.reset();
			    
				while(ChargeManaNoVO.hasNext()) {
					
					PosRow ChargeManaNoRow  = ChargeManaNoVO.next();
					V_CHARGE_MANA_ST        = (String)ChargeManaNoRow.getAttribute("CHARGE_MANA_ST");
					V_CHARGE_MANA_EN        = (String)ChargeManaNoRow.getAttribute("CHARGE_MANA_EN");
					
				} //ChargeManaNoVO while END
				
				if (V_CHARGE_MANA_ST != "0") {
			    	//HCR --> MILL INSTRUCTION CANCEL TBF01_SPEC_SLAB(MILL_SLAB_EDT_SEQ --> 0, MILL_FL --> 'N')
					//CCM COMPLETE --> NO MODIFY
			    	PosParameter param3 = new PosParameter();
			    	param3.setWhereClauseParameter(0, V_ROLL_MANA_ST); 
			    	param3.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
			    	param3.setWhereClauseParameter(2, V_ROLL_MANA_EN); 
			    	param3.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
				    V_HCR_CNT = getDao("mesdao").update("NIF024060_HCRCancel.update",param3);
				    
			    	//HCR --> MILL INSTRUCTION CANCEL TBF01_SPEC_CHARGE(MILL_FL --> 'N')
				    //CHARGE COMPLETE --> NO MODIFY
			    	PosParameter paramS = new PosParameter();
			    	paramS.setWhereClauseParameter(0, V_CHARGE_MANA_ST); 
			    	paramS.setWhereClauseParameter(1, V_CHARGE_MANA_EN); 
				    getDao("mesdao").update("NIF024060_ChargeHCRCancel.update",paramS);
				} 
		    }
		    
		    if (P_TYPE.equals("R") || P_TYPE.equals("S") || P_TYPE.equals("C")) {
		    	
				//CCR --> SLAB MASTER TBG02_SLAB_COMM (PROG_CD, BEF_PROG_CD, HCR_CLF) 
		    	PosParameter param4 = new PosParameter();
		    	param4.setWhereClauseParameter(0, V_ROLL_MANA_ST); 
		    	param4.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
		    	param4.setWhereClauseParameter(2, V_ROLL_MANA_EN); 
		    	param4.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN));
			    V_CCR_CNT = getDao("mesdao").update("NIF024060_SlabMaster.update",param4);
			    
				//SELECT TBF02_SPEC_MILL ORDER_NO, ORD_SEQ
			    PosParameter param2 = new PosParameter();
			    param2.setWhereClauseParameter(0, V_ROLL_MANA_ST); 
			    param2.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
			    param2.setWhereClauseParameter(2, V_ROLL_MANA_EN); 
			    param2.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
			    PosRowSet MILLLvlCanVO = getDao("mesdao").find("NIF024060_MILLLvlCan.select",param2);
			    MILLLvlCanVO.reset();
			    
				while(MILLLvlCanVO.hasNext()) {
					
					PosRow MILLLvlCanRow  = MILLLvlCanVO.next();
					V_SLAB_NO       = (String)MILLLvlCanRow.getAttribute("SLAB_NO");
					V_ORD_NO        = (String)MILLLvlCanRow.getAttribute("ORD_NO");
					V_ORD_SEQ       = (String)MILLLvlCanRow.getAttribute("ORD_SEQ");
					V_SLAB_WGT      = Long.parseLong((MILLLvlCanRow.getAttribute("SLAB_WGT")==null? "0":MILLLvlCanRow.getAttribute("SLAB_WGT")).toString());
				
					//CALL NIE012070_
			    	NIE012070_CALL(V_ORD_NO, V_ORD_SEQ, V_SLAB_NO, V_SLAB_WGT, V_PGMID, P_REG_ID);
			    	
			    	++V_PRC_CNT;
				    	
				} //MILLLvlCanVO while END
				
		    }
			
			if (P_TYPE.equals("C")) {   //RHT-OUT INSTRUCTION MARKING "D" 

				//UPDATE TBF02_MILL_IDX (STATUS_CD = 'D')
		    	PosParameter paramI = new PosParameter();
		    	paramI.setWhereClauseParameter(0, V_ROLL_MANA_ST); 
		    	paramI.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
		    	paramI.setWhereClauseParameter(2, V_ROLL_MANA_EN); 
		    	paramI.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
			    int UpdCntI = getDao("mesdao").delete("NIF024060_MillIdx.update",paramI);
			    
			    if (UpdCntI == 0) {
					
					V_TABLE_ID    =  "TBF02_MILL_IDX";
					V_TABLE_MODE  =  "U";
					V_ERR_DESC    =  "TBF02_MILL_IDX STATUS_CD = 'D' UPDATE COUNT IS ZERO";
					V_RTN_NAME    =  "MILLLvlCan TBF02_MILL_IDX UpdCntI " + V_ROLL_MANA_ST;
					
					LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					throw new PosException(V_RTN_NAME);
				}
						    
			    //UPDATE TBF02_SPEC_MILL_D (STATUS_CD = 'D')
		    	PosParameter paramJ = new PosParameter();
		    	paramJ.setWhereClauseParameter(0, V_ROLL_MANA_ST); 
		    	paramJ.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
		    	paramJ.setWhereClauseParameter(2, V_ROLL_MANA_EN); 
		    	paramJ.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
		    	int UpdCntJ = getDao("mesdao").delete("NIF024060_SpecMillD.update",paramJ);
		    	
		    	if (UpdCntJ == 0) {
					
					V_TABLE_ID    =  "TBF02_SPEC_MILL_D";
					V_TABLE_MODE  =  "U";
					V_ERR_DESC    =  "TBF02_SPEC_MILL_D STATUS_CD = 'D' UPDATE COUNT IS ZERO";
					V_RTN_NAME    =  "MILLLvlCan TBF02_SPEC_MILL_D UpdCntJ " + V_ROLL_MANA_ST;
					
					LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					//throw new PosException(V_RTN_NAME);
				}
			    
			    //UPDATE TBF02_SPEC_MILL (STATUS_CD = 'D')
		    	PosParameter paramK = new PosParameter();
		    	paramK.setWhereClauseParameter(0, V_ROLL_MANA_ST); 
		    	paramK.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
		    	paramK.setWhereClauseParameter(2, V_ROLL_MANA_EN); 
		    	paramK.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
		    	int UpdCntK = getDao("mesdao").delete("NIF024060_SpecMill.update",paramK);
		    	
		    	if (UpdCntK == 0) {
					
					V_TABLE_ID    =  "TBF02_SPEC_MILL";
					V_TABLE_MODE  =  "U";
					V_ERR_DESC    =  "TBF02_SPEC_MILL STATUS_CD = 'D' UPDATE COUNT IS ZERO";
					V_RTN_NAME    =  "MILLLvlCan TBF02_SPEC_MILL UpdCntK " + V_ROLL_MANA_ST;
					
					LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					//throw new PosException(V_RTN_NAME);
				}
		    	
			} else {   //INSTRUCTION DELETE

				//DELETE TBF02_MILL_IDX
		    	PosParameter param5 = new PosParameter();
		    	param5.setWhereClauseParameter(0, V_ROLL_MANA_ST); 
		    	param5.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
		    	param5.setWhereClauseParameter(2, V_ROLL_MANA_EN); 
		    	param5.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
			    int DelCnt5 = getDao("mesdao").delete("NIF024060_MillIdx.delete",param5);
			    
			    if (DelCnt5 == 0) {
					
					V_TABLE_ID    =  "TBF02_MILL_IDX";
					V_TABLE_MODE  =  "D";
					V_ERR_DESC    =  "TBF02_MILL_IDX UPDATE COUNT IS ZERO";
					V_RTN_NAME    =  "MILLLvlCan TBF02_MILL_IDX DELETE5 " + V_ROLL_MANA_ST;
					
					LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					throw new PosException(V_RTN_NAME);
				}
			
			    //DELETE TBF02_SPEC_MILL_DET
		    	PosParameter param6 = new PosParameter();
		    	param6.setWhereClauseParameter(0, V_ROLL_MANA_ST); 
		    	param6.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
		    	param6.setWhereClauseParameter(2, V_ROLL_MANA_EN); 
		    	param6.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
			    int DelCnt6 = getDao("mesdao").delete("NIF024060_SpecMillDet.delete",param6);
			    
			    if (DelCnt6 == 0) {
					
					V_TABLE_ID    =  "TBF02_SPEC_MILL_DET";
					V_TABLE_MODE  =  "D";
					V_ERR_DESC    =  "TBF02_SPEC_MILL_DET UPDATE COUNT IS ZERO";
					V_RTN_NAME    =  "MILLLvlCan TBF02_SPEC_MILL_DET DELETE6 " + V_ROLL_MANA_ST;
					
					LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					//throw new PosException(V_RTN_NAME);
				}
			    
			    //DELETE TBF02_SPEC_MILL_D
		    	PosParameter param7 = new PosParameter();
		    	param7.setWhereClauseParameter(0, V_ROLL_MANA_ST); 
		    	param7.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
		    	param7.setWhereClauseParameter(2, V_ROLL_MANA_EN); 
		    	param7.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
		    	int DelCnt7 = getDao("mesdao").delete("NIF024060_SpecMillD.delete",param7);
		    	
		    	if (DelCnt7 == 0) {
					
					V_TABLE_ID    =  "TBF02_SPEC_MILL_D";
					V_TABLE_MODE  =  "D";
					V_ERR_DESC    =  "TBF02_SPEC_MILL_D UPDATE COUNT IS ZERO";
					V_RTN_NAME    =  "MILLLvlCan TBF02_SPEC_MILL_D DELETE7 " + V_ROLL_MANA_ST;
					
					LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					//throw new PosException(V_RTN_NAME);
				}
			    
			    //DELETE TBF02_SPEC_MILL
		    	PosParameter param8 = new PosParameter();
		    	param8.setWhereClauseParameter(0, V_ROLL_MANA_ST); 
		    	param8.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_SEQ_ST)); 
		    	param8.setWhereClauseParameter(2, V_ROLL_MANA_EN); 
		    	param8.setWhereClauseParameter(3, String.valueOf(V_ROLL_SLAB_SEQ_EN)); 
		    	int DelCnt8 = getDao("mesdao").delete("NIF024060_SpecMill.delete",param8);
		    	
		    	if (DelCnt8 == 0) {
					
					V_TABLE_ID    =  "TBF02_SPEC_MILL";
					V_TABLE_MODE  =  "D";
					V_ERR_DESC    =  "TBF02_SPEC_MILL UPDATE COUNT IS ZERO";
					V_RTN_NAME    =  "MILLLvlCan TBF02_SPEC_MILL DELETE8 " + V_ROLL_MANA_ST;
					
					LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					//throw new PosException(V_RTN_NAME);
				}				
				
			}
			
	    	//PROESS COUNT != 0
			if ((V_HCR_CNT + V_CCR_CNT) != 0) {
				
				//SELECT TBF02_SPEC_MILL LEVEL2 CANCEL
			    PosParameter param9 = new PosParameter();
			    param9.setWhereClauseParameter(0, V_ROLL_MANA_ST);  
			    param9.setWhereClauseParameter(1, V_ROLL_MANA_EN);  
			    PosRowSet RollManaNoVO = getDao("mesdao").find("NIF024060_RollManaNo.select",param9);
			    RollManaNoVO.reset();
			    
				while(RollManaNoVO.hasNext()) {
					
					PosRow RollManaNoRow  = RollManaNoVO.next();
					V_ROLL_MANA_NO  = (String)RollManaNoRow.getAttribute("ROLL_MANA_NO");
					V_ROLL_SLAB_CNT = Long.parseLong((RollManaNoRow.getAttribute("ROLL_SLAB_CNT")==null? "0":RollManaNoRow.getAttribute("ROLL_SLAB_CNT")).toString());
					V_ROLL_SLAB_WGT = Long.parseLong((RollManaNoRow.getAttribute("ROLL_SLAB_WGT")==null? "0":RollManaNoRow.getAttribute("ROLL_SLAB_WGT")).toString());
					V_HCR_CNT       = Long.parseLong((RollManaNoRow.getAttribute("HCR_CNT")==null? "0":RollManaNoRow.getAttribute("HCR_CNT")).toString());
					V_MILL_LEN      = Long.parseLong((RollManaNoRow.getAttribute("MILL_LEN")==null? "0":RollManaNoRow.getAttribute("MILL_LEN")).toString());
					V_SPM_CNT       = Long.parseLong((RollManaNoRow.getAttribute("SPM_CNT")==null? "0":RollManaNoRow.getAttribute("SPM_CNT")).toString());
					
					if (V_HCR_CNT == 0){
						
						V_HCR_CLF = "C";
						
					} else {
						
						V_HCR_CLF = "H";
						
					}
					
					//TBF02_SPEC_ROLL RE-ARRANGE UPDATE
					PosParameter paramR = new PosParameter();
					paramR.setWhereClauseParameter(0, String.valueOf(V_ROLL_SLAB_CNT));
					paramR.setWhereClauseParameter(1, String.valueOf(V_ROLL_SLAB_WGT));
					paramR.setWhereClauseParameter(2, String.valueOf(V_HCR_CLF));
					paramR.setWhereClauseParameter(3, String.valueOf(V_MILL_LEN));
					paramR.setWhereClauseParameter(4, String.valueOf(V_SPM_CNT));
					paramR.setWhereClauseParameter(5, V_ROLL_MANA_NO);
				    int UpdCntR = getDao("mesdao").update("NIF024060_SpecRoll.update",paramR);
				    
				    if (UpdCntR == 0) {
						
						V_TABLE_ID    =  "TBF02_SPEC_ROLL";
						V_TABLE_MODE  =  "U";
						V_ERR_DESC    =  "TBF02_SPEC_ROLL UPDATE COUNT IS ZERO";
						V_RTN_NAME    =  "MILLLvlCan TBF02_SPEC_ROLL UPDATER " + V_ROLL_MANA_NO;
						
						LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
						//throw new PosException(V_RTN_NAME);
					}
				     
				    if (V_ROLL_SLAB_CNT == 0) {
				    	
				    	V_SEND_CLF = "3";    //SEND_CLF = DELETE
				    	
				    } else {
				    	
				    	V_SEND_CLF = "2";    //SEND_CLF = UPDATE
				    	
				    }
				    	
				    //TBH06_L2_ROLL_UNIT_INS CANCEL PROCESS
					PosParameter paramQ = new PosParameter();
					paramQ.setValueParamter(0, V_SEND_CLF);
					paramQ.setValueParamter(1, V_ROLL_MANA_NO);
					int InsertQ = getDao("mesdao").insert("NIF024060_L2ROLLCancel.insert",paramQ);
				    
				    if (InsertQ == 0) {
						
						V_TABLE_ID    =  "TBH06_L2_ROLL_UNIT_INS";
						V_TABLE_MODE  =  "I";
						V_ERR_DESC    =  "TBH06_L2_ROLL_UNIT_INS INSERT COUNT IS ZERO";
						V_RTN_NAME    =  "MILLLvlCan TBH06_L2_ROLL_UNIT_INS INSERTQ " + V_ROLL_MANA_NO;
						
						LogGpError.logMessageToDB("MILLLvlCan", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
						//throw new PosException(V_RTN_NAME);
					}
				
				} //RollManaNoVO while END
				
				//TBF02_SPEC_ROLL RE-ARRANGE (ROLL_SLAB_CNT = 0 DELETE)
				getDao("mesdao").delete("NIF024060_SpecRollDel.delete");
								
				if (V_PRC_CNT != 0) {
					//CALL NIE012080_
					NIE012080_CALL();
				}
		    	
			} //END if V_PRC_CNT != 0
			
//		}
//	    catch (PosException ex)
//	    {
//	    	context.put(SERVICE_ERR_MSG, ex.getMessage());
//	    	throw ex;
//	    } 
//	    catch (Throwable t)
//	    {
//	    	context.put(SERVICE_ERR_MSG, t.getMessage());
//	    	throw new PosException(t.getMessage(), t);
//	    }
		
		return PosBizControlConstants.SUCCESS;
		
	}
	
	public PosContext NIE012070_CALL(String V_ORD_NO, String V_ORD_SEQ, String V_SLAB_NO, long V_SLAB_WGT, String V_PGMID, String V_REG_ID)
	{
		PosContext context = new PosContext();
		PosMessage message = new PosMESMessageImpl();
		
		//
		String TcId = "NIE012070";
		message.setTCID(TcId);
		message.setObject("MSG_ID",      TcId);
		message.setObject("BEF_ORD_NO",  "");
		message.setObject("BEF_ORD_SEQ", ""); 
		message.setObject("ORD_NO",      V_ORD_NO);
		message.setObject("ORD_SEQ",     V_ORD_SEQ);
		message.setObject("BEF_PROG_CD", "RBB"); 
		message.setObject("PROG_CD",     "RBA");
		message.setObject("MAT_TYPE",    "TM");
		message.setObject("MAT_NO",      V_SLAB_NO); 
		message.setObject("WGT",         new BigDecimal(V_SLAB_WGT));
		message.setObject("PGMID",       V_PGMID); 
		message.setObject("REG_ID",      V_REG_ID); 
		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;  
	}

	public void updMillHCR(String p_type,String p_st ,String p_en) {
		
		String p_sql_id = "";
		PosParameter p_param =  new PosParameter();
		
		p_sql_id = (p_type.equals("S")) ? "NIF024060_SLAB_HCR.UPDATE" : "NIF024060_ROLL_HCR.UPDATE";
		p_param.setWhereClauseParameter(0, p_st);
		p_param.setWhereClauseParameter(1, p_en);
		
		this.getDao("mesdao").update(p_sql_id, p_param);
		
	}
	
	public PosContext NIE012080_CALL()
	{
		PosContext context = new PosContext();
		PosMessage message = new PosMESMessageImpl();
		
		//
		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; 
	}

}