weidu.aspx.cs

b to b 模式 电子商务系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;//数据库
using System.Configuration;//包含web.config配置文件

namespace B2Bsite.myinfo
{
	/// <summary>
	/// shoujian 的摘要说明。
	/// </summary>
	public class shoujian : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Repeater Repeater1;
		

		protected System.Web.UI.WebControls.Label lblCurPage;
		protected System.Web.UI.WebControls.Label lblEachPage;
		protected System.Web.UI.WebControls.Label lblTnum;
		protected System.Web.UI.WebControls.HyperLink lnkFirst;
		protected System.Web.UI.WebControls.HyperLink lnkPrev;
		protected System.Web.UI.WebControls.HyperLink lnkNext;
		protected System.Web.UI.WebControls.HyperLink lnkLast;
		protected System.Web.UI.WebControls.TextBox txtPage;
		protected System.Web.UI.WebControls.Button btnPage;
	
		public static int TotalPage;//定义变量来保存总页数
		public int CurPage;//定义变量来保存当前页索引
		public int Tnum;//总条数;
		public int EachPage;//每页总条数
		//数据库连接的类
		public string sid;
	
        SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);

		private void Page_Load(object sender, System.EventArgs e)
		{
			ListBind();
		}
		ICollection CreateSource()
		{
			string user=Session["username"].ToString();
			string sql="select * from tells where incepter='"+user+"' 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();
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.btnPage.Click += new System.EventHandler(this.btnPage_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnPage_Click(object sender, System.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));
		}
	}
}