| | |
| | | /// <returns>返回调度服务JobDTO集合。</returns> |
| | | public List<DispatchInfoDTO> QueryDispatchInfos() |
| | | { |
| | | return Db.Queryable<Dt_DispatchInfo, Dt_DeviceInfo>((a, b) => a.JobGroup == b.DeviceType && b.DeviceStatus == ((int)DeviceStatusEnum.Enable).ToString()).Select((a, b) => new DispatchInfoDTO |
| | | return Db.Queryable<Dt_DispatchInfo>().LeftJoin<Dt_DeviceInfo>((a, b) => a.JobGroup == b.DeviceType).Select((a, b) => new DispatchInfoDTO |
| | | { |
| | | JobGroup = a.JobGroup, |
| | | AssemblyName = a.AssemblyName, |
| | |
| | | ModifyDate = a.ModifyDate, |
| | | Name = a.Name, |
| | | Remark = a.Remark, |
| | | DeviceType = b.DeviceType |
| | | DeviceType = b.DeviceType, |
| | | Enable = (b.DeviceStatus) ?? (((int)DeviceStatusEnum.Enable).ToString()) |
| | | }).ToList(); |
| | | } |
| | | } |