public ActionResult List(int page, string keywords, int rows)
{
InviteRecordQuery query = new InviteRecordQuery();
query.PageNo = page;
query.PageSize = rows;
query.userName = keywords;
var pageModel = _iMemberInviteService.GetInviteList(query);
var jsonModel = pageModel.Models.ToList().Select(a => new{ a.Id, a.InviteIntegral, RegTime = a.RegTime.Value.ToString("yyyy-MM-dd"), a.RegIntegral, a.RegName, a.UserName });
var model = new{ rows = jsonModel, total = pageModel.Total };
return(Json(model));
}
public ActionResult List(int page, string keywords, int rows)
{
InviteRecordQuery inviteRecordQuery = new InviteRecordQuery()
{
PageNo = page,
PageSize = rows,
userName = keywords
};
PageModel <InviteRecordInfo> inviteList = ServiceHelper.Create <IMemberInviteService>().GetInviteList(inviteRecordQuery);
var list =
from a in inviteList.Models.ToList()
select new { Id = a.Id, InviteIntegral = a.InviteIntegral, RegTime = a.RegTime.Value.ToString("yyyy-MM-dd"), RegIntegral = a.RegIntegral, RegName = a.RegName, UserName = a.UserName };
return(Json(new { rows = list, total = inviteList.Total }));
}
public QueryPageModel <InviteRecordInfo> GetInviteList(InviteRecordQuery query)
{
var datasql = DbFactory.Default.Get <InviteRecordInfo>();
if (!string.IsNullOrEmpty(query.userName))
{
datasql.Where(d => d.UserName.Contains(query.userName));
}
var model = datasql.OrderByDescending(a => a.Id).ToPagedList(query.PageNo, query.PageSize);
return(new QueryPageModel <InviteRecordInfo>
{
Models = model,
Total = model.TotalRecordCount
});
}
public ObsoletePageModel <InviteRecordInfo> GetInviteList(InviteRecordQuery query)
{
int total = 0;
ObsoletePageModel <InviteRecordInfo> result = new ObsoletePageModel <InviteRecordInfo>();
var datasql = Context.InviteRecordInfo.AsQueryable();
if (!string.IsNullOrEmpty(query.userName))
{
datasql = datasql.Where(d => d.UserName.Equals(query.userName));
}
datasql = datasql.GetPage(out total, query.PageNo, query.PageSize, d => d.OrderByDescending(a => a.Id));
//数据转换
result.Models = datasql;
result.Total = total;
return(result);
}
public PageModel <InviteRecordInfo> GetInviteList(InviteRecordQuery query)
{
int num = 0;
PageModel <InviteRecordInfo> pageModel = new PageModel <InviteRecordInfo>();
IQueryable <InviteRecordInfo> page = context.InviteRecordInfo.AsQueryable <InviteRecordInfo>();
if (!string.IsNullOrEmpty(query.userName))
{
page =
from d in page
where d.UserName.Equals(query.userName)
select d;
}
page = page.GetPage(out num, query.PageNo, query.PageSize, (IQueryable <InviteRecordInfo> d) =>
from a in d
orderby a.Id descending
select a);
pageModel.Models = page;
pageModel.Total = num;
return(pageModel);
}
