#foreach($column in $columnList)
#if($velocityCount != $columnList.size())
a.$column.columnName,
#else
a.$column.columnName
#end
#end
1=1
#foreach($queryField in $queryFieldList)
#if ($queryField.sqlOperate == 'like')
AND INSTR(a.$queryField.columnName,#{queryDTO.$queryField.fieldName})
#end
#if ($queryField.sqlOperate == 'equals')
#if ($queryField.fieldType == 'String')
AND a.$queryField.columnName = #{queryDTO.$queryField.fieldName}
#else
AND a.$queryField.columnName = #{queryDTO.$queryField.fieldName}
#end
#end
#if ($queryField.sqlOperate == 'in')
and a.$queryField.columnName in
#{item}
#end
#end
and a.id in
#{item}
AND a.create_time >= #{queryDTO.createTimeBegin}
AND a.create_time <= #{queryDTO.createTimeEnd}
AND a.update_time >= #{queryDTO.updateTimeBegin}
AND a.update_time <= #{queryDTO.updateTimeEnd}
delete from ${tableName} where id = #{id}
delete from ${tableName} where id in
#{item}