orderbiz.java

crm系统 有源码 及相关文档sql2005 数据库 客户反馈模块

package org.jb.y272.team0.biz;

import java.io.Serializable;

import org.jb.common.biz.BaseBiz;
import org.jb.y272.team0.entity.CstCustomer;
import org.jb.y272.team0.entity.VOrders;

import java.util.List;

/**
 *  管理业务逻辑类
 * @author hailong.liu
 */
public class OrderBiz extends BaseBiz {
	/**
	 * 加载 
	 */
	public VOrders get(Serializable id){
		VOrders ret = (VOrders)this.getCommonDAO().get(VOrders.class, id);		
		return ret;
	}

	/**
	 * 查询  
	 */
	public List search(VOrders condition) {
		String hql = "select o from VOrders o where 1=1 ";
		if (null!=condition){				
			if(isNotNullOrEmpty(condition.getOdrCustomer())){
				String custName = getCustById(condition.getOdrCustomer()).getCustName();
				hql += "and o.odrCustomer = '" + custName + "' ";
			}
		}
		hql += "order by o.odrId desc";
		return this.getCommonDAO().list(hql);
	}
	
	public CstCustomer getCustById(String custId){
		CstCustomer item = (CstCustomer)this.getCommonDAO().get(CstCustomer.class, custId);
		return item;	
	}
}