[17:56] donato.tortelli (Guest)


    public List<ReportCompletoDTO> getListAttTraValidate() throws ValidazioneExitException {
        String sql = getQueryFromIstruzione(Costanti.COD_IST_901, PRG_IST);
        try {
            List<ReportCompletoDTO> list = namedParameterJdbcTemplate.query(sql,
                    new RowMapper<ReportCompletoDTO>() {
                @Override
                   public ReportCompletoDTO mapRow(ResultSet rs, int rowNum) throws SQLException {
                    ReportCompletoDTO dto = new ReportCompletoDTO();
                    dto.setTipo(rs.getString("TIPO"));
                    dto.setCodice(rs.getString("CODICE"));
                    dto.setDesUff1Att(rs.getString("DES_UFF_1_ATT"));
                    dto.setDesUff2Att(rs.getString("DES_UFF_2_ATT"));
                    dto.setDesUffProAtt(rs.getString("DES_UFF_PRO_ATT"));
                    dto.setCodAttTra(rs.getString("COD_ATT_TRA"));
                    dto.setCodVerAttTra(rs.getString("COD_VER_ATT_TRA"));
                    dto.setDesSinAttTra(rs.getString("DES_SIN_ATT_TRA"));
                    dto.setDesAttTra(rs.getString("DES_ATT_TRA"));
                    dto.setModTra(rs.getString("MOD_TRA"));
                    dto.setDesFin(rs.getString("DES_FIN"));
                    dto.setTipTra(rs.getString("TIP_TRA"));
                    dto.setBasGiu(rs.getString("BAS_GIU"));
                    dto.setDesBasGiu(rs.getString("DES_BAS_GIU"));
                    dto.setInformativa(rs.getString("INFORMATIVA"));
                    dto.setCatInt(rs.getString("CAT_INT"));
                    dto.setDatCom(rs.getString("DAT_COM"));
                    dto.setCatPart(rs.getString("CAT_PART"));
                    dto.setDatPerConPen(rs.getString("DAT_PER_CON_PEN"));
                    dto.setDesFonOriDpe(rs.getString("DES_FON_ORI_DPE"));
                    dto.setDesTerCan(rs.getString("DES_TER_CAN"));
                    dto.setDestDati(rs.getString("DEST_DATI"));
                    dto.setTrsEst(rs.getString("TRS_EST"));
                    dto.setDesPaeEueOgi(rs.getString("DES_PAE_EUE_OGI"));
                    dto.setCodPrcDecAut(rs.getString("COD_PRC_DEC_AUT"));
                    dto.setDesNotAggPrcDec(rs.getString("DES_NOT_AGG_PRC_DEC"));
                    dto.setMisSic(rs.getString("MIS_SIC"));
                    dto.setContitolari(rs.getString("CONTITOLARI"));
                    dto.setResponsabiliEsterni(rs.getString("RESPONSABILIESTERNI"));
                    dto.setCodValIpt(rs.getString("COD_VAL_IPT"));



                    return dto;
                }
            }
                    );
            return list;
        }


        catch (EmptyResultDataAccessException empyEx){
            return null;
        } catch (Exception e) {
            log.error("Errore getValoriSelPerMisSic() - " + e.getMessage());
            throw new ValidazioneExitException(Costanti.ERR_GS0901);
        }
    }