private static void AddTick(CQGTick tick, string symbol, DateTime runDateTime, int groupId, string userName) { try { var str = symbol.Trim().Split('.'); var query = "INSERT IGNORE INTO T_" + str[str.Length - 1] + "_" + GetIso8601WeekOfYear(tick.Timestamp); query += "(Symbol, Price, Volume, TickTime, SystemTime, ContinuationType, PriceType, GroupId, UserName) VALUES"; query += "('"; query += symbol + "',"; query += GetValueAsString(tick.Price) + ","; query += GetValueAsString(tick.Volume) + ","; query += GetValueAsString(tick.Timestamp) + ","; query += GetValueAsString(runDateTime) + ","; query += "'" + _continuationType + "',"; query += "'" + tick.PriceType.ToString() + "',"; query += GetValueAsString(groupId) + ","; query += "'" + userName + "');"; ClientDatabaseManager.AddToQueue(query, 2); } catch (Exception ex) { Console.WriteLine("Exception.AddTick." + ex.Message); } }
private void AddTick(CQGTick tick, string symbol, DateTime runDateTime, int groupId, string userName) { try { var str = symbol.Trim().Split('.'); var query = "INSERT IGNORE INTO T_" + str[str.Length - 1]; query += "(Symbol, Price, Volume, TickTime, SystemTime, ContinuationType, PriceType, GroupId, UserName) VALUES"; query += "('"; query += symbol + "',"; query += GetValueAsString(tick.Price) + ","; query += GetValueAsString(tick.Volume) + ","; query += GetValueAsString(tick.Timestamp) + ","; query += GetValueAsString(runDateTime) + ","; query += "'" + _aContinuationType + "',"; query += "'" + tick.PriceType.ToString() + "',"; query += GetValueAsString(groupId) + ","; query += "'" + userName + "');"; DatabaseManager.AddToQueue(query,2); } catch (Exception ex) { Console.WriteLine(ex.Message); _logger.LogAdd("AddTick. " + ex, Category.Error); } }