biss
fea91a19af
Excel：班级、账号、考生、缴费、考场、成绩、志愿、录取、报到及正式录取名册均改为 ClosedXML 原生处理，支持模板、校验、筛选和导入预检。[SystemWorkbook.cs](C:\\Users\\BI\\Documents\\EIS-dotnet\\src\\Eis.Infrastructure\\Spreadsheets\\SystemWorkbook.cs) 文书：录取通知书模板、成绩单/准考证/通知书业务数据与防伪验真已脱离 Node；保留现有前端排版导出效果。[AdminAdmissionService.Documents.cs](C:\\Users\\BI\\Documents\\EIS-dotnet\\src\\Eis.Infrastructure\\Administration\\AdminAdmissionService.Documents.cs) 缓存：完成 Redis 命名空间版本缓存、有界本地回退、请求合并和并发失效保护；公开数据及成绩写入后立即失效。[ApplicationCache.cs](C:\\Users\\BI\\Documents\\EIS-dotnet\\src\\Eis.Infrastructure\\Caching\\ApplicationCache.cs) 迁移清单已更新为完成。[MIGRATION.md](C:\\Users\\BI\\Documents\\EIS-dotnet\\MIGRATION.md)
67 lines
2.5 KiB
C#
67 lines
2.5 KiB
C#
using System.Text.Json.Nodes;
|
|
using ClosedXML.Excel;
|
|
using Eis.Infrastructure.Spreadsheets;
|
|
|
|
namespace Eis.Infrastructure.Tests.Spreadsheets;
|
|
|
|
public sealed class SystemWorkbookTests
|
|
{
|
|
[Fact]
|
|
public void AdmissionReporting_RoundTripsEditableFieldsAndKeepsProfessionalLayout()
|
|
{
|
|
var content = SystemWorkbook.Build(
|
|
"admission_reporting",
|
|
[
|
|
new JsonObject
|
|
{
|
|
["noticeNumber"] = "AD01-EX-2026-ZK-000001",
|
|
["candidateNumber"] = "2026-HZ01-F-0001",
|
|
["name"] = "张同学",
|
|
["examCode"] = "EX-2026-ZK",
|
|
["schoolCode"] = "AD01",
|
|
["categoryName"] = "普通生",
|
|
["reportingStatusCode"] = "Y",
|
|
["reportingNote"] = "材料齐全"
|
|
}
|
|
],
|
|
subtitle: "第 1 轮");
|
|
|
|
using var workbook = new XLWorkbook(new MemoryStream(content));
|
|
var sheet = workbook.Worksheet("考生报到");
|
|
|
|
Assert.True(content.Length > 1000);
|
|
Assert.Equal(XLColor.FromHtml("#173F60"), sheet.Cell(1, 1).Style.Fill.BackgroundColor);
|
|
Assert.Equal(XLColor.FromHtml("#FFF3CD"), sheet.Cell(3, 7).Style.Fill.BackgroundColor);
|
|
Assert.Equal(XLColor.FromHtml("#FFF3CD"), sheet.Cell(3, 8).Style.Fill.BackgroundColor);
|
|
|
|
var parsed = SystemWorkbook.Parse("admission_reporting", content);
|
|
Assert.Single(parsed);
|
|
Assert.Equal("Y", parsed[0]["reportingStatusCode"]!.GetValue<string>());
|
|
Assert.Equal("材料齐全", parsed[0]["reportingNote"]!.GetValue<string>());
|
|
Assert.Equal(3, parsed[0]["__row"]!.GetValue<int>());
|
|
}
|
|
|
|
[Fact]
|
|
public void Template_ContainsExampleRowAndValidation()
|
|
{
|
|
var content = SystemWorkbook.Build("classes", [], template: true);
|
|
|
|
using var workbook = new XLWorkbook(new MemoryStream(content));
|
|
var sheet = workbook.Worksheet("班级");
|
|
|
|
Assert.Equal("HZ01", sheet.Cell(3, 1).GetString());
|
|
Assert.Equal("启用", sheet.Cell(3, 4).GetString());
|
|
Assert.NotEmpty(sheet.DataValidations);
|
|
}
|
|
|
|
[Fact]
|
|
public void InvalidWorkbook_IsRejectedWithBusinessError()
|
|
{
|
|
var error = Assert.Throws<WorkbookException>(() =>
|
|
SystemWorkbook.Parse("results", "not-an-xlsx"u8.ToArray()));
|
|
|
|
Assert.Equal(400, error.StatusCode);
|
|
Assert.Contains("系统下载的 .xlsx 模板", error.Message, StringComparison.Ordinal);
|
|
}
|
|
}
|