private void Search_Adm_Load(object sender, EventArgs e)
{
bindingNavigator1.Visible = false;
//Запрос для вытягивания списка таблиц
dtQuery = DB.LoadTable($"select TABLE_NAME from INFORMATION_SCHEMA.TABLES", "Load_all_tables");
//Заполнение combobox списком таблиц
QuicklyChangeDB.ComboSettings(dtQuery, "TABLE_NAME", "TABLE_NAME", combo_objectSearch);
}
private void Get_Documents_inf_Load(object sender, EventArgs e)
{
GridViewStyles.ChancheViewGrid(grid_info_all);
bs_login.DataSource = dt;
bs_KL.DataSource = dt2;
dt = DB.LoadTable("SELECT Т_Клиент.ID_Клиента as aa, Т_Клиент.ФИО as bb FROM Т_Клиент", "Т_Клиент");
dt2 = DB.LoadTable($"SELECT * FROM Т_Клиент WHERE ФИО = {comboBox_Klient.Text}", "Т_Клиент");
QuicklyChangeDB.ComboSettings(dt, "ФИО", "ID_Клиента", comboBox_Klient);
}
private void Form1_Load(object sender, EventArgs e)
{
//* in password
text_password.UseSystemPasswordChar = true;
ToolTip tip = new ToolTip();
tip.Active.ToString();
tip.BackColor = System.Drawing.Color.BlueViolet;
tip.SetToolTip(text_password, "Обязательное поле для ввода!");
BindingSource bs_login = new BindingSource();
dt = DB.LoadTable("SELECT * FROM Login", "Login");
bs_login.DataSource = dt;
QuicklyChangeDB.ComboSettings(dt, "Access_rights", "ID_rights", combo_login);
}
private void Add_Dogovora_Load(object sender, EventArgs e)
{
BindingSource bs_language = new BindingSource();
BindingSource bs_curator = new BindingSource();
BindingSource bs_sotr = new BindingSource();
bs_language.DataSource = dt_lang;
bs_curator.DataSource = dt_curator;
bs_sotr.DataSource = dt_sotr;
dt_lang = DB.LoadTable("SELECT Т_Языки_прог.КодЯзыка as aa, Т_Языки_прог.Язык as bb FROM Т_Языки_прог", "Т_Языки_прог");
dt_curator = DB.LoadTable("SELECT Т_Кураторы.ID_Куратора as aa, Т_Кураторы.ФИО as bb FROM Т_Кураторы", "Т_Кураторы");
dt_sotr = DB.LoadTable("SELECT Т_Штат_сотрудников.ID_сотрудника as aa, Т_Штат_сотрудников.ФИО as bb FROM Т_Штат_сотрудников", "Т_Штат_сотрудников");
QuicklyChangeDB.ComboSettings(dt_lang, "Язык", "КодЯзыка", comboBox_language_dog);
QuicklyChangeDB.ComboSettings(dt_curator, "ФИО", "ID_Куратора", combo_Curator);
QuicklyChangeDB.ComboSettings(dt_sotr, "ФИО", "ID_сотрудника", comboBox_sotryd_dog);
}