cmdstateinfo.java

java阿里巴巴代码

package com.saas.biz.cmdStateMgr;

import java.util.ArrayList;
import com.saas.biz.dao.cmdStateDAO.CmdStateDAO;
import com.saas.biz.dao.cmdStateDAO.CmdStateExt;
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 CmdStateInfo {
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	ArrayList queryResult = new ArrayList();

	public CmdStateInfo() {
		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 addCmdInfo(Buffers inbuffer) {
		log.LOG_INFO("进入addCmdInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String cmd_id = inbuffer.getString("CMD_ID");
		String state_code = inbuffer.getString("STATE_CODE");
		String start_date = inbuffer.getString("START_DATE");
		String end_date = inbuffer.getString("END_DATE");
		String state_code_date = inbuffer.getString("STATE_CODE_DATE");
		String state_resean = inbuffer.getString("STATE_RESEAN");
		String now_addr = inbuffer.getString("NOW_ADDR");
		String oper_date = inbuffer.getString("OPER_DATE");
		String user_id = inbuffer.getString("SESSION_USER_ID");
		String remark = inbuffer.getString("REMARK");

		try {
			CmdStateDAO cmddao = new CmdStateDAO();
			cmddao.setCust_id(cust_id);
			cmddao.setCmd_id(cmd_id);
			cmddao.setState_code(state_code);
			cmddao.setStart_date(start_date);
			cmddao.setEnd_date(end_date);
			cmddao.setState_code_date(state_code_date);
			cmddao.setState_resean(state_resean);
			cmddao.setNow_addr(now_addr);
			cmddao.setOper_date(oper_date);
			cmddao.setUser_id(user_id);
			cmddao.setRemark(remark);

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

	public int addCmdInfo(CmdStateDAO cmdDao) throws SaasApplicationException {

		CmdStateExt cmdExt = new CmdStateExt();
		// log.LOG_INFO("开始执行SQL:===:");
		cmdExt.setParam(":VCUST_ID", cmdDao.getCust_id());
		cmdExt.setParam(":VCMD_ID", cmdDao.getCmd_id());
		cmdExt.setParam(":VSTATE_CODE", cmdDao.getState_code());
		cmdExt.setParam(":VSTART_DATE", cmdDao.getStart_date());
		cmdExt.setParam(":VEND_DATE", cmdDao.getEnd_date());
		cmdExt.setParam(":VSTATE_CODE_DATE", cmdDao.getState_code_date());
		cmdExt.setParam(":VSTATE_RESEAN", cmdDao.getState_resean());
		cmdExt.setParam(":VNOW_ADDR", cmdDao.getNow_addr());
		cmdExt.setParam(":VOPER_DATE", cmdDao.getOper_date());
		cmdExt.setParam(":VUSER_ID", cmdDao.getUser_id());
		cmdExt.setParam(":VREMARK", cmdDao.getRemark());

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

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

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

	public int getCmdStateList(String cust_id) throws SaasApplicationException {
		int count = 0;
		CmdStateExt chriExt = new CmdStateExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		ArrayList list = chriExt.selByList("SEL_BY_STATE");
		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 cmd_id = inbuffer.getString("CMD_ID");
		String state_code = inbuffer.getString("STATE_CODE");
		String start_date = inbuffer.getString("START_DATE");
		String end_date = inbuffer.getString("END_DATE");
		String state_code_date = inbuffer.getString("STATE_CODE_DATE");
		String state_resean = inbuffer.getString("STATE_RESEAN");
		String now_addr = inbuffer.getString("NOW_ADDR");
		String oper_date = inbuffer.getString("OPER_DATE");
		String user_id = inbuffer.getString("SESSION_USER_ID");
		String remark = inbuffer.getString("REMARK");

		try {
			CmdStateDAO cmddao = new CmdStateDAO();
			cmddao.setCust_id(cust_id);
			cmddao.setCmd_id(cmd_id);
			cmddao.setState_code(state_code);
			cmddao.setStart_date(start_date);
			cmddao.setEnd_date(end_date);
			cmddao.setState_code_date(state_code_date);
			cmddao.setState_resean(state_resean);
			cmddao.setNow_addr(now_addr);
			cmddao.setOper_date(oper_date);
			cmddao.setUser_id(user_id);
			cmddao.setRemark(remark);

			iResult = modifyFixList(cmddao);
		} 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(CmdStateDAO cmdDao)
			throws SaasApplicationException {

		CmdStateExt cmdExt = new CmdStateExt();
		// log.LOG_INFO("开始执行SQL:===:");
		cmdExt.setParam(":VCUST_ID", cmdDao.getCust_id());
		cmdExt.setParam(":VCMD_ID", cmdDao.getCmd_id());
		cmdExt.setParam(":VSTATE_CODE", cmdDao.getState_code());
		cmdExt.setParam(":VSTART_DATE", cmdDao.getStart_date());
		cmdExt.setParam(":VEND_DATE", cmdDao.getEnd_date());
		cmdExt.setParam(":VSTATE_CODE_DATE", cmdDao.getState_code_date());
		cmdExt.setParam(":VSTATE_RESEAN", cmdDao.getState_resean());
		cmdExt.setParam(":VNOW_ADDR", cmdDao.getNow_addr());
		cmdExt.setParam(":VOPER_DATE", cmdDao.getOper_date());
		cmdExt.setParam(":VUSER_ID", cmdDao.getUser_id());
		cmdExt.setParam(":VREMARK", cmdDao.getRemark());

		tradeQuery.executeBy(cmdExt.insBy("UP_CMD_BY_ALL"));
		return 0;
	}

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

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

}