'10' where UserID=ServiceOrdUserID and RecommendUserIDs like '%,".$AdminUserID.",%' and ServiceOrdState not in (4) and ServiceOrd_CC_Time BETWEEN '$DateStart' and '$DateEnd' order by ServiceOrd_NS_Time desc"; $data = sqlsrv_query($conn,$sql); if($data == true){ if (sqlsrv_rows_affected($data)!=0) { while($rs = sqlsrv_fetch_array($data) ) { $i++; if ($rs["NoteName"]!=""){ $UserName=substr($rs["NoteName"],0,16); }else{ $UserName=$rs["ServiceOrdCoName"]; } ?>

没有找到相关的订单

日期	金额	姓名	状态
			咨询"; }elseif ($rs["ServiceOrdState"]==2){ echo "未调度"; }elseif ($rs["ServiceOrdState"]==3){ $DispatchState=$rs["DispatchOrdState"]; if ($DispatchState==8){ echo "订单完成"; }elseif ($DispatchState==9 or $DispatchState==10) { echo "跑空取消"; }else{ echo "转运中"; } }elseif ($rs["ServiceOrdState"]==4){ echo "无效取消"; } ?>