valueresultinfo.java

java阿里巴巴代码

package com.saas.biz.valueResultMgr;

import java.util.ArrayList;
import com.saas.biz.dao.valueResultDAO.ValueResultDAO;
import com.saas.biz.dao.valueResultDAO.ValueResultExt;
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 ValueResultInfo {
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	ArrayList queryResult = new ArrayList();

	public ValueResultInfo() {
		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 addResultList(Buffers inbuffer) {
		log.LOG_INFO("进入addResultList方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String channels_type = inbuffer.getString("CHANNELS_TYPE");
		String obj_cust_id = inbuffer.getString("OBJ_CUST_ID");
		String value_month = inbuffer.getString("VALUE_MONTH");
		String value_date = inbuffer.getString("VALUE_DATE");
		String value_num = inbuffer.getString("VALUE_NUM");
		String value_desc = inbuffer.getString("VALUE_DESC");
		String pat_tag = inbuffer.getString("PAT_TAG");
		String pay_date = inbuffer.getString("PAY_DATE");
		String pay_type = inbuffer.getString("PAY_TYPE");
		String pay_user_id = inbuffer.getString("PAY_USER_ID");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String in_date = inbuffer.getString("IN_DATE");
		String remark = inbuffer.getString("REMARK");

		try {
			ValueResultDAO valuedao = new ValueResultDAO();
			valuedao.setCust_id(cust_id);
			valuedao.setChannels_type(channels_type);
			valuedao.setObj_cust_id(obj_cust_id);
			valuedao.setValue_month(value_month);
			valuedao.setValue_date(value_date);
			valuedao.setValue_num(value_num);
			valuedao.setValue_desc(value_desc);
			valuedao.setPat_tag(pat_tag);
			valuedao.setPay_date(pay_date);
			valuedao.setPay_type(pay_type);
			valuedao.setPay_user_id(pay_user_id);
			valuedao.setOper_user_id(oper_user_id);
			valuedao.setIn_date(in_date);
			valuedao.setRemark(remark);

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

	public int addResultList(ValueResultDAO chvaDao)
			throws SaasApplicationException {

		ValueResultExt chvaExt = new ValueResultExt();
		// log.LOG_INFO("开始执行SQL:===:");
		chvaExt.setParam(":VCUST_ID", chvaDao.getCust_id());
		chvaExt.setParam(":VCHANNELS_TYPE", chvaDao.getChannels_type());
		chvaExt.setParam(":VOBJ_CUST_ID", chvaDao.getObj_cust_id());
		chvaExt.setParam(":VVALUE_MONTH", chvaDao.getValue_month());
		chvaExt.setParam(":VVALUE_DATE", chvaDao.getValue_date());
		chvaExt.setParam(":VVALUE_NUM", chvaDao.getValue_num());
		chvaExt.setParam(":VVALUE_DESC", chvaDao.getValue_desc());
		chvaExt.setParam(":VPAT_TAG", chvaDao.getPat_tag());
		chvaExt.setParam(":VPAY_DATE", chvaDao.getPay_date());
		chvaExt.setParam(":VPAY_TYPE", chvaDao.getPay_type());
		chvaExt.setParam(":VPAY_USER_ID", chvaDao.getPay_user_id());
		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_RESULT_LIST"));
		return 0;
	}

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

		if (iStart > 1) {
			iStart = (iStart - 1) * 20;
		} else {
			iStart = 0;
		}
		ValueResultExt chriExt = new ValueResultExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		ArrayList list = chriExt.selByList("SEL_BY_KKK", iStart, 20);
//		log.LOG_INFO("=================" + list + "=======================");
		return list;
	}

	public int getAllValueList(String cust_id) throws SaasApplicationException {
		int count = 0;
		ValueResultExt chriExt = new ValueResultExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		ArrayList list = chriExt.selByList("SEL_BY_KKK");
		if (list != null && list.size() > 0) {
			count = list.size();
		}
		return count;
	}

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

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入modifyResultList方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String channels_type = inbuffer.getString("CHANNELS_TYPE");
		String obj_cust_id = inbuffer.getString("OBJ_CUST_ID");
		String value_month = inbuffer.getString("VALUE_MONTH");
		String value_date = inbuffer.getString("VALUE_DATE");
		String value_num = inbuffer.getString("VALUE_NUM");
		String value_desc = inbuffer.getString("VALUE_DESC");
		String pat_tag = inbuffer.getString("PAT_TAG");
		String pay_date = inbuffer.getString("PAY_DATE");
		String pay_type = inbuffer.getString("PAY_TYPE");
		String pay_user_id = inbuffer.getString("PAY_USER_ID");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String in_date = inbuffer.getString("IN_DATE");
		String remark = inbuffer.getString("REMARK");

		try {
			ValueResultDAO valuedao = new ValueResultDAO();
			valuedao.setCust_id(cust_id);
			valuedao.setChannels_type(channels_type);
			valuedao.setObj_cust_id(obj_cust_id);
			valuedao.setValue_month(value_month);
			valuedao.setValue_date(value_date);
			valuedao.setValue_num(value_num);
			valuedao.setValue_desc(value_desc);
			valuedao.setPat_tag(pat_tag);
			valuedao.setPay_date(pay_date);
			valuedao.setPay_type(pay_type);
			valuedao.setPay_user_id(pay_user_id);
			valuedao.setOper_user_id(oper_user_id);
			valuedao.setIn_date(in_date);
			valuedao.setRemark(remark);

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

	public int modifyResultList(ValueResultDAO chvaDao)
			throws SaasApplicationException {

		ValueResultExt chvaExt = new ValueResultExt();
		chvaExt.setParam(":VCUST_ID", chvaDao.getCust_id());
		chvaExt.setParam(":VCHANNELS_TYPE", chvaDao.getChannels_type());
		chvaExt.setParam(":VOBJ_CUST_ID", chvaDao.getObj_cust_id());
		chvaExt.setParam(":VVALUE_MONTH", chvaDao.getValue_month());
		chvaExt.setParam(":VVALUE_DATE", chvaDao.getValue_date());
		chvaExt.setParam(":VVALUE_NUM", chvaDao.getValue_num());
		chvaExt.setParam(":VVALUE_DESC", chvaDao.getValue_desc());
		chvaExt.setParam(":VPAT_TAG", chvaDao.getPat_tag());
		chvaExt.setParam(":VPAY_DATE", chvaDao.getPay_date());
		chvaExt.setParam(":VPAY_TYPE", chvaDao.getPay_type());
		chvaExt.setParam(":VPAY_USER_ID", chvaDao.getPay_user_id());
		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 {

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

	public ArrayList getValueById(String cust_id)
			throws SaasApplicationException {

		ArrayList relationList = new ArrayList();
		ValueResultExt relaExt = new ValueResultExt();
		relaExt.setParam(":VCUST_ID", cust_id);
		relationList = relaExt.selByList("SEL_BY_KKK");

		return relationList;
	}

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

		ArrayList relationList = new ArrayList();
		ValueResultExt relaExt = new ValueResultExt();
		relaExt.setParam(":VCUST_ID", cust_id);
		relaExt.setParam(":VTEST_ID", test_id);
		relationList = relaExt.selByList("SEL_ONE_BY_TEST_ID");
		return relationList;
	}

}