stockqueryinfo.java

java阿里巴巴代码

package com.saas.biz.stockQueryMgr;

import java.util.ArrayList;
import java.util.HashMap;
import com.saas.biz.dao.stockQueryDAO.StockQueryExt;
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 StockQueryInfo {
	Dbtable tradeQuery;

	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	ArrayList queryResult = new ArrayList();

	public StockQueryInfo() {
		log = new Logger(this);
		tradeQuery = new Dbtable();
	}

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

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

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

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

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

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

	public void addStockQueryInfo(Buffers inbuffer) {
		log.LOG_INFO("进入addStockQueryInfo方法...");
		this.outBuffer = inbuffer;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String form_id = inbuffer.getString("FORM_ID");
		String query_id = inbuffer.getString("QUERY_ID");
		String title = inbuffer.getString("TITLE");
		String content = inbuffer.getString("CONTENT");
		String q_user_id = inbuffer.getString("SALE_USER_ID");
		String q_date = inbuffer.getString("Q_DATE");
		String q_type = inbuffer.getString("Q_TYPE");
		String q_cust_id = inbuffer.getString("OBJ_CUST_ID");
		String q_cust_con = inbuffer.getString("CONTACT_ID");
		String q_cust_phone = inbuffer.getString("Q_CUST_PHONE");
		String pre_price = inbuffer.getString("PRE_PRICE");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String in_date = inbuffer.getString("IN_DATE");
		String remark = inbuffer.getString("REMARK");
		String cust_name = inbuffer.getString("OBJ_CUST_NAME");
		String contact_name = inbuffer.getString("CONTACT_MAN");
		String user_name = inbuffer.getString("SALE_USER_NAME");
		int iResult = -1;
		try {
			iResult = addStockQueryInfo(cust_id, form_id, query_id, title,
					content, q_user_id, q_date, q_type, q_cust_id, q_cust_con,
					q_cust_phone, pre_price, oper_user_id, in_date, remark,
					cust_name, contact_name, user_name);

		} catch (SaasApplicationException 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("退出addStockQueryInfo方法...");
	}

	public int addStockQueryInfo(String cust_id, String form_id,
			String query_id, String title, String content, String q_user_id,
			String q_date, String q_type, String q_cust_id, String q_cust_con,
			String q_cust_phone, String pre_price, String oper_user_id,
			String in_date, String remark, String cust_name,
			String contact_name, String user_name)
			throws SaasApplicationException {
		StockQueryExt stockQueryExt = new StockQueryExt();
		stockQueryExt.setParam(":VCUST_ID", cust_id);
		stockQueryExt.setParam(":VFORM_ID", form_id);
		stockQueryExt.setParam(":VQUERY_ID", query_id);
		stockQueryExt.setParam(":VTITLE", title);
		stockQueryExt.setParam(":VCONTENT", content);
		stockQueryExt.setParam(":VQ_USER_ID", q_user_id);
		stockQueryExt.setParam(":VQ_DATE", q_date);
		stockQueryExt.setParam(":VQ_TYPE", q_type);
		stockQueryExt.setParam(":VQ_CUST_ID", q_cust_id);
		stockQueryExt.setParam(":VQ_CUST_CON", q_cust_con);
		stockQueryExt.setParam(":VQ_CUST_PHONE", q_cust_phone);
		stockQueryExt.setParam(":VPRE_PRICE", pre_price);
		stockQueryExt.setParam(":VOPER_USER_ID", oper_user_id);
		stockQueryExt.setParam(":VIN_DATE", in_date);
		stockQueryExt.setParam(":VREMARK", remark);
		stockQueryExt.setParam(":VCUST_NAME", cust_name);
		stockQueryExt.setParam(":VCONTACT_NAME", contact_name);
		stockQueryExt.setParam(":VUSER_NAME", user_name);
		tradeQuery.executeBy(stockQueryExt.insBy("INS_STOCK_QUERY_ALL"));
		return 0;
	}

	public void updateStockQueryInfo(Buffers inbuffer) {
		log.LOG_INFO("进入updateStockQueryInfo方法...");
		this.outBuffer = inbuffer;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String form_id = inbuffer.getString("FORM_ID");
		String query_id = inbuffer.getString("QUERY_ID");
		String title = inbuffer.getString("TITLE");
		String content = inbuffer.getString("CONTENT");
		String q_user_id = inbuffer.getString("SALE_USER_ID");
		String q_date = inbuffer.getString("Q_DATE");
		String q_type = inbuffer.getString("Q_TYPE");
		String q_cust_id = inbuffer.getString("OBJ_CUST_ID");
		String q_cust_con = inbuffer.getString("CONTACT_ID");
		String q_cust_phone = inbuffer.getString("Q_CUST_PHONE");
		String pre_price = inbuffer.getString("PRE_PRICE");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String in_date = inbuffer.getString("IN_DATE");
		String remark = inbuffer.getString("REMARK");
		String cust_name = inbuffer.getString("OBJ_CUST_NAME");
		String contact_name = inbuffer.getString("CONTACT_MAN");
		String user_name = inbuffer.getString("SALE_USER_NAME");
		int iResult = -1;
		try {
			iResult = updateStockQueryInfo(cust_id, form_id, query_id, title,
					content, q_user_id, q_date, q_type, q_cust_id, q_cust_con,
					q_cust_phone, pre_price, oper_user_id, in_date, remark,
					cust_name, contact_name, user_name);

		} catch (SaasApplicationException 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("退出updateStockQueryInfo方法...");
	}

	public int updateStockQueryInfo(String cust_id, String form_id,
			String query_id, String title, String content, String q_user_id,
			String q_date, String q_type, String q_cust_id, String q_cust_con,
			String q_cust_phone, String pre_price, String oper_user_id,
			String in_date, String remark, String cust_name,
			String contact_name, String user_name)
			throws SaasApplicationException {
		StockQueryExt stockQueryExt = new StockQueryExt();
		stockQueryExt.setParam(":VCUST_ID", cust_id);
		stockQueryExt.setParam(":VFORM_ID", form_id);
		stockQueryExt.setParam(":VQUERY_ID", query_id);
		stockQueryExt.setParam(":VTITLE", title);
		stockQueryExt.setParam(":VCONTENT", content);
		stockQueryExt.setParam(":VQ_USER_ID", q_user_id);
		stockQueryExt.setParam(":VQ_DATE", q_date);
		stockQueryExt.setParam(":VQ_TYPE", q_type);
		stockQueryExt.setParam(":VQ_CUST_ID", q_cust_id);
		stockQueryExt.setParam(":VQ_CUST_CON", q_cust_con);
		stockQueryExt.setParam(":VQ_CUST_PHONE", q_cust_phone);
		stockQueryExt.setParam(":VPRE_PRICE", pre_price);
		stockQueryExt.setParam(":VOPER_USER_ID", oper_user_id);
		stockQueryExt.setParam(":VIN_DATE", in_date);
		stockQueryExt.setParam(":VREMARK", remark);
		stockQueryExt.setParam(":VCUST_NAME", cust_name);
		stockQueryExt.setParam(":VCONTACT_NAME", contact_name);
		stockQueryExt.setParam(":VUSER_NAME", user_name);
		tradeQuery.executeBy(stockQueryExt.insBy("UPDATE_STOCK_QUERY_ALL"));
//		log.LOG_INFO("开始执行SQL：========"+ stockQueryExt.insBy("UPDATE_STOCK_QUERY_ALL"));
		return 0;
	}

	public void delStockQuery(Buffers inbuffer) {
		log.LOG_INFO("进入delStockQuery方法...");
		this.outBuffer = inbuffer;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String query_id = inbuffer.getString("QUERY_ID");
		String form_id = inbuffer.getString("FORM_ID");
		int iResult = -1;
		try {
			iResult = delStockQuery(cust_id, query_id, form_id);
		} catch (SaasApplicationException 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("退出delStockQuery方法...");
	}

	public int delStockQuery(String cust_id, String query_id, String form_id)
			throws SaasApplicationException {
		StockQueryExt stockQueryExt = new StockQueryExt();
		stockQueryExt.setParam(":VCUST_ID", cust_id);
		stockQueryExt.setParam(":VQUERY_ID", query_id);
		stockQueryExt.setParam(":VFORM_ID", form_id);
		tradeQuery.executeBy(stockQueryExt.insBy("DEL_ONE_STOCKQUERY"));
		return 0;
	}

	public ArrayList getOneStockQuery(String cust_id, String query_id)
			throws SaasApplicationException {
		HashMap map = new HashMap();
		ArrayList list = new ArrayList();
		StockQueryExt stockQueryExt = new StockQueryExt();
		stockQueryExt.setParam(":VCUST_ID", cust_id);
		stockQueryExt.setParam(":VQUERY_ID", query_id);
		list = stockQueryExt.selByList("SEL_ONE_BY_QUO_ID");
		return list;
	}

	public ArrayList getStockQueryList(int iStart, String cust_id)
			throws SaasApplicationException {
		// log.LOG_INFO("==========="+cust_id+"=========="+iStart+"==================");
		StockQueryExt stockQueryExt = new StockQueryExt();
		ArrayList list = new ArrayList();
		try {
			iStart=iStart*20;
			stockQueryExt.setParam(":VCUST_ID", cust_id);
			list = stockQueryExt.selByList("SEL_ALL_STOCKQUERY", iStart, 20);
			// log.LOG_INFO("开始执行SQK：==============="+stockQueryExt.selByList("SEL_ALL_STOCKQUERY",
			// iStart, 20));
		} catch (RuntimeException e) {
			log.LOG_INFO(e.getMessage());
		}
		return list;
	}

	// 取出所有的采购单
	public int getStockQueryList(String cust_id)
			throws SaasApplicationException {
		StockQueryExt stockQueryExt = new StockQueryExt();
		ArrayList list = new ArrayList();
		int count = 0;
		try {
			stockQueryExt.setParam(":VCUST_ID", cust_id);
			list = stockQueryExt.selByList("SEL_ALL_STOCKQUERY");
		} catch (RuntimeException e) {
			log.LOG_INFO(e.getMessage());
		}
		if (list != null && list.size() > 0) {
			count = list.size();
		}
		return count;
	}

}