From 3da0e2b539be6f7c9f22ecdefaeca677008501ca Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期二, 13 五月 2025 08:48:25 +0800
Subject: [PATCH] MES->OA回写状态

---
 service/QC/OaApi.cs |   40 +++++++++++++++++++++++++++++++++++++---
 1 files changed, 37 insertions(+), 3 deletions(-)

diff --git a/service/QC/OaApi.cs b/service/QC/OaApi.cs
index c299283..90891f4 100644
--- a/service/QC/OaApi.cs
+++ b/service/QC/OaApi.cs
@@ -36,7 +36,8 @@
     public async Task<dynamic> SubmitIQCToOA(dynamic queryObj)
     {
         // 淇敼鍙傛暟楠岃瘉瀛楁鍚�
-        //if (queryObj.userId.IsNullOrEmpty()) throw new Exception("鐢ㄦ埛id涓嶅厑璁镐负绌�");
+        if (string.IsNullOrEmpty(queryObj.userId.ToString())) throw new Exception("鐢ㄦ埛id涓嶅厑璁镐负绌�");
+        if (string.IsNullOrEmpty(queryObj.qcczdGuid.ToString())) throw new Exception("寮傚父澶勭疆鍗昳d涓嶈兘涓虹┖");
         //if (queryObj.qcczdGuid.IsNullOrEmpty()) throw new Exception("寮傚父澶勭疆鍗昳d涓嶈兘涓虹┖"); // 鍘熷弬鏁板悕涓� qcczdGuid
 
         try
@@ -103,9 +104,42 @@
                 }
             }
 
-            return JObject.Parse(response.Content.ToString());  // 鐩存帴瑙f瀽涓篔Object
+            var result = JObject.Parse(response.Content.ToString());
 
+            // 鏂板鐘舵�佹洿鏂帮紙褰揙A杩斿洖鎴愬姛鏃讹級
+            if (result.code?.ToString() == "SUCCESS")
+            {
+                var updateSql = @"UPDATE Mes_QC_Exceptional
+SET checkStatus = 1,
+    checkDate   = GETDATE(),
+    checkBy     = (select top 1 u.[ACCOUNT] from [dbo].[SYS_USER] u where u.guid = @edtUserCode)
+WHERE GUID = @inOrderGuid";
+                
+                using (var conn = new SqlConnection(DbHelperSQL.strConn))
+                {
+                    using (var cmd = new SqlCommand(updateSql, conn))
+                    {
+                        try
+                        {
+                            conn.Open();
+                            //cmd.Parameters.AddWithValue("@dt", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
+                            cmd.Parameters.AddWithValue("@edtUserCode", queryObj.userId?.ToString());
+                            cmd.Parameters.AddWithValue("@inOrderGuid", queryObj.qcczdGuid?.ToString());
+                            cmd.ExecuteNonQuery();
+                        }
+                        catch (Exception updateEx)
+                        {
+                            Console.WriteLine($"鐘舵�佹洿鏂板け璐�: {updateEx.Message}");
+                        }
+                        finally
+                        {
+                            conn.Close();
+                        }
+                    }
+                }
+            }
 
+            return result;  // 鐩存帴瑙f瀽涓篔Object
 
         }
         catch (Exception ex)
@@ -475,4 +509,4 @@
     {
         _httpClient?.Dispose();
     }
-}
\ No newline at end of file
+}

--
Gitblit v1.9.3