public ActionResult Index(string k, string c = "", int page = 1, int pageSize = 15)
{
int count;
count = 0;
var query = new CRL.ExpressionJoin<Product>(b => b.ProductStatus == CRL.Package.Product.ProductStatus.已上架);
if (!string.IsNullOrEmpty(k))
{
query.And(b => b.ProductName.Contains(k));
}
if (!string.IsNullOrEmpty(c))
{
query.And(b => b.CategoryCode.StartsWith(c));
}
//使用缓存搜索
IEnumerable<Product> products = BLL.ProductManage.Instance.QueryFromCache(query.GetExpression());
products = products.OrderByDescending(b => b.Id);
count = products.Count();
var result = products.Skip((page - 1) * pageSize).Take(pageSize).ToList();
var pageObj = new PageObj<Product>(result, page, count, pageSize);
return View(pageObj);
}
public ActionResult Index(string k, string c = "", int page = 1, int pageSize = 15)
{
int count;
count = 0;
var query = new CRL.ExpressionJoin <Product>(b => b.ProductStatus == CRL.Package.Product.ProductStatus.已上架);
if (!string.IsNullOrEmpty(k))
{
query.And(b => b.ProductName.Contains(k));
}
if (!string.IsNullOrEmpty(c))
{
query.And(b => b.CategoryCode.StartsWith(c));
}
//使用缓存搜索
IEnumerable <Product> products = BLL.ProductManage.Instance.QueryFromCache(query.GetExpression());
products = products.OrderByDescending(b => b.Id);
count = products.Count();
var result = products.Skip((page - 1) * pageSize).Take(pageSize).ToList();
var pageObj = new PageObj <Product>(result, page, count, pageSize);
return(View(pageObj));
}
