//sửa dữ liệu public int SuaDuLieu(EC_DichVu et) { return(sql.SuaDuLieu(et)); }
//xóa dữ liệu public void XoaDuLieu(EC_DichVu et) { sql.XoaDuLieu(et); }
//xóa dữ liệu public void XoaDuLieu(EC_DichVu et) { cn.ThucThiCauLenhSQL(@"DELETE from DichVu where MaDV=N'" + et.MaDV + "'"); }
public int ThemDuLieu(EC_DichVu et) { return(sql.ThemDuLieu(et)); }
//sửa dữ liệu public int SuaDuLieu(EC_DichVu et) { return(cn.ThucThiCauLenhSQL(@"UPDATE DichVu SET TenDV =N'" + et.TenDV + "', Gia =N'" + et.Gia + "', MaNQL =N'" + et.MaNQL + "' where MaDV=N'" + et.MaDV + "'")); }
//Hàm thêm dữ liệu public int ThemDuLieu(EC_DichVu et) { return(cn.ThucThiCauLenhSQL(@"INSERT INTO DichVu(TenDV, Gia, MaNQL) VALUES (N'" + et.TenDV + "',N'" + et.Gia + "',N'" + et.MaNQL + "')")); }
public int XoaTTDichVu(EC_DichVu EC_DV) { return(connect.ThucHienLenh("delete from tblDichVu where MaDV = '" + EC_DV.MaDV + "'")); }
public void SuaThongTin(EC_DichVu EC_DV) { connect.ThucHienLenh("update tblDichVu set TenDV = N'" + EC_DV.TenDV + "', Gia = N'" + EC_DV.Gia + "' where MaDV = '" + EC_DV.MaDV + "'"); }
public void ThemThongTin(EC_DichVu EC_DV) { connect.ThucHienLenh("insert into tblDichVu(MaDV,TenDV,Gia) values(N'" + EC_DV.MaDV + "', N'" + EC_DV.TenDV + "', '" + EC_DV.Gia + "')"); }