计件登记，汇总，打印

username@email.com

2022-01-04 0c7b13e91cd472e21e4a620355e6fcabc11f695a

 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;


@@ -139,6 +153,102 @@
        }


        //[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>()
            {
                "建档时间","客户来源","行业分类","客户类型","客户名称","客户单位","联系人微信"
                ,"客户地址","网址","联系人座机","联系人手机","联系人QQ","联系人邮箱",

                "联系人2姓名","联系人2手机","联系人2QQ"

            };
            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.KhlyName;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.HyflName;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.KhlxName;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Name;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Name;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Weixin;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Address;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Url;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Tel;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Phone;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Qq;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.Email;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.YwName;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.YwTel;
                cell = worksheet.Cells[x, y++];
                cell.Value = item.YwQq;



            }

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




        }


        public IActionResult IndexYiXiang()
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
@@ -162,6 +272,14 @@
                actionEntity.ActionName = pageEntity.PageName;
                actionlist.Add(actionEntity);
            }

            ActionEntity actionEntity4 = new ActionEntity();
            actionEntity4.OpenType = 0;
            actionEntity4.ActionUrl = "";
            actionEntity4.ActionFun = "Duanxin";
            actionEntity4.PageIco = "";
            actionEntity4.ActionName = "群发短信";
            actionlist.Add(actionEntity4);

            ViewData["ActionInfo"] = actionlist;

@@ -332,6 +450,14 @@
                data.Creater = curentuser.Id;
                data.Createtime = DateTime.Now;
            }
            else
            {
                var intentionCustomerDTO = _intentionCustomerService.Get(data.Id);
                data.Yixiangtime = intentionCustomerDTO.Yixiangtime;
                data.Yixiang = intentionCustomerDTO.Yixiang;
                data.Dianxiaozhuanyuan = intentionCustomerDTO.Dianxiaozhuanyuan;
                data.Zuijinzhuizongtime = intentionCustomerDTO.Zuijinzhuizongtime;
            }
            data.Modifier = curentuser.Id;
            data.Modifytime = DateTime.Now;

@@ -425,7 +551,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>;