/// <summary>
/// 基础验证 通过实体特性
/// </summary>
public static void BasicValidate()
{
WorkBookValidate workbook = new WorkBookValidate("Default.xlsx");
var errlist = workbook[0].StartValidate <User>();
Validate(errlist);
}
/// <summary>
/// 基础验证 自定义对应关系
/// </summary>
public static void BasicValidate2()
{
WorkBookValidate workbook = new WorkBookValidate("Other.xlsx");
workbook[0].AddMapping("ID", "主键");
var errlist = workbook[0].StartValidate <User>();
Validate(errlist);
}
/// <summary>
/// 带条件验证
/// </summary>
public static void ValidateWithCondition()
{
WorkBookValidate workbook = new WorkBookValidate("Default.xlsx");
List <CellMatching <User> > rowValidate = new List <CellMatching <User> >();
rowValidate.Add(new CellMatching <User>()
{
paramater = u => u.Age,
matchCondition = u => u.Age > 10,
errMsg = "请选择年龄大于10的人员"
});
var errlist = workbook[0].StartValidate <User>(rowValidate);
Validate(errlist);
}
