MES采集工序，测试工序，包装工序

Rodney Chen

2024-07-14 507be0f76a93abfd825ce7fbf192cc098b978f10

 Tiger.Api/Controllers/MES/MESController.Route.cs

@@ -1,7 +1,10 @@
using 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,72 @@
            }
            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);
        }

        /// <summary>
        /// 添加生产工艺路线
        /// </summary>
        /// <param name="rotId"></param>
        /// <param name="prodCode"></param>
        /// <returns></returns>
        [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, 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_ROUTE2PROD", pars);
                response.Data = pars[3].Value;
                response.Message = pars[4].Value.ToString();
            }
            catch (System.Exception ex)
            {
                response = response.GetResponse().CatchExceptionWithLog(ex);
            }
            return Ok(response);
        }

        /// <summary>
        /// 添加客户工艺路线
        /// </summary>
        /// <param name="rotId"></param>
        /// <param name="prodCode"></param>
        /// <param name="custCode"></param>
        /// <returns></returns>
        [HttpGet]
        [Route("api/[controller]/[action]")]
        public async Task<IActionResult> RouteToCust(string rotId, string prodCode, string custCode)
        {
            ApiAction response = new();
            try
            {
                SugarParameter[] pars = Biz.Db.Ado.GetParameters(new { ROT_ID = rotId, PROD_CODE = prodCode, CUST_CODE = custCode, ERR_CODE=0, ERR_MSG="" });
                pars[3].Direction = System.Data.ParameterDirection.Output;
                pars[4].Direction = System.Data.ParameterDirection.Output;
                Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("SP_MES_ROUTE2CUST", pars);
                response.Data = pars[3].Value;
                response.Message = pars[4].Value.ToString();
            }
            catch (System.Exception ex)
            {
                response = response.GetResponse().CatchExceptionWithLog(ex);
            }
            return Ok(response);
        }
    }
}