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 <T> blog <T>(paging pagi) where T : class
{
Sql sql = new Sql().Select("*").From("dbo.blog").Where("Isdal =@0", 1);
if (pagi != null)
{
if (!string.IsNullOrWhiteSpace(pagi.keyword))
{
sql.Where("[title] like @0", $"%{pagi.keyword}%");
}
if (pagi.type_id.HasValue)
{
sql.Where("type_id =@0", $"{pagi.type_id.Value}");
}
if (pagi.lookno.HasValue)
{
sql.Where("lookno =@0", $"{pagi.lookno.Value}");
}
}
return(db.Page <T>(pagi.pageindex, pagi.pagesizi, sql));
}
