using SmartScanner.ViewModel;
|
using OfficeOpenXml;
|
using OfficeOpenXml.Style;
|
using System;
|
using System.Collections.Generic;
|
using System.Drawing;
|
using System.IO;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using System.Timers;
|
|
namespace SmartScanner
|
{
|
public static class ExcelResultRecorder
|
{
|
private static readonly string reportDirectory = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Reports");
|
private static readonly string reportFileName = $"DetectionResults_{DateTime.Now:yyyyMMdd}.xlsx";
|
private static readonly List<DetectionRecord> _pendingRecords = new List<DetectionRecord>();
|
private static readonly object _lock = new object();
|
private static Timer _autoFlushTimer;
|
static ExcelResultRecorder()
|
{
|
try
|
{
|
// 确保报告目录存在
|
if (!Directory.Exists(reportDirectory))
|
{
|
Directory.CreateDirectory(reportDirectory);
|
}
|
// 设置EPPlus许可证上下文
|
//ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
|
ExcelPackage.License.SetNonCommercialPersonal("Lanbao");
|
InitializeAutoFlush();
|
}
|
catch (Exception ex)
|
{
|
Console.WriteLine($"ExcelResultRecorder初始化失败: {ex.Message}");
|
throw;
|
}
|
}
|
|
public static void RecordDetectionResult(int sequence, string result, string qrCode = "N/A")
|
{
|
lock (_lock)
|
{
|
_pendingRecords.Add(new DetectionRecord
|
{
|
QrCode = qrCode,
|
Sequence = sequence,
|
Result = result,
|
Operator = UserManager.CurrentUser?.Username ?? "Unknown"
|
});
|
|
// 每10条记录或每隔20秒自动保存一次
|
if (_pendingRecords.Count >= 10)
|
{
|
Task.Run(() => FlushRecords());
|
}
|
}
|
}
|
|
public static void FlushRecords()
|
{
|
lock (_lock)
|
{
|
if (_pendingRecords.Count == 0) return;
|
|
try
|
{
|
string filePath = Path.Combine(reportDirectory, reportFileName);
|
|
using (var package = new ExcelPackage(new FileInfo(filePath)))
|
{
|
ExcelWorksheet worksheet = package.Workbook.Worksheets["检测结果"] ??
|
package.Workbook.Worksheets.Add("检测结果");
|
|
// 初始化表头（如果文件是新创建的）
|
if (worksheet.Dimension == null)
|
{
|
CreateHeader(worksheet);
|
}
|
|
// 找到第一个空行
|
int startRow = worksheet.Dimension?.End.Row + 1 ?? 2;
|
// 批量写入数据
|
for (int i = 0; i < _pendingRecords.Count; i++)
|
{
|
var record = _pendingRecords[i];
|
int currentRow = startRow + i;
|
|
worksheet.Cells[currentRow, 1].Value = record.QrCode;
|
worksheet.Cells[currentRow, 2].Value = $"点位 {record.Sequence}";
|
worksheet.Cells[currentRow, 3].Value = record.Result;
|
worksheet.Cells[currentRow, 4].Value = record.DetectionTime.ToString("yyyy-MM-dd HH:mm:ss");
|
worksheet.Cells[currentRow, 5].Value = record.Operator;
|
// 根据结果设置单元格背景色
|
var resultCell = worksheet.Cells[currentRow, 3];
|
resultCell.Style.Fill.PatternType = ExcelFillStyle.Solid;
|
resultCell.Style.Fill.BackgroundColor.SetColor(
|
record.Result == "OK" ? Color.LightGreen : Color.Red);
|
}
|
// 自动调整列宽
|
worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns();
|
|
// 保存文件
|
package.Save();
|
EnhancedLogViewModel.Instance.AddLog($"{_pendingRecords.Count}条检测结果已保存至{reportFileName}");
|
}
|
_pendingRecords.Clear();
|
}
|
catch (Exception ex)
|
{
|
// 记录错误并保留未写入的记录
|
Console.WriteLine($"记录检测结果到Excel失败: {ex.Message}");
|
EnhancedLogViewModel.Instance.AddLog($"{_pendingRecords.Count}条检测结果保存失败，请关闭{reportFileName}后重试", "ERROR");
|
}
|
}
|
}
|
|
private static void CreateHeader(ExcelWorksheet worksheet)
|
{
|
// 设置表头
|
worksheet.Cells["A1"].Value = "二维码";
|
worksheet.Cells["B1"].Value = "检测点位";
|
worksheet.Cells["C1"].Value = "检测结果";
|
worksheet.Cells["D1"].Value = "检测时间";
|
worksheet.Cells["E1"].Value = "操作人员";
|
|
// 设置表头样式
|
using (var range = worksheet.Cells["A1:E1"])
|
{
|
range.Style.Font.Bold = true;
|
range.Style.Border.Top.Style = ExcelBorderStyle.Thin;
|
range.Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
|
range.Style.Border.Left.Style = ExcelBorderStyle.Thin;
|
range.Style.Border.Right.Style = ExcelBorderStyle.Thin;
|
range.Style.Fill.PatternType = ExcelFillStyle.Solid;
|
range.Style.Fill.BackgroundColor.SetColor(Color.LightGray);
|
range.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
|
}
|
}
|
public static void OpenReportFolder()
|
{
|
try
|
{
|
if (Directory.Exists(reportDirectory))
|
{
|
System.Diagnostics.Process.Start("explorer.exe", reportDirectory);
|
}
|
else
|
{
|
Console.WriteLine("报告目录不存在");
|
}
|
}
|
catch (Exception ex)
|
{
|
Console.WriteLine($"打开报告文件夹失败: {ex.Message}");
|
}
|
}
|
|
// 定时保存任务
|
public static void InitializeAutoFlush()
|
{
|
// 如果定时器已存在，先停止并释放
|
if (_autoFlushTimer != null)
|
{
|
_autoFlushTimer.Stop();
|
_autoFlushTimer.Dispose();
|
}
|
|
// 创建新的定时器
|
_autoFlushTimer = new Timer(20000);
|
_autoFlushTimer.Elapsed += (s, e) =>
|
{
|
try
|
{
|
Task.Run(() => FlushRecords());
|
}
|
catch (Exception ex)
|
{
|
Console.WriteLine($"定时保存记录失败: {ex.Message}");
|
}
|
};
|
_autoFlushTimer.AutoReset = true;
|
_autoFlushTimer.Start();
|
}
|
|
private class DetectionRecord
|
{
|
public string QrCode { get; set; }
|
public int Sequence { get; set; }
|
public string Result { get; set; }
|
public DateTime DetectionTime { get; } = DateTime.Now;
|
public string Operator { get; set; }
|
}
|
}
|
}
|
