XinYu_RZMES/.svn/pristine/3b/3b526ac067bd8e5d5ae8816c91662e79081a121d.svn-base

package xin.glue.ui.G.G01;

import java.util.HashMap;

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.PosRowSet;

/*
 * 炼钢操作标准登录与查询
 * @author 王小炎
 * @data 2008.08.20
 * @desc 炼钢操作相关标准 温度 时间的 维护
 */
public class PosSaveChargeStandard extends PosActivity
{
	public String runActivity(PosContext context)
	{
//		从页面获取参数数据，供更新页面使用
		String[] status = (String[]) context.get("status");
		
		String[] stl_grd = (String[])context.get("STL_GRD");
		String[] iron_temp_min = (String[])context.get("IRON_TEMP_MIN");
		String[] iron_temp_max = (String[])context.get("IRON_TEMP_MAX");
		String[] bof_sta_temp_min = (String[])context.get("BOF_STA_TEMP_MIN");
		String[] bof_sta_temp_max = (String[])context.get("BOF_STA_TEMP_MAX");
		String[] cas_arrv_temp_min = (String[])context.get("CAS_ARRV_TEMP_MIN");
		String[] cas_arrv_temp_max = (String[])context.get("CAS_ARRV_TEMP_MAX");
		String[] cas_dep_temp_min = (String[])context.get("CAS_DEP_TEMP_MIN");
		String[] cas_dep_temp_max = (String[])context.get("CAS_DEP_TEMP_MAX");
		String[] rh_arrv_temp_min = (String[])context.get("RH_ARRV_TEMP_MIN");
		String[] rh_arrv_temp_max = (String[])context.get("RH_ARRV_TEMP_MAX");
		String[] rh_dep_temp_min = (String[])context.get("RH_DEP_TEMP_MIN");
		String[] rh_dep_temp_max = (String[])context.get("RH_DEP_TEMP_MAX");
		String[] lf_arrv_temp_min = (String[])context.get("LF_ARRV_TEMP_MIN");
		String[] lf_arrv_temp_max = (String[])context.get("LF_ARRV_TEMP_MAX");
		String[] lf_dep_temp_min = (String[])context.get("LF_DEP_TEMP_MIN");
		String[] lf_dep_temp_max = (String[])context.get("LF_DEP_TEMP_MAX");
		String[] kr_wk_hour_min = (String[])context.get("KR_WK_HOUR_MIN");
		String[] kr_wk_hour_max = (String[])context.get("KR_WK_HOUR_MAX");
		String[] bof_wk_hour_min = (String[])context.get("BOF_WK_HOUR_MIN");
		String[] bof_wk_hour_max = (String[])context.get("BOF_WK_HOUR_MAX");
		String[]cas_wk_hour_min = (String[])context.get("CAS_WK_HOUR_MIN");
		String[]cas_wk_hour_max = (String[])context.get("CAS_WK_HOUR_MAX");
		String[]rh_wk_hour_min = (String[])context.get("RH_WK_HOUR_MIN");
		String[]rh_wk_hour_max = (String[])context.get("RH_WK_HOUR_MAX");
		String[]lf_wk_hour_min = (String[])context.get("LF_WK_HOUR_MIN");
		String[]lf_wk_hour_max = (String[])context.get("LF_WK_HOUR_MAX");
		String[]ton_per_charge = (String[])context.get("TON_PER_CHARGE");
		String[]ton_per_hour = (String[])context.get("TON_PER_HOUR");
		String[]yield = (String[])context.get("YIELD");
		
//		查询结果如果已经有值，则进行修改操作，否则插入
		String sql = "select * from tbg01_oprn_std where stl_grd = ?";
		PosParameter param0 = new PosParameter();
		param0.setWhereClauseParameter(0,stl_grd[0]);
		PosRowSet rowset0 = getDao("mesdao").findByQueryStatement(sql, param0);
		
		PosParameter param1 = new PosParameter();
		
		
		if(rowset0.hasNext())
		{
			param1.setWhereClauseParameter(0, iron_temp_min[0]);
			param1.setWhereClauseParameter(1, iron_temp_max[0]);
			param1.setWhereClauseParameter(2, bof_sta_temp_min[0]);
			param1.setWhereClauseParameter(3, bof_sta_temp_max[0]);
			param1.setWhereClauseParameter(4, cas_arrv_temp_min[0]);
			param1.setWhereClauseParameter(5, cas_arrv_temp_max[0]);
			param1.setWhereClauseParameter(6, cas_dep_temp_min[0]);
			param1.setWhereClauseParameter(7, cas_dep_temp_max[0]);
			param1.setWhereClauseParameter(8, rh_arrv_temp_min[0]);
			param1.setWhereClauseParameter(9, rh_arrv_temp_max[0]);
			param1.setWhereClauseParameter(10, rh_dep_temp_min[0]);
			param1.setWhereClauseParameter(11, rh_dep_temp_max[0]);
			param1.setWhereClauseParameter(12, lf_arrv_temp_min[0]);
			param1.setWhereClauseParameter(13, lf_arrv_temp_max[0]);
			param1.setWhereClauseParameter(14, lf_dep_temp_min[0]);
			param1.setWhereClauseParameter(15, lf_dep_temp_max[0]);
			param1.setWhereClauseParameter(16, kr_wk_hour_min[0]);
			param1.setWhereClauseParameter(17, kr_wk_hour_max[0]);
			param1.setWhereClauseParameter(18, bof_wk_hour_min[0]);
			param1.setWhereClauseParameter(19, bof_wk_hour_max[0]);
			param1.setWhereClauseParameter(20, cas_wk_hour_min[0]);
			param1.setWhereClauseParameter(21, cas_wk_hour_max[0]);
			param1.setWhereClauseParameter(22, rh_wk_hour_min[0]);
			param1.setWhereClauseParameter(23, rh_wk_hour_max[0]);
			param1.setWhereClauseParameter(24, lf_wk_hour_min[0]);
			param1.setWhereClauseParameter(25, lf_wk_hour_max[0]);
			param1.setWhereClauseParameter(26, ton_per_charge[0]);
			param1.setWhereClauseParameter(27, ton_per_hour[0]);
			param1.setWhereClauseParameter(28, yield[0]);
			param1.setWhereClauseParameter(29, stl_grd[0]);
			
			getDao("mesdao").update("UIG010010_01.update", param1);
		}
		else
		{
			param1.setValueParamter(0, iron_temp_min[0]);
			param1.setValueParamter(1, iron_temp_max[0]);
			param1.setValueParamter(2, bof_sta_temp_min[0]);
			param1.setValueParamter(3, bof_sta_temp_max[0]);
			param1.setValueParamter(4, cas_arrv_temp_min[0]);
			param1.setValueParamter(5, cas_arrv_temp_max[0]);
			param1.setValueParamter(6, cas_dep_temp_min[0]);
			param1.setValueParamter(7, cas_dep_temp_max[0]);
			param1.setValueParamter(8, rh_arrv_temp_min[0]);
			param1.setValueParamter(9, rh_arrv_temp_max[0]);
			param1.setValueParamter(10, rh_dep_temp_min[0]);
			param1.setValueParamter(11, rh_dep_temp_max[0]);
			param1.setValueParamter(12, lf_arrv_temp_min[0]);
			param1.setValueParamter(13, lf_arrv_temp_max[0]);
			param1.setValueParamter(14, lf_dep_temp_min[0]);
			param1.setValueParamter(15, lf_dep_temp_max[0]);
			param1.setValueParamter(16, kr_wk_hour_min[0]);
			param1.setValueParamter(17, kr_wk_hour_max[0]);
			param1.setValueParamter(18, bof_wk_hour_min[0]);
			param1.setValueParamter(19, bof_wk_hour_max[0]);
			param1.setValueParamter(20, cas_wk_hour_min[0]);
			param1.setValueParamter(21, cas_wk_hour_max[0]);
			param1.setValueParamter(22, rh_wk_hour_min[0]);
			param1.setValueParamter(23, rh_wk_hour_max[0]);
			param1.setValueParamter(24, lf_wk_hour_min[0]);
			param1.setValueParamter(25, lf_wk_hour_max[0]);
			param1.setValueParamter(26, ton_per_charge[0]);
			param1.setValueParamter(27, ton_per_hour[0]);
			param1.setValueParamter(28, yield[0]);
			param1.setValueParamter(29, stl_grd[0]);
			getDao("mesdao").insert("UIG010010_01.insert",param1);
		}
		return PosBizControlConstants.SUCCESS;
	}

}