The FilterBuilderPanel type exposes the following members.
Back to Top
Back to Top
Back to Top
Constructors
| Name | Description | |
|---|---|---|
 | FilterBuilderPanel | Initializes a new instance of the FilterBuilderPanel class |
Methods
| Name | Description | |
|---|---|---|
| BuildCodedQuery |
Generates a coded query from this panel, for database use not end user viewing.
|
 | BuildIndent |
Builds the indent for this panel.
|
| BuildLiteralQuery |
Builds a literal query for display to end users.
|
| 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.
|
| DisableValues | |
| EnableValues | |
| GetBackgroundColor |
Returns the current background color.
|
| GetColumnDbType |
Returns the current selected column's database type.
|
| GetIndentAmount |
Returns the indent amount.
|
| GetIndentLevel |
Returns the indent level.
|
| GetIndex |
Returns the index of this panel.
|
| GetIsConnectorShowing |
Returns true if the connector drop down list is showing.
|
| GetIsDateValueVisible |
Returns the visibility of the date text field.
|
| GetIsDdlBtwnValuesVisible |
Returns true if the between values drop down list is visible.
|
| GetIsDdlValuesVisible |
Returns visibility of the drop down list.
|
| GetIsExclmShowing |
Returns true if the exclamation icon is showing.
|
| GetIsLbValuesVisible |
Returns the visibility of the list box list.
|
| GetIsLoaded |
Determines if this filter builder panel is loaded yet.
|
| GetIsSelected |
Returns true if this box has been selected.
|
| GetIsTimeValueVisible |
Returns the visibility of the time text field.
|
| GetIsTxtBtwnDateValueVisible |
Returns the visibility of the between dates fields.
|
| GetIsTxtBtwnStrValueVisible |
Returns the visibility of the between string fields.
|
| GetIsTxtBtwnTimeValueVisible |
Returns the visibility of the between time fields.
|
| GetIsTxtValueVisible |
Returns the visibility of the text field.
|
| GetTurnOffAltRowShading |
Returns the current alternate row shading.
|
| GetValue |
Returns the current form value based on the current display properties of the form.
|
| GetValue(Boolean) |
Returns a string array based on what fields the form is currently displaying.
|
| HideAllValueForms |
Hides all form value fields.
|
| IncrementIndentLevel |
Increases the indent level.
|
 | lbValues_SelectedIndexChanged |
