110,534
社区成员
发帖
与我相关
我的任务
分享
SQLiteHelper.ExecuteNonQuery(Config.dbPath, " CREATE TABLE if not exists config (mainTableName TEXT, CableDataSourcePath TEXT, TemplateNodePassingPath TEXT,templateCableSchedularPath TEXT); ", CommandType.Text);
SQLiteCommand cmd = new SQLiteCommand();
cmd.CommandText = "SELECT config.\"templateCableSchedularPath\" FROM config";
if (SQLiteHelper.ExecuteScalar(Config.dbPath, cmd) == null)
{
Config.templateCableSchedularPath = tbtemplateCableSchedularPath.Text = "请先选择文件路径再进行操作";
cmd.CommandText = "insert or replace into config(templateCableSchedularPath) values(@templateCableSchedularPath)";
cmd.Parameters.AddRange(new[] {//添加参数
new SQLiteParameter("@templateCableSchedularPath", Config.templateCableSchedularPath)
});
SQLiteHelper.ExecuteNonQuery(Config.dbPath, cmd);
}
else
{
try
{
this.tbtemplateCableSchedularPath.Text = SQLiteHelper.ExecuteScalar(Config.dbPath, cmd).ToString();
}
catch (Exception ex)
{
MessageBox.Show("请放置正确的数据库文件\n" + ex.Message);
_fatherForm.close();
return;
}
}
cmd.CommandText = "SELECT config.\"mainTableName\" FROM config";
if (SQLiteHelper.ExecuteScalar(Config.dbPath, cmd) == null )
{
Config.dbTableName = "无";
cmd.CommandText = "UPDATE config SET mainTableName=@mainTableName WHERE templateCableSchedularPath=@TemplateNodePassingPath";
cmd.Parameters.AddRange(new[] {//添加参数
new SQLiteParameter("@mainTableName", "无" ),
new SQLiteParameter("@templateCableSchedularPath", "请先选择文件路径再进行操作" )
});
SQLiteHelper.ExecuteNonQuery(Config.dbPath, cmd);
}
else
{
Config.dbTableName = SQLiteHelper.ExecuteScalar(Config.dbPath, cmd).ToString();
}