public string RestoreTableData(DateTime?fromDay, DateTime?toDay)
{
List <ConstraintInfo> backUpConstraintInfo = SqlCommandRunner.GetConstraintInfo(_MainTable, _RestoreDbName);
SqlCommandRunner.DropTable(_MainTable, _RestoreDbName);
SqlCommandRunner.CopyTable(_MainTable, _ForRestoreCopyDbName, _RestoreDbName);
SqlCommandRunner.RestoreConstraintInfo(backUpConstraintInfo, _MainTable, _RestoreDbName);
return(string.Format("--表{0}共计:覆盖所有数据", _MainTable));
}
private string DropNonUseTable(string theReleatedDb)
{
StringBuilder retVal = new StringBuilder("--丢弃表：");
//先删除所有外键，防止无法删除的表
SqlCommandRunner.DelAllFks(theReleatedDb);
//再删除表
foreach (string aTable in SqlCommandRunner.GetAllTables(_DbName))
{
if (FindTableTransfer(aTable) == null && FindTableProtected(aTable) == null)
{
SqlCommandRunner.DropTable(aTable, theReleatedDb);
retVal.Append(aTable).Append(",");
}
}
if (retVal.ToString().EndsWith(","))
{
return(retVal.Remove(retVal.Length - 1, 1).ToString());
}
return(retVal.ToString());
}
