BaseEquipment.cs
4.25 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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
using FreeSql.DataAnnotations;
namespace CNCFanucDataReading
{
/// <summary>
/// 设备信息表
/// </summary>
[Table(Name = "base_equipment")]
[Index("idx_equipment_bind", "equipmentCode,projectKeys", false)]
[Index("NonClusteredIndex-eqAndFac", "equipmentCode", true)]
public class BaseEquipment
{
/// <summary>
/// 主键ID
/// </summary>
[Column(Name = "id", IsPrimary = true, IsIdentity = true)]
public int Id { get; set; }
/// <summary>
/// 项目keys
/// </summary>
[Column(Name = "projectKeys", DbType = "uniqueidentifier")]
public Guid? ProjectKeys { get; set; }
/// <summary>
/// 厂房编码
/// </summary>
[Column(Name = "factoryCode", StringLength = 100, IsNullable = false)]
public string FactoryCode { get; set; }
/// <summary>
/// 设备编码
/// </summary>
[Column(Name = "equipmentCode", StringLength = 50, IsNullable = false)]
public string EquipmentCode { get; set; }
/// <summary>
/// 设备名称
/// </summary>
[Column(Name = "equipmentName", StringLength = 100)]
public string EquipmentName { get; set; }
/// <summary>
/// 设备类型编码
/// </summary>
[Column(Name = "equipmentTypeCode", StringLength = 50)]
public string EquipmentTypeCode { get; set; }
/// <summary>
/// 维护规则编码
/// </summary>
[Column(Name = "equipmentMaintainRuleCode", StringLength = 50)]
public string EquipmentMaintainRuleCode { get; set; }
/// <summary>
/// 图片文件路径
/// </summary>
[Column(Name = "imgSrc", StringLength = 255)]
public string ImgSrc { get; set; }
/// <summary>
/// 此处写到这台设备对应的IP，一般为PLC的IP
/// </summary>
[Column(Name = "ip", StringLength = 20)]
public string Ip { get; set; }
/// <summary>
/// 所在区域，出于调度目的或其他划分，比如：为兼容转轨堆垛机设定，正常情况下与巷道相同，转轨情况下对应虚拟划分巷道
/// </summary>
[Column(Name = "destinationArea", StringLength = 50)]
public string DestinationArea { get; set; }
/// <summary>
/// 描述
/// </summary>
[Column(Name = "remark", StringLength = 500)]
public string Remark { get; set; }
/// <summary>
/// 是否有待保养信息 false 没有 true存在
/// </summary>
[Column(Name = "isMaintain", DbType = "bit")]
public bool? IsMaintain { get; set; }
/// <summary>
/// 是否启用 0不启用/删除 1 正常/启用
/// </summary>
[Column(Name = "isEnable", DbType = "bit", IsNullable = false)]
public bool IsEnable { get; set; } = true;
/// <summary>
/// 外部编码
/// </summary>
[Column(Name = "otherCode", StringLength = 50)]
public string OtherCode { get; set; }
/// <summary>
/// 创建时间
/// </summary>
[Column(Name = "createTime", DbType = "datetime")]
public DateTime? CreateTime { get; set; }
/// <summary>
/// 创建人
/// </summary>
[Column(Name = "createBy", StringLength = 50)]
public string CreateBy { get; set; }
/// <summary>
/// 更新时间
/// </summary>
[Column(Name = "updateTime", DbType = "datetime")]
public DateTime? UpdateTime { get; set; }
/// <summary>
/// 更新人
/// </summary>
[Column(Name = "updateBy", StringLength = 50)]
public string UpdateBy { get; set; }
/// <summary>
/// 出厂时间
/// </summary>
[Column(Name = "startTime", DbType = "datetime")]
public DateTime? StartTime { get; set; }
/// <summary>
/// 排序
/// </summary>
[Column(Name = "sequence")]
public int? Sequence { get; set; }
/// <summary>
/// 设备组Id
/// </summary>
[Column(Name = "equipmentGroupId")]
public int? EquipmentGroupId { get; set; }
}
}