Esempio n. 1
0
 // 导入项目工兼职教师人员
 public void batchSaveWageEmpPerson(List<Map> list, String importType) throws SysException {
   String sql =
       "update a239 set a239200=null,a239201=null where id in (select id from a001 where A001054='"
           + importType
           + "')";
   this.jdbcTemplate.execute(sql);
   for (Map m : list) {
     UserBO bo = new UserBO();
     bo.setName(m.get("name").toString());
     bo.setDeptId(m.get("deptID").toString());
     bo.setPersonType(m.get("personType").toString());
     bo.setHasCashStr(m.get("hasCash").toString());
     bo.setCardNO(m.get("card").toString());
     bo.setBankNO(m.get("bank") == null ? "" : m.get("bank").toString());
     if (m.get("id") != null) {
       bo.setUserID(m.get("id").toString());
       bo.setPersonSeq(m.get("personCode").toString());
     }
     saveWageEmpPerson(bo, String.valueOf(m.get("wage")), String.valueOf(m.get("other")));
   }
 }