From 7d1ef31efa71b7514e1d912de43ff2096880ef92 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 26 九月 2024 13:16:19 +0800
Subject: [PATCH] 桥下车间综合看板增加采购订单
---
VueWebCoreApi/Controllers/KanBanManagerentController.cs | 14 ++++++++++++++
VueWebCoreApi/DLL/BLL/KanBanManagerentBLL.cs | 7 +++++++
VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs | 28 ++++++++++++++++++++++++++++
3 files changed, 49 insertions(+), 0 deletions(-)
diff --git a/VueWebCoreApi/Controllers/KanBanManagerentController.cs b/VueWebCoreApi/Controllers/KanBanManagerentController.cs
index 89283b7..559b002 100644
--- a/VueWebCoreApi/Controllers/KanBanManagerentController.cs
+++ b/VueWebCoreApi/Controllers/KanBanManagerentController.cs
@@ -92,6 +92,20 @@
}
#endregion
+ #region[杞﹂棿缁煎悎鐪嬫澘,宸︿笅閲囪喘璁㈠崟]
+ /// <summary>
+ /// 杞﹂棿缁煎悎鐪嬫澘,宸︿笅閲囪喘璁㈠崟
+ /// </summary>
+ /// <returns></returns>
+ [Route(template: "WorkShopCompreLeftBottom")]
+ [HttpGet]
+ public JsonResult WorkShopCompreLeftBottom()
+ {
+ mes = KanBanManagerentBLL.WorkShopCompreLeftBottom();
+ return Json(mes);
+ }
+ #endregion
+
#region[杞﹂棿缁煎悎鐪嬫澘,鍙充笅搴撳瓨]
/// <summary>
/// 杞﹂棿缁煎悎鐪嬫澘,鍙充笅搴撳瓨
diff --git a/VueWebCoreApi/DLL/BLL/KanBanManagerentBLL.cs b/VueWebCoreApi/DLL/BLL/KanBanManagerentBLL.cs
index 313bdbd..37971d7 100644
--- a/VueWebCoreApi/DLL/BLL/KanBanManagerentBLL.cs
+++ b/VueWebCoreApi/DLL/BLL/KanBanManagerentBLL.cs
@@ -45,6 +45,13 @@
}
#endregion
+ #region[杞﹂棿缁煎悎鐪嬫澘,宸︿笅閲囪喘璁㈠崟]
+ public static ToMessage WorkShopCompreLeftBottom()
+ {
+ return KanBanManagerentDAL.WorkShopCompreLeftBottom();
+ }
+ #endregion
+
#region[杞﹂棿缁煎悎鐪嬫澘,鍙充笅搴撳瓨]
public static ToMessage WorkShopCompreRightBottom()
{
diff --git a/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs b/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
index 4b767be..6546719 100644
--- a/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
@@ -182,6 +182,34 @@
}
#endregion
+ #region[杞﹂棿缁煎悎鐪嬫澘,宸︿笅閲囪喘璁㈠崟]
+ public static ToMessage WorkShopCompreLeftBottom()
+ {
+ var sql = "";
+ Dictionary<object, object> dir = new Dictionary<object, object>();
+ try
+ {
+ sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftBottom_Top";
+ var data = DapperHelper.selecttable(sql);
+ sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftBottom_Bottom";
+ var data1 = DapperHelper.selecttable(sql);
+ dir.Add("BottomLeftTop", data);
+ dir.Add("BottomLeftBottom", data1);
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = dir;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
#region[杞﹂棿缁煎悎鐪嬫澘,鍙充笅搴撳瓨]
public static ToMessage WorkShopCompreRightBottom()
{
--
Gitblit v1.9.3