From 374ce4ffd0c459bb4067e8d5765f972668aff9b1 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期四, 02 三月 2023 14:56:23 +0800
Subject: [PATCH] 变更oracle访问组件
---
web/Dao/GwOrderDao.cs | 9 ++++-----
1 files changed, 4 insertions(+), 5 deletions(-)
diff --git a/web/Dao/GwOrderDao.cs b/web/Dao/GwOrderDao.cs
index 1b177c9..7dcdcd4 100644
--- a/web/Dao/GwOrderDao.cs
+++ b/web/Dao/GwOrderDao.cs
@@ -4,7 +4,7 @@
using System.Text;
using Model;
using Common;
-using Oracle.DataAccess.Client;
+using Oracle.ManagedDataAccess.Client;
using System.Data.Common;
namespace Dao
@@ -229,13 +229,12 @@
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, PAY_AMOUNT=:PAY_AMOUNT, BEFORE_BALANCE_NUM=:BEFORE_BALANCE_NUM, STATUS = :STATUS where ORDER_ID=:ORDER_ID", OracleHelper.Connection
+ 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, PAY_AMOUNT=:PAY_AMOUNT, 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(":PAY_AMOUNT", (object)payAmount)
- , new OracleParameter(":BEFORE_BALANCE_NUM", (object)beforeGivingNum)
, new OracleParameter(":STATUS", (object)orderStatus)
, new OracleParameter(":ORDER_ID", (object)orderId)
) > 0;
@@ -308,7 +307,7 @@
builder.Append(" LEFT JOIN ( ");
builder.Append(" SELECT order_id, max(audit_time) update_time FROM gw_order_audit goa ");
builder.Append(" GROUP BY order_id ");
- builder.Append(" ) b ON b.order_id = a.order_id ");
+ builder.Append($" ) b ON b.order_id = a.order_id where update_time>=TO_date('{DateTime.Now.Date}','yyyy-MM-dd HH24:mi:ss') ");
builder.Append(" ) ");
builder.Append(" WHERE 1=1 AND status=2 ");
//builder.Append(" AND update_time=:UPDATE_TIME ");
@@ -380,7 +379,7 @@
o.OrderId = oracleReaderWrapper.GetString("ORDER_ID", "");
o.SpId = oracleReaderWrapper.GetString("SP_ID", "");
o.ClientId = oracleReaderWrapper.GetString("CLIENT_ID", "");
- o.Company = oracleReaderWrapper.GetString("Client_Name", "");
+ o.Company = oracleReaderWrapper.GetString("COMPANY", "");
o.ClientName = oracleReaderWrapper.GetString("CLIENT_NAME", "");
o.ProductId = oracleReaderWrapper.GetString("PRODUCT_ID", "");
o.ProductName = oracleReaderWrapper.GetString("PRODUCT_NAME", "");
--
Gitblit v1.9.1