8,497
社区成员
发帖
与我相关
我的任务
分享
from user in db.User
join face in db.Userfaces
on user.IDCard equals iris.IDCard into dc
from dci in dc.DefaultIfEmpty()
where user.UserName.ToLower().Contains(searchkey.ToLower())
select new UserEx
{
Id = user.Id,
CompanyCode = user.CompanyCode,
CompanyName = user.CompanyName,
UserCard = user.UserCard,
UserName = user.UserName,
Department1 = user.Department1,
IDCard = user.IDCard,
CreateDate = user.CreateDate,
Enrolled = dci.Template == null ? false : true
}).OrderByDescending(m => m.Id).ToList();