控制器代码
RbacDBEntities db = new RbacDBEntities ( ) ;
public ActionResult Index ( int pageIndex = 1 , int pageSize = 2 , string name = "" )
{
var fy = db. UserInfos. Where ( p = > p. Name. Contains ( name) )
. OrderBy ( p = > p. ID)
. Skip ( pageSize * ( pageIndex - 1 ) )
. Take ( pageSize) . ToList ( ) ;
int pageCount = db. UserInfos. Count ( ) ;
var rows = Math. Ceiling ( ( pageCount* 1.0 / pageSize) ) ;
ViewBag. pageIndex = pageIndex;
ViewBag. pageSize = pageSize;
ViewBag. count = rows;
ViewBag. name = name;
return View ( fy) ;
}
页面代码
< div style= "display:flex;justify-content:space-between" >
< div class = "btn-group" >
< button type= "button" class = "btn btn-default" > 新增< / button>
< button type= "button" class = "btn btn-default" > 删除< / button>
< / div>
< div class = "input-group" >
< label> 名称< / label>
< input type= "text" value = "@ViewBag.name" id= "txtCondName" / >
< input type= "button" value = "搜索" id= "btnSearch" onclick= "searchu();" / >
< / div>
< / div>
< table class = "table table-bordered" >
< thead>
< tr>
< td> ID< / td>
< td> 名字< / td>
< td> 账号< / td>
< / tr>
< / thead>
< tbody>
@foreach ( var item in Model) {
< tr>
< td> @item. ID< / td>
< td> @item. Name< / td>
< td> @item. Account< / td>
< / tr>
}
< / tbody>
< / table>
< nav aria- label= "Page navigation" style= "display:flex;justify-content:space-between" >
< ul class = "pagination" >
@{ var pagesize = new List < int > { 2 , 5 , 10 } ; }
< li>
共 @ViewBag. Count 页,第< input type= "text" id= "pageIndex" value = "@ViewBag.pageIndex" / > 页,每夜显示
< select id= "slt" >
@foreach ( var item in pagesize)
{
if ( item == ViewBag. pageSize)
{
< option selected= "selected" value = "@item" > @item< / option>
}
else
{
< option value = "@item" > @item< / option>
}
}
< / select > 条
< / li>
< / ul>
< ul class = "pagination" >
< li> < a href= "/userInfo/index?pageIndex=1" > 首页< / a> < / li>
< li> < a href= "/userInfo/index?pageIndex=@(ViewBag.pageIndex-1)&pageSize=@ViewBag.pageSize&name=@ViewBag.name" > 上页< / a> < / li>
< li> < a href= "/userInfo/index?pageIndex=@(ViewBag.pageIndex+1)&pageSize=@ViewBag.pageSize&name=@ViewBag.name" > 下页< / a> < / li>
< li> < a href= "/userInfo/index?pageIndex=@ViewBag.count&pageSize=@ViewBag.pageSize&name=@ViewBag.name" > 末页< / a> < / li>
< li> < input type= "button" class = "btn btn-danger" value = "GO" onclick= "searchu();" / > < / li>
< / ul>
< / nav>
@section scripts{
< script type= "text/javascript" >
function searchu ( ) {
var pageIdex = $( "#pageIndex" ) . val ( ) ;
var pageSize = $( "#slt" ) . val ( ) ;
var name = $( "#txtCondName" ) . val ( ) ;
window. location. href = "/userInfo/index?pageIndex=" + pageIdex + "&pageSize=" + pageSize + "&name=" + name
}
< / script>
}