From ec4e1f18de717d26b3e510f0d826e8f93e19eefe Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期二, 25 十月 2022 17:03:06 +0800
Subject: [PATCH] 修复客户信息管理 修复文字错误
---
web/Dao/GwSmDao.cs | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/web/Dao/GwSmDao.cs b/web/Dao/GwSmDao.cs
index 8130f8a..b71aaef 100644
--- a/web/Dao/GwSmDao.cs
+++ b/web/Dao/GwSmDao.cs
@@ -323,7 +323,7 @@
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
- public List<GwSm> LoadInfoList(string apMID, string opName, string clientID, string spID, string destnationId, string sDate, string beginTime, string endTime, string content, string opstat, int TStatus, out int recordcount, int pageSize, int pageIndex,string ReSend=null)
+ public List<GwSm> LoadInfoList(string apMID, string opName, string clientID, string spID, string destnationId, string sDate, string beginTime, string endTime, string content, string opstat, int TStatus, string permissionsSQL, out int recordcount, int pageSize, int pageIndex,string ReSend=null)
{
List<GwSm> list1 = new List<GwSm>();
recordcount = 0;
@@ -403,6 +403,10 @@
list2.Add(oracleParameter2);
((DbParameter)oracleParameter2).Value = (object)DateTime.Parse(sDate + " " + endTime);
stringBuilder.Append(" and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME");
+
+ //瀹㈡埛鏉冮檺SQL鑴氭湰
+ stringBuilder.Append(permissionsSQL);
+
using (OracleDataReader reader = OracleHelper.ExecuteReader("select count(*) as count " + stringBuilder.ToString(), OracleHelper.Connection, list2.ToArray()))
{
if (((DbDataReader)reader).Read())
--
Gitblit v1.9.1