public static long GetLastInsertRowId() { DocumentTakeoff docTakeoff = Autodesk.Navisworks.Api.Application.MainDocument.GetTakeoff(); using (NavisworksCommand cmd = docTakeoff.Database.Value.CreateCommand()) { //use SELECT ... FROM ... WHERE ... sql for query. //last_insert_rowid() is a stored function used to retrieve the rowid of the last insert row cmd.CommandText = "select last_insert_rowid()"; using (NavisWorksDataReader dataReader = cmd.ExecuteReader()) { long lastId = -1; if (dataReader.Read()) { long.TryParse(dataReader[0].ToString(), out lastId); } return(lastId); } } }
public static void ClaerSQL() { DocumentTakeoff docTakeoff = Autodesk.Navisworks.Api.Application.MainDocument.GetTakeoff(); using (NavisworksTransaction trans = docTakeoff.Database.BeginTransaction(DatabaseChangedAction.Edited)) { using (NavisworksCommand cmd = docTakeoff.Database.Value.CreateCommand()) { //use SELECT ... FROM ... WHERE ... sql for query. //last_insert_rowid() is a stored function used to retrieve the rowid of the last insert row cmd.CommandText = "DELETE FROM TK_Item"; cmd.ExecuteReader(); } using (NavisworksCommand cmd = docTakeoff.Database.Value.CreateCommand()) { //use SELECT ... FROM ... WHERE ... sql for query. //last_insert_rowid() is a stored function used to retrieve the rowid of the last insert row cmd.CommandText = "DELETE FROM TK_ItemGroup"; cmd.ExecuteReader(); } trans.Commit(); } }