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 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 Inform_Load(object sender, EventArgs e) { GridViewStyles.ChancheViewGrid(grid_KL_DOG); grid_KL_DOG.Visible = false; QuicklyChangeDB.TextBox(bs_Client, "ФИО", text_fio); QuicklyChangeDB.TextBox(bs_Client, "Адрес", text_adres); QuicklyChangeDB.TextBox(bs_Client, "Реквизиты банка", text_rec); QuicklyChangeDB.TextBox(bs_Client, "ID_Клиента", textBox_KL); QuicklyChangeDB.Picturebox("Image", pic_client, bs_Client, "Фото", true); }
private void button2_Click(object sender, EventArgs e) { if (grid_curator.Columns.Contains("Information")) { grid_curator.Columns.Remove("Information"); } //For Tables T_Position bs_Dol.DataSource = DB.ds.Tables["Т_Должность"]; grid_curator.DataSource = bs_Dol; //GridViewStyles.GridClear(grid_for_all); bindingNavigator1.BindingSource = bs_Dol; QuicklyChangeDB.GridVisible(new string[] { "ID_Должности" }, grid_curator); }
private void button_see_client_Click_1(object sender, EventArgs e) { if (grid_curator.Columns.Contains("Del")) { grid_curator.Columns.Remove("Del"); } //For Tables T_Client DataTable dt = DB.ds.Tables["Т_Клиент"]; bs_Client.DataSource = DB.ds.Tables["Т_Клиент"]; grid_curator.DataSource = bs_Client; bindingNavigator1.BindingSource = bs_Client; QuicklyChangeDB.GridVisible(new string[] { "Фото", "ID_Клиента" }, grid_curator); }
private void button_client_Click(object sender, EventArgs e) { GridViewStyles.ButtonGrid("Information", "Inf", "Подробнее", grid_for_all, inf); GridViewStyles.ButtonGrid("Del", "Delite", "Удалить", grid_for_all, inf); //For Tables T_Client DataTable dt = DB.ds.Tables["Т_Клиент"]; bs_Client.DataSource = DB.ds.Tables["Т_Клиент"]; grid_for_all.DataSource = bs_Client; bindingNavigator1.BindingSource = bs_Client; QuicklyChangeDB.GridVisible(new string [] { "Фото", "ID_Клиента" }, grid_for_all); }
private void button3_Click(object sender, EventArgs e) { GridViewStyles.ChancheViewGrid(grid_for_all); if (grid_for_all.Columns.Contains("Information") && grid_for_all.Columns.Contains("Del") && grid_for_all.Columns.Contains("ChangeContext")) { grid_for_all.Columns.Remove("Information"); grid_for_all.Columns.Remove("Del"); grid_for_all.Columns.Remove("ChangeContext"); } grid_for_all.DataSource = bs_curator; bindingNavigator1.BindingSource = bs_curator; QuicklyChangeDB.GridVisible(new string[] { "ID_Куратора", "Должность" }, grid_for_all); }
private void button4_Click(object sender, EventArgs e) { GridViewStyles.ChancheViewGrid(grid_curator); if (grid_curator.Columns.Contains("Information") && grid_curator.Columns.Contains("Del") && grid_curator.Columns.Contains("ChangeContext")) { grid_curator.Columns.Remove("Information"); grid_curator.Columns.Remove("Del"); grid_curator.Columns.Remove("ChangeContext"); } //For Tables Т_Языки_прог grid_curator.DataSource = bs_language; //GridViewStyles.GridClear(grid_for_all); bindingNavigator1.BindingSource = bs_language; QuicklyChangeDB.GridVisible(new string[] { "КодЯзыка" }, grid_curator); }
private void button_Dol_Click(object sender, EventArgs e) { GridViewStyles.ButtonGrid("ChangeContext", "Изменить", "Изменить", grid_for_all, izm); if (grid_for_all.Columns.Contains("Information") && grid_for_all.Columns.Contains("Del")) { grid_for_all.Columns.Remove("Information"); grid_for_all.Columns.Remove("Del"); } //For Tables T_Position bs_Dol.DataSource = DB.ds.Tables["Т_Должность"]; grid_for_all.DataSource = bs_Dol; bindingNavigator1.BindingSource = bs_Dol; QuicklyChangeDB.GridVisible(new string[] { "ID_Должности" }, grid_for_all); }
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); }
private void button1_Click(object sender, EventArgs e) { using (myCreatePO_projectEntities context = new myCreatePO_projectEntities()) { var x = from z in context.Т_ВидыРабот select z.Нормо_часов; } if (grid_curator.Columns.Contains("Information") && grid_curator.Columns.Contains("Del") && grid_curator.Columns.Contains("ChangeContext")) { grid_curator.Columns.Remove("Information"); grid_curator.Columns.Remove("Del"); grid_curator.Columns.Remove("ChangeContext"); } //For Tables Т_Договора Архив bs_work.DataSource = DB.ds.Tables["Т_ВидыРабот"]; grid_curator.DataSource = bs_work; bindingNavigator1.BindingSource = bs_work; QuicklyChangeDB.GridVisible(new string[] { "ID_Работы", "Сумма_руб" }, grid_curator); }
private void Add_Dogovora_EditStep_Load(object sender, EventArgs e) { QuicklyChangeDB.TextBox(bs_Dog, "Название_договора", textBox_Dog); }
private void test_insert_position_Load(object sender, EventArgs e) { QuicklyChangeDB.TextBox(bs_position, "Должность", text_insert_posisiton); }