asp.net mvc多条件+分页查询解决方案

来源：互联网发布：中世纪2原版优化9下载编辑：程序博客网时间：2024/05/22 06:52

开发环境vs2010

css:bootstrap

js:jquery

bootstrap paginator

原先只是想做个mvc的分页，但是一般的数据展现都需要检索条件，而且是多个条件，所以就变成了MVC多条件+分页查询

因为美工不是很好，所以用的是bootstrap前端框架，自己懒得写前端的分页控件，用的是bootstrap paginator分页控件。

方式：

用Get方式提交检索条件，分页可用2种模式，无刷新或者带刷新的跳转。

Shared\_Layout.cshtml中添加css、js脚本引用：

 1 <!DOCTYPE html> 2 <html> 3 <head> 4     <title>@ViewBag.Title</title> 5     <link href="@Url.Content("~/Content/bootstrap/css/bootstrap.min.css")" rel="stylesheet" media="screen" /> 6     <script type="text/javascript" src="@Url.Content("~/Scripts/jquery-1.7.1.min.js")" type="text/javascript"></script> 7     <script type="text/javascript" src="@Url.Content("~/Scripts/bootstrap.min.js")"></script> 8 </head> 9 10 <body>11 <div class="container">12 @RenderBody()13 </div>14 </body>15 </html>

_Layout.cshtml

查询页面（View）Index.cshtml：
引用分页插件库、生成分页脚本，定义分页跟数据展现的分部视图：

@Url.IncludePagerScript()@Html.Pager("#pager", "#Content", "/Search/?page=", Model)

<div class="container">    <div id="pager"></div>    <div id="Content">    @Html.Partial("IndexTable")    </div></div>

封装了下分页脚本：

@Html.Pager(分页控件, 数据展现, 分页的查询地址, 继承PagerSearchBase的Model,是否刷新默认为刷新的)

若要切换成分页的无刷新模式，只需要写成@Html.Pager("#pager", "#Content", "/Search/?page=", Model, false)

 1 public static MvcHtmlString Pager(this HtmlHelper htmlHelper, string filter, string content, string url, MvcPagerSearch.Models.PagerSearchBase pagerbase, bool refresh = true) 2         { 3             return Pager(htmlHelper, filter, content, url, pagerbase.CurrentPage, pagerbase.PageCount, pagerbase.Condition, refresh); 4         } 5  6         public static MvcHtmlString Pager(this HtmlHelper htmlHelper, string filter, string content, string url, int currentPage, int pageCount, string condition = "", bool refresh = true) 7         { 8             if(pageCount <= 1) return new MvcHtmlString(string.Empty); 9             string requestUrl = string.Empty;10             if(condition == null) condition = string.Empty;11             if(condition.Length > 0 && condition.Substring(0, 1) != "&")12             {13                 condition = "&" + condition;14             }15             requestUrl = "\"" + url + "\" + page + \"" + condition + "&rand=\" + Math.random()";16             return new MvcHtmlString("<script type=\"text/javascript\">$(function () {"17                     + " $(\"" + filter + "\").bootstrapPaginator({ currentPage: " + currentPage + ","18                     + " totalPages: " + pageCount + ","19                     + " numberOfPages: 10,"20                     + " size:\"large\","21                     + " alignment: \"center\","22                     + " useBootstrapTooltip: true,"23                     + " tooltipTitles: function (type, page, current) {"24                     + " switch (type) {"25                     + " case \"first\":"26                     + " return \"首页 <i class='icon-fast-backward icon-white'></i>\";"27                     + " case \"prev\":"28                     + " return \"上一页 <i class='icon-backward icon-white'></i>\";"29                     + " case \"next\":"30                     + " return \"下一页 <i class='icon-forward icon-white'></i>\";"31                     + " case \"last\":"32                     + " return \"最末页 <i class='icon-fast-forward icon-white'></i>\";"33                     + " case \"page\":"34                     + " return \"第 \" + page + \"页 <i class='icon-file icon-white'></i>\";"35                     + " }"36                     + " },"37                     + " onPageClicked: function (event, originalEvent, type, page) {"38                     + (refresh ? " location.href = " + requestUrl + ";" : " $.post(" + requestUrl + ", function (data) { $(\"" + content + "\").html(data); });")39                     + " }"40                     + " });"41                     + " });</script>");42         }

Html.Pager的源代码

定义查询表单：

@using(Html.BeginForm("Index", "Search", FormMethod.Get, new { @class = "form-search form-inline" })){    <div class="input-append">    @Html.TextBoxFor(model => model.UserName, new { @class = "span2 search-query" })    <button type="submit" class="btn">        快速查询</button>    </div>}

