/// <summary>
/// 查询点击事件,todo此处需要改成异步的，否则长时间的查询会造成假死
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void btnSearch_Click(object sender, RoutedEventArgs e)
{
try
{
string conString = txtDbString.Text?.Trim() ?? string.Empty;
if (string.IsNullOrEmpty(conString))
{
MessageBox.Show("数据库字符串不能为空");
return;
}
string sqlString = txtSqlString.Text?.Trim() ?? string.Empty;
if (string.IsNullOrEmpty(sqlString))
{
MessageBox.Show("请输入sql语句");
return;
}
SqlLiteDataCommand.InsertDBStringLog(new DBStringLog()
{
DBString = conString, CreateTime = DateTime.Now
}, sqliteConnectionCreate.Conn);
SqlLiteDataCommand.InsertSqlStringLog(new SqlStringLog()
{
SqlString = sqlString, DBStringID = 1, CreateTime = DateTime.Now
}, sqliteConnectionCreate.Conn);
DataTable dataTable = new DataTable();
using (IDbConnection conn = ConnectionCreate.GetDBConection(conString))
{
dataTable.Load(conn.ExecuteReader(sqlString));
}
string result = JsonConvert.SerializeObject(dataTable, new DataTableConverter());
txtJsonString.Text = ConvertJsonString(result);
}
catch (Exception ex)
{
txtJsonString.Text = ex.ToString();
}
}
/// <summary>
/// 初始化相关控制的值，取最近的一条记录
/// </summary>
public void InitTextValue()
{
txtDbString.Text = SqlLiteDataCommand.GetNewDBStringLog(sqliteConnectionCreate.Conn);
txtSqlString.Text = SqlLiteDataCommand.GetNewSqlStringLog(sqliteConnectionCreate.Conn);
}
