package xin.glue.ui.B.B01;

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

/**
 * 
 * @Description  增加或修改时使用{界面ID:UIB010191}
 * @author       梅贵平{meiguiping}
 * @date         2009-3-2 下午02:33:00
 * @JDK Version  jdk1.4.2
 */
public class SaveDefConvQlty extends PosActivity
{

	public String runActivity(PosContext context)
	{

		PosParameter	param	=	null;
		PosGenericDao	dao		=	this.getDao("mesdao");
		PosRowSet		rowset	=	null;
		///insert
		String[]PRDNM_CD		=	(String[])context.get("PRDNM_CD");//品名
		String[]SPEC_ABBSYM		=	(String[])context.get("SPEC_ABBSYM");//标准号
		String[]QLTYX			=	(String[])context.get("QLTYX");
		System.out.println("@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@");
		if(PRDNM_CD != null)
		{
			int	len	=	QLTYX.length;
			String	qq	=	"";//保存材质代码
			String	ss	=	"";//保存smp_lot_cd
			
			for(int i = 0; i < len; i++)
			{
				System.out.println("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!  "+QLTYX[i]);	
				qq	=	QLTYX[i].split("\\|")[0];
				if(ss != null && !"".equals(ss))//SMP_LOT_CD值不允许为空
				{
					ss	=	QLTYX[i].split("\\|")[1];
					param	=	new PosParameter();
					param.setValueParamter(0, PRDNM_CD[0]);//品名
					param.setValueParamter(1, SPEC_ABBSYM[0]);//标准号
					param.setValueParamter(2, qq);//材质代码
					param.setValueParamter(3, ss);//取样代码
					dao.insert("UIB010191_01.INSERT", param);
				}
			}
		}
		
		///updae
		String[]	PRDNMCD		=	(String[])context.get("PRDNMCD");//交货状态
		String[]	SPECABBSYM	=	(String[])context.get("SPECABBSYM");//标准号
		String[]	LOC			=	(String[])context.get("LOC");//材质项目
		
		if(PRDNMCD == null)
			return PosBizControlConstants.SUCCESS;
		
		int	len	=	PRDNMCD.length;
		String	qltyCD	=	"";
		String	smpLot	=	"";
		
		for(int i = 0; i < len; i++)
		{
			qltyCD	=	LOC[i].split("\\|")[0];//材质代码
			smpLot	=	LOC[i].split("\\|")[1];//取样方式
			System.out.println("########################################   "+i+"     "+qltyCD);
			System.out.println("########################################   "+i+"     "+smpLot);
			param	=	new PosParameter();
			param.setWhereClauseParameter(0, PRDNMCD[i]);
			param.setWhereClauseParameter(1, SPECABBSYM[i]);
			param.setWhereClauseParameter(2, qltyCD);
			rowset	=	dao.find("UIB010191_05.SELECT", param);
			if(rowset.count()==0 && !"".equals(smpLot))//insert
			{
				param	=	new PosParameter();
				param.setValueParamter(0, PRDNMCD[i]);
				param.setValueParamter(1, SPECABBSYM[i]);
				param.setValueParamter(2, qltyCD);
				param.setValueParamter(3, smpLot);
				dao.insert("UIB010191_01.INSERT", param);
			}
			if(rowset.count()!= 0 && !"".equals(smpLot))//update
			{
				param	=	new PosParameter();
				param.setWhereClauseParameter(0, smpLot);
				param.setWhereClauseParameter(1, PRDNMCD[i]);
				param.setWhereClauseParameter(2, SPECABBSYM[i]);
				param.setWhereClauseParameter(3, qltyCD);
				dao.update("UIB010191_01.UPDATE" , param);
			}
			if(rowset.count()!= 0 && "".equals(smpLot))//delete
			{
				param	=	new PosParameter();
				param.setValueParamter(0, PRDNMCD[i]);
				param.setValueParamter(1, SPECABBSYM[i]);
				param.setValueParamter(2, qltyCD);
				dao.delete("UIB010191_01.DELETE", param);
			}
		}
		
		return PosBizControlConstants.SUCCESS;
	}
}