SQL Tool for Partner Reports More...

Static Public Member Functions
static string	UCAddressFilterDataViewRowFilter (Dictionary< String, TVariant >AParameters)
	Adds the conditions for a UC_AddressFilter to a Query More...

static string	UCExtractChkFilterSQLConditions (Dictionary< String, TVariant >AParameters)
	Adds the conditions for a UC_ExtractChkFilter to a Query More...

static DataTable	GetPrimaryPhoneFax (List< string >APartnerKeys, TReportingDbAdapter ADbAdapter, Boolean AIncludeMobile=false, Boolean AIncludeAlternateTelephone=false, Boolean AIncludeURL=false)
	Reuturns a DataTable called ContactInformation More...

static void	AddPrimaryPhoneEmailFaxToTable (DataTable ADataTable, int APartnerKeyColumn, TReportingDbAdapter ADbAdapter, Boolean AIncludeMobile=false, Boolean AIncludeAlternateTelephone=false, Boolean AIncludeURL=false)
	Adds the primary Phone Email and Fax to a DataTable More...

static void	ConvertDbFieldNamesToReadable (DataTable ADataTable)
	Converts the field names from the database to a readable name (DataTable) More...

static void	ConvertDbFieldNamesToReadable (DataSet ADataSet)
	Converts the field names from the database to a readable name (DataSet) More...

static void	AddFieldNameToTable (DataTable ADataTable, int APartnerKeyColumn, Dictionary< String, TVariant >AParameters, String ADateKey, TReportingDbAdapter ADbAdapter)

static string	ColumnMapping (string ASortingColumnsAsText, DataColumnCollection AColumns, Dictionary< string, string >AMappingDictionaryWithoutBlanks, string AReportName)
	Maps a comma seperated list of column names with use of the given dictionary. More...

static string	ColumnNameMapping (string ASortingColumnsAsText, string[] ADataTableColumns, Dictionary< string, string >AMappingDictionaryWithoutBlanks, string AReportName)
	Maps a comma seperated list of column names with use of the given dictionary. More...

static string	ReplaceColumnWithNullWhenUnused (Dictionary< String, TVariant >AParameters, Dictionary< String, String >AColumnDBNamesAndAliases)
	Replaces the field name with NULL if it is not needed in order to improve the performance of certain reports. More...

static String	GetPartnerKeysAsString (Dictionary< String, TVariant >AParameters, TReportingDbAdapter DbAdapter)
	Returns the Partner Keys for UCPartnerSelection as a comma seperated list. More...

Detailed Description

SQL Tool for Partner Reports

Member Function Documentation

◆ AddFieldNameToTable()

static void Ict.Petra.Server.MPartner.Common.TPartnerReportTools.AddFieldNameToTable	(	DataTable	ADataTable,
		int	APartnerKeyColumn,
		Dictionary< String, TVariant >	AParameters,
		String	ADateKey,
		TReportingDbAdapter	ADbAdapter
	)

inlinestatic

Parameters

ADataTable
APartnerKeyColumn
AParameters
ADateKey
ADbAdapter

◆ AddPrimaryPhoneEmailFaxToTable()

static void Ict.Petra.Server.MPartner.Common.TPartnerReportTools.AddPrimaryPhoneEmailFaxToTable	(	DataTable	ADataTable,
		int	APartnerKeyColumn,
		TReportingDbAdapter	ADbAdapter,
		Boolean	AIncludeMobile = `false`,
		Boolean	AIncludeAlternateTelephone = `false`,
		Boolean	AIncludeURL = `false`
	)

inlinestatic

Adds the primary Phone Email and Fax to a DataTable

Parameters

ADataTable
APartnerKeyColumn
ADbAdapter
AIncludeMobile
AIncludeAlternateTelephone
AIncludeURL

◆ ColumnMapping()

static string Ict.Petra.Server.MPartner.Common.TPartnerReportTools.ColumnMapping	(	string	ASortingColumnsAsText,
		DataColumnCollection	AColumns,
		Dictionary< string, string >	AMappingDictionaryWithoutBlanks,
		string	AReportName
	)

inlinestatic

Maps a comma seperated list of column names with use of the given dictionary.

Parameters

ASortingColumnsAsText	Comma seperated list of Column Names.
AColumns	Column Collection of the DataTable to check if the given names are valid.
AMappingDictionaryWithoutBlanks	The Dictionary to use for the translation. Key is the old name, values is the new name.
AReportName	Used for the Log.

