From 72fb3e7707c38e113eeab778565e4da209f04a3d Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 15 三月 2024 15:30:33 +0800
Subject: [PATCH] 1.优化生产进度报表查询语句
---
VueWebApi/Controllers/KanBanManagerentController.cs | 209 ++++++++++------------------------------------------
1 files changed, 41 insertions(+), 168 deletions(-)
diff --git a/VueWebApi/Controllers/KanBanManagerentController.cs b/VueWebApi/Controllers/KanBanManagerentController.cs
index 911ec36..9a2117e 100644
--- a/VueWebApi/Controllers/KanBanManagerentController.cs
+++ b/VueWebApi/Controllers/KanBanManagerentController.cs
@@ -18,243 +18,116 @@
ToMessage mes = new ToMessage();
RedisHelper redis = new RedisHelper();
- #region[姝ｆ竻鍜岃溅闂寸湅鏉�,鑾峰彇鐢熶骇杞﹂棿]
+ #region[鍖楅福浠撳簱鐪嬫澘宸︿笂,鐢熶骇寰呭叆搴揮
/// <summary>
- /// 姝ｆ竻鍜岃溅闂寸湅鏉�,鑾峰彇鐢熶骇杞﹂棿
+ /// 鍖楅福浠撳簱鐪嬫澘宸︿笂,鐢熶骇寰呭叆搴�
/// </summary>
/// <returns></returns>
- [Route(template: "ShopSearch")]
+ [Route(template: "ProductionStockedInLeftTop")]
[HttpGet]
- public HttpResponseMessage ShopSearch()
+ public HttpResponseMessage ProductionStockedInLeftTop()
{
- mes = KanBanManagerentBLL.ShopSearch();
+ mes = KanBanManagerentBLL.ProductionStockedInLeftTop();
return TJson.toJson(mes);
}
#endregion
- #region[姝ｆ竻鍜岃溅闂寸湅鏉�,宸︿笂浜х嚎鍔犲伐浠诲姟鎺ュ彛]
+ #region[鍖楅福浠撳簱鐪嬫澘宸︿笅,浜у搧寰呭彂璐
/// <summary>
- /// 姝ｆ竻鍜岃溅闂寸湅鏉�,宸︿笂浜х嚎鍔犲伐浠诲姟鎺ュ彛
+ /// 鍖楅福浠撳簱鐪嬫澘宸︿笅,浜у搧寰呭彂璐�
/// </summary>
- /// <param name="shopcode">杞﹂棿缂栫爜</param>
/// <returns></returns>
- [Route(template: "LineSearchTopLeftData")]
- [HttpPost]
- public HttpResponseMessage LineSearchTopLeftData(string shopcode)
+ [Route(template: "ProductConsignmentLeftBottom")]
+ [HttpGet]
+ public HttpResponseMessage ProductConsignmentLeftBottom()
{
- mes = KanBanManagerentBLL.LineSearchTopLeftData(shopcode);
+ mes = KanBanManagerentBLL.ProductConsignmentLeftBottom();
return TJson.toJson(mes);
}
#endregion
- #region[姝ｆ竻鍜岃溅闂寸湅鏉�,宸︿笅鍒楄〃鎺ュ彛]
+ #region[鍖楅福浠撳簱鐪嬫澘鍙充笂,杩戜竴鍛ㄧ敓浜у緟鍏ュ簱浜у搧鎺掕TOP5]
/// <summary>
- /// 姝ｆ竻鍜岃溅闂寸湅鏉�,宸︿笅鍒楄〃鎺ュ彛
+ /// 鍖楅福浠撳簱鐪嬫澘鍙充笂,杩戜竴鍛ㄧ敓浜у緟鍏ュ簱浜у搧鎺掕TOP5
/// </summary>
- /// <param name="shopcode">杞﹂棿缂栫爜</param>
/// <returns></returns>
- [Route(template: "LineSearchBottomLeftData")]
+ [Route(template: "ProductionStockedInRightTop")]
[HttpGet]
- public HttpResponseMessage LineSearchBottomLeftData(string shopcode)
+ public HttpResponseMessage ProductionStockedInRightTop()
{
- mes = KanBanManagerentBLL.LineSearchBottomLeftData(shopcode);
+ mes = KanBanManagerentBLL.ProductionStockedInRightTop();
return TJson.toJson(mes);
}
#endregion
- #region[姝ｆ竻鍜岃溅闂寸湅鏉�,鍙充笂top鎺掕鎺ュ彛]
+ #region[鍖楅福浠撳簱鐪嬫澘鍙充笅,杩戜竴鍛ㄩ攢鍞緟鍙戣揣浜у搧鎺掕TOP5]
/// <summary>
- /// 姝ｆ竻鍜岃溅闂寸湅鏉�,鍙充笂top鎺掕鎺ュ彛
+ /// 鍖楅福浠撳簱鐪嬫澘鍙充笅,杩戜竴鍛ㄩ攢鍞緟鍙戣揣浜у搧鎺掕TOP5
/// </summary>
- /// <param name="shopcode">杞﹂棿缂栫爜</param>
/// <returns></returns>
- [Route(template: "LineSearchTopRightData")]
+ [Route(template: "ProductionStockedInRightBottom")]
[HttpGet]
- public HttpResponseMessage LineSearchTopRightData(string shopcode)
+ public HttpResponseMessage ProductionStockedInRightBottom()
{
- mes = KanBanManagerentBLL.LineSearchTopRightData(shopcode);
- return TJson.toJson(mes);
- }
- #endregion
-
- #region[姝ｆ竻鍜岃溅闂寸湅鏉�,鍙充笅top鎺掕鎺ュ彛]
- /// <summary>
- /// 姝ｆ竻鍜岃溅闂寸湅鏉�,鍙充笅top鎺掕鎺ュ彛
- /// </summary>
- /// <param name="shopcode">杞﹂棿缂栫爜</param>
- /// <returns></returns>
- [Route(template: "LineSearchBottomRightData")]
- [HttpGet]
- public HttpResponseMessage LineSearchBottomRightData(string shopcode)
- {
- mes = KanBanManagerentBLL.LineSearchBottomRightData(shopcode);
+ mes = KanBanManagerentBLL.ProductionStockedInRightBottom();
return TJson.toJson(mes);
}
#endregion
-
- #region[姝ｆ竻鍜岃溅闂磋川閲忔暟瀛楀寲鐪嬫澘,宸︿笂top5涓嶈壇]
+ #region[鍖楅福閲囪喘濮斿鐪嬫澘宸︿笂,閲囪喘寰呭叆搴揮
/// <summary>
- /// 姝ｆ竻鍜岃溅闂磋川閲忔暟瀛楀寲鐪嬫澘,宸︿笂top5涓嶈壇
+ /// 鍖楅福閲囪喘濮斿鐪嬫澘宸︿笂,閲囪喘寰呭叆搴�
/// </summary>
- /// <param name="wkshopcode">杞﹂棿缂栫爜瀛楃涓查泦</param>
/// <returns></returns>
- [Route(template: "QCBadTop")]
+ [Route(template: "ProcureOutsourcLeftTop")]
[HttpGet]
- public HttpResponseMessage QCBadTop(string wkshopcode)
+ public HttpResponseMessage ProcureOutsourcLeftTop()
{
- mes = KanBanManagerentBLL.QCBadTop(wkshopcode);
+ mes = KanBanManagerentBLL.ProcureOutsourcLeftTop();
return TJson.toJson(mes);
}
#endregion
- #region[姝ｆ竻鍜岃溅闂磋川閲忔暟瀛楀寲鐪嬫澘,宸︿腑鍛ㄤ笉鑹秼鍔縘
+ #region[鍖楅福閲囪喘濮斿鐪嬫澘宸︿笅,濮斿寰呭叆搴揮
/// <summary>
- /// 姝ｆ竻鍜岃溅闂磋川閲忔暟瀛楀寲鐪嬫澘,宸︿腑鍛ㄤ笉鑹秼鍔�
+ /// 鍖楅福閲囪喘濮斿鐪嬫澘宸︿笂,濮斿寰呭叆搴�
/// </summary>
- /// <param name="wkshopcode">杞﹂棿缂栫爜瀛楃涓查泦</param>
/// <returns></returns>
- [Route(template: "QCBadCenterLeftWeek")]
+ [Route(template: "ProcureOutsourcLeftBottom")]
[HttpGet]
- public HttpResponseMessage QCBadCenterLeftWeek(string wkshopcode)
+ public HttpResponseMessage ProcureOutsourcLeftBottom()
{
- mes = KanBanManagerentBLL.QCBadCenterLeftWeek(wkshopcode);
+ mes = KanBanManagerentBLL.ProcureOutsourcLeftBottom();
return TJson.toJson(mes);
}
#endregion
- #region[姝ｆ竻鍜岃溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鍙充腑鍛ㄥ畬鎴愭暟/鐜嘳
+ #region[鍖楅福閲囪喘濮斿鐪嬫澘鍙充笂,杩戜竴鍛ㄩ噰璐緟鍏ュ簱鐗╂枡鎺掕TOP5]
/// <summary>
- /// 姝ｆ竻鍜岃溅闂磋川閲忔暟瀛楀寲鐪嬫澘,鍙充腑鍛ㄥ畬鎴愭暟/鐜�
+ /// 鍖楅福閲囪喘濮斿鐪嬫澘鍙充笂,杩戜竴鍛ㄩ噰璐緟鍏ュ簱鐗╂枡鎺掕TOP5
/// </summary>
- /// <param name="wkshopcode">杞﹂棿缂栫爜瀛楃涓查泦</param>
/// <returns></returns>
- [Route(template: "QCBadCenterRightWeek")]
+ [Route(template: "ProcureOutsourcRightTop")]
[HttpGet]
- public HttpResponseMessage QCBadCenterRightWeek(string wkshopcode)
+ public HttpResponseMessage ProcureOutsourcRightTop()
{
- mes = KanBanManagerentBLL.QCBadCenterRightWeek(wkshopcode);
+ mes = KanBanManagerentBLL.ProcureOutsourcRightTop();
return TJson.toJson(mes);
}
#endregion
- #region[姝ｆ竻鍜岃溅闂磋川閲忔暟瀛楀寲鐪嬫澘,涓嬩换鍔¤繘搴
+ #region[鍖楅福閲囪喘濮斿鐪嬫澘鍙充笅,杩戜竴鍛ㄥ澶栧緟鍏ュ簱浜у搧鎺掕TOP5]
/// <summary>
- /// 姝ｆ竻鍜岃溅闂磋川閲忔暟瀛楀寲鐪嬫澘,涓嬩换鍔¤繘搴�
- /// </summary>
- /// <param name="wkshopcode">杞﹂棿缂栫爜瀛楃涓查泦</param>
- /// <returns></returns>
- [Route(template: "QCBadBottomWeek")]
- [HttpGet]
- public HttpResponseMessage QCBadBottomWeek(string wkshopcode)
- {
- mes = KanBanManagerentBLL.QCBadBottomWeek(wkshopcode);
- return TJson.toJson(mes);
- }
- #endregion
-
-
-
-
- #region[姝ｆ竻鍜屼粨搴撶湅鏉�,宸︿笂浜у搧寰呭叆搴撳垪琛╙
- /// <summary>
- /// 姝ｆ竻鍜屼粨搴撶湅鏉�,宸︿笂浜у搧寰呭叆搴撳垪琛�
+ /// 鍖楅福閲囪喘濮斿鐪嬫澘鍙充笅,杩戜竴鍛ㄥ澶栧緟鍏ュ簱浜у搧鎺掕TOP5
/// </summary>
/// <returns></returns>
- [Route(template: "WareHouseTopLeftData")]
+ [Route(template: "ProcureOutsourcRightBottom")]
[HttpGet]
- public HttpResponseMessage WareHouseTopLeftData()
+ public HttpResponseMessage ProcureOutsourcRightBottom()
{
- mes = KanBanManagerentBLL.WareHouseTopLeftData();
- return TJson.toJson(mes);
- }
- #endregion
-
- #region[姝ｆ竻鍜屼粨搴撶湅鏉�,宸︿笅浜у搧寰呭彂璐у垪琛╙
- /// <summary>
- /// 姝ｆ竻鍜屼粨搴撶湅鏉�,宸︿笅浜у搧寰呭彂璐у垪琛�
- /// </summary>
- /// <returns></returns>
- [Route(template: "WareHouseTopBottomData")]
- [HttpGet]
- public HttpResponseMessage WareHouseTopBottomData()
- {
- mes = KanBanManagerentBLL.WareHouseTopBottomData();
- return TJson.toJson(mes);
- }
- #endregion
-
- #region[姝ｆ竻鍜屼粨搴撶湅鏉�,鍙充笂鎴愬搧搴撱�佸崐鎴愬搧搴搕op5搴撳瓨鎺掕]
- /// <summary>
- /// 姝ｆ竻鍜屼粨搴撶湅鏉�,鍙充笂鎴愬搧搴撱�佸崐鎴愬搧搴搕op5搴撳瓨鎺掕
- /// </summary>
- /// <returns></returns>
- [Route(template: "WareHouseRightTopData")]
- [HttpGet]
- public HttpResponseMessage WareHouseRightTopData()
- {
- mes = KanBanManagerentBLL.WareHouseRightTopData();
- return TJson.toJson(mes);
- }
- #endregion
-
- #region[姝ｆ竻鍜屼粨搴撶湅鏉�,鍙充笅鍘熸枡搴撳簱top5搴撳瓨鎺掕]
- /// <summary>
- /// 姝ｆ竻鍜屼粨搴撶湅鏉�,鍙充笅鍘熸枡搴撳簱top5搴撳瓨鎺掕
- /// </summary>
- /// <returns></returns>
- [Route(template: "WareHouseRightBottomData")]
- [HttpGet]
- public HttpResponseMessage WareHouseRightBottomData()
- {
- mes = KanBanManagerentBLL.WareHouseRightBottomData();
- return TJson.toJson(mes);
- }
- #endregion
-
-
-
- #region[姝ｆ竻鍜岃溅闂寸患鍚堢湅鏉�,宸︿笂鐢熶骇璁㈠崟]
- /// <summary>
- /// 姝ｆ竻鍜岃溅闂寸患鍚堢湅鏉�,宸︿笂鐢熶骇璁㈠崟
- /// </summary>
- /// <param name="wkshopcode">杞﹂棿缂栫爜瀛楃涓查泦</param>
- /// <returns></returns>
- [Route(template: "WorkShopCompreLeftTop")]
- [HttpGet]
- public HttpResponseMessage WorkShopCompreLeftTop(string wkshopcode)
- {
- mes = KanBanManagerentBLL.WorkShopCompreLeftTop(wkshopcode);
- return TJson.toJson(mes);
- }
- #endregion
-
- #region[姝ｆ竻鍜岃溅闂寸患鍚堢湅鏉�,鍙充笂閿�鍞鍗昡
- /// <summary>
- /// 姝ｆ竻鍜岃溅闂寸患鍚堢湅鏉�,鍙充笂閿�鍞鍗�
- /// </summary>
- /// <returns></returns>
- [Route(template: "WorkShopCompreRightTop")]
- [HttpGet]
- public HttpResponseMessage WorkShopCompreRightTop()
- {
- mes = KanBanManagerentBLL.WorkShopCompreRightTop();
- return TJson.toJson(mes);
- }
- #endregion
-
- #region[姝ｆ竻鍜岃溅闂寸患鍚堢湅鏉�,鍙充笅搴撳瓨]
- /// <summary>
- /// 姝ｆ竻鍜岃溅闂寸患鍚堢湅鏉�,鍙充笅搴撳瓨
- /// </summary>
- /// <returns></returns>
- [Route(template: "WorkShopCompreRightBottom")]
- [HttpGet]
- public HttpResponseMessage WorkShopCompreRightBottom()
- {
- mes = KanBanManagerentBLL.WorkShopCompreRightBottom();
+ mes = KanBanManagerentBLL.ProcureOutsourcRightBottom();
return TJson.toJson(mes);
}
#endregion
--
Gitblit v1.9.3