From f76084c29964fb0bd45c7fd8da2d1837ae995608 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期五, 29 十一月 2024 13:23:40 +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