/// <summary> /// 根据委托单号,从今日委托和历史委托中查询相关的委托单数据 /// 这里如果在历史委托表中的数据因为没有可撤标识,这里为了能转换回今日委托,所以直接转为不可撤0 /// 通道号附为空字符串"" /// </summary> /// <param name="entrustStr">委托单号</param> /// <returns></returns> public List <QH_TodayEntrustTableInfo> GetEntrustListByEnturstNo(string entrustStr) { QH_TodayEntrustTableDal dal = new QH_TodayEntrustTableDal(); CommonDALOperate <QH_TodayEntrustTableInfo> com = new CommonDALOperate <QH_TodayEntrustTableInfo>(); return(com.ExecuterReaderDataBind(string.Format(GetEntrustListByEnturstNoSqlScript(), entrustStr.ToString()), dal.ReaderBind)); }
/// <summary> /// 根据通道号返回要回道的所有委托数据,这里包含历史委托的数据 /// </summary> /// <param name="channleID">通道号</param> /// <returns></returns> public List <QH_TodayEntrustTableInfo> GetEntrustListByChannleID(string channleID) { string sql = string.Format(GetDistincEntrustNumberSqlScript(), channleID); QH_TodayEntrustTableDal dal = new QH_TodayEntrustTableDal(); CommonDALOperate <QH_TodayEntrustTableInfo> com = new CommonDALOperate <QH_TodayEntrustTableInfo>(); return(com.ExecuterReaderDataBind(string.Format(GetEntrustListByEnturstNoSqlScript(), sql), dal.ReaderBind)); }
/// <summary> /// 根据通道号返回当日成交数据,这里包括清算后移动到历史表中还是当日的数据 /// </summary> /// <param name="channleID">通道Id</param> /// <returns></returns> public List <QH_TodayTradeTableInfo> GetTodayTradeListByChannleID(string channleID) { StringBuilder sb = new StringBuilder(""); sb.Append(" SELECT [TradeNumber],[EntrustNumber],[PortfolioLogo],[TradePrice],[EntrustPrice],[TradeAmount] "); sb.Append(" ,[TradeProceduresFee],[Margin],[ContractCode],[TradeAccount],[CapitalAccount],[BuySellTypeId] "); sb.Append(" ,[OpenCloseTypeId],[TradeUnitId],[TradeTypeId],[CurrencyTypeId],[TradeTime],[MarketProfitLoss] FROM [dbo].[QH_TodayTradeTable] "); sb.AppendFormat(" where TradeNumber in(select TradeNumber from dbo.QH_PushBackOrderTable where channelID='{0}') ", channleID); sb.Append(" union all "); sb.Append(" SELECT [TradeNumber],[EntrustNumber],[PortfolioLogo],[TradePrice],[EntrustPrice],[TradeAmount] "); sb.Append(" ,[TradeProceduresFee],[Margin],[ContractCode],[TradeAccount],[CapitalAccount],[BuySellTypeId] "); sb.Append(" ,[OpenCloseTypeId],[TradeUnitId],[TradeTypeId],[CurrencyTypeId],[TradeTime],[MarketProfitLoss] from QH_HistoryTradeTable "); sb.AppendFormat(" where TradeNumber in( select TradeNumber from dbo.QH_PushBackOrderTable where channelID='{0}') ", channleID); QH_TodayTradeTableDal dal = new QH_TodayTradeTableDal(); CommonDALOperate <QH_TodayTradeTableInfo> com = new CommonDALOperate <QH_TodayTradeTableInfo>(); return(com.ExecuterReaderDataBind(sb.ToString(), dal.ReaderBind)); }
/// <summary> /// 根据通道号返回当日成交数据,这里包括清算后移动到历史表中还是当日的数据 /// </summary> /// <param name="channleID">通道号</param> /// <returns></returns> public List <HK_TodayTradeInfo> GetTodayTradeListByChannleID(string channleID) { StringBuilder sb = new StringBuilder(""); sb.Append(" SELECT [TradeNumber],[PortfolioLogo],[EntrustNumber],[TradePrice],[TradeAmount]"); sb.Append(" ,[EntrustPrice],[StampTax],[Commission],[TransferAccountFee],[TradeProceduresFee],[MonitoringFee] "); sb.Append(" ,[TradingSystemUseFee],[TradeCapitalAmount],[ClearingFee],[HoldAccount],[CapitalAccount]"); sb.Append(" ,[Code],[TradeTypeId],[TradeUnitId],[BuySellTypeId],[CurrencyTypeId],[TradeTime] "); sb.Append(" from HK_TodayTrade "); sb.AppendFormat(" where TradeNumber in(select TradeNumber from dbo.HK_PushBackOrder where channelID='{0}')", channleID); sb.Append(" union all"); sb.Append(" SELECT [TradeNumber],[PortfolioLogo],[EntrustNumber],[TradePrice],[TradeAmount]"); sb.Append(" ,[EntrustPrice],[StampTax],[Commission],[TransferAccountFee],[TradeProceduresFee],[MonitoringFee]"); sb.Append(" ,[TradingSystemUseFee],[TradeCapitalAmount]=0.00,[ClearingFee],[HoldAccount],[CapitalAccount]"); sb.Append(" ,[Code],[TradeTypeId],[TradeUnitId],[BuySellTypeId],[CurrencyTypeId],[TradeTime] "); sb.Append(" from HK_HistoryTrade "); sb.AppendFormat(" where TradeNumber in(select TradeNumber from dbo.HK_PushBackOrder where channelID='{0}')", channleID); HK_TodayTradeDal dal = new HK_TodayTradeDal(); CommonDALOperate <HK_TodayTradeInfo> com = new CommonDALOperate <HK_TodayTradeInfo>(); return(com.ExecuterReaderDataBind(sb.ToString(), dal.ReaderBind)); }