优化产品及产品分类，订单，对称加密，IP转地区名称

yzh

2022-05-26 3b18a48485f7207438d9d0eb3038d979e069431d

 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["接入点ID"] = "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);
        }
    }