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; */ }