[转载]在ASP.NET MVC中绑定数据（包括分页和排序） - 三思而后行 - 博客园

namespace System.Web.Mvc.Html
{
public static class DataGridHelper
{
public static string DataGrid<T>(this HtmlHelper helper)
{
return DataGrid<T>(helper, null, null);
}

public static string DataGrid<T>(this HtmlHelper helper, object data)
{
return DataGrid<T>(helper, data, null);
}

public static string DataGrid<T>(this HtmlHelper helper, object data, string[] columns)
{
//Get items
var items = (IEnumerable<T>)data;
if (items == null)
items = (IEnumerable<T>)helper.ViewData.Model;

//Get column names
if (columns == null)
columns = typeof(T).GetProperties().Select(p => p.Name).ToArray();

//Create HtmlTextWriter
var writer = new HtmlTextWriter(new StringWriter());

//Open table tag
writer.RenderBeginTag(HtmlTextWriterTag.Table);

//Render Table Header
writer.RenderBeginTag(HtmlTextWriterTag.Thead);
RenderHeader(helper, writer, columns);
writer.RenderEndTag();

// Render table body
writer.RenderBeginTag(HtmlTextWriterTag.Tbody);
foreach (var item in items)
RenderRow<T>(helper, writer, columns, item);
writer.RenderEndTag();

//Close  table tag
writer.RenderEndTag();

//return the string
return writer.InnerWriter.ToString();
}

private static void RenderHeader(HtmlHelper helper, HtmlTextWriter writer, string[] columns)
{
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
foreach (var columnName in columns)
{
writer.RenderBeginTag(HtmlTextWriterTag.Th);
var currentAction = (string)helper.ViewContext.RouteData.Values[“action“];
var link = helper.ActionLink(columnName, currentAction, new { sort = columnName });
writer.Write(link);
writer.RenderEndTag();
}
writer.RenderEndTag();
}

public static void RenderRow<T>(HtmlHelper helper, HtmlTextWriter write, string[] columns, T item)
{
write.RenderBeginTag(HtmlTextWriterTag.Tr);
foreach (var columnName in columns)
{
write.RenderBeginTag(HtmlTextWriterTag.Td);
var value = typeof(T).GetProperty(columnName).GetValue(item, null) ?? String.Empty;
write.Write(helper.Encode(value.ToString()));
write.RenderEndTag();
}
write.RenderEndTag();
}

}
}

var diff = 1;
StringBuilder result = new StringBuilder();
var TotalPages = totalPages;

if (currentPage < 1)
currentPage = 1;

if ((currentPage + diff) < totalPages)
totalPages = currentPage + diff;
var startPage = 1;
if ((currentPage – diff) > startPage)
startPage = currentPage – diff;

if ((currentPage – diff) > 1)
{
TagBuilder tag3 = new TagBuilder(“a“);
tag3.Attributes.Add(“href“, pageUrl(1));
tag3.InnerHtml = “1“;
result.AppendLine(tag3.ToString());
}

if ((currentPage – (diff + 1)) > 1)
{
TagBuilder tag2 = new TagBuilder(“a“);
tag2.Attributes.Add(“href“, pageUrl(currentPage – (diff + 1)));
tag2.InnerHtml = “…“;
result.AppendLine(tag2.ToString());
}

for (int i = startPage; i <= totalPages; i++)
{
TagBuilder tag = new TagBuilder(“a“);
tag.Attributes.Add(“href“, pageUrl(i));
tag.InnerHtml = i.ToString();
if (i == currentPage)
tag.AddCssClass(“pageSelected“);
result.AppendLine(tag.ToString());
}

if ((currentPage + (diff + 1)) < TotalPages)
{
TagBuilder tag2 = new TagBuilder(“a“);
tag2.Attributes.Add(“href“, pageUrl(currentPage + (diff + 1)));
tag2.InnerHtml = “…“;
result.AppendLine(tag2.ToString());
}

if ((currentPage + diff) < TotalPages)
{
TagBuilder tag3 = new TagBuilder(“a“);
tag3.Attributes.Add(“href“, pageUrl(TotalPages));
tag3.InnerHtml = TotalPages.ToString();
result.AppendLine(tag3.ToString());
}
return result.ToString();
}
}
}

}

public ProductController(IProductsRepository repository)
{
_repository = repository;
_pageSize = 10;
}

public ActionResult List(string sort, int? page)
{
var currentPage = page ?? 1;
ViewData[“SortItem“] = sort;
sort = sort ?? “Name“;
ViewData[“CurrentPage“] = currentPage;
ViewData[“TotalPages“] = (int)Math.Ceiling((float)_repository.Products.Count() / _pageSize);

var products = from p in _repository.Products
select new ProductViewModel()
{
Name = p.ProductName,
Price = p.UnitPrice ?? 0,
Category = p.Category.CategoryName
};
var sortedProducts = products
.OrderBy(sort)
.Skip((currentPage – 1) * _pageSize)
.Take(_pageSize);
return View(sortedProducts);
}
}
}

<asp:Content ID=”Content2″ ContentPlaceHolderID=”MainContent” runat=”server”>

<h2>List of Product</h2>
<%=Html.DataGrid<ProductViewModel>() %>
<div>
<%=Html.PageLink((int)ViewData[“CurrentPage“],
(int)ViewData[“TotalPages“],
p => Url.Action(“List“,
new { page = p,
sort = (string)ViewData[“SortItem“] }))%>
</div>
</asp:Content>