Asp.Net MVC 分页、检索、排序整体实现

namespace Protal.Model.Abstract
{
    /// 

    /// 分页处理
    /// 
   public interface IPager
    {
        /// 

        /// 每页项目数
        /// 
        /// The page item count.
      int  PageItemCount { get; set; }
      /// 

      /// 总页数
      /// 
      /// The totoal page.
       int TotoalPage { get; }
       /// 

       /// 显示的页数
       /// 
       /// The display page.
       int DisplayPage { get; set; }
       /// 

       /// 满足条件的总数目
       /// 
        int TotalItem { get; set; }
    }
}

 public interface IUsersRepository : IPager
    {
        /// 

        /// Post list
        /// 
        /// Order expression
        /// Filter expression
        /// Records to skip
        /// Records to take
        /// List of users
        IEnumerable Find(int order=0,string filter="", int skip = 0, int take = 10);
        /// 

        /// Get single post
        /// 
        /// User id
        /// User object
        User FindByName(string name);
        /// 

        /// Add new user
        /// 
        /// Blog user
        /// Saved user
        User Add(User user);
        /// 

        /// Update user
        /// 
        /// User to update
        /// True on success
        bool Update(User user);
        /// 

        /// Save user profile
        /// 
        /// Blog user
        /// True on success
        bool SaveProfile(User user);
        /// 

        /// Delete user
        /// 
        /// User ID
        /// True on success
        bool Remove(string userName);
    }

 public class UsersRepository : IUsersRepository
   {
       /// 

       /// The _user list
       /// 
        private List _userList = new List();
       /// 

       /// The _page item count
       /// 
        private int _pageItemCount;
        /// 

        /// The _display page
        /// 
        private int _displayPage;
        /// 

        /// The _usercount
        /// 
        private int _usercount;
        /// 

        /// The _total item
        /// 
        private int _totalItem;
        /// 

        /// 标记是否有查询条件 没有的话则返回全部数目
        /// 
        private Funcbool> _func;

        /// 

        /// Gets or sets the users.
        /// 
        /// The users.
        public List Users
       {
           get
           {
               int count;
               var usercollection = Membership.GetAllUsers(0, 999, out count);
               if (count == _usercount) return _userList;
               _usercount = count;
               var members = usercollection.Cast().ToList();
               foreach (var membershipUser in members)//这里存在一个转换
               {
                   _userList.Add(new User
                   {
                       Email = membershipUser.Email,
                       UserName = membershipUser.UserName,
                       //roles password
                   });
               }
               return _userList;
           }
           set { _userList = value; }
       }

     
//查询
public IEnumerable Find(int order = 0, string filter = "", int skip = 0, int take = 10)
       {
           if (take == 0) take = Users.Count;
           //过滤
            _func = string.IsNullOrEmpty(filter) ? (Funcbool>) (n => n.UserName != "") : (n => n.UserName.Contains(filter));
            var users = Users.Where(_func).ToList();
            //更新总数目
           _totalItem = users.Count;
           users = order == 0 ? users.OrderBy(n => n.UserName).ToList() : users.OrderByDescending(n => n.UserName).ToList();
            return users.Skip(skip).Take(take);
       }
  /// 

       /// 每页项目数
       /// 
       /// The page item count.
        public int PageItemCount
        {
            get
            {
                if (_pageItemCount == 0)
                {
                    _pageItemCount = ProtalConfig.UserPageItemCount;
                }
                return _pageItemCount;
            }
            set { _pageItemCount = value; }
        }

        /// 

        /// 总页数
        /// 
        /// The totoal page.
        public int TotoalPage
        {
            get
            {
                var page = (int) Math.Ceiling((double) TotalItem/PageItemCount);
                return page==0?1:page; 
            }
        }
        /// 

        /// 显示的页数
        /// 
        /// The display page.
        public int DisplayPage
        {
            get
            {
                if (_displayPage == 0)
                {
                    _displayPage = ProtalConfig.UserDisplayPage;
                }
                return _displayPage;
            }
            set { _displayPage = value; }
        }


        /// 

        /// 满足条件的总数目 保持更新
        /// 
        /// The total item.
        public int TotalItem
        {
            get
            {
                if (_func == null)
                    _totalItem = Users.Count;
                return _totalItem;
            }
            set { _totalItem = value; }
        }
}

    _kernel.Bind().To();

   [Authorize]
    public class UserManagerController : Controller
    {
        /// 

        /// The _repository
        /// 
        private readonly IUsersRepository _repository;

        /// 

        /// Initializes a new instance of the  class.
        /// 
        /// The i repository.
        public UserManagerController(IUsersRepository iRepository)
        {
            _repository = iRepository; 
        }

        /// 

        /// Indexes the specified page index.
        /// 
        /// Index of the page.
        /// ActionResult.
        public ActionResult Index(int pageIndex=1)
        {
            ViewBag.DisplayPage = _repository.DisplayPage;
            pageIndex = HandlePageindex(pageIndex);
         
            //支持地址栏直接分页
            ViewBag.CurrentPage = pageIndex;
            return View();
        }


        /// 

        /// Users table. 分页模块
        /// 
        /// Index of the page.
        /// The order.
        /// The filter str.
        /// ActionResult.
        public ActionResult UserTable(int pageIndex = 1, int order = 0, string filter = "")
        {
            pageIndex = HandlePageindex(pageIndex);
            var skip = (pageIndex - 1) * _repository.PageItemCount;
            var users = _repository.Find(order,filter, skip, _repository.PageItemCount);
            
            //总用户数
            ViewBag.TotalUser = _repository.TotalItem;
            //总页数
            ViewBag.TotalPageCount = _repository.TotoalPage; ;

            return PartialView(users);
        }

        /// 

        /// 处理页数 防止过大或过小
        /// 
        /// 
        /// 
        private int HandlePageindex(int index)
        {
            var totoalpage = _repository.TotoalPage;
            if (index == 0) return 1;
            return index > totoalpage ? totoalpage : index;
        }
}

