From 13888b5aa85a9f3634442509704d35e28a343e1f Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期四, 16 十月 2025 17:39:17 +0800
Subject: [PATCH] 精确时间排序
---
Services/WomdaaManager.cs | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/Services/WomdaaManager.cs b/Services/WomdaaManager.cs
index a492600..eb3522b 100644
--- a/Services/WomdaaManager.cs
+++ b/Services/WomdaaManager.cs
@@ -175,8 +175,9 @@
var baseQuery = Db.Queryable<MesNumericalBycl>()
.Where(n => n.OrderId == Convert.ToDecimal(query.OrderId) && n.MachineNo == VOrdrerBycl.MachineNo);
- 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();
+ // 淇鍚庝唬鐮侊紙绮剧‘鏃堕棿鎺掑簭锛孫racle鏁版嵁搴撲笅瀛楃涓茶浆鏃堕棿锛�
+ var startCjNum = baseQuery.OrderBy(n => SqlFunc.Oracle_ToDate(n.CjTiem, "yyyy-MM-dd HH24:mi:ss")).Select(n => n.CjNum).First();
+ var currentCjNum = baseQuery.OrderBy(n => SqlFunc.Oracle_ToDate(n.CjTiem, "yyyy-MM-dd HH24:mi:ss"), OrderByType.Desc).Select(n => n.CjNum).First();
VOrdrerBycl.StartCjNum = startCjNum;
VOrdrerBycl.CurrentCjNum = currentCjNum;
--
Gitblit v1.9.3