productdisplay.ascx.cs

vs2005 C# sqlserver2000 制作完成

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using EShop.DataAccessLayer;
using EShop.BusinessLogicLayer;

public partial class control_Product_Product : System.Web.UI.UserControl
{
    private string productName;
    public string ProductName
    {
        set
        {
            this.productName = value.ToString();
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            hylProductName.Text = this.productName.ToString();
            Product product = new Product();
            SqlDataReader DR = product.getProReader(this.productName);
            DR.Read();

            lblID.Text = DR["ProductID"].ToString();
            hylProductName.NavigateUrl = "~/Detail.aspx?Name=" + productName;
            lblPrice.Text = DR["ProductPrice"].ToString();
            Image1.ImageUrl = "~/images/Product/" + DR["PictureUrl"];
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Session["userID"] == null)
        {
            Response.Write("<Script Language=JavaScript>alert('请登录！')</Script>");
        }
        else
        {
            Cart cart = new Cart();
            int productid = int.Parse(lblID.Text.ToString().Trim());
            SqlDataReader sdr=cart.getCartReader(Session["userID"].ToString().Trim(),productid);
            if(sdr.HasRows)
            {
                Response.Write("<script language=javascript>alert('您已购买过此商品，请进入购物车设定购买数量！')</script>");
            }
            else
            {
            sdr.Close();
            string userID = Session["userID"].ToString();
            int productID = int.Parse(lblID.Text.ToString().Trim());
            int number = 1;
            DateTime datetime = System.DateTime.Now;
            int status = 0;

            DataBase DB = new DataBase();
            SqlParameter[] Params = new SqlParameter[5];
            Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, userID);
            Params[1] = DB.MakeInParam("@ProductID", SqlDbType.Int, 4, productID);
            Params[2] = DB.MakeInParam("@Number", SqlDbType.Int, 4, number);
            Params[3] = DB.MakeInParam("@CreateDate", SqlDbType.DateTime, 100, datetime);
            Params[4] = DB.MakeInParam("@Status", SqlDbType.TinyInt, 2, status);

            if (DB.RunProc("Proc_CartAdd", Params) > 0)
            {
                Response.Write("<Script Language=JavaScript>alert('购入成功！')</Script>");
            }
            else
            {
                Response.Write("<Script Language=JavaScript>alert('数据库错误，请稍候购买！')</Script>");
            }
            }
            
        }
    }
}