autofixinfo.java

java阿里巴巴代码

package com.saas.biz.autoFixMgr;

import java.util.ArrayList;
import com.saas.biz.dao.autoFixDAO.AutoFixDAO;
import com.saas.biz.dao.autoFixDAO.AutoFixExt;
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 AutoFixInfo {
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	ArrayList queryResult = new ArrayList();

	public AutoFixInfo() {
		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 addFixInfo(Buffers inbuffer) {
		log.LOG_INFO("进入addFixInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String auto_id = inbuffer.getString("AUTO_ID");
		String trade_id = inbuffer.getString("TRADE_ID");
		String fix_title = inbuffer.getString("FIX_TITLE");
		String fix_type = inbuffer.getString("FIX_TYPE");
		String fix = inbuffer.getString("FIX");
		String fee = inbuffer.getString("FEE");
		String pay_type = inbuffer.getString("PAY_TYPE");
		String bill_no = inbuffer.getString("BILL_NO");
		String fix_addr = inbuffer.getString("FIX_ADDR");
		String fix_man = inbuffer.getString("FIX_MAN");
		String oper_date = inbuffer.getString("OPER_DATE");
		String user_id = inbuffer.getString("SESSION_USER_ID");
		String remark = inbuffer.getString("REMARK");

		try {
			AutoFixDAO fixdao = new AutoFixDAO();
			fixdao.setCust_id(cust_id);
			fixdao.setAuto_id(auto_id);
			fixdao.setTrade_id(trade_id);
			fixdao.setFix_title(fix_title);
			fixdao.setFix_type(fix_type);
			fixdao.setFix(fix);
			fixdao.setFee(fee);
			fixdao.setPay_type(pay_type);
			fixdao.setBill_no(bill_no);
			fixdao.setFix_addr(fix_addr);
			fixdao.setFix_man(fix_man);
			fixdao.setOper_date(oper_date);
			fixdao.setUser_id(user_id);
			fixdao.setRemark(remark);

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

	public int addFixInfo(AutoFixDAO fixDao) throws SaasApplicationException {

		AutoFixExt fixExt = new AutoFixExt();
		// log.LOG_INFO("开始执行SQL:===:");
		fixExt.setParam(":VCUST_ID", fixDao.getCust_id());
		fixExt.setParam(":VAUTO_ID", fixDao.getAuto_id());
		fixExt.setParam(":VTRADE_ID", fixDao.getTrade_id());
		fixExt.setParam(":VFIX_TITLE", fixDao.getFix_title());
		fixExt.setParam(":VFIX_TYPE", fixDao.getFix_type());
		fixExt.setParam(":VFIX", fixDao.getFix());
		fixExt.setParam(":VFEE", fixDao.getFee());
		fixExt.setParam(":VPAY_TYPE", fixDao.getPay_type());
		fixExt.setParam(":VBILL_NO", fixDao.getBill_no());
		fixExt.setParam(":VFIX_ADDR", fixDao.getFix_addr());
		fixExt.setParam(":VFIX_MAN", fixDao.getFix_man());
		fixExt.setParam(":VOPER_DATE", fixDao.getOper_date());
		fixExt.setParam(":VUSER_ID", fixDao.getUser_id());
		fixExt.setParam(":VREMARK", fixDao.getRemark());

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

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

		iStart = iStart  * 20;
	    AutoFixExt chriExt = new AutoFixExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		ArrayList list = chriExt.selByList("SEL_BY_DDD", iStart, 20);
//		log.LOG_INFO("=================" + list + "=======================");
		return list;
	}

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

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

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入modifyFixList方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String trade_id = inbuffer.getString("TRADE_ID");
		String fix_title = inbuffer.getString("FIX_TITLE");
		String fix_type = inbuffer.getString("FIX_TYPE");
		String fix = inbuffer.getString("FIX");
		String fee = inbuffer.getString("FEE");
		String pay_type = inbuffer.getString("PAY_TYPE");
		String bill_no = inbuffer.getString("BILL_NO");
		String fix_addr = inbuffer.getString("FIX_ADDR");
		String fix_man = inbuffer.getString("FIX_MAN");
		String oper_date = inbuffer.getString("OPER_DATE");
		String user_id = inbuffer.getString("SESSION_USER_ID");
		String remark = inbuffer.getString("REMARK");
		try {
			AutoFixDAO fixdao = new AutoFixDAO();
			fixdao.setCust_id(cust_id);
			fixdao.setTrade_id(trade_id);
			fixdao.setFix_title(fix_title);
			fixdao.setFix_type(fix_type);
			fixdao.setFix(fix);
			fixdao.setFee(fee);
			fixdao.setPay_type(pay_type);
			fixdao.setBill_no(bill_no);
			fixdao.setFix_addr(fix_addr);
			fixdao.setFix_man(fix_man);
			fixdao.setOper_date(oper_date);
			fixdao.setUser_id(user_id);
			fixdao.setRemark(remark);

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

	public int modifyFixList(AutoFixDAO fixDao)
			throws SaasApplicationException {

		AutoFixExt fixExt = new AutoFixExt();
		fixExt.setParam(":VCUST_ID", fixDao.getCust_id());
		fixExt.setParam(":VTRADE_ID", fixDao.getTrade_id());
		fixExt.setParam(":VFIX_TITLE", fixDao.getFix_title());
		fixExt.setParam(":VFIX_TYPE", fixDao.getFix_type());
		fixExt.setParam(":VFIX", fixDao.getFix());
		fixExt.setParam(":VFEE", fixDao.getFee());
		fixExt.setParam(":VPAY_TYPE", fixDao.getPay_type());
		fixExt.setParam(":VBILL_NO", fixDao.getBill_no());
		fixExt.setParam(":VFIX_ADDR", fixDao.getFix_addr());
		fixExt.setParam(":VFIX_MAN", fixDao.getFix_man());
		fixExt.setParam(":VOPER_DATE", fixDao.getOper_date());
		fixExt.setParam(":VUSER_ID", fixDao.getUser_id());
		fixExt.setParam(":VREMARK", fixDao.getRemark());

		tradeQuery.executeBy(fixExt.insBy("UP_AUTO_BY_ALL"));
		return 0;
	}

	public ArrayList getListByTradeId(String cust_id, String trade_id)
			throws SaasApplicationException {

		AutoFixExt chriExt = new AutoFixExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		chriExt.setParam(":VTRADE_ID", trade_id);
		ArrayList list = chriExt.selByList("SEL_BY_TRADE_ID");
		return list;
	}

	public ArrayList getValueById(String cust_id)
			throws SaasApplicationException {

		ArrayList relationList = new ArrayList();
		AutoFixExt relaExt = new AutoFixExt();
		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();
		AutoFixExt relaExt = new AutoFixExt();
		relaExt.setParam(":VCUST_ID", cust_id);
		relaExt.setParam(":VTEST_ID", test_id);
		relationList = relaExt.selByList("SEL_ONE_BY_TEST_ID");
		return relationList;
	}

	public void DelFixList(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入DelFixList方法...");
		int iResult = -1;
		String trade_id = inbuffer.getString("TRADE_ID");
		try {
			AutoFixDAO fixdao = new AutoFixDAO();
			fixdao.setTrade_id(trade_id);

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

	public int DelFixList(AutoFixDAO fixDao)
			throws SaasApplicationException {

		AutoFixExt fixExt = new AutoFixExt();
		fixExt.setParam(":VTRADE_ID", fixDao.getTrade_id());

		tradeQuery.executeBy(fixExt.insBy("DEL_AUTO_BY_ID"));
		return 0;
	}
}