FilterBuilderPanel MethodsA Sandcastle Documented Class Library
The FilterBuilderPanel type exposes the following members.
Methods

  NameDescription
Public methodBuildCodedQuery
Generates a coded query from this panel, for database use not end user viewing.
Private methodBuildIndent
Builds the indent for this panel.
Public methodBuildLiteralQuery
Builds a literal query for display to end users.
Private methodColInfoExists
Determines whether a column is a set, coded column stored in the ColumnInfo table.
Private methodColSchemaExists
Helper method for the LoadOperators method, gets DB_TYPE information from the DataSet return from a select TOP 1 on the target table.
Public methodDecrementIndentLevel
Decreases the indent level.
Private methodDisableValues
Private methodEnableValues
Public methodGetBackgroundColor
Returns the current background color.
Public methodGetColumnDbType
Returns the current selected column's database type.
Public methodGetIndentAmount
Returns the indent amount.
Public methodGetIndentLevel
Returns the indent level.
Public methodGetIndex
Returns the index of this panel.
Public methodGetIsConnectorShowing
Returns true if the connector drop down list is showing.
Private methodGetIsDateValueVisible
Returns the visibility of the date text field.
Private methodGetIsDdlBtwnValuesVisible
Returns true if the between values drop down list is visible.
Private methodGetIsDdlValuesVisible
Returns visibility of the drop down list.
Public methodGetIsExclmShowing
Returns true if the exclamation icon is showing.
Private methodGetIsLbValuesVisible
Returns the visibility of the list box list.
Public methodGetIsLoaded
Determines if this filter builder panel is loaded yet.
Public methodGetIsSelected
Returns true if this box has been selected.
Private methodGetIsTimeValueVisible
Returns the visibility of the time text field.
Private methodGetIsTxtBtwnDateValueVisible
Returns the visibility of the between dates fields.
Private methodGetIsTxtBtwnStrValueVisible
Returns the visibility of the between string fields.
Private methodGetIsTxtBtwnTimeValueVisible
Returns the visibility of the between time fields.
Private methodGetIsTxtValueVisible
Returns the visibility of the text field.
Public methodGetTurnOffAltRowShading
Returns the current alternate row shading.
Public methodGetValue 
Returns the current form value based on the current display properties of the form.
Public methodGetValue(Boolean)
Returns a string array based on what fields the form is currently displaying.
Private methodHideAllValueForms
Hides all form value fields.
Public methodIncrementIndentLevel
Increases the indent level.
Protected methodlbValues_SelectedIndexChanged
Empty event handler used in auto post back calls for the list box of values.
Public methodLoadAll
Loads all the information needed for displaying the filter builder panel. Tables, columns etc.
Private methodLoadColumns
Load up the table schema for the given core table.
Private methodLoadCrashYearRange
Loads the crash year range from the cache or from the database. Generates min date, max date, and year range for the date picker.
Private methodLoadOperators
Loads the operator list based on the column type. Sets the form type value used by the LoadValues method.
Private methodLoadTables
Load the filter configuration's core tables.
Private methodLoadValues
Loads values and the correct value fields for the given column and operator.
Protected methodPage_Load
Standard page load method.
Private methodSafeConvertToInt
Safely convert a string to an integer.
Private methodSetAltShadedBackgroundColor
Sets the background used alt shading.
Private methodSetBackgroundColor
Sets the background using NO alt shading.
Public methodSetChooseValue
Sets the choose checkbox based on a string value.
Public methodSetColumnsText
Sets the columns drop down list based on a string text.
Public methodSetColumnsValue
Sets the internal column value. Disconnected from asp.net control to gaurantee functionality. Uses jQuery to control the client side selection.
Public methodSetConnectorText
Sets the connector drop down list based on a string text.
Public methodSetConnectorValue
Sets the connector drop down list based on a string value.
Public methodSetDdlCodedValues1Value
Sets the value for the coded values drop down list 1.
Public methodSetDdlCodedValues2Value
Sets the value for the coded values drop down list 2.
Public methodSetDdlValuesValue
Sets the drop down list values.
Public methodSetIndentAmount
Sets the indent amount.
Public methodSetIndentLevel
Sets the indent level for this panel.
Public methodSetIndex
Sets the index of this panel.
Public methodSetIsConnectorShowing
Set if the connector drop down list is showing.
Private methodSetIsDateValueVisible
Shows/hides the date text field.
Private methodSetIsDdlBtwnValuesVisible
Sets if the between values drop down list is visible.
Private methodSetIsDdlValuesVisible
Shows/hides the drop down list based on the passed in value.
Public methodSetIsExclmShowing
Sets if the exclamation icon is showing or not, uses CSS to control display.
Private methodSetIsLbValuesVisible
Shows/hides the list box list based on the passed in value.
Private methodSetIsOneDdlBtwnValuesVisible
Public methodSetIsSelected
Sets this panel to selected.
Public methodSetIsStpShowing
Sets whether the stop icon is showing. Used for error handling.
Private methodSetIsTimeValueVisible
Shows/hides the time text field.
Private methodSetIsTxtBtwnDateValueVisible
Shows/hides the between dates fields.
Private methodSetIsTxtBtwnStrValueVisible
Shows/hids the between string fields.
Private methodSetIsTxtBtwnTimeValueVisible
Shows/hides the between time fields.
Private methodSetIsTxtValueVisible
Shows/hides the text field.
Public methodSetLbValuesValue
Stores the value for the values drop down list.
Public methodSetOperatorsText
Sets the operators drop down list based on a string text.
Public methodSetOperatorsValue
Sets the internal operators value. Disconnected from asp.net control to gaurantee functionality. Uses jQuery to control the client side selection.
Public methodSetParent
Sets the current parent of this panel.
Public methodSetSessionKey
Stores the session key to reference this object in the session.
Public methodSetTablesText
Sets the tables drop down list based on a string text.
Public methodSetTablesValue
Sets the internal table value. Disconnected from asp.net control to gaurantee functionality. Uses jQuery to control the client side selection.
Public methodSetTurnOffAltRowShading
Sets the current alternate row shading.
Public methodSetTxtBtwnDate1
Sets the value of the between date input field, field 1.
Public methodSetTxtBtwnDate2
Sets the value of the between date input field, field 2.
Public methodSetTxtBtwnStr1
Sets the value of the between input field, field 1.
Public methodSetTxtBtwnStr2
Sets the value of the between input field, field 2.
Public methodSetTxtBtwnTime1
Sets the value of the between time input field, field 1.
Public methodSetTxtBtwnTime2
Sets the value of the between date input field, field 2.
Public methodSetTxtDateValue
Sets the value of the date input field.
Public methodSetTxtTimeValue
Sets the values of the time input field.
Public methodSetTxtValue
Sets the value of the text input field.
Public methodSetValues
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.
Protected methodtxtValue_TextChanged
Empty event handler used i nauto post back calls for all text fields.
Public methodUpdatePanel
Handles any update tasks here.
Public methodValidateForm
Validates the current form looking for missing value fields etc.
Back to Top
See Also