public JsonResult List(PagingRequest pg, int?vip) { var res = new PagingReply(); res.iTotalRecords = MemberService.GetMemberCount(pg.sSearch); if (res.iTotalRecords > 0) { IList <St_member> members = null; if (vip.HasValue && vip.Value == 1) { members = MemberService.GetVipMembers(pg.iDisplayStart, pg.iDisplayLength, pg.sSearch); } else { members = MemberService.GetMembers(pg.iDisplayStart, pg.iDisplayLength, pg.sSearch); } var users = MemberService.GetUsers(members.Select(s => s.UserId.HasValue ? s.UserId.Value : 0).ToList()); //if (vip.HasValue && vip.Value == 1) //{ // var vipmembers=members.Where(ct=>ct.Level != "普通会员" && ct.VipOverDate.HasValue && ct.VipOverDate.Value > DateTime.Now).ToList(); // res.iTotalRecords = vipmembers.Count; // res.aaData = vipmembers.Select(ct => new object[] { ct.RealName, GetUserName(ct.UserId, users), ct.Level, ct.HadVerify.HasValue && ct.HadVerify.Value ? "已验证" : "未验证", GetContactInfo(ct.Mobile, ct.Tel, ct.QQ, ct.Email, ct.Wechat), ct.AddTime.ToString(), ct.Id }).ToList(); //} //else res.aaData = members.Select(ct => new object[] { ct.RealName, GetUserName(ct.UserId, users), ct.Level != "普通会员" && ct.VipOverDate.HasValue && ct.VipOverDate.Value > DateTime.Now ? ct.Level : "普通会员", ct.HadVerify.HasValue && ct.HadVerify.Value ? "已验证" : "未验证", GetContactInfo(ct.Mobile, ct.Tel, ct.QQ, ct.Email, ct.Wechat), ct.AddTime.ToString(), ct.Id }).ToList(); } res.iTotalDisplayRecords = res.iTotalRecords; res.sEcho = pg.sEcho.ToString(); return(Json(res)); }
public JsonResult List(int?memberid, string q, PagingRequest pg) { var res = new PagingReply(); string qr = q; if (!string.IsNullOrEmpty(pg.sSearch)) { qr = pg.sSearch; } res.iTotalRecords = StockService.GetStockCount(memberid, qr); if (res.iTotalRecords > 0) { var cats = StockService.GetStockCats(); var results = StockService.GetStocks(memberid, pg.iDisplayStart, pg.iDisplayLength, qr); var stockmemberids = results.Where(s => s.MemberId > 0).Select(s => s.MemberId.HasValue ? s.MemberId.Value : 0).ToList(); var members = MemberService.GetMembersByIds(stockmemberids); res.aaData = results.Select(ct => new object[] { ct.Name, ct.CatId.HasValue && ct.CatId > 0 ? GetCatName(ct.CatId.Value, cats) : "无", !string.IsNullOrEmpty(ct.MainPic) && ct.MainPic.StartsWith("~") ? VirtualPathUtility.ToAbsolute(ct.MainPic) : ct.MainPic, "区域:" + ct.GoodsArea + " 类型:" + (ct.GoodsType == 1?"<b>求购</b>":"<b>出售</b>") + "<br>" + (ct.IsBrandGoods == true?"品牌:" + ct.BrandName + "<br>":"") + "价格:" + (ct.Price.HasValue ? ct.Price.Value.ToString() + " " : " ") + ct.PriceDetail + " 数量:" + (ct.Qty.HasValue ? ct.Qty.Value.ToString() + " " : " ") + ct.QtyDetail, ct.Status == 1 ? "已验证" : "未验证", ct.AddTime.ToString() + "<br>会员名:" + GetMemberName(ct.MemberId, members), ct.Id }).ToList(); } res.iTotalDisplayRecords = res.iTotalRecords; res.sEcho = pg.sEcho.ToString(); return(Json(res)); }
public JsonResult List(PagingRequest pg) { var res = new PagingReply(); res.iTotalRecords = NoticeService.GetNoticeCount(pg.sSearch); if (res.iTotalRecords > 0) { var entitys = NoticeService.GetNotices(pg.iDisplayStart, pg.iDisplayLength, pg.sSearch); res.aaData = entitys.Select(ct => new object[] { ct.Title, ct.NoticeType == 1?"曝光台":"网站公告", ct.AddTime.ToString(), ct.Id }).ToList(); } res.iTotalDisplayRecords = res.iTotalRecords; res.sEcho = pg.sEcho.ToString(); return(Json(res)); }
public async Task <PagingReply <TDto> > ParseAsync(PagingRequest param, Expression <Func <TEntity, TDto> > selectFn) { int totalRecords = _entities.Count(); _entities = Sort(param); _entities = FilterGlobal(param); _entities = FilterSpecific(param); int displayRecords = _entities.Count(); _entities = _entities.Skip(param.start); _entities = _entities.Take(param.length); var data = await _entities.Select(selectFn).ToListAsync(); PagingReply <TDto> reply = new PagingReply <TDto>() { data = data, draw = param.draw, recordsTotal = totalRecords, recordsFiltered = displayRecords }; return(reply); }