ordersbiz.java

实现用户关系管理系统

package org.jb.y2t308.team3.biz;

import java.util.List;

import org.jb.common.biz.BaseBiz;
import org.jb.common.util.PageResult;
import org.jb.y2t308.team3.entity.Orders;
/**
 * 
 * 历史订单类
 * 
 * @author Administrator
 *
 */
public class OrdersBiz extends BaseBiz {
/**
 * 
 * 历史订单的分页列表
 * 
 * @param orders
 * @param pageResult
 */
	public void getOrderList(Orders orders, PageResult pageResult) {
		String hql="select odrId,odrCustomer,odrDate,odrAddr,odrStatus from Orders " +
		"inner join CstCustomer on Orders.odrCustomer=CstCustomer.custName";
		if (null != orders) {
			if (isNotNullOrEmpty(orders.getOdrCustomer())) {
				hql += "and Orders.odrCustomer like '%" + orders.getOdrCustomer()
						+ "%'";
			}
			if (isNotNullOrEmpty(orders.getOdrAddr())) {
				hql += "and orders.odrAddr like '%" + orders.getOdrAddr()
						+ "%'";
			}
			if (isNotNullOrEmpty(orders.getOdrStatus())) {
				hql += "and orders.odrStatus like '%" + orders.getOdrStatus()
						+ "%'";
			}
		}
		
		/**
		 * 排序
		 */
		if (isNotNullOrEmpty(pageResult.getOrderBy())) {
			String sort = pageResult.getSort();
			hql += "order by" + pageResult.getOrderBy() + "" + sort;
			if ("asc".equals(sort)) {
				pageResult.setSort("desc");

			} else {
				pageResult.setSort("asc");
			}
		} else {
			hql += "order by orders.odrId,orders.odrCustomer asc";
		}

		this.getCommonDAO().listByPage(hql, pageResult);
	}
	/**
	 * 
	 * 根据客户名称得到订单
	 * 
	 * @param custNo
	 * @return
	 */
	public List getOrderLineByodrCustomer(String odrCustomer) {
		return this.getCommonDAO().list(
				" FROM where Orders o where o.odrCustomer= '" + odrCustomer + "'");
	}
	/**
	 * 
	 * 根据历史订单的id查找历史订单的相信信息
	 * @param odrId
	 * @return
	 */
	public Orders getOrderByOdrId(Long odrId) {
		Orders orders = null;
		String hql = "from Orders o where 1=1 and o.odrId=" + odrId;
		orders = (Orders) this.getCommonDAO().get(Orders.class, odrId);
		return orders;
	}
}