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);*/ }
// Поиск товаров по названию 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); }
// -------------- Остатки 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); }
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); } }