The StatisticBuilderPanel type exposes the following members.
Back to Top
Back to Top
Back to Top
Constructors
| Name | Description | |
|---|---|---|
 | StatisticBuilderPanel | Initializes a new instance of the StatisticBuilderPanel class |
Methods
| Name | Description | |
|---|---|---|
| BuildCodedAliasQuery |
Returns an SqlQuery object that is a coded version of the alias tokens.
|
| BuildCodedQuery |
Generates a coded query from this panel, for database use not end user viewing.
|
| BuildConnectorQuery |
Builds an SqlQuery object that is the literal connector for this statistic builder panel.
|
 | BuildIndent |
Builds the indent for this panel.
|
| BuildLiteralAliasQuery |
Builds an SqlQuery object that is the literal alias for this statsitic builder panel.
|
| BuildLiteralQuery |
Builds a literal query for display to end users.
|
| CheckTypesValue |
Checks the value of th etypes drop down list and adjusts the form as needed.
|
| ColInfoBinary |
Column is a coded column and is binary only.
|
| ColInfoExists |
Determines whether a column is a set, coded column stored in the ColumnInfo table.
|
| ColSchemaExists |
Helper method for the LoadOperators method, gets DB_TYPE information from the
DataSet return from a select TOP 1 on the target table.
|
| DecrementIndentLevel |
Decreases the indent level.
|
| GetBackgroundColor |
Returns the current background color.
|
| GetColumnDbType |
Returns the current selected column's database type.
|
| GetColumnsText |
Returns the columns ddl text.
|
| GetColumnsValue |
Returns the columns ddl value.
|
| GetConnectorText |
Returns the connector ddl text.
|
| GetConnectorValue |
Returns the connector ddl value.
|
| GetExistsText |
Returns the exists text.
|
| GetExistsValue |
Returns the exists value.
|
| GetFilterCriteriaLinkText |
Returns the text value of the filter link drop down box.
|
| GetFilterCriteriaLinkValue |
Returns a boolean value for the filter criteria link value.
|
| GetFilterId |
Gets the stored filter id from thie statistic panel.
|
| GetFormulaNameValue |
Returns the current value of the formula name field.
|
| GetIndentAmount |
Returns the indent amount.
|
| GetIndentLevel |
Returns the indent level.
|
| GetIndex |
Returns the index of this panel.
|
| GetIsColumnsShowing |
Returns true if the columns drop down section is visible.
|
| GetIsConnectorShowing |
Returns true if the connector drop down list is showing.
|
| GetIsExclmShowing |
Returns true if the exclamation icon is showing.
|
| GetIsExistsShowing |
Returns true if the exist calculation drop down section is visible.
|
| GetIsFclShowing |
Returns true if the filter criteria link drop down list is visible.
|
| GetIsFormulaNameShowing |
Returns true if the formula name section is visible.
|
| GetIsLoaded |
Determines if this filter builder panel is loaded yet.
|
| GetIsNameShowing |
Returns true if the name section is visible.
|
| GetIsSelected |
Returns true if this box has been selected.
|
| GetIsStatFormatShowing |
Returns true if the statistic format field is visible.
|
| GetIsStaticValShowing |
Returns true if the static value text box is visible.
|
| GetIsStpShowing |
Returns true if the stop error icon is visible.
|
| GetIsTablesShowing |
Returns true if the tables drop down section is showing.
|
| GetNameValue |
Returns the current value of the name field.
|
| GetPanelMode |
Gets the current panel mode of this statistic builder panel.
|
| GetStatFormatText |
Returns the format text for this statistic panel.
|
| GetStatFormatValue |
Returns the format value for this statistic panel.
|
| GetStaticValValue |
Returns the currently stored static val text box value.
|
| GetTablesText |
Returns the tables ddl text.
|
| GetTablesValue |
Returns the tables ddl value.
|
| GetTurnOffAltRowShading |
Returns the current alternate row shading.
|
| GetTypesText |
Returns the types ddl text.
|
| GetTypesValue |
Returns the types ddl value.
|
| IncrementIndentLevel |
Increases the indent level.
|
| LoadAll |
Loads all the information needed for displaying the filter builder panel.
Tables, columns etc.
|
| LoadColumns |
Load up the table schema for the given core table.
|
| LoadConnector |
Loads the connectors.
|
| LoadExists |
Load exsting calculation list.
|
| LoadStatFormat |
Loads the statistic format list.
|
| LoadTables |
Load the filter configuration's core tables.
|
| LoadTypes |
Loads the different types of statistics panels there are.
|
 | Page_Load |
Standard page load method.
|
| ReloadExists |
Reload exists list.
|
| SafeConvertToInt |
Safely convert a string to an integer.
|
| SetAltShadedBackgroundColor |
Sets the background used alt shading.
|
| SetBackgroundColor |
Sets the background using NO alt shading.
|
| SetChooseValue |
Sets the choose checkbox based on a string value.
|
| SetColumnsText |
Sets the columns drop down list based on a string text.
|
| SetColumnsValue |
Sets the internal column value. Disconnected from asp.net control
to gaurantee functionality. Uses jQuery to control the client side selection.
|
| SetConnectorText |
Sets the connector drop down list based on a string text.
|
| SetConnectorValue |
Sets the connector drop down list based on a string value.
|
| SetExistsText |
Sets the value of the exsting calculations drop down list from a text value.
|
| SetExistsValue |
Sets the value of the exsting calculations drop down list from a value.
|
| SetFilterCriteriaLinkText |
Sets the filter criteria link drop down list based on the given text.
|
| SetFilterCriteriaLinkValue |
Sets the choose checkbox based on a string value.
|
| SetFilterId |
Sets the filter id for this statistic panel.
|
| SetFormulaNameValue |
Sets the current value of the formula name field.
|
| SetIndentAmount |
Sets the indent amount.
|
| SetIndentLevel |
Sets the indent level for this panel.
|
| SetIndex |
Sets the index of this panel.
|
| SetIsColumnsShowing |
Sets the visibility of the columns drop down section.
|
| SetIsConnectorShowing |
Set if the connector drop down list is showing.
|
| SetIsExclmShowing |
Sets if the exclamation icon is showing or not, uses CSS to control display.
|
| SetIsExistsShowing |
Sets the visibility of the existing calculation drop down section.
|
| SetIsFclShowing |
Set the display value for the filter criteria link drop down list.
|
| SetIsFormulaNameShowing |
Sets the visibility of the formula name section.
|
| SetIsNameShowing |
Sets the visibility of the name section.
|
| SetIsSelected |
Sets this panel to selected.
|
| SetIsStatFormatShowing |
Sets if the statistic format field is visible.
|
| SetIsStaticValShowing |
Set the display value for the static val text box.
|
| SetIsStpShowing |
Sets whether the stop icon is showing. Used for error handling.
|
| SetIsTablesShowing |
Sets the visibility of the tables drop down section.
|
| SetNameValue |
Sets the current value of the name field.
|
| SetPanelMode |
Sets the current panel mode of this statistic builder panel.
|
| SetParent |
Sets the current parent of this panel.
|
| SetSessionKey |
Stores the session key to reference this object in the session.
|
| SetStatFormatText |
Sets the statistic format text for this panel.
|
| SetStatFormatValue |
Sets the statistic format value for this panel.
|
| SetStaticValValue |
Sets the static val text box value.
Returns true if the value has changed from previous stored value.
|
| SetTablesText |
Sets the tables drop down list based on a string text.
|
| SetTablesValue |
Sets the internal table value. Disconnected from asp.net control
to gaurantee functionality. Uses jQuery to control the client side selection.
|
| SetTurnOffAltRowShading |
Sets the current alternate row shading.
|
| SetTypesText |
Sets the connector drop down list based on a string text.
|
| SetTypesValue |
Sets the types drop down list based on a string value.
|
| txtFormulaName_TextChanged |
Events handler for the formula name text box.
|
| txtName_TextChanged |
Handles post calls from the name text box.
|
| txtStaticVal_TextChanged |
Event handler for the static value text box.
|
| UpdatePanel |
Handles any update tasks here.
|
| ValidateForm |
Validates the current form looking for missing value fields etc.
|
Fields
| Name | Description | |
|---|---|---|
 | bgroundColor |
The current background color of this panel.
|
 | cbChoose |
