将分页作为一个单独的控件

namespace Web.enterprise.modules
{
 using System;
 using System.Data;
 using System.Drawing;
 using System.Web;
 using System.Web.UI.WebControls;
 using System.Web.UI.HtmlControls;

 /// <summary>
 ///  Page 的摘要说明。
 /// </summary>
 public class PageList : System.Web.UI.UserControl
 {

  private const int MAX_PAGE = 5;

  private string _url;
  private int _currentPage;
  private int _pageCount;
  private int _base = 0;

  protected System.Web.UI.WebControls.Label lblNoCount;
  protected System.Web.UI.WebControls.Label lblPageNum;
  protected System.Web.UI.WebControls.Label lblList;
  protected System.Web.UI.WebControls.Label linkNext;
  protected System.Web.UI.WebControls.Label linkPervious;
  

  /// <summary>
  ///  连接的Url,不包括分页的连接
  /// </summary>
  public string Url
  {
   get
   {
    return _url;
   }
   set
   {
    _url = value;
   }
  }

  /// <summary>
  ///  当前的页
  /// </summary>
  public int CurrentPage
  {
   get
   {
    return _currentPage;
   }
   set
   {
    _currentPage = value;
   }
  }

  /// <summary>
  ///  总的页数
  /// </summary>
  public int PageCount
  {
   get
   {
    return _pageCount;
   }
   set
   {
    _pageCount = value;
   }
  }

       //初始化第1页的值为0
  public int PageBase
  {
   get
   {
    return _base;
   }
   set
   {
    if (value !=0 )
    {
     _base = 1;
    }
    else
    {
     _base = 0;
    }
   }
  }

  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面

   if ( !IsPostBack )
   {
    InitPage();
   }

  }

 

  #region 分页
  public void InitPage(  )
  {
   //总的页数
   linkPervious.Visible = false;
   linkNext.Visible = false;
   lblList.Visible = false;
   lblPageNum.Visible = false;

   if( PageCount>0 )
   {
    linkPervious.Visible=true;
    linkNext.Visible=true;
    lblList.Visible = true;

    lblPageNum.Visible = true;

    lblNoCount.Visible = false;

   
    //如果当前页已经超出了总的页数，设置为最后一页
    if( _currentPage >= _pageCount )
    {
     _currentPage = _pageCount - 1 ;
    }

    //如果当前页小于0，则设置为第一页
    if( _currentPage<_base )
    {
     _currentPage= _base;
    }

    //最后一页不显示下一页的连接
    if ( _currentPage == _pageCount -1)
    {
     linkNext.Visible= false;
    }

    //第一页不显示上一页的连接
    if ( _currentPage == _base )
    {
     linkPervious.Visible = false;
    }
   
    //初始化页导航
    string listtext="";

    //要求仅显示10个页码
    int minPage=_currentPage-MAX_PAGE;
    int maxPage=_currentPage+MAX_PAGE;
                 
    //如果最小的页数已经少于0则初始化为0
    if( minPage < _base )
    {
     minPage = _base;

     //一开始也显示10个
     maxPage = MAX_PAGE * 2;
    }

    //如果最大的页数已经超过了总页数，则初始化为总页数
    if( maxPage > _pageCount )
    {
     maxPage = _pageCount  ;

     //后来显示10个
     if(  _pageCount >=  ( MAX_PAGE * 2) )
     {
      minPage =_pageCount - ( MAX_PAGE * 2) ;
     }
     
    }

    //循环显示列表
    for( int i=minPage ; i<= maxPage - 1;i++ )
    {
     if( i == _currentPage )
     {
      if (_base==0)
      {
       listtext=listtext+" <span class='CurrentPage'>" + ( i + 1 ) + "</span>";
      }
      else
      {
       listtext=listtext+" <span class='CurrentPage'>" + i + "</span>";
      }
     }
     else
     {
      if ( _base == 0 )
      {
       listtext=listtext+" "+"<a class='PageList' href='" + SetPage(i) + "'>" +(i+1)+ "</a>";
      }
      else
      {
       listtext=listtext+" "+"<a class='PageList' href='" + SetPage(i) + "'>" +i+ "</a>";
      }
     }

    }

    lblList.Text =listtext;

    linkPervious.Text = "<a class='PageList' href='" + SetPage(_currentPage-1) + "'>上一页</a>";
    linkNext.Text = "<a class='PageList' href='" + SetPage(_currentPage+1) + "'>下一页</a>";

    lblPageNum.Text = "第" + Convert.ToString(_currentPage+1)+"/" + PageCount + "页";
   }
   else
   {
    lblNoCount.Visible = true;
   }

 

  }