整个Index.cshtml与分部视图IndexTable.cshtml的源代码：

 1 @model MvcPagerSearch.Models.SearchModel 2  3 @{ 4     ViewBag.Title = "Index"; 5 } 6 @Url.IncludePagerScript() 7 @Html.Pager("#pager", "#Content", "/Search/?page=", Model) 8  9 <h2>查询</h2>10 @using(Html.BeginForm("Index", "Search", FormMethod.Get, new { @class = "form-search form-inline" }))11 {12     <div class="input-append">13     @Html.TextBoxFor(model => model.UserName, new { @class = "span2 search-query" })14     <button type="submit" class="btn">15         快速查询</button>16     </div>17 }18 19 <div class="container">20     <div id="pager"></div>21     <div id="Content">22     @Html.Partial("IndexTable")23     </div>24 </div>

Index.cshtml

 1 @model MvcPagerSearch.Models.SearchModel 2 <table class="table table-hover"> 3         <thead> 4             <tr> 5                 <th> 6                     昵称 7                 </th> 8                 <th> 9                     性别10                 </th>11                 <th>12                     年龄13                 </th>14             </tr>15         </thead>16         <tbody>17             @foreach(var entity in Model.Members)18             {19                 <tr>20                     <td>21                         @entity.UserName22                     </td>23                     <td>24                         @entity.Sex25                     </td>26                     <td>27                         @entity.Age28                     </td>29                 </tr>30             }31         </tbody>32     </table>

IndexTable.cshtml

控制器(Control)SearchController.cs：

Index：

 1 public ActionResult Index(int page = 1) 2         { 3             SearchModel conditionData = SearchModel.Create(Request, GetMembers()); 4             conditionData.Search(page); 5  6             if(Request.IsAjaxRequest()) return PartialView("IndexTable", conditionData); 7             return View("Index", conditionData); 8         }

取得数据（测试数据）：

 1 // 获取数据 2         private List<Member> GetMembers() 3         { 4             List<Member> result = new List<Member>(); 5             for(int i = 0; i <= 100; i++) 6             { 7                 result.Add(new Member() { UserName = "A" + i, Age = i, Sex = i % 2 == 0 ? "男" : "女" }); 8             } 9             return result;10         }

测试数据

模型(Model)SearchModel.cs、Member.cs：
SearchModel继承自PagerSearchBase

1 public class SearchModel : PagerSearchBase2     {3         public string UserName { get; set; }4 5         public IEnumerable<Member> Members { get; set; }6     }

创建SearchModel对象的方法：

1 public static SearchModel Create(HttpRequestBase request, IEnumerable<Member> members)2         {3             SearchModel result = new SearchModel();4             result.AddFields(request, "UserName");
5             result.Members = members;6             return result;7         }

protected void AddFields(HttpRequestBase request, params string[] fieldNames);

用于添加查询条件的属性名，并为属性设置值，这里的属性只能是string类型的

重载子类的SearchByPage函数

