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