From fad59c96add549467aeb66a0e1c39950886ce02b Mon Sep 17 00:00:00 2001
From: wangsheng <123456>
Date: 星期日, 26 九月 2021 15:37:36 +0800
Subject: [PATCH] 优化导出功能
---
web/web/ExportDocument.aspx.cs | 27 +++++++++++++++++++++++----
1 files changed, 23 insertions(+), 4 deletions(-)
diff --git a/web/web/ExportDocument.aspx.cs b/web/web/ExportDocument.aspx.cs
index 0effa22..af68933 100644
--- a/web/web/ExportDocument.aspx.cs
+++ b/web/web/ExportDocument.aspx.cs
@@ -302,14 +302,30 @@
this.Response.Write("<script type='text/javascript'>alert('瀵煎嚭鏁版嵁涓嶈兘澶т簬100涓囨潯锛�');location.href='GwSm.aspx';</script>");
this.Response.End();
}
- DataTable dataTable = gwSmDao.LoadSpDataTable(apMid, opName, clientId, spid, mobile, sDate, beginTime, endTime, content, @int, opstat);
+
+ DataTable dataTable = new DataTable();
+ if (this.AppContext.GetString("SendType") == "ReSend")
+ {
+ dataTable= gwSmDao.LoadSpDataTable(apMid, opName, clientId, spid, mobile, sDate, beginTime, endTime, content, @int, opstat, this.AppContext.GetString("SendType"));
+ }
+ else
+ {
+ dataTable = gwSmDao.LoadSpDataTable(apMid, opName, clientId, spid, mobile, sDate, beginTime, endTime, content, @int, opstat);
+ }
+
+ //if(dataTable.Rows.Count>1000000)
+ //{
+ // this.Response.Write("<script type='text/javascript'>alert('瀵煎嚭鏁版嵁涓嶈兘澶т簬100涓囨潯锛�');location.href='GwSm.aspx';</script>");
+ // this.Response.End();
+ //}
+
WebTool webTool = new WebTool();
Dictionary<string, string> dictionary = new Dictionary<string, string>();
dictionary["AP娑堟伅ID"] = "AP_MID";
- dictionary["CLTID"] = "CLIENT_ID";
+ dictionary["浠ｇ悊鍟�"] = "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 +344,9 @@
dictionary["鐘舵�佹姤鍛婂洖鎵ф椂闂�"] = "OP_DELIVER_TIME";
dictionary["鍐呭"] = "MSG_CONTENT";
dictionary["鐘舵��"] = "STAT";
+ dictionary["鐭俊绫诲瀷"] = "ResendStatus";//0==姝ｅ父 1==琛ュ彂
+ dictionary["琛ュ彂鐘舵��"] = "ResendFlag";
+ dictionary["鑰楁椂"] = "OUT_TIME";
webTool.Export(dataTable, dictionary, "鏃ュ織_" + sDate, this.Context.Response);
}
}
--
Gitblit v1.9.1