Example usage for org.hibernate.criterion DetachedCriteria addOrder

List of usage examples for org.hibernate.criterion DetachedCriteria addOrder

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. 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:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

/**
 * ?//from  w ww  . ja v a2s.c  o  m
 * ?del
* @Title: findByDel
* @Description: TODO(????)
* @param @param page
* @param @param office
* @param @return    
* @return Page<Office>    
* @throws
 */
public Page<Office> findByDel(Page<Office> page, Office office) {
    User user = UserUtils.getUser();
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(office.getName())) {
        dc.add(Restrictions.like("name", "%" + EscapeUtil.escapeLike(office.getName()) + "%"));
    }
    Office off = new Office();
    off.setId(1L);
    dc.add(Restrictions.ne("parent", off));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.ne("id", 34L));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(page, dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

/**
 * /*from www. j  av a2s .  c  om*/
 * @param office
 * @return
 */
public List<Office> findAllByDel(Office office) {
    User user = UserUtils.getUser();
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(office.getName())) {
        dc.add(Restrictions.like("name", "%" + EscapeUtil.escapeLike(office.getName()) + "%"));
    }
    Office off = new Office();
    off.setId(1L);
    dc.add(Restrictions.ne("parent", off));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.ne("id", 34L));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

public Page<Office> findOffice(Page<Office> page, Office office) {
    User user = UserUtils.getUser();//  w  w  w  .  j  av a  2 s.com
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    //      if (StringUtils.isNotEmpty(office.getName())){
    //         dc.add(Restrictions.like("name", "%"+EscapeUtil.escapeLike(office.getName())+"%"));
    //      }
    dc.add(Restrictions.eq("areaName", office.getName()));
    dc.add(Restrictions.eq("parent", office));
    //dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.ne("id", 34L));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(page, dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

public List<Office> find(Long areaId) {
    User user = UserUtils.getUser();/*from   w  w w  .ja v a2  s .  co m*/
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(areaId.toString())) {
        dc.add(Restrictions.eq("area.id", areaId));
    }
    dc.add(dataScopeFilter(user, dc.getAlias(), ""));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

public List<Office> findByParentId(Long areaId) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (areaId == null) {
        return null;
    }/*from   w  w  w  . ja v a  2s .c om*/
    if (areaId != null) {

        if (StringUtils.isNotEmpty(areaId.toString())) {
            dc.add(Restrictions.eq("parent.id", areaId));
        } else {
            return null;
        }
    }
    dc.add(Restrictions.neOrIsNotNull("type", "1"));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

public List<Office> findByParentIds(List<Long> areaIds) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (areaIds == null) {
        return null;
    }// ww w .  j a  va 2s.c o  m
    if (areaIds != null) {

        if (StringUtils.isNotEmpty(areaIds.toString())) {
            dc.add(Restrictions.in("parent.id", areaIds));
        } else {
            return null;
        }
    }
    dc.add(Restrictions.neOrIsNotNull("type", "1"));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

/**
 * ?//from w w  w .  j a  va 2 s .co  m
* @Title: findOfficesByParentId
* @Description: TODO(????)
* @param @param areaId
* @param @return    
* @return List<Office>    
* @throws
 */
public List<Office> findOfficesByParentId(Long areaId) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(areaId.toString())) {
        dc.add(Restrictions.eq("parent.id", areaId));
    }
    dc.add(Restrictions.eq("type", "2"));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

public List<Office> findByParentId(Long areaId, Integer type) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(areaId.toString())) {
        dc.add(Restrictions.eq("parent.id", areaId));
    }/*  w  w w.j  a va 2s .  c  o  m*/
    dc.add(Restrictions.eq("type", String.valueOf(type)));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

public List<Office> findByIds(Page<Office> page, List<Long> officeIds) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (officeIds.size() > 0) {
        dc.add(Restrictions.in("id", officeIds));
    }/*w w  w.j  av a  2s.c o  m*/
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

@Transactional(readOnly = false)
public List<Office> getOfficeList(Integer type) {
    List<Office> officeList = null;
    //User user = getUser();
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    //dc.add(dataScopeFilter(user, dc.getAlias(), ""));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.eq("type", type.toString()));
    dc.addOrder(Order.asc("code"));
    officeList = officeDao.find(dc);//  ww  w . j  av a2s .c om
    return officeList;
}