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(); } }
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(); }