通用导入Excel更新

Ben Lin

2024-12-28 6e78892c440406c94fa1190d8daa04480620f13a

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
using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;
 
namespace Tiger.Model
{
    /// <summary>
    /// ÊµÌ壺É豸¹ÊÕϵǼÇ
    /// </summary>
    [Description("Primary:ID")]
    [DisplayName("É豸¹ÊÕϵǼÇ")]
    [Serializable]
    [SugarTable("EMS_FAULT")]
    public class EMS_FAULT : DbEntityWithAuth
    {
        #region ¹¹Ô캯Êý
        /// <summary>
        /// ÊµÌ壺É豸¹ÊÕϵǼÇ
        /// </summary>
        public EMS_FAULT() {}
        #endregion
 
        #region ¹«¹²ÊôÐÔ
        /// <summary>
        /// É豸¹ÊÕϱàÂë
        /// </summary>
        [DisplayName("É豸¹ÊÕϱàÂë")]
        public string FAULT_NO { get; set; }
        /// <summary>
        /// É豸±àÂë
        /// </summary>
        [DisplayName("É豸±àÂë")]
        public string EQM_CODE { get; set; }
        /// <summary>
        /// ×´Ì¬(0BeFound±»·¢ÏÖ|1WaitHandle´ý´¦Àí|2RepairingάÐÞÖÐ|2ResolvedÒÑ´¦Àí)
        /// </summary>
        [DisplayName("״̬(0BeFound±»·¢ÏÖ|1WaitHandle´ý´¦Àí|2RepairingάÐÞÖÐ|2ResolvedÒÑ´¦Àí)")]
        public int STATUS { get; set; }
        /// <summary>
        /// ·¢Éúʱ¼ä
        /// </summary>
        [DisplayName("·¢Éúʱ¼ä")]
        public DateTime OCCUR_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// ·¢ÏÖÈË
        /// </summary>
        [DisplayName("·¢ÏÖÈË")]
        public DateTime OCCUR_USER { get; set; } = DateTime.MinValue;
        /// <summary>
        /// ¹ÊÕÏÏÖÏó
        /// </summary>
        [DisplayName("¹ÊÕÏÏÖÏó")]
        public string PROBLEM { get; set; }
        /// <summary>
        /// ¹ÊÕÏÔ­Òò
        /// </summary>
        [DisplayName("¹ÊÕÏÔ­Òò")]
        public string REASON { get; set; }
        /// <summary>
        /// Òì³£¹¤Ê±
        /// </summary>
        [DisplayName("Òì³£¹¤Ê±")]
        public double OFF_HOURS { get; set; }
        /// <summary>
        /// ÊÇ·ñÐèҪάÐÞ
        /// </summary>
        [DisplayName("ÊÇ·ñÐèҪάÐÞ")]
        public string NEED_REPAIR { get; set; }
        /// <summary>
        /// ´¦ÀíÈË
        /// </summary>
        [DisplayName("´¦ÀíÈË")]
        public DateTime HANDLE_USER { get; set; } = DateTime.MinValue;
        /// <summary>
        /// ´¦Àí´ëÊ©
        /// </summary>
        [DisplayName("´¦Àí´ëÊ©")]
        public string MEASURE { get; set; }
        /// <summary>
        /// ´¦Àí½á¹û
        /// </summary>
        [DisplayName("´¦Àí½á¹û")]
        public string RESULT { get; set; }
        /// <summary>
        /// ±¸×¢
        /// </summary>
        [DisplayName("±¸×¢")]
        public string REMARK { get; set; }
        #endregion
 
        #region ÐéÄâÊôÐÔ
        /*Àý×Ó
        [SugarColumn(IsIgnore = true)]
        public string FieldName { get; set; }
        */
        #endregion
 
        #region Íâ¼üÊôÐÔ
        /*Àý×Ó
        //Ò»¶ÔÒ»Íâ¼üµ¼º½
        [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//Ò»¶ÔÒ» ClassAIdÊÇEMS_FAULTÀàÀïÃæµÄÍâ¼üID×Ö¶Î
        public ClassA ClassA { get; set; } //×¢Òâ½ûÖ¹ÊÖ¶¯¸³Öµ£¬Ö»ÄÜÊÇnull
        //Ò»¶Ô¶àÍâ¼üµ¼º½
        [Navigate(NavigateType.OneToMany, nameof(ClassA.EMS_FAULTId))]//ClassA±íÖеÄEMS_FAULTId
        public List<ClassA> ClassAList { get; set; }//×¢Òâ½ûÖ¹ÊÖ¶¯¸³Öµ£¬Ö»ÄÜÊÇnull
        //¶à¶Ô¶àÍâ¼üµ¼º½
        [Navigate(typeof(MappingClass), nameof(MappingClass.EMS_FAULTId), nameof(MappingClass.ClassAId))]//×¢Òâ˳Ðò
        public List<ClassA> ClassAList { get; set; } //×¢Òâ½ûÖ¹ÊÖ¶¯¸³Öµ£¬Ö»ÄÜÊÇnull
        */
        #endregion
 
        #region Ã¶¾Ù±äÁ¿
        /*Àý×Ó
        public enum FieldNames
        {
            [Description("ö¾ÙÃèÊö0")]
            Enum0,
            [Description("ö¾ÙÃèÊö1")]
            Enum1,
        }
        */
 
        /// <summary>
        /// Ã¶¾Ù£º×´Ì¬(0BeFound±»·¢ÏÖ|1WaitHandle´ý´¦Àí|2RepairingάÐÞÖÐ|2ResolvedÒÑ´¦Àí)
        /// </summary>
        public enum STATUSs
        {
            [Description("±»·¢ÏÖ")]
            BeFound = 0,
            [Description("´ý´¦Àí")]
            WaitHandle = 1,
            [Description("άÐÞÖÐ")]
            Repairing = 2,
            [Description("ÒÑ´¦Àí")]
            Resolved = 2,
        }
        #endregion
 
        #region ¹«¹²·½·¨
 
        #endregion
 
    }//endClass
}