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/web/GwStatisV3.ashx | 45 ++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 42 insertions(+), 3 deletions(-)
diff --git a/web/web/GwStatisV3.ashx b/web/web/GwStatisV3.ashx
index e3e87ce..0d426ae 100644
--- a/web/web/GwStatisV3.ashx
+++ b/web/web/GwStatisV3.ashx
@@ -10,6 +10,11 @@
public class GwStatisV3 : PageHandler<SysUser>
{
private GwStatisV3Dao _Dao = new GwStatisV3Dao();
+ private GwOrderDao orderDao = new GwOrderDao();
+ private GwSpPrePatternDao spPrePatternDao = new GwSpPrePatternDao();
+ private GwAuditCacheDao gwAuditCacheDao = new GwAuditCacheDao();
+ private GwEventLogDao gwEventLogDao = new GwEventLogDao();
+
private int _userId = -1;
private string _userType = "";
private string _account = "";
@@ -34,10 +39,46 @@
private JsonPageResult GetRealtimeStatis5m(PageContext<SysUser> context)
{
+
+ string permissionsSQL = new GwClientDao().GetClientPermissions(_userId, _userType, null);
+
var oplist = _Dao.GetRealtimeStatis5mOut();
var aplist = _Dao.GetRealtimeStatis5mIn();
+
+ //娲诲姩瀹㈡埛锛氬鎴�-鍙戦�侀噺銆愬綋鏃ャ��
+ var activeClientDayList = _Dao.GetActiveClientDay(permissionsSQL);
+ //閫氶亾-鍙戦�侀噺銆愬綋鏃ャ��
+ var opSendDayList = _Dao.GetOpSendDay(permissionsSQL);
+ //浜у搧-鍙戦�侀噺銆愬綋鏃ャ��
+ var productSendDayList = _Dao.GetProductSendDay(permissionsSQL);
+ //璁㈠崟:浠婃棩宸插畬鎴愯鍗�
+ var orderDayList = orderDao.GetOrderDay(permissionsSQL);
+ //璁㈠崟:寰呭鏍歌鍗�
+ var orderAuditList = orderDao.GetOrderAudit(permissionsSQL);
+ //鍙戦�佸唴瀹�:寰呭鏍�
+ var sendAuditList = gwAuditCacheDao.GetSendAudit(permissionsSQL);
+ //鍙戦�佸唴瀹�:浜屾寰呭鏍�
+ var sendAuditTowList = gwAuditCacheDao.GetSendAuditTow(permissionsSQL);
+ //璐﹀彿鎶ュ鍐呭:寰呭鏍�
+ var spPrePatternAuditList = spPrePatternDao.GetSpPrePatternAudit(permissionsSQL);
+ //閫氶亾鐘舵��
+ var opStatusList = gwEventLogDao.GetOpStatus(permissionsSQL);
+
+
- return new JsonPageResult(true, new { ApList = aplist, OpList = oplist } );
+ return new JsonPageResult(true, new {
+ ApList = aplist,
+ OpList = oplist,
+ ActiveClientDayList = activeClientDayList,
+ OpSendDayList = opSendDayList,
+ ProductSendDayList = productSendDayList,
+ OrderDayList = orderDayList,
+ OrderAuditList = orderAuditList,
+ SendAuditList = sendAuditList,
+ SendAuditTowList = sendAuditTowList,
+ SpPrePatternAuditList = spPrePatternAuditList,
+ OpStatusList = opStatusList
+ } );
}
private string GetApName(List<GwAp>aplist, int apID)
{
@@ -151,8 +192,6 @@
sb.Append(@"</tr>");
-
- int i = 0;
foreach (GwStatisV3Item item in list)
{
--
Gitblit v1.9.1