分页

//前台分页

@{
ViewBag.Title = “Index”;
}
@using WebApplication1.Models

新增 删除

名称

</div>

    </tr>
</thead>
<tbody>
    @foreach (var item in Model)
    {
        <tr>
            <td>@item.ID</td>
            <td>@item.Name</td>
            <td>@item.Remark</td>

        </tr>
    }
</tbody>

编号	姓名	备注

•     <li><a >
  共10页，第
  <input type="text" value=" 1" id="pageIndex" />页，每页显示
      <select id="pageSize" onchange="page(1)">
      @{
          var pageIndexs = new List<int> { 5, 10, 20, 50, 100 };
  
      }
      @foreach (var item in pageIndexs)
      {
          if (@ViewBag.pageSize == @item)
          {
              <option value="@item" selected="selected">@item</option>
          }
          else
          {
              <option value="@item" >@item</option>
          }
  
      }
     </select>
      条
  

</ul>
<ul class="pagination">

    <li><a href="javascript:page(1);">首页</a></li>
    <li><a href="javascript:page(@ViewBag.pageIndex-1)">上页</a></li>
    <li><a href="javascript:page(@ViewBag.pageIndex+1)">下页</a></li>
    <li><a href="javascript:page(@ViewBag.totalPage)">末页</a></li>
    <li><input type="button" value="go" onclick="go(); " /></li>

</ul>

@section Scripts{

<script>
    function page(pageindex) {
        var pageSize = $("#pageSize").val();
        var name= $("#txtCondName").val();
        window.location.href = "/role/index?pageindex="
            + pageindex + "&pageSize="+ pageSize + "&name="+ name 

    }

    function go() {
        var pageindex = $("#pageIndex").val();
        page(pageindex);
    }
</script>

}

//控制器

```csharp
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using WebApplication1.Models;

namespace WebApplication1.Controllers
{
    public class RoleController : Controller
    {
        // GET: Role
        RbacDBEntities db = new RbacDBEntities();
        public ActionResult Index(int pageIndex=1,int pageSize=10,string Name="")
        {
            //总记录数满足条件
            var counts = db.Roles.Where(p => p.Name.Contains(Name)).Count();
            var totalPage = Math.Ceiling(counts*1.00/pageSize );

            //根据页面的条数名称查询
            var rows = db.Roles.Where(p => p.Name.Contains(Name))
                .OrderBy(p => p.ID)//排序
                .Skip(pageSize * (pageIndex - 1))//跳过
                .Take(pageSize)//取
                .ToList();//转化为集合
            ViewBag.pageIndex = pageIndex;
            ViewBag.totalPage = totalPage;
            ViewBag.Name = Name ;
            ViewBag.pageSize = pageSize;
            return View(rows);

        }
    }
}