036. asp.netWeb用户控件之五使用用户控件实现分页数据导航

UserDataPager.ascx用户控件代码:

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="UserDataPager.ascx.cs" Inherits="UserDataPager" %>

<style type="text/css">

    .style8

    {

    }

    .style11

    {

        width: 249px;

        font-size: small;

    }

    </style>

<table cellpadding="0" cellspacing="0"

    style="border: 1px solid #999999; font-size: small; height: 25px; width: 403px;"

    bgcolor="#F2F2F2">

    <tr>

        <td style="text-align: center" class="style11">

            共有数据<asp:Label ID="lbldatanum" runat="server" ForeColor="Red"></asp:Label>

            条&nbsp; 每页<asp:Label ID="lblnum" runat="server" ForeColor="Red"></asp:Label>

            条&nbsp; 第<asp:Label ID="lblCurrentPage" runat="server" ForeColor="Red"></asp:Label>

            页/共<asp:Label ID="lblcount" runat="server" Font-Size="9pt" ForeColor="Red"></asp:Label>

            页</td>

        <td style="text-align: center" class="style8">

            <asp:LinkButton ID="lbtnFirst" runat="server" Font-Size="9pt"

                onclick="lbtnFirst_Click" Enabled="False">|&lt;</asp:LinkButton>

        &nbsp;<asp:LinkButton ID="lbtnForward" runat="server" Font-Size="9pt"

                onclick="lbtnForward_Click" Enabled="False">&lt;</asp:LinkButton>

        &nbsp;<asp:LinkButton ID="lbtnBackwards" runat="server" Font-Size="9pt"

                onclick="lbtnBackwards_Click">&gt;</asp:LinkButton>

        &nbsp;<asp:LinkButton ID="lbtnLast" runat="server" Font-Size="9pt"

                onclick="lbtnLast_Click">&gt;|</asp:LinkButton>

        </td>

    </tr>

</table>

UserDataPager.ascx.cs代码:

public partial class UserDataPager : System.Web.UI.UserControl

{

    protected static PagedDataSource pds = new PagedDataSource();//创建一个分页数据源的对象且一定要声明为静态

    private SqlConnection conn;

    private object operateID;

    public object OperateID

    {

        get { return operateID; }

        set { operateID = value; }

    }

    private int pageNum=;

    public int PageNum

    {

        get { return pageNum; }

        set { pageNum = value; }

    }

    private string strSQL = "";

    public string StrSQL

    {

        get { return strSQL; }

        set { strSQL = value; }

    }

    private string sql = "";

    public string DataSQL

    {

        get { return sql; }

        set { sql = value; }

    }

    private void BindDataList(int currentpage)

    {

        string mytype = operateID.GetType().ToString();

        mytype = mytype.Substring(mytype.LastIndexOf(".") + , mytype.Length -  - mytype.LastIndexOf("."));

        conn = new SqlConnection(strSQL);

        pds.AllowPaging = true;//允许分页

        pds.PageSize = pageNum;//每页显示3条数据

        pds.CurrentPageIndex = currentpage;//当前页为传入的一个int型值

        conn.Open();//打开数据库连接

        SqlDataAdapter sda = new SqlDataAdapter(sql, conn);

        DataSet ds = new DataSet();

        sda.Fill(ds);//把执行得到的数据放在数据集中

        pds.DataSource = ds.Tables[].DefaultView;//把数据集中的数据放入分页数据源中

        lblcount.Text = pds.PageCount.ToString();

        lblCurrentPage.Text =(pds.CurrentPageIndex + ).ToString();

        lblnum.Text = pageNum.ToString();

        lbldatanum.Text = ds.Tables[].Rows.Count.ToString();

        if (pds.PageCount > )

        {

            lbtnBackwards.Enabled = true;

            lbtnLast.Enabled = true;

        }

        else

        {

            lbtnBackwards.Enabled = false;

            lbtnLast.Enabled = false;

        }

        if (mytype == "GridView")

        {

            ((GridView)(operateID)).DataSource = pds;

            ((GridView)(operateID)).DataBind();

        }

        else if (mytype == "DataList")

        {

            ((DataList)(operateID)).DataSource = pds;

            ((DataList)(operateID)).DataBind();

        }

        conn.Close();

    }

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            BindDataList();

        }

    }

    protected void lbtnFirst_Click(object sender, EventArgs e)//首页

    {

        pds.CurrentPageIndex = ;

        BindDataList(pds.CurrentPageIndex);

        lbtnFirst.Enabled = false;

        lbtnForward.Enabled = false;

        lbtnBackwards.Enabled = true;

        lbtnLast.Enabled = true;

    }

    protected void lbtnForward_Click(object sender, EventArgs e)//上一页

    {

        if (pds.CurrentPageIndex >= )

        {

            pds.CurrentPageIndex = pds.CurrentPageIndex - ;

            BindDataList(pds.CurrentPageIndex);

            lbtnBackwards.Enabled = true;

            lbtnLast.Enabled = true;

            if (pds.CurrentPageIndex == )

            {

                lbtnForward.Enabled = false;

                lbtnFirst.Enabled = false;

            }

        }

    }

    protected void lbtnBackwards_Click(object sender, EventArgs e)//下一页

    {

        if (pds.CurrentPageIndex <= pds.PageCount - )

        {

            lbtnFirst.Enabled = true;

            lbtnForward.Enabled = true;

            pds.CurrentPageIndex = pds.CurrentPageIndex + ;

            BindDataList(pds.CurrentPageIndex);

            if (pds.CurrentPageIndex == pds.PageCount - )

            {

                lbtnBackwards.Enabled = false;

                lbtnLast.Enabled = false;

            }

        }

    }

    protected void lbtnLast_Click(object sender, EventArgs e)//尾页

    {

        pds.CurrentPageIndex = pds.PageCount - ;

        BindDataList(pds.CurrentPageIndex);

        lbtnLast.Enabled = false;

        lbtnBackwards.Enabled = false;

        lbtnFirst.Enabled = true;

        lbtnForward.Enabled = true;

    }

}

Default.aspx代码:

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

<%@ Register src="UserDataPager.ascx" tagname="UserDataPager" tagprefix="uc1" %>

<!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>无标题页</title>

    <style type="text/css">

        .style7

        {

            width: 100%;

            height: 42px;

        }

    </style>

</head>

<body>

    <form id="form1" runat="server">

    <div style="width: 1019px; text-align: center; height: 54px;">

        <table align="center" cellpadding="0" cellspacing="0" class="style7">

            <tr>

                <td style="text-align: left">

                    <uc1:UserDataPager ID="UserDataPager1" runat="server" />

                </td>

            </tr>

            <tr>

                <td>

                    </td>

            </tr>

        </table>

    </div>

    <asp:GridView ID="GridView1" runat="server" BackColor="White"

        BorderColor="#CCCCCC" BorderStyle="Ridge" BorderWidth="1px"

        CellPadding="3" Width="403px">

        <RowStyle ForeColor="#000066" />

        <FooterStyle BackColor="White" ForeColor="#000066" />

        <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />

        <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />

        <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />

    </asp:GridView>

    </form>

</body>

</html>

Default.aspx.cs代码:

public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        UserDataPager1.OperateID = GridView1; //设置针对哪个控件进行分页描述

        UserDataPager1.StrSQL = "server=.;uid=sa;pwd=123.456;database=TYW;";//设置链接字符串

        UserDataPager1.DataSQL = "select * from card";

        UserDataPager1.PageNum = 6;

    }

}

最终效果: