public dialprogr_new(string path, neqweqe neqqqqq)
{
InitializeComponent();
this.neqqqqq = neqqqqq;
this.path = path;
log.Add("Старт диалога");
INIManager client_man = new INIManager(Environment.CurrentDirectory + @"\ecadpro.ini");
admin = client_man.GetPrivateString("giulianovars", "3dsadmin"); //версия клиента
authotiz_root = client_man.GetPrivateString("giulianovars", "attivazione"); //получ ключ активации
loadspis();
lb2.Content = "Текущий заказ " + path.Split('\\').Last();
log.Add("Текущий заказ " + path.Split('\\').Last());
if (admin != "1")
{
admbtn.Visibility = Visibility.Collapsed;
mivip.Visibility = Visibility.Collapsed;
miarh.Visibility = Visibility.Collapsed;
mizagr.Visibility = Visibility.Collapsed;
}
log.Add("admin " + admin);
}
public srtting(neqweqe _neqqqqq, string _path_ordini)
{
InitializeComponent();
path_ordini = _path_ordini;
neqqqqq = _neqqqqq;
Settings1 ps = Settings1.Default;
spiscolumn.Add(new spissettings()
{
Value = "№ заказа", IsSelected = ps.spisotobrstolb[0] == '1'
});
spiscolumn.Add(new spissettings()
{
Value = "ФИО клиента", IsSelected = ps.spisotobrstolb[1] == '1'
});
spiscolumn.Add(new spissettings()
{
Value = "Сумма", IsSelected = ps.spisotobrstolb[2] == '1'
});
spiscolumn.Add(new spissettings()
{
Value = "Дата изготовления", IsSelected = ps.spisotobrstolb[3] == '1'
});
spiscolumn.Add(new spissettings()
{
Value = "Номер в салоне", IsSelected = ps.spisotobrstolb[4] == '1'
});
spiscolumn.Add(new spissettings()
{
Value = "Номер на фабрике", IsSelected = ps.spisotobrstolb[5] == '1'
});
spiscolumn.Add(new spissettings()
{
Value = "Менеджер в салоне", IsSelected = ps.spisotobrstolb[6] == '1'
});
spiscolumn.Add(new spissettings()
{
Value = "Салон", IsSelected = ps.spisotobrstolb[7] == '1'
});
spiscolumn.Add(new spissettings()
{
Value = "Дата последнего изменения", IsSelected = ps.spisotobrstolb[8] == '1'
});
spiscolumn.Add(new spissettings()
{
Value = "Статус", IsSelected = ps.spisotobrstolb[9] == '1'
});
spiscolumn.Add(new spissettings()
{
Value = "Примечание", IsSelected = ps.spisotobrstolb[10] == '1'
});
lb1.ItemsSource = spiscolumn;
}
public dialprogr(neqweqe neqqqqq)
{
InitializeComponent();
this.neqqqqq = neqqqqq;
log.Add("подключаемся к фтп");
List <string> eve = new List <string>();
// WebClient client = new WebClient();
var url = "ftp://giulianovars.ru/zakaz/";
// Get the object used to communicate with the server.
FtpWebRequest request = (FtpWebRequest)WebRequest.Create(url);
request.Method = WebRequestMethods.Ftp.ListDirectory;
// This example assumes the FTP site uses anonymous logon.
request.Credentials = new NetworkCredential("ecad", "UWnlLh3PLy");
FtpWebResponse response = (FtpWebResponse)request.GetResponse();
Stream responseStream = response.GetResponseStream();
StreamReader reader = new StreamReader(responseStream);
string responses = reader.ReadToEnd();
// MessageBox.Show(responses);
reader.Close();
response.Close();
string[] masssiv = responses.Split('\r');
foreach (string elem in masssiv)
{
// MessageBox.Show(elem.Trim());
// string element = elem.Split(new string[] { ".eve</a>" }, StringSplitOptions.None).First();
if (elem.Trim().IndexOf("for_spis") == -1 && elem.Trim().Length == 10)
{
eve.Add(elem.Trim());
}
}
lb1.ItemsSource = eve;
}
public open(neqweqe _neqqqqq, string _path_ordini)
{
InitializeComponent();
path_ordini = _path_ordini;
this.neqqqqq = _neqqqqq;
timer.Tick += new EventHandler(timerTick);
timer.Interval = new TimeSpan(0, 0, 0, 0, 500);
string percorsoordini = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + @"\_ecadpro\ordini";
log.Add("percorsoordini= " + percorsoordini);
string[] files = Directory.GetFiles(percorsoordini, "*.eve", SearchOption.TopDirectoryOnly);
if (files.Length == 0 || percorsoordini.ToUpper() == (Environment.CurrentDirectory + @"\_ecadpro\ordini").ToUpper())
{
btn_share.Visibility = Visibility.Collapsed;
}
Title = "Заказы | Папка с заказами: " + path_ordini;
loadpage();
// MessageBox.Show("revisionnnn");
// getrevisioni();
createOpenBD(path_ordini);
nomer = updateTekZakaz(neqqqqq, path_ordini);
select(true);
//lb1.ScrollIntoView(lb1.SelectedItem);
}
public TAccessories(string path, string text, neqweqe _neqqqqq)
{
InitializeComponent();
this.neqqqqq = _neqqqqq;
BD.path = path; //укажем файл бд
this.text_otvet = text;
log.Add("Запуск окна");
timer.Tick += new EventHandler(timerTick);
timer.Interval = new TimeSpan(0, 0, 0, 0, 500);
log.Add("Запуск таймера");
loadpage();//загрузка полож окна
INIManager client_man = new INIManager(Environment.CurrentDirectory + @"\_ecadpro\ecadpro.ini");
ismanager = client_man.GetPrivateString("giulianovars", "ismanager");//версия клиента
if (ismanager == "1")
{
btnimp.Visibility = Visibility.Visible;
}
else
{
btnimp.Visibility = Visibility.Collapsed;
}
//отделка
log.Add("Подключимся к бд");
OleDbDataReader reader_otd = BD.conn("SELECT Id, Name FROM TOtdelka order by Name ASC");
otdelka_array = new List <todelka>();
otdelka_array.Add(new todelka()
{
ID = "", nameotd = ""
});
while (reader_otd.Read())
{
if (reader_otd["Name"].ToString() != "")
{
otdelka_array.Add(new todelka()
{
ID = reader_otd["Id"].ToString(),
nameotd = reader_otd["Name"].ToString(),
});
}
}
log.Add("установим отделку");
otdelka.ItemsSource = otdelka_array;
//.ItemsSource = todelka;
//ед изм
OleDbDataReader reader_izmer = BD.conn("SELECT UnitsID, UnitsName FROM TUnits order by UnitsName ASC");
while (reader_izmer.Read())
{
if (reader_izmer["UnitsName"].ToString() != "")
{
izmer.Add(new todelka()
{
ID = reader_izmer["UnitsID"].ToString(),
nameotd = reader_izmer["UnitsName"].ToString(),
});
}
}
log.Add("установим ед изм");
edizmer.ItemsSource = izmer;
log.Add("загрузим аксссуары");
//аксессуары
OleDbDataReader reader_GRACC = BD.conn("SELECT TPrice1.GRAFIKA, TPrice1.Articul, TUnits.UnitsID, TPrice1.TKOEFGROUP_ID, TUnits.UnitsName, TPrice1.MName, TPrice1.MatID, TPrice1.PriceID, TPrice1.Price, TMAT.MATNAME, TPrice1.Visibl FROM (TPrice1 LEFT OUTER JOIN TMAT ON TPrice1.MatID = TMAT.MATID) LEFT OUTER JOIN TUnits ON TUnits.UnitsID=TPrice1.UnitsID ");//WHERE TPrice1.GRAFIKA=0
//LEFT OUTER JOIN TUnits ON TUnits.UnitsID=TPrice1.UnitsID
while (reader_GRACC.Read())
{
float baseprice = 0;
if (reader_GRACC["Price"].ToString() != "")
{
baseprice = Convert.ToSingle(reader_GRACC["Price"].ToString());
}
bool vived = true;
if (reader_GRACC["Visibl"].ToString() == "1")
{
vived = false;
}
int sort = 0;
if (reader_GRACC["Articul"].ToString() == "***" || reader_GRACC["Articul"].ToString() == "15R***" || reader_GRACC["Articul"].ToString() == "SAD***")
{
}
else
{
sort = sort_forg1;
}
array_spis_tex.Add(new texnika()
{
type = "a",
ID = reader_GRACC["PriceID"].ToString(),
TName = reader_GRACC["MName"].ToString(),
Group = reader_GRACC["MatID"].ToString(),
baseprice = baseprice,
priceredak = baseprice,
UnitsId = reader_GRACC["UnitsName"].ToString(),
GroupName = reader_GRACC["MATNAME"].ToString(),
UnitsName = reader_GRACC["UnitsID"].ToString(),
Article = reader_GRACC["Articul"].ToString(),
Prim = "",
kolvo = 1,
vived = vived,
OTD = "",
sort = sort,
GROUP_dlyaspicif = reader_GRACC["TKOEFGROUP_ID"].ToString(),
GRAFIKA = reader_GRACC["GRAFIKA"].ToString(),
});
sort_forg1++;
}
log.Add("Загрузим технику");
//техника
OleDbDataReader reader = BD.conn("SELECT TTxPrice1.Article, TTxPrice1.TName, TTxPrice1.TKOEFGROUP_ID, TTxPrice1.TPriceID, TTxPrice1.TexID, TTxPrice1.Price, TTexnics.TexType FROM TTxPrice1 LEFT OUTER JOIN TTexnics ON TTxPrice1.TexID = TTexnics.TexID ");
while (reader.Read())
{
try
{
float baseprice = 0;
if (reader["Price"].ToString() != "")
{
baseprice = Convert.ToSingle(reader["Price"].ToString());
}
int sort = 0;
if (reader["Article"].ToString() == "*")
{
}
else
{
sort = sort_forg1;
}
array_spis_tex.Add(new texnika()
{
type = "t",
ID = reader["TPriceID"].ToString(),
TName = reader["TName"].ToString(),
Article = reader["Article"].ToString(),
UnitsId = "шт",
baseprice = baseprice,
priceredak = baseprice,
UnitsName = "3",
GroupName = reader["TexType"].ToString(),
Group = reader["TexID"].ToString(),
Prim = "",
kolvo = 1,
OTD = "",
sort = sort,
GROUP_dlyaspicif = reader["TKOEFGROUP_ID"].ToString(),
GRAFIKA = "0"
});
}
catch
{
MessageBox.Show("err");
}
sort_forg1++;
}
MenuItem root = new MenuItem()
{
Title = "Все", type = "at*"
};
MenuItem childItem1 = new MenuItem()
{
Title = "Аксессуары", type = "a*"
};
log.Add("Загрузим матид");
OleDbDataReader readertreeeacc = BD.conn("select T.MATID,MATNAME from TMAT T, TPrice1 T1 where T1.MATID = T.MATID group by T.MATID,T.MATNAME ORDER BY T.MATNAME ASC");
while (readertreeeacc.Read())
{
childItem1.Items.Add(new MenuItem()
{
Title = readertreeeacc["MATNAME"].ToString(),
ID = readertreeeacc["MATID"].ToString(),
type = "a",
});
}
root.Items.Add(childItem1);
childItem1 = new MenuItem()
{
Title = "Техника", type = "t*"
};
log.Add("загрузим ттехникс");
OleDbDataReader reader_texCB = BD.conn("select T.TexID,TexType from TTexnics T, TTxPrice1 T1 where T1.TexID=T.TexID group by T.TEXID,T.TexType ORDER BY T.TexType ASC ");
while (reader_texCB.Read())
{
childItem1.Items.Add(new MenuItem()
{
Title = reader_texCB["TexType"].ToString(),
ID = reader_texCB["TexID"].ToString(),
type = "t",
});
}
root.Items.Add(childItem1);
tv1.Items.Add(root);
log.Add("парсим строкуs");
pars(text);
}
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);
}