default.aspx.cs

网上书店系统由两部分组成:购书网站和订单处理中心。其中购书网站是一个Web应用程序, 用户可以通过Web浏览器登录到此网站.在此网站

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.OleDb;
using Bookshop;

namespace Bookshop
{
	/// <summary>
	/// _Default 的摘要说明。
	/// </summary>
	public class _Default : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if( !Page.IsPostBack )
			{
				initData();
				initData1();
			}
			
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}

		private void InitializeComponent()
		{
			this.Load += new System.EventHandler(this.Page_Load);

		}

		#endregion
	
		private void initData()
		{	
			OleDbDataReader tempReader = OleDbConn.ExecuteReader("select top 4 * from Titles order by salenum desc");
			Label2.Text += "<table cellpadding=0 cellspacing=0 border=0 width=100%><tr>";
			for( int i = 0; i < 4; i++  )
			{
				if( tempReader.Read() )
				{
					Label2.Text += "<td width=25% align=center><a href=\"BookShow.aspx?bookid=" + tempReader["title_id"] + "\"><img width=80 height=118 border=1 src=\"upload/" + tempReader["pic"] +"\"></a><br>&lt;&lt;" + tempReader["title"] + "&gt;&gt;</td>";
				}
				else
				{
					Label2.Text += "<td width=25% align=center></td>";
				}
			}
			Label2.Text += "</tr></table>";
			tempReader.Close();
			OleDbConn.CloseConn();
		}


	    private void initData1()
		{
			OleDbDataReader tempReader1 = OleDbConn.ExecuteReader("select top 4 * from Titles order by dateonsale desc");
			Label3.Text += "<table cellpadding=0 cellspacing=0 border=0 width=100%><tr>";
			for( int i = 0; i < 4; i++  )
			{
				if( tempReader1.Read() )
				{
					Label3.Text += "<td width=25% align=center><a href=\"BookShow.aspx?bookid=" + tempReader1["title_id"] + "\"><img width=80 height=118 border=1 src=\"upload/" + tempReader1["pic"] +"\"></a><br>&lt;&lt;" + tempReader1["title"] + "&gt;&gt;</td>";
				}
				else
				{
					Label3.Text += "<td width=25% align=center></td>";
				}
			}
			Label3.Text += "</tr></table>";
			tempReader1.Close();
			OleDbConn.CloseConn();
		}


	}
}