Usercontrol/ShoppingCar.ascx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;


public partial class Usercontrol_ShoppingCar : System.Web.UI.UserControl
{
    DataBaseShoppingCar dc = new DataBaseShoppingCar();
    protected void Page_Load(object sender, EventArgs e)
    {

        HttpCookie hc = HttpContext.Current.Request.Cookies["cookieCart"];
        ShoppingItem shopitem = new ShoppingItem();
        ShoppingCar sc = new ShoppingCar();
        if (hc != null)
        {
            sc.InsertInfo(Session["UserId"].ToString());
        }




        NewMethod();



    }

    private void NewMethod()
    {
        string strsql = string.Format("SELECT    ShoppingCar.ID as 编号, ShoppingCar.GoodsId as 商品编号, WenJu.Name as 商品名称, WenJu.Price as 价格, ShoppingCar.GoodsCount as 商品件数,ShoppingCar.CarTime as 加入时间  FROM         WenJu INNER JOIN ShoppingCar ON WenJu.Id = ShoppingCar.GoodsId Where UserId='{0}'and ShoppingId='001' order by ShoppingCar.CarTime desc", Session["UserId"]);
        DAL.DataAccess.GridviewBang(strsql, GridView1);
        string strsql1 = string.Format("SELECT   sum(GoodsCount),SUM(Price) FROM    WenJu INNER JOIN ShoppingCar ON WenJu.Id = ShoppingCar.GoodsId where UserId='{0}' and ShoppingId='001' ", Session["UserId"]);
        DataTable dt = DAL.DataAccess.Execute(strsql1);
        
        Label2.Text= dt.Rows[0][1].ToString();

        Label4.Text = dt.Rows[0][0].ToString();
        if (Label2.Text == ""||Label4.Text=="")
        { Label2.Text = "0";
        Label4.Text = "0";
        Page.ClientScript.RegisterClientScriptBlock(GetType(), "Ok", "alert(\"您的购物车为空！快点去购物吧！\")", true);

        }
 
    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {


    }