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