/// <summary>
/// 添加微信社交立减金活动配置
/// </summary>
/// <param name="model">model</param>
/// <returns></returns>
public int AddWechatSocialActivityConfig(WechatSocialActivityConfigModel model)
{
model.CreatedBy = ThreadIdentity.Operator.Name;
using (var conn = ProcessConnection.OpenConfiguration)
{
return(dal.AddWechatSocialActivityConfig(conn, model));
}
}
/// <summary>
/// 添加微信社交立减金活动配置
/// </summary>
/// <param name="conn">数据库连接</param>
/// <param name="model">model</param>
/// <returns></returns>
public int AddWechatSocialActivityConfig(SqlConnection conn, WechatSocialActivityConfigModel model) => conn.Execute(@"INSERT INTO [dbo].[WechatSocialActivityConfig]
(
[CardId],
[ActivityId],
[ActivityBgColor],
[ActivityWxAppId],
[BeginTime],
[EndTime],
[GiftNum],
[MerchantNo],
[MaxParticTimesAct],
[MaxParticTimesOneDay],
[MinAmount],
[UserScope],
[CreateDateTime],
[CreatedBy],
[LastUpdateDateTime],
[UpdatedBy]
)
VALUES
( @CardId, -- CardId - nvarchar(50)
@ActivityId, -- ActivityId - nvarchar(50)
@ActivityBgColor, -- ActivityBgColor - nvarchar(50)
@ActivityWxAppId, -- ActivityWxAppId - nvarchar(50)
@BeginTime, -- BeginTime - datetime
@EndTime, -- EndTime - datetime
@GiftNum, -- GiftNum - int
@MerchantNo, -- MerchantNo - nvarchar(50)
@MaxParticTimesAct, -- MaxParticTimesAct - int
@MaxParticTimesOneDay, -- MaxParticTimesOneDay - int
@MinAmount, -- MinAmount - int
@UserScope, -- UserScope - int
GETDATE(), -- CreateDateTime - datetime
@CreatedBy, -- CreatedBy - nvarchar(50)
GETDATE(), -- LastUpdateDateTime - datetime
@CreatedBy -- UpdatedBy - nvarchar(50)
)", model);
