feat: 更新系统

kongdeqiang

2026-03-23 79619d4274f3bb8d4b90a0e7ddafc17e3c9028bf

feat: 更新系统

 src/main/java/com/example/entity/DataExcel.java

@@ -44,4 +44,6 @@
    private String remark;

    private Integer status;

    private String pkVoucher;
}

 src/main/java/com/example/excel/DataExcelImport.java

@@ -53,4 +53,7 @@

    @ExcelProperty("备注")
    private String remark;

    @ExcelProperty("PK_VOUCHER")
    private String pkVoucher;
}

 src/main/java/com/example/service/impl/DataExcelServiceImpl.java

@@ -51,10 +51,10 @@
                        errorMsgs.add("第" + data.getSeqNo() + "行单位编码为空");
                        return;
                    }
                    if (!permissionDeptCodes.contains(data.getUnitCode())) {
                        errorMsgs.add("第" + data.getSeqNo() + "行无权限导入部门编码: " + data.getUnitCode());
                        return;
                    }
//                    if (!permissionDeptCodes.contains(data.getUnitCode())) {
//                        errorMsgs.add("第" + data.getSeqNo() + "行无权限导入部门编码: " + data.getUnitCode());
//                        return;
//                    }

                    DataExcel entity = new DataExcel();
                    entity.setSortNo(data.getSortNo());
@@ -74,6 +74,7 @@
                    entity.setBusinessRelation(data.getBusinessRelation());
                    entity.setRemark(data.getRemark());
                    entity.setStatus(1);
                    entity.setPkVoucher(data.getPkVoucher());

                    if (data.getSortNo() != null) {
                        DataExcel existData = baseMapper.selectBySortNo(data.getSortNo());

 src/main/resources/mapper/DataExcelMapper.xml

@@ -27,6 +27,7 @@
        <result column="update_by" property="updateBy"/>
        <result column="deleted" property="deleted"/>
        <result column="version" property="version"/>
        <result column="pk_voucher" property="pkVoucher"/>
    </resultMap>

    <select id="selectDataExcelPage" resultMap="dataExcelResultMap">
@@ -85,7 +86,8 @@
            create_by,
            update_by,
            deleted,
            version
            version,
            pk_voucher
        ) VALUES (
            #{id},
            <if test="seqNo != null">#{seqNo},</if>
@@ -110,7 +112,8 @@
            #{createBy},
            #{updateBy},
            0,
            1
            1,
            #{pkVoucher}
        )
    </insert>
</mapper>