package com.dayu.general.dao
|
|
import androidx.room.*
|
import com.dayu.general.bean.db.CardRegistrationBean
|
|
@Dao
|
interface CardRegistrationDao {
|
@Insert
|
suspend fun insert(cardRegistration: CardRegistrationBean): Long
|
|
@Update
|
suspend fun update(cardRegistration: CardRegistrationBean)
|
|
@Delete
|
suspend fun delete(cardRegistration: CardRegistrationBean)
|
|
@Query("SELECT * FROM card_registration WHERE cardNumber = :cardNumber")
|
suspend fun getByCardNumber(cardNumber: String): CardRegistrationBean?
|
|
@Query("SELECT * FROM card_registration WHERE orderId = :orderId")
|
suspend fun getByOrderId(orderId: String): CardRegistrationBean?
|
|
@Query("SELECT * FROM card_registration WHERE isReported = 0")
|
suspend fun getUnreportedCards(): List<CardRegistrationBean>
|
|
@Query("SELECT * FROM card_registration WHERE isCardWritten = 0")
|
suspend fun getUnwrittenCards(): List<CardRegistrationBean>
|
|
@Query("SELECT * FROM card_registration ORDER BY createTime DESC")
|
suspend fun getAllCards(): List<CardRegistrationBean>
|
}
|
