public DataTable TacGia_Search(DuLieu_ChiTietBanHang dl)
{
return(xl.table_Select("select * from Kho where TenTacGia like N'%" + dl.TenTacGia + "%'"));
}
public void ChiTietBanHang_INSERT(DuLieu_ChiTietBanHang dl)
{
xl.table_Command("set dateformat dmy INSERT into ChiTietBanHang VALUES ('" + dl.Ngay + "',N'" + dl.TheLoai + "',N'" + dl.TenSach + "',N'" + dl.TenTacGia + "',N'" + dl.NXB + "','" + dl.Gia + "','" + dl.Sl + "','" + dl.Tong + "')");
}
public DataTable TheLoai_Search(DuLieu_ChiTietBanHang dl)
{
return(xl.table_Select("select * from Kho where TheLoai like N'%" + dl.TheLoai + "%'"));
}