添加客户工单工艺路线

Ben Lin

2024-07-22 4820d874c4b163b1fc62ce3e17f85372232f81ff

添加客户工单工艺路线

 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);
        }
    }
}

 Tiger.Model.Net/Entitys/MES/V_MES_WO_PTREE.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,89 @@
using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;
using Tiger.Model;

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：V_MES_WO_PTREE
    /// </summary>
    [Serializable]
    [SugarTable("V_MES_WO_PTREE")]
    public class V_MES_WO_PTREE : iViewEntity
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：V_MES_WO_PTREE
        /// </summary>
        public V_MES_WO_PTREE() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// 
        /// </summary>
        public string pid { get; set; }
        /// <summary>
        /// 
        /// </summary>
        public string id { get; set; }
        /// <summary>
        /// 
        /// </summary>
        public string wo { get; set; }
        /// <summary>
        /// 
        /// </summary>
        public string prod { get; set; }
        /// <summary>
        /// 
        /// </summary>
        public string cust { get; set; }
        /// <summary>
        /// 
        /// </summary>
        public string code { get; set; }
        /// <summary>
        /// 
        /// </summary>
        public string name { get; set; }
        /// <summary>
        /// 
        /// </summary>
        public string type { get; set; }
        /// <summary>
        /// 
        /// </summary>
        public int seq { get; set; }
        #endregion

        #region è™šæ‹Ÿå±žæ€§
        /*例子
        [SugarColumn(IsIgnore = true)]
        public string FieldName { get; set; }
        */
        [SugarColumn(IsIgnore = true)]
        public string tid { get; set; }
        #endregion

        #region æžšä¸¾å˜é‡
        /*例子
        public enum FieldNames
        {
            [Description("枚举描述0")]
            Enum0,
            [Description("枚举描述1")]
            Enum1,
        }
        */
        #endregion

        #region å…¬å…±æ–¹æ³•

        #endregion

    }//endClass
}

 Tiger.Model.Net/Tiger.Model.Net.csproj

@@ -167,6 +167,7 @@
    <Compile Include="Entitys\MES\V_MES_ROUTE_NOE_POST.cs" />
    <Compile Include="Entitys\MES\V_MES_ROUTE_PTREE.cs" />
    <Compile Include="Entitys\MES\V_MES_WO_BATCH.cs" />
    <Compile Include="Entitys\MES\V_MES_WO_PTREE.cs" />
    <Compile Include="Entitys\MES\V_SMT_TOOL.cs" />
    <Compile Include="Entitys\MES\SMT_TOOL.cs" />
    <Compile Include="Entitys\MES\SMT_TOOL_HIS.cs" />