orderdao.java

客户关系管理系统主要管理新老客户的一些信息并可以发现潜在客户

/**
 * 
 */
package com.qrsx.qrsxcrm.dao;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.MatchMode;

import com.qrsx.qrsxcrm.model.Dept;
import com.qrsx.qrsxcrm.model.Duty;
import com.qrsx.qrsxcrm.model.Lists;
import com.qrsx.qrsxcrm.model.Order;

/**
 * @author Administrator
 *
 */
public class OrderDAO extends BaseDAO
{

	@SuppressWarnings("unchecked")
	public OrderDAO(Class Order) {
		super(Order);
		// TODO Auto-generated constructor stub
	}
	
	public void updates(Order order)
	{
		Order order1 = new Order();
		order1=(Order) session.get(Order.class, order.getId());
		order1.setClient(order.getClient());
		order1.setCreateDate(order.getCreateDate());
		order1.setEmployee(order.getEmployee());
		order1.setOrderId(order.getOrderId());
		order1.setPayDate(order.getPayDate());
		order1.setState(order.getState());
		order1.setUser(order.getUser());
		order1.setRemark(order.getRemark());
		
		session.update(order1);
	}
	
	
	@SuppressWarnings("unchecked")
	public List<Lists> lists(Order order){
		List<Lists> list=new ArrayList<Lists>();
		String sql="from Lists t where 1=1 ";
			sql+=" and t.orderId = "+order.getId();
		Query query=session.createQuery(sql);
		list=query.list();
		return list;
	}

	@SuppressWarnings("unchecked")
	public List<Lists>findByOrderId( String id )
	{
		String orderId=id;
		String sql="from Lists as l where l.orderId like '%"+orderId+"%' ";
		Query query=session.createQuery(sql);
//		query.setString("id", orderId);
		List list=query.list();
		return list;
	}
	/**
	 * 分析方法 动态检索订单   客户 & 负责人
	 */
	public List findByED(Order order){
		String sql="select * from orders o where 1=1 ";
		if(order.getClientId()!=null&&order.getClientId().trim().length()>0){
			sql+="and o.clientId ="+"'"+order.getClientId()+"'";
		}
		if(order.getEmployeeId()!=null&&order.getEmployeeId().trim().length()>0){
			sql+=" and o.employeeId ="+"'"+order.getEmployeeId()+"'";
		}
		Query query= session.createSQLQuery(sql);
		List lists=query.list();
		return lists;
	}
	

}