public async Task <TData <List <ZtreeInfo> > > GetZtreeDepartmentList(DepartmentListParam param)
{
var obj = new TData <List <ZtreeInfo> >();
obj.Data = new List <ZtreeInfo>();
List <DepartmentEntity> departmentList = await departmentService.GetList(param);
OperatorInfo operatorInfo = await Operator.Instance.Current();
if (operatorInfo.IsSystem != 1)
{
List <long> childrenDepartmentIdList = await GetChildrenDepartmentIdList(departmentList, operatorInfo.DepartmentId.Value);
departmentList = departmentList.Where(p => childrenDepartmentIdList.Contains(p.Id.Value)).ToList();
}
foreach (DepartmentEntity department in departmentList)
{
obj.Data.Add(new ZtreeInfo
{
id = department.Id,
pId = department.ParentId,
name = department.DepartmentName
});
}
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <DepartmentEntity> > > GetPageListJson([FromQuery] DepartmentListParam param,
[FromQuery] Pagination pagination)
{
var obj = await _departmentBLL.GetPageList(param, pagination);
return(obj);
}
public async Task <TData <List <ZtreeInfo> > > GetZtreeUserList(DepartmentListParam param)
{
var obj = new TData <List <ZtreeInfo> >();
obj.Result = new List <ZtreeInfo>();
List <UserEntity> userList = await userService.GetList(null);
List <DepartmentEntity> departmentList = await departmentService.GetList(param);
foreach (DepartmentEntity department in departmentList)
{
obj.Result.Add(new ZtreeInfo
{
id = department.Id,
pId = department.ParentId,
name = department.DepartmentName
});
List <long> userIdList = userList.Where(t => t.DepartmentId == department.Id).Select(t => t.Id.Value).ToList();
foreach (UserEntity user in userList.Where(t => userIdList.Contains(t.Id.Value)))
{
obj.Result.Add(new ZtreeInfo
{
id = user.Id,
pId = department.Id,
name = user.RealName
});
}
}
obj.Tag = 1;
return(obj);
}
public async Task <List <DepartmentEntity> > GetList(DepartmentListParam param)
{
var expression = ListFilter(param);
var list = await this.BaseRepository().FindList(expression);
return(list.OrderBy(p => p.DepartmentSort).ToList());
}
public async Task <TData <List <ZtreeInfo> > > GetZtreeUserList(DepartmentListParam param)
{
var obj = new TData <List <ZtreeInfo> >();
obj.Data = new List <ZtreeInfo>();
List <DepartmentEntity> departmentList = await departmentService.GetList(param);
OperatorInfo operatorInfo = await Operator.Instance.Current();
List <long> childrenDepartmentIdList = await GetChildrenDepartmentIdList(departmentList, operatorInfo.DepartmentId.Value);
List <UserEntity> userList = await userService.GetList(new UserListParam { DepartmentId = operatorInfo.DepartmentId });
foreach (DepartmentEntity department in departmentList.Where(p => childrenDepartmentIdList.Contains(p.Id.Value)))
{
obj.Data.Add(new ZtreeInfo
{
id = department.Id,
pId = department.ParentId,
name = department.DepartmentName
});
List <long> userIdList = userList.Where(t => t.DepartmentId == department.Id).Select(t => t.Id.Value).ToList();
foreach (UserEntity user in userList.Where(t => userIdList.Contains(t.Id.Value)))
{
obj.Data.Add(new ZtreeInfo
{
id = user.Id,
pId = department.Id,
name = user.RealName
});
}
}
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <DepartmentEntity> > > GetList(DepartmentListParam param, OperatorInfo user)
{
TData <List <DepartmentEntity> > obj = new TData <List <DepartmentEntity> >();
obj.Data = await departmentService.GetList(param);
OperatorInfo operatorInfo = await Operator.Instance.Current();
if (operatorInfo.IsSystem != 1)
{
List <long> childrenDepartmentIdList = await GetChildrenDepartmentIdList(obj.Data, operatorInfo.DepartmentId.Value);
obj.Data = obj.Data.Where(p => childrenDepartmentIdList.Contains(p.Id.Value)).ToList();
}
List <UserEntity> userList = await userService.GetList(new UserListParam { UserIds = string.Join(",", obj.Data.Select(p => p.PrincipalId).ToArray()) }, user);
foreach (DepartmentEntity entity in obj.Data)
{
if (entity.PrincipalId > 0)
{
entity.PrincipalName = userList.Where(p => p.Id == entity.PrincipalId).Select(p => p.RealName).FirstOrDefault();
}
else
{
entity.PrincipalName = string.Empty;
}
}
obj.Tag = 1;
return(obj);
}
public async Task <IActionResult> GetUserTreeListJson(DepartmentListParam param)
{
OperatorInfo opuser = await Operator.Instance.Current();
TData <List <ZtreeInfo> > obj = await departmentBLL.GetZtreeUserList(param, opuser);
return(Json(obj));
}
public async Task <IActionResult> GetListJson(DepartmentListParam param)
{
YiSha.Web.Code.OperatorInfo opuser = await Operator.Instance.Current();
TData <List <DepartmentEntity> > obj = await departmentBLL.GetList(param, opuser);
return(Json(obj));
}
public async Task <TData <List <DepartmentEntity> > > GetList(DepartmentListParam param)
{
var obj = new TData <List <DepartmentEntity> >();
obj.Data = await _departmentService.GetList(param);
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <DepartmentEntity> > > GetPageList(DepartmentListParam param, Pagination pagination)
{
var obj = new TData <List <DepartmentEntity> >();
obj.Data = await _departmentService.GetPageList(param, pagination);
obj.Total = pagination.TotalCount;
obj.Tag = 1;
return(obj);
}
private Expression<Func<DepartmentEntity, bool>> ListFilter(DepartmentListParam param)
{
var expression = LinqExtensions.True<DepartmentEntity>();
if (param != null)
{
if (!param.DepartmentName.IsEmpty())
{
expression = expression.And(t => t.DepartmentName.Contains(param.DepartmentName));
}
}
return expression;
}
public async Task <TData <List <ZtreeInfo> > > GetZtreeDepartmentList(DepartmentListParam param)
{
var obj = new TData <List <ZtreeInfo> >();
obj.Result = new List <ZtreeInfo>();
List <DepartmentEntity> list = await departmentService.GetList(param);
foreach (DepartmentEntity department in list)
{
obj.Result.Add(new ZtreeInfo
{
id = department.Id,
pId = department.ParentId,
name = department.DepartmentName
});
}
obj.Tag = 1;
return(obj);
}
/// <summary>
/// 带条件查询所有
/// </summary>
public async Task <List <DepartmentEntity> > GetList(DepartmentListParam param)
{
#region 查询条件
var query = _departmentEntityDB.AsQueryable();
/*
* // 部门名称
* if (!string.IsNullOrEmpty(param.DepartmentName))
* query = query.Where(p => p.DepartmentName.Contains(param.DepartmentName));
*
*/
#endregion
var data = await query.ToListAsync();
return(data);
}
public async Task <TData <List <ZtreeInfo> > > GetZtreeUserList(DepartmentListParam param)
{
var obj = new TData <List <ZtreeInfo> >();
obj.Data = new List <ZtreeInfo>();
var departmentList = await _departmentService.GetList(param);
var operatorInfo = await _operatorCache.Current();
if (operatorInfo.IsSystem != 1)
{
var childrenDepartmentIdList =
await GetChildrenDepartmentIdList(departmentList, operatorInfo.DepartmentId.Value);
departmentList = departmentList.Where(p => childrenDepartmentIdList.Contains(p.Id.Value)).ToList();
}
var userList = await _userService.GetList(null);
foreach (var department in departmentList)
{
obj.Data.Add(new ZtreeInfo
{
id = department.Id,
pId = department.ParentId,
name = department.DepartmentName
});
var userIdList = userList.Where(t => t.DepartmentId == department.Id).Select(t => t.Id.Value).ToList();
foreach (var user in userList.Where(t => userIdList.Contains(t.Id.Value)))
{
obj.Data.Add(new ZtreeInfo
{
id = user.Id,
pId = department.Id,
name = user.RealName
});
}
}
obj.Tag = 1;
return(obj);
}
/// <summary>
/// 分页查询
/// </summary>
public async Task <List <DepartmentEntity> > GetPageList(DepartmentListParam param, Pagination pagination)
{
#region 查询条件
var query = _departmentEntityDB.AsQueryable();
/*
* // 部门名称
* if (!string.IsNullOrEmpty(param.DepartmentName))
* query = query.Where(p => p.DepartmentName.Contains(param.DepartmentName));
*
*/
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 <TData <List <DepartmentEntity> > > GetList(DepartmentListParam param)
{
TData <List <DepartmentEntity> > obj = new TData <List <DepartmentEntity> >();
obj.Result = await departmentService.GetList(param);
List <UserEntity> userList = await userService.GetList(new UserListParam { UserIds = string.Join(",", obj.Result.Select(p => p.PrincipalId).ToArray()) });
foreach (DepartmentEntity entity in obj.Result)
{
if (entity.PrincipalId > 0)
{
entity.PrincipalName = userList.Where(p => p.Id == entity.PrincipalId).Select(p => p.RealName).FirstOrDefault();
}
else
{
entity.PrincipalName = string.Empty;
}
}
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <ZtreeInfo> > > GetDepartmentTreeListJson([FromQuery] DepartmentListParam param)
{
TData <List <ZtreeInfo> > obj = await _departmentBLL.GetZtreeDepartmentList(param);
return(obj);
}
public async Task <IActionResult> GetListJson(DepartmentListParam param)
{
TData <List <DepartmentEntity> > obj = await departmentBLL.GetList(param);
return(Json(obj));
}
public async Task <TData <List <DepartmentEntity> > > GetListJson([FromQuery] DepartmentListParam param)
{
var obj = await _departmentBLL.GetList(param);
return(obj);
}
public async Task <IActionResult> GetUserTreeListJson(DepartmentListParam param)
{
TData <List <ZtreeInfo> > obj = await departmentBLL.GetZtreeUserList(param);
return(Json(obj));
}
