clientanalysisdao.java

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

package com.qrsx.qrsxcrm.dao;

import java.util.List;
import java.util.Set;

import org.hibernate.Query;

import com.qrsx.qrsxcrm.model.Client;

public class ClientAnalysisDAO extends BaseDAO {

	public ClientAnalysisDAO(Class Client) {
		super(Client);
	}
	/**
	 * 根据客户来源检索客户数据    
	 */
	public List findByOrigin(String origin){

		String hql="from Client c where c.origin ="+"'"+origin+"'";
		Query query= session.createQuery(hql);
		List lists=query.list();
		return lists;
	}
	/**
	 * 根据客户地区分析客户
	 * @return
	 */
	public List finByArea(String  area){
		String hql="from Client c where c.address like"+"'%"+area+"%'";
		Query query= session.createQuery(hql);
		List lists=query.list();
		return lists;
	}
	/**
	 * 根据客户类型分析客户
	 */
	public List findByType(String clientTypeId){
		String sql="select * from client where clientTypeId ="+"'"+clientTypeId+"'";
		Query query= session.createSQLQuery(sql);
		List lists=query.list();
		return lists;
	}
	//根据客户查找联系人人
	//根据客户查找负责人
	
	//动态查询
	public List findByED(Client client){
		String sql="select * from client c where 1=1";
		if(client.getAddress()!=null&&client.getAddress().trim().length()>0){
			sql += " and c.address like '%" + client.getAddress() + "%'";
		}
		if(client.getOrigin()!=null&&client.getOrigin().trim().length()>0){
			sql += " and c.origin like '%" + client.getOrigin()+ "%'";
		}
		if(client.getClientTypeId()!=null&&client.getClientTypeId().trim().length()>0){
			sql += " and c.clientTypeId like '%" + client.getClientTypeId()+ "%'";
		}
		
		Query query= session.createSQLQuery(sql);
		List lists=query.list();
		return lists;
	}
	
}