From ea0628889f64f802768c4fdf17d2223424e5e29f Mon Sep 17 00:00:00 2001 From: hutongqing <hutongqing@hnkhzn.com> Date: 星期三, 30 十月 2024 11:13:22 +0800 Subject: [PATCH] 1 --- WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Service/DispatchInfoService.cs | 24 ++++++++++++++++++++++-- 1 files changed, 22 insertions(+), 2 deletions(-) diff --git a/WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Service/DispatchInfoService.cs b/WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Service/DispatchInfoService.cs index 27a92be..5c694aa 100644 --- a/WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Service/DispatchInfoService.cs +++ b/WIDESEAWCS_Server/WIDESEAWCS_QuartzJob/Service/DispatchInfoService.cs @@ -47,7 +47,7 @@ /// <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, @@ -63,8 +63,28 @@ ModifyDate = a.ModifyDate, Name = a.Name, Remark = a.Remark, - DeviceType = b.DeviceType + DeviceType = b.DeviceType, + Enable = (b.DeviceStatus) ?? (((int)DeviceStatusEnum.Enable).ToString()) }).ToList(); + + //return Db.Queryable<Dt_DispatchInfo, Dt_DeviceInfo>((a, b) => a.JobGroup == b.DeviceType && b.DeviceStatus == ((int)DeviceStatusEnum.Enable).ToString()).Select((a, b) => new DispatchInfoDTO + //{ + // JobGroup = a.JobGroup, + // AssemblyName = a.AssemblyName, + // BeginTime = a.BeginTime, + // ClassName = a.ClassName, + // CreateDate = a.CreateDate, + // Creater = a.Creater, + // CycleHasRunTimes = 0, + // EndTime = a.EndTime, + // Id = b.Id, + // IntervalSecond = a.IntervalSecond, + // Modifier = a.Modifier, + // ModifyDate = a.ModifyDate, + // Name = a.Name, + // Remark = a.Remark, + // DeviceType = b.DeviceType + //}).ToList(); } } } -- Gitblit v1.9.3