enquirydinfo.java

java阿里巴巴代码

		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VTRADE_ID", trade_id);
		tradeQuery.executeBy(enquiryExt.insBy("DELETE_BY_TRADE"));
		return 0;
	}
	
	
	
	/**
	 * @param trade_type
	 * @return 取出单条询价信息
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public HashMap getEnquriyById(String trade_id) throws SaasApplicationException {

		HashMap map = new HashMap();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VTRADE_ID", trade_id);
		ArrayList list = enquiryExt.selByList("UPDATE_BY_ENQURIY");
		if (list != null && list.size() > 0) {
			map = (HashMap) list.get(0);
		}
		return map;
	}
	
	
	
	/**
	 * add by WangY Date:08-07-08
	 * 
	 * @param iStart
	 * @param limit
	 * @return 取出未关闭的学院留言
	 * @throws SaasApplicationException
	 */
	
	@SuppressWarnings("unchecked")
	public ArrayList getEnquiryByList(int iStart, int limit) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * limit;
		}
		else {
			iStart = 0;
		}
		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		list = enquiryExt.selByList("SEL_ENQ_BY", iStart, limit);
		return list;
	}
	
	
	
	/**
	 * Date:08-07-11
	 */
	@SuppressWarnings("unchecked")
	public ArrayList getEnquiryNewByList(int iStart, int limit, String sale_id) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * limit;
		}
		else {
			iStart = 0;
		}
		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VSALE_ID", sale_id);
		list = enquiryExt.selByList("SEL_BY_ENQUIRY_SALE_ID", iStart, limit);
		return list;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getEnquiryByList() throws SaasApplicationException {

		ArrayList list = new ArrayList();
		int size = 0;
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		list = enquiryExt.selByList("SEL_ENQ_BY_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	/**
	 * add by WangY Date:08-07-08
	 * 
	 * @param trade_id
	 * @return 取出单条留言
	 * @throws SaasApplicationException
	 */
	@SuppressWarnings("unchecked")
	public ArrayList getEnquiryById(String trade_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VTRADE_ID", trade_id);
		list = enquiryExt.selByList("SEL_ENQ_BY_ID");
		return list;
	}
	
	
	@SuppressWarnings("unchecked")
	public ArrayList getMax() throws SaasApplicationException {

		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		list = enquiryExt.selByList("SEL_MAX");
		return list;
	}
	
	
	@SuppressWarnings( { "unchecked", "unchecked" })
	public ArrayList getOffEnquiryByList(int iStart, int limit) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * limit;
		}
		else {
			iStart = 0;
		}
		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		list = enquiryExt.selByList("SEL_OFF_ENQ_BY", iStart, limit);
		return list;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getOffEnquiryByList() throws SaasApplicationException {

		int count = 0;
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		ArrayList list = enquiryExt.selByList("SEL_OFF_ENQ_BY");
		if (list != null && list.size() > 0) {
			count = list.size();
		}
		return count;
	}
	
	
	
	/**
	 * add by WangY Date:08-07-10
	 * 
	 * @param iStart
	 * @return 取出提问列表关闭
	 * @throws SaasApplicationException
	 */
	
	@SuppressWarnings("unchecked")
	public ArrayList getEnquiryOffed(int iStart) throws SaasApplicationException {

		iStart = iStart * 20;
		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		list = enquiryExt.selByList("SEL_ENQ_BY", iStart, 20);
		return list;
	}
	
	
	@SuppressWarnings("unchecked")
	public ArrayList getEnquiryOffed(int iStart, int limit) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * limit;
		}
		else {
			iStart = 0;
		}
		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		list = enquiryExt.selByList("SEL_ENQ_BY", iStart, limit);
		return list;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getEnquiryOffed() throws SaasApplicationException {

		int count = 0;
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		ArrayList list = enquiryExt.selByList("SEL_ENQ_BY");
		if (list != null && list.size() > 0) {
			count = list.size();
		}
		return count;
	}
	
	
	
	/**
	 * add by WangY Date:08-07-10 关闭提问
	 * 
	 * @param inbuffer
	 */
	
	public void CloseEnquiryInfo(Buffers inbuffer) {

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

		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VTRADE_ID", trade_id);
		tradeQuery.executeBy(enquiryExt.insBy("CLOSE_BY_TRADE"));
		return 0;
	}
	
	
	@SuppressWarnings("unchecked")
	public ArrayList searchAdv(int iStart, int limit, String key) throws SaasApplicationException {

		ArrayList itemsList = new ArrayList();
		
		if (iStart > 1) {
			iStart = (iStart - 1) * limit;
		}
		else {
			iStart = 0;
		}
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VRSRV_STR3", "%" + key + "%");
		itemsList = enquiryExt.selByList("SEL_BY_SEARCHES", iStart, limit);
		return itemsList;
	}
	
	
	@SuppressWarnings("unchecked")
	public int searchAdv(String key) throws SaasApplicationException {

		int count = 0;
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VRSRV_STR3", "%" + key + "%");
		ArrayList list = enquiryExt.selByList("SEL_BY_SEARCHES");
		if (list != null && list.size() > 0) {
			count = list.size();
		}
		return count;
	}
	
	
	@SuppressWarnings("unchecked")
	public ArrayList getEnquiryList(int iStart, String cust_id) throws SaasApplicationException {

		iStart = iStart * 20;
		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VCUST_ID", cust_id);
		list = enquiryExt.selByList("SEL_ENQ_BY_CUST", iStart, 20);
		return list;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getEnquiryList(String cust_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		int size = 0;
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VCUST_ID", cust_id);
		list = enquiryExt.selByList("SEL_ENQ_CUST_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	@SuppressWarnings("unchecked")
	public ArrayList getEnqList(int iStart, String sale_id) throws SaasApplicationException {

		iStart = iStart * 20;
		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VSALE_ID", sale_id);
		list = enquiryExt.selByList("SEL_ENQ_BY_SALE", iStart, 20);
		return list;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getEnqList(String sale_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		int size = 0;
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VSALE_ID", sale_id);
		list = enquiryExt.selByList("SEL_ENQ_SALE_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	/**
	 * 找出企业留言
	 */
	public ArrayList getCustomerEnqList(int iStart, int limit, String sale_id,String deal_tage) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * limit;
		}
		else {
			iStart = 0;
		}
		ArrayList list = new ArrayList();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VDEAL_TAG", deal_tage);
		enquiryExt.setParam(":VSALE_ID", sale_id);
		list = enquiryExt.selByList("SEL_CUSTOMER_LEAVE", iStart, limit);
		return list;
	}
	
	
	
	/**
	 * 统计企业留言
	 */
	public int getCustomerEnqCount(String sale_id,String deal_tage) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		int size = 0;
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VSALE_ID", sale_id);
		enquiryExt.setParam(":VDEAL_TAG", deal_tage);
		list = enquiryExt.selByList("SEL_CUSTOMER_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	/**
	 * @param trade_id
	 * @return 取出单条留言信息
	 * @throws SaasApplicationException
	 */
	public HashMap getEnquiryInfoById(String trade_id,String deal_tage) throws SaasApplicationException {

		HashMap map = new HashMap();
		EnquirytrackExt enquiryExt = new EnquirytrackExt();
		enquiryExt.setParam(":VTRADE_ID", trade_id);
		enquiryExt.setParam(":VDEAL_TAG", deal_tage);
		ArrayList list = enquiryExt.selByList("SEL_ENQUIRY_BY_ID");
		if (list != null && list.size() > 0) {
			map = (HashMap) list.get(0);
		}
		return map;
	}
}