排序一个函数在c# gridview
本文关键字:函数 gridview 一个 排序 | 更新日期: 2023-09-27 18:11:23
我正在构建一个小的web应用程序来跟踪赢/输/平均。数据保存在XML文件中(因为只有几行)。我想尝试并给页面的访问者,按每一列可能排序的能力(玩,赢,平均)。我可以让它对play和Won进行排序,但不能对Average进行排序,因为Average是一个计算值。
我如何得到它排序GetWinAverage函数的结果?
现在的样子:
<asp:GridView ID="Results" runat="server" AutoGenerateColumns="false" AllowSorting="true" OnSorting="gvResults_Sorting" EnableViewState="true">
<Columns>
<asp:TemplateField HeaderText="Played" SortExpression="Played">
<ItemTemplate>
<asp:Label ID="lblPlayed" runat="server" Text='<%# Eval("Played") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<Columns>
<asp:TemplateField HeaderText="Won" SortExpression="Won">
<ItemTemplate>
<asp:Label ID="lblWon" runat="server" Text='<%# Eval("Won") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<Columns>
<asp:TemplateField HeaderText="Average" SortExpression="Average">
<ItemTemplate>
<asp:Label ID="lblAverage" runat="server" Text='<%# GetWinAverage(Eval("Won"), Eval("Played")) %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
gettwinaverage看起来像这样:
public string GetWinAverage(object gamesWon, object gamesPlayed)
{
string strReturn = "";
double iWon = Convert.ToDouble(gamesWon);
double iPlayed = Convert.ToDouble(gamesPlayed);
if (iPlayed < 0)
{
return "0%";
}
else
{
double dReturn = (iWon / iPlayed) * 100;
strReturn = string.Format("{0:N2}%", dReturn);
return strReturn;
}
}
排序是这样的:
private const string ASCENDING = " ASC";
private const string DESCENDING = " DESC";
public SortDirection GridViewSortDirection
{
get
{
if (ViewState["sortDirection"] == null)
ViewState["sortDirection"] = SortDirection.Ascending;
return (SortDirection)ViewState["sortDirection"];
}
set { ViewState["sortDirection"] = value; }
}
protected void gvResults_Sorting(object sender, GridViewSortEventArgs e)
{
string sortExpression = e.SortExpression;
if (GridViewSortDirection == SortDirection.Ascending)
{
GridViewSortDirection = SortDirection.Descending;
SortGridView(sortExpression, DESCENDING);
}
else
{
GridViewSortDirection = SortDirection.Ascending;
SortGridView(sortExpression, ASCENDING);
}
}
private void SortGridView(string sortExpression, string direction)
{
// You can cache the DataTable for improving performance
DataTable dt = dtPlayers;
DataView dv = new DataView(dt);
dv.Sort = sortExpression + direction;
gvResults.DataSource = dv;
gvResults.DataBind();
}
最简单的方法可能是修改DataTable以使用已计算的数据列。
您可以通过添加列"Average"和设置dataccolumn来做到这一点。表达式性质为Won/Played * 100
。然后像绑定其他列一样绑定它