/// <summary>
        /// 添加商品信息
        /// </summary>
        /// <param name="goodInfo">基本信息</param>
        /// <param name="goodInfoExtensions">扩展信息</param>
        public async Task <DataResult> AddGoodInfo(GoodInfo goodInfo, GoodInfoExtensions goodInfoExtensions, List <GoodInfoSKU> skuList)
        {
            ShopInfoExtensions shopInfoExtensions = await shopInfoExtensionsDbSet.FirstOrDefaultAsync(sh => sh.ShopId == goodInfo.ShopId);

            int goodCount = await CurrentDbSet.CountAsync(gr => gr.ShopId == goodInfo.ShopId);

            if (goodCount >= shopInfoExtensions.LimitGoodNum)
            {
                return new DataResult {
                           Code = DataResultCode.Fail, Message = $"最多只能拥有{shopInfoExtensions.LimitGoodNum}个商品!"
                }
            }
            ;


            using (IDbContextTransaction transaction = Database.BeginTransaction(IsolationLevel.ReadCommitted))
            {
                try
                {
                    await CurrentDbSet.AddAsync(goodInfo);

                    await goodInfoExtensionsDbSet.AddAsync(goodInfoExtensions);

                    await goodInfoSKUDbSet.AddRangeAsync(skuList);

                    string sql    = $"update ShopInfoExtensions set GoodDataVersion = @newVersion where shopId = @shopId and GoodDataVersion = @oldVersion";
                    int    result = this.Database.ExecuteSqlCommand(sql, new[]
                    {
                        new MySqlParameter("newVersion", Guid.NewGuid().ToString("N")),
                        new MySqlParameter("oldVersion", shopInfoExtensions.GoodDataVersion),
                        new MySqlParameter("shopId", shopInfoExtensions.ShopId),
                    });

                    if (result <= 0)
                    {
                        transaction.Rollback();
                        return(new DataResult {
                            Code = DataResultCode.Fail, Message = "添加失败,请重试!"
                        });
                    }

                    SaveChanges();
                    transaction.Commit();
                }
                catch
                {
                    transaction.Rollback();
                    return(new DataResult {
                        Code = DataResultCode.Fail, Message = "添加失败,请重试!"
                    });
                }
            }

            return(new DataResult {
                Code = DataResultCode.Success, Message = "添加成功!"
            });
        }
Example #2
0
        public async Task <DataResult> AddFileData(FileData fileData)
        {
            ShopInfoExtensions shopInfoExtensions = await shopInfoExtensionsDbSet.FirstOrDefaultAsync(sh => sh.ShopId == fileData.ShopId);

            int fileCount = await CurrentDbSet.CountAsync(gr => gr.ShopId == fileData.ShopId);

            if (fileCount >= shopInfoExtensions.LimitFileNum)
            {
                return new DataResult {
                           Code = DataResultCode.Fail, Message = $"该商店最多只能拥有{shopInfoExtensions.LimitFileNum}张图片!"
                }
            }
            ;

            using (IDbContextTransaction transaction = Database.BeginTransaction(IsolationLevel.ReadCommitted))
            {
                CurrentDbSet.Add(fileData);

                string sql    = $"update ShopInfoExtensions set FileDataVersion = @newVersion where shopId = @shopId and FileDataVersion = @oldVersion";
                int    result = this.Database.ExecuteSqlCommand(sql, new[]
                {
                    new MySqlParameter("newVersion", Guid.NewGuid().ToString("N")),
                    new MySqlParameter("oldVersion", shopInfoExtensions.FileDataVersion),
                    new MySqlParameter("shopId", shopInfoExtensions.ShopId),
                });

                if (result <= 0)
                {
                    transaction.Rollback();
                    return(new DataResult {
                        Code = DataResultCode.Fail, Message = "添加失败,请重试!"
                    });
                }

                SaveChanges();
                transaction.Commit();
            }

            return(new DataResult {
                Code = DataResultCode.Success, Message = "添加成功!"
            });
        }
    }
Example #3
0
        public void Test()
        {
            string             shopId             = "1";
            ShopInfoExtensions shopInfoExtensions = new ShopInfoExtensions {
                ShopId = shopId, LimitFileNum = 100, LimitGroupNum = 100
            };

            shopInfoExtensions.GroupDataVersion = Guid.NewGuid().ToString("N");
            shopInfoExtensions.FileDataVersion  = Guid.NewGuid().ToString("N");
            IShopInfoExtensionsBusiness shopInfoExtensionsBusiness = BusinessFactory.GetBusiness <IShopInfoExtensionsBusiness>();

            shopInfoExtensionsBusiness.Delete(shopId);
            shopInfoExtensionsBusiness.Add(shopInfoExtensions);

            IFileGroupBusiness fileGroupBusiness = BusinessFactory.GetBusiness <IFileGroupBusiness>();
            var f = fileGroupBusiness.Get(shopId, "123");

            Assert.Null(f);
            FileGroup fg = new FileGroup();

            fg.Name   = "test";
            fg.ShopId = shopId;
            var res = fileGroupBusiness.Add(fg).Result;

            Assert.False(res.Code == 0);
            fg.Name = "test2";
            fg      = fileGroupBusiness.Update(fg);
            Assert.False(fg.Name != "test2");
            var res2 = fileGroupBusiness.GetByShopId(shopId).Result;

            Assert.False(res2.Count == 0);
            fileGroupBusiness.Delete(shopId, fg.Id);
            var res3 = fileGroupBusiness.GetByShopId(shopId).Result;

            Assert.True(res3.Count == 0);
        }
 public ShopInfoExtensions Update(ShopInfoExtensions shopInfoExtensions)
 {
     shopInfoExtensionsContext.Update(shopInfoExtensions);
     return(shopInfoExtensionsContext.SingleOrDefault(f => f.ShopId == shopInfoExtensions.ShopId));
 }