public ApiResult GetListPhone(PhoneListParmaeter pagi) { var page = phoneServices.GetListPhone(pagi); return(new ApiResult() { StatusCode = HttpStatusCode.OK, Data = new { list = page.Items.Select(r => new ReturnPhone { id = r.id, color = r.color, ListedTime = r.ListedTime, name = r.name, Price = r.Price, Type = r.Type, Version = r.Version }), page = page.CurrentPage, pageSize = page.ItemsPerPage, totalPage = page.TotalPages } }); }
public Page <Phone> GetListPhone(PhoneListParmaeter pagi) { var sql = Sql.Builder.Select("*").From("Phone"); sql.Where("Type=@0", pagi.Type); if (!string.IsNullOrWhiteSpace(pagi.keyword))//构建查询条件 { sql.Where("name like @0", $"%{pagi.keyword}%"); } switch (pagi.OrderBy)//构建排序规则 { case OrderBy.价格: sql.OrderBy("price"); break; case OrderBy.价格倒序: sql.OrderBy("price Desc"); break; case OrderBy.市时间: sql.OrderBy("ListedTime"); break; case OrderBy.市时间倒序: sql.OrderBy("ListedTime Desc"); break; case OrderBy.大于价格区间: if (pagi.Price.HasValue) { sql.Where("Price >@0", pagi.Price.Value); } break; case OrderBy.小于价格区间: if (pagi.Price.HasValue) { sql.Where("Price <@0", pagi.Price.Value); } break; case OrderBy.大于上市时间: if (pagi.ListedTime.HasValue) { sql.Where("ListedTime >'@0'", pagi.ListedTime.Value); } break; case OrderBy.小于上市时间: if (pagi.ListedTime.HasValue) { sql.Where("ListedTime <'@0'", pagi.ListedTime.Value); } break; } return(db.Page <Phone>(pagi.page, pagi.pageSize, sql)); }
public Page <Phone> GetListPhone(PhoneListParmaeter pagi) => phoneRepository.GetListPhone(pagi);