/// <summary> /// 添加黑名单 /// </summary> /// <param name="request"></param> /// <param name="loginInfo"></param> /// <returns></returns> public ServiceResult <bool> Insert(InsertErrorLogBlackListRequest request, TRightsUser loginInfo) { var result = new ServiceResult <bool> { ReturnCode = ReturnCodeType.Error }; var currentTime = DateTime.Now; var item = new TLogsErrorLogBlackList { 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 = _errorLogBlackListDao.Insert(item); if (rs == true) { result.ReturnCode = ReturnCodeType.Success; result.Content = true; } return(result); }
/// <summary> /// 插入 /// </summary> /// <param name="item">待插入的记录</param> public bool Insert(TLogsErrorLogBlackList item) { using (var conn = DapperHelper.CreateConnection()) { var effectRows = conn.Execute(@"INSERT INTO dbo.t_logs_error_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 TLogsErrorLogBlackList GetById(long id) { TLogsErrorLogBlackList result = null; using (var conn = DapperHelper.CreateConnection()) { result = conn.Query <TLogsErrorLogBlackList>(@"SELECT errorLogBlackList.system_code AS SystemCode , errorLogBlackList.machine_name AS MachineName , errorLogBlackList.ip_address AS IpAddress , errorLogBlackList.client_ip AS ClientIp , errorLogBlackList.appdomain_name AS AppdomainName , errorLogBlackList.is_regex AS IsRegex , errorLogBlackList.created_by AS CreatedBy , errorLogBlackList.created_time AS CreatedTime , errorLogBlackList.last_updated_by AS LastUpdatedBy , errorLogBlackList.last_updated_time AS LastUpdatedTime , * FROM dbo.t_logs_error_log_black_list (NOLOCK) AS errorLogBlackList WHERE errorLogBlackList.id = @Id;", new { @Id = id }).FirstOrDefault(); } return(result); }
/// <summary> /// 更新 /// </summary> /// <param name="item">待更新的记录</param> /// <returns></returns> public bool Update(TLogsErrorLogBlackList item) { throw new NotImplementedException(); }