From 6b902884b05db6d2d8ce32ca615295e8ae9003e9 Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期五, 06 五月 2022 17:57:22 +0800
Subject: [PATCH] 订单审校
---
web/Dao/GwSpDao.cs | 13 ++++++++++++-
1 files changed, 12 insertions(+), 1 deletions(-)
diff --git a/web/Dao/GwSpDao.cs b/web/Dao/GwSpDao.cs
index a75574b..a25f2ae 100644
--- a/web/Dao/GwSpDao.cs
+++ b/web/Dao/GwSpDao.cs
@@ -428,7 +428,18 @@
) > 0;
}
- public bool UpdateBalance(int Balance, string spid)
+ //鏍规嵁璁㈠崟鏇存柊浣欓
+ public bool UpdateBalanceByOrder(int Balance,int basicNum, int givingNum, string spid)
+ {
+ return OracleHelper.ExecuteSql("UPDATE GW_SP SET BALANCE=:BALANCE, BASIC_NUM=:BASIC_NUM, GIVING_NUM=:GIVING_NUM WHERE SP_ID=:SP_ID", OracleHelper.Connection
+ , new OracleParameter(":BALANCE", (object)Balance)
+ , new OracleParameter(":BASIC_NUM", (object)basicNum)
+ , new OracleParameter(":GIVING_NUM", (object)givingNum)
+ , new OracleParameter(":SP_ID", (object)spid)
+ ) > 0;
+ }
+
+ public bool UpdateBalance(int Balance, string spid)
{
return OracleHelper.ExecuteSql("UPDATE GW_SP SET BALANCE=:BALANCE WHERE SP_ID=:SP_ID", OracleHelper.Connection, new OracleParameter(":BALANCE", (object) Balance), new OracleParameter(":SP_ID", (object) spid)) > 0;
}
--
Gitblit v1.9.1