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);
}
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));
}
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>();
}