public void Add(ChargeBackModel chargeBack)
{
if (chargeBack.Details.Count(c => c.Count <= 0) > 0)
{
throw new Exception("退货商品数量无效");
}
try
{
var dbcontext = ServiceProvider.GetDbcontext <IPurocumentDbcontext>();
var order = dbcontext.PurchasingOrder.Include(i => i.Details).SingleOrDefault(s => s.ID.Equals(chargeBack.PurchasingOrderID));
if (order == null || order.ID < 1)
{
throw new Exception("订单不存在");
}
//创建主表
var entity = new Entity.ChargeBack()
{
Code = StrCBPrefix + DateTime.Now.ToString(StrCBSuffixFormat),
PurchasingOrderID = order.ID,
PurchasingOrderStatusID = (int)EnumPurchasingOrderState.DepartmentChargeBack,
CreateTime = chargeBack.CreateTime,
UpdateTime = chargeBack.CreateTime,
CreateUsrID = chargeBack.CreateUsrID,
UpdateUserID = chargeBack.CreateUsrID,
ItemCount = chargeBack.Details.Count(),
Total = Convert.ToDecimal(0)
};
var details = from a in chargeBack.Details
join b in order.Details on a.PurchasingOrderDetailID equals b.ID
select new Entity.ChargeBackDetail()
{
PurchasingOrderDetailID = a.PurchasingOrderDetailID,
Count = a.Count,
Price = b.Price,
Subtotal = a.Count * b.Price,
ChargeBack = entity
};
entity.Total = details.Sum(d => d.Subtotal);
entity.Details = details.ToList();
dbcontext.Add(entity);
//dbcontext.AddRange(details);
//更新订单状态
order.PurchasingOrderStatusID = (int)EnumPurchasingOrderState.DepartmentChargeBack;
order.UpdateUserID = chargeBack.CreateUsrID;
order.UpdateTime = chargeBack.CreateTime;
dbcontext.Update(order);
dbcontext.SaveChanges();
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.Message);
}
}
public void Add(ChargeBackModel chargeBack)
{
if (chargeBack.Details.Count(c => c.Count <= 0) > 0)
{
throw new Exception("退货商品数量无效");
}
try
{
var dbcontext = ServiceProvider.GetDbcontext <IPurocumentDbcontext>();
var order = dbcontext.PurchasingOrder.Include(i => i.Details).SingleOrDefault(s => s.ID.Equals(chargeBack.PurchasingOrderID));
if (order == null || order.ID < 1)
{
throw new Exception("订单不存在");
}
DateTime dtNow = DateTime.Now;
//创建主表
var entity = new Entity.ChargeBack()
{
Code = StrCBPrefix + DateTime.Now.ToString(StrCBSuffixFormat),
PurchasingOrderID = order.ID,
PurchasingOrderStatusID = (int)EnumPurchasingOrderState.DepartmentChargeBack,
CreateTime = chargeBack.CreateTime,
UpdateTime = chargeBack.CreateTime,
CreateUsrID = chargeBack.CreateUsrID,
UpdateUserID = chargeBack.CreateUsrID,
ItemCount = chargeBack.Details.Count(),
Total = Convert.ToDecimal(0)
};
int intDepartmentID = order.DepartmentID;
string strOrderCode = entity.Code;
string strCode = string.Empty;
string strDateTime = dtNow.ToString(StrDateTimeFormat);
//string result = isPass ? "通过" : $"未通过:{Desc}";
string title = string.Empty;
string content = string.Empty;
string toUsrID = string.Empty;
var details = from a in chargeBack.Details
join b in order.Details on a.PurchasingOrderDetailID equals b.ID
select new Entity.ChargeBackDetail()
{
PurchasingOrderDetailID = a.PurchasingOrderDetailID,
Count = a.Count,
Price = b.Price,
Subtotal = a.Count * b.Price,
ChargeBack = entity
};
entity.Total = details.Sum(d => d.Subtotal);
entity.Details = details.ToList();
dbcontext.Add(entity);
//dbcontext.AddRange(details);
//更新订单状态
order.PurchasingOrderStatusID = (int)EnumPurchasingOrderState.DepartmentChargeBack;
order.UpdateUserID = chargeBack.CreateUsrID;
order.UpdateTime = chargeBack.CreateTime;
dbcontext.Update(order);
dbcontext.SaveChanges();
Department department = dbcontext.Department.SingleOrDefault(s => s.ID == intDepartmentID);
var toUsrs = dbcontext.Usr.Where(w =>
w.RoleID == (int)EnumRole.测试 ||
w.RoleID == (int)EnumRole.采购员
).ToList();
var toUsrIDs = toUsrs.Select(s => s.WechatID);
var toUserWechatIDs = toUsrs.Select(s => s.WechatID);
toUsrID = string.Join("|", toUsrs.Select(s => s.WechatID).ToArray());
title = "待审核退货计划";
content = $"订单编号:{strOrderCode} 退货编号:{strCode} 部门:{department?.Name}";
MessageService.Post(
toUsrID,
title,
strDateTime,
content
);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.Message);
}
}
