public async Task <List <PositionEntity> > GetPageList(PositionListParam param, Pagination pagination)
{
var expression = ListFilter(param);
var list = await this.BaseRepository().FindList(expression, pagination);
return(list.ToList());
}
public async Task <TData <List <PositionEntity> > > GetPageListJson([FromQuery] PositionListParam param,
[FromQuery] Pagination pagination)
{
var obj = await _positionBLL.GetPageList(param, pagination);
return(obj);
}
public async Task <TData <List <PositionEntity> > > GetList(PositionListParam param)
{
TData <List <PositionEntity> > obj = new TData <List <PositionEntity> >();
obj.Data = await positionService.GetList(param);
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <PositionEntity> > > GetPageList(PositionListParam param, Pagination pagination)
{
TData <List <PositionEntity> > obj = new TData <List <PositionEntity> >();
obj.Result = await positionService.GetPageList(param, pagination);
obj.TotalCount = pagination.TotalCount;
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <PositionEntity> > > GetList(PositionListParam param)
{
TData <List <PositionEntity> > obj = new TData <List <PositionEntity> >();
obj.Result = await sysPositionService.GetList(param);
obj.TotalCount = obj.TotalCount;
obj.Tag = 1;
return(obj);
}
public async Task <IActionResult> GetPositionName(PositionListParam param)
{
TData <string> obj = new TData <string>();
var list = await sysPositionBLL.GetList(param);
if (list.Tag == 1)
{
obj.Result = string.Join(",", list.Result.Select(p => p.PositionName));
obj.Tag = 1;
}
return(Json(obj));
}
private Expression <Func <PositionEntity, bool> > ListFilter(PositionListParam param)
{
var expression = LinqExtensions.True <PositionEntity>();
if (param != null)
{
if (!string.IsNullOrEmpty(param.PositionName))
{
expression = expression.And(t => t.PositionName.Contains(param.PositionName));
}
if (!string.IsNullOrEmpty(param.PositionIds))
{
long[] positionIdArr = TextHelper.SplitToArray <long>(param.PositionIds, ',');
expression = expression.And(t => positionIdArr.Contains(t.Id.Value));
}
}
return(expression);
}
/// <summary>
/// 带条件查询所有
/// </summary>
public async Task <List <PositionEntity> > GetList(PositionListParam param)
{
#region 查询条件
var query = _positionEntityDB.AsQueryable();
/*
* // 职位名称
* if (!string.IsNullOrEmpty(param.PositionName))
* query = query.Where(p => p.PositionName.Contains(param.PositionName));
*
*/
#endregion
var data = await query.ToListAsync();
return(data);
}
/// <summary>
/// 分页查询
/// </summary>
public async Task <List <PositionEntity> > GetPageList(PositionListParam param, Pagination pagination)
{
#region 查询条件
var query = _positionEntityDB.AsQueryable();
/*
* // 职位名称
* if (!string.IsNullOrEmpty(param.PositionName))
* query = query.Where(p => p.PositionName.Contains(param.PositionName));
*
*/
var data = await query.OrderByDescending(a => a.Id)
.ToPagedListAsync(pagination.PageIndex, pagination.PageSize);
#endregion
// 分页参数赋值
pagination.TotalCount = data.TotalCount;
return(data.Items.ToList());
}
public async Task <IActionResult> GetPageListJson(PositionListParam param, Pagination pagination)
{
TData <List <PositionEntity> > obj = await sysPositionBLL.GetPageList(param, pagination);
return(Json(obj));
}
public async Task <IActionResult> GetListJson(PositionListParam param)
{
TData <List <PositionEntity> > obj = await positionBLL.GetList(param);
return(Json(obj));
}
