storagebiz.java

来自「crm系统 有源码 及相关文档sql2005 数据库 客户反馈模块」· Java 代码 · 共 42 行

package org.jb.y272.team0.biz;

import org.jb.common.biz.BaseBiz;
import org.jb.common.util.PageResult;
import org.jb.y272.team0.entity.VStorage;

/**
 *  管理业务逻辑类
 * @author hailong.liu
 */
public class StorageBiz extends BaseBiz {
	/**
	 * 查询  
	 */
	public void search(VStorage condition, PageResult pageResult) {
		String hql = "select o from VStorage o where 1=1 ";
		if (null!=condition){	
			if (isNotNullOrEmpty(condition.getStkProduct())){
				hql += "and o.stkProduct like '%"
						+condition.getStkProduct()+"%' ";
			}
			if (isNotNullOrEmpty(condition.getStkWarehouse())){
				hql += "and o.stkWarehouse like '%"
						+condition.getStkWarehouse()+"%' ";
			}

		}
		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 o.stkId desc";
		}		
		this.getCommonDAO().listByPage(hql,pageResult);
	}
}