-
Notifications
You must be signed in to change notification settings - Fork 0
/
Column.cs
73 lines (57 loc) · 1.88 KB
/
Column.cs
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
using System;
using System.Data;
using System.Globalization;
namespace SatelliteDataScripter
{
public class Column
{
public string Name { get; set; }
public string DataType { get; set; }
public string EscapedName
{
get { return string.Format("[{0}]", Name); }
}
public bool IsIdColumn
{
get { return Name.ToLower() == "id"; }
}
public bool Generate { get; set; }
public Column(TablesDataSet.ColumnRow row)
{
Name = row.Column_Name;
DataType = row.Data_Type;
Generate = true;
}
public string GetValue(DataRow row)
{
var value = row[Name];
if (value == DBNull.Value)
{
return "NULL";
}
switch (DataType.ToLower())
{
case "int":
case "bigint":
case "smallint":
return value.ToString();
case "char":
case "varchar":
case "uniqueidentifier":
return string.Format("'{0}'", Convert.ToString(value).Replace("'", "''"));
case "nvarchar":
case "nchar":
return string.Format("N'{0}'", Convert.ToString(value).Replace("'", "''"));
case "datetime":
case "smalldatetime":
return string.Format("'{0:yyyy-MM-dd HH:mm:ss}'", value);
case "bit":
return (bool)value ? "1" : "0";
case "decimal":
return Convert.ToString(value, CultureInfo.GetCultureInfo("en-US"));
default:
throw new Exception(string.Format("The data type '{0}' is not supported for generation.", DataType));
}
}
}
}