Example #1
0
 /**
  * 从excel文件导入客户数据到本地数据库
  *
  * @return
  */
 @RequestMapping(params = "method=importOrderFromExcel")
 @ResponseBody
 public void importOrderFromExcel(HttpServletRequest request, HttpServletResponse response) {
   ImportContext importContext = new ImportContext();
   String result = null;
   importContext.setShopId((Long) request.getSession().getAttribute("shopId"));
   String importRecordIds = request.getParameter("importRecordId");
   List<Long> importRecordIdlist = NumberUtil.parseLongValues(importRecordIds);
   Map<String, String> fieldMapping =
       JsonUtil.jsonToStringMap(request.getParameter("fieldMapping"));
   if (importRecordIdlist == null
       || importRecordIdlist.isEmpty()
       || fieldMapping == null
       || fieldMapping.isEmpty()) {
     result = ImportConstants.MESSAGE_NEED_FILE_OR_MAPPING;
   }
   importContext.setImportRecordIdList(importRecordIdlist);
   importContext.setFieldMapping(fieldMapping);
   importContext.setType(ImportConstants.Type.TYPE_ORDER);
   ImportResult importResult = null;
   try {
     importResult = txnService.importOrderFromExcel(importContext);
   } catch (Exception e) {
     LOG.error(e.getMessage(), e);
   }
   result = JsonUtil.objectToJson(importResult);
   PrintWriter writer = null;
   try {
     writer = response.getWriter();
     writer.write(result);
     writer.flush();
     writer.close();
   } catch (IOException e) {
     LOG.error("/importOrder.do");
     LOG.error("method=importOrderFromExcel");
     LOG.error("单据导入出错");
     LOG.error(e.getMessage(), e);
   } catch (Exception e) {
     LOG.error("/importOrder.do");
     LOG.error("method=importOrderFromExcel");
     LOG.error("单据导入出错");
     LOG.error(e.getMessage(), e);
   }
 }