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