rose框架中
排序如果这样写
" ORDER BY :model.sortName :model.sortOrder"
发现并没有进行排序,日志中发现是因为 排序的desc 或者是asc 变成了带引号的'desc' 或者 'asc'
解决方案
+ " #if(:model.sortName == 'sampleDate') { order by s.sample_date #if(:model.sortOrder == 'asc'){ asc }#else{ desc } }"
+ " #if(:model.sortName == 'foodCategoryName') { order by s.food_category #if(:model.sortOrder == 'asc'){ asc }#else{ desc } }"
+ " #if(:model.sortName == 'addressTypeName') { order by s.address_type #if(:model.sortOrder == 'asc'){ asc }#else{ desc } }"
+ " #if(:model.sortName == 'labNo') { order by s.lab_no #if(:model.sortOrder == 'asc'){ asc }#else{ desc } }"
+ " #if(:model.sortName == 'sampleName') { order by s.sample_name #if(:model.sortOrder == 'asc'){ asc }#else{ desc } }"
+ " #if(:model.sortName == 'sampleStatusName') { order by s.sample_status #if(:model.sortOrder == 'asc'){ asc }#else{ desc } }"