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 shop.DbBase;
using System.Text;

namespace shop
{
	/// <summary>
	/// checkOut 的摘要說明。
	/// </summary>
	public class checkOut : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lblUserName;
		protected System.Web.UI.WebControls.DataGrid grdShopList;
		protected System.Web.UI.WebControls.Label lblError;
		protected System.Web.UI.WebControls.TextBox txtLinkMan;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox txtEmail;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.TextBox txtPhone;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.TextBox txtPost;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.TextBox txtAddress;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
		protected System.Web.UI.WebControls.TextBox txtRemark;
		protected System.Web.UI.WebControls.DropDownList dropTime;
		protected System.Web.UI.WebControls.DropDownList dropSMode;
		protected System.Web.UI.WebControls.DropDownList dropFMode;
		protected System.Web.UI.WebControls.RadioButtonList radButton;
		protected System.Web.UI.WebControls.Button btnSure;
		protected System.Web.UI.WebControls.Label lblError2;
		protected System.Web.UI.WebControls.Label lblSum;
		protected System.Web.UI.HtmlControls.HtmlInputHidden hiUserId;

		#region user defined private variables
		private string sUserId;
		private double dSum;
		private string sOrderId;
		#endregion
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 判斷用戶是否登錄
			if(!object.Equals(Session["UserId"],null))
			{
				sUserId = Session["UserId"].ToString();
				lblUserName.Text = Session["UserName"].ToString();
                //綁定用戶信息
				ShowUser();
                //綁定購物車信息
				ShowCart();
			}
			else
				Response.Redirect("userEntry.aspx");
		}

		#region Web 窗體設(shè)計器生成的代碼
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 該調(diào)用是 ASP.NET Web 窗體設(shè)計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設(shè)計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內(nèi)容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.btnSure.Click += new System.EventHandler(this.btnSure_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		/// <summary>
		/// 顯示用戶信息
		/// </summary>
		private void ShowUser()
		{
			try
			{　//定義查詢注冊用戶的基本信息
				string sSql = "select UserId,Name,Phone,Email,Address,Post from Users where UserId=" + sUserId;
                //調(diào)用類中的方法
				DataSet oDS = OleBase.ExecuteSql4Ds(sSql);
				DataRow oDR = oDS.Tables[0].Rows[0];
                //將用戶的信息綁定到文本框中
				hiUserId.Value = oDR.ItemArray[0].ToString();
				txtLinkMan.Text = oDR.ItemArray[1].ToString();
				txtPhone.Text = oDR.ItemArray[2].ToString();
				txtEmail.Text = oDR.ItemArray[3].ToString();
				txtAddress.Text = oDR.ItemArray[4].ToString();
				txtPost.Text = oDR.ItemArray[5].ToString();
			}
			catch(Exception e)//錯誤處理
			{
				lblError2.Text = e.Message;
			}
		}

		/// <summary>
		/// 顯示購物車中的信息
		/// </summary>
		private void ShowCart()
		{
			try
			{
				DataTable oDT = new DataTable();
				oDT.Columns.Add("ProductId");
				oDT.Columns.Add("PName");
				oDT.Columns.Add("PMemberPrice");
				oDT.Columns.Add("PNumber");

				dSum = 0;
                //判斷購物車是否有商品
				if(!object.Equals(Session["ProductInCart"],null))
				{
					Hashtable oHT = (Hashtable)Session["ProductInCart"];
					IDictionaryEnumerator oIDE = oHT.GetEnumerator();
					DataRow oDR;
					while(oIDE.MoveNext())
					{
						oDR = oDT.NewRow();
                        //定義查詢商品信息的sql語句
						string sSql = "Select ProductId,PName,PMemberPrice from product where ProductId=" + oIDE.Key.ToString();
						DataSet oDS = OleBase.ExecuteSql4Ds(sSql);
						oDR["ProductId"] = oDS.Tables[0].Rows[0].ItemArray[0].ToString();
						oDR["PName"] = oDS.Tables[0].Rows[0].ItemArray[1].ToString();
						oDR["PMemberPrice"] = oDS.Tables[0].Rows[0].ItemArray[2].ToString();
						oDR["PNumber"] = oIDE.Value.ToString();
						dSum += double.Parse(oDR["PMemberPrice"].ToString())*int.Parse(oDR["PNumber"].ToString());
						oDT.Rows.Add(oDR);
					}
				}
				grdShopList.DataSource = oDT.DefaultView;
				grdShopList.DataBind();
                //將商品的總額綁定到Lblsum文本框中
				lblSum.Text = dSum.ToString();
			}
			catch(Exception e)//錯誤處理
			{
				lblError.Text = e.Message;
			}
		}

		private void btnSure_Click(object sender, System.EventArgs e)
		{
			try
			{
                ////根據(jù)用戶輸入的信息構(gòu)造Insert SQL語句將用戶訂單插入數(shù)據(jù)庫
				StringBuilder sbSql = new StringBuilder("insert into Orders (UserId,LinkMan,Email,Phone,PostalCode,Address,ReMark,SongHuoQixian,SongHuoFangShi,FuKuanFangShi,YiWaiChuLi) values (");
				sbSql.Append(hiUserId.Value + ",");
				sbSql.Append("\"" + txtLinkMan.Text + "\",");
				sbSql.Append("\"" + txtEmail.Text + "\",");
				sbSql.Append("\"" + txtPhone.Text + "\",");
				sbSql.Append("\"" + txtPost.Text + "\",");
				sbSql.Append("\"" + txtAddress.Text + "\",");
				sbSql.Append("\"" + txtRemark.Text + "\",");
				sbSql.Append("\"" + dropTime.SelectedValue + "\",");
				sbSql.Append("\"" + dropSMode.SelectedValue + "\",");
				sbSql.Append("\"" + dropFMode.SelectedValue + "\",");
				sbSql.Append("\"" + radButton.SelectedValue + "\")");
				Response.Write(sbSql.ToString()+"<br>");
				OleBase.ExecuteSql(sbSql.ToString());
                //查詢剛剛插入的訂單Id
				sOrderId = OleBase.ExecuteSql4Value("select top 1 OrderId from Orders where UserId = " + sUserId + " order by OrderId desc").ToString();
                //將訂單中的每個產(chǎn)品的信息插入到訂單細(xì)目信息數(shù)據(jù)表中
				string[] aSqls = new string[grdShopList.Items.Count];
				for(int i=0;i<grdShopList.Items.Count;i++)
				{
					sbSql.Length = 0;
					sbSql.Append("insert into OrdersDetail (OrderId,ProductId,Quantity,UnitCost,ProductName) values (" + sOrderId + ",");
					sbSql.Append("\"" + ((Label)grdShopList.Items[i].FindControl("lblProductId")).Text + "\",");
					sbSql.Append("\"" + ((Label)grdShopList.Items[i].FindControl("lblNumber")).Text + "\",");
					sbSql.Append("" + ((Label)grdShopList.Items[i].FindControl("lblPrice")).Text + ",");
					sbSql.Append("\"" + ((Label)grdShopList.Items[i].FindControl("lblProductName")).Text + "\");");
					aSqls[i] = sbSql.ToString();
					Response.Write(aSqls[i]+"<br>");
				}
				OleBase.ExecuteSqls(aSqls);
				Response.Redirect("checkOutComplete.aspx?Mode=" + dropSMode.SelectedValue + "&OrderId=" + sOrderId);
			}
			catch(Exception ex)//錯誤處理
			{
				throw new Exception(ex.Message);
			}
		}
	}
}