Example usage for org.hibernate.criterion DetachedCriteria addOrder

Introduction

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

Prototype

public DetachedCriteria addOrder(Order order)

Source Link

Document

Adds an ordering

Usage

From source file:org.forzaframework.core.persistance.hibernate.BaseDaoHibernate.java

License:Apache License

public List getAll(Class clazz, String query) {
    DetachedCriteria crit = DetachedCriteria.forClass(clazz);
    Disjunction disjunction = Restrictions.disjunction();

    if (StringUtils.isNotBlank(query)) {
        disjunction.add(Restrictions.like("code", query, MatchMode.ANYWHERE).ignoreCase());
        disjunction.add(Restrictions.like("name", query, MatchMode.ANYWHERE).ignoreCase());
    }//  w  ww .j a  v a2  s.  co  m
    crit.add(disjunction);
    crit.addOrder(Order.asc("id"));

    log.debug("disjunction:" + disjunction.toString());
    return getHibernateTemplate().findByCriteria(crit);
}

From source file:org.gaixie.micrite.car.dao.hibernate.CarfileDAOImpl.java

License:Open Source License

@Override
public List<Carfile> findByMaintainDateWillExpired(Integer carownerId, int fromDays, int toDays, int start,
        int limit) {
    // TODO Auto-generated method stub
    DetachedCriteria criteria = DetachedCriteria.forClass(Carfile.class);
    if (carownerId != null)
        criteria.add(Expression.eq("carowner.id", carownerId));
    criteria.add(Expression.eq("carStatus", ICarfileService.CARSTATUS_NORMAL));
    criteria.add(Expression.eq("status", ICarfileService.STATUS_NORMAL));
    criteria.addOrder(Order.asc("daysToExpired"));
    criteria.add(Expression.between("daysToExpired", fromDays, toDays));
    List<Carfile> list = getHibernateTemplate().findByCriteria(criteria, start, limit);
    desidedExpiredFlag(list);/*from   w w  w .j  a  va2  s . c  o m*/
    return list;
}

From source file:org.gaixie.micrite.car.dao.hibernate.CarfileDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Carfile> advancedFindByPerPage(SearchBean[] queryBean, int start, int limit) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(Carfile.class, queryBean);
    criteria.add(Expression.eq("status", ICarfileService.STATUS_NORMAL));
    for (int i = 0; i < queryBean.length; i++) {
        if (queryBean[i] != null && queryBean[i].getName() != null
                && queryBean[i].getName().startsWith("carowner.id")) {
            criteria.addOrder(Order.desc("licenseNumber"));
            break;
        }/*from   ww  w  .  j  a v a  2  s . com*/
    }
    criteria.addOrder(Order.desc("editDate"));
    List<Carfile> list = getHibernateTemplate().findByCriteria(criteria, start, limit);
    desidedExpiredFlag(list);
    return list;
}

From source file:org.gaixie.micrite.car.dao.hibernate.CarfileDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Carfile> findByCreateDateSpacingPerPage(int start, int limit, int carType) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Carfile.class);
    criteria.add(Expression.eq("status", ICarfileService.STATUS_NORMAL));
    criteria.addOrder(Order.desc("editDate"));
    criteria.createAlias("skillRank", "cs");
    if (0 != carType) {
        criteria.add(Expression.eq("cs.id", carType));
    }/*from   w  w w  . j a  v a2 s .c  o m*/
    List<Carfile> list = getHibernateTemplate().findByCriteria(criteria, start, limit);
    desidedExpiredFlag(list);
    return list;
}

From source file:org.gaixie.micrite.car.dao.hibernate.CarfileDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Carfile> findCarfileBySkillPerPage(int start, int limit, int carType, int skill) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Carfile.class);
    criteria.add(Expression.eq("status", ICarfileService.STATUS_NORMAL));
    criteria.addOrder(Order.desc("editDate"));
    //        criteria.add(Expression.like("licenseNumber","%"+licenseNumber+"%"));  
    if (0 != carType)
        criteria.add(Restrictions.eq("carType.id", carType));
    if (0 != skill)
        criteria.add(Restrictions.eq("skillRank.id", skill));
    List<Carfile> list = getHibernateTemplate().findByCriteria(criteria, start, limit);
    desidedExpiredFlag(list);//from www. j  a v  a  2s  .com
    return list;
    //       List<Carfile> list= getHibernateTemplate().find("from Carfile c where c.carType.id like ? and c.skillRank.id=? ",new Object[]{carType,skill});
    //       return list; 
}

From source file:org.gaixie.micrite.car.dao.hibernate.CarfileDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List findCSGroupByTelVague(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(Carfile.class, queryBean);
    criteria.add(Expression.eq("status", ICarfileService.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<Carfile> list = getHibernateTemplate().findByCriteria(criteria);
    //        desidedExpiredFlag(list);
    return list;//from   w ww  . j ava 2  s  .c  om
}

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

License:Open Source License

@SuppressWarnings("unchecked")
public List<Carowner> advancedFindByPerPage(SearchBean[] queryBean, int start, int limit) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(Carowner.class, queryBean);
    criteria.addOrder(Order.desc("editDate"));
    criteria.add(Restrictions.gt("id", 0));
    return getHibernateTemplate().findByCriteria(criteria, start, limit);
}

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

@SuppressWarnings("unchecked")
public List<Enterprise> advancedFindByPerPage(SearchBean[] queryBean, int start, int limit) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(Enterprise.class, queryBean);
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.add(Expression.eq("status", IEnterpriseService.STATUS_NORMAL));
    criteria.addOrder(Order.desc("editDate"));
    return getHibernateTemplate().findByCriteria(criteria, start, limit);
}

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

License:Open Source License

@SuppressWarnings("unchecked")
public List<PatrolRiverSummary> advancedFindByPerPage(SearchBean[] queryBean, int start, int limit) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(PatrolRiverSummary.class, queryBean);
    criteria.add(Expression.eq("State", IPatrolRiverSummaryService.STATUS_NORMAL));
    //        for (int i = 0; i < queryBean.length; i++) {
    //         if(queryBean[i]!=null&&queryBean[i].getName()!=null&&queryBean[i].getName().startsWith("carowner.id")){
    //            criteria.addOrder(Order.desc("licenseNumber"));
    //            break;   
    //         }/*from   ww  w.  j a v a  2s .c o  m*/
    //      }
    criteria.addOrder(Order.desc("editDate"));
    List<PatrolRiverSummary> list = getHibernateTemplate().findByCriteria(criteria, start, limit);

    return list;
}

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

License:Open Source License

@SuppressWarnings("unchecked")
public List<PatrolRiverSummary> findByCreateDateSpacingPerPage(int start, int limit, int carType) {
    DetachedCriteria criteria = DetachedCriteria.forClass(PatrolRiverSummary.class);
    criteria.add(Expression.eq("status", IPatrolRiverSummaryService.STATUS_NORMAL));
    criteria.addOrder(Order.desc("editDate"));
    criteria.createAlias("skillRank", "cs");
    if (0 != carType) {
        criteria.add(Expression.eq("cs.id", carType));
    }/*from  ww  w .  j a v a 2s  .co m*/
    List<PatrolRiverSummary> list = getHibernateTemplate().findByCriteria(criteria, start, limit);

    return list;
}