asp.net分页（一）

 

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

/// <summary>
/// WJ_Page 的摘要说明
/// </summary>
    public class WJ_Page
     {
      #region 定义变量

         protected string Conmad;       //查询的字段
         protected string Conditions;   //查询的条件和查询的表
         protected string OrderBy;      //查询的条件和查询的表
         protected string OrderBy2;     //查询的条件和查询的表
         public string EX_Sql;          //要执行的SQL
         protected string RequestString;//HtmlRequest字段
         protected string pageonstr;

         protected string MainKeyName;     //区分键名称
         /// <summary>
         /// 返回字符类型的 当前页数
         /// </summary>
         public string PageOn;      //当前页
         /// <summary>
         /// 返回整形的 当前页面
         /// </summary>
         public int n_PageOn;
         /// <summary>
         /// 返回字符类型的 当前记录数
         /// </summary>
         public string Count;       //记录数
         /// <summary>
         /// 返回整形的 当前记录数
         /// </summary>
         public int n_Count;
         /// <summary>
         /// 返回字符类型的 每页显示的记录数
         /// </summary>
         public string PageSize;
         /// <summary>
         /// 返回整形的 每页显示的记录数
         /// </summary>
         public int n_PageSize;
         /// <summary>
         /// 返回字符类型的 最大页码数
         /// </summary>
         public string MaxPage;
         /// <summary>
         /// 返回整形的 最大页码数
         /// </summary>
         public int n_MaxPage;
         /// <summary>
         /// 返回要绑定的数据视图
         /// </summary>
         public DataView WJ_DataView;
         /// <summary>
         /// 返回已经打开的数据库连接对象
         /// </summary>
         public SqlConnection WJ_Conn;
         /// <summary>
         /// 返回上一页的连接
         /// </summary>
         public string PreviousPageUrl;
         /// <summary>
         /// 返回下一页的连接
         /// </summary>
         public string NextPageUrl;
         /// <summary>
         /// 返回首页的连接
         /// </summary>
         public string FirstPageUrl;
         /// <summary>
         /// 返回尾页的连接
         /// </summary>
         public string LastPageUrl;

         /// <summary>
         /// 除了分页pageon=   外的连接部分
         /// </summary>
         public string Linkstr;
         /// <summary>
         /// 返回数据集
         /// </summary>
         public SqlDataReader wj_rs;
         #endregion
      #region 类加载函数

         /// <summary>
         /// 查询分页类 默认识别字段 为 ID 大小写不区分
         /// 如果你查询的表中不存在自动编号的 ID 或 自动编号的字段不是 ID， 必须填写 MKeyName
         /// </summary>
         /// <param name="Sqlstr">查询语句</param>
         /// <param name="Connection">数据库连接对象</param>
         /// <param name="Request">请求URL对象</param>
         /// <param name="Psize">每页显示的记录数</param>
         public WJ_Page(string Sqlstr, SqlConnection Connection, HttpRequest Request, int Psize)
         {
             Conmad = "";
             Conditions = "";
             OrderBy = "";
             Count = "0";
             MainKeyName = "id";
             n_PageSize = Psize;
             PageSize = n_PageSize.ToString();
             WJ_Conn = Connection;
             pageonstr = "";
             RequestString = Request.QueryString.ToString();
             SetPage(Sqlstr, Request);

             SetPageUrl();
         }
         /// <summary>
         /// 查询分页类 默认识别字段 为 ID 大小写不区分
         /// 如果你查询的表中不存在自动编号的 ID 或 自动编号的字段不是 ID， 必须填写 MKeyName
         /// </summary>
         /// <param name="Sqlstr">查询语句</param>
         /// <param name="MKeyName">识别关键字段 如自动编号的字段 用来区分每条记录不同的字段</param>
         /// <param name="Connection">数据库连接对象</param>
         /// <param name="Request">请求URL对象</param>
         /// <param name="Psize">每页显示的记录数</param>
         public WJ_Page(string Sqlstr, string MKeyName, SqlConnection Connection, HttpRequest Request, int Psize)
         {
             Conmad = "";
             Conditions = "";
             OrderBy = "";
             Count = "0";
             MainKeyName = MKeyName.ToLower();
             n_PageSize = Psize;
             PageSize = n_PageSize.ToString();
             WJ_Conn = Connection;
             pageonstr = "";
             RequestString = Request.QueryString.ToString();

             SetPage(Sqlstr, Request);
             SetPageUrl();

         }

         /// <summary>
         /// 查询分页类 默认识别字段 为 ID 大小写不区分
         /// 如果你查询的表中不存在自动编号的 ID 或 自动编号的字段不是 ID， 必须填写 MKeyName
         /// </summary>
         /// <param name="Sqlstr">查询语句</param>
         /// <param name="ConnectionString">数据库连接字符串</param>
         /// <param name="Request">请求URL对象</param>
         /// <param name="Psize">每页显示的记录数</param>
         public WJ_Page(string Sqlstr, string ConnectionString, HttpRequest Request, int Psize)
         {
             Conmad = "";
             Conditions = "";
             OrderBy = "";
             Count = "0";
             MainKeyName = "id";
             n_PageSize = Psize;
             pageonstr = "";
             PageSize = n_PageSize.ToString();
             WJ_Conn = new SqlConnection(ConnectionString);
             RequestString = Request.QueryString.ToString();

             SetPage(Sqlstr, Request);
             SetPageUrl();

         }
         /// <summary>
         /// 查询分页类 默认识别字段 为 ID 大小写不区分
         /// 如果你查询的表中不存在自动编号的 ID 或 自动编号的字段不是 ID， 必须填写 MKeyName
         /// </summary>
         /// <param name="Sqlstr">查询语句</param>
         /// <param name="MKeyName">识别关键字段 如自动编号的字段 用来区分每条记录不同的字段</param>
         /// <param name="ConnectionString">数据库连接字符串</param>
         /// <param name="Request">请求URL对象</param>
         /// <param name="Psize">每页显示的记录数</param>
         public WJ_Page(string Sqlstr, string MKeyName, string ConnectionString, HttpRequest Request, int Psize)
         {
             Conmad = "";
             Conditions = "";
             OrderBy = "";
             Count = "0";
             MainKeyName = MKeyName.ToLower();
             n_PageSize = Psize;
             pageonstr = "";
             PageSize = n_PageSize.ToString();
             WJ_Conn = new SqlConnection(ConnectionString);
             RequestString = Request.QueryString.ToString();

             SetPage(Sqlstr, Request);
             SetPageUrl();

         }

         /// <summary>
         /// 查询分页类 默认识别字段 为 ID 大小写不区分
         /// 如果你查询的表中不存在自动编号的 ID 或 自动编号的字段不是 ID， 必须填写 MKeyName
         /// </summary>
         /// <param name="Sqlstr">查询语句</param>
         /// <param name="Request">请求URL对象</param>
         /// <param name="Psize">每页显示的记录数</param>
         /// <param name="AppSettings_SQLDB_KeyName">Web.Config里SQL数据库连接的 key</param>
         public WJ_Page(string Sqlstr, HttpRequest Request, int Psize, string AppSettings_SQLDB_KeyName)
         {
             Conmad = "";
             Conditions = "";
             OrderBy = "";
             Count = "0";
             MainKeyName = "id";
             n_PageSize = Psize;
             PageSize = n_PageSize.ToString();
             WJ_Conn = new SqlConnection(ConfigurationManager.AppSettings[AppSettings_SQLDB_KeyName]);
             pageonstr = "";
             RequestString = Request.QueryString.ToString();

             SetPage(Sqlstr, Request);
             SetPageUrl();
         }
         /// <summary>
         /// 查询分页类 默认识别字段 为 ID 大小写不区分
         /// 如果你查询的表中不存在自动编号的 ID 或 自动编号的字段不是 ID， 必须填写 MKeyName
         /// </summary>
         /// <param name="Sqlstr">查询语句</param>
         /// <param name="MKeyName">识别关键字段 如自动编号的字段 用来区分每条记录不同的字段</param>
         /// <param name="Request">请求URL对象</param>
         /// <param name="Psize">每页显示的记录数</param>
         /// <param name="AppSettings_SQLDB_KeyName">Web.Config里SQL数据库连接的 key</param>
         public WJ_Page(string Sqlstr, string MKeyName, HttpRequest Request, int Psize, string AppSettings_SQLDB_KeyName)
         {
             Conmad = "";
             Conditions = "";
             OrderBy = "";
             Count = "0";
             MainKeyName = MKeyName.ToLower();
             n_PageSize = Psize;
             PageSize = n_PageSize.ToString();
             WJ_Conn = new SqlConnection(ConfigurationManager.AppSettings[AppSettings_SQLDB_KeyName]);
             pageonstr = "";
             RequestString = Request.QueryString.ToString();

             SetPage(Sqlstr, Request);
             SetPageUrl();

         }
        #endregion
 

 

转载自http://hi.baidu.com/wj354/blog/item/1ad30d10ee7b01fdc3ce79a7.html