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