public static List <string> CheckTablesStruct()
{
TableInfoRepo OriTableRepo = new TableInfoRepo(ConnetionInfoFactory.GetMsOriginDbInfo());
TableInfoRepo CpyTableRepo = new TableInfoRepo(ConnetionInfoFactory.GetMsCopyDbInfo());
List <string> list = new List <string>();
var listOri = OriTableRepo.GetInformation_Class();
var listCpy = CpyTableRepo.GetInformation_Class();
foreach (TableInfo oInfo in listOri)
{
foreach (TableInfo cInfo in listCpy)
{
if (oInfo.TABLE_NAME == cInfo.TABLE_NAME)
{
bool x = CheckTableStruct(oInfo.TABLE_NAME, OriTableRepo, CpyTableRepo);
if (x == false)
{
list.Add(oInfo.TABLE_NAME);
}
}
}
}
return(list);
}
private static bool CheckTableStruct(
string tableName, TableInfoRepo OriTableRepo, TableInfoRepo CpyTableRepo)
{
DataTable oriInfo = OriTableRepo.GetStructInfomation_DataTable(tableName);
DataTable cpyInfo = CpyTableRepo.GetStructInfomation_DataTable(tableName);
return(TryIsTableSame(oriInfo, cpyInfo));
}
public static List <string> GetNotMatchTableData()
{
TableInfoRepo OriTableRepo = new TableInfoRepo(ConnetionInfoFactory.GetMsOriginDbInfo());
TableInfoRepo CpyTableRepo = new TableInfoRepo(ConnetionInfoFactory.GetMsCopyDbInfo());
var listOri = OriTableRepo.GetInformation_Class();
var listCpy = CpyTableRepo.GetInformation_Class();
return(GetErrorList(listOri, listCpy));
}
private void AddTableStructNotMatch(string tableName, TableInfoRepo OriTableRepo, TableInfoRepo CpyTableRepo)
{
var ori = OriTableRepo.GetStructInfomation_DataTable(tableName);
var cpy = OriTableRepo.GetStructInfomation_DataTable(tableName);
if (isTableStructSame(ori, cpy) == false)
{
resultNameList.Add(tableName);
resultTableList.Add(GetTableDataSet(ori, cpy));
}
}
public TableAnalyzeService()
{
var oriInfo = ConnetionInfoFactory.GetMsOriginDbInfo();
oriRepo = new TableInfoRepo(oriInfo);
var cpyInfo = ConnetionInfoFactory.GetMsCopyDbInfo();
cpyRepo = new TableInfoRepo(oriInfo);
resultTableList = new List <DataSet>();
resultNameList = new List <string>();
}
