From f1b2ef9600a038008e11b151a5cb7cffab336be5 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 28 二月 2025 09:26:26 +0800
Subject: [PATCH] 把这个我们政财里面有个常用资料，常用资料有通讯录和账号密码。把这个也放到川一头去，川饮也需要这个东西，就放在川渝的行政管理好行政管理里面。你二级栏目就是常用资料。
---
CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx.cs | 124 +++++++++++++++++++++++++++++++++++++++++
1 files changed, 124 insertions(+), 0 deletions(-)
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx.cs
index 68ad024..0a891b2 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/OrderList.aspx.cs
@@ -28,6 +28,10 @@
using CY.Infrastructure.Common;
using CY.BLL;
using CY.WebForm.Pages.common;
+using System.IO;
+using CY.Infrastructure.Query;
+using NPOI.SS.UserModel;
+using NPOI.XSSF.UserModel;
namespace CY.WebForm.Pages.business
{
@@ -780,6 +784,126 @@
return isCan;
}
+
+ //鏌ヨ浜嬩欢
+ protected void btn_Daochu_Click(object src, EventArgs e)
+ {
+
+ byte[] fileBytes = ExportToExcel();
+ if (fileBytes != null)
+ {
+ Response.Clear();
+ Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
+ Response.AppendHeader("Content-Disposition", "attachment; filename=璁㈠崟瀵煎嚭.xlsx");
+ Response.BinaryWrite(fileBytes);
+ Response.End();
+ }
+ else
+ {
+ // 澶勭悊瀵煎嚭澶辫触鐨勬儏鍐�
+ Response.Write("瀵煎嚭澶辫触锛岃绋嶅悗閲嶈瘯锛�");
+ }
+
+ }
+
+ public byte[] ExportToExcel()
+ {
+ byte[] bt = null;
+ try
+ {
+ Pagination pa = new Pagination();
+ pa.PageSize = 500;
+ pa.PageIndex = 1;
+
+ Dictionary<int, object> searchParam = new Dictionary<int, object>();
+
+ SetParamValue(searchParam, 1, CurrentUser.MemberId);
+ SetParamValue(searchParam, 2, this.txtOrderId.Value.Trim());
+ SetParamValue(searchParam, 3, this.txtCustormerName.Value.Trim());
+ SetParamValue(searchParam, 4, this.txtBeginData.Value.Trim());
+ SetParamValue(searchParam, 5, this.txtEndDate.Value.Trim());
+ SetParamValue(searchParam, 6, this.selPrintTypes.Value);
+ SetParamValue(searchParam, 7, this.selOrderTypes.Value);
+ SetParamValue(searchParam, 8, this.selOrderStates.Value);
+ SetParamValue(searchParam, 9, this.selPayStates.Value);
+ SetParamValue(searchParam, 10, this.txtCreaterName.Value.Trim());
+ SetParamValue(searchParam, 11, this.selCustormerLevels.Value);
+ SetParamValue(searchParam, 12, this.selCustormerManager.Value);
+ SetParamValue(searchParam, 13, this.selBusinessManager.Value);
+ SetParamValue(searchParam, 14, this.selPayType.SelectedValue);
+ SetParamValue(searchParam, 15, this.selReturnvisit.SelectedValue);
+ SetParamValue(searchParam, 16, this.selAppraise.SelectedValue);
+ SetParamValue(searchParam, 18, (CurrentUser.StaffId > 0 ? 0 : 0));
+ SetParamValue(searchParam, 19, CurrentUser.TrueMemberId);
+ SetParamValue(searchParam, 20, CurrentUser.StaffId);
+ SetParamValue(searchParam, 21, CurrentUser.TrueName);
+ SetParamValue(searchParam, 28, this.txtSearchyjname.Value);
+
+ var oA_WorkPlans = _eC_OrderBasicBLL.SelectModelPage_Seller(pa, searchParam);
+
+
+ // 鍒涘缓宸ヤ綔绨�
+ IWorkbook workbook = new XSSFWorkbook();
+ ISheet sheet = workbook.CreateSheet("瀵煎嚭鏁版嵁");
+
+ // 鍒涘缓琛ㄥご
+ IRow headerRow = sheet.CreateRow(0);
+ headerRow.CreateCell(0).SetCellValue("缂栧彿");
+ headerRow.CreateCell(1).SetCellValue("璁㈠崟鍙�");
+ headerRow.CreateCell(2).SetCellValue("瀹㈡埛鍚嶇О");
+ headerRow.CreateCell(3).SetCellValue("璁㈠崟鏉ユ簮");
+ headerRow.CreateCell(4).SetCellValue("璁㈠崟绫诲埆");
+ headerRow.CreateCell(5).SetCellValue("鍚堝悓搴忓彿");
+ headerRow.CreateCell(6).SetCellValue("鍗颁欢鍚嶇О");
+ headerRow.CreateCell(7).SetCellValue("鏁伴噺");
+ headerRow.CreateCell(8).SetCellValue("鍗曚綅");
+ headerRow.CreateCell(9).SetCellValue("璁㈠崟鐘舵��");
+ headerRow.CreateCell(10).SetCellValue("鏀舵鐘舵��");
+ headerRow.CreateCell(11).SetCellValue("浠樻鏂瑰紡");
+ headerRow.CreateCell(12).SetCellValue("閲戦");
+ headerRow.CreateCell(13).SetCellValue("宸叉敹娆�");
+ headerRow.CreateCell(14).SetCellValue("鏈粯娆�");
+
+ // 娣诲姞鏁版嵁
+ int rowIndex = 1;
+ foreach (var order in oA_WorkPlans)
+ {
+ IRow row = sheet.CreateRow(rowIndex++);
+ row.CreateCell(0).SetCellValue((rowIndex - 1).ToString());
+ row.CreateCell(1).SetCellValue(order.SellerOrderId);
+ row.CreateCell(2).SetCellValue(order.BuyerName);
+ row.CreateCell(3).SetCellValue(order.OrderType.Name);
+ row.CreateCell(4).SetCellValue(order.PrintType.PrintName);
+ row.CreateCell(5).SetCellValue(order.Duiyinghetongbianhao);
+ row.CreateCell(6).SetCellValue(order.DocumentName);
+ row.CreateCell(7).SetCellValue(order.OrderExtend.PrintNum.HasValue? order.OrderExtend.PrintNum.Value:0);
+ row.CreateCell(8).SetCellValue(order.yssldw);
+ row.CreateCell(9).SetCellValue(order.OrderStateObj.Name);
+ row.CreateCell(10).SetCellValue(order.PayStateObj.Name);
+ row.CreateCell(11).SetCellValue(order.PayType);
+ row.CreateCell(12).SetCellValue(order.SumPrice.HasValue? order.SumPrice.Value.ToDouble2().Value:0);
+ row.CreateCell(13).SetCellValue(order.TradingSingle.PayedMoney.HasValue ? order.TradingSingle.PayedMoney.Value.ToDouble2().Value : 0);
+ row.CreateCell(14).SetCellValue(order.UnPayedMoney.ToDouble2().Value);
+
+
+ }
+
+ // 灏嗗伐浣滅翱鍐欏叆鍐呭瓨娴�
+ using (var ms = new MemoryStream())
+ {
+ workbook.Write(ms);
+ bt = ms.ToArray();
+ }
+ }
+ catch (Exception e)
+ {
+ bt = null;
+ // 璁板綍鏃ュ織
+
+ }
+ return bt;
+ }
+
/// <summary>
/// 鏄惁宸茬粡鎿嶄綔
/// </summary>
--
Gitblit v1.9.1