private void button5_Click(object sender, EventArgs e) { var row = dataGridList.SelectedRows.Count > 0 ? dataGridList.SelectedRows[0] : null; if (row == null) { MessageBox.Show("Сначала выбирете строку", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var form = new ParametrProduct(); form.name_product.Text = row.Cells["name"].Value.ToString(); form.textBox_kol.Text = row.Cells["kol"].Value.ToString(); var res = form.ShowDialog(); if (res == DialogResult.OK) { var name = form.name_product.Text; var Koll = form.textBox_kol.Text; //var delta = (ish - Convert.ToInt32(Koll)).ToString(); //Kol = Kol + Convert.ToInt32(koll); if (Convert.ToInt32(Koll) > Convert.ToInt32(ish)) { MessageBox.Show("Превышено количество товара на складе", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var id = row.Cells["id"].Value.ToString(); var connection = new SqlConnection(connectionString); connection.Open(); var request = @"UPDATE help_prod SET name='" + name + "',kol='" + Koll + "' WHERE Id='" + id + "'"; //var request1 = @"UPDATE Product SET Quantity='" + delta + "' WHERE NameOfItem='" + name + "'"; var command = new SqlCommand(request, connection); //var command1 = new SqlCommand(request1, connection); command.ExecuteNonQuery(); //command1.ExecuteNonQuery(); connection.Close(); updateListDGV(); updateScladDGV(); } } }
private void button2_Click(object sender, EventArgs e) { var row = dataGrid_Sclad.SelectedRows.Count > 0 ? dataGrid_Sclad.SelectedRows[0] : null; if (row == null) { MessageBox.Show("Сначала выбирете строку", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var form = new ParametrProduct(); form.name_product.Text = row.Cells["NameOfItem"].Value.ToString(); var res = form.ShowDialog(); var NName = row.Cells["NameOfItem"].Value.ToString(); var Query = @"SELECT Id FROM Product WHERE NameOfItem='" + NName + "'"; SqlDataAdapter AORder = new SqlDataAdapter(Query, connectionString); DataTable Ttable = new DataTable(); AORder.Fill(Ttable); string Res1 = ""; foreach (DataRow Row in Ttable.Rows) { Res1 = Row["Id"].ToString(); if (Res1 != "") { break; } } //var nomer = row.Cells["Id"].Value.ToString(); if (res == DialogResult.OK) { string resName = ""; if (i != 1) { var que = @"SELECT name FROM help_prod WHERE Id=(SELECT MAX(Id) FROM help_prod)"; SqlDataAdapter rder = new SqlDataAdapter(que, connectionString); DataTable taBle = new DataTable(); rder.Fill(taBle); foreach (DataRow Roww in taBle.Rows) { resName += Roww["name"].ToString(); if (NName == resName) { MessageBox.Show("Вы уже добавили данный товар. Измените его количество или удалите.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } if (NName != resName) { var query = @"SELECT Id FROM help_prod WHERE Id=(SELECT MAX(Id) FROM help_prod)"; SqlDataAdapter aOrder = new SqlDataAdapter(query, connectionString); DataTable table = new DataTable(); aOrder.Fill(table); string res1 = ""; foreach (DataRow Row in table.Rows) { res1 += Row["Id"].ToString(); } if (res1 == "") { int m = 1; res1 = m.ToString(); } else { int m = Convert.ToInt32(res1); m++; res1 = m.ToString(); // Kol = 0; } var quer = @"SELECT Id FROM InfoTovar WHERE Id=(SELECT MAX(Id) FROM InfoTovar)"; SqlDataAdapter AOrder = new SqlDataAdapter(quer, connectionString); DataTable Table = new DataTable(); AOrder.Fill(Table); string ress = ""; foreach (DataRow Row in Table.Rows) { ress += Row["Id"].ToString(); } if (ress == "") { int m = 1; ress = m.ToString(); } else { int m = Convert.ToInt32(ress); m++; ress = m.ToString(); } var query1 = @"SELECT Product.NameOfItem,Buhgalteria.price FROM Product JOIN Product_has_Price ON Product.Id=Product_has_Price.product_id JOIN Buhgalteria ON Buhgalteria.Id=Product_has_Price.price_id WHERE Product.Id='" + Res1 + "'"; SqlDataAdapter aOrder1 = new SqlDataAdapter(query1, connectionString); DataTable table1 = new DataTable(); aOrder1.Fill(table1); var res2 = ""; foreach (DataRow Row1 in table1.Rows) { res2 += Row1["price"].ToString(); } var max_kol = row.Cells["KolVo"].Value.ToString(); var koll = form.textBox_kol.Text; Kol = Kol + Convert.ToInt32(koll); if (Convert.ToInt32(koll) > Convert.ToInt32(max_kol)) { MessageBox.Show("Превышено количество товара на складе", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { ish = 0; ish = Convert.ToInt32(max_kol); max_kol = (Convert.ToInt32(max_kol) - Kol).ToString(); var Price = res2; itogo += Convert.ToInt32(koll) * Convert.ToInt32(Price); // var menh_kol = (Convert.ToInt32(max_kol) - Convert.ToInt32(koll)).ToString(); var nname = form.name_product.Text; var id = res1; var idd = /*row.Cells["id"].Value.ToString();*/ Res1; var time = DateTime.Today; nums[Convert.ToInt32(id)] = Convert.ToInt32(idd); numsss[Convert.ToInt32(ress)] = Convert.ToInt32(ress); var connection = new SqlConnection(connectionString); connection.Open(); var request = @"INSERT INTO help_prod (name, kol,Id,price) VALUES ('" + nname + "','" + koll + "','" + id + "','" + Price + "')"; //var request1 = @"SELECT NameOfItem, SUM(Quantity) AS KolVo FROM Product //WHERE Product.ValidUntil > '" + time.ToString("yyyy-MM-dd") + "' AND NameOfItem!= '" + nname + "' GROUP BY NameOfItem ORDER BY KolVo DESC"; var request2 = @"INSERT INTO InfoTovar (Nazvanie, kol,Id,Price) VALUES ('" + nname + "','" + koll + "','" + ress + "','" + Price + "')"; var command = new SqlCommand(request, connection); command.ExecuteNonQuery(); //var command1 = new SqlCommand(request1, connection); //command1.ExecuteNonQuery(); var command3 = new SqlCommand(request2, connection); command3.ExecuteNonQuery(); connection.Close(); updateListDGV(); updateScladDGV(); i++; } } } }