From a980cd04341d71216e0f59bd4b7327fe9fc50032 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 21 五月 2025 11:41:46 +0800
Subject: [PATCH] 提交
---
CY_ECommercePlatform/CY.WebForm/Pages/business/InvoicingConfirm.aspx.cs | 251 ++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 242 insertions(+), 9 deletions(-)
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/InvoicingConfirm.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/InvoicingConfirm.aspx.cs
index 1b70e3c..007cb84 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/InvoicingConfirm.aspx.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/InvoicingConfirm.aspx.cs
@@ -29,6 +29,10 @@
using CY.BLL;
using CY.WebForm.Pages.common;
using System.Transactions;
+using CY.Infrastructure.Query;
+using NPOI.SS.UserModel;
+using NPOI.XSSF.UserModel;
+using System.IO;
namespace CY.WebForm.Pages.business
{
@@ -39,6 +43,7 @@
LF_OrderFileBLL _lF_OrderFileBLL = null;
EC_OrderBLL _eC_OrderBLL = null;
OA_KaipiaoshenqingBLL oA_KaipiaoshenqingBLL = null;
+
/// <summary>
/// 鍒濆鍖栨瀯閫�
/// </summary>
@@ -259,19 +264,123 @@
private void Accept()
{
Response.Clear();
- PayAbout payAbout = new PayAbout();
- payAbout.LoadNewestPaymentAccount(true);
- double? commission = MyConvert.ConvertToDouble(CY.Config.WebInfo.Instance.FirmOrderAgencyFee);
- int? orderId = string.IsNullOrEmpty(Request["id"]) ? null : MyConvert.ConvertToInt32(Request["id"]);
- if (!orderId.HasValue || !commission.HasValue)
+
+
+ var orderId = string.IsNullOrEmpty(Request["id"]) ? Guid.Empty : MyConvert.ConvertToGuid(Request["id"]);
+ if ( orderId == Guid.Empty)
{
Response.Write("-2");
return;
}
+
+
+
+ var a_Kaipiaoshenqing = oA_KaipiaoshenqingBLL.GetModelByKeyid(orderId);
+
+ if (a_Kaipiaoshenqing !=null )
+ {
+ if(a_Kaipiaoshenqing.Kaipiaoshenqing == 3)
+ {
+ Response.Write("宸插紑绁紝鏃犳硶鎾ゅ洖锛�");
+ return;
+ }
+ if(a_Kaipiaoshenqing.Shenqingleixing == "璁㈠崟寮�绁�")
+ {
+ Dictionary<int, object> searchParam = new Dictionary<int, object>();
+
+ SetParamValue(searchParam, 1, CurrentUser.MemberId);
+ SetParamValue(searchParam, 2, "");
+ SetParamValue(searchParam, 3, "");
+ SetParamValue(searchParam, 4, "");
+ SetParamValue(searchParam, 5, "");
+ SetParamValue(searchParam, 6, "");
+ SetParamValue(searchParam, 7, "");
+ SetParamValue(searchParam, 8, "");
+ SetParamValue(searchParam, 9, "");
+ SetParamValue(searchParam, 10, "");
+ SetParamValue(searchParam, 11, "");
+ SetParamValue(searchParam, 12, "");
+ SetParamValue(searchParam, 13, "");
+ SetParamValue(searchParam, 14, "");
+ SetParamValue(searchParam, 15, "");
+ SetParamValue(searchParam, 16, "");
+ SetParamValue(searchParam, 18, 0);
+ SetParamValue(searchParam, 19, CurrentUser.TrueMemberId);
+ SetParamValue(searchParam, 20, CurrentUser.StaffId);
+ SetParamValue(searchParam, 21, CurrentUser.TrueName);
+ SetParamValue(searchParam, 22, "");
+ SetParamValue(searchParam, 23, "");
+ SetParamValue(searchParam, 24, "");
+ SetParamValue(searchParam, 25, "");
+ SetParamValue(searchParam, 26, a_Kaipiaoshenqing.Keyid);
+ SetParamValue(searchParam, 29, "");
+
+
+
+ SearchParam = searchParam;
+
+
+
+ Infrastructure.Query.Pagination pagination = new Infrastructure.Query.Pagination()
+ {
+ PageSize = 1000,
+ PageIndex = 1
+ };
+ IEnumerable<EC_OrderBasic> result = _eC_OrderBasicBLL.SelectModelPage_Seller(pagination, SearchParam);
+
+ var PayedMoney = result.Sum(x => x.TradingSingle.PayedMoney);
+ if (PayedMoney.HasValue && PayedMoney > 0)
+ {
+ Response.Write("宸茬粡鏈夊洖娆捐褰曪紝鏃犳硶鎾ゅ洖锛�");
+ return;
+ }
+
+ }
+ else
+ {
+ if (a_Kaipiaoshenqing.Kehumoney.HasValue && a_Kaipiaoshenqing.Kehumoney.Value > 0)
+ {
+ Response.Write("宸茬粡鏈夊洖娆捐褰曪紝鏃犳硶鎾ゅ洖锛�");
+ return;
+ }
+
+ }
+ var sss = oA_KaipiaoshenqingBLL.DeleteModel(a_Kaipiaoshenqing);
+ if (!sss)
+ {
+ Response.Write("鎾ゅ洖澶辫触锛�");
+ return;
+ }
+ if (a_Kaipiaoshenqing.Shenqingleixing == "璁㈠崟寮�绁�")
+ {
+ EC_OrderExtend model = new EC_OrderExtend();
+ model.KaipiaoshenqingId = a_Kaipiaoshenqing.Keyid;
+ model.KaipiaoshenqingTime = null;
+ model.Kaipiaoshenqing = 2;
+ model.KaipiaoshenqingCreater = Guid.Empty;
+
+ sss = _eC_OrderBLL.NewUpdateKaipiaoshenqings(model);
+
+ if (!sss)
+ {
+ Response.Write("鎾ゅ洖澶辫触锛�");
+ return;
+ }
+ }
+
+
+
+ }
else
{
+ Response.Write("鎾ゅ洖澶辫触锛�");
+ return;
}
- Response.Write(_eC_OrderBasicBLL.AcceptOrder(orderId.Value, commission.Value) ? "1" : "0");
+
+
+
+
+ Response.Write( "1");
}
/// <summary>
@@ -474,7 +583,7 @@
//this.selKaipiaoshenqing.Value = "1";
//this.selPayStates.Value = "1";
- //this.selHuikuanStates.Value = "1";
+ this.selHuikuanStates.Value = "1";
@@ -485,8 +594,8 @@
this.selBusinessManager.Items.Insert(0, new ListItem("鍏ㄩ儴", ""));
//this.selBusinessManager.Items.Insert(1, new ListItem(CurrentUser.ShortName, CurrentUser.ShortName));
- this.txtSQBeginDate.Value = DateTime.Now.AddDays(-14).ToString("yyyy-MM-dd");
- this.txtSQEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
+ //this.txtSQBeginDate.Value = DateTime.Now.AddDays(-14).ToString("yyyy-MM-dd");
+ //this.txtSQEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
//鍒濇鏁版嵁鍔犺浇
btn_Search_Click(btn_Search, new EventArgs());
@@ -585,9 +694,133 @@
rptData.DataSource = result;
rptData.DataBind();
+ if (pagination.heji1.HasValue)
+ {
+ this.AllMoney.InnerText = pagination.heji1.Value.ToString("0.00");
+ }
+ else
+ {
+ this.AllMoney.InnerText = 0.ToString("0.00");
+ }
+
+ if (pagination.heji2.HasValue)
+ {
+ this.ZengMoney.InnerText = pagination.heji2.Value.ToString("0.00");
+ }
+ else
+ {
+ this.ZengMoney.InnerText = 0.ToString("0.00");
+ }
+
+ if (pagination.heji3.HasValue)
+ {
+ this.HuiMoney.InnerText = pagination.heji3.Value.ToString("0.00");
+ }
+ else
+ {
+ this.HuiMoney.InnerText = 0.ToString("0.00");
+ }
+
UCPager1.AspNetPager.RecordCount = pagination.RecordCount;
}
+
+
+ //鏌ヨ浜嬩欢
+ 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 = 1000;
+ pa.PageIndex = 1;
+
+
+
+ IEnumerable<OA_Kaipiaoshenqing> results = oA_KaipiaoshenqingBLL.SelectModelPage(pa, CurrentUser.MemberId, this.txtSQBeginDate.Value, this.txtSQEndDate.Value, this.selKaipiaoshenqing.Value, this.selKehuqianshou.Value, this.selBusinessManager.Value, this.txtCustormerName.Value, this.selPayStates.Value, this.selHuikuanStates.Value);
+
+
+ // 鍒涘缓宸ヤ綔绨�
+ 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("寮�绁ㄧ姸鎬�");
+
+
+ // 娣诲姞鏁版嵁
+ int rowIndex = 1;
+ foreach (var oA_Kaipiaoshenqing in results)
+ {
+ IRow row = sheet.CreateRow(rowIndex++);
+ row.CreateCell(0).SetCellValue((rowIndex - 1).ToString());
+ row.CreateCell(1).SetCellValue(oA_Kaipiaoshenqing.CreateTime.Value.ToString("yyyy-MM-dd"));
+ row.CreateCell(2).SetCellValue(oA_Kaipiaoshenqing.Shenqingleixing);
+ row.CreateCell(3).SetCellValue(oA_Kaipiaoshenqing.BusinessManager);
+ row.CreateCell(4).SetCellValue(oA_Kaipiaoshenqing.BuyerName);
+ row.CreateCell(5).SetCellValue(oA_Kaipiaoshenqing.Fapiaohao);
+ row.CreateCell(6).SetCellValue(oA_Kaipiaoshenqing.Dingdanshu.HasValue? oA_Kaipiaoshenqing.Dingdanshu.Value.ToString():"");
+ row.CreateCell(7).SetCellValue(oA_Kaipiaoshenqing.kpmoney.HasValue ? oA_Kaipiaoshenqing.kpmoney.Value.ToString() : "0");
+ row.CreateCell(8).SetCellValue(oA_Kaipiaoshenqing.Zengjianmoney.HasValue ? oA_Kaipiaoshenqing.Zengjianmoney.Value.ToString() : "0");
+ row.CreateCell(9).SetCellValue(oA_Kaipiaoshenqing.Huikuanmoney.HasValue ? oA_Kaipiaoshenqing.Huikuanmoney.Value.ToString() : "0");
+ row.CreateCell(10).SetCellValue(oA_Kaipiaoshenqing.ShoukuanTime.HasValue? oA_Kaipiaoshenqing.ShoukuanTime.Value.ToString("MM-dd HH:mm") : "");
+ row.CreateCell(11).SetCellValue(oA_Kaipiaoshenqing.KaipiaoshenqingName);
+
+
+
+ }
+
+ // 灏嗗伐浣滅翱鍐欏叆鍐呭瓨娴�
+ using (var ms = new MemoryStream())
+ {
+ workbook.Write(ms);
+ bt = ms.ToArray();
+ }
+ }
+ catch (Exception e)
+ {
+ bt = null;
+ // 璁板綍鏃ュ織
+
+ }
+ return bt;
+ }
+
+
/// <summary>
/// 鏌ヨ鍙傛暟
/// </summary>
--
Gitblit v1.9.1