public void UpdateSingleVersion(SQLAutoDocLib.BLL.Version oVersion) { StringBuilder sSQL = new StringBuilder(); sSQL.AppendLine("update [Version] set") .AppendFormat(" ScanComplete='{0}',", oVersion.ScanComplete) .AppendFormat(" ChangesFound='{0}',", DBHelper.BoolToBit(oVersion.ChangesFound)) .AppendFormat(" Change_Date_Time='{0}',", oVersion.ChangeDateTime) .AppendFormat(" Change_UID='{0}'", oVersion.ChangeUID) .AppendLine(" where") .AppendFormat(" DBID='{0}'", oVersion.DBID) .AppendFormat(" and VersionID='{0}'", oVersion.VersionID); base.ExecuteNonQuery(sSQL.ToString()); }
public void AddSingleVersion(SQLAutoDocLib.BLL.Version oVersion) { StringBuilder sSQL = new StringBuilder(); sSQL.AppendLine("insert into [Version] (") .AppendLine(" DBID,") .AppendLine(" VersionID,") .AppendLine(" ScanStart,") .AppendLine(" ChangesFound,") .AppendLine(" Change_Date_Time,") .AppendLine(" Change_UID) values (") .AppendFormat("'{0}',", oVersion.DBID) .AppendFormat("'{0}',", oVersion.VersionID) .AppendFormat("'{0}',", oVersion.ScanStart) .AppendFormat("'{0}',", DBHelper.BoolToBit(oVersion.ChangesFound)) .AppendFormat("'{0}',", oVersion.ChangeDateTime) .AppendFormat("'{0}')", oVersion.ChangeUID); base.ExecuteNonQuery(sSQL.ToString()); }
public void Scan() { bool ChangesFound = false; ScanDatabaseBegin(DateTime.Now); //create version record SQLAutoDocLib.BLL.Version oVersion = new SQLAutoDocLib.BLL.Version(m_DBID); //Scan beginning oVersion.ScanStart = DateTime.Now.ToString(); oVersion.Save(); //scan all functions ScanObjectTypeBegin(SQLAutoDocLib.UTIL.Constants.FUNCTIONNODE, DateTime.Now); ScanAllFunctions oFunctionScanner = new ScanAllFunctions(m_DBID, oVersion.VersionID); oFunctionScanner.ScanBegin += new ScanAllFunctions.ScanObjectBegin(ScanObjectBegin_Handler); oFunctionScanner.ScanChanged += new ScanAllFunctions.ScanObjectChanged(ScanObjectChanged_Handler); oFunctionScanner.ScanNotFound += new ScanAllFunctions.ScanObjectNotFound(ScanObjectNotFound_Handler); oFunctionScanner.ScanDeleted += new ScanAllFunctions.ScanObjectDeleted(ScanObjectDeleted_Handler); oFunctionScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler); oFunctionScanner.Scan(m_ConnectionString); oFunctionScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler); oFunctionScanner.ScanDeleted += new ScanAllFunctions.ScanObjectDeleted(ScanObjectDeleted_Handler); oFunctionScanner.ScanNotFound -= new ScanAllFunctions.ScanObjectNotFound(ScanObjectNotFound_Handler); oFunctionScanner.ScanChanged -= new ScanAllFunctions.ScanObjectChanged(ScanObjectChanged_Handler); oFunctionScanner.ScanBegin -= new ScanAllFunctions.ScanObjectBegin(ScanObjectBegin_Handler); ScanObjectTypeEnd(SQLAutoDocLib.UTIL.Constants.FUNCTIONNODE, DateTime.Now); if (oFunctionScanner.ChangesFound) { ChangesFound = true; } //scan all procedures ScanObjectTypeBegin(SQLAutoDocLib.UTIL.Constants.PROCEDURENODE, DateTime.Now); ScanAllProcedures oProcedureScanner = new ScanAllProcedures(m_DBID, oVersion.VersionID); oProcedureScanner.ScanBegin += new ScanAllProcedures.ScanObjectBegin(ScanObjectBegin_Handler); oProcedureScanner.ScanChanged += new ScanAllProcedures.ScanObjectChanged(ScanObjectChanged_Handler); oProcedureScanner.ScanNotFound += new ScanAllProcedures.ScanObjectNotFound(ScanObjectNotFound_Handler); oProcedureScanner.ScanDeleted += new ScanAllProcedures.ScanObjectDeleted(ScanObjectDeleted_Handler); oProcedureScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler); oProcedureScanner.Scan(m_ConnectionString); oProcedureScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler); oProcedureScanner.ScanDeleted += new ScanAllProcedures.ScanObjectDeleted(ScanObjectDeleted_Handler); oProcedureScanner.ScanNotFound -= new ScanAllProcedures.ScanObjectNotFound(ScanObjectNotFound_Handler); oProcedureScanner.ScanChanged -= new ScanAllProcedures.ScanObjectChanged(ScanObjectChanged_Handler); oProcedureScanner.ScanBegin -= new ScanAllProcedures.ScanObjectBegin(ScanObjectBegin_Handler); ScanObjectTypeEnd(SQLAutoDocLib.UTIL.Constants.PROCEDURENODE, DateTime.Now); if (oProcedureScanner.ChangesFound) { ChangesFound = true; } //scan all tables ScanObjectTypeBegin(SQLAutoDocLib.UTIL.Constants.TABLENODE, DateTime.Now); ScanAllTables oTableScanner = new ScanAllTables(m_DBID, oVersion.VersionID); oTableScanner.ScanBegin += new ScanAllTables.ScanObjectBegin(ScanObjectBegin_Handler); oTableScanner.ScanChanged += new ScanAllTables.ScanObjectChanged(ScanObjectChanged_Handler); oTableScanner.ScanNotFound += new ScanAllTables.ScanObjectNotFound(ScanObjectNotFound_Handler); oTableScanner.ScanDeleted += new ScanAllTables.ScanObjectDeleted(ScanObjectDeleted_Handler); oTableScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler); oTableScanner.Scan(m_ConnectionString); oTableScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler); oTableScanner.ScanDeleted -= new ScanAllTables.ScanObjectDeleted(ScanObjectDeleted_Handler); oTableScanner.ScanNotFound -= new ScanAllTables.ScanObjectNotFound(ScanObjectNotFound_Handler); oTableScanner.ScanChanged -= new ScanAllTables.ScanObjectChanged(ScanObjectChanged_Handler); oTableScanner.ScanBegin -= new ScanAllTables.ScanObjectBegin(ScanObjectBegin_Handler); ScanObjectTypeEnd(SQLAutoDocLib.UTIL.Constants.TABLENODE, DateTime.Now); if (oTableScanner.ChangesFound) { ChangesFound = true; } //scan all triggers ScanObjectTypeBegin(SQLAutoDocLib.UTIL.Constants.TRIGGERNODE, DateTime.Now); ScanAllTriggers oTriggerScanner = new ScanAllTriggers(m_DBID, oVersion.VersionID); oTriggerScanner.ScanBegin += new ScanAllTriggers.ScanObjectBegin(ScanObjectBegin_Handler); oTriggerScanner.ScanChanged += new ScanAllTriggers.ScanObjectChanged(ScanObjectChanged_Handler); oTriggerScanner.ScanNotFound += new ScanAllTriggers.ScanObjectNotFound(ScanObjectNotFound_Handler); oTriggerScanner.ScanDeleted += new ScanAllTriggers.ScanObjectDeleted(ScanObjectDeleted_Handler); oTriggerScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler); oTriggerScanner.Scan(m_ConnectionString); oTriggerScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler); oTriggerScanner.ScanDeleted += new ScanAllTriggers.ScanObjectDeleted(ScanObjectDeleted_Handler); oTriggerScanner.ScanNotFound -= new ScanAllTriggers.ScanObjectNotFound(ScanObjectNotFound_Handler); oTriggerScanner.ScanChanged -= new ScanAllTriggers.ScanObjectChanged(ScanObjectChanged_Handler); oTriggerScanner.ScanBegin -= new ScanAllTriggers.ScanObjectBegin(ScanObjectBegin_Handler); ScanObjectTypeEnd(SQLAutoDocLib.UTIL.Constants.TRIGGERNODE, DateTime.Now); if (oTriggerScanner.ChangesFound) { ChangesFound = true; } //scan all views ScanObjectTypeBegin(SQLAutoDocLib.UTIL.Constants.VIEWNODE, DateTime.Now); ScanAllViews oViewScanner = new ScanAllViews(m_DBID, oVersion.VersionID); oViewScanner.ScanBegin += new ScanAllViews.ScanObjectBegin(ScanObjectBegin_Handler); oViewScanner.ScanChanged += new ScanAllViews.ScanObjectChanged(ScanObjectChanged_Handler); oViewScanner.ScanNotFound += new ScanAllViews.ScanObjectNotFound(ScanObjectNotFound_Handler); oViewScanner.ScanDeleted += new ScanAllViews.ScanObjectDeleted(ScanObjectDeleted_Handler); oViewScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler); oViewScanner.Scan(m_ConnectionString); oViewScanner.ScanCount += new ScanAllFunctions.ScanCountOfObjectsToScan(ScanCountOfObjectsToScan_Handler); oViewScanner.ScanDeleted += new ScanAllViews.ScanObjectDeleted(ScanObjectDeleted_Handler); oViewScanner.ScanNotFound -= new ScanAllViews.ScanObjectNotFound(ScanObjectNotFound_Handler); oViewScanner.ScanChanged -= new ScanAllViews.ScanObjectChanged(ScanObjectChanged_Handler); oViewScanner.ScanBegin -= new ScanAllViews.ScanObjectBegin(ScanObjectBegin_Handler); ScanObjectTypeEnd(SQLAutoDocLib.UTIL.Constants.VIEWNODE, DateTime.Now); if (oViewScanner.ChangesFound) { ChangesFound = true; } //Scan complete oVersion.ScanComplete = DateTime.Now.ToString(); oVersion.ChangesFound = ChangesFound; oVersion.Save(); ScanDatabaseEnd(DateTime.Now); }