| | |
|---|
| | |
|
|---|
| | | <%
|
|---|
| | | 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
|
|---|
| | |
|---|
| | | 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
|
|---|
