Esempio n. 1
0
        private void Button_Click_3(object sender, RoutedEventArgs e)
        {
            ordini duplicate = lb1.SelectedItem as ordini;

            if (MessageBox.Show(
                    "Дублировать заказ?",
                    "Внимание",
                    MessageBoxButton.OKCancel,
                    MessageBoxImage.Warning) == MessageBoxResult.OK)
            {
                object xamb  = neqqqqq.getParam(neqqqqq.Ambiente, "GetObject", "XAMB");
                object info  = neqqqqq.getParamG(xamb, "INFO");
                object info2 = neqqqqq.getParamG(info, "INFO");
                neqqqqq.getParam(xamb, "carica", duplicate.file_path);
                string newnum = neqqqqq.getParamI(info, "NuovoNumeroOrdine").ToString();
                neqqqqq.setParamP(info, "Numero", newnum);
                neqqqqq.getParam(info2, "Add", "_NOMEFILEPARETI", duplicate.nomer_zakaza);
                neqqqqq.getParamI(xamb, "salva");//сохраним

                SQLiteConnection m_dbConn = new SQLiteConnection();
                SQLiteCommand    m_sqlCmd = new SQLiteCommand();
                m_dbConn = new SQLiteConnection("Data Source=" + dbFileName + ";Version=3;");
                m_dbConn.Open();
                m_sqlCmd.Connection = m_dbConn;



                string pattern  = "000000";
                string nom_form = pattern.Remove(0, newnum.Length) + newnum;
                m_sqlCmd.CommandText = "INSERT OR IGNORE INTO ordini(file_path, nomer_zakaza) VALUES('" + path_ordini + "\\" + nom_form + ".eve', '" + nom_form + "')";
                m_sqlCmd.ExecuteNonQuery();


                m_sqlCmd.Dispose();
                m_dbConn.Close();
                GC.Collect();

                MessageBox.Show("Новый заказ имеет номер " + nom_form);


                select();
            }
        }
Esempio n. 2
0
        void skachatb()
        {
            var        url         = "ftp://giulianovars.ru/zakaz/" + (lb1.SelectedItem as string);
            INIManager client_man  = new INIManager(Environment.CurrentDirectory + @"\_ecadpro\ecadpro.ini");
            string     path_sysdba = client_man.GetPrivateString("Infogen", "percorsoordini");//версия клиента
            string     tmppath     = Environment.CurrentDirectory + @"\" + path_sysdba + @"\000001.eve";

            log.Add("Путь куда установили " + tmppath);
            // MessageBox.Show(tmppath);
            //  client.DownloadFile(url, tmppath);//скачаем новую



            // Get the object used to communicate with the server.
            FtpWebRequest request = (FtpWebRequest)WebRequest.Create(url);

            request.Method = WebRequestMethods.Ftp.DownloadFile;

            // This example assumes the FTP site uses anonymous logon.
            request.Credentials = new NetworkCredential("ecad", "UWnlLh3PLy");
            FtpWebResponse response = (FtpWebResponse)request.GetResponse();

            // получаем поток ответа
            Stream responseStream = response.GetResponseStream();
            // сохраняем файл в дисковой системе
            // создаем поток для сохранения файла
            FileStream fs = new FileStream(tmppath, FileMode.Create);

            //Буфер для считываемых данных
            byte[] buffer = new byte[64];
            int    size   = 0;

            while ((size = responseStream.Read(buffer, 0, buffer.Length)) > 0)
            {
                fs.Write(buffer, 0, size);
            }
            fs.Close();
            response.Close();

            Console.WriteLine("Загрузка и сохранение файла завершены");
            Console.Read();



            retzakaz = "1";


            neqqqqq.getParam(neqqqqq.xamb, "carica", tmppath);
            neqqqqq.getParamI(neqqqqq.Ambiente, "bcarica");


            Close();
        }