channelsvalueinfo.java

java阿里巴巴代码

package com.saas.biz.channelsValueMgr;

import java.util.ArrayList;
import java.util.HashMap;
import com.saas.biz.dao.channelsValueDAO.ChannelsValueDAO;
import com.saas.biz.dao.channelsValueDAO.ChannelsValueExt;
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 ChannelsValueInfo {
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	ArrayList queryResult = new ArrayList();

	public ChannelsValueInfo() {
		log = new Logger(this);
		tradeQuery = new Dbtable();
		outBuffer = new Buffers();
	}

	public void setOutBuffer(Buffers outBuffer) {
		this.outBuffer = outBuffer;
	}

	public Buffers getOutBuffer() {
		return this.outBuffer;
	}

	public void setTradeQuery(Dbtable tradeQuery) {
		this.tradeQuery = tradeQuery;
	}

	public Dbtable getTradeQuery() {
		return this.tradeQuery;
	}

	public ArrayList getQueryResult() {
		return this.queryResult;
	}

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

	// 添加返利参数表
	public void addChannelsValue(Buffers inbuffer) {
		log.LOG_INFO("进入addChannelsValue方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String channels_id = inbuffer.getString("CHANNELS_ID");
		String value_id = inbuffer.getString("VALUE_ID");
		String value_name = inbuffer.getString("VALUE_NAME");
		String value_code = inbuffer.getString("VALUE_CODE");
		String value_type = inbuffer.getString("VALUE_TYPE");
		String value_num = inbuffer.getString("VALUE_NUM");
		String value_rage = inbuffer.getString("VALUE_RAGE");
		String value_cust_id = inbuffer.getString("VALUE_CUST_ID");
		String start_date = inbuffer.getString("START_DATE");
		String end_date = inbuffer.getString("END_DATE");
		String class_rage = inbuffer.getString("CLASS_RAGE");
		String level_rage = inbuffer.getString("LEVEL_RAGE");
		String first_tag = inbuffer.getString("FIRST_TAG");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String in_date = inbuffer.getString("IN_DATE");
		String remark = inbuffer.getString("REMARK");

		try {
			ChannelsValueDAO channelsvaluedao = new ChannelsValueDAO();
			channelsvaluedao.setCust_id(cust_id);
			channelsvaluedao.setChannels_id(channels_id);
			channelsvaluedao.setValue_id(value_id);
			channelsvaluedao.setValue_name(value_name);
			channelsvaluedao.setValue_code(value_code);
			channelsvaluedao.setValue_type(value_type);
			channelsvaluedao.setValue_num(value_num);
			channelsvaluedao.setValue_rage(value_rage);
			channelsvaluedao.setValue_cust_id(value_cust_id);
			channelsvaluedao.setStart_date(start_date);
			channelsvaluedao.setEnd_date(end_date);
			channelsvaluedao.setClass_rage(class_rage);
			channelsvaluedao.setLevel_rage(level_rage);
			channelsvaluedao.setFirst_tag(first_tag);
			channelsvaluedao.setOper_user_id(oper_user_id);
			channelsvaluedao.setIn_date(in_date);
			channelsvaluedao.setRemark(remark);

			iResult = addChannelsValue(channelsvaluedao);
		} 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("退出addChannelsValue方法...");
	}

	public int addChannelsValue(ChannelsValueDAO chvaDao)
			throws SaasApplicationException {

		ChannelsValueExt chvaExt = new ChannelsValueExt();
		// log.LOG_INFO("开始执行SQL:===:");
		chvaExt.setParam(":VCUST_ID", chvaDao.getCust_id());
		chvaExt.setParam(":VCHANNELS_ID", chvaDao.getChannels_id());
		chvaExt.setParam(":VVALUE_ID", chvaDao.getValue_id());
		chvaExt.setParam(":VVALUE_NAME", chvaDao.getValue_name());
		chvaExt.setParam(":VVALUE_CODE", chvaDao.getValue_code());
		chvaExt.setParam(":VVALUE_TYPE", chvaDao.getValue_type());
		chvaExt.setParam(":VVALUE_NUM", chvaDao.getValue_num());
		chvaExt.setParam(":VVALUE_RAGE", chvaDao.getValue_rage());
		chvaExt.setParam(":VVALUE_CUST_ID", chvaDao.getValue_cust_id());
		chvaExt.setParam(":VSTART_DATE", chvaDao.getStart_date());
		chvaExt.setParam(":VEND_DATE", chvaDao.getEnd_date());
		chvaExt.setParam(":VCLASS_RAGE", chvaDao.getClass_rage());
		chvaExt.setParam(":VLEVEL_RAGE", chvaDao.getLevel_rage());
		chvaExt.setParam(":VFIRST_TAG", chvaDao.getFirst_tag());
		chvaExt.setParam(":VOPER_USER_ID", chvaDao.getOper_user_id());
		chvaExt.setParam(":VIN_DATE", chvaDao.getIn_date());
		chvaExt.setParam(":VREMARK", chvaDao.getRemark());

		// log.LOG_INFO("开始执行SQL:===:" + chvaExt.insBy("INS_BY_CHA_VALUE"));
		tradeQuery.executeBy(chvaExt.insBy("INS_BY_CHA_VALUE"));
		return 0;
	}

	public ArrayList getListByValue(int iStart, String cust_id)
			throws SaasApplicationException {

		
			iStart = iStart  * 20;
		
		ChannelsValueExt chriExt = new ChannelsValueExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		ArrayList list = chriExt.selByList("SEL_BY_VALUE", iStart, 20);
		return list;
	}

	public int getListByValueCt(String cust_id) throws SaasApplicationException {

		int size = 0;
		ChannelsValueExt chriExt = new ChannelsValueExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		ArrayList list = chriExt.selByList("SEL_VLAUE_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}

	// 修改经销商权限
	public void modifyChannelsValue(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入modifyChannelsValue方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String channels_id = inbuffer.getString("CHANNELS_ID");
		String value_id = inbuffer.getString("VALUE_ID");
		String value_name = inbuffer.getString("VALUE_NAME");
		String value_code = inbuffer.getString("VALUE_CODE");
		String value_type = inbuffer.getString("VALUE_TYPE");
		String value_num = inbuffer.getString("VALUE_NUM");
		String value_rage = inbuffer.getString("VALUE_RAGE");
		String value_cust_id = inbuffer.getString("VALUE_CUST_ID");
		String start_date = inbuffer.getString("START_DATE");
		String end_date = inbuffer.getString("END_DATE");
		String class_rage = inbuffer.getString("CLASS_RAGE");
		String level_rage = inbuffer.getString("LEVEL_RAGE");
		String first_tag = inbuffer.getString("FIRST_TAG");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String in_date = inbuffer.getString("IN_DATE");
		String remark = inbuffer.getString("REMARK");

		try {
			ChannelsValueDAO channelsvaluedao = new ChannelsValueDAO();
			channelsvaluedao.setCust_id(cust_id);
			channelsvaluedao.setChannels_id(channels_id);
			channelsvaluedao.setValue_id(value_id);
			channelsvaluedao.setValue_name(value_name);
			channelsvaluedao.setValue_code(value_code);
			channelsvaluedao.setValue_type(value_type);
			channelsvaluedao.setValue_num(value_num);
			channelsvaluedao.setValue_rage(value_rage);
			channelsvaluedao.setValue_cust_id(value_cust_id);
			channelsvaluedao.setStart_date(start_date);
			channelsvaluedao.setEnd_date(end_date);
			channelsvaluedao.setClass_rage(class_rage);
			channelsvaluedao.setLevel_rage(level_rage);
			channelsvaluedao.setFirst_tag(first_tag);
			channelsvaluedao.setOper_user_id(oper_user_id);
			channelsvaluedao.setIn_date(in_date);
			channelsvaluedao.setRemark(remark);

			iResult = modifyChannelsValue(channelsvaluedao);
		} 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("退出modifyChannelsValue方法...");
	}

	public int modifyChannelsValue(ChannelsValueDAO chvaDao)
			throws SaasApplicationException {

		ChannelsValueExt chvaExt = new ChannelsValueExt();
		chvaExt.setParam(":VCUST_ID", chvaDao.getCust_id());
		chvaExt.setParam(":VCHANNELS_ID", chvaDao.getChannels_id());
		chvaExt.setParam(":VVALUE_ID", chvaDao.getValue_id());
		chvaExt.setParam(":VVALUE_NAME", chvaDao.getValue_name());
		chvaExt.setParam(":VVALUE_CODE", chvaDao.getValue_code());
		chvaExt.setParam(":VVALUE_TYPE", chvaDao.getValue_type());
		chvaExt.setParam(":VVALUE_NUM", chvaDao.getValue_num());
		chvaExt.setParam(":VVALUE_RAGE", chvaDao.getValue_rage());
		chvaExt.setParam(":VVALUE_CUST_ID", chvaDao.getValue_cust_id());
		chvaExt.setParam(":VSTART_DATE", chvaDao.getStart_date());
		chvaExt.setParam(":VEND_DATE", chvaDao.getEnd_date());
		chvaExt.setParam(":VCLASS_RAGE", chvaDao.getClass_rage());
		chvaExt.setParam(":VLEVEL_RAGE", chvaDao.getLevel_rage());
		chvaExt.setParam(":VFIRST_TAG", chvaDao.getFirst_tag());
		chvaExt.setParam(":VOPER_USER_ID", chvaDao.getOper_user_id());
		chvaExt.setParam(":VIN_DATE", chvaDao.getIn_date());
		chvaExt.setParam(":VREMARK", chvaDao.getRemark());
		tradeQuery.executeBy(chvaExt.insBy("UP_VALUE_BY_ALL"));
		return 0;
	}

	public ArrayList getListByValueId(String cust_id, String test_id)
			throws SaasApplicationException {

		ChannelsValueExt chriExt = new ChannelsValueExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		chriExt.setParam(":VTEST_ID", test_id);
		ArrayList list = chriExt.selByList("SEL_BY_VALUE_ID");
		return list;
	}

	public ArrayList getListByValueById(String cust_id, String value_id)
			throws SaasApplicationException {

		ChannelsValueExt chriExt = new ChannelsValueExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		chriExt.setParam(":VVALUE_ID", value_id);
		ArrayList list = chriExt.selByList("SEL_BY_VALUE_ID");
		return list;
	}

	public void delChannelsValue(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入delChannelsValue方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String value_id = inbuffer.getString("VALUE_ID");

		try {
			ChannelsValueDAO chridao = new ChannelsValueDAO();
			chridao.setCust_id(cust_id);
			chridao.setValue_id(value_id);

			iResult = delChannelsValue(chridao);
		} 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("退出delChannelsValue方法...");
	}

	public int delChannelsValue(ChannelsValueDAO chriDao)
			throws SaasApplicationException {

		ChannelsValueExt chriExt = new ChannelsValueExt();
		chriExt.setParam(":VCUST_ID", chriDao.getCust_id());
		chriExt.setParam(":VVALUE_ID", chriDao.getValue_id());

		// log.LOG_INFO("开始执行SQL:===:" + chriExt.insBy("DEL_RIG_BY_ALL"));
		tradeQuery.executeBy(chriExt.insBy("DEL_VALUE_BY_ALL"));
		return 0;
	}

	public ArrayList getValueById(String cust_id)
			throws SaasApplicationException {

		ArrayList relationList = new ArrayList();
		ChannelsValueExt relaExt = new ChannelsValueExt();
		relaExt.setParam(":VCUST_ID", cust_id);
		relationList = relaExt.selByList("SEL_BY_VALUE");
		return relationList;
	}

}