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