productbiz.java

实现用户关系管理系统

package org.jb.y2t308.team3.biz;

import org.jb.common.biz.BaseBiz;
import org.jb.common.util.PageResult;
import org.jb.y2t308.team3.entity.Product;

public class ProductBiz extends BaseBiz {
	//查询产品信息,分页显示
	public void getProductList(Product product, PageResult pageResult){
		String hql = "select p from Product p where 1=1";
		/**
		 * 根据（产品名称、类别、批次）进行模糊查询
		 */
		if (null != product) {
			if (isNotNullOrEmpty(product.getProdName())) {
				hql += " and p.prodName like '%" + product.getProdName().trim()
						+ "%'";
			}
			if (isNotNullOrEmpty(product.getProdType())) {
				hql += "and p.prodType like '%" + product.getProdType().trim()
						+ "%'";
			}
			if (isNotNullOrEmpty(product.getProdBatch())) {
				hql += "and p.prodBatch like '%" + product.getProdBatch().trim()
						+ "%'";
			}
		}
		
		/**
		 * 排序
		 */
		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 p.prodId,p.prodType asc";
		}

		this.getCommonDAO().listByPage(hql, pageResult);
	}
}