package xin.glue.ui.G.G01;

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.PosGenericDao;
import com.posdata.glue.dao.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRowSet;

/*
 * 铸造操作标准登录与查询
 * @author 王小炎
 * @data 2008.08.20
 */

public class PosSaveStlGrdList extends PosActivity{

	public String runActivity(PosContext ctx) {
//		1. Get DAO Class
        PosGenericDao dao = this.getDao("mesdao");
        
        PosParameter param = new PosParameter();
        PosParameter param1 = new PosParameter();
        //2. Get Parameter 
        //钢号
        String [] STL_GRD = (String [])ctx.get("STL_GRD"); 
        //最小浇铸速度
        String [] CCM_SPEED_MIN = (String [])ctx.get("CCM_SPEED_MIN");
        //最大浇铸速度
        String [] CCM_SPEED_MAX = (String [])ctx.get("CCM_SPEED_MAX");
        //目标浇铸速度
        String [] CCM_SPEED_AVG = (String [])ctx.get("CCM_SPEED_AVG");
        //凝固温度1
        String [] SOLIDE_TEMP = (String [])ctx.get("SOLIDE_TEMP");
        //最小中间包温度
        String [] TD_TEMP_MIN = (String [])ctx.get("TD_TEMP_MIN");
        //最大中间包温度
        String [] TD_TEMP_MAX = (String [])ctx.get("TD_TEMP_MAX");
        //目标中间包温度
        String [] TD_TEMP_AVG = (String [])ctx.get("TD_TEMP_AVG");
        //最小结晶器1 宽度
        String [] MD_WTH_MIN = (String [])ctx.get("MD_WTH_MIN");
        //最大结晶器1 宽度
        String [] MD_WTH_MAX = (String [])ctx.get("MD_WTH_MAX");
        
        if (STL_GRD != null) 
        {
          //3. Bind Parameter 从成分获取钢号
          param1.setWhereClauseParameter(0,STL_GRD[0]); 
          //4. Execute  在TBG01_OPRN_STD是否存在钢号
          PosRowSet rowset1 = dao.findByQueryStatement("select * from TBG01_OPRN_STD where stl_grd = ?",param1);

	        if (rowset1.hasNext()) 
	        {
	          //3. Bind Parameter
	          param.setWhereClauseParameter(0,CCM_SPEED_MIN[0]); 
	          param.setWhereClauseParameter(1,CCM_SPEED_MAX[0]); 
	          param.setWhereClauseParameter(2,CCM_SPEED_AVG[0]); 
	          param.setWhereClauseParameter(3,SOLIDE_TEMP[0]); 
	          param.setWhereClauseParameter(4,TD_TEMP_MIN[0]); 
	          param.setWhereClauseParameter(5,TD_TEMP_MAX[0]); 
	          param.setWhereClauseParameter(6,TD_TEMP_AVG[0]); 
	          param.setWhereClauseParameter(7,MD_WTH_MIN[0]);
	          param.setWhereClauseParameter(8,MD_WTH_MAX[0]);
	          param.setWhereClauseParameter(9, STL_GRD[0]);
	          
	          //4. Execute 
	          dao.update("UIG010020_01.update",param);
	          //5. Save Result
	          //ctx.put("Result",rowset);
	        }else{
	            //3. Bind Parameter
	        	 param.setWhereClauseParameter(0,STL_GRD[0]);
	             param.setWhereClauseParameter(1,CCM_SPEED_MIN[0]); 
	             param.setWhereClauseParameter(2,CCM_SPEED_MAX[0]); 
	             param.setWhereClauseParameter(3,CCM_SPEED_AVG[0]); 
	             param.setWhereClauseParameter(4,SOLIDE_TEMP[0]); 
	             param.setWhereClauseParameter(5,TD_TEMP_MIN[0]); 
	             param.setWhereClauseParameter(6,TD_TEMP_MAX[0]); 
	             param.setWhereClauseParameter(7,TD_TEMP_AVG[0]); 
	             param.setWhereClauseParameter(8,MD_WTH_MIN[0]);
	             param.setWhereClauseParameter(9,MD_WTH_MAX[0]);
	        	//4. Execute 
	            dao.insert("UIG010020_01.insert",param);
	            //5. Save Result
	            //ctx.put("Result",rowset);
	        	}
        	}
        return PosBizControlConstants.SUCCESS;
	}
}