protected override void createAdmin() { EnabledExportPBRValues = (HStatisticUsers.IsAllowed((int)HStatisticUsers.ID_ALLOWED.EXPORT_PBRVALUES_KOMDISP)); //??? ΡΠΎΠΆΠ΅ ΡΠ»Π΅Π΄ΡΠ΅Ρ ΡΠΈΡΠ°ΡΡ ΠΈΠ· ΠΠ ΠΊΠΎΠ½ΡΠΈΠ³ΡΡΠ°ΡΠΈΠΈ AdminTS_KomDisp.ModeDefaultExportPBRValues = AdminTS_KomDisp.MODE_EXPORT_PBRVALUES.MANUAL; AllowUserSetModeExportPBRValues = true & EnabledExportPBRValues; AllowUserChangeSheduleStartExportPBRValues = false & EnabledExportPBRValues; AllowUserChangeShedulePeriodExportPBRValues = false & EnabledExportPBRValues; //??? ΡΠΎΠΆΠ΅ ΡΠ»Π΅Π΄ΡΠ΅Ρ ΡΠΈΡΠ°ΡΡ ΠΈΠ· ΠΠ ΠΊΠΎΠ½ΡΠΈΠ³ΡΡΠ°ΡΠΈΠΈ AdminTS_KomDisp.ConstantExportPBRValues.MaskDocument = @"ΠΠΠ -Π€Π°ΠΊΡ-Π‘ΡΠ°ΡΠΈΡΡΠΈΠΊΠ°"; AdminTS_KomDisp.ConstantExportPBRValues.MaskExtension = @"xlsx"; AdminTS_KomDisp.ConstantExportPBRValues.NumberRow_0 = 7; AdminTS_KomDisp.ConstantExportPBRValues.Format_Date = "dd.MM.yyyy HH:mm"; AdminTS_KomDisp.ConstantExportPBRValues.NumberColumn_Date = 1; AdminTS_KomDisp.ConstantExportPBRValues.NumberRow_Date = 5; AdminTS_KomDisp.SEC_SHEDULE_START_EXPORT_PBR = int.Parse(FormMain.formParameters.m_arParametrSetup[(int)FormParameters.PARAMETR_SETUP.KOMDISP_SHEDULE_START_EXPORT_PBR]); AdminTS_KomDisp.SEC_SHEDULE_PERIOD_EXPORT_PBR = int.Parse(FormMain.formParameters.m_arParametrSetup[(int)FormParameters.PARAMETR_SETUP.KOMDISP_SHEDULE_PERIOD_EXPORT_PBR]); //AdminTS_KomDisp.MS_WAIT_EXPORT_PBR_MAX = 6666; ΡΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½ ΠΏΡΠΈ ΠΎΠ±ΡΡΠ²Π»Π΅Π½ΠΈΠΈ/ΠΎΠΏΡΠ΅Π΄Π΅Π»Π΅Π½ΠΈΠΈ //AdminTS_KomDisp.MS_WAIT_EXPORT_PBR_ABORT = 666; ΡΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½ ΠΏΡΠΈ ΠΎΠ±ΡΡΠ²Π»Π΅Π½ΠΈΠΈ/ΠΎΠΏΡΠ΅Π΄Π΅Π»Π΅Π½ΠΈΠΈ AdminTS_KomDisp.Folder_CSV = FormMain.formParameters.m_arParametrSetup[(int)FormParameters.PARAMETR_SETUP.KOMDISP_FOLDER_CSV]; //@"\\ne2844\2.X.X\ΠΠΠ -csv"; //@"E:\Temp\ΠΠΠ -csv"; //ΠΠΎΠ·ΠΌΠΎΠΆΠ½ΠΎΡΡΡ ΡΠ΅Π΄Π°ΠΊΡΠΈΡΠΎΠ²Π°Π½ΠΈΡ Π·Π½Π°ΡΠ΅Π½ΠΈΠΉ ΠΠΠ : ΡΠ°Π·ΡΠ΅ΡΠ΅Π½ΠΎ ΡΠΏΡΠ°Π²Π»Π΅Π½ΠΈΠ΅ (ΠΈΠ·ΠΌΠ΅Π½Π΅Π½ΠΈΠ΅ ΡΠ°Π·ΡΠ΅ΡΠ΅Π½ΠΈΡ Π½Π° Π·Π°ΠΏΠΈΡΡ), Π·Π°ΠΏΠΈΡΡ ΠΠ ΡΠ°Π·ΡΠ΅ΡΠ΅Π½Π° m_admin = new AdminTS_KomDisp(new bool[] { true, false }); Admin.EventExportPBRValues += new Action <AdminTS_KomDisp.MSExcelIOExportPBRValues.EventResultArgs> (admin_onEventExportPBRValues); }
protected override void createAdmin() { // 04.04.2018 KhryapinAN - Π½Π΅ΠΎΠ±Ρ ΠΎΠ΄ΠΈΠΌΠΎΡΡΡ ΠΏΠΎΠ»Π΅ΠΉ ΡΠ²ΡΠ·Π°Π½Π° Ρ Π²ΠΎΠ·ΠΌΠΎΠΆΠ½ΡΠΌ Π² Π΄Π°Π»ΡΠ½Π΅ΠΉΡΠ΅ΠΌ ΡΠΎΠ·Π΄Π°Π½ΠΈΡ ΡΠΎΠΎΡΠ²Π΅ΡΡΠ²ΡΡΡΠΈΡ ΠΏΠ°ΡΠ°ΠΌΠ΅ΡΡΠΎΠ² ΠΊΠΎΠ½ΡΠΈΠ³ΡΡΠ°ΡΠΈΠΈ (Π΄Π»Ρ ΠΏΡΠΎΡΠΈΠ»Ρ Π³ΡΡΠΏΠΏΡ/ΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°ΡΠ΅Π»Ρ) AllowUserImportAdminValuesDefault = AllowUserImportCSVPBRValues = HStatisticUsers.RoleIsKomDisp || HStatisticUsers.RoleIsAdmin; EnabledExportPBRValues = (HStatisticUsers.IsAllowed((int)HStatisticUsers.ID_ALLOWED.EXPORT_PBRVALUES_KOMDISP)); //??? ΡΠΎΠΆΠ΅ ΡΠ»Π΅Π΄ΡΠ΅Ρ ΡΠΈΡΠ°ΡΡ ΠΈΠ· ΠΠ ΠΊΠΎΠ½ΡΠΈΠ³ΡΡΠ°ΡΠΈΠΈ AdminTS_KomDisp.ModeDefaultExportPBRValues = AdminTS_KomDisp.MODE_EXPORT_PBRVALUES.MANUAL; AllowUserSetModeExportPBRValues = true & EnabledExportPBRValues; AllowUserChangeSheduleStartExportPBRValues = false & EnabledExportPBRValues; AllowUserChangeShedulePeriodExportPBRValues = false & EnabledExportPBRValues; //??? ΡΠΎΠΆΠ΅ ΡΠ»Π΅Π΄ΡΠ΅Ρ ΡΠΈΡΠ°ΡΡ ΠΈΠ· ΠΠ ΠΊΠΎΠ½ΡΠΈΠ³ΡΡΠ°ΡΠΈΠΈ AdminTS_KomDisp.ConstantExportPBRValues.MaskDocument = @"ΠΠΠ -Π€Π°ΠΊΡ-Π‘ΡΠ°ΡΠΈΡΡΠΈΠΊΠ°"; AdminTS_KomDisp.ConstantExportPBRValues.MaskExtension = @"xlsx"; AdminTS_KomDisp.ConstantExportPBRValues.NumberRow_0 = 7; AdminTS_KomDisp.ConstantExportPBRValues.Format_Date = "dd.MM.yyyy HH:mm"; AdminTS_KomDisp.ConstantExportPBRValues.NumberColumn_Date = 1; AdminTS_KomDisp.ConstantExportPBRValues.NumberRow_Date = 5; if ((Equals(FormMain.formParameters, null) == false) && (Equals(FormMain.formParameters.m_arParametrSetup, null) == false) && (FormMain.formParameters.m_arParametrSetup.Count > 0)) { AdminTS_KomDisp.SEC_SHEDULE_START_EXPORT_PBR = int.Parse(FormMain.formParameters.m_arParametrSetup [(int)FormParameters.PARAMETR_SETUP.KOMDISP_SHEDULE_START_EXPORT_PBR]); AdminTS_KomDisp.SEC_SHEDULE_PERIOD_EXPORT_PBR = int.Parse(FormMain.formParameters.m_arParametrSetup [(int)FormParameters.PARAMETR_SETUP.KOMDISP_SHEDULE_PERIOD_EXPORT_PBR]); //AdminTS_KomDisp.MS_WAIT_EXPORT_PBR_MAX = 6666; ΡΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½ ΠΏΡΠΈ ΠΎΠ±ΡΡΠ²Π»Π΅Π½ΠΈΠΈ/ΠΎΠΏΡΠ΅Π΄Π΅Π»Π΅Π½ΠΈΠΈ //AdminTS_KomDisp.MS_WAIT_EXPORT_PBR_ABORT = 666; ΡΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½ ΠΏΡΠΈ ΠΎΠ±ΡΡΠ²Π»Π΅Π½ΠΈΠΈ/ΠΎΠΏΡΠ΅Π΄Π΅Π»Π΅Π½ΠΈΠΈ AdminTS_KomDisp.Folder_CSV = FormMain.formParameters.m_arParametrSetup [(int)FormParameters.PARAMETR_SETUP.KOMDISP_FOLDER_CSV]; //@"\\ne2844\2.X.X\ΠΠΠ -csv"; //@"E:\Temp\ΠΠΠ -csv"; } else { ; } //ΠΠΎΠ·ΠΌΠΎΠΆΠ½ΠΎΡΡΡ ΡΠ΅Π΄Π°ΠΊΡΠΈΡΠΎΠ²Π°Π½ΠΈΡ Π·Π½Π°ΡΠ΅Π½ΠΈΠΉ ΠΠΠ : ΡΠ°Π·ΡΠ΅ΡΠ΅Π½ΠΎ ΡΠΏΡΠ°Π²Π»Π΅Π½ΠΈΠ΅ (ΠΈΠ·ΠΌΠ΅Π½Π΅Π½ΠΈΠ΅ ΡΠ°Π·ΡΠ΅ΡΠ΅Π½ΠΈΡ Π½Π° Π·Π°ΠΏΠΈΡΡ), Π·Π°ΠΏΠΈΡΡ ΠΠ ΡΠ°Π·ΡΠ΅ΡΠ΅Π½Π° m_admin = new AdminTS_KomDisp(new bool[] { true, false }); Admin.EventExportPBRValues += new Action <AdminTS_KomDisp.MSExcelIOExportPBRValues.EventResultArgs> (admin_onEventExportPBRValues); }
private void btnImportCSV_PBRValues_Click(object sender, EventArgs e) { int err = -1; // ΠΏΡΠΈΠ·Π½Π°ΠΊ ΠΎΡΠΈΠ±ΠΊΠΈ ΠΏΡΠΈ ΠΎΠΏΡΠ΅Π΄Π΅Π»Π΅Π½ΠΈΠΈ Π½ΠΎΠΌΠ΅ΡΠ° ΠΠΠ //ΠΠ°ΡΠΈΠ°Π½Ρ β1 (ΠΊΠ°ΡΠ°Π»ΠΎΠ³) //FolderBrowserDialog folders = new FolderBrowserDialog(); //folders.ShowNewFolderButton = false; //folders.RootFolder = Environment.SpecialFolder.Desktop; //folders.SelectedPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); //@"D:\Temp"; //if (folders.ShowDialog(FormMain.formParameters) == DialogResult.OK) // ((AdminTS_KomDisp)m_admin).ImpPPBRCSVValues(mcldrDate.SelectionStart, folders.SelectedPath + @"\"); //else // ; //ΠΠ°ΡΠΈΠ°Π½Ρ β2 (ΡΠ°ΠΉΠ») OpenFileDialog files = new OpenFileDialog(); files.Multiselect = false; //files.InitialDirectory = Environment.GetFolderPath (Environment.SpecialFolder.Desktop); files.InitialDirectory = AdminTS_KomDisp.Folder_CSV; files.DefaultExt = @"csv"; files.Filter = @"csv ΡΠ°ΠΉΠ»Ρ (*.csv)|*.csv"; files.Title = "ΠΡΠ±Π΅ΡΠΈΡΠ΅ ΡΠ°ΠΉΠ» Ρ ΠΠΠ ..."; if (files.ShowDialog(FormMain.formParameters) == DialogResult.OK) { Logging.Logg().Action(string.Format(@"PanelAdminKomDisp::btnImportCSV_PBRValues_Click () - Π²ΡΠ±ΡΠ°Π½ CSV-ΠΌΠ°ΠΊΠ΅Ρ {0}...", files.FileName), Logging.INDEX_MESSAGE.NOT_SET); int iRes = 0 , curPBRNumber = m_admin.GetPBRNumber(out err); //Π’Π΅ΠΊΡΡΠΈΠΉ Π½ΠΎΠΌΠ΅Ρ ΠΠΠ //ΠΠ°ΡΠ° ΠΠΠ , Π½ΠΎΠΌΠ΅Ρ ΠΠΠ ΠΈΠ· Π½Π°ΠΈΠΌΠ΅Π½ΠΎΠ²Π°Π½ΠΈΡ ΡΠ°ΠΉΠ»Π° object[] prop = AdminTS_KomDisp.GetPropertiesOfNameFilePPBRCSVValues(files.FileName); //if (!((DateTime)prop[0] == DateTime.Now.Date)) if (!(((DateTime)prop[0]).CompareTo(m_admin.m_curDate.Date) == 0)) { iRes = -1; } else //Π‘ΡΠ°Π²Π½ΠΈΡΡ Ρ ΡΠ΅ΠΊΡΡΠΈΠΌ Π½ΠΎΠΌΠ΅ΡΠΎΠΌ ΠΠΠ // , Π½ΠΎΠΌΠ΅Ρ ΠΠΠ ΠΏΠΎ ΡΠΌΠΎΠ»ΡΠ°Π½ΠΈΡ Π½Π΅ ΡΠ°ΡΡΠΌΠ°ΡΡΠΈΠ²Π°Π΅ΡΡΡ (err == 0) if ((!((int)prop[1] > curPBRNumber)) && (err == 0)) { iRes = -2; } else { ; //iRes = 0 } //ΠΡΠΎΠ²Π΅ΡΠΊΠ° Π½Π° ΠΎΡΠΈΠ±ΠΊΠΈ if (!(iRes == 0)) { string strMsg = string.Empty; //ΠΡΠΈΠ±ΠΊΠ° ΠΏΠΎ Π΄Π°ΡΠ΅ if (iRes == -1) { strMsg = string.Format(@"ΠΠ°ΡΠ° Π·Π°Π³ΡΡΠΆΠ°Π΅ΠΌΠΎΠ³ΠΎ [{0:dd.MM.yyyy}] Π½Π°Π±ΠΎΡΠ° ΠΠΠ Π½Π΅ ΡΠΎΠΎΡΠ²Π΅ΡΡΡΠ²ΡΠ΅Ρ ΡΡΡΠ°Π½ΠΎΠ²Π»./Π΄Π°ΡΠ΅ [{1:dd.MM.yyyy}]" , ((DateTime)prop[0]), m_admin.m_curDate.Date); MessageBox.Show(this, strMsg, @"ΠΠ½ΡΠΎΡΠΌΠ°ΡΠΈΡ", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { //ΠΡΠΈΠ±ΠΊΠ° ΠΏΠΎ Π½ΠΎΠΌΠ΅ΡΡ ΠΠΠ if (iRes == -2) { strMsg = string.Format(@"ΠΠΎΠΌΠ΅Ρ Π·Π°Π³ΡΡΠΆΠ°Π΅ΠΌΠΎΠ³ΠΎ Π½Π°Π±ΠΎΡΠ° [{0}] ΠΠΠ Π½Π΅ Π²ΡΡΠ΅, ΡΠ΅ΠΌ ΡΠ΅ΠΊΡΡΠΈΠΉ [{1}].{2}ΠΡΠΎΠ΄ΠΎΠ»ΠΆΠΈΡΡ?", (int)prop[1], curPBRNumber, Environment.NewLine); if (MessageBox.Show(this, strMsg, @"ΠΠΎΠ΄ΡΠ²Π΅ΡΠΆΠ΄Π΅Π½ΠΈΠ΅", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { iRes = 0; } else { ; } } else { ; } } } else { ; } //ΠΡΠ΅ ΠΎΠ΄Π½Π° ΠΏΡΠΎΠ²Π΅ΡΠΊΠ° Π½Π° ΠΎΡΠΈΠ±ΠΊΠΈ (Ρ.ΠΊ. Π±ΡΠ»Π° Π²ΠΎΠ·ΠΌΠΎΠΆΠ½ΠΎΡΡΡ Π΅Π΅ ΠΏΠΎΠ΄ΡΠ²Π΅ΡΠ΄ΠΈΡΡ) if (iRes == 0) { ((AdminTS_KomDisp)m_admin).ImpCSVValues(mcldrDate.SelectionStart, files.FileName); } else { Logging.Logg().Action(string.Format(@"PanelAdminKomDisp::btnImportCSV_PBRValues_Click () - ΠΎΡΠΌΠ΅Π½Π° ΠΈΠΌΠΏΠΎΡΡΠ° Π·Π½Π°ΡΠ΅Π½ΠΈΠΉ CSV-ΠΌΠ°ΠΊΠ΅ΡΠ°, ΠΎΡΠΈΠ±ΠΊΠ°={0}...", iRes), Logging.INDEX_MESSAGE.NOT_SET); } } else { Logging.Logg().Action(string.Format(@"PanelAdminKomDisp::btnImportCSV_PBRValues_Click () - ΠΎΡΠΌΠ΅Π½Π° Π²ΡΠ±ΠΎΡΠ° CSV-ΠΌΠ°ΠΊΠ΅ΡΠ°..."), Logging.INDEX_MESSAGE.NOT_SET); } }
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; // ΠΎΠΏΡΠ΅Π΄Π΅Π»ΠΈΡΡ ΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°ΡΠ΅Π»Ρ ΠΏΠΎ 1-ΠΎΠΉ ΠΠ ΠΊΠΎΠ½ΡΠΈΠ³ΡΡΠ°ΡΠΈΠΈ idListener = DbSources.Sources().Register(s_listFormConnectionSettings[(int)StatisticCommon.CONN_SETT_TYPE.CONFIG_DB].getConnSett(0), false, @"CONFIG_DB"); try { using (HStatisticUsers users = new HStatisticUsers(idListener, HUsers.MODE_REGISTRATION.MIXED)) {; } } catch (Exception e) { Logging.Logg().Exception(e, "FormMainTransGTP::FormMainTransGTP ()", Logging.INDEX_MESSAGE.NOT_SET); } //ΠΠ½ΠΈΡΠΈΠ°Π»ΠΈΠ·Π°ΡΠΈΡ ΠΎΠ±ΡΠ΅ΠΊΡΠΎΠ² ΠΏΠΎΠ»ΡΡΠ΅Π½ΠΈΡ Π΄Π°Π½Π½ΡΡ 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, new int[] { 0, (int)TECComponent.ID.GTP }); 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 { ; } } 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 { ; } }
private void btnImportCSV_PBRValues_Click(object sender, EventArgs e) { //ΠΠ°ΡΠΈΠ°Π½Ρ β1 (ΠΊΠ°ΡΠ°Π»ΠΎΠ³) //FolderBrowserDialog folders = new FolderBrowserDialog(); //folders.ShowNewFolderButton = false; //folders.RootFolder = Environment.SpecialFolder.Desktop; //folders.SelectedPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); //@"D:\Temp"; //if (folders.ShowDialog(FormMain.formParameters) == DialogResult.OK) // ((AdminTS_KomDisp)m_admin).ImpPPBRCSVValues(mcldrDate.SelectionStart, folders.SelectedPath + @"\"); //else // ; //ΠΠ°ΡΠΈΠ°Π½Ρ β2 (ΡΠ°ΠΉΠ») OpenFileDialog files = new OpenFileDialog(); files.Multiselect = false; //files.InitialDirectory = Environment.GetFolderPath (Environment.SpecialFolder.Desktop); files.InitialDirectory = FormMain.formParameters.m_arParametrSetup [(int)FormParameters.PARAMETR_SETUP.KOMDISP_FOLDER_CSV]; //@"\\ne2844\2.X.X\ΠΠΠ -csv"; //@"E:\Temp\ΠΠΠ -csv"; files.DefaultExt = @"csv"; files.Filter = @"csv ΡΠ°ΠΉΠ»Ρ (*.csv)|*.csv"; files.Title = "ΠΡΠ±Π΅ΡΠΈΡΠ΅ ΡΠ°ΠΉΠ» Ρ ΠΠΠ ..."; if (files.ShowDialog(FormMain.formParameters) == DialogResult.OK) { int iRes = 0 , curPBRNumber = m_admin.GetPBRNumber(); //Π’Π΅ΠΊΡΡΠΈΠΉ Π½ΠΎΠΌΠ΅Ρ ΠΠΠ //ΠΠ°ΡΠ° ΠΠΠ , Π½ΠΎΠΌΠ΅Ρ ΠΠΠ ΠΈΠ· Π½Π°ΠΈΠΌΠ΅Π½ΠΎΠ²Π°Π½ΠΈΡ ΡΠ°ΠΉΠ»Π° object[] prop = AdminTS_KomDisp.GetPropertiesOfNameFilePPBRCSVValues(files.FileName); //if (!((DateTime)prop[0] == DateTime.Now.Date)) if (!((DateTime)prop[0] == m_admin.m_curDate.Date)) { iRes = -1; } else { //Π‘ΡΠ°Π²Π½ΠΈΡΡ Ρ ΡΠ΅ΠΊΡΡΠΈΠΌ Π½ΠΎΠΌΠ΅ΡΠΎΠΌ ΠΠΠ if (!((int)prop[1] > curPBRNumber)) { iRes = -2; } else { ; //iRes = 0 } } //ΠΡΠΎΠ²Π΅ΡΠΊΠ° Π½Π° ΠΎΡΠΈΠ±ΠΊΠΈ if (!(iRes == 0)) { string strMsg = string.Empty; //ΠΡΠΈΠ±ΠΊΠ° ΠΏΠΎ Π΄Π°ΡΠ΅ if (iRes == -1) { strMsg = string.Format(@"ΠΠ°ΡΠ° Π·Π°Π³ΡΡΠΆΠ°Π΅ΠΌΠΎΠ³ΠΎ [{0:dd.MM.yyyy}] Π½Π°Π±ΠΎΡΠ° ΠΠΠ Π½Π΅ ΡΠΎΠΎΡΠ²Π΅ΡΡΡΠ²ΡΠ΅Ρ ΡΡΡΠ°Π½ΠΎΠ²Π»./Π΄Π°ΡΠ΅ [{1:dd.MM.yyyy}]" , ((DateTime)prop[0]), m_admin.m_curDate.Date); MessageBox.Show(this, strMsg, @"ΠΠ½ΡΠΎΡΠΌΠ°ΡΠΈΡ", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { //ΠΡΠΈΠ±ΠΊΠ° ΠΏΠΎ Π½ΠΎΠΌΠ΅ΡΡ ΠΠΠ if (iRes == -2) { strMsg = string.Format(@"ΠΠΎΠΌΠ΅Ρ Π·Π°Π³ΡΡΠΆΠ°Π΅ΠΌΠΎΠ³ΠΎ Π½Π°Π±ΠΎΡΠ° [{0}] ΠΠΠ Π½Π΅ Π²ΡΡΠ΅, ΡΠ΅ΠΌ ΡΠ΅ΠΊΡΡΠΈΠΉ [{1}].{2}ΠΡΠΎΠ΄ΠΎΠ»ΠΆΠΈΡΡ?", (int)prop[1], curPBRNumber, Environment.NewLine); if (MessageBox.Show(this, strMsg, @"ΠΠΎΠ΄ΡΠ²Π΅ΡΠΆΠ΄Π΅Π½ΠΈΠ΅", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { iRes = 0; } else { ; } } else { ; } } } else { ; } //ΠΡΠ΅ ΠΎΠ΄Π½Π° ΠΏΡΠΎΠ²Π΅ΡΠΊΠ° Π½Π° ΠΎΡΠΈΠ±ΠΊΠΈ (Ρ.ΠΊ. Π±ΡΠ»Π° Π²ΠΎΠ·ΠΌΠΎΠΆΠ½ΠΎΡΡΡ Π΅Π΅ ΠΏΠΎΠ΄ΡΠ²Π΅ΡΠ΄ΠΈΡΡ) if (iRes == 0) { ((AdminTS_KomDisp)m_admin).ImpCSVValues(mcldrDate.SelectionStart, files.FileName); } else { ; } } else { ; } }
protected override void Start() { int i = -1; EditFormConnectionSettings("connsett_gtp.ini", true); bool bIgnoreDateTime = false; if (Boolean.TryParse(FileAppSettings.This().GetValue(@"ΠΠ³Π½ΠΎΡΠΠ°ΡΠ°ΠΡΠ΅ΠΌΡ-techsite"), out bIgnoreDateTime) == false) { bIgnoreDateTime = false; } else { ; } ASUTP.Core.HMark markQueries = new ASUTP.Core.HMark(0); markQueries.Set((int)StatisticCommon.CONN_SETT_TYPE.PBR, ΠΠΏΡΠΎΡΠΠΠΠ ToolStripMenuItem.Checked); markQueries.Set((int)StatisticCommon.CONN_SETT_TYPE.ADMIN, ΠΠΏΡΠΎΡΠΠ΄ΠΌΠΈΠ½ΠΠ½Π°ΡΠ΅Π½ΠΈΡToolStripMenuItem.Checked); // ΠΎΠΏΡΠ΅Π΄Π΅Π»ΠΈΡΡ ΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°ΡΠ΅Π»Ρ ΠΏΠΎ 1-ΠΎΠΉ ΠΠ ΠΊΠΎΠ½ΡΠΈΠ³ΡΡΠ°ΡΠΈΠΈ DbTSQLConfigDatabase.DbConfig().Register(); try { using (HStatisticUsers users = new HStatisticUsers(DbTSQLConfigDatabase.DbConfig().ListenerId, ASUTP.Helper.HUsers.MODE_REGISTRATION.MIXED)) {; } } catch (Exception e) { Logging.Logg().Exception(e, "FormMainTransGTP::Start () - HStatisticUser initialize...", Logging.INDEX_MESSAGE.NOT_SET); } //ΠΠ½ΠΈΡΠΈΠ°Π»ΠΈΠ·Π°ΡΠΈΡ ΠΎΠ±ΡΠ΅ΠΊΡΠΎΠ² ΠΏΠΎΠ»ΡΡΠ΅Π½ΠΈΡ Π΄Π°Π½Π½ΡΡ 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 }); try { //((AdminTS_KomDisp)m_arAdmin[i]).InitTEC(m_formConnectionSettingsConfigDB.getConnSett((Int16)CONN_SETT_TYPE.DEST), m_modeTECComponent, true, false); m_arAdmin[i].InitTEC(m_modeTECComponent, /*arTypeConfigDB[i], */ markQueries, true, new int[] { 0, (int)TECComponent.ID.GTP }); 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 = FileAppSettings.This().GetValue(@"Π’ΠΠ¦ΠΠ°ΡΠ°ΠΌΠ΅ΡΡΡΠΠ°Π·Π½Π°ΡΠ΅Π½ΠΈΠ΅"); 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 { ; } } 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(); DbTSQLConfigDatabase.DbConfig().UnRegister(); switch ((CONN_SETT_TYPE)i) { case CONN_SETT_TYPE.SOURCE: // 1-ΡΠΉ ΠΈΡΡΠΎΡΠ½ΠΈΠΊ ΠΈΠ½ΠΈΡΠΈΠ°Π»ΠΈΠ·ΠΈΡΠΎΠ²Π°Π»ΠΈ, ΠΏΠΎΠ΄ΠΊΠ»ΡΡΠ°Π΅ΠΌ ΠΠ ΠΊΠΎΠ½ΡΠΈΠ³ΡΡΠ°ΡΠΈΠΈ 2-Π³ΠΎ ΠΈΡΡΠΎΡΠ½ΠΈΠΊΠ°(Π½Π°Π·Π½Π°ΡΠ΅Π½ΠΈΠ΅) DbTSQLConfigDatabase.DbConfig().SetConnectionSettings(s_listFormConnectionSettings [(int)StatisticCommon.CONN_SETT_TYPE.CONFIG_DB].getConnSett(i + 1)); DbTSQLConfigDatabase.DbConfig().Register(); break; case CONN_SETT_TYPE.DEST: //??? Π²ΠΎΡΡΡΠ°Π½ΠΎΠ²ΠΈΡΡ ΠΈΡΡ ΠΎΠ΄Π½ΡΠΉ ΠΈΡΡΠΎΡΠ½ΠΈΠΊ Π΄Π°Π½Π½ΡΡ break; } } if (!(i < (Int16)CONN_SETT_TYPE.COUNT_CONN_SETT_TYPE)) { start(); } else { ; } }