XinYu_RZMES/.svn/pristine/6f/6ffedffd106423ed15d8a4b0c1736ceefc0429d8.svn-base

package xin.glue.ui.B.B01;

import xin.glue.ui.B.common.SaveModifyHistory;

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

/**
 * 客户参数号事项操作(增、删、改，对应界面ID:UIB010250)
 * @author 梅贵平{meiguiping}
 * @date   2008-10-27
 */
public class SaveCustProceeding extends PosActivity
{

	PosGenericDao dao = this.getDao("mesdao");
	public String runActivity(PosContext context)
	{
		String	 INFID		   = "UIB010250";
		String[] CUST_SPEC_NO  	= 	(String[])context.get("CUST_SPEC_NO");//客户参数号(主键)
		String[] CUST_SPEC_NO1 	= 	(String[])context.get("CUST_SPEC_NO1");//客户参数号(主键)
		
		String[] CUST_SPEC_NO_INGR=	(String[])context.get("CUST_SPEC_NO_INGR");//成分
		String[] CUST_SPEC_NO_QLTY=	(String[])context.get("CUST_SPEC_NO_QLTY");//性能
		String[] CUST_SPEC_NO_DEL =	(String[])context.get("CUST_SPEC_NO_DEL");	//公差
		
		String[] SPEC_ABBSYM   	= 	(String[])context.get("SPEC_ABBSYM");//标准号
		String[] SPEC_STL_GRD  	= 	(String[])context.get("SPEC_STL_GRD");//标准牌号
		String[] THK_MIN       	= 	(String[])context.get("THK_MIN");//厚度min
		String[] THK_MAX       	= 	(String[])context.get("THK_MAX");//厚度max
		String[] WTH_MIN       	= 	(String[])context.get("WTH_MIN");//宽度min
		String[] WTH_MAX       	= 	(String[])context.get("WTH_MAX");//宽度max
		String[] ORD_USE_TP    	= 	(String[])context.get("ORD_USE_TP");//订单用途
		
		String[] FAC_STL_GRD 	= 	(String[])context.get("FAC_STL_GRD");//厂内钢号
		String[] SMS_STD_NO  	= 	(String[])context.get("SMS_STD_NO");//炼钢编码规范
		String[] MILL_STD_NO 	= 	(String[])context.get("MILL_STD_NO");//热轧编码规范
		String[] COLD_STD_NO	=	(String[])context.get("COLD_STD_NO");//冷轧生产规范
		String[] SIZE_SPEC_CD	=	(String[])context.get("SIZE_SPEC_CD");//尺寸对应码
		
		String[] DEV_SPEC_CD 	= 	(String[])context.get("DEV_SPEC_CD");//交付条件指定
		String[] DEV_DGR_CD		=	(String[])context.get("DEV_DGR_CD");//公差代码
		String[] REG_NM			=	(String[])context.get("REG_NM");
		
		PosParameter param= null;
		
		String[] rowStuts   = (String[])context.get("rowStuts");
		
		if(rowStuts != null)
		{
			int len = rowStuts.length;
			int j   = 0;
			for(int i = 0; i < len; i++)
			{
				j  = 0;
				param = new PosParameter(); 
				
				FAC_STL_GRD[i] = FAC_STL_GRD[i];
				SMS_STD_NO[i]  = SMS_STD_NO[i];
				MILL_STD_NO[i] = MILL_STD_NO[i];		
				
				if("i".equals(rowStuts[i]))
				{					
//					//若厂内钢号非空且不存与于表TBB01_FAC_INGR中则不能做插入操作
//					 if(!"".equals(FAC_STL_GRD[i]) && !beExist(FAC_STL_GRD[i], "UIB010250_01.SELECT"))
//						 continue;
//					 //若炼钢生产规范编码非空且不存在于TBB01_SMS_PROD
//					 if(!"".equals(SMS_STD_NO[i]) && !beExist(SMS_STD_NO[i],   "UIB010250_02.SELECT"))
//						 continue;
//					 //若轧钢生产规范编码非空且不存在于TBB01_MILL_PROD
//					 if(!"".equals(MILL_STD_NO[i]) && !beExist(MILL_STD_NO[i], "UIB010250_03.SELECT"))
//						 continue;
					 
					 param.setValueParamter(j++, CUST_SPEC_NO[i]);
					 param.setValueParamter(j++, CUST_SPEC_NO_INGR[i]);
					 param.setValueParamter(j++, CUST_SPEC_NO_QLTY[i]);
					 param.setValueParamter(j++, CUST_SPEC_NO_DEL[i]);
					 param.setValueParamter(j++, CUST_SPEC_NO[i].substring(0, 6));
					 param.setValueParamter(j++, SPEC_ABBSYM[i]);
					 param.setValueParamter(j++, SPEC_STL_GRD[i]);
					 param.setValueParamter(j++, THK_MIN[i]);
					 param.setValueParamter(j++, THK_MAX[i]);
					 param.setValueParamter(j++, WTH_MIN[i]);
					 param.setValueParamter(j++, WTH_MAX[i]);
					 param.setValueParamter(j++, ORD_USE_TP[i]);
					 param.setValueParamter(j++, FAC_STL_GRD[i]);
					 param.setValueParamter(j++, SMS_STD_NO[i]);
					 param.setValueParamter(j++, MILL_STD_NO[i]);
					 param.setValueParamter(j++, COLD_STD_NO[i]);
					 param.setValueParamter(j++, DEV_SPEC_CD[i]);
					 param.setValueParamter(j++, DEV_DGR_CD[i]);
					 param.setValueParamter(j++, SIZE_SPEC_CD[i]);
					 param.setValueParamter(j++, REG_NM[0]);
					 dao.insert("UIB010250_01.INSERT", param);
					 SaveModifyHistory.writeLog(dao, INFID, "I", "UIB010250_01.INSERT", param.getValueParameters(), "", REG_NM[0]);
				}
				else if("u".equals(rowStuts[i]))
				{
// 					//若厂内钢号非空且不存与于表TBB01_FAC_INGR中则不能做插入操作
//					 if(!"".equals(FAC_STL_GRD[i]) && !beExist(FAC_STL_GRD[i], "UIB010250_01.SELECT"))
//					 {
//						 continue;
//						 
//					 }
//					 //若炼钢生产规范编码非空且不存在于TBB01_SMS_PROD
//					 if(!"".equals(SMS_STD_NO[i]) && !beExist(SMS_STD_NO[i],   "UIB010250_02.SELECT"))
//						 continue;
//					 //若轧钢生产规范编码非空且不存在于TBB01_MILL_PROD
//					 if(!"".equals(MILL_STD_NO[i]) && !beExist(MILL_STD_NO[i], "UIB010250_03.SELECT"))
//						 continue;
					 
					 param.setWhereClauseParameter(j++, CUST_SPEC_NO[i]);
					 param.setWhereClauseParameter(j++, CUST_SPEC_NO_INGR[i]);
					 param.setWhereClauseParameter(j++, CUST_SPEC_NO_QLTY[i]);
					 param.setWhereClauseParameter(j++, CUST_SPEC_NO_DEL[i]);
					 param.setWhereClauseParameter(j++, CUST_SPEC_NO[i].substring(0, 6));
					 param.setWhereClauseParameter(j++, SPEC_ABBSYM[i]);
					 param.setWhereClauseParameter(j++, SPEC_STL_GRD[i]);
					 param.setWhereClauseParameter(j++, THK_MIN[i]);
					 param.setWhereClauseParameter(j++, THK_MAX[i]);
					 param.setWhereClauseParameter(j++, WTH_MIN[i]);
					 param.setWhereClauseParameter(j++, WTH_MAX[i]);
					 param.setWhereClauseParameter(j++, ORD_USE_TP[i]);
					 param.setWhereClauseParameter(j++, FAC_STL_GRD[i]);
					 param.setWhereClauseParameter(j++, SMS_STD_NO[i]);
					 param.setWhereClauseParameter(j++, MILL_STD_NO[i]);
					 param.setWhereClauseParameter(j++, COLD_STD_NO[i]);
					 param.setWhereClauseParameter(j++, DEV_SPEC_CD[i]);
					 param.setWhereClauseParameter(j++, DEV_DGR_CD[i]);
					 param.setWhereClauseParameter(j++, SIZE_SPEC_CD[i]);
					 param.setWhereClauseParameter(j++, REG_NM[0]);
					 param.setWhereClauseParameter(j++, CUST_SPEC_NO1[i]);
					 dao.update("UIB010250_01.UPDATE", param);
					 SaveModifyHistory.writeLog(dao, INFID, "U", "UIB010250_01.UPDATE", param.getWhereClauseParamters(), "", REG_NM[0]);
				}
				else if("d".equals(rowStuts[i]))
				{
					param.setWhereClauseParameter(0 , CUST_SPEC_NO[i]);
					dao.delete("UIB010250_01.DELETE", param);
					SaveModifyHistory.writeLog(dao, INFID, "D", "UIB010250_01.DELETE", param.getWhereClauseParamters(), "", REG_NM[0]);
				}
			}
		}
		
		return PosBizControlConstants.SUCCESS;
	}

	/**
	 * 判断厂内钢号、炼钢生产规范编号、轧钢生产规范编号是否存在
	 * @param str SQL中传入的参数
	 * @param sql 要执行的查询操作
	 * @return boolean 表有str参数的记录在数据库汇中是否存在
	 */
	public boolean beExist(String str , String sql)
	{
		PosParameter  pa = new PosParameter();
		PosRowSet rowset = null; 
		pa.setWhereClauseParameter(0, str);
		rowset = dao.find(sql, pa);
		if(rowset.count()==0 || rowset==null)
			return false;
		else
			return true;
	}
}