Core.Tools.Query.QueryBuilder Class Reference

Summary description for SearchQuery. More...

List of all members.

Public Member Functions
	QueryBuilder (Core.Data.DbFactory.CONNECTION_TYPE in_ct)
	QueryBuilder ()
int	GetColumnIndex (QueryBuilderEntities.FIELD_TYPE in_field)
String	BuildSchemaId ()
String	BuildSchemaId (bool use_alias)
String[]	GetColumnList ()
String[]	GetColumnList (bool use_alias, bool group_list)
String	BuildCountQuery ()
String	BuildSelectQuery ()
String	BuildSelectQuery (int top_results, String use_table_list, bool use_alias, String[] column_list, List< Query > where_queries, bool is_custom_sort, String custom_sort, QueryBuilderEntities.FIELD_TYPE order_field, bool is_desc_order, String[] group_by_list, bool use_join)
Query	InnerJoin (String join_table_name, Field join_field, QueryBuilderEntities.COMPARATOR field_comparator, Field match_field)
Query	AddQuery (QueryBuilderEntities.FIELD_TYPE field_type)
Query	AddQuery (QueryBuilderEntities.FIELD_TYPE field_type, QueryBuilderEntities.FIELD_TYPE comp_value)
Query	AddQuery (QueryBuilderEntities.FIELD_TYPE field_type, QueryBuilderEntities.COMPARATOR comp_type, QueryBuilderEntities.FIELD_TYPE comp_value)
Query	AddQuery (QueryBuilderEntities.FIELD_TYPE field_type, String comp_value)
Query	AddQuery (QueryBuilderEntities.FIELD_TYPE field_type, QueryBuilderEntities.COMPARATOR comp_type, String comp_value)
Public Attributes
Core.Data.DbFactory.CONNECTION_TYPE	ConnectionType = Core.Data.DbFactory.CONNECTION_TYPE.UNKNOWN
bool	IsParameterized = false
Properties
int	TopRecordCount [get, set]
Query[]	ActiveColumnList [get]
String	HashDiscriminator [get, set]
double	Version [get, set]
String	QueryId [get, set]
bool	NoLock [get, set]
QueryBuilderEntities.FIELD_TYPE	OrderBy [get, set]
bool	IsCustomSortOrder [get, set]
String	CustomSortOrder [get, set]
bool	IsDescendingOrder [get, set]
String	TableList [get, set]
List< Query >	Queries [get]
Private Attributes
double	version = System.Convert.ToDouble(QueryBuilderEntities.SERIALIZATION_MAXIMUM_SUPPORTED_VERSION)
List< Query >	queries = null
String	table_list = null
QueryBuilderEntities.FIELD_TYPE	order_by = QueryBuilderEntities.FIELD_TYPE.UNKNOWN
bool	is_descending_order = false
bool	is_custom_sort_order = false
String	custom_sort_order = null
bool	is_dcc_join = false
bool	no_lock = false
String	query_id = null
int	top_record_count = 0
String	hash_discriminator = null
Query[]	active_column_list = new Query[0]

---

Detailed Description

Summary description for SearchQuery.

---

Constructor & Destructor Documentation

Core.Tools.Query.QueryBuilder.QueryBuilder

(

Core.Data.DbFactory.CONNECTION_TYPE

in_ct

)

Core.Tools.Query.QueryBuilder.QueryBuilder

(

)

---

Member Function Documentation

int Core.Tools.Query.QueryBuilder.GetColumnIndex

(

QueryBuilderEntities.FIELD_TYPE

in_field

)

String Core.Tools.Query.QueryBuilder.BuildSchemaId

(

)

String Core.Tools.Query.QueryBuilder.BuildSchemaId

(

bool

use_alias

)

String [] Core.Tools.Query.QueryBuilder.GetColumnList

(

)

String [] Core.Tools.Query.QueryBuilder.GetColumnList	(	bool	use_alias,
		bool	group_list
	)

String Core.Tools.Query.QueryBuilder.BuildCountQuery

(

)

String Core.Tools.Query.QueryBuilder.BuildSelectQuery

(

)

