数据校验 about weihanli.npoi HOT 7 CLOSED

(List<TEntity?> EntityList, Dictionary<int, ValidationResult> ValidationResults) ToEntityListWithValidationResult<TEntity>()

    [Theory]
    [ExcelFormatData]
    public void ValidatorTest(ExcelFormat excelFormat)
    {
        var list = new List<Job>()
        {
            new()
            {
                Id = 1,
                Name = "test"
            },
            new()
        };
        var bytes = list.ToExcelBytes(excelFormat);
        var result = ExcelHelper.ToEntityListWithValidationResult<Job>(bytes, excelFormat);
        Assert.Equal(list.Count, result.EntityList.Count);
        for (var i = 0; i < list.Count; i++)
        {
            Assert.True(list[i] == result.EntityList[i]);
        }
        Assert.Single(result.ValidationResults);
    }

    [Theory]
    [ExcelFormatData]
    public void ValidatorTest_CustomValidator(ExcelFormat excelFormat)
    {
        var list = new List<Job>()
        {
            new()
            {
                Id = 1,
                Name = "test"
            }
        };
        var validator = new DelegateValidator<Job>(_ => new ValidationResult()
        {
            Valid = false,
            Errors = new Dictionary<string, string[]>() { { "", new[] { "Mock error" } } }
        });
        var bytes = list.ToExcelBytes(excelFormat);
        var result = ExcelHelper.ToEntityListWithValidationResult<Job>(bytes, excelFormat, validator: validator);
        Assert.Equal(list.Count, result.EntityList.Count);
        for (var i = 0; i < list.Count; i++)
        {
            Assert.True(list[i] == result.EntityList[i]);
        }
        Assert.Single(result.ValidationResults);
    }