Namespace: Consultingwerk.SmartFramework
Class 
SmartDataAccess Copy to Clipboard
Parent classes:
Inherits: Consultingwerk.OERA.DataAccess
Implements: Consultingwerk.OERA.IDataAccess, Consultingwerk.OERA.IDataAccessCanFind, Consultingwerk.OERA.IDataAccessCountRecords, IDSQueryStringSource, Consultingwerk.OERA.IProvidesSmartRecordInformation
Inherited by: Consultingwerk.SmartFramework.Authentication.UserDataAccess Consultingwerk.SmartFramework.Authentication.UserProfileDataAccess Consultingwerk.SmartFramework.Authorization.FieldSecurityItemDataAccess Consultingwerk.SmartFramework.Authorization.GroupDataAccess Consultingwerk.SmartFramework.Authorization.MenuGroupDataAccess Consultingwerk.SmartFramework.Authorization.ParentGroupDataAccess Consultingwerk.SmartFramework.Authorization.SecurityAssignmentDataAccess Consultingwerk.SmartFramework.Authorization.SecurityObjectDataAccess Consultingwerk.SmartFramework.Authorization.SecurityRealmDataAccess Consultingwerk.SmartFramework.Authorization.SecurityTokenDataAccess Consultingwerk.OERA.DynamicBusinessEntity.DynamicDataAccess Consultingwerk.SmartFramework.Authorization.ToolbarSecurityItemDataAccess Consultingwerk.SmartFramework.Authorization.UserGroupDataAccess Consultingwerk.SmartFramework.Context.ContextStoreDataAccess Consultingwerk.SmartFramework.Lock.LockDataAccess Consultingwerk.SmartFramework.Menu.MenuDataAccess Consultingwerk.SmartFramework.Menu.MenuStyleDataAccess Consultingwerk.SmartFramework.Menu.ModuleDataAccess Consultingwerk.SmartFramework.Menu.ProductDataAccess Consultingwerk.SmartFramework.Repository.BusinessEntities.RepositoryObjectDataAccess Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaBusinessEntity.MetaBusinessEntityDataAccess Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaDataSource.MetaDataSourceDataAccess Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaEntityTable.MetaEntityTableDataAccess Consultingwerk.SmartFramework.Repository.Class.AttributeDataAccess Consultingwerk.SmartFramework.Repository.Class.AttributeGroupDataAccess Consultingwerk.SmartFramework.Repository.Class.AttributeUsed.AttributeValueDataAccess Consultingwerk.SmartFramework.Repository.Class.AttributeValueDataAccess Consultingwerk.SmartFramework.Repository.Class.ClassTypeDataAccess Consultingwerk.SmartFramework.Repository.Class.LinkTypeDataAccess Consultingwerk.SmartFramework.Repository.Class.ObjectTypeDataAccess Consultingwerk.SmartFramework.System.ConfigurationValueDataAccess Consultingwerk.SmartFramework.System.DeletionDataAccess Consultingwerk.SmartFramework.System.ImportFileStatus.ImportFileStatusDataAccess Consultingwerk.SmartFramework.System.KeyFieldAssignmentTypeDataAccess Consultingwerk.SmartFramework.System.LanguageDataAccess Consultingwerk.SmartFramework.System.LoginCompanyDataAccess Consultingwerk.SmartFramework.System.MessageDataAccess Consultingwerk.SmartFramework.System.ModifiedStateDataAccess Consultingwerk.SmartFramework.System.RelationDataAccess Consultingwerk.SmartFramework.System.SmartBusinessEntityDataAccess Consultingwerk.SmartFramework.System.SmartCache.CacheDataAccess Consultingwerk.SmartFramework.System.TableDataAccess Consultingwerk.SmartFramework.System.Tags.TagDataAccess Consultingwerk.SmartFramework.System.TranslationDataAccess Consultingwerk.SmartFramework.System.UiTranslationDataAccess Consultingwerk.SmartFramework.System.ValueListDataAccess Consultingwerk.SmartFramework.Web.RouteDataAccess Consultingwerk.SmartFramework.Repository.Class.SupportedInstanceObjectTypeDataAccess Consultingwerk.SmartFramework.Repository.Class.SupportedLinkDataAccess Consultingwerk.SmartFramework.Repository.Customization.CustomizationDataAccess Consultingwerk.SmartFramework.Repository.Customization.CustomizationTypeDataAccess Consultingwerk.SmartFramework.Repository.Field.EntityFieldMappingDataAccess Consultingwerk.SmartFramework.Repository.Object.Export.ObjectMasterDataAccess Consultingwerk.SmartFramework.Repository.Object.ObjectMasterDataAccess Consultingwerk.SmartFramework.Repository.Object.WhereUsed.WhereUsedDataAccess Consultingwerk.SmartFramework.Repository.ScreenMapping.EntityTableMappingDataAccess Consultingwerk.SmartFramework.Repository.ScreenMapping.ScreenTypeDataAccess Consultingwerk.SmartFramework.Repository.ScreenMapping.UiTypeDataAccess Consultingwerk.SmartFramework.Scheduler.SchedulerJobDataAccess Consultingwerk.SmartFramework.Scheduler.SchedulerJobPlanDataAccess Consultingwerk.SmartFramework.Scheduler.SchedulerJobStatusDataAccess Consultingwerk.SmartFramework.Scheduler.SchedulerQueueDataAccess Consultingwerk.SmartFramework.System.AttachmentDataAccess Consultingwerk.SmartFramework.System.AttachmentRoleDataAccess Consultingwerk.SmartFramework.System.CommentRoleDataAccess Consultingwerk.SmartFramework.Workflow.WorkflowDataAccess Consultingwerk.SmartFramework.Workflow.WorkflowInstanceDataAccess Consultingwerk.SmartUnit.OERA.MockDataAccess.GenericMockDataAccess
ABSTRACT




