• 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. }
  • 相关阅读:
    洛谷P2770 航空路线问题 最小费用流
    洛谷P2766 最长不下降子序列问题 网络流_DP
    洛谷P2763 试题库问题 最大流
    洛谷P2756 飞行员配对方案问题 网络流_二分图
    洛谷P2045 方格取数加强版 最小费用流
    洛谷P1231 教辅的组成 网络流
    LA3231 Fair Share 二分_网络流
    [CTSC1999]家园 分层图网络流_并查集
    力扣题目汇总（丑数，重复N的元素，求众数）
    力扣题目汇总（最长连续递增序列，旋转图像（中等），宝石与石头）
  • 原文地址：https://www.cnblogs.com/zgqys1980/p/1440577.html
Copyright © 2020-2023  润新知