internal static void WriteErrorInfo(Exception ex) { try { PSA.Lib.Util.Settings prop = new PSA.Lib.Util.Settings(); StringBuilder sb = new StringBuilder(); sb.AppendFormat("{0}\r\n\r\n", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString()); sb.AppendFormat("- Информация об ошибке\r\n"); sb.AppendFormat("Основная информация об ошибке: {0}\r\n", ex.Message); sb.AppendFormat("Произошла ошибка типа {0}\r\n", ex.GetType()); sb.AppendFormat("Объект вызвавший ошибку: {0}\r\n", ex.Source); sb.AppendFormat("Ошибка произошла в методе {0}\r\n", ex.TargetSite); sb.AppendFormat("Стек вызова: \r\n{0}\r\n\r\n", ex.StackTrace); sb.AppendFormat("- Соединение с базой данных\r\n"); sb.AppendFormat("Строка подключения: {0}\r\n", prop.Connection_string); try { sb.AppendFormat("Попытка подключения: {0:MM/dd/yyy hh:mm:ss.fff}\r\n", DateTime.Now); SqlConnection c = new SqlConnection(prop.Connection_string); c.Open(); sb.AppendFormat("Соединение установлено: {0:MM/dd/yyy hh:mm:ss.fff}\r\n", DateTime.Now); c.Close(); } catch (Exception exx) { ErrorNfo.WriteErrorInfo(exx); sb.AppendFormat("Произошла ошибка: {0:MM/dd/yyy hh:mm:ss.fff}\r\n", DateTime.Now); sb.AppendFormat("Описание ошибки: {0}", exx.Message); } finally { sb.AppendFormat("\r\n"); } sb.AppendFormat("- Дополнительная информация\r\n"); sb.AppendFormat("Machine name: {0}\r\n", Environment.MachineName); sb.AppendFormat("OS Version: {0}\r\n", Environment.OSVersion); sb.AppendFormat("Processor count: {0}\r\n", Environment.ProcessorCount); sb.AppendFormat("User domain name: {0}\r\n", Environment.UserDomainName); sb.AppendFormat("User name: {0}\r\n", Environment.UserName); sb.AppendFormat("User interactive: {0}\r\n", Environment.UserInteractive); sb.AppendFormat("dotNet version: {0}\r\n\r\n", Environment.Version); sb.AppendFormat(""); StreamWriter sr = new StreamWriter(prop.Dir_export + "\\er_" + DateTime.Now.Year.ToString("D4") + "-" + DateTime.Now.Month.ToString("D2") + "-" + DateTime.Now.Day.ToString("D2") + ".info", true, Encoding.GetEncoding(1251)); sr.Write(sb); sr.Close(); } catch { } }
public string NewOrderNum(SqlConnection db_connection, UserInfo usr) { PSA.Lib.Util.Settings prop = new PSA.Lib.Util.Settings(); /* SqlCommand db_command = new SqlCommand("SELECT [order_num] FROM [vwLastOrderNum]", db_connection); SqlDataReader db_reader = db_command.ExecuteReader(); long lastno = 0; if (db_reader.Read()) { if (!db_reader.IsDBNull(0)) lastno = db_reader.GetInt64(0); else lastno = 0; } else { lastno = 0; } db_reader.Close(); lastno++; */ SqlCommand db_command = new SqlCommand(); db_command.CommandText = "DECLARE @last int; INSERT INTO [dbo].[ordernum] ([del], [guid], [date], [usr], [used]) VALUES (0, newid(), getdate(), '', 1); SET @last = scope_identity(); SELECT @last;"; db_command.Connection = db_connection; long lastno = int.Parse(prop.Order_prefics) * 10000000000 + (int)db_command.ExecuteScalar(); if (lastno.ToString().Length < 12) { string t = lastno.ToString(); string o = ""; for (int i = 0; i < (12 - t.Length); i++) { o += "0"; } return o + t; } else { return lastno.ToString(); } }
// Сохраняем из визарда текстовое описание public bool SaveEasyTextFile() { try { PSA.Lib.Util.Settings prop = new PSA.Lib.Util.Settings(); string path = prop.Dir_print + "\\" + fso.GetDateSubFolders() + "\\" + Orderno + "\\" + Orderno + ".txt"; if (!File.Exists(path)) { using (FileStream fs = File.Create(path)) { } using (StreamWriter fs = new StreamWriter(path, true, System.Text.Encoding.GetEncoding(1251))) { fs.WriteLine("! Заказ № " + Orderno); fs.WriteLine("# Печать"); List<string> Files = fso.GetListFilesForProc(prop.Dir_print + "\\" + fso.GetDateSubFolders() + "\\" + Orderno + "\\", prop.List_of_files, true, true); if (Files.Count > 0) { foreach (string f in Files) { fs.WriteLine("+ Файл -> " + f); } } else { fs.WriteLine("; Файлов не обнаружено!"); } } } path = prop.Dir_edit + "\\" + fso.GetDateSubFolders() + "\\" + Orderno + "\\" + Orderno + ".txt"; if (!File.Exists(path)) { using (FileStream fs = File.Create(path)) { } using (StreamWriter fs = new StreamWriter(path, true, System.Text.Encoding.GetEncoding(1251))) { fs.WriteLine("! " + Orderno); fs.WriteLine("# Обработка"); List<string> Files = fso.GetListFilesForProc(prop.Dir_edit + "\\" + fso.GetDateSubFolders() + "\\" + Orderno + "\\", prop.List_of_files, true, true); if (Files.Count > 0) { foreach (string f in Files) { fs.WriteLine("+ Файл -> " + f); } } else { fs.WriteLine("; Файлов не обнаружено!"); } } } return true; } catch (Exception ex) { ErrorNfo.WriteErrorInfo(ex); _err = ex.Message + " " + ex.Source + " " + ex.StackTrace; return false; } }
// Сохраняем из визарда текстовое описание public bool SaveAdvTextFile() { try { PSA.Lib.Util.Settings prop = new PSA.Lib.Util.Settings(); string path = prop.Dir_print + "\\" + fso.GetDateSubFolders() + "\\" + Orderno + "\\" + Orderno + ".txt"; if (!File.Exists(path)) { using (FileStream fs = File.Create(path)) { } using (StreamWriter fs = new StreamWriter(path, true, System.Text.Encoding.GetEncoding(1251))) { fs.WriteLine("! Заказ № " + Orderno); fs.WriteLine("# Печать"); fs.WriteLine("% " + Comment); // гуляем по строкам таблицы for (int i = 0; i < OrderBody.Rows.Count; i++) { // Если в 8-ой колонке на выставлена истина, значит эта // строка добавлена автоматически в результате сканирования папок if (!(bool)OrderBody.Rows[i][8]) { fs.WriteLine(": Услуга: " + OrderBody.Rows[i][6].ToString().Trim() + " [Количество " + OrderBody.Rows[i][2].ToString() + "] " + OrderBody.Rows[i]["comment"].ToString()); List<string> Files = fso.GetListFilesForProc(prop.Dir_print + "\\" + fso.GetDateSubFolders() + "\\" + Orderno + "\\" + OrderBody.Rows[i][6].ToString().Trim() + "\\", prop.List_of_files, true, true); if (Files.Count > 0) { foreach (string f in Files) { fs.WriteLine("+ Файл -> " + f); } } else { fs.WriteLine("; Файлов не обнаружено!"); } } else { // Если код услуги есть (а он по любому должен быть) if (OrderBody.Rows[i][5].ToString() != "") { // Запрашиваем тип услуги SqlCommand tmp_cmd = new SqlCommand("SELECT RTRIM([type]) as [type] FROM [vwGoodFull] WHERE [id_good] = '" + OrderBody.Rows[i][5].ToString() + "'", db_connection); SqlDataReader tmp_rdr = tmp_cmd.ExecuteReader(); if (tmp_rdr.Read()) { // Если это для печати (1) if (tmp_rdr.GetString(0) == "1") { fs.WriteLine("= Услуга: " + OrderBody.Rows[i][1].ToString().Trim() + " [Количество " + OrderBody.Rows[i][2].ToString() + "] " + OrderBody.Rows[i]["comment"].ToString()); List<string> Files = (List<string>)OrderBody.Rows[i][9]; if (Files.Count > 0) { foreach (string f in Files) { fs.WriteLine("+ Файл -> " + f); } } else { fs.WriteLine("; Файлов не обнаружено!"); } } } tmp_rdr.Close(); } } } } } path = prop.Dir_edit + "\\" + fso.GetDateSubFolders() + "\\" + Orderno + "\\" + Orderno + ".txt"; if (!File.Exists(path)) { using (FileStream fs = File.Create(path)) { } using (StreamWriter fs = new StreamWriter(path, true, System.Text.Encoding.GetEncoding(1251))) { fs.WriteLine("! Заказ № " + Orderno); fs.WriteLine("# Обработка"); fs.WriteLine("% " + Comment); // гуляем по строкам таблицы for (int i = 0; i < OrderBody.Rows.Count; i++) { // Если в 8-ой колонке на выставлена истина, значит эта // строка добавлена автоматически в результате сканирования папок if (!(bool)OrderBody.Rows[i][8]) { fs.WriteLine(": Услуга: " + OrderBody.Rows[i][6].ToString().Trim() + " [Количество " + OrderBody.Rows[i][2].ToString() + "] " + OrderBody.Rows[i]["comment"].ToString()); List<string> Files = fso.GetListFilesForProc(prop.Dir_edit + "\\" + fso.GetDateSubFolders() + "\\" + Orderno + "\\" + OrderBody.Rows[i][6].ToString().Trim() + "\\", prop.List_of_files, true, true); if (Files.Count > 0) { foreach (string f in Files) { fs.WriteLine("+ Файл -> " + f); } } else { fs.WriteLine("; Файлов не обнаружено!"); } } else { // Если код услуги есть (а он по любому должен быть) if (OrderBody.Rows[i][5].ToString() != "") { // Запрашиваем тип услуги SqlCommand tmp_cmd = new SqlCommand("SELECT RTRIM([type]) as [type] FROM [vwGoodFull] WHERE [id_good] = '" + OrderBody.Rows[i][5].ToString() + "'", db_connection); SqlDataReader tmp_rdr = tmp_cmd.ExecuteReader(); if (tmp_rdr.Read()) { // Если это не для печати (2) if (tmp_rdr.GetString(0) == "2") { fs.WriteLine("= Услуга: " + OrderBody.Rows[i][1].ToString().Trim() + " [Количество " + OrderBody.Rows[i][2].ToString() + "] " + OrderBody.Rows[i]["comment"].ToString()); List<string> Files = (List<string>)OrderBody.Rows[i][9]; if (Files.Count > 0) { foreach (string f in Files) { fs.WriteLine("+ Файл -> " + f); } } else { fs.WriteLine("; Файлов не обнаружено!"); } } } tmp_rdr.Close(); } } } } } return true; } catch (Exception ex) { ErrorNfo.WriteErrorInfo(ex); _err = ex.Message + " " + ex.Source + " " + ex.StackTrace; return false; } }
private void SaveProperties() { //Photoland.Security.Properties p = new Photoland.Security.Properties(); if((checkRemoteSetup.Checked) && (txtRemoteSetupPath.Text != "")) { PSA.Lib.Util.Semaphore.semRemoteSettings = txtRemoteSetupPath.Text; } else { PSA.Lib.Util.Semaphore.semRemoteSettings = ""; } p = new PSA.Lib.Util.Settings(); if (radioDSN.Checked == true) { p.Connection_type = "DSN"; p.Connection_string = "Dsn=" + txtDSN.Text + ";"; } if (radioConnectionString.Checked == true) { p.Connection_type = "ConnectionString"; p.Connection_string = "Data Source=" + txtSQLServer.Text + ";Initial Catalog=" + txtSQLBase.Text + ";Persist Security Info=True;User ID=" + txtSQLUser.Text + ";Password="******";"; } p.Db_dsn = txtDSN.Text; p.Db_server = txtSQLServer.Text; p.Db_user = txtSQLUser.Text; p.Db_password = txtSQLPassword.Text; p.Db_base = txtSQLBase.Text; if (checkRunOneCopyAcceptance.Checked) p.Run_one_copy_acceptance = true; else p.Run_one_copy_acceptance = false; if (checkRunOneCopyOperator.Checked) p.Run_one_copy_oprator = true; else p.Run_one_copy_oprator = false; if (checkRunOneCopyDesigner.Checked) p.Run_one_copy_designer = true; else p.Run_one_copy_designer = false; if (checkRunOneCopyAdmin.Checked) p.Run_one_copy_admin = true; else p.Run_one_copy_admin = false; p.Dir_print = txtDirPrint.Text; p.Dir_edit = txtDirEdit.Text; p.List_of_files = txtListOfFiles.Text; if (checkSearchSubDir.Checked) p.Search_SubDir = true; else p.Search_SubDir = false; p.Dir_rescan = int.Parse(txtDirRescan.Text); p.Time_for_output = int.Parse(txtTimeForOutput.Text); p.Time_begin_work = int.Parse(txtBeginWork.Text); p.Time_end_work = int.Parse(txtEndWork.Text); p.Order_prefics = txtOrderPrifics.Text; p.Qbtn01_id = lblQbtn1_id.Text; p.Qbtn02_id = lblQbtn2_id.Text; p.Qbtn03_id = lblQbtn3_id.Text; p.Qbtn04_id = lblQbtn4_id.Text; p.Qbtn05_id = lblQbtn5_id.Text; p.Qbtn06_id = lblQbtn6_id.Text; p.Qbtn07_id = lblQbtn7_id.Text; p.Qbtn08_id = lblQbtn8_id.Text; p.Qbtn09_id = lblQbtn9_id.Text; p.Qbtn10_id = lblQbtn10_id.Text; p.Qbtn01_text = txtQbtn1_string.Text; p.Qbtn02_text = txtQbtn2_string.Text; p.Qbtn03_text = txtQbtn3_string.Text; p.Qbtn04_text = txtQbtn4_string.Text; p.Qbtn05_text = txtQbtn5_string.Text; p.Qbtn06_text = txtQbtn6_string.Text; p.Qbtn07_text = txtQbtn7_string.Text; p.Qbtn08_text = txtQbtn8_string.Text; p.Qbtn09_text = txtQbtn9_string.Text; p.Qbtn10_text = txtQbtn10_string.Text; p.Qbtn01_stext = lblqbnts1.Text; p.Qbtn02_stext = lblqbnts2.Text; p.Qbtn03_stext = lblqbnts3.Text; p.Qbtn04_stext = lblqbnts4.Text; p.Qbtn05_stext = lblqbnts5.Text; p.Qbtn06_stext = lblqbnts6.Text; p.Qbtn07_stext = lblqbnts7.Text; p.Qbtn08_stext = lblqbnts8.Text; p.Qbtn09_stext = lblqbnts9.Text; p.Qbtn10_stext = lblqbnts10.Text; p.UpdatePaymentTable = int.Parse(txtUpdateTablePayment.Text); p.UpdateOrderTableInAcceptance = int.Parse(txtUpdateOrderTableInAcceptance.Text); p.PathReportsTemplates = txtReportFile.Text; if (checkColorRowsInOrderTable.Checked) p.Color_rows_in_order = true; else p.Color_rows_in_order = false; if (checkFlyWindowOperator.Checked) p.Fly_window_operator = true; else p.Fly_window_operator = false; if (checkModOperatorTopMost.Checked) p.Mod_operator_top_most = true; else p.Mod_operator_top_most = false; p.UpdateOrderTableInOperator = int.Parse(txtOrderListOperatorUpdate.Text); if (checkFlyWindowDesigner.Checked) p.Fly_window_designer = true; else p.Fly_window_designer = false; if (checkModDesignerTopMost.Checked) p.Mod_designer_top_most = true; else p.Mod_designer_top_most = false; p.UpdateOrderTableInDesigner = int.Parse(txtOrderListDesignerUpdate.Text); p.Dir_import = txtImport.Text; p.Dir_export = txtExport.Text; p.Dir_net_export = txtExportNet.Text; if (checkRobotIconAnimation.Checked) p.Robot_animation_icon = true; else p.Robot_animation_icon = false; if (checkRunOneCopyRobot.Checked) p.Run_one_copy_robot = true; else p.Run_one_copy_robot = false; p.SQL_Import_Template_DCard = txtSQLTemplateDCard.Text; p.SQL_Import_Template_Good = txtSQLTemplateGood.Text; p.SQL_Import_Template_Mashine = txtSQLTemplateMashine.Text; p.SQL_Import_Template_Material = txtSQLTemplateMaterial.Text; p.ReklamBlock1 = txtReklamBlock1.Text; if (checkCheckPreview.Checked) p.CheckPreview = true; else p.CheckPreview = false; p.CheckCount = int.Parse(txtCheckCount.Text); p.PasswordClass1 = txtPasswordClass1.Text; if (checkAutoSendCrashReport.Checked) p.AutoSendCrashReport = true; else p.AutoSendCrashReport = false; if (checkSMTPAut.Checked) p.SMTPAut = true; else p.SMTPAut = false; p.SMTPPasswordFrom = txtSMTPPassword.Text; p.SMTPServer = txtSMTPServer.Text; p.SMTPUserFrom = txtSMTPName.Text; p.SMTPUserFromEmail = txtSMTPFromEmail.Text; p.SMTPUserTo = txtSMTPToEmail.Text; p.FTP_Server = txtFTPServer.Text; p.FTP_Path = txtFTPPath.Text; p.FTP_User = txtFTPUser.Text; p.FTP_Password = txtFTPPassword.Text; p.FTP_Path_Export = txtFTPPathExport.Text; p.FTP_Server_Export = txtFTPServerExport.Text; p.Import_time = int.Parse(txtTimeImport.Text); p.Export_time = int.Parse(txtTimeExport.Text); if (checkFtpImport.Checked) p.Import_from_ftp = true; else p.Import_from_ftp = false; if (checkExportFP.Checked) p.Export_from_ftp = true; else p.Export_from_ftp = false; if (checkUseShortListGoods.Checked) p.ShortGoodsListInWizard = true; else p.ShortGoodsListInWizard = false; if (checkExportDoCopy.Checked) p.ExportDoCopy = true; else p.ExportDoCopy = false; if (checkClearAfterCopy.Checked) p.ExportClearDirAfterCopy = true; else p.ExportClearDirAfterCopy = false; p.ModelRound = int.Parse(txtSumRound.SelectedValue.ToString()); if (checkQueryDelete.Checked) p.QueryForDelete = true; else p.QueryForDelete = false; if (checkDenyDelete.Checked) p.DenyDelete = true; else p.DenyDelete = false; if (checkExportOld.Checked) p.ExportOld = true; else p.ExportOld = false; p.DCard_limit = int.Parse(txtDCardLimit.Text); p.PublicIni = txtPublicIni.Text; if (checkRunOneInventory.Checked) p.Run_one_copy_inventory = true; else p.Run_one_copy_inventory = false; p.Order_terminal_prefics = txtPrefixTerminal.Text; p.SemaphoreInventory = checkInventory.Checked; p.Dir_tmp_export = txtDirTmpExport.Text; p.Round3 = checkRound3.Checked; p.Terminal_client_one = checkTerminalClientOne.Checked; p.Terminal_print_check = checkTerminalPrintCheck.Checked; p.Terminal_control_worker = checkTerminalControlWorker.Checked; p.UseXmlCache = checkUseXmlCache.Checked; p.LoadNotApproved = checkLoadNotApproved.Checked; p.Load1000 = checkLoad1000.Checked; p.ShowQuickOrder = checkShowQuickOrder.Checked; p.DiscontServerAddress = txtDiscontServerAddress.Text; p.CheckString1 = txtCheckText1.Text; p.CheckString2 = txtCheckText2.Text; p.ShowMFoto = checkMFoto.Checked; p.MfotoAlbumsPath = txtDirMfoto.Text; p.ExportOld = checkExportOld.Checked; p.DontLockExported = checkDontLockExport.Checked; p.PublicKey = txtPublicKey.Text; p.PrivateKey = txtPrivateKey.Text; p.ApiRequestToken = txtApiRequestToken.Text; p.ApiAccessToken = txtApiAccessToken.Text; p.ApiOrder = txtApiOrder.Text; p.ApiOrderItems = txtApiOrderItems.Text; p.ApiProducts = txtApiProducts.Text; p.OrderPixlPark = txtOrderPixlPark.Text; p.Dir_auto_import = txtDirAutoImport.Text; p.ApiUser = txtApiUser.Text; p.AStatus = txtAStatus.Text; p.OStatus = txtOStatus.Text; p.DStatus = txtDStatus.Text; p.PrintAfterImport = checkPrintAfterImport.Checked; p.SelectImport = checkSelectImport.Checked; p.PixlParkClient = checkPixlParkClient.Checked; p.EmailDayReport = txtEmailDayReport.Text; p.EmailDayFrom = txtEmailDayFrom.Text; p.EmailDayAuth = txtEmailDayAuth.Text; p.EmailDayPas = txtEmailDayPas.Text; p.EmailDayHost = txtEmailDayHost.Text; p.EmailDayPort = int.Parse(txtEmailDayPort.Text); if(!p.Save()) MessageBox.Show("Ошибка при сохранении настроек!", "Настройки программы", MessageBoxButtons.OK, MessageBoxIcon.Warning); }
private void SaveProperties() { PSA.Lib.Util.Settings p = new PSA.Lib.Util.Settings(); if (radioDSN.Checked == true) { p.Connection_type = "DSN"; p.Connection_string = "Dsn=" + txtDSN.Text + ";"; } if (radioConnectionString.Checked == true) { p.Connection_type = "ConnectionString"; p.Connection_string = "Data Source=" + txtSQLServer.Text + ";Initial Catalog=" + txtSQLBase.Text + ";Persist Security Info=True;User ID=" + txtSQLUser.Text + ";Password="******";"; } p.Db_dsn = txtDSN.Text; p.Db_server = txtSQLServer.Text; p.Db_user = txtSQLUser.Text; p.Db_password = txtSQLPassword.Text; p.Db_base = txtSQLBase.Text; if (checkRunOneCopyAcceptance.Checked) p.Run_one_copy_acceptance = true; else p.Run_one_copy_acceptance = false; if (checkRunOneCopyOperator.Checked) p.Run_one_copy_oprator = true; else p.Run_one_copy_oprator = false; if (checkRunOneCopyDesigner.Checked) p.Run_one_copy_designer = true; else p.Run_one_copy_designer = false; if (checkRunOneCopyAdmin.Checked) p.Run_one_copy_admin = true; else p.Run_one_copy_admin = false; p.Dir_print = txtDirPrint.Text; p.Dir_edit = txtDirEdit.Text; p.List_of_files = txtListOfFiles.Text; if (checkSearchSubDir.Checked) p.Search_SubDir = true; else p.Search_SubDir = false; p.Dir_rescan = int.Parse(txtDirRescan.Text); p.Time_for_output = int.Parse(txtTimeForOutput.Text); p.Time_begin_work = int.Parse(txtBeginWork.Text); p.Time_end_work = int.Parse(txtEndWork.Text); p.Order_prefics = txtOrderPrifics.Text; p.Qbtn01_id = lblQbtn1_id.Text; p.Qbtn02_id = lblQbtn2_id.Text; p.Qbtn03_id = lblQbtn3_id.Text; p.Qbtn04_id = lblQbtn4_id.Text; p.Qbtn05_id = lblQbtn5_id.Text; p.Qbtn06_id = lblQbtn6_id.Text; p.Qbtn07_id = lblQbtn7_id.Text; p.Qbtn08_id = lblQbtn8_id.Text; p.Qbtn09_id = lblQbtn9_id.Text; p.Qbtn10_id = lblQbtn10_id.Text; p.Qbtn01_text = txtQbtn1_string.Text; p.Qbtn02_text = txtQbtn2_string.Text; p.Qbtn03_text = txtQbtn3_string.Text; p.Qbtn04_text = txtQbtn4_string.Text; p.Qbtn05_text = txtQbtn5_string.Text; p.Qbtn06_text = txtQbtn6_string.Text; p.Qbtn07_text = txtQbtn7_string.Text; p.Qbtn08_text = txtQbtn8_string.Text; p.Qbtn09_text = txtQbtn9_string.Text; p.Qbtn10_text = txtQbtn10_string.Text; p.Qbtn01_stext = lblqbnts1.Text; p.Qbtn02_stext = lblqbnts2.Text; p.Qbtn03_stext = lblqbnts3.Text; p.Qbtn04_stext = lblqbnts4.Text; p.Qbtn05_stext = lblqbnts5.Text; p.Qbtn06_stext = lblqbnts6.Text; p.Qbtn07_stext = lblqbnts7.Text; p.Qbtn08_stext = lblqbnts8.Text; p.Qbtn09_stext = lblqbnts9.Text; p.Qbtn10_stext = lblqbnts10.Text; p.UpdatePaymentTable = int.Parse(txtUpdateTablePayment.Text); p.UpdateOrderTableInAcceptance = int.Parse(txtUpdateOrderTableInAcceptance.Text); p.PathReportsTemplates = txtReportFile.Text; if (checkColorRowsInOrderTable.Checked) p.Color_rows_in_order = true; else p.Color_rows_in_order = false; if (checkFlyWindowOperator.Checked) p.Fly_window_operator = true; else p.Fly_window_operator = false; if (checkModOperatorTopMost.Checked) p.Mod_operator_top_most = true; else p.Mod_operator_top_most = false; p.UpdateOrderTableInOperator = int.Parse(txtOrderListOperatorUpdate.Text); if (checkFlyWindowDesigner.Checked) p.Fly_window_designer = true; else p.Fly_window_designer = false; if (checkModDesignerTopMost.Checked) p.Mod_designer_top_most = true; else p.Mod_designer_top_most = false; p.UpdateOrderTableInDesigner = int.Parse(txtOrderListDesignerUpdate.Text); p.Dir_import = txtImport.Text; p.Dir_export = txtExport.Text; if (checkRobotIconAnimation.Checked) p.Robot_animation_icon = true; else p.Robot_animation_icon = false; if (checkRunOneCopyRobot.Checked) p.Run_one_copy_robot = true; else p.Run_one_copy_robot = false; p.SQL_Import_Template_DCard = txtSQLTemplateDCard.Text; p.SQL_Import_Template_Good = txtSQLTemplateGood.Text; p.SQL_Import_Template_Mashine = txtSQLTemplateMashine.Text; p.SQL_Import_Template_Material = txtSQLTemplateMaterial.Text; p.ReklamBlock1 = txtReklamBlock1.Text; if (checkCheckPreview.Checked) p.CheckPreview = true; else p.CheckPreview = false; p.CheckCount = int.Parse(txtCheckCount.Text); p.PasswordClass1 = txtPasswordClass1.Text; if (checkAutoSendCrashReport.Checked) p.AutoSendCrashReport = true; else p.AutoSendCrashReport = false; if (checkSMTPAut.Checked) p.SMTPAut = true; else p.SMTPAut = false; p.SMTPPasswordFrom = txtSMTPPassword.Text; p.SMTPServer = txtSMTPServer.Text; p.SMTPUserFrom = txtSMTPName.Text; p.SMTPUserFromEmail = txtSMTPFromEmail.Text; p.SMTPUserTo = txtSMTPToEmail.Text; p.FTP_Server = txtFTPServer.Text; p.FTP_Path = txtFTPPath.Text; p.FTP_User = txtFTPUser.Text; p.FTP_Password = txtFTPPassword.Text; p.FTP_Path_Export = txtFTPPathExport.Text; p.FTP_Server_Export = txtFTPServerExport.Text; p.Import_time = int.Parse(txtTimeImport.Text); p.Export_time = int.Parse(txtTimeExport.Text); if (checkFtpImport.Checked) p.Import_from_ftp = true; else p.Import_from_ftp = false; if (checkExportFP.Checked) p.Export_from_ftp = true; else p.Export_from_ftp = false; if (checkUseShortListGoods.Checked) p.ShortGoodsListInWizard = true; else p.ShortGoodsListInWizard = false; if (checkExportDoCopy.Checked) p.ExportDoCopy = true; else p.ExportDoCopy = false; if (checkClearAfterCopy.Checked) p.ExportClearDirAfterCopy = true; else p.ExportClearDirAfterCopy = false; p.ModelRound = int.Parse(txtSumRound.SelectedValue.ToString()); if (checkQueryDelete.Checked) p.QueryForDelete = true; else p.QueryForDelete = false; if (checkDenyDelete.Checked) p.DenyDelete = true; else p.DenyDelete = false; p.DCard_limit = int.Parse(txtDCardLimit.Text); p.PublicIni = txtPublicIni.Text; p.Round3 = checkRound3.Checked; }
private void LoadProperties() { BildDSNList(); //Util.Settings p = new Util.Settings(); PSA.Lib.Util.Settings p = new PSA.Lib.Util.Settings(); if (p.Connection_type == "DSN") radioDSN.Checked = true; if (p.Connection_type == "ConnectionString") radioConnectionString.Checked = true; txtDSN.Text = p.Db_dsn; txtSQLServer.Text = p.Db_server; txtSQLUser.Text = p.Db_user; txtSQLPassword.Text = p.Db_password; txtSQLBase.Text = p.Db_base; if (p.Run_one_copy_acceptance) checkRunOneCopyAcceptance.Checked = true; else checkRunOneCopyAcceptance.Checked = false; if (p.Run_one_copy_oprator) checkRunOneCopyOperator.Checked = true; else checkRunOneCopyOperator.Checked = false; if (p.Run_one_copy_designer) checkRunOneCopyDesigner.Checked = true; else checkRunOneCopyDesigner.Checked = false; if (p.Run_one_copy_admin) checkRunOneCopyAdmin.Checked = true; else checkRunOneCopyAdmin.Checked = false; txtDirPrint.Text = p.Dir_print; txtDirEdit.Text = p.Dir_edit; txtListOfFiles.Text = p.List_of_files; if (p.Search_SubDir) checkSearchSubDir.Checked = true; else checkSearchSubDir.Checked = false; txtDirRescan.Text = p.Dir_rescan.ToString(); txtTimeForOutput.Text = p.Time_for_output.ToString(); txtBeginWork.Text = p.Time_begin_work.ToString(); txtEndWork.Text = p.Time_end_work.ToString(); txtOrderPrifics.Text = p.Order_prefics.ToString(); lblQbtn1_id.Text = p.Qbtn01_id.ToString(); lblQbtn2_id.Text = p.Qbtn02_id.ToString(); lblQbtn3_id.Text = p.Qbtn03_id.ToString(); lblQbtn4_id.Text = p.Qbtn04_id.ToString(); lblQbtn5_id.Text = p.Qbtn05_id.ToString(); lblQbtn6_id.Text = p.Qbtn06_id.ToString(); lblQbtn7_id.Text = p.Qbtn07_id.ToString(); lblQbtn8_id.Text = p.Qbtn08_id.ToString(); lblQbtn9_id.Text = p.Qbtn09_id.ToString(); lblQbtn10_id.Text = p.Qbtn10_id.ToString(); txtQbtn1_string.Text = p.Qbtn01_text; txtQbtn2_string.Text = p.Qbtn02_text; txtQbtn3_string.Text = p.Qbtn03_text; txtQbtn4_string.Text = p.Qbtn04_text; txtQbtn5_string.Text = p.Qbtn05_text; txtQbtn6_string.Text = p.Qbtn06_text; txtQbtn7_string.Text = p.Qbtn07_text; txtQbtn8_string.Text = p.Qbtn08_text; txtQbtn9_string.Text = p.Qbtn09_text; txtQbtn10_string.Text = p.Qbtn10_text; lblqbnts1.Text = p.Qbtn01_stext; lblqbnts2.Text = p.Qbtn02_stext; lblqbnts3.Text = p.Qbtn03_stext; lblqbnts4.Text = p.Qbtn04_stext; lblqbnts5.Text = p.Qbtn05_stext; lblqbnts6.Text = p.Qbtn06_stext; lblqbnts7.Text = p.Qbtn07_stext; lblqbnts8.Text = p.Qbtn08_stext; lblqbnts9.Text = p.Qbtn09_stext; lblqbnts10.Text = p.Qbtn10_stext; txtUpdateTablePayment.Text = p.UpdatePaymentTable.ToString(); txtUpdateOrderTableInAcceptance.Text = p.UpdateOrderTableInAcceptance.ToString(); txtReportFile.Text = p.PathReportsTemplates; if (p.Color_rows_in_order) checkColorRowsInOrderTable.Checked = true; else checkColorRowsInOrderTable.Checked = false; if (p.Fly_window_operator) checkFlyWindowOperator.Checked = true; else checkFlyWindowOperator.Checked = false; if (p.Mod_operator_top_most) checkModOperatorTopMost.Checked = true; else checkModOperatorTopMost.Checked = false; txtOrderListOperatorUpdate.Text = p.UpdateOrderTableInOperator.ToString(); if (p.Fly_window_designer) checkFlyWindowDesigner.Checked = true; else checkFlyWindowDesigner.Checked = false; if (p.Mod_designer_top_most) checkModDesignerTopMost.Checked = true; else checkModDesignerTopMost.Checked = false; txtOrderListDesignerUpdate.Text = p.UpdateOrderTableInDesigner.ToString(); txtExport.Text = p.Dir_export; txtImport.Text = p.Dir_import; if (p.Robot_animation_icon) checkRobotIconAnimation.Checked = true; else checkRobotIconAnimation.Checked = false; if (p.Run_one_copy_robot) checkRunOneCopyRobot.Checked = true; else checkRunOneCopyRobot.Checked = false; txtSQLTemplateDCard.Text = p.SQL_Import_Template_DCard; txtSQLTemplateGood.Text = p.SQL_Import_Template_Good; txtSQLTemplateMashine.Text = p.SQL_Import_Template_Mashine; txtSQLTemplateMaterial.Text = p.SQL_Import_Template_Material; txtReklamBlock1.Text = p.ReklamBlock1; if (p.CheckPreview) checkCheckPreview.Checked = true; else checkCheckPreview.Checked = false; txtCheckCount.Text = p.CheckCount.ToString(); txtPasswordClass1.Text = p.PasswordClass1; if (p.AutoSendCrashReport) checkAutoSendCrashReport.Checked = true; else checkAutoSendCrashReport.Checked = false; if (p.AutoSendCrashReport) checkAutoSendCrashReport.Checked = true; else checkAutoSendCrashReport.Checked = false; if (p.SMTPAut) checkSMTPAut.Checked = true; else checkSMTPAut.Checked = false; txtSMTPFromEmail.Text = p.SMTPUserFromEmail; txtSMTPName.Text = p.SMTPUserFrom; txtSMTPPassword.Text = p.SMTPPasswordFrom; txtSMTPServer.Text = p.SMTPServer; txtSMTPToEmail.Text = p.SMTPUserTo; txtFTPServer.Text = p.FTP_Server; txtFTPPath.Text = p.FTP_Path; txtFTPUser.Text = p.FTP_User; txtFTPPassword.Text = p.FTP_Password; txtFTPServerExport.Text = p.FTP_Server_Export; txtFTPPathExport.Text = p.FTP_Path_Export; txtTimeExport.Text = p.Export_time.ToString(); txtTimeImport.Text = p.Import_time.ToString(); if (p.Import_from_ftp) checkFtpImport.Checked = true; else checkFtpImport.Checked = false; if (p.Export_from_ftp) checkExportFP.Checked = true; else checkExportFP.Checked = false; if (p.ShortGoodsListInWizard) checkUseShortListGoods.Checked = true; else checkUseShortListGoods.Checked = false; if (p.ExportDoCopy) checkExportDoCopy.Checked = true; else checkExportDoCopy.Checked = false; if (p.ExportClearDirAfterCopy) checkClearAfterCopy.Checked = true; else checkClearAfterCopy.Checked = false; txtSumRound.SelectedValue = p.ModelRound.ToString(); if (p.QueryForDelete) checkQueryDelete.Checked = true; else checkQueryDelete.Checked = false; if (p.DenyDelete) checkDenyDelete.Checked = true; else checkDenyDelete.Checked = false; txtDCardLimit.Text = p.DCard_limit.ToString(); txtPublicIni.Text = p.PublicIni; checkRound3.Checked = p.Round3; Rebild(); }