/// <summary>
        /// Запрос пароля (шифрованного для 2.Х.Х и не шифрованного для 1.9.Х)
        /// </summary>
        /// <param name="typeDB_CFG">тип базы данных конфигурации (1.9.Х/2.Х.Х)</param>
        /// <param name="id">идентификатор пользователя(роли) - часть составного ключа</param>
        /// <param name="id_role">роль пользователя (только для 2.Х.Х), "роль" источника данных 501</param>
        /// <returns>текст запроса</returns>
        private static string PasswordRequest(TYPE_DATABASE_CFG typeDB_CFG, int id, int id_role)
        {
            string strRes = string.Empty;

            if (id_role < 0)
            {
                id_role = 501;
            }
            else
            {
                ;
            }

            strRes = "SELECT psw.* FROM passwords psw WHERE ";
            if (typeDB_CFG == TYPE_DATABASE_CFG.CFG_200)
            {
                strRes += @"psw.ID_EXT = " + id.ToString() + " AND ";
            }
            else
            {
                strRes += string.Empty;
            }

            strRes += "ID_ROLE = " + id_role.ToString();

            return(strRes);
        }
        public static DataTable GetConnectionSettings(TYPE_DATABASE_CFG typeDB_CFG, ref DbConnection conn, int id_ext, int id_role, out int er)
        {
            er = 0;

            DataTable tableRes = DbTSQLInterface.Select(ref conn, ConnectionSettingsRequest(id_ext), null, null, out er),
                      tablePsw = DbTSQLInterface.Select(ref conn, PasswordRequest(typeDB_CFG, id_ext, id_role), null, null, out er);

            if ((tableRes.Rows.Count > 0) && (tablePsw.Rows.Count > 0))
            {
                tableRes = GetConnectionSettings(ref tableRes, 0, ref tablePsw, 0);
            }
            else
            {
                if ((!(tablePsw.Rows.Count > 0)) && (tableRes.Columns.IndexOf(@"PASSWORD") < 0))
                {
                    er = -1;
                }
                else
                {
                    if (tableRes.Columns.IndexOf(@"PASSWORD") < 0)
                    {
                        tableRes.Columns.Add(@"PASSWORD", typeof(string));
                    }
                    else
                    {
                        ;
                    }

                    er = 0;
                }
            }

            return(tableRes);
        }
        /*public static DataTable GetConnectionSettings (ConnectionSettings connSett, int id_ext, int id_role, out int er)
         * {
         *  er = 0;
         *
         *  DataTable tableRes = DbTSQLInterface.Select(connSett, ConnectionSettingsRequest(id_ext), out er),
         *          tablePsw = DbTSQLInterface.Select(connSett, PasswordRequest(id_ext, id_role), out er);
         *
         *  return GetConnectionSettings (ref tableRes, 0, ref tablePsw, 0);
         * }*/

        public static DataTable GetConnectionSettings(TYPE_DATABASE_CFG typeDB_CFG, int idListener, int id_ext, int id_role, out int er)
        {
            DbConnection conn = DbSources.Sources().GetConnection(idListener, out er);

            if (er == 0)
            {
                return(GetConnectionSettings(typeDB_CFG, ref conn, id_ext, id_role, out er));
            }
            else
            {
                return(null);
            }
        }
