服务端的TigerApi 框架,基于.NET6 2024 版本
Rodney Chen
2024-07-14 507be0f76a93abfd825ce7fbf192cc098b978f10
Tiger.Api/Controllers/MES/MESController.Route.cs
@@ -163,8 +163,12 @@
            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); ;
                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)
            {
@@ -187,8 +191,12 @@
            ApiAction response = new();
            try
            {
                SugarParameter[] pars = Biz.Db.Ado.GetParameters(new { ROT_ID = rotId, PROD_CODE = prodCode, CUST_CODE = custCode });
                Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("SP_MES_ROUTE2CUST", pars); ;
                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)
            {