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;

/**
 * 类名    SaveCustIngr.java
 * 说明    客户成分保存{界面ID:UIB015020}
 * 创建日期 2008-10-29
 * 作者    何文熙 
 */
public class SaveCustIngr extends PosActivity {
	public String runActivity(PosContext context) {
		PosGenericDao dao = this.getDao("mesdao");
		PosParameter param = null;
		PosRowSet rowSet = null;
		
		String[] rowStuts = (String[]) context.get("rowStuts");
		String[] no = (String[]) context.get("no");//订单号
		String[] seq = (String[]) context.get("seq");//订单序号
		String[] CHEM_CD = (String[]) context.get("CHEM_CD");//成分代码
		String[] MIN1 = (String[]) context.get("MIN1");//成分最小值
		String[] MAX1 = (String[]) context.get("MAX1");//成分最大值
			if (rowStuts != null) {
				int len = rowStuts.length;
				for (int i = 0; i < len; i++) {
					param = new PosParameter();
					param.setWhereClauseParameter(0, no[0]);
					param.setWhereClauseParameter(1, seq[0]);
					param.setWhereClauseParameter(2, "1");//DNS_KIND = '1'
					param.setWhereClauseParameter(3, CHEM_CD[i]);
					rowSet = dao.find("UIB015020_15.SELECT", param);
					//根据订单号，成分代码，查询客户成分信息，若查到的记录大于0，则执行if,否则执行else
			
					if (rowSet.count() > 0) {
						//更新客户成分信息
						param = new PosParameter();
						param.setWhereClauseParameter(0, MIN1[i]);
						param.setWhereClauseParameter(1, MAX1[i]);
						param.setWhereClauseParameter(2, no[0]);
						param.setWhereClauseParameter(3, seq[0]);
						param.setWhereClauseParameter(4, "1");
						param.setWhereClauseParameter(5, CHEM_CD[i]);
						dao.update("UIB015020_17.UPDATE", param);
					}
					else {
						//插入客户成分信息
						param = new PosParameter();
						param.setValueParamter(0, no[0]);
						param.setValueParamter(1, seq[0]);
						param.setValueParamter(2, CHEM_CD[i]);
						param.setValueParamter(3, MIN1[i]);
						param.setValueParamter(4, MAX1[i]);
						dao.insert("UIB015020_16.INSERT", param);
					}
				}
			}
		return PosBizControlConstants.SUCCESS;
	}
}