程序博客网 > ruby元编程第二版 pdf

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

来源：互联网 发布：ruby元编程第二版 pdf 编辑：程序博客网 时间：2024/05/22 12:42

页面代码:

<%@ 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);");
        }
    }
}

 

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/amandag/archive/2008/08/05/2773541.aspx

ruby元编程第二版 pdf ruby元编程第二版 pdf
原创粉丝点击
热门IT博客
没有货怎么开淘宝店铺没有货怎么开淘宝店铺
js根据固定格式化金额js根据固定格式化金额
hadoop java环境
java 5-7天岗前培训
苹果mac重装系统教程
网络的坏处例子
王小波 程序员
本机mac地址查询
虚拟试衣间淘宝店铺
ifconfig 查看mac
指向数组的指针
vans淘宝正品店有哪些
js取当前时间
字符串数组的定义格式
织梦cms 演示版
多张excel数据汇总
淘宝上一件代发可靠吗
恩牛网络融资
网络商标有到期吗
nginx缓存释放
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 反毛皮的鞋脏了怎么办 鞋子洗完还是臭怎么办 棉拖鞋穿久了臭怎么办 脚被鞋子磨破了怎么办 脚磨破皮了露肉怎么办 乐福鞋后跟老掉怎么办 鞋大了一码怎么办 鞋子大了半码怎么办 鞋子买大了一码怎么办 凉鞋磨脚怎么办小妙招 露娜鞋垫扁了怎么办 牛皮鞋用水洗了怎么办 板鞋前面硌脚怎么办 练瑜伽膝盖疼了怎么办 练瑜伽腿筋拉伤怎么办 练完瑜伽腰疼怎么办 练瑜伽,膝盖儿疼怎么办 买了新车不敢开怎么办 提车新手不敢开怎么办 气垫颜色买深了怎么办 书包的双肩坏了怎么办 皮鞋的皮磨掉了怎么办 黑皮鞋蹭了皮怎么办 鞋子蹭掉了点皮怎么办 红色皮鞋皮裂了怎么办 白色鞋子皮破了怎么办 皮鞋鞋面刮破了怎么办 皮鞋表面的刮花怎么办 pu皮鞋头塌了怎么办 皮鞋前面踩塌了怎么办 皮鞋的皮破了怎么办 皮鞋挂的起皮了怎么办 皮鞋前面踢烂了怎么办 皮鞋掉了一块皮怎么办 马丁靴前头很硬怎么办 阿迪裤子起球怎么办 衣服没晒干有异味怎么办 84泡衣服变黄怎么办 白色衣服洗黑了怎么办 白衣服洗过发黑怎么办 小孩的衣服太脏怎么办

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里