| | |
| | | |
| | | @ApiOperation(tags = "产品管理",value = "产品打包下载") |
| | | @GetMapping("downloadBom") |
| | | public Response downloadBom(HttpServletRequest req, HttpServletResponse resp,@RequestParam String parentModel){ |
| | | return service.downloadBom(req,resp,parentModel); |
| | | public void downloadBom(HttpServletRequest req, HttpServletResponse resp,@RequestParam String parentModel){ |
| | | service.downloadBom(req,resp,parentModel); |
| | | } |
| | | |
| | | } |
| | |
| | | return new Response().setII(1,list!=null?true:false,list,"返回数据"); |
| | | } |
| | | //产品打包下载 |
| | | public Response downloadBom(HttpServletRequest req, HttpServletResponse resp, String parentModel) { |
| | | public void downloadBom(HttpServletRequest req, HttpServletResponse resp, String parentModel) { |
| | | HSSFWorkbook wb = new HSSFWorkbook(); |
| | | //字体格式-加粗 |
| | | HSSFCellStyle cellStyle = wb.createCellStyle(); |
| | |
| | | List<ProductBom> list=mapper.selectList(wrapper); |
| | | //生成excel并将dwg文件放在同一报下压缩 |
| | | creatBomExcel(req,resp,list,wb); |
| | | return new Response().setII(1,true,"",""); |
| | | } |
| | | //根据产品信息创建excel表格并存放在指定目录 |
| | | public void creatBomExcel(HttpServletRequest req, HttpServletResponse resp,List<ProductBom> list, HSSFWorkbook wb){ |