Rev 325 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 325 | Rev 530 | ||
|---|---|---|---|
| Line 9... | Line 9... | ||
| 9 | import br.com.ec.core.util.DataUtils; |
9 | import br.com.ec.core.util.DataUtils; |
| 10 | import br.com.ec.core.util.VerificadorUtil; |
10 | import br.com.ec.core.util.VerificadorUtil; |
| 11 | import br.com.ec.domain.dto.EstampaDTO; |
11 | import br.com.ec.domain.dto.EstampaDTO; |
| 12 | import br.com.ec.domain.dto.TemaEstampaDTO; |
12 | import br.com.ec.domain.dto.TemaEstampaDTO; |
| 13 | import br.com.ec.domain.model.Estampa; |
13 | import br.com.ec.domain.model.Estampa; |
| - | 14 | import br.com.ec.domain.model.TemaEstampa; |
|
| 14 | import br.com.ec.repository.EstampaRepository; |
15 | import br.com.ec.repository.EstampaRepository; |
| 15 | import br.com.ec.repository.SistemaAbstractRepository; |
16 | import br.com.ec.repository.SistemaAbstractRepository; |
| 16 | 17 | ||
| 17 | @Repository |
18 | @Repository |
| 18 | public class EstampaRepositoryJpaImpl extends SistemaAbstractRepository<Estampa> implements EstampaRepository { |
19 | public class EstampaRepositoryJpaImpl extends SistemaAbstractRepository<Estampa> implements EstampaRepository { |
| Line 60... | Line 61... | ||
| 60 | TypedQuery<EstampaDTO> query = getEntityManager().createQuery(jpql.toString(), EstampaDTO.class); |
61 | TypedQuery<EstampaDTO> query = getEntityManager().createQuery(jpql.toString(), EstampaDTO.class); |
| 61 | if (VerificadorUtil.naoEstaNulo(tema)) { |
62 | if (VerificadorUtil.naoEstaNulo(tema)) { |
| 62 | query.setParameter("sequencialTema", tema.getSequencial()); |
63 | query.setParameter("sequencialTema", tema.getSequencial()); |
| 63 | }
|
64 | }
|
| 64 | return query.getResultList(); |
65 | return query.getResultList(); |
| - | 66 | } catch(Exception ex) { |
|
| - | 67 | ex.printStackTrace(); |
|
| - | 68 | return null; |
|
| - | 69 | }
|
|
| - | 70 | }
|
|
| - | 71 | ||
| - | 72 | @Override |
|
| - | 73 | public String consultarUltimoCodigo(TemaEstampa temaEstampa) { |
|
| - | 74 | StringBuilder jpql = new StringBuilder(); |
|
| - | 75 | jpql.append("SELECT MAX(e.codigo) "); |
|
| - | 76 | jpql.append("FROM Estampa e "); |
|
| - | 77 | jpql.append("WHERE e.temaEstampa.sequencial = :sequencialTema "); |
|
| - | 78 | // jpql.append("ORDER BY e.sequencial DESC limit 1 ");
|
|
| - | 79 | try { |
|
| - | 80 | return getEntityManager().createQuery(jpql.toString(), String.class) |
|
| - | 81 | .setParameter("sequencialTema", temaEstampa.getSequencial()).getSingleResult(); |
|
| 65 | } catch(Exception ex) { |
82 | } catch(Exception ex) { |
| 66 | ex.printStackTrace(); |
83 | ex.printStackTrace(); |
| 67 | return null; |
84 | return null; |
| 68 | }
|
85 | }
|
| 69 | }
|
86 | }
|