Example #1
0
        /// <summary>
        /// Экспортировать таблицу базы конфигурации в файл формата DAT
        /// </summary>
        public static bool ExportTable(Tables.TableInfo srcTableInfo, string destFileName,
                                       int minID, int maxID, out string msg)
        {
            try
            {
                // проверка аргументов метода
                if (srcTableInfo == null)
                {
                    throw new ArgumentNullException("srcTableInfo");
                }

                if (string.IsNullOrWhiteSpace(destFileName))
                {
                    throw new ArgumentException(AppPhrases.ExportFileUndefied);
                }

                string dir = Path.GetDirectoryName(destFileName);
                if (string.IsNullOrWhiteSpace(dir))
                {
                    throw new DirectoryNotFoundException(AppPhrases.ExportDirUndefied);
                }

                if (!Directory.Exists(dir))
                {
                    throw new DirectoryNotFoundException(AppPhrases.ExportDirNotExists);
                }

                // получение таблицы
                DataTable srcTable = srcTableInfo.GetTable();

                // ограничение диапазона идентификаторов
                if ((0 < minID || maxID < int.MaxValue) && srcTableInfo.IDColName != "")
                {
                    srcTable.DefaultView.RowFilter = string.Format("{0} <= {2} and {2} <= {1}",
                                                                   minID, maxID, srcTableInfo.IDColName);
                }

                // сохранение таблицы в формате DAT
                BaseAdapter adapter = new BaseAdapter();
                adapter.FileName = destFileName;
                adapter.Update(srcTable);
                msg = AppPhrases.ExportCompleted;
                return(true);
            }
            catch (Exception ex)
            {
                msg = AppPhrases.ExportError + ":\r\n" + ex.Message;
                return(false);
            }
        }
Example #2
0
        /// <summary>
        /// Передать базу конфигурации серверу, т.е конвертировать из формата SDF в DAT
        /// </summary>
        public static bool PassBase(List <Tables.TableInfo> srcTableInfoList, string baseDATDir, out string msg)
        {
            try
            {
                // проверка аргументов метода
                if (srcTableInfoList == null)
                {
                    throw new ArgumentNullException("srcTableInfoList");
                }

                if (!Directory.Exists(baseDATDir))
                {
                    throw new DirectoryNotFoundException(CommonPhrases.BaseDATDirNotExists);
                }

                // создание файла блокировки базы конфигурации
                string     baseLockPath   = baseDATDir + "baselock";
                FileStream baseLockStream = new FileStream(baseLockPath, FileMode.Create, FileAccess.Write, FileShare.ReadWrite);
                baseLockStream.Close();

                try
                {
                    // сохранение таблиц в формате DAT
                    BaseAdapter adapter = new BaseAdapter();
                    foreach (Tables.TableInfo tableInfo in Tables.TableInfoList)
                    {
                        DataTable table = tableInfo.GetTable();
                        adapter.FileName = baseDATDir + tableInfo.FileName;
                        adapter.Update(table);
                    }
                }
                finally
                {
                    // удаление файла блокировки базы конфигурации
                    File.Delete(baseLockPath);
                }

                msg = AppPhrases.DbPassCompleted;
                return(true);
            }
            catch (Exception ex)
            {
                msg = AppPhrases.DbPassError + ":\r\n" + ex.Message;
                return(false);
            }
        }
Example #3
0
        private void miDbPassToServer_Click(object sender, EventArgs e)
        {
            // перевод базы конфигурации в формат DAT
            try
            {
                if (AppData.Connected)
                {
                    string baseDatDir = settings.AppSett.BaseDATDir;
                    if (Directory.Exists(baseDatDir))
                    {
                        // создание файла блокировки базы конфигурации
                        string     baseLockPath   = baseDatDir + "baselock";
                        FileStream baseLockStream = new FileStream(baseLockPath, FileMode.Create, FileAccess.Write, FileShare.ReadWrite);
                        baseLockStream.Close();

                        try
                        {
                            // сохранение таблиц базы конфигурации в формате DAT
                            BaseAdapter adapter = new BaseAdapter();
                            foreach (Tables.TableInfo tableInfo in Tables.TablesInfo)
                            {
                                DataTable table = tableInfo.GetTable();
                                adapter.FileName = baseDatDir + tableInfo.FileName;
                                adapter.Update(table);
                            }
                        }
                        finally
                        {
                            // удаление файла блокировки базы конфигурации
                            File.Delete(baseLockPath);
                        }

                        ScadaUtils.ShowInfo(AppPhrases.DbPassCompleted);
                    }
                    else
                    {
                        ScadaUtils.ShowError(CommonPhrases.BaseDATDirNotExists);
                    }
                }
            }
            catch (Exception ex)
            {
                AppUtils.ProcError(AppPhrases.DbPassError + ":\r\n" + ex.Message);
            }
        }
