public DataTable aplyBOOK(BOOK searchbook) { string sql = "select * from SACH where TenSach ='" + searchbook.TENSACH + "' and TheLoai='" + searchbook.THELOAI + "'and MaSach='" + searchbook.MASACH + "'"; return(da.GetTable(sql)); }
public void AddBook(BOOK addbook) { string sql = "Insert into SACH values( '" + addbook.TEBNXB + "','" + addbook.TENSACH + "','" + addbook.TACGIA + "','" + addbook.THELOAI + "','" + addbook.DONGIA + "','" + addbook.SOLUONG + "')"; da.ExNonQuery(sql); }
// update soluong sach public void updateSOLUONGSACH(BOOK book) { string sql = " update SACH set SoLuong ='" + book.SOLUONG + "' where MaSach='" + book.MASACH + "'"; da.ExNonQuery(sql); }
//update sach public void updateBOOK(BOOK book) { string sql = "UPDATE SACH set TenNXB = '" + book.TEBNXB + "', TenSach = '" + book.TENSACH + "', TacGia = '" + book.TACGIA + "', TheLoai = '" + book.THELOAI + "',DonGia = '" + book.DONGIA + "' where MaSach = '" + book.MASACH + "'"; da.ExNonQuery(sql); }