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.Query;
import mx.com.bcm.banamex.ae.persistencia.common.GlobalJpaDaoBean;
import mx.com.bcm.banamex.ae.persistencia.dao.TotalesRecepcionEfectivoDTOBeanLocal;
import mx.com.bcm.banamex.ae.persistencia.dto.TotalesRecepcionEfectivoDTO;
import mx.com.bcm.banamex.ae.persistencia.exception.EfectivoAplicacionDAOException;

@Stateless
public class TotalesRecepcionEfectivoDTODAOImplBeanLocal extends GlobalJpaDaoBean implements TotalesRecepcionEfectivoDTOBeanLocal {
   @PersistenceContext
   private EntityManager em;

   public TotalesRecepcionEfectivoDTO consultaTotales() throws EfectivoAplicacionDAOException {
      TotalesRecepcionEfectivoDTO obj = new TotalesRecepcionEfectivoDTO();
      StringBuilder queryString = new StringBuilder();
      queryString.append(" SELECT COUNT(COMPBTE_ID) FROM COMPROBANTES WHERE ");
      Query query = this.em.createNativeQuery(queryString.toString());
      List listaObject = query.getResultList();
      Object[] current = (Object[])listaObject.get(0);
      queryString.delete(-1, queryString.length());
      obj.setNumerocomprobantes(((Integer)current[0]).intValue());
      return obj;
   }
}
Page generated: Oct 19, 2017 2:35:12 PM