asp.net分页-利用后台直接生成html分页

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› ASP.NET›ASP.NET编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

一直想做一个属于自己的分页，

1：我试过用datapage,虽然是很好用，但是必须要配合datalist才能使用，感觉不太好

2：自己写分页控件，目前正在摸索中，关键是怎么分页的问题，有的是用datatable传进去分页，感觉效率有点低

3：就是今天我使用的方法，存储过程+Div+css分页了

说明：本人是毕业半年的菜鸟，以下程序全是按照自己的想法来写的，原创勿喷，并请大神们给出指导，谢谢了。

1：建好存储过程

ALTER procedure [dbo].[p_news_query]
@Page int
as
begin
select top 5 new_id,new_title,new_url,new_content_text,create_time,user_name from 
 (select *,ROW_NUMBER() over(order by new_id desc ) as RowNumber   from
        (select new_id,new_title,new_url,new_content_text,
                dbo.f_ConvertDate(a.create_time) create_time, b.user_name from xs_new a
                left join xs_users b on b.user_no=a.create_user
)TI 
) A 
 where A.RowNumber>(@Page-1)*5

end

目前实验的是每页5条数据，传入当前页码就可以了

2：前台定义一个div ，用于显示

 <div id="divPage" runat="server" class="divpage">
    </div>

3：后台根据传入参数来拼html

目前是模仿博客园的模式，前后显示5条，多余的加...后到最后一条

StringBuilder sbr = new StringBuilder();
            int ITotalCount = pageLogic.QueryNewsCount();
            int IPage = 1;
            if (Request["p"] != null)
            {
                IPage = Convert.ToInt32(Request["p"]);
            }
            int IPageCount = 5;
            int ITotalPage = ITotalCount / IPageCount;
            if (ITotalCount % IPageCount > 0)
            {
                ITotalPage += 1;
            }

            if (IPage != 1)
            {
                sbr.Append("<a href=\"news.aspx?p=" + (IPage - 1).ToString() + "\">上一页</a>");
            }

            if (ITotalPage <= 10)
            {
                for (int i = 1; i <= ITotalPage; i++)
                {
                    if (i == IPage)
                    {
                        sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\" class=\"pageSelect\">" + i.ToString() + "</a>");
                    }
                    else
                    {
                        sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\">" + i.ToString() + "</a>");
                    }
                }
            }
            else
            {

                if (IPage - 5 > 2 && IPage + 7 < ITotalPage)//前后都有的
                {
                    sbr.Append("<a href=\"news.aspx?p=1\">1</a>...");
                    for (int i = IPage - 5; i <= IPage + 5; i++)
                    {
                        if (i == IPage)
                        {
                            sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\" class=\"pageSelect\">" + i.ToString() + "</a>");
                        }
                        else
                        {
                            sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\">" + i.ToString() + "</a>");
                        }

                    }
                    sbr.Append("...<a href=\"news.aspx?p=" + ITotalPage.ToString() + "\">" + ITotalPage.ToString() + "</a>");

                }
                else if (IPage - 5 <= 2)//前面不够，后面有多余
                {
                    for (int i = 1; i <= 10; i++)
                    {
                        if (i == IPage)
                        {
                            sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\" class=\"pageSelect\">" + i.ToString() + "</a>");
                        }
                        else
                        {
                            sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\">" + i.ToString() + "</a>");
                        }
                    }
                    sbr.Append("...<a href=\"news.aspx?p=" + ITotalPage.ToString() + "\">" + ITotalPage.ToString() + "</a>");
                }
                else if (IPage + 7 >= ITotalPage)//前面多余，后面不足
                {
                    sbr.Append("<a href=\"news.aspx?p=1\">1</a>...");
                    for (int i = ITotalPage - 10; i <= ITotalPage; i++)
                    {
                        if (i == IPage)
                        {
                            sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\" class=\"pageSelect\">" + i.ToString() + "</a>");
                        }
                        else
                        {
                            sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\">" + i.ToString() + "</a>");
                        }
                    }

                }

            }
            if (IPage != ITotalPage)
            {
                sbr.Append("<a href=\"news.aspx?p=" + (IPage + 1).ToString() + "\">下一页</a>");
            }
            divPage.InnerHtml = sbr.ToString();
            rptNews.DataSource = pageLogic.QueryNews(IPage);
            rptNews.DataBind();