Example #1
0
        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
            {
            }
        }
Example #2
0
 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();
     }
 }
Example #3
0
        // Сохраняем из визарда текстовое описание
        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;
            }
        }
Example #4
0
        // Сохраняем из визарда текстовое описание
        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;
            }
        }
Example #5
0
        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);
        }
Example #6
0
        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;
        }
Example #7
0
        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();
        }