From b602aaae04898109df3fa72d1975301d38e2d626 Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@163.com> Date: 星期三, 20 四月 2022 22:20:27 +0800 Subject: [PATCH] # --- src/main/resources/mapper/MatMapper.xml | 1 + src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java | 1 + 2 files changed, 2 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java index 2992414..7dd8ac8 100644 --- a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java @@ -343,6 +343,7 @@ mat.setStatus(1); mat.setCreateTime(now); mat.setUpdateTime(now); + mat.setMemo("鎵撳寘涓婄嚎"); if (!matService.insert(mat)) { throw new CoolException("鏈嶅姟鍣ㄥ唴閮ㄩ敊璇紝璇疯仈绯荤鐞嗗憳"); } diff --git a/src/main/resources/mapper/MatMapper.xml b/src/main/resources/mapper/MatMapper.xml index f878349..5f89c82 100644 --- a/src/main/resources/mapper/MatMapper.xml +++ b/src/main/resources/mapper/MatMapper.xml @@ -60,6 +60,7 @@ group by matnr ) as mld on mld.matnr = mm.matnr WHERE 1=1 + and (mm.memo is null or mm.memo != '鎵撳寘涓婄嚎') AND (CHARINDEX(','+#{tagId}+',', ','+mt.path+',') > 0 OR mt.id = #{tagId}) <if test="matnr != null and matnr != ''"> and mm.matnr like concat('%',#{matnr},'%') -- Gitblit v1.9.1