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