aspnetpager分页控件源码

 

自定义设置格式化代码：
                            <webdiyer:AspNetPager id="AspNetPagerView" runat="server" SubmitButtonText="转到" ShowPageIndex="False"
                                ShowInputBox="Always" LastPageText="<font style='FONT-SIZE: x-small'>最后页</fornt>" NextPageText="<font style='FONT-SIZE: x-small'>下一页</fornt>"
                                PrevPageText="<font style='FONT-SIZE: x-small'>前一页</fornt>" FirstPageText="<font style='FONT-SIZE: x-small'>最前页</fornt>"
                                InputBoxStyle="border:1px #0000FF solid;text-align:center;FONT-SIZE: x-small" TextBeforeInputBox="第"
                                TextAfterInputBox="页" ShowCustomInfoSection="Right" AlwaysShow="True" CustomInfoTextAlign="Center"
                                SubmitButtonStyle="width:40px;height:21px;"></webdiyer:AspNetPager>
后台使用代码：
        private void Page_Load(object sender, System.EventArgs e)
        ...{
            if(!Page.IsPostBack)
            ...{
                this.sqlCmd=new System.Data.SqlClient.SqlCommand("SP_AspNetPager_Meeting",this.sqlConn);
                this.sqlCmd.CommandType=CommandType.StoredProcedure;
                this.sqlCmd.Parameters.Add("@pageindex",1);
                this.sqlCmd.Parameters.Add("@pagesize",1);
                this.sqlCmd.Parameters.Add("@docount",true);
                this.sqlConn.Open();
                this.AspNetPagerView.RecordCount=(int)this.sqlCmd.ExecuteScalar();
                this.sqlConn.Close();

                this.SetBindData();
            }
        }

        private void SetBindData()
        ...{
            this.sqlCmd=new SqlCommand("SP_AspNetPager_Meeting",this.sqlConn);
            this.sqlCmd.CommandType=CommandType.StoredProcedure;
            this.sqlCmd.Parameters.Add("@pageindex",this.AspNetPagerView.CurrentPageIndex);
            this.sqlCmd.Parameters.Add("@pagesize",this.AspNetPagerView.PageSize);
            this.sqlCmd.Parameters.Add("@docount",false);
            this.sqlConn.Open();
            this.dg.DataSource=this.sqlCmd.ExecuteReader();
            this.dg.DataBind();
            this.sqlConn.Close();

            this.AspNetPagerView.CustomInfoText=" 当前页：<font color="red"><b>"+this.AspNetPagerView.CurrentPageIndex.ToString()+"</b></font>";
            this.AspNetPagerView.CustomInfoText+=" 总页数：<font color="blue"><b>"+this.AspNetPagerView.PageCount.ToString()+"</b></font>";
            this.AspNetPagerView.CustomInfoText+=" 记录总数：<font color="blue"><b>"+this.AspNetPagerView.RecordCount.ToString()+"</b></font>";
        }

        private void AspNetPagerView_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
        ...{
            this.AspNetPagerView.CurrentPageIndex=e.NewPageIndex;

            this.SetBindData();

            System.Text.StringBuilder sb=new System.Text.StringBuilder("<script Language="Javascript"><!-- ");
            sb.Append("var el=document.all;");
            sb.Append(dg.ClientID);
            sb.Append(".scrollIntoView(true);");
            sb.Append("<");
            sb.Append("/");
            sb.Append("script>");
            if(!Page.IsStartupScriptRegistered("scrollScript"))
                Page.RegisterStartupScript("scrollScript",sb.ToString()); 
        }
存储过程：
CREATE procedure SP_AspNetPager_Meeting
(@pagesize int,
@pageindex int,
@docount bit)
as
set nocount on
if(@docount=1)
select count(id) from Meeting
else
begin
declare @indextable table(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
insert into @indextable(nid) select id from Meeting order by id asc
select O.* from Meeting O,@indextable t where O.id=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
end
set nocount off
GO