Esempio n. 1
0
 public Otdely(MySqlOperations mySqlOperations, MySqlQueries mySqlQueries, string iD)
 {
     InitializeComponent();
     MySqlOperations = mySqlOperations;
     MySqlQueries    = mySqlQueries;
     ID = iD;
 }
 public Sotrudniki(MySqlOperations mySqlOperations, MySqlQueries mySqlQueries, string iD)
 {
     InitializeComponent();
     MySqlOperations = mySqlOperations;
     MySqlQueries    = mySqlQueries;
     ID = iD;
     MySqlOperations.Select_ComboBox(MySqlQueries.Select_Otdely_ComboBox, comboBox1);
 }
Esempio n. 3
0
 public Othody(MySqlOperations mySqlOperations, MySqlQueries mySqlQueries, string iD)
 {
     InitializeComponent();
     MySqlOperations = mySqlOperations;
     MySqlQueries    = mySqlQueries;
     ID = iD;
     comboBox1.SelectedItem = comboBox1.Items[0];
     comboBox2.SelectedItem = comboBox2.Items[0];
 }
 public User_Main(string iD)
 {
     InitializeComponent();
     MySqlQueries    = new MySqlQueries();
     MySqlOperations = new MySqlOperations(MySqlQueries);
     ID = iD;
     MySqlOperations.Select_DataGridView(MySqlQueries.Select_Kartochka_Otdela, dataGridView1, ID);
     identify = "kartochka";
 }
Esempio n. 5
0
 public Kartochka(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD)
 {
     InitializeComponent();
     MySqlQueries    = mySqlQueries;
     MySqlOperations = mySqlOperations;
     ID = iD;
     MySqlOperations.Select_ComboBox(MySqlQueries.Select_Otdely_ComboBox, comboBox1);
     MySqlOperations.Select_ComboBox(MySqlQueries.Select_Othody_ComboBox, comboBox2);
 }
Esempio n. 6
0
        public Ubytiya(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD)
        {
            InitializeComponent();
            MySqlQueries    = mySqlQueries;
            MySqlOperations = mySqlOperations;
            ID = iD;
            MySqlOperations.Select_ComboBox(MySqlQueries.Select_Organizacii_ComboBox, comboBox1);
            string output = string.Empty;

            MySqlOperations.Select_Text(MySqlQueries.Select_Sum_Pribytiya, ref output, ID);
            textBox1.Text = output;
        }
Esempio n. 7
0
        public void Print_Vedomost(MySqlQueries mySqlQueries, SaveFileDialog saveFileDialog, DataGridView dataGridView, string ID = null)
        {
            ExcelApplication ExcelApp  = null;
            Workbooks        workbooks = null;
            Workbook         workbook  = null;
            string           output    = null;
            string           fileName  = null;

            Select_DataGridView(mySqlQueries.Select_Kartochka_Vedomost, dataGridView, ID);
            Select_Text(mySqlQueries.Select_Otdely_ComboBox_by_ID, ref output, ID);
            saveFileDialog.Title            = "Сохранить ведомость как";
            saveFileDialog.FileName         = "Ведомость отходов " + output;
            saveFileDialog.InitialDirectory = Application.StartupPath + "\\Отчеты\\";
            if (saveFileDialog.ShowDialog() == DialogResult.OK)
            {
                fileName = saveFileDialog.FileName;
                try
                {
                    ExcelApp  = new ExcelApplication();
                    workbooks = ExcelApp.Workbooks;
                    workbook  = workbooks.Open(Application.StartupPath + "\\Blanks\\Vedomost.xlsx");
                    int ExCol = 1;
                    int ExRow = 9;
                    for (int i = 0; i < dataGridView.Rows.Count - 1; i++)
                    {
                        for (int j = 0; j < dataGridView.Columns.Count; j++)
                        {
                            ExcelApp.Cells[ExRow, ExCol] = dataGridView.Rows[i].Cells[j].Value.ToString();
                            ExCol++;
                        }
                        ExCol = 1;
                        ExRow++;
                    }
                    workbook.SaveAs(fileName);
                    ExcelApp.Visible = true;
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                finally
                {
                    Marshal.ReleaseComObject(workbook);
                    Marshal.ReleaseComObject(workbooks);
                    Marshal.ReleaseComObject(ExcelApp);
                }
            }
        }
Esempio n. 8
0
        //Универсальные методы


        //Методы печати

        public void Print_Passport(MySqlQueries mySqlQueries, SaveFileDialog saveFileDialog, string ID = null)
        {
            ExcelApplication ExcelApp  = null;
            Workbooks        workbooks = null;
            Workbook         workbook  = null;
            string           output    = null;
            string           fileName  = null;

            Select_Text(mySqlQueries.Select_Kartochka_Passport, ref output, ID);
            saveFileDialog.Title            = "Сохранить сопроводительный паспорт как";
            saveFileDialog.FileName         = "Сопроводительный паспорт за " + output.Split(';')[0] + " (" + output.Split(';')[1] + ')';
            saveFileDialog.InitialDirectory = Application.StartupPath + "\\Отчеты\\";
            if (saveFileDialog.ShowDialog() == DialogResult.OK)
            {
                fileName = saveFileDialog.FileName;
                try
                {
                    ExcelApp               = new ExcelApplication();
                    workbooks              = ExcelApp.Workbooks;
                    workbook               = workbooks.Open(Application.StartupPath + "\\Blanks\\Passport.xlsx");
                    ExcelApp.Cells[15, 4]  = ID;
                    ExcelApp.Cells[15, 6]  = output.Split(';')[0];
                    ExcelApp.Cells[21, 10] = output.Split(';')[2];
                    ExcelApp.Cells[24, 6]  = output.Split(';')[3];
                    workbook.SaveAs(fileName);
                    ExcelApp.Visible = true;
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                finally
                {
                    Marshal.ReleaseComObject(workbook);
                    Marshal.ReleaseComObject(workbooks);
                    Marshal.ReleaseComObject(ExcelApp);
                }
            }
        }
Esempio n. 9
0
 public MySqlOperations(MySqlQueries sqlQueries)
 {
     this.MySqlQueries = sqlQueries;
 }
Esempio n. 10
0
 public Avtorizacia()
 {
     InitializeComponent();
     MySqlQueries    = new MySqlQueries();
     MySqlOperations = new MySqlOperations(MySqlQueries);
 }
Esempio n. 11
0
 public Main()
 {
     InitializeComponent();
     MySqlQueries    = new MySqlQueries();
     MySqlOperations = new MySqlOperations(MySqlQueries);
 }