增加字段

zhaowenxuan

2025-04-27 e4cac6b9062112b928afc0a49f70c31b0d12385b

增加字段

 ltkj-hosp/src/main/java/com/ltkj/hosp/domain/SysAttachment.java

@@ -56,6 +56,16 @@
    @Excel(name = "上传后的访问链接")
    private String url;

    private String oldFileName;

            public String getOldFileName() {
                return oldFileName;
            }

            public void setOldFileName(String oldFileName) {
                this.oldFileName = oldFileName;
            }

            public String getUrl() {
                return url;
            }
@@ -159,6 +169,7 @@
            .append("uploadTime",getUploadTime())
            .append("ip",getIp())
            .append("url",getUrl())
            .append("oldFileName",getOldFileName())
        .toString();
        }
        }

 ltkj-hosp/src/main/resources/mapper/hosp/SysAttachmentMapper.xml

@@ -15,10 +15,11 @@
            <result property="uploadTime" column="upload_time"/>
            <result property="ip" column="ip"/>
            <result property="url" column="url"/>
            <result property="oldFileName" column="old_file_name"/>
    </resultMap>

    <sql id="selectSysAttachmentVo">
        select id, sys_dict_val, file_path, file_name, file_size, file_size_mb, file_size_gb, upload_time, ip,url
        select id, sys_dict_val, file_path, file_name, file_size, file_size_mb, file_size_gb, upload_time, ip,url,old_file_name
        from sys_attachment
    </sql>

@@ -84,6 +85,8 @@
                    </if>
                    <if test="url != null and url != ''">url,
                    </if>
                    <if test="oldFileName != null and oldFileName != ''">old_file_name,
                    </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
                    <if test="id != null">#{id},
@@ -105,6 +108,8 @@
                    <if test="ip != null and ip != ''">#{ip},
                    </if>
                    <if test="url != null and url != ''">#{url},
                    </if>
                    <if test="oldFileName != null and oldFileName != ''">#{oldFileName},
                    </if>
        </trim>
    </insert>
@@ -139,6 +144,9 @@
                    <if test="url != null and url != ''">ip =
                        #{url},
                    </if>
                    <if test="oldFileName != null and oldFileName != ''">old_file_name =
                        #{oldFileName},
                    </if>
        </trim>
        where id = #{id}
    </update>