From 23518b1198cfb79c5a8f9d7d7921fb888c48a692 Mon Sep 17 00:00:00 2001 From: 移动系统liao <liaoxujun@qq.com> Date: 星期二, 11 二月 2025 11:52:31 +0800 Subject: [PATCH] no message --- CoreCms.Net.Services/CYOAServices/CyinOAService.cs | 10 +++++++--- 1 files changed, 7 insertions(+), 3 deletions(-) diff --git a/CoreCms.Net.Services/CYOAServices/CyinOAService.cs b/CoreCms.Net.Services/CYOAServices/CyinOAService.cs index bff2835..ee027df 100644 --- a/CoreCms.Net.Services/CYOAServices/CyinOAService.cs +++ b/CoreCms.Net.Services/CYOAServices/CyinOAService.cs @@ -1073,11 +1073,15 @@ deliverOrder = SqlFunc.Subqueryable<CoreDeliverOrder>().Where(x => x.OrderId == n.id && x.OrderState != CoreDeliverOrderType.Faile && x.OrderState != CoreDeliverOrderType.Completed - && (x.DeliveryMoble != "" && x.DeliveryMoble != null)).OrderByDesc(x => x.CreateTime).First() + && (x.DeliveryMoble != "" && x.DeliveryMoble != null)).OrderByDesc(x => x.CreateTime).First(), + MakeTime = SqlFunc.Subqueryable<CoreDeliverOrder>().Where(x => x.OrderId == n.id + && x.OrderState != CoreDeliverOrderType.Faile + && x.OrderState != CoreDeliverOrderType.Completed + && (x.DeliveryMoble != "" && x.DeliveryMoble != null)).OrderByDesc(x => x.CreateTime).Select(x=>x.MakeTime) }, true - ).MergeTable().Where(where).ToPageListAsync(entity.page, entity.limit, totalNumbe); + ).MergeTable().Where(where).OrderBy(n=>n.MakeTime).ToPageListAsync(entity.page, entity.limit, totalNumbe); var data = dlist.Select(x => new { @@ -1210,7 +1214,7 @@ } , true - ).MergeTable().Where(where).ToPageListAsync(entity.page, entity.limit, totalNumbe); + ).MergeTable().Where(where).OrderBy(x=>x.MakeTime).ToPageListAsync(entity.page, entity.limit, totalNumbe); var deliveryList = await _CyDbClient.Queryable<OA_Staff>().Where(x => x.Status == "鍦ㄨ亴" && x.BF_IsDriver == true).Select(x => new { -- Gitblit v1.9.1