/// <summary> /// 获取所有合约手续费相关信息 /// </summary> /// <returns></returns> private static List <ExchFareEntity> GetDbExchFares() { using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { return(conn.Query <ExchFareEntity>("SELECT * FROM ExchFare;").AsList()); } }
/// <summary> /// 获取所有品种行业信息 /// </summary> /// <returns></returns> private static List <VarietyIndustryEntity> GetDbVeriIndList() { using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { return(conn.Query <VarietyIndustryEntity>("select * from VarietyIndustry;").AsList()); } }
/// <summary> /// 获取品种排序值 /// </summary> /// <returns></returns> private static List <VariSort> GetVariSortList() { using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { return(conn.Query <VariSort>("select * from VarietySort").AsList()); } }
private static List <HolidaysDateEntity> GetDbHolidays() { using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { return(conn.Query <HolidaysDateEntity>("select * from HolidaysDate").AsList()); } }
/// <summary> /// 获取所有行业分类信息 /// </summary> /// <returns></returns> private static List <IndustryCatgEntity> GetDbIndCatgList() { using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { return(conn.Query <IndustryCatgEntity>("select * from IndustryCatg;").AsList()); } }
private static List <FilterWordEntity> GetDbFilterWords() { using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFUser)) { return(conn.Query <FilterWordEntity>("select * from [FilterWord]").AsList()); } }
private static List <IndexOpenTimeEntity> GetDbIndexOpenTime() { using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { return(conn.Query <IndexOpenTimeEntity>("select * from IndexOpenTime").ToList()); } }
/// <summary> /// 获取所有合约手续费相关信息 /// </summary> /// <returns></returns> private static List <ExchBailEntity> GetDbExchBails() { using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { return(conn.Query <ExchBailEntity>("select * from ExchBail;").AsList()); } }
private static List <HisSpotDayKline> GetFromDB(long spotId, DateTime startData, DateTime endDate) { using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { var sql = "select spotId,highPx,lowPx,lastPx,PreClosePx,vol,tradeDate from SpotHisPrice where spotId=@spotId and tradeDate>=@tradeDate and tradeDate<=@endDate order by tradeDate desc"; return(conn.Query <HisSpotDayKline>(sql, new { spotId = spotId, tradeDate = startData, endDate }).ToList()); } }
public static bool UpdateIndexComponent(List <IndexComponentDetail> details) { using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { var sql = "update IndexComponent set Point=@Point,InitialValue=@InitialValue where IndustryContractId=@IndustryContractId and VarietiesContractId=@VarietiesContractId"; return(conn.Execute(sql, details) > 0); } }
public static bool AddHisDatas(List <HisSpotFuturesPriceEntity> entities) { using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { var sql = "insert into hisSpotFuturesPrice(VarietyCode,VarietyName,SpotPrice,LastFutureSymbol,LastFuturePrice,MainFutureSymbol,MainFuturePrice,HqTime) " + "values (@VarietyCode,@VarietyName,@SpotPrice,@LastFutureSymbol,@LastFuturePrice,@MainFutureSymbol,@MainFuturePrice,@HqTime);"; return(conn.Execute(sql, entities) > 0); } }
/// <summary> /// 获取现货历史价格 /// </summary> /// <param name="tradeDate">交易日</param> /// <returns></returns> public static List <SpotHisPriceEntity> Get(DateTime tradeDate) { string sql = "select * from SpotHisPrice where tradeDate =@tradeDate"; using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { return(conn.Query <SpotHisPriceEntity>(sql, new { tradeDate }).AsList()); } }
private static List <ContractDetail> GetDbVirtualContracts() { lastReadDbTime = DateTime.Now; using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { //过滤掉垃圾数据 return(conn.Query <ContractDetail>("select * from VirtualContract ;").AsList()); } }
/// <summary> /// 获取所有品种信息 开盘时间 /// </summary> /// <returns></returns> private static Dictionary <long, List <VarietyOpenTimeEntity> > GetDbVarietyOpenTimes() { using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { var all = conn.Query <VarietyOpenTimeEntity>("select * from VarietyOpenTime;").AsList(); return(all.GroupBy(g => g.VID).ToDictionary(k => k.Key, v => v.ToList())); } }
/// <summary> /// 获取所有合约信息 /// </summary> /// <returns></returns> private static List <ContractEntity> GetDbContracts() { lastReadDbTime = DateTime.Now; using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { //过滤掉垃圾数据 return(conn.Query <ContractEntity>("select * from Contract t where t.VarietyID > 0;").AsList()); } }
internal static bool CheckPwd(string mobile, string pwd) { var sql = @"select count(*) from [DB_IQFUser].[dbo].[User] t where t.Mobile = @mobile and t.Password = @pwd;"; using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFUser)) { var count = conn.Query <int>(sql, new { mobile = mobile, pwd = pwd }).FirstOrDefault(); return(count > 0); } }
private static UserModel GetUserByMobile(string mobile) { var sql = @"select * from [DB_IQFUser].[dbo].[User] t where t.Mobile = @mobile"; using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFUser)) { var all = conn.Query <UserModel>(sql, new { mobile = mobile }).FirstOrDefault(); return(all); } }
private static List <SpotContractDetail> GetFromDB() { string sql = "select * from SpotContract"; using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { var datas = conn.Query <SpotContractEntity>(sql).AsList(); return(ConvertSpot(datas)); } }
public static int AddOrSet(SpotHisPriceEntity data) { if (data == null) { return(0); } string sql = "update SpotHisPrice set HighPx=@HighPx,OpenPx=@OpenPx,LowPx=@LowPx,LastPx=@LastPx,PreClosePx=@PreClosePx,Vol=@Vol,UpdateTime=getdate() where @SpotID=SpotID and TradeDate=@TradeDate IF @@ROWCOUNT=0 begin insert into SpotHisPrice(SpotID,HighPx,OpenPx,LowPx,LastPx,PreClosePx,Vol,TradeDate) values(@SpotID,@HighPx,@OpenPx,@LowPx,@LastPx,@PreClosePx,@Vol,@TradeDate) end"; using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { return(conn.Execute(sql, data)); } }
public static int Add(List <SpotHisPriceEntity> data) { if (data == null) { return(0); } string sql = "insert into SpotHisPrice(SpotID,HighPx,OpenPx,LowPx,LastPx,PreClosePx,Vol,TradeDate) values(@SpotID,@HighPx,@OpenPx,@LowPx,@LastPx,@PreClosePx,@Vol,@TradeDate)"; using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { return(conn.Execute(sql, data)); } }
/// <summary> /// Creates new connection /// </summary> /// <param name="streamId">Local reference id of the stream</param> /// <param name="remoteId">Remote reference of link</param> /// <param name="proxy">The proxy server</param> /// <param name="encoding">The encoding to use</param> /// <returns></returns> public Task <IConnection> CreateConnectionAsync(Reference streamId, Reference remoteId, INameRecord proxy, CodecId encoding) { var uri = new UriBuilder(_uri) { Scheme = _secure ? "wss" : "ws", Path = streamId.ToString() }; var connection = new WebSocketConnection(this, streamId, remoteId, encoding, ConnectionString.Create(uri.Uri, "proxy", "secret")); _connectionMap.AddOrUpdate(streamId, connection, (r, s) => connection); return(Task.FromResult((IConnection)connection)); }
private static List <SpotContractDetail> GetSoptByExchangeFormDb(Exchange exchange) { var sql = @"SELECT [SpotID] ,[SpotCode] ,[SpotName] ,[VarietyID] FROM [DB_IQFData].[dbo].[SpotContract] t where t.VarietyID in (SELECT [ID] FROM [DB_IQFData].[dbo].[Variety] where EID=@exchange)" ; using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFData)) { var datas = conn.Query <SpotContractEntity>(sql).AsList(); return(ConvertSpot(datas)); } }
/// <summary> /// 从数据库获取 /// </summary> /// <param name="userID"></param> /// <returns></returns> private static UserModel GetByID(long userID) { var sql = @"select * from [DB_IQFUser].[dbo].[User] t where t.UserID = @userID;"; using (var conn = ConnectionString.Create(Framework.Dao.DatabaseName.DB_IQFUser)) { var model = conn.Query <UserModel>(sql, new { userID = userID }).FirstOrDefault(); if (model == null) { return(null); } model.Mobile = DecryptMobile(model.Mobile); return(model); } }
/// <summary> /// Creates connection /// </summary> /// <param name="streamId">Local reference id of the stream</param> /// <param name="remoteId">Remote reference of link</param> /// <param name="proxy">The proxy server</param> /// <param name="encoding">The encoding to use</param> /// <returns>Created connection</returns> public async Task <IConnection> CreateConnectionAsync(Reference streamId, Reference remoteId, INameRecord proxy, CodecId encoding) { var uri = new UriBuilder(_uri); uri.Scheme = "http"; var token = await _tokenProvider.GetTokenAsync(uri.ToString(), TimeSpan.FromHours(24)).ConfigureAwait(false); var cs = ConnectionString.Create(_uri.DnsSafeHost, _uri.AbsolutePath.TrimStart('/'), "proxy", token.TokenString, false); var connection = new ServiceBusRelayConnection(this, streamId, remoteId, encoding, cs); _connectionMap.AddOrUpdate(streamId, connection, (r, s) => connection); return(connection); }
public override IObjectContainer CreateObjectContext( string entityConnectionString, string entityContainerName, string userId = null, string password = null, string server = null, string sid = null) { var entityConnection = new EntityConnection(entityConnectionString); entityConnection.StoreConnection.ConnectionString += ConnectionString.Create( userId, password, server, sid: sid); return (InvokeObjectContainerConstructor <IObjectContainer>( new ObjectContextWrapper(entityConnection, entityContainerName))); }