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

系统管理员 2021-11-22 08:12 383阅读 0赞

开发环境vs2010

css:bootstrap

js:jquery

bootstrap paginator

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

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

方式：

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

--------------------

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

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

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)

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

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的源代码：

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

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

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

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.UserName
    22                     </td>
    23                     <td>
    24                         @entity.Sex
    25                     </td>
    26                     <td>
    27                         @entity.Age
    28                     </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         }

取得数据（测试数据）：

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

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 : PagerSearchBase
    2     {
    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为空，则不进行条件过滤，且能链式调用

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

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基类

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

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 Member
    2     {
    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文件：

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

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文件：

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

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][http_files.cnblogs.com_nickppa_MvcPagerSearch.rar]

[ContractedBlock.gif]: http://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: /images/20211122/6a4b8449e1a64ca183291200636d5937.png
[http_files.cnblogs.com_nickppa_MvcPagerSearch.rar]: http://files.cnblogs.com/nickppa/MvcPagerSearch.rar