导出意向客户

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>;


 zhengcaioa/zhengcaioa/Views/IntentionCustomer/Index.cshtml

@@ -70,18 +70,15 @@
            var AreaId = $("#PBSAreaId").val();
            var Name = $("#PBSName").val();

            var Createtime = $("#PBSCreatetime").val();
            var Creater = $("#PBSCreater").val();
            var Shifouweixin = $("#PBSShifouweixin").val();


            var Createtimestart = $("#PBSCreatetimestart").val();

            var Createtimeend = $("#PBSCreatetimeend").val();
            var Createtime = '';
            if (Createtimestart != '' && Createtimeend != '') {
                Createtime = Createtimestart +'|'+ Createtimeend;
            }


            var url = "/IntentionCustomer/print?Khly=" + Khly + "&Hyfl=" + Hyfl + "&Khlx=" + Khlx + "&Ywjl=" + Ywjl + "&Sheng=" + Sheng + "&City=" + City + "&AreaId=" + AreaId + "&Name=" + Name + "&Createtime=" + Createtime ;
            var url = "/IntentionCustomer/print?Khly=" + Khly + "&Hyfl=" + Hyfl + "&Khlx=" + Khlx + "&Ywjl=" + Ywjl + "&Sheng=" + Sheng + "&City=" + City + "&AreaId=" + AreaId + "&Name=" + Name + "&Createtime=" + Createtime
                + "&Creater=" + Creater + "&Shifouweixin=" + Shifouweixin ;
            var me = window.open(url, "打印");  //打开新窗口


@@ -198,6 +195,40 @@
        }



        var _pageDaochu = function () {


            var Khly = $("#PBSKhly").val();
            var Hyfl = $("#PBSHyfl").val();
            var Khlx = $("#PBSKhlx").val();
            var Ywjl = $("#PBSYwjl").val();
            var Sheng = $("#PBSSheng").val();
            var City = $("#PBSCity").val();
            var AreaId = $("#PBSAreaId").val();
            var Name = $("#PBSName").val();

            var Createtime = $("#PBSCreatetime").val();
            var Creater = $("#PBSCreater").val();
            var Shifouweixin = $("#PBSShifouweixin").val();




            var url = "/IntentionCustomer/GetDaochu?Khly=" + Khly + "&Hyfl=" + Hyfl + "&Khlx=" + Khlx + "&Ywjl=" + Ywjl + "&Sheng=" + Sheng + "&City=" + City + "&AreaId=" + AreaId + "&Name=" + Name + "&Createtime=" + Createtime
                + "&Creater=" + Creater + "&Shifouweixin=" + Shifouweixin;
            var me = window.open(url, "导出");  //打开新窗口



          

           
        }




        var _afterSave = function (result) {
            if (result) {
                toastr.success("保存成功");

 zhengcaioa/zhengcaioa/zhengcaioa.csproj

@@ -164,6 +164,7 @@
    <PackageReference Include="AngleSharp" Version="0.14.0" />
    <PackageReference Include="AutoMapper" Version="10.1.1" />
    <PackageReference Include="AutoMapper.Extensions.Microsoft.DependencyInjection" Version="8.1.0" />
    <PackageReference Include="EPPlus" Version="5.7.3" />
    <PackageReference Include="Grpc.Core" Version="2.36.0" />
    <PackageReference Include="log4net" Version="2.0.12" />
    <PackageReference Include="log4net.AspNetCore" Version="1.0.0" />