//执行任务1
public static void TaskCase1()
{
//读取文件
//string filePathCase1 = Directory.GetCurrentDirectory() + "/files/en_case1";
string filePathCase1 = Utils.GetSettings("FileDir:EN_Case_1");
//Console.WriteLine("读取【英文Case1】文件夹中的结论...........");
Console.WriteLine("Read the conclusion in the [EN_Case1] folder...........");
if (!Directory.Exists(filePathCase1))
{
//Console.WriteLine("不存在此文件夹，请提前放入...........");
Console.WriteLine("This folder does not exist, please put it in advance...........");
}
//读取英文case1
var listCase1 = BatchImportHelper.ImportCase1(filePathCase1);
//Console.WriteLine($"读取完毕，获得记录总数：{listCase1.Count}...........");
Console.WriteLine($"After reading, get the total number of records:{listCase1.Count}...........");
if (listCase1.Count > 0)
{
//写入excel
DataTable dt = Utils.ToDataTable(listCase1);
ExportExcelHandler.ExecuteExportExcelData(filePathCase1, "ChemicaList1.xls", dt);
//Console.WriteLine("写入excel成功...........");
Console.WriteLine("Successfully write to Excel...........");
}
}
/// <summary>
/// 执行任务4
/// </summary>
public static void TaskCase4()
{
string filePathCase4 = Utils.GetSettings("FileDir:CN_Case_2");
Console.WriteLine("Read the conclusion in the [CN_Case2] folder...........");
if (!Directory.Exists(filePathCase4))
{
Console.WriteLine("This folder does not exist, please put it in advance...........");
}
//读取中文case2
var listCase4 = BatchImportHelper.ImportCase4(filePathCase4);
Console.WriteLine($"After reading, get the total number of records:{listCase4.Count}...........");
if (listCase4.Count > 0)
{
//写入excel
DataTable dt = Utils.ToDataTable(listCase4);
ExportExcelHandler.ExecuteExportExcelData(filePathCase4, "化合物集合2.xls", dt);
Console.WriteLine("Successfully write to Excel...........");
}
}