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);
}
}
