- select * from t_bus_calendar tbc WHERE 1=1
- <#if (calendarAscDto.year )?? && calendarAscDto.year ?length gt 0>
- and tbc.year = :calendarAscDto.year
- <#else >
- and tbc.year=null
- </#if>
- <#if (calendarAscDto.month )?? && calendarAscDto.month ?length gt 0>
- and tbc.month = :calendarAscDto.month
- <#else >
- and tbc.month=null
- </#if>
- ORDER BY day ASC
|