From 0bf2b0862dad1b4b71261c38ea1d9aad68921ca4 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 20 八月 2021 16:17:27 +0800
Subject: [PATCH] 导出意向客户
---
zhengcaioa/zhengcaioa/zhengcaioa.csproj | 1
zhengcaioa/zhengcaioa/Views/IntentionCustomer/Index.cshtml | 51 +++++++++++++---
zhengcaioa/zhengcaioa/Controllers/Customer/IntentionCustomerController.cs | 86 ++++++++++++++++++++++++++++
3 files changed, 127 insertions(+), 11 deletions(-)
diff --git a/zhengcaioa/zhengcaioa/Controllers/Customer/IntentionCustomerController.cs b/zhengcaioa/zhengcaioa/Controllers/Customer/IntentionCustomerController.cs
index 9393781..75196cb 100644
--- a/zhengcaioa/zhengcaioa/Controllers/Customer/IntentionCustomerController.cs
+++ b/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>;
diff --git a/zhengcaioa/zhengcaioa/Views/IntentionCustomer/Index.cshtml b/zhengcaioa/zhengcaioa/Views/IntentionCustomer/Index.cshtml
index f832d7e..13788e4 100644
--- a/zhengcaioa/zhengcaioa/Views/IntentionCustomer/Index.cshtml
+++ b/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("淇濆瓨鎴愬姛");
diff --git a/zhengcaioa/zhengcaioa/zhengcaioa.csproj b/zhengcaioa/zhengcaioa/zhengcaioa.csproj
index dde3e9b..075bf65 100644
--- a/zhengcaioa/zhengcaioa/zhengcaioa.csproj
+++ b/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" />
--
Gitblit v1.9.1