/// <summary>
/// 导入数据
/// </summary>
/// <param name="filePath"></param>
/// <param name="className"></param>
/// <param name="acctId"></param>
/// <returns></returns>
public ActionResult Import(string filePath, string className, string[] keyValue)
{
ExcelImportBase importApp = CreateInstance(className);
var data = importApp.Scan(filePath, keyValue);
if (data.Count > 0)
{
return(Error("导入数据存在未处理的错误！"));
}
else
{
importApp.Import(filePath, keyValue);
return(Success("数据导入成功！"));
}
}
public static bool LoadExcelSheet <T>(string dirPath, string sheetName, out ExcelImportBase import)
{
import = Activator.CreateInstance(typeof(T)) as ExcelImportBase;
import.LoadSheetLoader(dirPath, sheetName);
if (!import.Import())
{
Console.WriteLine($"Excel import failed, {import.TableName}");
return(false);
}
else
{
Console.WriteLine("{0}.xlsx 파일을 성공적으로 로딩했습니다.", sheetName);
}
return(true);
}