页面
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="CustomPaginAction.ascx.cs" Inherits="DB_test_CustomPaginAction" %>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
<asp:LinkButton ID="First" runat="server" OnClick="LinkButton_Click">首页</asp:LinkButton>
|
<asp:LinkButton ID="Prev" runat="server" OnClick="LinkButton_Click">前页</asp:LinkButton>
|
<asp:LinkButton ID="Nest" runat="server" OnClick="LinkButton_Click">后页</asp:LinkButton>
|
<asp:LinkButton ID="Last" runat="server" OnClick="LinkButton_Click">尾页</asp:LinkButton>
转到第
<asp:DropDownList ID="GoToPage" runat="server" AutoPostBack="True" OnSelectedIndexChanged="GoToPage_SelectedIndexChanged">
</asp:DropDownList>
页
代码
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using com.fzd.Tutorship.BusinessLayer;
using com.fzd.Tutorship.WebLayer;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/// <summary>
/// 作用:对数据显示控件gridview进行分页显示
/// 作者:耿鸿飞
/// 日期:2006-6-22
/// </summary>
public partial class DB_test_CustomPaginAction : System.Web.UI.UserControl
{
/// <summary>
/// 页面控件传入 GridView
/// </summary>
public GridView CustomDataView;
/// <summary>
/// 每一页显示的记录条数。
/// </summary>
public int PageSize;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CustomDataView.AllowPaging = true;//允许gridview控件分页
CustomDataView.PageSize = PageSize;//每一页显示的记录条数设定
CustomDataView.PagerSettings.Visible = false;//显示分页的ui不让显示出来
// DataSet dr = CustomPaginAction.GetData(ProceName);//根据传入的存储过程名字来进行查询
DataSet dr = (DataSet)CustomDataView.DataSource;
CustomDataView.DataSource = dr;//gridview的数据源
CustomDataView.DataBind();//邦定
IsFirstLastPage();//判断上下首尾按键是否可用。
shouPage();//显前页和一共;//数据绑定
for (int index = 0; index < CustomDataView.PageCount; index++)//把页数夹道下拉菜单中。
{
ListItem ite = new ListItem();
ite.Text = "" + (index + 1);
ite.Value = "" + (index + 1);
GoToPage.Items.Add(ite);
}
}
}
/// <summary>
/// 显示数据的dataview
/// </summary>
/// <param name="proce">存储过程的名字</param>
private void BindDataDataview()
{
// DataSet dr = CustomPaginAction.GetData(ProceName);//根据传入的存储过程名字来进行查询
DataSet dr = (DataSet)CustomDataView.DataSource;
CustomDataView.DataSource = dr;//gridview的数据源
CustomDataView.DataBind();//邦定
IsFirstLastPage();//判断上下首尾按键是否可用。
shouPage();//显示当前页和一共多少页
for (int index = 0; index < GoToPage.Items.Count; index++)
{
GoToPage.Items[index].Selected = false;
}
GoToPage.Items[CustomDataView.PageIndex].Selected = true;
}
/// <summary>
/// 检验前后页可不可以操作
/// </summary>
private void IsFirstLastPage()
{
if (CustomDataView.PageCount > 0)//有数据
{
if (CustomDataView.PageCount != 1)
{
if (CustomDataView.PageIndex == 0)//当前页是第一页时首页和前页不可用
{
Prev.Enabled = false;
First.Enabled = false;
}
else
{
Prev.Enabled = true;
First.Enabled = true;
}
if (CustomDataView.PageIndex == CustomDataView.PageCount - 1)//当前页是最后一页时后页和尾页不可用
{
Nest.Enabled = false;
Last.Enabled = false;
}
else
{
Nest.Enabled = true;
Last.Enabled = true;
}
}
else//查询结果只有一页的话全不可用
{
Prev.Enabled = false;
Nest.Enabled = false;
First.Enabled = false;
Last.Enabled = false;
}
}
else//没有数据的话全不可用
{
First.Enabled = false;
Prev.Enabled = false;
Nest.Enabled = false;
Last.Enabled = false;
}
}
protected void CustomDataView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
CustomDataView.PageIndex = e.NewPageIndex + 1;
BindDataDataview();
}
/// <summary>
/// 点击翻页的方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void LinkButton_Click(object sender, EventArgs e)
{
String command = ((LinkButton)sender).Text;
switch (command)
{
case "首页":
{
CustomDataView.PageIndex = 0;
break;
}
case "前页":
{
CustomDataView.PageIndex = (int)Math.Max(0, CustomDataView.PageIndex - 1);
break;
}
case "后页":
{
CustomDataView.PageIndex = (int)Math.Min(CustomDataView.PageCount - 1, CustomDataView.PageIndex + 1);
break;
}
case "尾页":
{
CustomDataView.PageIndex = CustomDataView.PageCount - 1;
break;
}
}
BindDataDataview();
}
/// <summary>
/// 显示当前页数和一共多少页。
/// </summary>
private void shouPage()
{
Label1.Text = "第" + (CustomDataView.PageIndex + 1) + "页/共" + CustomDataView.PageCount + "页";
}
/// <summary>
/// 下拉菜单质改变时触发,显示相应的页。
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GoToPage_SelectedIndexChanged(object sender, EventArgs e)
{
CustomDataView.PageIndex = Convert.ToInt32(GoToPage.SelectedItem.Text) - 1;//把页数置为下拉菜单所选的数,因为页数是从0开始的,所以有-1
BindDataDataview();//重新绑定数据
}
}