Repeater Order双向排序代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】 Repeater Order双向排序
作者:信和 / 发布于2016/9/13/ 1013
页面代码：

<div>
        <table border="1" bordercolor="#330033" bordercolordark="#999933" bordercolorlight="black">
            <tr>
                <td colspan="5" align="center">
                    <font color="blue" size="12">Repeater实现双向排序功能</font>
                </td>
            </tr>
            <asp:Repeater ID="rpOrder" runat="server" onitemcommand="rpOrder_ItemCommand" 
                onitemdatabound="rpOrder_ItemDataBound">
                <HeaderTemplate>
                    <tr align="center">                        
                        <td><asp:LinkButton ID="username" runat="server" Text="username" CommandName="username"></asp:LinkButton></td>
                        <td><asp:LinkButton ID="userphone" runat="server" Text="userphone" CommandName="userphone"></asp:LinkButton></td>
                        <td><asp:LinkButton ID="comment" runat="server" Text="comment" CommandName="comment"></asp:LinkButton></td>
                        <td><asp:LinkButton ID="pubtime" runat="server" Text="pubtime" CommandName="pubtime"></asp:LinkButton></td>
                    </tr>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                        <td><%# DataBinder.Eval(Container.DataItem, "username")%></td>
                        <td><%# DataBinder.Eval(Container.DataItem, "userphone")%></td>
                        <td><%# DataBinder.Eval(Container.DataItem, "comment")%></td>
                        <td><%# DataBinder.Eval(Container.DataItem, "pubtime")%></td>                        
                    </tr>
                </ItemTemplate>
            </asp:Repeater>
        </table>
    </div>

功能实现：

#region
    protected Repeater reOrder;
    private readonly string conStr = ConfigurationManager.ConnectionStrings["dbConnection"].ToString();
    private SqlConnection Conn()
    {
        return new SqlConnection(conStr);
    }

    /// <summary>
    /// 缓存DataView
    /// </summary>
    private DataView GetData
    {
        get { return Cache["data"] as DataView; }
        set
        {
            if (Cache["data"] == null)
                Cache["data"] = value;
        }
    }
    #endregion

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
            BindRepeater();
    }

    /// <summary>
    /// 绑定Repeater
    /// </summary>
    private void BindRepeater()
    {
        DataSet ds = new DataSet();
        using (SqlDataAdapter da = new SqlDataAdapter("select * from hxyl", Conn()))
        {
            da.Fill(ds);
        }
        GetData = ds.Tables[0].DefaultView;
        rpOrder.DataSource = ds.Tables[0];
        rpOrder.DataBind();
    }

    /// <summary>
    /// Repeater执行事件
    /// </summary>
    /// <param name="source"></param>
    /// <param name="e"></param>
    protected void rpOrder_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";           
                lkbtnSort.Text = lkbtnSort.Text + "▲";
            }
            else
            {
                if (ViewState[e.CommandName.Trim()].ToString().Trim() == "ASC")
                {
                    ViewState[e.CommandName.Trim()] = "DESC";
                    if (lkbtnSort.Text.IndexOf("▲") != -1)
                        lkbtnSort.Text = lkbtnSort.Text.Replace("▲", "▼");
                    else
                        lkbtnSort.Text = lkbtnSort.Text + "▼";
                }
                else
                {
                    ViewState[e.CommandName.Trim()] = "ASC";
                    if (lkbtnSort.Text.IndexOf("▼") != -1)
                        lkbtnSort.Text = lkbtnSort.Text.Replace("▼", "▲");
                    else
                        lkbtnSort.Text = lkbtnSort.Text + "▲";
                }
            }
            ViewState["text"] = lkbtnSort.Text;
            ViewState["id"] = e.CommandName.Trim();
            DataView dv = GetData;
            string s = ViewState[e.CommandName.Trim()].ToString();
            dv.Sort = e.CommandName.ToString().Trim() + " " + ViewState[e.CommandName.Trim()].ToString().Trim();
            rpOrder.DataSource = dv;
            rpOrder.DataBind();
        }
    }

    /// <summary>
    /// Repeater数据绑定
    /// </summary>
    protected void rpOrder_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Header)
        {
            if (ViewState["id"] != null)
            {
                LinkButton lkBtnSort = (LinkButton)e.Item.FindControl(ViewState["id"].ToString().Trim());
                lkBtnSort.Text = ViewState["text"].ToString();
            }
        }
    }
试试其它关键字
同语言下
可能有用的
信和贡献的其它代码(8)