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 | 220 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 220 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 242c3ec..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
{
@@ -60,6 +64,11 @@
{
try
{
+ if (Request["isSession"] != null)
+ {
+ if (!IsPostBack && !IsCallback)
+ Session["OrderList"] = null;
+ }
if (Request["downId"] != null)
{
int iDownId = Convert.ToInt32(Request["downId"]);
@@ -104,6 +113,9 @@
{
case "AcceptOrder":
Accept();
+ break;
+ case "SuodanOrder":
+ Suodan();
break;
case "AcceptOrderAll":
AcceptAll();
@@ -276,6 +288,25 @@
{
}
Response.Write(_eC_OrderBasicBLL.AcceptOrder(orderId.Value, commission.Value) ? "1" : "0");
+ }
+
+
+ /// <summary>
+ /// 閿佸崟
+ /// </summary>
+ private void Suodan()
+ {
+ Response.Clear();
+ int? orderId = string.IsNullOrEmpty(Request["id"]) ? null : MyConvert.ConvertToInt32(Request["id"]);
+ if (!orderId.HasValue)
+ {
+ Response.Write("-2");
+ return;
+ }
+ else
+ {
+ }
+ Response.Write(_eC_OrderBasicBLL.SuodingOrder(orderId.Value, CurrentUser.ShortName) ? "1" : "0");
}
/// <summary>
@@ -529,7 +560,76 @@
SetParamValue(searchParam, 19, CurrentUser.TrueMemberId);
SetParamValue(searchParam, 20, CurrentUser.StaffId);
SetParamValue(searchParam, 21, CurrentUser.TrueName);
+ SetParamValue(searchParam, 28, this.txtSearchyjname.Value);
+ if (!IsPostBack && !IsCallback)
+ {
+ if (Session["OrderList"] != null)
+ {
+ //鍏堣繕鍘熻〃鍗�
+ searchParam = Session["OrderList"] as Dictionary<int, object>;
+ if (searchParam.Keys.Count(x => x == 4)<=0)
+ {
+ this.txtBeginData.Value = "";
+ }
+ if (searchParam.Keys.Count(x => x == 5) <= 0)
+ {
+ this.txtEndDate.Value = "";
+ }
+ foreach (int index in searchParam.Keys)
+ {
+ if (index == 2)
+ this.txtOrderId.Value = searchParam[index].ToString();
+ if (index == 3)
+ this.txtCustormerName.Value = searchParam[index].ToString();
+ if (index == 4)
+ this.txtBeginData.Value = searchParam[index].ToString();
+ if (index == 5)
+ this.txtEndDate.Value = searchParam[index].ToString();
+ if (index == 6)
+ this.selPrintTypes.Value = searchParam[index].ToString();
+ if (index == 7)
+ this.selOrderTypes.Value = searchParam[index].ToString();
+ if (index == 8)
+ this.selOrderStates.Value = searchParam[index].ToString();
+ if (index == 9)
+ this.selPayStates.Value = searchParam[index].ToString();
+ if (index == 10)
+ this.txtCreaterName.Value = searchParam[index].ToString();
+ if (index == 11)
+ this.selCustormerLevels.Value = searchParam[index].ToString();
+ if (index == 12)
+ this.selCustormerManager.Value = searchParam[index].ToString();
+ if (index == 13)
+ this.selBusinessManager.Value = searchParam[index].ToString();
+ if (index == 14)
+ this.selPayType.SelectedValue = searchParam[index].ToString();
+ if (index == 15)
+ this.selReturnvisit.SelectedValue = searchParam[index].ToString();
+ if (index == 16)
+ this.selAppraise.SelectedValue = searchParam[index].ToString();
+ if (index == 28)
+ this.txtSearchyjname.Value = searchParam[index].ToString();
+
+ }
+
+
+
+
+ SetParamValue(searchParam, 1, CurrentUser.MemberId);
+ SetParamValue(searchParam, 18, (CurrentUser.StaffId > 0 ? 1 : 0));
+ SetParamValue(searchParam, 19, CurrentUser.TrueMemberId);
+ SetParamValue(searchParam, 20, CurrentUser.StaffId);
+ SetParamValue(searchParam, 21, CurrentUser.TrueName);
+ SetParamValue(searchParam, 28, this.txtSearchyjname.Value);
+ }
+ }
+ else
+ {
+ Session["OrderList"] = searchParam;
+ }
SearchParam = searchParam;
+
+
UCPager1.AspNetPager.CurrentPageIndex = 1;//閲嶇疆椤垫暟
//鍐嶆鏌ヨ
AspNetPager_PageChanged(UCPager1.AspNetPager, new EventArgs());
@@ -684,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