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