enquirytrackinfo.java

java阿里巴巴代码

			iResult = anEnquiryInfo(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", "业务处理成功！");
		}
	}
	
	public int anEnquiryInfo(String strTradeId) throws SaasApplicationException {

		ArrayList itemsList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VTRADE_ID", strTradeId);
		itemsList = enquirytrackExt.selByList("SEL_BY_TRADE");
		return 0;
	}
	
	public ArrayList searchEnquiry(String title, String cust_id) throws SaasApplicationException {

		ArrayList itemsList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VTITLE", "%" + title + "%");
		enquirytrackExt.setParam(":VCUST_ID", cust_id);
		itemsList = enquirytrackExt.selByList("SEL_BY_SEARCH");
		return itemsList;
	}
	
	// 修改询价信息 刘阳2007.11.11
	public void UpdateEnquiryInfoByTrade(Buffers inbuffer) {

		log.LOG_INFO("进入UpdateEnquiryInfoByTrade方法...");
		this.outBuffer = inbuffer;
		String trade_id = inbuffer.getString("enquiry_id");
		String deal_tag = inbuffer.getString("deal_tag");
		String user_id = inbuffer.getString("SESSION_USER_ID");
		int iResult = -1;
		try {
			iResult = UpdateEnquiryInfoByTrade(trade_id, deal_tag, user_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("退出UpdateEnquiryInfoByTrade方法...");
	}
	
	public int UpdateEnquiryInfoByTrade(String strTradeId, String deal_tag, String user_id) throws SaasApplicationException {

		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VTRADE_ID", strTradeId);
		enquirytrackExt.setParam(":VDEAL_TAG", deal_tag);
		enquirytrackExt.setParam(":VDEAL_USER", user_id);
		tradeQuery.executeBy(enquirytrackExt.insBy("UPDATE_ENQURIY_BY_ID"));
		return 0;
	}
	
	// 采购报价分页查询(receive)
	public ArrayList getStockListByUser(int iStart, String user_id) throws SaasApplicationException {

		if (iStart == 0) {
			iStart = 0;
		}
		else {
			iStart = (iStart - 1) * 30;
		}
		ArrayList enquiryList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VUSER_ID", user_id);
		enquiryList = enquirytrackExt.selByList("SEL_ENQUIRY_STOCK", iStart, 30);
		return enquiryList;
	}
	
	// 采购报价统计(receive)
	public int getStockNumberByUser(String user_id) throws SaasApplicationException {

		ArrayList enquiryList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VUSER_ID", user_id);
		enquiryList = enquirytrackExt.selByList("SEL_ENQUIRY_STOCK");
		if (enquiryList != null) {
			return enquiryList.size();
		}
		else {
			return 0;
		}
	}
	
	// 采购报价分页查询(send)
	public ArrayList getStockListBySend(int iStart, String user_id) throws SaasApplicationException {

		if (iStart == 0) {
			iStart = 0;
		}
		else {
			iStart = (iStart - 1) * 30;
		}
		ArrayList enquiryList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VUSER_ID", user_id);
		enquiryList = enquirytrackExt.selByList("SEL_STOCK_SEND", iStart, 30);
		return enquiryList;
	}
	
	// 采购报价统计(send)
	public int getStockNumberBySend(String user_id) throws SaasApplicationException {

		ArrayList enquiryList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VUSER_ID", user_id);
		enquiryList = enquirytrackExt.selByList("SEL_STOCK_SEND");
		if (enquiryList != null) {
			return enquiryList.size();
		}
		else {
			return 0;
		}
	}
	
	// 销售询价分页查询(receive)
	public ArrayList getSaleListByUser(int iStart, String cust_id) throws SaasApplicationException {

		if (iStart == 0) {
			iStart = 0;
		}
		else {
			iStart = (iStart - 1) * 30;
		}
		ArrayList enquiryList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VCUST_ID", cust_id);
		enquiryList = enquirytrackExt.selByList("SEL_ENQUIRY_SALE", iStart, 30);
		return enquiryList;
	}
	
	// 销售询价统计(receive)
	public int getSaleNumberByUser(String cust_id) throws SaasApplicationException {

		ArrayList enquiryList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VCUST_ID", cust_id);
		enquiryList = enquirytrackExt.selByList("SEL_ENQUIRY_SALE");
		if (enquiryList != null) {
			return enquiryList.size();
		}
		else {
			return 0;
		}
	}
	
	// 销售询价分页查询(send)
	public ArrayList getSaleListBySend(int iStart, String user_id) throws SaasApplicationException {

		if (iStart == 0) {
			iStart = 0;
		}
		else {
			iStart = (iStart - 1) * 30;
		}
		ArrayList enquiryList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VUSER_ID", user_id);
		enquiryList = enquirytrackExt.selByList("SEL_ENQUIRY_SEND", iStart, 30);
		return enquiryList;
	}
	
	// 销售询价统计(send)
	public int getSaleNumberBySend(String user_id) throws SaasApplicationException {

		ArrayList enquiryList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VUSER_ID", user_id);
		enquiryList = enquirytrackExt.selByList("SEL_ENQUIRY_SEND");
		if (enquiryList != null) {
			return enquiryList.size();
		}
		else {
			return 0;
		}
	}
	
	// 垃圾留言
	public ArrayList getGarbageListByUser(int iStart, String user_id) throws SaasApplicationException {

		if (iStart == 0) {
			iStart = 0;
		}
		else {
			iStart = (iStart - 1) * 30;
		}
		ArrayList enquiryList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VDEAL_USER", user_id);
		enquiryList = enquirytrackExt.selByList("SEL_BY_GARBAGE", iStart, 30);
		return enquiryList;
	}
	
	// 垃圾留言统计
	public int getGarbageNumber(String user_id) throws SaasApplicationException {

		ArrayList enquiryList = new ArrayList();
		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VDEAL_USER", user_id);
		enquiryList = enquirytrackExt.selByList("SEL_BY_GARBAGE");
		if (enquiryList != null) {
			return enquiryList.size();
		}
		else {
			return 0;
		}
	}
	
	// 删除留言
	public void deleteEnquiryInfo(Buffers inbuffer) {

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

		EnquirytrackExt enquirytrackExt = new EnquirytrackExt();
		enquirytrackExt.setParam(":VTRADE_ID", strTradeId);
		tradeQuery.executeBy(enquirytrackExt.insBy("DELETE_BY_TRADE"));
		return 0;
	}
}