private void btKadr_UchetExcel_Click(object sender, EventArgs e)
{
switch (Registry_Class.DirPath == "Empty" || Registry_Class.DocBM == 0.0 || Registry_Class.DocTM == 0.0 ||
Registry_Class.DocRM == 0.0 || Registry_Class.DocLM == 0.0)
{
case (true):
AppConfigForm configForm = new AppConfigForm();
configForm.ShowDialog();
break;
case (false):
btVih_DocWord.Enabled = false;
DataBaseTables data = new DataBaseTables();
data.qrKadr_uchet = "select [sotrudnik_id] as \"Код сотрудника\" ,[tabel_zarplata_id] as \"Код табеля ЗП\", [pribil_i_rashodi_id] as \"Код прибыли и расходов\" from [dbo].[kadr_uchet]";
ExcelDocument document = new ExcelDocument();
document.GroupDisciplineCreate();
btVih_DocWord.Enabled = true;
break;
}
}
private void btVih_DocWord_Click(object sender, EventArgs e)
{
switch (Registry_Class.DirPath == "Empty")
{
case (true):
AppConfigForm configForm = new AppConfigForm();
configForm.ShowDialog();
break;
case (false):
btVih_DocWord.Enabled = false;
DataBaseTables data = new DataBaseTables();
data.qrVih_doc = "select [prodaja_tovara_id] as \"Код продажи товара\",[kadr_uchet_id] as \"Код кадрового учета\", [ident_tov_party_id] as \"Код идентификации товарных партий\" from [dbo].[vih_doc]";
data.dtVih_docFill();
WordDocument document = new WordDocument();
document.table = data.dtVih_doc;
document.Vih_DocWord();
btVih_DocWord.Enabled = true;
break;
}
}
private void btKadr_UchetWord_Click(object sender, EventArgs e)
{
switch (Registry_Class.DirPath == "Empty")
{
case (true):
AppConfigForm configForm = new AppConfigForm();
configForm.ShowDialog();
break;
case (false):
btKadr_UchetWord.Enabled = false;
DataBaseTables data = new DataBaseTables();
data.qrKadr_uchet = "select [sotrudnik_id] as \"Код сотрудника\" ,[tabel_zarplata_id] as \"Код табеля ЗП\", [pribil_i_rashodi_id] as \"Код прибыли и расходов\" from [dbo].[kadr_uchet]";
data.dtKadr_uchetFill();
WordDocument document = new WordDocument();
document.table = data.dtKadr_uchet;
document.Kadr_UchetWord();
btKadr_UchetWord.Enabled = true;
break;
}
}
private void btWordCheck_Click(object sender, EventArgs e)
{
switch (Registry_Class.DirPath == "Empty")
{
case (true):
AppConfigForm configurationForm = new AppConfigForm();
configurationForm.ShowDialog();
break;
case (false):
btCheckWord.Enabled = false;
DataBaseTables data = new DataBaseTables();
data.qrCheck_vid_med =
"select [nom_check] as \"Номер чека\",[nazv_vid_med] as \"Название медикаментов\", [doljnost_id] as \"Код должности\",[sotrudnik_id] as \"Код сотрудников\" from [dbo].[check_vid_med]";
data.dtCheck_vid_medFill();
WordDocument document = new WordDocument();
document.table = data.dtCheck_vid_med;
document.CheckWord();
btCheckWord.Enabled = true;
break;
}
}
private void системаToolStripMenuItem1_Click(object sender, EventArgs e)
{
AppConfigForm wordFrm = new AppConfigForm();
wordFrm.ShowDialog();
}
