Repeater自定义分页 + 排序 + 全选删除(3)(转) dodo

页面代码:

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="RepeaterPagingSortingDelete.aspx.cs" Inherits="RepeaterPagingSortingDelete" %>
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  5. <html xmlns="http://www.w3.org/1999/xhtml">
  6. <head runat="server">
  7.     <title>RepeaterPagingSortingDelete</title>
  8.     <script language="javascript" type="text/javascript">
  9.         function chooseAll(sender)
  10.         {
  11.             var inputs = document.all.tags("INPUT");
  12.             // 遍历页面上所有的 input 
  13.             for (var i = 0; i < inputs.length; i++) 
  14.             {       
  15.                     //如果此input元素的类型为checkbox，并且其id中包含chkSelect
  16.                     if (inputs[i].type == "checkbox" && inputs[i].id.indexOf("chkSelect") >= 0)
  17.                     {
  18.                         //设置此复选框的checked与全选复选框相同
  19.                         inputs[i].checked = document.getElementById(sender).checked;
  20.                         inputs[i].onclick();
  21.                     } 
  22.             }
  23.         }
  24.         
  25.         function highLightSelected(chkSelect)
  26.         { 
  27.             if (chkSelect.checked) 
  28.                 chkSelect.parentElement.parentElement.style.backgroundColor='#CCCCFF'; 
  29.             else 
  30.                 chkSelect.parentElement.parentElement.style.backgroundColor='white'; 
  31.         }
  32.     </script>
  33. </head>
  34. <body>
  35.     <form id="form1" runat="server">
  36.     <div>
  37.         <asp:LinkButton id="lbtnFirst" runat="server" CommandName="First" OnCommand="lbtnPage_Command">|<</asp:LinkButton>  
  38.         <asp:LinkButton id="lbtnPrevious" runat="server" CommandName="Previous" OnCommand="lbtnPage_Command"><<</asp:LinkButton>  
  39.         <asp:Label id="lblMessage" runat="server" />  
  40.         <asp:LinkButton id="lbtnNext" runat="server" CommandName="Next" OnCommand="lbtnPage_Command">>></asp:LinkButton>  
  41.         <asp:LinkButton id="lbtnLast" runat="server" CommandName="Last" OnCommand="lbtnPage_Command">>|</asp:LinkButton>  
  42.         转到第<asp:DropDownList ID="dropPage" runat="server" AutoPostBack="True" OnSelectedIndexChanged="dropPage_SelectedIndexChanged"></asp:DropDownList>页        
  43.         <asp:Repeater ID="rptProducts" runat="server" 
  44.             onitemcreated="rptProducts_ItemCreated" 
  45.             onitemdatabound="rptProducts_ItemDataBound">
  46.             <HeaderTemplate>
  47.                 <table border="1">
  48.                 <tr>
  49.                     <td id="tdAll" runat="server"><asp:CheckBox ID="chkAll" runat="server" /></td>
  50.                     <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>
  51.                     <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>
  52.                     <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>
  53.                     <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>
  54.                     <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>
  55.                     <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>
  56.                     <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>
  57.                     <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>
  58.                     <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>
  59.                     <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>
  60.                 </tr>
  61.             </HeaderTemplate>
  62.             <ItemTemplate>
  63.                 <tr>
  64.                     <td id="tdSelect" runat="server"><asp:CheckBox ID="chkSelect" runat="server" /></td>
  65.                     <td><asp:Label ID="lblProductID" runat="server" Text='<%# Eval("ProductID") %>'></asp:Label></td>
  66.                     <td><asp:Label ID="lblProductName" runat="server" Text='<%# Eval("ProductName") %>'></asp:Label></td>
  67.                     <td><asp:Label ID="lblSupplierID" runat="server" Text='<%# Eval("SupplierID") %>'></asp:Label></td>
  68.                     <td><asp:Label ID="lblCategoryID" runat="server" Text='<%# Eval("CategoryID") %>'></asp:Label></td>
  69.                     <td><asp:Label ID="lblQuantityPerUnit" runat="server" Text='<%# Eval("QuantityPerUnit") %>'></asp:Label></td>
  70.                     <td><asp:Label ID="lblUnitPrice" runat="server" Text='<%# Eval("UnitPrice") %>'></asp:Label></td>
  71.                     <td><asp:Label ID="lblUnitsInStock" runat="server" Text='<%# Eval("UnitsInStock") %>'></asp:Label></td>
  72.                     <td><asp:Label ID="lblUnitsOnOrder" runat="server" Text='<%# Eval("UnitsOnOrder") %>'></asp:Label></td>
  73.                     <td><asp:Label ID="lblReorderLevel" runat="server" Text='<%# Eval("ReorderLevel") %>'></asp:Label></td>
  74.                     <td><asp:CheckBox ID="chkDiscontinued" runat="server" Checked='<%# Eval("Discontinued") %>' Enabled="false" /></td>
  75.                 </tr>
  76.             </ItemTemplate>
  77.             <FooterTemplate>
  78.                 </table>
  79.             </FooterTemplate>
  80.         </asp:Repeater>
  81.         <asp:Button ID="btnDelete" runat="server" Text="删除" onclick="btnDelete_Click" />
  82.     </div>
  83.     </form>
  84. </body>
  85. </html>