  private string SetPage( int page )
  {
   string retString = _url;

   retString = _url + "CurrentPage=" + page;

   return retString;
  }

  #endregion

  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  ///  设计器支持所需的方法 - 不要使用代码编辑器
  ///  修改此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion
 }
}

 

--zhangww 20060816 获取企业收藏的简历 enterprise/EnterpriseResumeManage/talentstorage.aspx
--维护内容：获取获取企业收藏的简历的数据
--维护人：jiangf  维护时间：20070625
CREATE     procedure Proc_Enterprise_Get_CustomerCollection_By_CID

(
 @CID int,
 @CurrentPage int,   --当前页数，从0开始
 @PageSize int,  --每页的数量
 @RecordCount int out, --记录数
 @PageCount int out  --页数
)

as

 declare @FieldList nvarchar(4000)
 declare @where nvarchar(4000)

set @FieldList='CCID,ResumeID,CustomerCollectionTab.Lng,
 (select top 1  PerName from PerCustomerInfoTab where PerID in ( select PerID from PerCustomerResumeTab where ResumeID = CustomerCollectionTab.ResumeID)) as PerName,
 dbo.GetSexByID( (select top 1  PerSex from PerCustomerInfoTab where PerID in ( select PerID from PerCustomerResumeTab where ResumeID = CustomerCollectionTab.ResumeID)) ) as PerSex,
 dbo.GetDegreeByID( (select top 1  PerDegree from PerCustomerInfoTab where PerID in ( select PerID from PerCustomerResumeTab where ResumeID = CustomerCollectionTab.ResumeID)) ) as PerDegree,
 (select top 1 dbo.GetPosition(PurPosition) from PerCustomerPurposeTab where CustomerCollectionTab.ResumeID = PerCustomerPurposeTab.ResumeID ) as  PositionName
'
set @where = 'ResumeID is not null and status = 1 and CID = ' + cast( @CID as nvarchar(1000))

 exec CrmPageGetPagesByMoreField
 @FieldList,
 'CustomerCollectionTab', 
 @where, 
 'CCreateDateTime desc , CCID desc', 
 'CCID', 
 @CurrentPage,   
 @PageSize,    
 @RecordCount out,  
 @PageCount out
GO

 

 

private int  CurPage = 0;  //当前页码
  private string strCurPage="";   //定义一个获取当前页码的变量
  private int RecodNum,PageNum;   //定义总记录数和总页数
  private int  PageSize = 12;          //定义每页显示的站点/记录数

EnterpriseCustomerResumeDownLoadData DownLoadData = ( new EnterpriseResumeDownLoadFacade()).GetCustomerResumeDownLoad( intCompanyID,CurPage ,PageSize ,out  RecodNum ,out PageNum);

public EnterpriseCustomerResumeDownLoadData GetCustomerResumeDownLoadData( int aCID ,int nStart,int nMaxCount , out int recordPage , out int pageNum )
  {
   EnterpriseCustomerResumeDownLoadData ds = new EnterpriseCustomerResumeDownLoadData( );
   dataConn = new SqlConnection(strConn);
   dataConn.Open();
   myCommand = new SqlCommand("Proc_Enterprise_Get_CustomerResumeLoad_By_CID",dataConn);
   myCommand.CommandType = CommandType.StoredProcedure;
   try
   {
    myCommand.Parameters.Add(new SqlParameter( "@CID" , SqlDbType.NVarChar , 3000 ));
    myCommand.Parameters.Add(new SqlParameter( "@CurrentPage" , SqlDbType.Int , 4 ));
    myCommand.Parameters.Add(new SqlParameter( "@PageSize" , SqlDbType.Int , 4 ));
    myCommand.Parameters.Add(new SqlParameter( "@RecordCount" , SqlDbType.Int , 4 ));
    myCommand.Parameters.Add(new SqlParameter( "@PageCount" , SqlDbType.Int , 4 ));

    myCommand.Parameters[0].Value = aCID ;
    myCommand.Parameters[1].Value = nStart ;
    myCommand.Parameters[2].Value = nMaxCount ;
    myCommand.Parameters[3].Direction = ParameterDirection.Output ;
    myCommand.Parameters[4].Direction = ParameterDirection.Output ;
   }
   catch(Exception error)
   {
    throw new Exception( error.Message , error );
   }
   this.sqlDataAdapter.SelectCommand = myCommand ;
   try
   {
    sqlDataAdapter.Fill( ds ,"CustomerResumeDownLoadTab");
   }
   catch(Exception error)
   {
    throw new Exception( error.Message , error );
   }
   recordPage = Convert.ToInt32( myCommand.Parameters[ "@RecordCount" ].Value );
   pageNum = Convert.ToInt32( myCommand.Parameters[ "@PageCount" ].Value );
   //返回 ds
   return ds;
  }

 

