Easyui Click the DataGrid column header to sort

There are two types of clicks on the DataGrid in Easyui, one local and one server. Local can only sort the current page, and the server can sort all the pages. Here the main is to share the next server sort.

1. Add property remotesort:true for DataGrid to sort by server request

2. Add an attribute to the column in the DataGrid that you want to sort sortable:true indicates that the column allows sorting

3. Clicking on a column header will automatically send a request with sort and order two parameters to the server, where the request calls the query method for dynamically binding the DataGrid

Sort indicates a sorted field name

Order represents the collation, which is ASC and DESC two kinds

4, from the background to receive the two parameters splicing query SQL can be

Easyui Click the DataGrid column header to sort