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