String Core.Tools.Query.QueryBuilder.BuildSelectQuery	(	int	top_results,
		String	use_table_list,
		bool	use_alias,
		String[]	column_list,
		List< Query >	where_queries,
		bool	is_custom_sort,
		String	custom_sort,
		QueryBuilderEntities.FIELD_TYPE	order_field,
		bool	is_desc_order,
		String[]	group_by_list,
		bool	use_join
	)

Query Core.Tools.Query.QueryBuilder.InnerJoin	(	String	join_table_name,
		Field	join_field,
		QueryBuilderEntities.COMPARATOR	field_comparator,
		Field	match_field
	)

Query Core.Tools.Query.QueryBuilder.AddQuery

(

QueryBuilderEntities.FIELD_TYPE

field_type

)

Query Core.Tools.Query.QueryBuilder.AddQuery	(	QueryBuilderEntities.FIELD_TYPE	field_type,
		QueryBuilderEntities.FIELD_TYPE	comp_value
	)

Query Core.Tools.Query.QueryBuilder.AddQuery	(	QueryBuilderEntities.FIELD_TYPE	field_type,
		QueryBuilderEntities.COMPARATOR	comp_type,
		QueryBuilderEntities.FIELD_TYPE	comp_value
	)

Query Core.Tools.Query.QueryBuilder.AddQuery	(	QueryBuilderEntities.FIELD_TYPE	field_type,
		String	comp_value
	)

Query Core.Tools.Query.QueryBuilder.AddQuery	(	QueryBuilderEntities.FIELD_TYPE	field_type,
		QueryBuilderEntities.COMPARATOR	comp_type,
		String	comp_value
	)

---

Member Data Documentation

double Core.Tools.Query.QueryBuilder.version = System.Convert.ToDouble(QueryBuilderEntities.SERIALIZATION_MAXIMUM_SUPPORTED_VERSION) [private]

List<Query> Core.Tools.Query.QueryBuilder.queries = null [private]

String Core.Tools.Query.QueryBuilder.table_list = null [private]

QueryBuilderEntities.FIELD_TYPE Core.Tools.Query.QueryBuilder.order_by = QueryBuilderEntities.FIELD_TYPE.UNKNOWN [private]

bool Core.Tools.Query.QueryBuilder.is_descending_order = false [private]

bool Core.Tools.Query.QueryBuilder.is_custom_sort_order = false [private]

String Core.Tools.Query.QueryBuilder.custom_sort_order = null [private]

bool Core.Tools.Query.QueryBuilder.is_dcc_join = false [private]

bool Core.Tools.Query.QueryBuilder.no_lock = false [private]

String Core.Tools.Query.QueryBuilder.query_id = null [private]

int Core.Tools.Query.QueryBuilder.top_record_count = 0 [private]

String Core.Tools.Query.QueryBuilder.hash_discriminator = null [private]

Core.Data.DbFactory.CONNECTION_TYPE Core.Tools.Query.QueryBuilder.ConnectionType = Core.Data.DbFactory.CONNECTION_TYPE.UNKNOWN

bool Core.Tools.Query.QueryBuilder.IsParameterized = false

Query [] Core.Tools.Query.QueryBuilder.active_column_list = new Query[0] [private]

---

Property Documentation

int Core.Tools.Query.QueryBuilder.TopRecordCount [get, set]

Query [] Core.Tools.Query.QueryBuilder.ActiveColumnList [get]

String Core.Tools.Query.QueryBuilder.HashDiscriminator [get, set]

double Core.Tools.Query.QueryBuilder.Version [get, set]

String Core.Tools.Query.QueryBuilder.QueryId [get, set]

bool Core.Tools.Query.QueryBuilder.NoLock [get, set]

QueryBuilderEntities.FIELD_TYPE Core.Tools.Query.QueryBuilder.OrderBy [get, set]

bool Core.Tools.Query.QueryBuilder.IsCustomSortOrder [get, set]

String Core.Tools.Query.QueryBuilder.CustomSortOrder [get, set]

bool Core.Tools.Query.QueryBuilder.IsDescendingOrder [get, set]

String Core.Tools.Query.QueryBuilder.TableList [get, set]

List<Query> Core.Tools.Query.QueryBuilder.Queries [get]

---

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

• e:/projects/Deploy/ReportLib/Core/Tools/Query/QueryBuilder.cs