Esempio n. 1
0
        private async void Form1_Load(object sender, EventArgs e)
        {
            await connection.OpenAsync();

            if (tabControl1.SelectedTab == tabPage1)
            {
                Remains remains = new Remains();
                remains.getAllProducts(connection, selectDbCategory, dataGridView1);
            }
            if (tabControl1.SelectedTab == tabPage2)
            {
                Postings postings = new Postings();
                postings.getAllDocuments(connection, selectDbPostings, dataGridView2);
            }
            if (tabControl1.SelectedTab == tabPage3)
            {
                Postings writeOff = new Postings();
                writeOff.getAllDocuments(connection, selectDbWriteOff, dataGridView3);
            }


            /*Remains remains = new Remains();
             * remains.getAllProducts(connection, selectDbCategory, dataGridView1);
             *
             * Postings postings = new Postings();
             * postings.getAllDocuments(connection, selectDbPostings, dataGridView2);
             *
             * Postings writeOff = new Postings();
             * writeOff.getAllDocuments(connection, selectDbWriteOff, dataGridView3);*/
        }
Esempio n. 2
0
        // Поиск товаров по названию
        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            selectDbCategory = "SELECT * FROM Products WHERE name LIKE N'%" + textBox1.Text + "%'";

            Remains remains = new Remains();

            remains.getAllProducts(connection, selectDbCategory, dataGridView1);
        }
Esempio n. 3
0
        // --------------  Остатки
        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            Remains remains = new Remains();

            if (comboBox1.Text == "Все товары" && comboBox2.Text == "Все")
            {
                selectDbCategory = "SELECT * FROM Products";
                remains.getAllProducts(connection, selectDbCategory, dataGridView1);
                return;
            }

            if (comboBox1.Text == "Все товары" && comboBox2.Text == "В наличии")
            {
                selectDbCategory = "SELECT * FROM Products WHERE (remains > 0)";
                remains.getAllProducts(connection, selectDbCategory, dataGridView1);
                return;
            }

            if (comboBox1.Text == "Все товары" && comboBox2.Text == "Нет на складе")
            {
                selectDbCategory = "SELECT * FROM Products WHERE (remains = 0)";
                remains.getAllProducts(connection, selectDbCategory, dataGridView1);
                return;
            }

            if (comboBox1.Text == "Все товары" && comboBox2.Text == "Меньше мин. остатка")
            {
                selectDbCategory = "SELECT * FROM Products WHERE (remains < min_remains)";
                remains.getAllProducts(connection, selectDbCategory, dataGridView1);
                return;
            }

            if (comboBox2.Text == "Все")
            {
                selectDbCategory = "SELECT * FROM Products WHERE category = N'" + comboBox1.Text + "'";
            }

            if (comboBox2.Text == "В наличии")
            {
                selectDbCategory = "SELECT * FROM Products WHERE category = N'" + comboBox1.Text + "' AND (remains > 0)";
            }

            if (comboBox2.Text == "Нет на складе")
            {
                selectDbCategory = "SELECT * FROM Products WHERE category = N'" + comboBox1.Text + "' AND (remains = 0)";
            }

            if (comboBox2.Text == "Меньше мин. остатка")
            {
                selectDbCategory = "SELECT * FROM Products WHERE category = N'" + comboBox1.Text + "' AND (remains < min_remains)";
            }

            remains.getAllProducts(connection, selectDbCategory, dataGridView1);
        }
Esempio n. 4
0
 private void tabControl1_Selected(object sender, TabControlEventArgs e)
 {
     if (tabControl1.SelectedTab == tabPage1)
     {
         Remains remains = new Remains();
         remains.getAllProducts(connection, selectDbCategory, dataGridView1);
     }
     if (tabControl1.SelectedTab == tabPage2)
     {
         Postings postings = new Postings();
         postings.getAllDocuments(connection, selectDbPostings, dataGridView2);
     }
     if (tabControl1.SelectedTab == tabPage3)
     {
         Postings writeOff = new Postings();
         writeOff.getAllDocuments(connection, selectDbWriteOff, dataGridView3);
     }
 }