C# 클래스 IBE.Enums_and_Utility_Classes.DataRetriever

retriever class
상속: IDataPageRetriever
파일 보기 프로젝트 열기: Duke-Jones/ED-IBE 1 사용 예제들

공개 메소드들

메소드 설명
DataRetriever ( SQL DBCon, string BaseTableName, string columnStatement, String baseStatement, String SortByColumn, DBConnector SortOrder, DataTable TypeTable = null ) : System

constructor for the DataRetriever (used for loading and caching data in DGV VirtualMode)

GetWhereStatement ( string ignoreFilter = "" ) : String
RowCount ( System.Boolean refresh = false ) : int
SupplyPageOfData ( int lowerPageBoundary, int rowsPerPage ) : DataTable

비공개 메소드들

메소드 설명
CommaSeparatedListOfColumnNames ( String Prefix = "" ) : string
GetDataTable ( ) : DataTable
SetFilter ( string name, string filterString ) : void

메소드 상세

DataRetriever() 공개 메소드

constructor for the DataRetriever (used for loading and caching data in DGV VirtualMode)
public DataRetriever ( SQL DBCon, string BaseTableName, string columnStatement, String baseStatement, String SortByColumn, DBConnector SortOrder, DataTable TypeTable = null ) : System
DBCon SQL used DBConnector
BaseTableName string
columnStatement string
baseStatement String
SortByColumn String column for sorting (must be existingClassification in the base table (m_BaseTableName) and in the 'DataStement')
SortOrder DBConnector sort oder
TypeTable System.Data.DataTable
리턴 System

GetWhereStatement() 공개 메소드

public GetWhereStatement ( string ignoreFilter = "" ) : String
ignoreFilter string
리턴 String

RowCount() 공개 메소드

public RowCount ( System.Boolean refresh = false ) : int
refresh System.Boolean
리턴 int

SupplyPageOfData() 공개 메소드

public SupplyPageOfData ( int lowerPageBoundary, int rowsPerPage ) : DataTable
lowerPageBoundary int
rowsPerPage int
리턴 System.Data.DataTable