shoplist.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>
	/// 店铺列表
	/// </summary>
	public class shopList : System.Web.UI.Page
	{
        protected System.Web.UI.WebControls.Repeater Repeater1;
        protected System.Web.UI.WebControls.Repeater Repeater2;
        protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label lblCurPage;
		protected System.Web.UI.WebControls.Label lblTnum;
		protected System.Web.UI.WebControls.Label lblEachPage;
		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 SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnStr"]);
    
		private void Page_Load(object sender, System.EventArgs e)
		{
            if(!IsPostBack)
            {
                //绑定 分类列表
                String sql="SELECT * FROM PType where parentId=0";
                SqlCommand command=new SqlCommand(sql,conn);
                conn.Open();
                SqlDataReader dr=command.ExecuteReader();
                Repeater1.DataSource = dr;
                Repeater1.DataBind();
                dr.Close();
                conn.Close();
            
                //绑定 类别所对应的店铺列表
                string mysql = "";
                string strID = "0";
                if(Request.QueryString["categoryid"]!=null)
                {
                    
                    strID = Request.QueryString["categoryid"].ToString ();
                    if( strID.Equals("0") )
                    {
                        mysql="SELECT * FROM DianPuDetail";
                    }
                    else
                    {
                        mysql="SELECT * FROM DianPuDetail where DianPuClass=" + strID;
                    }
                }
                else
                {
                    mysql="SELECT * FROM DianPuDetail";
                }
                    
                    
                /*
				SqlCommand mycommand=new SqlCommand(mysql,conn);
                conn.Open();
                SqlDataReader mydr=mycommand.ExecuteReader();
				*/
				SqlDataAdapter da=new SqlDataAdapter(mysql,conn);
				DataSet ds=new DataSet();
				da.Fill(ds,"Table");
				PagedDataSource objPage=new PagedDataSource();//创建分页类
				objPage.DataSource=ds.Tables["Table"].DefaultView;//设置数据源

				objPage.AllowPaging=true;
				objPage.PageSize=5;

                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.ToString()+" 条记录  ";
				lblEachPage.Text="每页有: "+EachPage.ToString()+" 条记录";

				if(objPage.CurrentPageIndex!=0)
					lnkFirst.NavigateUrl=Request.CurrentExecutionFilePath+"?categoryid="+strID+"&Page="+Convert.ToString(1);
				if(objPage.CurrentPageIndex!=TotalPage-1)
					lnkLast.NavigateUrl=Request.CurrentExecutionFilePath+"?categoryid="+strID+"&Page="+Convert.ToString(TotalPage);
		
				if(!objPage.IsFirstPage)
					lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath+"?categoryid="+strID+"&Page="+Convert.ToString(CurPage-1);
				if(!objPage.IsLastPage)
					lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+"?categoryid="+strID+"&Page="+Convert.ToString(CurPage+1);
		

                Repeater2.DataSource = objPage;
                Repeater2.DataBind();
                //mydr.Close();
                conn.Close(); 

                //查询 当前的类别名
                String mysql2="SELECT * FROM PType where category_ID=" + strID;
                SqlCommand mycommand2=new SqlCommand(mysql2,conn);
                conn.Open();
                SqlDataReader mydr2=mycommand2.ExecuteReader();
                    
                if( mydr2.Read() )
                {
                    Label1.Text = mydr2["category_name"].ToString();
                }
                else
                {
                    Label1.Text = "所有分类";
                }
                    
                //mydr.Close();
                conn.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+"?categoryid="+Request.QueryString["categoryid"].ToString()+"&Page="+Convert.ToString(1));
			else
				Response.Redirect(Request.CurrentExecutionFilePath+"?categoryid="+Request.QueryString["categoryid"].ToString()+"&Page="+Convert.ToString(PageNum));
		}


	}
}