Beispiel #4
0
        public void InitTEC(int idListener, FormChangeMode.MODE_TECCOMPONENT mode, TYPE_DATABASE_CFG typeCfg, HMark markQueries, bool bIgnoreTECInUse)
        {
            //Logging.Logg().Debug("Admin::InitTEC () - вход...");

            //m_ignore_connsett_data = ! bUseData;

            if (!(idListener < 0))
            {
                if (mode == FormChangeMode.MODE_TECCOMPONENT.UNKNOWN)
                {
                    switch (typeCfg)
                    {
                    case TYPE_DATABASE_CFG.CFG_190:
                        this.m_list_tec = new InitTEC_190(idListener, bIgnoreTECInUse, false).tec;
                        break;

                    case TYPE_DATABASE_CFG.CFG_200:
                        this.m_list_tec = new InitTEC_200(idListener, bIgnoreTECInUse, false).tec;
                        break;

                    default:
                        break;
                    }
                }
                else
                {
                    switch (typeCfg)
                    {
                    case TYPE_DATABASE_CFG.CFG_190:
                        this.m_list_tec = new InitTEC_190(idListener, (short)mode, bIgnoreTECInUse, false).tec;
                        break;

                    case TYPE_DATABASE_CFG.CFG_200:
                        this.m_list_tec = new InitTEC_200(idListener, (short)mode, bIgnoreTECInUse, false).tec;
                        break;

                    default:
                        break;
                    }
                }
            }
            else
            {
                this.m_list_tec = new InitTECBase.ListTEC();
            }

            initQueries(markQueries);
            initTEC();
        }
