Esempio n. 1
0
        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;
            }
        }
Esempio n. 2
0
        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;
            }
        }
Esempio n. 3
0
        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;
            }
        }
Esempio n. 4
0
        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;
            }
        }
Esempio n. 5
0
        private void системаToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            AppConfigForm wordFrm = new AppConfigForm();

            wordFrm.ShowDialog();
        }