CalendarAscMiniDao_getCalendarAsc.sql 352 B

12345678910111213
  1. select * from t_bus_calendar tbc WHERE 1=1
  2. <#if (calendarAscDto.year )?? && calendarAscDto.year ?length gt 0>
  3. and tbc.year = :calendarAscDto.year
  4. <#else >
  5. and tbc.year=null
  6. </#if>
  7. <#if (calendarAscDto.month )?? && calendarAscDto.month ?length gt 0>
  8. and tbc.month = :calendarAscDto.month
  9. <#else >
  10. and tbc.month=null
  11. </#if>
  12. ORDER BY day ASC