datagrid中巧用loadFilter对数据整形

    最近由于数据格式没有完全弄懂，在使用datagrid加载数据时各种报错真让人抓狂，今天得一高人指点，总算是解决了数据加载问题，略有心得，望与大家分享。

   先是js，这里只需关注loadfilter里的内容。loadfilter介绍：返回过滤数据显示。该函数带一个参数'data'用来指向源数据（即：获取的数据源，比如Json对象）。您可以改变源数据的标准数据格式。这个函数必须返回包含'total'和'rows'属性的标准数据对象。返回的数据格式必须为{todal:int 行数 ,rows:数据}。

function GetUserList(Sqlwhere) {
    $("#userlist").datagrid({
        width: 400,
        url: "../ajax/UserMAjax.ashx",
        method: 'post',
        queryParams: {
            cmd: "list",
            strSqlWhere: Sqlwhere,
        },
        loadFilter:function(data){
            return {total:data.data.length,rows:data.data};
        },
        columns: [[
            { field: "UserId", title: "userid" },
            { field: "UserName", title: "username" },
              { field: "Pwd", title: "password" },
        { field: "RegReason", title: "regreason" },
{ field: "QQ", title: "QQ" },
  { field: "HeadPic", title: "headpic" }
        ]],
             });

采用mvc3搭建的后台，由于主要测试datagrid数据加载，查询语句做了简化"select * from userinfo",查询出的内容为userinfo表中的所有内容，返回数据内容如下：{"data":[{"UserId":21,"UserName":"fffffff33dddds","Pwd":"ffff","RegReason":"fff","QQ":"33333","HeadPic":null,"RegDate":"\/Date(1435595121443)\/","PrimaryKey":"UserId","IsAutoID":true,"DataBaseName":1,"IsExternalConn":false,"connName":"","HasIdentityPK":true},{"UserId":20,"UserName":"fffffff33dddd","Pwd":"ffff","RegReason":"fff","QQ":"33333","HeadPic":null,"RegDate":"\/Date(1435595018103)\/","PrimaryKey":"UserId","IsAutoID":true,"DataBaseName":1,"IsExternalConn":false,"connName":"","HasIdentityPK":true}]}

为便于显示只取两条数据，经过loadfilter后，数据变为

{todal：2，rows：[{"UserId":21,"UserName":"fffffff33dddds","Pwd":"ffff","RegReason":"fff","QQ":"33333","HeadPic":null,"RegDate":"\/Date(1435595121443)\/","PrimaryKey":"UserId","IsAutoID":true,"DataBaseName":1,"IsExternalConn":false,"connName":"","HasIdentityPK":true},{"UserId":20,"UserName":"fffffff33dddd","Pwd":"ffff","RegReason":"fff","QQ":"33333","HeadPic":null,"RegDate":"\/Date(1435595018103)\/","PrimaryKey":"UserId","IsAutoID":true,"DataBaseName":1,"IsExternalConn":false,"connName":"","HasIdentityPK":true}]}，之后就可以使用columns随意显示数据啦！

    public class UserMAjax : IHttpHandler
    {
        HttpContext context;
        JavaScriptSerializer jss = new JavaScriptSerializer();
        string json = "";
        public void ProcessRequest(HttpContext context)
        {
            this.context = context;
            context.Request.ContentEncoding = Encoding.GetEncoding("utf-8");
            string cmd = context.Request["cmd"].ToString();
            string strSqlwhere = context.Request["strSqlWhere"].ToString();
            List<UserInfo> UserList = UserInfoDal.C_UserInfo.GetList(strSqlwhere);
            Dictionary<string, List<UserInfo>> db = new Dictionary<string, List<UserInfo>>();
            db.Add("data", UserList);
            json = jss.Serialize(db);
           context.Response.Write(json);