/// <summary>
/// 保存微信用户事件配置
/// </summary>
/// <param name="config">config</param>
/// <returns></returns>
public int SaveWxAppUserEventConfig(WxAppUserEventConfigModel config)
{
config.CreateBy = ThreadIdentity.Operator.Name;
config.UpdateBy = ThreadIdentity.Operator.Name;
if (config.UserData != null)
{
config.UserData = config.UserData.Trim().Replace(" ", "");
}
using (var conn = ProcessConnection.OpenConfiguration)
{
var result = dal.SaveWxAppUserEventConfig(conn, config);
if (result > 0)
{
new CommonConfigLogManager().AddCommonConfigLogInfo(new CommonConfigLogModel
{
AfterValue = JsonConvert.SerializeObject(config),
ObjectId = config.OriginId,
ObjectType = "WxAppConfigLog",
Remark = $"{(config.PKID > 0 ? $"更新({config.PKID})" : "新增")}小程序配置",
Creator = ThreadIdentity.Operator.Name
});
}
return(result);
}
}
/// <summary>
/// 删除配置（逻辑删除
/// </summary>
/// <param name="conn">数据库连接</param>
/// <param name="model">model</param>
/// <returns></returns>
public int DeleteWxAppConfig(SqlConnection conn, WxAppUserEventConfigModel model)
{
return(conn.Execute(@"UPDATE [Configuration].[dbo].[WxApp_UserEventConfig] WITH (ROWLOCK)
SET [IsDeleted] = 1,
[LastUpdateDateTime] = GETDATE(),
[UpdateBy] = @UpdateBy
WHERE [PKID]=@PKID;", model));
}
/// <summary>
/// 删除配置（逻辑删除
/// </summary>
/// <param name="model">model</param>
/// <returns></returns>
public int DeleteWxAppConfig(WxAppUserEventConfigModel model)
{
model.UpdateBy = ThreadIdentity.Operator.Name;
using (var conn = ProcessConnection.OpenConfiguration)
{
return(dal.DeleteWxAppConfig(conn, model));
}
}
/// <summary>
/// 保存微信用户事件配置
/// </summary>
/// <param name="config">config</param>
/// <returns></returns>
public int SaveWxAppUserEventConfig(WxAppUserEventConfigModel config)
{
config.CreateBy = ThreadIdentity.Operator.Name;
config.UpdateBy = ThreadIdentity.Operator.Name;
if (config.UserData != null)
{
config.UserData = config.UserData.Trim().Replace(" ", "");
}
using (var conn = ProcessConnection.OpenConfiguration)
{
return(dal.SaveWxAppUserEventConfig(conn, config));
}
}
/// <summary>
/// 删除配置（逻辑删除
/// </summary>
/// <param name="model">model</param>
/// <returns></returns>
public int DeleteWxAppConfig(WxAppUserEventConfigModel model)
{
model.UpdateBy = ThreadIdentity.Operator.Name;
using (var conn = ProcessConnection.OpenConfiguration)
{
var result = dal.DeleteWxAppConfig(conn, model);
if (result > 0)
{
new CommonConfigLogManager().AddCommonConfigLogInfo(new CommonConfigLogModel
{
BeforeValue = $"Config:{model.PKID}",
AfterValue = "",
ObjectId = model.OriginId,
ObjectType = "WxAppConfigLog",
Remark = $"删除【{model.PKID}】小程序配置",
Creator = ThreadIdentity.Operator.Name
});
}
return(result);
}
}
/// <summary>
/// 微信小程序用户事件配置
/// </summary>
/// <returns></returns>
public int SaveWxAppUserEventConfig(SqlConnection conn, WxAppUserEventConfigModel model)
{
return(model.PKID > 0
? conn.Execute(@"UPDATE [Configuration].[dbo].[WxApp_UserEventConfig] WITH (ROWLOCK)
SET [EventType] = @EventType,
[MsgType] = @MsgType,
[ResponseJson] = @ResponseJson,
[IsActive] = @IsActive,
[UserData] = @UserData,
[UpdateBy] = @UpdateBy,
[LastUpdateDateTime] = GETDATE()
WHERE [IsDeleted] = 0
AND [PKID] = @pkid;", model)
: conn.Execute(@"INSERT INTO [Configuration].[dbo].[WxApp_UserEventConfig]
(
[OriginId],
[EventType],
[MsgType],
[ResponseJson],
[UserData],
[IsActive],
[CreateBy],
[UpdateBy],
[CreateDateTime],
[LastUpdateDateTime]
)
VALUES
( @OriginId, -- OriginId - varchar(20)
@EventType, -- EventType - nvarchar(50)
@MsgType, -- MsgType -nvarchar
@ResponseJson, -- ResponseJson - int
@UserData, -- UserData - nvarchar(500)
@IsActive, -- IsActive - bit
@CreateBy, -- CreateBy - nvarchar(50)
@CreateBy, -- UpdateBy - nvarchar(50)
GETDATE(), -- CreateDateTime - datetime
GETDATE() -- LastUpdateDateTime - datetime
)", model));
}
