public ActionResult List(PagerRequest request, UserAuthSearchOption search)
{
int totalCount;
var data = _authRepo.Get(e => (!search.Type.HasValue || e.Type == search.Type.Value)
&& (!search.BrandId.HasValue || e.BrandId == search.BrandId.Value)
&& (!search.StoreId.HasValue || e.StoreId == search.StoreId.Value)
&& (!search.UserId.HasValue || e.UserId == search.UserId.Value)
&& e.Status != (int)DataStatus.Deleted
, out totalCount
, request.PageIndex
, request.PageSize
, e =>
{
if (!search.OrderBy.HasValue)
return e.OrderByDescending(o => o.CreatedDate);
else
{
switch (search.OrderBy.Value)
{
case GenericOrder.OrderByCreateUser:
return e.OrderByDescending(o => o.CreatedUser);
case GenericOrder.OrderByName:
case GenericOrder.OrderByCreateDate:
default:
return e.OrderByDescending(o => o.CreatedDate);
}
}
});
var models = data.Join(_customerRepo.GetAll(),o=>o.UserId,i=>i.Id,(o,i)=>new {UA=o,U=i})
.GroupJoin(_storeRepo.GetAll(),o=>o.UA.StoreId,i=>i.Id,(o,i)=>new {UA=o.UA,U=o.U,S=i.FirstOrDefault()})
.GroupJoin(_brandRep.GetAll(),o=>o.UA.BrandId,i=>i.Id,(o,i)=>new {UA=o.UA,U=o.U,S=o.S,B=i.FirstOrDefault()})
.ToList()
.Select(o=>new UserAuthViewModel(){
Id = o.UA.Id
, BrandId = o.UA.BrandId
, StoreId = o.UA.StoreId
, Type = o.UA.Type
, BrandName = o.B==null?"所有":o.B.Name
, UserId = o.UA.UserId
,UserNick = o.U.Nickname
, StoreName = o.S == null ? "所有" : o.S.Name
,Status = o.UA.Status.Value
});
return View("List", new Pager<UserAuthViewModel>(request, totalCount) { Data=models.ToList()});
}
public ActionResult Index(PagerRequest request,UserAuthSearchOption search)
{
return List(request,search);
}
