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