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 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; }
private void button1_Click(object sender, EventArgs e) { MySqlOperations.OpenConnection(); MySqlOperations.Select_Text(MySqlQueries.Select_Avtorizacia, ref ID, null, textBox1.Text, textBox2.Text); if (ID == "1") { MySqlOperations.Select_Text(MySqlQueries.Select_SignIn, ref ID, null, textBox1.Text); if (ID == "0") { this.DialogResult = DialogResult.Yes; } else { this.DialogResult = DialogResult.No; } this.Close(); } else { MessageBox.Show("Неверный пароль или логин.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } MySqlOperations.CloseConnection(); }
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 button1_Click(object sender, EventArgs e) { if (textBox1.Text != "") { string output = string.Empty; textBox1.Text = textBox1.Text.Replace('.', ','); MySqlOperations.Select_Text(MySqlQueries.Select_Kartochka_Ostatok, ref output, ID); if (output == "" || decimal.Parse(output) >= decimal.Parse(textBox1.Text)) { string date1 = dateTimePicker1.Value.Year.ToString() + '-' + dateTimePicker1.Value.Month.ToString() + '-' + dateTimePicker1.Value.Day.ToString(); MySqlOperations.Insert_Update(MySqlQueries.Insert_Pribytiya, ID, date1, textBox1.Text); this.Close(); } else { MessageBox.Show("Количество больше остатка." + '\n' + "Остаток: " + output, "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("Поле 'Количество' не заполнено.", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }