Information

0
Story Points

Technologies

Decompiled Java File
package mx.com.bcm.banamex.ae.persistencia.dao.impl;

import java.util.ArrayList;
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.OperacionProcesadoraDTODAOBeanLocal;
import mx.com.bcm.banamex.ae.persistencia.dto.OperacionProcesadoraDTO;
import mx.com.bcm.banamex.ae.persistencia.exception.EfectivoAplicacionDAOException;

@Stateless
public class OperacionProcesadoraDTODAOImplBeanLocal extends GlobalJpaDaoBean implements OperacionProcesadoraDTODAOBeanLocal {
   @PersistenceContext
   private EntityManager em;

   public List consultaReporProcesadoraEtvSirh() throws EfectivoAplicacionDAOException {
      StringBuilder queryString = new StringBuilder();
      queryString.append(" SELECT DISTINCT  d.ESTRUCTRA_SIRH AS ESTRUCTRA_SIRH ,c.SIRH_NOMBRE AS SIRH_NOMBRE,  d.ETV_IDN AS ETV_IDN,e.ETV_NOMBRE_LARGO AS ETV_NOMBRE_LARGO FROM DETALLE_INTERFACE_PROCESADORAS d  JOIN  ETVS e ON  d.ETV_IDN=e.ETV_IDN  JOIN CPAES c ON d.ESTRUCTRA_SIRH=c.CPAES_ESTRUCTURA_SIRH_IDN  ");
      Query query = this.em.createNativeQuery(queryString.toString());
      ArrayList listOperProcDTO = new ArrayList();
      List listaObject = query.getResultList();

      for(int index = 0; index < listaObject.size(); ++index) {
         Object[] current = (Object[])listaObject.get(index);
         OperacionProcesadoraDTO obj = new OperacionProcesadoraDTO();
         obj.setEstructraSirh(Integer.parseInt(current[0].toString()));
         System.out.println(obj.getEstructraSirh());
         obj.setSirhNombre(current[1].toString());
         System.out.println(obj.getSirhNombre());
         obj.setEtvIdn(Short.valueOf(Short.parseShort(current[2].toString())));
         System.out.println(obj.getEtvIdn());
         obj.setEtvNombreLargo(current[3].toString());
         System.out.println(obj.getEtvNombreLargo());
         listOperProcDTO.add(obj);
      }

      return listOperProcDTO;
   }

   public List consultaReportes() throws EfectivoAplicacionDAOException {
      return null;
   }
}
Page generated: Oct 19, 2017 2:34:38 PM