schangxiang@126.com
2024-06-11 2954a2dd4529679ff30c1fd08870895c29d507f2
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
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace iWare.Wms.Core
{
    /// <summary>
    /// 修改表WorkPieceInfo记得同步修改WorkPieceInfoLog表
    /// </summary>
    [Table("v_get_equipment_alert")]
    [Comment("获取设备告警信息")]
    public class V_GetEquipmentAlert : DEntityBase
    {
 
        /// <summary>
        /// 设备编号
        /// </summary>
        [Comment("设备编号")]
        [Required, MaxLength(32)]
        public string EquipmentId { get; set; }
 
        /// <summary>
        /// 设备名称
        /// </summary>
        [Comment("设备名称")]
        [MaxLength(255)]
        public string EquipmentName { get; set; }
 
        /// <summary>
        /// 设备所属工序
        /// </summary>
        [Comment("设备所属工序")]
        [MaxLength(32)]
        public string WorkingProcedure { get; set; }
 
        /// <summary>
        /// 设备型号
        /// </summary>
        [Comment("设备型号")]
        [MaxLength(900)]
        public string EquipmentModel { get; set; }
 
        /// <summary>
        /// 设备IP地址
        /// </summary>
        [Comment("设备IP地址")]
        [MaxLength(32)]
        public string EquipmentIP { get; set; }
 
        /// <summary>
        /// 功能
        /// </summary>
        [Comment("功能")]
        [MaxLength(255)]
        public string EquipmentFunction { get; set; }
 
        /// <summary>
        /// 设备品牌
        /// </summary>
        [Comment("设备品牌")]
        [MaxLength(255)]
        public string EquipmentBrand { get; set; }
 
        /// <summary>
        /// 设备制造商
        /// </summary>
        [Comment("设备制造商")]
        [MaxLength(255)]
        public string EquipmentManufacturer { get; set; }
 
        /// <summary>
        /// 清洗液更换时间
        /// </summary>
        [Comment("清洗液更换时间")]
        public DateTime? Detergentchangetime { get; set; }
 
        /// <summary>
        /// 清洗液更换预警阈值
        /// </summary>
        [Comment("清洗液更换预警阈值")]
        public int DetergentChangeAlertThreshold { get; set; }
 
        /// <summary>
        /// 清洗液更换周期
        /// </summary>
        [Comment("清洗液更换周期")]
        public int? DetergentChangeCycle { get; set; }
        /// <summary>
        /// 清洗液描述
        /// </summary>
        [Comment("清洗液描述")]
        [MaxLength(900)]
        public string DetergentDesc { get; set; }
        /// <summary>
        /// 刀具更换描述
        /// </summary>
        [Comment("刀具更换描述")]
        [MaxLength(900)]
        public string KnifeToolDesc { get; set; }
        /// <summary>
        /// 切削液更换描述
        /// </summary>
        [Comment("切削液更换描述")]
        [MaxLength(900)]
        public string CuttingFluidDesc { get; set; }
        /// <summary>
        /// 告警描述
        /// </summary>
        [Comment("告警描述")]
        [MaxLength(4000)]
        public string AlertDesc { get; set; }
 
        /// <summary>
        /// 刀具更换时间
        /// </summary>
        [Comment("刀具更换时间")]
        public DateTime? KnifeToolChangeTime { get; set; }
 
        /// <summary>
        /// 刀具更换预警阈值
        /// </summary>
        [Comment("刀具更换预警阈值")]
        public int? KnifeToolChangeAlertThreshold { get; set; }
 
        /// <summary>
        /// 切削液更换时间
        /// </summary>
        [Comment("切削液更换时间")]
        public DateTime? CuttingFluidChangeTime { get; set; }
 
        /// <summary>
        /// 切削液预警阈值
        /// </summary>
        [Comment("切削液预警阈值")]
        public int? CuttingFluidChangeAlertThreshold { get; set; }
 
        /// <summary>
        /// 备注
        /// </summary>
        [Comment("备注")]
        [MaxLength(900)]
        public string Remarks { get; set; }
        /// <summary>
        /// 报警时间
        /// </summary>
        [Comment("报警时间")]
        public DateTime? AlertTime { get; set; }
 
        /// <summary>
        /// 故障代码
        /// </summary>
        [Comment("故障代码")]
        [MaxLength(32)]
        public string FailureType { get; set; }
 
        /// <summary>
        /// 报警信息
        /// </summary>
        [Comment("报警信息")]
        [MaxLength(255)]
        public string Alertmsg { get; set; }
 
        /// <summary>
        /// 清洗液更换告警
        /// </summary>
        public bool IsAlertDetergent { get; set; }
        /// <summary>
        /// 刀具更换告警
        /// </summary>
        public bool IsAlertKnifeTool { get; set; }
        /// <summary>
        /// 切削液是否告警
        /// </summary>
        public bool IsAlertCuttingFluid { get; set; }
        /// <summary>
        /// 设备是否告警
        /// </summary>
        public bool IsAlert { get; set; }
 
 
    }
}