伪静态分页

前台代码：

 

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="WebPage.ascx.cs" 
Inherits="MyUrlRewriter.WebPage" %>

<asp:Repeater ID="Repeater1" runat="server"
    onitemdatabound="Repeater1_ItemDataBound">
         <HeaderTemplate>
        <table>
        </HeaderTemplate>
        <ItemTemplate>
            <asp:Literal ID="Literal4" runat="server"></asp:Literal>
        </ItemTemplate>
        <FooterTemplate>
        </table>
        </FooterTemplate>
        </asp:Repeater>
        第<asp:Literal ID="Literal3" runat="server" Text="1">1</asp:Literal>页
        共<asp:Literal ID="Literal1" runat="server"></asp:Literal>条数据
        共<asp:Literal ID="Literal2" runat="server"></asp:Literal>页

        <br/>
        <asp:LinkButton ID="firstPage" runat="server" onclick="firstPage_Click">首页</asp:LinkButton>
        <asp:LinkButton ID="upPage" runat="server" onclick="firstPage_Click">上一页</asp:LinkButton>
        <asp:LinkButton ID="downPage" runat="server" onclick="firstPage_Click">下一页</asp:LinkButton>
        <asp:LinkButton ID="lastPage" runat="server" onclick="firstPage_Click">末页</asp:LinkButton>
        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
        onselectedindexchanged="DropDownList1_SelectedIndexChanged">
        </asp:DropDownList>

        <div id="pan1" runat="server"></div>

 

后台代码：

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Literal3.Text = Request.QueryString["index"] ?? "1";
                fenyeFuntion(Repeater1, DropDownList1, Literal1, Literal2, "select * from K_U_Special", ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            }
        }

        /// <summary>
        /// 伪静态分页
        /// </summary>
        /// <param name="repeater">Repeater数据绑定控件</param>
        /// <param name="dropDownList">下拉选择页</param>
        /// <param name="dataCount">数据总数</param>
        /// <param name="pageCount">数据页数总数</param>
        /// <param name="sqlstr">分页sql语句</param>
        /// <param name="connstr">数据库连接字符串</param>
        void fenyeFuntion(Repeater repeater,DropDownList dropDownList,Literal dataCount,Literal pageCount, string sqlstr,string connstr)
        {
            PagedDataSource page = new PagedDataSource();
            DataTable dt = SQLhelp.SqlDataAdapter(connstr, sqlstr, null).Tables[0];
            page.DataSource = dt.DefaultView;
            page.AllowPaging = true;
            page.PageSize = 5;
            dataCount.Text = Convert.ToString(page.DataSourceCount);
            pageCount.Text = Convert.ToString(page.PageCount);

            page.CurrentPageIndex = Convert.ToInt32(Literal3.Text.Trim()) - 1;

            repeater.DataSource = page;
            repeater.DataBind();

            if (page.IsFirstPage)
            {
                upPage.Enabled = false;
                firstPage.Enabled = false;
            }
            if (page.IsLastPage)
            {
                downPage.Enabled = false;
                lastPage.Enabled = false;
            }
            StringBuilder text = new StringBuilder();
            for (int i = 0; i < page.PageCount; i++)
            {
                if ((i + 1).ToString().Equals(Literal3.Text))
                {
                    text.Append("<a style=\"color:Red;margin-right:15px\" href=\"/web2/" + (i + 1) + "\">" + (i + 1) + "</a>");
                }
                else
                {
                    text.Append("<a style=\"margin-right:15px\" href=\"/web2/" + (i + 1) + "\">" + (i + 1) + "</a>");
                }
                dropDownList.Items.Add("第" + (i + 1) + "页");
            }
            
            pan1.InnerHtml = text.ToString();
            dropDownList.SelectedIndex = Convert.ToInt32(Request.QueryString["index"] ?? "1") - 1;


        }



        protected void firstPage_Click(object sender, EventArgs e)
        {
            LinkButton link = (LinkButton)sender;
            if (link.ID == "firstPage")
            {
                Response.Redirect("/web2/1");
            }
            else if (link.ID == "upPage")
            {
                int index = Convert.ToInt32(Literal3.Text) - 1;
                Response.Redirect("/web2/" + index + "");
            }
            else if (link.ID == "downPage")
            {
                int index = Convert.ToInt32(Literal3.Text) + 1;
                Response.Redirect("/web2/" + index + "");
            }
            else
            {
                Response.Redirect("/web2/" + Literal2.Text + "");
            }
        }

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            string index = Convert.ToString(DropDownList1.SelectedIndex + 1);
            Response.Redirect("/web2/" + index + "");
        }

        protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                DataRowView drv = e.Item.DataItem as DataRowView;
                if (e.Item.FindControl("Literal4") != null)
                {
                    Literal liter = e.Item.FindControl("Literal4") as Literal;
                    liter.Text += "<tr><td>" + drv["Title"].ToString() + "</td><td>" + drv["AddDate"].ToString() + "</td></tr>";
                }
            }
        }

 

 重写代码：

public void Init(HttpApplication context)
        {
            context.BeginRequest += new EventHandler(context_BeginRequest);
        }

        void context_BeginRequest(object sender, EventArgs e)
        {
            
            HttpApplication application = sender as HttpApplication;
            HttpContext content = application.Context;
           
            string url = content.Request.Url.LocalPath;
            if (url.Contains("new"))
            {
                string id = url.Substring(url.LastIndexOf("/") + 1);
                content.RewritePath("/news/new.aspx?id="+id);
            }
            else if (url.Contains("product"))
            {
                string id = url.Substring(url.LastIndexOf("/") + 1);
                content.RewritePath("/product/product.aspx?id=" + id);
            }
            else if (url.Contains("web2"))
            {
                string index = url.Substring(url.LastIndexOf("/") + 1);
                content.RewritePath("/web2.aspx?index=" + index);
            }
        }