${if(len(区段编号)==0,'',"and B.AREANO IN ('"+区段编号+"')")}${if(len(设备编号)==0,'',"and A.EQUIPMENTNO IN ('"+设备编号+"')")}${if(len(开始时间)==0,'',"and to_char(A.ENDTIME,'yyyy/mm/dd') >='"+开始时间+"'")}${if(len(结束时间)==0,'',"and to_char(A.ENDTIME,'yyyy/mm/dd') <='"+结束时间+"'")} |