package xin.glue.ui.H.H04;
import xin.glue.ui.common.PosGridSave;
//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.15
 */
public class PosSaveRollWait extends PosActivity{
	public String runActivity(PosContext context)
	{
//		从页面获取数据供插入和更新使用
		String[] status = (String[]) context.get("rowStuts");
		
		//上部轧辊号
		String[] topRollNo = (String[]) context.get("topRollNo");
		//上部轧辊类型
		String[] topRollType = (String[]) context.get("topRollType");
		//上部轧辊传动侧轴承座
		String[] topRollWork = (String[]) context.get("topRollWork");
		//上部轧辊的操作侧轴承座
		String[] topRollDirver = (String[]) context.get("topRollDirver");
		
		//下部轧辊号
		String[] RollNo = (String[]) context.get("RollNo");
		//下部轧辊类型
		String[] RollType = (String[]) context.get("RollType");
		//下部轧辊传动侧轴承座
		String[] RollWork = (String[]) context.get("RollWork");
		//下部轧辊的操作侧轴承座
		String[] RollDriver = (String[]) context.get("RollDriver");
		
		//机架号信息
		String[] MILL_MCH_CLF = (String[]) context.get("MILL_MCH_CLF");
		
		//这里先对两个轧辊号进行验证，再进行相关的操作。避免轧辊号不存在的情况
		PosParameter param0 = new PosParameter();
		param0.setWhereClauseParameter(0, topRollNo[0]);
		
		String sql = "select ROLL_NO from tbh04_roll where ROLL_NO = ?";
		
		PosRowSet rowset1 = getDao("mesdao").findByQueryStatement(sql, param0);
		
		PosParameter param3 = new PosParameter();
		param3.setWhereClauseParameter(0, RollNo[0]);
		
		String sql1 = "select ROLL_NO from tbh04_roll where ROLL_NO = ?";
		
		PosRowSet rowset2 = getDao("mesdao").findByQueryStatement(sql1, param3);

		//如果上部轧辊的值存在就更新
		if(rowset1.hasNext() && rowset2.hasNext()){
			PosParameter param1 = new PosParameter();
			//更新
			param1.setWhereClauseParameter(0, topRollType[0]);
			param1.setWhereClauseParameter(1, topRollDirver[0]);
			param1.setWhereClauseParameter(2, topRollWork[0]);
			param1.setWhereClauseParameter(3, RollNo[0]); 
			param1.setWhereClauseParameter(4, "T"); 
			param1.setWhereClauseParameter(5, topRollNo[0]);
	
			getDao("mesdao").update("UIH040020_01.update", param1);
			
			//打印日志 
//			if (PosSiteConfig.writeLog)
//				PosSiteLog.writeLog(context, getDao("mesdao"),"UIH040020_01.update", param1.getWhereClauseParamters());
//			
//			轧辊号不存在的情况，说明这个轧辊根本就不存在于仓库中，要在前台给予异常提示。不能进行插入操作。
			//先处理磨削等待的界面，回头再来处理装配的界面
			
//			PosParameter param1 = new PosParameter();
//			param1.setValueParamter(0, topRollNo[0]);
//			param1.setValueParamter(1, topRollType[0]);
//			param1.setValueParamter(2, topRollWork[0]);
//			param1.setValueParamter(3, topRollDirver[0]);
//			param1.setValueParamter(4, RollNo[0]);
//			param1.setValueParamter(5, MILL_MCH_CLF[0]);
//			
//			getDao("mesdao").insert("UIH040020_01.insert", param1);
			
//			打印日志 
//			if (PosSiteConfig.writeLog)
//				PosSiteLog.writeLog(context, getDao("mesdao"),"UIH040020_01.insert", param1.getWhereClauseParamters());


			PosParameter param4 = new PosParameter();
			//更新
			param4.setWhereClauseParameter(0, RollType[0]);
			param4.setWhereClauseParameter(1, RollDriver[0]);
			param4.setWhereClauseParameter(2, topRollWork[0]);
			param4.setWhereClauseParameter(3, topRollNo[0]); 
			param4.setWhereClauseParameter(4, "B"); 
			param4.setWhereClauseParameter(5, RollNo[0]);
	
			getDao("mesdao").update("UIH040020_02.update", param4);
			
//				打印日志 
//			if (PosSiteConfig.writeLog)
//				PosSiteLog.writeLog(context, getDao("mesdao"),"UIH040020_02.update", param4.getWhereClauseParamters());
//			
			//新增
//			PosParameter param4 = new PosParameter();
//			param4.setValueParamter(0, RollNo[0]);
//			param4.setValueParamter(1, RollType[0]);
//			param4.setValueParamter(2, RollWork[0]);
//			param4.setValueParamter(3, RollDriver[0]);
//			param4.setValueParamter(4, topRollNo[0]);
//			param4.setValueParamter(5, MILL_MCH_CLF[0]);
//				
//			getDao("mesdao").insert("UIH040020_02.insert", param4);
//				
//			打印日志 
//			if (PosSiteConfig.writeLog)
//				PosSiteLog.writeLog(context, getDao("mesdao"),"UIH040020_02.insert", param4.getWhereClauseParamters());
			
			}else{
				
			//这里抛出异常，给予提示信息
			logger.logDebug("PosSaveRollWait 输入的轧辊号在轧辊表 TBH04_ROLL 中不存在！ ");
			String vtemp="topRollNo";
			context.put("rs", vtemp);
		}
		
		return PosBizControlConstants.SUCCESS;
	}

}