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("刷新失败!"); } }