product/show.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class product_show : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["ProId"] == null)
        {
            Response.Redirect("~/Default.aspx");
        }
        else
        {
            string sql = "select * from Product where ProductId=" + Request.QueryString["ProId"];
            DataTable dt = MyClass.OfflineSelect(sql);
            Image1.ImageUrl=dt.Rows[0]["ProductImg"].ToString();
            lblProName.Text=dt.Rows[0]["ProductName"].ToString();
            lblProCon.Text=dt.Rows[0]["ProductContent"].ToString();
            lblProPrice.Text=dt.Rows[0]["ProductPrice"].ToString();
        }
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        if (Session.Count == 0)
        {
            Response.Write("<script>alert('请先登录！');location.assign('Default.sapx')</script>");
        }
        else
        {
            double iprice;
            int num = Convert.ToInt32(TextBox1.Text);
            int id = Convert.ToInt32(Request.QueryString["ProId"]);
            string sql = "select ProductPrice from Product where ProductId=" + id;
            iprice = Convert.ToDouble(MyClass.OfflineSelect(sql).Rows[0]["ProductPrice"]);
            sql = "select * from Buys where ProductId =" + id + "and UserName='" + Session["UserName"].ToString() + "'";
            DataTable dt = MyClass.OfflineSelect(sql);
            if (dt.Rows.Count > 0)
            {
                sql = "update Buys set Num=Num+" + num + ",TotalPrice=TotalPrice+" + num * iprice + " where ProductId=" + id;
            }
            else
            { 
                if(id!=0)
                {
                    sql = "insert into Buys(UserName,ProductId,Num,TotalPrice)values('" + Session["UserName"].ToString() + "','" + id + "','" + num + "','" + num * iprice + "')";
                }
            }
            MyClass.ExecuteSql(sql);
            Response.Redirect("buy.aspx");
        }