| | |
| | | '取消部分排序算法(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
|
| | |
|
| | |
| | | followerCount = SafeRequest(Request.form("FollowersCount"))
|
| | | If Trim(followerCount)<>"" and IsNumeric(followerCount) then
|
| | | numericFollowerCount = CInt(Trim(followerCount))
|
| | | |
| | | if numericFollowerCount>0 then
|
| | | delFollower ServiceOrderID
|
| | | if numericFollowerCount>0 then
|
| | | |
| | | for i=1 to numericFollowerCount
|
| | | userId = SafeRequest(Request.form("FollowerId_" & i ))
|
| | | userName = SafeRequest(Request.form("FollowerName_" & i))
|