/// <summary> /// 股票代码 /// </summary> /// <returns></returns> public ApiResponse <List <GetStockCodeResponse> > GetStockCodeList(GetStockCodeRequest request) { var response = new ApiResponse <List <GetStockCodeResponse> > { Data = new List <GetStockCodeResponse>() }; var provinceList = _financeRepository.GetStockCodeList(request); provinceList.ForEach(item => { response.Data.Add(_mapper.Map <GetStockCodeResponse>(item)); }); return(response); }
/// <summary> /// 获取股票信息 /// </summary> /// <param name="request"></param> /// <returns></returns> public List <StockInfo> GetStockCodeList(GetStockCodeRequest request) { var sbSql = new StringBuilder(@" select * from finance_stockcode where 1=1"); var param = new DynamicParameters(); if (request.MarketType > 0) { sbSql.Append(" and MarketType = ?MarketType"); param.Add("MarketType", (int)request.MarketType); } if (request.SubMarketType > 0) { sbSql.Append(" and SubMarketType = ?SubMarketType"); param.Add("SubMarketType", (int)request.SubMarketType); } using (var conn = OpenConnection()) { return(conn.Query <StockInfo>(sbSql.ToString(), param).AsList()); } }