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 { ; } }
//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); } }
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 { ; } }
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 { ; } }