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