package xin.glue.ui.H.H02;

import java.math.BigDecimal;

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

/*
 * author:TangLiang 唐亮
 * date:2008-10-21
 * desc:COIL废钢处理登录与查询
 */

public class saveDisuseCoilNo extends PosActivity{

	public String runActivity(PosContext context)
	{
//		从页面获取参数数据，供更新页面使用
		//钢卷号,其实是批次号
		String[] coilNo = (String[])context.get("COIL_NO");
		//废钢处理重量
		String[] scrapWgt = (String[])context.get("SCRAP_WGT");
		//废钢处理原因
		String[] scrapCauseCd = (String[])context.get("SCRAP_CAUSE_CD");
		//废钢处理时间
		String[] scrapTreateDtime = (String[])context.get("SCRAP_TREATE_DTIME");
		//班次
		String[] scrapWkshift = (String[])context.get("SCRAP_WKSHIFT");
		//组
		String[] scrapWkgroup = (String[])context.get("SCRAP_WKGROUP");
		//废钢处理人
		String[] scrapEmpNo = (String[])context.get("SCRAP_EMP_NO");
		
//		查询结果如果已经有值，则进行修改操作，否则插入
		String sql = "select OLD_SAMPL_NO coil_no from tbh02_coil_comm where OLD_SAMPL_NO = ? ";
		PosParameter param0 = new PosParameter();
		param0.setWhereClauseParameter(0,coilNo[0] );
		
		PosRowSet rowset0 = getDao("mesdao").findByQueryStatement(sql, param0);
		
		if(rowset0.hasNext()){
			//更新操作
			PosParameter param1 = new PosParameter();
			
			param1.setWhereClauseParameter(0,scrapWgt[0]);
			param1.setWhereClauseParameter(1,scrapCauseCd[0]);
			param1.setWhereClauseParameter(2,scrapTreateDtime[0]);
			param1.setWhereClauseParameter(3,scrapWkshift[0]);
			param1.setWhereClauseParameter(4,scrapWkgroup[0]);
			param1.setWhereClauseParameter(5,scrapEmpNo[0]);
			param1.setWhereClauseParameter(6,coilNo[0]);
			
			getDao("mesdao").update("UIH020060_01.update", param1);
			
//			打印日志 
//			if (PosSiteConfig.writeLog)
//				PosSiteLog.writeLog(context, getDao("mesdao"),"UIH020060_01.update", param1.getWhereClauseParamters());
		}else{
			
//			PosParameter param1 = new PosParameter();
//			param1.setValueParamter(0, coilNo[0]);
//			param1.setValueParamter(1, scrapWgt[0]);
//			param1.setValueParamter(2, scrapCauseCd[0]);
//			param1.setValueParamter(3, scrapTreateDtime[0]);
//			param1.setValueParamter(4, scrapWkshift[0]);
//			param1.setValueParamter(5, scrapWkgroup[0]);
//			param1.setValueParamter(6, scrapEmpNo[0]);
//
//			getDao("mesdao").insert("UIH020060_01.insert",param1);
//			由于废钢不能新增钢卷，所以插入操作不能进行。钢卷必须是存在的。
			logger.logInfo("UIH020060里的钢卷信息必须是存在的才可以进行操作。");
			String vtemp="error";
			context.put("rs", vtemp);
		}	
		return PosBizControlConstants.SUCCESS;
	}
}