| | |
|---|
| | | '取消部分排序算法(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
|
|---|
| | |
|
|---|
| | |
|---|
| | | 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
|
|---|
