From 7ff74f599084561338eef1230db5aa45f74565f8 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 15 四月 2024 18:03:33 +0800
Subject: [PATCH] 1.ERP订单关闭增加单据id 2.MES工单关闭增加源单id关联

---
 VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs |   61 ++++++++++++++++++++++++------
 1 files changed, 49 insertions(+), 12 deletions(-)

diff --git a/VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs b/VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs
index b6b4f78..bb8b2f1 100644
--- a/VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs
@@ -34,14 +34,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鍚屾璁¢噺鍗曚綅鎴愬姛!";
+                    mes.message = "鍚屾璁¢噺鍗曚綅鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鍚屾璁¢噺鍗曚綅澶辫触!";
+                    mes.message = "鍚屾璁¢噺鍗曚綅澶辫触!";
                     mes.data = null;
                 }
             }
@@ -49,7 +49,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -71,14 +71,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鍚屾瀛樿揣妗f鎴愬姛!";
+                    mes.message = "鍚屾瀛樿揣妗f鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鍚屾瀛樿揣妗f澶辫触!";
+                    mes.message = "鍚屾瀛樿揣妗f澶辫触!";
                     mes.data = null;
                 }
             }
@@ -86,7 +86,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -108,14 +108,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鍚屾浠撳簱鎴愬姛!";
+                    mes.message = "鍚屾浠撳簱鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鍚屾浠撳簱澶辫触!";
+                    mes.message = "鍚屾浠撳簱澶辫触!";
                     mes.data = null;
                 }
             }
@@ -123,7 +123,7 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;
@@ -145,14 +145,14 @@
                 {
                     mes.code = "200";
                     mes.count = 0;
-                    mes.Message = "鍚屾浠撳簱鎴愬姛!";
+                    mes.message = "鍚屾浠撳簱鎴愬姛!";
                     mes.data = null;
                 }
                 else
                 {
                     mes.code = "300";
                     mes.count = 0;
-                    mes.Message = "鍚屾浠撳簱澶辫触!";
+                    mes.message = "鍚屾浠撳簱澶辫触!";
                     mes.data = null;
                 }
             }
@@ -160,7 +160,44 @@
             {
                 mes.code = "300";
                 mes.count = 0;
-                mes.Message = e.Message;
+                mes.message = e.Message;
+                mes.data = null;
+            }
+            return mes;
+        }
+        #endregion
+
+        #region[鐢熶骇绠$悊锛欵RP鐢熶骇璁㈠崟鍚屾]
+        public static ToMessage SeaveSearchErpOrder(User us)
+        {
+            var sql = "";
+            var dynamicParams = new DynamicParameters();
+            try
+            {
+                //瀛樺偍杩囩▼鍚�
+                sql = @"h_p_IFCLD_ERPMO";
+                dynamicParams.Add("@username", us.usercode);
+                bool a = DapperHelper.IsProcedure(sql, dynamicParams);
+                if (a)
+                {
+                    mes.code = "200";
+                    mes.count = 0;
+                    mes.message = "鍚屾鐢熶骇璁㈠崟鎴愬姛!";
+                    mes.data = null;
+                }
+                else
+                {
+                    mes.code = "300";
+                    mes.count = 0;
+                    mes.message = "鍚屾鐢熶骇璁㈠崟澶辫触!";
+                    mes.data = null;
+                }
+            }
+            catch (Exception e)
+            {
+                mes.code = "300";
+                mes.count = 0;
+                mes.message = e.Message;
                 mes.data = null;
             }
             return mes;

--
Gitblit v1.9.3