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 + "')");
}
