public bool Verify(ref List <string> errors) { if (string.IsNullOrEmpty(Name)) { errors.Add(WDBConst.VERIFY_SHEET_NAME_EMPTY_ERR); return(false); } if (!Regex.IsMatch(Name, WDBConst.VERIFY_SHEET_NAME_REGEX)) { errors.Add(string.Format(WDBConst.VERIFY_SHEET_NAME_REGEX_ERR, Name)); return(false); } if (FieldCount == 0) { errors.Add(string.Format(WDBConst.VERIFY_SHEET_NO_FIELD_ERR, Name)); return(false); } if (RowCount == 0) { errors.Add(string.Format(WDBConst.VERIFY_SHEET_NO_ROW_ERR, Name)); return(false); } bool result = true; foreach (var field in fields) { if (!field.Verify(ref errors)) { if (result) { result = false; } } } if (!result) { return(false); } StringContextContainer context = new StringContextContainer(); context.Add(WDBConst.CONTEXT_SHEET_NAME, this); context.Add(WDBConst.CONTEXT_ERRORS_NAME, errors); foreach (var row in rows) { if (row.CellCount != FieldCount) { if (result) { result = false; } errors.Add(string.Format(WDBConst.VERIFY_SHEET_FIELD_ROW_ERR, FieldCount, row.Row)); } } if (!result) { return(false); } for (int i = 0; i < fields.Count; ++i) { var field = fields[i]; context.Add(WDBConst.CONTEXT_FIELD_NAME, field); foreach (var row in rows) { var cell = row.GetCellByIndex(i); if (cell.Col != field.Col) { if (result) { result = false; } errors.Add(string.Format(WDBConst.VERIFY_CELL_COL_NOTSAME_ERR, cell.Row, cell.Col)); } else { context.Add(WDBConst.CONTEXT_CELL_NAME, cell); foreach (var cellValidation in field.Validations) { context.InjectTo(cellValidation); } context.Remove(WDBConst.CONTEXT_CELL_NAME); } } context.Remove(WDBConst.CONTEXT_FIELD_NAME); } return(errors.Count == 0); }