orderlinebiz.java

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

package org.jb.y272.team0.biz;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import org.jb.common.biz.BaseBiz;
import org.jb.y272.team0.entity.VOrdersLine;
import org.jb.y272.team0.entity.VProduct;

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

	/**
	 * 查询  
	 */
	@SuppressWarnings("unchecked")
	public List search(VOrdersLine condition) {
		List ret = new ArrayList();
		String hql = "select o,p from VOrdersLine o,VProduct p where o.oddProdId=p.prodId ";
		if (null!=condition){
			if(condition.getOddOrderId()!=null && condition.getOddOrderId()>0){
				hql += "and o.oddOrderId = '" + condition.getOddOrderId() + "' ";
			}
		}
		hql += "order by o.oddId desc";
		List list = this.getCommonDAO().list(hql);
		Iterator it = list.iterator();
		while(it.hasNext()){
			Object[] arr = (Object[])it.next();
			VOrdersLine line = (VOrdersLine)arr[0];
			VProduct prod = (VProduct)arr[1];
			line.setOddProdName(prod.getProdName()+"-"+prod.getProdType()+"-"+prod.getProdBatch());
			ret.add(line);
		}
		
		return ret;
	}
}