public ViewResult Copy(int id) { SE_GiftManageConfigModel model = new SE_GiftManageConfigModel(); var U_ChannelPayList = SE_GiftManageConfigBLL.GetU_ChannelPayList(); if (id > 0) { model = SE_GiftManageConfigBLL.GetEntity(id); if (!string.IsNullOrWhiteSpace(model.Channel)) { U_ChannelPayList?.ToList().ForEach(_ => { var channels = model.Channel.Split(','); foreach (var item in channels) { if (_.ChannelKey.Contains(item)) { _.IsChecked = true; } } }); } _CreateLogs = model; } ViewBag.U_ChannelPayList = U_ChannelPayList; ViewBag.B_Categorys = SE_MDBeautyPartConfigController.InteriorCategorysTreeJson(model.B_Categorys); return(View(model)); }
public static bool Update(SE_GiftManageConfigModel model) { try { var giftFlag = true; var reGiftP = SE_GiftManageConfigDAL.DeleteGiftProductConfig(model.Id); giftFlag = giftFlag && reGiftP >= 0; var giftProductModels = JsonConvert.DeserializeObject <List <GiftStockModel2> >(model.GiftProducts); foreach (var g in giftProductModels) { g.RuleId = model.Id; giftFlag = giftFlag && SE_GiftManageConfigDAL.MergeIntoGiftProductStock(g.Pid, g.Stock, model.Id) > 0; giftFlag = giftFlag && SE_GiftManageConfigDAL.InsertGiftProductConfig(g) > 0; } var result = SE_GiftManageConfigDAL.Update(ProcessConnection.OpenConfiguration, model) && giftFlag; // 按PID配置赠品后刷新牛皮癣缓存 RefreshGiftPicture(model); return(result); } catch (Exception ex) { throw ex; } }
public ActionResult Save(SE_GiftManageConfigModel model) { model.ActivityType = 2; var dataSource = model; if (model.Id <= 0) { dataSource.Creater = User.Identity.Name; dataSource.CreateTime = DateTime.Now; DiscountManageConfigManage.Insert(dataSource, new SE_DictionaryConfigModel { ParentId = dataSource.Id, Key = "SE_GiftManageConfig", Extend1 = _CreateLogs != null ? JsonConvert.SerializeObject(_CreateLogs) : "", Extend2 = dataSource != null ? JsonConvert.SerializeObject(dataSource) : "", Extend3 = dataSource.Mender, Extend4 = "新增", CreateTime = DateTime.Now, UpdateTime = DateTime.Now }); //Logs(dataSource, "新增"); } else { dataSource.Mender = User.Identity.Name; dataSource.UpdateTime = DateTime.Now; if (DiscountManageConfigManage.Update(dataSource)) { Logs(dataSource, "更新"); } } return(RedirectToAction("Index")); }
public static bool Insert(SE_GiftManageConfigModel model, SE_DictionaryConfigModel log) { try { var result = SE_GiftManageConfigDAL.Insert(ProcessConnection.OpenConfiguration, model); var giftFlag = true; log.ParentId = result; //var reGiftP = SE_GiftManageConfigDAL.DeleteGiftProductConfig(result); var giftProductModels = JsonConvert.DeserializeObject <List <GiftStockModel2> >(model.GiftProducts); foreach (var g in giftProductModels) { g.RuleId = result; g.IsGiveAway = model.GiveAway; giftFlag = giftFlag && SE_GiftManageConfigDAL.MergeIntoGiftProductStock(g.Pid, g.Stock, result) > 0; giftFlag = giftFlag && SE_GiftManageConfigDAL.InsertGiftProductConfig(g) > 0; } // 按PID配置赠品后刷新牛皮癣缓存 RefreshGiftPicture(model); return(result > 0 && SE_GiftManageConfigDAL.InsertLog(ProcessConnection.OpenConfiguration, log) && giftFlag); } catch (Exception ex) { throw ex; } }
public static bool Update(SE_GiftManageConfigModel model) { try { return(DiscountManageConfigDal.Update(ProcessConnection.OpenConfiguration, model)); } catch (Exception ex) { throw ex; } }
public static bool Insert(SE_GiftManageConfigModel model, SE_DictionaryConfigModel log) { try { var result = DiscountManageConfigDal.Insert(ProcessConnection.OpenConfiguration, model); log.ParentId = result; //var reGiftP = SE_GiftManageConfigDAL.DeleteGiftProductConfig(result); return(SE_GiftManageConfigDAL.InsertLog(ProcessConnection.OpenConfiguration, log)); } catch (Exception ex) { throw ex; } }
public ActionResult Save(SE_GiftManageConfigModel model) { model.ActivityType = 2; var dataSource = model; if (model.Id <= 0) { dataSource.Creater = User.Identity.Name; dataSource.CreateTime = DateTime.Now; DiscountManageConfigManage.Insert(dataSource, new SE_DictionaryConfigModel { ParentId = dataSource.Id, Key = "SE_GiftManageConfig", Extend1 = _CreateLogs != null ? JsonConvert.SerializeObject(_CreateLogs) : "", Extend2 = dataSource != null ? JsonConvert.SerializeObject(dataSource) : "", Extend3 = dataSource.Mender, Extend4 = "新增", CreateTime = DateTime.Now, UpdateTime = DateTime.Now }); //Logs(dataSource, "新增"); } else { dataSource.Mender = User.Identity.Name; dataSource.UpdateTime = DateTime.Now; if (DiscountManageConfigManage.Update(dataSource)) { Logs(dataSource, "更新"); } } RefreshCache(); if (dataSource.P_PID != null) { var pidModel = JsonConvert.DeserializeObject <List <PidModel> >(dataSource.P_PID); var pids = pidModel.Select(r => r.Pid).ToList(); if (pids.Any()) { Thread.Sleep(50); TuhuNotification.SendNotification("notification.productModify.ProductCommonTag", new { type = "RebuildCache", pids, tag = ProductCommonTag.Discount }); } } return(RedirectToAction("Index")); }
public static bool Update(SqlConnection connection, SE_GiftManageConfigModel model) { using (IDbConnection conn = connection) { string sql = @" UPDATE Configuration.dbo.SE_GiftManageConfig SET Name = @Name, State = @State, Limit = @Limit, DonateWay = @DonateWay, Describe = @Describe, Visible = @Visible, OrdersWay = @OrdersWay, ValidTimeBegin = @ValidTimeBegin, ValidTimeEnd = @ValidTimeEnd, Channel = @Channel, Type = @Type, ConditionSize = @ConditionSize, TireType = @TireType, Size = @Size, B_Categorys = @B_Categorys, B_Brands = @B_Brands, B_PID = @B_PID, B_PID_Type = @B_PID_Type, P_PID = @P_PID, GiftCondition = @GiftCondition, GiftNum = @GiftNum, GiftMoney = @GiftMoney, GiftUnit = @GiftUnit, GiftType = @GiftType, GiftProducts = @GiftProducts, GiftDescribe = @GiftDescribe, Creater = @Creater, Mender = @Mender, CreateTime = @CreateTime, UpdateTime = @UpdateTime, TireSizeCondition= @TireSizeCondition, TireSize= @TireSize, Category=@Category, IsPackage=@IsPackage, ActivityType=@ActivityType, TagDisplay=@TagDisplay WHERE Id = @Id " ; return(conn.Execute(sql, model) > 0); } }
private void Logs(SE_GiftManageConfigModel source, string type) { if (source != null) { var result = SE_DictionaryConfigBLL.Insert(new SE_DictionaryConfigModel { ParentId = source.Id, Key = "SE_GiftManageConfig", Extend1 = _CreateLogs != null ? JsonConvert.SerializeObject(_CreateLogs) : "", Extend2 = source != null ? JsonConvert.SerializeObject(source) : "", Extend3 = source.Mender, Extend4 = type, CreateTime = DateTime.Now, UpdateTime = DateTime.Now }); //_CreateLogs = null; } }
public static bool Update(SqlConnection connection, SE_GiftManageConfigModel model) { using (IDbConnection conn = connection) { string sql = @" UPDATE Configuration.dbo.SE_GiftManageConfig SET Name = @Name, ValidTimeBegin = @ValidTimeBegin, ValidTimeEnd = @ValidTimeEnd, Channel = @Channel, GiftProducts = @GiftProducts, Creater = @Creater, Mender = @Mender, CreateTime = @CreateTime, UpdateTime = @UpdateTime, TagDisplay=@TagDisplay WHERE Id = @Id " ; return(conn.Execute(sql, model) > 0); } }
/// <summary> /// 刷新赠品牛皮癣 /// </summary> /// <param name="model"></param> private static void RefreshGiftPicture(SE_GiftManageConfigModel model) { var pids = model.P_PID != null?JsonConvert.DeserializeObject <List <PidModel> >( model.P_PID).Select(p => p.Pid).ToList() : new List <string>(); if (!pids.Any()) { return; } var productCacheService = new ProductCacheService(); Task.Delay(3000).ContinueWith((task) => { if (task.IsCompleted) { productCacheService.RefreshGiftCache(); productCacheService.SetProductCommonTagDetailsCache(ProductCommonTag.GiftProduct, pids); } }); }
public ActionResult Save(SE_GiftManageConfigModel model) { model.ActivityType = 1; model.PictureUrl = model.PictureUrl?.Trim(); model.PictureUrl4Detail = model.PictureUrl4Detail?.Trim(); var dataSource = model; if (model.Type == 4) { var flag = false; var pPids = JsonConvert.DeserializeObject <List <PidModel> >(model.P_PID); var result = SE_GiftManageConfigBLL.GetProductsModel(pPids.Select(r => r.Pid).ToList()); foreach (var value in result.Values) { if (value.Contains("BaoYang")) { flag = true; break; } } if (flag) { model.Category = "BaoYang"; } } if (model.Type == 3) { var pNodes = new List <string>(); var list = SE_GiftManageConfigBLL.GetByAllNodes(); foreach (var item in list) { pNodes.AddRange(item.Split('.').ToList()); } var distinctNodes = pNodes.Distinct().ToList(); var categorys = model.B_Categorys?.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries) ?? new string[0]; var bBrands = model.B_Brands == null ? new List <BrandModel>() : JsonConvert.DeserializeObject <List <BrandModel> >(model.B_Brands); var isBrand = false; //var isCategory = categorys.Contains("28656"); var isCategory = distinctNodes.Any() && distinctNodes.Any(category => categorys.Contains(category)); foreach (var brand in bBrands) { isBrand = distinctNodes.Any() && distinctNodes.Contains(brand.Category); if (isBrand) { break; } } var isbPid = false; if (model.B_PID_Type) { var pPids = model.B_PID == null ? new List <PidModel>() : JsonConvert.DeserializeObject <List <PidModel> >(model.B_PID); var result = SE_GiftManageConfigBLL.GetProductsModel(pPids.Select(r => r.Pid).ToList()); foreach (var value in result.Values) { if (value.Contains("BaoYang")) { isbPid = true; break; } } } if (isBrand || isCategory || isbPid) { model.Category = "BaoYang"; } } //var giftProductModels = JsonConvert.DeserializeObject<List<GiftProductModel>>(dataSource.GiftProducts); //giftProductModels.ForEach(g => //{ // //if (g.Stock.HasValue) // //{ // var stock = SE_GiftManageConfigBLL.GetGiftProductStock(g.Pid); // if (!stock.HasValue) // { // if (g.Stock.HasValue) // SE_GiftManageConfigBLL.InsertGiftProductStock(g.Pid, g.Stock.Value); // } // else // { // if (g.Stock.HasValue) // SE_GiftManageConfigBLL.UpdateGiftProductStock(g.Pid, g.Stock.Value); // else // SE_GiftManageConfigBLL.DeleteGiftProductStock(g.Pid); // } // // } //}); if (model.Id <= 0) { dataSource.Creater = User.Identity.Name; dataSource.CreateTime = DateTime.Now; SE_GiftManageConfigBLL.Insert(dataSource, new SE_DictionaryConfigModel { ParentId = dataSource.Id, Key = "SE_GiftManageConfig", Extend1 = _CreateLogs != null ? JsonConvert.SerializeObject(_CreateLogs) : "", Extend2 = dataSource != null ? JsonConvert.SerializeObject(dataSource) : "", Extend3 = dataSource.Mender, Extend4 = "新增", CreateTime = DateTime.Now, UpdateTime = DateTime.Now }); //Logs(dataSource, "新增"); } else { dataSource.Mender = User.Identity.Name; dataSource.UpdateTime = DateTime.Now; if (SE_GiftManageConfigBLL.Update(dataSource)) { Logs(dataSource, "更新"); } } return(RedirectToAction("Index")); }
public ActionResult CopySave(SE_GiftManageConfigModel model) { model.Id = 0; return(Save(model)); }
public static int Insert(SqlConnection connection, SE_GiftManageConfigModel model) { using (IDbConnection conn = connection) { string sql = @" INSERT INTO Configuration.dbo.SE_GiftManageConfig ( Name, State, Limit, DonateWay, Describe, Visible, OrdersWay, ValidTimeBegin, ValidTimeEnd, Channel, Type, ConditionSize, TireType, Size, B_Categorys, B_Brands, B_PID, B_PID_Type, P_PID, GiftCondition, GiftNum, GiftMoney, GiftUnit, GiftType, GiftProducts, GiftDescribe, Creater, Mender, CreateTime, UpdateTime, TireSizeCondition, TireSize, CateGory, IsPackage, ActivityType, TagDisplay, GiveAway, PictureUrl, PictureUrl4Detail ) VALUES ( @Name, @State, @Limit, @DonateWay, @Describe, @Visible, @OrdersWay, @ValidTimeBegin, @ValidTimeEnd, @Channel, @Type, @ConditionSize, @TireType, @Size, @B_Categorys, @B_Brands, @B_PID, @B_PID_Type, @P_PID, @GiftCondition, @GiftNum, @GiftMoney, @GiftUnit, @GiftType, @GiftProducts, @GiftDescribe, @Creater, @Mender, @CreateTime, @UpdateTime, @TireSizeCondition, @TireSize, @Category, @IsPackage, @ActivityType, @TagDisplay, @GiveAway, @PictureUrl, @PictureUrl4Detail )SELECT @@IDENTITY" ; return(conn.ExecuteScalar <int>(sql, model)); } }