Example usage for org.hibernate.criterion DetachedCriteria add

Introduction

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

Prototype

public DetachedCriteria add(Criterion criterion) 

Source Link

Document

Add a restriction

Usage

From source file:com.sapienter.jbilling.server.metafields.db.MetaFieldGroupDAS.java

License:Open Source License

@SuppressWarnings("unchecked")
public MetaFieldGroup getGroupByName(Integer entityId, EntityType entityType, String name) {
    if (name == null || name.trim().length() == 0) {
        return null;
    }//  w ww.ja va  2  s  .co  m
    DetachedCriteria query = DetachedCriteria.forClass(MetaFieldGroup.class);
    query.add(Restrictions.eq("entityId", entityId));
    query.add(Restrictions.eq("entityType", entityType));
    query.add(Restrictions.eq("description", name));
    query.add(Restrictions.eq("class", MetaFieldGroup.class));
    List<MetaFieldGroup> fields = (List<MetaFieldGroup>) getHibernateTemplate().findByCriteria(query);
    return !fields.isEmpty() ? fields.get(0) : null;
}

---

From source file:com.sccl.attech.modules.mobile.service.UpdateFileService.java

License:Open Source License

public Page<UpdateFile> find(Page<UpdateFile> page, UpdateFile updateFile) {
    if (logger.isDebugEnabled()) {
        logger.debug("find(Page<UpdateFile>=" + page + ", UpdateFile=" + updateFile + ") - ");
    }//from w  w  w. j a  v  a2  s  .c o m

    DetachedCriteria dc = updateFileDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(updateFile.getName())) {
        dc.add(Restrictions.eq("name", updateFile.getName()));
    }
    if (StringUtils.isNotEmpty(updateFile.getVersion())) {
        dc.add(Restrictions.eq("version", updateFile.getVersion()));
    }
    if (StringUtils.isNotEmpty(updateFile.getType())) {
        dc.add(Restrictions.eq("type", updateFile.getType()));
    }
    if (StringUtils.isNotEmpty(updateFile.getPath())) {
        dc.add(Restrictions.eq("path", updateFile.getPath()));
    }
    if (StringUtils.isNotEmpty(updateFile.getUrl())) {
        dc.add(Restrictions.eq("url", updateFile.getUrl()));
    }
    dc.add(Restrictions.eq(UpdateFile.FIELD_DEL_FLAG, UpdateFile.DEL_FLAG_NORMAL));
    dc.addOrder(Order.desc("updateDate"));
    Page<UpdateFile> returnPage = updateFileDao.find(page, dc);

    if (logger.isDebugEnabled()) {
        logger.debug("find(Page<UpdateFile>=" + page + ", UpdateFile=" + updateFile + ") - ? - ="
                + page);
    }
    return returnPage;
}

---

From source file:com.sccl.attech.modules.sys.service.AreaService.java

License:Open Source License

/**
 * /*from ww w .  j  a  va  2s  .  c  om*/
 * @param page
 * @param area
 * @return
 */
public Page<Area> findArea(Page<Area> page, Area area) {
    DetachedCriteria dc = areaDao.createDetachedCriteria();

    if (StringUtils.isNotEmpty(area.getName())) {
        dc.add(Restrictions.like("name", "%" + area.getName() + "%"));
    }
    if (StringUtils.isNotEmpty(area.getType())) {
        dc.add(Restrictions.like("type", "%" + area.getType() + "%"));
    }
    dc.createAlias("officeList", "officeList", JoinType.LEFT_OUTER_JOIN);
    //dc.add(dataScopeFilter(UserUtils.getUser(), "officeList", "createBy"));
    dc.add(Restrictions.eq(Area.FIELD_DEL_FLAG, Area.DEL_FLAG_NORMAL));

    return areaDao.find(page, dc);
}

---

From source file:com.sccl.attech.modules.sys.service.AreaService.java

License:Open Source License

/**
 * ?//from   w w  w.  ja  va  2s .co  m
 * @param area
 * @return
 */
public List<Area> getList(Area area) {
    DetachedCriteria dc = areaDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(area.getName())) {
        dc.add(Restrictions.like("name", "%" + area.getName() + "%"));
    }
    dc.add(Restrictions.eq(Area.FIELD_DEL_FLAG, Area.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("code"));
    return areaDao.find(dc);
}

---

From source file:com.sccl.attech.modules.sys.service.AreaService.java

License:Open Source License

/**
 * ?type?//from w  w w. java2s.co m
 * @author luoyang
 * @param type
 * @return
 */
public List<Area> findListByType(String type) {
    DetachedCriteria dc = areaDao.createDetachedCriteria();
    dc.add(Restrictions.eq("type", type));

    return areaDao.find(dc);
}

---

From source file:com.sccl.attech.modules.sys.service.DictService.java

License:Open Source License

public Page<Dict> find(Page<Dict> page, Dict dict) {
    // MyBatis /*ww w.j ava2  s .co m*/
    //      dict.setPage(page);
    //      page.setList(myBatisDictDao.find(dict));
    //      return page;
    // Hibernate 

    DetachedCriteria dc = dictDao.createDetachedCriteria();
    dc.setProjection(Projections.distinct(Projections.property("type")));
    if (StringUtils.isNotEmpty(dict.getLabel())) {
        dc.add(Restrictions.like("label", "%" + dict.getLabel() + "%"));
    }
    if (StringUtils.isNotEmpty(dict.getType())) {
        dc.add(Restrictions.eq("type", dict.getType()));
    }
    System.out.println(dict.getType());
    if (StringUtils.isNotEmpty(dict.getDescription())) {
        dc.add(Restrictions.like("description", "%" + dict.getDescription() + "%"));
    }

    //      if(StringUtils.isNotEmpty(dict.getParentId())){
    //         dc.add(Restrictions.sqlRestriction("parent_id = '"+dict.getParentId()+"'"));
    //         dc.add(Restrictions.like("parentIds", "%"+dict.getParentId()+"%"));//?
    //      }

    //      dc.add(Restrictions.sqlRestriction("parent_ids is not null"));
    dc.add(Restrictions.sqlRestriction("del_flag=0"));
    dc.add(Restrictions.eq(Dict.FIELD_DEL_FLAG, Dict.DEL_FLAG_NORMAL));

    dc.setResultTransformer(dc.DISTINCT_ROOT_ENTITY);
    return dictDao.find(page, dc);
}

