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