From dda51148e5fd88c946e3a91afc0c684f2427f4ae Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期四, 20 六月 2024 12:00:28 +0800
Subject: [PATCH] RouteToProd
---
Tiger.Api/Controllers/MES/MESController.Route.cs | 32 ++++++++++++++++++++++++++++++++
1 files changed, 32 insertions(+), 0 deletions(-)
diff --git a/Tiger.Api/Controllers/MES/MESController.Route.cs b/Tiger.Api/Controllers/MES/MESController.Route.cs
index 383aa66..91275f6 100644
--- a/Tiger.Api/Controllers/MES/MESController.Route.cs
+++ b/Tiger.Api/Controllers/MES/MESController.Route.cs
@@ -1,7 +1,10 @@
锘縰sing Microsoft.AspNetCore.Mvc;
using Rhea.Common;
+using SqlSugar;
using System.Collections.Generic;
using System.Threading.Tasks;
+using System.Xml.Linq;
+using Tiger.Api.iBiz;
using Tiger.IBusiness;
using Tiger.Model;
@@ -134,5 +137,34 @@
}
return Ok(response);
}
+
+ /// <summary>
+ /// 鑾峰彇宸ヨ壓璺嚎鏍戝舰缁撴瀯
+ /// </summary>
+ /// <param name="param"></param>
+ /// <returns></returns>
+ [HttpGet]
+ [Route("api/[controller]/[action]")]
+ public async Task<IActionResult> GetRoutePTreeAsync(string param) {
+ var data = Biz.Db.Ado.UseStoredProcedure().SqlQuery<V_MES_ROUTE_PTREE>("SP_MES_GET_ROUTE_PTREE", new SugarParameter("@PROD_CODE", param));//杩斿洖List
+ return Ok(data);
+ }
+
+ [HttpGet]
+ [Route("api/[controller]/[action]")]
+ public async Task<IActionResult> RouteToProd(string rotId, string prodCode)
+ {
+ ApiAction response = new();
+ try
+ {
+ SugarParameter[] pars = Biz.Db.Ado.GetParameters(new { ROT_ID = rotId, PROD_CODE = prodCode });
+ Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("SP_MES_ROUTE2PROD", pars); ;
+ }
+ catch (System.Exception ex)
+ {
+ response = response.GetResponse().CatchExceptionWithLog(ex);
+ }
+ return Ok(response);
+ }
}
}
--
Gitblit v1.9.3