From e76da58d55a18a746d021fd96351c48cc9648d7c Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期六, 09 十月 2021 11:37:56 +0800
Subject: [PATCH] 产品管理导出优化
---
web/web/ExportDocument.aspx.cs | 41 ++++++++++++++++++++++++++++++++++++++---
1 files changed, 38 insertions(+), 3 deletions(-)
diff --git a/web/web/ExportDocument.aspx.cs b/web/web/ExportDocument.aspx.cs
index 0effa22..7ce3bc4 100644
--- a/web/web/ExportDocument.aspx.cs
+++ b/web/web/ExportDocument.aspx.cs
@@ -25,6 +25,9 @@
case "exportGwStatisV3"://瀵煎嚭缁熻鎶ヨ〃
this.ExprortGwStatisV3();
break;
+ case "exGwProduct":
+ this.ExGwProduct();
+ break;
}
}
@@ -303,13 +306,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["浠ｇ悊鍟�"] = "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,7 +332,38 @@
dictionary["鐘舵�佹姤鍛婂洖鎵ф椂闂�"] = "OP_DELIVER_TIME";
dictionary["鍐呭"] = "MSG_CONTENT";
dictionary["鐘舵��"] = "STAT";
+ dictionary["鑰楁椂"] = "OUT_TIME";
webTool.Export(dataTable, dictionary, "鏃ュ織_" + sDate, this.Context.Response);
}
}
+
+ //浜у搧瀵煎嚭Excel
+ private void ExGwProduct()
+ {
+ string name = this.AppContext.GetString("name");
+ string classes = this.AppContext.GetString("classes");
+ string is_default = this.AppContext.GetString("is_default");
+ string op_group_id = this.AppContext.GetString("op_group_id");
+ using (GwProductDao gwProductDao = new GwProductDao())
+ {
+ DataTable dataTable = gwProductDao.LoadGwProductDataTable(name, classes, is_default, op_group_id);
+ WebTool webTool = new WebTool();
+ Dictionary<string, string> dictionary = new Dictionary<string, string>();
+ //dictionary["浜у搧ID"] = "ID";
+ dictionary["浜у搧鍚嶇О"] = "NAME";
+ //dictionary["鍥炬爣"] = "ICON";
+ dictionary["浣跨敤璇存槑"] = "INSTRUCTIONS";
+ dictionary["绫诲埆"] = "CLASSES";
+ dictionary["鐖剁骇浜у搧鍒嗙被"] = "PARENT_ID";
+ //dictionary["璺緞"] = "PATH";
+ dictionary["鏄惁榛樿"] = "IS_DEFAULT";
+ dictionary["鏄惁鍚敤"] = "IS_ENABLE";
+ dictionary["鎺掑簭"] = "SORT";
+ dictionary["榛樿閫氶亾"] = "OP_GROUP_ID";
+ dictionary["API璐﹀彿鐢熸垚瑙勫垯"] = "API_SP_XH_ID";
+ dictionary["榛樿璧犻�佹潯鏁�"] = "GIVING_NUM";
+ dictionary["澶囨敞"] = "REMARK";
+ webTool.Export(dataTable, dictionary, "PRODUCT_" + (object)DateTime.Now.Ticks, this.Context.Response);
+ }
+ }
}
--
Gitblit v1.9.1