productdetail.aspx.cs

电子商务网站,结合Visual Sttudio 2005和SQL 2005 用ASP.NET语言开发的网站.

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);
		}
	
	}
}