custpublicinfo.java

java阿里巴巴代码

package com.saas.biz.custPublicMgr;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.StringTokenizer;

import net.sf.json.JSONArray;
import com.saas.biz.JavaScriptObject.TreeNode;
import com.saas.biz.JavaScriptObject.TreeObject;
import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.custPublicDAO.CustPublicDAO;
import com.saas.biz.dao.custPublicDAO.CustPublicExt;
import com.saas.biz.dao.relationccDAO.RelationCcExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

public class CustPublicInfo {
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	Dbtable tradeQuery;
	
	
	commMethodMgr commen;
	
	
	ArrayList queryResult = new ArrayList();
	
	
	
	public CustPublicInfo() {

		log = new Logger(this);
		tradeQuery = new Dbtable();
		commen = new commMethodMgr();
	}
	
	
	public void setOutBuffer(Buffers outBuffer) {

		this.outBuffer = outBuffer;
	}
	
	
	public Buffers getOutBuffer() {

		return this.outBuffer;
	}
	
	
	public void setTradeQuery(Dbtable tradeQuery) {

		this.tradeQuery = tradeQuery;
	}
	
	
	public Dbtable getTradeQuery() {

		return this.tradeQuery;
	}
	
	
	public ArrayList getQueryResult() {

		return this.queryResult;
	}
	
	
	public void setQueryResult(ArrayList queryResult) {

		this.queryResult = queryResult;
	}
	
	
	
	
	public void addCustPublicInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入addCustPublicInfo方法...");
		int iResult = -1;
		String cust_id=inbuffer.getString("SESSION_CUST_ID");       
		String obj_cust_id=inbuffer.getString("OBJ_CUST_ID");
		String param_id=inbuffer.getString("PARAM_ID");
		String param_name=inbuffer.getString("PARAM_NAME");       
		String param_value=inbuffer.getString("PARAM_VALUE");                
		String oper_user_id=inbuffer.getString("SESSION_USER_ID");       
		String in_date=inbuffer.getString("IN_DATE");       
		String remark=inbuffer.getString("REMARK");
		log.LOG_INFO("============="+param_id+"^^^^^^^^^"+param_name+"************"+param_value+"########");
		String delims = "";
		String dd[] = param_name.split(delims);
		if(dd[1].equals("|")){
			iResult = 0;
		}else{
			String param_no="";    
			StringTokenizer param_id1 = new StringTokenizer(param_id,"|");
			int j = getMaxParamNo(cust_id,obj_cust_id);
			while (param_id1.hasMoreTokens()) {
				param_id1.nextToken();
				param_no +=String.valueOf(j)+"|";
				j++;
			}      
			int i = 0;
			StringTokenizer param_id6 = new StringTokenizer(param_id,"|");
			StringTokenizer param_name6 = new StringTokenizer(param_name,"|");
			StringTokenizer param_value6 = new StringTokenizer(param_value,"|");
			StringTokenizer param_no6 = new StringTokenizer(param_no,"|");
			String param_id7 = "",param_name7 = "",param_value7 = "",param_no7 = "";
			while (param_id6.hasMoreTokens()){
				param_id7 = param_id6.nextToken();
				param_name7 = param_name6.nextToken();
				param_value7 = param_value6.nextToken();
				param_no7 = param_no6.nextToken();
				i = checkCustPublic(cust_id,obj_cust_id,param_id7);
					try {
						if(i==0){
							iResult = addCustPublicInfo(cust_id,obj_cust_id,param_id7,param_no7,param_name7,param_value7,
									oper_user_id,in_date,remark);
						}else{
							iResult = updateCustPublicInfo(cust_id,obj_cust_id,param_id7,param_no7,param_name7,param_value7,
									oper_user_id,in_date,remark);
						}
					}
					catch (Exception e) {
						log.LOG_INFO(e.getMessage());
					}
			}
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "业务处理失败！");
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "业务处理成功！");
		}
		log.LOG_INFO("退出addCustPublicInfo方法...");
	}
	
	
	public int addCustPublicInfo(String cust_id,String obj_cust_id,String param_id,String param_no,String param_name,String param_value,String oper_user_id,String in_date,String remark) throws SaasApplicationException {
		    
		    	CustPublicExt custPublicExt = new CustPublicExt();
				custPublicExt.setParam(":VCUST_ID",cust_id);                          
				custPublicExt.setParam(":VOBJ_CUST_ID",obj_cust_id);
				custPublicExt.setParam(":VPARAM_ID",param_id);                          
				custPublicExt.setParam(":VPARAM_NO",param_no);                          
				custPublicExt.setParam(":VPARAM_NAME",param_name);                          
				custPublicExt.setParam(":VPARAM_VALUE",param_value);                                                   
				custPublicExt.setParam(":VOPER_USER_ID",oper_user_id);                          
				custPublicExt.setParam(":VIN_DATE",in_date);                          
				custPublicExt.setParam(":VREMARK",remark); 
				tradeQuery.executeBy(custPublicExt.insBy("INS_ALL_CUSTPUBLIC"));
				//log.LOG_INFO("开始执行SQL====================："+custPublicExt.insBy("INS_ALL_CUSTPUBLIC"));
				return 0;
	}



	public int updateCustPublicInfo(String cust_id,String obj_cust_id,String param_id,String param_no,String param_name,String param_value,
			String oper_user_id,String in_date,String remark) throws SaasApplicationException {
	
	    	CustPublicExt custPublicExt = new CustPublicExt();
			custPublicExt.setParam(":VCUST_ID",cust_id);                          
			custPublicExt.setParam(":VOBJ_CUST_ID",obj_cust_id);
			custPublicExt.setParam(":VPARAM_ID",param_id);                          
			custPublicExt.setParam(":VPARAM_NO",param_no);                          
			custPublicExt.setParam(":VPARAM_NAME",param_name);                          
			custPublicExt.setParam(":VPARAM_VALUE",param_value);                                                   
			custPublicExt.setParam(":VOPER_USER_ID",oper_user_id);                          
			custPublicExt.setParam(":VIN_DATE",in_date);                          
			custPublicExt.setParam(":VREMARK",remark); 
			tradeQuery.executeBy(custPublicExt.insBy("UPDATE_ALL_CUSTPUBLIC"));
	        return 0;
	}



	public int checkCustPublic(String cust_id,String obj_cust_id,String param_id){
		ArrayList list = new ArrayList();
		CustPublicExt custPublicExt = new CustPublicExt();
		custPublicExt.setParam(":VCUST_ID", cust_id);
		custPublicExt.setParam(":VOBJ_CUST_ID", obj_cust_id);
		custPublicExt.setParam(":VPARAM_ID", param_id);
		list = custPublicExt.selByList("SEL_ONE_CUSTPUBLIC_CHECK");
		if(list!=null&&list.size()>0){
			return 1;
		}
			return 0;
	}
	


	public HashMap getOneCustPublic(String cust_id,String obj_cust_id){
		ArrayList list = new ArrayList();
		CustPublicExt custPublicExt = new CustPublicExt();
		HashMap map = new HashMap();
		custPublicExt.setParam(":VCUST_ID", cust_id);
		custPublicExt.setParam(":VOBJ_CUST_ID", obj_cust_id);
		list = custPublicExt.selByList("SEL_ONE_CUSTPUBLIC_CHECK");
		if(list!=null&&list.size()>0){
			map = (HashMap)list.get(0);
		}
		return map;
	}
	
	public ArrayList getServalCustPublic(String cust_id,String obj_cust_id){
		ArrayList list = new ArrayList();
		CustPublicExt custPublicExt = new CustPublicExt();
		custPublicExt.setParam(":VCUST_ID", cust_id);
		custPublicExt.setParam(":VOBJ_CUST_ID", obj_cust_id);
		list = custPublicExt.selByList("SEL_SERVAL_CUSTPUBLIC_CHECK");
		return list;
	}
	
	
	public void delCustPublicInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入delCustPublicInfo方法...");
		int iResult = -1;
		String cust_id=inbuffer.getString("SESSION_CUST_ID");           
		String param_id=inbuffer.getString("PARAM_ID");       
		try {
				iResult = delCustPublicInfo(cust_id,param_id);
		}
		catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "业务处理失败！");
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "业务处理成功！");
		}
		log.LOG_INFO("退出delCustPublicInfo方法...");
	}
	
	
	public int delCustPublicInfo(String cust_id,String param_id) throws SaasApplicationException {
			CustPublicExt custPublicExt = new CustPublicExt();
			custPublicExt.setParam(":VCUST_ID",cust_id);                          
			custPublicExt.setParam(":VPARAM_ID",param_id);                          
			tradeQuery.executeBy(custPublicExt.insBy("DEL_ONE_CUSTPUBLIC"));
			return 0;
	}
	
	public int getMaxParamNo(String cust_id,String obj_cust_id){
		ArrayList list = new ArrayList();
		CustPublicExt custPublicExt = new CustPublicExt();
		HashMap map = new HashMap();
		int maxCount = 0;
		custPublicExt.setParam(":VCUST_ID", cust_id);
		custPublicExt.setParam(":VOBJ_CUST_ID", obj_cust_id);
		list = custPublicExt.selByList("SEL_MAX_PARAM_NO");
		if(list!=null&&list.size()>0){
			map = (HashMap)list.get(0);
			if(map.get("ct")!=null){
				maxCount = Integer.parseInt(map.get("ct").toString());
			}
		}
		return maxCount+1;
	}

}