saleorderinfo.java

java阿里巴巴代码

package com.saas.biz.saleOrderMgr;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.StringTokenizer;
import com.saas.biz.commen.ParamethodMgr;
import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.formStateDAO.FormStateExt;
import com.saas.biz.dao.saleFormDAO.SaleFormDAO;
import com.saas.biz.dao.saleFormDAO.SaleFormExt;
import com.saas.biz.dao.templateFormDAO.TemplateExt;
import com.saas.biz.dao.templateItemDAO.TemplateItemExt;
import com.saas.biz.formStateMgr.FieldItemEntity;
import com.saas.biz.formStateMgr.FormAreaEnity;
import com.saas.biz.formStateMgr.FormFieldEntity;
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:销售订单结果信息表[tf_f_saleform]
 * @2008-4-16
 */
public class SaleOrderInfo {

	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	commMethodMgr commen;

	ArrayList queryResult = new ArrayList();

	public SaleOrderInfo() {

		log = new Logger(this);
		tradeQuery = new Dbtable();
		commen = new commMethodMgr();
		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 addSaleOrder(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入addCustinfo方法...");
		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 quo_name = inbuffer.getString("QUO_NAME");
		String item_id = inbuffer.getString("ITEM_ID");
		String field_value = inbuffer.getString("FIELD_VALUE");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");
		try {
			iResult = addSaleOrder(cust_id,form_id,quo_id,quo_name,item_id,field_value,oper_user_id,remark2);
		} catch (Exception e) {
		}
		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("退出addCustinfo方法...");
	}

	public int addSaleOrder(String cust_id,String form_id,String quo_id,String quo_name,String item_id,
			String field_value,String oper_user_id,String remark2) {

		StringTokenizer st = new StringTokenizer(field_value, "|");
		while (st.hasMoreTokens()) {
			String filed_Data = st.nextToken();
			String id = filed_Data.substring(0, filed_Data.indexOf("&"));
			String value = filed_Data.substring(filed_Data.indexOf("&") + 1,
					filed_Data.length());
			SaleFormExt saleExt = new SaleFormExt();
			saleExt.setParam(":VCUST_ID", cust_id);
			saleExt.setParam(":VFIELD_ID", id);
			saleExt.setParam(":VQUO_NAME", quo_name);
			saleExt.setParam(":VFIELD_VALUE", value);
			saleExt.setParam(":VQUO_ID", quo_id);
			saleExt.setParam(":VITEM_ID", item_id);
			saleExt.setParam(":VFORM_ID", form_id);
			saleExt.setParam(":VOPER_USER_ID",oper_user_id);
			saleExt.setParam(":VREMARK2", remark2);
			saleExt.setParam(":VITEM_VALUE", "");
			tradeQuery.executeBy(saleExt.insBy("INS_BY_ALL"));
		}
		return 0;
	}

	// 新增明细条目
	public void addSaleOrderItem(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入addSaleOrderItem方法...");
		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 quo_name = inbuffer.getString("QUO_NAME");
		String item_id = inbuffer.getString("ITEM_ID");
		String field_id = inbuffer.getString("FIELD_ID");
		String item_value = inbuffer.getString("ITEM_VALUE");
		String field_value = inbuffer.getString("FIELD_VALUE");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");
		try {
			iResult = addSaleOrderItem(cust_id,form_id,quo_id,quo_name,item_id,field_id,item_value,field_value,
					oper_user_id,remark2);
		} catch (Exception e) {
		}
		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("退出addSaleOrderItem方法...");
	}

	public int addSaleOrderItem(String cust_id,String form_id,String quo_id,String quo_name,String item_id,
			String field_id,String item_value,String field_value,String oper_user_id,String remark2) {

		SaleFormExt saleExt = new SaleFormExt();
		saleExt.setParam(":VCUST_ID", cust_id);
		saleExt.setParam(":VFIELD_ID", field_id);
		saleExt.setParam(":VFIELD_VALUE", field_value);
		saleExt.setParam(":VQUO_ID", quo_id);
		saleExt.setParam(":VITEM_ID",item_id);
		saleExt.setParam(":VFORM_ID", form_id);
		saleExt.setParam(":VITEM_VALUE", item_value);
		saleExt.setParam(":VQUO_ID", quo_id);
		saleExt.setParam(":VQUO_NAME", quo_name);
		saleExt.setParam(":VOPER_USER_ID", oper_user_id);
		saleExt.setParam(":VREMARK2", remark2);
		tradeQuery.executeBy(saleExt.insBy("INS_BY_ALL"));
		return 0;
	}

	// 取出销售订单列表
	public ArrayList getSaleOrderList(int iStart, String cust_id, String form_id)
			throws SaasApplicationException {

		iStart = iStart * 20;

		ArrayList list = new ArrayList();
		SaleFormExt saleExt = new SaleFormExt();
		saleExt.setParam(":VCUST_ID", cust_id);
		saleExt.setParam(":VFORM_ID", form_id);
		list = saleExt.selByList("SEL_BY_FORM", iStart, 20);
		return list;
	}

	// 销售订单统计
	public int getSaleOrderCount(String cust_id, String form_id)
			throws SaasApplicationException {

		int size = 0;
		ArrayList list = new ArrayList();
		SaleFormExt saleExt = new SaleFormExt();
		saleExt.setParam(":VCUST_ID", cust_id);
		saleExt.setParam(":VFORM_ID", form_id);
		list = saleExt.selByList("SEL_BY_FORM_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}

	// 取出订单明细
	public ArrayList getOrderDetailByList(String cust_id, String form_id,
			String quo_id) throws SaasApplicationException {

		SaleFormExt saleExt = new SaleFormExt();
		ArrayList list = new ArrayList();
		saleExt.setParam(":VCUST_ID", cust_id);
		saleExt.setParam(":VFORM_ID", form_id);
		saleExt.setParam(":VQUO_ID", quo_id);
		list = saleExt.selByList("SEL_BY_QU_ID");
		return list;
	}

	// 取出订单信息
	public ArrayList<FormAreaEnity> getOrderInfoById(String cust_id,
			String form_id, String quo_id) throws SaasApplicationException {

		ArrayList<FormAreaEnity> areaList = new ArrayList<FormAreaEnity>();
		TemplateExt formExt = new TemplateExt();
		formExt.setParam(":VCUST_ID", cust_id);
		formExt.setParam(":VFORM_ID", form_id);
		ArrayList list = formExt.selByList("SEL_BY_GROUP");
		if (list != null && list.size() > 0) {
			for (int i = 0; i < list.size(); i++) {
				FormAreaEnity area = new FormAreaEnity();
				HashMap map = (HashMap) list.get(i);
				String area_id = "";
				if (map.get("area_id") != null) {
					area_id = map.get("area_id").toString();
				}
				String area_name = "";
				if (map.get("area_name") != null) {
					area_name = map.get("area_name").toString();
				}
				area.setArea_id(area_id);
				area.setArea_name(area_name);
				// 存放所有字段
				ArrayList<FormFieldEntity> field = getFieldByAreaId(cust_id,
						form_id, area_id, quo_id);
				area.setField(field);
				areaList.add(area);
			}
		}
		return areaList;
	}

	/**
	 * 从模板中取出区域字段
	 */

	public ArrayList<FormFieldEntity> getFieldByAreaId(String cust_id,
			String form_id, String area_id, String quo_id)
			throws SaasApplicationException {

		ArrayList<FormFieldEntity> fieldList = new ArrayList<FormFieldEntity>();
		TemplateExt formExt = new TemplateExt();
		formExt.setParam(":VCUST_ID", cust_id);
		formExt.setParam(":VFORM_ID", form_id);
		formExt.setParam(":VAREA_ID", area_id);
		ArrayList list = formExt.selByList("SEL_BY_AREAID");
		if (list != null && list.size() > 0) {
			for (int i = 0; i < list.size(); i++) {
				FormFieldEntity field = new FormFieldEntity();
				HashMap map = new HashMap();
				map = (HashMap) list.get(i);

				String field_id = "", field_name = "", field_type = "", field_value = "";
				if (map.get("field_id") != null) {
					field_id = map.get("field_id").toString();
				}
				if (map.get("field_name") != null) {
					field_name = map.get("field_name").toString();
				}
				if (map.get("field_type") != null) {
					field_type = map.get("field_type").toString();
				}
				ArrayList itemSaleList = new ArrayList();
				if (field_type == "0" || field_type.equals("0")) {
					itemSaleList = getOrderFormValue(cust_id, form_id,
							field_id, quo_id);
				} else if (field_type == "1" || field_type.equals("1")) {
					// 存放订单信息
					itemSaleList = getItemByFieldId(cust_id, form_id, field_id,
							quo_id);
				} else if (field_type == "2" || field_type.equals("2")) {
					// 存放订单信息
					ArrayList tempList = getItemByFieldId(cust_id, form_id,
							field_id, quo_id);
					if (tempList != null && tempList.size() > 0) {

						HashMap saleMap = (HashMap) tempList.get(0);
						if (saleMap.get("field_value") != null) {
							field_value = saleMap.get("field_value").toString();
						}
						itemSaleList = getItemByFieldId(cust_id, form_id,
								field_id, field_value);
					}
				} else if (field_type == "3" || field_type.equals("3")) {
					if (map.get("default_value") != null) {
						field_value = map.get("default_value").toString();
					}
				}
				field.setField_id(field_id);
				field.setField_name(field_name);
				field.setField_type(field_type);
				field.setFiled_value(field_value);
				field.setList(itemSaleList);
				fieldList.add(field);
			}
		}
		return fieldList;
	}

	// 取出字段所对应的条目值
	public ArrayList getItemByFieldId(String cust_id, String form_id,
			String field_id, String quo_id) throws SaasApplicationException {

		SaleFormExt saleExt = new SaleFormExt();
		ArrayList list = new ArrayList();
		saleExt.setParam(":VCUST_ID", cust_id);
		saleExt.setParam(":VFORM_ID", form_id);
		saleExt.setParam(":VFIELD_ID", field_id);
		saleExt.setParam(":VQUO_ID", quo_id);
		list = saleExt.selByList("SEL_BY_FIELD");
		return list;
	}

	public ArrayList getValueList(String cust_id, String form_id, String quo_id)
			throws SaasApplicationException {

		ArrayList list = new ArrayList();
		SaleFormExt saleExt = new SaleFormExt();
		saleExt.setParam(":VCUST_ID", cust_id);
		saleExt.setParam(":VFORM_ID", form_id);
		saleExt.setParam(":VQUO_ID", quo_id);
		list = saleExt.selByList("SEL_BY_ITEM");
		log.equals("===" + list);
		return list;
	}

	// 取出单个订单
	public HashMap getOrderById(String cust_id, String form_id, String quo_id)
			throws SaasApplicationException {

		HashMap map = new HashMap();

		ArrayList list = new ArrayList();
		SaleFormExt saleExt = new SaleFormExt();
		saleExt.setParam(":VCUST_ID", cust_id);
		saleExt.setParam(":VFORM_ID", form_id);
		saleExt.setParam(":VQUO_ID", quo_id);
		list = saleExt.selByList("SEL_BY_NAME");
		if (list != null && list.size() > 0) {
			map = (HashMap) list.get(0);
		}
		return map;
	}