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