From 5610ce8f05f45e8da7bffa286c6db5c61ea06a79 Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期四, 16 十月 2025 17:00:12 +0800
Subject: [PATCH] 改为按采集时间查询采集数
---
Services/WomdaaManager.cs | 13 +++++--------
1 files changed, 5 insertions(+), 8 deletions(-)
diff --git a/Services/WomdaaManager.cs b/Services/WomdaaManager.cs
index 66d7430..a492600 100644
--- a/Services/WomdaaManager.cs
+++ b/Services/WomdaaManager.cs
@@ -171,18 +171,15 @@
var sqlQuerySingle = Db.Ado.SqlQuerySingle<string>(sql);
VOrdrerBycl.finalResult = sqlQuerySingle;
- // 鏂板锛氭煡璇㈡渶鏃╀笌鏈�鏂版暟閲囪褰�
+ // 鏂板锛氭煡璇㈡渶鏃╀笌鏈�鏂版暟閲囪褰曪紙鎸夐噰闆嗘椂闂存帓搴忥級
var baseQuery = Db.Queryable<MesNumericalBycl>()
.Where(n => n.OrderId == Convert.ToDecimal(query.OrderId) && n.MachineNo == VOrdrerBycl.MachineNo);
- var startCjNum = baseQuery.OrderBy(n => n.Id)
- .Select(n => n.CjNum).First();
+ var startCjNum = baseQuery.OrderBy(n => n.CjTiem).Select(n => n.CjNum).First();
+ var currentCjNum = baseQuery.OrderBy(n => n.CjTiem, OrderByType.Desc).Select(n => n.CjNum).First();
- var currentCjNum = baseQuery.OrderBy(n => n.Id, OrderByType.Desc)
- .Select(n => n.CjNum).First();
-
- VOrdrerBycl.StartCjNum = startCjNum ;
- VOrdrerBycl.CurrentCjNum = currentCjNum ;
+ VOrdrerBycl.StartCjNum = startCjNum;
+ VOrdrerBycl.CurrentCjNum = currentCjNum;
return VOrdrerBycl;
}
--
Gitblit v1.9.3