分页存储过程

CREATE  proc dbo.CrmPageGetPagesByMoreField
 @FieldList nvarchar( 3000 ), --取出的列
 @TableName nvarchar( 1000 ), --表名
 @Filter  nvarchar( 3000 ), --搜索条件
 @OrderList nvarchar( 3000 ), --排序字段 , 按主键顺序排列
 @KeyName nvarchar( 200 ), --主键的字段名称
 @CurrentPage int,   --当前页，从0开始
 @PageSize int,   --每页的页数  
 @RecordCount int out,  --总的记录数
 @PageCount int out   --总的页数
as
 Declare @sqlStr nvarchar( 4000 ) --查询语句

 Declare @strGetRecordCount nvarchar(4000)--得到记录数的语句

 --如果没有指定@Filter , 用一个恒定表达式
 if @Filter = ''
 begin
  set @Filter = ' 1 > 0 '
 end
 
 set @strGetRecordCount = 'select @RecordCount = count( distinct '+ @KeyName + ') from ' + @TableName + ' where ' + @Filter
 exec sp_executesql  @strGetRecordCount ,
    N'@RecordCount int out',
    @RecordCount out

 if @PageSize = -1
 begin
  set @PageSize = @RecordCount
 end
 
 --取出总的页数
 if @RecordCount !=0
 begin
  set @PageCount = ceiling( @RecordCount*1.0 / @PageSize )
 end
 else
 begin
  set @PageCount = 0
 end

 if @PageCount != 0
 begin
  if  @CurrentPage >= @PageCount
  begin
   set @CurrentPage = @PageCount -1
  end
 end

 --如果没有指定取出多少列，则取出所有的
 if @FieldList = ''
 begin
  set @FieldList = ' * '
 end

 if @OrderList = ''
 begin
  set @OrderList = @KeyName + ' asc '
 end

 if @RecordCount > 0
 begin
  set @sqlStr = ' select top ' + Convert( nvarchar( 50 ) , @PageSize )+ @FieldList + ' from ' + @TableName
 
  set @sqlStr = @sqlStr + ' where ' + @KeyName + ' not in ' + ' ( select top ' + Convert( nvarchar( 50 ) , @PageSize * @CurrentPage ) + @KeyName + ' from ' + @TableName + ' where ' + @Filter + ' order by ' + @OrderList + ' ) and ' + @Filter + ' order by ' +  @OrderList
 end
 else
 begin
  set @sqlStr= ' select top ' +  Convert( nvarchar( 50 ) , @PageSize )+ ' '+ @FieldList + '  from ' + @TableName +  ' where ' + @Filter  + ' order by ' +  @OrderList
 end

 print @sqlStr
 exec( @sqlStr )
GO

 

CREATE   proc dbo.Proc_Flink_Get_flinks_BySearchCondition
--进行前台和后台的搜索
--default 表示默认的排序方式
--xyy
--20061219
--exec Proc_Flink_Get_flinks_BySearchCondition '1>0 ' , '( select count(*) from FlinkSiteTab x where charindex( '',903,'', '','' + PartSite + '','' ) > 0 and x.Siteid = FlinkSiteTab.Siteid ) desc', 0 , 110 , null , null
 --@ShowType int,    --0：不补充，1：进行补充
 @where    nvarchar(3000), --where条件
 @orderby  nvarchar(3000), --order by条件
 @CurrentPage int,   --当前页数，从0开始
 @PageSize int,  --每页的数量
 @RecordCount int out, --记录数
 @PageCount int out  --页数
