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(); } }
private void Button_Click_7(object sender, RoutedEventArgs e) { if (MessageBox.Show( "Сейчас будет загружена техника, принадлежащая заказу. Все раннее выбранные аксессуары и техника будут очищены. Продолжить?", "Важно", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes) { object xamb = neqqqqq.getParam(neqqqqq.Ambiente, "GetObject", "XAMB"); object info = neqqqqq.getParamG(xamb, "INFO"); object info2 = neqqqqq.getParamG(info, "INFO"); string _RIFFABRICA = neqqqqq.getParam(info2, "Var", "_RIFFABRICA").ToString(); if (_RIFFABRICA == "") { MessageBox.Show("Заказу не присвоен фабричный номер"); } else { log.Add("номер заказа на фабрике = " + _RIFFABRICA); nom_PP = 0; List <texnika> importlist = new List <texnika>(); FbConnectionStringBuilder fb_con = new FbConnectionStringBuilder(); fb_con.Charset = "WIN1251"; //используемая кодировка fb_con.UserID = "sysdba"; //логин fb_con.Password = "******"; //пароль fb_con.Database = "172.16.6.155:/usr/interbase/db/resurs.gdb"; //путь к файлу базы данных fb_con.ServerType = 0; //указываем тип сервера (0 - "полноценный Firebird" (classic или super server), 1 - встроенный (embedded)) //создаем подключение var fb = new FbConnection(fb_con.ToString()); //передаем нашу строку подключения объекту класса FbConnection fb.Open(); //открываем БД if (fb.State == ConnectionState.Closed) { fb.Open(); } FbTransaction fbt = fb.BeginTransaction(); //стартуем транзакцию; стартовать транзакцию можно только для открытой базы (т.е. мутод Open() уже был вызван ранее, иначе ошибка) FbCommand SelectSQL = new FbCommand("SELECT * FROM CCUSTOMTEXNICS WHERE CUSTOMID=" + _RIFFABRICA + " order by POZ asc", fb); //задаем запрос на выборку SelectSQL.Transaction = fbt; //необходимо проинициализить транзакцию для объекта SelectSQL FbDataReader reader = SelectSQL.ExecuteReader(); //для запросов, которые возвращают результат в виде набора данных надо использоваться метод ExecuteReader() while (reader.Read()) //пока не прочли все данные выполняем... { float baseprice = 0; if (reader["WPRICE"].ToString() != "") { baseprice = Convert.ToSingle(reader["WPRICE"].ToString()); } int nompp = Convert.ToInt32(reader["POZ"].ToString()); //MessageBox.Show(reader["SALONNUMBER"].ToString()); importlist.Add(new texnika() { type = "t", ID = reader["TPriceID"].ToString(), TName = reader["NAME"].ToString(), Article = reader["ARTICLE"].ToString(), UnitsId = "шт", baseprice = baseprice, priceredak = baseprice, UnitsName = "3", Prim = "", kolvo = Convert.ToInt32(reader["CNT"].ToString()), OTD = "", nom_pp = nompp, // GroupName = reader["TexType"].ToString(), // Group = reader["TexID"].ToString(), // sort = sort, GROUP_dlyaspicif = "",// reader["TKOEFGROUP_ID"].ToString(), }); // MessageBox.Show(reader["CNT"].ToString()+""+ reader["WPRICE"].ToString()); if (nom_PP < nompp) { nom_PP = nompp; } // Grid_select(texnika); } SelectSQL.Dispose(); //в документации написано, что ОЧЕНЬ рекомендуется убивать объекты этого типа, если они больше не нужны fb.Close(); // MessageBox.Show(str_sobr(importlist)); pars(str_sobr(importlist)); } } }
private void Button_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show( "Нажмите \"ОК\", чтобы обновить список заказов", "Внимание", MessageBoxButton.OKCancel, MessageBoxImage.Warning) == MessageBoxResult.OK) { SQLiteConnection m_dbConn = new SQLiteConnection(); SQLiteCommand m_sqlCmd = new SQLiteCommand(); string dbFileName = path_ordini + @"\sample.sqlite"; m_dbConn = new SQLiteConnection("Data Source=" + dbFileName + ";Version=3;"); m_dbConn.Open(); m_sqlCmd.Connection = m_dbConn; string[] files = Directory.GetFiles(path_ordini, "*.eve", SearchOption.TopDirectoryOnly); // Array.Sort(files); object xamb = neqqqqq.getParam(neqqqqq.Ambiente, "GetObject", "XAMB"); object engine = neqqqqq.getParam(neqqqqq.Ambiente, "GetObject", "ENGINE"); object info = neqqqqq.getParamG(xamb, "INFO"); object info2 = neqqqqq.getParamG(info, "INFO"); m_sqlCmd.CommandText = "DELETE FROM ordini"; m_sqlCmd.ExecuteNonQuery(); foreach (string file in files) { string nomfile = file.Split('\\').Last().Split('.').First(); neqqqqq.getParam(xamb, "carica", file); // string newnum = neqqqqq.getParamI(info, "NuovoNumeroOrdine").ToString(); // neqqqqq.setParamP(info, "Numero", newnum); // neqqqqq.getParam(info2, "Add", "_NOMEFILEPARETI", nomfile); // neqqqqq.getParamI(xamb, "salva");//сохраним string FIO = neqqqqq.getParam(info2, "Var", "CLI_1").ToString(); string Manager = neqqqqq.getParam(info2, "Var", "Manager").ToString(); string orderprice = neqqqqq.getParam(info2, "Var", "orderprice").ToString().Trim(); string _RIFFABRICA = neqqqqq.getParam(info2, "Var", "_RIFFABRICA").ToString(); string _RIFSALON = neqqqqq.getParam(info2, "Var", "_RIFSALON").ToString(); string SROK = neqqqqq.getParam(info2, "Var", "SROK").ToString(); string SALON = neqqqqq.getParam(info2, "Var", "SALON").ToString(); object prim = neqqqqq.getParamG(info, "rif").ToString(); m_sqlCmd.CommandText = "INSERT OR IGNORE INTO ordini (file_path, nomer_zakaza, FIO, manager, orderprice, _RIFFABRICA, _RIFSALON, SROK, SALON, prim) " + "VALUES ('" + file + "', '" + nomfile + "','" + FIO + "','" + Manager + "', '" + orderprice + "', '" + _RIFFABRICA + "', '" + _RIFSALON + "', '" + SROK + "', '" + SALON + "', '" + prim + "')"; m_sqlCmd.ExecuteNonQuery(); string pathtmp = path_ordini + @"\" + nomfile; string GetFileBitmap = neqqqqq.getParam(xamb, "GetFileBitmap", pathtmp + ".DRG1").ToString(); if (GetFileBitmap.ToUpper() == "TRUE") { object imgget = neqqqqq.getParam(neqqqqq.Ambiente, "GetObject", "DauImg"); object GetPicture = neqqqqq.getParam(engine, "GetPicture", pathtmp + ".DRG1", "0", "0"); imgget.GetType().InvokeMember("SetPicture", BindingFlags.InvokeMethod, null, imgget, new object[] { GetPicture, "0" }); neqqqqq.getParam(imgget, "SaveImage", pathtmp + ".JPG", "1"); } } m_sqlCmd.Dispose(); m_dbConn.Close(); GC.Collect(); MessageBox.Show("Готово"); } }
public static string updateTekZakaz(neqweqe neqqqqq, string path_ordini) { object xamb = neqqqqq.getParam(neqqqqq.Ambiente, "GetObject", "XAMB"); object engine = neqqqqq.getParam(neqqqqq.Ambiente, "GetObject", "ENGINE"); object info = neqqqqq.getParamG(xamb, "INFO"); object info2 = neqqqqq.getParamG(info, "INFO"); string nomer = neqqqqq.getParam(info, "Numero").ToString(); string evefile = "000000".Substring(0, 6 - nomer.Length) + nomer; SQLiteConnection m_dbConn = new SQLiteConnection(); SQLiteCommand m_sqlCmd = new SQLiteCommand(); string dbFileName = path_ordini + @"\sample.sqlite"; m_dbConn = new SQLiteConnection("Data Source=" + dbFileName + ";Version=3;"); m_dbConn.Open(); m_sqlCmd.Connection = m_dbConn; // MessageBox.Show(FIO); string file_path_load1 = path_ordini + @"\" + evefile + ".eve"; double date_last_update = ConvertToUnixTime(File.GetLastWriteTime(file_path_load1)); log.Add("SELECT * FROM ordini where nomer_zakaza ='" + evefile + "' limit 1"); m_sqlCmd.CommandText = "SELECT * FROM ordini where nomer_zakaza ='" + evefile + "' limit 1"; var reader = m_sqlCmd.ExecuteReader(); int i = 0; while (reader.Read()) { i++; } reader.Close(); string nomfile = file_path_load1.Split('\\').Last().Split('.').First(); //neqqqqq.getParam(xamb, "carica", file_path_load1); string FIO = neqqqqq.getParam(info2, "Var", "CLI_1").ToString(); string Manager = neqqqqq.getParam(info2, "Var", "Manager").ToString(); string orderprice = neqqqqq.getParam(info2, "Var", "orderprice").ToString().Trim(); string _RIFFABRICA = neqqqqq.getParam(info2, "Var", "_RIFFABRICA").ToString(); string _RIFSALON = neqqqqq.getParam(info2, "Var", "_RIFSALON").ToString(); string SROK = neqqqqq.getParam(info2, "Var", "SROK").ToString(); string SALON = neqqqqq.getParam(info2, "Var", "SALON").ToString(); string status = neqqqqq.getParam(info2, "Var", "status_zakaza").ToString(); string prim = neqqqqq.getParamG(info, "rif").ToString(); if (i > 0) { m_sqlCmd.CommandText = "UPDATE ordini SET " + "file_path='" + file_path_load1 + "', " + "nomer_zakaza='" + nomfile + "', " + "FIO='" + FIO + "', " + "manager='" + Manager + "', " + "orderprice='" + orderprice + "', " + "_RIFFABRICA='" + _RIFFABRICA + "', " + "_RIFSALON='" + _RIFSALON + "', " + "SROK='" + SROK + "', " + "SALON='" + SALON + "', " + "date_last_update='" + date_last_update + "', " + "status='" + status + "', " + "prim='" + prim + "' " + " where nomer_zakaza ='" + evefile + "'"; log.Add(m_sqlCmd.CommandText); m_sqlCmd.ExecuteNonQuery(); } else { // object xamb = neqqqqq.getParam(neqqqqq.Ambiente, "GetObject", "XAMB"); // neqqqqq.getParamI(neqqqqq.xamb, "salva");//сохраним if (File.Exists(file_path_load1)) { m_sqlCmd.CommandText = "INSERT INTO ordini (file_path, nomer_zakaza, FIO, manager, orderprice, _RIFFABRICA, _RIFSALON, SROK, date_last_update, status, prim) " + "VALUES ('" + file_path_load1 + "', '" + nomfile + "','" + FIO + "','" + Manager + "', '" + orderprice + "', '" + _RIFFABRICA + "', '" + _RIFSALON + "', '" + SROK + "', '" + date_last_update + "', '" + status + "', '" + prim + "')"; log.Add(m_sqlCmd.CommandText); m_sqlCmd.ExecuteNonQuery(); } } string pathtmp = path_ordini + @"\" + nomfile; string GetFileBitmap = neqqqqq.getParam(xamb, "GetFileBitmap", pathtmp + ".DRG1").ToString(); if (GetFileBitmap.ToUpper() == "TRUE") { object imgget = neqqqqq.getParam(neqqqqq.Ambiente, "GetObject", "DauImg"); object GetPicture = neqqqqq.getParam(engine, "GetPicture", pathtmp + ".DRG1", "0", "0"); imgget.GetType().InvokeMember("SetPicture", BindingFlags.InvokeMethod, null, imgget, new object[] { GetPicture, "0" }); neqqqqq.getParam(imgget, "SaveImage", pathtmp + ".JPG", "1"); } m_sqlCmd.Dispose(); m_dbConn.Close(); GC.Collect(); return(nomer); }