/// <summary>
/// 插入
/// </summary>
/// <param name="request"></param>
/// <param name="loginInfo"></param>
/// <returns></returns>
public ServiceResult <bool> Insert(InsertDebugLogBlackListRequest request, TRightsUser loginInfo)
{
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var currentTime = DateTime.Now;
var item = new TLogsDebugLogBlackList
{
SystemCode = request.SystemCode,
Source = request.Source,
MachineName = request.MachineName,
IpAddress = request.IpAddress,
ClientIp = request.ClientIp,
AppdomainName = request.AppdomainName,
Message = request.Message,
IsRegex = request.IsRegex,
CreatedBy = loginInfo.Id,
CreatedTime = currentTime,
LastUpdatedBy = loginInfo.Id,
LastUpdatedTime = currentTime
};
var rs = _debugLogBlackListDao.Insert(item);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="item">待插入的记录</param>
public bool Insert(TLogsDebugLogBlackList item)
{
using (var conn = DapperHelper.CreateConnection())
{
var effectRows = conn.Execute(@"INSERT INTO dbo.t_logs_debug_log_black_list VALUES (@SystemCode ,@Source ,@MachineName ,@IpAddress ,@ClientIp ,@AppdomainName ,@Message ,@IsRegex ,@CreatedBy ,@CreatedTime ,@LastUpdatedBy ,@LastUpdatedTime);", item);
if (effectRows > 0)
{
return(true);
}
}
return(false);
}
/// <summary>
/// 依id查询
/// </summary>
/// <param name="id">id</param>
/// <returns></returns>
public TLogsDebugLogBlackList GetById(long id)
{
TLogsDebugLogBlackList result = null;
using (var conn = DapperHelper.CreateConnection())
{
result = conn.Query <TLogsDebugLogBlackList>(@"SELECT debugLogBlackList.system_code AS SystemCode ,
debugLogBlackList.machine_name AS MachineName ,
debugLogBlackList.ip_address AS IpAddress ,
debugLogBlackList.client_ip AS ClientIp ,
debugLogBlackList.appdomain_name AS AppdomainName ,
debugLogBlackList.is_regex AS IsRegex ,
debugLogBlackList.created_by AS CreatedBy ,
debugLogBlackList.created_time AS CreatedTime ,
debugLogBlackList.last_updated_by AS LastUpdatedBy ,
debugLogBlackList.last_updated_time AS LastUpdatedTime ,
*
FROM dbo.t_logs_debug_log_black_list (NOLOCK) AS debugLogBlackList
WHERE debugLogBlackList.id = @Id;", new { @Id = id }).FirstOrDefault();
}
return(result);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="item">待更新的记录</param>
/// <returns></returns>
public bool Update(TLogsDebugLogBlackList item)
{
throw new NotImplementedException();
}
