From f95dd1ce548f2a465d13f70fe4616410a4d77cc5 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期三, 14 五月 2025 08:45:58 +0800
Subject: [PATCH] 1.OA接口优化。 2.携客云接口调用 3.携客云送货单、送货明细、条码信息实体
---
service/QC/OaApi.cs | 42 ++++++++++++++++++++++++++++++++++++++----
1 files changed, 38 insertions(+), 4 deletions(-)
diff --git a/service/QC/OaApi.cs b/service/QC/OaApi.cs
index c299283..60c3601 100644
--- a/service/QC/OaApi.cs
+++ b/service/QC/OaApi.cs
@@ -1,4 +1,4 @@
-锘�// OaApiService.cs
+// OaApiService.cs
using System;
using System.Collections.Generic;
using System.Dynamic;
@@ -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