package UIE.NIE01;

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

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

/**
 * 
 * @desc   订单整理MAIN
 * @author wxy
 * @date   2010 4:24:36 PM
 */
public class OrdStsMain extends CoreIComponent{
	String V_TABLE_ID   = "";
	String V_TABLE_MODE = "";
	String V_ERR_DESC   = "";
	String V_RTN_NAME   = "";

	
	public void ordStsUpdt() throws Exception
	{
		// SELECT TBE02_ORDSTS INFORMATION
		CoreReturnObject	cro		=	new CoreReturnObject();
		//获取满足条件的所有检验项目
		String sqlstr = XmlSqlParsersFactory.getSql("NIE042010_ORDSTS.select");
		
		cro = this.getDao("KgDao").ExecutequeryForRowSet(sqlstr);
		SqlRowSet	srs	=	(SqlRowSet)cro.getResult();
		while(srs.next()){
			String P_BEF_ORD_NO  = (String) srs.getObject("BEF_ORD_NO");
			String P_BEF_ORD_SEQ = (String) srs.getObject("BEF_ORD_SEQ");
			String P_ORD_NO      = (String) srs.getObject("ORD_NO");
			String P_ORD_SEQ     = (String) srs.getObject("ORD_SEQ");
			String P_BEF_PROG_CD = (String) srs.getObject("BEF_PROG_CD");
			String P_PROG_CD     = (String) srs.getObject("PROG_CD");
			String P_MAT_TYPE    = (String) srs.getObject("MAT_TYPE");
			String P_MAT_NO      = (String) srs.getObject("MAT_NO");
			String P_PGMID       = (String) srs.getObject("PGMID");
			String P_REG_ID      = (String) srs.getObject("REG_ID");
			
			if  ((P_BEF_PROG_CD == null || "".equals(P_BEF_PROG_CD)) & 
					 (P_PROG_CD     == null || "".equals(P_PROG_CD)) )  {
					
			} else {
				
				if (P_MAT_TYPE.equals("CH")) {
					//酸轧基料整理
					ordStsCoil(P_BEF_ORD_NO,P_BEF_ORD_SEQ,P_ORD_NO,P_ORD_SEQ,P_BEF_PROG_CD,P_PROG_CD,P_MAT_TYPE
								,P_MAT_NO,P_PGMID,P_REG_ID);
					
				} else if (P_MAT_TYPE.equals("TM")) {
					// 酸轧成品整理
					ordStsColdCoil(P_BEF_ORD_NO,P_BEF_ORD_SEQ,P_ORD_NO,P_ORD_SEQ,P_BEF_PROG_CD,P_PROG_CD,P_MAT_TYPE
							,P_MAT_NO,P_PGMID,P_REG_ID);
				} else if (P_MAT_TYPE.equals("AR")) {
					// CALL NIE012083_OrdStsCoil
				}
			}
			
			//UPDATE TBE02_ORDSTS FL = '*' (ORD STATUS PROCESS COMPLETE)
			sqlstr = XmlSqlParsersFactory.getSql("NIE042010_ORDSTS.update");
			cro = this.getDao("KgDao").ExcuteNonQuery(sqlstr, new Object[]{srs.getObject("OCC_SEQ")});
//			if (cro. == 0) {
//				V_TABLE_ID = "TBE02_ORDSTS";
//				V_TABLE_MODE = "U";
//				V_ERR_DESC = "TBE02_ORDSTS UPDATE COUNT IS ZERO";
//				V_RTN_NAME = "OrdStsMain TBE02_ORDSTS UPDATE";
//	
//				LogGpError.logMessageToDB("OrdStsMain", V_TABLE_ID, V_TABLE_MODE, V_ERR_DESC, V_RTN_NAME);
//				throw new PosException(V_RTN_NAME);
//			}
			
		}
		
		// DELETE TBE02_ORD_PRC_DET TOT_WGT = 0
		sqlstr = XmlSqlParsersFactory.getSql("NIE042010_ORDPRCDET.delete");
		cro = this.getDao("KgDao").ExcuteNonQuery(sqlstr);
	}
	
	private void ordStsCoil(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,String P_PGMID,String P_REG_ID){
		
	}
	
	private void ordStsColdCoil(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,String P_PGMID,String P_REG_ID){
		
	}
}