public IActionResult List(HomeRequestPayload payload)
{
using (_dbContext)
{
var query = from p in _dbContext.ScenicSpot
where p.IsDelete == 0 && p.State == 1
select new
{
p.ScenicSpotUuid,
p.Name,
p.Address,
p.OrderBy,
p.Picture,
p.SpotContent,
p.CreateTime
};
//if (!string.IsNullOrEmpty(payload.Kw))
//{
// query = query.Where(x => x.Name.Contains(payload.Kw.Trim()) || x.Address.Contains(payload.Kw.Trim()));
//}
query = query.OrderBy(x => x.OrderBy);
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult Discovery(HomeRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
//var query1 = _dbContext.ScenicSpot.Select(x => new Information
//{
// Uuid = x.ScenicSpotUuid,
// Title = x.Name,
// Type = "img",
// Url = x.Picture,
// IsRecommend= x.IsRecommend,
// IsDel = x.IsDelete,
// Time = x.CreateTime,
//}).Where(x => x.IsRecommend == false && x.IsDel == 0).OrderByDescending(x => x.Time);
//var query2 = _dbContext.PromotionalVideo.Select
// (x => new Information
// {
// Uuid = x.PromotionalVideoUuid,
// Title = x.Title,
// Type = "video",
// Url = x.Video,
// IsRecommend=x.IsRecommend,
// IsDel = x.IsDeleted,
// Time = x.CreateTime,
// }).Where(x => x.IsDel == 0 && x.IsRecommend == false).OrderByDescending(x => x.Time);
//var query3 = _dbContext.ArticlesManagement.Select(x => new Information
//{
// Uuid = x.ArticleUuid,
// Title = x.ArticleTitle,
// Type = "img",
// Url = x.CoverPhoto,
// IsRecommend=x.IsRecommend,
// IsDel = x.IsDelete,
// Time = x.AddTime,
//}).Where(x => x.IsDel == 0 && x.IsRecommend == false).OrderByDescending(x => x.Time);
//var query4 = query1.Union(query2.Union(query3));
var query4 = _dbContext.Cabinet.Where(x => x.IsRecommend == false && x.Type != "video");
var list = query4.OrderByDescending(x => x.Time).Select(x => new
{
x.Id,
x.IsDel,
x.IsRecommend,
x.Time,
x.Title,
x.Type,
x.Url,
x.Uuid,
Content = x.Type == "aimg"?GetContent(x.Content):x.Content.Trim().Substring(0, (x.Content.Trim().Length >= 25?25:x.Content.Trim().Length)),
}).Paged(payload.CurrentPage, payload.PageSize).ToList();;
response.SetData(list);
return(Ok(response));
}
public IActionResult Recommend(HomeRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
//var query1 = _dbContext.ScenicSpot.Select(x => new Information
//{
// Uuid = x.ScenicSpotUuid,
// Title = x.Name,
// Type = "img",
// Url = x.Picture,
// IsRecommend = x.IsRecommend,
// IsDel = x.IsDelete,
// Time = x.CreateTime,
//}).Where(x => x.IsRecommend == true && x.IsDel == 0).OrderByDescending(x => x.Time);
//var query2 = _dbContext.PromotionalVideo.Select
// (x => new Information
// {
// Uuid = x.PromotionalVideoUuid,
// Title = x.Title,
// Type = "video",
// Url= x.Video,
// IsRecommend=x.IsRecommend,
// IsDel=x.IsDeleted,
// Time= x.CreateTime,
// }).Where(x => x.IsDel == 0 && x.IsRecommend == true).OrderByDescending(x => x.Time);
//var query3 = _dbContext.ArticlesManagement.Select(x => new Information
//{
// Uuid = x.ArticleUuid,
// Title=x.ArticleTitle,
// Type="img",
// Url= x.CoverPhoto,
// IsRecommend=x.IsRecommend,
// IsDel=x.IsDelete,
// Time=x.AddTime,
//}).Where(x => x.IsDel == 0 && x.IsRecommend == true).OrderByDescending(x => x.Time);
//var query4 = query1.Union(query2.Union(query3));
var query4 = _dbContext.Cabinet.Where(x => x.IsRecommend == true);
var list = query4.OrderByDescending(x => x.Time).ToList();
response.SetData(list);
return(Ok(response));
}
public IActionResult infolist2(HomeRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
var query4 = _dbContext.Attractions.Where(x => x.SceientUuid.ToString() == payload.Kw);
var list = query4.OrderByDescending(p => p.Id).Select(p => new
{
p.AttractionsUuid,
p.SceientUuid,
type = "scien",
p.Id,
Picture = p.Picture == "" ? "" : image1url(p.Picture),
p.Evaluate,
p.AddTime,
p.Praise,
UserName = GetUserName(p.UserUuid, _dbContext),
}).Paged(payload.CurrentPage, payload.PageSize).ToList();;
response.SetData(list);
return(Ok(response));
}
public IActionResult infolist1(HomeRequestPayload payload)
{
using (_dbContext)
{
var query = from p in _dbContext.Attractions
where p.SceientUuid.ToString() == payload.Kw
select new
{
p.AttractionsUuid,
p.SceientUuid,
type = "scien",
p.Id,
Picture = p.Picture == "" ? "" : image1url(p.Picture),
p.Evaluate,
p.AddTime,
p.Praise,
UserName = GetUserName(p.UserUuid, _dbContext),
};
query = query.OrderByDescending(p => p.Id);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(query.ToList());
return(Ok(response));
}
}
