public QueryPageModel <LabelInfo> GetMemberLabelList(LabelQuery model)
{
//var result = Context.LabelInfo.AsQueryable();
var result = DbFactory.Default.Get <LabelInfo>();
if (!string.IsNullOrWhiteSpace(model.LabelName))
{
result.Where(item => item.LabelName.Contains(model.LabelName));
}
if (model.LabelIds != null)
{
//result = result.Where(item => model.LabelIds.Contains(item.Id));
result.Where(item => item.Id.ExIn(model.LabelIds));
}
//int total = 0;
if (model.PageNo > 0 && model.PageSize > 0)
{
//result = result.GetPage(d => d.OrderByDescending(o => o.Id), out total, model.PageNo, model.PageSize);
var models = result.OrderByDescending(o => o.Id).ToPagedList(model.PageNo, model.PageSize);
QueryPageModel <LabelInfo> pageModel = new QueryPageModel <LabelInfo> {
Models = models, Total = models.TotalRecordCount
};
return(pageModel);
}
else
{
QueryPageModel <LabelInfo> pageModel = new QueryPageModel <LabelInfo> {
Models = result.ToList(), Total = result.Count()
};
return(pageModel);
}
}
public JsonResult List(int page, string keywords, int rows)
{
IMemberLabelService memberLabelService = this._iMemberLabelService;
LabelQuery labelQuery = new LabelQuery()
{
LabelName = keywords,
PageSize = rows,
PageNo = page
};
PageModel <LabelInfo> memberLabelList = memberLabelService.GetMemberLabelList(labelQuery);
IEnumerable <LabelModel> list =
from item in memberLabelList.Models.ToList <LabelInfo>()
select new LabelModel()
{
MemberNum = (long)this._iMemberService.GetMembersByLabel(item.Id).Count <MemberLabelInfo>(),
LabelName = item.LabelName,
Id = item.Id
};
DataGridModel <LabelModel> dataGridModel = new DataGridModel <LabelModel>()
{
rows = list,
total = memberLabelList.Total
};
return(base.Json(dataGridModel));
}
private IQueryable <Label> Where(LabelQuery queries)
{
if (!string.IsNullOrEmpty(queries.BoardId))
{
var boardId = Guid.Parse(queries.BoardId);
return(Where(x => x.BoardId == boardId && x.EntityStatus == EntityStatus.Activated));
}
return(Where(x => x.EntityStatus == EntityStatus.Activated));
}
/// <summary>
/// List labels with pagination and optional filters.
/// </summary>
/// <param name="query">Label query</param>
/// <param name="token">Optional cancellation token</param>
/// <returns>List of retrieved labels with cursor if the limit was reached.</returns>
public async Task <ItemsWithCursor <Label> > ListAsync(LabelQuery query, CancellationToken token = default)
{
if (query is null)
{
throw new ArgumentNullException(nameof(query));
}
var req = Labels.list(query);
return(await RunAsync(req, token));
}
/// <summary>
/// 获取所有标签
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static QueryPageModel <LabelModel> GetLabelList(LabelQuery query)
{
var labelList = _iMemberLabelService.GetMemberLabelList(query);
QueryPageModel <LabelModel> models = new QueryPageModel <LabelModel>();
models.Total = labelList.Total;
var list = AutoMapper.Mapper.Map <List <LabelModel> >(labelList.Models.ToList());
models.Models = list;
return(models);
}
public IEnumerable <Label> GetLabels(LabelQuery query)
{
var res = _unitOfWork.Repository <Label>().All();
if (!string.IsNullOrEmpty(query.BoardId))
{
res = res.Where(x => x.BoardId == Guid.Parse(query.BoardId));
}
return(res);
}
public PageModel <LabelInfo> GetMemberLabelList(LabelQuery model)
{
IQueryable <LabelInfo> page = this.context.LabelInfo.AsQueryable <LabelInfo>();
if (!string.IsNullOrWhiteSpace(model.LabelName))
{
page =
from item in page
where item.LabelName.Contains(model.LabelName)
select item;
}
int num = 0;
if ((model.PageNo <= 0 ? false : model.PageSize > 0))
{
page = page.GetPage <LabelInfo>(out num, model.PageNo, model.PageSize, null);
}
return(new PageModel <LabelInfo>()
{
Models = page,
Total = num
});
}
public ObsoletePageModel <LabelInfo> GetMemberLabelList(LabelQuery model)
{
var result = Context.LabelInfo.AsQueryable();
if (!string.IsNullOrWhiteSpace(model.LabelName))
{
result = result.Where(item => item.LabelName.Contains(model.LabelName));
}
if (model.LabelIds != null)
{
result = result.Where(item => model.LabelIds.Contains(item.Id));
}
int total = 0;
if (model.PageNo > 0 && model.PageSize > 0)
{
result = result.GetPage(out total, model.PageNo, model.PageSize);
}
ObsoletePageModel <LabelInfo> pageModel = new ObsoletePageModel <LabelInfo> {
Models = result, Total = total
};
return(pageModel);
}
public SuccessResponse <IEnumerable <LabelDto> > GetLabels([FromQuery] LabelQuery query)
{
return(new SuccessResponse <IEnumerable <LabelDto> >(_labelService.GetLabels(query).Select(x => _mapper.Map <LabelDto>(x))));
}
