public static void ImportExcel <T, TList>(string configFile, string tableId, string importId, string sourceFile, TList successList, TList failList,
bool withEvents, SourceDataValidatingHandler <IRow, ISheet> sourceDataVilidater = null, DataValidatingHandler <T, TList> targetDataValidater = null)
where T : class, new()
where TList : class
{
NPOIImport <T, TList> import = CreateNPOIImport <T, TList>(configFile, tableId, importId, withEvents, sourceDataVilidater, targetDataValidater);
import.Import(sourceFile, successList, failList);
import.Dispose();
}
private static NPOIImport <T, TList> CreateNPOIImport <T, TList>(string configFile, string tableId, string importId, bool withEvents,
SourceDataValidatingHandler <IRow, ISheet> sourceDataVilidater = null, DataValidatingHandler <T, TList> targetDataValidater = null)
where T : class, new()
where TList : class
{
NPOIImport <T, TList> import = new NPOIImport <T, TList>(configFile, tableId);
import.ImportId = importId;
if (withEvents)
{
if (sourceDataVilidater != null)
{
import.SourceDataValidating += sourceDataVilidater;
}
if (targetDataValidater != null)
{
import.TargetDataValidating += targetDataValidater;
}
}
return(import);
}
