shop_display.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.Configuration;
using System.Data.SqlClient;

namespace B2Bsite
{
	/// <summary>
	/// 店铺展示页面
	/// </summary>
	public class shop_display : System.Web.UI.Page
	{        
        protected System.Web.UI.HtmlControls.HtmlImage shopLogo;
        protected System.Web.UI.WebControls.DataList DataList1;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
        public string dianpuid="0";
        public string dianpuname;
        public string dianpuuser;
        public string dianpulogo;
        public string dianputime;
        public string dianpugonggao;
        public string dianpuclass;
        public string dianpuitem;
	
		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 dianpujieshao;	

		private void Page_Load(object sender, System.EventArgs e)
		{
            if( Request.QueryString["id"] == null || Request.QueryString["id"].ToString() == String.Empty)
            {
                Response.Write ("<script language='JavaScript'>");
                Response.Write ("alert('没有这个店铺！');");
                Response.Write ("</script>");
                return;
            }
            
            if( !IsPostBack )
            {
                dianpuid = Request.QueryString["id"].ToString();
                shopLogo.Src= "showProductshopLogo.aspx?id=" + dianpuid;

                SqlConnection connection=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
                string sql="select * from DianPuDetail where DianPuId="+dianpuid;
                SqlCommand command=new SqlCommand(sql,connection);
                connection.Open();
                SqlDataReader dr=command.ExecuteReader();
                if(dr.Read())
                {
                    dianpuname=dr["DianPuName"].ToString();
                    dianpuuser=dr["DianPuUser"].ToString();	
                    dianputime=Convert.ToDateTime(dr["DianPuTime"]).ToShortDateString();
                    dianpugonggao=dr["DianPuGongGao"].ToString();
                    dianpuclass=dr["DianPuClass"].ToString();				
                    dianpuitem=dr["DianPuItem"].ToString();
                    dianpujieshao=dr["DianPuJieshao"].ToString();
                }
                else
                {
                    Response.Write ("<script language='JavaScript'>");
                    Response.Write ("alert('没有这个店铺！');");
                    Response.Write ("</script>");
                    return;
                }
                dr.Close();
                connection.Close();
			
                //绑定 新进店铺对应的商品列表
                String mysql="SELECT * FROM Products where UserName='" + dianpuuser + "' and ProductState=0 order by ProductId desc";
                /*
				SqlCommand mycommand=new SqlCommand(mysql,connection);
                connection.Open();
                SqlDataReader mydr=mycommand.ExecuteReader();
				*/
				SqlDataAdapter da=new SqlDataAdapter(mysql,connection);
				DataSet ds=new DataSet();
				da.Fill(ds,"Table");
				
				PagedDataSource objPage=new PagedDataSource();//创建分页类
				objPage.DataSource=ds.Tables["Table"].DefaultView;//设置数据源

				objPage.AllowPaging=true;
				objPage.PageSize=12;

				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+"?id="+dianpuid+"&Page="+Convert.ToString(1);
				if(objPage.CurrentPageIndex!=TotalPage-1)
					lnkLast.NavigateUrl=Request.CurrentExecutionFilePath+"?id="+dianpuid+"&Page="+Convert.ToString(TotalPage);
			
				if(!objPage.IsFirstPage)
					lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath+"?id="+dianpuid+"&Page="+Convert.ToString(CurPage-1);
				if(!objPage.IsLastPage)
					lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+"?id="+dianpuid+"&Page="+Convert.ToString(CurPage+1);

                DataList1.DataSource = objPage;
                DataList1.DataBind();
                dr.Close();
                connection.Close();
            }
		}

		#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+"?id="+Request.QueryString["id"].ToString()+"&Page="+Convert.ToString(1));
			else
				Response.Redirect(Request.CurrentExecutionFilePath+"?id="+Request.QueryString["id"]+"&Page="+Convert.ToString(PageNum));
		}
	}
}