public void doiMK(BUS_QLBaiXe.BUS_NhanVien nv) { con.ExcuteNonQuery("update NHANVIEN set matkhau='" + nv.matKhau + "' where manv='" + nv.maNV + "'"); }
public void xoaNV(BUS_QLBaiXe.BUS_NhanVien nv) { con.ExcuteNonQuery("DELETE NHANVIEN WHERE MaNV = '" + nv.maNV + "'"); }
public void suaNV(BUS_QLBaiXe.BUS_NhanVien nv) { con.ExcuteNonQuery("UPDATE NHANVIEN set HoTen = N'" + nv.hoTen + "', CMND ='" + nv.CMND + "', DiaChi = '" + nv.diaChi + "',SDT = '" + nv.SDT + "' where manv = '" + nv.maNV + "'"); }
public void themNV(BUS_QLBaiXe.BUS_NhanVien nv) { con.ExcuteNonQuery("INSERT INTO NHANVIEN VALUES ('" + nv.maNV + "', '" + nv.matKhau + "',N'" + nv.hoTen + "', '" + nv.CMND + "',N'" + nv.diaChi + "', '" + nv.SDT + "')"); }