XinYu_RZMES/.svn/pristine/4c/4c848b96f7efa957aa1d482216434b904160f25e.svn-base

package xin.glue.nui.G.G02;

import java.math.BigDecimal;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

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  xin.glue.ui.common.PosDateFormat; 

/*
 * author:wangxiaoyan
 * Date:08-10-28
 * desc: 
 */
public class XinSaveCcmResult extends PosActivity 
{
	public String runActivity(PosContext context) 
	{
		PosMessage message = context.getMessage();
		
		String 			MSG_RSV_DATE               = (String)message.get("RSV_DATE");
		String 			MSG_CHRGE_NO               = (String)message.get("CHRGE_NO");
		String 			MSG_PLAN_CHARGE_NO         = (String)message.get("PLAN_CHARGE_NO");
		String 			MSG_CAST_NO                = (String)message.get("CAST_NO");
		BigDecimal 		MSG_CAST_EDT_CHARGE_CNT    = (BigDecimal)message.get("CAST_EDT_CHARGE_CNT");
		BigDecimal 		MSG_CAST_CHARGE_SEQ        = (BigDecimal)message.get("CAST_CHARGE_SEQ");
		String 			MSG_CAST_END_YN            = (String)message.get("CAST_END_YN");
		String 			MSG_CC_DEVNO               = (String)message.get("CC_DEVNO");
		BigDecimal 		MSG_STLMELT_WGT            = (BigDecimal)message.get("STLMELT_WGT");
		BigDecimal 		MSG_STLMELT_TEMP           = (BigDecimal)message.get("STLMELT_TEMP");
		BigDecimal 		MSG_CC_END_STLMELT_USE_WGT = (BigDecimal)message.get("CC_END_STLMELT_USE_WGT");
		BigDecimal 		MSG_REM_WGT_IN_LD          = (BigDecimal)message.get("REM_WGT_IN_LD");
		BigDecimal 		MSG_REM_WGT_IN_TD          = (BigDecimal)message.get("REM_WGT_IN_TD");
		BigDecimal 		MSG_CC_YIELD               = (BigDecimal)message.get("CC_YIELD");
//		String 			MSG_SPEC_ABBSYM            = (String)message.get("SPEC_ABBSYM");
//		String 			MSG_LD_NO                  = (String)message.get("LD_NO");
		BigDecimal 		MSG_CC_SPEED_AVG1          = (BigDecimal)message.get("CC_SPEED_AVG1");
		BigDecimal 		MSG_CC_SPEED_MIN1          = (BigDecimal)message.get("CC_SPEED_MIN1");
		BigDecimal 		MSG_CC_SPEED_MAX1          = (BigDecimal)message.get("CC_SPEED_MAX1");
		BigDecimal 		MSG_CC_SPEED_AVG2          = (BigDecimal)message.get("CC_SPEED_AVG2");
		BigDecimal 		MSG_CC_SPEED_MIN2          = (BigDecimal)message.get("CC_SPEED_MIN2");
		BigDecimal 		MSG_CC_SPEED_MAX2          = (BigDecimal)message.get("CC_SPEED_MAX2");
		BigDecimal 		MSG_TD_TEMP_AVG            = (BigDecimal)message.get("TD_TEMP_AVG");
		BigDecimal 		MSG_TD_TEMP_MIN            = (BigDecimal)message.get("TD_TEMP_MIN");
		BigDecimal 		MSG_TD_TEMP_MAX            = (BigDecimal)message.get("TD_TEMP_MAX");
		String 		    MSG_LD_OPEN_YN             = (String)message.get("LD_OPEN_YN");
		BigDecimal 		MSG_MD_LVL1                = (BigDecimal)message.get("MD_LVL1");
		BigDecimal 		MSG_MD_UPPER_WTH1          = (BigDecimal)message.get("MD_UPPER_WTH1");
		BigDecimal 		MSG_MD_LOWER_WTH1          = (BigDecimal)message.get("MD_LOWER_WTH1");
		BigDecimal 		MSG_MD_LVL2                = (BigDecimal)message.get("MD_LVL2");
		BigDecimal 		MSG_MD_UPPER_WTH2          = (BigDecimal)message.get("MD_UPPER_WTH2");
		BigDecimal 		MSG_MD_LOWER_WTH2          = (BigDecimal)message.get("MD_LOWER_WTH2");
		BigDecimal 		MSG_COOLWAT_WGT            = (BigDecimal)message.get("COOLWAT_WGT");
		BigDecimal 		MSG_MD_VIBRATE_CNT1        = (BigDecimal)message.get("MD_VIBRATE_CNT1");
		BigDecimal 		MSG_MD_VIBRATE_WTH1        = (BigDecimal)message.get("MD_VIBRATE_WTH1");
		BigDecimal 		MSG_MD_VIBRATE_CNT2        = (BigDecimal)message.get("MD_VIBRATE_CNT2");
		BigDecimal 		MSG_MD_VIBRATE_WTH2        = (BigDecimal)message.get("MD_VIBRATE_WTH2");
		String 			MSG_LD_ARRV_DTIME          = (String)message.get("LD_ARRV_DTIME");
		String 			MSG_CC_STA_DTIME           = (String)message.get("CC_STA_DTIME");
		String 			MSG_LD_OPEN_DTIME          = (String)message.get("LD_OPEN_DTIME");
		String 			MSG_LD_CLOSE_DTIME         = (String)message.get("LD_CLOSE_DTIME");
		String 			MSG_CC_END_DTIME           = (String)message.get("CC_END_DTIME");
		BigDecimal 		MSG_CC_HOUR                = (BigDecimal)message.get("CC_HOUR");
		BigDecimal 		MSG_SLAB_TOTLEN            = (BigDecimal)message.get("SLAB_TOTLEN");
		BigDecimal 		MSG_SLAB_PROD_CNT          = (BigDecimal)message.get("SLAB_PROD_CNT");
		BigDecimal 		MSG_SLAB_TOTWGT            = (BigDecimal)message.get("SLAB_TOTWGT");                                                                  
		
        int chLth = MSG_CHRGE_NO.trim().length();
		
		if (chLth < 10   ) {
			
			logger.logError("XinSaveCcmResult  CHARGE_NO ERROR !!!!-->"+MSG_CHRGE_NO     ); 	
			
		   return PosBizControlConstants.SUCCESS;
		}
	 	
        String sShift = null;
        if (MSG_RSV_DATE == null || MSG_RSV_DATE.equals("")  ) {	 
  	      DateFormat formatter =  new SimpleDateFormat("yyyyMMddHHmmss");
  	      MSG_RSV_DATE = formatter.format(new Date());
  	    }
	    sShift = PosDateFormat.getShift(MSG_RSV_DATE);
	      
        PosParameter paramA = new PosParameter();
        paramA.setWhereClauseParameter(0, MSG_RSV_DATE.substring(0,6));
        paramA.setWhereClauseParameter(1, MSG_RSV_DATE.substring(6,8));
        paramA.setWhereClauseParameter(2, sShift);
        paramA.setWhereClauseParameter(3, "S");
        PosRowSet groupVO = this.getDao("mesdao").find("NIG020210_SHIFT.select", paramA);
        
        String sGroup = null;
        if (groupVO.hasNext()){
        	PosRow groupROW = groupVO.next();
        	sGroup = (String)groupROW.getAttribute("GR_GROUP_CD");
        }
        /*
        //获取计划牌号
        PosParameter paramB = new PosParameter();
        paramB.setWhereClauseParameter(0, "J"+MSG_PLAN_CHARGE_NO.substring(1));
        PosRowSet GETSTLGRD = this.getDao("mesdao").find("NIG020620_02.select", paramB);
        String stlgrd = null;
        if (GETSTLGRD.hasNext()){
        	PosRow stlROW = GETSTLGRD.next();
        	stlgrd = (String)stlROW.getAttribute("STL_GRD");
        }
        */
        
		PosParameter param0 = new PosParameter();
        PosParameter param1 = new PosParameter();
        
//      用电文接收的数据项修改 RH炉实绩表 tbg02_rh_result
        param0.setWhereClauseParameter(0, MSG_CHRGE_NO);
        PosRowSet rowset0 = this.getDao("mesdao").find("NIG020620_01.select", param0);
        
         
        if(rowset0.hasNext())
        {
            
        	param1.setValueParamter(0,MSG_PLAN_CHARGE_NO);	 
        	param1.setValueParamter(1,MSG_RSV_DATE.substring(0,8)  ); 					
        	param1.setValueParamter(2,MSG_CAST_NO            ); 			         
        	param1.setValueParamter(3,MSG_CAST_EDT_CHARGE_CNT); 				       
        	param1.setValueParamter(4,MSG_CAST_CHARGE_SEQ    ); 			         
        	param1.setValueParamter(5,MSG_CAST_END_YN        ); 							 
        	param1.setValueParamter(6,MSG_CC_DEVNO           ); 	
         	param1.setValueParamter(7,MSG_STLMELT_WGT  ); 	
         	param1.setValueParamter(8,MSG_STLMELT_TEMP ); 						         
        	param1.setValueParamter(9,MSG_CC_END_STLMELT_USE_WGT            ); 
        	param1.setValueParamter(10,MSG_REM_WGT_IN_LD                     );
        	param1.setValueParamter(11,MSG_REM_WGT_IN_TD                     );
         	param1.setValueParamter(12,MSG_CC_YIELD                          );
        	param1.setValueParamter(13,MSG_CC_SPEED_AVG1                     );
        	param1.setValueParamter(14,MSG_CC_SPEED_MIN1                     );
        	param1.setValueParamter(15,MSG_CC_SPEED_MAX1                     );
        	param1.setValueParamter(16,MSG_CC_SPEED_AVG2                     );
         	param1.setValueParamter(17,MSG_CC_SPEED_MIN2                     );
        	param1.setValueParamter(18,MSG_CC_SPEED_MAX2                     );
        	param1.setValueParamter(19,MSG_TD_TEMP_AVG                       );
         	param1.setValueParamter(20,MSG_TD_TEMP_MIN                       );
        	param1.setValueParamter(21,MSG_TD_TEMP_MAX                       );
        	param1.setValueParamter(22,MSG_LD_OPEN_YN                        );
        	param1.setValueParamter(23,MSG_MD_LVL1                           );
         	param1.setValueParamter(24,MSG_MD_UPPER_WTH1                     );
        	param1.setValueParamter(25,MSG_MD_LOWER_WTH1                     );
        	param1.setValueParamter(26,MSG_MD_VIBRATE_CNT1                   );
        	param1.setValueParamter(27,MSG_MD_VIBRATE_WTH1                   );
        	param1.setValueParamter(28,MSG_MD_LVL2                           );
         	param1.setValueParamter(29,MSG_MD_UPPER_WTH2                     );
        	param1.setValueParamter(30,MSG_MD_LOWER_WTH2                     );
        	param1.setValueParamter(31,MSG_MD_VIBRATE_CNT2                   );
        	param1.setValueParamter(32,MSG_MD_VIBRATE_WTH2                   );
         	param1.setValueParamter(33,MSG_COOLWAT_WGT                       );
        	param1.setValueParamter(34,MSG_LD_ARRV_DTIME                     );
        	param1.setValueParamter(35,MSG_CC_STA_DTIME                      );
        	param1.setValueParamter(36,MSG_LD_OPEN_DTIME                     );
         	param1.setValueParamter(37,MSG_LD_CLOSE_DTIME                    );
        	param1.setValueParamter(38,MSG_CC_END_DTIME                      );
        	param1.setValueParamter(39,MSG_CC_HOUR                           );
        	param1.setValueParamter(40,MSG_SLAB_TOTLEN                       );
         	param1.setValueParamter(41,MSG_SLAB_PROD_CNT                     );
         	param1.setValueParamter(42,MSG_SLAB_TOTWGT                       );
         	param1.setValueParamter(43,sShift                                );
         	param1.setValueParamter(44,sGroup                                );  
        	param1.setValueParamter(45,MSG_CHRGE_NO                          );
         	
        	this.getDao("mesdao").update("NIG020620_CCM.update",param1);
        	//获取原料浇次信息便于静态报表数据统计 20190525wl
        	this.getDao("mesdao").update("NIG020620_REPORTCCM.update",param1);
        }
        else
        {
        	 
        	param1.setValueParamter(0,MSG_CHRGE_NO);                                                                           
        	param1.setValueParamter(1,MSG_PLAN_CHARGE_NO);		                                                          
        	param1.setValueParamter(2,MSG_RSV_DATE.substring(0,8)  ); 						                                                        
        	param1.setValueParamter(3,MSG_CAST_NO            ); 			                                                        
        	param1.setValueParamter(4,MSG_CAST_EDT_CHARGE_CNT); 				                                                          
        	param1.setValueParamter(5,MSG_CAST_CHARGE_SEQ    ); 			                                                        
        	param1.setValueParamter(6,MSG_CAST_END_YN        ); 							                                                      
        	param1.setValueParamter(7,MSG_CC_DEVNO           ); 			                                                        
        	param1.setValueParamter(8,MSG_STLMELT_WGT  ); 						                                                        
        	param1.setValueParamter(9,MSG_STLMELT_TEMP ); 						                                                        
        	param1.setValueParamter(10,MSG_CC_END_STLMELT_USE_WGT            ); 						                                                      
        	param1.setValueParamter(11,MSG_REM_WGT_IN_LD                     ); 		                                                      
        	param1.setValueParamter(12,MSG_REM_WGT_IN_TD                     ); 		                                                      
        	param1.setValueParamter(13,MSG_CC_YIELD                          ); 		                                                      
        	param1.setValueParamter(14,MSG_CC_SPEED_AVG1                     ); 		                                                      
        	param1.setValueParamter(15,MSG_CC_SPEED_MIN1                     ); 			                                                       
        	param1.setValueParamter(16,MSG_CC_SPEED_MAX1                     ); 			                                                       
        	param1.setValueParamter(17,MSG_CC_SPEED_AVG2                     ); 		                                                       
        	param1.setValueParamter(18,MSG_CC_SPEED_MIN2                     ); 			                                                      
        	param1.setValueParamter(19,MSG_CC_SPEED_MAX2                     ); 			                                                      
        	param1.setValueParamter(20,MSG_TD_TEMP_AVG                       ); 		                                                      
        	param1.setValueParamter(21,MSG_TD_TEMP_MIN                       );                                                      
        	param1.setValueParamter(22,MSG_TD_TEMP_MAX                       ); 				                                                      
        	param1.setValueParamter(23,MSG_LD_OPEN_YN                        ); 				                                                      
        	param1.setValueParamter(24,MSG_MD_LVL1                           ); 			                                                      
        	param1.setValueParamter(25,MSG_MD_UPPER_WTH1                     ); 		                                                      
        	param1.setValueParamter(26,MSG_MD_LOWER_WTH1                     ); 	                                                      
        	param1.setValueParamter(27,MSG_MD_VIBRATE_CNT1                   ); 	                                                      
        	param1.setValueParamter(28,MSG_MD_VIBRATE_WTH1                   ); 			                                                      
        	param1.setValueParamter(29,MSG_MD_LVL2                           ); 				                                                      
        	param1.setValueParamter(30,MSG_MD_UPPER_WTH2                     ); 			                                                      
        	param1.setValueParamter(31,MSG_MD_LOWER_WTH2                     ); 				                                                      
        	param1.setValueParamter(32,MSG_MD_VIBRATE_CNT2                   ); 				                                                      
        	param1.setValueParamter(33,MSG_MD_VIBRATE_WTH2                   ); 				                                                      
        	param1.setValueParamter(34,MSG_COOLWAT_WGT                       ); 				                                                      
        	param1.setValueParamter(35,MSG_LD_ARRV_DTIME                     ); 			                                                      
        	param1.setValueParamter(36,MSG_CC_STA_DTIME                      ); 			                                                      
        	param1.setValueParamter(37,MSG_LD_OPEN_DTIME                     );			                                                      
        	param1.setValueParamter(38,MSG_LD_CLOSE_DTIME                    ); 			                                    
            param1.setValueParamter(39,MSG_CC_END_DTIME                      );
            param1.setValueParamter(40,MSG_CC_HOUR                           );
            param1.setValueParamter(41,MSG_SLAB_TOTLEN                       );
            param1.setValueParamter(42,MSG_SLAB_PROD_CNT                     );
            param1.setValueParamter(43,MSG_SLAB_TOTWGT                       );
            param1.setValueParamter(44,sShift                                );
            param1.setValueParamter(45,sGroup                                ); 
          	
        	this.getDao("mesdao").insert("NIG020620_CCM.insert",param1);
        	//获取原料浇次信息便于静态报表数据统计 20190525wl
        	this.getDao("mesdao").insert("NIG020620_REPORTCCM.insert",param1);
        
        }
        
        PosParameter param6 = new PosParameter();  
        param6.setValueParamter(0, MSG_CC_DEVNO  );
        param6.setValueParamter(1, MSG_CC_STA_DTIME  );
        param6.setValueParamter(2, MSG_CC_END_DTIME  );
    	param6.setValueParamter(3, MSG_CHRGE_NO  );
    	
    	this.getDao("mesdao").update("NIG020620_CHARGE_COMM.update", param6);
       
	 
	    
		return PosBizControlConstants.SUCCESS;
	}
	
	 

}