private System.Data.DataTable GetTableList(string sheetName)
{
using (ExcelAccessor xlsAdo = new ExcelAccessor(Config.DbTableListSettingFile))
{
return(xlsAdo.GetTableData(sheetName, "TableList", null));
}
}
private DataTable GetCheckTableList(ExcelAccessor xlsAdo)
{
string sheetName = "目次";
string sql = "Select * from [" + sheetName + "$]";
return(xlsAdo.GetTableData("TableIndex", null, sql));
}
/// <summary>
/// データ初期化する
/// </summary>
/// <param name="filePath"></param>
/// <param name="isTarget"></param>
public void DoInitlize(string filePath, string batchFile)
{
string outPutPath = System.IO.Path.ChangeExtension(filePath, "sql");
Logging.OutputFileName = outPutPath;
try
{
base.Report("テーブル一覧を取得しています");
using (ExcelAccessor xlsAdo = new ExcelAccessor(filePath))
{
DataTable tableList = GetSheetTableDatas(xlsAdo, "目次");
base.SetStep(tableList.Rows.Count, "データクリア用SQL文を作成しています。");
Logging.WriteLine("/*** データクリア ***/");
DataTableInfo tableInfo = null;
Logging.WriteLine("set search_path to " + Config.DenshowDbSchema + " ;");
foreach (DataRow row in tableList.Rows)
{
tableInfo = new DataTableInfo(row);
string sql = string.Format("TRUNCATE TABLE \"{0}\" CASCADE;", tableInfo.TableName);
Logging.WriteLine(sql);
base.ReportStep("{0}\n{1}", tableInfo.DisplayName, tableInfo.TableName);
}
base.SetStep(tableList.Rows.Count, "インサートSQL文を作成しています。");
foreach (DataRow row in tableList.Rows)
{
tableInfo = new DataTableInfo(row);
DataTable dtt = xlsAdo.GetTableData(tableInfo.SheetName, tableInfo.TableName, null, 2, Config.MaxDataCount + 2);
string sql = CreateSheetDataSql(tableInfo, dtt, true);
Logging.WriteLine(sql);
base.ReportStep("{0}\n{1}", tableInfo.DisplayName, tableInfo.TableName);
}
}
string connStr = Config.DenshowDbConnection;
//Batファイル作成する
//string batFilePath = System.IO.Path.ChangeExtension(filePath, "bat");
//string cmdSqlBat = GetSqlCmdLine(connStr,batchFile);
//System.IO.File.WriteAllText(batFilePath, cmdSqlBat, System.Text.Encoding.Default);
base.Report("SQL文を作成しました。");
}
finally
{
Logging.OutputFileName = "";
}
}
private void CheckExpectData(ExcelAccessor xlsAdo, DataTableInfo info)
{
try
{
DatabaseAcsesser dbAdo = new DatabaseAcsesser();
DataTable dttResult = dbAdo.GetResultData(info.TableName);
DataTable dttSchema = dttResult.Clone();
DataTable dttExpect = xlsAdo.GetTableData(info.SheetName, info.TableName, dttSchema, 2, Config.MaxDataCount + 2);
//データ比較する
DiffDataSouce(info, dttExpect, dttResult);
}
catch (Exception ex)
{
Logging.Exception("", ex);
throw ex;
}
}
private System.Data.DataTable GetTableList(LayoutType layoutType)
{
using (ExcelAccessor xlsAdo = new ExcelAccessor(Config.TemplateFile))
{
string sheetName = "";
string tableName = "";
switch (layoutType)
{
case LayoutType.Live:
//sheetName = "テーブル一覧";
sheetName = "テーブル一覧２";
tableName = "TableIndex";
break;
default:
sheetName = "旧テーブル一覧";
tableName = "OldTableIndex";
break;
}
return(xlsAdo.GetTableData(sheetName, tableName, null));
}
}
private DataTable GetSheetTableDatas(ExcelAccessor xlsAdo, string sheetName)
{
string sql = "Select * from [" + sheetName + "$]";
return(xlsAdo.GetTableData("tableList", null, sql));
}
private DataTable GetSettingTableList(ExcelAccessor xlsAdo, string sheetName)
{
string sql = "Select * from [" + sheetName + "$] where [No] IS NOT NULL";
return(xlsAdo.GetTableData("tableList", null, sql));
}
