现场检查新增字段

Administrator

2021-09-15 fa730daca20ce1a61cfa8c309e385aee74df0b19

现场检查新增字段

 src/main/java/org/springblade/modules/coinspect/controller/CoinspectController.java

@@ -105,7 +105,7 @@
        }
        //数据同步
        String s1 =
            "insert into sys_coinspect(id,name,sName,deptName,reviewTime,insid,results,url) " +
            "insert into sys_coinspect(id,name,sName,deptName,reviewTime,insid,results,url,handler_result) " +
                "values(" + "'" + coinspect.getId() + "'" + "," +
                "'" + coinspect.getName() + "'" + "," +
                "'" + coinspect.getSname() + "'" + "," +
@@ -114,7 +114,8 @@
                "'" + new SimpleDateFormat("yyyy-MM-dd").format(coinspect.getReviewtime()) + "'" + "," +
                "'" + coinspect.getInsid() + "'" + "," +
                "'" + coinspect.getResults() + "'" + "," +
                "'" + coinspect.getUrl() + "'" + ")";
                "'" + coinspect.getUrl() + "'" + "," +
                "'" + coinspect.getHandlerResult() + "'" + ")";
        FtpUtil.sqlFileUpload(s1);
        return R.success("新增成功");
    }

 src/main/java/org/springblade/modules/coinspect/entity/Coinspect.java

@@ -77,7 +77,16 @@
     */
    @ApiModelProperty(value = "检查结果")
    private String results;


    private String url;


    /**
     * 处理结果
     */
    @TableField("handler_result")
    private String handlerResult;


}