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