From f6f761a2a846c69f261281a88ce7d42ebefcc0e5 Mon Sep 17 00:00:00 2001
From: whycq <10027870+whycq@user.noreply.gitee.com>
Date: 星期二, 06 八月 2024 11:09:11 +0800
Subject: [PATCH] #
---
src/main/resources/mapper/LocDetlMapper.xml | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 85f6e52..22714d6 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -320,7 +320,9 @@
#{item}
</foreach>
</if>
- and a.bom_code = #{bomCode}
+ <if test="bomCode != null and bomCode != ''">
+ and a.bom_code = #{bomCode}
+ </if>
order by
DATEPART(yyyy,a.modi_time),DATEPART(mm,a.modi_time),DATEPART(dd,a.modi_time), a.anfme
desc,
--
Gitblit v1.9.1