private void button_Click_5(object sender, RoutedEventArgs e)
{
string[] Field_name = new string[] { "Код сотрудника", "Фамилия", "Имя", "Отчество", "Возраст", "Пол", "Адрес по прописке",
"Адрес фактического проживание", "Серия", "Номер паспорта", "Подразделение", "Дата выдачи", "Кто выдал", "Телефон", "Код номера", "Наименование", "Вместимость", "Описание", "Стоимость" };
string[] query_input_name = new string[] { "Staff.ID_Employee", "Staff.Surname", "Staff.Name", "Staff.Patronymic", "Staff.Age", "Staff.Gender", "Staff.Registered_address", "Staff.Address_of_actual_residence", "Staff.Series", "Staff.ID_Passport", "Staff.Subdivision", "CAST(Staff.Date_of_issue AS varchar)",
"Staff.Issued_by", "Staff.Phone", "Rooms.ID_Numbers", "Rooms.Name", "Rooms.Capacity", "Rooms.Description", "Rooms.The_cost" };
string[] query_output_name = new string[] { "ID_Employee", "Surname", "Name", "Patronymic", "Age", "Gender", "Registered_address", "Address_of_actual_residence", "Series", "ID_Passport", "Subdivision", "Date_of_issue",
"Issued_by", "Phone", "ID_Numbers", "Name", "Capacity", "Description", "The_cost" };
string[] array = new string[] { };
string[] line = new string[] { };
string sql_fil_end = " FROM Staff INNER JOIN Rooms ON Staff.ID_Employee = Rooms.ID_Employee";
string full_sql = "SELECT Staff.ID_Employee, Staff.ID_Position, Staff.Surname, Staff.Name, Staff.Patronymic, Staff.Age, Staff.Gender, Staff.Registered_address, Staff.Address_of_actual_residence, Staff.Series, Staff.ID_Passport, Staff.Subdivision, " +
"Staff.Date_of_issue, Staff.Issued_by, Staff.Phone, Rooms.ID_Numbers, Rooms.Name, Rooms.Capacity, Rooms.Description, Rooms.The_cost" +
" FROM Staff INNER JOIN Rooms ON Staff.ID_Employee = Rooms.ID_Employee";
string[] explore = new string[] { "Код сотрудника", "Фамилия", "Имя", "Отчество", "Возраст", "Пол", "Адрес по прописке",
"Адрес фактического проживание", "Серия", "Номер паспорта", "Подразделение", "Дата выдачи", "Кто выдал", "Телефон", "Код номера", "Наименование", "Вместимость", "Описание", "Стоимость" };
CheckBox[] array_check = new CheckBox[] { Check_ID_Emp, 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,
Check_ID_Num, Check_Name, Check_Capa, Check_Descr, Check_Cos };
Query_input Query = new Query_input();
Query.report_query(Field_name, query_output_name, query_input_name, array, line, explore, array_check, explorer_box, explorer_textBox, sql_fil_end, full_sql);
}
private void button_Click_9(object sender, RoutedEventArgs e)
{
string[] Field_name = new string[] { "Код сотрудника", "Код должности", "Фамилия сотрудника", "Имя сотрудника", "Отчество сотрудника", "Возраст сотрудника", "Пол сотрудника", "Адрес по прописке сотрудника", "Адрес фактического проживание сотрудника", "Серия паспорта сотрудника", "Номер паспорта сотрудника", "Код подразделение сотрудника", "Дата выдачи паспорта сотруднику", "Кто выдал паспорт сотруднику", "Телефон сотрудника",
"Код клиента", "Фамилия клиента", "Имя клиента", "Отчество клиента", "Адрес по прописке клиента", "Серия паспорта клиента", "Номер паспорта клиента", "Код подразделение клиента", "Дата выдачи паспорта клиента", "Кто выдал паспорт клиенту", "Дата выезда клиента", "Дата заселения клиента",
"Код услуги", "Наименование услуги", "Описание услуги", "Стоимость услуги", "Наименование номера", "Вместимость номера", "Описание номера", "Стоимость номера" };
string[] query_input_name = new string[] { "Staff.ID_Employee", "Staff.ID_Position", "Staff.Surname", "Staff.Name", "Staff.Patronymic", "Staff.Age", "Staff.Gender", "Staff.Registered_address", "Staff.Address_of_actual_residence",
"Staff.Series", "Staff.ID_Passport", "Staff.Subdivision", "Staff.Date_of_issue", "Staff.Issued_by", "Staff.Phone", "Clients.ID_Client", "Clients.Surname", "Clients.Name", "Clients.Patronymic", "Clients.Registered_address",
"Clients.Series", "Clients.ID_Passport", "Clients.Subdivision", "Clients.Date_of_issue", "Clients.Issued_by", "Clients.Check_in_date", "Clients.Date_of_departure", "Services.ID_Services", "Services.Name", "Services.Description", "Services.The_cost", "Rooms.Name", "Rooms.Capacity", "Rooms.Description", "Rooms.The_cost" };
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", "ID_Client", "Surname", "Name", "Patronymic", "Registered_address",
"Series", "ID_Passport", "Subdivision", "Date_of_issue", "Issued_by", "Check_in_date", "Date_of_departure", "ID_Services", "Name", "Description", "The_cost", "Name", "Capacity", "Description", "The_cost" };
string[] array = new string[] { };
string[] line = new string[] { };
string sql_fil_end = " FROM Clients INNER JOIN " +
"Rooms ON Clients.ID_Numbers = Rooms.ID_Numbers INNER JOIN " +
"[Services provided to the client] ON Clients.ID_Client = [Services provided to the client].ID_Client INNER JOIN " +
"Services ON [Services provided to the client].ID_Services = Services.ID_Services INNER JOIN " +
"Staff ON Clients.ID_Employee = Staff.ID_Employee";
string full_sql = "SELECT Staff.ID_Employee,Staff.ID_Position,Staff.Surname,Staff.Name,Staff.Patronymic,Staff.Age,Staff.Gender,Staff.Registered_address,Staff.Address_of_actual_residence, Staff.Series,Staff.ID_Passport, Staff.Subdivision,Staff.Date_of_issue," +
"Staff.Issued_by, Staff.Phone,Clients.ID_Client,Clients.Surname,Clients.Name,Clients.Patronymic,Clients.Registered_address,Clients.Series," +
"Clients.ID_Passport,Clients.Subdivision,Clients.Date_of_issue,Clients.Issued_by,Clients.Check_in_date,Clients.Date_of_departure,Services.ID_Services, Services.Name," +
"Services.Description,Services.The_cost,Rooms.Name,Rooms.Capacity,Rooms.Description,Rooms.The_cost" +
" FROM Clients INNER JOIN " +
"Rooms ON Clients.ID_Numbers = Rooms.ID_Numbers INNER JOIN " +
"[Services provided to the client] ON Clients.ID_Client = [Services provided to the client].ID_Client INNER JOIN " +
"Services ON [Services provided to the client].ID_Services = Services.ID_Services INNER JOIN " +
"Staff ON Clients.ID_Employee = Staff.ID_Employee";
string[] explore = new string[] { "Код сотрудника", "Код должности", "Фамилия сотрудника", "Имя сотрудника", "Отчество сотрудника", "Возраст сотрудника", "Пол сотрудника", "Адрес по прописке сотрудника", "Адрес фактического проживание сотрудника", "Серия паспорта сотрудника", "Номер паспорта сотрудника", "Код подразделение сотрудника", "Дата выдачи паспорта сотруднику", "Кто выдал паспорт сотруднику", "Телефон сотрудника",
"Код клиента", "Фамилия клиента", "Имя клиента", "Отчество клиента", "Адрес по прописке клиента", "Серия паспорта клиента", "Номер паспорта клиента", "Код подразделение клиента", "Дата выдачи паспорта клиента", "Кто выдал паспорт клиенту", "Дата выезда клиента", "Дата заселения клиента",
"Код услуги", "Наименование услуги", "Описание услуги", "Стоимость услуги", "Наименование номера", "Вместимость номера", "Описание номера", "Стоимость номера" };
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,
Check_ID_Cli, Check_Familys, Check_Name, Check_Patrе, Check_Register, Check_Ceria, Check_ID_P, Check_Podrazdelenia, Check_Dates, Check_Is_Date, Check_Date_Vi, Check_Data_Za, Check_ID_Ser, Check_Nam, Check_Desc, Check_Cost,
Check_Nameq, Check_Capa, Check_Descr, Check_Cos };
Query_input Query = new Query_input();
Query.report_query(Field_name, query_output_name, query_input_name, array, line, explore, array_check, explorer_box, explorer_textBox, sql_fil_end, full_sql);
}
private void button_Click_6(object sender, RoutedEventArgs e)
{
string[] Field_name = new string[] { "Код сотрудника", "Фамилия", "Имя", "Отчество", "Возраст", "Пол", "Адрес по прописке",
"Адрес фактического проживание", "Серия", "Номер паспорта", "Подразделение", "Дата выдачи", "Кто выдал", "Телефон", "Код должности", "Наименование должности", "Обязанности", "Требование", "Оклад" };
string[] query_input_name = new string[] { "Staff.ID_Employee", "Staff.Surname", "Staff.Name", "Staff.Patronymic", "Staff.Age", "Staff.Gender", "Staff.Registered_address", "Staff.Address_of_actual_residence", "Staff.Series", "Staff.ID_Passport", "Staff.Subdivision", "CAST(Staff.Date_of_issue AS varchar)",
"Staff.Issued_by", "Staff.Phone", "Positionen.ID_Position", "Positionen.Job_title", "Positionen.Duties", "Positionen.Requirements", "Positionen.Salary" };
string[] query_output_name = new string[] { "ID_Employee", "Surname", "Name", "Patronymic", "Age", "Gender", "Registered_address", "Address_of_actual_residence", "Series", "ID_Passport", "Subdivision", "Date_of_issue",
"Issued_by", "Phone", "ID_Position", "Job_title", "Duties", "Requirements", "Salary" };
string[] array = new string[] { };
string[] line = new string[] { };
string sql_fil_end = " FROM Staff INNER JOIN Positionen ON Staff.ID_Position = Positionen.ID_Position";
string full_sql = "SELECT Staff.ID_Employee, Staff.Surname, Staff.Name, Staff.Patronymic, Staff.Age, Staff.Gender, Staff.Registered_address, Staff.Address_of_actual_residence, Staff.Series, Staff.ID_Passport, Staff.Subdivision, " +
" Staff.Date_of_issue, Staff.Issued_by, Staff.Phone, Positionen.ID_Position, Positionen.Job_title, Positionen.Duties, Positionen.Requirements, Positionen.Salary" +
" FROM Staff INNER JOIN Positionen ON Staff.ID_Position = Positionen.ID_Position";
string[] explore = new string[] { "Код сотрудника", "Фамилия", "Имя", "Отчество", "Возраст", "Пол", "Адрес по прописке",
"Адрес фактического проживание", "Серия", "Номер паспорта", "Подразделение", "Дата выдачи", "Кто выдал", "Телефон", "Код должности", "Наименование должности", "Обязанности", "Требование", "Оклад" };
CheckBox[] array_check = new CheckBox[] { Check_ID_Emp, 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, Check_ID, Check_Job, Check_Dut, Check_Requ, Check_Sal };
Query_input Query = new Query_input();
Query.report_query(Field_name, query_output_name, query_input_name, array, line, explore, array_check, explorer_box, explorer_textBox, sql_fil_end, full_sql);
}
