Example usage for org.hibernate.criterion DetachedCriteria setProjection

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria setProjection.

Prototype

public DetachedCriteria setProjection(Projection projection)

Source Link

Document

Set the projection to use.

Usage

From source file:org.gaixie.micrite.crm.dao.hibernate.CustomerDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List findCSGroupByTelVague(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(Carowner.class, queryBean);
    criteria.createAlias("customerSource", "cs");
    criteria.setProjection(Projections.projectionList().add(Projections.count("cs.name"))
            .add(Projections.groupProperty("cs.name")));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.gaixie.micrite.enterprise.dao.hibernate.EnterpriseDAOImpl.java

public int advancedFindCount(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(Enterprise.class, queryBean);
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.add(Expression.eq("status", IEnterpriseService.STATUS_NORMAL));
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.enterprise.dao.hibernate.EnterpriseDAOImpl.java

public int findByCreateDateSpacingCount(Date startDate, Date endDate, int EnterpriseSourceType) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Enterprise.class);
    criteria.createAlias("enterpriseSource8", "cs");
    if (0 != EnterpriseSourceType) {
        criteria.add(Expression.eq("cs.id", EnterpriseSourceType));
    }/*from  w  ww. j a va 2s .  c o m*/
    criteria.add(Expression.between("createDate", startDate, endDate));
    criteria.add(Restrictions.ne("id", 1));
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.enterprise.dao.hibernate.EnterpriseDAOImpl.java

@SuppressWarnings("unchecked")
public List findCSGroupByTelVague(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(Enterprise.class, queryBean);
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.createAlias("qualification", "cs");
    criteria.setProjection(Projections.projectionList().add(Projections.count("cs.name"))
            .add(Projections.groupProperty("cs.name")));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.gaixie.micrite.enterprise.dao.hibernate.EnterpriseDAOImpl.java

@Override
public boolean existEnterprise(Integer id, String license) {
    // TODO Auto-generated method stub
    DetachedCriteria criteria = DetachedCriteria.forClass(Enterprise.class);
    criteria.add(Expression.eq("status", IEnterpriseService.STATUS_NORMAL));
    criteria.setProjection(Projections.rowCount());
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.add(Expression.eq("license", license));
    if (id != null) {
        criteria.add(Expression.ne("id", id));
    }/* www  .  java  2  s  . c om*/
    return ((Integer) getHibernateTemplate().findByCriteria(criteria).get(0)) > 0;
}

From source file:org.gaixie.micrite.patrolRiverSummary.dao.hibernate.PatrolRiverSummaryDAOImpl.java

License:Open Source License

public int advancedFindCount(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(PatrolRiverSummary.class, queryBean);
    criteria.add(Expression.eq("State", IPatrolRiverSummaryService.STATUS_NORMAL));
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.patrolRiverSummary.dao.hibernate.PatrolRiverSummaryDAOImpl.java

License:Open Source License

public int findByCreateDateSpacingCount(int carType) {
    DetachedCriteria criteria = DetachedCriteria.forClass(PatrolRiverSummary.class);
    criteria.add(Expression.eq("State", IPatrolRiverSummaryService.STATUS_NORMAL));
    //        criteria.createAlias("skillRank", "cs");
    //        if(0!=carType){
    //            criteria.add(Expression.eq("cs.id", carType));
    //        }/*from w w  w .  j  a v a2s . co m*/
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.patrolRiverSummary.dao.hibernate.PatrolRiverSummaryDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List findCSGroupByTelVague(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(PatrolRiverSummary.class, queryBean);
    criteria.add(Expression.eq("approveStatus", IPatrolRiverSummaryService.STATUS_NORMAL));
    criteria.addOrder(Order.desc("editDate"));
    criteria.createAlias("carType", "cs");
    criteria.setProjection(Projections.projectionList().add(Projections.count("cs.name"))
            .add(Projections.groupProperty("cs.name")));
    List<PatrolRiverSummary> list = getHibernateTemplate().findByCriteria(criteria);
    //        desidedExpiredFlag(list);
    return list;//from  w w  w.  j  a  v a  2  s .  c  o  m
}

From source file:org.gaixie.micrite.patrolRiverSummary.dao.hibernate.PatrolRiverSummaryDAOImpl.java

License:Open Source License

@Override
public boolean existPatrolRiverSummary(Integer userid) {
    DetachedCriteria criteria = DetachedCriteria.forClass(PatrolRiverSummary.class);
    criteria.add(Expression.eq("status", IPatrolRiverSummaryService.STATUS_NORMAL));
    criteria.setProjection(Projections.rowCount());
    if (userid != null) {
        criteria.add(Expression.ne("id", userid));
    }//from w  w w .j  av  a2  s .c  o m
    return ((Integer) getHibernateTemplate().findByCriteria(criteria).get(0)) > 0;
}

From source file:org.gaixie.micrite.river.dao.hibernate.RiverDAOImpl.java

public int advancedFindCount(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(River.class, queryBean);
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.add(Expression.eq("State", IRiverService.STATUS_NORMAL));
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}