From 18c7a44d2e9db3f4a5322389c3ee94468cce4de1 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期二, 06 五月 2025 10:10:06 +0800
Subject: [PATCH] feat: 新增获取状态写入库，供广交集团的接口使用
---
Task_List.gds | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/Task_List.gds b/Task_List.gds
index 981b6df..b7d9eb6 100644
--- a/Task_List.gds
+++ b/Task_List.gds
@@ -349,7 +349,7 @@
<%
if searchTXT<>"" Then
- searchSql=" DispatchOrdID=(select DispatchOrdIDDt from DispatchOrd_Entourage where EntourageState<>4 and DispatchOrdIDDt=DispatchOrdID and EntourageOAid="&session("adminID")&") and "
+ searchSql=" DispatchOrdID in(select DispatchOrdIDDt from DispatchOrd_Entourage where EntourageState<>4 and DispatchOrdIDDt=DispatchOrdID and EntourageOAid="&session("adminID")&") and "
If Len(searchTXT)=14 And Not IsNumeric(Left(searchTXT,2)) And IsNumeric(Mid(searchTXT,3,8)) And IsNumeric(Right(searchTXT,3)) And Mid(searchTXT,11,1)="-" Then
searchSql=" DispatchOrdClass='"&Left(searchTXT,2)&"' and CONVERT(VARCHAR(10),DispatchOrd_NS_Time,120)=CONVERT(VARCHAR(10),'"&Mid(searchTXT,3,4)&"-"&Mid(searchTXT,7,2)&"-"&Mid(searchTXT,9,2)&"',120) and Right('00'+convert(varchar(3),DispatchOrdNo),3)='"&Right(searchTXT,3)&"' "
ElseIf Len(searchTXT)=10 And IsNumeric(searchTXT) Then
@@ -358,15 +358,15 @@
searchSql=" (ServiceOrdCoName like '%"&searchTXT&"%' or ServiceOrdCoPhone like '%"&searchTXT&"%' or ServiceOrdPtName like '%"&searchTXT&"%' or ServiceOrdTraStreet like '%"&searchTXT&"%' or ServiceOrdTraEnd like '%"&searchTXT&"%') "
End if
else
- searchSql=" DispatchOrd_NS_Time "&SqlOrdDateType&" and DispatchOrdID=(select DispatchOrdIDDt from DispatchOrd_Entourage where EntourageState<>4 and DispatchOrdIDDt=DispatchOrdID and EntourageOAid="&session("adminID")&")"
+ searchSql=" DispatchOrd_NS_Time "&SqlOrdDateType&" and DispatchOrdID in(select DispatchOrdIDDt from DispatchOrd_Entourage where EntourageState<>4 and DispatchOrdIDDt=DispatchOrdID and EntourageOAid="&session("adminID")&")"
If OrdState="0" Then
searchSql=searchSql&" and DispatchOrdState<>4 "
ElseIf OrdState="1" Then
searchSql=searchSql&" and DispatchOrdState in (0) "
ElseIf OrdState="2" Then
- searchSql=searchSql&" and DispatchOrdState in (1,2) and DispatchOrdID=(select DispatchOrdIDDt from DispatchOrd_Entourage where EntourageState<>4 and DispatchOrdIDDt=DispatchOrdID and EntourageOAid="&session("adminID")&") "
+ searchSql=searchSql&" and DispatchOrdState in (1,2) and DispatchOrdID in(select DispatchOrdIDDt from DispatchOrd_Entourage where EntourageState<>4 and DispatchOrdIDDt=DispatchOrdID and EntourageOAid="&session("adminID")&") "
ElseIf OrdState="3" Then
- searchSql=" DispatchOrdState in (3,4,5,6,7) and DispatchOrdID=(select DispatchOrdIDDt from DispatchOrd_Entourage where EntourageState<>4 and DispatchOrdIDDt=DispatchOrdID and EntourageOAid="&session("adminID")&") "
+ searchSql=" DispatchOrdState in (3,4,5,6,7) and DispatchOrdID in(select DispatchOrdIDDt from DispatchOrd_Entourage where EntourageState<>4 and DispatchOrdIDDt=DispatchOrdID and EntourageOAid="&session("adminID")&") "
ElseIf OrdState="8" Then
searchSql=searchSql&" and DispatchOrdState in (8,9) "
Else
--
Gitblit v1.9.1