//Xoá public void XoaDuLieu(E_Sach et) { sql.XoaDuLieu(et); }
//Sửa public void SuaDuLieu(E_Sach et) { sql.SuaDuLieu(et); }
// Thêm Dữ Liệu public void ThemDuLieu(E_Sach et) { sql.ThemDuLieu(et); }
//Xoá public void XoaDuLieu(E_Sach et) { cn.ThucThiCauLenh(@"DELETE FROM Sach Where masach='" + et.masach + "'"); }
//Sửa public void SuaDuLieu(E_Sach et) { cn.ThucThiCauLenh(@"UPDATE Sach SET tensach = N'" + et.tensach + "', theloai =N'" + et.theloai + "', tacgia ='" + et.tacgia + "', namsx ='" + et.namsx + "', nhaxuatban ='" + et.nhaxuatban + "', ngaynhap ='" + et.ngaynhap + "', trigia ='" + et.trigia + "' Where masach='" + et.masach + "'"); }
// Thêm Dữ Liệu public void ThemDuLieu(E_Sach et) { cn.ThucThiCauLenh(@"INSERT INTO Sach (masach, tensach, theloai, tacgia, namsx, nhaxuatban, ngaynhap, trigia) VALUES ('" + et.masach + "',N'" + et.tensach + "',N'" + et.theloai + "',N'" + et.tacgia + "',N'" + et.namsx + "',N'" + et.nhaxuatban + "',N'" + et.ngaynhap + "',N'" + et.trigia + "')"); }