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