C# Class CmsData.QueryFunctions

Show file Open project: bvcms/bvcms Class Usage Examples

Public Methods

Method	Description
BlueToolbarReport ( ) : IEnumerable
BlueToolbarReport ( string sort ) : IEnumerable
QueryCount ( string query ) : int
QueryFunctions ( CmsData.CMSDataContext db ) : System
QueryFunctions ( CmsData.CMSDataContext db, object>.Dictionary dictionary ) : System
QueryFunctions ( string dbname ) : System
QueryList ( object query, string sort = "name" ) : IEnumerable
QuerySql ( string sql ) : IEnumerable
QuerySql ( string sql, object p1 ) : IEnumerable
QuerySql ( string sql, object p1, string>.Dictionary d ) : IEnumerable
QuerySqlTop1 ( string sql ) : dynamic
QuerySqlTop1 ( string sql, object p1 ) : dynamic
QuerySqlTop1 ( string sql, object p1, string>.Dictionary d ) : dynamic
SqlDateValueArray ( string header, int numvalcols, string sql ) : string	Function takes a sql script and then places the results into an array. The first column in the SQL results should countain Dates. This is followed by 1 to 10 columns value Each row of SQL results is processed into a row of the array by creating a DateValueRow class header: string containing the header row. (less the square brackets) numvalcols: number of columns containing values. (do not include date column) sql: string containing the sql script. Example: SqlDateValueArray("{label: 'Date', type: 'date'},{label: 'Sum', type: 'number'},{label: 'Avg', type: 'number'}", 2, '''sql string''') If there are no results from the SQL query, then a table is returned that prints "NULL" on the chart
SqlNameCountArray ( string title, string sql ) : string
SqlPeopleIdsToQuery ( string sql ) : string
StatusCount ( string flags ) : int
TagCount ( int tagid ) : int
TagQueryList ( object query ) : int

Private Methods

Method	Description
GetReadonlyConnection ( ) : DbConnection
SortList ( string sort, IQueryable q ) : IQueryable

Method Details

BlueToolbarReport() public method

public BlueToolbarReport ( ) : IEnumerable
return	IEnumerable

BlueToolbarReport() public method

public BlueToolbarReport ( string sort ) : IEnumerable
sort	string
return	IEnumerable

QueryCount() public method

public QueryCount ( string query ) : int
query	string
return	int

QueryFunctions() public method

public QueryFunctions ( CmsData.CMSDataContext db ) : System
db	CmsData.CMSDataContext
return	System

QueryFunctions() public method

public QueryFunctions ( CmsData.CMSDataContext db, object>.Dictionary dictionary ) : System
db	CmsData.CMSDataContext
dictionary	object>.Dictionary
return	System

QueryFunctions() public method

public QueryFunctions ( string dbname ) : System
dbname	string
return	System

QueryList() public method

public QueryList ( object query, string sort = "name" ) : IEnumerable
query	object
sort	string
return	IEnumerable

QuerySql() public method

public QuerySql ( string sql ) : IEnumerable
sql	string
return	IEnumerable

QuerySql() public method

public QuerySql ( string sql, object p1 ) : IEnumerable
sql	string
p1	object
return	IEnumerable

QuerySql() public method

public QuerySql ( string sql, object p1, string>.Dictionary d ) : IEnumerable
sql	string
p1	object
d	string>.Dictionary
return	IEnumerable

QuerySqlTop1() public method

public QuerySqlTop1 ( string sql ) : dynamic
sql	string
return	dynamic

QuerySqlTop1() public method

public QuerySqlTop1 ( string sql, object p1 ) : dynamic
sql	string
p1	object
return	dynamic

QuerySqlTop1() public method

public QuerySqlTop1 ( string sql, object p1, string>.Dictionary d ) : dynamic
sql	string
p1	object
d	string>.Dictionary
return	dynamic

SqlDateValueArray() public method

Function takes a sql script and then places the results into an array. The first column in the SQL results should countain Dates. This is followed by 1 to 10 columns value Each row of SQL results is processed into a row of the array by creating a DateValueRow class header: string containing the header row. (less the square brackets) numvalcols: number of columns containing values. (do not include date column) sql: string containing the sql script. Example: SqlDateValueArray("{label: 'Date', type: 'date'},{label: 'Sum', type: 'number'},{label: 'Avg', type: 'number'}", 2, '''sql string''') If there are no results from the SQL query, then a table is returned that prints "NULL" on the chart

public SqlDateValueArray ( string header, int numvalcols, string sql ) : string
header	string
numvalcols	int
sql	string
return	string

SqlNameCountArray() public method

public SqlNameCountArray ( string title, string sql ) : string
title	string
sql	string
return	string

SqlPeopleIdsToQuery() public method

public SqlPeopleIdsToQuery ( string sql ) : string
sql	string
return	string

StatusCount() public method

public StatusCount ( string flags ) : int
flags	string
return	int

TagCount() public method

public TagCount ( int tagid ) : int
tagid	int
return	int

TagQueryList() public method

public TagQueryList ( object query ) : int
query	object
return	int