private void cbFilterStandart_CheckedChanged(object sender, EventArgs e)
{
switch (cbFilterStandart.CheckState)
{
case (CheckState.Checked):
DataBaseTables data = new DataBaseTables();
data.qrDepartment = filterDepartment + " and [Department_Number] like '%" + tbDepartmentSearch.Text + "%' or [Department_Name] like '%" + tbDepartmentSearch.Text + "%'";
data.dtDepartmentFill();
dgvDepartment.DataSource = data.dtDepartment;
dgvDepartment.Columns[0].Visible = false;
dgvDepartment.Columns[1].HeaderText = "Номер специальности";
dgvDepartment.Columns[2].HeaderText = "Название специальности";
dgvDepartment.Columns[3].Visible = false;
dgvDepartment.Columns[4].HeaderText = "Группа стандартов";
dgvDepartment.Columns[5].Visible = false;
break;
case (CheckState.Unchecked):
dgvDepartmentFill();
for (int i = 0; i < dgvDepartment.RowCount; i++)
{
for (int j = 0; j < dgvDepartment.ColumnCount; j++)
{
if (dgvDepartment.Rows[i].Cells[j].Value != null)
{
if (dgvDepartment.Rows[i].Cells[j].Value.ToString().Contains(tbDepartmentSearch.Text))
{
dgvDepartment.Rows[i].Selected = true;
}
}
}
}
break;
}
}
private void dgvDepartmentFill()
{
Action action = () =>
{
try
{
DataBaseTables data = new DataBaseTables();
filterDepartment = data.qrDepartment;
data.dtDepartmentFill();
data.dependency.OnChange += onchangeDepartment;
dgvDepartment.DataSource = data.dtDepartment;
dgvDepartment.Columns[0].Visible = false;
dgvDepartment.Columns[1].HeaderText = "Номер специальности";
dgvDepartment.Columns[2].HeaderText = "Название специальности";
dgvDepartment.Columns[3].Visible = false;
dgvDepartment.Columns[4].HeaderText = "Группа стандартов";
dgvDepartment.Columns[5].Visible = false;
}
catch
{
}
};
Invoke(action);
}
private void DepartmentFill()
{
DataBaseTables dataDepartment = new DataBaseTables();
dataDepartment.dtDepartmentFill();
comboBoxDepartment.DataSource = dataDepartment.dtDepartment;
comboBoxDepartment.ValueMember = "ID_Department";
comboBoxDepartment.DisplayMember = "Departments_List";
}
private void cbDepartmentFill()
{
Action action = () =>
{
DataBaseTables tables = new DataBaseTables();
tables.dtDepartmentFill();
tables.dependency.OnChange += onchangeDepartment;
cbDepartment.DataSource = tables.dtDepartment;
cbDepartment.ValueMember = "ID_Department";
cbDepartment.DisplayMember = "Departments_List";
};
Invoke(action);
}
private void departmentFill()
{
Action action = () =>
{
try
{
DataBaseTables data = new DataBaseTables();
data.dtDepartmentFill();
data.dependency.OnChange += onChangeDepartment;
cbDepartment.DataSource = data.dtDepartment;
cbDepartment.ValueMember = "ID_Department";
cbDepartment.DisplayMember = "Departments_List";
}
catch
{
}
};
Invoke(action);
}
private void DepartmentLoad()
{
Action action = () =>
{
try
{
DataBaseTables tables = new DataBaseTables();
tables.dtDepartmentFill();
tables.dependency.OnChange += Departmentonchange;
cbDepartment.DataSource = tables.dtDepartment;
cbDepartment.ValueMember = "ID_Department";
cbDepartment.DisplayMember = "Departments_List";
}
catch
{
}
};
Invoke(action);
Thread threadGroup = new Thread(GroupLoad);
threadGroup.Start();
}
