From 91f2aa1414d31ab1a2791c7a907abfaf715a7bce Mon Sep 17 00:00:00 2001
From: hzj <1831054011@qq.com>
Date: 星期四, 18 十二月 2025 10:06:55 +0800
Subject: [PATCH] fix:修复出车人员显示和福祉车地区
---
AdminUserSearch.gds | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/AdminUserSearch.gds b/AdminUserSearch.gds
index 8ac6469..ec962ae 100644
--- a/AdminUserSearch.gds
+++ b/AdminUserSearch.gds
@@ -109,7 +109,7 @@
'鍙栨秷閮ㄥ垎鎺掑簭绠楁硶(22.11.19) 鎺掑簭浼樺寲鏂规A
sql="select OA_User_ID,OA_Name,OA_mobile,OA_weixinAvatar,OA_Img,OA_Img_64,OA_UserRemark,aa=(isnull(SchedulesShiftTOP,10000)+1),SchedulesTypeManeuver=isnull(SchedulesTypeManeuver,0),SchedulesTypeAM,SchedulesTypePM from OA_User LEFT JOIN OA_Schedules on OAid=OA_User_ID and SchedulesDate='"&DateDay&"' and CompetencyID="&OA_CompetencyID&" and SchedulesShiftID="&SchedulesShiftID&" ,OA_Competency where OA_User_ID=OA_CompetencyUserID and OA_CompetencyID="&OA_CompetencyID&" and OA_execLevel in (0,1,2)"&ClassSql&" order by SchedulesTypeManeuver desc,aa,OA_User_ID"
end If
-'Response.Write sql
+Response.Write sql
end if
@@ -164,7 +164,7 @@
OA_Name=OA_Name&"[浼戜笅鍗圿"
end if
if rs("aa")<10001 then
- sql="select top 1 DispatchOrdIDDt from DispatchOrd_Entourage,DispatchOrd where DispatchOrdID=DispatchOrdIDDt and EntourageState<>4 and DispatchOrdState not in (8,9,10,14) and EntourageEnd_Time is null and DATEDIFF(d,EntourageState_Time,GETDATE())<3 and EntourageOAid="&OA_UserID
+ sql="select top 1 DispatchOrdIDDt from DispatchOrd_Entourage,DispatchOrd where DispatchOrdID=DispatchOrdIDDt and EntourageState<>4 and DispatchOrdState not in (8,9,10,14) and EntourageEnd_Time is null and DATEDIFF(d,EntourageState_Time,GETDATE())<10 and EntourageOAid="&OA_UserID
rsDt.open Sql,objConn,1,1
if not rsDt.Eof then
OA_Name="<img src=/resources/images/2016090802.png>"&OA_Name
--
Gitblit v1.9.1