public int SuaThongTin(EC_ThietBi EC_ThietBi)
{
return(connect.ThucHienLenh("update tblThietBi set SoLuong='" + EC_ThietBi.SoLuong + "',NhaSanXuat=N'" + EC_ThietBi.NhaSanXuat + "' where MaPh=N'" + EC_ThietBi.MaPh + "' and ThietBi=N'" + EC_ThietBi.ThietBi + "'"));
}
public int XoaTTThietBi(EC_ThietBi EC_ThietBi)
{
return(connect.ThucHienLenh("delete from tblThietBi where MaPh=N'" + EC_ThietBi.MaPh + "' and ThietBi=N'" + EC_ThietBi.ThietBi + "'"));
}
public int ThemThongTin(EC_ThietBi EC_ThietBi)
{
return(connect.ThucHienLenh("insert into tblThietBi(MaPh, ThietBi, SoLuong, NhaSanXuat) values(N'" + EC_ThietBi.MaPh + "', N'" + EC_ThietBi.ThietBi + "', '" + EC_ThietBi.SoLuong + "', N'" + EC_ThietBi.NhaSanXuat + "') "));
}
