#foreach ($column in $columns)
a.${column.columnName} as "${column.javaField}"#if($foreach.hasNext),
#else
#end
#end
##根据排序字段计算最大排序号
#foreach($column in $columns)
#if($column.columnName == "sort")
#break
#end
#end
INSERT INTO ${tableName}(
#foreach($column in $columns)
$column.columnName#if($foreach.hasNext),
#end
#end
) VALUES (
#foreach($column in $columns)
#{$column.javaField}#if($foreach.hasNext),
#end
#end
)
UPDATE ${tableName} SET
#foreach($column in $columns)
#if($column.javaField != "id" && $column.javaField != "createBy" && $column.javaField != "createDept" && $column.javaField != "createTime" && $column.javaField != "id" && $column.javaField != "version" && $column.javaField != "delFlag")
$column.columnName = #{$column.javaField},
#end
#end
version = version + 1
WHERE id = #{id} and version = #{version}
UPDATE ${tableName} SET
status = #{status},
version = version + 1
WHERE id = #{id}
UPDATE ${tableName} SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE ${tableName} SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id in
#{id}