showbookdet.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 HKeBookshop
{
	/// <summary>
	/// showbookdet 的摘要说明。
	/// </summary>
	public class showbookdet : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid pinglun;
		protected System.Web.UI.WebControls.Label bookname;
		protected System.Web.UI.WebControls.Label bookwrite;
		protected System.Web.UI.WebControls.Label date;
		protected System.Web.UI.WebControls.TextBox mypinglun;
		protected System.Web.UI.WebControls.Button sub;
		protected System.Web.UI.WebControls.Image Image1;
		myclass MyClass = new myclass();
		protected System.Web.UI.WebControls.Label price;
		protected System.Web.UI.WebControls.Label beizhu;
		DataSet ds = new DataSet();
		string strsql;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.ImageButton ImageCar;
		string Bookid;


		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			
			
			if (!IsPostBack)
			{
				Bookid = Request.QueryString["bookid"].ToString();
				strsql= "select * from pinlun where bookid='" + Bookid +"'";
				ds =  MyClass.Readdate(strsql);
				pinglun.DataSource = ds;
				pinglun.DataBind();
							

				strsql = "Select * from T_bookinfo where bookid='" + Bookid + "'";
				ds = MyClass.Readdate(strsql);
				bookname.Text = ds.Tables["myDB"].Rows[0][1].ToString();
				date.Text = ds.Tables["myDB"].Rows[0][3].ToString();
				bookwrite.Text = ds.Tables["myDB"].Rows[0][4].ToString();
				beizhu.Text = ds.Tables["myDB"].Rows[0][6].ToString();
				price.Text = ds.Tables["myDB"].Rows[0][2].ToString();
				Image1.ImageUrl = ds.Tables["myDB"].Rows[0][5].ToString();

			}
			

		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.sub.Click += new System.EventHandler(this.sub_Click);
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.ImageCar.Click += new System.Web.UI.ImageClickEventHandler(this.ImageCar_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void sub_Click(object sender, System.EventArgs e)
		{
			if (Session["name"]=="")
			{
				Response.Write("<script>alert('请先登录')</script>");
			}
			else
			{
				if (mypinglun.Text !="")
				{
					Bookid=Request.QueryString["bookid"].ToString();
					strsql="insert into pinlun(bookid,pinlun,userid) values('" + Bookid +"','" + mypinglun.Text + "','" + Session["name"].ToString() + "')";
					MyClass.Insert(strsql);
					Response.Write("<script>alert('评论成功')</script>");
				}
				else
				{
					Response.Write("<script>alert('评论不能为空')</script>");
				}
				
			}
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("bookshow.aspx");
		}

		private void ImageCar_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if (Session["name"] == "")
			{
				Response.Write("<script>alert('请您登录,或者注册')</script>");

			}
			else
			{
					
				
				strsql = "select * from T_bookinfo where bookname ='" + bookname.Text + "'";
				ds = MyClass.Readdate(strsql);
				BookOrder Order=new BookOrder(ds.Tables["myDB"].Rows[0][0].ToString(),bookname.Text,Convert.ToDecimal(price.Text),1);
				ShoppingCart cart = (ShoppingCart)Session["shoppingcar"];
				cart.AddOrder(Order);
				Response.Write("<script>alert('添加成功')</script>");
			}
		}

	}
}