From 61747a14819075bf6da2c1597b6c22e22e026686 Mon Sep 17 00:00:00 2001
From: fei.wang <wf18701153496@163.com>
Date: 星期一, 15 四月 2024 14:25:11 +0800
Subject: [PATCH] 4-15修改提交
---
src/main/java/com/flow/mapper/CardMapper.java | 48 +++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 45 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/flow/mapper/CardMapper.java b/src/main/java/com/flow/mapper/CardMapper.java
index 10530d1..63fa27f 100644
--- a/src/main/java/com/flow/mapper/CardMapper.java
+++ b/src/main/java/com/flow/mapper/CardMapper.java
@@ -10,13 +10,14 @@
import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.annotations.Update;
public interface CardMapper extends BaseMapper<Card> {
@Select({"select * from card where none = 0 ORDER BY enterdate DESC"})
List<Card> findAllUsers();
@Select({"select * from card where none = 0 and company = #{Zong} ORDER BY enterdate DESC"})
- List<Card> findAllUsersZi(String var1);
+ List<Card> findAllUsersZi(@Param("Zong")String var1);
@Select({"SELECT COUNT(*) FROM card where none = 0"})
int findCardNum1();
@@ -48,9 +49,50 @@
@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}"})
+ @Select({"SELECT * FROM card WHERE none = 0 and cardnumber LIKE CONCAT('%', #{number}, '%') and company = #{company} ORDER BY enterdate DESC"})
List<Card> FindSearch(@Param("number") String var1, @Param("company") String var2);
- @Select({"SELECT * FROM card WHERE none = 0 and cardnumber LIKE CONCAT('%', #{number}, '%')"})
+ @Select({"SELECT * FROM card WHERE none = 0 and cardnumber LIKE CONCAT('%', #{number}, '%') ORDER BY enterdate DESC"})
List<Card> FindSearch1(@Param("number") String var1);
+
+ @Update({
+ "<script>",
+ "UPDATE card",
+ "<set>",
+ "<foreach item='item' collection='list' separator=','>",
+ "carddate = #{item.carddate},",
+ "enddate = #{item.enddate},",
+ "unitprice = #{item.unitprice},",
+ "enterdate = #{item.enterdate}",
+// "...", // 鏇村鐨勫瓧娈垫洿鏂拌鍙�
+ "</foreach>",
+ "</set>",
+ "WHERE num IN",
+ "<foreach item='item' collection='list' open='(' separator=',' close=')'>",
+ "#{item.num}",
+ "</foreach>",
+ "</script>"
+ })
+ int updateBatchById(List<Card> list);
+
+ @Update({
+ "<script>",
+ "UPDATE card",
+ "<set>",
+ "<foreach item='item' collection='list' separator=','>",
+ "rechargedate = #{item.rechargedate},",
+ "rechargemoney = #{item.rechargemoney},",
+ "enddate = #{item.enddate},",
+ "remainingdays = #{item.remainingdays},",
+ "enterdate = #{item.rechargedate}",
+// "...", // 鏇村鐨勫瓧娈垫洿鏂拌鍙�
+ "</foreach>",
+ "</set>",
+ "WHERE num IN",
+ "<foreach item='item' collection='list' open='(' separator=',' close=')'>",
+ "#{item.num}",
+ "</foreach>",
+ "</script>"
+ })
+ int updateBatchByIdcz(List<Card> list);
}
--
Gitblit v1.9.3