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
| using System;
| using System.Text;
| using System.Collections.Generic;
| namespace Excel2SQL
| {
| //表列实体
| public class ColumnEntity
| {
| /// <summary>
| /// 序号
| /// </summary>
| public string OrderNo { get; set; }
|
| /// <summary>
| /// 字段名称
| /// </summary>
| public string ColumnName { get; set; }
|
| /// <summary>
| /// 中文名称
| /// </summary>
| public string ChinaName { get; set; }
|
| /// <summary>
| /// 数据类型
| /// </summary>
| public string DataType { get; set; }
|
|
| /// <summary>
| /// 数据长度
| /// </summary>
| public string DataLength { get; set; }
|
| /// <summary>
| /// 是否允许为空
| /// </summary>
| public string IsNullAuble { get; set; }
| }
|
| /// <summary>
| /// 数据类型枚举
| /// </summary>
| public enum DataTypeEnum
| {
| dt_nvarchar = 0,
| dt_datetime = 1,
| dt_int = 2,
| dt_bigint = 3,
| dt_decimal = 4,
| dt_bit = 5,
| dt_varchar = 6,
| dt_char = 7
| }
| }
|
|