---

From source file:com.sccl.attech.modules.sys.service.DictService.java

License:Open Source License

public List<Dict> findChildren(String id) {

    DetachedCriteria dc = dictDao.createDetachedCriteria();

    dc.add(Restrictions.sqlRestriction("parent_id = '" + id + "'"));//?id?

    return dictDao.find(dc);
}

---

From source file:com.sccl.attech.modules.sys.service.DictService.java

License:Open Source License

/**
 * ?//w w  w. jav a 2 s .  c  o m
 * @param dict
 * @return
 */
public List<Dict> getDicts(Dict dict) {
    DetachedCriteria dc = dictDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(dict.getLabel())) {
        dc.add(Restrictions.like("label", "%" + dict.getLabel() + "%"));
    }
    if (StringUtils.isNotEmpty(dict.getType())) {
        dc.add(Restrictions.like("type", "%" + dict.getType() + "%"));
    }
    if (StringUtils.isNotEmpty(dict.getDescription())) {
        dc.add(Restrictions.like("description", "%" + dict.getDescription() + "%"));
    }
    dc.add(Restrictions.eq(Dict.FIELD_DEL_FLAG, Dict.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("type")).addOrder(Order.asc("sort"));
    return dictDao.find(dc);

}

---

From source file:com.sccl.attech.modules.sys.service.DictService.java

License:Open Source License

/**
 * //from  w w w .  j  a  va2 s.  co m
 * param dictID?
 * dict  type?
 */
public List<AllTreeVo> getTreeList(Dict dict, String companyId) {
    List<Dict> list = null;
    DetachedCriteria dc = dictDao.createDetachedCriteria();
    if (!"".equals(StrUtils.null2String(dict.getType()))) {
        dc.add(Restrictions.eq("type", dict.getType()));
    }
    if (!"".equals(StrUtils.null2String(dict.getId()))) {
        //         dc.add(Restrictions.eq("parent", dict));
        dc.add(Restrictions.sqlRestriction("parent_id = '" + dict.getId() + "'"));
    } else {
        //         dc.add(Restrictions.isNull("parent"));
        dc.add(Restrictions.sqlRestriction("parent_id is null"));
    }
    dc.add(Restrictions.or(Restrictions.isNull("companyId"), Restrictions.eq("companyId", "0"),
            Restrictions.eq("companyId", StrUtils.null2String(companyId))));
    dc.add(Restrictions.eq("delFlag", "0"));
    list = dictDao.find(dc);
    List<AllTreeVo> listAllTreeVos = new ArrayList<AllTreeVo>();
    if (null != list && list.size() > 0) {
        for (Dict dicts : list) {
            AllTreeVo allTreeVo = new AllTreeVo();
            allTreeVo.setLabel(dicts.getLabel());
            allTreeVo.setId(dicts.getId());
            //??
            List<Dict> dictChildren = findChildren(dicts.getId());//?id?
            //            if(null != dicts.getChildren() && dicts.getChildren().size() > 0){
            //               allTreeVo.setHasChild(true);
            //            }
            if (null != dictChildren && dictChildren.size() > 0) {//?????
                allTreeVo.setHasChild(true);
            }
            listAllTreeVos.add(allTreeVo);
        }
    }
    return listAllTreeVos;
}

---

From source file:com.sccl.attech.modules.sys.service.DictService.java

License:Open Source License

/**
 * ????/*from ww w. ja  v a2 s  .c  o  m*/
 */
public List<AllTreeVo> getAllChildTreeList(Dict dicts, String companyId, String name) {
    DetachedCriteria dc = dictDao.createDetachedCriteria();
    if (!"".equals(StrUtils.null2String(dicts.getType()))) {
        dc.add(Restrictions.eq("type", dicts.getType()));
    }

    if (name != null && !name.equals("")) {
        dc.add(Restrictions.like("label", "%" + name.trim() + "%"));
    }
    dc.add(Restrictions.eq("delFlag", "0"));
    dc.add(Restrictions.or(Restrictions.isNull("companyId"), Restrictions.eq("companyId", "0"),
            Restrictions.eq("companyId", StrUtils.null2String(companyId))));
    List<Dict> list = dictDao.find(dc);
    List<AllTreeVo> listAllTreeVo = new ArrayList<AllTreeVo>();
    if (null != list && list.size() > 0) {
        for (Dict dict : list) {

            List<Dict> dictChildren = findChildren(dict.getId());//?id?

            //            if(null == dict.getChildren() || dict.getChildren().size() <= 0){
            if (null == dictChildren || dictChildren.size() <= 0) {//?????
                AllTreeVo allTreeVo = new AllTreeVo();
                allTreeVo.setId(dict.getId());
                allTreeVo.setLabel(dict.getLabel());
                listAllTreeVo.add(allTreeVo);
            }
        }
    }
    return listAllTreeVo;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »