edit | blame | history | raw

queryByCondition

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

queryRelListByVehicleId

select t.* 
 from xzx_user_vehicle_rel t 
where del_flag=0 
  and vehicle_id=#vehicleId# 
  and user_id=#userId#

batchDelXzxUserVehicleRelByIds

  • 批量逻辑删除

    update xzx_user_vehicle_rel set del_flag = 1 where id in( #join(ids)#)