Example usage for org.hibernate Criteria add

Introduction

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

Prototype

public Criteria add(Criterion criterion);

Source Link

Document

Add a Criterion restriction to constrain the results to be retrieved.

Usage

From source file:au.org.theark.admin.model.dao.AdminDao.java

License:Open Source License

public ArkRole getArkRoleByName(String name) {
    Criteria criteria = getSession().createCriteria(ArkRole.class);
    criteria.add(Restrictions.eq("name", name));
    return (ArkRole) criteria.list().get(0);
}

From source file:au.org.theark.admin.model.dao.AdminDao.java

License:Open Source License

public List<ArkRoleModuleFunctionVO> getArkRoleModuleFunctionVoList(ArkRole arkRole) {
    Criteria criteria = getSession().createCriteria(ArkRolePolicyTemplate.class, "arpt");
    criteria.add(Restrictions.eq("arpt.arkRole", arkRole));

    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.groupProperty("arpt.arkRole"), "arkRole");
    projectionList.add(Projections.groupProperty("arpt.arkModule"), "arkModule");
    projectionList.add(Projections.groupProperty("arpt.arkFunction"), "arkFunction");

    criteria.setProjection(projectionList);

    ResultTransformer resultTransformer = Transformers.aliasToBean(ArkRoleModuleFunctionVO.class);
    criteria.setResultTransformer(resultTransformer);

    return criteria.list();
}

From source file:au.org.theark.admin.model.dao.AdminDao.java

License:Open Source License

public List<ArkRolePolicyTemplate> getArkRolePolicyTemplateList(
        ArkRolePolicyTemplate arkRolePolicyTemplateCriteria) {
    Criteria criteria = getSession().createCriteria(ArkRolePolicyTemplate.class, "arpt");

    if (arkRolePolicyTemplateCriteria.getId() != null) {
        criteria.add(Restrictions.eq("arpt.id", arkRolePolicyTemplateCriteria.getId()));
    }// ww  w .j av a 2  s  . c om

    if (arkRolePolicyTemplateCriteria.getArkRole() != null) {
        criteria.add(Restrictions.eq("arpt.arkRole", arkRolePolicyTemplateCriteria.getArkRole()));
    }

    if (arkRolePolicyTemplateCriteria.getArkModule() != null) {
        criteria.add(Restrictions.eq("arpt.arkModule", arkRolePolicyTemplateCriteria.getArkModule()));
    }

    if (arkRolePolicyTemplateCriteria.getArkFunction() != null) {
        criteria.add(Restrictions.eq("arpt.arkFunction", arkRolePolicyTemplateCriteria.getArkFunction()));
    }
    return criteria.list();
}

From source file:au.org.theark.admin.model.dao.AdminDao.java

License:Open Source License

public List<ArkModule> getArkModuleList(ArkRole arkRole) {
    Criteria criteria = getSession().createCriteria(ArkModuleRole.class);

    if (arkRole != null) {
        criteria.add(Restrictions.eq("arkRole", arkRole));
    }//from ww  w. ja v a2 s  .  co m
    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.groupProperty("arkModule"), "arkModule");
    criteria.setProjection(projectionList);

    return criteria.list();
}

From source file:au.org.theark.admin.model.dao.AdminDao.java

License:Open Source License

private Criteria buildArkModuleFunctionCriteria(ArkModuleFunction arkModuleFunctionCriteria) {
    Criteria criteria = getSession().createCriteria(ArkModuleFunction.class);

    if (arkModuleFunctionCriteria.getArkModule() != null
            && arkModuleFunctionCriteria.getArkModule().getId() != null) {
        criteria.add(Restrictions.eq("arkModule", arkModuleFunctionCriteria.getArkModule()));
    }/*from  w  w  w .  ja v a 2  s.co m*/

    criteria.createAlias("arkModule", "module");
    criteria.addOrder(Order.asc("module.name"));
    criteria.addOrder(Order.asc("functionSequence"));

    return criteria;
}

From source file:au.org.theark.admin.model.dao.AdminDao.java

License:Open Source License

public ArkModuleFunction getArkModuleFunction(Long id) {
    Criteria criteria = getSession().createCriteria(ArkModuleFunction.class);
    criteria.add(Restrictions.eq("id", id));
    return (ArkModuleFunction) criteria.uniqueResult();
}

From source file:au.org.theark.admin.model.dao.AdminDao.java

License:Open Source License

public List<ArkModuleFunction> getArkModuleFunctionByArkModule(ArkModule arkModule) {
    Criteria criteria = getSession().createCriteria(ArkModuleFunction.class);
    criteria.add(Restrictions.eq("arkModule", arkModule));
    return (List<ArkModuleFunction>) criteria.list();
}

From source file:au.org.theark.admin.model.dao.AdminDao.java

License:Open Source License

public List<ArkFunction> getArkFunctionListByArkModule(ArkModule arkModule) {
    Criteria criteria = getSession().createCriteria(ArkModuleFunction.class);
    if (arkModule.getId() != null) {
        criteria.add(Restrictions.eq("arkModule", arkModule));
    }//  w w w  . j a  va2 s.com
    criteria.createAlias("arkModule", "module");
    criteria.addOrder(Order.asc("module.name"));
    criteria.addOrder(Order.asc("functionSequence"));

    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.groupProperty("arkFunction"), "arkFunction");
    criteria.setProjection(projectionList);
    return criteria.list();
}

From source file:au.org.theark.admin.model.dao.AdminDao.java

License:Open Source License

public ArkRole getArkRole(Long id) {
    Criteria criteria = getSession().createCriteria(ArkRole.class);
    criteria.add(Restrictions.eq("id", id));
    return (ArkRole) criteria.uniqueResult();
}

From source file:au.org.theark.admin.model.dao.AdminDao.java

License:Open Source License

private Criteria buildArkRoleCriteria(ArkRole arkRoleCriteria) {
    Criteria criteria = getSession().createCriteria(ArkRole.class);

    if (arkRoleCriteria.getId() != null) {
        criteria.add(Restrictions.eq("id", arkRoleCriteria.getId()));
    }/* ww w  . j  av  a  2s . c  o m*/

    if (arkRoleCriteria.getName() != null) {
        criteria.add(Restrictions.eq("name", arkRoleCriteria.getName()));
    }

    if (arkRoleCriteria.getDescription() != null) {
        criteria.add(Restrictions.ilike("description", arkRoleCriteria.getName(), MatchMode.ANYWHERE));
    }

    criteria.addOrder(Order.asc("id"));
    return criteria;
}