package UIE.NIE01;

import java.util.ArrayList;

import org.springframework.jdbc.support.rowset.SqlRowSet;

import UIB.COM.XmlSqlParsersFactory;
import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;

public class SaveOrdSts extends CoreIComponent {
	String V_TABLE_ID     = "" ;
	String V_TABLE_MODE   = "" ;
	String V_ERR_DESC     = "" ; 
	String V_RTN_NAME     = "" ;
	
	String P_BEF_ORD_NO    ; 
	String P_BEF_ORD_SEQ   ; 
	String P_ORD_NO        ;
	String P_ORD_SEQ       ;
	String P_BEF_PROG_CD   ;
	String P_PROG_CD       ;
	String P_MAT_TYPE      ;
	String P_MAT_NO        ;
	Number P_WGT           ;
	String P_PGMID         ;
	String P_REG_ID        ;
	
	String sqlstr 	   ;
	CoreReturnObject	cro	;
	SqlRowSet srs;
	ArrayList paramArray ;
	
	public SaveOrdSts(String P_BEF_ORD_NO,String P_BEF_ORD_SEQ,String P_ORD_NO,String P_ORD_SEQ,
				 		String P_BEF_PROG_CD,String P_PROG_CD,String P_MAT_TYPE,String P_MAT_NO,
				 		Number P_WGT,String P_PGMID,String P_REG_ID){
		this.P_BEF_ORD_NO 	= P_BEF_ORD_NO; 
		this.P_BEF_ORD_SEQ 	= P_BEF_ORD_SEQ; 
		this.P_ORD_NO 		= P_ORD_NO;
		this.P_ORD_SEQ 		= P_ORD_SEQ;
		this.P_BEF_PROG_CD 	= P_BEF_PROG_CD;
		this.P_PROG_CD 		= P_PROG_CD;
		this.P_MAT_TYPE 	= P_MAT_TYPE;
		this.P_MAT_NO 		= P_MAT_NO;
		this.P_WGT 			= P_WGT;
		this.P_PGMID 		= P_PGMID;
		this.P_REG_ID 		= P_REG_ID;
		
	}
	public void SaveOrdStsUpdt() throws Exception{	
		try {
			
			if (P_MAT_TYPE  == null || "".equals(P_MAT_TYPE)) {
				
				V_RTN_NAME    =  "SaveOrdSts MAT_TYPE IS NULL ";
				
				throw new Exception(V_RTN_NAME);
				
			}
			
			if (P_MAT_NO  == null || "".equals(P_MAT_NO)) {
				
				V_RTN_NAME    =  "SaveOrdSts MAT_NO IS NULL ";
				
				throw new Exception(V_RTN_NAME);
				
			}
			
			//SELECT NXET SEQUEANCE FROM TBE02_ORDSTS
			sqlstr = "SELECT ORDER_STATUS_OCC_SEQ.NEXTVAL NEXT_SEQ FROM DUAL ";
    		cro = this.getDao("KgDao").ExecutequeryForRowSet(sqlstr);
    		srs	=	(SqlRowSet)cro.getResult();
    		Number V_OCC_SEQ = 0;
    		if(srs.next()){
    			V_OCC_SEQ = (Number)srs.getObject("NEXT_SEQ");
    		}
			
			//SELECT PK CHECK FROM TBE02_ORDSTS
    		sqlstr = "SELECT OCC_SEQ FROM TBE02_ORDSTS WHERE OCC_SEQ = ? ";
    		cro = this.getDao("KgDao").ExecutequeryForRowSet(sqlstr,new Object[]{V_OCC_SEQ});
    		srs	=	(SqlRowSet)cro.getResult();
		    
			if (srs.next()) {
				
				paramArray = new ArrayList();
	    	 
				paramArray.add(P_BEF_ORD_NO);   
				paramArray.add(P_BEF_ORD_SEQ);  
				paramArray.add(P_ORD_NO);  
				paramArray.add(P_ORD_SEQ);  
				paramArray.add(P_BEF_PROG_CD);  
				paramArray.add(P_PROG_CD); 
				paramArray.add(P_MAT_TYPE);
				paramArray.add(P_MAT_NO);
				paramArray.add(P_WGT);
				paramArray.add(P_PGMID);
				paramArray.add(P_REG_ID);
				paramArray.add(V_OCC_SEQ);
				sqlstr = XmlSqlParsersFactory.getSql("NIE042040_ORDSTS.update");
				cro = this.getDao("KgDao").ExcuteNonQuery(sqlstr,paramArray.toArray());
				
//				if (UpdCnt == 0) {
//					
//					V_TABLE_ID    =  "TBE02_ORDSTS";
//					V_TABLE_MODE  =  "U";
//					V_ERR_DESC    =  "TBE02_ORDSTS UPDATE COUNT IS ZERO";
//					V_RTN_NAME    =  "SaveOrdSts TBE02_ORDSTS UPDATE " + V_OCC_SEQ;
//					
//					LogGpError.logMessageToDB("SaveOrdSts", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
//					throw new PosException(V_RTN_NAME);
//				}	

	    	 } else {	    	  
	    	   
	    		paramArray = new ArrayList();
				 
	    		paramArray.add(V_OCC_SEQ); 
	    		paramArray.add(P_BEF_ORD_NO);   
	    		paramArray.add(P_BEF_ORD_SEQ);  
	    		paramArray.add(P_ORD_NO);  
	    		paramArray.add(P_ORD_SEQ);  
	    		paramArray.add(P_BEF_PROG_CD);  
	    		paramArray.add(P_PROG_CD); 
	    		paramArray.add(P_MAT_TYPE);
	    		paramArray.add(P_MAT_NO);
	    		paramArray.add(P_WGT);
	    		paramArray.add(P_PGMID);
	    		paramArray.add(P_REG_ID);
	    		sqlstr = XmlSqlParsersFactory.getSql("NIE042040_ORDSTS.insert");
				cro = this.getDao("KgDao").ExcuteNonQuery(sqlstr,paramArray.toArray());
				
//				if (InsCnt == 0) {
//					
//					V_TABLE_ID    =  "TBE02_ORDSTS";
//					V_TABLE_MODE  =  "I";
//					V_ERR_DESC    =  "TBE02_ORDSTS INSERT COUNT IS ZERO";
//					V_RTN_NAME    =  "SaveOrdSts TBE02_ORDSTS INSERT " + V_OCC_SEQ;
//					
//					LogGpError.logMessageToDB("SaveOrdSts", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
//					throw new PosException(V_RTN_NAME);
//				}
	    	 } 	
		}catch(Exception ex){
			throw ex;
		}
	}
	
}