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 static void AddBar(CQGTimedBar timedBar, string symbol, DateTime runDateTime, string tType, string userName)
{
try
{
string MonthChar = "";
string Year = "";
foreach (var monthCharYearModel in monthCharYearlList)
{
if (symbol == monthCharYearModel.Symbol)
{
MonthChar = monthCharYearModel.MonthChar;
Year = monthCharYearModel.Year;
}
}
var str5 = symbol.Trim();
var str = str5.Split('.');
str5 = str[str.Length - 1];
if (GetValueAsString(timedBar.Open) == "N/A")
{
}
else
{
GetValueAsString(timedBar.Open);
}
GetValueAsString(timedBar.Timestamp);
var str3 = "'" + symbol + "'," +
GetValueAsString(Math.Max(timedBar.Open, 0)) + "," +
GetValueAsString(Math.Max(timedBar.High, 0)) + "," +
GetValueAsString(Math.Max(timedBar.Low, 0)) + "," +
GetValueAsString(Math.Max(timedBar.Close, 0)) + "," +
GetValueAsString(Math.Max(timedBar.TickVolume, 0)) + "," +
GetValueAsString(Math.Max(timedBar.ActualVolume, 0)) + "," +
GetValueAsString(Math.Max(timedBar.AskVolume, 0)) + "," +
GetValueAsString(Math.Max(timedBar.BidVolume, 0)) + "," +
GetValueAsString(Math.Max(timedBar.OpenInterest, 0)) + "," +
GetValueAsString(timedBar.Timestamp) + "," +
GetValueAsString(runDateTime) + ",'" +
_continuationType + "','" +
userName + "','" +
MonthChar + "','" +
Year + "'";
var sql = "INSERT IGNORE INTO B_" + str5 + "_" + tType + " (Symbol, OpenValue, HighValue, LowValue, CloseValue," +
" TickVol, ActualVol, AskVol, BidVol, OpenInterest," +
"BarTime, SystemTime, ContinuationType, UserName, MonthChar, Year) VALUES (" + str3 + ");";
ClientDatabaseManager.AddToQueue(sql, 5);
}
catch (Exception ex)
{
Console.WriteLine("AddBar." + ex.Message);
}
}