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.HistTurnoEnOperacionDAOBeanLocal;
import mx.com.bcm.banamex.ae.persistencia.exception.EfectivoAplicacionDAOException;
import mx.com.bcm.banamex.ae.persistencia.modelo.HistTurnoEnOperacion;

@Stateless
public class HistTurnoEnOperacionDAOImplBeanLocal extends GlobalJpaDaoBean implements HistTurnoEnOperacionDAOBeanLocal {
   @PersistenceContext
   private EntityManager em;

   public List consultarHistTurnoEnOperacion(String turnoId) {
      StringBuilder query = new StringBuilder();
      query.append("SELECT h FROM HistTurnoEnOperacion h WHERE h.histTurnoEnOperacionPK.turnoId = :turnoId AND h.histStatus = :histStatus");
      TypedQuery criteria = this.em.createQuery(query.toString(), HistTurnoEnOperacion.class);
      criteria.setParameter("turnoId", turnoId);
      criteria.setParameter("histStatus", "01");
      return criteria.getResultList();
   }

   public List obtenerHist(int turnoIdn) throws EfectivoAplicacionDAOException {
      TypedQuery query = this.em.createNamedQuery("HistTurnoEnOperacion.findByTurnoId", HistTurnoEnOperacion.class);
      query.setParameter("turnoId", String.valueOf(turnoIdn));
      return query.getResultList();
   }

   public HistTurnoEnOperacion obtenerhora() throws EfectivoAplicacionDAOException {
      new HistTurnoEnOperacion();
      StringBuilder query = new StringBuilder();
      query.append("SELECT h FROM HistTurnoEnOperacion h order by h.histTurnoEnOperacionPK.histFecHorIni desc");
      TypedQuery criteria = this.em.createQuery(query.toString(), HistTurnoEnOperacion.class);
      HistTurnoEnOperacion hora = (HistTurnoEnOperacion)criteria.getResultList().get(0);
      return hora;
   }
}
Page generated: Oct 19, 2017 2:34:38 PM