修改导入人员

李宇

2021-06-18 b0f32077cca12adb359ec359578307b3bad1774c

修改导入人员

 src/main/java/com/nanometer/smartlab/controller/UserMngController.java

@@ -188,19 +188,18 @@
                        }
                        valuesList.add(id);
                    }else if(t==6){
                        cellInfo=new BigDecimal(""+cellInfo).toString();
                        valuesList.add(cellInfo);
                        if (!StringUtils.isEmpty(cellInfo)){
                            cellInfo=new BigDecimal(""+cellInfo).toString();
                            valuesList.add(cellInfo);
                        }else{
                            valuesList.add(cellInfo);
                        }
                    }
                    else {
                        valuesList.add(cellInfo);
                    }
                }

                }
                System.out.println("size :     "+valuesList.size());
                System.out.println("value :     "+valuesList);
                if (valuesList.size() != 14){
                    break;
                }
                SysUser sysUser=new SysUser();
                sysUser.setCompany(valuesList.get(0));//单位
                sysUser.setDepartment(valuesList.get(1));//部门
@@ -211,8 +210,8 @@
                String PW_PATTERN = "(?=.*[A-Z])(?=.*[a-z])(?=.*[0-9])(?=.*[~!@#$%^&*_.]).{8,}";
                if (!valuesList.get(5).matches(PW_PATTERN)){
                    errorMsg += "第"+i+"行,密码必须8位以上,并且包含大小写字母、数字、特殊符号三种以上";
                    continue;
                }

                sysUser.setPassword(MD5Utils.encode(valuesList.get(5))+"");//密码

                //valuesList.get(8) id卡号检查
@@ -225,10 +224,12 @@
                            //8位补齐20位，否则不做操作
                            String idCard = "E0E01E000A" + idCardUpper + "01";
                            sysUser.setIdCard(idCard);//id卡号
                        }else {
                            sysUser.setIdCard(idCardUpper);//id卡号
                        }
                    }else{
                        FacesUtils.warn("第"+i+"行,id卡号需要8位或者20位");
                        return;
                        errorMsg += ("第"+i+"行,id卡号需要8位或者20位");
                        continue;
                    }
                }
                sysUser.setPhone(valuesList.get(6));//电话
@@ -259,7 +260,8 @@
                    for (String project : projects) {
                        //不存再就直接推出
                        if (!sysProjectService.isExistProject(project)) {
                            throw new Exception("课题组不存在,（" + i  + "行）");
                            errorMsg += ("课题组不存在,（" + i  + "行）");
                            continue;
                        }
                    }
                    //都存在就设置
@@ -271,13 +273,14 @@
                sysUser.setValidFlag(ValidFlag.VALID);
                userList.add(sysUser);
            }
            if (errorMsg != null){
                FacesUtils.warn(errorMsg);
            }

            this.sysUserService.insertSysUserList(userList);
            System.out.println("=========导入结束=====");
            FacesUtils.info("导入成功。");
            if (errorMsg != null){
                FacesUtils.warn(errorMsg);
            }else {
                FacesUtils.info("导入成功。");
            }
        }catch (Exception ex) {
            ex.printStackTrace();
            FacesUtils.info("导入失败。");