public static void LoadData(baseDS.stockCodeDataTable tbl, string code) { stockCodeTA.ClearBeforeFill = false; if (code == null) { stockCodeTA.Fill(tbl); } else { stockCodeTA.FillByCode(tbl, code); } }
public static void LoadStockCode_ByBizSectors(tmpDS.stockCodeDataTable tbl, StringCollection bizSectors) { baseDS.stockCodeDataTable comTbl = new baseDS.stockCodeDataTable(); string cond = common.system.MakeConditionStr(bizSectors, comTbl.bizSectorsColumn.ColumnName + " LIKE N'" + common.Consts.SQL_CMD_ALL_MARKER + common.Settings.sysListSeparatorPrefix, common.Settings.sysListSeparatorPostfix + common.Consts.SQL_CMD_ALL_MARKER + "'", "OR"); string sqlCmd = "SELECT code, stockExchange, tickerCode, name,nameEn,0 AS price,0 AS priceVariant FROM stockCode WHERE " + cond; LoadFromSQL(tbl, sqlCmd); }
public static void LoadData(baseDS.stockCodeDataTable tbl, AppTypes.CommonStatus status) { try { stockCodeTA.ClearBeforeFill = false; stockCodeTA.FillByStatusMask(tbl, ((byte)status).ToString()); } catch (Exception er) { WriteLog(common.SysSeverityLevel.Alert, "AAA2 ", er); } }
/// <summary> /// Get the all last price (grouped by timescale and stock) from databases /// </summary> public static void GetLastClosePrices() { ClearLastClosePrices(); databases.baseDS.stockCodeDataTable stockCodeTbl = new baseDS.stockCodeDataTable(); databases.DbAccess.LoadData(stockCodeTbl); databases.baseDS.priceDataSumRow priceDataSumRow; for (int idx = 0; idx < stockCodeTbl.Count; idx++) { foreach (AppTypes.TimeScale timeScale in AppTypes.myTimeScales) { if (timeScale == AppTypes.MainDataTimeScale) { continue; } priceDataSumRow = databases.DbAccess.GetLastPrice(timeScale.Code, stockCodeTbl[idx].code); if (priceDataSumRow == null) { continue; } lastClosePrices.Add(timeScale.Code + stockCodeTbl[idx].code, priceDataSumRow.closePrice); } } }
/// <summary> /// Get the all last price (grouped by timescale and stock) from databases /// </summary> public static void GetLastClosePrices() { ClearLastClosePrices(); databases.baseDS.stockCodeDataTable stockCodeTbl = new baseDS.stockCodeDataTable(); databases.DbAccess.LoadData(stockCodeTbl); databases.baseDS.priceDataSumRow priceDataSumRow; for (int idx = 0; idx < stockCodeTbl.Count; idx++) { foreach (AppTypes.TimeScale timeScale in AppTypes.myTimeScales) { if (timeScale == AppTypes.MainDataTimeScale) continue; priceDataSumRow = databases.DbAccess.GetLastPrice(timeScale.Code, stockCodeTbl[idx].code); if (priceDataSumRow == null) continue; lastClosePrices.Add(timeScale.Code + stockCodeTbl[idx].code, priceDataSumRow.closePrice); } } }
public static void LoadStockCode_ByStatus(baseDS.stockCodeDataTable tbl, AppTypes.CommonStatus status) { stockCodeTA.FillByStatusMask(tbl, ((byte)status).ToString()); }
public static void LoadData(baseDS.stockCodeDataTable tbl) { stockCodeTA.ClearBeforeFill = false; stockCodeTA.Fill(tbl); }
public static void LoadData(baseDS.stockCodeDataTable tbl, AppTypes.CommonStatus status) { stockCodeTA.ClearBeforeFill = false; stockCodeTA.FillByStatusMask(tbl, ((byte)status).ToString()); }
public static void UpdateData(baseDS.stockCodeDataTable tbl) { stockCodeTA.Update(tbl); tbl.AcceptChanges(); }