using SqlSugar;
|
|
namespace GSModbus.Database
|
{
|
/// <summary>
|
/// Modbus主数据实体 - 存储从PLC读取的数据
|
/// </summary>
|
[SugarTable("ModbusData")]
|
public class ModbusDataEntity
|
{
|
/// <summary>
|
/// 主键ID
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
|
public long Id { get; set; }
|
|
/// <summary>
|
/// 数据读取时间
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "数据读取时间")]
|
public DateTime ReadTime { get; set; }
|
|
/// <summary>
|
/// 项目名称（来自配置）
|
/// </summary>
|
[SugarColumn(Length = 100, IsNullable = false, ColumnDescription = "项目名称")]
|
public string ProjectName { get; set; } = string.Empty;
|
|
/// <summary>
|
/// PLC IP地址
|
/// </summary>
|
[SugarColumn(Length = 50, IsNullable = false, ColumnDescription = "PLC IP地址")]
|
public string PlcIpAddress { get; set; } = string.Empty;
|
|
/// <summary>
|
/// 控制信号数据（JSON格式）
|
/// </summary>
|
[SugarColumn(ColumnDataType = "TEXT", IsNullable = true, ColumnDescription = "控制信号数据JSON")]
|
public string? ControlSignalsJson { get; set; }
|
|
/// <summary>
|
/// 产品数据（JSON格式）
|
/// </summary>
|
[SugarColumn(ColumnDataType = "TEXT", IsNullable = true, ColumnDescription = "产品数据JSON")]
|
public string? ProductDataJson { get; set; }
|
|
/// <summary>
|
/// 测量数据（JSON格式）
|
/// </summary>
|
[SugarColumn(ColumnDataType = "TEXT", IsNullable = true, ColumnDescription = "测量数据JSON")]
|
public string? MeasurementDataJson { get; set; }
|
|
/// <summary>
|
/// 原始寄存器数据（JSON格式，用于调试）
|
/// </summary>
|
[SugarColumn(ColumnDataType = "TEXT", IsNullable = true, ColumnDescription = "原始寄存器数据JSON")]
|
public string? RawRegistersJson { get; set; }
|
|
/// <summary>
|
/// 数据创建时间
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "记录创建时间")]
|
public DateTime CreatedAt { get; set; } = DateTime.Now;
|
}
|
|
/// <summary>
|
/// 通信日志实体 - 记录通信状态和统计信息
|
/// </summary>
|
[SugarTable("CommunicationLog")]
|
public class CommunicationLogEntity
|
{
|
/// <summary>
|
/// 主键ID
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
|
public long Id { get; set; }
|
|
/// <summary>
|
/// 日志时间
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "日志时间")]
|
public DateTime LogTime { get; set; }
|
|
/// <summary>
|
/// 项目名称
|
/// </summary>
|
[SugarColumn(Length = 100, IsNullable = false, ColumnDescription = "项目名称")]
|
public string ProjectName { get; set; } = string.Empty;
|
|
/// <summary>
|
/// PLC IP地址
|
/// </summary>
|
[SugarColumn(Length = 50, IsNullable = false, ColumnDescription = "PLC IP地址")]
|
public string PlcIpAddress { get; set; } = string.Empty;
|
|
/// <summary>
|
/// 事件类型（Connected, Disconnected, DataReceived, Error等）
|
/// </summary>
|
[SugarColumn(Length = 50, IsNullable = false, ColumnDescription = "事件类型")]
|
public string EventType { get; set; } = string.Empty;
|
|
/// <summary>
|
/// 事件描述
|
/// </summary>
|
[SugarColumn(Length = 500, IsNullable = true, ColumnDescription = "事件描述")]
|
public string? EventDescription { get; set; }
|
|
/// <summary>
|
/// 是否成功
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "是否成功")]
|
public bool IsSuccess { get; set; }
|
|
/// <summary>
|
/// 耗时（毫秒）
|
/// </summary>
|
[SugarColumn(IsNullable = true, ColumnDescription = "操作耗时毫秒")]
|
public int? DurationMs { get; set; }
|
|
/// <summary>
|
/// 附加数据（JSON格式）
|
/// </summary>
|
[SugarColumn(ColumnDataType = "TEXT", IsNullable = true, ColumnDescription = "附加数据JSON")]
|
public string? AdditionalDataJson { get; set; }
|
}
|
|
/// <summary>
|
/// 错误日志实体 - 记录通信和处理错误
|
/// </summary>
|
[SugarTable("ErrorLog")]
|
public class ErrorLogEntity
|
{
|
/// <summary>
|
/// 主键ID
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
|
public long Id { get; set; }
|
|
/// <summary>
|
/// 错误发生时间
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "错误发生时间")]
|
public DateTime ErrorTime { get; set; }
|
|
/// <summary>
|
/// 项目名称
|
/// </summary>
|
[SugarColumn(Length = 100, IsNullable = false, ColumnDescription = "项目名称")]
|
public string ProjectName { get; set; } = string.Empty;
|
|
/// <summary>
|
/// PLC IP地址
|
/// </summary>
|
[SugarColumn(Length = 50, IsNullable = false, ColumnDescription = "PLC IP地址")]
|
public string PlcIpAddress { get; set; } = string.Empty;
|
|
/// <summary>
|
/// 错误类型
|
/// </summary>
|
[SugarColumn(Length = 100, IsNullable = false, ColumnDescription = "错误类型")]
|
public string ErrorType { get; set; } = string.Empty;
|
|
/// <summary>
|
/// 错误消息
|
/// </summary>
|
[SugarColumn(Length = 1000, IsNullable = false, ColumnDescription = "错误消息")]
|
public string ErrorMessage { get; set; } = string.Empty;
|
|
/// <summary>
|
/// 异常堆栈信息
|
/// </summary>
|
[SugarColumn(ColumnDataType = "TEXT", IsNullable = true, ColumnDescription = "异常堆栈信息")]
|
public string? StackTrace { get; set; }
|
|
/// <summary>
|
/// 错误严重级别（Critical, High, Medium, Low）
|
/// </summary>
|
[SugarColumn(Length = 20, IsNullable = false, ColumnDescription = "错误严重级别")]
|
public string Severity { get; set; } = "Medium";
|
|
/// <summary>
|
/// 重试次数
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "重试次数")]
|
public int RetryCount { get; set; } = 0;
|
|
/// <summary>
|
/// 是否已解决
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "是否已解决")]
|
public bool IsResolved { get; set; } = false;
|
}
|
|
/// <summary>
|
/// 统计数据实体 - 记录通信统计信息
|
/// </summary>
|
[SugarTable("Statistics")]
|
public class StatisticsEntity
|
{
|
/// <summary>
|
/// 主键ID
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
|
public long Id { get; set; }
|
|
/// <summary>
|
/// 统计时间
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "统计时间")]
|
public DateTime StatisticsTime { get; set; }
|
|
/// <summary>
|
/// 项目名称
|
/// </summary>
|
[SugarColumn(Length = 100, IsNullable = false, ColumnDescription = "项目名称")]
|
public string ProjectName { get; set; } = string.Empty;
|
|
/// <summary>
|
/// PLC IP地址
|
/// </summary>
|
[SugarColumn(Length = 50, IsNullable = false, ColumnDescription = "PLC IP地址")]
|
public string PlcIpAddress { get; set; } = string.Empty;
|
|
/// <summary>
|
/// 连接尝试总数
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "连接尝试总数")]
|
public int TotalConnectionAttempts { get; set; }
|
|
/// <summary>
|
/// 连接成功总数
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "连接成功总数")]
|
public int SuccessfulConnections { get; set; }
|
|
/// <summary>
|
/// 数据读取总数
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "数据读取总数")]
|
public int TotalDataReads { get; set; }
|
|
/// <summary>
|
/// 数据读取成功总数
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "数据读取成功总数")]
|
public int SuccessfulDataReads { get; set; }
|
|
/// <summary>
|
/// 错误总数
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "错误总数")]
|
public int TotalErrors { get; set; }
|
|
/// <summary>
|
/// 平均响应时间（毫秒）
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "平均响应时间毫秒")]
|
public double AverageResponseTimeMs { get; set; }
|
|
/// <summary>
|
/// 最大响应时间（毫秒）
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "最大响应时间毫秒")]
|
public int MaxResponseTimeMs { get; set; }
|
|
/// <summary>
|
/// 最小响应时间（毫秒）
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "最小响应时间毫秒")]
|
public int MinResponseTimeMs { get; set; }
|
|
/// <summary>
|
/// 连接成功率
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "连接成功率")]
|
public double ConnectionSuccessRate { get; set; }
|
|
/// <summary>
|
/// 数据读取成功率
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "数据读取成功率")]
|
public double DataReadSuccessRate { get; set; }
|
|
/// <summary>
|
/// 统计时间范围开始
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "统计时间范围开始")]
|
public DateTime PeriodStart { get; set; }
|
|
/// <summary>
|
/// 统计时间范围结束
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "统计时间范围结束")]
|
public DateTime PeriodEnd { get; set; }
|
}
|
|
/// <summary>
|
/// 事件类型常量
|
/// </summary>
|
public static class EventTypes
|
{
|
public const string Connected = "Connected";
|
public const string Disconnected = "Disconnected";
|
public const string DataReceived = "DataReceived";
|
public const string ConnectionError = "ConnectionError";
|
public const string DataReadError = "DataReadError";
|
public const string ConfigurationLoaded = "ConfigurationLoaded";
|
public const string SystemStarted = "SystemStarted";
|
public const string SystemStopped = "SystemStopped";
|
}
|
|
/// <summary>
|
/// 错误严重级别常量
|
/// </summary>
|
public static class ErrorSeverity
|
{
|
public const string Critical = "Critical"; // 系统无法继续运行
|
public const string High = "High"; // 功能受到严重影响
|
public const string Medium = "Medium"; // 功能受到影响但可继续
|
public const string Low = "Low"; // 轻微问题，不影响主要功能
|
}
|
}
|
