修改文件信息

lxw

2022-10-26 6aca9d89ce73536948dec7b6062c7b392c52376d

修改文件信息

 res.db

Binary files differ

 src/main/java/com/whyc/mapper/FileParamMapper.java

@@ -17,4 +17,6 @@
    void deleteParamByStationId(int stationId);
    //修改文件对应的数据库数据
    void updateParamByFileUrl(@Param("fileParam") FileParam fileParam, @Param("filePath") String filePath);
    //修改参数信息
    void updateParam(@Param("fileParam")  FileParam fileParam, @Param("fileId") String fileId);
}

 src/main/java/com/whyc/service/FileParamService.java

@@ -119,9 +119,25 @@
            bl=XmlFileOpreate.writeXml(map,filePath);
        }
        //修改文件对应的数据库数据
        paramMapper.updateParamByFileUrl(fileParam,filePath);
        //paramMapper.updateParamByFileUrl(fileParam,filePath);
        updateParamByFileUrl(fileParam,filePath);
        return new Response().setII(1,bl,map,"修改文件");
    }
    //修改文件对应的数据库数据
    public void updateParamByFileUrl(FileParam fileParam,String filePath){
        //根据文件路径查出file_id
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.eq("file_url",filePath);
        List<FileInfo> list=infoMapper.selectList(wrapper);
        if(list!=null&&list.size()>0){
            for (FileInfo info:list){
                //修改参数信息
                paramMapper.updateParam(fileParam,info.getFileId());
            }
        }

    }

    //通过修改属性窗口值来修改文件值
    public Response updateXmlByParamMap(Map<String,String> map,String filePath) {
        boolean bl=false;

 src/main/resources/mapper/FileParamMapper.xml

@@ -15,6 +15,19 @@
        where p.file_id=i.file_id
          and i.file_url=#{filePath}
    </update>
    <update id="updateParam">
        update tb_file_param set
            upload_time=#{fileParam.uploadTime},test_time=#{fileParam.testTime},version=#{fileParam.version},
            upload_flag=#{fileParam.uploadFlag},batt_group_name=#{fileParam.battGroupName},batt_brand=#{fileParam.battBrand},
            batt_model=#{fileParam.battModel},batt_batch=#{fileParam.battBatch},batt_station=#{fileParam.battStation},
            battline_name=#{fileParam.battlineName},batt_tha=#{fileParam.battTha},batt_errFlag=#{fileParam.battErrflag},batt_testNum=#{fileParam.battTestnum},
            batt_faultNum=#{fileParam.battFaultnum},batt_cap=#{fileParam.battCap},batt_count=#{fileParam.battCount},
            batt_vol=#{fileParam.battVol},batt_res=#{fileParam.battRes},group_num=#{fileParam.groupNum},
            volLowCoeK1=#{fileParam.volLowCoeK1},volHighCoeK2=#{fileParam.volHighCoeK2},resGoodCoeK3=#{fileParam.resGoodCoeK3},
            resBadCoeK4=#{fileParam.resBadCoeK4},sample_percent=#{fileParam.samplePercent},highTempAlarm=#{fileParam.highTempAlarm},
            chainRes=#{fileParam.chainRes},evaluation_mode=#{fileParam.evaluationMode},factor_disabled=#{fileParam.factorDisabled}
        where file_id=#{fileId}
    </update>
    <delete id="deleteParamByFileId">
        delete from tb_file_param where  file_id=#{fileId}
    </delete>