/// <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));
}
