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