开发环境vs2010
css:bootstrap
js:jquery
bootstrap paginator
原先只是想做个mvc的分页，但是一般的数据展现都需要检索条件，而且是多个条件，所以就变成了MVC多条件+分页查询
因为美工不是很好，所以用的是bootstrap前端框架，自己懒得写前端的分页控件，用的是bootstrap paginator分页控件。
方式：
用Get方式提交检索条件，分页可用2种模式，无刷新或者带刷新的跳转。
Shared\_Layout.cshtml中添加css、js脚本引用：
<!DOCTYPE html>
<html>
<head>
<title>@ViewBag.Title</title>
<link href="@Url.Content("~/Content/bootstrap/css/bootstrap.min.css")" rel="stylesheet" media="screen" />
<script type="text/javascript" src="@Url.Content("~/Scripts/jquery-1.7.1.min.js")" type="text/javascript"></script>
<script type="text/javascript" src="@Url.Content("~/Scripts/bootstrap.min.js")"></script>
</head> <body>
<div class="container">
@RenderBody()
</div>
</body>
</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)
public static MvcHtmlString Pager(this HtmlHelper htmlHelper, string filter, string content, string url, MvcPagerSearch.Models.PagerSearchBase pagerbase, bool refresh = true)
{
return Pager(htmlHelper, filter, content, url, pagerbase.CurrentPage, pagerbase.PageCount, pagerbase.Condition, refresh);
} public static MvcHtmlString Pager(this HtmlHelper htmlHelper, string filter, string content, string url, int currentPage, int pageCount, string condition = "", bool refresh = true)
{
if(pageCount <= ) return new MvcHtmlString(string.Empty);
string requestUrl = string.Empty;
if(condition == null) condition = string.Empty;
if(condition.Length > && condition.Substring(, ) != "&")
{
condition = "&" + condition;
}
requestUrl = "\"" + url + "\" + page + \"" + condition + "&rand=\" + Math.random()";
return new MvcHtmlString("<script type=\"text/javascript\">$(function () {"
+ " $(\"" + filter + "\").bootstrapPaginator({ currentPage: " + currentPage + ","
+ " totalPages: " + pageCount + ","
+ " numberOfPages: 10,"
+ " size:\"large\","
+ " alignment: \"center\","
+ " useBootstrapTooltip: true,"
+ " tooltipTitles: function (type, page, current) {"
+ " switch (type) {"
+ " case \"first\":"
+ " return \"首页 <i class='icon-fast-backward icon-white'></i>\";"
+ " case \"prev\":"
+ " return \"上一页 <i class='icon-backward icon-white'></i>\";"
+ " case \"next\":"
+ " return \"下一页 <i class='icon-forward icon-white'></i>\";"
+ " case \"last\":"
+ " return \"最末页 <i class='icon-fast-forward icon-white'></i>\";"
+ " case \"page\":"
+ " return \"第 \" + page + \"页 <i class='icon-file icon-white'></i>\";"
+ " }"
+ " },"
+ " onPageClicked: function (event, originalEvent, type, page) {"
+ (refresh ? " location.href = " + requestUrl + ";" : " $.post(" + requestUrl + ", function (data) { $(\"" + content + "\").html(data); });")
+ " }"
+ " });"
+ " });</script>");
}
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的源代码：
@model MvcPagerSearch.Models.SearchModel
@{
ViewBag.Title = "Index";
}
@Url.IncludePagerScript()
@Html.Pager("#pager", "#Content", "/Search/?page=", Model)
<h2>查询</h2>
@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>
}
<div class="container">
<div id="pager"></div>
<div id="Content">
@Html.Partial("IndexTable")
</div>
</div>
Index.cshtml
@model MvcPagerSearch.Models.SearchModel
<table class="table table-hover">
<thead>
<tr>
<th>
昵称
</th>
<th>
性别
</th>
<th>
年龄
</th>
</tr>
</thead>
<tbody>
@foreach(var entity in Model.Members)
{
<tr>
<td>
@entity.UserName
</td>
<td>
@entity.Sex
</td>
<td>
@entity.Age
</td>
</tr>
}
</tbody>
</table>
IndexTable.cshtml
控制器(Control)SearchController.cs：
Index：
public ActionResult Index(int page = )
{
SearchModel conditionData = SearchModel.Create(Request, GetMembers());
conditionData.Search(page); if(Request.IsAjaxRequest()) return PartialView("IndexTable", conditionData);
return View("Index", conditionData);
}
取得数据（测试数据）：
// 获取数据
private List<Member> GetMembers()
{
List<Member> result = new List<Member>();
for(int i = ; i <= ; i++)
{
result.Add(new Member() { UserName = "A" + i, Age = i, Sex = i % == ? "男" : "女" });
}
return result;
}
测试数据
模型(Model)SearchModel.cs、Member.cs：
SearchModel继承自PagerSearchBase
public class SearchModel : PagerSearchBase
{
public string UserName { get; set; } public IEnumerable<Member> Members { get; set; }
}
创建SearchModel对象的方法：
public static SearchModel Create(HttpRequestBase request, IEnumerable<Member> members)
{
SearchModel result = new SearchModel();
result.AddFields(request, "UserName");
result.Members = members;
return result;
}
protected void AddFields(HttpRequestBase request, params string[] fieldNames);
用于添加查询条件的属性名，并为属性设置值，这里的属性只能是string类型的
重载子类的SearchByPage函数
protected override void SearchByPage(int page)
{
// 过滤
Members = Members.Where(UserName, entity => entity.UserName.Contains(UserName));
// 分页
Members = Pager(Members.OrderBy(entity => entity.UserName));
}
扩展了下IEnumerable<TSource>的Where函数，若遇到UserName为空，则不进行条件过滤，且能链式调用
public static IEnumerable<TSource> Where<TSource>(this IEnumerable<TSource> data, string condition, Func<TSource, bool> predicate)
{
if(string.IsNullOrEmpty(condition)) return data;
return data.Where(predicate);
} public static IEnumerable<TSource> Where<TSource>(this IEnumerable<TSource> data, string condition, Func<TSource, int, bool> predicate)
{
if(string.IsNullOrEmpty(condition)) return data;
return data.Where(predicate);
}
扩展Where函数
PagerSearchBase.cs基类
public abstract class PagerSearchBase
{
/// <summary>
/// 每页行数，默认20，子类可调
/// </summary>
protected int pageSize = ;
private int pageCount = ;
private Hashtable hsCondition = new Hashtable(); /// <summary>
/// 总页数
/// </summary>
public int PageCount { get { return pageCount; } set { pageCount = value; } } /// <summary>
/// 当前页
/// </summary>
public int CurrentPage { get; protected set; } /// <summary>
/// 条件Url
/// </summary>
public string Condition { get; protected set; } /// <summary>
/// 按页查询
/// </summary>
/// <param name="page"></param>
protected abstract void SearchByPage(int page); /// <summary>
/// 取得条件，可外部调用
/// </summary>
/// <returns></returns>
public string GetCondition()
{
string result = string.Empty;
int i = ;
foreach(object key in hsCondition.Keys)
{
if(i++ > )
result += "&";
result += key.ToString() + "=" + HttpUtility.UrlEncode(hsCondition[key].ToString().Trim());
}
return result;
} /// <summary>
/// 按页查询，外部调用
/// </summary>
/// <param name="page"></param>
public void Search(int page)
{
// 设置当前页
CurrentPage = page;
// 取得反馈的条件Url
Condition = GetCondition();
SearchByPage(page);
} /// <summary>
/// 批量添加用于查询条件的属性名，并为属性设置值
/// </summary>
/// <param name="request"></param>
/// <param name="fieldNames"></param>
protected void AddFields(HttpRequestBase request, params string[] fieldNames)
{
for(int i = ; i <= fieldNames.Length - ; i++)
{
string fieldName = fieldNames[i];
string value = WebUtil.GetSafeQueryString(request, fieldName).Trim();
// 设置属性值
this.GetType().GetProperty(fieldName).SetValue(this, value, null);
// 添加反馈的条件Url
AddCondition(fieldName, value);
}
} /// <summary>
/// 分页
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="searchData"></param>
/// <returns></returns>
protected IEnumerable<T> Pager<T>(IEnumerable<T> searchData)
{
return PagerUtil.GetPageData(CurrentPage, pageSize, searchData, out pageCount);
} /// <summary>
/// 添加反馈的条件Url，内部方法
/// </summary>
/// <param name="name"></param>
/// <param name="value"></param>
private void AddCondition(string name, string value)
{
if(!string.IsNullOrEmpty(value))
hsCondition.Add(name, value);
}
}
PagerSearchBase.cs
Member.cs
public class Member
{
public string UserName { get; set; }
public int Age { get; set; }
public string Sex { get; set; }
}
这样就完成了多条件查询+分页的页面。
如果要增加条件，就只要修改Model跟View就可以了
如要增加个Age的条件：
修改Model:
增加属性字段：public string Age { get; set; }
原result.AddFields(request, "UserName");改为result.AddFields(request, "UserName", "Age");
SearchByPage中增加过滤条件：
protected override void SearchByPage(int page)
{
int age = ;
if(!Int32.TryParse(Age, out age)) Age = string.Empty;
// 过滤
Members = Members.Where(UserName, entity => entity.UserName.Contains(UserName))
.Where(Age, entity => entity.Age == age);
// 分页
Members = Pager(Members.OrderBy(entity => entity.UserName));
}
完整的SearchModel.cs文件：
public class SearchModel : PagerSearchBase
{
public string UserName { get; set; }
public string Age { get; set; } public IEnumerable<Member> Members { get; set; } public static SearchModel Create(HttpRequestBase request, IEnumerable<Member> members)
{
SearchModel result = new SearchModel();
result.AddFields(request, "UserName", "Age");
result.Members = members;
return result;
} protected override void SearchByPage(int page)
{
int age = ;
if(!Int32.TryParse(Age, out age)) Age = string.Empty;
// 过滤
Members = Members.Where(UserName, entity => entity.UserName.Contains(UserName))
.Where(Age, entity => entity.Age == age);
// 分页
Members = Pager(Members.OrderBy(entity => entity.UserName));
}
}
SearchModel.cs
修改View:
在Index.cshtml查询的表单中增加查询条件:
@Html.TextBoxFor(model => model.Age, new { @class = "span2 search-query" })
完整的Index.cshtml文件：
@model MvcPagerSearch.Models.SearchModel
@{
ViewBag.Title = "Index";
}
@Url.IncludePagerScript()
@Html.Pager("#pager", "#Content", "/Search/?page=", Model)
<h2>查询</h2>
@using(Html.BeginForm("Index", "Search", FormMethod.Get, new { @class = "form-search form-inline" }))
{
<div class="input-append">
@Html.TextBoxFor(model => model.Age, new { @class = "span2 search-query" })
@Html.TextBoxFor(model => model.UserName, new { @class = "span2 search-query" })
<button type="submit" class="btn">
快速查询</button>
</div>
}
<div class="container">
<div id="pager"></div>
<div id="Content">
@Html.Partial("IndexTable")
</div>
</div>
Index.cshtml
就可以了，应该是挺方便了
完整项目文件下载：