Example usage for org.hibernate Query list

List of usage examples for org.hibernate Query list

Introduction

In this page you can find the example usage for org.hibernate Query list.

Prototype

List<R> list();

Source Link

Document

Return the query results as a List.

Usage

From source file:bo.com.kibo.dal.impl.ReporteHibernateDAO.java

@Override
public List<CensoGeneral> obtenerSaldoCenso() {
    Query query = getSession().createQuery("from CensoGeneral t " + "where t.estado = 0 and t.existe = 0");
    return query.list();
}

From source file:bo.com.kibo.dal.impl.ReporteHibernateDAO.java

@Override
public List<TrozaGeneral> obtenerTalaGeneral() {
    Query query = getSession().createQuery("from TrozaGeneral t " + "where t.fechaTala is not null");
    return query.list();
}

From source file:bo.com.kibo.dal.impl.ReporteHibernateDAO.java

@Override
public List<TrozaGeneral> obtenerTalaSaldo() {
    Query query = getSession().createQuery("from TrozaGeneral t " + "where t.estado = 1 and t.existe = 0");
    return query.list();
}

From source file:bo.com.kibo.dal.impl.ReporteHibernateDAO.java

@Override
public List<TrozaGeneral> obtenerExtraccionGeneral() {
    Query query = getSession().createQuery("from TrozaGeneral t " + "where t.fechaArrastre is not null");
    return query.list();
}

From source file:bo.com.kibo.dal.impl.ReporteHibernateDAO.java

@Override
public List<TrozaGeneral> obtenerExtraccionSaldo() {
    Query query = getSession().createQuery("from TrozaGeneral t " + "where t.estado = 2 and t.existe = 0");
    return query.list();
}

From source file:bo.com.kibo.dal.impl.ReporteHibernateDAO.java

@Override
public List<TrozaGeneral> obtenerDespachoGeneral() {
    Query query = getSession().createQuery("from TrozaGeneral t " + "where t.fechaDespacho is not null");
    return query.list();
}

From source file:bo.com.kibo.dal.impl.RolPermisoHibernateDAO.java

@Override
public List<RolPermiso> getPermisos(int idRol, Integer idPadre) {
    Query query;
    if (idPadre == null) {
        query = getSession().createQuery("from RolPermiso rp where rp.rol.id =  :idRol "
                + "and rp.permiso in (from Permiso p where p.padre is null)");
    } else {//from w  w  w.  j a v a  2  s. c  o m
        query = getSession().createQuery("from RolPermiso rp where rp.rol.id = :idRol and "
                + "rp.permiso in (from Permiso p where p.padre.id = :idPadre)");
        query.setParameter("idPadre", idPadre);
    }
    query.setParameter("idRol", idRol);
    List<RolPermiso> resultado = query.list();
    for (RolPermiso rp : resultado) {
        rp.getPermiso().getDescripcion();
    }
    return resultado;
}

From source file:bo.com.kibo.dal.impl.TrozaHibernateDAO.java

@Override
public List<Troza> getTrozasParaTala(Integer idArea) {
    Query query = getSession()
            .createQuery("from Troza t Where t.area.id = :idArea " + "and t.existe = 0 and t.estado = 0");
    query.setParameter("idArea", idArea);
    return query.list();
}

From source file:bo.com.kibo.dal.impl.TrozaHibernateDAO.java

@Override
public List<Troza> getTrozasParaExtraccion(Integer idArea) {
    Query query = getSession()
            .createQuery("from Troza t Where t.area.id = :idArea " + "and t.existe = 0 and t.estado = 1");
    query.setParameter("idArea", idArea);
    return query.list();
}

From source file:bo.com.kibo.dal.impl.TrozaHibernateDAO.java

@Override
public List<Troza> getTrozasParaMovimiento(Integer idArea) {
    Query query = getSession()
            .createQuery("from Troza t Where t.area.id = :idArea " + "and t.existe = 0 and t.estado = 2");
    query.setParameter("idArea", idArea);
    return query.list();
}