/// <summary> /// 添加微信社交立减金代金券配置 /// </summary> /// <param name="model">model</param> /// <returns></returns> public int AddWechatSocialCardConfig(WechatSocialCardConfigModel model) { model.CreatedBy = ThreadIdentity.Operator.Name; using (var conn = ProcessConnection.OpenConfiguration) { if (null == model.OtherMerchantNo) { model.OtherMerchantNo = ""; } return(dal.AddWechatSocialCardConfig(conn, model)); } }
/// <summary> /// 添加微信社交立减金代金券配置 /// </summary> /// <param name="conn">数据库连接</param> /// <param name="model">model</param> /// <returns></returns> public int AddWechatSocialCardConfig(SqlConnection conn, WechatSocialCardConfigModel model) => conn.Execute(@"INSERT INTO [dbo].[WechatSocialCardConfig] ( [CardId], [MerchantName], [MerchantNo], [CardName], [CardDescription], [LogoUrl], [OtherMerchantNo], [CardColor], [CutomerServiceTelphone], [CardDateInfoType], [BeginTime], [EndTime], [FixedTerm], [FixedBeginTerm], [EndDateTime], [CardAmount], [CardCondition], [IsCanUseWithOtherDiscount], [CardButtonText], [CardButtonToWxApp], [CardButtonToPath], [IsCanShare], [IsCanGiveToFriend], [CardStockQuantity], [CardGetLimit], [CreateDateTime], [CreatedBy], [LastUpdateDateTime], [UpdatedBy], [UseMids], [CreateMid] ) VALUES ( @CardId, -- CardId - nvarchar(50) @MerchantName, -- MerchantName - nvarchar(20) @MerchantNo, -- MerchantNo - nvarchar(50) @CardName, -- CardName - nvarchar(20) @CardDescription, -- CardDescription - nvarchar(500) @LogoUrl, -- LogoUrl - nvarchar(500) @OtherMerchantNo, -- OtherMerchantNo - nvarchar(500) @CardColor, -- CardColor - nvarchar(50) @CutomerServiceTelphone, -- CutomerServiceTelphone - nvarchar(50) @CardDateInfoType, -- CardDateInfoType - nvarchar(50) @BeginTime, -- BeginTime - datetime @EndTime, -- EndTime - datetime @FixedTerm, -- FixedTerm - int @FixedBeginTerm, -- FixedBeginTerm - int @EndDateTime, -- EndDateTime - datetime @CardAmount, -- CardAmount - nvarchar(50) @CardCondition, -- CardCondition - int @IsCanUseWithOtherDiscount, -- IsCanUseWithOtherDiscount - bit @CardButtonText, -- CardButtonText - nvarchar(50) @CardButtonToWxApp, -- CardButtonToWxApp - nvarchar(50) @CardButtonToPath, -- CardButtonToPath - nvarchar(200) @IsCanShare, -- IsCanShare - bit @IsCanGiveToFriend, -- IsCanGiveToFriend - bit @CardStockQuantity, -- CardStockQuantity - bigint @CardGetLimit, -- CardGetLimit - int GETDATE(), -- CreateDateTime - datetime @CreatedBy, -- CreatedBy - nvarchar(50) GETDATE(), -- LastUpdateDateTime - datetime @CreatedBy, -- UpdatedBy - nvarchar(50) @UseMids, @CreateMid )", model);