개정판 93c417a9
dev issue #000 : project
Change-Id: Ifb5fd7037e129872dd095ac729e0e8db3393dead
| DTI_PID/SPPIDConverter/DB/Project_DB.cs | ||
|---|---|---|
| 130 | 130 |
} |
| 131 | 131 |
|
| 132 | 132 |
#region Check Column 업데이트시 예비용 |
| 133 |
cmd.CommandText = string.Format("SELECT * FROM {0}", SPPID_ATTRIBUTE_MAPPING_TABLE);
|
|
| 134 |
using (SQLiteDataReader dr = cmd.ExecuteReader()) |
|
| 135 |
using (DataTable dt = new DataTable()) |
|
| 136 |
{
|
|
| 137 |
dt.Load(dr); |
|
| 138 |
if (!dt.Columns.Contains("ISTEXT"))
|
|
| 139 |
{
|
|
| 140 |
cmd.CommandText = string.Format("ALTER TABLE {0} ADD COLUMN ISTEXT BOOLEAN", SPPID_ATTRIBUTE_MAPPING_TABLE);
|
|
| 141 |
cmd.ExecuteNonQuery(); |
|
| 142 |
} |
|
| 143 |
} |
|
| 144 |
|
|
| 133 | 145 |
cmd.CommandText = string.Format("SELECT * FROM {0}", SPPID_SYMBOL_MAPPING_TABLE);
|
| 134 | 146 |
using (SQLiteDataReader dr = cmd.ExecuteReader()) |
| 135 | 147 |
using (DataTable dt = new DataTable()) |
| ... | ... | |
| 250 | 262 |
} |
| 251 | 263 |
|
| 252 | 264 |
#region Check Column 업데이트시 예비용 |
| 265 |
//cmd.CommandText = string.Format("SELECT * FROM {0}", SPPID_ATTRIBUTE_MAPPING_TABLE);
|
|
| 266 |
//using (SQLiteDataReader dr = cmd.ExecuteReader()) |
|
| 267 |
//using (DataTable dt = new DataTable()) |
|
| 268 |
//{
|
|
| 269 |
// dt.Load(dr); |
|
| 270 |
// if (!dt.Columns.Contains("ISTEXT"))
|
|
| 271 |
// {
|
|
| 272 |
// cmd.CommandText = string.Format("ALTER TABLE {0} ADD COLUMN ISTEXT BIT", SPPID_ATTRIBUTE_MAPPING_TABLE);
|
|
| 273 |
// cmd.ExecuteNonQuery(); |
|
| 274 |
// } |
|
| 275 |
//} |
|
| 253 | 276 |
#endregion |
| 254 | 277 |
} |
| 255 | 278 |
result = true; |
내보내기 Unified diff
