asp.net Repeater之非常好的數(shù)據(jù)分頁
2024-07-10 12:38:37
供稿：網(wǎng)友
分頁控件源代碼如下：
代碼如下:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Collections;
#region Assembly Resource Attribute
[assembly: System.Web.UI.WebResource("WebControlLibrary.Js.AjaxHelper.js", "text/javascript")]
[assembly: System.Web.UI.WebResource("WebControlLibrary.img.bg_pager.png", "image/gif")]
#endregion
namespace WebControlLibrary
{
/// <summary>
/// Repeater分頁控件可進(jìn)行Ajax分頁(但Ajax分頁不能傳參數(shù))
/// </summary>
[DefaultProperty("Text")]
[ToolboxData("<{0}:RepeaterPages runat=server></{0}:RepeaterPages>")]
public class RepeaterPages : WebControlLibrary.Repeater
{
// <summary>
/// 構(gòu)造函數(shù)
/// </summary>
public RepeaterPages()
: base()
{
}
/// <summary>
/// 下一頁分頁文本內(nèi)容
/// </summary>
private string _NextPage = ">";
/// <summary>
/// 下一頁標(biāo)記
/// </summary>
[Bindable(false), Description("下一頁標(biāo)記所顯示的文本內(nèi)容")]
public string NextPage
{
get { return _NextPage; }
set { _NextPage = value; }
}
/// <summary>
/// 下一頁標(biāo)記
/// </summary>
private string _LastPage = "<";
/// <summary>
/// 上一頁標(biāo)記
/// </summary>
[Bindable(false), Description("上一頁標(biāo)記所顯示的文本內(nèi)容")]
public string LastPage
{
get { return _LastPage; }
set { _LastPage = value; }
}
/// <summary>
/// 總記錄數(shù)屬性
/// </summary>
private int _RecordCount;
/// <summary>
/// 頁面分頁大小屬性
/// </summary>
private int _PageSize;
/// <summary>
/// 當(dāng)前頁數(shù)
/// </summary>
private int _CurrentPage;
/// <summary>
/// 返回總頁面
/// </summary>
private int _AllPages;
/// <summary>
/// 頁面地址
/// </summary>
private string _Url;
/// <summary>
/// 傳入Sql語句
/// </summary>
private string _SqlString;
/// <summary>
/// 每頁顯示頁碼數(shù)
/// </summary>
private int _PageNumberCount;
/// <summary>
/// 數(shù)據(jù)庫中顯示的字段列表
/// </summary>
private string _ShowTableCollName;
/// <summary>
/// 記錄數(shù)屬性
/// </summary>
[Bindable(true), Category("Appearance"), DefaultValue("0")]
private int RecordCount
{
get
{
int IntTempValue = 0;
if (Int32.TryParse(Sql_Function.SqlDb.RecordCounts(SqlString), out IntTempValue))
return IntTempValue;
else
return 0;
}
set
{
_RecordCount = value;
}
}
/// <summary>
