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";
}
