Information

0
Story Points

Technologies

Decompiled Java File
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();
   }
}
Page generated: Oct 19, 2017 2:34:18 PM