C# Class DataServer.SqlProcessing.SqlQuery

Inheritance: BaseContent

ファイルを表示 Open project: TNOCS/csTouch Class Usage Examples

Private Properties

Property	Type	Description
AddOutputsAsLabel	void
DefineParametrizedQuery	string
InitializeFieldNames	void
RemoveExistingPoIs	void
RetreiveFieldName	string
RetreiveId	string
RetreiveName	string
RetreivePosition	Position
SetGeometry	void
UpdateMinMax	void

Public Methods

Method	Description
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

Private Methods

Method	Description
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

Method Details

Execute() public method

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
return	void

FromXml() public method

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

SqlQuery() public method

public SqlQuery ( ) : System.Collections.Concurrent
return	System.Collections.Concurrent

ToXml() public method

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