|
楼主 |
发表于 2017-11-1 16:21:41
|
显示全部楼层
- public static String importExpertExcel(Object file,String fileName,String inFlag) throws Exception {
- Map<String,Object> retMap = getExpertDataFromExcel((InputStream) file,fileName,inFlag);
- String warnMsg = (String) retMap.get("WARN");
- List<Map<String,Object>> cnList = (List<Map<String, Object>>) retMap.get("CNLIST");
- List<Map<String,Object>> snList = (List<Map<String, Object>>) retMap.get("SNLIST");
-
- String insertExpertSql = "insert into t_rpt_expert t_rpt_expert(t_rpt_expert,t_rpt_expert.version,t_rpt_expert.cName,t_rpt_expert.eName,"
- + "t_rpt_expert.sex,t_rpt_expert.birth,t_rpt_expert.nation,t_rpt_expert.poliStatus,t_rpt_expert.country,"
- + "t_rpt_expert.duty,t_rpt_expert.title,t_rpt_expert.isAcadmin,t_rpt_expert.eduDegree,"
- + "t_rpt_expert.workUnit,t_rpt_expert.workPostAdd,t_rpt_expert.postCode,t_rpt_expert.officeTel,t_rpt_expert.fax,t_rpt_expert.mobile,t_rpt_expert.interMail,t_rpt_expert.miliMail,"
- + "t_rpt_expert.secretDegree,t_rpt_expert.certifiNum,t_rpt_expert.status,t_rpt_expert.belongDepart,"
- + "t_rpt_expert.certifiType,t_rpt_expert.unitID,t_rpt_expert.unitName,t_rpt_expert.expertFrom,t_rpt_expert.createTime,t_rpt_expert.updateTime,t_rpt_expert.eduExp,"
- + "t_rpt_expert.reviewFlag,t_rpt_expert.reviewStatus,t_rpt_expert.outIn,t_rpt_expert.outOrIn)"
-
- + "values(:expertId,:version,:name,:ename,:sex,:birthDate,:nation,:policeStatus,:country,"
- + ":postName,:titleName,:isAcadmin,:acadName,"
- + ":workUnitName,:commAddressName,:postCode,:unitPhoneNum,:faxNum,:phoneNum,:interMail,:miliMail,"
- + ":secretlevelName,:certifiNum,:status,:belongDepName,"
- + ":certifiType,:unitID,:unitName,:expertFrom,:createTime,:updateTime,:eduExp,"
- + ":reviewFlag,:reviewStatus,:outIn,:outOrIn)";
-
- try{
- //// 有效数据专家插入到专家表中
- for(Map<String,Object> m:cnList){
- KSQL.executeUpdate(insertExpertSql, m, "/expert/expertInfo/data", null);
- }
-
- //// 重复数据专家插入到专家临时表中,先根据操作用户清除临时表数据
- String insertExpertBakSql = null;
- if(!snList.isEmpty()){
- insertExpertBakSql = insertExpertSql.replace("t_rpt_expert", "t_rpt_expert_bak");
- deleteExpertBak();
- for(Map<String,Object> m:snList){
- KSQL.executeUpdate(insertExpertBakSql, m, "/expert/expertInfo/data", null);
- }
- }
-
- if(StringUtils.isNotEmpty(warnMsg)){
- return "existExpert";
- //return "existExpert&" + warnMsg.substring(0, warnMsg.length()-1);
- }
- return "success";
- } catch (Exception e) {
- e.printStackTrace();
- throw new Exception("导入信息保存失败!");
- }
-
- }
-
复制代码 |
|