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