From a6a84e6f677447342e8c5984fdc0b52241b92ce3 Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期四, 30 六月 2022 01:20:34 +0800
Subject: [PATCH] 客户管理分配个性产品优化、返回URL优化
---
web/Dao/GwClientDao.cs | 8 +++++---
1 files changed, 5 insertions(+), 3 deletions(-)
diff --git a/web/Dao/GwClientDao.cs b/web/Dao/GwClientDao.cs
index 93929f7..6d27537 100644
--- a/web/Dao/GwClientDao.cs
+++ b/web/Dao/GwClientDao.cs
@@ -586,6 +586,8 @@
//鏇存柊涓�у垎閰嶅鎴烽泦闀垮害澶т簬0鏃�
string key2 = "UPDATE GW_PRODUCT SET CLIENT_IDS=:CLIENT_ID || ',' || CLIENT_IDS WHERE (CLIENT_IDS IS NOT NULL AND LENGTH(CLIENT_IDS) > 0) AND ID=:PRODUCT_ID ";
+
+ list = new List<KeyValuePair<string, OracleParameter[]>>();
foreach (string str in productIdArray)
{
OracleParameter[] oracleParameterArray2 = new OracleParameter[2]
@@ -594,7 +596,6 @@
new OracleParameter(":PRODUCT_ID", (object) str)
};
- list = new List<KeyValuePair<string, OracleParameter[]>>();
list.Add(new KeyValuePair<string, OracleParameter[]>(key2, oracleParameterArray2));
}
OracleHelper.ExecuteSqlTran(list, OracleHelper.Connection);
@@ -602,6 +603,8 @@
//鏇存柊涓�у垎閰嶅鎴烽泦闀垮害涓�0鏃�
string key3 = "UPDATE GW_PRODUCT SET CLIENT_IDS=:CLIENT_ID WHERE (CLIENT_IDS IS NULL OR LENGTH(CLIENT_IDS) <= 0) AND ID=:PRODUCT_ID ";
+
+ list = new List<KeyValuePair<string, OracleParameter[]>>();
foreach (string str in productIdArray)
{
OracleParameter[] oracleParameterArray2 = new OracleParameter[2]
@@ -609,8 +612,7 @@
new OracleParameter(":CLIENT_ID", (object) clientId),
new OracleParameter(":PRODUCT_ID", (object) str)
};
-
- list = new List<KeyValuePair<string, OracleParameter[]>>();
+
list.Add(new KeyValuePair<string, OracleParameter[]>(key3, oracleParameterArray2));
}
OracleHelper.ExecuteSqlTran(list, OracleHelper.Connection);
--
Gitblit v1.9.1