Ejemplo n.º 1
0
        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);
            }
        }
Ejemplo n.º 2
0
        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);
            }
        }