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;

namespace shop
{
	/// <summary>
	/// productDetail 的摘要說明。
	/// </summary>
	public class productDetail : System.Web.UI.Page
	{

		protected Repeater Repeater1;
		protected Repeater Repeater2;
		protected Label lblClick;
		protected TextBox txtName;
		protected RequiredFieldValidator RequiredFieldValidator1;
		protected RequiredFieldValidator RequiredFieldValidator2;
		protected TextBox txtContent;
		protected Button btnReView;
		protected Label lblTest;
		private string sProductId = "1";
		
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此處放置用戶代碼以初始化頁面
			if(!object.Equals(Request.QueryString["ProductId"],null))
			{
				sProductId = Request.QueryString["ProductId"];
                //定義要綁定商品的sql語句
				string sSql = "Select * from Product where ProductId=" + sProductId;
                //調用類中的方法
				DataSet oDS = OleBase.ExecuteSql4Ds(sSql);
                //設置Repeater1的數據源
				Repeater1.DataSource = oDS.Tables[0].DefaultView;
                //將數據源綁定到Repeater1
				Repeater1.DataBind();

				int iClick = int.Parse(oDS.Tables[0].Rows[0].ItemArray[10].ToString()) + 1;
                //定義一個修改商品的點擊數的sql語句
				string sSqlUpdate = "update Product set PClick = " + iClick.ToString() + " where ProductId=" + sProductId;
				OleBase.ExecuteSql(sSqlUpdate);
                //定義對商品要顯示的評論信息
				string sSql2 = "Select * from review where productId=" + sProductId + " order by time desc";
                //調用類中的方法
				DataSet oDS2 = OleBase.ExecuteSql4Ds(sSql2);
                //設置Repeater2的數據源
				Repeater2.DataSource = oDS2.Tables[0].DefaultView;
                //將數據源綁定到Repeater2
				Repeater2.DataBind();
			}
		}

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

		private void btnReView_OnClick(object sender, EventArgs e)
		{　//定義一個插入商品評論的sql語句
			string sSql = "insert into review (GuestName,GuestContent,ProductId) values ('" + txtName.Text + "','" + txtContent.Text + "'," + sProductId + ")";
			//執行插入語句
            OleBase.ExecuteSql(sSql);
		}
	
	}
}