Repeater自定义分页 + 排序 + 全选删除

时间:2022-06-20 10:18:53
页面代码:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="RepeaterPagingSortingDelete.aspx.cs" Inherits="RepeaterPagingSortingDelete" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml"> 
<head runat="server"> 
    <title>RepeaterPagingSortingDelete</title> 
    <script language="javascript" type="text/javascript"> 
        function chooseAll(sender) 
        { 
            var inputs = document.all.tags("INPUT"); 
            // 遍历页面上所有的 input  
            for (var i = 0; i < inputs.length; i++)  
            {        
                    //如果此input元素的类型为checkbox,并且其id中包含chkSelect 
                    if (inputs[i].type == "checkbox" && inputs[i].id.indexOf("chkSelect") >= 0) 
                    { 
                        //设置此复选框的checked与全选复选框相同 
                        inputs[i].checked = document.getElementById(sender).checked; 
                        inputs[i].onclick(); 
                    }  
            } 
        } 
         
        function highLightSelected(chkSelect) 
        {  
            if (chkSelect.checked)  
                chkSelect.parentElement.parentElement.style.backgroundColor='#CCCCFF';  
            else  
                chkSelect.parentElement.parentElement.style.backgroundColor='white';  
        } 
    </script> 
</head> 
<body> 
    <form id="form1" runat="server"> 
    <div> 
        <asp:LinkButton id="lbtnFirst" runat="server" CommandName="First" OnCommand="lbtnPage_Command">|<</asp:LinkButton>   
        <asp:LinkButton id="lbtnPrevious" runat="server" CommandName="Previous" OnCommand="lbtnPage_Command"><<</asp:LinkButton>   
        <asp:Label id="lblMessage" runat="server" />   
        <asp:LinkButton id="lbtnNext" runat="server" CommandName="Next" OnCommand="lbtnPage_Command">>></asp:LinkButton>   
        <asp:LinkButton id="lbtnLast" runat="server" CommandName="Last" OnCommand="lbtnPage_Command">>|</asp:LinkButton>   
        转到第<asp:DropDownList ID="dropPage" runat="server" AutoPostBack="True" OnSelectedIndexChanged="dropPage_SelectedIndexChanged"></asp:DropDownList>页         
        <asp:Repeater ID="rptProducts" runat="server"  
            onitemcreated="rptProducts_ItemCreated"  
            onitemdatabound="rptProducts_ItemDataBound"> 
            <HeaderTemplate> 
                <table border="1"> 
                <tr> 
                    <td id="tdAll" runat="server"><asp:CheckBox ID="chkAll" runat="server" /></td> 
                    <td id="tdProductID" runat="server"><asp:LinkButton ID="lbtnProductID" runat="server" Text="ProductID" CommandName="ProductID" OnCommand="lbtnSort_Command"></asp:LinkButton><asp:Label ID="lblHeadProductID" runat="server" Visible="false"></asp:Label></td> 
                    <td id="tdProductName" runat="server"><asp:LinkButton ID="lbtnProductName" runat="server" Text="ProductName" CommandName="ProductName" OnCommand="lbtnSort_Command"></asp:LinkButton><asp:Label ID="lblProductName" runat="server" Visible="false"></asp:Label></td> 
                    <td id="tdSupplierID" runat="server"><asp:LinkButton ID="lbtnSupplierID" runat="server" Text="SupplierID" CommandName="SupplierID" OnCommand="lbtnSort_Command"></asp:LinkButton><asp:Label ID="lblSupplierID" runat="server" Visible="false"></asp:Label></td> 
                    <td id="tdCategoryID" runat="server"><asp:LinkButton ID="lbtnCategoryID" runat="server" Text="CategoryID" CommandName="CategoryID" OnCommand="lbtnSort_Command"></asp:LinkButton><asp:Label ID="lblCategoryID" runat="server" Visible="false"></asp:Label></td> 
                    <td id="tdQuantityPerUnit" runat="server"><asp:LinkButton ID="lbtnQuantityPerUnit" runat="server" Text="QuantityPerUnit" CommandName="QuantityPerUnit" OnCommand="lbtnSort_Command"></asp:LinkButton><asp:Label ID="lblQuantityPerUnit" runat="server" Visible="false"></asp:Label></td> 
                    <td id="tdUnitPrice" runat="server"><asp:LinkButton ID="lbtnUnitPrice" runat="server" Text="UnitPrice" CommandName="UnitPrice" OnCommand="lbtnSort_Command"></asp:LinkButton><asp:Label ID="lblUnitPrice" runat="server" Visible="false"></asp:Label></td> 
                    <td id="tdUnitsInStock" runat="server"><asp:LinkButton ID="lbtnUnitsInStock" runat="server" Text="UnitsInStock" CommandName="UnitsInStock" OnCommand="lbtnSort_Command"></asp:LinkButton><asp:Label ID="lblUnitsInStock" runat="server" Visible="false"></asp:Label></td> 
                    <td id="tdUnitsOnOrder" runat="server"><asp:LinkButton ID="lbtnUnitsOnOrder" runat="server" Text="UnitsOnOrder" CommandName="UnitsOnOrder" OnCommand="lbtnSort_Command"></asp:LinkButton><asp:Label ID="lblUnitsOnOrder" runat="server" Visible="false"></asp:Label></td> 
                    <td id="tdReorderLevel" runat="server"><asp:LinkButton ID="lbtnReorderLevel" runat="server" Text="ReorderLevel" CommandName="ReorderLevel" OnCommand="lbtnSort_Command"></asp:LinkButton><asp:Label ID="lblReorderLevel" runat="server" Visible="false"></asp:Label></td> 
                    <td id="tdDiscontinued" runat="server"><asp:LinkButton ID="lbtnDiscontinued" runat="server" Text="Discontinued" CommandName="Discontinued" OnCommand="lbtnSort_Command"></asp:LinkButton><asp:Label ID="lblDiscontinued" runat="server" Visible="false"></asp:Label></td> 
                </tr> 
            </HeaderTemplate> 
            <ItemTemplate> 
                <tr> 
                    <td id="tdSelect" runat="server"><asp:CheckBox ID="chkSelect" runat="server" /></td> 
                    <td><asp:Label ID="lblProductID" runat="server" Text='<%# Eval("ProductID") %>'></asp:Label></td> 
                    <td><asp:Label ID="lblProductName" runat="server" Text='<%# Eval("ProductName") %>'></asp:Label></td> 
                    <td><asp:Label ID="lblSupplierID" runat="server" Text='<%# Eval("SupplierID") %>'></asp:Label></td> 
                    <td><asp:Label ID="lblCategoryID" runat="server" Text='<%# Eval("CategoryID") %>'></asp:Label></td> 
                    <td><asp:Label ID="lblQuantityPerUnit" runat="server" Text='<%# Eval("QuantityPerUnit") %>'></asp:Label></td> 
                    <td><asp:Label ID="lblUnitPrice" runat="server" Text='<%# Eval("UnitPrice") %>'></asp:Label></td> 
                    <td><asp:Label ID="lblUnitsInStock" runat="server" Text='<%# Eval("UnitsInStock") %>'></asp:Label></td> 
                    <td><asp:Label ID="lblUnitsOnOrder" runat="server" Text='<%# Eval("UnitsOnOrder") %>'></asp:Label></td> 
                    <td><asp:Label ID="lblReorderLevel" runat="server" Text='<%# Eval("ReorderLevel") %>'></asp:Label></td> 
                    <td><asp:CheckBox ID="chkDiscontinued" runat="server" Checked='<%# Eval("Discontinued") %>' Enabled="false" /></td> 
                </tr> 
            </ItemTemplate> 
            <FooterTemplate> 
                </table> 
            </FooterTemplate> 
        </asp:Repeater> 
        <asp:Button ID="btnDelete" runat="server" Text="删除" onclick="btnDelete_Click" /> 
    </div> 
    </form> 
