package xin.glue.nui.F.F02;

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.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  MILLLvlReSend (NIF024090)
 * Description   MILL WORK INSTRUCTION LEVEL2 RESEND 
 * Write By      KIM SUNG HO 
 * Date          2009-04-01
 */

public class MILLLvlReSend extends PosActivity implements GlobalConstants {
		
	public String runActivity(PosContext context) {
		
		long V_SLAB_EDT_SEQ      = 0 ;
	
		String V_ROLL_MANA_NO    = "" ;
		
		String V_TABLE_ID        = "" ;
		String V_TABLE_MODE      = "" ;
		String V_ERR_DESC        = "" ; 
		String V_RTN_NAME        = "" ;
		
		PosMessage message = context.getMessage();	
		
		Number P_SLAB_EDT_SEQ  = (Number)message.get("SLAB_EDT_SEQ"); 
		
		V_SLAB_EDT_SEQ = Long.parseLong(P_SLAB_EDT_SEQ.toString());
    		
		if (V_SLAB_EDT_SEQ == 0) {
				
			//MESSAGE ERROR --> PROGRAM EXIT
			throw new PosException("MILLLvlReSend..SLAB_EDT_SEQ ERROR..");

		}
		
		//SELECT ROLL_MANA_NO
	    PosParameter paramA = new PosParameter();
	    paramA.setWhereClauseParameter(0, String.valueOf(V_SLAB_EDT_SEQ)); 
	    PosRowSet RollManaINfVO = getDao("mesdao").find("NIF024090_RollManaNo.select",paramA);
	    RollManaINfVO.reset();
			
	    if (RollManaINfVO.hasNext()) {
	    	
	    	PosRow	RollManaINfRow = RollManaINfVO.next(); 
	    	
	    	V_ROLL_MANA_NO   =  (String)RollManaINfRow.getAttribute("ROLL_MANA_NO");
	    	
	    } else {
	    	
	    	//Error Display
	    	throw new PosException("MILLLvlReSend --> NOT FOUND ROLL_MANA_NO..");
	    	
	    }
			
	    //-------------------------------------------------------------------------------
	    //INSERT MILL INSTRUCTION LEVEL2 RESEND PROCESS -----------------------------------
		
		//TBH06_L2_ROLL_UNIT_INS RESEND PROCESS
		PosParameter paramB = new PosParameter();
		paramB.setValueParamter(0, V_ROLL_MANA_NO);
		int InsertQ = getDao("mesdao").insert("NIF024090_L2ROLLReSend.insert",paramB);
	    
	    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    =  "MILLLvlReSend TBH06_L2_ROLL_UNIT_INS INSERTQ " + V_ROLL_MANA_NO;
			
			LogGpError.logMessageToDB("MILLLvlReSend", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
			throw new PosException(V_RTN_NAME);
		}
		    
	    //TBH06_L2_RHT_INS RESEND PROCESS
	    PosParameter paramC = new PosParameter();
	    paramC.setValueParamter(0, String.valueOf(V_SLAB_EDT_SEQ));  
	    int InsertC = getDao("mesdao").insert("NIF024090_L2RHTReSend.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    =  "MILLLvlReSend TBH06_L2_RHT_INS INSERTC " + String.valueOf(V_SLAB_EDT_SEQ);
			
			LogGpError.logMessageToDB("MILLLvlReSend", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
			throw new PosException(V_RTN_NAME);
		}
			
	    //TBH06_L2_MILL_INS SEND PROCESS
	    PosParameter paramD = new PosParameter();
	    paramD.setValueParamter(0, String.valueOf(V_SLAB_EDT_SEQ));    
	    int InsertD = getDao("mesdao").insert("NIF024090_L2MILLReSend.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    =  "MILLLvlReSend TBH06_L2_MILL_INS INSERTD " + String.valueOf(V_SLAB_EDT_SEQ);
			
			LogGpError.logMessageToDB("MILLLvlReSend", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
			throw new PosException(V_RTN_NAME);
		}

		//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");

		//TBH06_L2_COIL_NO_INS SEND PROCESS
	    PosParameter paramG = new PosParameter();
	    paramG.setValueParamter(0, V_SET_SEQ);
	    paramG.setValueParamter(1, String.valueOf(V_SLAB_EDT_SEQ)); 
	    int InsertG = getDao("mesdao").insert("NIF024090_L2ROLLCOILReSend.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    =  "MILLLvlReSend TBH06_L2_COIL_NO_INS INSERTG " + String.valueOf(V_SLAB_EDT_SEQ);
			
			LogGpError.logMessageToDB("MILLLvlReSend", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
			throw new PosException(V_RTN_NAME);
		}
	
		return PosBizControlConstants.SUCCESS;
		
	}

}