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