public List <KeyValueSetting> KeyValueSettings()
{
string error = "";
DataTable dataTable = EnvironmentInfo.SqliteHelper.GetDataTable(out error, "select * from sys_key_value_setting");
List <KeyValueSetting> settings = new List <KeyValueSetting>();
foreach (DataRow dr in dataTable.Rows)
{
KeyValueSetting setting = new KeyValueSetting();
setting.KeyType = int.Parse(dr["KeyType"].ToString());
setting.KeyId = dr["KeyId"].ToString();
setting.KeyName = dr["KeyName"].ToString();
setting.ValueText = dr["ValueText"].ToString();
setting.Remark = dr["Remark"].ToString();
settings.Add(setting);
}
return(settings);
}
public void WriteSetting(KeyValueSetting keyValueSetting)
{
KeyValueSetting setting = ReadSetting(keyValueSetting.KeyId);
if (setting == null || (setting != null && setting.KeyType == -1))//插入
{
string error = "";
setting.KeyType = 1;
EnvironmentInfo.SqliteHelper.UpdateData(out error, $"insert into sys_key_value_setting(KeyType, KeyID, KeyName, ValueText, Remark)values('{keyValueSetting.KeyType}','{keyValueSetting.KeyId}','{keyValueSetting.KeyName}','{keyValueSetting.ValueText}','{keyValueSetting.Remark}');");
EnvironmentInfo.Settings.Add(keyValueSetting);
}
else
{
string error = "";
EnvironmentInfo.SqliteHelper.UpdateData(out error, $"update sys_key_value_setting set ValueText='{keyValueSetting.ValueText}' where KeyID='{keyValueSetting.KeyId}';");
setting.ValueText = keyValueSetting.ValueText;
}
}
