智慧保安后台管理-外网项目备份
src/main/java/org/springblade/modules/dispatcher/service/impl/DispatcherUnitServiceImpl.java
@@ -117,6 +117,22 @@
            dispatcherUnit.setPhone(dispatcherUnitExcel.getPhone());
         }
         if (dispatcherUnitExcel.getSecurityLinkman()!=null && dispatcherUnitExcel.getSecurityLinkman()!=""){
            dispatcherUnit.setSecurityLinkman(dispatcherUnitExcel.getSecurityLinkman());
         }
         if (dispatcherUnitExcel.getCell()!=null && dispatcherUnitExcel.getCell()!=""){
            dispatcherUnit.setCell(dispatcherUnitExcel.getCell());
         }
         if (dispatcherUnitExcel.getServeType()!=null && dispatcherUnitExcel.getServeType()!=""){
            dispatcherUnit.setServeType(dispatcherUnitExcel.getServeType());
         }
         if (dispatcherUnitExcel.getNum()!=null){
            dispatcherUnit.setNum(dispatcherUnitExcel.getNum());
         }
         dispatcherUnit.setStartTime(dispatcherUnitExcel.getStartTime());
         dispatcherUnit.setEndTime(dispatcherUnitExcel.getEndTime());
@@ -146,19 +162,26 @@
//            }
//         }
         dispatcherUnit.setCreateTime(new Date());
         //新增
         this.save(dispatcherUnit);
         //数据同步
         String s1 =
            "insert into sys_dispatcher_unit(id,name,dept_id,linkman,phone,start_time,end_time) " +
            "insert into sys_dispatcher_unit(id,name,dept_id,linkman,phone,create_time,start_time,end_time,serve_type,security_linkman,cell,num) " +
               "values(" + "'" + dispatcherUnit.getId() + "'" + "," +
               "'" + dispatcherUnit.getName() + "'" + "," +
               "'" + dispatcherUnit.getDeptId() + "'" + "," +
               "'" + dispatcherUnit.getLinkman() + "'" + "," +
               "'" + dispatcherUnit.getPhone() + "'" + "," +
               "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(dispatcherUnit.getCreateTime()) + "'" + "," +
               "'" + new SimpleDateFormat("yyyy/MM/dd").format(dispatcherUnit.getStartTime()) + "'" + "," +
               "'" + new SimpleDateFormat("yyyy/MM/dd").format(dispatcherUnit.getEndTime()) + "'" + ")";
               "'" + new SimpleDateFormat("yyyy/MM/dd").format(dispatcherUnit.getEndTime()) + "'" + "," +
               "'" + dispatcherUnit.getServeType() + "'" + "," +
               "'" + dispatcherUnit.getSecurityLinkman() + "'" + "," +
               "'" + dispatcherUnit.getCell() + "'" + "," +
               "'" + dispatcherUnit.getNum() + "'" + ")";
         FtpUtil.sqlFileUpload(s1);
      });
   }