//public void Insert(NhanVien obj)
//{
// db.Insert("INSERT INTO `nhanvien` (`MaNhanVien`, `MaPB`, `MaCV`, `HeSoLuong`, `TenNV`, `GioiTinh`, `NgaySinh`, `NgayVaoLam`, `SoCM`, `DienThoai`, `DiaChi`, `Email`) VALUES('"+obj.MaNhanVien+"', '"+obj.MaPB+"', '"+obj.MaCV+"', '"+obj.HeSoLuong+"', '"+obj.TenNV+"', '"+obj.GioiTinh+"', '"+obj.NgaySinh+"', '"+obj.NgayVaoLam+"', '"+obj.SoCM+"', '"+obj.DienThoai+"', '"+obj.DiaChi+"', '"+obj.DiaChi+"')");
//}
public void Update(NhanVien obj)
{
db.Update("UPDATE `nhanvien` SET `MaPB` = '" + obj.MaPB + "', `MaCV` = '" + obj.MaCV + "', `HeSoLuong` = '" + obj.HeSoLuong + "', `TenNV` = '" + obj.TenNV + "', `GioiTinh` = '" + obj.GioiTinh + "', `NgaySinh` = '" + obj.NgaySinh + "',`NgayVaoLam` = '" + obj.NgayVaoLam + "',`SoCM` = '" + obj.SoCM + "',`SoCM` = '" + obj.SoCM + "',`DienThoai` = '" + obj.DienThoai + "',`DiaChi` = '" + obj.DiaChi + "',`Email` = '" + obj.Email + "' WHERE `nhanvien`.`MaNhanVien` = '" + obj.MaNhanVien + "'");
}
public void Update(PhongBan obj)
{
db.Update("update phongban set TenPB = '" + obj.namePhongBan + "' Where MaPB = '" + obj.IDPhongBan + "'");
}
public void Update(ChucVu obj)
{
db.Update("update chucvu set TenCV = '" + obj.TenCV + "' Where MaCV = '" + obj.MaCV + "' ");
}