From 6c235963d6fc46b38ea59d9b19c6519b892e080b Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Mon, 16 May 2022 09:42:06 +0800 Subject: [PATCH] 20220516 逻辑删除,更新字段IS_Delete字段为已删除,默认为空,删除后其余信息从查询中过滤了 --- zq-erp/src/main/java/com/matrix/system/hive/dao/SysProjUseDao.java | 4 +++- 1 files changed, 3 insertions(+), 1 deletions(-) diff --git a/zq-erp/src/main/java/com/matrix/system/hive/dao/SysProjUseDao.java b/zq-erp/src/main/java/com/matrix/system/hive/dao/SysProjUseDao.java index cd06925..cd19d3d 100644 --- a/zq-erp/src/main/java/com/matrix/system/hive/dao/SysProjUseDao.java +++ b/zq-erp/src/main/java/com/matrix/system/hive/dao/SysProjUseDao.java @@ -127,11 +127,13 @@ public int updateTcStatus(@Param("id") Long id, @Param("status") String status); - List<SysProjUse> selectHasValidProjUse(); + int updateInvalidProjUse(); List<SysProjUseFlow> selectProjUseFlow(@Param("record") SysProjUseFlow projUseFlow, @Param("pageVo")PaginationVO pageVo); Integer selectProjUseFlowTotal(@Param("record") SysProjUseFlow projUseFlow); List<SysProjUse> selectTaoCanListWithProj(@Param("record") SysProjUse sysProjUse); + + int selectTaocanCountForCourseAndInfinite(@Param("taocanId") Long taocanId, @Param("vipId") Long vipId); } \ No newline at end of file -- Gitblit v1.9.1