shopcommandinfo.java

java阿里巴巴代码

package com.saas.biz.shopCommandMgr;

import java.util.ArrayList;
import com.saas.biz.dao.shopCommandDAO.ShopCommandDAO;
import com.saas.biz.dao.shopCommandDAO.ShopCommandExt;
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 ShopCommandInfo {
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	ArrayList queryResult = new ArrayList();

	public ShopCommandInfo() {
		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 addCommandList(Buffers inbuffer) {
		log.LOG_INFO("进入addCommandList方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String task_id = inbuffer.getString("TASK_ID");
		String cmd_id = inbuffer.getString("CMD_ID");
		String cmd_order = inbuffer.getString("CMD_ORDER");
		String cmd_obj_id = inbuffer.getString("CMD_OBJ_ID");
		String cmd_obj_name = inbuffer.getString("CMD_OBJ_NAME");
		String pre_date = inbuffer.getString("PRE_DATE");
		String act_date = inbuffer.getString("ACT_DATE");
		String from_addr = inbuffer.getString("FROM_ADDR");
		String to_addr = inbuffer.getString("TO_ADDR");
		String ship_type = inbuffer.getString("SHIP_TYPE");
		String cmd_num = inbuffer.getString("CMD_NUM");
		String unit = inbuffer.getString("UNIT");
		String state_code = inbuffer.getString("STATE_CODE");
		String state_code_date = inbuffer.getString("STATE_CODE_DATE");
		String user_id = inbuffer.getString("SESSION_USER_ID");
		String publish_date = inbuffer.getString("PUBLISH_DATE");
		String remark = inbuffer.getString("REMARK");

		try {
			ShopCommandDAO shopDao = new ShopCommandDAO();
			shopDao.setCust_id(cust_id);
			shopDao.setTask_id(task_id);
			shopDao.setCmd_id(cmd_id);
			shopDao.setCmd_order(cmd_order);
			shopDao.setCmd_obj_id(cmd_obj_id);
			shopDao.setCmd_obj_name(cmd_obj_name);
			shopDao.setPre_date(pre_date);
			shopDao.setAct_date(act_date);
			shopDao.setFrom_addr(from_addr);
			shopDao.setTo_addr(to_addr);
			shopDao.setShip_type(ship_type);
			shopDao.setCmd_num(cmd_num);
			shopDao.setUnit(unit);
			shopDao.setState_code(state_code);
			shopDao.setState_code_date(state_code_date);
			shopDao.setUser_id(user_id);
			shopDao.setPublish_date(publish_date);
			shopDao.setRemark(remark);

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

	public int addCommandList(ShopCommandDAO shopDao)
			throws SaasApplicationException {

		ShopCommandExt shopExt = new ShopCommandExt();
		// log.LOG_INFO("开始执行SQL:===:");
		shopExt.setParam(":VCUST_ID", shopDao.getCust_id());
		shopExt.setParam(":VTASK_ID", shopDao.getTask_id());
		shopExt.setParam(":VCMD_ID", shopDao.getCmd_id());
		shopExt.setParam(":VCMD_ORDER", shopDao.getCmd_order());
		shopExt.setParam(":VCMD_OBJ_ID", shopDao.getCmd_obj_id());
		shopExt.setParam(":VCMD_OBJ_NAME", shopDao.getCmd_obj_name());
		shopExt.setParam(":VPRE_DATE", shopDao.getPre_date());
		shopExt.setParam(":VACT_DATE", shopDao.getAct_date());
		shopExt.setParam(":VFROM_ADDR", shopDao.getFrom_addr());
		shopExt.setParam(":VTO_ADDR", shopDao.getTo_addr());
		shopExt.setParam(":VSHIP_TYPE", shopDao.getShip_type());
		shopExt.setParam(":VCMD_NUM", shopDao.getCmd_num());
		shopExt.setParam(":VUNIT", shopDao.getUnit());
		shopExt.setParam(":VSTATE_CODE", shopDao.getState_code());
		shopExt.setParam(":VSTATE_CODE_DATE", shopDao.getState_code_date());
		shopExt.setParam(":VUSER_ID", shopDao.getUser_id());
		shopExt.setParam(":VPUBLISH_DATE", shopDao.getPublish_date());
		shopExt.setParam(":VREMARK", shopDao.getRemark());

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

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

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

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

	public void modifyCommandList(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入modifyCommandList方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String cmd_id = inbuffer.getString("CMD_ID");
		String cmd_order = inbuffer.getString("CMD_ORDER");
		String cmd_obj_id = inbuffer.getString("CMD_OBJ_ID");
		String cmd_obj_name = inbuffer.getString("CMD_OBJ_NAME");
		String pre_date = inbuffer.getString("PRE_DATE");
		String act_date = inbuffer.getString("ACT_DATE");
		String from_addr = inbuffer.getString("FROM_ADDR");
		String to_addr = inbuffer.getString("TO_ADDR");
		String ship_type = inbuffer.getString("SHIP_TYPE");
		String cmd_num = inbuffer.getString("CMD_NUM");
		String unit = inbuffer.getString("UNIT");
		String state_code = inbuffer.getString("STATE_CODE");
		String state_code_date = inbuffer.getString("STATE_CODE_DATE");
		String user_id = inbuffer.getString("SESSION_USER_ID");
		String publish_date = inbuffer.getString("PUBLISH_DATE");
		String remark = inbuffer.getString("REMARK");

		try {
			ShopCommandDAO shopDao = new ShopCommandDAO();
			shopDao.setCust_id(cust_id);
			shopDao.setCmd_id(cmd_id);
			shopDao.setCmd_order(cmd_order);
			shopDao.setCmd_obj_id(cmd_obj_id);
			shopDao.setCmd_obj_name(cmd_obj_name);
			shopDao.setPre_date(pre_date);
			shopDao.setAct_date(act_date);
			shopDao.setFrom_addr(from_addr);
			shopDao.setTo_addr(to_addr);
			shopDao.setShip_type(ship_type);
			shopDao.setCmd_num(cmd_num);
			shopDao.setUnit(unit);
			shopDao.setState_code(state_code);
			shopDao.setState_code_date(state_code_date);
			shopDao.setUser_id(user_id);
			shopDao.setPublish_date(publish_date);
			shopDao.setRemark(remark);

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

	public int modifyCommandList(ShopCommandDAO shopDao)
			throws SaasApplicationException {

		ShopCommandExt shopExt = new ShopCommandExt();
		shopExt.setParam(":VCUST_ID", shopDao.getCust_id());
		shopExt.setParam(":VCMD_ID", shopDao.getCmd_id());
		shopExt.setParam(":VCMD_ORDER", shopDao.getCmd_order());
		shopExt.setParam(":VCMD_OBJ_ID", shopDao.getCmd_obj_id());
		shopExt.setParam(":VCMD_OBJ_NAME", shopDao.getCmd_obj_name());
		shopExt.setParam(":VPRE_DATE", shopDao.getPre_date());
		shopExt.setParam(":VACT_DATE", shopDao.getAct_date());
		shopExt.setParam(":VFROM_ADDR", shopDao.getFrom_addr());
		shopExt.setParam(":VTO_ADDR", shopDao.getTo_addr());
		shopExt.setParam(":VSHIP_TYPE", shopDao.getShip_type());
		shopExt.setParam(":VCMD_NUM", shopDao.getCmd_num());
		shopExt.setParam(":VUNIT", shopDao.getUnit());
		shopExt.setParam(":VSTATE_CODE", shopDao.getState_code());
		shopExt.setParam(":VSTATE_CODE_DATE", shopDao.getState_code_date());
		shopExt.setParam(":VUSER_ID", shopDao.getUser_id());
		shopExt.setParam(":VPUBLISH_DATE", shopDao.getPublish_date());
		shopExt.setParam(":VREMARK", shopDao.getRemark());
		tradeQuery.executeBy(shopExt.insBy("UP_COMM_BY_ALL"));
		return 0;
	}

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

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

	public void delCommandList(Buffers inbuffer) {

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

		try {
			ShopCommandDAO shopDao = new ShopCommandDAO();
			shopDao.setCust_id(cust_id);
			shopDao.setCmd_id(cmd_id);

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

	public int delCommandList(ShopCommandDAO shopDao)
			throws SaasApplicationException {

		ShopCommandExt shopExt = new ShopCommandExt();
		shopExt.setParam(":VCUST_ID", shopDao.getCust_id());
		shopExt.setParam(":VCMD_ID", shopDao.getCmd_id());

		tradeQuery.executeBy(shopExt.insBy("DEL_COMM_BY_ALL"));
		return 0;
	}

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

		ShopCommandExt chriExt = new ShopCommandExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		chriExt.setParam(":VCMD_ID", cmd_id);
		ArrayList list = chriExt.selByList("SEL_BY_CMD_ID");
		return list;
	}
}