/*private void OnSTIOrderUpdateXML(ref string strOrder) * { * XmlSerializer xs = new XmlSerializer(typeof(SterlingLib.structSTIOrderUpdate)); * SterlingLib.structSTIOrderUpdate structOrder = (SterlingLib.structSTIOrderUpdate)xs.Deserialize(new StringReader(strOrder)); * } * * private void OnSTIPositionUpdateXML(ref string strPosition) * { * XmlSerializer xs = new XmlSerializer(typeof(SterlingLib.structSTIPositionUpdate)); * SterlingLib.structSTIPositionUpdate structPosition = (SterlingLib.structSTIPositionUpdate)xs.Deserialize(new StringReader(strPosition)); * int netPos = (structPosition.nSharesBot - structPosition.nSharesSld); * //AddListBoxItem("Postion (XML): " + structPosition.bstrSym + " Position = " + netPos); * }*/ private void button1_Click(object sender, EventArgs e) { using (SQLiteConnection conn = new SQLiteConnection("Data Source=database.db;Version=3;New=True;Compress=True;")) { conn.Open(); string stm = "SELECT * FROM Algo WHERE Status='Queued'"; using (SQLiteCommand cmd = new SQLiteCommand(stm, conn)) { using (SQLiteDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { if (DateTime.ParseExact(rdr.GetString(3), "yyyy-MM-dd HH:mm:ss.ff", null) > DateTime.ParseExact(stiApp.GetServerTime(), "yyyyMMddHHmmss", null)) { Debug.WriteLine("---------------------"); Debug.WriteLine(rdr.GetString(1) + " : " + rdr.GetString(2) + " : " + rdr.GetString(3)); AlgoForm af = new AlgoForm(rdr.GetString(1), rdr.GetString(2), DateTime.ParseExact(rdr.GetString(3), "yyyy-MM-dd HH:mm:ss.ff", null), DateTime.ParseExact(rdr.GetString(4), "yyyy-MM-dd HH:mm:ss.ff", null), rdr.GetInt32(5), rdr.GetDecimal(6), rdr.GetInt32(7), rdr.GetInt32(10), rdr.GetInt32(11)); af.Show(); } } } } conn.Close(); } }
private void button2_Click(object sender, EventArgs e) { AlgoForm af = new AlgoForm(); af.Show(); }