private void miAddDataSource_Click(object sender, EventArgs e) { // добавление назначения экспорта DataSource dataSource = null; if (sender == miAddSqlDataSource) { dataSource = new SqlDataSource(); } else if (sender == miAddOraDataSource) { dataSource = new OraDataSource(); } else if (sender == miAddPgSqlDataSource) { dataSource = new PgSqlDataSource(); } else if (sender == miAddMySqlDataSource) { dataSource = new MySqlDataSource(); } else if (sender == miAddOleDbDataSource) { dataSource = new OleDbDataSource(); } if (dataSource != null) { ModConfig.ExportDestination expDest = new ModConfig.ExportDestination(dataSource, new ModConfig.ExportParams()); TreeNode treeNode = NewExpDestNode(expDest); int ind = config.ExportDestinations.BinarySearch(expDest); if (ind >= 0) { ind++; } else { ind = ~ind; } config.ExportDestinations.Insert(ind, expDest); treeView.Nodes.Insert(ind, treeNode); treeView.SelectedNode = treeNode; SetConnectionString(); SetControlsEnabled(); Modified = true; } }
/// <summary> /// Загрузить конфигурацию модуля /// </summary> public bool Load(out string errMsg) { SetToDefault(); try { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(FileName); // загрузка назначений экспорта XmlNode expDestsNode = xmlDoc.DocumentElement.SelectSingleNode("ExportDestinations"); if (expDestsNode != null) { XmlNodeList expDestNodeList = expDestsNode.SelectNodes("ExportDestination"); foreach (XmlElement expDestElem in expDestNodeList) { // загрузка источника данных DataSource dataSource = null; if (expDestElem.SelectSingleNode("DataSource") is XmlNode dataSourceNode) { // получение типа источника данных if (!Enum.TryParse(dataSourceNode.GetChildAsString("DBType"), out DBType dbType)) { dbType = DBType.Undefined; } // создание источника данных switch (dbType) { case DBType.MSSQL: dataSource = new SqlDataSource(); break; case DBType.Oracle: dataSource = new OraDataSource(); break; case DBType.PostgreSQL: dataSource = new PgSqlDataSource(); break; case DBType.MySQL: dataSource = new MySqlDataSource(); break; case DBType.OLEDB: dataSource = new OleDbDataSource(); break; default: dataSource = null; break; } if (dataSource != null) { dataSource.Server = dataSourceNode.GetChildAsString("Server"); dataSource.Database = dataSourceNode.GetChildAsString("Database"); dataSource.User = dataSourceNode.GetChildAsString("User"); dataSource.Password = ScadaUtils.Decrypt(dataSourceNode.GetChildAsString("Password")); dataSource.ConnectionString = dataSourceNode.GetChildAsString("ConnectionString"); if (string.IsNullOrEmpty(dataSource.ConnectionString)) { dataSource.ConnectionString = dataSource.BuildConnectionString(); } } } if (dataSource != null && expDestElem.SelectSingleNode("ExportParams") is XmlNode exportParamsNode) { // загрузка параметров экспорта ExportParams exportParams = new ExportParams(); exportParams.LoadFromXml(exportParamsNode); // создание назначения экспорта ExportDestination expDest = new ExportDestination(dataSource, exportParams); ExportDestinations.Add(expDest); } } // сортировка назначений экспорта ExportDestinations.Sort(); } // загрузка номеров каналов управления для экспорта в ручном режиме if (xmlDoc.DocumentElement.SelectSingleNode("ManualExport") is XmlNode manExpNode) { CurDataCtrlCnlNum = manExpNode.GetChildAsInt("CurDataCtrlCnlNum"); ArcDataCtrlCnlNum = manExpNode.GetChildAsInt("ArcDataCtrlCnlNum"); EventsCtrlCnlNum = manExpNode.GetChildAsInt("EventsCtrlCnlNum"); } errMsg = ""; return(true); } catch (FileNotFoundException ex) { errMsg = ModPhrases.LoadModSettingsError + ": " + ex.Message + Environment.NewLine + ModPhrases.ConfigureModule; return(false); } catch (Exception ex) { errMsg = ModPhrases.LoadModSettingsError + ": " + ex.Message; return(false); } }
private void miAddDataSource_Click(object sender, EventArgs e) { // добавление назначения экспорта DataSource dataSource = null; if (sender == miAddSqlDataSource) dataSource = new SqlDataSource(); else if (sender == miAddOraDataSource) dataSource = new OraDataSource(); else if (sender == miAddPgSqlDataSource) dataSource = new PgSqlDataSource(); else if (sender == miAddMySqlDataSource) dataSource = new MySqlDataSource(); else if (sender == miAddOleDbDataSource) dataSource = new OleDbDataSource(); if (dataSource != null) { Config.ExportDestination expDest = new Config.ExportDestination(dataSource, new Config.ExportParams()); TreeNode treeNode = NewExpDestNode(expDest); int ind = config.ExportDestinations.BinarySearch(expDest); if (ind >= 0) ind++; else ind = ~ind; config.ExportDestinations.Insert(ind, expDest); treeView.Nodes.Insert(ind, treeNode); treeView.SelectedNode = treeNode; SetConnectionString(); SetControlsEnabled(); Modified = true; } }
/// <summary> /// Download module configuration /// </summary> public bool Load(out string errMsg) { SetToDefault(); try { var xmlDoc = new XmlDocument(); xmlDoc.Load(FileName); // loading export destinations var expDestsNode = xmlDoc.DocumentElement.SelectSingleNode("ExportDestinations"); if (expDestsNode != null) { var expDestNodeList = expDestsNode.SelectNodes("ExportDestination"); foreach (XmlElement expDestElem in expDestNodeList) { // loading data source DataSource dataSource = null; var dataSourceNode = expDestElem.SelectSingleNode("DataSource"); if (dataSourceNode != null) { // getting data source type DBTypes dbType; if (!Enum.TryParse <DBTypes>(dataSourceNode.GetChildAsString("DBType"), out dbType)) { dbType = DBTypes.Undefined; } // create data source switch (dbType) { case DBTypes.MSSQL: dataSource = new SqlDataSource(); break; case DBTypes.Oracle: dataSource = new OraDataSource(); break; case DBTypes.PostgreSQL: dataSource = new PgSqlDataSource(); break; case DBTypes.MySQL: dataSource = new MySqlDataSource(); break; case DBTypes.OLEDB: dataSource = new OleDbDataSource(); break; default: dataSource = null; break; } if (dataSource != null) { dataSource.Server = dataSourceNode.GetChildAsString("Server"); dataSource.Database = dataSourceNode.GetChildAsString("Database"); dataSource.User = dataSourceNode.GetChildAsString("User"); dataSource.Password = dataSourceNode.GetChildAsString("Password"); dataSource.ConnectionString = dataSourceNode.GetChildAsString("ConnectionString"); if (string.IsNullOrEmpty(dataSource.ConnectionString)) { dataSource.ConnectionString = dataSource.BuildConnectionString(); } } } // load export options ExportParams exportParams = null; var exportParamsNode = expDestElem.SelectSingleNode("ExportParams"); if (dataSource != null && exportParamsNode != null) { exportParams = new ExportParams { ExportCurDataQuery = exportParamsNode.GetChildAsString("ExportCurDataQuery") }; exportParams.ExportCurData = !string.IsNullOrEmpty(exportParams.ExportCurDataQuery) && exportParamsNode.GetChildAsBool("ExportCurData"); exportParams.ExportArcDataQuery = exportParamsNode.GetChildAsString("ExportArcDataQuery"); exportParams.ExportArcData = !string.IsNullOrEmpty(exportParams.ExportArcDataQuery) && exportParamsNode.GetChildAsBool("ExportArcData"); exportParams.ExportEventQuery = exportParamsNode.GetChildAsString("ExportEventQuery"); exportParams.ExportEvents = !string.IsNullOrEmpty(exportParams.ExportEventQuery) && exportParamsNode.GetChildAsBool("ExportEvents"); } // creating export destination if (dataSource != null && exportParams != null) { var expDest = new ExportDestination(dataSource, exportParams); ExportDestinations.Add(expDest); } } // sort export destinations ExportDestinations.Sort(); } // loading control channel numbers for manual export var manExpNode = xmlDoc.DocumentElement.SelectSingleNode("ManualExport"); if (manExpNode != null) { CurDataCtrlCnlNum = manExpNode.GetChildAsInt("CurDataCtrlCnlNum"); ArcDataCtrlCnlNum = manExpNode.GetChildAsInt("ArcDataCtrlCnlNum"); EventsCtrlCnlNum = manExpNode.GetChildAsInt("EventsCtrlCnlNum"); } errMsg = ""; return(true); } catch (FileNotFoundException ex) { errMsg = ModPhrases.LoadModSettingsError + ": " + ex.Message + Environment.NewLine + ModPhrases.ConfigureModule; return(false); } catch (Exception ex) { errMsg = ModPhrases.LoadModSettingsError + ": " + ex.Message; return(false); } }