private void btn_Query_Click(object sender, EventArgs e)
{
Database.DemoDataQueryParams queryParams = new Database.DemoDataQueryParams()
{
Line = 1,
Column = 2,
Plat = 3,
};
//if (Database.DemoData.Insert(queryParams))
//{
// Console.WriteLine("Insert OK..");
//}
Database.DemoData.QueryData(queryParams);
label_Status.Text = "正在查询中";
Task.Factory.StartNew(() =>
{
var ret = Database.LocalDataQuery.QueryData();
if (ret.Item1)
{
this.Invoke(new Action(() =>
{
dataGridView1.DataSource = ret.Item2;
label_Status.Text = "查询完毕";
}));
}
});
}
public static bool Insert(DemoDataQueryParams queryParams)
{
string sql = "REPLACE INTO [demo_data] ([line_number], [column_number], [plat_number], [update_time]) " +
"VALUES(@Line, @Column, @Plat, @UpdateTime);";
//"VALUES(1, 4, 1, '2018-06-03 15:02:00');";
using (SQLiteCommand cmd = new SQLiteCommand(sql))
{
cmd.Parameters.Add("@Line", System.Data.DbType.Int32).Value = queryParams.Line;
cmd.Parameters.Add("@Column", System.Data.DbType.Int32).Value = queryParams.Column;
cmd.Parameters.Add("@Plat", System.Data.DbType.Int32).Value = queryParams.Plat;
cmd.Parameters.Add("@UpdateTime", System.Data.DbType.DateTime).Value = DateTime.Now;
return(DemoDataSource.Instance.Execute(cmd) > 0);
}
}
public static Tuple <bool, DataTable> QueryData(DemoDataQueryParams queryParams)
{
StringBuilder sql = new StringBuilder();
sql.Append("SELECT * FROM [demo_data] ");
sql.Append("WHERE ");
sql.Append("[line_number] = @Line;");
using (SQLiteCommand cmd = new SQLiteCommand(sql.ToString()))
{
cmd.Parameters.Add("@Line", System.Data.DbType.Int32).Value = queryParams.Line;
DataTable table = DemoDataSource.Instance.GetTable(cmd);
if (table != null)
{
return(new Tuple <bool, DataTable>(true, table));
}
return(new Tuple <bool, DataTable>(false, null));
}
}
