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/GwSpDao.cs | 16 ++++++++--------
1 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/web/Dao/GwSpDao.cs b/web/Dao/GwSpDao.cs
index 3c3843a..482c169 100644
--- a/web/Dao/GwSpDao.cs
+++ b/web/Dao/GwSpDao.cs
@@ -1,7 +1,7 @@
锘�
using Common;
using Model;
-using Oracle.DataAccess.Client;
+using Oracle.ManagedDataAccess.Client;
using System;
using System.Collections.Generic;
using System.Data;
@@ -249,7 +249,7 @@
return list1;
}
- public List<GwSp> LoadInfoList(string spId, string apId, string clientId, string clientName, int routerType, string opID, int chargeType, int pageIndex, int pageSize
+ public List<GwSp> LoadInfoList(string spId, string apId, string clientId, string company, int routerType, string opId, int chargeType, int pageIndex, int pageSize
, string resendStatus, string productId, string permissionsSQL, out int recordCount)
{
List<GwSp> list1 = new List<GwSp>();
@@ -288,9 +288,9 @@
list2.Add(new OracleParameter(":ClientID", (object)('%' + clientId + '%')));
stringBuilder.Append(" and CLIENT_ID like :ClientID");
}
- if (clientName != null && clientName != "")
+ if (company != null && company != "")
{
- stringBuilder.Append(" and CLIENT_ID IN (SELECT CLIENT_ID FROM GW_CLIENT WHERE CLIENT_NAME like '%" + clientName + "%' )");
+ stringBuilder.Append(" and CLIENT_ID IN (SELECT CLIENT_ID FROM GW_CLIENT WHERE COMPANY like '%" + company + "%' )");
}
/**
if (chargeType > 0)
@@ -309,20 +309,20 @@
{
list2.Add(new OracleParameter(":ROUTER_TYPE", (object)routerType));
stringBuilder.Append(" and ROUTER_TYPE=:ROUTER_TYPE");
- if (!string.IsNullOrEmpty(opID))
+ if (!string.IsNullOrEmpty(opId))
{
stringBuilder.Append(" and (CM_OP_ID=:OPID) OR (CT_OP_ID=:OPID) OR (UN_OP_ID=:OPID) ");
- list2.Add(new OracleParameter(":OPID", (object)opID));
+ list2.Add(new OracleParameter(":OPID", (object)opId));
}
}
if (routerType == 3)
{
list2.Add(new OracleParameter(":ROUTER_TYPE", (object)routerType));
stringBuilder.Append(" and ROUTER_TYPE=:ROUTER_TYPE");
- if (!string.IsNullOrEmpty(opID))
+ if (!string.IsNullOrEmpty(opId))
{
stringBuilder.Append(" and (CM_GROUP_ID=:OPID) OR (CU_GROUP_ID=:OPID) OR (CT_GROUP_ID=:OPID) ");
- list2.Add(new OracleParameter(":OPID", (object)opID));
+ list2.Add(new OracleParameter(":OPID", (object)opId));
}
}
}
--
Gitblit v1.9.1