private void button_Click_11(object sender, RoutedEventArgs e)
{
string[] Field_name = new string[] { "Код номера", "Код сотрудника", "Наименование", "Вместимость", "Описание", "Стоимость" };
string[] explore = new string[] { "Код номера", "Код сотрудника", "Наименование", "Вместимость", "Описание", "Стоимость" };
string[] query_output_name = new string[] { "ID_Numbers", "ID_Employee", "Name", "Capacity", "Description", "The_cost" };
string[] array = new string[] { };
string[] line = new string[] { };
string sql_fil_end = " from dbo.Rooms";
string full_sql = "select ID_Numbers,ID_Employee,Name,Capacity,Description,The_cost from dbo.Rooms";
CheckBox[] array_check = new CheckBox[] { Check_ID_Num, Check_ID_Emp, Check_Names, Check_Capa, Check_Descr, Check_Cos };
Query_input Query = new Query_input();
Query.report(Field_name, query_output_name, array, line, explore, array_check, explorer_box, explorer_textBox, sql_fil_end, full_sql);
}
private void button_Click_10(object sender, RoutedEventArgs e)
{
string[] Field_name = new string[] { "Код клиента", "Код услуги", "Стоимость" };
string[] explore = new string[] { "Код клиента", "Код услуги", "Стоимость" };
string[] query_output_name = new string[] { "ID_Client", "ID_Services", "The_cost" };
string[] array = new string[] { };
string[] line = new string[] { };
string sql_fil_end = " from dbo.[Services provided to the client]";
string full_sql = "select ID_Client, ID_Services, The_cost from dbo.[Services provided to the client]";
CheckBox[] array_check = new CheckBox[] { Check_Cli, Check_ID_Ser, Check_Cost };
Query_input Query = new Query_input();
Query.report(Field_name, query_output_name, array, line, explore, array_check, explorer_box, explorer_textBox, sql_fil_end, full_sql);
}
private void button_Click_11(object sender, RoutedEventArgs e)
{
string[] Field_name = new string[] { "Код услуги", "Наименование", "Описание", "Стоимость" };
string[] explore = new string[] { "Код услуги", "Наименование", "Описание", "Стоимость" };
string[] query_output_name = new string[] { "ID_Services", "Name", "Description", "The_cost" };
string[] array = new string[] { };
string[] line = new string[] { };
string sql_fil_end = " from dbo.Services";
string full_sql = "Select ID_Services, Name, Description, The_cost from dbo.Services";
CheckBox[] array_check = new CheckBox[] { Check_ID_Ser, Check_Nam, Check_Desc, Check_Cost };
Query_input Query = new Query_input();
Query.report(Field_name, query_output_name, array, line, explore, array_check, explorer_box, explorer_textBox, sql_fil_end, full_sql);
}
private void button_Click_11(object sender, RoutedEventArgs e)
{
string[] Field_name = new string[] { "Код должности", "Наименование должности", "Обязанности", "Требование", "Оклад" };
string[] query_output_name = new string[] { "ID_Position", "Job_title", "Duties", "Requirements", "Salary" };
string[] array = new string[] { };
string[] line = new string[] { };
string[] explore = new string[] { "Код должности", "Наименование должности", "Обязанности", "Требование", "Оклад" };
string sql_fil_end = " from dbo.Positionen";
string full_sql = "select ID_Position, Job_title, Duties, Requirements, Salary from dbo.Positionen";
CheckBox[] array_check = new CheckBox[] { Check_ID, Check_Job, Check_Dut, Check_Requ, Check_Sal };
Query_input Query = new Query_input();
Query.report(Field_name, query_output_name, array, line, explore, array_check, explorer_box, explorer_textBox, sql_fil_end, full_sql);
}
private void button_Click_11(object sender, RoutedEventArgs e)
{
string[] Field_name = new string[] { "Код клиента", "Код сотрудника", "Код номера", "Фамилия", "Имя", "Отчество", "Адрес по прописке", "Серия",
"Номер паспорта", "Подразделение", "Дата выдачи", "Кто выдал", "Дата выезда", "Дата заселения" };
string[] query_output_name = new string[] { "ID_Client", "ID_Employee", "ID_Numbers", "Surname", "Name", "Patronymic", "Registered_address", "Series", "ID_Passport", "Subdivision", "Date_of_issue", "Issued_by", "Check_in_date", "Date_of_departure" };
string[] array = new string[] { };
string[] line = new string[] { };
string sql_fil_end = " from dbo.Clients";
string full_sql = "select ID_Client,ID_Employee,ID_Numbers,Surname,Name,Patronymic,Registered_address,Series,ID_Passport,Subdivision,Date_of_issue,Issued_by,Check_in_date,Date_of_departure from dbo.Clients";
string[] explore = new string[] { "Код клиента", "Код сотрудника", "Код номера", "Фамилия", "Имя", "Отчество", "Адрес по прописке", "Серия",
"Номер паспорта", "Подразделение", "Дата выдачи", "Кто выдал", "Дата выезда", "Дата заселения" };
CheckBox[] array_check = new CheckBox[] { Check_ID_Cli, Check_ID_EMP, Check_ID_NUM, Check_Familys, Check_Names, Check_Patr, Check_Register, Check_Ceria,
Check_ID_P, Check_Podrazdelenia, Check_Dates, Check_Is_Date, Check_Date_Vi, Check_Data_Za };
Query_input Query = new Query_input();
Query.report(Field_name, query_output_name, array, line, explore, array_check, explorer_box, explorer_textBox, sql_fil_end, full_sql);
}
private void button_Click_11(object sender, RoutedEventArgs e)
{
string[] Field_name = new string[] { "Код сотрудника", "Код должности", "Фамилия", "Имя", "Отчество", "Возраст", "Пол", "Адрес по прописке",
"Адрес фактического проживание", "Серия", "Номер паспорта", "Подразделение", "Дата выдачи", "Кто выдал", "Телефон" };
string[] query_output_name = new string[] { "ID_Employee", "ID_Position", "Surname", "Name", "Patronymic", "Age", "Gender", "Registered_address", "Address_of_actual_residence", "Series", "ID_Passport", "Subdivision", "Date_of_issue",
"Issued_by", "Phone" };
string[] array = new string[] { };
string[] line = new string[] { };
string[] explore = new string[] { "Код сотрудника", "Код должности", "Фамилия", "Имя", "Отчество", "Возраст", "Пол", "Адрес по прописке",
"Адрес фактического проживание", "Серия", "Номер паспорта", "Подразделение", "Дата выдачи", "Кто выдал", "Телефон" };
string sql_fil_end = " from dbo.Staff";
string full_sql = "select ID_Employee,ID_Position,Surname,Name,Patronymic,Age,Gender,Registered_address,Address_of_actual_residence,Series,ID_Passport,Subdivision,Date_of_issue,Issued_by,Phone from dbo.Staff";
CheckBox[] array_check = new CheckBox[] { Check_ID_Emp, Check_ID_Post, Check_Sur, Check_Names, Check_Patr, Check_Year, Check_Gendr, Check_Registered, Check_actual, Check_Series, Check_ID_Pass, Check_Subdivision, Check_Date, Check_Issued, Check_Phones };
Query_input Query = new Query_input();
Query.report(Field_name, query_output_name, array, line, explore, array_check, explorer_box, explorer_textBox, sql_fil_end, full_sql);
}
