From ab64b09ce3020b376af1e6ee0326ea71330d34ad Mon Sep 17 00:00:00 2001
From: fei.wang <wf18701153496@163.com>
Date: 星期四, 21 三月 2024 09:52:42 +0800
Subject: [PATCH] 修改bug
---
src/main/java/com/flow/mapper/CardMapper.java | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/flow/mapper/CardMapper.java b/src/main/java/com/flow/mapper/CardMapper.java
index dd30f6c..10530d1 100644
--- a/src/main/java/com/flow/mapper/CardMapper.java
+++ b/src/main/java/com/flow/mapper/CardMapper.java
@@ -48,9 +48,9 @@
@Select({"SELECT count(*) FROM card WHERE syflow < '2G' and none = 0 and company = #{zi}"})
int findCardNum5z(String var1);
- @Select({"SELECT * FROM card WHERE none = 0 and cardnumber LIKE CONCAT('%', #{number}, '%') and company = #{company} OR notes LIKE CONCAT('%', #{notes}, '%')"})
- List<Card> FindSearch(@Param("number") String var1, @Param("company") String var2, @Param("notes") String var3);
+ @Select({"SELECT * FROM card WHERE none = 0 and cardnumber LIKE CONCAT('%', #{number}, '%') and company = #{company}"})
+ List<Card> FindSearch(@Param("number") String var1, @Param("company") String var2);
- @Select({"SELECT * FROM card WHERE none = 0 and cardnumber LIKE CONCAT('%', #{number}, '%') OR notes LIKE CONCAT('%', #{notes}, '%')"})
- List<Card> FindSearch1(@Param("number") String var1, @Param("notes") String var3);
+ @Select({"SELECT * FROM card WHERE none = 0 and cardnumber LIKE CONCAT('%', #{number}, '%')"})
+ List<Card> FindSearch1(@Param("number") String var1);
}
--
Gitblit v1.9.3