myorder.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;

namespace BookStore.MyBookStore
{
	/// <summary>
	/// MyOrder 的摘要说明。
	/// </summary>
	public class MyOrder : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.HyperLink HyperLink2;
		protected System.Web.UI.WebControls.HyperLink HyperLink3;
		protected System.Web.UI.WebControls.HyperLink HyperLink4;
		protected System.Web.UI.WebControls.HyperLink HyperLink5;
		protected System.Web.UI.WebControls.HyperLink HyperLink6;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		string strSql;
		static int nUserID;
		protected Lei.WebControls.PagerDataList pdlMyOrder;
		protected Lei.WebControls.PagerDataList dlMyOrder;
		protected System.Web.UI.WebControls.Label lbInfo;

		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!IsPostBack)
			{
				if(Object.Equals(Session["UserName"],null))
				{
					Session["ReqestedURL"] = Request.RawUrl;
					Response.Redirect("../Error.aspx");
				}
				else
				{
					OrderDataBind();
				}
			}
		}

		private void OrderDataBind()
		{
			nUserID = int.Parse(Session["UserID"].ToString());
			strSql = "select * from OrderUserDetail where UserID=" + nUserID;
			DataSet currentDS;
			currentDS = RobertSoft.BookStore.DBClass.DBBaseClass.ExecuteSQLForDS(strSql);
			
			DataRow currentDR, tempDR;
			DataTable currentDT;
			string str="";

			// Add a new table which contains all the shopping cart table will list.
			currentDT = new DataTable();
			currentDT.Columns.Add(new DataColumn("ID", str.GetType()));
			currentDT.Columns.Add(new DataColumn("TotalDiscountPrice", str.GetType()));
			currentDT.Columns.Add(new DataColumn("OrderDate", str.GetType()));
			currentDT.Columns.Add(new DataColumn("OrderStatus", str.GetType()));

			for(int i=0; i< currentDS.Tables[0].Rows.Count; i++)
			{
				tempDR = currentDS.Tables[0].Rows[i];
				currentDR = currentDT.NewRow();
				currentDR[0] = tempDR["ID"].ToString();
				currentDR[1] = tempDR["TotalDiscountPrice"].ToString();
				currentDR[2] = tempDR["OrderDate"].ToString();
				int nStatus = int.Parse(tempDR["OrderStatus"].ToString());
				if( nStatus == 1)
				{
					currentDR[3] = "用户已发出订单，等待确认";
				}
				else if( nStatus == 2)
				{
					currentDR[3] = "网站已经确认订单，处理中";
				}
				else if( nStatus == 3)
				{
					currentDR[3] = "图书已经送达，订单完成";
				}
				else
				{
					currentDR[3] = "用户已发出订单，等待确认";
				}
				currentDT.Rows.Add(currentDR);
			}

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

		}
		#endregion

		private void dlMyOrder_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
		{
			if(e.CommandName == "BookDetail")
			{
				string url;
				url = "MyOrderDetail.aspx?OrderID=" + e.CommandArgument.ToString();
				Response.Redirect(url);
			}
		}

		private void dlMyOrder_DeleteCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
		{
			int intOrderID = int.Parse(e.CommandArgument.ToString());
			DeleteData(intOrderID);
			OrderDataBind();
			
		}

		private void DeleteData(int intOrderID)
		{
			int nStatus;
			string strSql;
			strSql = "select OrderStatus from OrderUserDetail where ID=" + intOrderID;
			nStatus = RobertSoft.BookStore.DBClass.DBBaseClass.ExecuteSQLForValue(strSql);
			if( nStatus == 1)
			{
				strSql = "DELETE FROM [OrderUserDetail] where ID=" + intOrderID;
				try
				{
					RobertSoft.BookStore.DBClass.DBBaseClass.ExecuteSQLCmd(strSql);			
					this.lbInfo.Text = "删除成功";
				}
				catch
				{
					this.lbInfo.Text = "删除失败！";
					return;
				}	
				strSql = "DELETE FROM [OrderBookDetail] where OrderID=" + intOrderID;
				try
				{
					RobertSoft.BookStore.DBClass.DBBaseClass.ExecuteSQLCmd(strSql);			
					this.lbInfo.Text = "删除成功";
				}
				catch
				{
					this.lbInfo.Text = "删除失败！";
					return;
				}	
			}
			else
			{
				this.lbInfo.Text = "订单已经在受理中或者已经受理完毕，无法删除。如有问题，请直接和网站管理员联系。";
				this.lbInfo.ForeColor = Color.Red;
			}
		}

		private void dlMyOrder_PageIndexChanged(object sender, System.EventArgs e)
		{
			int pageindex = ((DataGridPageChangedEventArgs)e).NewPageIndex;
			this.dlMyOrder.CurrentPageIndex = pageindex;
			OrderDataBind();
		}
	}
}