public bool AddLoginInfo(LoginLogEntity logEntity, string openMoblie, TradeAccountSource source, out string error)
{
error = string.Empty;
if (logEntity == null)
{
error = "参数为null";
return(false);
}
using (var conn = factory.Create(DatabaseName.DB_IQFTrade))
{
var list = conn.Query("proc_Login_Add", new { userID = logEntity.UserID, brokerAccount = logEntity.BrokerAccount, brokerType = logEntity.BrokerType, accountType = logEntity.AccountType, IP = logEntity.IP, Mac = logEntity.Mac, packType = logEntity.PackType, clientVersion = logEntity.ClientVersion, status = logEntity.Status, errorNo = logEntity.ErrorNo, errorMsg = logEntity.ErrorMsg, openAcctMobile = openMoblie, source = source }, null, true, null, System.Data.CommandType.StoredProcedure).FirstOrDefault();
var ret = list as IDictionary <string, object>;
if (ret == null || ret.Count != 2)
{
error = "插入登录数据失败";
return(false);
}
var errorNo = (int)ret.Values.First();
if (errorNo != 0)
{
error = ret.Values.ElementAt(1).ToString();
return(false);
}
return(true);
}
}
/// <summary>
/// 更新服务信息
/// </summary>
/// <param name="brokerType"></param>
/// <param name="serverIP"></param>
/// <param name="serverPort"></param>
/// <param name="userCount"></param>
public void Update(int brokerType, string serverIP, int serverPort, int userCount, int procId, int tradingCounter)
{
using (var conn = factory.Create(DatabaseName.DB_IQFTrade))
{
var count = conn.Execute("proc_ServiceInfo_Update", new { brokerType, serverIP, serverPort, userCount, procId, tradingCounter }, null, null, System.Data.CommandType.StoredProcedure);
}
}
public List <ApiInfoEntity> GetAllFromDB()
{
string sql = "SELECT * FROM [ApiInfo];";
using (var conn = factory.Create(DatabaseName.DB_IQFTrade))
{
return(conn.Query <ApiInfoEntity>(sql).AsList());
}
}
public List <OrderConfigEntity> Get(int brokerType, string brokerAccount)
{
string sql = "SELECT * FROM [DB_IQFTrade].[dbo].[OrderConfig] where [BrokerType] =@brokerType and [BrokerAccount] =@brokerAccount;";
using (var conn = factory.Create(DatabaseName.DB_IQFTrade))
{
return(conn.Query <OrderConfigEntity>(sql, new { brokerType, brokerAccount }).AsList());
}
}
/// <summary>
/// 获取用户设置的登录有效时间（分钟）
/// </summary>
/// <param name="brokerAccount"></param>
/// <param name="brokerType"></param>
/// <returns>有效时间（分钟）</returns>
public int GetLoginAvailableTime(string brokerAccount, BrokerType brokerType)
{
using (var conn = factory.Create(DatabaseName.DB_IQFTrade))
{
using (var reader = conn.QueryMultiple("proc_LoginLength_Get", new { brokerAccount, brokerType }, null, null, CommandType.StoredProcedure))
{
return(reader.Read <int>().FirstOrDefault());
}
}
}
public List <AccountBindingView> GetDetail(long userID)
{
string sql = "SELECT a.*,t.BrokerType,t.BrokerAccount,t.CompCounter FROM [AccountBinding] a inner join [TradeAccount] t on a.TradeAccount=t.TradeAccountID where UserID =@userID order by Sequence;";
using (var conn = factory.Create(DatabaseName.DB_IQFTrade))
{
return(conn.Query <AccountBindingView>(sql, new { userID = userID }).AsList());
}
}
public int Add(OrderLogEntity entity)
{
if (null == entity)
{
return(0);
}
string insert = "INSERT INTO [OrderLog] ([UserID], [BrokerAccount], [BrokerType], [Symbol], [Exchange], [OrderSide], [Price], [Quantity], [OrderType], [Offset], [Source], [OderID],[BizType], [ErrorNo], [ErrorMsg], [IP], [Mac], [PackType], [TradeDate]) VALUES (@UserID, @BrokerAccount, @BrokerType, @Symbol, @Exchange, @OrderSide, @Price, @Quantity, @OrderType, @Offset, @Source, @OderID, @BizType, @ErrorNo, @ErrorMsg, @IP ,@Mac ,@PackType ,@TradeDate)";
using (var conn = factory.Create(DatabaseName.DB_IQFTrade))
{
return(conn.Execute(insert, entity));
}
}
public int Add(LoginLogEntity entity)
{
if (null == entity)
{
return(0);
}
string insert = "INSERT INTO [LoginLog] ([UserID],[BrokerAccount],[BrokerType],[AccountType],[IP],[Mac],[PackType],[ClientVersion],[Status],[ErrorNo],[ErrorMsg]) VALUES (@UserID, @BrokerAccount, @BrokerType, @AccountType, @IP, @Mac, @PackType, @ClientVersion,@Status,@ErrorNo,@ErrorMsg)";
using (var conn = factory.Create(DatabaseName.DB_IQFTrade))
{
return(conn.Execute(insert, entity));
}
}
/// <summary>
/// 根据期货代码获取公司信息
/// </summary>
/// <param name="fcCode">公司代码</param>
/// <returns></returns>
public IFuturesCompany GetByFcCode(string fcCode)
{
using (var conn = factory.Create(DatabaseName.DB_IQFTrade))
{
var ay = SqlMapper.Query <IFuturesCompany>(conn, "select * from FuturesCompany where fcCode=@fcCode",
new { fcCode = fcCode }).ToList();
if (ay.Count == 0)
{
return(null);
}
else
{
return(ay[0]);
}
}
}
/// <summary>
/// 获取代理
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public AgentEntity GetDBAgent(long userID)
{
using (var conn = factory.Create(DatabaseName.DB_IQFTrade))
{
var sql = string.Format(@"select TOP 1 * from dbo.Agent t where t.UserID = {0};", userID);
return(conn.Query <AgentEntity>(sql).FirstOrDefault());
}
}
public virtual List <CompCounterEntity> GetAll()
{
string sql = "SELECT * FROM [CompCounter];";
using (var conn = factory.Create(DatabaseName.DB_IQFTrade))
{
return(conn.Query <CompCounterEntity>(sql).AsList());
}
}
public virtual List <GateWayInfoEntity> GetAll()
{
string sql = "SELECT * FROM [GatewayInfo];";
using (var conn = factory.Create(DatabaseName.DB_IQFTrade))
{
return(conn.Query <GateWayInfoEntity>(sql).AsList());
}
}
