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