private void btnHuy_Click(object sender, EventArgs e) { double sl, slcon, slxoa; if (MessageBox.Show("Bạn có chắc chắn muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { string sql = "SELECT Mabinh,SoLuong FROM chi_tiet_hoa_don_nhap WHERE SoHDN = N'" + txtSoHDN.Text + "'"; DataTable DM_Binh_ga = DAO.GetDataToTable(sql); for (int ga = 0; ga <= DM_Binh_ga.Rows.Count - 1; ga++) { // Cập nhật lại số lượng cho các loại ga sl = Convert.ToDouble(DAO.GetFieldValues("SELECT SoLuong FROM DM_Binh_ga WHERE Mabinh = N'" + DM_Binh_ga.Rows[ga][0].ToString() + "'")); slxoa = Convert.ToDouble(DM_Binh_ga.Rows[ga][1].ToString()); slcon = sl - slxoa; sql = "UPDATE DM_Binh_ga SET SoLuong =" + slcon + " WHERE Mabinh= N'" + DM_Binh_ga.Rows[ga][0].ToString() + "'"; DAO.RunSql(sql); } //Xóa chi tiết hóa đơn sql = "DELETE Chi_tiet_hoa_don_nhap WHERE SoHDN=N'" + txtSoHDN.Text + "'"; DAO.RunSqlDel(sql); //Xóa hóa đơn sql = "DELETE hoa_don_nhap WHERE SoHDN=N'" + txtSoHDN.Text + "'"; DAO.RunSqlDel(sql); ResetValues(); LoadDataGridView(); } }
private void buttonxoa_Click(object sender, EventArgs e) { string sql = "delete from khoi_luong where ma_khoi_luong='" + txtMakhoiluong.Text + "'"; DAO.RunSqlDel(sql); loaddata(); }
private void buttonxoa_Click_1(object sender, EventArgs e) { string sql = "delete from nhan_vien where manv='" + textBoxMaNV.Text + "'"; DAO.RunSqlDel(sql); loatdata(); }
private void buttonxoa_Click_1(object sender, EventArgs e) { string sql = "delete from nha_cc where mancc=N'" + textBoxmanhacungcap.Text + "'"; DAO.RunSqlDel(sql); loaddata(); }
private void buttonxoa_Click(object sender, EventArgs e) { string sql = "delete from ca_lam where maca=N'" + textBoxmaca.Text + "'"; DAO.RunSqlDel(sql); loaddata(); }
private void buttonxoa_Click(object sender, EventArgs e) { string sql = "delete from khach_hang where makhach=N'" + textBoxmakh.Text + "'"; DAO.RunSqlDel(sql); loaddata(); }
private void btnXoa_Click_1(object sender, EventArgs e) { double sl, slcon, slxoa; if (MessageBox.Show("Bạn có chắc chắn muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { string sql = "SELECT Mabinh,Soluong FROM Chi_tiet_hoa_don_ban WHERE SoHDB = N'" + txtSoHDB.Text + "'"; DataTable DM_Binh_ga = DAO.GetDataToTable(sql); for (int hang = 0; hang <= DM_Binh_ga.Rows.Count - 1; hang++) { // Cập nhật lại số lượng cho các mặt hàng sl = Convert.ToDouble(DAO.GetFieldValues("SELECT SoLuong FROM DM_Binh_ga WHERE Mabinh = N'" + DM_Binh_ga.Rows[hang][0].ToString() + "'")); slxoa = Convert.ToDouble(DM_Binh_ga.Rows[hang][1].ToString()); slcon = sl + slxoa; sql = "UPDATE DM_Binh_ga SET Soluong =" + slcon + " WHERE Mabinh= N'" + DM_Binh_ga.Rows[hang][0].ToString() + "'"; DAO.RunSql(sql); } //Xóa chi tiết hóa đơn sql = "DELETE Chi_tiet_hoa_don_ban WHERE SoHDB=N'" + txtSoHDB.Text + "'"; DAO.RunSqlDel(sql); //Xóa hóa đơn sql = "DELETE Hoa_don_ban WHERE SoHDB=N'" + txtSoHDB.Text + "'"; DAO.RunSqlDel(sql); ResetValues(); Load_DataGridViewChitiet(); btnXoa.Enabled = false; } }
private void buttonsua_Click(object sender, EventArgs e) { string sql = "update cong_viec set tencv=N'" + textBoxtencv.Text + "'where macv=N'" + textBoxmacv.Text + "'"; DAO.RunSqlDel(sql); loaddata(); }
private void buttonsua_Click(object sender, EventArgs e) { string sql = "update Nhan_Vien set tennv=N'" + textBoxTenNV.Text + "',diachi=N'" + textBoxdiachi.Text + "',gioitinh='" + comboBoxgioitinh.SelectedValue + "',ngaysinh='" + maskedTextBoxngaysinh.Text + "',dienthoai='" + textBoxdienthoai.Text + "',maca='" + comboBoxmaca.SelectedValue + "',macv='" + comboBoxmacongviec.SelectedValue + "' where maNv=N'" + textBoxMaNV.Text + "'"; //MessageBox.Show(sql); //DAO.openconnectionstring(); //SqlCommand cmd = new SqlCommand(sql, DAO.conn); //cmd.ExecuteNonQuery(); //DAO.closeconnectionstring(); DAO.RunSqlDel(sql); loatdata(); }