From e3f3ce1d8a06d72cc63bccbd2b39834145d028a9 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期三, 06 十一月 2024 10:24:35 +0800
Subject: [PATCH] 1.丽德单据区分江西和宁波推送
---
HandleData/AE_MES_ERP.cs | 37 +++++++++++++++++++++++++++++++------
1 files changed, 31 insertions(+), 6 deletions(-)
diff --git a/HandleData/AE_MES_ERP.cs b/HandleData/AE_MES_ERP.cs
index 8360e9c..94f0168 100644
--- a/HandleData/AE_MES_ERP.cs
+++ b/HandleData/AE_MES_ERP.cs
@@ -1883,11 +1883,21 @@
if (dr.Table.Columns.Contains("CGAORG"))
{
org = "涓藉痉";
-
- string UP = string.Format(@"EXEC [WMS_CGLD_TOJX] '{0}' ", rtaskid);
- _sqlHelper.ExecuteNonQuery(UP);
- dr["NEWERPID"] = "LD"+dr["ERPID"].ToString();
- IDList.Add("LD"+dr["ERPID"].ToString());
+ dr["NEWERPID"] = "LD" + dr["ERPID"].ToString();
+ IDList.Add("LD" + dr["ERPID"].ToString());
+
+ if (dr["CGA0018"].ToString() == "103")
+ {
+ string UP = string.Format(@"EXEC [WMS_CGLD_TOJX] '{0}' ", rtaskid);
+ _sqlHelper.ExecuteNonQuery(UP);
+
+ string SYSDEC = string.Format(@"UPDATE SYSDEC SET STATES='IGNORE' WHERE task_name='TB_ERPTOMES_CG' AND STATES='NEW' AND TASK_ID ='{0}'", rtaskid);
+ _sqlHelper.ExecuteNonQuery(SYSDEC);
+
+ return true;
+ }
+
+
}
else
{
@@ -2242,7 +2252,22 @@
{
if (dF["TLA020"].ToString().Contains("瑁呴厤"))
{
- if (dF["TLA023"].ToString().Contains("-"))
+ if (dF["TLA023"].ToString().Contains("*"))
+ {
+ string[] tr = dF["TLA023"].ToString().Split('*');
+
+ //int i = dF["TLA023"].ToString().LastIndexOf('-');
+ string StrNew = tr[1].ToString();//dF["TLA023"].ToString().Substring(i + 1, 10);
+ string SQLT = string.Format(@"SELECT TOP 1 * FROM WOMCAA(NOLOCK) WHERE CAA018='{0}' ", StrNew);
+ DataTable CAA = _sqlHelper.ExecuteDataTable(SQLT);
+ if (CAA.Rows.Count > 0)
+ {
+ string UP = string.Format(@"UPDATE WOMCAA SET CAA016='{0}',CAA017='{1}',CAA018='{2}' WHERE CAA002='{3}' ", CAA.Rows[0]["CAA016"].ToString(), CAA.Rows[0]["CAA017"].ToString(), CAA.Rows[0]["CAA018"].ToString(), dF["TLA002"].ToString());
+ _sqlHelper.ExecuteNonQuery(UP);
+ }
+
+ }
+ else if (dF["TLA023"].ToString().Contains("-"))
{
string[] tr = dF["TLA023"].ToString().Split('-');
--
Gitblit v1.9.3