From c86a2e79e4f038401e37acc58b622d487b57af5d Mon Sep 17 00:00:00 2001 From: whycq <10027870+whycq@user.noreply.gitee.com> Date: 星期五, 17 三月 2023 14:29:46 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/LocMastMapper.java | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java index 9fd1d06..f9ae090 100644 --- a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java +++ b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java @@ -32,6 +32,8 @@ LocMast queryDemoLoc(@Param("crnNo") Integer crnNo); + LocMast queryDemoLoc0(@Param("crnNo") Integer crnNo, @Param("locType1") short locType1); + @Select("select count(*) as count from asr_loc_mast where 1=1 and loc_sts = 'O' and loc_type1 = #{locType1} and crn_no = #{crnNo}") Integer selectEmptyLocCount(@Param("locType1") Short locType1, @Param("crnNo") Integer crnNo); -- Gitblit v1.9.1