OpenPetra
Free Administration Software for Non-Profits
Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess Class Reference

Basic information for each general ledger on the system. Also counters for ledger-specific variables (such as last receipt number). More...

Inheritance diagram for Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess:
Ict.Common.Data.TTypedDataAccess

Public Types

enum  eSubmitChangesOperations { eUpdate = 1 , eDelete = 2 , eInsert = 4 , eAll = 7 }
 enumeration of operations that can be selected for SubmitChanges More...
 

Static Public Member Functions

static void LoadAll (DataSet ADataSet, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 this method is called by all overloads More...
 
static void LoadAll (DataSet AData, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadAll (DataSet AData, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadAll (StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadAll (TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadAll (StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerRow LoadByPrimaryKey (DataSet ADataSet, Int32 ALedgerNumber, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 this method is called by all overloads More...
 
static ALedgerRow LoadByPrimaryKey (DataSet AData, Int32 ALedgerNumber, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerRow LoadByPrimaryKey (DataSet AData, Int32 ALedgerNumber, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadByPrimaryKey (Int32 ALedgerNumber, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadByPrimaryKey (Int32 ALedgerNumber, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadByPrimaryKey (Int32 ALedgerNumber, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadUsingTemplate (DataSet ADataSet, ALedgerRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 this method is called by all overloads More...
 
static void LoadUsingTemplate (DataSet AData, ALedgerRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadUsingTemplate (DataSet AData, ALedgerRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadUsingTemplate (ALedgerRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadUsingTemplate (ALedgerRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadUsingTemplate (ALedgerRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadUsingTemplate (ALedgerRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadUsingTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 this method is called by all overloads More...
 
static void LoadUsingTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadUsingTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadUsingTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadUsingTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadUsingTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountAll (TDBTransaction ATransaction)
 this method is called by all overloads More...
 
static bool Exists (Int32 ALedgerNumber, TDBTransaction ATransaction)
 check if a row exists by using the primary key More...
 
static int CountUsingTemplate (ALedgerRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 this method is called by all overloads More...
 
static int CountUsingTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 this method is called by all overloads More...
 
static void LoadViaATaxType (DataSet ADataSet, String ATaxTypeCode, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated LoadViaLinkTable More...
 
static void LoadViaATaxType (DataSet AData, String ATaxTypeCode, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxType (DataSet AData, String ATaxTypeCode, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaATaxType (String ATaxTypeCode, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaATaxType (String ATaxTypeCode, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaATaxType (String ATaxTypeCode, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTypeTemplate (DataSet ADataSet, ATaxTypeRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaATaxTypeTemplate (DataSet AData, ATaxTypeRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTypeTemplate (DataSet AData, ATaxTypeRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaATaxTypeTemplate (ATaxTypeRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaATaxTypeTemplate (ATaxTypeRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaATaxTypeTemplate (ATaxTypeRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaATaxTypeTemplate (ATaxTypeRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTypeTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaATaxTypeTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaATaxTypeTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaATaxTypeTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaATaxTypeTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaATaxTypeTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaATaxType (String ATaxTypeCode, TDBTransaction ATransaction)
 auto generated CountViaLinkTable More...
 
static int CountViaATaxTypeTemplate (ATaxTypeRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaATaxTypeTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAAnalysisType (DataSet ADataSet, Int32 ALedgerNumber, String AAnalysisTypeCode, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated LoadViaLinkTable More...
 
static void LoadViaAAnalysisType (DataSet AData, Int32 ALedgerNumber, String AAnalysisTypeCode, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAAnalysisType (DataSet AData, Int32 ALedgerNumber, String AAnalysisTypeCode, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAAnalysisType (Int32 ALedgerNumber, String AAnalysisTypeCode, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaAAnalysisType (Int32 ALedgerNumber, String AAnalysisTypeCode, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAAnalysisType (Int32 ALedgerNumber, String AAnalysisTypeCode, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAAnalysisTypeTemplate (DataSet ADataSet, AAnalysisTypeRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaAAnalysisTypeTemplate (DataSet AData, AAnalysisTypeRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAAnalysisTypeTemplate (DataSet AData, AAnalysisTypeRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAAnalysisTypeTemplate (AAnalysisTypeRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaAAnalysisTypeTemplate (AAnalysisTypeRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAAnalysisTypeTemplate (AAnalysisTypeRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAAnalysisTypeTemplate (AAnalysisTypeRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAAnalysisTypeTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaAAnalysisTypeTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAAnalysisTypeTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAAnalysisTypeTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaAAnalysisTypeTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAAnalysisTypeTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaAAnalysisType (Int32 ALedgerNumber, String AAnalysisTypeCode, TDBTransaction ATransaction)
 auto generated CountViaLinkTable More...
 
static int CountViaAAnalysisTypeTemplate (AAnalysisTypeRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaAAnalysisTypeTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAMotivationDetail (DataSet ADataSet, Int32 ALedgerNumber, String AMotivationGroupCode, String AMotivationDetailCode, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated LoadViaLinkTable More...
 
static void LoadViaAMotivationDetail (DataSet AData, Int32 ALedgerNumber, String AMotivationGroupCode, String AMotivationDetailCode, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAMotivationDetail (DataSet AData, Int32 ALedgerNumber, String AMotivationGroupCode, String AMotivationDetailCode, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAMotivationDetail (Int32 ALedgerNumber, String AMotivationGroupCode, String AMotivationDetailCode, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaAMotivationDetail (Int32 ALedgerNumber, String AMotivationGroupCode, String AMotivationDetailCode, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAMotivationDetail (Int32 ALedgerNumber, String AMotivationGroupCode, String AMotivationDetailCode, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAMotivationDetailTemplate (DataSet ADataSet, AMotivationDetailRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaAMotivationDetailTemplate (DataSet AData, AMotivationDetailRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAMotivationDetailTemplate (DataSet AData, AMotivationDetailRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAMotivationDetailTemplate (AMotivationDetailRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaAMotivationDetailTemplate (AMotivationDetailRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAMotivationDetailTemplate (AMotivationDetailRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAMotivationDetailTemplate (AMotivationDetailRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAMotivationDetailTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaAMotivationDetailTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaAMotivationDetailTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAMotivationDetailTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaAMotivationDetailTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaAMotivationDetailTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaAMotivationDetail (Int32 ALedgerNumber, String AMotivationGroupCode, String AMotivationDetailCode, TDBTransaction ATransaction)
 auto generated CountViaLinkTable More...
 
static int CountViaAMotivationDetailTemplate (AMotivationDetailRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaAMotivationDetailTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaASubSystem (DataSet ADataSet, String ASubSystemCode, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated LoadViaLinkTable More...
 
static void LoadViaASubSystem (DataSet AData, String ASubSystemCode, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaASubSystem (DataSet AData, String ASubSystemCode, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaASubSystem (String ASubSystemCode, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaASubSystem (String ASubSystemCode, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaASubSystem (String ASubSystemCode, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaASubSystemTemplate (DataSet ADataSet, ASubSystemRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaASubSystemTemplate (DataSet AData, ASubSystemRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaASubSystemTemplate (DataSet AData, ASubSystemRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaASubSystemTemplate (ASubSystemRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaASubSystemTemplate (ASubSystemRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaASubSystemTemplate (ASubSystemRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaASubSystemTemplate (ASubSystemRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaASubSystemTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaASubSystemTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaASubSystemTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaASubSystemTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaASubSystemTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaASubSystemTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaASubSystem (String ASubSystemCode, TDBTransaction ATransaction)
 auto generated CountViaLinkTable More...
 
static int CountViaASubSystemTemplate (ASubSystemRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaASubSystemTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaSGroup (DataSet ADataSet, String AGroupId, Int64 AUnitKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated LoadViaLinkTable More...
 
static void LoadViaSGroup (DataSet AData, String AGroupId, Int64 AUnitKey, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaSGroup (DataSet AData, String AGroupId, Int64 AUnitKey, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaSGroup (String AGroupId, Int64 AUnitKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaSGroup (String AGroupId, Int64 AUnitKey, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaSGroup (String AGroupId, Int64 AUnitKey, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaSGroupTemplate (DataSet ADataSet, SGroupRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaSGroupTemplate (DataSet AData, SGroupRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaSGroupTemplate (DataSet AData, SGroupRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaSGroupTemplate (SGroupRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaSGroupTemplate (SGroupRow ATemplateRow, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaSGroupTemplate (SGroupRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaSGroupTemplate (SGroupRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaSGroupTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static void LoadViaSGroupTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void LoadViaSGroupTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaSGroupTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 auto generated More...
 
static ALedgerTable LoadViaSGroupTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static ALedgerTable LoadViaSGroupTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaSGroup (String AGroupId, Int64 AUnitKey, TDBTransaction ATransaction)
 auto generated CountViaLinkTable More...
 
static int CountViaSGroupTemplate (SGroupRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static int CountViaSGroupTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void DeleteByPrimaryKey (Int32 ALedgerNumber, TDBTransaction ATransaction)
 auto generated More...
 
static void DeleteUsingTemplate (ALedgerRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 auto generated More...
 
static void DeleteUsingTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 auto generated More...
 
static void SubmitChanges (ALedgerTable ATable, TDBTransaction ATransaction)
 Auto generated code ... More...
 
static void AddOrModifyRecord (Int32 ALedgerNumber, ALedgerTable ATable, ALedgerRow ANewRow, bool ADoNotOverwrite, TDBTransaction ATransaction)
 
static bool NoDefaultColumn (String AColumnName)
 This function returns true if the column name is not one of the special columns, that are written automatically: modified date and by, created date and by, modification id More...
 
static void GetStoredModification (short ATableId, string[] AColumnNames, int[] APrimKeyColumnOrdList, DataRow ADataRow, DB.TDBTransaction ATransaction, out DateTime AModificationID, out String AModifiedBy, out System.DateTime AModifiedDate, bool ATreatRowAsAdded=false)
 This function returns the modification details of a row More...
 
static void InsertRow (short ATableId, ref DataRow ADataRow, String ACurrentUser, StringBuilder AInsertStatement, List< OdbcParameter >AInsertParameters)
 This function is called by the DataStore (SubmitChanges). it will not update the modification id. More...
 
static void InsertRow (short ATableId, ref DataRow ADataRow, TDBTransaction ATransaction, String ACurrentUser, bool ATreatRowAsAdded)
 This function is called by the DataStore (SubmitChanges). it will update the modification id. More...
 
static void UpdateRow (short ATableId, bool AThrowAwayAfterSubmitChanges, ref DataRow ADataRow, DB.TDBTransaction ATransaction, String ACurrentUser)
 This function is called by the DataStore (SubmitChanges) More...
 
static void DeleteRow (short ATableId, DataRow ADataRow, DB.TDBTransaction ATransaction)
 This function is called by the DataStore (SubmitChanges) More...
 
static String GenerateSelectClause (StringCollection AFieldList, short ATableID, bool AIncludeTableNames=false)
 This function expects a StringCollection that can be filled, empty or nil. It also needs the list of the primary key columns, because otherwise the returned row will fail the constraints. It will return a proper Select Clause. More...
 
static String GenerateSelectClauseLong (String ATableName, StringCollection AFieldList, short ATableId)
 This function expects a StringCollection that can be filled, empty or nil. It also needs the list of the primary key columns, because otherwise the returned row will fail the constraints. It will prefix all fields with the given tablename. needed for selecting from join statements. It will return a proper Select Clause. If a field has already a dot in the name, the ATablename is not put before it: That way you can do SUM(PUB_table.p_something). More...
 
static String GenerateWhereClause (string[] AColumnNames, DataRow ADataRow, StringCollection ATemplateOperators)
 This function expects an empty table that contains all existing columns, and a datarow that has a string or an empty value for each column. It will return a Where clause, using the given values. More...
 
static String GenerateWhereClause (string[] AColumnNames, DataRow ADataRow)
 This function expects an empty table that contains all existing columns, and a datarow that has a string or an empty value for each column. It will return a Where clause, using the given values. More...
 
static String GenerateWhereClause (TSearchCriteria[] ASearchCriteria)
 This function expects an empty table that contains all existing columns, and search criteria. It will return a Where clause, using the given values. More...
 
static String GenerateWhereClauseFromPrimaryKey (short ATableId)
 this function generates a where clause for the primary key of the given table More...
 
static String GenerateWhereClauseFromUniqueKey (short ATableId)
 this function generates a where clause for the unique key of the given table More...
 
static String GenerateWhereClauseLong (String ATableName, short ATableId, DataRow ADataRow, StringCollection ATemplateOperators)
 This function expects a string list of all existing columns, and a datarow that has a value or an empty value for each column. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname More...
 
static String GenerateWhereClauseLong (String ATableName, TSearchCriteria[] ASearchCriteria)
 This function expects a string list of all existing columns, and a criteria list of values to search for. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname More...
 
static String GenerateWhereClauseLong (String ATableName, short ATableId, DataRow ADataRow)
 This function expects a string array with the names of all existing columns, and a datarow that has a value or an empty value for each column. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname More...
 
static String GenerateOrderByClause (StringCollection AOrderBy)
 This function expects a list of string, where the first string is either "order by" or "group by", and the rest of the string is e.g. "p_partner.p_partner_key_n ASC" It will return the appropriate part of the sql query More...
 
static OdbcParameter CreateOdbcParameter (short ATableId, Int32 AColumnNr, Type AType)
 This function creates an odbc parameter with the correct type, based on the obj which comes from a DataRow More...
 
static System.Object GetSafeValue (DataRow ADataRow, System.Int32 AColumnNr, DataRowVersion AVersion)
 This function returns either a valid object or System.DBNull; this is necessary because mono sometimes has a nil pointer in the DataRow for the original version etc. More...
 
static System.Object GetSafeValue (DataRow ADataRow, String AColumnName, DataRowVersion AVersion)
 This function returns either a valid object or System.DBNull; this is necessary because mono sometimes has a nil pointer in the DataRow for the original version etc. More...
 
static bool NotEquals (DataRow ADataRow, System.Int32 AColumnNr, ref System.Object ACurrentValue)
 Compare the original and the current value of a column in a datarow. Make sure some mono specific troubles are worked around. More...
 
static OdbcParameter[] GetParametersForWhereClause (short ATableId, DataRow ADataRow)
 This function provides the actual parameters for the GenerateWhereClause uses only the values that are not DBNULL More...
 
static OdbcParameter[] GetParametersForWhereClause (short ATableNumber, TSearchCriteria[] ASearchCriteria)
 This function provides the actual parameters for the GenerateWhereClause More...
 
static OdbcParameter[] GetParametersForWhereClauseWithPrimaryKey (short ATableId, DataRow ADataRow)
 This function provides the actual parameters for the GenerateWhereClause uses only the values that are not DBNULL More...
 
static List< OdbcParameter > GetParametersForInsertClause (short ATableId, ref DataRow ADataRow, Int32 ANumberDBColumns, String ACurrentUser, bool AIncludeDefaultColumns)
 This function provides the actual parameters for the GenerateInsertClause uses only the values that are not DBNULL adds the next modification ID More...
 
static OdbcParameter[] GetParametersForUpdateClause (short ATableId, ref DataRow ADataRow, int[] APrimaryKeyColumnOrd, Int32 ANumberDBColumns, String ACurrentUser)
 This function provides the actual parameters for the GenerateUpdateClause uses only the values that are changed (comparing the current and the original version of the row) More...
 
static OdbcParameter[] GetParametersForDeleteClause (short ATableId, DataRow ADataRow, int[] APrimaryKeyColumnOrd)
 This function provides the actual parameters for the GenerateDeleteClause it uses the OriginalVersion of the primary key values More...
 
static String GenerateInsertClause (String ATableName, string[] AColumnNames, DataRow ADataRow, bool AIncludeDefaultColumns)
 This function expects an empty table that contains all existing columns, and a datarow that has a value or an empty value for each column. It will return a complete INSERT Clause. More...
 
static String GenerateUpdateClause (String ATableName, string[] AColumnNames, DataRow ADataRow, int[] APrimKeyColumnOrdList)
 This function expects an empty table that contains all existing columns, and a datarow that has a value or an empty value for each column. More...
 
static DataRow LoadByPrimaryKey (short ATableId, DataSet ADataSet, System.Object[] APrimaryKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 load data row by primary key into a dataset More...
 
static DataRow LoadByPrimaryKey (short ATableId, TTypedDataTable ADataTable, System.Object[] APrimaryKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 different version for data table More...
 
static void LoadByUniqueKey (short ATableId, DataSet ADataSet, System.Object[] AUniqueKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 load data row by unique key into a dataset More...
 
static void LoadByUniqueKey (short ATableId, TTypedDataTable ADataTable, System.Object[] AUniqueKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 different version for data table More...
 
static void LoadViaForeignKey (short ATableId, short AOtherTableId, DataSet ADataSet, string[] AThisFieldNames, System.Object[] AForeignKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 load data for the current table via a foreign key, eg. load all extracts created by user x More...
 
static void LoadViaForeignKey (short ATableId, short AOtherTableId, TTypedDataTable ADataTable, string[] AThisFieldNames, System.Object[] AForeignKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 load data for the current table via a foreign key, eg. load all extracts created by user x More...
 
static void LoadViaForeignKey (short ATableId, short AOtherTableId, DataSet ADataSet, string[] AThisFieldNames, DataRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 Load via other table, using template values. More...
 
static void LoadViaForeignKey (short ATableId, short AOtherTableId, TTypedDataTable ADataTable, string[] AThisFieldNames, DataRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 Load via other table, using template values. More...
 
static void LoadViaForeignKey (short ATableId, short AOtherTableId, DataSet ADataSet, string[] AThisFieldNames, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 Load via other table, using template values. More...
 
static void LoadViaForeignKey (short ATableId, short AOtherTableId, TTypedDataTable ADataTable, string[] AThisFieldNames, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 Load via other table, using template values. More...
 
static int CountViaForeignKey (short ATableId, short AOtherTableId, string[] AThisFieldNames, System.Object[] AForeignKeyValues, TDBTransaction ATransaction)
 count the rows by the values of a foreign key More...
 
static int CountViaForeignKey (short ATableId, short AOtherTableId, string[] AThisFieldNames, DataRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 count the rows by the values of a foreign key More...
 
static int CountViaForeignKey (short ATableId, short AOtherTableId, string[] AThisFieldNames, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 count the rows by the values of a foreign key More...
 
static void DeleteByPrimaryKey (short ATableId, System.Object[] APrimaryKeyValues, TDBTransaction ATransaction)
 delete by primary key values More...
 
static bool Exists (short ATableId, System.Object[] APrimaryKeyValues, TDBTransaction ATransaction)
 check if row exists with the primary key More...
 
static bool ExistsUniqueKey (short ATableId, System.Object[] AUniqueKeyValues, TDBTransaction ATransaction)
 check if row exists with the unique key More...
 
static void LoadUsingTemplate (short ATableID, DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 loads all rows matching certain search criteria into a dataset More...
 
static void LoadUsingTemplate (short ATableID, TTypedDataTable ATypedTableToLoad, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 loads all rows matching certain search criteria into a typed data table More...
 
static void LoadUsingTemplate (short ATableId, DataSet ADataSet, DataRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 load using a template row More...
 
static void LoadUsingTemplate (short ATableId, TTypedDataTable ADataTable, DataRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
 load using a template row More...
 
static void DeleteUsingTemplate (short ATableId, DataRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
 delete all rows matching the given row More...
 
static void DeleteUsingTemplate (short ATableId, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
 delete all rows matching the search criteria More...
 
static void SubmitChanges (TTypedDataTable ATable, TDBTransaction ATransaction, eSubmitChangesOperations ASelectedOperations, string AUserId, string ASequenceName, string ASequenceField)
 submit those rows in the table that have been modified or created or deleted More...
 
static void SubmitChanges (TTypedDataTable ATable, TDBTransaction ATransaction, string AUserId, string ASequenceName, string ASequenceField)
 overloaded version without ASelectedOperations More...
 
static void SubmitChanges (TTypedDataTable ATable, TDBTransaction ATransaction, string AUserId)
 overloaded version without sequence More...
 
static void SubmitChanges (TTypedDataTable ATable, TDBTransaction ATransaction, eSubmitChangesOperations ASelectedOperations, string AUserId)
 overloaded version without sequence, but with ASelectedOperations More...
 
static TVerificationResultCollection BuildVerificationResultCollectionFromRefTables (string AThisTable, string AThisTableLabel, Dictionary< string, object >APKInfo, List< TRowReferenceInfo >AReferences, TResultSeverity AResultSeverity=TResultSeverity.Resv_Critical)
 Builds a TVerificationResultCollection from DB Table references created by a cascading count Method. It will contain only a single TVerificationResult. More...
 

Static Public Attributes

const string DATATABLENAME = "ALedger"
 CamelCase version of table name. More...
 
const string DBTABLENAME = "a_ledger"
 original table name in database More...
 
const string MODIFICATION_ID = "s_modification_id_t"
 name of the column used for tracking changes, one ID per change More...
 
const string MODIFIED_BY = "s_modified_by_c"
 who has last modified the row More...
 
const string MODIFIED_DATE = "s_date_modified_d"
 when was the last change to the row More...
 
const string CREATED_BY = "s_created_by_c"
 who has originally created this row More...
 
const string CREATED_DATE = "s_date_created_d"
 when was this row originally created More...
 
static readonly DateTime MODIFICATION_ID_DELETEDROW_INDICATOR = DateTime.MaxValue
 indicates whether a row has been deleted More...
 

Detailed Description

Basic information for each general ledger on the system. Also counters for ledger-specific variables (such as last receipt number).

Member Enumeration Documentation

◆ eSubmitChangesOperations

enumeration of operations that can be selected for SubmitChanges

Enumerator
eUpdate 

update records

eDelete 

delete records

eInsert 

add new records

eAll 

execute all operations, no matter if it is update, delete, insert

Member Function Documentation

◆ AddOrModifyRecord()

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.AddOrModifyRecord ( Int32  ALedgerNumber,
ALedgerTable  ATable,
ALedgerRow  ANewRow,
bool  ADoNotOverwrite,
TDBTransaction  ATransaction 
)
inlinestatic

If a record with this primary key already exists in the database, that record will be updated. otherwise a new record will be added.

◆ BuildVerificationResultCollectionFromRefTables()

static TVerificationResultCollection Ict.Common.Data.TTypedDataAccess.BuildVerificationResultCollectionFromRefTables ( string  AThisTable,
string  AThisTableLabel,
Dictionary< string, object >  APKInfo,
List< TRowReferenceInfo AReferences,
TResultSeverity  AResultSeverity = TResultSeverity.Resv_Critical 
)
inlinestaticinherited

Builds a TVerificationResultCollection from DB Table references created by a cascading count Method. It will contain only a single TVerificationResult.

Returns
TVerificationResultCollection from DB Table references created by a cascading count Method. In case AReferences does not contain elements a TVerificationResultCollection containing no elements will be returned.
Parameters
AThisTableName of the DB Table (as in the DB) that the references point to.
AThisTableLabelLabel (='friendly name' for the user) of the DB Table that the references point to.
APKInfoDictionary<T, T> consisting of a string-object pair for each Primary Key Column. The string (Key) is the Label ('friendly name' for the user) of the PK Column and the object (Value) holds the actual data of the PK Column.
AReferencesA List<T> of TRowReferenceInfo objects that contain information about the DB Table references created by a cascading count Method.
AResultSeverityAllows the specification of a TResultSeverity for the TVerificationResult that gets added to the return value. (Default=TResultSeverity.Resv_Critical.)
Returns
A TVerificationResultCollection containing a single TVerificationResult that contains information about DB Table references created by a cascading count Method.

◆ CountAll()

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountAll ( TDBTransaction  ATransaction)
inlinestatic

this method is called by all overloads

◆ CountUsingTemplate() [1/2]

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountUsingTemplate ( ALedgerRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

this method is called by all overloads

◆ CountUsingTemplate() [2/2]

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountUsingTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

this method is called by all overloads

◆ CountViaAAnalysisType()

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaAAnalysisType ( Int32  ALedgerNumber,
String  AAnalysisTypeCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated CountViaLinkTable

◆ CountViaAAnalysisTypeTemplate() [1/2]

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaAAnalysisTypeTemplate ( AAnalysisTypeRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaAAnalysisTypeTemplate() [2/2]

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaAAnalysisTypeTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaAMotivationDetail()

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaAMotivationDetail ( Int32  ALedgerNumber,
String  AMotivationGroupCode,
String  AMotivationDetailCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated CountViaLinkTable

◆ CountViaAMotivationDetailTemplate() [1/2]

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaAMotivationDetailTemplate ( AMotivationDetailRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaAMotivationDetailTemplate() [2/2]

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaAMotivationDetailTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaASubSystem()

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaASubSystem ( String  ASubSystemCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated CountViaLinkTable

◆ CountViaASubSystemTemplate() [1/2]

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaASubSystemTemplate ( ASubSystemRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaASubSystemTemplate() [2/2]

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaASubSystemTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaATaxType()

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaATaxType ( String  ATaxTypeCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated CountViaLinkTable

◆ CountViaATaxTypeTemplate() [1/2]

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaATaxTypeTemplate ( ATaxTypeRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaATaxTypeTemplate() [2/2]

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaATaxTypeTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaForeignKey() [1/3]

static int Ict.Common.Data.TTypedDataAccess.CountViaForeignKey ( short  ATableId,
short  AOtherTableId,
string[]  AThisFieldNames,
DataRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestaticinherited

count the rows by the values of a foreign key

◆ CountViaForeignKey() [2/3]

static int Ict.Common.Data.TTypedDataAccess.CountViaForeignKey ( short  ATableId,
short  AOtherTableId,
string[]  AThisFieldNames,
System.Object[]  AForeignKeyValues,
TDBTransaction  ATransaction 
)
inlinestaticinherited

count the rows by the values of a foreign key

◆ CountViaForeignKey() [3/3]

static int Ict.Common.Data.TTypedDataAccess.CountViaForeignKey ( short  ATableId,
short  AOtherTableId,
string[]  AThisFieldNames,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestaticinherited

count the rows by the values of a foreign key

◆ CountViaSGroup()

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaSGroup ( String  AGroupId,
Int64  AUnitKey,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated CountViaLinkTable

◆ CountViaSGroupTemplate() [1/2]

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaSGroupTemplate ( SGroupRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CountViaSGroupTemplate() [2/2]

static int Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.CountViaSGroupTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ CreateOdbcParameter()

static OdbcParameter Ict.Common.Data.TTypedDataAccess.CreateOdbcParameter ( short  ATableId,
Int32  AColumnNr,
Type  AType 
)
inlinestaticinherited

This function creates an odbc parameter with the correct type, based on the obj which comes from a DataRow

Parameters
ATableIdTable that we are operating on
AColumnNrwhich column should the parameter be generated for
ATypethe value that needs to be converted to OdbcParameter
Returns
the Odbc parameter

◆ DeleteByPrimaryKey() [1/2]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.DeleteByPrimaryKey ( Int32  ALedgerNumber,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ DeleteByPrimaryKey() [2/2]

static void Ict.Common.Data.TTypedDataAccess.DeleteByPrimaryKey ( short  ATableId,
System.Object[]  APrimaryKeyValues,
TDBTransaction  ATransaction 
)
inlinestaticinherited

delete by primary key values

Parameters
ATableId
APrimaryKeyValues
ATransaction

◆ DeleteRow()

static void Ict.Common.Data.TTypedDataAccess.DeleteRow ( short  ATableId,
DataRow  ADataRow,
DB.TDBTransaction  ATransaction 
)
inlinestaticinherited

This function is called by the DataStore (SubmitChanges)

Returns
void

◆ DeleteUsingTemplate() [1/4]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.DeleteUsingTemplate ( ALedgerRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ DeleteUsingTemplate() [2/4]

static void Ict.Common.Data.TTypedDataAccess.DeleteUsingTemplate ( short  ATableId,
DataRow  ATemplateRow,
StringCollection  ATemplateOperators,
TDBTransaction  ATransaction 
)
inlinestaticinherited

delete all rows matching the given row

Parameters
ATableId
ATemplateRow
ATemplateOperators
ATransaction

◆ DeleteUsingTemplate() [3/4]

static void Ict.Common.Data.TTypedDataAccess.DeleteUsingTemplate ( short  ATableId,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestaticinherited

delete all rows matching the search criteria

Parameters
ATableIdspecify which typed table is used
ASearchCriteria
ATransaction

◆ DeleteUsingTemplate() [4/4]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.DeleteUsingTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ Exists() [1/2]

static bool Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.Exists ( Int32  ALedgerNumber,
TDBTransaction  ATransaction 
)
inlinestatic

check if a row exists by using the primary key

◆ Exists() [2/2]

static bool Ict.Common.Data.TTypedDataAccess.Exists ( short  ATableId,
System.Object[]  APrimaryKeyValues,
TDBTransaction  ATransaction 
)
inlinestaticinherited

check if row exists with the primary key

Parameters
ATableId
APrimaryKeyValues
ATransaction

◆ ExistsUniqueKey()

static bool Ict.Common.Data.TTypedDataAccess.ExistsUniqueKey ( short  ATableId,
System.Object[]  AUniqueKeyValues,
TDBTransaction  ATransaction 
)
inlinestaticinherited

check if row exists with the unique key

Parameters
ATableId
AUniqueKeyValues
ATransaction

◆ GenerateInsertClause()

static String Ict.Common.Data.TTypedDataAccess.GenerateInsertClause ( String  ATableName,
string[]  AColumnNames,
DataRow  ADataRow,
bool  AIncludeDefaultColumns 
)
inlinestaticinherited

This function expects an empty table that contains all existing columns, and a datarow that has a value or an empty value for each column. It will return a complete INSERT Clause.

Returns
the INSERT statement

◆ GenerateOrderByClause()

static String Ict.Common.Data.TTypedDataAccess.GenerateOrderByClause ( StringCollection  AOrderBy)
inlinestaticinherited

This function expects a list of string, where the first string is either "order by" or "group by", and the rest of the string is e.g. "p_partner.p_partner_key_n ASC" It will return the appropriate part of the sql query

Parameters
AOrderByString list with instructions how to order or group the result
Returns
the order by / group by clause

◆ GenerateSelectClause()

static String Ict.Common.Data.TTypedDataAccess.GenerateSelectClause ( StringCollection  AFieldList,
short  ATableID,
bool  AIncludeTableNames = false 
)
inlinestaticinherited

This function expects a StringCollection that can be filled, empty or nil. It also needs the list of the primary key columns, because otherwise the returned row will fail the constraints. It will return a proper Select Clause.

Returns
the Select Clause

◆ GenerateSelectClauseLong()

static String Ict.Common.Data.TTypedDataAccess.GenerateSelectClauseLong ( String  ATableName,
StringCollection  AFieldList,
short  ATableId 
)
inlinestaticinherited

This function expects a StringCollection that can be filled, empty or nil. It also needs the list of the primary key columns, because otherwise the returned row will fail the constraints. It will prefix all fields with the given tablename. needed for selecting from join statements. It will return a proper Select Clause. If a field has already a dot in the name, the ATablename is not put before it: That way you can do SUM(PUB_table.p_something).

Returns
the Select Clause

◆ GenerateUpdateClause()

static String Ict.Common.Data.TTypedDataAccess.GenerateUpdateClause ( String  ATableName,
string[]  AColumnNames,
DataRow  ADataRow,
int[]  APrimKeyColumnOrdList 
)
inlinestaticinherited

This function expects an empty table that contains all existing columns, and a datarow that has a value or an empty value for each column.

Returns
the UPDATE statement

◆ GenerateWhereClause() [1/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClause ( string[]  AColumnNames,
DataRow  ADataRow 
)
inlinestaticinherited

This function expects an empty table that contains all existing columns, and a datarow that has a string or an empty value for each column. It will return a Where clause, using the given values.

Returns
the Where Clause

◆ GenerateWhereClause() [2/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClause ( string[]  AColumnNames,
DataRow  ADataRow,
StringCollection  ATemplateOperators 
)
inlinestaticinherited

This function expects an empty table that contains all existing columns, and a datarow that has a string or an empty value for each column. It will return a Where clause, using the given values.

Parameters
AColumnNamesthe column names
ADataRowthe data row with the the columns for the where clause
ATemplateOperatorsEvery template field can have an operator; the default version always used = or LIKE
Returns
the Where Clause

◆ GenerateWhereClause() [3/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClause ( TSearchCriteria[]  ASearchCriteria)
inlinestaticinherited

This function expects an empty table that contains all existing columns, and search criteria. It will return a Where clause, using the given values.

Parameters
ASearchCriteria
Returns
the Where Clause

◆ GenerateWhereClauseFromPrimaryKey()

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseFromPrimaryKey ( short  ATableId)
inlinestaticinherited

this function generates a where clause for the primary key of the given table

Parameters
ATableId
Returns

◆ GenerateWhereClauseFromUniqueKey()

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseFromUniqueKey ( short  ATableId)
inlinestaticinherited

this function generates a where clause for the unique key of the given table

Parameters
ATableId
Returns

◆ GenerateWhereClauseLong() [1/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseLong ( String  ATableName,
short  ATableId,
DataRow  ADataRow 
)
inlinestaticinherited

This function expects a string array with the names of all existing columns, and a datarow that has a value or an empty value for each column. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname

Parameters
ATableNamethe table that the where clause is generated for
ATableIdid of the table to get the list of all columns of that table
ADataRowcontains the values for the where clause
Returns
the Where Clause

◆ GenerateWhereClauseLong() [2/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseLong ( String  ATableName,
short  ATableId,
DataRow  ADataRow,
StringCollection  ATemplateOperators 
)
inlinestaticinherited

This function expects a string list of all existing columns, and a datarow that has a value or an empty value for each column. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname

Parameters
ATableNamethe table that the where clause is generated for
ATableIdid of the table to get the list of all columns of that table
ADataRowcontains the values for the where clause
ATemplateOperatorsEvery template field can have an operator; the default version always used = or LIKE
Returns
the Where Clause

◆ GenerateWhereClauseLong() [3/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseLong ( String  ATableName,
TSearchCriteria[]  ASearchCriteria 
)
inlinestaticinherited

This function expects a string list of all existing columns, and a criteria list of values to search for. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname

Parameters
ATableNamethe table that the where clause is generated for
ASearchCriteria
Returns
the Where Clause

◆ GetParametersForDeleteClause()

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForDeleteClause ( short  ATableId,
DataRow  ADataRow,
int[]  APrimaryKeyColumnOrd 
)
inlinestaticinherited

This function provides the actual parameters for the GenerateDeleteClause it uses the OriginalVersion of the primary key values

Parameters
ATableId
ADataRowvalues that are used as parameters
APrimaryKeyColumnOrdhas the order numbers of the columns that make up the primary key
Returns
an array of OdbcParameters

◆ GetParametersForInsertClause()

static List< OdbcParameter > Ict.Common.Data.TTypedDataAccess.GetParametersForInsertClause ( short  ATableId,
ref DataRow  ADataRow,
Int32  ANumberDBColumns,
String  ACurrentUser,
bool  AIncludeDefaultColumns 
)
inlinestaticinherited

This function provides the actual parameters for the GenerateInsertClause uses only the values that are not DBNULL adds the next modification ID

Parameters
ATableId
ADataRowvalues that are used as parameters
ANumberDBColumnsthe number of columns of this row that should be stored in the database; that allows some columns to be added temporarily, e.g. PPartnerLocation.BestAddress in PartnerEdit Dataset
ACurrentUserfor setting modified by
AIncludeDefaultColumnsonly useful when saving many rows in one query
Returns
an array of OdbcParameters

◆ GetParametersForUpdateClause()

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForUpdateClause ( short  ATableId,
ref DataRow  ADataRow,
int[]  APrimaryKeyColumnOrd,
Int32  ANumberDBColumns,
String  ACurrentUser 
)
inlinestaticinherited

This function provides the actual parameters for the GenerateUpdateClause uses only the values that are changed (comparing the current and the original version of the row)

Parameters
ATableId
ADataRowvalues that are used as parameters
APrimaryKeyColumnOrdcan be empty; is needed for the UPDATE WHERE statement; it has the order numbers of the columns that make up the primary key
ANumberDBColumnsthe number of columns of this row that should be stored in the database; that allows some columns to be added temporarily, e.g. PPartnerLocation.BestAddress in PartnerEdit Dataset
ACurrentUserfor setting modified by
Returns
an array of OdbcParameters

◆ GetParametersForWhereClause() [1/2]

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForWhereClause ( short  ATableId,
DataRow  ADataRow 
)
inlinestaticinherited

This function provides the actual parameters for the GenerateWhereClause uses only the values that are not DBNULL

Returns
an array of OdbcParameters

◆ GetParametersForWhereClause() [2/2]

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForWhereClause ( short  ATableNumber,
TSearchCriteria[]  ASearchCriteria 
)
inlinestaticinherited

This function provides the actual parameters for the GenerateWhereClause

Returns
an array of OdbcParameters

◆ GetParametersForWhereClauseWithPrimaryKey()

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForWhereClauseWithPrimaryKey ( short  ATableId,
DataRow  ADataRow 
)
inlinestaticinherited

This function provides the actual parameters for the GenerateWhereClause uses only the values that are not DBNULL

Parameters
ADataRowvalues that are used as parameters
ATableIdidentifier of the table to get the primary key from it
Returns
an array of OdbcParameters

◆ GetSafeValue() [1/2]

static System.Object Ict.Common.Data.TTypedDataAccess.GetSafeValue ( DataRow  ADataRow,
String  AColumnName,
DataRowVersion  AVersion 
)
inlinestaticinherited

This function returns either a valid object or System.DBNull; this is necessary because mono sometimes has a nil pointer in the DataRow for the original version etc.

Returns
either a valid object or System.DBNull

◆ GetSafeValue() [2/2]

static System.Object Ict.Common.Data.TTypedDataAccess.GetSafeValue ( DataRow  ADataRow,
System.Int32  AColumnNr,
DataRowVersion  AVersion 
)
inlinestaticinherited

This function returns either a valid object or System.DBNull; this is necessary because mono sometimes has a nil pointer in the DataRow for the original version etc.

Returns
either a valid object or System.DBNull

◆ GetStoredModification()

static void Ict.Common.Data.TTypedDataAccess.GetStoredModification ( short  ATableId,
string[]  AColumnNames,
int[]  APrimKeyColumnOrdList,
DataRow  ADataRow,
DB.TDBTransaction  ATransaction,
out DateTime  AModificationID,
out String  AModifiedBy,
out System.DateTime  AModifiedDate,
bool  ATreatRowAsAdded = false 
)
inlinestaticinherited

This function returns the modification details of a row

Returns
void

◆ InsertRow() [1/2]

static void Ict.Common.Data.TTypedDataAccess.InsertRow ( short  ATableId,
ref DataRow  ADataRow,
String  ACurrentUser,
StringBuilder  AInsertStatement,
List< OdbcParameter >  AInsertParameters 
)
inlinestaticinherited

This function is called by the DataStore (SubmitChanges). it will not update the modification id.

◆ InsertRow() [2/2]

static void Ict.Common.Data.TTypedDataAccess.InsertRow ( short  ATableId,
ref DataRow  ADataRow,
TDBTransaction  ATransaction,
String  ACurrentUser,
bool  ATreatRowAsAdded 
)
inlinestaticinherited

This function is called by the DataStore (SubmitChanges). it will update the modification id.

◆ LoadAll() [1/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadAll ( DataSet  AData,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadAll() [2/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadAll ( DataSet  AData,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadAll() [3/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadAll ( DataSet  ADataSet,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

this method is called by all overloads

◆ LoadAll() [4/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadAll ( StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadAll() [5/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadAll ( StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadAll() [6/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadAll ( TDBTransaction  ATransaction)
inlinestatic

auto generated

◆ LoadByPrimaryKey() [1/8]

static ALedgerRow Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadByPrimaryKey ( DataSet  AData,
Int32  ALedgerNumber,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadByPrimaryKey() [2/8]

static ALedgerRow Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadByPrimaryKey ( DataSet  AData,
Int32  ALedgerNumber,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadByPrimaryKey() [3/8]

static ALedgerRow Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadByPrimaryKey ( DataSet  ADataSet,
Int32  ALedgerNumber,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

this method is called by all overloads

◆ LoadByPrimaryKey() [4/8]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadByPrimaryKey ( Int32  ALedgerNumber,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadByPrimaryKey() [5/8]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadByPrimaryKey ( Int32  ALedgerNumber,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadByPrimaryKey() [6/8]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadByPrimaryKey ( Int32  ALedgerNumber,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadByPrimaryKey() [7/8]

static DataRow Ict.Common.Data.TTypedDataAccess.LoadByPrimaryKey ( short  ATableId,
DataSet  ADataSet,
System.Object[]  APrimaryKeyValues,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

load data row by primary key into a dataset

Parameters
ATableId
ADataSet
APrimaryKeyValues
AFieldList
ATransaction
AOrderBy
AStartRecord
AMaxRecords

◆ LoadByPrimaryKey() [8/8]

static DataRow Ict.Common.Data.TTypedDataAccess.LoadByPrimaryKey ( short  ATableId,
TTypedDataTable  ADataTable,
System.Object[]  APrimaryKeyValues,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

different version for data table

◆ LoadByUniqueKey() [1/2]

static void Ict.Common.Data.TTypedDataAccess.LoadByUniqueKey ( short  ATableId,
DataSet  ADataSet,
System.Object[]  AUniqueKeyValues,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

load data row by unique key into a dataset

Parameters
ATableId
ADataSet
AUniqueKeyValues
AFieldList
ATransaction
AOrderBy
AStartRecord
AMaxRecords

◆ LoadByUniqueKey() [2/2]

static void Ict.Common.Data.TTypedDataAccess.LoadByUniqueKey ( short  ATableId,
TTypedDataTable  ADataTable,
System.Object[]  AUniqueKeyValues,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

different version for data table

◆ LoadUsingTemplate() [1/17]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( ALedgerRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [2/17]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( ALedgerRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [3/17]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( ALedgerRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [4/17]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( ALedgerRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [5/17]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( DataSet  AData,
ALedgerRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [6/17]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( DataSet  AData,
ALedgerRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [7/17]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [8/17]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [9/17]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( DataSet  ADataSet,
ALedgerRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

this method is called by all overloads

◆ LoadUsingTemplate() [10/17]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

this method is called by all overloads

◆ LoadUsingTemplate() [11/17]

static void Ict.Common.Data.TTypedDataAccess.LoadUsingTemplate ( short  ATableId,
DataSet  ADataSet,
DataRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

load using a template row

◆ LoadUsingTemplate() [12/17]

static void Ict.Common.Data.TTypedDataAccess.LoadUsingTemplate ( short  ATableID,
DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

loads all rows matching certain search criteria into a dataset

Parameters
ATableIDspecify which typed table is used
ADataSetthe result will be added to this dataset
ASearchCriteria
AFieldListfields to load from the database table
ATransaction
AOrderBy
AStartRecord
AMaxRecords

◆ LoadUsingTemplate() [13/17]

static void Ict.Common.Data.TTypedDataAccess.LoadUsingTemplate ( short  ATableId,
TTypedDataTable  ADataTable,
DataRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

load using a template row

◆ LoadUsingTemplate() [14/17]

static void Ict.Common.Data.TTypedDataAccess.LoadUsingTemplate ( short  ATableID,
TTypedDataTable  ATypedTableToLoad,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

loads all rows matching certain search criteria into a typed data table

Parameters
ATableIDspecify which typed table is used
ATypedTableToLoadpre condition: has to have an object of the typed table
ASearchCriteria
AFieldList
ATransaction
AOrderBy
AStartRecord
AMaxRecords

◆ LoadUsingTemplate() [15/17]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [16/17]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadUsingTemplate() [17/17]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadUsingTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisType() [1/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisType ( DataSet  AData,
Int32  ALedgerNumber,
String  AAnalysisTypeCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisType() [2/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisType ( DataSet  AData,
Int32  ALedgerNumber,
String  AAnalysisTypeCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisType() [3/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisType ( DataSet  ADataSet,
Int32  ALedgerNumber,
String  AAnalysisTypeCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated LoadViaLinkTable

◆ LoadViaAAnalysisType() [4/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisType ( Int32  ALedgerNumber,
String  AAnalysisTypeCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisType() [5/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisType ( Int32  ALedgerNumber,
String  AAnalysisTypeCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisType() [6/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisType ( Int32  ALedgerNumber,
String  AAnalysisTypeCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [1/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( AAnalysisTypeRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [2/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( AAnalysisTypeRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [3/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( AAnalysisTypeRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [4/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( AAnalysisTypeRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [5/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( DataSet  AData,
AAnalysisTypeRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [6/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( DataSet  AData,
AAnalysisTypeRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [7/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [8/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [9/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( DataSet  ADataSet,
AAnalysisTypeRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [10/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [11/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [12/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAAnalysisTypeTemplate() [13/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAAnalysisTypeTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetail() [1/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetail ( DataSet  AData,
Int32  ALedgerNumber,
String  AMotivationGroupCode,
String  AMotivationDetailCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetail() [2/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetail ( DataSet  AData,
Int32  ALedgerNumber,
String  AMotivationGroupCode,
String  AMotivationDetailCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetail() [3/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetail ( DataSet  ADataSet,
Int32  ALedgerNumber,
String  AMotivationGroupCode,
String  AMotivationDetailCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated LoadViaLinkTable

◆ LoadViaAMotivationDetail() [4/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetail ( Int32  ALedgerNumber,
String  AMotivationGroupCode,
String  AMotivationDetailCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetail() [5/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetail ( Int32  ALedgerNumber,
String  AMotivationGroupCode,
String  AMotivationDetailCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetail() [6/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetail ( Int32  ALedgerNumber,
String  AMotivationGroupCode,
String  AMotivationDetailCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [1/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( AMotivationDetailRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [2/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( AMotivationDetailRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [3/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( AMotivationDetailRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [4/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( AMotivationDetailRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [5/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( DataSet  AData,
AMotivationDetailRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [6/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( DataSet  AData,
AMotivationDetailRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [7/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [8/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [9/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( DataSet  ADataSet,
AMotivationDetailRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [10/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [11/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [12/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaAMotivationDetailTemplate() [13/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaAMotivationDetailTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystem() [1/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystem ( DataSet  AData,
String  ASubSystemCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystem() [2/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystem ( DataSet  AData,
String  ASubSystemCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystem() [3/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystem ( DataSet  ADataSet,
String  ASubSystemCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated LoadViaLinkTable

◆ LoadViaASubSystem() [4/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystem ( String  ASubSystemCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystem() [5/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystem ( String  ASubSystemCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaASubSystem() [6/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystem ( String  ASubSystemCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [1/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( ASubSystemRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [2/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( ASubSystemRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [3/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( ASubSystemRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [4/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( ASubSystemRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [5/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( DataSet  AData,
ASubSystemRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [6/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( DataSet  AData,
ASubSystemRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [7/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [8/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [9/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( DataSet  ADataSet,
ASubSystemRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [10/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [11/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [12/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaASubSystemTemplate() [13/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaASubSystemTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxType() [1/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxType ( DataSet  AData,
String  ATaxTypeCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxType() [2/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxType ( DataSet  AData,
String  ATaxTypeCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxType() [3/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxType ( DataSet  ADataSet,
String  ATaxTypeCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated LoadViaLinkTable

◆ LoadViaATaxType() [4/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxType ( String  ATaxTypeCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxType() [5/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxType ( String  ATaxTypeCode,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxType() [6/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxType ( String  ATaxTypeCode,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [1/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( ATaxTypeRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [2/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( ATaxTypeRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [3/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( ATaxTypeRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [4/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( ATaxTypeRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [5/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( DataSet  AData,
ATaxTypeRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [6/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( DataSet  AData,
ATaxTypeRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [7/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [8/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [9/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( DataSet  ADataSet,
ATaxTypeRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [10/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [11/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [12/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaATaxTypeTemplate() [13/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaATaxTypeTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaForeignKey() [1/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId,
short  AOtherTableId,
DataSet  ADataSet,
string[]  AThisFieldNames,
DataRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

Load via other table, using template values.

◆ LoadViaForeignKey() [2/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId,
short  AOtherTableId,
DataSet  ADataSet,
string[]  AThisFieldNames,
System.Object[]  AForeignKeyValues,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

load data for the current table via a foreign key, eg. load all extracts created by user x

◆ LoadViaForeignKey() [3/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId,
short  AOtherTableId,
DataSet  ADataSet,
string[]  AThisFieldNames,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

Load via other table, using template values.

◆ LoadViaForeignKey() [4/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId,
short  AOtherTableId,
TTypedDataTable  ADataTable,
string[]  AThisFieldNames,
DataRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

Load via other table, using template values.

◆ LoadViaForeignKey() [5/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId,
short  AOtherTableId,
TTypedDataTable  ADataTable,
string[]  AThisFieldNames,
System.Object[]  AForeignKeyValues,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

load data for the current table via a foreign key, eg. load all extracts created by user x

◆ LoadViaForeignKey() [6/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId,
short  AOtherTableId,
TTypedDataTable  ADataTable,
string[]  AThisFieldNames,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestaticinherited

Load via other table, using template values.

◆ LoadViaSGroup() [1/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroup ( DataSet  AData,
String  AGroupId,
Int64  AUnitKey,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaSGroup() [2/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroup ( DataSet  AData,
String  AGroupId,
Int64  AUnitKey,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaSGroup() [3/6]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroup ( DataSet  ADataSet,
String  AGroupId,
Int64  AUnitKey,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated LoadViaLinkTable

◆ LoadViaSGroup() [4/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroup ( String  AGroupId,
Int64  AUnitKey,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaSGroup() [5/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroup ( String  AGroupId,
Int64  AUnitKey,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaSGroup() [6/6]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroup ( String  AGroupId,
Int64  AUnitKey,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [1/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( DataSet  AData,
SGroupRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [2/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( DataSet  AData,
SGroupRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [3/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [4/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( DataSet  AData,
TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [5/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( DataSet  ADataSet,
SGroupRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [6/13]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( DataSet  ADataSet,
TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [7/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( SGroupRow  ATemplateRow,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [8/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( SGroupRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [9/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( SGroupRow  ATemplateRow,
StringCollection  ATemplateOperators,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [10/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( SGroupRow  ATemplateRow,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [11/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [12/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( TSearchCriteria[]  ASearchCriteria,
StringCollection  AFieldList,
TDBTransaction  ATransaction,
StringCollection  AOrderBy,
int  AStartRecord,
int  AMaxRecords 
)
inlinestatic

auto generated

◆ LoadViaSGroupTemplate() [13/13]

static ALedgerTable Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.LoadViaSGroupTemplate ( TSearchCriteria[]  ASearchCriteria,
TDBTransaction  ATransaction 
)
inlinestatic

auto generated

◆ NoDefaultColumn()

static bool Ict.Common.Data.TTypedDataAccess.NoDefaultColumn ( String  AColumnName)
inlinestaticinherited

This function returns true if the column name is not one of the special columns, that are written automatically: modified date and by, created date and by, modification id

Returns
true if this is no special auto column

◆ NotEquals()

static bool Ict.Common.Data.TTypedDataAccess.NotEquals ( DataRow  ADataRow,
System.Int32  AColumnNr,
ref System.Object  ACurrentValue 
)
inlinestaticinherited

Compare the original and the current value of a column in a datarow. Make sure some mono specific troubles are worked around.

Returns
result of comparison

◆ SubmitChanges() [1/5]

static void Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.SubmitChanges ( ALedgerTable  ATable,
TDBTransaction  ATransaction 
)
inlinestatic

Auto generated code ...

Parameters
ATable
ATransaction

◆ SubmitChanges() [2/5]

static void Ict.Common.Data.TTypedDataAccess.SubmitChanges ( TTypedDataTable  ATable,
TDBTransaction  ATransaction,
eSubmitChangesOperations  ASelectedOperations,
string  AUserId 
)
inlinestaticinherited

overloaded version without sequence, but with ASelectedOperations

◆ SubmitChanges() [3/5]

static void Ict.Common.Data.TTypedDataAccess.SubmitChanges ( TTypedDataTable  ATable,
TDBTransaction  ATransaction,
eSubmitChangesOperations  ASelectedOperations,
string  AUserId,
string  ASequenceName,
string  ASequenceField 
)
inlinestaticinherited

submit those rows in the table that have been modified or created or deleted

Parameters
ATable
ATransaction
ASelectedOperations
AUserIdthe current user, for auditing
ASequenceName
ASequenceField
Returns

◆ SubmitChanges() [4/5]

static void Ict.Common.Data.TTypedDataAccess.SubmitChanges ( TTypedDataTable  ATable,
TDBTransaction  ATransaction,
string  AUserId 
)
inlinestaticinherited

overloaded version without sequence

◆ SubmitChanges() [5/5]

static void Ict.Common.Data.TTypedDataAccess.SubmitChanges ( TTypedDataTable  ATable,
TDBTransaction  ATransaction,
string  AUserId,
string  ASequenceName,
string  ASequenceField 
)
inlinestaticinherited

overloaded version without ASelectedOperations

◆ UpdateRow()

static void Ict.Common.Data.TTypedDataAccess.UpdateRow ( short  ATableId,
bool  AThrowAwayAfterSubmitChanges,
ref DataRow  ADataRow,
DB.TDBTransaction  ATransaction,
String  ACurrentUser 
)
inlinestaticinherited

This function is called by the DataStore (SubmitChanges)

Returns
void

Member Data Documentation

◆ CREATED_BY

const string Ict.Common.Data.TTypedDataAccess.CREATED_BY = "s_created_by_c"
staticinherited

who has originally created this row

◆ CREATED_DATE

const string Ict.Common.Data.TTypedDataAccess.CREATED_DATE = "s_date_created_d"
staticinherited

when was this row originally created

◆ DATATABLENAME

const string Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.DATATABLENAME = "ALedger"
static

CamelCase version of table name.

◆ DBTABLENAME

const string Ict.Petra.Server.MFinance.Account.Data.Access.ALedgerAccess.DBTABLENAME = "a_ledger"
static

original table name in database

◆ MODIFICATION_ID

const string Ict.Common.Data.TTypedDataAccess.MODIFICATION_ID = "s_modification_id_t"
staticinherited

name of the column used for tracking changes, one ID per change

◆ MODIFICATION_ID_DELETEDROW_INDICATOR

readonly DateTime Ict.Common.Data.TTypedDataAccess.MODIFICATION_ID_DELETEDROW_INDICATOR = DateTime.MaxValue
staticinherited

indicates whether a row has been deleted

◆ MODIFIED_BY

const string Ict.Common.Data.TTypedDataAccess.MODIFIED_BY = "s_modified_by_c"
staticinherited

who has last modified the row

◆ MODIFIED_DATE

const string Ict.Common.Data.TTypedDataAccess.MODIFIED_DATE = "s_date_modified_d"
staticinherited

when was the last change to the row


The documentation for this class was generated from the following file: