usingSqlSugar;
namespaceEasyBuyShop.Models{
/// <summary>/// 购物车/// </summary>    [SugarTable("EB_Cart")]
publicclassCart:EntityModel    {
publiclongProductId { get; set; }
publiclongCustomerId { get; set; }
/// <summary>/// 数量/// </summary>publicintQuantity { get; set; }
publicstringRemark { get; set; }
    }
}

usingEasyBuyShop.Models;
usingEasyBuyShop.Utils;
namespaceEasyBuyShop.DAL{
publicclassCartDal:BaseDal    {
/// <summary>/// 获取购物车列表/// </summary>/// <param name="userId"></param>/// <returns></returns>publicList<Cart>GetCartListByUserId(longuserId)
        {
try            {
using (vardb=this.GetDb(BaseDal.ConnStr))
                {
returndb.Queryable<Cart>().Where(r=>r.CustomerId==userId).ToList();
                }
            }
catch (Exceptionex)
            {
LogHelper.Fatal(ex.Message);
returnnewList<Cart>();
            }
        }
publicintDeleteById(longid)
        {
try            {
using (vardb=this.GetDb(BaseDal.ConnStr))
                {
intcnt=db.Deleteable<Cart>(r=>r.Id==id).ExecuteCommand();
returncnt;
                }
            }
catch (Exceptionex)
            {
LogHelper.Fatal(ex.Message);
return-1;
            }
        }
publicCartGetCart(longid)
        {
try            {
using (vardb=this.GetDb(BaseDal.ConnStr))
                {
returndb.Queryable<Cart>().First(r=>r.Id==id);
                }
            }
catch (Exceptionex)
            {
LogHelper.Fatal(ex.Message);
returnnull;
            }
        }
    }
}

usingEasyBuyShop.DAL;
usingEasyBuyShop.Models;
usingMicrosoft.AspNetCore.Mvc;
namespaceEasyBuyShop.Controllers{
/// <summary>/// 购物车控制器/// </summary>publicclassCartController : Controller    {
/// <summary>/// 购物车列表页面/// </summary>/// <returns></returns>publicIActionResultIndex()
        {
varuserId=HttpContext.Session.GetInt32("userid");
if (userId==null)
            {
returnRedirect("/Auth/login");
            }
varcartDal=newCartDal();
varproductDal=newProductDal();
varcartList=cartDal.GetCartListByUserId((long)userId);
varproducts=productDal.GetProductListByIds(cartList.Select(r=>r.ProductId).ToList());
ViewData["CartList"] =cartList;
ViewData["ProductList"]=products;
varusername=HttpContext.Session.GetString("username");
varrealName=HttpContext.Session.GetString("realname");
ViewData["Username"] =username;
ViewData["RealName"] =realName;
returnView();
        }
/// <summary>/// 首页或商品列表，快捷加入购物车/// </summary>/// <param name="productId"></param>/// <returns></returns>        [HttpPost]
publicIActionResultAdd(intproductId)
        {
Msgmsg=newMsg();
varuserId=HttpContext.Session.GetInt32("userid");
varuserName=HttpContext.Session.GetString("username");
if (userId==null)
            {
msg.code=-1;
msg.message="尚未登录";
returnJson(msg);
            }
varproductDal=newProductDal();
varproduct=productDal.GetProduct(productId);
if (product!=null)
            {
varcartDal=newCartDal();
varcart=newCart();
cart.ProductId=productId;
cart.CustomerId=userId.Value;
cart.Quantity=1;
cart.Remark=string.Empty;
cart.CreateUser=userName;
cart.CreateTime=DateTime.Now;
cart.LastEditUser=userName;
cart.LastEditTime=DateTime.Now;
intid=cartDal.InsertT<Cart>(cart);
if(id>0)
                {
msg.code=0;
msg.message="成功";
returnJson(msg);
                }
else                {
msg.code=-1;
msg.message="加入购物车失败";
returnJson(msg);
                }
            }
else            {
msg.code=-1;
msg.message="商品不存在";
returnJson(msg);
            }
        }
/// <summary>/// 商品详情页面加入购物车/// </summary>/// <returns></returns>        [HttpPost]
publicIActionResultAddWithForm()
        {
Msgmsg=newMsg();
varuserId=HttpContext.Session.GetInt32("userid");
varuserName=HttpContext.Session.GetString("username");
if (userId==null)
            {
msg.code=-1;
msg.message="尚未登录";
returnJson(msg);
            }
varproductId=long.Parse( Request.Form["productId"]);
varquantity=int.Parse(Request.Form["quantity"]);
varcolor=Request.Form["color"];
varsize=Request.Form["size"];
varremark=$"颜色：{color},大小：{size}";
varproductDal=newProductDal();
varproduct=productDal.GetProduct(productId);
if (product!=null)
            {
varcartDal=newCartDal();
varcart=newCart();
cart.ProductId=productId;
cart.CustomerId=userId.Value;
cart.Quantity=quantity;
cart.Remark=remark;
cart.CreateUser=userName;
cart.CreateTime=DateTime.Now;
cart.LastEditUser=userName;
cart.LastEditTime=DateTime.Now;
intid=cartDal.InsertT<Cart>(cart);
if (id>0)
                {
msg.code=0;
msg.message="成功";
                }
else                {
msg.code=-1;
msg.message="加入购物车失败";
                }
            }
else            {
msg.code=-1;
msg.message="商品不存在";
            }
returnRedirect("/Cart/Index");
        }
/// <summary>/// 移除购物车/// </summary>/// <param name="Id"></param>/// <returns></returns>publicActionResultDelete(intId)
        {
varcartDal=newCartDal();
if(cartDal.DeleteById(Id) >0)
            {
//成功            }
else            {
//删除失败            }
returnView();
        }
    }
}