private void MainForm_Load(object sender, EventArgs e) { SqLiteHelper sqlHelper = new SqLiteHelper(); sqlHelper.SqliteOpen(); try { //查询所有可以交易品种 symbols = SYRequest.QureyAllSymbol(); if (symbols == null) { MessageBox.Show("查询当前可用交易品种失败!"); windowStop = true; Close(); return; } //读取整张表 SQLiteDataReader reader = sqlHelper.ReadFullTable("user"); if (reader != null) { List <string> item = new List <string>(); while (reader.Read()) { int id = reader.GetInt32(reader.GetOrdinal("id")); string username = reader.GetString(reader.GetOrdinal("username")); string password = reader.GetString(reader.GetOrdinal("password")); int uid = reader.GetInt32(reader.GetOrdinal("uid")); string coinSymbol = reader.GetString(reader.GetOrdinal("coinSymbol")); string reamrks = reader.GetString(reader.GetOrdinal("remarks")); ListViewItem lvt = new ListViewItem(); lvt.Text = id + ""; lvt.SubItems.Add(username); lvt.SubItems.Add("********"); lvt.SubItems.Add(uid + ""); lvt.SubItems.Add(coinSymbol); lvt.SubItems.Add(getRunStatus(uid).ToString()); lvt.SubItems.Add(reamrks); strategyList.Items.Add(lvt); } } sqlHelper.SqliteClose(); //设置顶时任务 System.Timers.Timer timer = new System.Timers.Timer(); timer.Enabled = true; timer.Interval = 10000;//执行间隔时间,单位为毫秒 timer.Start(); timer.Elapsed += new System.Timers.ElapsedEventHandler(OnTimer); } catch { sqlHelper.SqliteClose(); } }
private void btn_Flush_Click(object sender, EventArgs e) { try { //查询所有可以交易品种 symbols = SYRequest.QureyAllSymbol(); if (symbols == null) { MessageBox.Show("刷新失败!"); return; } SqLiteHelper sqlHelper = new SqLiteHelper(); strategyList.Items.Clear(); sqlHelper.SqliteOpen(); //读取整张表 SQLiteDataReader reader = sqlHelper.ReadFullTable("user"); if (reader != null) { List <string> item = new List <string>(); while (reader.Read()) { int id = reader.GetInt32(reader.GetOrdinal("id")); string username = reader.GetString(reader.GetOrdinal("username")); string password = reader.GetString(reader.GetOrdinal("password")); int uid = reader.GetInt32(reader.GetOrdinal("uid")); string coinSymbol = reader.GetString(reader.GetOrdinal("coinSymbol")); string reamrks = reader.GetString(reader.GetOrdinal("remarks")); ListViewItem lvt = new ListViewItem(); lvt.Text = id + ""; lvt.SubItems.Add(username); lvt.SubItems.Add("********"); lvt.SubItems.Add(uid + ""); lvt.SubItems.Add(coinSymbol); lvt.SubItems.Add(getRunStatus(uid).ToString()); lvt.SubItems.Add(reamrks); strategyList.Items.Add(lvt); } } sqlHelper.SqliteClose(); MessageBox.Show("刷新成功!"); } catch { MessageBox.Show("刷新失败!"); } }
static void dllMain(string[] args) { sql = new SqLiteHelper(); sql.SqliteOpen(""); //创建名为table1的数据表 sql.CreateTable("table1", new string[] { "ID", "Name", "Age", "Email" }, new string[] { "INTEGER", "TEXT", "INTEGER", "TEXT" }); //插入两条数据 sql.InsertValues("table1", new string[] { "1", "张三", "22", "*****@*****.**" }); sql.InsertValues("table1", new string[] { "2", "李四", "25", "*****@*****.**" }); //更新数据,将Name="张三"的记录中的Name改为"Zhang3" sql.UpdateValues("table1", new string[] { "Name" }, new string[] { "ZhangSan" }, "Name", "Zhang3"); //删除Name="张三"且Age=26的记录,DeleteValuesOR方法类似 sql.DeleteValuesAND("table1", new string[] { "Name", "Age" }, new string[] { "张三", "22" }, new string[] { "=", "=" }); //读取整张表 SQLiteDataReader reader = sql.ReadFullTable("table1"); while (reader.Read()) { //读取ID Log("" + reader.GetInt32(reader.GetOrdinal("ID"))); //读取Name Log("" + reader.GetString(reader.GetOrdinal("Name"))); //读取Age Log("" + reader.GetInt32(reader.GetOrdinal("Age"))); //读取Email Log(reader.GetString(reader.GetOrdinal("Email"))); } while (true) { Console.ReadLine(); } }