From 65cb66d1fd548540745bd2552f4668ac88549a4c Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期三, 26 六月 2024 17:07:57 +0800
Subject: [PATCH] 仓库看板接口开发
---
VueWebCoreApi/Controllers/KanBanManagerentController.cs | 58 ++++++++++++++
VueWebCoreApi/DLL/BLL/KanBanManagerentBLL.cs | 29 +++++++
VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs | 95 +++++++++++++++++++++++
3 files changed, 182 insertions(+), 0 deletions(-)
diff --git a/VueWebCoreApi/Controllers/KanBanManagerentController.cs b/VueWebCoreApi/Controllers/KanBanManagerentController.cs
index 942d390..89283b7 100644
--- a/VueWebCoreApi/Controllers/KanBanManagerentController.cs
+++ b/VueWebCoreApi/Controllers/KanBanManagerentController.cs
@@ -105,5 +105,63 @@
return Json(mes);
}
#endregion
+
+
+
+ #region[浠撳簱鐪嬫澘,宸︿笂浜у搧寰呭叆搴撳垪琛╙
+ /// <summary>
+ /// 浠撳簱鐪嬫澘,宸︿笂浜у搧寰呭叆搴撳垪琛�
+ /// </summary>
+ /// <returns></returns>
+ [Route(template: "WareHouseTopLeftData")]
+ [HttpGet]
+ public JsonResult WareHouseTopLeftData()
+ {
+ mes = KanBanManagerentBLL.WareHouseTopLeftData();
+ return Json(mes);
+ }
+ #endregion
+
+ #region[浠撳簱鐪嬫澘,宸︿笅濮斿寰呭叆搴撳垪琛╙
+ /// <summary>
+ /// 浠撳簱鐪嬫澘,宸︿笅濮斿寰呭叆搴撳垪琛�
+ /// </summary>
+ /// <returns></returns>
+ [Route(template: "WareHouseTopBottomData")]
+ [HttpGet]
+ public JsonResult WareHouseTopBottomData()
+ {
+ mes = KanBanManagerentBLL.WareHouseTopBottomData();
+ return Json(mes);
+ }
+ #endregion
+
+ #region[浠撳簱鐪嬫澘,鍙充笂鎴愬搧搴撱�佸崐鎴愬搧搴搕op5搴撳瓨鎺掕]
+ /// <summary>
+ /// 浠撳簱鐪嬫澘,鍙充笂鎴愬搧搴撱�佸崐鎴愬搧搴搕op5搴撳瓨鎺掕
+ /// </summary>
+ /// <returns></returns>
+ [Route(template: "WareHouseRightTopData")]
+ [HttpGet]
+ public JsonResult WareHouseRightTopData()
+ {
+ mes = KanBanManagerentBLL.WareHouseRightTopData();
+ return Json(mes);
+ }
+ #endregion
+
+ #region[浠撳簱鐪嬫澘,鍙充笅鍘熸枡搴撳簱top5搴撳瓨鎺掕]
+ /// <summary>
+ /// 浠撳簱鐪嬫澘,鍙充笅鍘熸枡搴撳簱top5搴撳瓨鎺掕
+ /// </summary>
+ /// <returns></returns>
+ [Route(template: "WareHouseRightBottomData")]
+ [HttpGet]
+ public JsonResult WareHouseRightBottomData()
+ {
+ mes = KanBanManagerentBLL.WareHouseRightBottomData();
+ return Json(mes);
+ }
+ #endregion
}
}
diff --git a/VueWebCoreApi/DLL/BLL/KanBanManagerentBLL.cs b/VueWebCoreApi/DLL/BLL/KanBanManagerentBLL.cs
index a6f15e4..313bdbd 100644
--- a/VueWebCoreApi/DLL/BLL/KanBanManagerentBLL.cs
+++ b/VueWebCoreApi/DLL/BLL/KanBanManagerentBLL.cs
@@ -51,5 +51,34 @@
return KanBanManagerentDAL.WorkShopCompreRightBottom();
}
#endregion
+
+
+ #region[浠撳簱鐪嬫澘,宸︿笂浜у搧寰呭叆搴撳垪琛╙
+ public static ToMessage WareHouseTopLeftData()
+ {
+ return KanBanManagerentDAL.WareHouseTopLeftData();
+ }
+ #endregion
+
+ #region[浠撳簱鐪嬫澘,宸︿笅濮斿寰呭叆搴撳垪琛╙
+ public static ToMessage WareHouseTopBottomData()
+ {
+ return KanBanManagerentDAL.WareHouseTopBottomData();
+ }
+ #endregion
+
+ #region[浠撳簱鐪嬫澘,鍙充笂鎴愬搧搴撱�佸崐鎴愬搧搴搕op5搴撳瓨鎺掕]
+ public static ToMessage WareHouseRightTopData()
+ {
+ return KanBanManagerentDAL.WareHouseRightTopData();
+ }
+ #endregion
+
+ #region[浠撳簱鐪嬫澘,鍙充笅鍘熸枡搴撳簱top5搴撳瓨鎺掕]
+ public static ToMessage WareHouseRightBottomData()
+ {
+ return KanBanManagerentDAL.WareHouseRightBottomData();
+ }
+ #endregion
}
}
diff --git a/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs b/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
index 9765700..4b767be 100644
--- a/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs
@@ -208,5 +208,100 @@
return mes;
}
#endregion
+
+
+ #region[浠撳簱鐪嬫澘,宸︿笂浜у搧寰呭叆搴撳垪琛╙
+ public static ToMessage WareHouseTopLeftData()
+ {
+ string sql = "";
+ try
+ {
+ //鑾峰彇浠撳簱鐢熶骇鍔犲伐鍗曞緟鍏ュ簱鍒楄〃
+ sql = @"select * from h_v_JLKanBan_WareHouseTopLeft order by voucherdate";
+ var data = DapperHelper.selecttable(sql);
+ 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
+
+ #region[浠撳簱鐪嬫澘,宸︿笅濮斿寰呭叆搴撳垪琛╙
+ public static ToMessage WareHouseTopBottomData()
+ {
+ string sql = "";
+ try
+ {
+ //鑾峰彇浠撳簱鐢熶骇鍔犲伐鍗曞緟鍏ュ簱鍒楄〃
+ sql = @"select * from h_v_JLKanBan_WareHouseTopBottom order by voucherdate";
+ var data = DapperHelper.selecttable(sql);
+ 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
+
+ #region[浠撳簱鐪嬫澘,鍙充笂鎴愬搧搴撱�佸崐鎴愬搧搴搕op5搴撳瓨鎺掕]
+ public static ToMessage WareHouseRightTopData()
+ {
+ string sql = "";
+ try
+ {
+ sql = @"select * from h_v_JLKanBan_WareHouseRightTop";
+ var data = DapperHelper.selecttable(sql);
+ 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
+
+ #region[浠撳簱鐪嬫澘,鍙充笅鍘熸枡搴撳簱top5搴撳瓨鎺掕]
+ public static ToMessage WareHouseRightBottomData()
+ {
+ string sql = "";
+ try
+ {
+ sql = @"select * from h_v_JLKanBan_WareHouseRightBottom";
+ var data = DapperHelper.selecttable(sql);
+ 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
}
}
--
Gitblit v1.9.3