customerdaoimpl.java

CRM源码CRM源码CRM源码CRM源码CRM源码CRM源码

package com.bjsxt.crm.dao.hibernate.impl;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.bjsxt.crm.dao.CustomerDAO;
import com.bjsxt.crm.model.Customer;

public class CustomerDaoImpl extends HibernateDaoSupport implements CustomerDAO {

	public void delete(Customer customer) {
		getHibernateTemplate().delete(customer);		
	}

	public List findAll() {
		return getHibernateTemplate().loadAll(Customer.class);
	}

	public List findCompanyCustomer(String name, int userId) {
		return getHibernateTemplate().find("select c from CompanyCustomer c where ( c.name like ? or c.shortName like ? ) " +
				"and c.owner.id = ?",new Object[]{"%"+name+"%","%"+name+"%",userId});
	}

	public Customer findById(int customerId) {
		// TODO Auto-generated method stub
		return (Customer)getHibernateTemplate().load(Customer.class,customerId);
	}

	public List find(String name, int userId) {
		return getHibernateTemplate().find("select c from Customer c where ( c.name like ? or c.shortName like ? ) " +
				"and c.owner.id = ?",new Object[]{"%"+name+"%","%"+name+"%",userId});
	}

	public List findPersonalCustomer(String name, int userId) {
		return getHibernateTemplate().find("select c from PersonalCustomer c where ( c.name like ? or c.shortName like ? ) " +
				"and c.owner.id = ?",new Object[]{"%"+name+"%","%"+name+"%",userId});
	}

	public void save(Customer customer) {
		getHibernateTemplate().save(customer);
		
	}

	public void update(Customer customer) {
		getHibernateTemplate().update(customer);
		
	}

	
}