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