EquipmentDataRecord.cs
2.96 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
using FreeSql.DataAnnotations;
using HHECS.DAQHandle.Common.Utils;
using System.Text.Json;
namespace HHECS.DAQHandle.Models
{
/// <summary>
/// 设备数据记录
/// </summary>
[Table(Name = "daq_equipmentdatarecord")]
public class EquipmentDataRecord
{
/// <summary>
/// 设置值异常
/// </summary>
public readonly byte SET_VALUE_ERROR = 0b001;
/// <summary>
/// 设置报警异常
/// </summary>
public readonly byte SET_ALARM_ERROR = 0b010;
/// <summary>
/// 设置状态异常
/// </summary>
public readonly byte SET_STATUS_ERROR = 0b100;
/// <summary>
/// 主键
/// </summary>
[Column(IsPrimary = true)]
public Guid Id { get; set; }
/// <summary>
/// 设备编号/IOT云平台设备SN
/// </summary>
public string EquipmentCode { get; set; } = null!;
/// <summary>
/// 设备类型编号
/// </summary>
public string EquipmentTypeCode { get; set; } = null!;
/// <summary>
/// 设备名称
/// </summary>
public string EquipmentName { get; set; } = null!;
private string _tags = null;
/// <summary>
/// Json数据
/// </summary>
[Column(DbType = "varchar(max)")]
public string Tags
{
get { return _tags; }
set
{
_tags = value;
try
{
if (!string.IsNullOrWhiteSpace(_tags))
{
Props = JsonSerializer.Deserialize<Dictionary<string, string>>(value);
}
}
catch (Exception ex)
{
SystemLog.PrintError($"{ex}");
}
}
}
[Column(IsIgnore = true)]
public Dictionary<string, string> Props { get; set; }
/// <summary>
/// 版本号
/// </summary>
public int Version { get; set; }
/// <summary>
/// 客户端提交时间戳
/// </summary>
public long Timestamp { get; set; }
/// <summary>
/// 是否已处理
/// </summary>
public bool IsHandle { get; set; }
/// <summary>
/// 各阶段是否处理成功
/// 第一位赋值是否报错,第二位是否记录异常成功 第三位是否记录状态成功
/// public readonly byte SET_VALUE_ERROR = 0b001;
/// public readonly byte SET_ALARM_ERROR = 0b010;
/// public readonly byte SET_STATUS_ERROR = 0b100;
/// </summary>
public byte HandleStage { get; set; }
/// <summary>
/// 创建时间
/// </summary>
public DateTime? CreateTime { get; set; }
/// <summary>
/// 修改时间
/// </summary>
public DateTime? UpdateTime { get; set; }
}
}