mybatisplus 自定义sql查询

最新推荐文章于 2024-08-09 21:51:09 发布

千百元

最新推荐文章于 2024-08-09 21:51:09 发布

阅读量4.1k

点赞数

分类专栏： # mybatis-plus

本文链接：https://blog.csdn.net/liuming690452074/article/details/102562996

版权

mybatis-plus 专栏收录该内容

33 篇文章 0 订阅

订阅专栏

public void reconciliationForConfirmOne(Integer Id, Integer payoffType) {
    List<FinanceReconciliationEntity> frList = financeReconciliationService.selectList(
            new EntityWrapper<FinanceReconciliationEntity>()
                    .eq("payoff_id", Id)
                    .eq("payoff_type", payoffType)
                    .where("(reconciliation_status <> 1 OR reconciliation_status IS NULL)")
    );
    for (FinanceReconciliationEntity fr : frList) {
        fr.setReconciliationStatus(1);
    }
    if (frList != null && frList.size() > 0) {
        financeReconciliationService.updateBatchById(frList);
    }
}