//TabPage Канцелярия
private void MagazineStationeryFill() //Заполнение таблицы Техника
{
DBTables dbTables = new DBTables();
Action action = () =>
{
try
{
dbTables.DTMagazineStationery.Clear();
dbTables.DTMagazineStationeryFill();
dbTables.dependency.OnChange += ChangeStationery;
dgvStationery.DataSource = dbTables.DTMagazineStationery;
dgvStationery.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvStationery.Columns[0].HeaderText = "№ п/п";
dgvStationery.Columns[1].HeaderText = "Производитель";
dgvStationery.Columns[2].HeaderText = "Название";
dgvStationery.Columns[3].HeaderText = "Тип";
dgvStationery.Columns[4].HeaderText = "Количество";
dgvStationery.Columns[5].HeaderText = "Дата принятия";
dgvStationery.Columns[5].Visible = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
};
Invoke(action);
}
private void OrdersFill() //Заполнение таблицы Заказы
{
DBTables dbTables = new DBTables();
Action action = () =>
{
try
{
dbTables.DTOrders.Clear();
dbTables.DTOrderFill();
dbTables.dependency.OnChange += ChangeOrder;
dgvOrders.DataSource = dbTables.DTOrders;
dgvOrders.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvOrders.Columns[0].Width = 30;
dgvOrders.Columns[0].HeaderText = "№ п/п";
dgvOrders.Columns[1].HeaderText = "Описание";
dgvOrders.Columns[1].Width = 250;
dgvOrders.Columns[2].HeaderText = "Дата заказа";
dgvOrders.Columns[3].HeaderText = "Статус заказа";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
};
Invoke(action);
}
private void RoleFill()
{
DBTables dbTables = new DBTables();
Action action = () =>
{
try
{
dbTables.DTRoles.Clear();
dbTables.DTRolesForComboBoxFill();
dbTables.dependency.OnChange += ChangeRole;
cbRole.DataSource = dbTables.DTRoles;
cbRole.ValueMember = "ID_role";
cbRole.DisplayMember = "role_name";
cbRole.SelectedValue = -1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
};
Invoke(action);
}