/// <summary>
/// 获取指定员工的上级部门主管
/// </summary>
/// <param name="depUserModel"></param>
/// <returns></returns>
public List <ViewUserModel> GetParentDepInfo(DepUserModel depUserModel)
{
var _context = SiteManager.Kernel.Get <ModelContext>();
var list =
from ddu in _context.Set <DepUserModel>()
join dd in _context.Set <DepartmentModel>() on ddu.DepId equals dd.Id into ddm
from d in ddm.DefaultIfEmpty()
join depf in _context.Set <DepartmentModel>() on d.ParentId equals depf.Id into da
from depx in da.DefaultIfEmpty()
join depUser in _context.Set <DepUserModel>()
on new { Id = depx.Id, IsLeader = (int?)1 } equals new { Id = depUser.DepId, IsLeader = depUser.IsLeader } into depUserl
from epUsera in depUserl.DefaultIfEmpty()
where ddu.UserName == depUserModel.UserName
select new ViewUserModel
{
UserId = epUsera.UserId,
UserName = epUsera.UserName,
ParentId = depx.ParentId,
DepId = depx.Id,
DepName = depx.Name,
DepHID = depx.DepHID
};
List <ViewUserModel> data = list.ToList();
if (data.Any())
{
return(data);
}
return(new List <ViewUserModel>());
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult VerifyUserIsMainOrg(string name, string id)
{
DepUserModel model = new DepUserModel();
model.UserName = name;
model.DepId = id.ToInt();
ViewUserModel data = organizationManager.VerifyUserIsMainOrg(model);
return(JsonNT(data));
}
/// <summary>
/// 获取用户所属部门以及直属领导人对象
/// </summary>
/// <param name="depUserModel"></param>
/// <returns></returns>
public ViewUserModel GetUserInfo(DepUserModel depUserModel)
{
List <ViewUserModel> data = new List <ViewUserModel>();
var model = GetUserInfoAllList().FirstOrDefault(p => p.UserName == depUserModel.UserName);
if (model != null)
{
return(model);
}
return(new ViewUserModel());
}
/// <summary>
/// 获取员工的第一部门对象
/// </summary>
/// <param name="depUserModel"></param>
/// <returns></returns>
public ViewUserModel VerifyUserIsMainOrg(DepUserModel depUserModel)
{
List <ViewUserModel> data = new List <ViewUserModel>();
using (var _context = SiteManager.Kernel.Get <ModelContext>())
{
var list = from du in _context.Set <DepUserModel>()
join d in _context.Set <DepartmentModel>() on du.DepId equals d.Id
where du.UserName == depUserModel.UserName && du.DepId != depUserModel.DepId && du.IsMain == 1
select new ViewUserModel
{
DepId = d.Id,
DepName = d.Name,
UserId = du.UserId,
UserName = du.UserName
};
data = list.ToList();
}
if (data.Any())
{
return(data[0]);
}
return(new ViewUserModel());
}
