Repeater控件实现排序

<form id="form1" runat="server">

                <table id="tblSort">

                    <tbody>

                        <asp:Repeater ID="ddllinputlist" OnItemCommand="ddllinputlist_ItemCommand" runat="server">

                            <HeaderTemplate>

                                <th class="tblSort_x enter_list_sort" style="cursor: pointer;">

                                    <asp:LinkButton ID="ContractNo" runat="server" CommandName="ContractNo">合同编号</asp:LinkButton></th>

                                <th class="tblSort_x">客户姓名</th>

                                <th class="tblSort_x">客户手机号</th>

                                <th class="tblSort_x">投资产品</th>

                                <th class="tblSort_x">业务员姓名</th>

                                <th class="tblSort_x">业务员身份证号</th>

                                <th class="tblSort_d">金额(元)</th>

                                <th class="tblSort_d enter_list_sort" style="cursor: pointer;">

                                    <asp:LinkButton ID="AddDate" runat="server" CommandName="AddDate">录入时间</asp:LinkButton></th>

                                <th class="tblSort_x">审核状态</th>

                                <th class="tblSort_x">备注</th>

                            </HeaderTemplate>

                            <ItemTemplate>

                                <tr>

                                    <td><%#Eval("ContractNo") %></td>

                                    <td><%#Eval("CustomerName") %></td>

                                    <td><%#Eval("CustomerPhone") %></td>

                                    <td><%#((int)Eval("Productid") != 0)?Flatty.Library.Sys.DataAccess.Wq.ProductAdapter.Instance.LoadByid((int)Eval("Productid")).ProductName:""%></td>

                                    <td><%#((int)Eval("Personnelid") != 0)?Flatty.Library.DataAccess.Wq.WqPersonnelAdapter.Instance.LoadByid((int)Eval("Personnelid")).Named:""%></td>

                                    <td><%#((int)Eval("Personnelid") != 0)?Flatty.Library.DataAccess.Wq.WqPersonnelAdapter.Instance.LoadByid((int)Eval("Personnelid")).CardNumber:""%></td>

                                    <td><%#Math.Round(Convert.ToDecimal(Eval("InvestAmount").ToString()),2) %></td>

                                    <td><%#Eval("AddDate","{0:yyyy-MM-dd}") %></td>

                                    <td><a <%#BindTitle(Eval("AuditState"))?" style='color:#f00;'": " style='color:#000;'"%>><%#Flatty.Common.Helper.EnumHelper.GetDescription<Flatty.Common.AuditState>((int)Eval("AuditState"))%></a></td>

                                    <td class="tblSort_Remarks"><a href="#">备注</a><p><i></i><%#Eval("Remarks")%></p>

                                    </td>

                                </tr>

                            </ItemTemplate>

                        </asp:Repeater>

                    </tbody>

                </table>

            </form>

            <div id="PageInfo" runat="server" class="anpager"></div>

 

private static DataSet dts = new DataSet();

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            if (dts.Tables.Count == 0)

            {

                dts = FeatListAdapter.Instance.GetAllList();

                if (dts.Tables[0].Rows.Count != 0)

                {

                    PageInfo.InnerHtml = PageNums.GetPageNum(dts, ddllinputlist, 20, null); //传入DataSet,DataList名称和分页大小               

                }

            }

            else

            {

                if (dts.Tables[0].Rows.Count != 0)

                {

                    PageInfo.InnerHtml = PageNums.GetPageNum(dts, ddllinputlist, 20, null); //传入DataSet,DataList名称和分页大小               

                }

            }

        }

    }

 

/// <summary>

    /// 排序事件

    /// </summary>

    /// <param name="source"></param>

    /// <param name="e"></param>

    protected void ddllinputlist_ItemCommand(object source, RepeaterCommandEventArgs e)

    {

        if (e.Item.ItemType == ListItemType.Header)

        {

            LinkButton lkbtnSort = (LinkButton)e.Item.FindControl(e.CommandName.Trim());

            if (ViewState[e.CommandName.Trim()] == null)

            {

                ViewState[e.CommandName.Trim()] = "ASC";

            }

            else

            {

                if (ViewState[e.CommandName.Trim()].ToString().Trim() == "ASC")

                {

                    ViewState[e.CommandName.Trim()] = "DESC";

                }

                else

                {

                    ViewState[e.CommandName.Trim()] = "ASC";

                }

            }

            ViewState["text"] = lkbtnSort.Text;

            ViewState["id"] = e.CommandName.Trim();

            DataView dv = new DataView(dts.Tables[0]);

            dv.Sort = e.CommandName.ToString().Trim() + " " + ViewState[e.CommandName.Trim()].ToString().Trim();

            dts = new DataSet();

            dts.Tables.Add(dv.ToTable());

            PageInfo.InnerHtml = PageNums.GetPageNum(dts, ddllinputlist, 20, null); //传入DataSet,DataList名称和分页大小  

        }

    }