queryByCondition
===
    select 
    @pageTag(){
    t.*
    @}
    from xzx_user_vehicle_info t
    where 1=1  
    @//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行  
    and #function("xzxUserVehicleInfo.query")#
    
batchDelXzxUserVehicleInfoByIds
===

* 批量逻辑删除

    update xzx_user_vehicle_info set del_flag = 1 where id  in( #join(ids)#)
    
queryByVehicleInfoList   
=== 
        select a.id,m.id as relId,a.vehicle_no as vehicleNo,(select c.storage_name from xzx_sys_storage c where c.id=a.storage_id) as address,
              m.name as name,a.weight as weight,m.user_id as userId,a.storage_id as storageId
        from xzx_user_vehicle_info a
        left join ( select b.id,b.user_id,d.name,b.vehicle_id,d.partner_id 
                   from xzx_user_vehicle_rel b
                   left join xzx_user_other_info d on b.user_id=d.user_id) m
                 on a.id=m.vehicle_id 
        where  a.del_flag=0
        @if(!isEmpty(vehicleNo)){
                            AND a.vehicle_no like #'%'+vehicleNo+'%'# 
        @}
        @if(!isEmpty(partnerIds)){
               AND m.partner_id in (#join(partnerIds)#)
        @}                       
         LIMIT #page#, #limit#
queryByVehicleInfoCount
===

        select count(a.id)
        from xzx_user_vehicle_info a
        left join ( select b.id,b.user_id,d.name,b.vehicle_id,d.partner_id 
                           from xzx_user_vehicle_rel b
                           left join xzx_user_other_info d on b.user_id=d.user_id) m
                         on a.id=m.vehicle_id 
        where  a.del_flag=0   
        @if(!isEmpty(vehicleNo)){
                                AND a.vehicle_no=#vehicleNo#
                             @} 
         @if(!isEmpty(partnerIds)){
                        AND m.partner_id in (#join(partnerIds)#)
                 @}