博客

EasyUI实现Datagrid排序

需求分析与实现

航次费用处理–查看费用明细加一个按托单号排序的功能

{field: 'trade_code', title: '托单编号', halign: "center", width: 180,sortable: true},
url: '/fee/feeManagement/getboxFeeIncomeHc.do',

sortable:true增加排序功能

url为前端发送请求地址

前端页面点击托单编号按钮

发送请求 传递sort和order参数

String sort = CommonUtil.getParam(request,"sort");
String order = CommonUtil.getParam(request,"order");

服务器端获取到sort和order的值

+ " from t_box_income_rate tb where 1=1  " + consql + permissionSql +" ORDER BY "+sort+" "+order  ;

在sql语句末尾加上排序语句order by…

优化

增加判空处理

String orderBySql="";
if(Helper.isNotEmpty(sort) && Helper.isNotEmpty(order)){
   orderBySql+="order by " +sort +" "+order;
}
list = feeImportService.nativeQueryForMap(sql+orderBySql, paramList);

注意”order by “中by后需要加空格不然orderBySql的值会变为order bysort order导致排序失败