public async Task <PagedResult <Topic> > Query(int pageIndex, int pageSize, string category, string keywords, bool?isRecommand, bool?isTop)
{
var query = this.CreateDefaultQuery();
if (!string.IsNullOrWhiteSpace(category))
{
query = query.Where(t => t.Category == category);
}
if (!string.IsNullOrWhiteSpace(keywords))
{
query = query.Where(t => t.Title.Contains(keywords) || t.Content.Contains(keywords));
}
if (isRecommand.HasValue)
{
query = query.Where(t => t.IsRecommand == isRecommand.Value);
}
if (isTop.HasValue)
{
query = query.Where(t => t.IsTop == isTop.Value);
}
var total = await query.CountAsync();
query = query.OrderByDescending(t => t.ID).Skip((pageIndex - 1) * pageSize).Take(pageSize);
var entityList = await query.ToListAsync();
return(PagedResult <Topic> .SuccessResult(entityList, pageIndex, pageSize, total));
}
public async Task <PagedResult <TopicModel> > QueryByUserCollect(long userID, int pageIndex, int pageSize)
{
using (var uw = this.CreateUnitOfWork())
{
var result = await uw.CreateRepository <ITopicRepository>().QueryByUserCollect(userID, pageIndex, pageSize);
var modelList = await this.Transform(result.Data.ToArray());
return(PagedResult <TopicModel> .SuccessResult(modelList, result.PageIndex, result.PageSize, result.Total));
}
}
public async Task <PagedResult <TopicModel> > Query(int pageIndex, int pageSize, string category = null, string keywords = null, bool?isRecommand = null, bool?isTop = null)
{
using (var uw = this.CreateUnitOfWork())
{
var result = await uw.CreateRepository <ITopicRepository>().Query(pageIndex, pageSize, category, keywords, isRecommand, isTop);
var modelList = await this.Transform(result.Data.ToArray());
return(PagedResult <TopicModel> .SuccessResult(modelList, result.PageIndex, result.PageSize, result.Total));
}
}
public async Task <PagedResult <UserLoginModel> > GetList()
{
using (var uw = this.CreateUnitOfWork())
{
var result = await uw.CreateRepository <IUserLoginRepository>().QueryAsync_UserLogin(1, 100, "");
var modelList = this.Transform(result.Data.ToArray());
return(PagedResult <UserLoginModel> .SuccessResult(modelList, result.PageIndex, result.PageSize, result.Total));
}
}
public async Task <PagedResult <Topic> > QueryByUser(long userID, int pageIndex, int pageSize)
{
var query = this.CreateDefaultQuery().Where(t => t.CreateUser == userID);
var total = await query.CountAsync();
query = query.OrderByDescending(t => t.ID).Skip((pageIndex - 1) * pageSize).Take(pageSize);
var entityList = await query.ToListAsync();
return(PagedResult <Topic> .SuccessResult(entityList, pageIndex, pageSize, total));
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="category"></param>
/// <param name="keywords"></param>
/// <returns></returns>
public async Task <PagedResult <UserLogin> > QueryAsync_UserLogin(int pageIndex, int pageSize, string keywords = null)
{
var query = this.CreateDefaultQuery();
if (!string.IsNullOrWhiteSpace(keywords))
{
query = query.Where(t => t.UserName.Contains(keywords));
}
var total = await query.CountAsync();
query = query.OrderByDescending(t => t.Order).Skip((pageIndex - 1) * pageSize).Take(pageSize);
var entityList = await query.ToListAsync();
return(PagedResult <UserLogin> .SuccessResult(entityList, pageIndex, pageSize, total));
}
public async Task <PagedResult <Topic> > QueryByUserCollect(long userID, int pageIndex, int pageSize)
{
var query = from topic in this.CreateDefaultQuery()
join tc in this.Context.Set <TopicCollect>() on topic.ID equals tc.TopicID
where tc.UserID == userID
orderby tc.CreateDate descending
select topic;
var total = await query.CountAsync();
query = query.Skip((pageIndex - 1) * pageSize).Take(pageSize);
var entityList = await query.ToListAsync();
return(PagedResult <Topic> .SuccessResult(entityList, pageIndex, pageSize, total));
}
