searchbytype.aspx.cs

这是一个编好的网上书店系统

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;

namespace BookStore
{
	/// <summary>
	/// SearchByType 的摘要说明。
	/// </summary>
	public class SearchByType : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.HyperLink hlViaNew;
		protected System.Web.UI.WebControls.HyperLink hlViaHitNumber;
		protected System.Web.UI.WebControls.HyperLink hlViaAuthor;
		protected System.Web.UI.WebControls.HyperLink hlViaPublisher;
		protected System.Web.UI.WebControls.DataList dlSubType;
		protected System.Web.UI.WebControls.Label lbTitle;
		protected System.Web.UI.WebControls.Label lbNobook;
		protected Lei.WebControls.PagerDataList pdlSubTypeDetail;
		protected System.Web.UI.HtmlControls.HtmlForm QuickSearchFrom;
		RobertSoft.BookStore.Book currentBook = new RobertSoft.BookStore.Book();
		static int nSuperType = 0;

		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!IsPostBack)
			{
				InitDataBind();				
			}
		}

		private void InitDataBind()
		{
			int nSubType;
			string strListOrder;
			if(!Object.Equals(Request["SuperType"],null))
			{
				nSuperType = int.Parse(Request["SuperType"]);

				if(Object.Equals(Request["SubType"],null))
				{
					nSubType = nSuperType*100 + 1;
				}
				else
				{
					nSubType = int.Parse(Request["SubType"]);
				}
			}
			else
			{
				if(Object.Equals(Request["SubType"],null))
				{
					nSubType = nSuperType*100 + 1;
				}
				else
				{
					nSubType = int.Parse(Request["SubType"]);
				}
			}
							
			if(Object.Equals(Request["SubType"],null))
			{
				nSubType = nSuperType*100 + 1;
			}
			else
			{
				nSubType = int.Parse(Request["SubType"]);
			}

			if(!Object.Equals(Request["ListOrder"],null))
			{
				strListOrder = Request["ListOrder"].ToString();
			}
			else
			{
				strListOrder = "ID";
			}
			
		
			SqlDataReader drSubType;
			DataRow currentDR;
			string strSuperType;

			currentDR = currentBook.GetTypeDetail(nSubType);

			if(int.Parse(currentDR["SuperBookType"].ToString()) == 1)
			{
				nSuperType = 1;
				strSuperType = "计算机书籍";
			}
			else if(int.Parse(currentDR["SuperBookType"].ToString())  == 2)
			{
				nSuperType = 2;
				strSuperType = "外语书籍";
			}
			else if(int.Parse(currentDR["SuperBookType"].ToString())  == 3)
			{
				nSuperType = 3;
				strSuperType = "经济管理书籍";
			}
			else
			{
				nSuperType = 4;
				strSuperType = "其他书籍";
			}			

			this.lbTitle.Text = "您的位置：<a href='Default.aspx'>首页</a>>>" + 
				"<a href='SearchByType.aspx?SuperType=" + int.Parse(currentDR["SuperBookType"].ToString()) 
				+ "'>" + strSuperType + "</a>>>" + currentDR["TypeName"].ToString();

			drSubType = currentBook.GetBookSubType(nSuperType);
			this.dlSubType.DataSource = drSubType;
			this.dlSubType.DataBind();
			
			DataView dvTypeDetail;
			dvTypeDetail = currentBook.GetBookDetailBySubType(nSubType, strListOrder);
			if(dvTypeDetail.Count !=0)
			{
				this.pdlSubTypeDetail.DataSource = dvTypeDetail;
				this.pdlSubTypeDetail.DataBind();
			}
			else
			{
				this.pdlSubTypeDetail.Visible = false;
				this.lbNobook.Visible = true;
				this.lbNobook.Text = "很抱歉本站目前还没有这类书籍。您可以去<a href='LackBook.aspx'>缺书登记</a>登记您的需求！谢谢。"	;
			}

			this.hlViaAuthor.NavigateUrl = "SearchByType.aspx?SuperType="+ nSuperType + "&SubType=" + nSubType + "&ListOrder=Author";
			this.hlViaHitNumber.NavigateUrl = "SearchByType.aspx?SuperType="+ nSuperType + "&SubType=" + nSubType + "&ListOrder=HitNumber";
			this.hlViaNew.NavigateUrl = "SearchByType.aspx?SuperType="+ nSuperType + "&SubType=" + nSubType + "&ListOrder=ID";
			this.hlViaPublisher.NavigateUrl = "SearchByType.aspx?SuperType="+ nSuperType + "&SubType=" + nSubType + "&ListOrder=PublishingHouse";
		}

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

		}
		#endregion

		private void dlSubType_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
		{
			if(e.CommandName == "select")
			{
				string strUrl;
				strUrl = "SearchByType.aspx?SuperType=" + nSuperType + " &SubType=" + e.CommandArgument.ToString();
				Response.Redirect(strUrl);
			}
		}

		private void pdlSubTypeDetail_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
		{
			if(e.CommandName == "select")
			{
				string strUrl;
				strUrl = "ShowBookDetail.aspx?ID=" + e.CommandArgument;
				Response.Redirect(strUrl);
			}
		}

		private void pdlSubTypeDetail_PageIndexChanged(object sender, System.EventArgs e)
		{
			int pageindex = ((DataGridPageChangedEventArgs)e).NewPageIndex;
			this.pdlSubTypeDetail.CurrentPageIndex = pageindex;
			this.InitDataBind();
		}
	
	}
}