XinYu_RZMES/.svn/pristine/f6/f62e504bd10f0d7a0c6e9349d2dae20931e0239a.svn-base

package xin.glue.nui.F.F02;

import xin.glue.user.common.GlobalConstants;
import xin.glue.user.common.LogGpError;
import xin.glue.user.common.StringUtils;
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;
import com.posdata.glue.msg.PosMessage;

//import java.lang.Long;

/* Program Name  MILLRollSeqChange (NIF024030)
 * Description   MILL WORK INSTRUCTION CHANGING ROLL SEQUENCE 
 * Write By      KIM SUNG HO 
 * Date          2008-11-14
 */
/************************************************************************/
/* CLASS             MILLRollSeqChange            Author: KIM SUNG HO   */
/************************************************************************/
/* DESCRIPTION   轧制顺序调整                                                    */
/************************************************************************/
/* UPD_TIME  | WHO       | PROGRAM                                    | CONTTENT
/* 090613     SUNJIAWANG                 添加注释
/* 090613     SUNJIAWANG  NIF024030_MILLStatusChk.select               增加对入炉辊道的处理
/* 090613     SUNJIAWANG  NIF024030_MILLStatusChk.select               add slab_stat
/* 090815	  SUNJIAWANG  moveAble                                     轧辊单元不能够移动正在进行的轧辊之间
/************************************************************************/
public class MILLRollSeqChange extends PosActivity implements GlobalConstants {


	/**
	 * 轧制顺序调整【M】
	 * 检查操作对象位置
	 * 检查移动对象中是否有进行的对象和已上料的板坯
	 * 检查操作对象 头尾轧辊 头尾板坯是否存在
	 * 进行轧辊位置移动跟换 使用临时表 TBF02_CHG_ROLL 
	 * 指示更新 TBH06_ROLL_INS TBH06_RHT_INS TBH06_MILL_INS TBH06_COIL_NO_INS
	 * 更新TBF02_CHG_ROLL的状态
	 * 更新 TBF02_SPEC_ROLL TBF02_SPEC_MILL TBF02_MILL_IDX 的FL
	 * !!! add function move hcr 热装HCR 不需要检查顺序 热送HCR 移动时需要检查顺序
	 */
	
	String P_ROLL_MANA_ST  = "";
	String P_ROLL_MANA_EN  = "";
	String P_ROLL_MANA_TG  = "";
	String P_POS           = "";
	
