public override void LoadData(DBConn dbConn)
{
dbConn.SourceInfo = "Stock.LoadData";
stockId = dbConn.ColLong("StockId", 0, 0);
symbol = dbConn.ColString("Symbol");
exchangeCode = dbConn.ColString("BrokerExchangeCode", 0, 0);
primaryExchange = dbConn.ColString("PrimaryExchange", 0, 0);
securityType = dbConn.ColString("SecType", 0, 0);
currencyCode = dbConn.ColString("CUR", 0, 0);
resolution = dbConn.ColString("Resolution", 0, 0);
theDate = dbConn.ColDate("Date", 0, 0);
ticksMax = dbConn.ColLong("Ticks", 0, 0);
ticksSkip = dbConn.ColLong("Skip", 0, 0);
// UNIX timestamps, BigInt (64-bit)
fromDate = dbConn.ColBig("FromDate", 0, 0);
toDate = dbConn.ColBig("ToDate", 0, 0);
// UNIX timestamps, Int (32-bit)
// fromDate = dbConn.ColLong ("FromDate",0,0);
// toDate = dbConn.ColLong ("ToDate",0,0);
// Date format
// fromDate = dbConn.ColDate ("FromDate",0,0);
// toDate = dbConn.ColDate ("ToDate",0,0);
price = 0;
quantity = 0;
tickType = 0;
}
public override void LoadData(DBConn dbConn)
{
dbConn.SourceInfo = "MiscData.LoadData";
colNo = -88;
string dataType;
decimal curr;
DateTime dt;
try
{
for (int k = 0; k < dbConn.ColumnCount; k++)
{
if (k > theData.Length)
{
break;
}
dataType = dbConn.ColDataType("", k).ToUpper();
if (dataType.Contains("DATE"))
{
dt = dbConn.ColDate("", k);
theData[k] = Tools.DateToString(dt, 7, 0); // yyyy-mm-dd
}
else if (dataType.Contains("DECIMAL") || dataType.Contains("FLOAT"))
{
curr = dbConn.ColDecimal("", k);
theData[k] = Tools.DecimalToString(curr, 2);
}
else
{
theData[k] = dbConn.ColValue(k);
}
if (theData[k].ToUpper().StartsWith("[FORECOLOR]"))
{
foreColor = System.Drawing.Color.FromName(theData[k].Substring(11).Trim());
}
else if (theData[k].ToUpper().StartsWith("[BACKCOLOR]"))
{
backColor = System.Drawing.Color.FromName(theData[k].Substring(11).Trim());
}
}
}
catch (Exception ex)
{
Tools.LogException("LoadData", "", ex, this);
}
}