Top Method Summary
Options Name Purpose
AssignKeyFieldValues (handle) Invoked by DataAccess:CommitChanges within the database transaction to optionally assign key field values for new records
AssignSmartRecordInformation () Assign SmartRecordKey and Attachment/Comment function
CheckSystemOwned (handle) Checks if the user is authorized to maintain records with the System Owned flag
CommitChanges (handle) This procedure is called from SaveChanges in the DA to do the actual database commit and any transaction-related validation logic for a buffer.
ResetModifiedState (character, character) Resets a modification for the given table and key field values
CHARACTER SourceTable (character) Returns the name of the source (database) table for a ProDataset table name
CHARACTER TargetColumn (character, character, handle) Returns the temp-table field name matching a database field name
TrackModifiedState (character, character) Tracks a modification for the given table and key field values

Top Constructor Summary
Options Name Purpose
SmartDataAccess (handle) Constructor of the SmartDataAccess class

Top Property Summary
Options Name Purpose
LOGICAL DisableReferentialIntegrity
Consultingwerk.Framework.Collections.CharacterDictionary SourceTables
LOGICAL TrackDeletions
LOGICAL UseNoWaitForReferentialIntegrity


Method Detail
Top

AssignKeyFieldValues (handle)

Purpose: Invoked by DataAccess:CommitChanges within the database transaction
to optionally assign key field values for new records
Notes: Assigns key field values for new records based on the
SmartTable.KeyFieldAssignmentGUID setting

Parameters:
phBeforeBuffer HANDLE
The handle of the before buffer
Top

AssignSmartRecordInformation ()

Purpose: Assign SmartRecordKey and Attachment/Comment function
Notes:

Top

CheckSystemOwned (handle)

Purpose: Checks if the user is authorized to maintain records with the
System Owned flag
Notes:

Parameters:
phBuffer HANDLE
The handle of the buffer
Top

CommitChanges (handle)

Purpose: This procedure is called from SaveChanges in the DA
to do the actual database commit and any transaction-related
validation logic for a buffer.
Notes: Override to CommitChanges in the DataAccess class. Performs cascading
deletion of SmartAttachment records
Uses Consultingwerk.SmartFramework.IRelationService to ensure
referential integrity (Delete Restrict, Delete Cascade)

Parameters:
phBuffer HANDLE
The handle of the buffer to commit
Top

ResetModifiedState (character, character)

Purpose: Resets a modification for the given table and key field values
Notes:

Parameters:
pcModifiedTable CHARACTER
The name of the database table to reset the modification for
pcKeyFieldValues CHARACTER
The values of the key fields to reset the modification for
Top

CHARACTER SourceTable (character)

Purpose: Returns the name of the source (database) table for a ProDataset
table name
Notes:

Parameters:
pcTempTableName CHARACTER
The temp-table buffer name to return the source table for
Returns CHARACTER
The database table name of the source table
Top

CHARACTER TargetColumn (character, character, handle)

Purpose: Returns the temp-table field name matching a database field name
Notes: The database table specified is the source table of the temp-table
This method should be overridden when the default functionality does
not return the proper field mapping (complex joined queries)

Parameters:
pcDatabaseTable CHARACTER
The name of the source database table
pcColumn CHARACTER
The name of the database field to return the mapped temp-table for
phDataSource HANDLE
The data source with the established mapping
Returns CHARACTER
The target (temp-table) field name
Top

TrackModifiedState (character, character)

Purpose: Tracks a modification for the given table and key field values
Notes:

Parameters:
pcModifiedTable CHARACTER
The name of the database table to track the modification for
pcKeyFieldValues CHARACTER
The values of the key fields to track the modification for


Constructor Detail
Top

SmartDataAccess (handle)

Purpose: Constructor of the SmartDataAccess class
Notes:

Parameters:
phDataset HANDLE
The handle of the Business Entity dataset


Property Detail
Top

LOGICAL DisableReferentialIntegrity


Returns LOGICAL
Top

Consultingwerk.Framework.Collections.CharacterDictionary SourceTables


Returns Consultingwerk.Framework.Collections.CharacterDictionary
Top

LOGICAL TrackDeletions


Returns LOGICAL
Top

LOGICAL UseNoWaitForReferentialIntegrity


Returns LOGICAL


©2006-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       13.04.2026 10:27:34