From 51123c1c38884cb8a16e0060aa28b1988bf7de81 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 19 十二月 2022 14:39:46 +0800
Subject: [PATCH] 安灯呼叫绑定人员加上已删除的人员过滤条件 App班组计件工资(平均)接口开发
---
VueWebApi/DLL/DAL/ProductionManagementDAL.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/VueWebApi/DLL/DAL/ProductionManagementDAL.cs b/VueWebApi/DLL/DAL/ProductionManagementDAL.cs
index 6bf5f23..066e8fe 100644
--- a/VueWebApi/DLL/DAL/ProductionManagementDAL.cs
+++ b/VueWebApi/DLL/DAL/ProductionManagementDAL.cs
@@ -3291,7 +3291,7 @@
A.plan_qty AdvaScheQty,
U.name AdvaScheUom,
isnull(E.sched_qty,0) AdvaScheYPQty,
- CONVERT(varchar(100), B.planenddate, 23) AdvaScheEndDate,
+ CONVERT(varchar(100), B.saleOrderDeliveryDate, 23) AdvaScheEndDate,
convert(varchar(20),isnull(E.sched_qty,0))+'/'+convert(varchar(20),isnull(A.plan_qty,0)) AdvaScheSpeed,
A.route_code AdvaScheRoutid,
F.name AdvaScheRoutName,
--
Gitblit v1.9.3