saleorderinfo.java

java阿里巴巴代码

	// 取出订单字段值
	public ArrayList getOrderFormValue(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_ID");
		return list;
	}

	// 取出单个条目
	public String getTemplateItemById(String cust_id, String form_id,
			String item_id) throws SaasApplicationException {

		String item_Name = "";
		ArrayList list = new ArrayList();
		TemplateItemExt itemExt = new TemplateItemExt();
		itemExt.setParam(":VCUST_ID", cust_id);
		itemExt.setParam(":VFORM_ID", form_id);
		itemExt.setParam(":VITEM_ID", item_id);
		list = itemExt.selByList("SEL_BY_ID");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			if (map.get("item_name") != null) {
				item_Name = map.get("item_name").toString();
			}
		}
		return item_Name;
	}

	// 删除订单和日志
	public void delSaleOrder(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入delSaleOrder方法...");
		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");
		try {
			iResult = delSaleOrder(cust_id, form_id, quo_id);
		} 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("退出delSaleOrder方法...");
	}

	public int delSaleOrder(String cust_id, String form_id, String quo_id)
			throws SaasApplicationException {

		SaleFormExt saleExt = new SaleFormExt();
		saleExt.setParam(":VCUST_ID", cust_id);
		saleExt.setParam(":VFORM_ID", form_id);
		saleExt.setParam(":VQUO_ID", quo_id);
		tradeQuery.executeBy(saleExt.insBy("DEL_BY_ID"));
		FormStateExt stateExt = new FormStateExt();
		stateExt.setParam(":VCUST_ID", cust_id);
		stateExt.setParam(":VSERVER_ID", quo_id);
		tradeQuery.executeBy(stateExt.insBy("DEL_BY_ID"));
		return 0;
	}

	/**
	 * @生成下拉列表框
	 * @param cust_id
	 * @param form_id
	 * @param field_id
	 * @param index:元素的值
	 * @param elemName:元素名称
	 * @param elemId:元素id名称
	 * @return:Html Select element
	 * @throws SaasApplicationException
	 */
	public String getItemSelectedByFieldId(String cust_id, String form_id,
			String field_id, String index, String elemName, String elemId)
			throws SaasApplicationException {

		String htmlElement = "<select name=" + elemName + " id=" + elemId + ">", selected = "";
		String htemSelect = "";
		ArrayList list = getTemplateItemByFieldId(cust_id, form_id, field_id);
		if (list != null && list.size() > 0) {
			for (int i = 0; i < list.size(); i++) {
				HashMap map = (HashMap) list.get(i);
				String item_id = "";
				String item_name = "";
				if (map.get("item_id") != null) {
					item_id = map.get("item_id").toString();
				}
				if (map.get("item_name") != null) {
					item_name = map.get("item_name").toString();
				}
				if (index == item_id || index.equals(item_id)) {
					selected = "selected";
				} else {
					selected = "";
				}
				htemSelect = htemSelect + "<option value=" + item_id + " "
						+ selected + ">" + item_name + "</option>";
			}
		}
		htmlElement = htmlElement + htemSelect + "</select>";
		return htmlElement;
	}

	// 取出一个字段的条目
	public ArrayList getTemplateItemByFieldId(String cust_id, String form_id,
			String field_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		TemplateItemExt itemExt = new TemplateItemExt();
		itemExt.setParam(":VCUST_ID", cust_id);
		itemExt.setParam(":VFIELD_ID", field_id);
		itemExt.setParam(":VFORM_ID", form_id);
		list = itemExt.selByList("SEL_ITEM_BY_FIELD");
		return list;
	}

	// 修改订单
	public void eidtSaleOrder(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入eidtSaleOrder方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String form_id = inbuffer.getString("FORM_ID");
		String field_name = inbuffer.getString("FIELD_NAME");
		String remark = inbuffer.getString("REMARK2");
		;
		try {
			iResult = eidtSaleOrder(cust_id, form_id, field_name, remark);
		} 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("退出eidtSaleOrder方法...");
	}

	public int eidtSaleOrder(String cust_id, String form_id, String field_name,
			String remark) throws SaasApplicationException {

		StringTokenizer stk = new StringTokenizer(field_name, "|");
		while (stk.hasMoreTokens()) {
			String str = stk.nextToken();
			String value = "";
			String quo_id = "";
			String field_id = "";
			String item_id = "";
			value = str.substring(0, str.indexOf("@"));
			quo_id = str.substring(str.indexOf("@") + 1, str.indexOf("&"));
			field_id = str.substring(str.indexOf("&") + 1, str.indexOf(","));
			item_id = str.substring(str.indexOf(",") + 1, str.indexOf("$"));
			String field_type = str.substring(str.indexOf("$") + 1, str
					.length());
			if (field_type == "2" || field_type.equals("2")) {
				SaleFormExt saleExt = new SaleFormExt();
				saleExt.setParam(":VCUST_ID", cust_id);
				saleExt.setParam(":VFORM_ID", form_id);
				saleExt.setParam(":VQUO_ID", quo_id);
				saleExt.setParam(":VFIELD_ID", field_id);
				saleExt.setParam(":VITEM_VALUE", value);
				saleExt.setParam(":VITEM_ID", item_id);
				saleExt.setParam(":VREMARK2", remark);
				tradeQuery.executeBy(saleExt.insBy("UPDATE_BY_ITEMVALUE"));
			} else if (field_type == "0" || field_type.equals("0")) {

				SaleFormExt saleExt = new SaleFormExt();
				saleExt.setParam(":VCUST_ID", cust_id);
				saleExt.setParam(":VFORM_ID", form_id);
				saleExt.setParam(":VQUO_ID", quo_id);
				saleExt.setParam(":VFIELD_ID", field_id);
				saleExt.setParam(":VITEM_ID", item_id);
				saleExt.setParam(":VFIELD_VALUE", value);
				saleExt.setParam(":VREMARK2", remark);
				tradeQuery.executeBy(saleExt.insBy("UPDATE_BY_FIELD"));

			} else {
				SaleFormExt saleExt = new SaleFormExt();
				saleExt.setParam(":VCUST_ID", cust_id);
				saleExt.setParam(":VFORM_ID", form_id);
				saleExt.setParam(":VQUO_ID", quo_id);
				saleExt.setParam(":VFIELD_ID", field_id);
				saleExt.setParam(":VITEM_ID", item_id);
				saleExt.setParam(":VFIELD_VALUE", value);
				saleExt.setParam(":VREMARK2", remark);
				tradeQuery.executeBy(saleExt.insBy("UPDATE_BY_ITEM"));
			}
		}
		return 0;
	}

	// 判断字段类型
	public String getFieldTypeByField(String cust_id, String form_id,
			String filed_id) throws SaasApplicationException {

		SaleFormExt saleExt = new SaleFormExt();
		String field_type = "";
		saleExt.setParam(":VCUST_ID", cust_id);
		saleExt.setParam(":VFORM_ID", form_id);
		saleExt.setParam(":VFILED_ID", filed_id);
		ArrayList list = saleExt.selByList("SEL_BY_FILEDID");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			if (map.get("field_type") != null) {
				field_type = map.get("field_type").toString();
			}
		}
		return field_type;
	}

	/**
	 * @订单列表
	 * @取出新增加、未通过、被打回的订单
	 */
	public ArrayList getOrderListByState(int iStart, String cust_id,
			String state1, String state2, String state3)
			throws SaasApplicationException {
		log.LOG_INFO("进入getOrderListByState方法");

		iStart = iStart * 20;

		ArrayList statelist = new ArrayList();
		FormStateExt sateExt = new FormStateExt();
		sateExt.setParam(":VCUST_ID", cust_id);
		sateExt.setParam(":VSTATE1", state1);
		sateExt.setParam(":VSTATE2", state2);
		sateExt.setParam(":VSTATE3", state3);
		ArrayList list = sateExt.selByList("SEL_BY_STATE", iStart, 20);
		if (list != null && list.size() > 0) {
			for (int i = 0; i < list.size(); i++) {
				HashMap map = (HashMap) list.get(i);
				String state_code = "", quo_id = "", form_name = "", entity_type = "", quo_name = "", form_id = "";
				HashMap objMap = new HashMap();
				if (map.get("quo_id") != null) {
					quo_id = map.get("quo_id").toString();
				}
				if (map.get("state_code") != null) {
					state_code = map.get("state_code").toString();
				}
				HashMap form_Map = getOrderFormAdd(quo_id, cust_id);
				if (form_Map != null && form_Map.size() > 0) {
					if (form_Map.get("form_name") != null) {
						form_name = form_Map.get("form_name").toString();
					}
					if (form_Map.get("entity_type") != null) {
						entity_type = form_Map.get("entity_type").toString();
					}
					if (form_Map.get("quo_name") != null) {
						quo_name = form_Map.get("quo_name").toString();
					}
					if (form_Map.get("form_id") != null) {
						form_id = form_Map.get("form_id").toString();
					}
				}
				objMap.put("quo_id", quo_id);
				objMap.put("state_code", state_code);
				objMap.put("form_name", form_name);
				objMap.put("form_id", form_id);
				objMap.put("entity_type", entity_type);
				objMap.put("quo_name", quo_name);
				statelist.add(objMap);
			}
		}
		log.LOG_INFO("退出getOrderListByState方法");
		return statelist;
	}

	/**
	 * 取出订单
	 */
	public HashMap getOrderFormAdd(String quo_id, String cust_id)
			throws SaasApplicationException {
		log.LOG_INFO("进入getOrderFormAdd方法");
		SaleFormExt saleExt = new SaleFormExt();
		saleExt.setParam(":VQUO_ID", quo_id);
		ArrayList list = saleExt.selByList("SEL_BY_ID");
		HashMap orderMap = new HashMap();
		String form_name = "", entity_type = "";
		String form_id = "", quo_name = "";
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			if (map.get("form_id") != null) {
				form_id = map.get("form_id").toString();
			}
			if (map.get("quo_name") != null) {
				quo_name = map.get("quo_name").toString();
			}
			HashMap form_Map = getFormNameByName(form_id, cust_id);
			if (form_Map != null && form_Map.size() > 0) {
				if (form_Map.get("name") != null) {
					form_name = form_Map.get("name").toString();
				}
				if (form_Map.get("type") != null) {
					entity_type = form_Map.get("type").toString();
				}
			}
		}
		orderMap.put("form_name", form_name);
		orderMap.put("entity_type", entity_type);
		orderMap.put("quo_name", quo_name);
		orderMap.put("form_id", form_id);
		log.LOG_INFO("退出getOrderFormAdd方法");
		return orderMap;
	}

	/**
	 * 取出单条模板
	 */
	public HashMap getFormNameByName(String form_id, String cust_id)
			throws SaasApplicationException {
		log.LOG_INFO("进入getFormNameByName方法");
		HashMap formMap = new HashMap();
		String form_name = "", entity_type = "";
		TemplateExt temp = new TemplateExt();
		temp.setParam(":VFORM_ID", form_id);
		temp.setParam(":VCUST_ID", cust_id);
		ArrayList list = temp.selByList("SEL_BY_ID");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			if (map.get("form_name") != null) {
				form_name = map.get("form_name").toString();
			}
			if (map.get("entity_type") != null) {
				entity_type = map.get("entity_type").toString();
			}
			formMap.put("type", entity_type);
			formMap.put("name", form_name);
		}
		log.LOG_INFO("退出getFormNameByName方法");
		return formMap;
	}

	/**
	 * @订单总数
	 * @取出新增加、未通过、被打回的订单
	 */
	public int getOrderCountByState(String cust_id, String state1,
			String state2, String state3) throws SaasApplicationException {

		int size = 0;
		ArrayList list = new ArrayList();
		FormStateExt stateExt = new FormStateExt();
		stateExt.setParam(":VCUST_ID", cust_id);
		stateExt.setParam(":VSTATE1", state1);
		stateExt.setParam(":VSTATE2", state2);
		stateExt.setParam(":VSTATE3", state3);
		list = stateExt.selByList("SEL_BY_STATE_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
}