自动化立体仓库 - WMS系统
野心家
2023-06-30 3a41e569efa225c4285d2b2b0e0b7035a6324d9e
src/main/java/com/zy/asrs/controller/OrderController.java
@@ -12,6 +12,7 @@
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;
@@ -389,7 +390,22 @@
        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");
@@ -405,11 +421,11 @@
        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")