导出意向客户

username@email.com

2021-08-20 0bf2b0862dad1b4b71261c38ea1d9aad68921ca4

 zhengcaioa/zhengcaioa/Controllers/Customer/IntentionCustomerController.cs

@@ -16,6 +16,11 @@
using zhengcaioa.Models;
using zhengcaioa.IService;
using System.Transactions;
using OfficeOpenXml;
using OfficeOpenXml.Drawing;
using OfficeOpenXml.Drawing.Chart;
using OfficeOpenXml.Style;
using System.IO;

namespace zhengcaioa.Controllers.Customer
{
@@ -113,6 +118,15 @@
            actionlist.Add(actionEntity6);


            ActionEntity actionEntity7 = new ActionEntity();
            actionEntity7.OpenType = 0;
            actionEntity7.ActionUrl = "";
            actionEntity7.ActionFun = "Daochu";
            actionEntity7.PageIco = "";
            actionEntity7.ActionName = "导出";
            actionlist.Add(actionEntity7);


            ViewData["ActionInfo"] = actionlist;


@@ -136,6 +150,76 @@
        {
            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());
            return new JsonResult(_intentionCustomerService.SearchByPaging(search));
        }


        //[HttpGet("excel")]
        public IActionResult GetDaochu(IntentionCustomerDTOSearch search)
        {
          
            search.page = 1;
            search.rows = 10000;
         var aaa =    _intentionCustomerService.SearchByPaging(search);
          var data1 =   aaa.DataList;

            ExcelPackage.LicenseContext = OfficeOpenXml.LicenseContext.NonCommercial;
            using var ep = new ExcelPackage();

            //添加sheet
            using var worksheet = ep.Workbook.Worksheets.Add("档案客户资料");

           

            int x = 1;
            int y = 1;
            var columnTitles = new List<string>()
            {
                /*"建档时间",*/"客户单位","详细地址","联系电话","电子邮箱","客户微信"
            };
            foreach(var columnTitle in columnTitles)
            {
                //设置样式
                var cell = worksheet.Cells[x, y++];
                cell.Style.Font.Bold = true;
                cell.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
                cell.Style.VerticalAlignment = ExcelVerticalAlignment.Center;
                cell.Value = columnTitle;
            }
            foreach (var item in data1)
            {
                x++;
                y = 1;
                var cell = worksheet.Cells[x, y++];
                //cell.Value = item.CreatetimeName;
                //cell = worksheet.Cells[x, y++];
                cell.Value = item.Name;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Address;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Tel;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Email;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Weixin;


            }

            worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns();

            using (var stream = new MemoryStream())
            {
                ep.SaveAs(stream);
                return new FileContentResult(stream.ToArray(),
                "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
                {
                    FileDownloadName = "导出档案客户资料" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx"
                };
            }




        }


@@ -425,7 +509,7 @@
        public IActionResult print(IntentionCustomerDTOSearch search)
        {
            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());
            search.rows = 1000;
            search.rows = 10000;
            search.page = 1;
            ViewBag.listLiaotianDTO = _intentionCustomerService.SearchByPaging(search).DataList as List<IntentionCustomerDTO>;