</body> 
</html>
后台代码:

using System; 
using System.Collections; 
using System.Configuration; 
using System.Data; 
using System.Linq; 
using System.Web; 
using System.Web.Security; 
using System.Web.UI; 
using System.Web.UI.HtmlControls; 
using System.Web.UI.WebControls; 
using System.Web.UI.WebControls.WebParts; 
using System.Xml.Linq; 
using System.Data.SqlClient;

public partial class RepeaterPagingSortingDelete : System.Web.UI.Page 
{ 
    //每页显示的最多记录的条数 
    private int pageSize = 10; 
    //当前页号 
    private int currentPageNumber; 
    //排序表达式 
    private string sortExpression = string.Empty; 
    //排序方向 
    private string sortDirection = string.Empty; 
    //显示数据的总条数 
    private static int rowCount; 
    //总页数 
    private static int pageCount;

    protected void Page_Load(object sender, EventArgs e) 
    { 
        if (!IsPostBack) 
        { 
            SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString); 
            SqlCommand cmd = new SqlCommand("GetProductsCount", cn); 
            cmd.CommandType = CommandType.StoredProcedure; 
            cn.Open(); 
            rowCount = (int)cmd.ExecuteScalar(); 
            cn.Close(); 
            pageCount = (rowCount - 1) / pageSize + 1; 
            currentPageNumber = 1; 
            for (int i = 1; i <= pageCount; i++) 
            { 
                dropPage.Items.Add(new ListItem(i.ToString(), i.ToString())); 
            } 
            dropPage.SelectedValue = dropPage.Items.FindByValue(currentPageNumber.ToString()).Value; 
            Query(); 
        } 
        sortExpression = ViewState["sortExpression"].ToString(); 
        sortDirection = ViewState["sortDirection"].ToString(); 
        currentPageNumber = Convert.ToInt32(ViewState["currentPageNumber"]); 
    }

    private void Query() 
    { 
        SetButton(currentPageNumber); 
        SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString); 
        SqlCommand cmd = new SqlCommand("GetProductsByPage", cn); 
        cmd.CommandType = CommandType.StoredProcedure; 
        cmd.Parameters.AddWithValue("@sortExpression", sortExpression + " " + sortDirection); 
        cmd.Parameters.AddWithValue("@pageNumber", currentPageNumber); 
        cmd.Parameters.AddWithValue("@pageSize", pageSize); 
        cn.Open(); 
        rptProducts.DataSource = cmd.ExecuteReader(); 
        rptProducts.DataBind(); 
        cn.Close(); 
        lblMessage.Text = "共找到" + rowCount + "条记录, 当前第" + currentPageNumber + "/" + pageCount + "页"; 
        Save(); 
    }

    protected void lbtnPage_Command(object sender, CommandEventArgs e) 
    { 
        switch (e.CommandName) 
        { 
            case "First": 
                currentPageNumber = 1; 
                break; 
            case "Previous": 
                currentPageNumber = (int)ViewState["currentPageNumber"] - 1 > 1 ? (int)ViewState["currentPageNumber"] - 1 : 1; 
                break; 
            case "Next": 
                currentPageNumber = (int)ViewState["currentPageNumber"] + 1 < pageCount ? (int)ViewState["currentPageNumber"] + 1 : pageCount; 
                break; 
            case "Last": 
                currentPageNumber = pageCount; 
                break; 
        } 
        dropPage.SelectedValue = dropPage.Items.FindByValue(currentPageNumber.ToString()).Value; 
        Query(); 
    }

    protected void lbtnSort_Command(object sender, CommandEventArgs e) 
    { 
        if (e.CommandName != ViewState["sortExpression"].ToString()) 
        { 
            sortDirection = "ASC"; 
        } 
        else 
        { 
            if (sortDirection == "ASC") 
            { 
                sortDirection = "DESC"; 
            } 
            else if (sortDirection == "DESC" || sortDirection == string.Empty) 
            { 
                sortDirection = "ASC"; 
            } 
        } 
        sortExpression = e.CommandName; 
        Query(); 
    }

    protected void dropPage_SelectedIndexChanged(object sender, EventArgs e) 
    { 
        currentPageNumber = int.Parse(dropPage.SelectedValue); 
        Query(); 
    }

    private void SetButton(int currentPageNumber) 
    { 
        lbtnFirst.Enabled = currentPageNumber != 1; 
        lbtnPrevious.Enabled = currentPageNumber != 1; 
        lbtnNext.Enabled = currentPageNumber != pageCount; 
        lbtnLast.Enabled = currentPageNumber != pageCount; 
    }

    private void Save() 
    { 
        ViewState["currentPageNumber"] = currentPageNumber; 
        ViewState["sortExpression"] = sortExpression; 
        ViewState["sortDirection"] = sortDirection; 
    }

    protected void rptProducts_ItemCreated(object sender, RepeaterItemEventArgs e) 
    { 
        if (e.Item.ItemType == ListItemType.Header) 
        { 
            if (!string.IsNullOrEmpty(sortDirection)) 
            { 
                Label lblSort = new Label(); 
                lblSort.EnableTheming = false; 
                lblSort.Font.Name = "webdings"; 
                lblSort.Font.Size = FontUnit.Small; 
                lblSort.Text = sortDirection == "ASC" ? "5" : "6"; 
                (e.Item.FindControl("td" + sortExpression) as HtmlTableCell).Controls.Add(lblSort); 
            } 
        } 
    } 
    protected void btnDelete_Click(object sender, EventArgs e) 
    { 
        CheckBox chkSelect; 
        Label lblProductID; 
        foreach (RepeaterItem item in rptProducts.Items) 
        { 
            chkSelect = item.FindControl("chkSelect") as CheckBox; 
            if (chkSelect != null && chkSelect.Checked) 
            { 
                lblProductID = item.FindControl("lblProductID") as Label; 
                //Response.Write(lblProductID.Text); 
                //可以在这里完成删除逻辑 
            } 
        } 
    }

    protected void rptProducts_ItemDataBound(object sender, RepeaterItemEventArgs e) 
    { 
        if (e.Item.ItemType == ListItemType.Header) 
        {  
            CheckBox chkAll = e.Item.FindControl("chkAll") as CheckBox; 
            chkAll.Attributes.Add("onclick", "chooseAll('" + chkAll.ClientID + "')");         
        }

        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) 
        { 
            CheckBox chkSelect = e.Item.FindControl("chkSelect") as CheckBox; 
            chkSelect.Attributes.Add("onclick", "highLightSelected(this);"); 
        } 
    } 
}