From 3b18a48485f7207438d9d0eb3038d979e069431d Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期四, 26 五月 2022 17:58:18 +0800
Subject: [PATCH] 优化产品及产品分类，订单，对称加密，IP转地区名称
---
web/web/ExportDocument.aspx.cs | 24 ++++++++++++++++++------
1 files changed, 18 insertions(+), 6 deletions(-)
diff --git a/web/web/ExportDocument.aspx.cs b/web/web/ExportDocument.aspx.cs
index 0effa22..6ad04c7 100644
--- a/web/web/ExportDocument.aspx.cs
+++ b/web/web/ExportDocument.aspx.cs
@@ -10,10 +10,17 @@
public partial class ExportDocument : PageBase<SysUser>, IRequiresSessionState
{
-
+
+ private int _userId = -1;
+ private int _userType = -1;
+ private string _account = "";
protected void Page_Load(object sender, EventArgs e)
{
+ _userId = this.AppContext.SessionObject.UserID;
+ _userType = this.AppContext.SessionObject.UserType;
+ _account = this.AppContext.SessionObject.Account;
+
switch (this.AppContext.GetString("action"))
{
case "exPortGwSp":
@@ -45,6 +52,8 @@
string statistype = this.AppContext.GetString("Statistype");
StatisOption statisoption = (StatisOption)this.AppContext.GetInt("Statisoption");
+ string permissionsSQL = new GwClientDao().GetClientPermissions(_userId, _userType, null);
+
List<GwOp> opList;
using (GwOpDao dao = new GwOpDao())
@@ -56,7 +65,7 @@
using (GwClientDao dao = new GwClientDao())
{
- clientList = dao.LoadInfoList("", "", "", "");
+ clientList = dao.LoadInfoList("", "", "", "", permissionsSQL);
}
List<GwAp> apList;
@@ -68,8 +77,9 @@
apList = dao.LoadInfoList("", "", "", out recordCount, 99999, 1);
}
+
GwStatisV3Dao _Dao = new GwStatisV3Dao();
- var list = _Dao.Query(Convert.ToDateTime(beginTime), Convert.ToDateTime(endTime), clientId, spid, apMid, opid, statistype, (StatisOption)statisoption);
+ var list = _Dao.Query(Convert.ToDateTime(beginTime), Convert.ToDateTime(endTime), clientId, spid, apMid, opid, statistype, permissionsSQL, (StatisOption)statisoption);
List<Model.GwStatisV3> statisList = new List<Model.GwStatisV3>();
foreach (GwStatisV3Item item in list)
@@ -303,13 +313,14 @@
this.Response.End();
}
DataTable dataTable = gwSmDao.LoadSpDataTable(apMid, opName, clientId, spid, mobile, sDate, beginTime, endTime, content, @int, opstat);
+
WebTool webTool = new WebTool();
Dictionary<string, string> dictionary = new Dictionary<string, string>();
dictionary["AP娑堟伅ID"] = "AP_MID";
- dictionary["CLTID"] = "CLIENT_ID";
+ dictionary["瀹㈡埛ID"] = "CLIENT_ID";
dictionary["璐﹀彿"] = "SP_ID";
- dictionary["APID"] = "AP_ID";
- dictionary["OPID"] = "OP_ID";
+ dictionary["鎺ュ叆鐐笽D"] = "AP_ID";
+ dictionary["閫氶亾鍚�"] = "OP_NAME";
dictionary["鐮佸彿"] = "ACCESS_CODE";
dictionary["鎺ユ敹鍙风爜"] = "MOBILE";
dictionary["PKN "] = "PK_NUMBER";
@@ -328,6 +339,7 @@
dictionary["鐘舵�佹姤鍛婂洖鎵ф椂闂�"] = "OP_DELIVER_TIME";
dictionary["鍐呭"] = "MSG_CONTENT";
dictionary["鐘舵��"] = "STAT";
+ dictionary["鑰楁椂"] = "OUT_TIME";
webTool.Export(dataTable, dictionary, "鏃ュ織_" + sDate, this.Context.Response);
}
}
--
Gitblit v1.9.1