1 protected override void SearchByPage(int page)2         {3             // 过滤4             Members = Members.Where(UserName, entity => entity.UserName.Contains(UserName));5             // 分页6             Members = Pager(Members.OrderBy(entity => entity.UserName));7         }

扩展了下IEnumerable<TSource>的Where函数，若遇到UserName为空，则不进行条件过滤，且能链式调用

 1 public static IEnumerable<TSource> Where<TSource>(this IEnumerable<TSource> data, string condition, Func<TSource, bool> predicate) 2         { 3             if(string.IsNullOrEmpty(condition)) return data; 4             return data.Where(predicate); 5         } 6  7         public static IEnumerable<TSource> Where<TSource>(this IEnumerable<TSource> data, string condition, Func<TSource, int, bool> predicate) 8         { 9             if(string.IsNullOrEmpty(condition)) return data;10             return data.Where(predicate);11         }

扩展Where函数

PagerSearchBase.cs基类

  1 public abstract class PagerSearchBase  2     {  3         /// <summary>  4         /// 每页行数，默认20，子类可调  5         /// </summary>  6         protected int pageSize = 20;  7         private int pageCount = 0;  8         private Hashtable hsCondition = new Hashtable();  9  10         /// <summary> 11         /// 总页数 12         /// </summary> 13         public int PageCount { get { return pageCount; } set { pageCount = value; } } 14  15         /// <summary> 16         /// 当前页 17         /// </summary> 18         public int CurrentPage { get; protected set; } 19  20         /// <summary> 21         /// 条件Url 22         /// </summary> 23         public string Condition { get; protected set; } 24  25         /// <summary> 26         /// 按页查询 27         /// </summary> 28         /// <param name="page"></param> 29         protected abstract void SearchByPage(int page); 30  31         /// <summary> 32         /// 取得条件，可外部调用 33         /// </summary> 34         /// <returns></returns> 35         public string GetCondition() 36         { 37             string result = string.Empty; 38             int i = 0; 39             foreach(object key in hsCondition.Keys) 40             { 41                 if(i++ > 0) 42                     result += "&"; 43                 result += key.ToString() + "=" + HttpUtility.UrlEncode(hsCondition[key].ToString().Trim()); 44             } 45             return result; 46         } 47  48         /// <summary> 49         /// 按页查询，外部调用 50         /// </summary> 51         /// <param name="page"></param> 52         public void Search(int page) 53         { 54             // 设置当前页 55             CurrentPage = page; 56             // 取得反馈的条件Url 57             Condition = GetCondition(); 58             SearchByPage(page); 59         } 60  61         /// <summary> 62         /// 批量添加用于查询条件的属性名，并为属性设置值 63         /// </summary> 64         /// <param name="request"></param> 65         /// <param name="fieldNames"></param> 66         protected void AddFields(HttpRequestBase request, params string[] fieldNames) 67         { 68             for(int i = 0; i <= fieldNames.Length - 1; i++) 69             { 70                 string fieldName = fieldNames[i]; 71                 string value = WebUtil.GetSafeQueryString(request, fieldName).Trim(); 72                 // 设置属性值 73                 this.GetType().GetProperty(fieldName).SetValue(this, value, null); 74                 // 添加反馈的条件Url 75                 AddCondition(fieldName, value); 76             } 77         } 78  79         /// <summary> 80         /// 分页 81         /// </summary> 82         /// <typeparam name="T"></typeparam> 83         /// <param name="searchData"></param> 84         /// <returns></returns> 85         protected IEnumerable<T> Pager<T>(IEnumerable<T> searchData) 86         { 87             return PagerUtil.GetPageData(CurrentPage, pageSize, searchData, out pageCount); 88         } 89  90         /// <summary> 91         /// 添加反馈的条件Url，内部方法 92         /// </summary> 93         /// <param name="name"></param> 94         /// <param name="value"></param> 95         private void AddCondition(string name, string value) 96         { 97             if(!string.IsNullOrEmpty(value)) 98                 hsCondition.Add(name, value); 99         }100     }

PagerSearchBase.cs

Member.cs

1 public class Member2     {3         public string UserName { get; set; }4         public int Age { get; set; }5         public string Sex { get; set; }6     }

这样就完成了多条件查询+分页的页面。

如果要增加条件，就只要修改Model跟View就可以了

如要增加个Age的条件：

修改Model:

增加属性字段：public string Age { get; set; }

原result.AddFields(request, "UserName");改为result.AddFields(request, "UserName", "Age");

SearchByPage中增加过滤条件：

 1 protected override void SearchByPage(int page) 2         { 3             int age = 0; 4             if(!Int32.TryParse(Age, out age)) Age = string.Empty; 5             // 过滤 6             Members = Members.Where(UserName, entity => entity.UserName.Contains(UserName)) 7                 .Where(Age, entity => entity.Age == age); 8             // 分页 9             Members = Pager(Members.OrderBy(entity => entity.UserName));10         }

完整的SearchModel.cs文件：

 1 public class SearchModel : PagerSearchBase 2     { 3         public string UserName { get; set; } 4         public string Age { get; set; } 5  6         public IEnumerable<Member> Members { get; set; } 7  8         public static SearchModel Create(HttpRequestBase request, IEnumerable<Member> members) 9         {10             SearchModel result = new SearchModel();11             result.AddFields(request, "UserName", "Age");12             result.Members = members;13             return result;14         }15 16         protected override void SearchByPage(int page)17         {18             int age = 0;19             if(!Int32.TryParse(Age, out age)) Age = string.Empty;20             // 过滤21             Members = Members.Where(UserName, entity => entity.UserName.Contains(UserName))22                 .Where(Age, entity => entity.Age == age);23             // 分页24             Members = Pager(Members.OrderBy(entity => entity.UserName));25         }26     }

SearchModel.cs

修改View:

在Index.cshtml查询的表单中增加查询条件:

@Html.TextBoxFor(model => model.Age, new { @class = "span2 search-query" })

完整的Index.cshtml文件：

 1 @model MvcPagerSearch.Models.SearchModel 2  3 @{ 4     ViewBag.Title = "Index"; 5 } 6 @Url.IncludePagerScript() 7 @Html.Pager("#pager", "#Content", "/Search/?page=", Model) 8  9 <h2>查询</h2>10 @using(Html.BeginForm("Index", "Search", FormMethod.Get, new { @class = "form-search form-inline" }))11 {12     <div class="input-append">13     @Html.TextBoxFor(model => model.Age, new { @class = "span2 search-query" })14     @Html.TextBoxFor(model => model.UserName, new { @class = "span2 search-query" })15     <button type="submit" class="btn">16         快速查询</button>17     </div>18 }19 20 <div class="container">21     <div id="pager"></div>22     <div id="Content">23     @Html.Partial("IndexTable")24     </div>25 </div>

Index.cshtml

就可以了，应该是挺方便了

完整项目文件下载：

http://files.cnblogs.com/nickppa/MvcPagerSearch.rar