XinYu_RZMES/.svn/pristine/4a/4a3bc397df1e4f4d12d724f17435db04c05353cb.svn-base

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-11-12
 * 由于需要把母钢卷的编号一分为二，并且改变母钢卷和子钢卷的信息，
 * 所以自己写一个类已便于操作
 * desc:SPM实绩登录与查询
 */

public class SaveCoilNo extends PosActivity{
	public String runActivity(PosContext context)
	{
//		从页面获取参数数据，供更新页面使用
		String[] status2 = (String[]) context.get("rowStuts2");
		String[] status4 = (String[]) context.get("rowStuts4");
		//钢卷号
		String[] coilNo = (String[])context.get("COIL_NO");
		//批次号
		String[] OLD_SAMPL_NO = (String[])context.get("OLD_SAMPL_NO");
		//钢卷分割号1
		String CUT_NO1 = "1";
		//钢卷分割号2
		String CUT_NO2 = "2";
//		钢卷厚度
		String[] coilThk = (String[])context.get("COIL_THK");
//		钢卷宽度
		String[] coilWth = (String[])context.get("COIL_WTH");
//		钢卷外径
		String[] coilOutDia= (String[])context.get("COIL_OUTDIA");
//		钢卷重量
		String[] actWgt= (String[])context.get("ACT_WGT");
//		取样採取有无
		String[] samplPickYn= (String[])context.get("SAMPL_PICK_YN");
//		瑕疵代码1
		String[] crkCd1= (String[])context.get("CRK_CD1");
//		瑕疵代码2
		String[] crkCd2= (String[])context.get("CRK_CD2");
//		瑕疵代码3
		String[] crkCd3= (String[])context.get("CRK_CD3");
//		瑕疵代码4
		String[] crkCd4= (String[])context.get("CRK_CD4");
//		余材区分
		String[] ordFl= (String[])context.get("ORD_FL");
//		班次
		String[] SPM_SHIFT= (String[])context.get("SPM_SHIFT");
//		组次
		String[] SPM_GROUP= (String[])context.get("SPM_GROUP");
//		作业人
		String[] SPM_EMP_ID= (String[])context.get("SPM_EMP_ID");
		//子钢卷的堆放地址
		String[] CUR_LOAD_LOC= (String[])context.get("CUR_LOAD_LOC");
		
		//循环获得的发送接点里信息的行数，一行一行插入
		for(int i=0;i<status2.length;i++){
			if(status2[i].equals("u")){
				//先插入新生成的钢卷信息，再改变原来的母钢卷状态
				PosParameter param0 = new PosParameter();
				//这里钢卷号的最后一位是用来标识分卷的。0为母卷、1、2为分开的子卷
				param0.setValueParamter(0, coilNo[0].substring(0, coilNo[0].length()-1)+CUT_NO1);
				param0.setValueParamter(1, coilThk[0]);
				param0.setValueParamter(2, coilWth[0]);
				param0.setValueParamter(3, coilOutDia[0]);
				param0.setValueParamter(4, actWgt[0]);
				param0.setValueParamter(5, samplPickYn[0]);
				param0.setValueParamter(6, crkCd1[0]);
				param0.setValueParamter(7, crkCd2[0]);
				param0.setValueParamter(8, crkCd3[0]);
				param0.setValueParamter(9, crkCd4[0]);
				param0.setValueParamter(10, ordFl[0]);
				param0.setValueParamter(11, SPM_SHIFT[0]);
				param0.setValueParamter(12, SPM_GROUP[0]);
				param0.setValueParamter(13, SPM_EMP_ID[0]);
				param0.setValueParamter(14, CUR_LOAD_LOC[i]);
				param0.setValueParamter(15, OLD_SAMPL_NO[0].substring(0, OLD_SAMPL_NO[0].length()-1)+CUT_NO1);
				
				getDao("mesdao").insert("UIH020080_01.insert", param0);
				
	//			打印日志 
//				if (PosSiteConfig.writeLog)
//					PosSiteLog.writeLog(context, getDao("mesdao"),"UIH020080_01.insert", param0.getValueParameters());
			}else if(status2[i].equals("i")){
				//插入分卷的第二条信息
				PosParameter param1 = new PosParameter();
//				这里钢卷号的最后一位是用来标识分卷的。0为母卷、1、2为分开的子卷
				param1.setValueParamter(0, coilNo[0].substring(0, coilNo[0].length()-1)+CUT_NO2);
				param1.setValueParamter(1, coilThk[0]);
				param1.setValueParamter(2, coilWth[0]);
				param1.setValueParamter(3, coilOutDia[0]);
				param1.setValueParamter(4, actWgt[0]);
				param1.setValueParamter(5, samplPickYn[0]);
				param1.setValueParamter(6, crkCd1[0]);
				param1.setValueParamter(7, crkCd2[0]);
				param1.setValueParamter(8, crkCd3[0]);
				param1.setValueParamter(9, crkCd4[0]);
				param1.setValueParamter(10, ordFl[0]);
				param1.setValueParamter(11, SPM_SHIFT[0]);
				param1.setValueParamter(12, SPM_GROUP[0]);
				param1.setValueParamter(13, SPM_EMP_ID[0]);
				param1.setValueParamter(14, CUR_LOAD_LOC[i]);
				param1.setValueParamter(15, OLD_SAMPL_NO[0].substring(0, OLD_SAMPL_NO[0].length()-1)+CUT_NO2);
				
				getDao("mesdao").insert("UIH020080_01.insert", param1);
				
		//			打印日志 
//				if (PosSiteConfig.writeLog)
//					PosSiteLog.writeLog(context, getDao("mesdao"),"UIH020080_01.insert", param1.getValueParameters());
				}else{
				//这里的钢卷号位数为13，分卷后位数为14。不能写入数据库
				//已经解决
				logger.logInfo(" 平整分卷出现异常情况，UIH020080！ ");
			}
		}
		
		//更新母卷信息
		PosParameter param2 = new PosParameter();
		
		param2.setWhereClauseParameter(0, coilThk[0]);
		param2.setWhereClauseParameter(1, coilWth[0]);
		param2.setWhereClauseParameter(2, coilOutDia[0]);
		param2.setWhereClauseParameter(3, actWgt[0]);
		param2.setWhereClauseParameter(4, samplPickYn[0]);
		param2.setWhereClauseParameter(5, crkCd1[0]);
		param2.setWhereClauseParameter(6, crkCd2[0]);
		param2.setWhereClauseParameter(7, crkCd3[0]);
		param2.setWhereClauseParameter(8, crkCd4[0]);
		param2.setWhereClauseParameter(9, ordFl[0]);
		param2.setWhereClauseParameter(10, SPM_SHIFT[0]);
		param2.setWhereClauseParameter(11, SPM_GROUP[0]);
		param2.setWhereClauseParameter(12, SPM_EMP_ID[0]);
		//母卷的话就使用自身的钢卷号就可以了。
		param2.setWhereClauseParameter(13, coilNo[0]);
		param2.setWhereClauseParameter(14, OLD_SAMPL_NO[0]);
		
		getDao("mesdao").update("UIH020080_01.update", param2);
		
//		打印日志 
//		if (PosSiteConfig.writeLog)
//			PosSiteLog.writeLog(context, getDao("mesdao"),"UIH020080_01.update", param2.getWhereClauseParamters());
//		
		return PosBizControlConstants.SUCCESS;
	}
}