sqlserver jpa 多条件查询

/**
 * 查詢 list
 *
 * @param gameCode
 * @param currency
 * @param gameRoom
 */
@Query(value = "select * from dbo.robot_offline with(nolock) WHERE ((currency = :cu AND :cu <> '') OR (:cu = '' AND 1 = 1))\r\n" +
        " AND ((game_code = :gc AND :gc <> '') OR (:gc = '' AND 1 = 1)) AND ((game_room = :gr AND :gr <> '') OR (:gr = '' AND 1 = 1))"
        + " order by [game_code] desc ", nativeQuery = true)
List<RobotOffline> findList(@Param(value = "gc") String gameCode, @Param(value = "cu") String currency, @Param(value = "gr") String gameRoom);