后台代码:

  1. using System;
  2. using System.Collections;
  3. using System.Configuration;
  4. using System.Data;
  5. using System.Linq;
  6. using System.Web;
  7. using System.Web.Security;
  8. using System.Web.UI;
  9. using System.Web.UI.HtmlControls;
  10. using System.Web.UI.WebControls;
  11. using System.Web.UI.WebControls.WebParts;
  12. using System.Xml.Linq;
  13. using System.Data.SqlClient;
  15. public partial class RepeaterPagingSortingDelete : System.Web.UI.Page
  16. {
  17.     //每页显示的最多记录的条数
  18.     private int pageSize = 10;
  19.     //当前页号
  20.     private int currentPageNumber;
  21.     //排序表达式
  22.     private string sortExpression = string.Empty;
  23.     //排序方向
  24.     private string sortDirection = string.Empty;
  25.     //显示数据的总条数
  26.     private static int rowCount;
  27.     //总页数
  28.     private static int pageCount;
  30.     protected void Page_Load(object sender, EventArgs e)
  31.     {
  32.         if (!IsPostBack)
  33.         {
  34.             SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);
  35.             SqlCommand cmd = new SqlCommand("GetProductsCount", cn);
  36.             cmd.CommandType = CommandType.StoredProcedure;
  37.             cn.Open();
  38.             rowCount = (int)cmd.ExecuteScalar();
  39.             cn.Close();
  40.             pageCount = (rowCount - 1) / pageSize + 1;
  41.             currentPageNumber = 1;
  42.             for (int i = 1; i <= pageCount; i++)
  43.             {
  44.                 dropPage.Items.Add(new ListItem(i.ToString(), i.ToString()));
  45.             }
  46.             dropPage.SelectedValue = dropPage.Items.FindByValue(currentPageNumber.ToString()).Value;
  47.             Query();
  48.         }
  49.         sortExpression = ViewState["sortExpression"].ToString();
  50.         sortDirection = ViewState["sortDirection"].ToString();
  51.         currentPageNumber = Convert.ToInt32(ViewState["currentPageNumber"]);
  52.     }
  54.     private void Query()
  55.     {
  56.         SetButton(currentPageNumber);
  57.         SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);
  58.         SqlCommand cmd = new SqlCommand("GetProductsByPage", cn);
  59.         cmd.CommandType = CommandType.StoredProcedure;
  60.         cmd.Parameters.AddWithValue("@sortExpression", sortExpression + " " + sortDirection);
  61.         cmd.Parameters.AddWithValue("@pageNumber", currentPageNumber);
  62.         cmd.Parameters.AddWithValue("@pageSize", pageSize);
  63.         cn.Open();
  64.         rptProducts.DataSource = cmd.ExecuteReader();
  65.         rptProducts.DataBind();
  66.         cn.Close();
  67.         lblMessage.Text = "共找到" + rowCount + "条记录, 当前第" + currentPageNumber + "/" + pageCount + "页";
  68.         Save();
  69.     }
  71.     protected void lbtnPage_Command(object sender, CommandEventArgs e)
  72.     {
  73.         switch (e.CommandName)
  74.         {
  75.             case "First":
  76.                 currentPageNumber = 1;
  77.                 break;
  78.             case "Previous":
  79.                 currentPageNumber = (int)ViewState["currentPageNumber"] - 1 > 1 ? (int)ViewState["currentPageNumber"] - 1 : 1;
  80.                 break;
  81.             case "Next":
  82.                 currentPageNumber = (int)ViewState["currentPageNumber"] + 1 < pageCount ? (int)ViewState["currentPageNumber"] + 1 : pageCount;
  83.                 break;
  84.             case "Last":
  85.                 currentPageNumber = pageCount;
  86.                 break;
  87.         }
  88.         dropPage.SelectedValue = dropPage.Items.FindByValue(currentPageNumber.ToString()).Value;
  89.         Query();
  90.     }
  92.     protected void lbtnSort_Command(object sender, CommandEventArgs e)
  93.     {
  94.         if (e.CommandName != ViewState["sortExpression"].ToString())
  95.         {
  96.             sortDirection = "ASC";
  97.         }
  98.         else
  99.         {
  100.             if (sortDirection == "ASC")
  101.             {
  102.                 sortDirection = "DESC";
  103.             }
  104.             else if (sortDirection == "DESC" || sortDirection == string.Empty)
  105.             {
  106.                 sortDirection = "ASC";
  107.             }
  108.         }
  109.         sortExpression = e.CommandName;
  110.         Query();
  111.     }
  113.     protected void dropPage_SelectedIndexChanged(object sender, EventArgs e)
  114.     {
  115.         currentPageNumber = int.Parse(dropPage.SelectedValue);
  116.         Query();
  117.     }
  119.     private void SetButton(int currentPageNumber)
  120.     {
  121.         lbtnFirst.Enabled = currentPageNumber != 1;
  122.         lbtnPrevious.Enabled = currentPageNumber != 1;
  123.         lbtnNext.Enabled = currentPageNumber != pageCount;
  124.         lbtnLast.Enabled = currentPageNumber != pageCount;
  125.     }
  127.     private void Save()
  128.     {
  129.         ViewState["currentPageNumber"] = currentPageNumber;
  130.         ViewState["sortExpression"] = sortExpression;
  131.         ViewState["sortDirection"] = sortDirection;
  132.     }
  134.     protected void rptProducts_ItemCreated(object sender, RepeaterItemEventArgs e)
  135.     {
  136.         if (e.Item.ItemType == ListItemType.Header)
  137.         {
  138.             if (!string.IsNullOrEmpty(sortDirection))
  139.             {
  140.                 Label lblSort = new Label();
  141.                 lblSort.EnableTheming = false;
  142.                 lblSort.Font.Name = "webdings";
  143.                 lblSort.Font.Size = FontUnit.Small;
  144.                 lblSort.Text = sortDirection == "ASC" ? "5" : "6";
  145.                 (e.Item.FindControl("td" + sortExpression) as HtmlTableCell).Controls.Add(lblSort);
  146.             }
  147.         }
  148.     }
  149.     protected void btnDelete_Click(object sender, EventArgs e)
  150.     {
  151.         CheckBox chkSelect;
  152.         Label lblProductID;
  153.         foreach (RepeaterItem item in rptProducts.Items)
  154.         {
  155.             chkSelect = item.FindControl("chkSelect") as CheckBox;
  156.             if (chkSelect != null && chkSelect.Checked)
  157.             {
  158.                 lblProductID = item.FindControl("lblProductID") as Label;
  159.                 //Response.Write(lblProductID.Text);
  160.                 //可以在这里完成删除逻辑
  161.             }
  162.         }
  163.     }
  165.     protected void rptProducts_ItemDataBound(object sender, RepeaterItemEventArgs e)
  166.     {
  167.         if (e.Item.ItemType == ListItemType.Header)
  168.         { 
  169.             CheckBox chkAll = e.Item.FindControl("chkAll") as CheckBox;
  170.             chkAll.Attributes.Add("onclick", "chooseAll('" + chkAll.ClientID + "')");        
  171.         }
  173.         if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
  174.         {
  175.             CheckBox chkSelect = e.Item.FindControl("chkSelect") as CheckBox;
  176.             chkSelect.Attributes.Add("onclick", "highLightSelected(this);");
  177.         }
  178.     }
  179. }
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/zgqys1980/p/1440577.html