Red Hat Application Migration Toolkit
package mx.com.bcm.banamex.ae.persistencia.dao.impl; import java.util.List; import javax.ejb.Stateless; import javax.persistence.EntityManager; import javax.persistence.PersistenceContext; import javax.persistence.TypedQuery; import mx.com.bcm.banamex.ae.persistencia.common.GlobalJpaDaoBean; import mx.com.bcm.banamex.ae.persistencia.constantes.OperadorLogicoType; import mx.com.bcm.banamex.ae.persistencia.dao.CatalogoDivisaDAOBeanLocal; import mx.com.bcm.banamex.ae.persistencia.exception.EfectivoAplicacionDAOException; import mx.com.bcm.banamex.ae.persistencia.helper.UtileriaHelper; import mx.com.bcm.banamex.ae.persistencia.modelo.Divisa; import mx.com.bcm.banamex.ae.persistencia.vo.DivisaVO; @Stateless public class CatalogoDivisaDAOImplBeanLocal extends GlobalJpaDaoBean implements CatalogoDivisaDAOBeanLocal { @PersistenceContext private EntityManager em; public List consultaDivisaPorNum(DivisaVO divisaVO) throws EfectivoAplicacionDAOException { StringBuilder queryBuilder = new StringBuilder(); String queryFormateado = UtileriaHelper.getFiltroDeAtributos(divisaVO.toString(), OperadorLogicoType.AND, 'd'); if(queryFormateado.equals("")) { new StringBuilder(); new String(); return this.findAll(); } else { queryBuilder.append(" SELECT d FROM Divisa d "); queryBuilder.append(" WHERE " + queryFormateado); TypedQuery criteria = this.em.createQuery(queryBuilder.toString(), Divisa.class); new StringBuilder(); return criteria.getResultList(); } } public List consultaDivisaPorParametros(DivisaVO divisaVO) throws EfectivoAplicacionDAOException { StringBuilder query = new StringBuilder(); String queryFormateado = UtileriaHelper.getFiltroDeAtributos(divisaVO.toString(), OperadorLogicoType.AND, 'd'); if(queryFormateado.equals("")) { new StringBuilder(); new String(); return this.findAll(); } else { query.append(" SELECT d FROM Divisa d "); query.append(" WHERE " + queryFormateado); query.append("ORDER BY d.divisaId ASC, d.divisaNomLargo ASC"); TypedQuery criteria = this.em.createQuery(query.toString(), Divisa.class); new StringBuilder(); return criteria.getResultList(); } } public Divisa consultaDivisa(Integer idDivisa) throws EfectivoAplicacionDAOException { StringBuilder query = new StringBuilder(); query.append(" SELECT d FROM Divisa d "); query.append(" JOIN FETCH d.denominacionDeDivisaList "); query.append(" WHERE d.divisaId=:idDivisa"); TypedQuery typeQuery = this.em.createQuery(query.toString(), Divisa.class); typeQuery.setParameter("idDivisa", idDivisa); return (Divisa)typeQuery.getSingleResult(); } public Divisa consultaDivisa(Short idDivisa) { StringBuilder query = new StringBuilder(); query.append(" SELECT d FROM Divisa d "); query.append(" JOIN FETCH d.denominacionDeDivisaList "); query.append(" WHERE d.divisaId=:idDivisa"); TypedQuery typeQuery = this.em.createQuery(query.toString(), Divisa.class); typeQuery.setParameter("idDivisa", idDivisa); return (Divisa)typeQuery.getSingleResult(); } }