From f2d9adf4e26b1173a51387ad203a33cf617454a0 Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期三, 25 九月 2024 18:39:34 +0800
Subject: [PATCH] 获取工单批次的数量汇总

---
 Tiger.Controllers.MES/MESController.BIZ_MES_WO.cs |   29 +++++++++++++++++++++++++++++
 1 files changed, 29 insertions(+), 0 deletions(-)

diff --git a/Tiger.Controllers.MES/MESController.BIZ_MES_WO.cs b/Tiger.Controllers.MES/MESController.BIZ_MES_WO.cs
index 3b4ac77..80e135c 100644
--- a/Tiger.Controllers.MES/MESController.BIZ_MES_WO.cs
+++ b/Tiger.Controllers.MES/MESController.BIZ_MES_WO.cs
@@ -1,10 +1,12 @@
 锘縰sing Microsoft.AspNetCore.Mvc;
 using Rhea.Common;
+using SqlSugar;
 using System.Threading.Tasks;
 using Tiger.IBusiness;
 using Tiger.Model;
 using Tiger.Model.Entitys.MES.BizMesWo;
 using Tiger.Model.Entitys.MES.BizMesWoBatch;
+using Tiger.Api.iBiz;
 
 namespace Tiger.Api.Controllers.MES
 {
@@ -157,5 +159,32 @@
             }
             return Ok(response);
         }
+
+        /// <summary>
+        /// 鑾峰彇宸ュ崟鎵规鐨勬暟閲忔眹鎬�
+        /// </summary>
+        /// <param name="batch"></param>
+        /// <returns></returns>
+        [HttpGet]
+        [Route("api/[controller]/[action]")]
+        public async Task<IActionResult> GetWoBatchCount(ApiAction action)
+        {
+            ApiAction response = new();
+            try
+            {
+                SugarParameter[] pars = Biz.Db.Ado.GetParameters(new { BATCH = action.Data?.ToString(), ERR_CODE = 0, ERR_MSG = "" });
+                pars[1].Direction = System.Data.ParameterDirection.Output;
+                pars[2].Direction = System.Data.ParameterDirection.Output;
+                Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("SP_MES_GET_WO_BATCH_COUNT", pars);
+                response.Data = pars[1].Value;
+                response.IsSuccessed = pars[1].Value.ToInt32() == 0 ? true : false;
+                response.LocaleMsg = new(pars[2].Value.ToString());
+            }
+            catch (System.Exception ex)
+            {
+                response = response.GetResponse().CatchExceptionWithLog(ex);
+            }
+            return Ok(response);
+        }
     }
 }

--
Gitblit v1.9.3