개정판 ad983925
dev issue #000 : fix
Change-Id: I96d32e5a0804e36ac6fb5eca1a4e855608a77e8a
| DTI_PID/APIDConverter/DB/Project_DB.cs | ||
|---|---|---|
| 93 | 93 |
} |
| 94 | 94 |
if (dt.Select(string.Format("NAME = '{0}'", APID_ATTRIBUTE_TABLE)).Length == 0)
|
| 95 | 95 |
{
|
| 96 |
cmd.CommandText = string.Format("CREATE TABLE {0} (LEVEL1 TEXT PRIMARY KEY, LEVEL2 TEXT, ATTRIBUTE_KEY TEXT, ATTRIBUTE_NAME TEXT)", APID_ATTRIBUTE_TABLE);
|
|
| 96 |
cmd.CommandText = string.Format("CREATE TABLE {0} (LEVEL1 TEXT, LEVEL2 TEXT, ATTRIBUTE_KEY TEXT, ATTRIBUTE_NAME TEXT)", APID_ATTRIBUTE_TABLE);
|
|
| 97 | 97 |
cmd.ExecuteNonQuery(); |
| 98 | 98 |
} |
| 99 | 99 |
} |
| ... | ... | |
| 894 | 894 |
{
|
| 895 | 895 |
cmd.Parameters.Clear(); |
| 896 | 896 |
cmd.CommandText = string.Format(@" |
| 897 |
DELETE FROM {0} WHERE LEVEL1 = @LEVEL1 AND LEVEL2 = @LEVEL2 AND ATTRIBUTE_KEY = @ATTRIBUTE_KEY",
|
|
| 898 |
APID_ATTRIBUTE_TABLE, item.Item1, item.Item2, item.Item3); |
|
| 899 |
cmd.Parameters.AddWithValue("@LEVEL1", item.Item1);
|
|
| 900 |
cmd.Parameters.AddWithValue("@LEVEL2", item.Item2);
|
|
| 901 |
cmd.Parameters.AddWithValue("@ATTRIBUTE_KEY", item.Item3);
|
|
| 902 |
cmd.ExecuteNonQuery(); |
|
| 903 |
|
|
| 904 |
cmd.Parameters.Clear(); |
|
| 905 |
cmd.CommandText = string.Format(@" |
|
| 897 | 906 |
INSERT OR REPLACE INTO {0} (LEVEL1, LEVEL2, ATTRIBUTE_KEY, ATTRIBUTE_NAME) VALUES (@LEVEL1, @LEVEL2, @ATTRIBUTE_KEY, @ATTRIBUTE_NAME)",
|
| 898 | 907 |
APID_ATTRIBUTE_TABLE, item.Item1, item.Item2, item.Item3); |
| 899 | 908 |
cmd.Parameters.AddWithValue("@LEVEL1", item.Item1);
|
내보내기 Unified diff
