public int update(NhanVienEntities obj)
{
int result = 0;
string strQuery = @"update dbo.NhanVien set hoten=" + obj.Hoten + ",ngaysinh=" + obj.Ngaysinh + ",gioitinh=" + obj.Gioitinh + ",diachi=" + obj.Diachi + ",dantoc=" + obj.Dantoc + ",tongiao=" + obj.Tongiao + ",cmtnd=" + obj.Cmtnd + ",honnhan=" + obj.Tinhtranghonnhan + ",sdt=" + obj.Sodienthoai + ",ghichu=" + obj.Ghichu + ",maphongban=" + obj.Maphongban + "'machucvu='" + obj.Machucvu + ",matrinhdo=" + obj.Matrinhdo + ",ngoaingu=" + obj.Ngoaingu + ",mahopdong=" + obj.Mahopdong + ",baohiem=" + obj.Masobaohiem + ",khenthuong=" + obj.Makhenthuong + ",kyluat=" + obj.Makyluat + "where manv=" + obj.Manv;
DataConfig config = new DataConfig();
result = config.excuteNonquery(strQuery);
return(result);
}
//them csdl
public int insert(NhanVienEntities obj)
{
int result = 0;
string strQuery = @"insert into NhanVien(MaNV,HoTen,NgaySinh,GioiTinh,DiaChi,DanToc,TonGiao,CMTND,TinhTrangHonNhan,SoDienThoai,GhiChu,MaPhongBan,MaChucVu,MaTDHV,NgoaiNgu,MaHD,MaSBH,MaKT,MaKL) values ('" + obj.Manv + "','" + obj.Hoten + "','" + obj.Ngaysinh + "','" + obj.Gioitinh + "','" + obj.Diachi + "','" + obj.Dantoc + "','" + obj.Tongiao + "','" + obj.Cmtnd + "','" + obj.Tinhtranghonnhan + "','" + obj.Sodienthoai + "','" + obj.Ghichu + "','" + obj.Maphongban + "','" + obj.Machucvu + "','" + obj.Matrinhdo + "','" + obj.Ngoaingu + "','" + obj.Mahopdong + "','" + obj.Masobaohiem + "','" + obj.Makhenthuong + "','" + obj.Makyluat + "')";
DataConfig config = new DataConfig(); //khoi tao
result = config.excuteNonquery(strQuery); //thuc thi cau lenh
return(result); //tra ve so ban ghi dc them
}
