/// <summary> /// /// </summary> /// <param name="InvestorID"></param> /// <returns></returns> internal List<Business.InvestorAccountLog> GetInvestorAccountLogByInvestorID(int InvestorID) { List<Business.InvestorAccountLog> Result = new List<Business.InvestorAccountLog>(); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection); DSTableAdapters.InvestorAccountLogTableAdapter adap = new DSTableAdapters.InvestorAccountLogTableAdapter(); DS.InvestorAccountLogDataTable tbInvestorAccountLog = new DS.InvestorAccountLogDataTable(); try { conn.Open(); adap.Connection = conn; tbInvestorAccountLog = adap.GetInvestorAccountLogByInvestorID(InvestorID); if (tbInvestorAccountLog != null) { int count = tbInvestorAccountLog.Count; for (int i = 0; i < count; i++) { Business.InvestorAccountLog newInvestorAccountLog = new Business.InvestorAccountLog(); newInvestorAccountLog.Amount = tbInvestorAccountLog[i].Amount; newInvestorAccountLog.Comment = tbInvestorAccountLog[i].Comment; newInvestorAccountLog.Date = tbInvestorAccountLog[i].Date; newInvestorAccountLog.DealID = tbInvestorAccountLog[i].DealID; newInvestorAccountLog.ID = tbInvestorAccountLog[i].ID; newInvestorAccountLog.InvestorID = tbInvestorAccountLog[i].InvestorID; newInvestorAccountLog.Name = tbInvestorAccountLog[i].Name; Result.Add(newInvestorAccountLog); } } } catch (Exception ex) { return null; } finally { adap.Connection.Close(); conn.Close(); } return Result; }
/// <summary> /// /// </summary> /// <param name="InvestorID"></param> /// <param name="Start"></param> /// <param name="Limit"></param> /// <returns></returns> internal List<Business.OrderData> GetOrderByInvestorID(int InvestorID, int Start, int Limit) { List<Business.OrderData> Result = new List<Business.OrderData>(); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection); DSTableAdapters.InvestorTableAdapter adapInvestor = new DSTableAdapters.InvestorTableAdapter(); DSTableAdapters.OnlineCommandTableAdapter adapOpenTrade = new DSTableAdapters.OnlineCommandTableAdapter(); DSTableAdapters.CommandHistoryTableAdapter adapHistory = new DSTableAdapters.CommandHistoryTableAdapter(); DSTableAdapters.InvestorAccountLogTableAdapter adapAccountLog = new DSTableAdapters.InvestorAccountLogTableAdapter(); DS.InvestorDataTable tbInvestor = new DS.InvestorDataTable(); DS.OnlineCommandDataTable tbOnlineCommand = new DS.OnlineCommandDataTable(); DS.CommandHistoryDataTable tbCommandHistory = new DS.CommandHistoryDataTable(); DS.InvestorAccountLogDataTable tbInvestorAccountLog = new DS.InvestorAccountLogDataTable(); try { conn.Open(); adapInvestor.Connection = conn; adapOpenTrade.Connection = conn; adapHistory.Connection = conn; adapAccountLog.Connection = conn; tbOnlineCommand = adapOpenTrade.GetOpenTradeByInvestorID(Start, InvestorID, Limit); tbCommandHistory = adapHistory.GetHistoryByInvestorID(Start, InvestorID, Limit); tbInvestorAccountLog = adapAccountLog.GetInvestorLogByInvestorID(Start, InvestorID, Limit); if (tbOnlineCommand != null) { int count = tbOnlineCommand.Count; for (int i = 0; i < count; i++) { Business.OrderData newOrderData = new Business.OrderData(); newOrderData.OrderCode = "OPT001"; newOrderData.Code = tbOnlineCommand[i].CommandCode; newOrderData.ID = tbOnlineCommand[i].OnlineCommandID; tbInvestor = adapInvestor.GetInvestorNameByInvestorID(tbOnlineCommand[i].InvestorID); if (tbInvestor != null) newOrderData.Login = tbInvestor[0].Code; newOrderData.InvestorID = tbOnlineCommand[i].InvestorID; newOrderData.AgentCommission = 0; newOrderData.ClosePrice = tbOnlineCommand[i].ClosePrice; newOrderData.CloseTime = tbOnlineCommand[i].CloseTime; //newOrderData.Comment = tbOnlineCommand[i] newOrderData.Commission = tbOnlineCommand[i].Commission; newOrderData.ExpDate = tbOnlineCommand[i].ExpTime; newOrderData.Lots = tbOnlineCommand[i].Size; //newOrderData.MarginRate = //newOrderData.OneConvRate newOrderData.OpenPrice = tbOnlineCommand[i].OpenPrice; newOrderData.OpenTime = tbOnlineCommand[i].OpenTime; newOrderData.Profit = tbOnlineCommand[i].Profit; newOrderData.StopLoss = tbOnlineCommand[i].StopLoss; newOrderData.Swaps = tbOnlineCommand[i].Swap; newOrderData.Symbol = TradingServer.Facade.FacadeGetSymbolNameBySymbolID(tbOnlineCommand[i].SymbolID); newOrderData.TakeProfit = tbOnlineCommand[i].TakeProfit; newOrderData.Taxes = tbOnlineCommand[i].Taxes; //newOrderData.TwoConvRate newOrderData.Type = TradingServer.Facade.FacadeGetTypeNameByTypeID(tbOnlineCommand[i].CommandTypeID); //newOrderData.ValueDate Result.Add(newOrderData); } } if (tbCommandHistory != null) { int count = tbCommandHistory.Count; for (int i = 0; i < count; i++) { Business.OrderData newOrderData = new Business.OrderData(); newOrderData.OrderCode = "CMH01"; newOrderData.Code = tbCommandHistory[i].CommandCode; newOrderData.ID = tbCommandHistory[i].CommandHistoryID; tbInvestor = adapInvestor.GetInvestorNameByInvestorID(tbCommandHistory[i].InvestorID); if (tbInvestor != null) newOrderData.Login = tbInvestor[0].Code; newOrderData.InvestorID = tbCommandHistory[i].InvestorID; newOrderData.AgentCommission = 0; newOrderData.ClosePrice = tbCommandHistory[i].ClosePrice; newOrderData.CloseTime = tbCommandHistory[i].CloseTime; //newOrderData.Code = tbOnlineCommand[i].inves //newOrderData.Comment = tbOnlineCommand[i] newOrderData.Commission = tbCommandHistory[i].Commission; newOrderData.ExpDate = tbCommandHistory[i].ExpTime; newOrderData.Lots = tbCommandHistory[i].Size; //newOrderData.MarginRate = //newOrderData.OneConvRate newOrderData.OpenPrice = tbCommandHistory[i].OpenPrice; newOrderData.OpenTime = tbCommandHistory[i].OpenTime; newOrderData.Profit = tbCommandHistory[i].Profit; newOrderData.StopLoss = tbCommandHistory[i].StopLoss; newOrderData.Swaps = tbCommandHistory[i].Swap; newOrderData.Symbol = TradingServer.Facade.FacadeGetSymbolNameBySymbolID(tbCommandHistory[i].SymbolID); newOrderData.TakeProfit = tbCommandHistory[i].TakeProfit; newOrderData.Taxes = tbCommandHistory[i].Taxes; //newOrderData.TwoConvRate switch (tbCommandHistory[i].CommandTypeID) { case 13: { newOrderData.Type = "ADP01"; } break; case 14: { newOrderData.Type = "WRD01"; } break; case 15: { newOrderData.Type = "ACD01"; } break; case 16: { newOrderData.Type = "CRD01"; } break; default: { newOrderData.Type = TradingServer.Facade.FacadeGetTypeNameByTypeID(tbCommandHistory[i].CommandTypeID); } break; } //newOrderData.Type = TradingServer.Facade.FacadeGetTypeNameByTypeID(tbCommandHistory[i].CommandTypeID); //newOrderData.ValueDate Result.Add(newOrderData); } } if (tbInvestorAccountLog != null) { int count = tbInvestorAccountLog.Count; for (int i = 0; i < count; i++) { Business.OrderData newOrderData = new Business.OrderData(); newOrderData.OrderCode = "IAL01"; newOrderData.Code = tbInvestorAccountLog[i].DealID; newOrderData.ID = tbInvestorAccountLog[i].ID; tbInvestor = adapInvestor.GetInvestorNameByInvestorID(tbInvestorAccountLog[i].InvestorID); if (tbInvestor != null) newOrderData.Login = tbInvestor[0].Code; newOrderData.InvestorID = tbInvestorAccountLog[i].InvestorID; //newOrderData.AgentCommission = 0; //newOrderData.ClosePrice = tbCommandHistory[i].ClosePrice; //newOrderData.CloseTime = tbCommandHistory[i].CloseTime; //newOrderData.Code = tbOnlineCommand[i].inves //newOrderData.Comment = tbOnlineCommand[i] //newOrderData.Commission = tbCommandHistory[i].Commission; //newOrderData.ExpDate = tbCommandHistory[i].ExpTime; //newOrderData.Lots = tbCommandHistory[i].Size; //newOrderData.MarginRate = //newOrderData.OneConvRate //newOrderData.OpenPrice = tbCommandHistory[i].OpenPrice; newOrderData.OpenTime = tbInvestorAccountLog[i].Date; //newOrderData.Profit = tbCommandHistory[i].Profit; //newOrderData.StopLoss = tbCommandHistory[i].StopLoss; //newOrderData.Swaps = tbCommandHistory[i].Swap; //newOrderData.Symbol = TradingServer.Facade.FacadeGetSymbolNameBySymbolID(tbCommandHistory[i].SymbolID); //newOrderData.TakeProfit = tbCommandHistory[i].TakeProfit; //newOrderData.Taxes = tbCommandHistory[i].Taxes; //newOrderData.TwoConvRate newOrderData.Type = tbInvestorAccountLog[i].Code; newOrderData.Comment = tbInvestorAccountLog[i].Comment; newOrderData.Profit = tbInvestorAccountLog[i].Amount; //newOrderData.ValueDate Result.Add(newOrderData); } } } catch (Exception ex) { return null; } finally { adapInvestor.Connection.Close(); adapOpenTrade.Connection.Close(); adapHistory.Connection.Close(); adapAccountLog.Connection.Close(); conn.Close(); } return Result; }
/// <summary> /// /// </summary> /// <param name="Code"></param> /// <returns></returns> internal Business.OrderData GetOrderByCode(string Code) { Business.OrderData Result = new Business.OrderData(); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection); DSTableAdapters.OnlineCommandTableAdapter adapOnlineCommand = new DSTableAdapters.OnlineCommandTableAdapter(); DSTableAdapters.CommandHistoryTableAdapter adapCommandHistory = new DSTableAdapters.CommandHistoryTableAdapter(); DSTableAdapters.InvestorAccountLogTableAdapter adapAccountLog = new DSTableAdapters.InvestorAccountLogTableAdapter(); DSTableAdapters.InvestorTableAdapter adapInvestor = new DSTableAdapters.InvestorTableAdapter(); DS.OnlineCommandDataTable tbOnlineCommand = new DS.OnlineCommandDataTable(); DS.CommandHistoryDataTable tbCommandHistory = new DS.CommandHistoryDataTable(); DS.InvestorAccountLogDataTable tbAccountLog = new DS.InvestorAccountLogDataTable(); DS.InvestorDataTable tbInvestor = new DS.InvestorDataTable(); try { bool flag = false; conn.Open(); adapAccountLog.Connection = conn; adapCommandHistory.Connection = conn; adapOnlineCommand.Connection = conn; adapInvestor.Connection = conn; tbOnlineCommand = adapOnlineCommand.GetOnlineCommandByCommandCode(Code); if (tbOnlineCommand != null && tbOnlineCommand.Count > 0) { Result.OrderCode = "OPT001"; Result.Code = tbOnlineCommand[0].CommandCode; tbInvestor = adapInvestor.GetInvestorNameByInvestorID(tbOnlineCommand[0].InvestorID); if (tbInvestor != null) Result.Login = tbInvestor[0].Code; Result.InvestorID = tbOnlineCommand[0].InvestorID; Result.AgentCommission = 0; Result.ClosePrice = tbOnlineCommand[0].ClosePrice; Result.CloseTime = tbOnlineCommand[0].CloseTime; //newOrderData.Comment = tbOnlineCommand[i] Result.Commission = tbOnlineCommand[0].Commission; Result.ExpDate = tbOnlineCommand[0].ExpTime; Result.Lots = tbOnlineCommand[0].Size; //newOrderData.MarginRate = //newOrderData.OneConvRate Result.OpenPrice = tbOnlineCommand[0].OpenPrice; Result.OpenTime = tbOnlineCommand[0].OpenTime; Result.Profit = tbOnlineCommand[0].Profit; Result.StopLoss = tbOnlineCommand[0].StopLoss; Result.Swaps = tbOnlineCommand[0].Swap; Result.Symbol = TradingServer.Facade.FacadeGetSymbolNameBySymbolID(tbOnlineCommand[0].SymbolID); Result.TakeProfit = tbOnlineCommand[0].TakeProfit; Result.Taxes = tbOnlineCommand[0].Taxes; //newOrderData.TwoConvRate Result.Type = TradingServer.Facade.FacadeGetTypeNameByTypeID(tbOnlineCommand[0].CommandTypeID); //newOrderData.ValueDate flag = true; } if (!flag) { tbCommandHistory = adapCommandHistory.GetCommandHistoryByCommandCode(Code); if (tbCommandHistory != null && tbCommandHistory.Count > 0) { Result.OrderCode = "CMH01"; Result.Code = tbCommandHistory[0].CommandCode; tbInvestor = adapInvestor.GetInvestorNameByInvestorID(tbCommandHistory[0].InvestorID); if (tbInvestor != null) Result.Login = tbInvestor[0].Code; Result.InvestorID = tbCommandHistory[0].InvestorID; Result.AgentCommission = 0; Result.ClosePrice = tbCommandHistory[0].ClosePrice; Result.CloseTime = tbCommandHistory[0].CloseTime; //newOrderData.Code = tbOnlineCommand[i].inves //newOrderData.Comment = tbOnlineCommand[i] Result.Commission = tbCommandHistory[0].Commission; Result.ExpDate = tbCommandHistory[0].ExpTime; Result.Lots = tbCommandHistory[0].Size; //newOrderData.MarginRate = //newOrderData.OneConvRate Result.OpenPrice = tbCommandHistory[0].OpenPrice; Result.OpenTime = tbCommandHistory[0].OpenTime; Result.Profit = tbCommandHistory[0].Profit; Result.StopLoss = tbCommandHistory[0].StopLoss; Result.Swaps = tbCommandHistory[0].Swap; Result.Symbol = TradingServer.Facade.FacadeGetSymbolNameBySymbolID(tbCommandHistory[0].SymbolID); Result.TakeProfit = tbCommandHistory[0].TakeProfit; Result.Taxes = tbCommandHistory[0].Taxes; //newOrderData.TwoConvRate Result.Type = TradingServer.Facade.FacadeGetTypeNameByTypeID(tbCommandHistory[0].CommandTypeID); //newOrderData.ValueDate flag = true; } } if (!flag) { tbAccountLog = adapAccountLog.GetInvestorAccountLogByCode(Code); if (tbAccountLog != null && tbAccountLog.Count > 0) { Result.OrderCode = "IAL01"; Result.Code = tbAccountLog[0].DealID; tbInvestor = adapInvestor.GetInvestorNameByInvestorID(tbAccountLog[0].InvestorID); if (tbInvestor != null) Result.Login = tbInvestor[0].Code; Result.InvestorID = tbAccountLog[0].InvestorID; //newOrderData.AgentCommission = 0; //newOrderData.ClosePrice = tbCommandHistory[i].ClosePrice; //newOrderData.CloseTime = tbCommandHistory[i].CloseTime; //newOrderData.Code = tbOnlineCommand[i].inves //newOrderData.Comment = tbOnlineCommand[i] //newOrderData.Commission = tbCommandHistory[i].Commission; //newOrderData.ExpDate = tbCommandHistory[i].ExpTime; //newOrderData.Lots = tbCommandHistory[i].Size; //newOrderData.MarginRate = //newOrderData.OneConvRate //newOrderData.OpenPrice = tbCommandHistory[i].OpenPrice; Result.OpenTime = tbAccountLog[0].Date; //newOrderData.Profit = tbCommandHistory[i].Profit; //newOrderData.StopLoss = tbCommandHistory[i].StopLoss; //newOrderData.Swaps = tbCommandHistory[i].Swap; //newOrderData.Symbol = TradingServer.Facade.FacadeGetSymbolNameBySymbolID(tbCommandHistory[i].SymbolID); //newOrderData.TakeProfit = tbCommandHistory[i].TakeProfit; //newOrderData.Taxes = tbCommandHistory[i].Taxes; //newOrderData.TwoConvRate Result.Type = tbAccountLog[0].Code; Result.Comment = tbAccountLog[0].Comment; Result.Profit = tbAccountLog[0].Amount; } } } catch (Exception ex) { return null; } finally { adapAccountLog.Connection.Close(); adapCommandHistory.Connection.Close(); adapInvestor.Connection.Close(); adapOnlineCommand.Connection.Close(); conn.Close(); } return Result; }