public APIResult Update([FromBody] UpdateArgsModel args) { if (string.IsNullOrEmpty(args.Name)) { throw new ArgumentNullException("Name"); } if (string.IsNullOrEmpty(args.Flag)) { args.Flag = System.Guid.NewGuid().ToString(); } var model = db.Query <ShopBrandCommodityParameter>() .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } //在获取后检查是否拥有管理权限 CheckShopBrandActor(model.ShopBrandId, ShopBrandActorType.超级管理员); model.Name = args.Name; db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { if (string.IsNullOrEmpty(args.Name)) { throw new ArgumentNullException("Name"); } if (string.IsNullOrEmpty(args.Flag)) { args.Flag = System.Guid.NewGuid().ToString(); } if (!args.Status.HasValue) { args.Status = ShopBrandStatus.正常; } var model = db.Query <ShopBrand>() .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } model.Flag = args.Flag; model.Name = args.Name; model.Status = args.Status.Value; model.Detail = args.Detail; model.Address = args.Address; db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { if (!args.Id.HasValue) { throw new ArgumentNullException("Id"); } CheckShopBrandActor(args.Id.Value, ShopBrandActorType.超级管理员); if (string.IsNullOrEmpty(args.Name)) { throw new ArgumentNullException("Name"); } var model = db.Query <ShopBrand>() .Where(m => !m.IsDel) .Where(m => m.Id == args.Id.Value) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } model.Address = args.Address; model.Detail = args.Detail; model.Name = args.Name; model.Cover = args.Cover; model.Logo = args.Logo; db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { try { var model = memberDb.QueryMember() .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } if (model.Email != args.Email) {//如果Email有改变,则需要判断一下email有没有被使用 if (memberDb.MemberEmailIsUsed(model.Email)) { throw new Exception("Email is Used"); } } model.Truename = args.Truename; model.Email = args.Email; model.EmailIsValid = args.EmailIsValid; model.Status = args.Status; memberDb.SaveChanges(); return(Success()); } catch (Exception ex) { return(Error(ex.Message)); } }
public APIResult SetingBannerUpdate([FromBody] UpdateArgsModel model) { try { var viewModel = _db.BannerConfiguration.Find(model.Id); //_db.Query<BannerConfiguration>().Where(m => m.Id == model.Id.Value).FirstOrDefault(); if (viewModel == null) { return(Error("未找到BannerConfiguration")); } if (string.IsNullOrEmpty(model.Name)) { return(Error("请填写广告图名称")); } viewModel.Name = model.Name; viewModel.Url = model.Url; viewModel.Link = model.Link; viewModel.IsShow = model.IsShow; viewModel.IsDel = model.IsDel; viewModel.Sorting = model.Sorting; //此处映射出错 // var banner = _mapper.Map<BannerSetingAPIModels,BannerConfiguration>(model); //_db.Update(banner); _db.SaveChanges(); return(Success()); } catch (Exception ex) { throw new Exception(ex.Message); } }
public APIResult Update([FromBody] UpdateArgsModel args) { var model = db.Query <ShopBrandCommodityCategory>() .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } //在获取后检查是否拥有管理权限 CheckShopBrandActor(model.ShopBrandId, ShopBrandActorType.超级管理员); if (model.Id == args.PId) { throw new Exception("自己的父类不能是自己"); } if (model.PId != args.PId && args.PId.HasValue) {//说明父类有变更,并且不是在根下,那么需要判定一下旧的类别是否是当前新的类别的父类 List <int> ids = new List <int>(); Action <int> getChildrenIds = null; getChildrenIds = id => { var chidrenIds = db.Query <ShopBrandCommodityCategory>().Where(m => m.PId == id).Select(m => m.Id).ToList(); ids.AddRange(chidrenIds); foreach (var item in chidrenIds) { getChildrenIds(item); } }; getChildrenIds(model.Id); if (ids.Contains(args.PId.Value)) { throw new Exception("不能放在自己的子目录下面"); } } model.PId = args.PId; model.Name = args.Name; model.OrderWeight = args.OrderWeight; model.Detail = args.Detail; //有值才修改,没有值不修改 if (!string.IsNullOrEmpty(model.Flag)) { model.Flag = args.Flag; } model.Ico = args.Ico; model.Tags = args.Tags; model.Keywords = args.Keywords; model.Description = args.Description; db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { if (string.IsNullOrEmpty(args.Name)) { throw new ArgumentNullException("Name"); } if (string.IsNullOrEmpty(args.Flag)) { args.Flag = System.Guid.NewGuid().ToString(); } var model = db.Query <Shop>() .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } var brand = db.GetSingle <ShopBrand>(args.ShopBrandId); if (brand == null) { throw new Exception("指定的商铺品牌不存在"); } model.ShopBrand = brand; model.Flag = args.Flag; model.Address = args.Address; model.AddressGuide = args.AddressGuide; model.Detail = args.Detail; model.Latitude = args.Latitude; model.Longitude = args.Longitude; model.Name = args.Name; model.OpenTime = args.OpenTime; model.ScoreValue = args.ScoreValue; model.Tel = args.Tel; model.UsePerUser = args.UsePerUser; model.Logo = args.Logo; model.IsShowApplets = args.IsShowApplets; model.Phone = args.Phone; if (model.Latitude.HasValue && model.Longitude.HasValue) { model.GeoHash = Geohash.Encode(model.Latitude.Value, model.Longitude.Value); } else { model.GeoHash = string.Empty; } db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { var model = db.Query <ShopCallingQueueProduct>() .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } model.Detail = args.Detail; model.Title = args.Title; model.Status = args.Status; db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { var model = db.Query <ShopPart>() .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } //在获取后检查是否拥有管理权限 CheckShopActor(model.ShopId, ShopActorType.超级管理员); model.Title = args.Title; model.Detail = args.Detail; db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { var model = db.Query <ShopCommodityStock>() .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } model.Stock = args.Stock; model.CostPrice = args.CostPrice; model.SalePrice = args.SalePrice; model.MarketPrice = args.MarketPrice; db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { if (string.IsNullOrEmpty(args.Name)) { throw new ArgumentNullException("Name"); } if (string.IsNullOrEmpty(args.Flag)) { args.Flag = System.Guid.NewGuid().ToString(); } if (!args.Status.HasValue) { args.Status = CommercialDistrictStatus.正常; } var model = db.Query <CommercialDistrict>() .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } model.Flag = args.Flag; model.Name = args.Name; model.Status = args.Status.Value; model.Detail = args.Detail; model.Address = args.Address; model.Longitude = args.Longitude; model.Latitude = args.Latitude; if (model.Latitude.HasValue && model.Longitude.HasValue) { model.GeoHash = Geohash.Encode(model.Latitude.Value, model.Longitude.Value); } else { model.GeoHash = string.Empty; } db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { try { var model = wechatCoreDb.QueryRobotMessage() .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } model.Answer = args.Answer; wechatCoreDb.SaveChanges(); return(Success()); } catch (Exception ex) { return(Error(ex.Message)); } }
public APIResult Update([FromBody] UpdateArgsModel args) { if (string.IsNullOrEmpty(args.Name)) { throw new ArgumentNullException("Name"); } if (string.IsNullOrEmpty(args.Flag)) { args.Flag = System.Guid.NewGuid().ToString(); } var model = db.Query <ShopBrandCommodity>() .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } var category = db.GetSingle <ShopBrandCommodityCategory>(args.CategoryId); if (category == null) { throw new Exception("店铺商品类别不存在"); } model.Category = category; model.Detail = args.Detail; model.Name = args.Name; model.Cover = args.Cover; model.IsRecommand = args.IsRecommand; model.Price = args.Price; model.SalesForMonth = args.SalesForMonth; model.Summary = args.Summary; model.Unit = args.Unit; model.Upvote = args.Upvote; db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { var model = db.Query <ShopCallingQueueProduct>() .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } //获取到订单后判断是否拥有指定的店铺的权限 CheckShopActor(model.ShopId, ShopActorType.超级管理员); model.Detail = args.Detail; model.Title = args.Title; model.Name = args.Name; model.Status = args.Status; db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { var commodity = db.GetSingle <ShopBrandCommodity>(args.CommodityId.Value); if (commodity == null) { throw new Exception("商品纪录不存在"); } var parameterIds = args.ParameterIds; //套餐商品只能添加一个规格 if (commodity.CategoryId == 0) { if (args.ParameterIds.Count > 1) { throw new Exception("套餐只能添加单个规格"); } if (args.ParameterIds.Count != 0) { var pvListCount = db.Query <ShopBrandCommodityParameterValue>() .Where(m => !m.IsDel) .Where(m => parameterIds.Contains(m.ParameterId)) .Count(); if (pvListCount != 1) { throw new Exception("套餐只能添加单个规格"); } } } //在获取后检查是否拥有管理权限 CheckShopBrandActor(commodity.ShopBrandId, ShopBrandActorType.超级管理员); //获取到旧的skuParameter var skus = db.Query <ShopBrandCommoditySku>() .Where(m => !m.IsDel) .Where(m => m.CommodityId == args.CommodityId) .ToList(); //删掉原来的 foreach (var sku in skus) { sku.IsDel = true; } var skuIds = skus.Select(m => m.Id).ToList(); //删掉原来的 var skuItems = db.Query <ShopBrandCommoditySkuItem>() .Where(m => !m.IsDel) .Where(m => skuIds.Contains(m.SkuId)) .ToList(); foreach (var skuItem in skuItems) { skuItem.IsDel = true; } var oldParameterIds = skuItems.Select(m => m.ParameterId).Distinct().ToList(); //判定新的跟旧的是否一样,如果一样,则不需要修改 //判定的方法是获得并集,如果两个集的长度相等并且合并后长度还是等于新的长度,则表示是一样的 if (oldParameterIds.Count == args.ParameterIds.Count && oldParameterIds.Union(args.ParameterIds).Count() == args.ParameterIds.Count) { throw new Exception("当前数据跟提交数据一样,不需要修改"); } //需要判定一下是否sku已经在使用,如果在使用,则不能删除 var usedSkuCount = db.Query <ShopCommodityStock>() .Where(m => !m.IsDel) .Where(m => skuIds.Contains(m.SkuId)) .Count(); if (usedSkuCount > 0) { throw new Exception("原规格还在使用中,不能修改"); } var paramterCount = db.Query <ShopBrandCommodityParameter>() .Where(m => !m.IsDel) .Where(m => parameterIds.Contains(m.Id)) .Count(); if (parameterIds.Count != paramterCount) { throw new Exception("参数有误,请刷新重试"); } var paramterValues = db.Query <ShopBrandCommodityParameterValue>() .Where(m => !m.IsDel) .Where(m => parameterIds.Contains(m.ParameterId)) .Select(m => new { ParameterId = m.ParameterId, Id = m.Id, ParameterName = m.Parameter.Name, ParameterValue = m.Value }) .OrderBy(m => m.Id) .ToList(); //得到新的sku列表 var newSkus = new List <List <int> >(); newSkus.Add(new List <int> { commodity.Id }); foreach (var parameterId in parameterIds) { var values = paramterValues.Where(m => m.ParameterId == parameterId).Select(m => m.Id).ToList(); newSkus = CombineArray(newSkus, values); } foreach (var newSkuItems in newSkus) { var sku = new ShopBrandCommoditySku() { CommodityId = commodity.Id, Flag = string.Join('_', newSkuItems.AsQueryable().OrderBy(m => m)), Summary = string.Empty }; db.Add <ShopBrandCommoditySku>(sku); for (int i = 1; i < newSkuItems.Count; i++) {//0位为parameterId,这里从1开始 var parameterValueId = newSkuItems[i]; var paramValue = paramterValues.Where(m => m.Id == parameterValueId).First(); db.Add(new ShopBrandCommoditySkuItem() { ParameterId = paramValue.ParameterId, ParameterValueId = parameterValueId, Sku = sku }); sku.Summary += $"{paramValue.ParameterName}:{paramValue.ParameterValue},"; } sku.Summary = sku.Summary.TrimEnd(','); } db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { if (!args.Id.HasValue) { throw new ArgumentNullException("Id"); } CheckShopActor(args.Id.Value, ShopActorType.超级管理员); if (string.IsNullOrEmpty(args.Name)) { throw new ArgumentNullException("Name"); } var model = db.Query <Shop>() .Where(m => !m.IsDel) .Where(m => m.Id == args.Id.Value) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } model.Address = args.Address; model.AddressGuide = args.AddressGuide; model.Detail = args.Detail; model.Name = args.Name; model.OpenTime = args.OpenTime; model.Tel = args.Tel; model.UsePerUser = args.UsePerUser; model.Logo = args.Logo; model.Cover = args.Cover; model.Longitude = args.Longitude; model.Latitude = args.Latitude; model.AreaCode = args.AreaCode; model.AreaText = args.AreaText; List <BannerModel> bannermodel = new List <BannerModel>(); string bannerjson = string.Empty; try { if (args.Banners != null && args.Banners != "") { var banners = args.Banners.Split(","); for (int i = 0; i < banners.Length; i++) { bannermodel.Add(new BannerModel() { Id = i + 1, Name = banners[i], Url = "http://91huichihuihe.oss-cn-shenzhen.aliyuncs.com/" + banners[i], Sorting = i + 1, IsShow = true }); } bannerjson = JsonConvert.SerializeObject(bannermodel); } } catch (Exception ex) { throw new Exception(ex.Message); } model.Banners = bannerjson; db.SaveChanges(); return(Success()); }
public APIResult Update([FromBody] UpdateArgsModel args) { if (string.IsNullOrEmpty(args.Name)) { throw new ArgumentNullException("Name"); } if (string.IsNullOrEmpty(args.Flag)) { args.Flag = System.Guid.NewGuid().ToString(); } var model = db.Query <ShopBrandCommodity>() .Where(m => !m.IsDel) .Where(m => m.Id == args.Id) .FirstOrDefault(); if (model == null) { throw new Exception("数据库记录不存在"); } //在获取后检查是否拥有管理权限 CheckShopBrandActor(model.ShopBrandId, ShopBrandActorType.超级管理员); ShopBrandCommodityCategory category; if (args.CategoryId == 0) { category = null; } else { category = db.GetSingle <ShopBrandCommodityCategory>(args.CategoryId); if (category == null) { throw new Exception("店铺商品类别不存在"); } } model.Category = category; model.Detail = args.Detail; model.Name = args.Name; model.Cover = args.Cover; model.IsRecommand = args.IsRecommand; model.Price = args.Price; model.SalesForMonth = args.SalesForMonth; model.Summary = args.Summary; model.Unit = args.Unit; model.IsTakeout = args.IsTakeout; model.IsScanCode = args.IsScanCode; model.IsSelfOrder = args.IsSelfOrder; model.Upvote = args.Upvote; model.UseMemberPrice = args.UseMemberPrice; //model.DiningWay = args.DiningWay; if (args.CategoryId == 0) //套餐 { foreach (var commodityId in args.CommodityIds) { db.Query <ShopOrderComboItem>() .Where(m => !m.IsDel && m.Pid == model.Id) .ToList() .ForEach(m => m.IsDel = true); ShopOrderComboItem comboItem = new ShopOrderComboItem() { ParentCommodity = model, CommodityId = commodityId }; db.Add(comboItem); } } db.SaveChanges(); return(Success()); }