App_Code/DataBaseShoppingCar.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;

/// <summary>
///DataBaseShoppingCar 的摘要说明
/// </summary>
public class DataBaseShoppingCar
{
    public DataBaseShoppingCar()
    {
        //
        //TODO: 在此处添加构造函数逻辑
        //
    }
    public int add(string  GoodsId, string userid, string quantity)
    {
        string strsql = string.Empty;
        SqlParameter[] parameters = null;
        if (!SameBooks( GoodsId, userid))
        {
            strsql = "Insert Into ShoppingCar (GoodsId,UserId,ShoppingId,GoodsCount,CarTime) values(@Id,@UserId,@ShoppingId,@GoodsCount,@CarTime) ";
            parameters = new SqlParameter[]
        {
         new SqlParameter("@Id", GoodsId),
         new SqlParameter("@UserId",userid),
         new SqlParameter("@ShoppingId","001"),
         new SqlParameter("@GoodsCount",quantity),
         new SqlParameter("@CarTime",DateTime.Now.ToString())
      };
            return DAL.DataAccess.ExecuteNonQuery(strsql, CommandType.Text, parameters);
        }
        else
            strsql = "Update ShoppingCar Set GoodsCount=GoodsCount+1 Where Id=@Id And UserId=@UserId";
        parameters = new SqlParameter[] 
        {
            new SqlParameter("@Id", GoodsId),
            new SqlParameter("@UserId",userid)  };
        return DAL.DataAccess.ExecuteNonQuery(strsql, CommandType.Text, parameters);

    }
    public bool SameBooks(string GoodsId, string userid)
    {
        string strsql = "Select Count(*) From ShoppingCar Where Id=@Id And UserId=@UserId";
        SqlParameter[] parameters = new SqlParameter[]
        {
            new SqlParameter("@Id", GoodsId),
            new SqlParameter("@UserId",userid) 
        };
        return int.Parse(DAL.DataAccess.ExecuteScalor(strsql, CommandType.Text, parameters).ToString()) > 0 ? true : false;



    }
    public void DeleteBooks(string userId)
    {
        string strSql = "Delete ShoppingCar Where UserId=@UserId ";