servicedaoimpl.java

来自「通过这个系统完成对客户基本信息、联系人信息、交往信息、客户服务信息的充分共享和规」· Java 代码 · 共 79 行

package com.t53.crm4.serve.dao.impl;

import java.sql.SQLException;
import java.util.Date;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.MatchMode;
import org.hibernate.criterion.Restrictions;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.t53.crm4.common.dao.impl.GenericDao;
import com.t53.crm4.common.entity.CstService;
import com.t53.crm4.serve.dao.IServiceDao;

public class ServiceDaoImpl extends
		GenericDao<CstService, Long, ServiceDaoImpl> implements IServiceDao {

	/**
	 * 添加服务条目
	 */
	public Long addService(CstService cstService) {
		return this.save(cstService);

	}

	public int update(String hql) {

		return this.bulkUpdate(hql);
	}

	public void deleteBySvrId(CstService cstService) {

		this.delete(cstService);
	}

	public List<CstService> findByAllot(String hql) {

		return this.find(hql);
	}

	public CstService findById(Long id) {
		// TODO Auto-generated method stub
		return this.get(id);
	}

	@SuppressWarnings("unchecked")
	public List<CstService> findByPagination(final CstService cstService,
			final int firstResult, final int maxResult, final Date loDate,
			final Date hiDate) {
		return getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Criteria criteria = session.createCriteria(getEntityClass());
				criteria.add(Example.create(cstService).enableLike(
						MatchMode.ANYWHERE));
				criteria.setFirstResult(firstResult);
				criteria.setMaxResults(maxResult);
				if (loDate != null || hiDate != null) {
					// 之前时间的所有记录
					if (loDate == null)
						criteria.add(Restrictions.le("svrCreateDate", hiDate));
					// 之后时间的所有记录
					else if (hiDate == null)
						criteria.add(Restrictions.ge("svrCreateDate", loDate));
					// 两者之间的所有记录
					else
						criteria.add(Restrictions.between("svrCreateDate",
								loDate, hiDate));
				}
				return criteria.list();
			}
		});
	}
}