public static IEnumerable <BinhLuan> DanhSach(int id)
{
var db = new ShopDienThoaiConnectionDB();
return(db.Query <BinhLuan>("Select * from BinhLuan where TinhTrang != 1 AND MaSP=@0 order by ThoiGian desc",
id));
}
public static IEnumerable <SanPham> SanPhamHot()
{
var db = new ShopDienThoaiConnectionDB();
return(db.Query <SanPham>("select TOP 3 * from SanPham where BiXoa=0 and GhiChu=N'New'"));
}
public static IEnumerable <SanPham> DanhSach()
{
var db = new ShopDienThoaiConnectionDB();
return(db.Query <SanPham>("select * from SanPham where BiXoa=0"));
}
public static IEnumerable <HangSP> DanhSach()
{
var db = new ShopDienThoaiConnectionDB();
return(db.Query <HangSP>("select * from HangSP where BiXoa=0"));
}
public static IEnumerable <TinhTrangSP> DanhSach()
{
var db = new ShopDienThoaiConnectionDB();
return(db.Query <TinhTrangSP>("select * from TinhTrangSP where MaTinhTrang=1"));
}
