개정판 8ab98ea3
issue #000:
Change-Id: I8c1f8ee91c31dfeb113c91110d06e03124304869
| DTI_PID/ID2PSN/DB.cs | ||
|---|---|---|
| 768 | 768 |
return true; |
| 769 | 769 |
} |
| 770 | 770 | |
| 771 |
public static bool SaveKeywordsSetting(List<KeywordInfo> keywordInfos)
|
|
| 771 |
public static bool SaveKeywordsSetting(List<KeywordItem> keywordItems)
|
|
| 772 | 772 |
{
|
| 773 | 773 |
ID2Info id2Info = ID2Info.GetInstance(); |
| 774 | 774 |
using (IAbstractDatabase connection = id2Info.CreateConnection(ID2DB_Type.SQLite)) |
| ... | ... | |
| 779 | 779 |
{
|
| 780 | 780 |
var query = $"DELETE FROM {PSN_TRANSFORMKEYWORD_SETTING}";
|
| 781 | 781 |
connection.ExecuteNonQuery(connection.GetSqlStringCommand(query), txn); |
| 782 | ||
| 783 |
foreach (KeywordInfo keywordInfo in keywordInfos)
|
|
| 782 |
|
|
| 783 |
foreach (KeywordItem item in keywordItems)
|
|
| 784 | 784 |
{
|
| 785 |
foreach (KeywordItem item in keywordInfo.KeywordItems) |
|
| 786 |
{
|
|
| 787 |
query = $"INSERT INTO {PSN_TRANSFORMKEYWORD_SETTING} VALUES (@INDEX, @NAME, @KEYWORD)";
|
|
| 788 |
var cmd = connection.GetSqlStringCommand(query); |
|
| 789 |
AddWithValue(cmd, "@INDEX", item.Index); |
|
| 790 |
AddWithValue(cmd, "@NAME", item.Name); |
|
| 791 |
AddWithValue(cmd, "@KEYWORD", item.Keyword); |
|
| 792 |
connection.ExecuteNonQuery(cmd, txn); |
|
| 793 |
} |
|
| 785 |
query = $"INSERT INTO {PSN_TRANSFORMKEYWORD_SETTING} VALUES (@INDEX, @NAME, @KEYWORD)";
|
|
| 786 |
var cmd = connection.GetSqlStringCommand(query); |
|
| 787 |
AddWithValue(cmd, "@INDEX", item.Index); |
|
| 788 |
AddWithValue(cmd, "@NAME", item.Name); |
|
| 789 |
AddWithValue(cmd, "@KEYWORD", item.Keyword); |
|
| 790 |
connection.ExecuteNonQuery(cmd, txn); |
|
| 794 | 791 |
} |
| 792 |
|
|
| 795 | 793 |
txn.Commit(); |
| 796 | 794 |
} |
| 797 | 795 |
catch (Exception ex) |
내보내기 Unified diff