/// <summary> 指数代码列表
/// </summary>
/// <returns></returns>
public List <string> GetZSCodeList()
{
const string strSql = "SELECT StkCode FROM StockHead WHERE StkType = 0";
if (_stockZSCodeList == null || _stockZSCodeList.Count == 0)
{
DataTable dt = SQLHelper.ExecuteDataTable(strSql, CommandType.Text, _cnn);
_stockZSCodeList = SysFunction.GetColList <string>(dt, 0).ToList();
}
return(_stockZSCodeList);
}
/// <summary> 查找所有历史交易日（取上证指数为参考项）
/// </summary>
/// <param name="tableName"></param>
/// <returns></returns>
public List <DateTime> GetAllTradeDay(string tableName)
{
if (!AllTypeTradeDay.ContainsKey(tableName))
{
const string sqlMod = "SELECT DISTINCT TradeDay FROM {0} WHERE StkCode = '999999' ORDER BY TradeDay";
DataTable dtDays = SQLHelper.ExecuteDataTable(string.Format(sqlMod, tableName), CommandType.Text, _cnn);
List <DateTime> lstDay = SysFunction.GetColList <DateTime>(dtDays, 0).ToList();
AllTypeTradeDay.Add(tableName, lstDay);
}
return(AllTypeTradeDay[tableName]);
}
