private void button2_Click(object sender, EventArgs e) { TienTraTruoc f4 = new TienTraTruoc(); var result = f4.ShowDialog(); Int64 tientratruoc = 0; if (result == DialogResult.OK) { tientratruoc = f4.ReturnValue1; } MySqlConnection connection = new MySqlConnection(MyConnectionMySQL); MySqlCommand cmd, cmd2; connection.Open(); //Lấy phân loại try { cmd2 = connection.CreateCommand(); cmd2.CommandText = @"SELECT TienDaTra FROM hoadon WHERE MaHD = @MA"; cmd2.Parameters.AddWithValue("@MA", mahoadon); Int64 res = Int64.Parse(cmd2.ExecuteScalar().ToString(), NumberStyles.AllowThousands); cmd = connection.CreateCommand(); cmd.CommandText = @"UPDATE hoadon SET TrangThai = @trangthai,TienDaTra = @datra WHERE MaHD = @MA"; cmd.Parameters.AddWithValue("@MA", mahoadon); cmd.Parameters.AddWithValue("@datra", (tientratruoc + res).ToString("#,##0")); cmd.Parameters.AddWithValue("@trangthai", "Nợ"); cmd.ExecuteNonQuery(); } catch (Exception v) { MessageBox.Show(v.Message.ToString()); //throw; } finally { connection.Close(); } HienHoaDon f = new HienHoaDon(mahoadon); f.ShowDialog(); this.Close(); }
private void button1_Click(object sender, EventArgs e) { MySqlConnection connection = new MySqlConnection(MyConnectionMySQL); MySqlCommand cmd, cmd2; connection.Open(); //Lấy phân loại try { cmd2 = connection.CreateCommand(); cmd2.CommandText = @"SELECT TongTien FROM hoadon WHERE MaHD = @MA"; cmd2.Parameters.AddWithValue("@MA", mahoadon); string s = cmd2.ExecuteScalar().ToString(); cmd = connection.CreateCommand(); cmd.CommandText = @"UPDATE hoadon SET TrangThai = @trangthai,TienDaTra = @tongtien WHERE MaHD = @MA"; cmd.Parameters.AddWithValue("@MA", mahoadon); cmd.Parameters.AddWithValue("@tongtien", s); cmd.Parameters.AddWithValue("@trangthai", "Hoàn tất"); cmd.ExecuteNonQuery(); this.Close(); } catch (Exception v) { MessageBox.Show(v.Message.ToString()); //throw; } finally { connection.Close(); } HienHoaDon f = new HienHoaDon(mahoadon); f.ShowDialog(); }