学步园

<form action="teTesk/Setauthorization" name="setHt" id="setHt" method="post" enctype="multipart/form-data">

<input name="ll" id = "ll" type="file" value="" />
  <input onclick='sub2()' name = "btn" id = "btn" type="button" value="上传">

</form>

@RequestMapping(value = { "/doAddTeTesk" }, method = { org.springframework.web.bind.annotation.RequestMethod.POST })
 public ModelAndView doAddTeTesk(TeTesk tt, HttpServletRequest request,
   @RequestParam("myExcel") MultipartFile myExcel) {
  Env env = Env.getInstance();
  String path = Env.path1;
  String upStr = myExcel.getOriginalFilename();
  String fileName = getDateTime()
    + upStr.substring(upStr.length() - 4, upStr.length());
   try {
   FileCopyUtils.copy(myExcel.getBytes(), new File(path + fileName));
  } catch (IOException e) {
   e.printStackTrace();
  }

  Workbook rwb = openExcel(path + fileName);
  Sheet sheets = rwb.getSheet(0);
  TeNumber tn = new TeNumber();
  tn.setTeskId(id);
  tt.setCount(sheets.getRows());
  try {
   for (int i = 0; i < sheets.getRows(); i++) {
    Cell c01 = sheets.getCell(1, i);
    Cell c00 = sheets.getCell(0, i);
    tn.setFid(Long.valueOf(fileid));
    tn.setState("-2");
    tn.setCid(user.getCid());
    tn.setNum(c01.getContents());
    tn.setUserCode(c00.getContents());
    this.tnManager.addTeNumber(tn);
   }
  } catch (Exception e) {
   e.printStackTrace();
  }
  closeExcel(rwb);

   ModelAndView md = new ModelAndView();
  md.setViewName("/tesk/addTeTesk");
  md.addObject("taskid", id);
  List bl = this.bizManager.findByUId(user.getUserId());
  List ul = this.userManager.getAllUserByCid(user.getCid());
  List te = this.teTeskManager.getTeTaskInfo(user.getCid());
  md.addObject("te", te);
  md.addObject("bl", bl);
  md.addObject("ul", ul);
  md.addObject("whatSelect", "1");
  return md;
 }

===================================

@RequestMapping(value ="/uploadAuthor", method = RequestMethod.POST)
 public ModelAndView uploadAuthor( HttpServletRequest request,
   @RequestParam("ll") MultipartFile ll) {
    Workbook rwb=null;
  try {
   rwb= Workbook.getWorkbook(ll.getInputStream()) ;
   Sheet sheets = rwb.getSheet(0);
     if("0".equals(runType)){//按部门执行
    for (int i = 3; i < sheets.getRows(); i++) {
     TeSetRole sr = new TeSetRole();
     Cell c00 = sheets.getCell(0, i);//部门id
     Cell c02 = sheets.getCell(2, i);//优先等级
     sr.setBiz(Long.valueOf(c00.getContents()));
     sr.setBizOrder(Integer.parseInt(c02.getContents()));
     System.out.println(sr.getBizOrder());
     sr.setTeskId(Long.valueOf(taskid));
     teTeskManager.addSetRole(sr);
    }
   }else if("1".equals(runType)){//按操作员执行
    for (int i = 3; i < sheets.getRows(); i++) {
     TeSetRole sr = new TeSetRole();
     Cell c00 = sheets.getCell(0, i);//部门id
     Cell c03 = sheets.getCell(3, i);//优先等级
     sr.setUserId(Long.valueOf(c00.getContents()));
     sr.setBizOrder(Integer.parseInt(c03.getContents()));
     System.out.println(sr.getBizOrder());
     sr.setTeskId(Long.valueOf(taskid));
     teTeskManager.addSetRole(sr);
    }
   }
  } catch (Exception e) {
   e.printStackTrace();
  }
  closeExcel(rwb);
    ModelAndView md = new ModelAndView();
  if("edit".equals(type)){
   md.setViewName("/tesk/mytask");
  }else{
   md.setViewName("forward:toAddTeTesk");
  }
  return md;
 }