/// <summary> /// 新增礼包配置 /// </summary> /// <param name="conn"></param> /// <param name="config"></param> /// <returns></returns> public static long AddVipBaoYangGiftPackConfig(SqlConnection conn, VipBaoYangGiftPackConfig config) { var sql = @" INSERT INTO BaoYang..VipBaoYangGiftPackConfig ( PackName , PackageId , IsValid , CreateDateTime , LastUpdateDateTime ) OUTPUT Inserted.PKID VALUES ( @PackName , @PackageId , @IsValid , GETDATE() , GETDATE() );"; var result = Convert.ToInt64(conn.ExecuteScalar(sql, new { PackName = config.PackName, PackageId = config.PackageId, IsValid = config.IsValid }, commandType: CommandType.Text)); return(result); }
/// <summary> /// 新增礼包配置 /// </summary> /// <param name="config"></param> /// <returns></returns> public bool AddVipBaoYangGiftPackConfig(VipBaoYangGiftPackConfig config, string user) { bool success = false; try { var pkid = dbScopeManager.Execute(conn => DALVipBaoYangPackage.AddVipBaoYangGiftPackConfig(conn, config)); success = pkid > 0; config.PKID = pkid; if (success) { VipBaoYangPackageService.InsertBaoYangOprLog(new { LogType = "VipBaoYangPackageRedemptionCodeGiftPack", IdentityID = pkid.ToString(), OldValue = string.Empty, NewValue = JsonConvert.SerializeObject(new { config.PackId, config.PackageId, config.IsValid, config.PackName }), Remarks = $"Add", OperateUser = user, }); } } catch (Exception ex) { logger.Error(ex.Message, ex); } return(success); }
/// <summary> /// 是否存在礼包名称 /// </summary> /// <param name="config"></param> /// <returns></returns> public bool IsExisitsVipBaoYangGiftPackName(VipBaoYangGiftPackConfig config) { bool exists = false; try { exists = dbScopeReadManager.Execute(conn => DALVipBaoYangPackage.IsExisitsVipBaoYangGiftPackName(conn, config)); } catch (Exception ex) { logger.Error(ex.Message, ex); } return(exists); }
/// <summary> /// 修改礼包配置 /// </summary> /// <param name="config"></param> /// <returns></returns> public bool EditVipBaoYangGiftPackConfig(VipBaoYangGiftPackConfig config) { bool success = false; try { success = dbScopeManager.Execute(conn => DALVipBaoYangPackage.EditVipBaoYangGiftPackConfig(conn, config)); } catch (Exception ex) { logger.Error(ex.Message, ex); } return(success); }
/// <summary> /// 是否存在礼包名称 /// </summary> /// <param name="conn"></param> /// <param name="config"></param> /// <returns></returns> public static bool IsExisitsVipBaoYangGiftPackName(SqlConnection conn, VipBaoYangGiftPackConfig config) { var sql = @"SELECT COUNT(1) FROM BaoYang..VipBaoYangGiftPackConfig AS c WITH ( NOLOCK ) WHERE c.PackName = @PackName AND c.PKID <> @PackId;"; var returnvalue = conn.ExecuteScalar(sql, new { PackName = config.PackName, PackId = config.PackId }, commandType: CommandType.Text); var count = Convert.ToInt32(returnvalue); return(count > 0); }
/// <summary> /// 修改礼包配置 /// </summary> /// <param name="conn"></param> /// <param name="config"></param> /// <returns></returns> public static bool EditVipBaoYangGiftPackConfig(SqlConnection conn, VipBaoYangGiftPackConfig config) { var sql = @" UPDATE BaoYang..VipBaoYangGiftPackConfig SET PackName = @PackName , IsValid = @IsValid , LastUpdateDateTime = GETDATE() WHERE PKID = @PKID;"; var result = conn.Execute(sql, new { PackName = config.PackName, PackageId = config.PackageId, IsValid = config.IsValid, PKID = config.PKID }, commandType: CommandType.Text) > 0; return(result); }
/// <summary> /// 更新或者新增礼包配置 /// </summary> /// <param name="config"></param> /// <returns></returns> public ActionResult AddOrUpdateGiftPackConfig(VipBaoYangGiftPackConfig config) { if (config == null || string.IsNullOrWhiteSpace(config.PackName) || config.PackageId < 0) { return(Json(new { status = false, msg = "礼包名称、套餐不能为空" })); } config.PackName = config.PackName.Trim(); var manager = new VipBaoYangPackageManager(); if (manager.IsExisitsVipBaoYangGiftPackName(config)) { return(Json(new { status = false, msg = "礼包名称已存在" })); } var result = config.PackId <= 0 ? manager.AddVipBaoYangGiftPackConfig(config, User.Identity.Name) : manager.EditVipBaoYangGiftPackConfig(config); return(Json(new { status = result }, JsonRequestBehavior.AllowGet)); }