• 홈
• CmsData
• QueryFunctions

C# 클래스 CmsData.QueryFunctions

파일 보기 프로젝트 열기: bvcms/bvcms 1 사용 예제들

공개 메소드들

메소드	설명
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

비공개 메소드들

메소드	설명
GetReadonlyConnection ( ) : DbConnection
SortList ( string sort, IQueryable q ) : IQueryable

메소드 상세