| | |
| | | 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(); |
| | |
| | | @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); |
| | | } |