/// <summary> /// 查询组织架构日志 /// </summary> /// <param name="StartTime">开始时间</param> /// <param name="EndTime">结束时间</param> /// <param name="UnitID">组织ID</param> /// <param name="PageIndex">页号</param> /// <param name="PageSize">页大小</param> /// <param name="RecordCount">总记录数</param> /// <returns>组织架构数据</returns> private DataTable QueryOrganizationLog(string startTime, string endTime, string unitID, int pageIndex, int pageSize, out int total) { #region 构造查询参数 QueryConditonCollection conditions = new QueryConditonCollection(); DateTime startTimeValue = DateTime.MinValue; DateTime endTimeValue = DateTime.MinValue; if (DateTime.TryParse(startTime, out startTimeValue)) { conditions.Add(ComparisonOperatorType.NotBelow, OrganizationLog.PropertyName_Time, startTimeValue, this.Engine.EngineConfig.LogDBType); } if (DateTime.TryParse(endTime, out endTimeValue)) { endTimeValue = endTimeValue.AddDays(1); conditions.Add(ComparisonOperatorType.NotAbove, OrganizationLog.PropertyName_Time, endTimeValue, this.Engine.EngineConfig.LogDBType); } if (!string.IsNullOrEmpty(unitID)) { conditions.Add(ComparisonOperatorType.Equal, OrganizationLog.PropertyName_UnitID, unitID); } #endregion return(this.Engine.Query.QueryOrganizationLog(conditions.ToArray(), pageIndex, pageSize, out total)); }
/// <summary> /// 查询用户登录日志 /// </summary> /// <param name="startTime">开始时间</param> /// <param name="endTime">结束时间</param> /// <param name="userId">登录用户ID</param> /// <param name="siteType">客户端登录类型</param> /// <param name="loginIP">登录IP</param> /// <param name="pageIndex">页码</param> /// <param name="pageSize">每页显示记录数</param> /// <param name="total">返回记录总数</param> /// <returns>返回用户登录日志表格</returns> private System.Data.DataTable QueryUserLoginLog(string startTime, string endTime, string userIds, string siteTypes, string loginIP, int pageIndex, int pageSize, out int total) { QueryConditonCollection conditions = new QueryConditonCollection(); DateTime start; if (DateTime.TryParse(startTime, out start)) { conditions.Add(ComparisonOperatorType.NotBelow, UserLog.PropertyName_CreatedTime, start, this.Engine.EngineConfig.LogDBType); } DateTime end; if (DateTime.TryParse(endTime, out end)) { end = end.AddDays(1); conditions.Add(ComparisonOperatorType.NotAbove, UserLog.PropertyName_CreatedTime, end, this.Engine.EngineConfig.LogDBType); } if (!string.IsNullOrEmpty(userIds)) { string[] userIdarray = userIds.Split(','); conditions.Add(ComparisonOperatorType.In, UserLog.PropertyName_UserID, userIdarray, this.Engine.EngineConfig.LogDBType); } if (!string.IsNullOrEmpty(siteTypes)) { string[] siteTypearray = siteTypes.Split(','); conditions.Add(ComparisonOperatorType.In, UserLog.PropertyName_SiteType, siteTypearray, this.Engine.EngineConfig.LogDBType); } if (!string.IsNullOrEmpty(loginIP)) { conditions.Add(ComparisonOperatorType.Equal, UserLog.PropertyName_ClientAddress, loginIP, this.Engine.EngineConfig.LogDBType); } conditions.Add(ComparisonOperatorType.Equal, UserLog.PropertyName_LogType, ((int)UserLogType.Login).ToString(), this.Engine.EngineConfig.LogDBType); return(this.Engine.Query.QueryUserLoginLog(conditions.ToArray(), pageIndex, pageSize, out total)); }
/// <summary> /// 获取异常数据Table /// </summary> /// <param name="pageIndex">页数</param> /// <param name="pageSize">尺寸</param> /// <param name="startTime">开始时间</param> /// <param name="endTime">结束事件</param> /// <param name="instanceName">实例名称</param> /// <param name="sequenceNo">流水号</param> /// <param name="userId">用户ID</param> /// <param name="total">总数</param> /// <returns>异常日志结果集</returns> private DataTable QueryExceptionTable(int pageIndex, int pageSize, string startTime, string endTime, string instanceName, string sequenceNo, string userId, out int total) { #region 构造查询参数 QueryConditonCollection conditions = new QueryConditonCollection(); DateTime startTimeValue = DateTime.MinValue; DateTime endTimeValue = DateTime.MinValue; if (DateTime.TryParse(startTime, out startTimeValue)) { conditions.Add(ComparisonOperatorType.NotBelow, ExceptionLog.PropertyName_ThrownTime, startTimeValue, this.Engine.EngineConfig.LogDBType); } if (DateTime.TryParse(endTime, out endTimeValue)) { endTimeValue = endTimeValue.AddDays(1); conditions.Add(ComparisonOperatorType.NotAbove, ExceptionLog.PropertyName_ThrownTime, endTimeValue, this.Engine.EngineConfig.LogDBType); } conditions.Add(ComparisonOperatorType.Contain, ExceptionLog.PropertyName_SourceName, instanceName); conditions.Add(ComparisonOperatorType.Contain, ExceptionLog.PropertyName_SequenceNo, sequenceNo); conditions.Add(ComparisonOperatorType.Equal, ExceptionLog.PropertyName_Originator, userId); #endregion return(this.Engine.Query.QueryException(conditions.ToArray(), pageIndex, pageSize, out total)); }