	public String runActivity(PosContext context) {

		long V_MOV_STATUS_CNT      = 0 ; 
		long V_MOV_COIL_STAT_CNT   = 0;
		long V_MOV_SLAB_STAT_CNT   = 0;	  //已切割形成的板坯
		long V_TAG_STATUS_CNT      = 0 ;
		long V_MOV_HCR_CNT         = 0 ;
		long V_TAG_HCR_CNT         = 0 ;
		long V_TAG_COIL_STAT_CNT   = 0;
		long V_TAG_HCR_SLAB_STAT_CNT = 0;
		long V_ORG_SEQ             = 0 ;
		long V_CHG_SEQ             = 0 ;
		long V_SEQ_ST              = 0 ;
		long V_SEQ_EN              = 0 ;
		long V_SEQ_TG              = 0 ;
		long V_SHIFT_CNT           = 0 ;
		long V_MOVE_CNT            = 0 ;
		long V_SHIFT_FR_SEQ        = 0 ;
		long V_SHIFT_TO_SEQ        = 0 ;
				
		String V_ROLL_MANA_NO      = "" ;
		String V_ROLL_MANA_IC      = "" ;
		String V_BEF_ROLL_MANA_NO  = "" ;
		String V_CHG_ROLL_MANA_NO  = "" ;
		String V_ROLL_MANA_ST      = "" ;
		String V_ROLL_MANA_EN      = "" ;
		String V_BEF_ROLL_MANA_ST  = "" ;
		String V_BEF_ROLL_MANA_EN  = "" ;
		String V_AFT_ROLL_MANA_ST  = "" ;
		String V_AFT_ROLL_MANA_EN  = "" ;
		String V_BEF_SLAB_NO_ST    = "" ;
		String V_BEF_SLAB_NO_EN    = "" ;
		String V_AFT_SLAB_NO_ST    = "" ;
		String V_AFT_SLAB_NO_EN    = "" ;
		String V_CHG_FL            = "" ;
		
		String V_TABLE_ID          = "" ;
		String V_TABLE_MODE        = "" ;
		String V_ERR_DESC          = "" ; 
		String V_RTN_NAME          = "" ;
	
		PosMessage message = context.getMessage();	
		
		//ROLL_MANA_NO FROM/TO/TARGET
		P_ROLL_MANA_ST  = (String)message.get("FROM");
		P_ROLL_MANA_EN  = (String)message.get("TO");
		P_ROLL_MANA_TG  = (String)message.get("TARGET");
		P_POS           = (String)message.get("POS");
		
//		try {    		
							
			if (P_ROLL_MANA_ST.compareTo(P_ROLL_MANA_EN) > 0) {
				
				//P_MODE PARAMETER ERROR MESSAGE
				throw new PosException("MILLRollSeqChange..ROLL_MANA_ST > ROLL_MANA_EN..");
				
			} else if (P_ROLL_MANA_ST.compareTo(P_ROLL_MANA_TG) < 0 && P_ROLL_MANA_EN.compareTo(P_ROLL_MANA_TG) > 0) {
				
				//P_MODE PARAMETER ERROR MESSAGE
				throw new PosException("MILLRollSeqChange..ROLL_MANA_ST < ROLL_MANA_TG < ROLL_MANA_EN..");
				
			} else if (P_ROLL_MANA_ST.equals(P_ROLL_MANA_TG) && P_POS.equals("A")) {
				
				//P_MODE PARAMETER ERROR MESSAGE
				throw new PosException("MILLRollSeqChange..ROLL_MANA_ST = ROLL_MANA_TG, P_POS IS 'A'..");
				
			} else if (P_ROLL_MANA_ST.equals(P_ROLL_MANA_TG) && P_POS.equals("B")) {
				
				//PROGRAM EXIT (SAME WORK)
				throw new PosException("MILLRollSeqChange..ROLL_MANA_ST = ROLL_MANA_TG, P_POS IS 'B'..");

			} else if (P_ROLL_MANA_EN.equals(P_ROLL_MANA_TG) && P_POS.equals("A")) {
				
				//PROGRAM EXIT (SAME WORK)
				throw new PosException("MILLRollSeqChange..ROLL_MANA_EN = ROLL_MANA_TG, P_POS IS 'A'..");

			} else if (P_ROLL_MANA_EN.equals(P_ROLL_MANA_TG) && P_POS.equals("B")) {
				
				//P_MODE PARAMETER ERROR MESSAGE
				throw new PosException("MILLRollSeqChange..ROLL_MANA_EN = ROLL_MANA_TG, P_POS IS 'B'..");
				
			}
			
			//---------------------------------------------------------------------------------
			//MOVE, TARGET ROLL HCR_CLF = 'H', STATUS_CD = 'B' CHECK 
		    PosParameter param1 = new PosParameter();
		    param1.setWhereClauseParameter(0, P_ROLL_MANA_ST);  
		    param1.setWhereClauseParameter(1, P_ROLL_MANA_EN);  
		    PosRowSet MILLStatusChkVO = getDao("mesdao").find("NIF024030_MILLStatusChk.select",param1);
		    MILLStatusChkVO.reset();
			
		    if (MILLStatusChkVO.hasNext()) {
				
				PosRow MILLStatusChkRow  = MILLStatusChkVO.next();
				//移动对象中的STATUS个数 
				V_MOV_STATUS_CNT  = Long.parseLong((MILLStatusChkRow.getAttribute("STATUS_CNT")==null? "0":MILLStatusChkRow.getAttribute("STATUS_CNT")).toString());
				//移动对象中的HCR个数
				V_MOV_HCR_CNT     = Long.parseLong((MILLStatusChkRow.getAttribute("HCR_CNT")==null? "0":MILLStatusChkRow.getAttribute("HCR_CNT")).toString());
				//移动对象中的已上料板坯的个数
				V_MOV_COIL_STAT_CNT     = Long.parseLong((MILLStatusChkRow.getAttribute("COIL_STAT_CNT")==null? "0":MILLStatusChkRow.getAttribute("COIL_STAT_CNT")).toString());
//				//移动对象中的虚拟HCR板坯的个数
				V_MOV_SLAB_STAT_CNT     = Long.parseLong((MILLStatusChkRow.getAttribute("SLAB_STAT_CNT")==null? "0":MILLStatusChkRow.getAttribute("SLAB_STAT_CNT")).toString());
			} else {
				
				V_MOV_STATUS_CNT    = 0;
				V_MOV_HCR_CNT       = 0;
				V_MOV_COIL_STAT_CNT = 0;
				V_MOV_SLAB_STAT_CNT = 0;
			}
		  
		    if (V_MOV_STATUS_CNT != 0){ //移动对象中含有轧制进行的板坯
				
				//MESSAGE ERROR --> PROGRAM EXIT
		    	throw new PosException("MILLRollSeqChange..STATUS_CD = 'B'..");	
		    	//throw new PosException("移动对象已处于轧制进行中");	
		    	
			}
		    if (V_MOV_COIL_STAT_CNT != 0){ //移动对象中含有轧制进行的板坯
				
				//MESSAGE ERROR --> PROGRAM EXIT
		    	//throw new PosException("MILLRollSeqChange..STATUS_CD = 'B'..");	
		    	throw new PosException("移动对象已处于上料！");	
		    	
			}
		    
		    if (P_ROLL_MANA_ST.compareTo(P_ROLL_MANA_TG) > 0){
			    this.moveAble(P_POS, P_ROLL_MANA_EN, P_ROLL_MANA_TG);
		    }

		    
/*************************************************************************************************************************/				    
/**
 * 处理含有HCR的移动对象
 */
		    //MOVE ROLL IN HCR_CNT <> 0
		    //移动对象含有虚拟HCR 
		    if (V_MOV_HCR_CNT != 0 && V_MOV_SLAB_STAT_CNT != 0){
		    	
		    	//AFTER MOVE ROLL START/END
		    	//移动对象位置在目标对象前 对象前移
		    	if (P_ROLL_MANA_ST.compareTo(P_ROLL_MANA_TG) > 0) {
					
		    		//BEFORE TARGET
		    		if (P_POS.equals("B")) {
					
		    			V_ROLL_MANA_ST = P_ROLL_MANA_TG;
					
		    		} else {
		    			
		    			PosParameter param2 = new PosParameter();
						param2.setWhereClauseParameter(0, P_ROLL_MANA_TG);
					    PosRowSet RollManaNoAftVO = getDao("mesdao").find("NIF024030_RollManaNoAft.select",param2);
					    RollManaNoAftVO.reset();
					    
						if (RollManaNoAftVO.hasNext()) {
							
							PosRow RollManaNoAftRow  = RollManaNoAftVO.next();
							V_ROLL_MANA_ST = (String)RollManaNoAftRow.getAttribute("ROLL_MANA_NO");
							
						} else {
							
							V_ROLL_MANA_ST = "";
							
						}		
		    			
		    		}
		    		
					PosParameter param3 = new PosParameter();
					param3.setWhereClauseParameter(0, P_ROLL_MANA_ST);
				    PosRowSet RollManaNoAftVO = getDao("mesdao").find("NIF024030_RollManaNoBef.select",param3);
				    RollManaNoAftVO.reset();
				    
					if (RollManaNoAftVO.hasNext()) {
						
						PosRow RollManaNoAftRow  = RollManaNoAftVO.next();
						V_ROLL_MANA_EN = (String)RollManaNoAftRow.getAttribute("ROLL_MANA_NO");
						
					} else {
						
						V_ROLL_MANA_EN = "";
						
					}						
		    	
		    	} else if (P_ROLL_MANA_EN.compareTo(P_ROLL_MANA_TG) < 0 ) { //对象后移
		    		
		    		//AFTER TARGET
		    		if (P_POS.equals("A")) {
						
		    			V_ROLL_MANA_EN = P_ROLL_MANA_TG;
					
		    		} else {
		    			
		    			PosParameter param4 = new PosParameter();
		    			param4.setWhereClauseParameter(0, P_ROLL_MANA_TG);
					    PosRowSet RollManaNoAftVO = getDao("mesdao").find("NIF024030_RollManaNoBef.select",param4);
					    RollManaNoAftVO.reset();
					    
						if (RollManaNoAftVO.hasNext()) {
							
							PosRow RollManaNoAftRow  = RollManaNoAftVO.next();
							V_ROLL_MANA_EN = (String)RollManaNoAftRow.getAttribute("ROLL_MANA_NO");
							
						} else {
							
							V_ROLL_MANA_EN = "";
							
						}		
		    		}
		    		
					PosParameter param5 = new PosParameter();
					param5.setWhereClauseParameter(0, P_ROLL_MANA_EN);
				    PosRowSet RollManaNoAftVO = getDao("mesdao").find("NIF024030_RollManaNoAft.select",param5);
				    RollManaNoAftVO.reset();
				    
					if (RollManaNoAftVO.hasNext()) {
						
						PosRow RollManaNoAftRow  = RollManaNoAftVO.next();
						V_ROLL_MANA_ST = (String)RollManaNoAftRow.getAttribute("ROLL_MANA_NO");
						
					} else {
						
						V_ROLL_MANA_ST = "";
						
					}
		    	}
		    	
			    PosParameter param6 = new PosParameter();
			    param6.setWhereClauseParameter(0, V_ROLL_MANA_ST);  
			    param6.setWhereClauseParameter(1, V_ROLL_MANA_EN);  
			    PosRowSet MILLStatusChkTgVO = getDao("mesdao").find("NIF024030_MILLStatusChk.select",param6);
			    MILLStatusChkTgVO.reset();
				
			    if (MILLStatusChkTgVO.hasNext()) {
					
					PosRow MILLStatusChkTgRow  = MILLStatusChkTgVO.next();
					V_TAG_STATUS_CNT  = Long.parseLong((MILLStatusChkTgRow.getAttribute("STATUS_CNT")==null? "0":MILLStatusChkTgRow.getAttribute("STATUS_CNT")).toString());
					V_TAG_HCR_CNT     = Long.parseLong((MILLStatusChkTgRow.getAttribute("HCR_CNT")==null? "0":MILLStatusChkTgRow.getAttribute("HCR_CNT")).toString());
					V_TAG_COIL_STAT_CNT     = Long.parseLong((MILLStatusChkTgRow.getAttribute("COIL_STAT_CNT")==null? "0":MILLStatusChkTgRow.getAttribute("COIL_STAT_CNT")).toString());
					V_TAG_HCR_SLAB_STAT_CNT     = Long.parseLong((MILLStatusChkTgRow.getAttribute("SLAB_STAT_CNT")==null? "0":MILLStatusChkTgRow.getAttribute("COIL_STAT_CNT")).toString());
				} else {
					
					V_TAG_STATUS_CNT = 0;
					V_TAG_HCR_CNT    = 0;
					V_TAG_HCR_SLAB_STAT_CNT =0;
					
				}
			    //comment by sunjiawang 090625
			    if (V_TAG_STATUS_CNT != 0 ){
					
					//MESSAGE ERROR --> PROGRAM EXIT
			    	throw new PosException("MILLRollSeqChange..STATUS_CD = 'B' 不能够移动到已轧制进行板坯前");	
			    	
				}
			    
			    if ( V_TAG_COIL_STAT_CNT != 0){
					
					//MESSAGE ERROR --> PROGRAM EXIT
			    	throw new PosException("MILLRollSeqChange..COIL_STAT_CNT = '0' 不能移动到已上料板坯前..");	
			    	
				}
			    //comment by sunjiawang 090625
//			    if (V_TAG_HCR_SLAB_STAT_CNT == 0 && V_TAG_HCR_CNT != 0 ){
//					
//					//MESSAGE ERROR --> PROGRAM EXIT
//			    	throw new PosException(" MILLRollSeqChange.. V_TAG_HCR_SLAB_STAT_CNT == 0 && V_TAG_HCR_CNT != 0 虚拟HCR不能够移动到已切割HCR之前..");	
//			    	
//				}
//			    //移动对象中含有虚拟的HCR 后移有已切割的HCR  ADD BY SUNJIAWANG  090625
//			    if (V_MOV_HCR_CNT > 0 && V_MOV_SLAB_STAT_CNT == 0 && V_TAG_HCR_SLAB_STAT_CNT != 0  && P_POS =="A"){
//					
//					//MESSAGE ERROR --> PROGRAM EXIT
//			    	throw new PosException(" MILLRollSeqChange.. V_TAG_HCR_SLAB_STAT_CNT == 0 && V_TAG_HCR_CNT != 0 虚拟HCR不能够移动到已切割HCR之前..");	
//			    	
//				}


		    } //IF V_MOV_HCR_CNT != 0 END
/*************************************************************************************************************************/			
		    else {
			    //取消HCR移动的限制
			    if ( V_TAG_STATUS_CNT != 0 || V_TAG_COIL_STAT_CNT != 0){
					
					//MESSAGE ERROR --> PROGRAM EXIT
			    	throw new PosException("MILLRollSeqChange..STATUS_CD = 'B' OR V_TAG_COIL_STAT_CNT = 0..");	
			    	
				}
		    } //add by sunjiwang 090625 
		    
		    
			//---------------------------------------------------------------------------------
			//BEFORE MOVE ROLL FIRST SLAB_NO, LAST SLAB_NO SELECT 
		    //移动对象在目标位置后  ： 移动对象前移
			if (P_ROLL_MANA_ST.compareTo(P_ROLL_MANA_TG) > 0) {
				
				V_BEF_ROLL_MANA_EN = P_ROLL_MANA_EN;
				
				//ROLL_MANA_TG BEFORE/AFTER ROLL_MANA_NO SELECT
				if (P_POS.equals("B")) { 
				    
					V_BEF_ROLL_MANA_ST = P_ROLL_MANA_TG;
				
				} else {
					
					PosParameter param7 = new PosParameter();
					param7.setWhereClauseParameter(0, P_ROLL_MANA_TG);
				    PosRowSet RollManaNoAftVO = getDao("mesdao").find("NIF024030_RollManaNoAft.select",param7);
				    RollManaNoAftVO.reset();
				    
					if (RollManaNoAftVO.hasNext()) {
						
						PosRow RollManaNoAftRow  = RollManaNoAftVO.next();
						V_BEF_ROLL_MANA_ST = (String)RollManaNoAftRow.getAttribute("ROLL_MANA_NO");
						
					} else {
						
						V_BEF_ROLL_MANA_ST = "";
						
					}
				}
				
			} //end (P_ROLL_MANA_ST.compareTo(P_ROLL_MANA_TG) > 0)  移动对象在目标位置后  ： 移动对象前移
			else if (P_ROLL_MANA_EN.compareTo(P_ROLL_MANA_TG) < 0 ) //移动对象在目标对象前 ：移动对象后移
			  { 
				
				V_BEF_ROLL_MANA_ST = P_ROLL_MANA_ST;
				
				//LAST ROLL_MANA_NO
			    PosRowSet LastRollManaNoVO = getDao("mesdao").find("NIF024030_LastRollManaNo.select");
			    LastRollManaNoVO.reset();
			    
			    if (LastRollManaNoVO.hasNext()) {
			    	
					PosRow LastRollManaNoRow  = LastRollManaNoVO.next();
					V_BEF_ROLL_MANA_EN = (String)LastRollManaNoRow.getAttribute("ROLL_MANA_NO");
					
				} else {
					
					V_BEF_ROLL_MANA_EN = "";
					
				}											
			}//end  (P_ROLL_MANA_EN.compareTo(P_ROLL_MANA_TG) < 0 ) 移动对象在目标对象前 ：移动对象后移
			
			if (V_BEF_ROLL_MANA_ST == "" || V_BEF_ROLL_MANA_EN == ""){
				
				//MESSAGE ERROR --> PROGRAM EXIT
				throw new PosException("MILLRollSeqChange..BEF_ROLL_MANA ST/EN IS NULL..");				
			}

			//BEFORE CHANGE ROLL START/END SLAB_NO CHECK 
		    PosParameter param8 = new PosParameter();
		    param8.setWhereClauseParameter(0, V_BEF_ROLL_MANA_ST);
		    param8.setWhereClauseParameter(1, V_BEF_ROLL_MANA_ST); 
		    param8.setWhereClauseParameter(2, V_BEF_ROLL_MANA_EN);
		    param8.setWhereClauseParameter(3, V_BEF_ROLL_MANA_EN); 
		    PosRowSet RollSlabSeqVO = getDao("mesdao").find("NIF024030_SlabNoFind.select",param8);
		    RollSlabSeqVO.reset();
		    //查找所有的移动板坯
			if (RollSlabSeqVO.hasNext()) {
				
				PosRow RollSlabSeqRow  = RollSlabSeqVO.next();
				V_BEF_SLAB_NO_ST  = (String)RollSlabSeqRow.getAttribute("SLAB_NO_ST");
				V_BEF_SLAB_NO_EN  = (String)RollSlabSeqRow.getAttribute("SLAB_NO_EN");
			
			} else {
				
				V_BEF_SLAB_NO_ST  = "";
				V_BEF_SLAB_NO_EN  = "";
				
			}//对移动的头尾板坯赋值
			
    		//没有可操作的对象
			if (V_BEF_SLAB_NO_ST == "" || V_BEF_SLAB_NO_EN == ""){
				
				//MESSAGE ERROR --> PROGRAM EXIT
			//	throw new PosException("MILLRollSeqChange..BEF_SLAB_NO ST/EN IS NULL..");
				throw new PosException("没有可操作的对象 MILLRollSeqChange..BEF_SLAB_NO ST/EN IS NULL..");				
			} //end 没有可操作的对象
			
		 	//--------------------------------------------------------------------------------------
		 	//AFTER MOVE ROLL FIRST SLAB_NO, LAST SLAB_NO SELECT 
			//对象前移
		 	if (P_ROLL_MANA_ST.compareTo(P_ROLL_MANA_TG) > 0) 
		 	{
				
		 		V_AFT_ROLL_MANA_ST = P_ROLL_MANA_ST;
		 		
				PosParameter param9 = new PosParameter();
				param9.setWhereClauseParameter(0, P_ROLL_MANA_ST);
			    PosRowSet RollManaNoBefVO = getDao("mesdao").find("NIF024030_RollManaNoBef.select",param9);
			    RollManaNoBefVO.reset();
			    
				if (RollManaNoBefVO.hasNext()) {
					
					PosRow RollManaNoBefRow  = RollManaNoBefVO.next();
					V_AFT_ROLL_MANA_EN = (String)RollManaNoBefRow.getAttribute("ROLL_MANA_NO");
					
				} else {
					
					V_AFT_ROLL_MANA_EN = "";
					
				}
   			 	
			} //end 对象前移
		 	
		 	//对象后移
		 	else if (P_ROLL_MANA_EN.compareTo(P_ROLL_MANA_TG) < 0 ) 
		 	{
				
				PosParameter param10 = new PosParameter();
				param10.setWhereClauseParameter(0, P_ROLL_MANA_EN);
			    PosRowSet RollManaNoAftVO = getDao("mesdao").find("NIF024030_RollManaNoAft.select",param10);
			    RollManaNoAftVO.reset();
			    
			    //获取最小轧辊单元 赋值 V_AFT_ROLL_MANA_ST 
				if (RollManaNoAftVO.hasNext()) {
					
					PosRow RollManaNoAftRow  = RollManaNoAftVO.next();
					V_AFT_ROLL_MANA_ST = (String)RollManaNoAftRow.getAttribute("ROLL_MANA_NO");
				
				} else {
					
					V_AFT_ROLL_MANA_ST = "";
					
				}//end
				
				//LAST ROLL_MANA_NO
			    PosRowSet LastRollManaNoVO = getDao("mesdao").find("NIF024030_LastRollManaNo.select");
			    LastRollManaNoVO.reset();
			    
			    //获取最大轧辊单元 赋值 V_AFT_ROLL_MANA_EN 
			    if (LastRollManaNoVO.hasNext()) {
			    	
					PosRow LastRollManaNoRow  = LastRollManaNoVO.next();
					V_AFT_ROLL_MANA_EN = (String)LastRollManaNoRow.getAttribute("ROLL_MANA_NO");
				
			    } else {
					
					V_AFT_ROLL_MANA_EN = "";
					
				}//end										

			    if (P_POS.equals("A") && V_AFT_ROLL_MANA_EN.equals(P_ROLL_MANA_TG)) {
			    	
			    	V_AFT_ROLL_MANA_EN = P_ROLL_MANA_EN;
			    	
			    }
			}//end 对象后移
			
		 	//没有可以操作的对象
			if (V_AFT_ROLL_MANA_ST == "" || V_AFT_ROLL_MANA_EN == ""){
				
				//MESSAGE ERROR --> PROGRAM EXIT
				//throw new PosException("MILLRollSeqChange..AFT_ROLL_MANA ST/EN IS NULL..");	
				throw new PosException("没有可操作的对象 MILLRollSeqChange..AFT_ROLL_MANA ST/EN IS NULL..");	
				
			}//end 没有可以操作的对象

			//MOVE AFTER CHANGE ROLL START/END SLAB_NO CHECK 
			//获取移动之前的头尾板坯
		    PosParameter param11 = new PosParameter();
		    param11.setWhereClauseParameter(0, V_AFT_ROLL_MANA_ST);
		    param11.setWhereClauseParameter(1, V_AFT_ROLL_MANA_ST); 
		    param11.setWhereClauseParameter(2, V_AFT_ROLL_MANA_EN);
		    param11.setWhereClauseParameter(3, V_AFT_ROLL_MANA_EN); 
		    PosRowSet RollSlabSeqAftVO = getDao("mesdao").find("NIF024030_SlabNoFind.select",param11);
		    RollSlabSeqAftVO.reset();
		    
			if (RollSlabSeqAftVO.hasNext()) {
				
				PosRow RollSlabSeqAftRow  = RollSlabSeqAftVO.next();
				V_AFT_SLAB_NO_ST  = (String)RollSlabSeqAftRow.getAttribute("SLAB_NO_ST");
				V_AFT_SLAB_NO_EN  = (String)RollSlabSeqAftRow.getAttribute("SLAB_NO_EN");
			
			} else {
				
				V_AFT_SLAB_NO_ST  = "";
				V_AFT_SLAB_NO_EN  = "";
				
			}
    		
			if (V_AFT_SLAB_NO_ST == "" || V_AFT_SLAB_NO_EN == ""){
				
				//MESSAGE ERROR --> PROGRAM EXIT
				//throw new PosException("MILLRollSeqChange..AFT_SLAB_NO ST/EN IS NULL..");	
				throw new PosException("缺少操作对象  MILLRollSeqChange..AFT_SLAB_NO ST/EN IS NULL..");	
				
			}//end 获取移动之前的头尾板坯
			
			//DELETE TBF02_CHG_ROLL 
			getDao("mesdao").delete("NIF024030_ChgRoll.delete");
			
			//INSERT TEMP TABLE TBF02_CHG_ROLL 
			getDao("mesdao").insert("NIF024030_TempRoll.insert");
		    
		    //START ROLL_MANA_NO, SLAB_EDT_SEQ, ROLL_SLAB_SEQ CHECK 
		    PosParameter param12 = new PosParameter();
		    param12.setWhereClauseParameter(0, P_ROLL_MANA_ST); 
		    param12.setWhereClauseParameter(1, P_ROLL_MANA_EN);
		    param12.setWhereClauseParameter(2, P_ROLL_MANA_TG);
		    PosRowSet RollEdtSeqFindVO = getDao("mesdao").find("NIF024030_RollEdtSeqFind.select",param12);
		    RollEdtSeqFindVO.reset();
		    
			if (RollEdtSeqFindVO.hasNext()) {
				
				PosRow RollEdtSeqFindRow  = RollEdtSeqFindVO.next();
				V_SEQ_ST  = Long.parseLong((RollEdtSeqFindRow.getAttribute("SEQ_ST")==null? "0":RollEdtSeqFindRow.getAttribute("SEQ_ST")).toString());
				V_SEQ_EN  = Long.parseLong((RollEdtSeqFindRow.getAttribute("SEQ_EN")==null? "0":RollEdtSeqFindRow.getAttribute("SEQ_EN")).toString());
				V_SEQ_TG  = Long.parseLong((RollEdtSeqFindRow.getAttribute("SEQ_TG")==null? "0":RollEdtSeqFindRow.getAttribute("SEQ_TG")).toString());
			
			} else {
				
				V_SEQ_ST  = 0;
				V_SEQ_EN  = 0;
				V_SEQ_TG  = 0;
				
			}
			
		    //进行轧辊移动操作
			//CHANGE RANGE VALUE SETTING
		    if (V_SEQ_ST > V_SEQ_TG) {
		    	
		    	if (P_POS.equals("B")) {
			    	V_SHIFT_CNT     = V_SEQ_EN - V_SEQ_ST + 1;
			    	V_MOVE_CNT      = V_SEQ_TG - V_SEQ_ST;
			    	V_SHIFT_FR_SEQ  = V_SEQ_TG;
			    	V_SHIFT_TO_SEQ  = V_SEQ_ST - 1;
		    	} else {
		    		V_SHIFT_CNT     = V_SEQ_EN - V_SEQ_ST + 1;
			    	V_MOVE_CNT      = V_SEQ_TG - V_SEQ_ST + 1;
			    	V_SHIFT_FR_SEQ  = V_SEQ_TG + 1;
			    	V_SHIFT_TO_SEQ  = V_SEQ_ST - 1;
		    	}
		    	
		    } else {
		    	
		    	if (P_POS.equals("B")) {
			    	V_SHIFT_CNT     = V_SEQ_ST - V_SEQ_EN - 1;
			    	V_MOVE_CNT      = V_SEQ_TG - V_SEQ_EN - 1;
			    	V_SHIFT_FR_SEQ  = V_SEQ_EN + 1;
			    	V_SHIFT_TO_SEQ  = V_SEQ_TG - 1;
		    	} else {
		    		V_SHIFT_CNT     = V_SEQ_ST - V_SEQ_EN - 1;
			    	V_MOVE_CNT      = V_SEQ_TG - V_SEQ_EN;
			    	V_SHIFT_FR_SEQ  = V_SEQ_EN + 1;
			    	V_SHIFT_TO_SEQ  = V_SEQ_TG;
		    	}
		    	
		    }

		    //RE-ARRANGE ROLL_SEQ CHANGING
		    PosRowSet TmpChgRollVO = getDao("mesdao").find("NIF024030_TmpChgRoll.select");
		    TmpChgRollVO.reset();
		    
			while(TmpChgRollVO.hasNext()) {
				
				PosRow TmpChgRollRow  = TmpChgRollVO.next();
				V_ORG_SEQ  = Long.parseLong((TmpChgRollRow.getAttribute("ORG_SEQ")==null? "0":TmpChgRollRow.getAttribute("ORG_SEQ")).toString());
			
				V_CHG_SEQ  = V_ORG_SEQ;
				
				//CHECK SEQUENCE
		    	if (V_CHG_SEQ >= V_SEQ_ST && V_CHG_SEQ <= V_SEQ_EN) {
		    		
		    		V_CHG_SEQ = V_CHG_SEQ + V_MOVE_CNT;
		    		
		    	} else if (V_CHG_SEQ >= V_SHIFT_FR_SEQ &&  V_CHG_SEQ <= V_SHIFT_TO_SEQ) {
		        
		    		V_CHG_SEQ = V_CHG_SEQ + V_SHIFT_CNT;
		    	}
		    	
		    	if (V_ORG_SEQ != V_CHG_SEQ) {
		    	
		    		V_CHG_FL = "Y";
		    		
		    	} else {
		    		
		    		V_CHG_FL = "N";
		    		
		    	}
				
				//RE-ARRANGE UPDATE TBF02_CHG_ROLL --> CHG_SEQ
		    	PosParameter param13 = new PosParameter();
		    	param13.setWhereClauseParameter(0, String.valueOf(V_CHG_SEQ));
		    	param13.setWhereClauseParameter(1, V_CHG_FL);
		    	param13.setWhereClauseParameter(2, String.valueOf(V_ORG_SEQ));
		    	getDao("mesdao").update("NIF024030_TmpChgRoll.update",param13);
			
			}  //TmpChgRollVO while END
			
		    //RE-ARRANGE ROLL_MANA_NO CHANGING
		    PosRowSet TmpChgRollChgVO = getDao("mesdao").find("NIF024030_TmpChgRollChg.select");
		    TmpChgRollChgVO.reset();
		    
			while(TmpChgRollChgVO.hasNext()) {
				
				PosRow TmpChgRollChgRow  = TmpChgRollChgVO.next();
				V_ORG_SEQ       = Long.parseLong((TmpChgRollChgRow.getAttribute("ORG_SEQ")==null? "0":TmpChgRollChgRow.getAttribute("ORG_SEQ")).toString());
				V_ROLL_MANA_NO  = (String)TmpChgRollChgRow.getAttribute("ROLL_MANA_NO");
				V_CHG_FL        = (String)TmpChgRollChgRow.getAttribute("FL");
			
				if (V_CHG_FL.equals("Y")) {
					
					if (V_BEF_ROLL_MANA_NO.equals("")) {
						
						V_ROLL_MANA_NO  = "A0001"; 
						
					} else {
						
						if (V_BEF_ROLL_MANA_NO.substring(1, 5).equals("9999")) {//20210124 == 调整为equals

							//ROLL_MANA_NO HEADER ALPHABET + 1
							String nextSeqQr = "SELECT CHR(ASCII('" + V_BEF_ROLL_MANA_NO.substring(0, 1) + "')+1) ROLL_HEAD FROM DUAL";
							PosRowSet nextSeqVO = getDao("mesdao").findByQueryStatement(nextSeqQr);
							nextSeqVO.reset();
							PosRow nextSeqRow = nextSeqVO.next(); 
							String V_ROLL_HEAD = (String)nextSeqRow.getAttribute("ROLL_HEAD");
							
							V_ROLL_MANA_NO = V_ROLL_HEAD + "0001";
						
						} else {
							
							V_ROLL_MANA_IC  = StringUtils.calculateIntegerStringValue(V_BEF_ROLL_MANA_NO.substring(1, 5), 1);
							V_ROLL_MANA_NO  = new StringBuffer(5).append(V_BEF_ROLL_MANA_NO.substring(0, 1)).append(V_ROLL_MANA_IC).toString();
						
						}
					}
				}

				V_BEF_ROLL_MANA_NO = V_ROLL_MANA_NO;
				
				//RE-ARRANGE UPDATE TBF02_CHG_ROLL --> CHG_ROLL_MANA_NO
		    	PosParameter param14 = new PosParameter();
		    	param14.setWhereClauseParameter(0, V_ROLL_MANA_NO);
		    	param14.setWhereClauseParameter(1, String.valueOf(V_ORG_SEQ));
		    	getDao("mesdao").update("NIF024030_TmpChgRollManaNo.update",param14);
			
			} //TmpChgRollChgVO while END
			
			//-------------------------------------------------------------------------------------------------------
			//CHANGE ROLL_MANA_NO UPDATE
		    PosRowSet ChgManaNoUpdVO = getDao("mesdao").find("NIF024030_ChgManaNoUpd.select");
		    ChgManaNoUpdVO.reset();
		    
			while(ChgManaNoUpdVO.hasNext()) {
				
				PosRow ChgManaNoUpdRow  = ChgManaNoUpdVO.next();
				V_ROLL_MANA_NO      = (String)ChgManaNoUpdRow.getAttribute("ROLL_MANA_NO");
				V_CHG_ROLL_MANA_NO  = (String)ChgManaNoUpdRow.getAttribute("CHG_ROLL_MANA_NO");
			
				//UPDATE TBF02_SPEC_ROLL (ROLL_MANA_NO)
				PosParameter param17 = new PosParameter();
				param17.setWhereClauseParameter(0, V_CHG_ROLL_MANA_NO);
				param17.setWhereClauseParameter(1, V_ROLL_MANA_NO);
				int UpdCnt17 = getDao("mesdao").update("NIF024030_SpecRollUpd.update",param17);
				
				if (UpdCnt17 == 0) {
					
					V_TABLE_ID    =  "TBF02_SPEC_ROLL";
					V_TABLE_MODE  =  "U";
					V_ERR_DESC    =  "TBF02_SPEC_ROLL UPDATE COUNT IS ZERO";
					V_RTN_NAME    =  "MILLRollSeqChange TBF02_SPEC_ROLL UPDATE17";
					
					LogGpError.logMessageToDB("MILLRollSeqChange", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					//throw new PosException(V_RTN_NAME);
					
				}
				
				//UPDATE TBF02_SPEC_MILL (ROLL_MANA_NO)
				PosParameter param18= new PosParameter();
				param18.setWhereClauseParameter(0, V_CHG_ROLL_MANA_NO);
				param18.setWhereClauseParameter(1, V_ROLL_MANA_NO);
			    int UpdCnt18 = getDao("mesdao").update("NIF024030_SpecMillUpd.update",param18);
			    
			    if (UpdCnt18 == 0) {
					
					V_TABLE_ID    =  "TBF02_SPEC_MILL";
					V_TABLE_MODE  =  "U";
					V_ERR_DESC    =  "TBF02_SPEC_MILL UPDATE COUNT IS ZERO";
					V_RTN_NAME    =  "MILLRollSeqChange TBF02_SPEC_MILL UPDATE18";
					
					LogGpError.logMessageToDB("MILLRollSeqChange", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					//throw new PosException(V_RTN_NAME);
					
				}
	
				//UPDATE TBF02_MILL_IDX (ROLL_MANA_NO)
			    PosParameter param19 = new PosParameter();
			    param19.setWhereClauseParameter(0, V_CHG_ROLL_MANA_NO);
			    param19.setWhereClauseParameter(1, V_ROLL_MANA_NO);
			    int UpdCnt19 = getDao("mesdao").update("NIF024030_MillIdxUpd.update",param19);
			    
			    if (UpdCnt19 == 0) {
					
					V_TABLE_ID    =  "TBF02_MILL_IDX";
					V_TABLE_MODE  =  "U";
					V_ERR_DESC    =  "TBF02_MILL_IDX UPDATE COUNT IS ZERO";
					V_RTN_NAME    =  "MILLRollSeqChange TBF02_MILL_IDX UPDATE19";
					
					LogGpError.logMessageToDB("MILLRollSeqChange", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					//throw new PosException(V_RTN_NAME);
					
				}
			    
			} //ChgRollManaNoVO  while END			
		    		    
			//---------------------------------------------------------------------------------
			//MILL INSTRUCTION LEVEL2 RE-SEND(UPDATE) PROCESS
			
			//TBH06_L2_ROLL_UNIT_INS SEND PROCESS
			int InsertA = getDao("mesdao").insert("NIF024030_L2ROLLReSend.insert");
		    
		    if (InsertA == 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    =  "MILLRollSeqChange TBH06_L2_ROLL_UNIT_INS INSERTA";
				
				LogGpError.logMessageToDB("MILLRollSeqChange", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
				throw new PosException(V_RTN_NAME);
				
			}
		    
			//TBH06_L2_RHT_INS RE-SEND PROCESS
		    int InsertB = getDao("mesdao").insert("NIF024030_L2RHTReSend.insert");
		    
		    if (InsertB == 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    =  "MILLRollSeqChange TBH06_L2_RHT_INS INSERTB";
				
				LogGpError.logMessageToDB("MILLRollSeqChange", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
				throw new PosException(V_RTN_NAME);
				
			}
			
		    //TBH06_L2_MILL_INS RE-SEND PROCESS
		    int InsertC = getDao("mesdao").insert("NIF024030_L2MILLReSend.insert");
		    
		    if (InsertC == 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    =  "MILLRollSeqChange TBH06_L2_MILL_INS INSERTC";
				
				LogGpError.logMessageToDB("MILLRollSeqChange", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
				throw new PosException(V_RTN_NAME);
				
			}

		    //CHANGE ROLL_MANA_NO 
		    PosRowSet ChgRollManaNoVO = getDao("mesdao").find("NIF024030_ChgRollManaNo.select");
		    ChgRollManaNoVO.reset();
		    
			while(ChgRollManaNoVO.hasNext()) {
				
				PosRow ChgRollManaNoRow  = ChgRollManaNoVO.next();
				V_ROLL_MANA_NO  = (String)ChgRollManaNoRow.getAttribute("CHG_ROLL_MANA_NO");
		    
			    //SELECT NXET SET SEQUEANCE
				String RenextSeqQr = "SELECT L2_COIL_NO_SET_SEQ.NEXTVAL SET_SEQ FROM DUAL ";
				PosRowSet RenextSeqVO = getDao("mesdao").findByQueryStatement(RenextSeqQr);
				RenextSeqVO.reset();
				PosRow RenextSeqRow = RenextSeqVO.next(); 
				Number V_RESET_SEQ = (Number)RenextSeqRow.getAttribute("SET_SEQ");
				
				//TBH06_L2_COIL_NO_INS RE-SEND PROCESS
			    PosParameter paramD = new PosParameter();
			    paramD.setValueParamter(0, V_RESET_SEQ);
			    paramD.setValueParamter(1, V_ROLL_MANA_NO); 
			    int InsertD = getDao("mesdao").insert("NIF024030_L2ROLLCOILReSend.insert",paramD);
			    
			    if (InsertD == 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    =  "MILLRollSeqChange TBH06_L2_COIL_NO_INS INSERT D " + V_ROLL_MANA_NO;
					
					LogGpError.logMessageToDB("MILLRollSeqChange", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
					throw new PosException(V_RTN_NAME);
					
				}
		    
			} //ChgRollManaNoVO  while END		    
		    
		    //MILL INSTRUCTION LEVEL2 RE-SEND(UPDATE) PROCESS END
			//---------------------------------------------------------------------------------
			
		    //LAST JOB DELETE TBF02_CHG_ROLL 
			getDao("mesdao").delete("NIF024030_ChgRoll.delete");

			//FL INIT TBF02_SPEC_ROLL 
			getDao("mesdao").update("NIF024030_InitSpecRoll.update");

			//FL INIT TBF02_SPEC_MILL
			getDao("mesdao").update("NIF024030_InitSpecMill.update");
			
			//FL INIT TBF02_MILL_IDX
			getDao("mesdao").update("NIF024030_InitMillIdx.update");
		    
//		}
//	    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;
		
	}
	/**
	 * @param p_pos        A : 后  B:前
	 * @param p_roll_st	   轧辊单元起始位置
	 * @param p_roll_aim   轧辊单元目标位置
	 * @return moveable    是否可以移动
	 */
	public boolean moveAble  (String p_pos ,String p_roll_end,String p_aim) {
	    boolean moveable = true;
	    
	    PosParameter param =  new PosParameter();
	    param.setWhereClauseParameter(0,P_ROLL_MANA_EN);
	    param.setWhereClauseParameter(0,P_ROLL_MANA_TG);
	    long v_cnt_coil_stat = 0;
	    long v_cnt_status 	=  0;
	    PosRowSet rowset    = null;
	    PosRow    row  		= null;
	    
	  
	    if("A".equals(p_pos)) {
	    	 rowset  = this.getDao("mesdao").find("NIF024030_MILLStatusChkPosA.select", param);

	    }else if("B".equals(p_pos)) {
	    	 rowset  = this.getDao("mesdao").find("NIF024030_MILLStatusChk.select", param);
	    }else {
	    	throw new PosException("[MILLRollSeqChange]：[moveAble]：p_pos...位置没有输入...");
	    }
	 	   
	   	 while (rowset.hasNext()) {
	   		 row  = rowset.next();
	   		 v_cnt_coil_stat = Long.parseLong(row.getAttribute("COIL_STAT_CNT").toString());
	   		 v_cnt_status    = Long.parseLong(row.getAttribute("STATUS_CNT").toString());
	   		 if(v_cnt_coil_stat  > 0 || v_cnt_status > 0) {
	   			 throw new PosException("[MILLRollSeqChange]：[moveAble]：v_cnt_coil_stat || v_cnt_status 不能够插入在已上料板坯间...");
	   		 }
	   	 }
		return moveable;
	}
}