From 97aa542d1a1cdcb46b2942026d28b7e5dca6c6c0 Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期一, 20 六月 2022 21:10:23 +0800
Subject: [PATCH] 首页：通道状态
---
web/Dao/GwAuditCacheDao.cs | 48 ++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 48 insertions(+), 0 deletions(-)
diff --git a/web/Dao/GwAuditCacheDao.cs b/web/Dao/GwAuditCacheDao.cs
index f95e3ce..b012f24 100644
--- a/web/Dao/GwAuditCacheDao.cs
+++ b/web/Dao/GwAuditCacheDao.cs
@@ -7,6 +7,7 @@
using System;
using System.Collections.Generic;
using System.Data;
+ using System.Data.Common;
using System.Runtime.InteropServices;
using System.Text;
using System.Text.RegularExpressions;
@@ -190,5 +191,52 @@
OracleParameter[] parameterArray = new OracleParameter[] { new OracleParameter(":AUDITING_STATUS", (int)status), new OracleParameter(":HASH_CODE", hashCode), new OracleParameter(":OP_ID", opID) };
return (OracleHelper.ExecuteSql(str, OracleHelper.Connection, parameterArray) > 0);
}
+
+ //鍙戦�佸唴瀹�:寰呭鏍哥粺璁�
+ public List<Dictionary<string, object>> GetSendAudit(string permissionsSQL)
+ {
+ List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
+ StringBuilder builder = new StringBuilder();
+ builder.Append(" SELECT COUNT(1) COUNT FROM GW_AUDIT_CACHE WHERE AUDITING_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;
+ }
+
+ //鍙戦�佸唴瀹�:浜屾寰呭鏍哥粺璁�
+ public List<Dictionary<string, object>> GetSendAuditTow(string permissionsSQL)
+ {
+ List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
+ StringBuilder builder = new StringBuilder();
+ builder.Append(" SELECT COUNT(1) COUNT FROM GW_AUDIT_CACHE WHERE AUDITING_STATUS =10 ");
+ 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;
+ }
}
+
}
--
Gitblit v1.9.1