From 3bf021ed05b7ae7a50b4287b2831588495bb06e6 Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期四, 30 六月 2022 12:35:39 +0800
Subject: [PATCH] 优化金额或条数的长度处理。
---
web/Dao/GwClientDao.cs | 10 ++++++----
1 files changed, 6 insertions(+), 4 deletions(-)
diff --git a/web/Dao/GwClientDao.cs b/web/Dao/GwClientDao.cs
index 93929f7..fe7bc15 100644
--- a/web/Dao/GwClientDao.cs
+++ b/web/Dao/GwClientDao.cs
@@ -303,7 +303,7 @@
* clientId锛氬鎴稩D
*
*/
- public bool UpdateClientAmount(int AddBalance, int payAmount, string clientId )
+ public bool UpdateClientAmount(Int64 AddBalance, Int64 payAmount, string clientId )
{
return OracleHelper.ExecuteSql("UPDATE GW_CLIENT SET BALANCE=(BALANCE + :BALANCE), TOP_UP_AMOUNT_TOTAL=(TOP_UP_AMOUNT_TOTAL + :TOP_UP_AMOUNT_TOTAL) WHERE CLIENT_ID=:CLIENT_ID", OracleHelper.Connection, new OracleParameter(":BALANCE", (object)AddBalance), new OracleParameter(":TOP_UP_AMOUNT_TOTAL", (object)payAmount), new OracleParameter(":CLIENT_ID", (object)clientId)) > 0;
}
@@ -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