Example #4
0
        private void btnExport_Click(object sender, EventArgs e)
        {
            // экспорт выбранной таблицы в формат DAT
            try
            {
                Tables.TableInfo tableInfo = cbTable.SelectedItem as Tables.TableInfo;

                if (tableInfo != null && AppData.Connected)
                {
                    string fileName  = txtFileName.Text.Trim();
                    string directory = fileName == "" ? "" : Path.GetDirectoryName(fileName);
                    if (directory == "")
                    {
                        ScadaUtils.ShowError(AppPhrases.ExportDirUndefied);
                    }
                    else
                    {
                        if (Directory.Exists(directory))
                        {
                            BaseAdapter adapter = new BaseAdapter();
                            DataTable   table   = tableInfo.GetTable();
                            adapter.FileName = fileName;
                            adapter.Update(table);

                            ScadaUtils.ShowInfo(AppPhrases.ExportCompleted);
                        }
                        else
                        {
                            ScadaUtils.ShowError(AppPhrases.ExportDirNotExists);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                AppUtils.ProcError(AppPhrases.ExportError + ":\r\n" + ex.Message);
            }
        }
Example #5
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try {
                if (dataTable == null)
                {
                    ScadaUiUtils.ShowWarning("Table is not initialized.");
                }
                else
                {
                    if (rbSnapshot.Checked)
                    {
                        var sa = new SrezAdapter {
                            FileName = txtFileName.Text
                        };
                        sa.Update(srezTable);
                    }
                    else if (rbEvent.Checked)
                    {
                        var ea = new EventAdapter {
                            FileName = txtFileName.Text
                        };
                        ea.Update(dataTable);
                    }
                    else     // rbBase.Checked
                    {
                        var ba = new BaseAdapter {
                            FileName = txtFileName.Text
                        };
                        ba.Update(dataTable);
                    }

                    ScadaUiUtils.ShowInfo("Data saved successfully.");
                }
            } catch (Exception ex) {
                ScadaUiUtils.ShowError(ex.Message);
            }
        }
Example #6
0
        /// <summary>
        /// Exports the configuration to the specified archive.
        /// </summary>
        public void ExportToArchive(string destFileName, ScadaProject project, Instance instance,
                                    TransferSettings transferSettings)
        {
            if (destFileName == null)
            {
                throw new ArgumentNullException("destFileName");
            }
            if (project == null)
            {
                throw new ArgumentNullException("project");
            }
            if (instance == null)
            {
                throw new ArgumentNullException("instance");
            }

            FileStream fileStream = null;
            ZipArchive zipArchive = null;

            try {
                fileStream = new FileStream(destFileName, FileMode.Create, FileAccess.Write, FileShare.Read);
                zipArchive = new ZipArchive(fileStream, ZipArchiveMode.Create);
                bool ignoreRegKeys = transferSettings.IgnoreRegKeys;

                // add the configuration database to the archive
                if (transferSettings.IncludeBase)
                {
                    foreach (IBaseTable srcTable in project.ConfigBase.AllTables)
                    {
                        string entryName  = "BaseDAT/" + srcTable.Name.ToLowerInvariant() + ".dat";
                        var    tableEntry = zipArchive.CreateEntry(entryName, CompressionLevel.Fastest);

                        using (var entryStream = tableEntry.Open()) {
                            // convert the table to DAT format
                            BaseAdapter baseAdapter = new BaseAdapter()
                            {
                                Stream = entryStream
                            };
                            baseAdapter.Update(srcTable);
                        }
                    }
                }

                // add the interface files to the archive
                if (transferSettings.IncludeInterface)
                {
                    PackDirectory(zipArchive, project.Interface.InterfaceDir,
                                  DirectoryBuilder.GetDirectory(ConfigParts.Interface, '/'), ignoreRegKeys);
                }

                // add the Server settings to the archive
                if (transferSettings.IncludeServer && instance.ServerApp.Enabled)
                {
                    PackDirectory(zipArchive, instance.ServerApp.AppDir,
                                  DirectoryBuilder.GetDirectory(ConfigParts.Server, '/'), ignoreRegKeys);
                }

                // add the Communicator settings to the archive
                if (transferSettings.IncludeServer && instance.ServerApp.Enabled)
                {
                    PackDirectory(zipArchive, instance.CommApp.AppDir,
                                  DirectoryBuilder.GetDirectory(ConfigParts.Comm, '/'), ignoreRegKeys);
                }

                // add the Webstation settings to the archive
                if (transferSettings.IncludeServer && instance.ServerApp.Enabled)
                {
                    PackDirectory(zipArchive, Path.Combine(instance.WebApp.AppDir, "config"),
                                  DirectoryBuilder.GetDirectory(ConfigParts.Web, AppFolder.Config, '/'), ignoreRegKeys);

                    if (!transferSettings.IgnoreWebStorage)
                    {
                        PackDirectory(zipArchive, Path.Combine(instance.WebApp.AppDir, "storage"),
                                      DirectoryBuilder.GetDirectory(ConfigParts.Web, AppFolder.Storage, '/'), ignoreRegKeys);
                    }
                }
            } catch (Exception ex) {
                throw new ScadaException(AdminPhrases.ExportToArchiveError, ex);
            } finally {
                zipArchive?.Dispose();
                fileStream?.Dispose();
            }
        }
Example #7
0
        /// <summary>
        /// Exports the configuration to the specified archive.
        /// </summary>
        public void ExportToArchive(string destFileName, ScadaProject project, Instance instance,
                                    UploadSettings uploadSettings)
        {
            if (destFileName == null)
            {
                throw new ArgumentNullException("destFileName");
            }
            if (project == null)
            {
                throw new ArgumentNullException("project");
            }
            if (instance == null)
            {
                throw new ArgumentNullException("instance");
            }
            if (uploadSettings == null)
            {
                throw new ArgumentNullException("transferSettings");
            }

            FileStream fileStream = null;
            ZipArchive zipArchive = null;

            try
            {
                fileStream = new FileStream(destFileName, FileMode.Create, FileAccess.Write, FileShare.Read);
                zipArchive = new ZipArchive(fileStream, ZipArchiveMode.Create);

                List <int> objNums       = uploadSettings.ObjNums;
                bool       filterByObj   = objNums.Count > 0;
                bool       ignoreRegKeys = uploadSettings.IgnoreRegKeys;

                // add the configuration database to the archive
                if (uploadSettings.IncludeBase)
                {
                    foreach (IBaseTable srcTable in project.ConfigBase.AllTables)
                    {
                        string          entryName  = "BaseDAT/" + srcTable.Name.ToLowerInvariant() + ".dat";
                        ZipArchiveEntry tableEntry = zipArchive.CreateEntry(entryName, CompressionLevel.Fastest);

                        using (Stream entryStream = tableEntry.Open())
                        {
                            // filter the source table by objects if needed
                            IBaseTable baseTable = srcTable;

                            if (filterByObj)
                            {
                                if (srcTable.ItemType == typeof(InCnl))
                                {
                                    baseTable = GetFilteredTable <InCnl>(srcTable, objNums);
                                }
                                else if (srcTable.ItemType == typeof(CtrlCnl))
                                {
                                    baseTable = GetFilteredTable <CtrlCnl>(srcTable, objNums);
                                }
                                else if (srcTable.ItemType == typeof(Interface))
                                {
                                    baseTable = GetFilteredTable <Interface>(srcTable, objNums);
                                }
                            }

                            // convert the table to DAT format
                            BaseAdapter baseAdapter = new BaseAdapter()
                            {
                                Stream = entryStream
                            };
                            baseAdapter.Update(baseTable);
                        }
                    }
                }

                // add the interface files to the archive
                if (uploadSettings.IncludeInterface)
                {
                    string interfaceDir = project.Interface.InterfaceDir;
                    string entryPrefix  = DirectoryBuilder.GetDirectory(ConfigParts.Interface, '/');

                    if (filterByObj)
                    {
                        PackFiles(zipArchive, interfaceDir,
                                  GetInterfaceFiles(project.ConfigBase.InterfaceTable, interfaceDir, objNums),
                                  entryPrefix);
                    }
                    else
                    {
                        PackDirectory(zipArchive, interfaceDir, entryPrefix, ignoreRegKeys);
                    }
                }

                // add the Server settings to the archive
                if (uploadSettings.IncludeServer && instance.ServerApp.Enabled)
                {
                    PackDirectory(zipArchive, instance.ServerApp.AppDir,
                                  DirectoryBuilder.GetDirectory(ConfigParts.Server, '/'), ignoreRegKeys);
                }

                // add the Communicator settings to the archive
                if (uploadSettings.IncludeComm && instance.CommApp.Enabled)
                {
                    PackDirectory(zipArchive, instance.CommApp.AppDir,
                                  DirectoryBuilder.GetDirectory(ConfigParts.Comm, '/'), ignoreRegKeys);
                }

                // add the Webstation settings to the archive
                if (uploadSettings.IncludeWeb && instance.WebApp.Enabled)
                {
                    PackDirectory(zipArchive, Path.Combine(instance.WebApp.AppDir, "config"),
                                  DirectoryBuilder.GetDirectory(ConfigParts.Web, AppFolder.Config, '/'), ignoreRegKeys);

                    if (!uploadSettings.IgnoreWebStorage)
                    {
                        PackDirectory(zipArchive, Path.Combine(instance.WebApp.AppDir, "storage"),
                                      DirectoryBuilder.GetDirectory(ConfigParts.Web, AppFolder.Storage, '/'), ignoreRegKeys);
                    }
                }

                // add an information entry to the archive
                using (Stream entryStream =
                           zipArchive.CreateEntry(ProjectInfoEntryName, CompressionLevel.Fastest).Open())
                {
                    using (StreamWriter writer = new StreamWriter(entryStream, Encoding.UTF8))
                    {
                        writer.Write(project.GetInfo());
                    }
                }
            }
            catch (Exception ex)
            {
                throw new ScadaException(AdminPhrases.ExportToArchiveError, ex);
            }
            finally
            {
                zipArchive?.Dispose();
                fileStream?.Dispose();
            }
        }
 void Update()
 {
     adapter.Update();
 }