From c3acb0bf589ba6de244e4eae737152688e5d3e61 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期三, 23 十一月 2022 16:41:29 +0800
Subject: [PATCH] 优化待审核页面
---
web/web/GwStatisV3.ashx | 61 +++++++++++++++++++++++++++---
1 files changed, 55 insertions(+), 6 deletions(-)
diff --git a/web/web/GwStatisV3.ashx b/web/web/GwStatisV3.ashx
index 557e27a..0d426ae 100644
--- a/web/web/GwStatisV3.ashx
+++ b/web/web/GwStatisV3.ashx
@@ -10,10 +10,21 @@
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 = "";
public override JsonPageResult ProcessRequestInternal(PageContext<Model.SysUser> context)
{
string action = context.GetString("action");
+ _userId = context.SessionObject.UserID;
+ _userType = context.SessionObject.UserType;
+ _account = context.SessionObject.Account;
switch (action)
{
@@ -28,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)
{
@@ -75,6 +122,8 @@
string opID = context.GetString("opid");
string statistype = context.GetString("statistype");
StatisOption statisoption = (StatisOption)context.GetInt("statisoption");
+
+ string permissionsSQL = new GwClientDao().GetClientPermissions(_userId, _userType, null);
List<GwOp> opList;
@@ -87,7 +136,7 @@
using (GwClientDao dao = new GwClientDao())
{
- clientList = dao.LoadInfoList("", "", "", "");
+ clientList = dao.LoadInfoList("", "", "", "", permissionsSQL);
}
List<GwAp> apList;
@@ -98,9 +147,11 @@
apList = dao.LoadInfoList("", "", "", out recordCount, 99999, 1);
}
+
+ //var list = _Dao.Query(beginTime, endTime, clientID, spID, apID, opID, statistype, (StatisOption)statisoption);
-
- var list = _Dao.Query(beginTime, endTime, clientID, spID, apID, opID, statistype, (StatisOption)statisoption);
+ //鏍规嵁绯荤粺鐢ㄦ埛鑾峰彇鏈夋潈闄愬鎴�
+ var list = _Dao.Query(beginTime, endTime, clientID, spID, apID, opID, statistype, permissionsSQL, (StatisOption)statisoption);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
@@ -141,8 +192,6 @@
sb.Append(@"</tr>");
-
- int i = 0;
foreach (GwStatisV3Item item in list)
{
--
Gitblit v1.9.1