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.dao.CatalogoAtmDAOBeanLocal;
import mx.com.bcm.banamex.ae.persistencia.modelo.Atm;
import mx.com.bcm.banamex.ae.persistencia.vo.CriterioAtmVO;

@Stateless
public class CatalogoAtmDAOImplBeanLocal extends GlobalJpaDaoBean implements CatalogoAtmDAOBeanLocal {
   @PersistenceContext
   private EntityManager em;

   public List findByIdnAtm(CriterioAtmVO criterioAtmVO) {
      StringBuilder query = new StringBuilder();
      query.append("SELECT a FROM Atm a WHERE a.atmPK.atmIdn = :atmIdn AND  a.atmBajaLogica = :atmBajaLogica");
      TypedQuery criteria = this.em.createQuery(query.toString(), Atm.class);
      criteria.setParameter("atmIdn", criterioAtmVO.getAtmIdn());
      criteria.setParameter("atmBajaLogica", criterioAtmVO.getBajaLogica());
      List listaAtms = criteria.getResultList();
      return listaAtms;
   }

   public List findByAllAtm() {
      StringBuilder query = new StringBuilder();
      query.append("SELECT a FROM Atm a  WHERE a.atmBajaLogica = :atmBajaLogica");
      TypedQuery criteria = this.em.createQuery(query.toString(), Atm.class);
      criteria.setParameter("atmBajaLogica", "01");
      List listaAtms = criteria.getResultList();
      return listaAtms;
   }
}
Page generated: Oct 19, 2017 2:34:38 PM