package xin.glue.ui.H.H04;

//import xin.glue.ui.common.component.PosSiteConfig;
import xin.glue.ui.common.component.PosSiteLog;

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 TangLiang 唐亮
 * @data 2008.10.08
 */
public class PosSaveRollResult extends PosActivity{
	
	public String runActivity(PosContext context)
		{
			//从页面获取数据供插入和更新使用
			String[] status = (String[]) context.get("rowStuts");
			
			//辊号
			String[] ROLL_NO = (String[]) context.get("ROLL_NO");
			//类别
			String[] ROLL_TYPE = (String[]) context.get("ROLL_TYPE");
			//厂家标志
			
		 	
			String[] ROLL_MAKER = (String[]) context.get("ROLL_MAKER");
			//单价
			String[] ROLL_UCOST = (String[]) context.get("ROLL_UCOST");
			//入库直径
			String[] ENT_DIA = (String[]) context.get("ENT_DIA");
			//废气直径
			String[] DISUSE_DIA = (String[]) context.get("DISUSE_DIA");
			//长度
			String[] ROLL_LEN = (String[]) context.get("ROLL_LEN");
			//入库时间
			String[] ENT_DTIME = (String[]) context.get("ENT_DTIME");
			//班次
			String[] ENT_ROLL_WKSHIFT = (String[]) context.get("ENT_ROLL_WKSHIFT");
			//组
			String[] ENT_ROLL_WKSGROUP = (String[]) context.get("ENT_ROLL_WKSGROUP");
			//录入人
			String[] ROLL_ENT_EMP_ID = (String[]) context.get("ROLL_ENT_EMP_ID");
			//材质
			String[] ROLL_MAT_QLTY = (String[]) context.get("ROLL_MAT_QLTY");
			//超声波探伤
			String[] SONIC_SIGHT = (String[]) context.get("SONIC_SIGHT");
			//表面质量
			String[] SURFACE_TREAT_TYPE = (String[]) context.get("SURFACE_TREAT_TYPE");
			//尺寸公差
			String[] LEN_TOL = (String[]) context.get("LEN_TOL");
			//辊型
			String[] ROLL_SHAPE_CD = (String[]) context.get("ROLL_SHAPE_CD");
			
			if (ROLL_TYPE[0].equals("JWR") || ROLL_TYPE[0].equals("ZWR") || ROLL_TYPE[0].equals("SWR") || ROLL_TYPE[0].equals("SWR")) {
				
				ROLL_TYPE[0] = "WKR";
			}
			if (ROLL_TYPE[0].equals("JBR") ) {
				ROLL_TYPE[0] = "BUR";
			}
			
			//通过传入的辊号在表中查询结果是否存在,如果存在就更新否则就新增
			PosParameter param0 = new PosParameter();
			param0.setWhereClauseParameter(0, ROLL_NO[0]);
			
			String sql = "select ROLL_NO from tbh04_roll where ROLL_NO = ?";
			
			PosRowSet rowset1 = getDao("mesdao").findByQueryStatement(sql, param0);
			//如果值存在就更新
			if(rowset1.hasNext()){
				PosParameter param1 = new PosParameter();

				//更新
				param1.setWhereClauseParameter(0, ROLL_TYPE[0]);
				param1.setWhereClauseParameter(1, ROLL_MAKER[0]);
				param1.setWhereClauseParameter(2, ROLL_UCOST[0]);
				param1.setWhereClauseParameter(3, ENT_DIA[0]);
				param1.setWhereClauseParameter(4, DISUSE_DIA[0]);
				param1.setWhereClauseParameter(5, ROLL_LEN[0]);
				param1.setWhereClauseParameter(6, ENT_DTIME[0]);
				param1.setWhereClauseParameter(7, ENT_ROLL_WKSHIFT[0]);
				param1.setWhereClauseParameter(8, ENT_ROLL_WKSGROUP[0]);
				param1.setWhereClauseParameter(9, ROLL_ENT_EMP_ID[0]);
				param1.setWhereClauseParameter(10, ROLL_MAT_QLTY[0]);
				param1.setWhereClauseParameter(11, SONIC_SIGHT[0]);
				param1.setWhereClauseParameter(12, SURFACE_TREAT_TYPE[0]);
				param1.setWhereClauseParameter(13, LEN_TOL[0]);
				param1.setWhereClauseParameter(14, ROLL_SHAPE_CD[0]);
				param1.setWhereClauseParameter(15, ENT_DIA[0]);
				param1.setWhereClauseParameter(16, ENT_DIA[0]);
				param1.setWhereClauseParameter(17, ROLL_NO[0]);

				getDao("mesdao").update("UIH040010_01.update", param1);
				
				//打印日志 
//				if (PosSiteConfig.writeLog)
//					PosSiteLog.writeLog(context, getDao("mesdao"),"UIH040010_01.update", param1.getWhereClauseParamters());
//				
			}else{
				PosParameter param2 = new PosParameter();
				
				//插入
				param2.setValueParamter(0, ROLL_NO[0]);
				param2.setValueParamter(1, ROLL_TYPE[0]);
				param2.setValueParamter(2, ROLL_MAKER[0]);
				param2.setValueParamter(3, ROLL_UCOST[0]);
				param2.setValueParamter(4, ENT_DIA[0]);
				param2.setValueParamter(5, DISUSE_DIA[0]);
				param2.setValueParamter(6, ROLL_LEN[0]);
				param2.setValueParamter(7, ENT_DTIME[0]);
				param2.setValueParamter(8, ENT_ROLL_WKSHIFT[0]);
				param2.setValueParamter(9, ENT_ROLL_WKSGROUP[0]);
				param2.setValueParamter(10, ROLL_ENT_EMP_ID[0]);
				param2.setValueParamter(11, ROLL_MAT_QLTY[0]);
				param2.setValueParamter(12, SONIC_SIGHT[0]);
				param2.setValueParamter(13, SURFACE_TREAT_TYPE[0]);
				param2.setValueParamter(14, LEN_TOL[0]);
				param2.setValueParamter(15, ROLL_SHAPE_CD[0]);
				param2.setValueParamter(16, ENT_DIA[0]);
				param2.setValueParamter(17, ENT_DIA[0]);
				
				getDao("mesdao").insert("UIH040010_01.insert", param2);
							
			}
			return PosBizControlConstants.SUCCESS;
		}
}