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 = ""; } }