C# 클래스 DataServer.SqlProcessing.SqlQuery

상속: BaseContent
파일 보기 프로젝트 열기: TNOCS/csTouch 1 사용 예제들

Private Properties

프로퍼티 타입 설명
AddOutputsAsLabel void
DefineParametrizedQuery string
InitializeFieldNames void
RemoveExistingPoIs void
RetreiveFieldName string
RetreiveId string
RetreiveName string
RetreivePosition Position
SetGeometry void
UpdateMinMax void

공개 메소드들

메소드 설명
Execute ( PoiService service, PoI refPoi, List zone, bool isQueueAble = false, bool forceExecute = false ) : void

Execute the SQL query and update the service.

FromXml ( System.Xml.Linq.XElement element, string directoryName ) : void
SqlQuery ( ) : System.Collections.Concurrent
ToXml ( ServiceSettings settings ) : System.Xml.Linq.XElement

비공개 메소드들

메소드 설명
AddOutputsAsLabel ( BaseContent refPoi, IDataRecord dr ) : void
DefineParametrizedQuery ( PoI poi, List zone ) : string

Replace the parameter placeholders in the query with their values.

InitializeFieldNames ( IDataRecord dr ) : void
RemoveExistingPoIs ( PoiService poiService, IEnumerable currPois ) : void

Remove all PoIs created by this service (checks whether the UserId == SqlQuery.Id).

RetreiveFieldName ( IDataRecord dr, SqlOutputType type ) : string
RetreiveId ( IDataRecord dr ) : string
RetreiveName ( IDataRecord dr ) : string
RetreivePosition ( IDataRecord dr ) : Position
SetGeometry ( PoI poi ) : void
UpdateMinMax ( PoiService service ) : void

메소드 상세

Execute() 공개 메소드

Execute the SQL query and update the service.
public Execute ( PoiService service, PoI refPoi, List zone, bool isQueueAble = false, bool forceExecute = false ) : void
service PoiService
refPoi PoI
zone List
isQueueAble bool
forceExecute bool
리턴 void

FromXml() 공개 메소드

public FromXml ( System.Xml.Linq.XElement element, string directoryName ) : void
element System.Xml.Linq.XElement
directoryName string
리턴 void

SqlQuery() 공개 메소드

public SqlQuery ( ) : System.Collections.Concurrent
리턴 System.Collections.Concurrent

ToXml() 공개 메소드

public ToXml ( ServiceSettings settings ) : System.Xml.Linq.XElement
settings ServiceSettings
리턴 System.Xml.Linq.XElement