enquirydinfo.java

java阿里巴巴代码

package com.saas.biz.enquirydealMgr;

import java.util.ArrayList;
import java.util.HashMap;
import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.enquirytrackDAO.EnquirytrackDAO;
import com.saas.biz.dao.enquirytrackDAO.EnquirytrackExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

/**
 * @AUTHOR:LIUYANG
 * @DESC : 销售询价
 * @2008-7-7
 */
public class EnquirydInfo {
	
	
	Dbtable tradeQuery;
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	commMethodMgr comm;
	
	
	@SuppressWarnings("unchecked")
	ArrayList queryResult = new ArrayList();
	
	
	
	public EnquirydInfo() {

		log = new Logger(this);
		tradeQuery = new Dbtable();
		comm = new commMethodMgr();
	}
	
	
	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;
	}
	
	
	@SuppressWarnings("unchecked")
	public ArrayList getQueryResult() {

		return this.queryResult;
	}
	
	
	@SuppressWarnings("unchecked")
	public void setQueryResult(ArrayList queryResult) {

		this.queryResult = queryResult;
	}
	
	
	
	// 新增询价回复
	public void addEnquiryInfo(Buffers inbuffer) {

		log.LOG_INFO("进入addEnquiryInfo方法...");
		this.outBuffer = inbuffer;
		String trade_id = comm.GenTradeId();
		String cust_id = inbuffer.getString("CUST_ID");
		String user_id = inbuffer.getString("USER_ID");
		String sale_id = inbuffer.getString("SALE_ID");
		String enquiry_content = inbuffer.getString("CONTENT");
		String enquiry_user = inbuffer.getString("SESSION_USER_ID");
		String deal_tag = inbuffer.getString("DEAL_TAG");
		String rsrv_str3 = inbuffer.getString("RSRV_STR3");
		String rsrv_str4 = inbuffer.getString("RSRV_STR4");
		String rsrv_str5 = inbuffer.getString("RSRV_STR5");
		int iResult = -1;
		try {
			EnquirytrackDAO enquiry = new EnquirytrackDAO();
			enquiry.setCust_id(cust_id);
			enquiry.setTrade_id(trade_id);
			enquiry.setUser_id(user_id);
			enquiry.setSale_id(sale_id);
			enquiry.setEnquiry_content(enquiry_content);
			enquiry.setEnquiry_user(enquiry_user);
			enquiry.setDeal_tag(deal_tag);
			enquiry.setRsrv_str3(rsrv_str3);
			enquiry.setRsrv_str4(rsrv_str4);
			enquiry.setRsrv_str5(rsrv_str5);
			iResult = addEnquiryInfo(enquiry);
		}
		catch (SaasApplicationException 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("退出addEnquiryInfo方法...");
	}
	
	
	public int addEnquiryInfo(EnquirytrackDAO enquiry) throws SaasApplicationException {

		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VCUST_ID", enquiry.getCust_id());
		enquiryExt.setParam(":VTRADE_ID", enquiry.getTrade_id());
		enquiryExt.setParam(":VUSER_ID", enquiry.getUser_id());
		enquiryExt.setParam(":VSALE_ID", enquiry.getSale_id());
		enquiryExt.setParam(":VENQUIRY_CONTENT", enquiry.getEnquiry_content());
		enquiryExt.setParam(":VENQUIRY_USER", enquiry.getEnquiry_user());
		enquiryExt.setParam(":VDEAL_TAG", enquiry.getDeal_tag());
		enquiryExt.setParam(":VRSRV_STR1", "0");// 未做出回复
		enquiryExt.setParam(":VRSRV_STR3", enquiry.getRsrv_str3());
		enquiryExt.setParam(":VRSRV_STR4", enquiry.getRsrv_str4());
		enquiryExt.setParam(":VRSRV_STR5", enquiry.getRsrv_str5());
		tradeQuery.executeBy(enquiryExt.insBy("INS_BY_ENQURIY"));
		return 0;
	}
	
	
	
	/**
	 * @param user_id
	 * @param tag
	 * @param 0
	 *            rsrv_str1 没读过
	 * @return
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public ArrayList getEnquriyInfoByTag(int iStart, String user_id, String tag, String rsrv_str1) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * 20;
		}
		else {
			iStart = 0;
		}
		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VUSER_ID", user_id);
		enquiryExt.setParam(":VDEAL_TAG", tag);
		enquiryExt.setParam(":VRSRV_STR1", rsrv_str1);
		list = enquiryExt.selByList("SEL_BY_TAG", iStart, 20);
		return list;
	}
	
	
	
	/**
	 * @param user_id
	 * @param tag
	 * @param rsrv_str1
	 * @return 统计记录
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public int getEnquriyInfoByTag(String user_id, String tag, String rsrv_str1) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		int size = 0;
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VUSER_ID", user_id);
		enquiryExt.setParam(":VDEAL_TAG", tag);
		enquiryExt.setParam(":VRSRV_STR1", rsrv_str1);
		list = enquiryExt.selByList("SEL_BY_TAG_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	/**
	 * @param user_id
	 * @param tag
	 * @param 0
	 *            rsrv_str1 没读过
	 * @return
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public ArrayList getEnquriyInfoByUser(int iStart, String user_id, String deal_tag) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * 20;
		}
		else {
			iStart = 0;
		}
		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VUSER_ID", user_id);
		enquiryExt.setParam(":VDEAL_TAG", deal_tag);
		list = enquiryExt.selByList("SEL_BY_USER", iStart, 20);
		return list;
	}
	
	
	
	/**
	 * @param user_id
	 * @param tag
	 * @param rsrv_str1
	 * @return 统计记录
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public int getEnquriyInfoByUser(String user_id, String deal_tag) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		int size = 0;
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VUSER_ID", user_id);
		enquiryExt.setParam(":VDEAL_TAG", deal_tag);
		list = enquiryExt.selByList("SEL_BY_USER_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	/**
	 * @param iStart
	 * @param user_id
	 * @param tag
	 * @return 取出自己发出的留言
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public ArrayList getEnquiryByMySelf(int iStart, String user_id, String tag) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * 20;
		}
		else {
			iStart = 0;
		}
		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VUSER_ID", user_id);
		enquiryExt.setParam(":VDEAL_TAG", tag);
		list = enquiryExt.selByList("SEL_BY_MYSELF", iStart, 20);
		return list;
	}
	
	
	
	/**
	 * @param user_id
	 * @param tag
	 * @return 统计自己发出的留言
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public int getEnquiryByMySelf(String user_id, String tag) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		int size = 0;
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VUSER_ID", user_id);
		enquiryExt.setParam(":VDEAL_TAG", tag);
		list = enquiryExt.selByList("SEL_BY_MYSELF_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	/**
	 * 修改询价留言
	 * 
	 * @param inbuffer
	 */
	
	public void editEnquiryInfo(Buffers inbuffer) {

		log.LOG_INFO("进入editEnquiryInfo方法...");
		this.outBuffer = inbuffer;
		String trade_id = inbuffer.getString("TRADE_ID");
		String rsrv_str1 = inbuffer.getString("RSRV_STR1");
		int iResult = -1;
		try {
			EnquirytrackDAO enquiry = new EnquirytrackDAO();
			enquiry.setTrade_id(trade_id);
			enquiry.setRsrv_str1(rsrv_str1);
			iResult = editEnquiryInfo(enquiry);
		}
		catch (SaasApplicationException 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("退出addEnquiryInfo方法...");
	}
	
	
	public int editEnquiryInfo(EnquirytrackDAO enquiry) throws SaasApplicationException {

		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VTRADE_ID", enquiry.getTrade_id());
		enquiryExt.setParam(":VRSRV_STR1", enquiry.getRsrv_str1());// 未做出回复
		tradeQuery.executeBy(enquiryExt.insBy("EDIT_BY_ENQURIY"));
		return 0;
	}
	
	
	
	/**
	 * 删除询价留言
	 * 
	 * @param inbuffer
	 */
	
	public void delEnquiryInfo(Buffers inbuffer) {

		log.LOG_INFO("进入delEnquiryInfo方法...");
		this.outBuffer = inbuffer;
		String trade_id = inbuffer.getString("TRADE_ID");
		int iResult = -1;
		try {
			iResult = delEnquiryInfo(trade_id);
		}
		catch (SaasApplicationException 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("退出addEnquiryInfo方法...");
	}
	
	
	public int delEnquiryInfo(String trade_id) throws SaasApplicationException {