public void CreateDBScript(LayoutType layout, string tableLayoutFile, ScriptOptions opt)
{
base.Report(Resource.StringTable.Messages.OpenDesignFile);
using (ExcelHelp xls = new ExcelHelp(tableLayoutFile))
{
//int sheectCount = xls.WorkBook.Sheets.Count;
base.Report(Resource.StringTable.Messages.ReadingTableList);
System.Data.DataTable dttList = GetTableList(layout);
//System.Data.DataTable dttList = GetTableList(xls,layout );
base.SetStep(dttList.Rows.Count, Resource.StringTable.Messages.CreatingSqlScript);
foreach (System.Data.DataRow row in dttList.Rows)
{
string sheetName = Utility.DBToString(row["DisplayName"]);
string tabName = Utility.DBToString(row["TableName"]);
try
{
TableLayoutInfo tableInfo = ReadTableLayout(xls, sheetName, layout);
//Script出力
CreateSqlScript(opt, tableInfo);
ReportStep(Resource.StringTable.Messages.CreatedTableSqlScript, tableInfo.DisplayName, tableInfo.TableName);
}
catch (Exception ex)
{
Logging.WriteLine("/*");
Logging.WriteLine(Resource.StringTable.Messages.ScriptCreateFailed, sheetName, tabName);
Logging.Exception("", ex);
Logging.WriteLine("*/");
}
}
Report(Resource.StringTable.Messages.ProcessFinished);
xls.Close();
}
}
public void CreateDBScript(TableCreateInfo info)
{
string outPutPath = System.IO.Path.ChangeExtension(info.LayoutFileName, "sql");
Logging.OutputFileName = outPutPath;
try
{
base.Report(Resource.StringTable.Messages.OpenDesignFile);
using (ExcelHelp xls = new ExcelHelp(info.LayoutFileName))
{
//int sheectCount = xls.WorkBook.Sheets.Count;
base.Report(Resource.StringTable.Messages.ReadingTableList);
System.Data.DataTable dttList = GetTableList(info.TableListSheetName);
base.SetStep(dttList.Rows.Count, Resource.StringTable.Messages.CreatingSqlScript);
foreach (System.Data.DataRow row in dttList.Rows)
{
DataTableInfo tbInfo = new DataTableInfo(row);
try
{
TableLayoutInfo tableInfo = ReadTableLayout(xls, tbInfo.SheetName, info.LayoutKind);
//Script出力
CreateSqlScript(info.Options, tableInfo);
ReportStep(Resource.StringTable.Messages.CreatedTableSqlScript, tableInfo.DisplayName, tableInfo.TableName);
}
catch (Exception ex)
{
Logging.WriteLine("/*");
Logging.WriteLine(Resource.StringTable.Messages.ScriptCreateFailed, tbInfo.SheetName, tbInfo.TableName);
Logging.Exception("", ex);
Logging.WriteLine("*/");
}
}
Report(Resource.StringTable.Messages.ProcessFinished);
xls.Close();
}
}
finally
{
Logging.OutputFileName = "";
}
}
