XinYu_RZMES/.svn/pristine/7d/7d7566f308d160e3a6a17b910baf5197a3973d80.svn-base

package xin.glue.nui.H.H02;

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

import xin.glue.ui.common.PosDateFormat;

import com.posdata.glue.biz.activity.PosActivity;
import com.posdata.glue.biz.constants.PosBizControlConstants;
import com.posdata.glue.biz.control.PosBizControlIF;
import com.posdata.glue.biz.control.PosBizProvider;
import com.posdata.glue.component.PosConstants;
import com.posdata.glue.context.PosContext;
import com.posdata.glue.dao.PosGenericDao;
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.PosMESMessageImpl;
import com.posdata.glue.msg.PosMessage;

public class XinSaveRollDataReq extends PosActivity
{
  public String runActivity(PosContext context)
  {	
	logger.logInfo("XinSaveRollDataReq  START " ); 
	
	DateFormat formatter =  new SimpleDateFormat("yyyyMMddHHmmss");
	String currDate = formatter.format(new Date());
	  
	PosMessage message = context.getMessage();
 	  
	PosParameter param0 = new PosParameter(); ;
	PosRowSet rollDataVo = getDao("mesdao").find("NIH020110_01.select" );
    
	while(rollDataVo.hasNext())
	{
		PosRow rollDataROW           = rollDataVo.next();
		//配好的上部轧辊
		String TOP_ROLL_NO           =  (String)rollDataROW.getAttribute("ROLL_NO");
		//配好的下部轧辊
		String BOT_ROLL_NO           =  (String)rollDataROW.getAttribute("BOT_ROLL_NO");
		//机架号区分
		String MILL_CLF              =  (String)rollDataROW.getAttribute("MILL_MCH_CLF");
		//上部轧辊的当前直径
		String TOP_ROLL_DIA          =  (String)rollDataROW.getAttribute("TOP_ROLL_DIA");
		//下部轧辊的当前直径
		String BOT_ROLL_DIA          =  (String)rollDataROW.getAttribute("BOT_ROLL_DIA");
		//磨削时间有无标志，没有为0、有为1
		String GRIND_YN              =  (String)rollDataROW.getAttribute("GRIND_YN");
		//机架号
		String PLAN_STAND_NO         =  (String)rollDataROW.getAttribute("STAND_NO");
		//上部轧辊的轧辊等级
		String TOP_ROLL_GRD          =  (String)rollDataROW.getAttribute("TOP_ROLL_GRD");
		//上部轧辊的轧辊材质等级
		String TOP_ROLL_MAT_QLTY_GRD =  (String)rollDataROW.getAttribute("TOP_ROLL_MAT_QLTY_GRD");
		//上部轧辊的轧辊类别
		String TOP_ROLL_TYPE         =  (String)rollDataROW.getAttribute("TOP_ROLL_TYPE");
		//上部轧辊的表面粗糙度
		String TOP_SURFACE_ROUGH     =  (String)rollDataROW.getAttribute("TOP_SURFACE_ROUGH");
		//上部轧辊的形状代码
		String TOP_ROLL_SHAPE_CD     =  (String)rollDataROW.getAttribute("TOP_ROLL_SHAPE_CD");
		//上部轧辊的垫片厚度
		String TOP_SLIM_PLATE_THK    =  (String)rollDataROW.getAttribute("TOP_SLIM_PLATE_THK");
		//上部轧辊的表面硬度
		String TOP_SURFACE_HARD      =  (String)rollDataROW.getAttribute("TOP_SURFACE_HARD");
		//上部轧辊的表面处理类型
		String TOP_SURFACE_TREAT_TYPE=  (String)rollDataROW.getAttribute("TOP_SURFACE_TREAT_TYPE");
		//上部轧辊的花纹轧辊
		String TOP_ROLL_DECO         =  (String)rollDataROW.getAttribute("TOP_ROLL_DECO");
		//上部轧辊的轧钢材质
		String TOP_ROLL_MAT_QLTY     =  (String)rollDataROW.getAttribute("TOP_ROLL_MAT_QLTY");
        
		String PlanStandNo = null;
		if (PLAN_STAND_NO != null && !PLAN_STAND_NO.equals("")) {
			PLAN_STAND_NO.substring(1,2);
		}
		
		PosParameter param1 = new PosParameter();  
		param1.setWhereClauseParameter(0, "N");
		param1.setWhereClauseParameter(1, "4002");
		param1.setWhereClauseParameter(2, currDate);
		param1.setWhereClauseParameter(3, TOP_ROLL_NO);
	 	param1.setWhereClauseParameter(4, BOT_ROLL_NO);
	 	param1.setWhereClauseParameter(5, MILL_CLF);
		param1.setWhereClauseParameter(6, TOP_ROLL_DIA);
		param1.setWhereClauseParameter(7, BOT_ROLL_DIA);
		param1.setWhereClauseParameter(8, GRIND_YN);
		param1.setWhereClauseParameter(9, PlanStandNo);
		param1.setWhereClauseParameter(10,TOP_ROLL_GRD);
		param1.setWhereClauseParameter(11,TOP_ROLL_MAT_QLTY_GRD);
		param1.setWhereClauseParameter(12,TOP_ROLL_TYPE);
		param1.setWhereClauseParameter(13,TOP_SURFACE_ROUGH);
		param1.setWhereClauseParameter(14,TOP_ROLL_SHAPE_CD);
		param1.setWhereClauseParameter(15,TOP_SLIM_PLATE_THK);
		param1.setWhereClauseParameter(16,TOP_SURFACE_HARD);
		param1.setWhereClauseParameter(17,TOP_SURFACE_TREAT_TYPE);
		param1.setWhereClauseParameter(18,TOP_ROLL_DECO);
		param1.setWhereClauseParameter(19,TOP_ROLL_MAT_QLTY);
	 	
	    this.getDao("mesdao").update("NIH020110_01.insert", param1);
	}
	  
		return PosBizControlConstants.SUCCESS;
	}
	 
}