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