public static void GetLsTradeSail(int id) { if (!TimeSpanExtensions.IsTimeWork()) { return; } while (busyLsTradeAgent) { Color.WriteLineColor("LsTradeAgent занят...", ConsoleColor.Red); Thread.Sleep(1000); } //Color.WriteLineColor("busyLsTradeAgent = true", ConsoleColor.Cyan); busyLsTradeAgent = true; while (!Server.clients.ContainsValue("LsTradeAgent")) { Color.WriteLineColor("Внимание не запущен LsTradeAgent ..Ожидаю подключение...", ConsoleColor.Red); Thread.Sleep(5000); } string bar; int price; DateTime date; Color.WriteLineColor("Запрос в LsTrade информации по списаниям...", ConsoleColor.Cyan); try { using (MySqlConnection conn = new MySqlConnection(Connector.BarrierStringConnecting)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(@"SELECT `bar`,`turn_price`,`date` FROM `priority` WHERE `id` = " + id, conn); cmd.CommandTimeout = 0; using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { bar = dr.GetString(0); price = dr.GetInt32(1); date = dr.GetDateTime(2); Msg.SendUser("LsTradeAgent", "DR", 0, id + ";" + bar + ";" + price + ";" + date.ToString("yyyy-MM-dd,HH:mm:ss")); } } } } catch (System.Exception ex) { Color.WriteLineColor("[GetLsTradeSail] " + ex.Message, ConsoleColor.Red); Log.ExcWrite("[GetLsTradeSail] " + ex.Message); } finally { Color.WriteLineColor("Запрос отправлен.", ConsoleColor.Gray); Thread.Sleep(2000); //Color.WriteLineColor("busyLsTradeAgent = false", ConsoleColor.Cyan); busyLsTradeAgent = false; } }
private static void CheckSendUkmPrice() { if (!TimeSpanExtensions.IsTimeWork()) { return; } while (CheckThisBar.busyLsTradeAgent) { Color.WriteLineColor("LsTradeAgent занят...", ConsoleColor.Red); Thread.Sleep(1000); } //Color.WriteLineColor("busyLsTradeAgent = true", ConsoleColor.Cyan); CheckThisBar.busyLsTradeAgent = true; while (!Server.clients.ContainsValue("LsTradeAgent")) { Color.WriteLineColor("Внимание не запущен LsTradeAgent .\nДля продолжения работы нужно запустить LsTradeAgent", ConsoleColor.Red); Thread.Sleep(5000); } try { using (MySqlConnection conn = new MySqlConnection(Connector.BarrierStringConnecting)) { conn.Open(); MySqlCommand cmd = new MySqlCommand("SELECT t.tasks_id,p.id,p.bar,p.date FROM tasks t,priority p WHERE p.id = t.priority_id", conn); cmd.CommandTimeout = 0; using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { if (!dr.IsDBNull(0)) { int tasks_id = dr.GetInt32(0); int priority_id = dr.GetInt32(1); string bar = dr.GetString(2); string datetime = dr.GetDateTime(3).ToString("yyyy-MM-dd,HH:mm:ss"); //send lstradeagent priority_id;bar;datetime Msg.SendUser("LsTradeAgent", "DR", 1, priority_id + ";" + bar + ";" + datetime); Thread.Sleep(1000); } } Color.WriteLineColor("Данные для проверки задач отправлены в LsTradeAgent.", ConsoleColor.Cyan); Msg.SendUser("LsTradeAgent", "DR", 2, "Данные для проверки задач отправлены."); } } } catch (Exception ex) { Color.WriteLineColor("[CheckSendUkmPrice]" + ex.Message, ConsoleColor.Red); Log.ExcWrite("[CheckSendUkmPrice]" + ex.Message); } finally { Thread.Sleep(2000); //Color.WriteLineColor("busyLsTradeAgent = false", ConsoleColor.Cyan); CheckThisBar.busyLsTradeAgent = false; } }