TONIYH 2020-02-20
网上关于webpager的介绍很多,对着做着做着,就发现有问题了,有的说要引用 x.pagelist.mvc或 pagelist.mvc或mvcpager,但最后发现之后部分功能被实现了,要不就是分页可以了,带参数的查询参数不能传到后台。经过自己的一番摸索终于搞定了,记录一下。希望后面的朋友看到可以少走弯路。如有不足之处可以指出共同探讨。
首先要nuget引用 WebPager.MvcPageer

js 引用 jquery.unobtrusive-ajax.min.js

1、Controller 内容
public class HomeController : Controller
{
public ActionResult Index(string title, int id = 1)
{
return AjaxSearchGet(title, id);
}
public ActionResult AjaxSearchGet(string title, int id = 1)
{
SQLDBContext db = new SQLDBContext();
PagedList<Pic_Image> model = db.Pic_Images.AsQueryable().OrderByDescending(x => x.CreateDate).ToPagedList(id, 20);
return View(model);
}
}2、Model 内容
public class Pic_Image
{
public string ID { get; set; }
public string Pic_MenuId { get; set; }
public string Title { get; set; }
public string KeyWork { get; set; }
public string Description { get; set; }
public string ImageName { get; set; }
public string ImageName_New { get; set; }
public string Extend { get; set; }public int IsDel { get; set; }
}3、视图 (视图直接抄官网demo可以直接使用)
@using Webdiyer.WebControls.Mvc;
@model PagedList<MvcPagerTest.Models.Pic_Image>
<div class="row">
<fieldset>
<legend>查询</legend>
@using (Ajax.BeginForm("AjaxSearchGet", new RouteValueDictionary { { "id", "" } }, new AjaxOptions { UpdateTargetId = "articles", HttpMethod = "Get", InsertionMode = InsertionMode.Replace }, new RouteValueDictionary { { "id", "searchForm" } }))
{
<span>标题:</span><input type="text" name="title" id="title" style="width:120px" />
<span>作者:</span><input type="text" name="author" id="author" style="width:120px" /><span>(如:Webdiyer)</span>
<span>来源:</span><input type="text" name="source" id="source" style="width:120px" /><span>(如:吴起热线)</span>
<input type="submit" value="搜索(S)" accesskey="S" />
}
</fieldset>
<div id="articles111">
@*@Html.Partial("_AjaxSearchGet", Model)*@ 官方的例子
<div class="well well-sm">当前查询条件:标题:<span class="emph"></span> 作者:<span class="emph">222</span> 来源:<span class="emph">111</span></div>
@*@Html.Partial("_ArticleTable", Model)*@ 官方的例子
<table>
@{ int i = 0;}
@foreach (var item in Model)
{
<tr>
<td>@(Model.StartItemIndex + i++)</td>
<td>
@Html.DisplayFor(modelItem => item.Title)
</td>
<td>
@Html.DisplayFor(modelItem => item.BiaoQian)
</td>
<td>
@Html.DisplayFor(modelItem => item.Description)
</td>
<td>
@Html.DisplayFor(modelItem => item.ImageName)
</td>
</tr>
}
</table>
<div>
<div style="float:left;width:50%">共 @Model.TotalPageCount 页 @Model.TotalItemCount 条记录,当前为第 @Model.CurrentPageIndex 页</div>
@Ajax.Pager(Model).Options(o => o.SetPageIndexParameterName("id").AddHtmlAttribute("style", "float:right").SetPagerItemTemplate(" {0}")).AjaxOptions(a => a.SetUpdateTargetId("articles").SetDataFormId("searchForm"))
</div>
</div>
@section Scripts
{ @{Html.RegisterMvcPagerScriptResource();}
<script type="text/javascript" src="/Scripts/jquery.unobtrusive-ajax.min.js"></script>
}
</div>注意点在分布视图中要添加引用命名空间
_AjaxSearchGet.cshtml (分布视图)
@using Webdiyer.WebControls.Mvc;
@model PagedList<MvcPagerTest.Models.Pic_Image>
<table>
@{ int i = 0;}
@foreach (var item in Model)
{
<tr>
<td>@(Model.StartItemIndex + i++)</td>
<td>
@Html.DisplayFor(modelItem => item.Title)
</td>
<td>
@Html.DisplayFor(modelItem => item.BiaoQian)
</td>
<td>
@Html.DisplayFor(modelItem => item.Description)
</td>
<td>
@Html.DisplayFor(modelItem => item.ImageName)
</td>
</tr>
}
</table>上面第3点的例子 ,是把分布视图合并了,没有使用分布视图。官方例子
