storagebiz.java

来自「实现用户关系管理系统」· Java 代码 · 共 46 行

package org.jb.y2t308.team3.biz;

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

public class StorageBiz extends BaseBiz {
	// 查询库存信息
	public void getStorageList(Storage storage, PageResult pageResult) {
		String hql = "select s from Storage s where 1=1";
		/**
		 * 根据（产品名、仓库）进行模糊查询
		 */
		if (null != storage.getProduct()) {
			if (isNotNullOrEmpty(storage.getProduct().getProdName())) {
				hql += "and s.product.prodName like '%"
						+ storage.getProduct().getProdName().trim() + "%'";
			}

		}

		if (null != storage.getStkWarehouse()) {
			if (isNotNullOrEmpty(storage.getStkWarehouse())) {
				hql += "and s.stkWarehouse like '%" + storage.getStkWarehouse().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 s.stkId,s.product.prodId asc";
		}
		this.getCommonDAO().listByPage(hql, pageResult);
	}
}