| | |
| | | import com.sun.org.apache.xpath.internal.operations.Or; |
| | | import com.zy.asrs.entity.*; |
| | | import com.zy.asrs.entity.param.OrderDomainParam; |
| | | import com.zy.asrs.entity.result.OrderDetlVo; |
| | | import com.zy.asrs.service.*; |
| | | import com.zy.common.CodeRes; |
| | | import com.zy.common.model.DetlDto; |
| | |
| | | EntityWrapper<OrderDetl> locCheckEntityWrapper = new EntityWrapper<>(); |
| | | locCheckEntityWrapper.eq("order_no",orderNo); |
| | | List<OrderDetl> list = orderDetlService.selectList(locCheckEntityWrapper); |
| | | |
| | | List<OrderDetlVo> orderDetlVos=new ArrayList<>(); |
| | | OrderDetlVo orderDetlVo=new OrderDetlVo(); |
| | | for (OrderDetl o: |
| | | list) { |
| | | orderDetlVo.setOrderNo(o.getOrderNo()); |
| | | orderDetlVo.setMatnr(o.getMatnr()); |
| | | orderDetlVo.setMaktx(o.getMaktx()); |
| | | orderDetlVo.setSpecs(o.getSpecs()); |
| | | orderDetlVo.setOwner(o.getOwner$()); |
| | | orderDetlVo.setPayment(o.getPayment$()); |
| | | orderDetlVo.setAnfme(o.getAnfme()); |
| | | orderDetlVo.setQty(o.getQty()); |
| | | orderDetlVo.setWorkQty(o.getWorkQty()); |
| | | orderDetlVo.setWeight(o.getWeight()); |
| | | orderDetlVos.add(orderDetlVo); |
| | | } |
| | | response.setContentType("application/vnd.ms-excel"); |
| | | response.setCharacterEncoding("utf-8"); |
| | | String fileName = URLEncoder.encode("单据", "UTF-8"); |
| | |
| | | includeColumnFiledNames.add("qty"); |
| | | includeColumnFiledNames.add("workQty"); |
| | | includeColumnFiledNames.add("weight"); |
| | | EasyExcel.write(response.getOutputStream(), OrderDetl.class) |
| | | EasyExcel.write(response.getOutputStream(), OrderDetlVo.class) |
| | | .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) |
| | | .includeColumnFiledNames(includeColumnFiledNames) |
| | | .sheet("表1") |
| | | .doWrite(list); |
| | | .doWrite(orderDetlVos); |
| | | } |
| | | |
| | | @RequestMapping(value = "/order/list/all") |