private static void Execute(Options options)
{
/* 判断 ExcelPath 为目录路径还是文件路径 */
string[] excelPaths = null;
if (Directory.Exists(options.ExcelPath))
{
DirectoryInfo dirInfo = new DirectoryInfo(options.ExcelPath);
excelPaths = dirInfo.GetFiles().Where(fileInfo => ExcelUtil.IsSupported(fileInfo.Name)).Select(fileInfo => fileInfo.FullName).ToArray();
}
else if (File.Exists(options.ExcelPath))
{
if (ExcelUtil.IsSupported(options.ExcelPath))
{
excelPaths = new[] { options.ExcelPath };
}
}
if (excelPaths == null)
{
Console.WriteLine("No supported excel file found.");
return;
}
/* 对目标 Excel 文件进行转译 */
foreach (var excelPath in excelPaths)
{
string excelName = Path.GetFileName(excelPath);
Console.WriteLine("[{0}]", excelName);
DataTableCollection dataTables = ExcelReader.ReadExcelToDataTables(excelPath);
foreach (DataTable dataTable in dataTables)
{
/* 开始转换 DataTable */
string sheetName = dataTable.TableName;
int rowsCount = dataTable.Rows.Count;
int columnsCount = dataTable.Columns.Count;
Console.WriteLine(" sheet {0}(rows: {1}, column: {2})...", sheetName, rowsCount.ToString(), columnsCount.ToString());
ESheet sheetType = ExcelUtil.GetSheetType(sheetName);
string fileName = sheetType switch {
ESheet.EnumSheet => options.EnumNamePrefix + sheetName.Substring(4),
ESheet.ParamSheet => options.ParamNamePrefix + sheetName.Substring(5),
ESheet.ClassSheet => options.ClassNamePrefix + sheetName,
_ => null
};
/* 生成 JSON 数据 */
Console.WriteLine(" generate json...");
string jsonContent = DataWriter.DataTableToJSON(dataTable, options);
if (!string.IsNullOrEmpty(jsonContent))
{
if (!Directory.Exists(options.JSONPath))
{
Directory.CreateDirectory(options.JSONPath);
}
string jsonPath = string.Format("{0}/{1}.json", options.JSONPath, fileName);
File.WriteAllText(jsonPath, jsonContent, Encoding.UTF8);
}
/* 生成 C# 代码 */
Console.WriteLine(" generate csharp code...");
string codeContent = CodeWriter.DataTableToCSharp(dataTable, excelName, options);
if (!string.IsNullOrEmpty(codeContent))
{
if (!Directory.Exists(options.CSharpCodePath))
{
Directory.CreateDirectory(options.CSharpCodePath);
}
string codePath = string.Format("{0}/{1}.cs", options.CSharpCodePath, fileName);
File.WriteAllText(codePath, codeContent, Encoding.UTF8);
}
}
}
}
}