using Autofac.Core;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using Newtonsoft.Json;
using NPOI.SS.UserModel;
using NPOI.SS.Util;
using NPOI.XSSF.UserModel;
using Ropin.Inspection.Api.Common;
using Ropin.Inspection.Model;
using Ropin.Inspection.Model.SearchModel;
using Ropin.Inspection.Model.ViewModel;
using Ropin.Inspection.Model.ViewModel.DEV;
using Ropin.Inspection.Service.Interface;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Threading.Tasks;
namespace Ropin.Inspection.Api.Controllers
{
public class ReportController : BaseController
{
public ILogger<ReportController> _logger { get; }
private readonly IReportService _service;
/// <summary>
/// 构造函数
/// </summary>
/// <param name="service"></param>
/// <param name="logger"></param>
public ReportController(IReportService service, ILogger<ReportController> logger)
{
_service = service;
_logger = logger;
}
/// <summary>
/// 通过ID获取报表信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
[HttpGet("GetReportDataAsync/{id}")]
public async Task<ApiResult> GetReportDataAsync(Guid id)
{
if (Guid.Empty == id)
{
return new ApiResult(ReturnCode.GeneralError);
}
try
{
object Report = await _service.GetReportDataByIdAsync(id);
return new ApiResult<object>(Report);
}
catch (Exception ex)
{
return new ApiResult(ReturnCode.GeneralError, ex.Message);
}
}
/// <summary>
/// 条件获取报表记录，不包含报表数据,带分页
/// </summary>
/// <param name="searchModel"></param>
/// <returns></returns>
[HttpPost("GetWithoutReportData")]
public async Task<ApiResult> GetWithoutReportData(ReportSearchModel searchModel)
{
if (searchModel == null)
{
return new ApiResult(ReturnCode.ArgsError);
}
try
{
var reportList = await _service.GetWithoutReportData(searchModel);
return new ApiResult<PagesModel<ReportViewModel>>(new PagesModel<ReportViewModel>(reportList?.ToList(), searchModel));
}
catch (Exception ex)
{
return new ApiResult(ReturnCode.GeneralError, ex.Message);
}
}
/// <summary>
/// 更新巡检记录
/// </summary>
/// <param name="id"></param>
/// <param name="updateModel"></param>
/// <returns></returns>
[HttpPut("UpdateReportAsync/{id}")]
public async Task<ApiResult> UpdateReportAsync(Guid id, ReportUpdateViewModel updateModel)
{
if (Guid.Empty == id|| updateModel == null)
{
return new ApiResult(ReturnCode.GeneralError);
}
try
{
await _service.UpdateAsync(id, updateModel);
}
catch (Exception ex)
{
return new ApiResult(ReturnCode.GeneralError, ex.Message);
}
return new ApiResult(ReturnCode.Success);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
[HttpDelete("DeleteReportAsync/{id}")]
public async Task<ApiResult> DeleteReportAsync(Guid id)
{
if (Guid.Empty == id)
{
return new ApiResult(ReturnCode.GeneralError);
}
try
{
await _service.DeleteAsync(id);
}
catch (Exception ex)
{
return new ApiResult(ReturnCode.GeneralError, ex.Message);
}
return new ApiResult(ReturnCode.Success);
}
/// <summary>
/// 导出报表-Excel
/// </summary>
/// <param name="id"></param>
/// <param name="OrgName"></param>
/// <param name="StoreName"></param>
/// <returns></returns>
[HttpPost("ReportExportExcel")]
[AllowAnonymous]
public async Task<IActionResult> ReportExportExcel(Guid id,string OrgName,string StoreName)
{
if (Guid.Empty == id)
{
throw new Exception("参数不能为空值");
}
try
{
ReportViewModel model = await _service.GetByIdAsync(id);
if (model == null)
{
throw new Exception("没有此报表");
}
object Report= await _service.GetReportDataByIdAsync(id);
IWorkbook workbook = new XSSFWorkbook();
ISheet sheet = workbook.CreateSheet();
#region 标题-第一行
//标题加粗居中.
IFont font = workbook.CreateFont();
font.IsBold = true;
font.FontHeightInPoints = 22;
font.FontName = "宋体";
ICellStyle titleCellStyle = workbook.CreateCellStyle();
titleCellStyle.SetFont(font);
titleCellStyle.Alignment = HorizontalAlignment.Center; //字体居中
titleCellStyle.VerticalAlignment = VerticalAlignment.Center;//字体上下居中
//边框
titleCellStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
titleCellStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
titleCellStyle.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
titleCellStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
titleCellStyle.WrapText = true;
#endregion
#region 说明 -
//标题加粗居中.
IFont font0 = workbook.CreateFont();
font0.IsBold = false;
font0.FontHeightInPoints = 14;
font0.FontName = "宋体";
ICellStyle headCellStyle1 = workbook.CreateCellStyle();
headCellStyle1.SetFont(font0);
headCellStyle1.Alignment = HorizontalAlignment.Left; //字体左右居左
headCellStyle1.VerticalAlignment = VerticalAlignment.Center;//字体上下居中
//边框
headCellStyle1.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
headCellStyle1.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
headCellStyle1.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
headCellStyle1.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
headCellStyle1.WrapText = true;
#endregion
#region 表头 -
//标题加粗居中.
IFont font1 = workbook.CreateFont();
font1.IsBold = true;
font1.FontHeightInPoints = 14;
font1.FontName = "宋体";
ICellStyle headCellStyle = workbook.CreateCellStyle();
headCellStyle.SetFont(font1);
headCellStyle.Alignment = HorizontalAlignment.Center; //字体左右居中
headCellStyle.VerticalAlignment = VerticalAlignment.Center;//字体上下居中
//边框
headCellStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
headCellStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
headCellStyle.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
headCellStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
headCellStyle.WrapText = true;
#endregion
#region 内容 -
//标题加粗居中.
IFont font2 = workbook.CreateFont();
font2.IsBold = false;
font2.FontHeightInPoints = 12;
font2.FontName = "宋体";
ICellStyle rowCellStyle = workbook.CreateCellStyle();
rowCellStyle.SetFont(font2);
rowCellStyle.Alignment = HorizontalAlignment.Center; //字体居中
rowCellStyle.VerticalAlignment = VerticalAlignment.Center;//字体上下居中
//边框
rowCellStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
rowCellStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
rowCellStyle.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
rowCellStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
rowCellStyle.WrapText = true;
#endregion
string TitelName = model.C_DevName+"点检工单记录表"+(string.IsNullOrEmpty(model.C_DevNumber)?"":"（设备编号："+model.C_DevNumber+" ）");
if (model.I_Type==5)
{
IRow title = sheet.CreateRow(0);
title.Height = 30 * 25;
title.CreateCell(0).SetCellValue(TitelName);
foreach (var item in title.Cells)
{
item.CellStyle = titleCellStyle;
}
// 合并列示例，合并第 1 行的第 0 列到第 15 列
sheet.AddMergedRegion(new CellRangeAddress(0, 0, 0, 4));
IRow row3 = sheet.CreateRow(3);
row3.CreateCell(0).SetCellValue("序号");
row3.CreateCell(1).SetCellValue("设备和设施");
row3.CreateCell(2).SetCellValue("巡视检查内容");
row3.CreateCell(3).SetCellValue("巡检状态");
row3.CreateCell(4).SetCellValue("维护维修记录");
foreach (var item in row3.Cells)
{
item.CellStyle = headCellStyle;
}
string UserName = "";
IEnumerable<InspectionWorkOrderModel> Report3 =(IEnumerable<InspectionWorkOrderModel>)Report;
if (Report3 == null || Report3.Count() == 0)
{
IRow row4 = sheet.CreateRow(4);
row4.CreateCell(0).SetCellValue("暂无数据");
row4.CreateCell(1).SetCellValue("");
row4.CreateCell(2).SetCellValue("");
row4.CreateCell(3).SetCellValue("");
row4.CreateCell(4).SetCellValue("");
foreach (var item in row4.Cells)
{
item.CellStyle = rowCellStyle;
}
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(4, 4, 0, 4));
}
else
{
int seriaNum = 1;int rowsNumber = 4;
List<string> nameList= new List<string>();
foreach (var item in Report3)
{
if (item.ContentRecordList != null&&item.ContentRecordList.Count()>0)
{
int mergeRowNum = 0;
foreach (var index in item.ContentRecordList)
{
if (index != null)
{
nameList.AddRange(index.UserName);
IRow rows = sheet.CreateRow(rowsNumber);
if (mergeRowNum == 0)
{
rows.CreateCell(0).SetCellValue(seriaNum);
rows.CreateCell(1).SetCellValue(item.PatrolItem);
rows.CreateCell(4).SetCellValue(item.Remark);
}
else
{
rows.CreateCell(0).SetCellValue("");
rows.CreateCell(1).SetCellValue("");
rows.CreateCell(4).SetCellValue("");
}
rows.CreateCell(2).SetCellValue(index.Name);
//string tick = "\u2713"; // 对勾的Unicode编码 "✓"; // 对勾
//string cross = "\u2718"; // 叉号的Unicode编码 "✘"; // 叉号
string FuHao = "\u25EF"; // 输出：◯
switch (index.CheckStatus)
{
case "3": FuHao = "\u2717"; break;
case "0":
case "1":
case "2":
case "4": FuHao = "✓"; break;
default: FuHao = "\u25EF"; break;
}
rows.CreateCell(3).SetCellValue(FuHao);
foreach (var cel in rows.Cells)
{
cel.CellStyle = rowCellStyle;
}
rowsNumber++;
mergeRowNum++;
}
}
if (mergeRowNum > 1)
{
sheet.AddMergedRegion(new CellRangeAddress(rowsNumber - mergeRowNum, rowsNumber - 1, 0, 0));
sheet.AddMergedRegion(new CellRangeAddress(rowsNumber - mergeRowNum, rowsNumber - 1, 1, 1));
sheet.AddMergedRegion(new CellRangeAddress(rowsNumber - mergeRowNum, rowsNumber - 1, 4, 4));
}
seriaNum++;
}
}
UserName = string.Join("；", nameList.Distinct());
IRow rown = sheet.CreateRow(rowsNumber);
rown.Height = 30 * 20;
rown.CreateCell(0).SetCellValue("使用部门确认：");
rown.CreateCell(1).SetCellValue("");
rown.CreateCell(2).SetCellValue("");
rown.CreateCell(3).SetCellValue("日期： 年 月 日");
rown.CreateCell(4).SetCellValue("");
foreach (var item in rown.Cells)
{
item.CellStyle = headCellStyle1;
}
// 合并列示例，合并第 2 行的第 0 列到第 2 列
sheet.AddMergedRegion(new CellRangeAddress(rowsNumber, rowsNumber, 0, 2));
// 合并列示例，合并第 2 行的第 3 列到第 4 列
sheet.AddMergedRegion(new CellRangeAddress(rowsNumber, rowsNumber, 3, 4));
IRow rown1 = sheet.CreateRow(rowsNumber+1);
rown1.CreateCell(0).SetCellValue("巡检状态说明： ✓ = 已检查且正常； ✘ = 已检查且异常； ◯ = 未检查");
// 合并列示例，合并第 2 行的第 0 列到第 2 列
sheet.AddMergedRegion(new CellRangeAddress(rowsNumber+1, rowsNumber+1, 0, 4));
}
IRow row1 = sheet.CreateRow(1);
row1.Height = 30 * 15;
row1.CreateCell(0).SetCellValue("使用部门：" + StoreName);
row1.CreateCell(1).SetCellValue("");
row1.CreateCell(2).SetCellValue("");
row1.CreateCell(3).SetCellValue("维保时间：" + model.D_CreateTime.ToString("yyyy年MM月dd日"));
row1.CreateCell(4).SetCellValue("");
IRow row2 = sheet.CreateRow(2);
row2.Height = 30 * 15;
row2.CreateCell(0).SetCellValue("服务公司：" + OrgName);
row2.CreateCell(1).SetCellValue("");
row2.CreateCell(2).SetCellValue("");
row2.CreateCell(3).SetCellValue("维保人员："+ UserName);
row2.CreateCell(4).SetCellValue("");
foreach (var item in row1.Cells)
{
item.CellStyle = headCellStyle1;
}
foreach (var item in row2.Cells)
{
item.CellStyle = headCellStyle1;
}
// 合并列示例，合并第 2 行的第 0 列到第 2 列
sheet.AddMergedRegion(new CellRangeAddress(1, 1, 0, 2));
// 合并列示例，合并第 2 行的第 3 列到第 4 列
sheet.AddMergedRegion(new CellRangeAddress(1, 1, 3, 4));
// 合并列示例，合并第 3 行的第 0 列到第 2 列
sheet.AddMergedRegion(new CellRangeAddress(2, 2, 0, 2));
// 合并列示例，合并第 3 行的第 3 列到第 4 列
sheet.AddMergedRegion(new CellRangeAddress(2, 2, 3, 4));
}
// 自适应单元格
//for (int i = 4; i < sheet.LastRowNum; i++)
//{
// sheet.AutoSizeRow(i);
//}
for (int i = 0; i < 5; i++)
{
if (i == 0)
{
sheet.SetColumnWidth(i, 256 * 10);
}
else if(i==2)
{
sheet.SetColumnWidth(i, 256 * 55);
}
else if (i == 4)
{
sheet.SetColumnWidth(i, 256 * 35);
}
else
{
sheet.SetColumnWidth(i, 256 * 22);
}
}
using (MemoryStream stream = new MemoryStream())
{
workbook.Write(stream);
byte[] data = stream.ToArray();
return File(data, "application/vnd.ms-excel", $"{model.C_Name}.xlsx");
}
}
catch (Exception ex)
{
throw new Exception("导出Excel数据异常："+ex.Message);
}
}
}
}