目前项目需要点击datagrid的某列后台自动按此列的升降规则排序返回分页的结果集,目前用的是ORM的映射Select不是拼装的SQL语句,于是查了下资料
发觉用如下SQL代码实现自定义排序规则:
declare @sort nvarchar(60) declare @ order nvarchar(50) set @sort= 'Buyer' set @ order = 'desc' if @ order = 'desc' begin select buyer from View_StockInto order by case @sort when 'Buyer' then Buyer end desc end else begin select buyer from View_StockInto order by case @sort when 'Buyer' then Buyer end end |