From 04ac29e927990eecf2f9eadd1a74d7b4daf9058c Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@163.com> Date: 星期五, 25 三月 2022 14:51:22 +0800 Subject: [PATCH] #杰克缝纫机立库 【根据单号检索单据数据】 优化 --- src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java b/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java index 578ea15..cff29c5 100644 --- a/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java +++ b/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java @@ -24,6 +24,9 @@ public List<ViewStayTimeBean> getViewStayTimeAll(ViewStayTimeBean viewStayTime); // // 搴撲綅Map + @Select("select distinct row1 from asr_loc_mast order by row1 asc") + List<Integer> getViewLocRowTotal(); + @Select("select distinct lev1 from asr_loc_mast where row1=#{row1} order by lev1 desc") public List<String> getViewLocLevCount(@Param("row1") int row1); // -- Gitblit v1.9.1