Class StiSqlCeSource

Hierarchy

Implements

Index

Constructors

Properties

Accessors

Methods

Constructors

constructor

  • new StiSqlCeSource(nameInSource?: string, name?: string, alias?: string, sqlCommand?: string, connectOnStart?: boolean, reconnectOnEachRow?: boolean, commandTimeout?: number, key?: string): StiSqlCeSource

  • Parameters

    • Default value nameInSource: string = ""
    • Default value name: string = ""
    • Default value alias: string = name
    • Default value sqlCommand: string = ""
    • Default value connectOnStart: boolean = true
    • Default value reconnectOnEachRow: boolean = false
    • Default value commandTimeout: number = 30
    • Default value key: string = ""

    Returns StiSqlCeSource

Properties

Protected _hash

_hash: StiMeta[]

alias

alias: string

allowExpressions

allowExpressions: boolean = true

calcColumns

calcColumns: Hashtable = new Hashtable()

columnsIndexs

columnsIndexs: Hashtable

commandTimeout

commandTimeout: number = 30

connectOnStart

connectOnStart: boolean = true

connectionOrder

connectionOrder: number = Stimulsoft.Report.Dictionary.StiConnectionOrder.Standard

detailRows

detailRows: DataRow[] = null

dictionary

dictionary: StiDictionary

inherited

inherited: boolean = false

initForSubreport

initForSubreport: boolean = false

Protected isBofValue

isBofValue: boolean = false

Protected isEofValue

isEofValue: boolean = false

isInited

isInited: boolean = false

key

key: string = null

nameInSource

nameInSource: string

parameters

parameters: StiDataParametersCollection

Protected positionValue

positionValue: number = 0

reconnectOnEachRow

reconnectOnEachRow: boolean = false

rowToLevel

rowToLevel: Hashtable = null

rows

rows: StiRowsCollection

type

type: StiSqlSourceType = StiSqlSourceType.Table

xmlRefAttrValue

xmlRefAttrValue: string = null

Accessors

columns

count

  • get count(): number

current

  • get current(): any

dataName

  • get dataName(): string
  • set dataName(value: string): void

dataTable

isBof

  • get isBof(): boolean
  • set isBof(value: boolean): void

  • Gets value indicates that this position specifies to the beginning of data.

    Returns boolean

  • Gets value indicates that this position specifies to the beginning of data.

    Parameters

    • value: boolean

    Returns void

isCloud

  • get isCloud(): boolean

isConnected

  • get isConnected(): boolean

isEmpty

  • get isEmpty(): boolean

isEof

  • get isEof(): boolean
  • set isEof(value: boolean): void

  • Gets value indicates that this position specifies to the data end.

    Returns boolean

  • Gets value indicates that this position specifies to the data end.

    Parameters

    • value: boolean

    Returns void

name

  • get name(): string
  • set name(value: string): void

position

  • get position(): number
  • set position(value: number): void

realCount

  • get realCount(): number

sqlCommand

  • get sqlCommand(): string
  • set sqlCommand(v: string): void

Protected states

Methods

GetData

  • GetData(columnName: string, index?: number): any

  • Parameters

    • columnName: string
    • Default value index: number = this.position

    Returns any

as

checkColumnsIndexs

  • checkColumnsIndexs(): void

childRelationList

clearAllStates

  • clearAllStates(): void

clone

connect

  • connect(datas: StiDataCollection, loadData: boolean): void

  • Parameters

    • datas: StiDataCollection
    • loadData: boolean

    Returns void

connectAsync

  • connectAsync(datas: StiDataCollection, loadData: boolean): StiPromise<void>

disconnect

  • disconnect(): void

fetchChildRelations

fetchColumnValues

  • fetchColumnValues(names: List<string>): List<any[]>

fetchColumnValuesAsync

  • fetchColumnValuesAsync(names: List<string>): Promise<List<any[]>>

fetchColumns

fetchParentRelations

fillColumns

  • fillColumns(): void

first

  • first(): void

