AspNetPager分页控件之url重写

最新推荐文章于 2013-02-28 11:53:00 发布

最新推荐文章于 2013-02-28 11:53:00 发布 · 177 阅读

文章标签：

#HTML

.Net 专栏收录该内容

61 篇文章

订阅专栏

本文介绍如何在ASP.NET中使用分页控件AspNetPager实现动态页面的产品列表展示。根据URL参数设置分页样式，并根据不同的筛选条件（如标签或类型）调整SQL查询语句，确保正确的数据被加载到数据源控件。

type代表类型，pgid代表当前页码。

     int currentPageId = Convert.ToInt32(Request.QueryString["pgid"].ToString());
                 ViewState["currentPageId"] = currentPageId;
                if (Session["ptype"] == null)
                 {
                     Session["ptype"] = string.Empty;
                 }

                if (Request.QueryString["tag"] != null && Request.QueryString["tag"] != "")
                 {
                    this.AspNetPager1.UrlRewritePattern = "listproduct/tag_{tag}_pgid_{0}.html".Replace("{tag}", Request.QueryString["tag"]);
                    string tag = Server.HtmlDecode(Request.QueryString["tag"].ToString());
                     Session["Where"] = "proe.ProcTitle like '%" + tag + "%'";

                     txtProduceName.Text = tag;
                 }
                else if (Request.QueryString["type"] != null && Request.QueryString["type"] != "")
                 {
                    this.AspNetPager1.UrlRewritePattern = "listproduct/type_{type}_pgid_{0}.html".Replace("{type}", Request.QueryString["type"]);
                    string type = Request.QueryString["type"];
                    if (type.Equals("product")) //表示所有的产品类型
                     {
                         Session["Where"] = string.Empty;
                     }
                    else
                     {
                         Session["Where"] = " proe.ProductType like '" + type + "%'                         this.SelectThType1.Value = type;
                     }

一些属性需读者自己参考吴旗娃官方网址查阅。

1.上面的代码根据传过来的参数，然后指定分页控件的UrlRewritePattern。写在Page_Load里。

code

   protected void AspNetPager1_PageChanged(object src, EventArgs e)
     {
         AspNetPager1.CurrentPageIndex = Convert.ToInt32(ViewState["currentPageId"].ToString());
        this.PageDataBind();
     }

2.上面的代码是它的绑定数据的事件。

public void PageDataBind()
     {
        try
         {
            this.dlProducts.DataSource = null;
            if (Session["Where"] == null)
             {
                 Session["Where"] = "";
             }
            if (Session["Where"].ToString().Length > 0)
             {
                this.AspNetPager1.RecordCount = GetProduceSizeBySQL(Session["Where"].ToString());
             }
            else
             {
                this.AspNetPager1.RecordCount = GetProductSize();
             }

            string[] list = new string[] { "*", "Produce as proe inner join companyinfo as comp " +
        "on proe.UserId=comp.UserId ", Session["Where"].ToString(), "proe.Id ", " order by proe.SendTime   desc ", ViewState["currentPageId"].ToString(), "15" };

            //Response.Write(list.GetValue(0) + "___" + list.GetValue(1) + "___" + list.GetValue(2) + "___" + list.GetValue(3) + "___" + list.GetValue(4) + "___" + list.GetValue(5) + "___");

             AspNetPager1.CurrentPageIndex = Convert.ToInt32(ViewState["currentPageId"].ToString());
             dlProducts.DataSource = ProduceManage.GetProductsByProc(list);
             dlProducts.DataBind();
         }
        catch (Exception)
         {
         }
     }

3.上面的代码通过存储过程返回当前页的数据给数据源控件。

  <webdiyer:AspNetPager ID="AspNetPager1" CssClass="anpager" CurrentPageButtonClass="cpb"
                     PageSize="15" runat="server" HorizontalAlign="Center" Width="100%"
                     EnableUrlRewriting="true" UrlRewritePattern="listproduct/type_{type}_pgid_{0}.html"
                     OnPageChanged="AspNetPager1_PageChanged" FirstPageText="首页" LastPageText="尾页"
                    NextPageText="下一页" PrevPageText="上一页" CustomInfoHTML="第<font color='red'><b>%currentPageIndex%</b></font>页/共%PageCount%页    每页%PageSize%条/共/%RecordCount%条" ShowPageIndexBox="Always" ShowCustomInfoSection="Right" CustomInfoSectionWidth="250px">
                </webdiyer:AspNetPager>