关于EF框架实现分页功能的笔记

效果界面

控制器代码

public ActionResult Index(int roleID=0,string name="",int pageIndex=1,int pageSize=5)
{

        var roles = db.Roles.ToList();
        ViewBag.roles = roles;
        //总记录数
        var pageCounts = db.UserInfos.Count();
        var rowCounts = Math.Ceiling(1.00*pageCounts/pageSize);
        //根据页码每页的条数名称查询
        var userInfos = db.UserInfos.Where(p=>p.Name==""||(p.Name.Contains(name)))
            .OrderBy(p=>p.ID) //排序
            .Skip((pageIndex - 1) * pageSize)   //跳过
            .Take(pageSize)     //取
            .ToList();  //转化集合

        ViewBag.pageIndex = pageIndex;
        ViewBag.pageSize = pageSize;
        ViewBag.Name = name;
        ViewBag.pageCounts = pageCounts;
        ViewBag.rowCounts = rowCounts;


        return View(userInfos);
    }

界面代码

• 共 @ViewBag.rowCounts 页，第 页，每页显示 @{ var pageIndexs = new List { 5, 10, 20, 50 }; } @foreach (var item in pageIndexs) { if (@ViewBag.pageSize == item) { @item } else { @item

                  }
              }
  
          </select>条
      </li>
  </ul>
  <ul class="pagination">
      <li><a href="javascript:page(1)">首页</a></li>
      @if (@ViewBag.pageIndex > 1)
      {
          <li><a href="javascript:page(@ViewBag.pageIndex-1)">上页</a></li>
      }
      else
      {
          <li class="disabled"><a href="javascript:page(@ViewBag.pageIndex-1)">上页</a></li>
      }
      @if (@ViewBag.pageIndex < ViewBag.rowCounts)
      {
          <li><a href="javascript:page(@ViewBag.pageIndex+1)">下页</a></li>
      }
      else
      {
          <li class="disabled"><a href="javascript:page(@ViewBag.pageIndex+1)">下页</a></li>
      }
      <li><a href="javascript:page(@ViewBag.rowCounts)">末页</a></li>
      <li><input type="button" class="btn btn-danger" value="GO" onclick="go();" /></li>
  </ul>
  

js代码