public GetListsResponse <arts> GetArticlesToType() { var response = new GetListsResponse <arts>(); var typelist = DbBase.Query <ArticleCategory>().Where(ac => ac.ParentId == 0).ToList(); IList <arts> artslist = new List <arts>(); foreach (var item in typelist) { var result = DbBase.Query <Articles>().Include(p => p.ArticleCategory) .Include(p => p.ArticleCategorys).OrderByDescending(p => p.Hits).Where(ac => ac.ArticleParentcategoryId == item.Id).ToPage(1, 2); artslist.Add(new arts { categoryid = item.Id, categoryname = item.CategoryName, articlelist = result.Items }); } if (artslist != null && artslist.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = artslist; return(response); } response.Message = "暂无数据"; return(response); }
/// <summary> /// 获取上一篇和下一篇 /// </summary> /// <param name="id"></param> /// <param name="type">0:上一篇 1:下一篇</param> /// <returns></returns> public GetListsResponse <StarCartoon> GetPageArticleByOne(int id, int type = 0) { var response = new GetListsResponse <StarCartoon>(); var result = DbBase.Query <StarCartoon>() .Where(p => p.IsShow == 1 && p.Id < id) .OrderBy(p => p.Id) .ThenByDescending(p => p.IsTop) .ThenByDescending(p => p.AddTime) .ThenByDescending(p => p.Sort).ToPage(1, 1); if (type == 1) { result = DbBase.Query <StarCartoon>() .Where(p => p.IsShow == 1 && p.Id > id) .OrderBy(p => p.Id) .ThenByDescending(p => p.IsTop) .ThenByDescending(p => p.AddTime) .ThenByDescending(p => p.Sort).ToPage(1, 1); } if (result.Items != null && result.Items.Count > 0) { response.IsSuccess = true; response.Message = "获取成功!"; response.Items = result.Items; return(response); } response.Message = "暂无数据!"; return(response); }
public HttpResponseMessage GetLists(int sessionId) { var response = new GetListsResponse(); if (_sessionManager.IsActive(sessionId)) { response.Lists = _listManager.GetLists(sessionId); return(Request.CreateResponse(HttpStatusCode.OK, response)); } else { return(Request.CreateResponse(HttpStatusCode.Conflict, response)); } }
public GetListsResponse <ArticleCategory> GetArticleCategories(int CategoriesId) { var response = new GetListsResponse <ArticleCategory>(); var result = DbBase.Query <ArticleCategory>().Where(a => a.ParentId == CategoriesId).ToList(); if (result != null && result.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result; return(response); } response.Message = "暂无数据"; return(response); }
/// <summary> /// 读取帖子分类列表 /// </summary> /// <returns></returns> public GetListsResponse <PostCategory> GetPostCategories() { var response = new GetListsResponse <PostCategory>(); var result = DbBase.Query <PostCategory>().ToList(); if (result != null && result.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result; return(response); } response.Message = "暂无数据"; return(response); }
public GetListsResponse <LuckyUserList> GetLuckTop() { var response = new GetListsResponse <LuckyUserList>(); var result = DbBase.Query <LuckyUserList>().OrderByDescending(o => o.Id).ToPage(1, 10); if (result.Items != null && result.Items.Count > 0) { response.IsSuccess = true; response.Message = "获取成功!"; response.Items = result.Items; return(response); } response.Message = "暂无数据!"; return(response); }
public GetListsResponse <W_Users> GetAsterListToHome() { var response = new GetListsResponse <W_Users>(); var result = DbBase.Query <W_Users>().OrderBy(p => p.AsterSort).Where(u => u.IsAster == 1).ToPage(1, 4); if (result.Items != null && result.Items.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result.Items; return(response); } response.Message = "暂无数据"; return(response); }
public GetListsResponse <ActivityBannerList> GetBannerList(int type = 0) { var response = new GetListsResponse <ActivityBannerList>(); var result = DbBase.Query <ActivityBannerList>().OrderByDescending(b => b.Sort).ToList(); if (result != null && result.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result; return(response); } response.Message = "暂无数据"; return(response); }
public GetListsResponse <ActivityUser> GetActivityTop(int activityid) { var response = new GetListsResponse <ActivityUser>(); var result = DbBase.Query <ActivityUser>().Where(o => o.ActivityId == activityid).OrderByDescending(p => p.voteNum).ToPage(1, 100); if (result.Items != null && result.Items.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result.Items; return(response); } response.Message = "暂无数据"; return(response); }
public GetListsResponse <Articles> GetArticlesByUserId(int userid) { var response = new GetListsResponse <Articles>(); var result = DbBase.Query <Articles>().Where(p => p.TUserId == userid).ToPage(1, 10); if (result.Items != null && result.Items.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result.Items; return(response); } response.Message = "暂无数据"; return(response); }
/// <summary> /// 星座快讯(随机获取6条) /// </summary> /// <returns></returns> public GetListsResponse <Articles> GetFastArticles() { var response = new GetListsResponse <Articles>(); var result = DbBase.Query <Articles>().Where(p => p.IsBoutique == 1).OrderByDescending(p => p.Hits).ToPage(1, 6); if (result.Items != null && result.Items.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result.Items; return(response); } response.Message = "暂无数据"; return(response); }
/// <summary> /// 获取最近热贴Top15 /// </summary> /// <returns></returns> public GetListsResponse <Posts> GetHotPostsTopFifteen() { var response = new GetListsResponse <Posts>(); var result = DbBase.Query <Posts>().OrderByDescending(p => p.Hits).ToPage(1, 15); if (result.Items != null && result.Items.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result.Items; return(response); } response.Message = "暂无数据"; return(response); }
/// <summary> /// 读取友情链接列表 /// </summary> /// <returns></returns> public GetListsResponse <Links> GetLinks() { var response = new GetListsResponse <Links>(); var result = DbBase.Query <Links>().OrderByDescending(p => p.Sort).ToList(); if (result != null && result.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result; return(response); } response.IsSuccess = false; response.Message = "暂无数据"; return(response); }
public GetListsResponse <TwelveAstro> GetTwelveAstroList() { var response = new GetListsResponse <TwelveAstro>(); var result = DbBase.Query <TwelveAstro>() .OrderBy(p => p.Id).ToList(); //排序方式:倒序,顺序:是否置顶->排序值->创建时间 if (result.Count > 0) { response.IsSuccess = true; response.Message = "获取成功!"; response.Items = result; return(response); } response.Message = "暂无数据!"; return(response); }
/// <summary> /// 获取随机10篇文章 /// </summary> /// <returns></returns> public GetListsResponse <Articles> GetRandomArticles() { var response = new GetListsResponse <Articles>(); var result = DbBase.Query <Articles>().Include(p => p.ArticleCategory) .Include(p => p.ArticleCategorys).OrderByDescending(p => p.CommentCount).ToPage(1, 10); if (result.Items != null && result.Items.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result.Items; return(response); } response.Message = "暂无数据"; return(response); }
public GetListsResponse <AsterLikes> GetMyLike(int userId) { var response = new GetListsResponse <AsterLikes>(); var result = DbBase.Query <AsterLikes>() .Include(u => u.UserLike) .Where(p => p.LikeUserId == userId) .ToPage(1, 100); if (result.Items != null && result.Items.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result.Items; return(response); } response.Message = "暂无关注"; return(response); }
/// <summary> /// 获取最近热议Top3 /// </summary> /// <returns></returns> public GetListsResponse <Posts> GetHotCommentPostsTopNine() { var response = new GetListsResponse <Posts>(); var result = DbBase.Query <Posts>().OrderByDescending(p => p.CommentCount).Where(p => p.IsShow == 1).ToPage(1, 9); foreach (var item in result.Items) { item.User = DbBase.Query <W_Users>().Single(p => p.Id == item.TUserId); } if (result.Items != null && result.Items.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result.Items; return(response); } response.Message = "暂无数据"; return(response); }
/// <summary> /// 获取测试列表 /// </summary> /// <param name="request">搜索条件</param> /// <returns></returns> public GetListsResponse <StarTest> GetTest() { var response = new GetListsResponse <StarTest>(); var result = DbBase.Query <StarTest>() .Where(p => p.Id > 0) .ToPage(1, 18);; if (result.Items != null && result.Items.Count > 0) { response.IsSuccess = true; response.Message = "获取成功!"; response.Items = result.Items; return(response); } else { response.IsSuccess = false; response.Message = "获取失败!"; return(response); } }
/// <summary> /// 获取月贡献TOP12 /// </summary> /// <returns></returns> public GetListsResponse <Contribution> GetTopTwelve() { var response = new GetListsResponse <Contribution>(); var result = DbBase.Query <Contribution>() .Include(p => p.User) .Where(p => p.Time == DateTime.Now.ToString("yyyy-MM")) .OrderByDescending(p => p.Number) .ToPage(1, 12); if (result.Items != null && result.Items.Count > 0) { response.IsSuccess = true; response.Message = "获取成功"; response.Items = result.Items; return(response); } response.Message = "获取失败"; return(response); }