62,041
社区成员
发帖
与我相关
我的任务
分享
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="True" DataKeyNames="Id" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" Width="100%" CellPadding="4" ForeColor="#333333" GridLines="Horizontal" CssClass="myGrid" AllowSorting="true" OnSorting="GridView1_Sorting">
<Columns>
<asp:CommandField ShowSelectButton="True" ShowCancelButton="True" />
<asp:TemplateField HeaderText="部门">
<%-- <EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" Width="154px">
<asp:ListItem Value="营销部">营销部</asp:ListItem>
<asp:ListItem Value="研发部">研发部</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>--%>
<ItemTemplate>
<asp:Label ID="lblDpt" runat="server" Text='<%# Bind("d_Name") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField HeaderText="姓名" DataField="s_Name" />
<asp:BoundField DataField="RecDate" SortExpression="RecDate" HeaderText="日期" />
<asp:BoundField DataField="Income" SortExpression="Income" HeaderText="金额" />
<%--<asp:TemplateField ShowHeader="False">
<EditItemTemplate>
<asp:LinkButton ID="btnUpdate" runat="server" CausesValidation="True" CommandName="Update" Text="更新" CommandArgument='<%#Eval("Id")%>'></asp:LinkButton>
<asp:LinkButton ID="btnCancel" runat="server" CausesValidation="False" CommandName="Cancel" Text="取消" CommandArgument='<%#Eval("Id")%>'></asp:LinkButton>
</EditItemTemplate>
<ItemTemplate>
<asp:LinkButton ID="btnEdit" runat="server" CausesValidation="False" CommandName="Edit" Text="编辑" CommandArgument='<%#Eval("Id")%>'></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>--%>
</Columns>
<SelectedRowStyle Font-Bold="True" />
</asp:GridView>
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
string SortExpression = e.SortExpression.ToString();
string SortDirection = "ASC";
if (SortExpression == GridView1.Attributes["SortExpression"])
{
SortDirection = (GridView1.Attributes["SortDirection"].ToString() == SortDirection ? "DESC" : "ASC");
}
GridView1.Attributes["SortExpression"] = SortExpression;
GridView1.Attributes["SortDirection"] = SortDirection;
GridViewDataBind(txtDate.Text);
}
<asp:GridView ID="GridView1" runat="server" AllowSorting="true" OnSorting="GridView1_Sorting" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" SortExpression="Id" />
<asp:BoundField DataField="dpt" HeaderText="团队" SortExpression="dpt" />
<asp:BoundField DataField="EID" HeaderText="员工编号" SortExpression="EID" />
<asp:BoundField DataField="EName" HeaderText="员工姓名" SortExpression="EName" />
<asp:BoundField DataField="PayDate" HeaderText="发放日期" SortExpression="PayDate" />
<asp:BoundField DataField="Wage" HeaderText="当月工资" SortExpression="Wage" />
</Columns>
</asp:GridView>
后台:
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
GridViewDataBind();
}
}
private void GridViewDataBind()
{
string today = DateTime.Now.ToString("yyyy-MM-dd");
string sql = "select Id,dpt,EID,EName,PayDate,Wage from MonthWage order by dpt,PayDate asc";
DataTable dt = SQLDBHelper.selectDB(sql);
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
string SortExpression = e.SortExpression.ToString(); //获得当前排序表达式
string SortDirection = "ASC"; //为排序方向变量赋初值
if (SortExpression == GridView1.Attributes["SortExpression"]) //如果为当前排序列
{
SortDirection = (GridView1.Attributes["SortDirection"].ToString() == SortDirection ? "DESC" : "ASC"); //获得下一次的排序状态
}
GridView1.Attributes["SortExpression"] = SortExpression;
GridView1.Attributes["SortDirection"] = SortDirection;
GridViewDataBind();
}