解决大坝安全监测人工上报报错问题

xieb

2024-06-05 45221f115bca8d278af9569f07bb2709118212f5

解决大坝安全监测人工上报报错问题

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztdw/mapper/DwsWaterResZEightDetailAllMapper.xml

@@ -7,10 +7,10 @@

        UPDATE SJZT_DW."dws_water_res_z_eight_detail_all" SET
            <if test="entity.rz != null and entity.rz !='' ">
                "rz" = #{entity.rz},
                "rz" = #{entity.rz}
            </if>
            <if test="entity.lowZ != null and entity.lowZ !='' ">
                "low_z" = #{entity.lowZ}
                ,"low_z" = #{entity.lowZ}
            </if>
        WHERE 1=1
            <if test="entity.isTb != null and entity.isTb != ''">

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztdw/service/impl/DwsResFormDiServiceImpl.java

@@ -42,6 +42,7 @@
    private IDsmSpgSpprmpService dsmSpgSpprmpService;

    @Override
    @Transactional
    public void importDbPersonData(List<DbExcel> data, String resGuid,String ch) {

        //获取行政区划
@@ -61,7 +62,7 @@
        List<DsmSpgSpqnmp> dsmSpgSpqnmpList = dsmSpgSpqnmpService.getList(paramSl);

        data.forEach(dbExcel->{

            dbExcel.setAvgValue(dbExcel.getAvgValue().replace("，",","));
            if (StringUtil.isBlank(dbExcel.getRz())){
                dbExcel.setRz("");
            }
@@ -200,6 +201,7 @@
                }
            }
        }catch (Exception e){
            e.printStackTrace();
            throw new RuntimeException("表格渗压数据个数超过当前水库断面测点个数");
        }