enquirytrackinfo.java

java阿里巴巴代码

package com.saas.biz.enquirytrackMgr;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.ArrayList;
import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.enquirytrackDAO.*;
import com.saas.biz.dao.userDAO.UserExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;
import java.util.HashMap;

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

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

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

		return this.tradeQuery;
	}
	
	public void setOutBuffer(Buffers outBuffer) {

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

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

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

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

		this.outBuffer = inbuffer;
		// this.inBuffer = inbuffer;
		
		log.LOG_INFO("进入addEnquirytrackInfo方法...");
		String sale_id = inbuffer.getString("SALE_ID");
		String user_id = inbuffer.getString("PUBLISH_USER_ID");
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String enquiry_content = inbuffer.getString("ENQUIRY_CONTENT");
		String enquiry_user = inbuffer.getString("SESSION_USER_ID");
		String deal_tag = inbuffer.getString("DEAL_TAG");
		int iResult = -1;
		try {
			iResult = addEnquirytrackInfo(user_id, cust_id, enquiry_content, sale_id, enquiry_user, deal_tag);
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "请在24小时之内不能重复提交！");
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "业务处理成功！");
		}
		log.LOG_INFO("退出addEnquirytrackInfo方法...");
	}
	
	public int addEnquirytrackInfo(String user_id, String cust_id, String enquiry_content, String sale_id, String enquiry_user, String deal_tag) throws SaasApplicationException {

		int arr = searchEnquiry1(cust_id, user_id, sale_id, enquiry_user, deal_tag);
		if (arr != -1) {
			EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
			commMethodMgr comm = new commMethodMgr();
			String gentrade_id = comm.GenTradeId();
			enquirytrackExt.setParam(":VSALE_ID", sale_id);
			enquirytrackExt.setParam(":VUSER_ID", user_id);
			enquirytrackExt.setParam(":VCUST_ID", cust_id);
			enquirytrackExt.setParam(":VTRADE_ID", gentrade_id);
			enquirytrackExt.setParam(":VENQUIRY_CONTENT", enquiry_content);
			enquirytrackExt.setParam(":VDEAL_TAG", deal_tag);
			enquirytrackExt.setParam(":VENQUIRY_USER", enquiry_user);
			tradeQuery.executeBy(enquirytrackExt.insBy("INS_BY_ALL"));
			log.LOG_INFO("cust_id.........." + cust_id);
			return 0;
		}
		else {
			return -1;
		}
	}
	
	
	
	// 查找记录是否存在
	
	public int searchEnquiry1(String cust_id, String user_id, String sale_id, String enquiry_user, String deal_tag) throws SaasApplicationException {

		String enquiry_date = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
		ArrayList itemsList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VCUST_ID", cust_id);
		enquirytrackExt.setParam(":VUSER_ID", user_id);
		enquirytrackExt.setParam(":VSALE_ID", sale_id);
		enquirytrackExt.setParam(":VENQUIRY_USER", enquiry_user);
		enquirytrackExt.setParam(":VENQUIRY_DATE", enquiry_date);
		enquirytrackExt.setParam(":VDEAL_TAG", deal_tag);
		itemsList = enquirytrackExt.selByList("SEL_BY_ENQUIRY");
		if (itemsList != null && itemsList.size() > 0) {
			return -1;
		}
		else {
			return 0;
		}
	}
	
	
	
	// 查找全部询价资料
	public void getEnquiryList(Buffers inbuffer) {

		log.LOG_INFO("进入getEnquiryList方法...");
		this.outBuffer = inbuffer;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		
		try {
			
			this.queryResult = getEnquiryList(cust_id);
			
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
			
		}
		log.LOG_INFO("退出getEnquiryList方法...");
	}
	
	
	public ArrayList getEnquiryList(String strCustid) throws SaasApplicationException {

		ArrayList itemsList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VCUST_ID", strCustid);
		itemsList = enquirytrackExt.selByList("SEL_BY_SALE");
		
		return itemsList;
	}
	
	// 查找全部询价资料
	public void getCustEnquiryList(Buffers inbuffer) {

		log.LOG_INFO("进入getCustEnquiryList方法...");
		this.outBuffer = inbuffer;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String query_param = inbuffer.getString("QUERY_PARAM");
		try {
			if (query_param.equals(""))
				this.queryResult = getCustEnquiryList(cust_id);
			else
				this.queryResult = searchEnquiry(query_param, cust_id);
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
			
		}
		log.LOG_INFO("退出getCustEnquiryList方法...");
	}
	
	
	public ArrayList getCustEnquiryList(String strCustid) throws SaasApplicationException {

		ArrayList itemsList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VCUST_ID", strCustid);
		itemsList = enquirytrackExt.selByList("SEL_BY_CUST");
		return itemsList;
	}
	
	public String getCustEnquiryBySaleId(String job_id) throws SaasApplicationException {

		String enquiry_user = "";
		ArrayList itemsList = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VSALE_ID", job_id);
		itemsList = enquiryExt.selByList("SEL_SPEC_SALE_ID");
		if (itemsList != null && itemsList.size() > 0) {
			HashMap map = (HashMap) itemsList.get(0);
			
			if (map.get("enquiry_user") != null) {
				enquiry_user = map.get("enquiry_user").toString();
			}
		}
		return enquiry_user;
	}
	
	
	
	// /////////////////////////////////////////////////
	/*
	 * public String getCustEnquiryBySaleId(String user_id) throws SaasApplicationException { String user_id = ""; ArrayList itemsList = new ArrayList(); EnquirytrackExt enquiryExt = new EnquirytrackExt(); enquiryExt.setParam(":VUSER_ID", user_id); itemsList = enquiryExt.selByList("SEL_SPEC_SALE_ID"); if( itemsList != null && itemsList.size() > 0 ) { HashMap map = ( HashMap )itemsList.get(0); if( map.get( "user_id" ) != null ) { user_id = map.get( "user_id" ).toString(); } } return user_id; }
	 */
	public void getEnquiryInfo(Buffers inbuffer) {

		log.LOG_INFO("进入getEnquiryInfo方法...");
		this.outBuffer = inbuffer;
		String trade_id = inbuffer.getString("TRADE_ID");
		try {
			this.queryResult = getEnquiryInfo(trade_id);
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
			
		}
		log.LOG_INFO("退出getEnquiryInfo方法...");
	}
	
	
	public ArrayList getEnquiryInfo(String strTradeId) throws SaasApplicationException {

		ArrayList itemsList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VTRADE_ID", strTradeId);
		itemsList = enquirytrackExt.selByList("SEL_BY_TRADE");
		return itemsList;
	}
	
	public void anEnquiryInfo(Buffers inbuffer) {

		log.LOG_INFO("进入anEnquiryInfo方法...");
		this.outBuffer = inbuffer;
		String trade_id = inbuffer.getString("TRADE_ID");
		int iResult = -1;
		try {