##sql case语句
(a.Orderer = {1} or case when a.Visibility > 2 then ( ISNULL({0}) or (a.Visibility & {0})>0 )
else (a.Visibility & {0})>0 end )
case when distance < 5 then 0 when distance < 10 then 1 when distance < 20 then 2 " +
" else 3 end,