JdGrid排序问题

JdGrid排序问题

js代码

function gridList() {
        var $gridList = $("#gridList");
        $gridList.dataGrid({
            url: "/SystemManage/User/GetGridJson",
            height: $(window).height() - 128,
            colModel: [
                { label: '主键', name: 'F_Id', hidden: true },
                { label: '账户', name: 'F_Account', width: 100, align: 'left' },
                { label: '姓名', name: 'F_RealName', width: 80, align: 'left' },
                ……
            ],
            pager: "#gridPager",
            sortname: 'CreatorTime desc',
            viewrecords: true
        });
    
    }

后端使用linq查询无错

public List<UserEntity> GetList(Pagination pagination, string keyword)
        {
            var expression = ExtLinq.True<UserEntity>();
            if (!string.IsNullOrEmpty(keyword))
            {
                expression = expression.And(t => t.F_Account.Contains(keyword));
                expression = expression.Or(t => t.F_RealName.Contains(keyword));
                expression = expression.Or(t => t.F_MobilePhone.Contains(keyword));
            }
            //expression = expression.And(t => t.F_Account != "admin");
            return service.FindList(expression, pagination);
        }

如修改为sql即

public List<UserEntity> GetList(Pagination pagination)
        {
             string sql = string.Format(@"select T.* from User ");
            return service.SqlQueryList<UserEntity>(sql,pagination);
        }

排序失效，

 

在此在前端修改 sortname: 'CreatorTime',

增加排序条件 sortorder: 'desc',

后台增加条件，此处pagination.sidx存储点击列头id；

pagination.sord 为desc与asc

public List<UserEntity> GetList(Pagination pagination)
        {
             string sql = string.Format(@"select T.* from User ");
                if (!string.IsNullOrEmpty(pagination.sidx))
                    {
                       sql += "  order by " + pagination.sidx + " " + pagination.sord;
                    }
            return service.SqlQueryList<UserEntity>(sql,pagination);
        }