public async Task <Order> AddAsync(OrderDto dto, CancellationToken token = default)
{
try
{
using (var db = new GuoGuoCommunityContext())
{
if (!Guid.TryParse(dto.ShopId, out var shopId))
{
throw new NotImplementedException("商店id信息不正确！");
}
var smallDistrictShop = await db.SmallDistrictShops.Include(x => x.Shop).Where(x => x.Id == shopId && x.IsDeleted == false).FirstOrDefaultAsync(token);
if (smallDistrictShop == null)
{
throw new NotImplementedException("该商家不存在！");
}
//if (!Guid.TryParse(dto.OwnerCertificationRecordId, out var ownerCertificationRecordId))
//{
// 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 industry = await db.Industries.Include(x => x.BuildingUnit.Building).Where(x => x.Id.ToString() == dto.IndustryId && x.IsDeleted == false).FirstOrDefaultAsync(token);
if (industry == null)
{
throw new NotImplementedException("收货人业户信息不存在！");
}
if (industry.BuildingUnit.Building.SmallDistrictId != smallDistrictShop.SmallDistrictId)
{
throw new NotImplementedException("配送地址不在配送范围内！");
}
var list = await db.ShoppingTrolleys.Include(x => x.ShopCommodity.GoodsType.Shop).Where(item => item.ShopCommodity.GoodsType.ShopId == smallDistrictShop.ShopId && item.CreateOperationUserId == user.Id && item.ShopCommodity.IsDeleted == false).ToListAsync(token);
using (var transaction = db.Database.BeginTransaction())
{
if (!list.Any())
{
throw new NotImplementedException("购物车内无商品！");
}
//折扣价
var price = list.Sum(x => x.CommodityCount * x.ShopCommodity.DiscountPrice);
//正价
var dcRegularPriced = list.Sum(x => x.CommodityCount * x.ShopCommodity.Price);
//先查询店铺活动是否处于开启状态
Shop shop = db.Shops.Where(x => x.Id == smallDistrictShop.ShopId).FirstOrDefault();
List <Activity> activities = new List <Activity>();
//判断店铺是否开启活动
if (shop.ActivitySign == "0")
{
//查询可用的平台活动
activities = db.Activities.Where(x => x.IsDeleted == false && x.ActivitySource == 2 && x.ActivityBeginTime < DateTime.Now && x.ActivityEndTime <= DateTime.Now).OrderByDescending(b => b.Money).ToList();
}
else
{
activities = db.Activities.Where(x => x.IsDeleted == false && x.ActivitySource == 1 && x.ShopId == smallDistrictShop.Id && x.ActivityBeginTime < DateTime.Now && x.ActivityEndTime <= DateTime.Now).OrderByDescending(b => b.Money).ToList();
}
//list已经倒叙，循环判断第一个小于等于的金额
foreach (Activity item in activities)
{
if (item.Money <= price)
{
price = price - item.Off;
break;
}
}
var entity = db.Orders.Add(new Order
{
SmallDistrictShopId = smallDistrictShop.Id,
ShopId = smallDistrictShop.ShopId,
Address = dto.Address,
DeliveryName = dto.DeliveryName,
DeliveryPhone = dto.DeliveryPhone,
Number = dto.Number,
OrderStatusValue = dto.OrderStatusValue,
OrderStatusName = dto.OrderStatusName,
ReceiverName = dto.ReceiverName,
ReceiverPhone = dto.ReceiverPhone,
//OwnerCertificationRecordId = ownerCertificationRecordId,
IndustryId = industry.Id,
LastOperationTime = dto.OperationTime,
LastOperationUserId = dto.OperationUserId,
CreateOperationTime = dto.OperationTime,
CreateOperationUserId = user.Id,
ShopCommodityCount = list.Sum(x => x.CommodityCount),
ShopCommodityPrice = price,
RegularPriced = dcRegularPriced,
Postage = smallDistrictShop.Postage,
PaymentPrice = price + smallDistrictShop.Postage,
PaymentStatusValue = PaymentStatus.Unpaid.Value,
PaymentStatusName = PaymentStatus.Unpaid.Name
});
db.SaveChanges();
foreach (var item in list)
{
db.OrdeItems.Add(new OrderItem
{
CommodityCount = item.CommodityCount,
DiscountPrice = item.ShopCommodity.DiscountPrice,
ShopCommodityId = item.ShopCommodityId,
Price = item.ShopCommodity.Price,
OrderId = entity.Id,
ImageUrl = item.ShopCommodity.ImageUrl,
Name = item.ShopCommodity.Name
});
}
db.SaveChanges();
db.ShoppingTrolleys.RemoveRange(list);
db.SaveChanges();
//提交事务
transaction.Commit();
return(entity);
}
}
}
catch (Exception e)
{
throw new NotImplementedException(e.Message);
}
}