Empty event handler used in auto post back calls for the list box of values.
|
| 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.
|
| LoadCrashYearRange |
Loads the crash year range from the cache or from the database.
Generates min date, max date, and year range for the date picker.
|
| LoadOperators |
Loads the operator list based on the column type.
Sets the form type value used by the LoadValues method.
|
| LoadTables |
Load the filter configuration's core tables.
|
| LoadValues |
Loads values and the correct value fields for the given column and operator.
|
| Page_Load |
Standard page load method.
|
| 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.
|
| SetDdlCodedValues1Value |
Sets the value for the coded values drop down list 1.
|
| SetDdlCodedValues2Value |
Sets the value for the coded values drop down list 2.
|
| SetDdlValuesValue |
Sets the drop down list values.
|
| SetIndentAmount |
Sets the indent amount.
|
| SetIndentLevel |
Sets the indent level for this panel.
|
| SetIndex |
Sets the index of this panel.
|
| SetIsConnectorShowing |
Set if the connector drop down list is showing.
|
| SetIsDateValueVisible |
Shows/hides the date text field.
|
| SetIsDdlBtwnValuesVisible |
Sets if the between values drop down list is visible.
|
| SetIsDdlValuesVisible |
Shows/hides the drop down list based on the passed in value.
|
| SetIsExclmShowing |
Sets if the exclamation icon is showing or not, uses CSS to control display.
|
| SetIsLbValuesVisible |
Shows/hides the list box list based on the passed in value.
|
| SetIsOneDdlBtwnValuesVisible | |
| SetIsSelected |
Sets this panel to selected.
|
| SetIsStpShowing |
Sets whether the stop icon is showing. Used for error handling.
|
| SetIsTimeValueVisible |
Shows/hides the time text field.
|
| SetIsTxtBtwnDateValueVisible |
Shows/hides the between dates fields.
|
| SetIsTxtBtwnStrValueVisible |
Shows/hids the between string fields.
|
| SetIsTxtBtwnTimeValueVisible |
Shows/hides the between time fields.
|
| SetIsTxtValueVisible |
Shows/hides the text field.
|
| SetLbValuesValue |
Stores the value for the values drop down list.
|
| SetOperatorsText |
Sets the operators drop down list based on a string text.
|
| SetOperatorsValue |
Sets the internal operators value. Disconnected from asp.net control
to gaurantee functionality. Uses jQuery to control the client side selection.
|
| SetParent |
Sets the current parent of this panel.
|
| SetSessionKey |
Stores the session key to reference this object in the session.
|
| 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.
|
| SetTxtBtwnDate1 |
Sets the value of the between date input field, field 1.
|
| SetTxtBtwnDate2 |
Sets the value of the between date input field, field 2.
|
| SetTxtBtwnStr1 |
Sets the value of the between input field, field 1.
|
| SetTxtBtwnStr2 |
Sets the value of the between input field, field 2.
|
| SetTxtBtwnTime1 |
Sets the value of the between time input field, field 1.
|
| SetTxtBtwnTime2 |
Sets the value of the between date input field, field 2.
|
| SetTxtDateValue |
Sets the value of the date input field.
|
| SetTxtTimeValue |
Sets the values of the time input field.
|
| SetTxtValue |
Sets the value of the text input field.
|
| SetValues |
Sets the values of this panel based on what is currently visible.
In order to be used correctly the values of this panel must be set in the
following order, table, column, operator, then value.
|
| txtValue_TextChanged |
Empty event handler used i nauto post back calls for all text fields.
|
| 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.
|
| columnCodedSupportsBetween | |
| columnDbType |
Stores the database type of the selected column, used for value field type determinations.
|
| columnLookupTable |
Holds a datatable with all the columninfo rows for the given column.
|
| 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.
|
| columnType |
Represents the type of column we're looking at, determines the value field along with the formType variable
and the operator. Once column type is set we can rely on it to determine where the data is being stored.
|
| columnUsesSetList |
Stores whether or not the selected column is in the COLUMNINFO table.
Signifies a coded set type column if it is present.
|
| connectorText |
Stores the text of the selected connector along with its value in connectorValue.
|
| connectorValue |
Stores the value of the selected connector.
|
| 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.
|
| cssDateValueHeight |
Used to control css values client side for hiding/showing elements.
|
| cssDateValueVis |
Used to control css values client side for hiding/showing elements.
|
| cssDdlBtwnValuesHeight |
Sets the height of the coded ddl between values.
|
| cssDdlBtwnValuesVis |
Sets the visibility of the coded ddl between values.
|
| cssDdlValuesHeight |
Used to control css values client side for hiding/showing elements.
|
| cssDdlValuesVis |
Used to control css values client side for hiding/showing elements.
|
| cssDefaultDate |
Used to set the default date on the date picker control.
|
| cssExclmHeight |
Used to display/hide the exclamation icon.
|
| cssExclmVis |
Used to hide the exclamation icon.
|
| cssLbValuesHeight |
Used to control css values client side for hiding/showing elements.
|
| cssLbValuesVis |
Used to control css values client side for hiding/showing elements.
|
| cssMaxYear |
Used to set the maximum year on the date picker control.
|
| cssMinYear |
Used to set the minimum year on the date picker control.
|
| cssStpHeight |
Used to display/hide the exclamation icon.
|
| cssStpVis |
Used to hide the exclamation icon.
|
| cssTimeValueHeight |
Used to control css values client side for hiding/showing elements.
|
| cssTimeValueVis |
Used to control css values client side for hiding/showing elements.
|
| cssTxtBtwnDateValueHeight |
Used to control css values client side for hiding/showing elements.
|
| cssTxtBtwnDateValueVis |
Used to control css values client side for hiding/showing elements.
|
| cssTxtBtwnStrValueHeight |
Used to control css values client side for hiding/showing elements.
|
| cssTxtBtwnStrValueVis |
Used to control css values client side for hiding/showing elements.
|
| cssTxtBtwnTimeValueHeight |
Used to control css values client side for hiding/showing elements.
|
| cssTxtBtwnTimeValueVis |
Used to control css values client side for hiding/showing elements.
|
| cssTxtValueHeight |
Used to control css values client side for hiding/showing elements.
|
| cssTxtValueVis |
Used to control css values client side for hiding/showing elements.
|
| cssYearRange |
Used to set the year range on the date picker control.
|
| ddlCodedValues1 |
ddlCodedValues1 control.
|
| ddlCodedValues1Hldr |
Tracks the value of the coded drop down list 1.
|
| ddlCodedValues1HldrText | |
| ddlCodedValues2 |
ddlCodedValues2 control.
|
| ddlCodedValues2Hldr |
Tracks the value of the coded drop down list 2.
|
| ddlCodedValues2HldrText | |
| ddlColumns |
ddlColumns control.
|
| ddlConnector |
ddlConnector control.
|
| ddlOperators |
ddlOperators control.
|
| ddlTables |
ddlTables control.
|
| ddlValues |
ddlValues control.
|
| ddlValuesHldr |
Tracks the value of the drop down list control.
|
| ddlValuesHldrText | |
| dvMainWrapper |
dvMainWrapper control.
|
| dvRounded |
dvRounded control.
|
| errorText |
Represents the current error state of this control.
|
| formType |
Represents the form state that should be used.
|
| 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.
|
| isConnectorShowing |
True if the connector drop down list is showing.
|
| isDateValueVisible |
Used to control css values client side for hiding/showing elements.
|
| isDdlBtwnValuesVisible | |
| isDdlValuesVisible |
Used to control css values client side for hiding/showing elements.
|
| isExclmShowing |
Indicates the status of the exclamation icon's visibility.
|
| isLbValuesVisible |
Used to control css values client side for hiding/showing elements.
|
| isSelected |
True if the checkbox on this panel has been selected.
|
| isStpShowing |
Indicates the status of the exclamation icon's visibility.
|
| isTimeValueVisible |
Used to control css values client side for hiding/showing elements.
|
| isTxtBtwnDateValueVisible |
Used to control css values client side for hiding/showing elements.
|
| isTxtBtwnStrValueVisible |
Used to control css values client side for hiding/showing elements.
|
| isTxtBtwnTimeValueVisible |
Used to control css values client side for hiding/showing elements.
|
| isTxtValueVisible |
Used to control css values client side for hiding/showing elements.
|
| key |
Secret key.
|
| lblBtwn1 |
lblBtwn1 control.
|
| lblBtwn2 |
lblBtwn2 control.
|
| lblBtwn3 |
lblBtwn3 control.
|
| lblBtwn4 |
lblBtwn4 control.
|
| lblColumnName |
lblColumnName control.
|
| lblOperator |
lblOperator control.
|
| lblTableName |
lblTableName control.
|
| lblValue |
lblValue control.
|
| lbValues |
lbValues control.
|
| lbValuesHldr |
Tracks the value of the list box control.
|
| lbValuesHldrText | |
| loaded |
Represents if this filter builder panel has had its base data loaded.
|
| operatorsText |
Stores the text of the selected operator along with its value in operatorsValue.
|
| operatorsValue |
Controls the operators ddl value.
Using jQuery to ensure proper drop down list selection.
|
| parent |
The owner of this filter builder panel.
|
| sessionKey |
The session key for the list of filter builder panels.
|
| 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.
|
| txtBtwnDate1 |
txtBtwnDate1 control.
|
| txtBtwnDate1Hldr | |
| txtBtwnDate2 |
txtBtwnDate2 control.
|
| txtBtwnDate2Hldr | |
| txtBtwnStr1 |
txtBtwnStr1 control.
|
| txtBtwnStr1Hldr | |
| txtBtwnStr2 |
txtBtwnStr2 control.
|
| txtBtwnStr2Hldr | |
| txtBtwnTime1 |
txtBtwnTime1 control.
|
| txtBtwnTime1Hldr | |
| txtBtwnTime2 |
txtBtwnTime2 control.
|
| txtBtwnTime2Hldr | |
| txtDateValue |
txtDateValue control.
|
| txtDateValueHldr | |
| txtTimeValue |
txtTimeValue control.
|
| txtTimeValueHldr | |
| txtValue |
txtValue control.
|
| txtValueHldr |
See Also