firstAsync

  • firstAsync(): Promise<void>

getByColumnName

  • getByColumnName(columnName: string): any

getByName

  • getByName(columnName: string): any

getCategoryName

  • getCategoryName(): string

getChildDataSource

getChildRelations

getColumnIndex

  • getColumnIndex(columnName: string): number

getConditions

getConnection

getData

  • getData(columnName: string, index?: number): any

  • Parameters

    • columnName: string
    • Default value index: number = this.position

    Returns any

getDataAdapter

getDataAdapterType

  • getDataAdapterType(): Type

getDataAsync

  • getDataAsync(columnName: string, index?: number): Promise<any>

  • Parameters

    • columnName: string
    • Default value index: number = this.position

    Returns Promise<any>

getDataBase

  • getDataBase(): StiDatabase

getDataBaseName

  • getDataBaseName(): string

getDataRow

  • getDataRow(index: number): DataRow

getDataTable

getDataTable2

  • getDataTable2(allowConnectToData: boolean): Promise<DataTable>

getDictionary

getEnumerator

getFinalSqlCommand

  • getFinalSqlCommand(): string

getKey

  • getKey(): string

getLevel

  • getLevel(): number

getName

  • getName(): string

getNameInSource

  • getNameInSource(): string

getParameterTypesEnum

  • getParameterTypesEnum(): any

getParentData

getParentDataSource

  • getParentDataSource(relationName: string, allowRelationName?: boolean): StiDataSource

getParentRelations

implements

  • implements(): any[]

Protected invokeConnecting

  • invokeConnecting(): void

Protected invokeDisconnecting

  • invokeDisconnecting(): void

is

is2

  • is2<T>(type: object | Interface<T>): boolean

last

  • last(): void

loadFromJsonObject

  • loadFromJsonObject(jObject: StiJson): void

loadFromXml

  • loadFromXml(xmlNode: XmlNode): void

memberwiseClone

meta

moveNext

  • moveNext(): boolean

next

  • next(): void

nextAsync

  • nextAsync(): Promise<void>

parentRelationList

parseSqlQuery

  • parseSqlQuery(baseSqlCommand: string, dataSource: StiSqlSource): string

prior

  • prior(): void

reset

  • reset(): void

resetData

  • resetData(): void

resetDetailsRows

  • resetDetailsRows(): void

restoreState

  • restoreState(stateName: string): void

retrieveDataAsync

  • retrieveDataAsync(schemaOnly?: boolean): StiPromise<void>

saveState

  • saveState(stateName: string): void

saveToJsonObject

setData

  • setData(dataBand: StiDataBand, relationName: string, filterMethod: any, sortColumns: string[], reinit: boolean, component: StiComponent, allowReconnectOnEachRow?: boolean): void

  • Parameters

    • dataBand: StiDataBand
    • relationName: string
    • filterMethod: any
    • sortColumns: string[]
    • reinit: boolean
    • component: StiComponent
    • Default value allowReconnectOnEachRow: boolean = true

    Returns void

setDataAsync

  • setDataAsync(dataBand: StiDataBand, relationName: string, filterMethod: any, sortColumns: string[], reinit: boolean, component: StiComponent, allowReconnectOnEachRow?: boolean): Promise<void>

  • Parameters

    • dataBand: StiDataBand
    • relationName: string
    • filterMethod: any
    • sortColumns: string[]
    • reinit: boolean
    • component: StiComponent
    • Default value allowReconnectOnEachRow: boolean = true

    Returns Promise<void>

setDetails

  • setDetails(relationName: string): void

setDetailsAsync

  • setDetailsAsync(relationName: string): Promise<void>

setFilter

  • setFilter(filterMethod: any): void

setKey

  • setKey(key: string): void

setSort

synchronizeColumns

  • synchronizeColumns(): void

toString

  • toString(): string

updateParameters

  • updateParameters(): void

updateParametersAsync

  • updateParametersAsync(): Promise<void>

Generated using TypeDoc