XinYu_RZMES/.svn/pristine/0d/0d309bd1dedc0db79161cc47556e3a638e5df04a.svn-base

package xin.glue.nui.H.H02;

import java.math.BigDecimal;

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;

public class XinSaveCoilComm extends PosActivity 
{

	public String runActivity(PosContext context) 
	{
//		获取从二级接收过来的数据 
		
		 
		
		String slabNo = (String)context.get("slabNo");
		String coilNo = (String)context.get("coilNo");
		
		//这里在XinInitRhfOut中已经把真实钢卷号转换成流水号，所以这里不需要再次转换
		
		/*
		 * 从TBF02_SPEC_MILL中取得被 SELECT的轧钢参数table
		 * 轧钢参数data编辑 ( COIL公用 <-轧钢参数data)
		 * 牌号  .,标准号, 交货期, 合同号, 订单号, 订单用途代码, 产品代码   订单去向
		 * 需要插入到TBH02_COIL_COMM表中
		 * 板坯编制号用于查询TBF02_SPEC_MILL_D表时 作为查询条件
		 */
//			真实钢号，品质需要
	 	String specstlGrd = "";
		String stlGrd = "";					//牌号
		String specAbbsym = "";				//标准号
		String delvReqData = "";			//交货期
		String ordNo = "";					//合同号
		String ordSeq = "";					//订单号
		String ordUseageCd = "";			//订单用途代码
		String route = "";					//订单去向
		BigDecimal slabEdtSeq = null;		//板坯编制号，TBF02_SPEC_MILL表主键
		//对应加热炉出炉情况增加的
		String SPEC_ORD_FL         = null;  //产品余材区分
		String SPM_PROC_YN         = null;  //平整分卷判定
		String SPEC_ORD_CUST_CD    = null;  //客户代码
		String SPEC_PATH_MILL_CD   = null;  //轧制产线工艺流程
		String SPEC_PACK_METHOD    = null;  //包装方法
		Number SPEC_ORD_INDIA      = null;  //钢卷定单内径
		Number SPEC_ORD_OUTDIA     = null;  //钢卷定单外径
        Number SPEC_ORD_THK        = null;  //定单厚度
        Number SPEC_ORD_WTH        = null;  //定单宽度
        Number SPEC_ORD_WGT        = null;  //定单重量
        String SPEC_DEST_CD        = null;  //目的地代码
        
         
		/*
		 * 从TBG02_SLAB_COMM中取得 产品代码 需要插入到TBH02_COIL_COMM表中
		 */
		//String prodnmCd = "";				//产品代码 这里没有取到具体的数据
		
		/*
		 * 从TBF02_SPEC_MILL_D中取得被 SELECT的轧钢参数详细table
		 * 轧钢参数详细data编辑 (COIL详细 <-  轧钢参数详细data) 
		 */
		String coilCutSeq = "";				//切割顺序
		BigDecimal ordThk = null;			//订单厚度
		BigDecimal ordWth = null;			//订单宽度
		BigDecimal ordLen = null;			//订单长度
		BigDecimal ordWgt = null;			//订单重量
		BigDecimal ordWgtMin = null;		//订单单重下限
		BigDecimal ordWgtMax = null;		//订单单重上限
		BigDecimal ordIndia = null;			//订单内径
		BigDecimal ordOutdia = null;		//订单外径
		String ordNo1 = "";					//合同号  用于详细表
		String ordSeq1 = "";				//订单号  用于详细表
		String ordFl = "";					//订单余才区分
		//String statusCd = "";				//状态区分  后面没有用到
		String ProdnmCd = "";               //产品代码  TL 后面用到了。
		String CUST_CD = "";					 
		
		PosParameter param0 = new PosParameter();
		//PosParameter param1 = new PosParameter();
		PosParameter param2 = new PosParameter();
		PosParameter param3 = new PosParameter();
		PosParameter param4 = new PosParameter();
		PosParameter param5 = new PosParameter();
		  
//			从TBH02_SPEC_MILL中取得数据 需要插入到TBH02_COIL_COMM表中
		param0.setWhereClauseParameter(0, coilNo);
		PosRowSet rowset0 = this.getDao("mesdao").find("NIH020020_02.select", param0);
		
		if(rowset0.hasNext())
		{
			PosRow row0 = rowset0.next();
			specstlGrd = (String)row0.getAttribute("SPEC_STL_GRD");         //标准牌号
			stlGrd = (String)row0.getAttribute("STL_GRD");					//牌号
			specAbbsym = (String)row0.getAttribute("SPEC_ABBSYM");			//标准号
			delvReqData = (String)row0.getAttribute("DELV_REQ_DATE");		//交货期
			ordNo = (String)row0.getAttribute("ORD_NO");					//合同号
			ordSeq = (String)row0.getAttribute("ORD_SEQ");					//订单号
			ordUseageCd = (String)row0.getAttribute("ORD_USEAGE_CD");		//订单用途代码
			route = (String)row0.getAttribute("ROUTE");						//订单去向
			slabEdtSeq = (BigDecimal)row0.getAttribute("SLAB_EDT_SEQ");		//板坯编制号
			ProdnmCd = (String)row0.getAttribute("PRODNM_CD");	            //产品代码  冷卷、厚板、冷轧题、热板
			SPEC_ORD_FL = "1";
			SPM_PROC_YN = (String)row0.getAttribute("SPM_PROC_YN"); 
			SPEC_ORD_CUST_CD = (String)row0.getAttribute("ORD_CUST_CD");
			SPEC_PATH_MILL_CD = (String)row0.getAttribute("PATH_MILL_CD");
			SPEC_PACK_METHOD = (String)row0.getAttribute("PACK_METHOD");
			SPEC_ORD_INDIA = (Number)row0.getAttribute("ORD_INDIA");
			SPEC_ORD_OUTDIA = (Number)row0.getAttribute("ORD_OUTDIA");
			SPEC_ORD_THK = (Number)row0.getAttribute("ORD_THK");
			SPEC_ORD_WTH = (Number)row0.getAttribute("ORD_WTH");
			SPEC_ORD_WGT = (Number)row0.getAttribute("ORD_WGT");
			SPEC_DEST_CD = (String)row0.getAttribute("DEST_CD");
			CUST_CD = (String)row0.getAttribute("CUST_CD");
		}
		
		String SpmYn = null;
        if (SPM_PROC_YN != null && SPM_PROC_YN.equals("Y")) {
        	SpmYn = "1";
        } else {
        	SpmYn = "";
        }
		 
//			用钢卷号作为条件查询钢卷公共表，以决定插入或修改操作
		param3.setWhereClauseParameter(0, coilNo);
		param3.setWhereClauseParameter(1, slabNo);
		PosRowSet rowset3 = this.getDao("mesdao").find("NIH020020_05.select", param3);
		if(!rowset3.hasNext())
		{	
//				 
//				用轧钢参数表 TBF02_SPEC_MILL 查询出来的数据项 INERT 钢卷公告表 TBG02_COIL_COMM
			param4.setValueParamter(0, coilNo);                
			param4.setValueParamter(1, slabNo);                
			param4.setValueParamter(2, stlGrd);                
			param4.setValueParamter(3, "1");            
			param4.setValueParamter(4, specAbbsym);            
			param4.setValueParamter(5, delvReqData);           
			param4.setValueParamter(6, ordNo);                 
			param4.setValueParamter(7, ordSeq);                
			param4.setValueParamter(8, ordUseageCd);           
			param4.setValueParamter(9, route);                 
			param4.setValueParamter(10, ProdnmCd);             
			param4.setValueParamter(11, SPEC_ORD_FL);          
			param4.setValueParamter(12, SpmYn);                
			param4.setValueParamter(13, SPEC_ORD_CUST_CD);     
			param4.setValueParamter(14, SPEC_PATH_MILL_CD);    
			param4.setValueParamter(15, SPEC_PACK_METHOD);     
			param4.setValueParamter(16, SPEC_ORD_INDIA);       
			param4.setValueParamter(17, SPEC_ORD_OUTDIA);      
			param4.setValueParamter(18, SPEC_ORD_THK);         
			param4.setValueParamter(19, SPEC_ORD_WTH);         
			param4.setValueParamter(20, SPEC_ORD_WGT);         
			param4.setValueParamter(21, SPEC_DEST_CD);         
			param4.setValueParamter(22, SPEC_ORD_INDIA);       
			param4.setValueParamter(23, "XinSaveCoilComm");    
			param4.setValueParamter(24, CUST_CD);
			param4.setValueParamter(25, ordNo);
			param4.setValueParamter(26, ordSeq);
			param4.setValueParamter(27, specstlGrd);
			
			int rowset4 = this.getDao("mesdao").insert("NIH020020_02.insert", param4);
			 
//				从TBF02_SPEC_MILL_D中取得数据 需要插入到TBH02_COIL_COMM_d表中
			param2.setWhereClauseParameter(0, slabEdtSeq);
			PosRowSet rowset2 = this.getDao("mesdao").find("NIH020020_04.select",param2);
			while(rowset2.hasNext())
			{
				PosRow row2 = rowset2.next();
				coilCutSeq = (String)row2.getAttribute("COIL_CUT_SEQ");						//切割顺序
				ordThk = (BigDecimal)row2.getAttribute("ORD_THK");							//订单厚度
				ordWth = (BigDecimal)row2.getAttribute("ORD_WTH");							//订单宽度
				ordLen = (BigDecimal)row2.getAttribute("ORD_LEN");							//订单长度
				ordWgt = (BigDecimal)row2.getAttribute("ORD_WGT");							//订单重量
				ordWgtMin = (BigDecimal)row2.getAttribute("ORD_WGT_MIN");					//订单单重下限
				ordWgtMax = (BigDecimal)row2.getAttribute("ORD_WGT_MAX");					//订单单重上限
				ordIndia = (BigDecimal)row2.getAttribute("ORD_INDIA");						//订单内径
				ordOutdia = (BigDecimal)row2.getAttribute("ORD_OUTDIA");					//订单外径
				ordNo1 = (String)row2.getAttribute("ORD_NO");							 	//合同号  TL
				ordSeq1 = (String)row2.getAttribute("ORD_SEQ");								//订单号  TL
				ordFl = (String)row2.getAttribute("ORD_FL");								//订单材余材区分
				//这里没有用到
				//statusCd = (String)row2.getAttribute("STATUS_CD");							//状态区分
			 
			
//				用轧钢详细参数表 TBF02_SPEC_MILL_D 查询出来的数据项 INERT 钢卷详细表 TBG02_COIL_COMM_D
			    param5.setValueParamter(0, coilNo);
			    param5.setValueParamter(1, coilCutSeq);
     			param5.setValueParamter(2, ordThk);
	    		param5.setValueParamter(3, ordWth);
		    	param5.setValueParamter(4, ordLen);
		    	param5.setValueParamter(5, ordWgt);
			    param5.setValueParamter(6, ordWgtMin);
			    param5.setValueParamter(7, ordWgtMax);
		    	param5.setValueParamter(8, ordIndia);
		    	param5.setValueParamter(9, ordOutdia);
		    	param5.setValueParamter(10, ordNo1);
	     		param5.setValueParamter(11, ordSeq1);
		    	param5.setValueParamter(12, ordFl);
			
			
			    int rowset5 = this.getDao("mesdao").insert("NIH020020_03.insert",param5);
			    
		 	
		    }
		} else {
			
		   PosParameter param6 = new PosParameter();
		   param6.setWhereClauseParameter(0, "1");
		   param6.setWhereClauseParameter(1, coilNo);
			 
		   getDao("mesdao").update("UIH020020_COIL_COMM.update", param6);
			
			
		}
		
		return PosBizControlConstants.SUCCESS;
	}

}