public AcDomesticCandidateRouteTmp read(JwSqlResultSet rs) {
   AcDomesticCandidateRouteTmp e;
   e = getAccess().newDomesticCandidateRouteTmp();
   e.setLogin(rs.getString());
   e.setCreatedUtcTs(rs.getTimestamp());
   e.setBlockBeginUtcDt(rs.getDate());
   e.setBlockEndUtcDt(rs.getDate());
   e.setRouteBeginUtcDt(rs.getDate());
   e.setRouteEndUtcDt(rs.getDate());
   e.setError(AcDomesticCandidateRouteErrorEnum.getFromCode(rs.getInteger()));
   return e;
 }
  public static AcDomesticNominatedRouteSummaryVo readNominatedRouteSummaryVo(JwSqlResultSet rs) {
    JwDate blockBeginUtcDt = rs.getDate();
    JwDate blockEndUtcDt = rs.getDate();
    JwTimestamp minCreatedUtcTs = rs.getTimestamp();
    Integer countNew = rs.getInteger();

    AcDomesticNominatedRouteSummaryVo vo = new AcDomesticNominatedRouteSummaryVo();
    vo.setBlockBeginUtcDt(blockBeginUtcDt);
    vo.setBlockEndUtcDt(blockEndUtcDt);
    vo.setMinimumCreatedUtcTs(minCreatedUtcTs);
    vo.setUnhandledRoutesCount(countNew);
    return vo;
  }
  public static AcDomesticCandidateRouteSummaryVo readSummaryVo(JwSqlResultSet rs) {
    JwDate blockBeginUtcDt = rs.getDate();
    JwDate blockEndUtcDt = rs.getDate();
    Integer count = rs.getInteger();
    String statuses = rs.getString();

    AcDomesticCandidateRouteSummaryVo vo = new AcDomesticCandidateRouteSummaryVo();
    vo.setBlockBeginUtcDt(blockBeginUtcDt);
    vo.setBlockEndUtcDt(blockEndUtcDt);
    vo.setCandidateRoutesCount(0);
    vo.setNominatedRoutesCount(count);
    vo.setNominatedRouteStatusDisplayLabelFromDelimitedString(statuses);
    vo.setRequestedRoutesCount(0);
    return vo;
  }
 public AcScheduledFlightUpload read(JwSqlResultSet rs) {
   AcScheduledFlightUpload e;
   e = getAccess().newScheduledFlightUpload();
   e.setId(rs.getInteger());
   e.setOperatorCarrierCode(rs.getString());
   e.setOperatorNumber(rs.getString());
   e.setRelationship(AcFlightRelationshipEnum.getFromCode(rs.getString()));
   e.setOriginAirportCode(rs.getString());
   e.setDestinationAirportCode(rs.getString());
   e.setDepartureLocalTm(rs.getTime());
   e.setArrivalLocalTm(rs.getTime());
   e.setDayOffset(rs.getInteger());
   e.setBoundingStartLocalDt(rs.getDate());
   e.setBoundingEndLocalDt(rs.getDate());
   e.setFrequency(rs.getDayFrequency());
   e.setEquipmentCode(rs.getString());
   e.setSource(AcScheduledFlightCalendarSourceEnum.getFromCode(rs.getString()));
   e.setAbsoluteSource(AcScheduledFlightCalendarAbsoluteSourceEnum.getFromCode(rs.getString()));
   e.setCancel(rs.getBoolean());
   e.setCreatedUtcTs(rs.getTimestamp());
   e.setSequence(rs.getInteger());
   return e;
 }