From 4820d874c4b163b1fc62ce3e17f85372232f81ff Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期一, 22 七月 2024 18:37:56 +0800
Subject: [PATCH] 添加客户工单工艺路线
---
Tiger.Api/Controllers/MES/MESController.Route.cs | 29 ++++++++++++++++++++++++++++-
1 files changed, 28 insertions(+), 1 deletions(-)
diff --git a/Tiger.Api/Controllers/MES/MESController.Route.cs b/Tiger.Api/Controllers/MES/MESController.Route.cs
index 63c004f..1b0f289 100644
--- a/Tiger.Api/Controllers/MES/MESController.Route.cs
+++ b/Tiger.Api/Controllers/MES/MESController.Route.cs
@@ -157,7 +157,7 @@
public async Task<IActionResult> GetWoPTreeAsync(string wo)
{
SugarParameter[] pars = Biz.Db.Ado.GetParameters(new { WO = wo });
- var data = Biz.Db.Ado.UseStoredProcedure().SqlQuery<V_MES_ROUTE_PTREE>("SP_MES_GET_WO_PTREE", pars);//杩斿洖List
+ var data = Biz.Db.Ado.UseStoredProcedure().SqlQuery<V_MES_WO_PTREE>("SP_MES_GET_WO_PTREE", pars);//杩斿洖List
return Ok(data);
}
@@ -245,5 +245,32 @@
}
return Ok(response);
}
+
+ /// <summary>
+ /// 娣诲姞宸ュ崟鐨勫鎴风殑宸ヨ壓璺嚎
+ /// </summary>
+ /// <param name="wo"></param>
+ /// <returns></returns>
+ [HttpGet]
+ [Route("api/[controller]/[action]")]
+ public async Task<IActionResult> SP_MES_WO2CUST(string wo)
+ {
+ ApiAction response = new();
+ try
+ {
+ SugarParameter[] pars = Biz.Db.Ado.GetParameters(new { WO = wo, 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_WO2CUST", 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