private void btnDel_Click(object sender, EventArgs e) { NhanvienBUL cls = new NhanvienBUL(); NhanvienPublic p = new NhanvienPublic(); HoadonPublic q = new HoadonPublic(); int r = dataGridView1.CurrentCell.RowIndex; string MaNhanVien = dataGridView1.Rows[r].Cells[0].Value.ToString(); q.Manv = MaNhanVien; cls.SuaManvtrongHD(q); p.Manv = MaNhanVien; cls.XoaNhanvien(p); frmNhanvien_Load(sender, e); }
public int SuaManvtrongHD(HoadonPublic q) { return(cls.SuaMaNVthanhnull(q)); }
public int SuaMaNVthanhnull(HoadonPublic q) { name[0] = "@MANV"; value[0] = q.Manv; return(cn.Update("update HOADON set MANV = null where MANV=@MANV", name, value, 1)); }