private void ButtonBase_Click(object sender, RoutedEventArgs e)
{
ClearMe();
AccBase.AccGetAll();
textBox1.Text += "~ " + Papa.infoSmall;
/*
* string query = "SELECT Терминалы.department, Терминалы.termial, Терминалы.model, Терминалы.serial_number, Терминалы.date_manufacture, Терминалы.soft, Терминалы.producer, Терминалы.rne_rro, Терминалы.sealing, Терминалы.fiscal_number, Терминалы.oro_serial, Терминалы.oro_number, Терминалы.ticket_serial, Терминалы.ticket_1sheet, Терминалы.ticket_number, Терминалы.sending, Терминалы.books_arhiv, Терминалы.tickets_arhiv, Терминалы.to_rro, Терминалы.owner_rro, Отделения.department, Отделения.region, Отделения.district_region, Отделения.city_type, Отделения.city, Отделения.district_city, Отделения.street_type, Отделения.street, Отделения.hous, Отделения.post_index, Отделения.partner, Отделения.status, Отделения.register, Отделения.edrpou, Отделения.address, Отделения.[partner name], Отделения.id_terminal, Отделения.koatu, Отделения.tax_id FROM Терминалы INNER JOIN Отделения ON Терминалы.department = Отделения.department ORDER BY Терминалы.termial;";
* string ofName = "vsyo_zapros.csv";
* string outText = "Терминалы.department;termial;model;serial_number;date_manufacture;soft;producer;rne_rro;sealing;fiscal_number;oro_serial;oro_number;ticket_serial;ticket_1sheet;ticket_number;sending;books_arhiv;tickets_arhiv;to_rro;owner_rro;Отделения.department;region;district_region;city_type;city;district_city;street_type;street;hous;post_index;partner;status;register;edrpou;address;partner name;id_terminal;koatu;tax_id\n";
* AccessProcess(query, ofName, outText);
*/
}
private void ButtonTerms_Click(object sender, RoutedEventArgs e)
{
ClearMe();
AccBase.AccGetTerms();
textBox1.Text += "~ " + Papa.infoSmall;
/*
* string query = "SELECT * FROM Терминалы ORDER BY termial; ";
* string ofName = "terminals.csv";
* ofName = System.IO.Path.Combine("R:/DRM/Access/Data/InData", ofName);
* string outText = "";
* AccessProcess(query, ofName, outText);
*/
}
private void ButtonDeps_Click(object sender, RoutedEventArgs e)
{
ClearMe();
AccBase.AccGetDeps();
textBox1.Text += "~ " + Papa.infoSmall;
/*
* string query = "SELECT * FROM Отделения ORDER BY department; ";
* string ofName = "departments.csv";
* ofName = System.IO.Path.Combine("R:/DRM/Access/Data/InData", ofName);
* string outText = "";
* AccessProcess(query, ofName, outText);
*/
}
private void ButtonAccSite_Click(object sender, RoutedEventArgs e)
{
ClearMe();
AccBase.AccGetAccess();
textBox2.Text = "~ " + Papa.infoSmall + "\t\n";
SiteNew.MainSite();
textBox1.Text = Papa.infoSmall + "\t\n" + Papa.infoBig;
textBox2.Text += "\n" + textBox1.Text;
/*
* string query = "SELECT * FROM ACCESS ORDER BY department; ";
* string ofName = "access.csv";
* ofName = System.IO.Path.Combine("R:/DRM/Access/Data/InData", ofName);
* string outText = "";
* AccessProcess(query, ofName, outText);
*
* SiteNew.MainSite();
* textBox1.Text += " -> " + Papa.infoSmall;
*/
}