header.ascx.cs

电子商城源代码,包含项目工程文件! 数据库建表语句 具体功能包括电子购物车,在线购物!

namespace EMall.UserControls
{
	using System;
	using System.Data;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;

	/// <summary>
	///		Header 的摘要说明。
	/// </summary>
	public abstract class Header : System.Web.UI.UserControl
	{
		protected Pub pub = new Pub();
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.DataList Datalist1;
		protected System.Web.UI.WebControls.DataList Datalist3;
		protected System.Web.UI.WebControls.Button Button1;

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			BindData();
		}

		void BindData()
		{
			string sSQL;
			sSQL = "SELECT * FROM SiteMenu WHERE ParentID = 2 ORDER BY OrderID";
			pub.BindDataList(sSQL, Datalist1);
			sSQL = "SELECT * FROM Categories WHERE ParentID IS NOT NULL";
			pub.BindDataList(sSQL, Datalist3);

			sSQL = "SELECT TOP 10 * FROM Products ORDER BY Clicks DESC";
			// 从URL获取所选的ID
			string SelectedID = Request.Params["SelectedID"];
			if (SelectedID != null) 
			{
				Datalist3.SelectedIndex = Int32.Parse(SelectedID);
			}
		}

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

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
			string sStr = TextBox1.Text.Trim();
			if ((sStr != null) && (sStr.Length > 2))
			{
				Response.Redirect("SearchProducts.aspx?sStr=" + sStr, true);
			}
			else
				TextBox1.Text = "至少三位货号或者货名, 甚至描述也可以";
		}
	}
}