Beispiel #5
0
        protected override void Start()
        {
            int i = -1;

            CreateFormConnectionSettings("connsett_tg.ini", true);

            int    iConfigDB       = -1;
            string keyTypeConfigDB = @"ТипБДКфгНазначение";

            //FileINI fileINI = new FileINI(@"setup.ini");
            //string sec = "Main (" + ProgramBase.AppName + ")";
            iConfigDB = Int32.Parse(m_sFileINI.GetMainValueOfKey(keyTypeConfigDB));

            TYPE_DATABASE_CFG iTypeConfigDB = TYPE_DATABASE_CFG.UNKNOWN;

            for (TYPE_DATABASE_CFG t = TYPE_DATABASE_CFG.CFG_190; t < TYPE_DATABASE_CFG.UNKNOWN; t++)
            {
                if (t.ToString().Contains(iConfigDB.ToString()) == true)
                {
                    iTypeConfigDB = t;
                    break;
                }
                else
                {
                    ;
                }
            }

            bool bIgnoreTECInUse = false;

            HMark markQueries = new HMark();

            markQueries.Marked((int)StatisticCommon.CONN_SETT_TYPE.ADMIN);
            markQueries.Marked((int)StatisticCommon.CONN_SETT_TYPE.PBR);

            int idListener = DbSources.Sources().Register(s_listFormConnectionSettings[(int)StatisticCommon.CONN_SETT_TYPE.CONFIG_DB].getConnSett(), false, @"CONFIG_DB");

            for (i = 0; i < (Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE; i++)
            {
                if (i == (Int16)CONN_SETT_TYPE.SOURCE)
                {
                    m_arAdmin[i] = new AdminTransTG(new bool [] { false, false });
                }
                else
                if (i == (Int16)CONN_SETT_TYPE.DEST)
                {
                    m_arAdmin[i] = new AdminTransTG(new bool[] { false, true });
                }
                else
                {
                    ;
                }

                try {
                    ((AdminTS)m_arAdmin[i]).InitTEC(idListener, FormChangeMode.MODE_TECCOMPONENT.UNKNOWN, iTypeConfigDB, markQueries, bIgnoreTECInUse);
                    RemoveTEC(m_arAdmin[i]);
                }
                catch (Exception e)
                {
                    Logging.Logg().Exception(e, Logging.INDEX_MESSAGE.NOT_SET, "FormMainTransTG::FormMainTransTG ()");
                    //ErrorReport("Ошибка соединения. Перехож в ожидание.");
                    //setUIControlConnectionSettings(i);
                    break;
                }
                //((AdminTS)m_arAdmin[i]).connSettConfigDB = m_formConnectionSettings.getConnSett();
                ((AdminTS)m_arAdmin[i]).m_typeFields = AdminTS.TYPE_FIELDS.DYNAMIC;
                if (i == (Int16)CONN_SETT_TYPE.SOURCE)
                {
                    m_arAdmin[i].m_ignore_date = false;
                }
                else
                if (i == (Int16)CONN_SETT_TYPE.DEST)
                {
                    m_arAdmin[i].m_ignore_date = true;
                }
                else
                {
                    ;
                }

                //m_arAdmin[i].m_ignore_connsett_data = true; //-> в конструктор
            }

            DbSources.Sources().UnRegister(idListener);

            if (!(i < (Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE))
            {
                setUIControlConnectionSettings((Int16)CONN_SETT_TYPE.DEST);

                for (i = 0; i < (Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE; i++)
                {
                    m_arAdmin[i].SetDelegateWait(delegateStartWait, delegateStopWait, delegateEvent);
                    //m_arAdmin[i].SetDelegateWait(new DelegateFunc(StartWait), new DelegateFunc(StopWait), delegateEvent);
                    m_arAdmin[i].SetDelegateReport(ErrorReport, WarningReport, ActionReport, ReportClear);

                    m_arAdmin[i].SetDelegateData(setDataGridViewAdmin, errorDataGridViewAdmin);
                    m_arAdmin[i].SetDelegateSaveComplete(saveDataGridViewAdminComplete);

                    m_arAdmin[i].SetDelegateDatetime(setDatetimePicker);

                    //m_arAdmin [i].mode (FormChangeMode.MODE_TECCOMPONENT.GTP);

                    m_arAdmin[i].Start();
                }

                /*
                 * // This needs to be declared in a place where it will not go out of scope.
                 * // For example, it would be a class variable in a form class.
                 * System.IO.FileSystemWatcher watcher = new System.IO.FileSystemWatcher();
                 * // This code would go in one of the initialization methods of the class.
                 * watcher.Path = "c:\\";
                 * // Watch only for changes to *.txt files.
                 * watcher.Filter = "*.txt";
                 * watcher.IncludeSubdirectories = false;
                 * // Enable the component to begin watching for changes.
                 * watcher.EnableRaisingEvents = true;
                 * // Filter for Last Write changes.
                 * watcher.NotifyFilter = System.IO.NotifyFilters.LastWrite;
                 * // Example of watching more than one type of change.
                 * watcher.NotifyFilter = System.IO.NotifyFilters.LastWrite | System.IO.NotifyFilters.Size;
                 *
                 * //Асинхронно
                 * watcher.Changed += new System.IO.FileSystemEventHandler(this.watcher_Changed);
                 *
                 * //Сихронно
                 * watcher.WaitForChanged(System.IO.WatcherChangeTypes.All);
                 */

                //panelMain.Visible = false;

                start();
            }
            else
            {
                ;
            }
        }
Beispiel #6
0
 public static DataTable getConnSettingsOfIdSource(TYPE_DATABASE_CFG typeDB_CFG, ref DbConnection conn, int id_ext, int id_role, out int err)
 {
     return(ConnectionSettingsSource.GetConnectionSettings(typeDB_CFG, ref conn, id_ext, id_role, out err));
 }
Beispiel #7
0
        public static DataTable getConnSettingsOfIdSource(TYPE_DATABASE_CFG typeDB_CFG, int idListener, int id_ext, int id_role, out int err)
        {
            DbConnection conn = DbSources.Sources().GetConnection(idListener, out err);

            return(getConnSettingsOfIdSource(typeDB_CFG, ref conn, id_ext, id_role, out err));
        }
Beispiel #8
0
        protected override void Start()
        {
            int i = -1;

            CreateFormConnectionSettings("connsett_mt.ini", true);

            m_sFileINI.AddMainPar(@"ТипБДКфгИсточник", @"200");
            m_sFileINI.AddMainPar(@"ИгнорДатаВремя-ModesTerminale", false.ToString());

            int[]    arConfigDB        = new int[(Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE];
            string[] arKeyTypeConfigDB = new string[(Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE] {
                @"ТипБДКфгИсточник", @"ТипБДКфгНазначение"
            };

            TYPE_DATABASE_CFG[] arTypeConfigDB = new TYPE_DATABASE_CFG[(Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE] {
                TYPE_DATABASE_CFG.UNKNOWN, TYPE_DATABASE_CFG.UNKNOWN
            };
            for (i = 0; i < (Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE; i++)
            {
                arConfigDB[i] = Int32.Parse(m_sFileINI.GetMainValueOfKey(arKeyTypeConfigDB[i]));
                for (TYPE_DATABASE_CFG t = TYPE_DATABASE_CFG.CFG_190; t < TYPE_DATABASE_CFG.UNKNOWN; t++)
                {
                    if (t.ToString().Contains(arConfigDB[i].ToString()) == true)
                    {
                        arTypeConfigDB[i] = t;
                        break;
                    }
                    else
                    {
                        ;
                    }
                }
            }

            bool   bIgnoreTECInUse = false;
            string strTypeField    = m_sFileINI.GetMainValueOfKey(@"РДГФорматТаблицаНазначение");
            int    idListener      = -1;

            HMark markQueries = new HMark(new int[] { (int)StatisticCommon.CONN_SETT_TYPE.ADMIN, (int)StatisticCommon.CONN_SETT_TYPE.PBR, (int)StatisticCommon.CONN_SETT_TYPE.MTERM });

            //markQueries.Marked((int)StatisticCommon.CONN_SETT_TYPE.ADMIN);
            //markQueries.Marked((int)StatisticCommon.CONN_SETT_TYPE.PBR);
            //markQueries.Marked((int)StatisticCommon.CONN_SETT_TYPE.MTERM);

            for (i = 0; i < (Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE; i++)
            {
                idListener = DbMCSources.Sources().Register(s_listFormConnectionSettings[(int)StatisticCommon.CONN_SETT_TYPE.CONFIG_DB].getConnSett(i), false, @"CONFIG_DB");

                if (!(idListener < 0))
                {
                    switch (i)
                    {
                    case (Int16)CONN_SETT_TYPE.SOURCE:
                        m_arAdmin[i] = new AdminMT();
                        break;

                    case (Int16)CONN_SETT_TYPE.DEST:
                        m_arAdmin[i] = new AdminTS_Modes(new bool[] { false, true });
                        break;

                    default:
                        break;
                    }
                    try
                    {
                        m_arAdmin[i].InitTEC(idListener, m_modeTECComponent, arTypeConfigDB [i], markQueries, bIgnoreTECInUse);
                        RemoveTEC(m_arAdmin[i]);
                    }
                    catch (Exception e)
                    {
                        Logging.Logg().Exception(e, "FormMainTransMT::FormMainTransMT ()", Logging.INDEX_MESSAGE.NOT_SET);
                        //ErrorReport("Ошибка соединения. Переход в ожидание.");
                        //setUIControlConnectionSettings(i);
                        break;
                    }
                    switch (i)
                    {
                    case (Int16)CONN_SETT_TYPE.SOURCE:
                        m_arAdmin[i].m_ignore_date = bool.Parse(m_sFileINI.GetMainValueOfKey(@"ИгнорДатаВремя-ModesTerminale"));
                        break;

                    case (Int16)CONN_SETT_TYPE.DEST:
                        if (strTypeField.Equals(AdminTS.TYPE_FIELDS.DYNAMIC.ToString()) == true)
                        {
                            ((AdminTS)m_arAdmin[i]).m_typeFields = AdminTS.TYPE_FIELDS.DYNAMIC;
                        }
                        else if (strTypeField.Equals(AdminTS.TYPE_FIELDS.STATIC.ToString()) == true)
                        {
                            ((AdminTS)m_arAdmin[i]).m_typeFields = AdminTS.TYPE_FIELDS.STATIC;
                        }
                        else
                        {
                            ;
                        }
                        m_arAdmin[i].m_ignore_date = bool.Parse(m_sFileINI.GetMainValueOfKey(@"ИгнорДатаВремя-techsite"));
                        break;

                    default:
                        break;
                    }

                    //m_arAdmin[i].m_ignore_connsett_data = true; //-> в конструктор

                    DbMCSources.Sources().UnRegister(idListener);
                }
                else
                {
                    ;
                }
            }

            if (!(i < (Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE))
            {
                setUIControlConnectionSettings((Int16)CONN_SETT_TYPE.DEST);

                for (i = 0; i < (Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE; i++)
                {
                    //setUIControlConnectionSettings(i); //??? Перенос ДО цикла

                    m_arAdmin[i].SetDelegateWait(delegateStartWait, delegateStopWait, delegateEvent);
                    //m_arAdmin[i].SetDelegateWait(new DelegateFunc(StartWait), new DelegateFunc(StopWait), delegateEvent);
                    m_arAdmin[i].SetDelegateReport(ErrorReport, WarningReport, ActionReport, ReportClear);

                    m_arAdmin[i].SetDelegateData(setDataGridViewAdmin, errorDataGridViewAdmin);
                    m_arAdmin[i].SetDelegateSaveComplete(saveDataGridViewAdminComplete);

                    m_arAdmin[i].SetDelegateDatetime(setDatetimePicker);

                    //m_arAdmin [i].mode (FormChangeMode.MODE_TECCOMPONENT.GTP);

                    //??? Перенос ПОСЛЕ цикла
                    //if (i == (int)(Int16)CONN_SETT_TYPE.DEST)
                    //    (Int16)CONN_SETT_TYPE.DEST
                    m_arAdmin[i].Start();
                    //else
                    //    ;
                }

                //Перенес обратно...
                //((AdminTS)m_arAdmin[(Int16)CONN_SETT_TYPE.DEST]).StartDbInterface();

                //panelMain.Visible = false;

                base.Start();
            }
            else
            {
                ;
            }
        }
Beispiel #9
0
        //SortedList<DateTime, OneField> HourlyFieldValues;

        /// <summary>
        /// Конструктор открывает коннект к базе. Закрывает деструктор.
        /// </summary>
        public MySQLtechsite(bool bCalculatedHalfHourValues)
        {
            int iRes = -1;

            m_bCalculatedHalfHourValues = bCalculatedHalfHourValues;

            int iConfigDB = -1;
            ConnectionSettings connSett = Program.ReadConnSettFromFileINI(out iConfigDB);

            connSett.id = ConnectionSettings.UN_ENUMERABLE_ID;

            Console.WriteLine("DB parametrs: IP=" + connSett.server + ", port=" + connSett.port + ", DBName=" + connSett.dbName + ", UID=" + connSett.userName + Environment.NewLine);

            //Соединение дл я БД конфигурации
            m_idListener = DbSources.Sources().Register(connSett, false, @"CONFIG_DB");
            m_connection = DbSources.Sources().GetConnection(m_idListener, out iRes);

            TYPE_DATABASE_CFG typeConfigDB = TYPE_DATABASE_CFG.UNKNOWN;

            for (TYPE_DATABASE_CFG t = TYPE_DATABASE_CFG.CFG_190; t < TYPE_DATABASE_CFG.UNKNOWN; t++)
            {
                if (t.ToString().Contains(iConfigDB.ToString()) == true)
                {
                    typeConfigDB = t;
                    break;
                }
                else
                {
                    ;
                }
            }

            if (iRes == 0)
            {
                m_admin = new AdminTS(new bool [] { false, true });

                HMark markQueries = new HMark();
                markQueries.Marked((int)StatisticCommon.CONN_SETT_TYPE.ADMIN);
                markQueries.Marked((int)StatisticCommon.CONN_SETT_TYPE.PBR);

                m_admin.InitTEC(m_idListener, FormChangeMode.MODE_TECCOMPONENT.GTP, typeConfigDB, markQueries, true);
                m_listIndexTECComponent = m_admin.GetListIndexTECComponent(FormChangeMode.MODE_TECCOMPONENT.GTP);

                m_listIdMCTECComponent = new List <int>();

                int i = -1, j = -1;
                for (i = 0; i < m_listIndexTECComponent.Count; i++)
                {
                    for (j = 0; j < m_admin.allTECComponents[m_listIndexTECComponent[i]].m_listMCentreId.Count; j++)
                    {
                        m_listIdMCTECComponent.Add(m_admin.allTECComponents[m_listIndexTECComponent[i]].m_listMCentreId[j]);
                    }
                }

                //Пересоединение для таблиц ПБР
                if ((DbTSQLInterface.IsConnected(ref m_connection) == true) && (m_listIdMCTECComponent.Count > 0))
                {
                    DbSources.Sources().UnRegister(m_idListener);

                    m_idListener       = DbSources.Sources().Register(m_admin.allTECComponents[m_listIndexTECComponent[0]].tec.connSetts[(int)StatisticCommon.CONN_SETT_TYPE.PBR], false, @"PBR");
                    m_connection       = DbSources.Sources().GetConnection(m_idListener, out iRes);
                    m_strTableNamePPBR = m_admin.allTECComponents[m_listIndexTECComponent[0]].tec.m_arNameTableUsedPPBRvsPBR[(int)AdminTS.TYPE_FIELDS.STATIC];
                }
                else
                {
                }
            }
            else
            {
                ;
            }

            {
                //itssAUX.PrintErrorMessage("Ошибка! MySQLtechsite::MySQLtechsite () - чтение файла с шифрованными параметрами соединения (" + m_strFileNameConnSett + ")...");
                itssAUX.PrintErrorMessage("Проверте параметры соединения (" + Program.m_fileINI.m_NameFileINI + "). Затем запустите программу с аргументом /setmysqlpassword..." + Environment.NewLine);
            }
        }
Beispiel #10
0
        protected override void Start()
        {
            int i = -1;

            EditFormConnectionSettings("connsett_gtp.ini", true);

            //Добавление необходимого кол-ва элементов настроек для соединения с БД конфигурации
            //if (m_formConnectionSettingsConfigDB.Count < 2)
            //{
            //    while (!(m_formConnectionSettingsConfigDB.Count < 2))
            //        m_formConnectionSettingsConfigDB.addConnSett(m_formConnectionSettingsConfigDB.Count);
            //    конфигурацияБДToolStripMenuItem.PerformClick();

            //    return;
            //}
            //else
            //    ;

            m_sFileINI.AddMainPar(@"ТипБДКфгИсточник", @"190");
            m_sFileINI.AddMainPar(@"РДГФорматТаблицаИсточник", @"STATIC");

            ////Для переназначения идентификаторов источников данных БийскТЭЦ
            //m_fileINI.Add(@"ID_БДНазначение_ASKUE", @"6,");
            //m_fileINI.Add(@"ID_БДНазначение_SOTIASSO", @"6,");
            //m_fileINI.Add(@"ID_БДНазначение_PPBR_PBR", @"6,103");
            //m_fileINI.Add(@"ID_БДНазначение_PPBR_ADMIN", @"6,");

            int[]    arConfigDB        = new int[(Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE];
            string[] arKeyTypeConfigDB = new string[(Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE] {
                @"ТипБДКфгИсточник", @"ТипБДКфгНазначение"
            };

            TYPE_DATABASE_CFG[] arTypeConfigDB = new TYPE_DATABASE_CFG[(Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE] {
                TYPE_DATABASE_CFG.UNKNOWN, TYPE_DATABASE_CFG.UNKNOWN
            };
            for (i = 0; i < (Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE; i++)
            {
                arConfigDB[i] = Int32.Parse(m_sFileINI.GetMainValueOfKey(arKeyTypeConfigDB[i]));
                for (TYPE_DATABASE_CFG t = TYPE_DATABASE_CFG.CFG_190; t < TYPE_DATABASE_CFG.UNKNOWN; t++)
                {
                    if (t.ToString().Contains(arConfigDB[i].ToString()) == true)
                    {
                        arTypeConfigDB[i] = t;
                        break;
                    }
                    else
                    {
                        ;
                    }
                }
            }

            string[] arStrTypeField = new string[(Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE];
            arStrTypeField[(int)CONN_SETT_TYPE.SOURCE] = m_sFileINI.GetMainValueOfKey(@"РДГФорматТаблицаИсточник");
            arStrTypeField[(int)CONN_SETT_TYPE.DEST]   = m_sFileINI.GetMainValueOfKey(@"РДГФорматТаблицаНазначение");

            bool bIgnoreDateTime = false;

            if (Boolean.TryParse(m_sFileINI.GetMainValueOfKey(@"ИгнорДатаВремя-techsite"), out bIgnoreDateTime) == false)
            {
                bIgnoreDateTime = false;
            }
            else
            {
                ;
            }

            m_sFileINI.AddMainPar(@"ТЭЦПараметрыНазначение", @"{}");

            HMark markQueries = new HMark(0);

            markQueries.Set((int)StatisticCommon.CONN_SETT_TYPE.PBR, ОпросППБРToolStripMenuItem.Checked);
            markQueries.Set((int)StatisticCommon.CONN_SETT_TYPE.ADMIN, ОпросАдминЗначенияToolStripMenuItem.Checked);

            int idListener = -1;

            //Инициализация объектов получения данных
            for (i = 0; i < (Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE; i++)
            {
                bool bPPBRSavedValues = false;
                if (i == (Int16)CONN_SETT_TYPE.DEST)
                {
                    bPPBRSavedValues = СохранППБРToolStripMenuItem.Checked;
                }
                else
                {
                    ;
                }
                m_arAdmin[i] = new AdminTS_KomDisp(new bool[] { false, bPPBRSavedValues });
                idListener   = DbSources.Sources().Register(s_listFormConnectionSettings[(int)StatisticCommon.CONN_SETT_TYPE.CONFIG_DB].getConnSett(i), false, @"CONFIG_DB");
                try
                {
                    //((AdminTS_KomDisp)m_arAdmin[i]).InitTEC(m_formConnectionSettingsConfigDB.getConnSett((Int16)CONN_SETT_TYPE.DEST), m_modeTECComponent, true, false);
                    m_arAdmin[i].InitTEC(idListener, m_modeTECComponent, arTypeConfigDB[i], markQueries, true);
                    RemoveTEC(m_arAdmin[i]);
                }
                catch (Exception e)
                {
                    Logging.Logg().Exception(e, "FormMainTransGTP::FormMainTransGTP ()", Logging.INDEX_MESSAGE.NOT_SET);
                    //ErrorReport("Ошибка соединения. Перехож в ожидание.");
                    //setUIControlConnectionSettings(i);
                    break;
                }

                ////Для переназначения идентификаторов источников данных БийскТЭЦ
                //int j = -1;
                //string val = m_fileINI.GetValueOfKey (@"ID_БДНазначение_PPBR_PBR");
                //val = val.Split (',')[0];
                //for (j = 0; j < m_arAdmin[i].m_list_tec.Count; j ++) {
                //    if (m_arAdmin[i].m_list_tec[j].m_id == Int32.Parse (val))
                //        break;
                //    else
                //        ;
                //}

                //if (j < m_arAdmin[i].m_list_tec.Count) {
                //} else {
                //}

                if ((i == (int)CONN_SETT_TYPE.DEST) && (arTypeConfigDB[(int)CONN_SETT_TYPE.DEST] == TYPE_DATABASE_CFG.CFG_190))
                {
                    string strTECParametersDest = m_sFileINI.GetMainValueOfKey(@"ТЭЦПараметрыНазначение");
                    if (strTECParametersDest.Equals(string.Empty) == false)
                    {
                        //if ((HAdmin.DEBUG_ID_TEC == -1) || (HAdmin.DEBUG_ID_TEC == Convert.ToInt32 (list_tec.Rows[i]["ID"]))) {
                        int err    = -1
                        , indx     = -1
                        , indx_tec = -1;

                        foreach (TEC t in m_arAdmin[(int)CONN_SETT_TYPE.DEST].m_list_tec)
                        {
                            if (t.m_id == 6) //Идентификатор БиТЭЦ
                            {
                                indx_tec = m_arAdmin[(int)CONN_SETT_TYPE.DEST].m_list_tec.IndexOf(t);
                                break;
                            }
                            else
                            {
                                ;
                            }
                        }

                        if (!(indx_tec < 0))
                        {
                            m_arAdmin[(int)CONN_SETT_TYPE.DEST].m_list_tec[indx_tec].m_arNameTableAdminValues[(int)((AdminTS)m_arAdmin[(int)CONN_SETT_TYPE.DEST]).m_typeFields]   = @"";
                            m_arAdmin[(int)CONN_SETT_TYPE.DEST].m_list_tec[indx_tec].m_arNameTableUsedPPBRvsPBR[(int)((AdminTS)m_arAdmin[(int)CONN_SETT_TYPE.DEST]).m_typeFields] = @"BiPPBRvsPBR"; //???

                            m_arAdmin[(int)CONN_SETT_TYPE.DEST].m_list_tec[indx_tec].SetNamesField(@"",                                                                                             //ADMIN_DATETIME
                                                                                                   @"",                                                                                             //ADMIN_REC
                                                                                                   @"",                                                                                             //ADMIN_IS_PER
                                                                                                   @"",                                                                                             //ADMIN_DIVIAT
                                                                                                   @"Date_time",                                                                                    //PBR_DATETIME
                                                                                                   @"PBR",                                                                                          //PPBRvsPBR
                                                                                                   @"PBR_number");

                            m_arAdmin[(int)CONN_SETT_TYPE.DEST].m_list_tec[indx_tec].connSettings(ConnectionSettingsSource.GetConnectionSettings(TYPE_DATABASE_CFG.CFG_190, idListener, 103, -1, out err), (int)StatisticCommon.CONN_SETT_TYPE.PBR);
                        }
                        else
                        {
                            ;
                        }
                    }
                    else
                    {
                        ;
                    }
                }
                else
                {
                }

                for (AdminTS.TYPE_FIELDS tf = AdminTS.TYPE_FIELDS.STATIC; i < (int)AdminTS.TYPE_FIELDS.COUNT_TYPE_FIELDS; tf++)
                {
                    if (arStrTypeField[i].Equals(tf.ToString()) == true)
                    {
                        ((AdminTS)m_arAdmin[i]).m_typeFields = tf;
                        break;
                    }
                    else
                    {
                        ;
                    }
                }

                m_arAdmin[i].m_ignore_date = bIgnoreDateTime;
                //m_arAdmin[i].m_ignore_connsett_data = true; //-> в конструктор

                setUIControlConnectionSettings(i);

                m_arAdmin[i].SetDelegateWait(delegateStartWait, delegateStopWait, delegateEvent);
                //m_arAdmin[i].SetDelegateWait(new DelegateFunc(StartWait), new DelegateFunc (StopWait), delegateEvent);
                m_arAdmin[i].SetDelegateReport(ErrorReport, WarningReport, ActionReport, ReportClear);

                m_arAdmin[i].SetDelegateData(setDataGridViewAdmin, errorDataGridViewAdmin);
                m_arAdmin[i].SetDelegateSaveComplete(saveDataGridViewAdminComplete);

                m_arAdmin[i].SetDelegateDatetime(setDatetimePicker);

                //m_arAdmin [i].mode (FormChangeMode.MODE_TECCOMPONENT.GTP);

                m_arAdmin[i].Start();

                DbSources.Sources().UnRegister(idListener);
            }

            if (!(i < (Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE))
            {
                start();
            }
            else
            {
                ;
            }
        }