1

13693261870

2022-12-21 1cc39fcee029ead0aa87898d67023855ce24a419

1

 src/main/java/com/lf/server/entity/all/BaseEntity.java

@@ -1,5 +1,6 @@
package com.lf.server.entity.all;

import com.baomidou.mybatisplus.annotation.FieldStrategy;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
@@ -31,19 +32,19 @@

    private Timestamp updatetime;

    @TableField(value = "fn_rec_query(dirid,'dir')")
    @TableField(value = "fn_rec_query(dirid,'dir')", updateStrategy = FieldStrategy.NEVER)
    private String dirName;

    @TableField(value = "fn_rec_query(depid,'dep')")
    @TableField(value = "fn_rec_query(depid,'dep')", updateStrategy = FieldStrategy.NEVER)
    private String depName;

    @TableField(value = "fn_ver(verid)")
    @TableField(value = "fn_ver(verid)", updateStrategy = FieldStrategy.NEVER)
    private String verName;

    @TableField(value = "fn_uname(createuser)")
    @TableField(value = "fn_uname(createuser)", updateStrategy = FieldStrategy.NEVER)
    private String createName;

    @TableField(value = "fn_uname(updateuser)")
    @TableField(value = "fn_uname(updateuser)", updateStrategy = FieldStrategy.NEVER)
    private String updateName;

    public BaseEntity() {

 src/main/java/com/lf/server/entity/all/StaticData.java

@@ -72,17 +72,17 @@
    /**
     * 插入排除字段
     */
    public final static List<String> INSERT_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("gid", "objectid", "updateuser", "updatetime", "shape_leng", "shape_area", "dirName", "depName", "verName", "createName", "updateName"));
    public final static List<String> INSERT_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("gid", "objectid", "updateuser", "updatetime", "shape_leng", "shape_area", "serialVersionUID", "dirName", "depName", "verName", "createName", "updateName"));

    /**
     * 更新排除字段
     */
    public final static List<String> UPDATE_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("objectid", "createuser", "createtime", "shape_leng", "shape_area", "dirName", "depName", "verName", "createName", "updateName"));
    public final static List<String> UPDATE_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("objectid", "createuser", "createtime", "shape_leng", "shape_area", "serialVersionUID", "dirName", "depName", "verName", "createName", "updateName"));

    /**
     * 读取排除字段
     */
    public final static List<String> READ_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("gid", "objectid", "dirid", "depid", "verid", "createtime", "createuser", "updateuser", "updatetime", "shape_leng", "shape_area", "dirName", "depName", "verName", "createName", "updateName"));
    public final static List<String> READ_EXCLUDE_FIELDS = new ArrayList<>(Arrays.asList("gid", "objectid", "dirid", "depid", "verid", "createtime", "createuser", "updateuser", "updatetime", "shape_leng", "shape_area", "serialVersionUID", "dirName", "depName", "verName", "createName", "updateName"));

    /**
     * MDB排除字段

 src/main/java/com/lf/server/extend/InsertBatchMethod.java

@@ -41,7 +41,7 @@
        // fieldSql.append(tableInfo.getKeyColumn()).append(",")
        // tableInfo.getFieldList().forEach(x -> fieldSql.append(x.getColumn()).append(","))
        for (TableFieldInfo f : tableInfo.getFieldList()) {
            if (StaticData.INSERT_EXCLUDE_FIELDS.contains(f.getColumn())) {
            if (StaticData.INSERT_EXCLUDE_FIELDS.contains(f.getProperty())) {
                continue;
            }

@@ -61,11 +61,11 @@
        // valueSql.append("#{item.").append(tableInfo.getKeyProperty()).append("},")
        // tableInfo.getFieldList().forEach(x -> valueSql.append("#{item.").append(x.getProperty()).append("},"))
        for (TableFieldInfo f : tableInfo.getFieldList()) {
            if (StaticData.INSERT_EXCLUDE_FIELDS.contains(f.getColumn())) {
            if (StaticData.INSERT_EXCLUDE_FIELDS.contains(f.getProperty())) {
                continue;
            }

            valueSql.append("geom".equals(f.getColumn()) ? "${item." : "#{item.").append(f.getProperty()).append("},");
            valueSql.append("geom".equals(f.getProperty()) ? "${item." : "#{item.").append(f.getProperty()).append("},");
        }

        valueSql.delete(valueSql.length() - 1, valueSql.length());

 src/main/java/com/lf/server/extend/UpdateBatchMethod.java

@@ -68,7 +68,7 @@
    private String getSqlSet(TableInfo tableInfo) {
        StringBuilder sb = new StringBuilder();
        for (TableFieldInfo f : tableInfo.getFieldList()) {
            if (StaticData.UPDATE_EXCLUDE_FIELDS.contains(f.getColumn())) {
            if (StaticData.UPDATE_EXCLUDE_FIELDS.contains(f.getProperty())) {
                continue;
            }

@@ -77,7 +77,7 @@
                continue;
            }

            sb.append(String.format("<if test=\"item['%s'] != null\">%s=#{item.%s},</if>\n", f.getColumn(), f.getColumn(), f.getColumn()));
            sb.append(String.format("<if test=\"item['%s'] != null\">%s=#{item.%s},</if>\n", f.getProperty(), f.getColumn(), f.getProperty()));
        }
        sb.deleteCharAt(sb.length() - 1);