From 6ce619b328af4ec209a8a15ef5ba3416fd956c14 Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期日, 21 七月 2024 19:51:14 +0800
Subject: [PATCH] 产品信息增加权限查询
---
Tiger.Model.Net/Entitys/MES/V_BAS_PROD.cs | 4 ++--
Tiger.Api/Controllers/MES/MESController.Route.cs | 35 ++++++++++++++++++++++++++++++++---
2 files changed, 34 insertions(+), 5 deletions(-)
diff --git a/Tiger.Api/Controllers/MES/MESController.Route.cs b/Tiger.Api/Controllers/MES/MESController.Route.cs
index 0207069..1ebd915 100644
--- a/Tiger.Api/Controllers/MES/MESController.Route.cs
+++ b/Tiger.Api/Controllers/MES/MESController.Route.cs
@@ -141,12 +141,14 @@
/// <summary>
/// 鑾峰彇宸ヨ壓璺嚎鏍戝舰缁撴瀯
/// </summary>
- /// <param name="param"></param>
+ /// <param name="prodCode"></param>
+ /// <param name="orgCode"></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
+ public async Task<IActionResult> GetRoutePTreeAsync(string prodCode, string orgCode) {
+ SugarParameter[] pars = Biz.Db.Ado.GetParameters(new { PROD_CODE = prodCode,ORG_CODE = orgCode });
+ var data = Biz.Db.Ado.UseStoredProcedure().SqlQuery<V_MES_ROUTE_PTREE>("SP_MES_GET_ROUTE_PTREE", pars);//杩斿洖List
return Ok(data);
}
@@ -204,5 +206,32 @@
}
return Ok(response);
}
+
+ /// <summary>
+ /// 娣诲姞宸ュ崟宸ヨ壓璺嚎
+ /// </summary>
+ /// <param name="rotId"></param>
+ /// <param name="wo"></param>
+ /// <returns></returns>
+ [HttpGet]
+ [Route("api/[controller]/[action]")]
+ public async Task<IActionResult> SP_MES_PROD2WO(string rotId, string wo)
+ {
+ ApiAction response = new();
+ try
+ {
+ SugarParameter[] pars = Biz.Db.Ado.GetParameters(new { ROT_ID = rotId, WO = wo, ERR_CODE = 0, ERR_MSG = "" });
+ pars[2].Direction = System.Data.ParameterDirection.Output;
+ pars[3].Direction = System.Data.ParameterDirection.Output;
+ Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("SP_MES_PROD2WO", pars);
+ response.Data = pars[2].Value;
+ response.Message = pars[3].Value.ToString();
+ }
+ catch (System.Exception ex)
+ {
+ response = response.GetResponse().CatchExceptionWithLog(ex);
+ }
+ return Ok(response);
+ }
}
}
diff --git a/Tiger.Model.Net/Entitys/MES/V_BAS_PROD.cs b/Tiger.Model.Net/Entitys/MES/V_BAS_PROD.cs
index 9a523f5..dc6aa34 100644
--- a/Tiger.Model.Net/Entitys/MES/V_BAS_PROD.cs
+++ b/Tiger.Model.Net/Entitys/MES/V_BAS_PROD.cs
@@ -12,8 +12,8 @@
/// </summary>
[Serializable]
[SugarTable("V_BAS_PROD")]
- public class V_BAS_PROD : iViewEntity
- {
+ public class V_BAS_PROD : iViewEntity, iTableHasAuth
+ {
#region 构造函数
/// <summary>
/// 实体：V_BAS_PROD
--
Gitblit v1.9.3