Returns

◆ ColumnNameMapping()

static string Ict.Petra.Server.MPartner.Common.TPartnerReportTools.ColumnNameMapping	(	string	ASortingColumnsAsText,
		string[]	ADataTableColumns,
		Dictionary< string, string >	AMappingDictionaryWithoutBlanks,
		string	AReportName
	)

inlinestatic

Maps a comma seperated list of column names with use of the given dictionary.

Parameters

ASortingColumnsAsText	Comma seperated list of Column Names.
ADataTableColumns	Column Names of the DataTable as a string[] to check if the given names are valid.
AMappingDictionaryWithoutBlanks	The Dictionary to use for the translation. Key is the old name, values is the new name.
AReportName	Used for the Log.

Returns

◆ ConvertDbFieldNamesToReadable() [1/2]

static void Ict.Petra.Server.MPartner.Common.TPartnerReportTools.ConvertDbFieldNamesToReadable ( DataSet ADataSet )

inlinestatic

Converts the field names from the database to a readable name (DataSet)

Parameters

ADataSet

◆ ConvertDbFieldNamesToReadable() [2/2]

static void Ict.Petra.Server.MPartner.Common.TPartnerReportTools.ConvertDbFieldNamesToReadable ( DataTable ADataTable )

inlinestatic

Converts the field names from the database to a readable name (DataTable)

Parameters

ADataTable

◆ GetPartnerKeysAsString()

static String Ict.Petra.Server.MPartner.Common.TPartnerReportTools.GetPartnerKeysAsString	(	Dictionary< String, TVariant >	AParameters,
		TReportingDbAdapter	DbAdapter
	)

inlinestatic

Returns the Partner Keys for UCPartnerSelection as a comma seperated list.

Parameters

AParameters
DbAdapter

Returns

◆ GetPrimaryPhoneFax()

static DataTable Ict.Petra.Server.MPartner.Common.TPartnerReportTools.GetPrimaryPhoneFax	(	List< string >	APartnerKeys,
		TReportingDbAdapter	ADbAdapter,
		Boolean	AIncludeMobile = `false`,
		Boolean	AIncludeAlternateTelephone = `false`,
		Boolean	AIncludeURL = `false`
	)

inlinestatic

Reuturns a DataTable called ContactInformation

Parameters

APartnerKeys
ADbAdapter
AIncludeMobile
AIncludeAlternateTelephone
AIncludeURL

Returns

◆ ReplaceColumnWithNullWhenUnused()

static string Ict.Petra.Server.MPartner.Common.TPartnerReportTools.ReplaceColumnWithNullWhenUnused	(	Dictionary< String, TVariant >	AParameters,
		Dictionary< String, String >	AColumnDBNamesAndAliases
	)

inlinestatic

Replaces the field name with NULL if it is not needed in order to improve the performance of certain reports.

Parameters

AParameters
AColumnDBNamesAndAliases	Dictionary of the column names. Key: full DB Name, Value: Alias.

Returns

◆ UCAddressFilterDataViewRowFilter()

static string Ict.Petra.Server.MPartner.Common.TPartnerReportTools.UCAddressFilterDataViewRowFilter ( Dictionary< String, TVariant > AParameters )

inlinestatic

Adds the conditions for a UC_AddressFilter to a Query

Parameters

AParameters

◆ UCExtractChkFilterSQLConditions()

static string Ict.Petra.Server.MPartner.Common.TPartnerReportTools.UCExtractChkFilterSQLConditions ( Dictionary< String, TVariant > AParameters )

inlinestatic

Adds the conditions for a UC_ExtractChkFilter to a Query

Parameters

AParameters

Returns

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

csharp/ICT/Petra/Server/lib/MPartner/Common/ReportTools.cs

Static Public Member Functions

Detailed Description

Member Function Documentation

◆ AddFieldNameToTable()

◆ AddPrimaryPhoneEmailFaxToTable()

◆ ColumnMapping()

◆ ColumnNameMapping()

◆ ConvertDbFieldNamesToReadable() [1/2]

◆ ConvertDbFieldNamesToReadable() [2/2]

◆ GetPartnerKeysAsString()

◆ GetPrimaryPhoneFax()

◆ ReplaceColumnWithNullWhenUnused()

◆ UCAddressFilterDataViewRowFilter()

◆ UCExtractChkFilterSQLConditions()