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