这个账务处理需要导出功能 不能他们不收款

username@email.com

2025-03-14 4a16f96ceaac9b4cf684287cd2865fc3d2966475

 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
{
@@ -579,7 +583,7 @@
                //this.selKaipiaoshenqing.Value = "1";

                //this.selPayStates.Value = "1";
                //this.selHuikuanStates.Value = "1";
                this.selHuikuanStates.Value = "1";
                


@@ -590,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());
@@ -690,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>