From 3d38eee51b81e372418b891fe9282fbcd01c9df8 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期六, 10 九月 2022 00:06:33 +0800
Subject: [PATCH] nothing
---
VueWebApi/DLL/DAL/KanBanManagerentDAL.cs | 32 ++++++++++++++++++++++++++++++--
1 files changed, 30 insertions(+), 2 deletions(-)
diff --git a/VueWebApi/DLL/DAL/KanBanManagerentDAL.cs b/VueWebApi/DLL/DAL/KanBanManagerentDAL.cs
index aa496a9..3e09e6f 100644
--- a/VueWebApi/DLL/DAL/KanBanManagerentDAL.cs
+++ b/VueWebApi/DLL/DAL/KanBanManagerentDAL.cs
@@ -233,7 +233,6 @@
inner join TK_Wrk_Man M on A.wo_code=M.wo_code
where DateDiff(dd,A.lm_date,getdate())<=7 and M.wkshp_code in @shopcode
group by B.name order by cont desc";
- dynamicParams.Add("@shopcode", shopcode);
var data = DapperHelper.selectlist(sql, new { shopcode = selects.ToArray() });
mes.code = "200";
mes.Message = "鏌ヨ鎴愬姛!";
@@ -418,5 +417,34 @@
return mes;
}
#endregion
+
+
+ #region[杞﹂棿鐪嬫澘鍏憡]
+ public static ToMessage WkspReportNotice(string shopcode)
+ {
+ string sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ string[] selects = Array.ConvertAll<string, string>(shopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
+ //鑾峰彇杞﹂棿鍏憡淇℃伅
+ sql = @"select contents from TSystemAnnouncement
+ where wksp_code in @shopcode";
+ var data = DapperHelper.selectlist(sql, new { shopcode = selects.ToArray() });
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
}
-}
\ No newline at end of file
+}
+
--
Gitblit v1.9.3