From d35dd49decd2207b80b8c9410427d4ff25d3e3d0 Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期六, 11 二月 2023 13:12:46 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/asrs/service/impl/WrkMastServiceImpl.java |    6 ++++++
 1 files changed, 6 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/zy/asrs/service/impl/WrkMastServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/WrkMastServiceImpl.java
index 85ef4d2..ab394ec 100644
--- a/src/main/java/com/zy/asrs/service/impl/WrkMastServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/WrkMastServiceImpl.java
@@ -39,4 +39,10 @@
         return wrkMasts.get(0);
     }
 
+    @Override
+    public int getStoreCount(Integer crnNo) {
+        return selectCount(new EntityWrapper<WrkMast>().eq("crn_no", crnNo)
+                .last(" and (wrk_sts in (1,2) or (wrk_sts=3 and wrk_no in (select wrk_no from asr_bas_devp)))"));
+    }
+
 }

--
Gitblit v1.9.1