增加

schangxiang@126.com

2025-09-23 ea04aef49691444ed8ac1e7e7b94feabcbb5326f

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
using iWareCommon.Common.Entity;
using iWareCommon.Utils;
using iWareExcel.ORM;
using System;
using System.Collections.Generic;
namespace iWareExcel.EXCEL.Entity
{
    public class WorkCellEntity : ICommonEntity<EXCELWorkCell>
    {
        /// <summary>
        /// 主键
        /// </summary>
        public int Id { get; set; }
 
        /// <summary>
        /// Excel展示名
        /// </summary>
        public string DisplayName { get; set; }
 
        /// <summary>
        /// 属性名
        /// </summary>
        public string PropName { get; set; }
 
        /// <summary>
        /// 工作页Id
        /// </summary>
        public int WorkSheetId { get; set; }
 
        /// <summary>
        /// 工作页名称
        /// </summary>
        public string WorkSheetName { get; set; }
 
        /// <summary>
        /// 工作簿Id
        /// </summary>
        public int WorkBookId { get; set; }
 
        /// <summary>
        /// 工作簿名称
        /// </summary>
        public string WorkBookName { get; set; }
 
        /// <summary>
        /// 数据类型
        /// </summary>
        public int DataType { get; set; }
 
        /// <summary>
        /// 是否枚举
        /// </summary>
        public int IsEnum { get; set; }
 
        /// <summary>
        /// 枚举类名
        /// </summary>
        public string EnumClass { get; set; }
 
        /// <summary>
        /// 排序
        /// </summary>
        public int CellIndex { get; set; }
       
 
        /// <summary>
        /// 构造函数
        /// </summary>
        public WorkCellEntity(){}
 
 
       /// <summary>
       /// 构造函数
       /// </summary>
       /// <param name="workCell">工作单元</param>
        public WorkCellEntity(EXCELWorkCell workCell) 
        {
            EntityPropHelper<WorkCellEntity, EXCELWorkCell>.CopyProp(workCell, this, GetColumnMap());
        }
 
        /// <summary>
        /// 将实体类转成ORM类
        /// </summary>
        /// <returns></returns>
        public EXCELWorkCell ToOrm()
        {
            var workCell = new EXCELWorkCell();
            EntityPropHelper<WorkCellEntity, EXCELWorkCell>.CopyProp(this, workCell, GetColumnMap());
            return workCell;
        }
 
        /// <summary>
        /// 获取自定义工位类中的字段名为键，orm中对象的字段名为值的字段
        /// </summary>
        /// <returns></returns>
        public static Dictionary<String, String> GetColumnMap()
        {
            return new Dictionary<string, string>() 
            { 
                {"Id", "id"},
                {"DisplayName", "displayname"},
                {"PropName","propname"},
                {"WorkSheetId","worksheetid"},
                {"WorkSheetName","worksheetname"},
                {"WorkBookId","workbookid"},
                {"WorkBookName","workbookname"},
                {"DataType","datatype"},
                {"IsEnum","isenum"},
                {"EnumClass","enumclass"},
                {"CellIndex", "cellindex"}
            };
        }
 
 
        /// <summary>
        /// 根据Entity的字段转ORM的字段
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public static String GetColumnName(String name)
        {
            var columnMap = GetColumnMap();
            return columnMap.ContainsKey(name) ? columnMap[name] : name;
        }
 
 
        public static string GetTableName()
        {
            return "[dbo].[EXCELWorkCell]";
        }
 
 
 
        
    }
}