通用导入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
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_REPAIR")]
    public class EMS_REPAIR : DbEntityWithAuth
    {
        #region ¹¹Ô캯Êý
        /// <summary>
        /// ÊµÌ壺É豸άÐ޼Ǽ
        /// </summary>
        public EMS_REPAIR() {}
        #endregion
 
        #region ¹«¹²ÊôÐÔ
        /// <summary>
        /// É豸άÐÞ±àÂë
        /// </summary>
        [DisplayName("É豸άÐÞ±àÂë")]
        public string REPAIR_NO { get; set; }
        /// <summary>
        /// É豸±àÂë
        /// </summary>
        [DisplayName("É豸±àÂë")]
        public string EQM_CODE { get; set; }
        /// <summary>
        /// ×´Ì¬(0Waiting´ýάÐÞ|1RepairingάÐÞÖÐ|2RepairedάÐÞÍê)
        /// </summary>
        [DisplayName("״̬(0Waiting´ýάÐÞ|1RepairingάÐÞÖÐ|2RepairedάÐÞÍê)")]
        public int STATUS { get; set; }
        /// <summary>
        /// ¹ÊÕÏÔ­Òò
        /// </summary>
        [DisplayName("¹ÊÕÏÔ­Òò")]
        public string REASON { get; set; }
        /// <summary>
        /// Î¬ÐÞÈË
        /// </summary>
        [DisplayName("άÐÞÈË")]
        public DateTime REPAIR_USER { get; set; } = DateTime.MinValue;
        /// <summary>
        /// Î¬ÐÞ¿ªÊ¼Ê±¼ä
        /// </summary>
        [DisplayName("άÐÞ¿ªÊ¼Ê±¼ä")]
        public DateTime BEGIN_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// Î¬ÐÞ½áÊøʱ¼ä
        /// </summary>
        [DisplayName("άÐÞ½áÊøʱ¼ä")]
        public DateTime END_TIME { get; set; } = DateTime.MinValue;
        /// <summary>
        /// Î¬ÐÞÏêÇé
        /// </summary>
        [DisplayName("άÐÞÏêÇé")]
        public string DETAILS { get; set; }
        /// <summary>
        /// Î¬ÐÞ·ÑÓÃ
        /// </summary>
        [DisplayName("άÐÞ·ÑÓÃ")]
        public double COSTS { get; set; }
        /// <summary>
        /// Òì³£¹¤Ê±
        /// </summary>
        [DisplayName("Òì³£¹¤Ê±")]
        public double HOURS { get; set; }
        /// <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_REPAIRÀàÀïÃæµÄÍâ¼üID×Ö¶Î
        public ClassA ClassA { get; set; } //×¢Òâ½ûÖ¹ÊÖ¶¯¸³Öµ£¬Ö»ÄÜÊÇnull
        //Ò»¶Ô¶àÍâ¼üµ¼º½
        [Navigate(NavigateType.OneToMany, nameof(ClassA.EMS_REPAIRId))]//ClassA±íÖеÄEMS_REPAIRId
        public List<ClassA> ClassAList { get; set; }//×¢Òâ½ûÖ¹ÊÖ¶¯¸³Öµ£¬Ö»ÄÜÊÇnull
        //¶à¶Ô¶àÍâ¼üµ¼º½
        [Navigate(typeof(MappingClass), nameof(MappingClass.EMS_REPAIRId), nameof(MappingClass.ClassAId))]//×¢Òâ˳Ðò
        public List<ClassA> ClassAList { get; set; } //×¢Òâ½ûÖ¹ÊÖ¶¯¸³Öµ£¬Ö»ÄÜÊÇnull
        */
        #endregion
 
        #region Ã¶¾Ù±äÁ¿
        /*Àý×Ó
        public enum FieldNames
        {
            [Description("ö¾ÙÃèÊö0")]
            Enum0,
            [Description("ö¾ÙÃèÊö1")]
            Enum1,
        }
        */
 
        /// <summary>
        /// Ã¶¾Ù£º×´Ì¬(0Waiting´ýάÐÞ|1RepairingάÐÞÖÐ|2RepairedάÐÞÍê)
        /// </summary>
        public enum STATUSs
        {
            [Description("´ýάÐÞ")]
            Waiting = 0,
            [Description("άÐÞÖÐ")]
            Repairing = 1,
            [Description("άÐÞÍê")]
            Repaired = 2,
        }
        #endregion
 
        #region ¹«¹²·½·¨
 
        #endregion
 
    }//endClass
}