MVC简捷调用EasyUI的datagrid

        /// 

        /// 用户列表Json
        /// 
        /// 
        public ActionResult GetUserList()
        {
            int currentPageIndex = RequestExtension.GetQueryStringint>("page", 0);
            int pagesize = RequestExtension.GetQueryStringint>("rows", 0);
            String sort = RequestExtension.GetQueryString("sort", "");
            String order = RequestExtension.GetQueryString("order", "");

            String name = RequestExtension.GetQueryString("name", "");

            Pagination pagin = new Pagination
            {
                CurrentPageIndex = currentPageIndex,
                PageSize = pagesize,
                OrderBy = String.IsNullOrEmpty(sort) ? "" : String.Concat(sort + " " + order)
            };

            UsersModel condition = new UsersModel();

            KeyValuePair> list = usersRepository.UsersPagination(pagin, condition);

            return JsonExtension.JsonPagination(list.Value, pagin.CurrentPageIndex, pagin.PageSize, list.Key.TotalItemCount);
        }

        /// 

        /// 分页处理
        /// 
        /// 
        /// 
        /// 
        /// 
        public static JsonResult JsonPagination(IEnumerable dataList, int page, int rows, int dataListAuctalCount = -1)
        {
            var result = dataList;
            Dictionarystring, object> json = new Dictionarystring, object>();
            int total = dataListAuctalCount;
            if (total == -1 && dataList != null)
            {
                //自动分页
                total = dataList.Count();
                result = dataList.Skip((page - 1) * rows).Take(rows).ToList();
            }
            json.Add("total", total);
            json.Add("rows", result);
            return new JsonResult() { Data = json, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
        }

        public KeyValuePair> UsersPagination(Pagination pagin, UsersModel condition)
        {
            using (SqlConnection conn = DapperFactory.CrateOpenConnection())
            {
                String condtionStr = "";
                String orderBy = "CreateTime DESC";
                if (!String.IsNullOrEmpty(pagin.OrderBy))
                {
                    orderBy = pagin.OrderBy;
                }

                String executeQuery = String.Format(@"WITH pagintable AS(
                                        SELECT ROW_NUMBER() OVER(ORDER BY {1} )AS RowID, ID, DomainName, EnName, PassWord, CnName, Email, DeptID, RoleId, CreateMan, CreateTime, EditMan, EditTime, IsValid FROM Users
                                        WHERE 1= 1 {0} ) 
                                        SELECT * FROM pagintable where RowID between ((@CurrentPageIndex - 1)  * @PageSize) + 1  and (@CurrentPageIndex  * @PageSize)", condtionStr, orderBy);
                String executeCount = String.Format("SELECT COUNT(*) AS CountNum FROM Users WHERE 1= 1 {0} ", condtionStr);
                var mixCondition = new
                {
                    CurrentPageIndex = pagin.CurrentPageIndex,
                    PageSize = pagin.PageSize
                };
                List listScore = conn.Query(executeQuery, mixCondition).ToList();
                pagin.TotalItemCount = conn.Query(executeCount, mixCondition).SingleOrDefault();
                KeyValuePair> result =
                    new KeyValuePair>(pagin, listScore);
                return result;
            }
        }