/// <summary> /// 获取套餐内内容 /// </summary> /// <param name="db"></param> /// <param name="shopOrderItem"></param> /// <param name="logger"></param> /// <returns></returns> static List <ComboConten> GetPrintComboContenParameter(ShopDbContext db, ShopOrderItem shopOrderItem, ILogger logger) { List <ComboConten> comboContens = new List <ComboConten>(); try { var shopBrandCommodity = ( from b in db.ShopCommoditySku where shopOrderItem.CommodityStockId == b.Id join c in db.ShopBrandCommoditySkus on b.SkuId equals c.Id join d in db.ShopBrandCommoditys on c.CommodityId equals d.Id where !b.IsDel && !d.IsDel select d).FirstOrDefault(); if (shopBrandCommodity.CategoryId == 0) { var shopOrderComboItem = db.ShopOrderComboItems.Where(m => m.Pid.Equals(shopBrandCommodity.Id) && !m.IsDel); foreach (var item in shopOrderComboItem) { ComboConten comboConten = new ComboConten(); var shopBrandCommoditys = db.ShopBrandCommoditys.Find(item.CommodityId); comboConten.Name = shopBrandCommoditys.Name; comboConten.Count = 0; comboContens.Add(comboConten); } } return(comboContens); } catch (Exception e) { logger.LogInformation($"获取套餐打印内容错误,错误信息:{e}"); return(comboContens); } }
/// <summary> /// 更新数据 /// </summary> /// <param name="model">实体类</param> /// <param name="whereString">可选,更新条件</param> /// <returns></returns> public bool Update(ShopOrderItem model, string whereString = null) { return(CreateDao().Update(model, whereString)); }
/// <summary> /// 新增数据,并返回自增ID /// </summary> /// <param name="model">实体类</param> /// <returns></returns> public int InsertIdentity(ShopOrderItem model) { return(CreateDao().InsertIdentity(model)); }
/// <summary> /// 新增数据 /// </summary> /// <param name="model">实体类</param> /// <returns></returns> public bool Insert(ShopOrderItem model) { return(CreateDao().Insert(model)); }
public APIResult Add([FromBody] AddArgsModel args) { //TODO:这里还需要进行锁操作,保证每个店铺的库存不是负数 if (args.Items == null || args.Items.Count <= 0) { throw new Exception("商品内容不能为空"); } bool isTakeOut = args.IsTakeOut == null ? false : args.IsTakeOut.Value; bool isThird = false; var memberId = GetMemberId(); var shop = db.Query <Shop>() .Where(m => !m.IsDel) .Where(m => m.Id == args.ShopId) .FirstOrDefault(); if (shop == null) { throw new Exception("商铺纪录不存在"); } ShopMember shopMember = ShopMemberServer.GetShopMember(db, shop.Id, memberId); var shopMemberSet = ShopMemberServer.GetShopMemberSet(db, shop.Id); bool IsTopUpDiscount = shopMemberSet == null ? false : shopMemberSet.IsTopUpDiscount; double memberDiscount = 1; if (shopMember != null) { var shopMemberLevel = db.GetSingle <ShopMemberLevel>(shopMember.ShopMemberLevelId); if (shopMemberLevel != null) { memberDiscount = shopMemberLevel.Discount; } } var shoptakeoutinfo = db.ShopTakeOutInfo.FirstOrDefault(r => r.ShopId == args.ShopId && !r.IsDel); if (shoptakeoutinfo != null && shoptakeoutinfo.TakeDistributionType == TakeDistributionType.达达配送 && isTakeOut && args.TakeWay == TakeWay.送货上门) { isThird = true; } var model = new ShopOrder() { AddTime = DateTime.Now, MemberId = memberId, ShopId = args.ShopId, Remark = args.Remark, AddUser = $"member{memberId}", AddIp = GetIp(), Flag = Guid.NewGuid().ToString(), IsTakeOut = isTakeOut, Status = ShopOrderStatus.待支付, takeDistributionType = isThird == true ? TakeDistributionType.达达配送 : TakeDistributionType.商家配送 }; ShopOrderServer shopOrderServer = new ShopOrderServer(model); db.AddTo(model); if (isTakeOut) { shopOrderServer.RecordTakeout(db, shop, memberId, args.TakeWay.Value, args.PickupTime); } else if (args.IsSelfHelp.HasValue && args.IsSelfHelp.Value) { shopOrderServer.RecordShopOrderSelfHelp(db, shop.Id, args.IsSelfHelpTakeOut ?? false); } else if (!string.IsNullOrEmpty(args.ShopPartFlag)) { shopOrderServer.RecordScancode(db, args.ShopPartFlag); } else { throw new Exception("请先扫描桌上二唯码"); } int cartCount = 0; args.Items.ForEach(m => cartCount += m.Count); shopOrderServer.RecordOtherFee(db, args.TakeWay, cartCount); var commodityIdAndCounts = new Dictionary <int, int>(); //商铺库存判断 foreach (var item in args.Items) { var stock = db.Query <ShopCommodityStock>() .Where(m => !m.IsDel) .Where(m => m.ShopId == shop.Id) .Where(m => m.Sku.Flag == item.SkuFlag) .Select(m => new { m.Id, m.Stock, IsCombo = m.Sku.Commodity.CategoryId == 0, //是否套餐 CommodityName = m.Sku.Commodity.Name, m.Sku.CommodityId, m.CostPrice, m.SalePrice, m.MarketPrice, HasVipPrice = m.Sku.Commodity.UseMemberPrice, SkuSummary = m.Sku.Summary }) .FirstOrDefault(); if (stock == null) { throw new Exception("商品不存在或者商铺商品未上架"); } if (stock.Stock <= 0 || stock.Stock < item.Count) { throw new Exception("库存不足"); } db.AddStock(stock.Id, -item.Count); //纪录下commodity的count if (commodityIdAndCounts.ContainsKey(stock.CommodityId)) { commodityIdAndCounts[stock.CommodityId] += item.Count; } else { commodityIdAndCounts.Add(stock.CommodityId, item.Count); } var orderItem = new ShopOrderItem() { CommodityName = stock.CommodityName, CommodityStockId = stock.Id, AddIp = model.AddIp, AddTime = model.AddTime, AddUser = model.AddUser, CostPrice = stock.CostPrice, SalePrice = (stock.HasVipPrice && !stock.IsCombo && (!IsTopUpDiscount || args.IsBalance)) ? ShopMemberServer.GetMemberPrice(stock.SalePrice, memberDiscount) : stock.SalePrice, PrimePrice = stock.SalePrice, ShopOrder = model, Count = item.Count, SkuSummary = stock.SkuSummary }; db.AddTo(orderItem); model.Amount += orderItem.SalePrice * orderItem.Count; } if (args.ComboPrice.HasValue) { model.Amount += args.ComboPrice.Value; } //这里尝试扣钱 //var memberAmount = db.GetMemberAmountList(memberId); //var availAmount = memberAmount.GetAvailAmount(); //if (availAmount >= model.Amount) //{ // memberAmount.DecreaseAvailAmount(model.Amount, 0, $"{shop.Name}消费", Newtonsoft.Json.JsonConvert.SerializeObject(new { shopId = shop.Id, orderFlag = model.Flag }), FinaceType.商品购买支出); // memberAmount.UpdateMemberAmountCache(); // model.PayTime = DateTime.Now; // //更新商品的销售量 // //注意,这里如果有一个品牌,多个店铺的情况,会出现销售额共享的情况 // var commodityIds = commodityIdAndCounts.Select(m => m.Key).ToList(); // var commoditys = db.Query<ShopBrandCommodity>() // .Where(m => commodityIds.Contains(m.Id)) // .ToList(); // foreach (var item in commoditys) // { // item.SalesForMonth += commodityIdAndCounts[item.Id]; // } // db.SaveChanges(); // AfterOrderPlacing(model, shop.Name); //} //else //{ // db.SaveChanges(); //} model.OrderNumber = shopOrderServer.GenerateOrderNumber(); shopOrderServer.ComputePayment(db); db.SaveChanges(); model.Shop = null; //不返回商店信息 return(Success(model)); }