private void заявкаToolStripMenuItem_Click(object sender, EventArgs e) { FormApplication app = new FormApplication(); app.ShowDialog(); }
//Выбор заявки private void buttonPick_Click(object sender, EventArgs e) { FormApplication app = new FormApplication(); app.toolStrip1.Visible = false; app.dateTimePicker.Enabled = false; app.comboBoxSeria.Enabled = false; app.comboBoxAuto.Enabled = false; app.comboBoxContragent.Enabled = false; app.textBoxCountAuto.ReadOnly = true; app.ShowDialog(); RequestID = app.getID(); if (RequestID != "") { //Остаток selectCommand = "select AutoID from Application where ID='" + RequestID + "'"; string AutoID = selectValue(ConnectionString, selectCommand).ToString(); selectCommand = "select SUM(Count) from Entrance where date(Date) <= date('" + dateTimePicker.Value.ToString("yyyy-MM-dd") + "') AND AutoID ='" + AutoID + "'"; string AutoEntrance = selectValue(ConnectionString, selectCommand).ToString(); if (AutoEntrance == "") { AutoEntrance = "0"; } selectCommand = "select SUM(a.CountAuto) from Sale s JOIN Application a ON s.RequestID = a.ID where date(s.Date) <= date('" + dateTimePicker.Value.ToString("yyyy-MM-dd") + "') AND AutoID ='" + AutoID + "'"; string AutoSale = selectValue(ConnectionString, selectCommand).ToString(); if (AutoSale == "") { AutoSale = "0"; } int Ostatok = Convert.ToInt32(AutoEntrance) - Convert.ToInt32(AutoSale); selectCommand = "select CountAuto from Application where ID='" + RequestID + "'"; string CountAuto = selectValue(ConnectionString, selectCommand).ToString(); selectCommand = "select SaleCost from Service where ID = (select ServiceID from Application where ID = '" + RequestID + "')"; if (Ostatok < Convert.ToInt32(CountAuto)) { MessageBox.Show("Остаток данной серии автомобилей составляет " + Ostatok + ". Продажа невозможна", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { comboBoxRequest.SelectedValue = RequestID; selectCommand = "select SaleCost from Auto where ID = (select AutoID from Application where ID = '" + RequestID + "')"; AutoSum = selectValue(ConnectionString, selectCommand).ToString(); selectCommand = "select SaleCost from Service where ID = (select ServiceID from Application where ID = '" + RequestID + "')"; ServiceSum = selectValue(ConnectionString, selectCommand).ToString(); string CountService; if (ServiceSum == "") { ServiceSum = "0"; CountService = "0"; } else { selectCommand = "select CountService from Application where ID = '" + RequestID + "'"; CountService = selectValue(ConnectionString, selectCommand).ToString(); } AutoSum = (Convert.ToDecimal(AutoSum) * Convert.ToDecimal(CountAuto)).ToString(); ServiceSum = (Convert.ToDecimal(ServiceSum) * Convert.ToDecimal(CountService)).ToString(); textBoxSum.Text = (Convert.ToDecimal(AutoSum) + Convert.ToDecimal(ServiceSum)).ToString(); } } }