From 8cdeacd407027fdffa13b86c089c6ab407f3b773 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期三, 13 十二月 2023 17:57:06 +0800
Subject: [PATCH] 1.设备保养项目、设备保养标准导入接口开发
---
VueWebCoreApi/DLL/DAL/DeviceManagerDAL.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/DeviceManagerDAL.cs b/VueWebCoreApi/DLL/DAL/DeviceManagerDAL.cs
index 1ff294c..ee9293d 100644
--- a/VueWebCoreApi/DLL/DAL/DeviceManagerDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/DeviceManagerDAL.cs
@@ -1792,7 +1792,7 @@
try
{
//鑾峰彇宸ヤ綔绔欓泦鍚�(杞﹂棿,鍖呭惈宸茬粦瀹氬伐浣滅珯鏍囪瘑)
- sql = @"select distinct E.torg_code,T.torg_name as wksp_name,'E' as type,(case when B.wksp_code is null then 'N' else 'Y' end) flag
+ sql = @"select distinct E.torg_code as wksp_code,T.torg_name as wksp_name,'E' as type,(case when B.wksp_code is null then 'N' else 'Y' end) flag
from TEqpInfo E
left join TOrganization T on E.torg_code=T.torg_code
left join(
--
Gitblit v1.9.3