public string WriteList(string sort, string order, int page = 1, int rows = 30) { string result = string.Empty; var pag = new PaginationVM { PageNumber = page, PageSize = rows }; int uid = new Func.UserAuthAid(HttpContext).Get().UserId; using var db = new ContextBase(); var query = from a in db.UserWriting where a.Uid == uid select new { a.UwId, a.UwTitle, a.UwCreateTime, a.UwUpdateTime, a.UwReadNum, a.UwReplyNum, a.UwOpen, a.UwStatus, a.UwLaud, a.UwMark, a.UwCategory }; query = Fast.QueryableTo.OrderBy(query, sort, order); pag.Total = query.Count(); var list = query.Skip((pag.PageNumber - 1) * pag.PageSize).Take(pag.PageSize).ToList(); result = new { data = list, total = pag.Total }.ToJson(); return(result); }
public IActionResult List(int page = 1) { if (int.TryParse(RouteData.Values["Id"]?.ToString(), out int wid)) { var uwo = Func.Common.UserWritingOneQuery(wid); if (uwo == null) { return(Redirect("/")); } var pag = new PaginationVM { PageNumber = Math.Max(page, 1), PageSize = 10 }; var vm = new PageVM() { Rows = Func.Common.ReplyOneQuery(Func.EnumAid.ReplyType.UserWriting, wid.ToString(), pag), Pag = pag, Temp = uwo, Route = "/home/list/" + wid.ToString() }; if (User.Identity.IsAuthenticated) { var uinfo = new Func.UserAuthAid(HttpContext).Get(); using var db = new ContextBase(); var listuc = db.UserConnection.Where(x => x.Uid == uinfo.UserId && x.UconnTargetType == Func.EnumAid.ConnectionType.UserWriting.ToString() && x.UconnTargetId == wid.ToString()).ToList(); ViewData["uca1"] = listuc.Any(x => x.UconnAction == 1) ? "yes" : ""; ViewData["uca2"] = listuc.Any(x => x.UconnAction == 2) ? "yes" : ""; } return(View(vm)); } else { return(Redirect("/")); } }
public ActionResultVM ReplyList(string id, int page = 1) { var vm = new ActionResultVM(); try { var uinfo = new UserAuthAid(HttpContext).Get(); var pag = new PaginationVM { PageNumber = Math.Max(page, 1), PageSize = 10 }; var list = Func.Common.ReplyOneQuery(EnumAid.ReplyType.GuffRecord, id, pag); //匿名用户,生成邮箱MD5加密用于请求头像 foreach (var item in list) { if (item.Uid == 0 && !string.IsNullOrWhiteSpace(item.UrAnonymousMail)) { item.Spare3 = CalcTo.MD5(item.UrAnonymousMail); } } var pvm = new PageVM() { Rows = list, Pag = pag }; vm.data = pvm; vm.Set(ARTag.success); } catch (Exception ex) { vm.Set(ex); ConsoleTo.Log(ex); } return(vm); }
public ActionResultVM ReplyList(string id, int page = 1) { var vm = new ActionResultVM(); try { var uinfo = new Application.UserAuthService(HttpContext).Get(); var pag = new PaginationVM { PageNumber = Math.Max(page, 1), PageSize = 10 }; var list = Application.CommonService.ReplyOneQuery(Application.EnumService.ReplyType.GuffRecord, id, pag); //匿名用户,生成邮箱MD5加密用于请求头像 foreach (var item in list) { if (item.Uid == 0 && !string.IsNullOrWhiteSpace(item.UrAnonymousMail)) { item.Spare3 = Core.CalcTo.MD5(item.UrAnonymousMail); } } var pvm = new PageVM() { Rows = list, Pag = pag }; vm.Data = pvm; vm.Set(ARTag.success); } catch (Exception ex) { vm.Set(ex); Filters.FilterConfigs.WriteLog(HttpContext, ex); } return(vm); }
public static PaginationVM GetPaginationData(IQueryable <object> query, int page, int limit) { var totalCount = query.Count(); var totalPages = (int)Math.Ceiling((double)totalCount / limit); if (totalPages < page + 1) { throw new KeyNotFoundException(); } var prevPageLink = page > 0 ? GetPaginationUrl("team-members", page - 1, limit) : ""; var nextPageLink = page < totalPages - 1 ? GetPaginationUrl("team-members", page + 1, limit) : ""; var pagination = new PaginationVM() { TotalCount = totalCount, TotalPages = totalPages, CurrPage = page, NextPageLink = nextPageLink, PrevPageLink = prevPageLink, }; return(pagination); }
public async Task <IActionResult> GetAll(int pageIndex = 1) { if (ModelState.IsValid) { string token = HttpContext.Session.GetString("token_access"); var paginationVM = new PaginationVM() { PageIndex = pageIndex }; var list = await _modelServiceApiClient.GetAllPaging(token, paginationVM); if (TempData["ErrorResult"] != null) { ViewBag.ErrorMsg = TempData["ErrorResult"]; } if (TempData["SuccessResult"] != null) { ViewBag.SuccessMsg = TempData["SuccessResult"]; } return(View(list)); } return(BadRequest("Error 400")); }
public IActionResult Index(PaginationVM pagination, PostFilterVM postFilter) { if (this.HasAlert) { this.SetAlertModel(); } var configuration = new MapperConfiguration(cfg => cfg.CreateMap <SalePost, PostVM>().ReverseMap()); var postsQuery = this.FilterPosts(postFilter, this.salePostService.GetAll().ProjectTo <PostVM>(configuration)); var paginatedPosts = this.PaginateList <PostVM>(pagination, postsQuery).ToList(); foreach (var post in paginatedPosts) { post.Sneaker.PosterImageRelativeLink = FileManager.GetRelativeFilePath(post.Sneaker.PosterImageLink); post.Sneaker.OverallRating = post.Sneaker.Ratings.Any() ? post.Sneaker.Ratings.Average(s => s.Rating.Score) : 0; } int totalPages = this.GetTotalPages(pagination.PageSize, postsQuery.Count()); PostListVM postListViewModel = new PostListVM { Posts = paginatedPosts, NextPage = pagination.Page < totalPages ? pagination.Page + 1 : pagination.Page, PreviousPage = pagination.Page > 1 ? pagination.Page - 1 : pagination.Page, CurrentPage = pagination.Page, TotalPages = totalPages, ShowPagination = totalPages > 1, }; this.LoadListSneakersDropdowns(postFilter); return(this.View(postListViewModel)); }
public ActionResult Index(int pageNumber = 1) { try { int totalPages; IEnumerable <LibraryItem> items = commonAccessLogic.GetAll(pageNumber, 20, out totalPages); PaginationVM newModel = new PaginationVM { TotalNumberOfPages = totalPages, Items = items, CurrentPage = pageNumber }; return(View(newModel)); } catch (System.Exception e) { if (e is DalException) { return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError)); } else { logger.Warning("BL", e); return(RedirectToAction("Index", "Common")); } } }
public async Task <PageResultVM <ConditionVM> > GetAllConditionByIdPaging(int id, [FromQuery] PaginationVM paginationVM) { return(await _VehicleService.GetAllConditionByIdPaging(id, paginationVM)); }
public async Task <PageResultVM <ConditionVM> > GetAllConditionByIdPaging(int id, PaginationVM paginationVM) { var listConditionDTO = await _dbContextDTO.Set <ConditionDTO>().Where(x => x.VehicleId.Equals(id)).AsNoTracking().ToListAsync(); var listConditionVM = _mapper.Map <List <ConditionVM> >(listConditionDTO).OrderByDescending(x => x.CreateAt.Date); var listConditionVMPagination = listConditionVM.Skip((paginationVM.PageIndex - 1) * paginationVM.PageSize).Take(paginationVM.PageSize).ToList(); return(new PageResultVM <ConditionVM> { Items = listConditionVMPagination, PageIndex = paginationVM.PageIndex, TotalRecord = listConditionVM.Count() }); }
public async Task <PageResultVM <VehicleCrawlDataVM> > GetAllVehicleVinfastCrawlData([FromQuery] PaginationVM paginationVM) { return(await _vehicleCrawlDataService.GetAllVehicleVinfastCrawlData(paginationVM)); }
public Task <IViewComponentResult> InvokeAsync(PaginationVM paginationVM) { return(Task.FromResult((IViewComponentResult)View("Default", paginationVM))); }
/// <summary> /// Guff查询 /// </summary> /// <param name="category">类别,可选,支持 text、image、audio、video、me(我的)、melaud(我点赞的)、mereply(我回复的)</param> /// <param name="q">搜索</param> /// <param name="nv">分类名/分类值</param> /// <param name="tag">标签</param> /// <param name="obj">对象</param> /// <param name="OwnerId">所属用户</param> /// <param name="UserId">登录用户</param> /// <param name="page">页码</param> /// <returns></returns> public static PageVM GuffQuery(string category, string q, string nv, string tag, string obj, int OwnerId, int UserId, int page = 1) { var ctype = EnumService.ConnectionType.GuffRecord.ToString(); using var db = new ContextBase(); IQueryable <GuffRecord> query = null; switch (category?.ToLower()) { case "melaud": { query = from c in db.UserConnection join a in db.GuffRecord on c.UconnTargetId equals a.GrId join b in db.UserInfo on a.Uid equals b.UserId where c.Uid == UserId && c.UconnTargetType == ctype && c.UconnAction == 1 && a.GrStatus == 1 orderby c.UconnCreateTime descending select new GuffRecord { GrId = a.GrId, GrTypeName = a.GrTypeName, GrTypeValue = a.GrTypeValue, GrObject = a.GrObject, GrContent = a.GrContent, GrContentMd = a.GrContentMd, GrImage = a.GrImage, GrAudio = a.GrAudio, GrVideo = a.GrVideo, GrFile = a.GrFile, GrRemark = a.GrRemark, GrTag = a.GrTag, GrCreateTime = a.GrCreateTime, GrUpdateTime = a.GrUpdateTime, GrOpen = a.GrOpen, GrReadNum = a.GrReadNum, GrReplyNum = a.GrReplyNum, GrLaud = a.GrLaud, GrMark = a.GrMark, Uid = a.Uid, //已点赞 Spare1 = "laud", //是我的 Spare2 = a.Uid == UserId ? "owner" : "", //昵称 Spare3 = b.Nickname }; } break; case "mereply": { query = from c in db.UserReply join a in db.GuffRecord on c.UrTargetId equals a.GrId join b in db.UserInfo on a.Uid equals b.UserId where c.Uid == UserId && c.UrTargetType == ctype && a.GrStatus == 1 orderby c.UrCreateTime descending select new GuffRecord { GrId = a.GrId, GrTypeName = a.GrTypeName, GrTypeValue = a.GrTypeValue, GrObject = a.GrObject, GrContent = a.GrContent, GrContentMd = a.GrContentMd, GrImage = a.GrImage, GrAudio = a.GrAudio, GrVideo = a.GrVideo, GrFile = a.GrFile, GrRemark = a.GrRemark, GrTag = a.GrTag, GrCreateTime = a.GrCreateTime, GrUpdateTime = a.GrUpdateTime, GrOpen = a.GrOpen, GrReadNum = a.GrReadNum, GrReplyNum = a.GrReplyNum, GrLaud = a.GrLaud, GrMark = a.GrMark, Uid = a.Uid, Spare2 = a.Uid == UserId ? "owner" : "", Spare3 = b.Nickname }; } break; case "me": case "top": case "text": case "image": case "audio": case "video": default: { query = from a in db.GuffRecord join b in db.UserInfo on a.Uid equals b.UserId where a.GrStatus == 1 select new GuffRecord { GrId = a.GrId, GrTypeName = a.GrTypeName, GrTypeValue = a.GrTypeValue, GrObject = a.GrObject, GrContent = a.GrContent, GrContentMd = a.GrContentMd, GrImage = a.GrImage, GrAudio = a.GrAudio, GrVideo = a.GrVideo, GrFile = a.GrFile, GrRemark = a.GrRemark, GrTag = a.GrTag, GrCreateTime = a.GrCreateTime, GrUpdateTime = a.GrUpdateTime, GrOpen = a.GrOpen, GrReadNum = a.GrReadNum, GrReplyNum = a.GrReplyNum, GrLaud = a.GrLaud, GrMark = a.GrMark, Uid = a.Uid, Spare2 = a.Uid == UserId ? "owner" : "", Spare3 = b.Nickname }; } break; } query = (category?.ToLower()) switch { "top" => query.OrderByDescending(x => x.GrLaud), "text" => query.OrderByDescending(x => x.GrCreateTime).Where(x => !string.IsNullOrEmpty(x.GrContent) && string.IsNullOrEmpty(x.GrImage) && string.IsNullOrEmpty(x.GrAudio) && string.IsNullOrEmpty(x.GrVideo)), "image" => query.OrderByDescending(x => x.GrCreateTime).Where(x => !string.IsNullOrEmpty(x.GrImage)), "audio" => query.OrderByDescending(x => x.GrCreateTime).Where(x => !string.IsNullOrEmpty(x.GrAudio)), "video" => query.OrderByDescending(x => x.GrCreateTime).Where(x => !string.IsNullOrEmpty(x.GrVideo)), _ => query.OrderByDescending(x => x.GrCreateTime), }; //所属用户 if (OwnerId != 0) { query = query.Where(x => x.Uid == OwnerId); } //未登录 if (UserId == 0) { query = query.Where(x => x.GrOpen == 1); } else { //已登录:公开&登录用户的所有 query = query.Where(x => x.GrOpen == 1 || x.Uid == UserId); } //分类名/分类值 if (!string.IsNullOrWhiteSpace(nv)) { if (!nv.Contains("/")) { nv += "/"; } var nvs = nv.Split('/').ToList(); var n = nvs.FirstOrDefault(); var v = nvs.LastOrDefault(); //分类名 if (!string.IsNullOrWhiteSpace(n)) { query = query.Where(x => x.GrTypeName == n); } //分类值 if (!string.IsNullOrWhiteSpace(v)) { query = query.Where(x => x.GrTypeValue == v); } } //标签 if (!string.IsNullOrWhiteSpace(tag)) { query = query.Where(x => x.GrTag.Contains(tag)); } //标签 if (!string.IsNullOrWhiteSpace(tag)) { query = query.Where(x => x.GrTag.Contains(tag)); } //对象 if (!string.IsNullOrWhiteSpace(obj)) { query = query.Where(x => x.GrObject.Contains(obj)); } if (!string.IsNullOrWhiteSpace(q)) { query = query.Where(x => x.GrContent.Contains(q) || x.GrTag.Contains(q)); } var pag = new PaginationVM { PageNumber = Math.Max(page, 1), PageSize = 18 }; var dicQs = new Dictionary <string, string> { { "q", q } }; pag.Total = query.Count(); var list = query.Skip((pag.PageNumber - 1) * pag.PageSize).Take(pag.PageSize).ToList(); var listid = list.Select(x => x.GrId).ToList(); //点赞查询 if (category != "melaud") { var listtid = db.UserConnection.Where(x => listid.Contains(x.UconnTargetId) && x.Uid == UserId && x.UconnTargetType == ctype && x.UconnAction == 1).Select(x => x.UconnTargetId).ToList(); foreach (var item in list) { if (listtid.Contains(item.GrId)) { item.Spare1 = "laud"; } } } //查询记录 var ormo = new OperationRecord() { OrId = Core.UniqueTo.LongId().ToString(), OrType = ctype, OrAction = "query", OrSource = string.Join(",", listid), OrCreateTime = DateTime.Now, OrMark = "default" }; db.OperationRecord.Add(ormo); db.SaveChanges(); PageVM pageSet = new PageVM() { Rows = list, Pag = pag, QueryString = dicQs }; return(pageSet); }
/// <summary> /// 获取关联的文章列表 /// </summary> /// <param name="OwnerId">所属用户关联</param> /// <param name="connectionType">关联分类</param> /// <param name="action">动作</param> /// <param name="page"></param> /// <returns></returns> public static PageSetVM UserConnWritingQuery(int OwnerId, EnumAid.ConnectionType connectionType, int action, int page) { var pag = new PaginationVM { PageNumber = Math.Max(page, 1), PageSize = 20 }; using (var db = new ContextBase()) { IQueryable <UserWriting> query = null; switch (connectionType) { case EnumAid.ConnectionType.UserWriting: { query = from a in db.UserConnection join b in db.UserWriting on a.UconnTargetId equals b.UwId.ToString() where a.Uid == OwnerId && a.UconnTargetType == connectionType.ToString() && a.UconnAction == action orderby a.UconnCreateTime descending select b; } break; } if (query == null) { return(null); } pag.Total = query.Count(); query = query.Skip((pag.PageNumber - 1) * pag.PageSize).Take(pag.PageSize); var list = query.ToList(); //文章ID var listUwId = list.Select(x => x.UwId).ToList(); //文章的所有的标签 var listUwTags = (from a in db.Tags join b in db.UserWritingTags on a.TagName equals b.TagName where listUwId.Contains(b.UwId) select new { b.UwId, b.TagName, a.TagIcon }).ToList(); //文章人员ID var listUwUid = list.Select(x => x.UwLastUid).Concat(list.Select(x => x.Uid)).Distinct(); //文章人员ID对应的信息 var listUwUserInfo = db.UserInfo.Where(x => listUwUid.Contains(x.UserId)).Select(x => new { x.UserId, x.Nickname }).ToList(); //把信息赋值到文章表的备用字段上 foreach (var item in list) { //标签 item.Spare1 = listUwTags.Where(x => x.UwId == item.UwId).Select(x => new { x.TagName, x.TagIcon }).ToJson(); if (item.UwLastUid > 0) { item.Spare2 = listUwUserInfo.FirstOrDefault(x => x.UserId == item.UwLastUid)?.Nickname; item.Spare3 = item.UwLastUid.ToString(); } if (string.IsNullOrWhiteSpace(item.Spare2)) { item.Spare2 = listUwUserInfo.FirstOrDefault(x => x.UserId == item.Uid)?.Nickname; item.Spare3 = item.Uid.ToString(); } } var vm = new PageSetVM() { Rows = list, Pag = pag }; return(vm); } }
/// <summary> /// Gist查询,按列权重排序 /// </summary> /// <param name="q">搜索</param> /// <param name="lang">语言</param> /// <param name="OwnerId">所属用户</param> /// <param name="UserId">登录用户</param> /// <param name="page">页码</param> /// <returns></returns> public static PageSetVM GistQuery(string q, string lang, int OwnerId = 0, int UserId = 0, int page = 1) { using (var db = new ContextBase()) { var query1 = from a in db.Gist join b in db.UserInfo on a.Uid equals b.UserId where a.GistStatus == 1 orderby a.GistCreateTime descending select new { a, b.Nickname }; if (!string.IsNullOrWhiteSpace(lang)) { query1 = query1.Where(x => x.a.GistLanguage == lang); } if (!string.IsNullOrWhiteSpace(q)) { query1 = query1.Where(x => x.a.GistFilename.Contains(q) || x.a.GistContent.Contains(q) || x.a.GistRemark.Contains(q)); } //所属用户 if (OwnerId != 0) { query1 = query1.Where(x => x.a.Uid == OwnerId); } //未登录 if (UserId == 0) { query1 = query1.Where(x => x.a.GistOpen == 1); } else { //已登录:公开&登录用户的所有 query1 = query1.Where(x => x.a.GistOpen == 1 || x.a.Uid == UserId); } var query2 = query1.Select(x => new { SearchOrder = (x.a.GistFilename.Contains(q) ? 4 : 0) + (x.a.GistContent.Contains(q) ? 2 : 0) + (x.a.GistRemark.Contains(q) ? 1 : 0), x.Nickname, x.a }); var query = query2.OrderByDescending(x => x.SearchOrder).Select(x => new Gist { GistCode = x.a.GistCode, GistContentPreview = x.a.GistContentPreview, GistCreateTime = x.a.GistCreateTime, GistFilename = x.a.GistFilename, GistId = x.a.GistId, GistLanguage = x.a.GistLanguage, GistRemark = x.a.GistRemark, GistRow = x.a.GistRow, GistTags = x.a.GistTags, GistTheme = x.a.GistTheme, Uid = x.a.Uid, Spare3 = x.Nickname }); var pag = new PaginationVM { PageNumber = Math.Max(page, 1), PageSize = 10 }; var dicQs = new Dictionary <string, string> { { "q", q } }; pag.Total = query.Count(); var list = query.Skip((pag.PageNumber - 1) * pag.PageSize).Take(pag.PageSize).ToList(); PageSetVM pageSet = new PageSetVM() { Rows = list, Pag = pag, QueryString = dicQs }; return(pageSet); } }
public async Task <PageResultVM <VehicleVM> > GetAllVehicleBoughtPaging(DateTime fromDate, DateTime toDate, [FromQuery] PaginationVM paginationVM) { return(await _VehicleService.GetAllVehicleBoughtPaging(fromDate, toDate, paginationVM)); }
public async Task <PageResultVM <VehicleVM> > GetAllVehicleBoughtPaging(DateTime fromDate, DateTime toDate, PaginationVM paginationVM) { if (fromDate.Year != 0001 || toDate.Year != 0001) { var listVehicleDTO = await dbset.Where(x => x.isBought == true).Where(x => x.UpdateAt.Date >= fromDate.Date).Where(x => x.UpdateAt.Date <= toDate).ToListAsync(); var listVehicleVM = await VehicleJoinQuery(listVehicleDTO); var listVehicleVMPagination = listVehicleVM.Skip((paginationVM.PageIndex - 1) * paginationVM.PageSize).Take(paginationVM.PageSize).OrderByDescending(x => x.UpdateAt).ToList(); return(new PageResultVM <VehicleVM> { Items = listVehicleVMPagination, PageIndex = paginationVM.PageIndex, TotalRecord = listVehicleVM.Count() }); } else { var listVehicleDTO = await dbset.Where(x => x.isBought == true).ToListAsync(); var listVehicleVM = await VehicleJoinQuery(listVehicleDTO); var listVehicleVMPagination = listVehicleVM.Skip((paginationVM.PageIndex - 1) * paginationVM.PageSize).Take(paginationVM.PageSize).OrderByDescending(x => x.UpdateAt).ToList(); return(new PageResultVM <VehicleVM> { Items = listVehicleVMPagination, PageIndex = paginationVM.PageIndex, PageSize = paginationVM.PageSize, TotalRecord = listVehicleVM.Count() }); } }
public async Task <PageResultVM <ConditionVM> > GetAllConditionByIdPaging(string token, int id, PaginationVM paginationVM) { var client = _httpClientFactory.CreateClient(); client.DefaultRequestHeaders.Add("Authorization", "Bearer " + token); client.BaseAddress = new Uri(_configuration["UrlApi"]); var response = await client.GetAsync("/api/vehicles/" + id + "/conditions/paging/?pageIndex=" + paginationVM.PageIndex); var body = await response.Content.ReadAsStringAsync(); return(JsonConvert.DeserializeObject <PageResultVM <ConditionVM> >(body)); }
public async Task <PageResultVM <AppUserModelMVC> > GetAllPaging(string token, PaginationVM paginationVM) { var client = _httpClientFactory.CreateClient(); client.DefaultRequestHeaders.Add("Authorization", "Bearer " + token); client.BaseAddress = new Uri(_configuration["UrlApi"]); var response = await client.GetAsync("/api/users/paging/?pageIndex=" + paginationVM.PageIndex); var body = await response.Content.ReadAsStringAsync(); var pageResult = JsonConvert.DeserializeObject <PageResultVM <AppUserVM> >(body); var appuserroleVM = await _userRoleServiceApiClient.GetAll(token); var listAppUserModelMVC = (from _user in pageResult.Items join _userrole in appuserroleVM on _user.AppUserRolesId equals _userrole.Id into userroles from _userroles in userroles.DefaultIfEmpty() select new AppUserModelMVC { appUserRoleVM = _userroles, appUserVM = _user }).ToList(); return(new PageResultVM <AppUserModelMVC> { Items = listAppUserModelMVC, PageIndex = pageResult.PageIndex, PageSize = pageResult.PageSize, TotalRecord = pageResult.TotalRecord }); }
public async Task <PageResultVM <VehicleVM> > GetAllVehicleBoughtPaging(string token, DateTime fromDate, DateTime toDate, PaginationVM paginationVM) { var client = _httpClientFactory.CreateClient(); client.DefaultRequestHeaders.Add("Authorization", "Bearer " + token); client.BaseAddress = new Uri(_configuration["UrlApi"]); var response = await client.GetAsync("/api/vehicles/vehicle-bought/paging/?pageIndex=" + paginationVM.PageIndex + "&fromDate=" + fromDate + "&toDate=" + toDate); var body = await response.Content.ReadAsStringAsync(); return(JsonConvert.DeserializeObject <PageResultVM <VehicleVM> >(body)); }
public IActionResult Index(PaginationVM pagination, string name) { return(View()); }
public async Task <PageResultVM <AppUserVM> > GetAllPaging([FromQuery] PaginationVM paginationVM) { return(await _userService.GetAllPaging(paginationVM)); }
public Task <PageResultVM <VehicleAppraisalVM> > GetAllPaging(PaginationVM paginationVM) { throw new NotImplementedException(); }
public async Task <PageResultVM <ModelVM> > GetAllPaging([FromQuery] PaginationVM paginationVM) { return(await _ModelService.GetAllPaging(paginationVM)); }
/// <summary> /// 获取文章列表 /// </summary> /// <param name="KeyWords"></param> /// <param name="page"></param> /// <param name="TagName"></param> /// <returns></returns> public static PageSetVM UserWritingQuery(string KeyWords, int page, string TagName = "") { KeyWords = KeyWords ?? ""; var pag = new PaginationVM { PageNumber = Math.Max(page, 1), PageSize = 20 }; var dicQs = new Dictionary <string, string> { { "k", KeyWords } }; using (var db = new ContextBase()) { IQueryable <UserWriting> query; if (!string.IsNullOrWhiteSpace(TagName)) { query = from a in db.UserWritingTags.Where(x => x.TagName == TagName) join b in db.UserWriting on a.UwId equals b.UwId select b; query = query.Distinct(); } else { query = from a in db.UserWriting select a; } query = query.Where(x => x.UwOpen == 1 && x.UwStatus == 1); if (!string.IsNullOrWhiteSpace(KeyWords)) { query = query.Where(x => x.UwTitle.Contains(KeyWords)); } pag.Total = query.Count(); query = query.OrderByDescending(x => x.UwId).Skip((pag.PageNumber - 1) * pag.PageSize).Take(pag.PageSize); var list = query.ToList(); //文章ID var listUwId = list.Select(x => x.UwId).ToList(); //文章的所有的标签 var listUwTags = (from a in db.Tags join b in db.UserWritingTags on a.TagName equals b.TagName into bg from b in bg.DefaultIfEmpty() where listUwId.Contains(b.UwId) || a.TagName == TagName select new { UwId = b == null ? 0 : b.UwId, TagName = b == null ? TagName : b.TagName, a.TagIcon }).ToList(); //文章人员ID var listUwUid = list.Select(x => x.UwLastUid).Concat(list.Select(x => x.Uid)).Distinct(); //文章人员ID对应的信息 var listUwUserInfo = db.UserInfo.Where(x => listUwUid.Contains(x.UserId)).Select(x => new { x.UserId, x.Nickname }).ToList(); //把信息赋值到文章表的备用字段上 foreach (var item in list) { //标签 item.Spare1 = listUwTags.Where(x => x.UwId == item.UwId).Select(x => new { x.TagName, x.TagIcon }).ToJson(); if (item.UwLastUid > 0) { item.Spare2 = listUwUserInfo.FirstOrDefault(x => x.UserId == item.UwLastUid)?.Nickname; item.Spare3 = item.UwLastUid.ToString(); } if (string.IsNullOrWhiteSpace(item.Spare2)) { item.Spare2 = listUwUserInfo.FirstOrDefault(x => x.UserId == item.Uid)?.Nickname; item.Spare3 = item.Uid.ToString(); } } var vm = new PageSetVM() { Rows = list, Pag = pag, QueryString = dicQs }; if (!string.IsNullOrWhiteSpace(TagName)) { try { var jt = KeyValuesQuery(new List <string> { TagName }).FirstOrDefault().KeyValue.ToJObject(); var tags = new List <object> { new { TagName, listUwTags.FirstOrDefault(x => x.TagName == TagName)?.TagIcon } }; vm.Temp = new { abs = new List <string> { jt["abstract"].ToString(), jt["url"].ToString() }, tags }.ToJson(); } catch (Exception) { } } return(vm); } }
public async Task <PageResultVM <VehicleCrawlDataVM> > GetAllVehicleLexusCrawlData(PaginationVM paginationVM) { var vehicleCrawlDataDTOs = await dbset.Where(x => x.Name.Contains("Lexus")).ToListAsync(); var vehicleCrawlDataVMs = _mapper.Map <List <VehicleCrawlDataVM> >(vehicleCrawlDataDTOs); var vehicleCrawlDataVMPaging = vehicleCrawlDataVMs.Skip((paginationVM.PageIndex - 1) * paginationVM.PageSize).Take(paginationVM.PageSize).ToList(); return(new PageResultVM <VehicleCrawlDataVM> { Items = vehicleCrawlDataVMPaging, PageIndex = paginationVM.PageIndex, TotalRecord = vehicleCrawlDataVMs.Count() }); }
/// <summary> /// 获取一个目标ID的回复 /// </summary> /// <param name="replyType">回复分类</param> /// <param name="UrTargetId">回复目标ID</param> /// <param name="pag">分页信息</param> /// <returns></returns> public static List <UserReply> ReplyOneQuery(EnumAid.ReplyType replyType, string UrTargetId, PaginationVM pag) { using (var db = new ContextBase()) { var query = from a in db.UserReply join b in db.UserInfo on a.Uid equals b.UserId into bg from b1 in bg.DefaultIfEmpty() where a.UrTargetType == replyType.ToString() && a.UrTargetId == UrTargetId orderby a.UrCreateTime ascending select new UserReply { Uid = a.Uid, UrId = a.UrId, UrStatus = a.UrStatus, UrCreateTime = a.UrCreateTime, UrContent = a.UrContent, UrAnonymousLink = a.UrAnonymousLink, UrAnonymousMail = a.UrAnonymousMail, UrAnonymousName = a.UrAnonymousName, UrTargetId = a.UrTargetId, Spare1 = b1.Nickname, Spare2 = b1.UserPhoto }; pag.Total = query.Count(); query = query.Skip((pag.PageNumber - 1) * pag.PageSize).Take(pag.PageSize); var list = query.ToList(); return(list); } }
/// <summary> /// Run查询 /// </summary> /// <param name="q">搜索</param> /// <param name="OwnerId">所属用户</param> /// <param name="UserId">登录用户</param> /// <param name="page">页码</param> /// <returns></returns> public static PageVM RunQuery(string q, int OwnerId = 0, int UserId = 0, int page = 1) { using var db = new ContextBase(); var query = from a in db.Run join b in db.UserInfo on a.Uid equals b.UserId where a.RunStatus == 1 orderby a.RunCreateTime descending select new Run { RunCode = a.RunCode, RunCreateTime = a.RunCreateTime, RunId = a.RunId, RunRemark = a.RunRemark, RunTags = a.RunTags, RunTheme = a.RunTheme, Uid = a.Uid, RunOpen = a.RunOpen, Spare3 = b.Nickname, }; //所属用户 if (OwnerId != 0) { query = query.Where(x => x.Uid == OwnerId); } //未登录 if (UserId == 0) { query = query.Where(x => x.RunOpen == 1); } else { //已登录:公开&登录用户的所有 query = query.Where(x => x.RunOpen == 1 || x.Uid == UserId); } if (!string.IsNullOrWhiteSpace(q)) { query = query.Where(x => x.RunTheme.Contains(q) || x.RunRemark.Contains(q)); } var pag = new PaginationVM { PageNumber = Math.Max(page, 1), PageSize = 4 }; var dicQs = new Dictionary <string, string> { { "q", q } }; pag.Total = query.Count(); var list = query.Skip((pag.PageNumber - 1) * pag.PageSize).Take(pag.PageSize).ToList(); PageVM pageSet = new PageVM() { Rows = list, Pag = pag, QueryString = dicQs }; return(pageSet); }
/// <summary> /// Draw查询 /// </summary> /// <param name="q">搜索</param> /// <param name="OwnerId">所属用户</param> /// <param name="UserId">登录用户</param> /// <param name="page">页码</param> /// <returns></returns> public static PageSetVM DrawQuery(string q, int OwnerId = 0, int UserId = 0, int page = 1) { using (var db = new ContextBase()) { var query = from a in db.Draw join b in db.UserInfo on a.Uid equals b.UserId where a.DrStatus == 1 orderby a.DrCreateTime descending select new Draw { DrId = a.DrId, Uid = a.Uid, DrType = a.DrType, DrName = a.DrName, DrRemark = a.DrRemark, DrCategory = a.DrCategory, DrOrder = a.DrOrder, DrCreateTime = a.DrCreateTime, DrStatus = a.DrStatus, DrOpen = a.DrOpen, Spare3 = b.Nickname }; //所属用户 if (OwnerId != 0) { query = query.Where(x => x.Uid == OwnerId); } //未登录 if (UserId == 0) { query = query.Where(x => x.DrOpen == 1); } else { //已登录:公开&登录用户的所有 query = query.Where(x => x.DrOpen == 1 || x.Uid == UserId); } if (!string.IsNullOrWhiteSpace(q)) { query = query.Where(x => x.DrName.Contains(q) || x.DrRemark.Contains(q)); } var pag = new PaginationVM { PageNumber = Math.Max(page, 1), PageSize = 20 }; var dicQs = new Dictionary <string, string> { { "q", q } }; pag.Total = query.Count(); var list = query.Skip((pag.PageNumber - 1) * pag.PageSize).Take(pag.PageSize).ToList(); PageSetVM pageSet = new PageSetVM() { Rows = list, Pag = pag, QueryString = dicQs }; return(pageSet); } }