From 82dac540156cb29e58c86f7d7d840e3c7e548c15 Mon Sep 17 00:00:00 2001
From: xwt <2740516069@qq.com>
Date: 星期四, 14 八月 2025 19:55:41 +0800
Subject: [PATCH] 来料检,入库检,首检巡检。

---
 StandardInterface/MES.Service/service/QC/LljService.cs |   12 ++++++++++++
 1 files changed, 12 insertions(+), 0 deletions(-)

diff --git a/StandardInterface/MES.Service/service/QC/LljService.cs b/StandardInterface/MES.Service/service/QC/LljService.cs
index 341a0a4..78ba1fb 100644
--- a/StandardInterface/MES.Service/service/QC/LljService.cs
+++ b/StandardInterface/MES.Service/service/QC/LljService.cs
@@ -70,6 +70,18 @@
             .OrderBy("CASE WHEN a.EMERGENCY = 1 THEN 0 ELSE 1 END, CASE WHEN a.STATUS = '宸叉彁浜�' THEN 0 ELSE 1 END, a.IQC_DATE desc, a.ID asc")
             .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount);
 
+        // 涓烘瘡涓楠屽崟娣诲姞妫�楠岄」鐩暟閲忎俊鎭�
+        foreach (var item in pageList)
+        {
+            // 鑾峰彇璇ユ楠屽崟鐨勬楠岄」鐩暟閲�
+            var itemCount = db.Queryable<MesQaItemsDetectDetail5>()
+                .Where(x => x.ReleaseNo == item.ReleaseNo)
+                .Count();
+            
+            // 璁剧疆妫�楠岄」鐩暟閲�
+            item.InspectionItemCount = itemCount;
+        }
+        
         var emergencyValues = pageList.Select(item => item.EMERGENCY).ToList(); 
         return (pageList, totalCount);
     }

--
Gitblit v1.9.3