/// <summary>
/// 插入或更新银行活动广告位配置
/// </summary>
/// <param name="config"></param>
/// <returns></returns>
public bool UpsertBankMRActivityAdConfig(BankMRActivityAdConfig config)
{
var result = false;
try
{
result = TuhuGrouponDbScopeManagerReadOnly.Execute(conn =>
BankMRActivityDal.UpsertBankMRActivityAdConfig(conn, config));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(result);
}
/// <summary>
/// 插入或更新银行活动广告位配置
/// </summary>
/// <param name="conn"></param>
/// <param name="config"></param>
/// <returns></returns>
public static bool UpsertBankMRActivityAdConfig(SqlConnection conn, BankMRActivityAdConfig config)
{
var sql = @"IF EXISTS ( SELECT 1
FROM Tuhu_groupon..BankMRActivityAdConfig WITH ( NOLOCK )
WHERE ActivityId = @ActivityId
AND AdType = @AdType )
BEGIN
UPDATE Tuhu_groupon..BankMRActivityAdConfig
SET ImgUrl = @ImgUrl ,
JumpUrl = @JumpUrl ,
UpdateTime = GETDATE()
WHERE ActivityId = @ActivityId
AND AdType = @AdType
END
ELSE
BEGIN
INSERT Tuhu_groupon..BankMRActivityAdConfig
( ActivityId ,
AdType ,
ImgUrl ,
JumpUrl
)
VALUES ( @ActivityId ,
@AdType ,
@ImgUrl ,
@JumpUrl
)
END";
var parameters = new SqlParameter[]
{
new SqlParameter("@ActivityId", config.ActivityId),
new SqlParameter("@AdType", config.AdType),
new SqlParameter("@ImgUrl", config.ImgUrl),
new SqlParameter("@JumpUrl", config.JumpUrl),
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters) > 0);
}
