public bool Xoanhanvien(Businessobject.CNhanvien objec)
{
try
{
SqlCommand cmd = new SqlCommand("delete from NhanVien where MANHANVIEN=N'" + objec.MaNV + "'");
m_ds.ExecuteNoneQuery(cmd);
return(true);
}
catch
{
return(false);
}
}
public bool capnhatNV(Businessobject.CNhanvien objec)
{
try
{
SqlCommand cmd = new SqlCommand("update NhanVien set TENNHANVIEN=N'" +
objec.TenNV + "',NAMSINH='" +
objec.Namsinh + "',GIOITINH=N'" +
objec.Gioitinh + "',DIENTHOAI='" +
objec.Dienthoai + "',DIACHI=N'" +
objec.Diachi + "',CHUCVU=N'" +
objec.Chucvu + "',LUONGCOBAN='" +
objec.LuongCB + "' where MANHANVIEN=N'" + objec.MaNV + "'");
m_ds.ExecuteNoneQuery(cmd);
return(true);
}
catch
{ }
return(false);
}
public bool ThemNV(Businessobject.CNhanvien objec)
{
try
{
SqlCommand cmd = new SqlCommand("insert into NhanVien values(N'" +
objec.MaNV + "',N'" +
objec.TenNV + "','" +
objec.Namsinh + "',N'" +
objec.Gioitinh + "','" +
objec.Dienthoai + "',N'" +
objec.Diachi + "',N'" +
objec.Chucvu + "','" +
objec.LuongCB + "')");
m_ds.ExecuteNoneQuery(cmd);
return(true);
}
catch
{ }
return(false);
}
