product_buy.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 ;

namespace B2Bsite
{
	/// <summary>
	/// Product_buy 的摘要说明。
	/// </summary>
	public class Product_buy : System.Web.UI.Page
	{
		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;
		protected System.Web.UI.WebControls.Repeater Repeater1;
	
		public static int TotalPage;//定义变量来保存总页数
		public int CurPage;//定义变量来保存当前页索引
		public int Tnum;//总条数;
		public int EachPage;//每页总条数

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				SqlConnection connection=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);//调用Web.config连接数据库
				String sql="SELECT * FROM Orders where BuyerId='"+Session["username"].ToString()+"'"; //数据库连接字符串
				/*
				 SqlCommand command=new SqlCommand(sql,connection);//构件执行数据命令
				connection.Open();//打开数据库
				SqlDataReader dr=command.ExecuteReader();//保存从数据库里面返回的一条记录
				*/
				SqlDataAdapter da=new SqlDataAdapter(sql,connection);
				DataSet ds=new DataSet();
				da.Fill(ds,"Table");
				PagedDataSource objPage=new PagedDataSource();//创建分页类
				objPage.DataSource=ds.Tables["Table"].DefaultView;//设置数据源

				objPage.AllowPaging=true;
				objPage.PageSize=10;

				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));
		}
	}
}