62,271
社区成员
发帖
与我相关
我的任务
分享
List<PositionInfo> PositionInfoList = new List<PositionInfo>();
PositionInfoList = from ps in context.Position
join pt in context.PositionTemplate on ps.PositionTemplateId equals pt.Id
join jb in context.JobGrade on pt.JobGradeId equals jb.Id
join ptp in context.PositionType on pt.PositionTypeId equals ptp.Id
select new
{
JobGradeId = jb.Id,
JobGradeName = jb.Name,
PositionTypeId = ptp.Id,
PositionTypeName = ptp.Name,
PositionId = ps.Id
};
PositionInfoList = (from ps in context.Position
join pt in context.PositionTemplate on ps.PositionTemplateId equals pt.Id
join jb in context.JobGrade on pt.JobGradeId equals jb.Id
join ptp in context.PositionType on pt.PositionTypeId equals ptp.Id
select new
{
JobGradeId = jb.Id,
JobGradeName = jb.Name,
PositionTypeId = ptp.Id,
PositionTypeName = ptp.Name,
PositionId = ps.Id
}) as List<PositionInfo> ;
List<PositionInfo> PositionInfoList = new List<PositionInfo>();
PositionInfoList = (from ps in context.Position
join pt in context.PositionTemplate on ps.PositionTemplateId equals pt.Id
join jb in context.JobGrade on pt.JobGradeId equals jb.Id
join ptp in context.PositionType on pt.PositionTypeId equals ptp.Id
select new PositionInfo
{
JobGradeId = jb.Id,
JobGradeName = jb.Name,
PositionTypeId = ptp.Id,
PositionTypeName = ptp.Name,
PositionId = ps.Id
}).ToList();
select new 的时候 初始化对象 PositionInfo 然后tolist集合