public AddCompany(bool temp) { try { InitializeComponent(); howform = temp; WorkSQL.sql_p = "select \"Форма собственности\" from show_owner_ship"; cbx_owner.ItemsSource = WorkSQL.ConvertQueryToComboBox(); if (howform) { mainwin.Title = "Добавить предприятие"; btn_add.Content = "Добавить"; } else { mainwin.Title = "Изменить предприятие"; btn_add.Content = "Изменить"; txt_name.Text = WorkSQL.drv_p.Row.ItemArray[1].ToString(); cbx_owner.SelectedItem = WorkSQL.drv_p.Row.ItemArray[2]; txt_phone.Text = WorkSQL.drv_p.Row.ItemArray[3].ToString(); dp_date.SelectedDate = (DateTime)WorkSQL.drv_p.Row.ItemArray[4]; txt_number.Text = WorkSQL.drv_p.Row.ItemArray[5].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public AddCross(bool temp) { try { InitializeComponent(); howform = temp; WorkSQL.sql_p = "select Номер from show_department"; cbx_department.ItemsSource = WorkSQL.ConvertQueryToComboBox(); WorkSQL.sql_p = "select Номер from show_employee"; cbx_employee.ItemsSource = WorkSQL.ConvertQueryToComboBox(); if (howform) { mainwin.Title = "Добавить распределение"; btn_add.Content = "Добавить"; } else { mainwin.Title = "Изменить распределение"; btn_add.Content = "Изменить"; cbx_department.Text = WorkSQL.drv_p.Row.ItemArray[1].ToString(); cbx_employee.Text = WorkSQL.drv_p.Row.ItemArray[3].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public AddEmployee(bool temp) { try { InitializeComponent(); howform = temp; WorkSQL.sql_p = "select Образование from show_education"; cbx_education.ItemsSource = WorkSQL.ConvertQueryToComboBox(); if (howform) { mainwin.Title = "Добавить сотрудника"; btn_add.Content = "Добавить"; } else { mainwin.Title = "Изменить сотрудника"; btn_add.Content = "Изменить"; txt_first.Text = WorkSQL.drv_p.Row.ItemArray[1].ToString(); txt_second.Text = WorkSQL.drv_p.Row.ItemArray[2].ToString(); txt_middle.Text = WorkSQL.drv_p.Row.ItemArray[3].ToString(); dp_date.SelectedDate = (DateTime)WorkSQL.drv_p.Row.ItemArray[4]; txt_position.Text = WorkSQL.drv_p.Row.ItemArray[5].ToString(); txt_salary.Text = WorkSQL.drv_p.Row.ItemArray[6].ToString(); cbx_education.SelectedItem = WorkSQL.drv_p.Row.ItemArray[7]; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public AddDepartment(bool temp) { try { InitializeComponent(); howform = temp; WorkSQL.sql_p = "select Название from show_title"; cbx_title.ItemsSource = WorkSQL.ConvertQueryToComboBox(); WorkSQL.sql_p = "select Тип from show_type"; cbx_type.ItemsSource = WorkSQL.ConvertQueryToComboBox(); if (howform) { mainwin.Title = "Добавить отделение"; btn_add.Content = "Добавить"; } else { mainwin.Title = "Изменить отделение"; btn_add.Content = "Изменить"; cbx_title.SelectedItem = WorkSQL.drv_p.Row.ItemArray[1]; cbx_type.SelectedItem = WorkSQL.drv_p.Row.ItemArray[2]; dp_date.SelectedDate = (DateTime)WorkSQL.drv_p.Row.ItemArray[3]; txt_phone.Text = WorkSQL.drv_p.Row.ItemArray[4].ToString(); txt_address.Text = WorkSQL.drv_p.Row.ItemArray[5].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public AddPayment(bool temp) { try { InitializeComponent(); howform = temp; WorkSQL.sql_p = "select Вид from show_kind"; cbx_kind.ItemsSource = WorkSQL.ConvertQueryToComboBox(); WorkSQL.sql_p = "select Номер from show_company"; cbx_company.ItemsSource = WorkSQL.ConvertQueryToComboBox(); WorkSQL.sql_p = "select department_code from show_available('" + WorkSQL.login_p + "');"; cbx_department.ItemsSource = WorkSQL.ConvertQueryToComboBox(); if (howform) { mainwin.Title = "Добавить платёж"; btn_add.Content = "Добавить"; } else { mainwin.Title = "Изменить платёж"; btn_add.Content = "Изменить"; cbx_kind.SelectedItem = WorkSQL.drv_p.Row.ItemArray[1]; dp_date.SelectedDate = (DateTime)WorkSQL.drv_p.Row.ItemArray[2]; txt_amount.Text = WorkSQL.drv_p.Row.ItemArray[3].ToString(); cbx_company.SelectedItem = WorkSQL.drv_p.Row.ItemArray[6].ToString(); cbx_department.SelectedItem = WorkSQL.drv_p.Row.ItemArray[5].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public DeleteUsers() { InitializeComponent(); WorkSQL.sql_p = "select select_all_users_from_group('Tax_SuperVisor')"; cbx_login.ItemsSource = WorkSQL.ConvertQueryToComboBox(); }