private static ExcelReader CreateReader(ConvertCommandLine cmd)
{
switch (cmd.Type)
{
case "TRN":
var trnReader = new TRNExcelReader();
if (ReadConfiguration(trnReader))
{
return(trnReader);
}
return(null);
case "SDT":
var sdtReader = new SDTExcelReader();
if (ReadConfiguration(sdtReader))
{
return(sdtReader);
}
return(null);
case "GRP":
var grpReader = new GRPExcelReader();
if (ReadConfiguration(grpReader))
{
return(grpReader);
}
return(null);
default:
Console.WriteLine("Invalid value for Type argument");
return(null);
}
}
public void TestReadFiles()
{
TRNExcelReader reader = new TRNExcelReader();
Config(reader);
reader.Configuration.DefinitionSheetName = "TransactionDefinitionSheet";
reader.ReadExcel(new string[] { Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "Test.xlsx"), Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "Test3.xlsx") }
, Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "trns.xml"), false);
}
private void Config(TRNExcelReader reader)
{
reader.Configuration.ObjectNameRow = 2;
reader.Configuration.ObjectNameColumn = 1;
reader.Configuration.ObjectDescColumn = 2;
reader.Configuration.ObjectDescRow = 2;
reader.Configuration.LevelCheckColumn = 3;
reader.Configuration.LevelIdentifierKeyword = "LVL";
reader.Configuration.LevelParentIdColumn = 9;
reader.Configuration.LevelIdColumn = 8;
reader.Configuration.BaseTypeColumn = 10;
reader.Configuration.DataStartRow = 5;
reader.Configuration.DataStartColumn = 1;
reader.Configuration.DataNameColumn = 1;
reader.Configuration.DataDescriptionColumn = 2;
reader.Configuration.DataTypeColumn = 4;
reader.Configuration.DataLengthColumn = 5;
reader.Configuration.AttributeKeyColumn = 3;
reader.Configuration.AttributeNullableColumn = 6;
}
private static bool ReadConfiguration(TRNExcelReader reader)
{
if (!ReadBaseDataConfiguration(reader))
{
return(false);
}
reader.Configuration.AttributeKeyColumn = Settings.Default.AttributeKeyColumn;
reader.Configuration.AttributeNullableColumn = Settings.Default.AttributeNullableColumn;
reader.Configuration.AttributeAutonumberColumn = Settings.Default.AttributeAutonumberColumn;
reader.Configuration.AttributeTitleColumn = Settings.Default.AttributeTitleColumn;
reader.Configuration.AttributeColumnTitleColumn = Settings.Default.AttributeColumnTitleColumn;
reader.Configuration.AttributeContextualTitleColumn = Settings.Default.AttributeContextualTitleColumn;
// Values for PK and Nullable
reader.Configuration.PKValue = Settings.Default.PKValue;
reader.Configuration.NullableValue = Settings.Default.NullableValue;
// Formula
reader.Configuration.FormulaCheckColumn = Settings.Default.FormulaCheckColumn;
reader.Configuration.FormulaIdentifierKeyword = Settings.Default.FormulaIdentifierKeyword;
reader.Configuration.FormulaColumn = Settings.Default.FormulaColumn;
return(true);
}
private void ConfigJapan(TRNExcelReader reader)
{
reader.Configuration.DefinitionSheetName = "トランザクション定義書";
reader.Configuration.ObjectNameRow = 3;
reader.Configuration.ObjectNameColumn = 12;
reader.Configuration.ObjectDescRow = 3;
reader.Configuration.ObjectDescColumn = 13;
reader.Configuration.DataStartRow = 6;
reader.Configuration.DataStartColumn = 2;
reader.Configuration.AttributeKeyColumn = 7;
reader.Configuration.PKValue = "PK";
reader.Configuration.DataNameColumn = 5;
reader.Configuration.DataDescriptionColumn = 6;
reader.Configuration.BaseTypeColumn = 8;
reader.Configuration.DataTypeColumn = 9;
reader.Configuration.DataLengthColumn = 10;
reader.Configuration.AttributeNullableColumn = 11;
reader.Configuration.NullableValue = "Y";
reader.Configuration.LevelCheckColumn = 3;
reader.Configuration.LevelIdentifierKeyword = "レベル";
reader.Configuration.LevelIdColumn = 2;
reader.Configuration.LevelParentIdColumn = 4;
}
