/// <summary> /// /// </summary> /// <param name="MarketConfigID"></param> /// <returns></returns> internal Business.ParameterItem GetMarketConfigByMarketConfigID(int MarketConfigID) { Business.ParameterItem Result = new Business.ParameterItem(); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection); DSTableAdapters.MarketConfigTableAdapter adap = new DSTableAdapters.MarketConfigTableAdapter(); DS.MarketConfigDataTable tbMarketConfig = new DS.MarketConfigDataTable(); try { conn.Open(); adap.Connection = conn; tbMarketConfig = adap.GetMarketConfigByMarketConfigID(MarketConfigID); if (tbMarketConfig != null) { Result.ParameterItemID = tbMarketConfig[0].MarketConfigID; Result.Name = tbMarketConfig[0].Name; Result.Code = tbMarketConfig[0].Code; Result.BoolValue = tbMarketConfig[0].BoolValue; Result.StringValue = tbMarketConfig[0].StringValue; Result.NumValue = tbMarketConfig[0].NumValue; Result.DateValue = tbMarketConfig[0].DateValue; } } catch (Exception ex) { return null; } finally { adap.Connection.Close(); conn.Close(); } return Result; }
/// <summary> /// /// </summary> /// <returns></returns> internal List<Business.ParameterItem> GetAllMarketConfig() { List<Business.ParameterItem> Result = new List<Business.ParameterItem>(); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection); DSTableAdapters.MarketConfigTableAdapter adap = new DSTableAdapters.MarketConfigTableAdapter(); DS.MarketConfigDataTable tbMarketConfig = new DS.MarketConfigDataTable(); try { conn.Open(); adap.Connection = conn; tbMarketConfig = adap.GetData(); if (tbMarketConfig != null) { int count = tbMarketConfig.Count; for (int i = 0; i < count; i++) { if (tbMarketConfig[i].Code == "C36") { if (tbMarketConfig[i].BoolValue == 1) Business.Market.IsConnectMT4 = true; else Business.Market.IsConnectMT4 = false; } if (tbMarketConfig[i].Code == "C44") Business.Market.ScalperTimeValue = int.Parse(tbMarketConfig[i].NumValue); if (tbMarketConfig[i].Code == "C45") Business.Market.ScalperPipValue = int.Parse(tbMarketConfig[i].NumValue); if (tbMarketConfig[i].Code == "C36") Business.Market.CompanyWebsite = tbMarketConfig[i].StringValue; if (tbMarketConfig[i].Code == "C37") Business.Market.AccessLink = tbMarketConfig[i].StringValue; if (tbMarketConfig[i].Code == "C38") Business.Market.ServiceName = tbMarketConfig[i].StringValue; if (tbMarketConfig[i].Code == "C39") Business.Market.MailSupport = tbMarketConfig[i].StringValue; if (tbMarketConfig[i].Code == "C40") Business.Market.MailContact = tbMarketConfig[i].StringValue; if (tbMarketConfig[i].Code == "C41") Business.Market.CompanyName = tbMarketConfig[i].StringValue; if (tbMarketConfig[i].Code == "C42") Business.Market.About = tbMarketConfig[i].StringValue; if (tbMarketConfig[i].Code == "C43") Business.Market.CompanyCopyright = tbMarketConfig[i].StringValue; Business.ParameterItem newParameterItem = new Business.ParameterItem(); newParameterItem.ParameterItemID = tbMarketConfig[i].MarketConfigID; newParameterItem.Name = tbMarketConfig[i].Name; newParameterItem.Code = tbMarketConfig[i].Code; newParameterItem.BoolValue = tbMarketConfig[i].BoolValue; newParameterItem.StringValue = tbMarketConfig[i].StringValue; newParameterItem.NumValue = tbMarketConfig[i].NumValue; newParameterItem.DateValue = tbMarketConfig[i].DateValue; Result.Add(newParameterItem); } } } catch (Exception ex) { return null; } finally { adap.Connection.Close(); conn.Close(); } return Result; }