From 32a10c272b7cd543a7172a6ebc222e6f8c8b0334 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期四, 20 二月 2025 15:24:23 +0800 Subject: [PATCH] 森楷自动包装线同步金蝶入库申请单,如果没有审核,则在扫物料条码时自动审核;排产匹配产品器具清单,产线器具清单,器具占用时间存入数据库 --- WebAPI/Controllers/GG_NoticeController.cs | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/GG_NoticeController.cs b/WebAPI/Controllers/GG_NoticeController.cs index 0753af0..35c2687 100644 --- a/WebAPI/Controllers/GG_NoticeController.cs +++ b/WebAPI/Controllers/GG_NoticeController.cs @@ -318,8 +318,9 @@ try { List<object> columnNameList = new List<object>(); - var sql = "select top(10) m.HMakeDate as 鏃ユ湡, m.HLevel as 绱ф�ョ▼搴�, m.HContext as 涓婚 " + - " , m.HSendMan as 鍙戦�佷汉, s.HReceiveMan as 鎺ユ敹浜�, d.HName as 鍙戦�侀儴闂� " + + var sql = "select top(10) m.HMakeDate as 鏃ユ湡, m.HLevel as 鐘跺喌, m.HContext as 涓婚 " + + ", m.HContext as 鍐呭" + + ", m.HSendMan as 鍙戦�佷汉, s.HReceiveMan as 鎺ユ敹浜�, d.HName as 鍙戦�侀儴闂� " + " from OA_InformBillMain as m" + " inner join OA_InformBillSub as s on m.HInterID = s.HInterID" + " left join Gy_Department d on m.HDeptID = d.HItemID" + -- Gitblit v1.9.1