public virtual IList <TKLineToday> GetStockClosePrices(IList <DateTime> queryDates, IList <string> stockFullCodes)
{
var result = new List <TKLineToday>();
if (queryDates == null || !queryDates.Any())
{
return(result);
}
string stockCodeConditionString = string.Empty;
string sql = @" SELECT [Id] , [StockCode] , [TradeDate] , [Close] FROM [dbo].[TKLineToday] WHERE [TradeDate] BETWEEN '{0}' AND '{1}' ";
if (stockFullCodes != null && stockFullCodes.Any())
{
sql += @" AND [StockCode] IN ({2}) ";
stockCodeConditionString = CommonHelper.ArrayListToSqlConditionString(stockFullCodes);
}
var commandText = stockFullCodes == null?string.Format(sql, queryDates.Min(), queryDates.Max()) : string.Format(sql, queryDates.Min(), queryDates.Max(), stockCodeConditionString);
var query = _dbContext.SqlQuery <TKLineToday>(commandText);
result.AddRange(query.ToList());
return(result);
}
public virtual IList <DataVerifyEntity> sp_GetDeliveryAndEntrustDiffData(int displayType, IList <int> accountIds, DateTime dateFrom, DateTime dateTo)
{
string ids = CommonHelper.ArrayListToSqlConditionString(accountIds);
var commanText = $@"EXEC [dbo].[sp_GetDeliveryAndEntrustDiffData] @DisplayType= {displayType}, @AccountIds = '{ids}', @DateFrom = '{dateFrom}', @DateTo = '{dateTo}'";
var result = _dbContext.SqlQuery <DataVerifyEntity>(commanText).ToList();
return(result);
}
private string GetSelectedAccountIds()
{
string accountName = this.cbAccount.SelectedItem as string;
if (accountName == "全部")
{
accountName = null;
}
int securityCode = string.IsNullOrEmpty(this.cbSecurity.SelectedValue()) ? 0 : int.Parse(this.cbSecurity.SelectedValue());
int attributeCode = string.IsNullOrEmpty(this.cbAttribute.SelectedValue()) ? 0 : int.Parse(this.cbAttribute.SelectedValue());
IList <int> accountIds = _accountService.GetAccountIds(accountName, securityCode, attributeCode);
return(CommonHelper.ArrayListToSqlConditionString(accountIds));
}
/// <summary>
/// 取得股票交易日的收盘价
/// </summary>
/// <param name="queryDates"></param>
/// <returns></returns>
public virtual IList <TKLineToday> GetStockClosePrices(DateTime queryDate, IList <string> stockFullCodes)
{
var result = new List <TKLineToday>();
string stockCodeConditionString = string.Empty;
string sql = @" SELECT [Id] , [StockCode] , [TradeDate] , [Close] FROM [dbo].[TKLineToday] WHERE [TradeDate] = '{0}' ";
if (stockFullCodes != null && stockFullCodes.Any())
{
sql += @" AND [StockCode] IN ({1}) ";
stockCodeConditionString = CommonHelper.ArrayListToSqlConditionString(stockFullCodes);
}
var commandText = stockFullCodes == null?string.Format(sql, queryDate.Date) : string.Format(sql, queryDate.Date, stockCodeConditionString);
var query = _dbContext.SqlQuery <TKLineToday>(commandText);
result = query.ToList();
return(result);
}
