From 8dca993e320f7dff7d6175b7b69d9f14d1eb95fb Mon Sep 17 00:00:00 2001
From: lch <luluchen515@163.com>
Date: 星期一, 26 八月 2024 10:33:53 +0800
Subject: [PATCH] 供应商接口优化
---
HandleData/AE_MES_ERP.cs | 5 ++---
1 files changed, 2 insertions(+), 3 deletions(-)
diff --git a/HandleData/AE_MES_ERP.cs b/HandleData/AE_MES_ERP.cs
index 8bc8136..ca6af41 100644
--- a/HandleData/AE_MES_ERP.cs
+++ b/HandleData/AE_MES_ERP.cs
@@ -1221,7 +1221,7 @@
try
{
DataTable dt = ds.Tables[0];
- if (operatype == "INSERT")
+ if (operatype == "INSERT" || operatype == "UPDATE")
{
#region INSERT
//dt.Columns.Add("MAA005", typeof(string));
@@ -1268,7 +1268,7 @@
GYS005='{5}',
FUseOrgld='{6}'
where ERPID='{0}'; ", dr["ERPID"]
- , dr["GYS001"], dr["GYS002"], dr["GYS003"], dr["GYS004"], dr["GYS005"], dr["FUseOrgld"]);
+ , dr["GYSA001"], dr["GYSA002"], dr["GYSA003"], dr["GYSA004"], dr["GYSA005"], dr["FUseOrgld"]);
}
return _sqlHelper.ExecuteNonQuery(sql) > 0;
#endregion
@@ -3172,7 +3172,6 @@
string res = a.Body(US).msg.ToString();
sql = string.Format(@" update sysdec set states='NEW' WHERE TASK_ID='{0}' ", rtaskid);
-
_sqlHelper.ExecuteNonQuery(sql);
//string res = a.arg0.ws.MES_TO_ERP_DataTransport(task_name, descript, create_time, creator, operatype, source_table, target_table, data, data_inserted, data_deleted);
if (res.Contains("OK"))
--
Gitblit v1.9.3