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 Func _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) ? (Func) (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; } } } 

 public static int UserPageItemCount { get { if (_userPageItemCount == 0) { _userPageItemCount = WebConfigurationManager.AppSettings["UserPageItemCount"] != null ? Convert.ToInt16(WebConfigurationManager.AppSettings["UserPageItemCount"]) : 5; } return _userPageItemCount; } set { _userPageItemCount = 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; } } 

管理用户
新增用户删除
 @Html.Action("UserTable",new{pageIndex=ViewBag.CurrentPage}) 
×
Add new User
 @{ Html.RenderAction("Create","UserManager"); } 
 @section Scripts { @Scripts.Render("~/bundles/jqueryval") }

 @model IEnumerable @foreach (var item in Model) {  }
全选
名称
角色
E-mail
@item.UserName
 @Html.Raw(item.Role) 
 @item.Email
@Html.Raw("共"+ViewBag.TotalUser+"人") @*@ViewBag.TotalPageCount*@ 

 $(function () { var options = { dataType: 'json', success: processJson }; pageagin($("#totoalpage").val()); //分页 function pageagin(totalcount) { $("#userpager").paginate({ count: totalcount, start: $("#page").val(), dispaly: $("#dispalypage").val(), boder: false, border_color: '#fff',//自己调整样式。 text_color: 'black', background_color: 'none', border_
                
提示：
                    本文由神整理自网络，如有侵权请联系本站删除！
                    

                    本站声明： 

                    1、本站所有资源均来源于互联网，不保证100%完整、不提供任何技术支持； 

                    2、本站所发布的文章以及附件仅限用于学习和研究目的;不得将用于商业或者非法用途；否则由此产生的法律后果，本站概不负责！
                
                

                

                                            
上一篇：ASP.NET MVC下基于异常处理的完整解决方案总结_实用技巧_
                                                                
下一篇：asp.net Mvc4 使用ajax结合分页插件实现无刷新分页_实用技巧_