storeoutinfo.java

java阿里巴巴代码

package com.saas.biz.storeOutMgr;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.HashMap;

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.storeOutDAO.StoreOutDAO;
import com.saas.biz.dao.storeOutDAO.StoreOutExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

/**
 * @author:LiuYang
 * @desc:出库单
 * @2008-5-7
 */
public class StoreOutInfo implements Serializable {
	
	
	private static final long serialVersionUID = 1L;
	
	
	
	public StoreOutInfo() {

		log = new Logger(this);
		tradeQuery = new Dbtable();
		commen = new commMethodMgr();
		outBuffer = new Buffers();
		
	}
	
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	Dbtable tradeQuery;
	
	
	commMethodMgr commen;
	
	
	ArrayList queryResult = new ArrayList();
	
	
	
	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 addStoreOutInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入addStoreOutInfo方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String form_id = inbuffer.getString("FORM_ID");
		String quo_id = inbuffer.getString("QUO_ID");
		String link_quo_id = inbuffer.getString("LINK_QUO_ID");
		String quo_name = inbuffer.getString("QUO_NAME");
		String quo_no = inbuffer.getString("QUO_NO");
		String quo_num = inbuffer.getString("QUO_NUM");
		String goods_id = inbuffer.getString("GOODS_ID");
		String goods_name = inbuffer.getString("GOODS_NAME");
		String goods_desc = inbuffer.getString("GOODS_DESC");
		String goods_no = inbuffer.getString("GOODS_NO");
		String store_no = inbuffer.getString("STORE_NO");
		String goods_type = inbuffer.getString("GOODS_TYPE");
		String store_type = inbuffer.getString("STORE_TYPE");
		String obj_cust = inbuffer.getString("OBJ_CUST");
		String meas_unit = inbuffer.getString("MEAS_UNIT");
		String per_unit_num = inbuffer.getString("PER_UNIT_NUM");
		String pack_unit = inbuffer.getString("PACK_UNIT");
		String lenght = inbuffer.getString("LENGHT");
		String width = inbuffer.getString("WIDTH");
		String height = inbuffer.getString("HEIGHT");
		String volume = inbuffer.getString("VOLUME");
		String weight = inbuffer.getString("WEIGHT");
		String ship_type = inbuffer.getString("SHIP_TYPE");
		String ship_date = inbuffer.getString("SHIP_DATE");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");
		try {
			StoreOutDAO store = new StoreOutDAO();
			store.setCust_id(cust_id);
			store.setForm_id(form_id);
			store.setQuo_id(quo_id);
			store.setLink_quo_id(link_quo_id);
			store.setQuo_name(quo_name);
			store.setQuo_no(quo_no);
			store.setQuo_num(quo_num);
			store.setGoods_id(goods_id);
			store.setGoods_name(goods_name);
			store.setGoods_desc(goods_desc);
			store.setGoods_no(goods_no);
			store.setStore_no(store_no);
			store.setGoods_type(goods_type);
			store.setStore_type(store_type);
			store.setObj_cust(obj_cust);
			store.setMeas_unit(meas_unit);
			store.setPer_unit_num(per_unit_num);
			store.setPack_unit(pack_unit);
			store.setLenght(lenght);
			store.setWidth(width);
			store.setHeight(height);
			store.setVolume(volume);
			store.setWeight(weight);
			store.setShip_type(ship_type);
			store.setShip_date(ship_date);
			store.setOper_user_id(oper_user_id);
			store.setRemark2(remark2);
			
			iResult = addStoreOutInfo(store);
		}
		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("退出addReportInfo方法...");
	}
	
	
	public int addStoreOutInfo(StoreOutDAO store) {

		StoreOutExt storeExt = new StoreOutExt();
		storeExt.setParam(":VCUST_ID", store.getCust_id());
		storeExt.setParam(":VFORM_ID", store.getForm_id());
		storeExt.setParam(":VQUO_ID", store.getQuo_id());
		storeExt.setParam(":VLINK_QUO_ID", store.getLink_quo_id());
		storeExt.setParam(":VQUO_NAME", store.getQuo_name());
		storeExt.setParam(":VQUO_NO", store.getQuo_no());
		storeExt.setParam(":VQUO_NUM", store.getQuo_num());
		storeExt.setParam(":VGOODS_ID", store.getGoods_id());
		storeExt.setParam(":VGOODS_NAME", store.getGoods_name());
		storeExt.setParam(":VGOODS_DESC", store.getGoods_desc());
		storeExt.setParam(":VGOODS_NO", store.getGoods_no());
		storeExt.setParam(":VSTORE_NO", store.getStore_no());
		storeExt.setParam(":VGOODS_TYPE", store.getGoods_type());
		storeExt.setParam(":VSTORE_TYPE", store.getStore_type());
		storeExt.setParam(":VOBJ_CUST", store.getObj_cust());
		storeExt.setParam(":VMEAS_UNIT", store.getMeas_unit());
		storeExt.setParam(":VPER_UNIT_NUM", store.getPer_unit_num());
		storeExt.setParam(":VPACK_UNIT", store.getPack_unit());
		storeExt.setParam(":VLENGHT", store.getLenght());
		storeExt.setParam(":VWIDTH", store.getWidth());
		storeExt.setParam(":VHEIGHT", store.getHeight());
		storeExt.setParam(":VVOLUME", store.getVolume());
		storeExt.setParam(":VWEIGHT", store.getWeight());
		storeExt.setParam(":VSHIP_TYPE", store.getShip_type());
		storeExt.setParam(":VSHIP_DATE", store.getShip_date());
		storeExt.setParam(":VOPER_USER_ID", store.getOper_user_id());
		storeExt.setParam(":VREMARK2", store.getRemark2());
		tradeQuery.executeBy(storeExt.insBy("INS_BY_ALL"));
		return 0;
	}
	
	
	
	// 修改出库单
	public void editStoreOutInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入editStoreOutInfo方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String form_id = inbuffer.getString("FORM_ID");
		String quo_id = inbuffer.getString("QUO_ID");
		String link_quo_id = inbuffer.getString("LINK_QUO_ID");
		String quo_name = inbuffer.getString("QUO_NAME");
		String quo_no = inbuffer.getString("QUO_NO");
		String quo_num = inbuffer.getString("QUO_NUM");
		String goods_id = inbuffer.getString("GOODS_ID");
		String goods_name = inbuffer.getString("GOODS_NAME");
		String goods_desc = inbuffer.getString("GOODS_DESC");
		String goods_no = inbuffer.getString("GOODS_NO");
		String store_no = inbuffer.getString("STORE_NO");
		String goods_type = inbuffer.getString("GOODS_TYPE");
		String store_type = inbuffer.getString("STORE_TYPE");
		String obj_cust = inbuffer.getString("OBJ_CUST");
		String meas_unit = inbuffer.getString("MEAS_UNIT");
		String per_unit_num = inbuffer.getString("PER_UNIT_NUM");
		String pack_unit = inbuffer.getString("PACK_UNIT");
		String lenght = inbuffer.getString("LENGHT");
		String width = inbuffer.getString("WIDTH");
		String height = inbuffer.getString("HEIGHT");
		String volume = inbuffer.getString("VOLUME");
		String weight = inbuffer.getString("WEIGHT");
		String ship_type = inbuffer.getString("SHIP_TYPE");
		String ship_date = inbuffer.getString("SHIP_DATE");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");
		try {
			StoreOutDAO store = new StoreOutDAO();
			store.setCust_id(cust_id);
			store.setForm_id(form_id);
			store.setQuo_id(quo_id);
			store.setLink_quo_id(link_quo_id);
			store.setQuo_name(quo_name);
			store.setQuo_no(quo_no);
			store.setQuo_num(quo_num);
			store.setGoods_id(goods_id);
			store.setGoods_name(goods_name);
			store.setGoods_desc(goods_desc);
			store.setGoods_no(goods_no);
			store.setStore_no(store_no);
			store.setGoods_type(goods_type);
			store.setStore_type(store_type);
			store.setObj_cust(obj_cust);
			store.setMeas_unit(meas_unit);
			store.setPer_unit_num(per_unit_num);
			store.setPack_unit(pack_unit);
			store.setLenght(lenght);
			store.setWidth(width);
			store.setHeight(height);
			store.setVolume(volume);
			store.setWeight(weight);
			store.setShip_type(ship_type);
			store.setShip_date(ship_date);
			store.setOper_user_id(oper_user_id);
			store.setRemark2(remark2);
			
			iResult = editStoreOutInfo(store);
		}
		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("退出editStoreOutInfo方法...");
	}
	
	
	public int editStoreOutInfo(StoreOutDAO store) {

		StoreOutExt storeExt = new StoreOutExt();
		storeExt.setParam(":VCUST_ID", store.getCust_id());
		storeExt.setParam(":VFORM_ID", store.getForm_id());
		storeExt.setParam(":VQUO_ID", store.getQuo_id());
		storeExt.setParam(":VLINK_QUO_ID", store.getLink_quo_id());
		storeExt.setParam(":VQUO_NAME", store.getQuo_name());
		storeExt.setParam(":VQUO_NO", store.getQuo_no());
		storeExt.setParam(":VQUO_NUM", store.getQuo_num());
		storeExt.setParam(":VGOODS_ID", store.getGoods_id());
		storeExt.setParam(":VGOODS_NAME", store.getGoods_name());
		storeExt.setParam(":VGOODS_DESC", store.getGoods_desc());
		storeExt.setParam(":VGOODS_NO", store.getGoods_no());
		storeExt.setParam(":VSTORE_NO", store.getStore_no());
		storeExt.setParam(":VGOODS_TYPE", store.getGoods_type());
		storeExt.setParam(":VSTORE_TYPE", store.getStore_type());
		storeExt.setParam(":VOBJ_CUST", store.getObj_cust());
		storeExt.setParam(":VMEAS_UNIT", store.getMeas_unit());
		storeExt.setParam(":VPER_UNIT_NUM", store.getPer_unit_num());
		storeExt.setParam(":VPACK_UNIT", store.getPack_unit());
		storeExt.setParam(":VLENGHT", store.getLenght());
		storeExt.setParam(":VWIDTH", store.getWidth());
		storeExt.setParam(":VHEIGHT", store.getHeight());
		storeExt.setParam(":VVOLUME", store.getVolume());
		storeExt.setParam(":VWEIGHT", store.getWeight());
		storeExt.setParam(":VSHIP_TYPE", store.getShip_type());
		storeExt.setParam(":VSHIP_DATE", store.getShip_date());
		storeExt.setParam(":VOPER_USER_ID", store.getOper_user_id());
		storeExt.setParam(":VREMARK2", store.getRemark2());
		tradeQuery.executeBy(storeExt.insBy("UPDATE_BY_ALL"));
		return 0;
	}
	
	
	
	// 删除出库单
	public void delStoreOutInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入editStoreOutInfo方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String goods_id = inbuffer.getString("GOODS_ID");
		String quo_id = inbuffer.getString("QUO_ID");
		try {
			iResult = delStoreOutInfo(cust_id, goods_id, quo_id);
		}
		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("退出editStoreOutInfo方法...");
	}
	
	
	public int delStoreOutInfo(String cust_id, String goods_id, String quo_id) throws SaasApplicationException {

		StoreOutExt storeExt = new StoreOutExt();
		storeExt.setParam(":VCUST_ID", cust_id);
		storeExt.setParam(":VGOODS_ID", goods_id);
		storeExt.setParam(":VQUO_ID", quo_id);
		tradeQuery.executeBy(storeExt.insBy("DEL_BY_ALL"));
		return 0;
	}
	
	
	
	// 取出出库单
	public ArrayList getStoreOutInfo(int iStart, String cust_id) throws SaasApplicationException {

		iStart = iStart*20;
		StoreOutExt storeExt = new StoreOutExt();
		storeExt.setParam(":VCUST_ID", cust_id);
		ArrayList list = storeExt.selByList("SEL_BY_CUST", iStart, 20);
		return list;
	}
	
	
	
	// 取出出库单条数
	public int getStoreOutSize(String cust_id) throws SaasApplicationException {

		int size = 0;
		StoreOutExt storeExt = new StoreOutExt();
		storeExt.setParam(":VCUST_ID", cust_id);
		ArrayList list = storeExt.selByList("SEL_SIZE_BY_CUST");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	// 取出出库单JSON数据
	public String getStoreOutJSON(int start, String cust_id) throws SaasApplicationException {

		String json = "";
		return json;
	}
	
	
	
	// 取出单条出库信息
	public HashMap getStoreOutInfo(String cust_id, String quo_id) throws SaasApplicationException {

		HashMap map = new HashMap();
		StoreOutExt storeExt = new StoreOutExt();
		storeExt.setParam(":VCUST_ID", cust_id);
		storeExt.setParam(":VQUO_ID", quo_id);
		ArrayList list = storeExt.selByList("SEL_BY_ID");
		if (list != null && list.size() > 0) {
			map = (HashMap) list.get(0);
		}
		return map;
	}
}