C# Class Sage.Integration.Northwind.Application.Base.RTDVBase

显示文件 Open project: Sage/SData-Contracts Class Usage Examples

Public Methods

Method	Description
GetXmlSchemaElement ( ) : XmlSchemaElement
RTDVBase ( string reportName, string reportPrefix ) : System
ViewRealTimeData ( string entityName, string selectFields, SearchField searchFields, string orderFields, int rowsPerPage, int pageNumber, NorthwindConfig config ) : XmlNode

Protected Methods

Method	Description
ConcatSqlQuery ( string sqlQueryTemplate ) : string
ConvertToXmlDocument ( DataSet dataSet, string selectedFields, int pageNumber, int rowsPerPage ) : XmlDocument
CreateHavingClause ( SearchField searchFields, List &oleDbParameterList ) : string
CreateOleDbParameter ( string fieldName, string fieldValue ) : System.Data.OleDb.OleDbParameter
CreateOrderClause ( string orderFields ) : string
CreateSqlQuery ( SearchField whereFields, SearchField havingFields, string orderFields, List &oleDbParameterList ) : string
CreateWhereClause ( SearchField searchFields, List &oleDbParameterList ) : string
Fill ( string sqlQuery, List oleDbParameterList, NorthwindConfig config, DataSet &dataSet ) : int
GetHavingFields ( SearchField list ) : Sage.Integration.Northwind.Application.API.SearchField[]
GetSqlQueryFieldValueRepresentation ( string fieldValue, OperatorValue operationTag ) : string
GetSqlQueryNameRepresentation ( string fieldName ) : string
GetSqlQueryOperatorRepresentation ( OperatorValue operationTag ) : string
GetSqlQueryTemplate ( ) : string
GetWhereFields ( SearchField list ) : Sage.Integration.Northwind.Application.API.SearchField[]

Private Methods

Method	Description
ResponseCalcStartPosition ( int pageNumber, int rowsPerPage ) : int
ResponseCreateFieldNode ( XmlDocument xmlDoc, string fieldName, object value ) : XmlNode
ResponseCreateRootNode ( XmlDocument xmlDoc, string reportName, int nOfRows ) : XmlNode
ResponseCreateRowNode ( XmlDocument xmlDoc ) : XmlNode

Method Details

ConcatSqlQuery() protected method

protected ConcatSqlQuery ( string sqlQueryTemplate ) : string
sqlQueryTemplate	string
return	string

ConvertToXmlDocument() protected method

protected ConvertToXmlDocument ( DataSet dataSet, string selectedFields, int pageNumber, int rowsPerPage ) : XmlDocument
dataSet	System.Data.DataSet
selectedFields	string
pageNumber	int
rowsPerPage	int
return	System.Xml.XmlDocument

CreateHavingClause() protected method

protected CreateHavingClause ( SearchField searchFields, List &oleDbParameterList ) : string
searchFields	Sage.Integration.Northwind.Application.API.SearchField
oleDbParameterList	List
return	string

CreateOleDbParameter() protected abstract method

protected abstract CreateOleDbParameter ( string fieldName, string fieldValue ) : System.Data.OleDb.OleDbParameter
fieldName	string
fieldValue	string
return	System.Data.OleDb.OleDbParameter

CreateOrderClause() protected method

protected CreateOrderClause ( string orderFields ) : string
orderFields	string
return	string

CreateSqlQuery() protected method

protected CreateSqlQuery ( SearchField whereFields, SearchField havingFields, string orderFields, List &oleDbParameterList ) : string
whereFields	Sage.Integration.Northwind.Application.API.SearchField
havingFields	Sage.Integration.Northwind.Application.API.SearchField
orderFields	string
oleDbParameterList	List
return	string

CreateWhereClause() protected method

protected CreateWhereClause ( SearchField searchFields, List &oleDbParameterList ) : string
searchFields	Sage.Integration.Northwind.Application.API.SearchField
oleDbParameterList	List
return	string

Fill() protected method

protected Fill ( string sqlQuery, List oleDbParameterList, NorthwindConfig config, DataSet &dataSet ) : int
sqlQuery	string
oleDbParameterList	List
config	NorthwindConfig
dataSet	System.Data.DataSet
return	int

GetHavingFields() protected abstract method

protected abstract GetHavingFields ( SearchField list ) : Sage.Integration.Northwind.Application.API.SearchField[]
list	Sage.Integration.Northwind.Application.API.SearchField
return	Sage.Integration.Northwind.Application.API.SearchField[]

GetSqlQueryFieldValueRepresentation() protected method

protected GetSqlQueryFieldValueRepresentation ( string fieldValue, OperatorValue operationTag ) : string
fieldValue	string
operationTag	OperatorValue
return	string

GetSqlQueryNameRepresentation() protected method

protected GetSqlQueryNameRepresentation ( string fieldName ) : string
fieldName	string
return	string

GetSqlQueryOperatorRepresentation() protected method

protected GetSqlQueryOperatorRepresentation ( OperatorValue operationTag ) : string
operationTag	OperatorValue
return	string

GetSqlQueryTemplate() protected abstract method

protected abstract GetSqlQueryTemplate ( ) : string
return	string

GetWhereFields() protected abstract method

protected abstract GetWhereFields ( SearchField list ) : Sage.Integration.Northwind.Application.API.SearchField[]
list	Sage.Integration.Northwind.Application.API.SearchField
return	Sage.Integration.Northwind.Application.API.SearchField[]

GetXmlSchemaElement() public method

public GetXmlSchemaElement ( ) : XmlSchemaElement
return	System.Xml.Schema.XmlSchemaElement

RTDVBase() public method

public RTDVBase ( string reportName, string reportPrefix ) : System
reportName	string
reportPrefix	string
return	System

ViewRealTimeData() public method

public ViewRealTimeData ( string entityName, string selectFields, SearchField searchFields, string orderFields, int rowsPerPage, int pageNumber, NorthwindConfig config ) : XmlNode
entityName	string
selectFields	string
searchFields	Sage.Integration.Northwind.Application.API.SearchField
orderFields	string
rowsPerPage	int
pageNumber	int
config	NorthwindConfig
return	System.Xml.XmlNode