From 28e792c272441162b15d95bdc7356d82ea3e2908 Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期六, 07 五月 2022 16:02:12 +0800
Subject: [PATCH] 优化
---
web/Dao/GwOrderDao.cs | 17 +++++++++++++++++
1 files changed, 17 insertions(+), 0 deletions(-)
diff --git a/web/Dao/GwOrderDao.cs b/web/Dao/GwOrderDao.cs
index 84b510b..0d9c47f 100644
--- a/web/Dao/GwOrderDao.cs
+++ b/web/Dao/GwOrderDao.cs
@@ -218,6 +218,23 @@
return OracleHelper.ExecuteSql("update GW_ORDER SET STATUS = :STATUS where ORDER_ID=:ORDER_ID", OracleHelper.Connection, new OracleParameter(":STATUS", (object)status), new OracleParameter(":ORDER_ID", (object)orderId)) > 0;
}
+ //鏇存柊璁㈠崟淇敼鍓嶄綑棰�
+ public bool UpdateBalanceAndStatus(int basicNum, int givingNum, int orderNumTotal, int orderAmountTotal, int beforeGivingNum , int orderStatus, string orderId )
+ {
+ if (string.IsNullOrEmpty(orderId))
+ return false;
+ //status:4-鍙栨秷
+ return OracleHelper.ExecuteSql("update GW_ORDER SET BASIC_NUM=:BASIC_NUM, GIVING_NUM=:GIVING_NUM, ORDER_NUM_TOTAL=:ORDER_NUM_TOTAL, ORDER_AMOUNT_TOTAL=:ORDER_AMOUNT_TOTAL, BEFORE_BALANCE_NUM=:BEFORE_BALANCE_NUM, STATUS = :STATUS where ORDER_ID=:ORDER_ID", OracleHelper.Connection
+ , new OracleParameter(":BASIC_NUM", (object)basicNum)
+ , new OracleParameter(":GIVING_NUM", (object)givingNum)
+ , new OracleParameter(":ORDER_NUM_TOTAL", (object)orderNumTotal)
+ , new OracleParameter(":ORDER_AMOUNT_TOTAL", (object)orderAmountTotal)
+ , new OracleParameter(":BEFORE_BALANCE_NUM", (object)beforeGivingNum)
+ , new OracleParameter(":STATUS", (object)orderStatus)
+ , new OracleParameter(":ORDER_ID", (object)orderId)
+ ) > 0;
+ }
+
//鏇存柊浜у搧鎴栦骇鍝佸垎绫讳俊鎭�
public bool Update(GwOrder o)
{
--
Gitblit v1.9.1