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/GwSpPrePatternDao.cs | 25 ++++++++++++++++++++++++-
1 files changed, 24 insertions(+), 1 deletions(-)
diff --git a/web/Dao/GwSpPrePatternDao.cs b/web/Dao/GwSpPrePatternDao.cs
index 36e9c5d..71f4f5a 100644
--- a/web/Dao/GwSpPrePatternDao.cs
+++ b/web/Dao/GwSpPrePatternDao.cs
@@ -1,6 +1,6 @@
锘�
using Common;
-using Oracle.DataAccess.Client;
+using Oracle.ManagedDataAccess.Client;
using System;
using System.Collections.Generic;
using System.Data.Common;
@@ -125,6 +125,29 @@
return list;
}
+ //璐﹀彿鎶ュ鍐呭寰呭鏍哥粺璁�
+ public List<Dictionary<string, object>> GetSpPrePatternAudit(string permissionsSQL)
+ {
+ List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
+ StringBuilder builder = new StringBuilder();
+ builder.Append(" SELECT COUNT(1) COUNT FROM GW_SP_PREPATTERN WHERE Audit_Status =0 ");
+ builder.Append(permissionsSQL);
+
+ using (OracleDataReader reader = OracleHelper.ExecuteReader(builder.ToString(), OracleHelper.Connection))
+ {
+ while (reader != null && ((DbDataReader)reader).Read())
+ {
+ OracleReaderWrapper oracleReaderWrapper = new OracleReaderWrapper(reader);
+ int count = oracleReaderWrapper.GetInt("COUNT", 0);
+
+ Dictionary<string, object> map = new Dictionary<string, object>();
+ map.Add("count", count);
+ list.Add(map);
+ }
+ }
+ return list;
+ }
+
private int ReadCount(OracleDataReader reader)
{
return new OracleReaderWrapper(reader).GetInt("count", 0);
--
Gitblit v1.9.1