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);