as
 declare @FieldList nvarchar(3000) --列表
 declare @tableName nvarchar(500) --表名

 set @FieldList = '[Siteid]  ,   
  [Sitename]  ,   
  [Siteurl]  ,   
  [LogoSrc],   
  [Imgsrc]  ,   
  [Level],
  Status,
  [PartSite] , 
  dbo.GetPartSiteNameByMoreSiteID([PartSite]) as PartSiteName,
  [FlinkPosition],
  dbo.GetFlinkPosition([FlinkPosition]) as FlinkPositionName,
   ( select SiteTypeName from FlinkSiteTypeTab where SiteTypeID = FlinkSiteTab.Sitetype) as SiteTypeName ,
  case [Type ] when 0 then ''文字链接'' when 1 then ''图片链接'' when 2 then ''不限'' End as TypeName,
  case [Status] when 0 then ''未审核'' when 1 then ''已审核'' else ''未审核'' End as StatusName, 
  [Applytime]  ,    
  [Starttime],    
  [LastRanking] ,   
  [CurrentRanking],
  (LastRanking - CurrentRanking) as SubRanking,
  [Description], 
  [AlexaRank],
  [PageRank],
  
  AllInHit,  
  AllOutHit,  
  TodayInHit,
  TodayOutHit,
  YesterDayInHit,
  YesterDayOutHit,
  (cast( AllInHit as float) / cast( datediff( dy , StartTime , getDate()) + 1 as float) ) as AvgInHit , 
  (cast( AllOutHit as float) / cast( datediff( dy , StartTime , getDate()) + 1 as float) ) as AvgOutHit,
  LastInTime , 
  LastOutTime  
 '

 set @tableName = ' FlinkSiteTab '

 --得到默认的排序方式

 set @orderby = dbo.GetFlinkOrder(@orderby)

 exec CrmPageGetPagesByMoreField
 @FieldList,
 @tableName, 
 @where, 
 @orderby, 
 'Siteid', 
 @CurrentPage,   
 @PageSize,    
 @RecordCount out,  
 @PageCount out
GO

private void btnDeleteLog_Click(object sender, System.EventArgs e)
  {
   LogFacade lofInfo = new LogFacade();
   bool isleag = false;
   int Num = 0 ;
   System.Web.UI.WebControls.CheckBox chkExport;
   foreach(DataListItem listItem in dlLog.Items)
   {
    chkExport = (CheckBox)listItem.FindControl("ChkAll");
    if(chkExport.Checked)
    {
     Num++;
     int logID = Convert.ToInt32( this.dlLog.DataKeys[listItem.ItemIndex] );
     isleag = lofInfo.DeleteLog( logID );
    }
   }
   if( Num==0 )
   {
    Response.Write("<script>alert('请选择要删除的数据！')</script>");
   }
   else if( Num>=1 )
   {
    if( isleag )
    {
     Response.Write("<script>alert('成功删除数据！')</script>");
     ShowList();
    }
    else
    {
     Response.Write("<script>alert('删除失败！')</script>");
    }
   }
  }

 

private void btnAll_Click(object sender, System.EventArgs e)
  {
   System.Web.UI.WebControls.CheckBox chkExport;
   if(btnAll.Text == "全选")
   {
    foreach(DataListItem listItem in dlLog.Items)
    {
     try
     {
      chkExport = (CheckBox)listItem.FindControl("ChkAll");
      chkExport.Checked = true ;
     }
     catch(Exception error)
     {
      throw new Exception(error.Message , error);
     }
    }
    btnAll.Text = "全消";
   }
   else
   {
    foreach(DataListItem listItem in dlLog.Items)
    {
     try
     {
      chkExport = (CheckBox)listItem.FindControl("ChkAll");
      chkExport.Checked = false ;
     }
     catch(Exception error)
     {
      throw new Exception(error.Message , error);
     }
    }
    btnAll.Text = "全选";
   }
  }

 

public bool DeleteLog(int logID)
  {
   deleteCommand = new SqlCommand("ProcAdminLogDelete",dataConn);
   deleteCommand.CommandType = CommandType.StoredProcedure;
   SqlParameterCollection sqlParams = deleteCommand.Parameters;

   //向存储过程中传递参数。
   SqlParameter parameterUserID = new SqlParameter( "@ID", SqlDbType.Int,4 );
   parameterUserID.Value = logID;
   deleteCommand.Parameters.Add( parameterUserID );

   dataConn.Open( );
   int result= deleteCommand.ExecuteNonQuery( );
   if( result==0 )
   {
    return false;
   }
   else
   {
    return true;
   }
  }