private void number_of_order_Click(object sender, EventArgs e) { var form = new NumberOfOrder(); var res = form.ShowDialog(); if (res == DialogResult.OK) { var number_of_order = form.numberoforder_textbox.Text; number_textbox.Text = number_of_order; var request = @"SELECT * FROM InfoTovar JOIN SaveInfo ON InfoTovar.Id = SaveInfo.id_info JOIN Nakladnie ON SaveInfo.id_nakladS = Nakladnie.Id WHERE Nakladnie.Id = '" + number_of_order + "'"; var adapter = new SqlDataAdapter(request, connectionString); DataTable delivery = new DataTable(); adapter.Fill(delivery); delivery_dgv.DataSource = delivery; delivery_dgv.Columns["Id"].Visible = false; delivery_dgv.Columns["Naklad"].Visible = false; delivery_dgv.Columns["id_nakladS"].Visible = false; delivery_dgv.Columns["id_info"].Visible = false; delivery_dgv.Columns["Id1"].Visible = false; delivery_dgv.Columns["delivery_flag"].Visible = false; delivery_dgv.Columns["Nazvanie"].HeaderText = "Позиция"; delivery_dgv.Columns["Price"].HeaderText = "Цена"; delivery_dgv.Columns["kol"].HeaderText = "Количество"; } }
private void pickuporder_Click(object sender, EventArgs e) { var connection = new SqlConnection(connectionString); connection.Open(); var form = new NumberOfOrder(); var number = number_textbox.Text; if (number == "") { MessageBox.Show("Укажите номер заказа!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Question); } //var Query = @"SELECT * FROM Nakladnie // JOIN SaveInfo // ON Nakladnie.Id = SaveInfo.id_nakladS // JOIN InfoTovar // ON SaveInfo.id_info = InfoTovar.Id // WHERE Nakladnie.Id = '" + number + "'"; var Query = @"SELECT * FROM InfoTovar JOIN SaveInfo ON InfoTovar.Id = SaveInfo.id_info JOIN Nakladnie ON SaveInfo.id_nakladS = Nakladnie.Id WHERE Nakladnie.Id = '" + number + "'"; SqlDataAdapter AORder = new SqlDataAdapter(Query, connectionString); DataTable Ttable = new DataTable(); AORder.Fill(Ttable); var flag_req = @"SELECT delivery_flag FROM Nakladnie WHERE Nakladnie.Id = '" + number + "'"; var command_flag = new SqlCommand(flag_req, connection); command_flag.ExecuteNonQuery(); SqlDataAdapter order_flag = new SqlDataAdapter(flag_req, connectionString); DataTable table_flag = new DataTable(); order_flag.Fill(table_flag); var flag = 0; foreach (DataRow Row in table_flag.Rows) { flag = Convert.ToInt32(Row["delivery_flag"].ToString()); } if (flag == 1) { MessageBox.Show("Товар уже выдан!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Hand); } else { var Tovar = ""; var Kolvo = 0; var KolvonaSklade = 0; var id = 0; foreach (DataRow Row in Ttable.Rows) { Tovar = Row["Nazvanie"].ToString(); Kolvo = Convert.ToInt32(Row["kol"].ToString()); var request1 = @"SELECT Id, Quantity FROM Product WHERE Product.NameOfItem = '" + Tovar + "' AND Product.Quantity > 0"; var command1 = new SqlCommand(request1, connection); command1.ExecuteNonQuery(); SqlDataAdapter Order = new SqlDataAdapter(request1, connectionString); DataTable table = new DataTable(); Order.Fill(table); foreach (DataRow dbRow in table.Rows) { KolvonaSklade = Convert.ToInt32(dbRow["Quantity"].ToString()); id = Convert.ToInt32(dbRow["Id"].ToString()); if (Kolvo < KolvonaSklade) { var request = @"UPDATE Product SET Quantity = Quantity - '" + Kolvo + "' WHERE Product.Id = '" + id + "'"; var command = new SqlCommand(request, connection); command.ExecuteNonQuery(); break; } else { var request = @"UPDATE Product SET Quantity = 0 WHERE Product.Id = '" + id + "'"; var command = new SqlCommand(request, connection); command.ExecuteNonQuery(); Kolvo -= KolvonaSklade; continue; } } } var flag_new = @"UPDATE Nakladnie SET delivery_flag = 1 WHERE Nakladnie.Id = '" + number + "'"; var command_flag_new = new SqlCommand(flag_new, connection); command_flag_new.ExecuteNonQuery(); this.Close(); MessageBox.Show("Товар успешно выдан", "Success", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } connection.Close(); }