public static void ModifyUserConfig(UserConfig userConfig)
{
using (var sqlConn = new SQLiteConnection(ConnectionString))
{
try
{
sqlConn.Open();
var cmd = sqlConn.CreateCommand();
cmd.CommandText = string.Format("update TB_Config set Config=@Config where [Name]='UserConfig'");
cmd.Parameters.Add(new SQLiteParameter("@Config", ObjectEx.ToBinary(userConfig)));
cmd.ExecuteNonQuery();
}
catch (Exception)
{
sqlConn.Close();
}
}
}
public static void AddUserConfig(UserConfig userConfig)
{
using (var sqlConn = new SQLiteConnection(ConnectionString))
{
try
{
sqlConn.Open();
var cmd = sqlConn.CreateCommand();
cmd.CommandText = string.Format("insert into TB_Config([Name],[Config]) values('UserConfig',@Config);");
cmd.Parameters.Add(new SQLiteParameter("@Config", ObjectEx.ToBinary(userConfig)));
cmd.ExecuteNonQuery();
}
catch (Exception)
{
sqlConn.Close();
}
}
}