/// <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));
}
