private void Insert_String() { if (identify == "kartochka") { Kartochka kartochka = new Kartochka(MySqlQueries, MySqlOperations, null); string output = string.Empty; kartochka.button1.Visible = true; kartochka.button3.Visible = false; kartochka.button4.Visible = false; kartochka.button5.Visible = false; kartochka.button6.Visible = false; kartochka.button7.Visible = false; kartochka.button8.Visible = false; kartochka.label6.Visible = false; kartochka.label7.Visible = false; kartochka.dataGridView1.Visible = false; kartochka.dataGridView2.Visible = false; MySqlOperations.Select_Text(MySqlQueries.Select_Otdely_ComboBox_by_ID, ref output, ID); MySqlOperations.Search_In_ComboBox(output, kartochka.comboBox1); kartochka.comboBox1.DropDownStyle = ComboBoxStyle.Simple; kartochka.comboBox1.Enabled = false; kartochka.ShowDialog(); MySqlOperations.Select_DataGridView(MySqlQueries.Select_Kartochka_Otdela, dataGridView1, ID); } }
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"; }
private void Proverka_Ostatka() { string output = string.Empty; MySqlOperations.Select_Text(MySqlQueries.Select_Kartochka_Ostatok, ref output, ID); if (decimal.Parse(output) == decimal.Parse("0,00")) { if (MessageBox.Show("Необходимое количество отходов уже собрано." + '\n' + "Желаете отправить собранные отходы на утилизацию?", "Вопрос", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { Ubytiya ubytiya = new Ubytiya(MySqlQueries, MySqlOperations, ID); ubytiya.button1.Visible = true; ubytiya.button3.Visible = false; ubytiya.dateTimePicker1.MinDate = DateTime.Parse(dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[2].Value.ToString()); ubytiya.dateTimePicker1.MaxDate = dateTimePicker2.Value; ubytiya.ShowDialog(); MySqlOperations.Select_DataGridView(MySqlQueries.Select_Ubytiya_Kartochki, dataGridView2, ID); button4.Enabled = false; button5.Enabled = false; button6.Enabled = false; button7.Enabled = false; button8.Enabled = false; } } }
private void карточкиОтходовToolStripMenuItem_Click(object sender, EventArgs e) { MySqlOperations.Select_DataGridView(MySqlQueries.Select_Kartochka, dataGridView1); identify = "kartochka"; }