/// <summary> /// 清空购物车 /// </summary> /// <param name="dto"></param> /// <param name="token"></param> /// <returns></returns> public async Task DeleteAsync(ShoppingTrolleyDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.ShopId, out var ShopId)) { throw new NotImplementedException("店铺ID无效!"); } //if (!Guid.TryParse(dto.OwnerCertificationRecordId, out var ocrId)) //{ // throw new NotImplementedException("业主ID无效!"); //} var user = await db.Users.Where(x => x.Id.ToString() == dto.OperationUserId && x.IsDeleted == false).FirstOrDefaultAsync(token); if (user == null) { throw new NotImplementedException("创建人信息不存在!"); } var list = await db.ShoppingTrolleys.Where(item => item.ShopCommodity.GoodsType.ShopId == ShopId && item.CreateOperationUserId == user.Id).ToListAsync(token); db.ShoppingTrolleys.RemoveRange(list); if (await db.SaveChangesAsync(token) <= 0) { throw new NotImplementedException("数据操作失败。"); } } }
public async Task <ShoppingTrolley> GetForShopCommodityIdAsync(ShoppingTrolleyDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { var user = await db.Users.Where(x => x.Id.ToString() == dto.OperationUserId && x.IsDeleted == false).FirstOrDefaultAsync(token); if (user == null) { throw new NotImplementedException("创建人信息不存在!"); } return(await db.ShoppingTrolleys.Where(item => item.ShopCommodityId.ToString() == dto.ShopCommodityId && item.CreateOperationUserId == user.Id).FirstOrDefaultAsync(token)); } }
public async Task <ShoppingTrolley> AddAsync(ShoppingTrolleyDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { //if (!Guid.TryParse(dto.OwnerCertificationRecordId, out var ocrId)) //{ // throw new NotImplementedException("业主ID无效!"); //} if (!Guid.TryParse(dto.ShopCommodityId, out var scId)) { throw new NotImplementedException("店铺商品ID无效!"); } var user = await db.Users.Where(x => x.Id.ToString() == dto.OperationUserId && x.IsDeleted == false).FirstOrDefaultAsync(token); if (user == null) { throw new NotImplementedException("创建人信息不存在!"); } //ShoppingTrolley model = new ShoppingTrolley(); ShoppingTrolley model = await db.ShoppingTrolleys.Where(item => item.ShopCommodityId == scId && item.CreateOperationUserId == user.Id).FirstOrDefaultAsync(token); if (model != null) { model.CommodityCount += dto.CommodityCount; } else { model = db.ShoppingTrolleys.Add(new ShoppingTrolley { //OwnerCertificationRecordId = ocrId, ShopCommodityId = scId, CommodityCount = dto.CommodityCount, CreateOperationTime = dto.OperationTime, CreateOperationUserId = user.Id, LastOperationTime = dto.OperationTime, LastOperationUserId = dto.OperationUserId }); } await db.SaveChangesAsync(token); return(model); } throw new NotImplementedException(); }
/// <summary> /// 更新购物车 /// </summary> /// <param name="dto"></param> /// <param name="token"></param> /// <returns></returns> public async Task UpdateAsync(ShoppingTrolleyDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { //if (!Guid.TryParse(dto.OwnerCertificationRecordId, out var ocrId)) //{ // throw new NotImplementedException("业主ID无效!"); //} if (!Guid.TryParse(dto.ShopCommodityId, out var scId)) { throw new NotImplementedException("店铺商品ID无效!"); } var user = await db.Users.Where(x => x.Id.ToString() == dto.OperationUserId && x.IsDeleted == false).FirstOrDefaultAsync(token); if (user == null) { throw new NotImplementedException("创建人信息不存在!"); } var model = await db.ShoppingTrolleys.Where(item => item.CreateOperationUserId == user.Id && item.ShopCommodityId == scId).FirstOrDefaultAsync(token); if (model == null) { throw new NotImplementedException("购物车商品不存在!"); } if (model.CommodityCount > dto.CommodityCount) { model.CommodityCount -= dto.CommodityCount; } else { db.ShoppingTrolleys.Remove(model); } if (await db.SaveChangesAsync(token) <= 0) { throw new NotImplementedException("数据操作失败!"); } } }
public async Task <List <ShoppingTrolley> > GetAllIncludeAsync(ShoppingTrolleyDto dto, CancellationToken token = default) { using (var db = new GuoGuoCommunityContext()) { if (!Guid.TryParse(dto.ShopId, out var ShopId)) { throw new NotImplementedException("店铺ID无效!"); } //if (!Guid.TryParse(dto.OwnerCertificationRecordId, out var ocrId)) //{ // throw new NotImplementedException("业主ID无效!"); //} var user = await db.Users.Where(x => x.Id.ToString() == dto.OperationUserId && x.IsDeleted == false).FirstOrDefaultAsync(token); if (user == null) { throw new NotImplementedException("创建人信息不存在!"); } return(await db.ShoppingTrolleys.Include(x => x.ShopCommodity.GoodsType.Shop).Where(item => item.ShopCommodity.GoodsType.ShopId == ShopId && item.CreateOperationUserId == user.Id && item.ShopCommodity.IsDeleted == false && item.ShopCommodity.SalesTypeValue == SalesType.Shelf.Value).ToListAsync(token)); } }
public Task <List <ShoppingTrolley> > GetListIncludeAsync(ShoppingTrolleyDto dto, CancellationToken token = default) { throw new NotImplementedException(); }