clewinfo.java

java阿里巴巴代码

package com.saas.biz.clewInfoMgr;

import java.util.ArrayList;
import java.util.HashMap;

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.clewInfoDAO.ClewInfoDAO;
import com.saas.biz.dao.clewInfoDAO.ClewInfoExt;
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 ClewInfo {
	
	
	Dbtable tradeQuery;
	
	
	commMethodMgr comm;
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	ArrayList queryResult = new ArrayList();
	
	
	
	public ClewInfo() {

		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;
	}
	
	
	public ArrayList getQueryResult() {

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

		this.queryResult = queryResult;
	}
	
	
	
	// 增加线索
	/**
	 * @param inbuffer
	 */
	public void addClewInfo(Buffers inbuffer) {

		log.LOG_INFO("进入addClewInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String clew_id = inbuffer.getString("CLEW_ID");
		String entity_type = inbuffer.getString("ENTITY_TYPE");
		String title = inbuffer.getString("TITLE");
		String content = inbuffer.getString("CONTENT");
		String cl_cust_name = inbuffer.getString("CL_CUST_NAME");
		String cl_cust_id = inbuffer.getString("CL_CUST_ID");
		String cl_contact = inbuffer.getString("CL_CONTACT");
		String cl_contactman = inbuffer.getString("CL_CONTACTMAN");
		String cl_addr = inbuffer.getString("CL_ADDR");
		String cl_per = inbuffer.getString("CL_PER");
		String cl_pay = inbuffer.getString("CL_PAY");
		String state_code = inbuffer.getString("STATE_CODE");
		String get_mode = inbuffer.getString("GET_MODE");
		String get_user_name = inbuffer.getString("GET_USER_NAME");
		String get_user_id = inbuffer.getString("GET_USER_ID");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");
		
		try {
			ClewInfoDAO clewDao = new ClewInfoDAO();
			clewDao.setCl_addr(cl_addr);
			clewDao.setCl_contact(cl_contact);
			clewDao.setCust_id(cust_id);
			clewDao.setClew_id(clew_id);
			clewDao.setEntity_type(entity_type);
			clewDao.setTitle(title);
			clewDao.setContent(content);
			clewDao.setCl_cust_name(cl_cust_name);
			clewDao.setCl_cust_id(cl_cust_id);
			clewDao.setCl_contactman(cl_contactman);
			clewDao.setCl_pay(cl_pay);
			clewDao.setCl_per(cl_per);
			clewDao.setState_code(state_code);
			clewDao.setGet_mode(get_mode);
			clewDao.setGet_user_id(get_user_id);
			clewDao.setGet_user_name(get_user_name);
			clewDao.setOper_user_id(oper_user_id);
			clewDao.setRemark2(remark2);
			iResult = addClewInfo(clewDao);
		}
		catch (Exception 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("退出addClewInfo方法...");
	}
	
	
	public int addClewInfo(ClewInfoDAO clewDao) throws SaasApplicationException {

		ClewInfoExt clewExt = new ClewInfoExt();
		try {
			clewExt.setParam(":VCUST_ID", clewDao.getCust_id());
			clewExt.setParam(":VCLEW_ID", clewDao.getClew_id());
			clewExt.setParam(":VENTITY_TYPE", clewDao.getEntity_type());
			clewExt.setParam(":VTITLE", clewDao.getTitle());
			clewExt.setParam(":VCONTENT", clewDao.getContent());
			clewExt.setParam(":VCL_CUST_NAME", clewDao.getCl_cust_name());
			clewExt.setParam(":VCL_CUST_ID", clewDao.getCl_cust_id());
			clewExt.setParam(":VCL_CONTACT", clewDao.getCl_contact());
			clewExt.setParam(":VCL_CONTACTMAN", clewDao.getCl_contactman());
			clewExt.setParam(":VCL_ADDR", clewDao.getCl_addr());
			clewExt.setParam(":VCL_PER", clewDao.getCl_per());
			clewExt.setParam(":VCL_PAY", clewDao.getCl_pay());
			clewExt.setParam(":VSTATE_CODE", clewDao.getState_code());
			clewExt.setParam(":VGET_MODE", clewDao.getGet_mode());
			clewExt.setParam(":VGET_USER_NAME", clewDao.getGet_user_name());
			clewExt.setParam(":VGET_USER_ID", clewDao.getGet_user_id());
			clewExt.setParam(":VOPER_USER_ID", clewDao.getOper_user_id());
			clewExt.setParam(":VREMARK2", clewDao.getRemark2());
			tradeQuery.executeBy(clewExt.insBy("INS_BY_ALL"));
		}
		catch (RuntimeException e) {
			log.LOG_INFO(e.getMessage());
		}
		return 0;
	}
	
	
	
	// 修改线索信息
	public void updateClewInfo(Buffers inbuffer) {

		log.LOG_INFO("进入updateClewInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String clew_id = inbuffer.getString("CLEW_ID");
		String entity_type = inbuffer.getString("ENTITY_TYPE");
		String title = inbuffer.getString("TITLE");
		String content = inbuffer.getString("CONTENT");
		String cl_cust_name = inbuffer.getString("CL_CUST_NAME");
		String cl_cust_id = inbuffer.getString("CL_CUST_ID");
		String cl_contact = inbuffer.getString("CL_CONTACT");
		String cl_contactman = inbuffer.getString("CL_CONTACTMAN");
		String cl_addr = inbuffer.getString("CL_ADDR");
		String cl_per = inbuffer.getString("CL_PER");
		String cl_pay = inbuffer.getString("CL_PAY");
		String state_code = inbuffer.getString("STATE_CODE");
		String get_mode = inbuffer.getString("GET_MODE");
		String get_user_name = inbuffer.getString("GET_USER_NAME");
		String get_user_id = inbuffer.getString("GET_USER_ID");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");
		
		try {
			ClewInfoDAO clewDao = new ClewInfoDAO();
			clewDao.setCl_addr(cl_addr);
			clewDao.setCl_contact(cl_contact);
			clewDao.setCust_id(cust_id);
			clewDao.setClew_id(clew_id);
			clewDao.setEntity_type(entity_type);
			clewDao.setTitle(title);
			clewDao.setContent(content);
			clewDao.setCl_cust_name(cl_cust_name);
			clewDao.setCl_cust_id(cl_cust_id);
			clewDao.setCl_contactman(cl_contactman);
			clewDao.setCl_pay(cl_pay);
			clewDao.setCl_per(cl_per);
			clewDao.setState_code(state_code);
			clewDao.setGet_mode(get_mode);
			clewDao.setGet_user_id(get_user_id);
			clewDao.setGet_user_name(get_user_name);
			clewDao.setOper_user_id(oper_user_id);
			clewDao.setRemark2(remark2);
			iResult = updateClewInfo(clewDao);
		}
		catch (Exception 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("退出updateClewInfo方法...");
	}
	
	
	public int updateClewInfo(ClewInfoDAO clewDao) throws SaasApplicationException {

		ClewInfoExt clewExt = new ClewInfoExt();
		try {
			clewExt.setParam(":VCUST_ID", clewDao.getCust_id());
			clewExt.setParam(":VCLEW_ID", clewDao.getClew_id());
			clewExt.setParam(":VENTITY_TYPE", clewDao.getEntity_type());
			clewExt.setParam(":VTITLE", clewDao.getTitle());
			clewExt.setParam(":VCONTENT", clewDao.getContent());
			clewExt.setParam(":VCL_CUST_NAME", clewDao.getCl_cust_name());
			clewExt.setParam(":VCL_CUST_ID", clewDao.getCl_cust_id());
			clewExt.setParam(":VCL_CONTACT", clewDao.getCl_contact());
			clewExt.setParam(":VCL_CONTACTMAN", clewDao.getCl_contactman());
			clewExt.setParam(":VCL_ADDR", clewDao.getCl_addr());
			clewExt.setParam(":VCL_PER", clewDao.getCl_per());
			clewExt.setParam(":VCL_PAY", clewDao.getCl_pay());
			clewExt.setParam(":VSTATE_CODE", clewDao.getState_code());
			clewExt.setParam(":VGET_MODE", clewDao.getGet_mode());
			clewExt.setParam(":VGET_USER_NAME", clewDao.getGet_user_name());
			clewExt.setParam(":VGET_USER_ID", clewDao.getGet_user_id());
			clewExt.setParam(":VOPER_USER_ID", clewDao.getOper_user_id());
			clewExt.setParam(":VREMARK2", clewDao.getRemark2());
			tradeQuery.executeBy(clewExt.insBy("UP_BY_ID"));
		}
		catch (RuntimeException e) {
			log.LOG_INFO(e.getMessage());
		}
		return 0;
	}
	
	
	
	// 删除线索信息
	public void delClewInfo(Buffers inbuffer) {

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

		ClewInfoExt clewExt = new ClewInfoExt();
		clewExt.setParam(":VCLEW_ID", clew_id);
		tradeQuery.executeBy(clewExt.insBy("DEL_BY_ID"));
		return 0;
	}
	
	
	
	// 转为销售机会
	public void changeClewInfo(Buffers inbuffer) {

		log.LOG_INFO("进入changeClewInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		try {
			String clew_id = inbuffer.getString("CLEW_ID");
			String state_code = inbuffer.getString("STATE_CODE");
			iResult = changeClewInfo(clew_id, state_code);
		}
		catch (Exception 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("退出changeClewInfo方法...");
	}
	
	
	public int changeClewInfo(String clew_id, String state_code) throws SaasApplicationException {

		ClewInfoExt clewExt = new ClewInfoExt();
		clewExt.setParam(":VCLEW_ID", clew_id);
		clewExt.setParam(":VSTATE_CODE", state_code);
		tradeQuery.executeBy(clewExt.insBy("CHANGE_BY_ID"));
		return 0;
	}
	
	
	
	// 找出所有的线索信息
	public ArrayList getClewInfoByCust(String cust_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		ClewInfoExt clewExt = new ClewInfoExt();
		clewExt.setParam(":VCUST_ID", cust_id);
		list = clewExt.selByList("SEL_BY_CUST");
		return list;
	}
	
	
	public ArrayList getClewPageByCust(int iStart, String cust_id) throws SaasApplicationException {

		if (iStart == 0) {
			iStart = 0;
		}
		else {
			iStart = (iStart - 1) * 20;
		}
		ArrayList list = new ArrayList();
		ClewInfoExt clewExt = new ClewInfoExt();
		clewExt.setParam(":VCUST_ID", cust_id);
		list = clewExt.selByList("SEL_BY_CUST", iStart, 20);
		return list;
	}
	
	
	
	// 取出条数
	public int getClewPageSizeByCust(String cust_id) {

		int size = 0;
		ArrayList list = new ArrayList();
		ClewInfoExt clewExt = new ClewInfoExt();
		clewExt.setParam(":VCUST_ID", cust_id);
		list = clewExt.selByList("SEL_BY_SIZE");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	// 取出转为销售机会条数
	public int getClewPageSizeBySale(String cust_id) {

		int size = 0;
		ArrayList list = new ArrayList();
		ClewInfoExt clewExt = new ClewInfoExt();
		clewExt.setParam(":VCUST_ID", cust_id);
		list = clewExt.selByList("SEL_SALE_SIZE");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	// 通过状态取出销售线索
	public ArrayList getClewPageByState(int iStart, String cust_id, String state) throws SaasApplicationException {

		if (iStart == 0) {
			iStart = 0;
		}
		else {
			iStart = (iStart - 1) * 20;
		}
		ArrayList list = new ArrayList();
		ClewInfoExt clewExt = new ClewInfoExt();
		clewExt.setParam(":VCUST_ID", cust_id);
		clewExt.setParam(":VSTATE_CODE", state);
		list = clewExt.selByList("SEL_BY_STATE", iStart, 20);
		return list;
	}
	
	
	public int getClewPagesByState(String cust_id, String state) throws SaasApplicationException {

		int size = 0;
		ArrayList list = new ArrayList();
		ClewInfoExt clewExt = new ClewInfoExt();
		clewExt.setParam(":VCUST_ID", cust_id);
		clewExt.setParam(":VSTATE_CODE", state);
		list = clewExt.selByList("SEL_STATE_SIZE");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
		
	}
	
	
	
	// 取出单条记录
	public ArrayList getClewInfoById(String clew_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		ClewInfoExt clewExt = new ClewInfoExt();
		clewExt.setParam(":VCLEW_ID", clew_id);
		list = clewExt.selByList("SEL_BY_ID");
		return list;
	}
}