custlinkinfo.java

java阿里巴巴代码

package com.saas.biz.custlinkMgr;

import java.util.ArrayList;

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.custlinkDAO.CustlinkDAO;
import com.saas.biz.dao.custlinkDAO.CustlinkExt;
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 CustlinkInfo {
	Dbtable tradeQuery;

	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	ArrayList queryResult = new ArrayList();

	public CustlinkInfo() {
		log = new Logger(this);
		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 addCustLinkInfo(Buffers inbuffer) {
		log.LOG_INFO("进入addCustLinkInfo方法...");
		this.outBuffer = inbuffer;
		CustlinkDAO custlinkdao = new CustlinkDAO();
		this.outBuffer = inbuffer;
		custlinkdao.setCust_id(inbuffer.getString("SESSION_CUST_ID"));
		custlinkdao.setLink_name(inbuffer.getString("LINK_NAME"));
		custlinkdao.setLink_no(inbuffer.getString("LINK_NO"));
		custlinkdao.setLink_url(inbuffer.getString("LINK_URL"));
		custlinkdao.setLink_type(inbuffer.getString("LINK_TYPE"));
		custlinkdao.setRsrv_str3(inbuffer.getString("RSRV_STR3"));
		int iResult = -1;
		try {
			iResult = addCustLinkInfo(custlinkdao);
		} 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 addCustLinkInfo(CustlinkDAO custlinkdao) throws SaasApplicationException {
		CustlinkExt custlinExt = new CustlinkExt();
		custlinExt.setParam(":VCUST_ID", custlinkdao.getCust_id());
		custlinExt.setParam(":VLINK_NAME", custlinkdao.getLink_name());
		custlinExt.setParam(":VLINK_NO", custlinkdao.getLink_no());
		custlinExt.setParam(":VLINK_URL", custlinkdao.getLink_url());
		custlinExt.setParam(":VLINK_TYPE", custlinkdao.getLink_type());
		custlinExt.setParam(":VRSRV_STR1", "");
		custlinExt.setParam(":VRSRV_STR2", "");
		custlinExt.setParam(":VRSRV_STR3", custlinkdao.getRsrv_str3());
		custlinExt.setParam(":VRSRV_STR4", "");
		custlinExt.setParam(":VRSRV_STR5", "");
		custlinExt.setParam(":VRSRV_STR6", "");
		custlinExt.setParam(":VREMARK", "");
		tradeQuery.executeBy(custlinExt.insBy("INS_BY_ALL"));
		return 0;
	}

	// 修改友情链接
	public void updateCustLinkInfo(Buffers inbuffer) {
		log.LOG_INFO("进入updateCustLinkInfo方法...");
		this.outBuffer = inbuffer;
		CustlinkDAO custlinkdao = new CustlinkDAO();
		this.outBuffer = inbuffer;
		custlinkdao.setCust_id(inbuffer.getString("SESSION_CUST_ID"));
		custlinkdao.setLink_name(inbuffer.getString("LINK_NAME"));
		custlinkdao.setLink_no(inbuffer.getString("LINK_NO"));
		custlinkdao.setLink_url(inbuffer.getString("LINK_URL"));
		custlinkdao.setLink_type(inbuffer.getString("LINK_TYPE"));
		custlinkdao.setRsrv_str3(inbuffer.getString("RSRV_STR3"));
		int iResult = -1;
		try {
			iResult = updateCustLinkInfo(custlinkdao);
		} 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 updateCustLinkInfo(CustlinkDAO custlinkdao) throws SaasApplicationException {
		CustlinkExt custlinExt = new CustlinkExt();
		custlinExt.setParam(":VCUST_ID", custlinkdao.getCust_id());
		custlinExt.setParam(":VLINK_NAME", custlinkdao.getLink_name());
		custlinExt.setParam(":VLINK_NO", custlinkdao.getLink_no());
		custlinExt.setParam(":VLINK_URL", custlinkdao.getLink_url());
		custlinExt.setParam(":VLINK_TYPE", custlinkdao.getLink_type());
		custlinExt.setParam(":VRSRV_STR3", custlinkdao.getRsrv_str3());
		tradeQuery.executeBy(custlinExt.insBy("UPDATE_BY_ALL"));
		return 0;
	}

	// 查询客户友情链接列表
	public void genCustCustlink(Buffers inbuffer) {
		log.LOG_INFO("进入genCustCustlink方法...");
		this.outBuffer = inbuffer;
		String query_param = inbuffer.getString("QUERY_PARAM");
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		try {
			if (query_param.equals(""))
				this.queryResult = genCustCustlink(cust_id);
			else
				this.queryResult = searchLink(query_param, cust_id);
		} catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());

		}
		log.LOG_INFO("退出genCustCustlink方法...");
	}

	public ArrayList genCustCustlink(String cust_id) throws SaasApplicationException {
		ArrayList itemsList = new ArrayList();
		CustlinkExt custlinkExt = new CustlinkExt();
		custlinkExt.setParam(":VCUST_ID", cust_id);
		itemsList = custlinkExt.selByList("SEL_BY_CUST");
		return itemsList;
	}

	// 查询单条友情链接(link_no)为id
	public void genOneCustlink(Buffers inbuffer) {
		log.LOG_INFO("进入genOneCustlink方法...");
		this.outBuffer = inbuffer;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String link_no = inbuffer.getString("LINK_NO");
		try {
			this.queryResult = genOneCustlink(link_no, cust_id);
		} catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());

		}
		log.LOG_INFO("退出genOneCustlink方法...");
	}

	public ArrayList genOneCustlink(String link_no, String cust_id) throws SaasApplicationException {
		ArrayList itemsList = new ArrayList();
		CustlinkExt custlinkExt = new CustlinkExt();
		custlinkExt.setParam(":VLINK_NO", link_no);
		custlinkExt.setParam(":VCUST_ID", cust_id);
		itemsList = custlinkExt.selByList("SEL_BY_ONE");
		return itemsList;
	}

	// 删除友情链接
	public void deloneinfo(Buffers inbuffer) {
		log.LOG_INFO("进入deloneinfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String link_no = inbuffer.getString("LINK_NO");
		try {
			iResult = deloneinfo(link_no, cust_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("退出deloneinfo方法...");
	}

	public int deloneinfo(String link_no, String cust_id) throws SaasApplicationException {
		CustlinkExt custlinkExt = new CustlinkExt();
		custlinkExt.setParam(":VLINK_NO", link_no);
		custlinkExt.setParam(":VCUST_ID", cust_id);
		tradeQuery.executeBy(custlinkExt.insBy("DEL_BY_ONE"));
		return 0;
	}

	/**
	 * 
	 * @param title
	 * @param cust_id
	 * @return
	 * @throws SaasApplicationException
	 */
	public ArrayList searchLink(String linkname, String cust_id) throws SaasApplicationException {
		ArrayList itemsList = new ArrayList();
		CustlinkExt custlinkExt = new CustlinkExt();
		custlinkExt.setParam(":VLINK_NAME", "%" + linkname + "%");
		custlinkExt.setParam(":VCUST_ID", cust_id);
		itemsList = custlinkExt.selByList("SEL_BY_SEARCH");
		return itemsList;
	}

	// 分页查询
	public ArrayList getCustLinkListByAll(int iStart, String cust_id) throws SaasApplicationException {
		if (iStart == 0) {
			iStart = 0;
		} else {
			iStart = (iStart - 1) * 30;
		}
		ArrayList linkList = new ArrayList();
		CustlinkExt custlinkExt = new CustlinkExt();
		custlinkExt.setParam(":VCUST_ID", cust_id);
		linkList = custlinkExt.selByList("SEL_BY_CUST", iStart, 30);
		return linkList;
	}

	// 统计总数
	public int getLinkNumber(String cust_id) throws SaasApplicationException {
		ArrayList linkList = new ArrayList();
		CustlinkExt custlinkExt = new CustlinkExt();
		custlinkExt.setParam(":VCUST_ID", cust_id);
		linkList = custlinkExt.selByList("SEL_BY_CUST");
		if (linkList != null) {
			return linkList.size();
		} else {
			return 0;
		}
	}

	// 判断友链接是否重复
	public int getCustFriendlyExists(String cust_id, String link_name, String link_url) throws SaasApplicationException {
		int result = 0;
		ArrayList linkList = new ArrayList();
		CustlinkExt custlinkExt = new CustlinkExt();
		custlinkExt.setParam(":VCUST_ID", cust_id);
		custlinkExt.setParam(":VLINK_NAME", link_name);
		custlinkExt.setParam(":VLINK_URL", link_url);
		linkList=custlinkExt.selByList("SEL_BY_EXIST");
		if (linkList != null && linkList.size() > 0) {
			result = linkList.size();
		}
		return result;
	}
}