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()); // 鐩存帴瑙ｆ瀽涓篔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; // 鐩存帴瑙ｆ瀽涓篔Object
}
catch (Exception ex)
@@ -475,4 +509,4 @@
{
_httpClient?.Dispose();
}
-}
\ No newline at end of file
+}
--
Gitblit v1.9.3