private void SotrLoad()
{
try
{
Action action = () =>
{
try
{
DataBaseTables dataComb = new DataBaseTables();
dataComb.dtSotr.Clear();
dataComb.dtSotrFill();
dataComb.dependency.OnChange += Sotronchange;
dataGridView1.DataSource = dataComb.dtSotr;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].Visible = false;
dataGridView1.Columns[2].Visible = false;
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns[5].HeaderText = "Дата рождения";
dataGridView1.Columns[6].HeaderText = "Адрес проживания";
}
catch
{
}
};
Invoke(action);
}
catch { }
}
public void SotrLoad()
{
try
{
Action action = () =>
{
try
{
DataBaseTables dataComb = new DataBaseTables();
dataComb.dtSotr.Clear();
dataComb.dtSotrFill();
//Test function
dataComb.dependency.OnChange += Sotronchange;
comboBox2.DataSource = dataComb.dtSotr;
comboBox2.ValueMember = "Login_Sotr";
comboBox2.DisplayMember = "ФИО";
imya = comboBox2.Text;
}
catch
{
}
};
Invoke(action);
}
catch { }
}
public void otch()
{
Documentacia configurationForm = new Documentacia();
configurationForm.Documentacia_Load(null, null);
switch (Registry_Class.DirPath == "Empry" || Registry_Class.OrganizationName == "Empty" ||
Registry_Class.DocBM == 0.0 || Registry_Class.DocTM == 0.0 ||
Registry_Class.DocRM == 0.0 || Registry_Class.DocLM == 0.0)
{
case (true):
configurationForm.ShowDialog();
break;
case (false):
DataBaseTables data = new DataBaseTables();
data.qrSotr = "SELECT dbo.Sotr.Surname_Sotr + ' ' + dbo.Sotr.Name_Sotr + ' ' + dbo.Sotr.Middle_name_Sotr, dbo.Sotr.The_date_of_the_Rojd, dbo.Access_rights.Dolj FROM dbo.Access_rights INNER JOIN dbo.Profile ON dbo.Access_rights.ID_Access_rights = dbo.Profile.Access_rights_ID INNER JOIN dbo.Sotr ON dbo.Profile.Login_Profile = dbo.Sotr.Login_Sotr ORDER BY dbo.Access_rights.Dolj ASC";
data.dtSotrFill();
ExcelDocument document = new ExcelDocument();
document.dtDannieSklada = data.dtSotr;
document.SpisokSotr();
break;
}
}