script src="~/Scripts/form.js">script>
div class="container">
    h4 class="bottomline">管理用户h4>
    p>
        button data-target="#adduser" id="adduserbt" data-toggle="modal" class="btn btn-info btn-hover">新增用户button>
        button class="btn btn-danger" id="deluser">删除button>
        span class="errorinfo">span>
        input type="search" class="pull-right" id="usersearch" placeholder="搜索"/>
    p>
    div id="userpart">
          @Html.Action("UserTable",new{pageIndex=ViewBag.CurrentPage})
    div>
    div  id="userpager">div>
    input type="hidden" id="dispalypage" value="@ViewBag.DisplayPage"/>
    input type="hidden" id="page" value="@ViewBag.CurrentPage"/>
    input type="hidden" id="currentpage" value="@ViewBag.CurrentPage"/>

div>
div class="modal fade adduserbox"id="adduser" tabindex="1" role="dialog" aria-hidden="true">
    div class="modal-content">
        div class="modal-header">
             button type="button" class="close" data-dismiss="modal" aria-hidden="true" >×button>
             h4 class="modal-title">Add new Userh4>
        div>
        div class="modal-body">
           @{
               Html.RenderAction("Create","UserManager");
            }
        div>
    div>
div>

@section Scripts {
    @Scripts.Render("~/bundles/jqueryval")
}

@model IEnumerableProtal.Model.Data.User.User>
 table id="usertable" class="table table-striped table-condensed table-hover table-bordered">
        tr>
            th>input type="checkbox" id="allcheck" />label for="allcheck">全选label>th>
            th>a href="#" id="usersort" data-order="0" class="glyphicon-sort">名称a>th>
            th>角色th>
            th>E-mailth>
        tr>
        tbody>
            @foreach (var item in Model) {
                tr>
                    td> input type="checkbox" data-id="@item.UserName" />td>
                    td> a>@item.UserNamea> td>
                    td> @Html.Raw(item.Role) td>
                    td> @item.Emailtd>
                tr>
            }tbody>
     tfoot>
         tr>
             td colspan="4">
                  span>@Html.Raw("共"+ViewBag.TotalUser+"人")span> @*span>@ViewBag.TotalPageCountspan>*@
             td>
         tr>
     tfoot>
    table>
  input type="hidden" id="totoalpage" value="@ViewBag.TotalPageCount"/>