dev 数据库连接配置修改

zhongrj

2022-08-24 354ca3e06039fbd59a774b6fa168b283f5f1d392

 src/main/java/org/springblade/modules/dispatcher/controller/DispatcherUnitController.java

@@ -140,7 +140,7 @@
            //数据同步
            String s1 =
               "insert into sys_dispatcher_unit(id,name,dept_id,linkman,phone,jurisdiction,create_time,start_time,end_time," +
                  "serve_type,security_linkman,cell,num) " +
                  "serve_type,security_linkman,cell,num,district) " +
                  "values(" + "'" + dispatcherUnit.getId() + "'" + "," +
                  "'" + dispatcherUnit.getName() + "'" + "," +
                  "'" + dispatcherUnit.getDeptId() + "'" + "," +
@@ -153,15 +153,14 @@
                  "'" + dispatcherUnit.getServeType() + "'" + "," +
                  "'" + dispatcherUnit.getSecurityLinkman() + "'" + "," +
                  "'" + dispatcherUnit.getCell() + "'" + "," +
                  "'" + dispatcherUnit.getNum() + "'" + ")";
            //FtpUtil.sqlFileUpload(s1);
            myAsyncService.FTP(s1);
                  "'" + dispatcherUnit.getNum() + "'" + "," +
                  "'" + dispatcherUnit.getDistrict() + "'" + ")";
            myAsyncService.dataSync(s1);
         }
      } else {
         //修改
         status = dispatcherUnitService.updateById(dispatcherUnit);
         //派遣记录修改合同时间

         Long id = dispatcherUnit.getId();
         String ids = String.valueOf(id);
         Date date = dispatcherUnit.getEndTime();
@@ -182,14 +181,13 @@
                  ",security_linkman = " + "'" + dispatcherUnit.getSecurityLinkman() + "'" +
                  ",cell = " + "'" + dispatcherUnit.getCell() + "'" +
                  ",num = " + "'" + dispatcherUnit.getNum() + "'" +
                  ",district = " + "'" + dispatcherUnit.getDistrict() + "'" +
                  " " + "where id = " + "'" + dispatcherUnit.getId() + "'";
            //FtpUtil.sqlFileUpload(s1);
            myAsyncService.FTP(s1);
            myAsyncService.dataSync(s1);
            //内网同步派遣记录修改合同时间
            String s2 =
               "update sys_dispatcher set end_time = " + "'" + endTime + "'" + " " + "where dispatcher_unit_id = " + "'" + ids + "'";
            //FtpUtil.sqlFileUpload(s2);
            myAsyncService.FTP(s2);
            myAsyncService.dataSync(s2);
         }
      }
      return R.status(status);
@@ -208,7 +206,7 @@
         //内网同步
         String s1 = "delete from sys_dispatcher_unit where id = " + "'" + id + "'";
         //FtpUtil.sqlFileUpload(s1);
         myAsyncService.FTP(s1);
         myAsyncService.dataSync(s1);
      });
      return R.status(dispatcherUnitService.removeByIds(Func.toLongList(ids)));
   }