weidu.aspx.cs

基于VS05和SQL05做的一个电子商务网站

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class MyInfo_weidu : System.Web.UI.Page
{
    public static int TotalPage;//定义变量来保存总页数
    public int CurPage;//定义变量来保存当前页索引
    public int Tnum;//总条数;
    public int EachPage;//每页总条数
    //数据库连接的类
    public string sid;

    SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"]);
    protected void Page_Load(object sender, EventArgs e)
    {
        ListBind();
    }
    ICollection CreateSource()
    {
     
        string username = Session["username"].ToString();
        string sql = "select * from tells where incepter='" + username + "' and islook='否'";
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(sql, conn);
        conn.Open();
        da.Fill(ds, "mytable");
        if (ds.Tables["mytable"].DefaultView.Count <= 0)
        {
            Repeater1.Visible = false;
            //Response.Write("<br/><br/><br/><br/>没有未读的信件!!");
            return null;
        }
        else
        {
            return ds.Tables["mytable"].DefaultView;
        }
    }
    public void ListBind()
    {
        PagedDataSource objPage = new PagedDataSource();//创建分页类
        objPage.DataSource = CreateSource();//设置数据源

        if (objPage.DataSource == null)
        {
            Response.Write("<br/><br/><br/><br/>没有未读的信件!!");
            return;
        }

        objPage.AllowPaging = true;
        objPage.PageSize = 3;

        if (Request.QueryString["Page"] != null)
        {
            CurPage = Convert.ToInt32(Request.QueryString["Page"]);
            CurPage = Math.Min(CurPage, objPage.PageCount);
            CurPage = Math.Max(CurPage, 1);
        }
        else
            CurPage = 1;
        objPage.CurrentPageIndex = CurPage - 1;
        TotalPage = objPage.PageCount;
        Tnum = objPage.DataSourceCount;
        EachPage = objPage.Count;
        lblCurPage.Text = "第 " + CurPage.ToString() + " / " + TotalPage.ToString() + " 页";
        lblTnum.Text = "共: " + Tnum + " 条记录";
        lblEachPage.Text = "每页有: " + EachPage.ToString() + " 条记录";

        if (objPage.CurrentPageIndex != 0)
            lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(1);
        if (objPage.CurrentPageIndex != TotalPage - 1)
            lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(TotalPage);

        if (!objPage.IsFirstPage)
            lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
        if (!objPage.IsLastPage)
            lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);

        Repeater1.DataSource = objPage;
        Repeater1.DataBind();
    }
    protected void btnPage_Click(object sender, EventArgs e)
    {
        int PageNum = 0;
        if (!Request.Form["txtPage"].Equals(""))
            PageNum = Convert.ToInt32(Request.Form["txtPage"]);
        if (PageNum <= 0 || PageNum > TotalPage)
            Response.Redirect(Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(1));
        else
            Response.Redirect(Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(PageNum));
    }
}