cbChoose control.
|
| columnDbType |
Stores the database type of the selected column, used for value field type determinations.
|
| columnsText |
Stores the text of the selected column along with its value in columnsValue.
|
| columnsValue |
Controls the columns drop down list selection value.
Using jQuery to ensure proper drop down list selection.
|
| connectorText |
Stores the text of the selected connector along with its value in connectorValue.
|
| connectorValue |
Stores the value of the selected connector.
|
| cssColumnsVis |
Controls the display for the column drop down list.
|
| cssConnHeight |
Used to hide the connector control when it isn't visible.
|
| cssConnVis |
Variable that holds the CSS value for the connector visibility.
//Pushed to cient side because of control rendering issues with server side.
|
| cssExclmHeight |
Used to display/hide the exclamation icon.
|
| cssExclmVis |
Used to hide the exclamation icon.
|
| cssExistsVis |
Controls the display for the existing calculations drop down list.
|
| cssFclVis |
Controls the display for the force criteria link drop down list.
|
| cssFormulaNameClear |
Controls the formula name div's clear value.
Should be set to empty when FCL is showing and clear:both; when FCL
is nit visible.
|
| cssFormulaNameVis |
Controls the display for the name text box.
|
| cssNameVis |
Controls the display for the name text box.
|
| cssStatFormatClear |
Controls the css clear value of the stat format section.
|
| cssStatFormatVis |
Controls the visibility of the stat format drop down list.
|
| cssStaticValVis |
Controls the display for static value text box.
|
| cssStpHeight |
Used to display/hide the exclamation icon.
|
| cssStpVis |
Used to hide the exclamation icon.
|
| cssTablesVis |
Controls the display for the table drop down list.
|
| ddlColumns |
ddlColumns control.
|
| ddlConnector |
ddlConnector control.
|
| ddlExists |
ddlExists control.
|
| ddlFilterCriteriaLink |
ddlFilterCriteriaLink control.
|
| ddlStatFormat |
ddlStatFormat control.
|
| ddlTables |
ddlTables control.
|
| ddlTypes |
ddlTypes control.
|
| dvMainWrapper |
dvMainWrapper control.
|
| dvRounded |
dvRounded control.
|
| errorText |
Error text for this controls current state.
|
| existsText |
Stores the selected text of the types drop down list.
|
| existsValue |
Stores the value of the types drop down list.
|
| fclText |
Stores the filter criteria link text of the drop down list.
|
| fclValue |
Stores the filter criteria link value of the drop down list.
|
| filterId |
Holds the filter id of the currently loaded filter.
|
| imgExclm |
imgExclm control.
|
| imgStp |
imgStp control.
|
| indentAmount |
Controls how much the panel is indented per level.
|
| indentLevel |
Represents the grouping level of this panel.
|
| index |
Represents the index of this panel in a list of panels.
|
| isColumnsShowing |
Tracks the display for the column drop down list.
|
| isConnectorShowing |
True if the connector drop down list is showing.
|
| isExclmShowing |
Indicates the status of the exclamation icon's visibility.
|
| isExistsShowing |
Tracks the display of the existing calculations drop down list.
|
| isFclShowing |
Tracks the display for the name text box.
|
| isFormulaNameShowing |
Tracks the display for the name text box.
|
| isNameShowing |
Tracks the display for the name text box.
|
| isSelected |
True if the checkbox on this panel has been selected.
|
| isStatFormatShowing |
Returns true if the stat format field is showing.
|
| isStaticValShowing |
Tracks the display of the static value text box.
|
| isStpShowing |
Indicates the status of the exclamation icon's visibility.
|
| isTablesShowing |
Tracks display of the tables drop down list.
|
| key |
Secret key.
|
| lblColumnName |
lblColumnName control.
|
| lblExists |
lblExists control.
|
| lblFilterCriteriaLink |
lblFilterCriteriaLink control.
|
| lblFormulaName |
lblFormulaName control.
|
| lblName |
lblName control.
|
| lblStatFormat |
lblStatFormat control.
|
| lblStaticVal |
lblStaticVal control.
|
| lblTableName |
lblTableName control.
|
| lblType |
lblType control.
|
| loaded |
Determines if this control has been loaded.
|
| logging |
Controls logging to debugging purposes.
|
| panelMode |
Represents the mode the statistic builder form is running in.
|
| parent |
The owner of this filter builder panel.
|
| sessionKey |
The session key for the list of filter builder panels.
|
| statFormatText |
Stores the text of the selected connector along with its value in connectorValue.
|
| statFormatValue |
Stores the value of the selected connector.
|
| staticValValue | |
| svc |
Service reference.
|
| tablesText |
Stores the text of the selected table along with its value in tablesValue.
|
| tablesValue |
Controls the tables drop down list selection value.
Using jQuery to ensure proper drop down list selection.
|
| turnOffAltRowShading |
Controls how alternate rows are shaded.
|
| txtFormulaName |
txtFormulaName control.
|
| txtFormulaNameValue |
Tracks the value of the name text box.
|
| txtName |
txtName control.
|
| txtNameValue |
Tracks the value of the name text box.
|
| txtStaticVal |
txtStaticVal control.
|
| typesText |
Stores the selected text of the types drop down list.
|
| typesValue |
Stores the value of the types drop down list.
|
See Also