Class DBCmdSelect
- Namespace
- PHCDataLayer
- Assembly
- PHCDataLayer.dll
public class DBCmdSelect : DbCmd, IBaseSerialization, ICloneVO, ICloneable, IQueryFilters, ISelectedItens
- Inheritance
-
DBCmdSelect
Constructors
DBCmdSelect()
In this way the class outside the dll can only be used with Inherits, but inside it can be used with New
Fields
Payload
Field Value
- IResult
Properties
Distinct
public bool Distinct { get; set; }
Property Value
- bool
FilterItems
public FilterItems FilterItems { get; set; }
Property Value
- FilterItems
GroupByItems
public GroupByItems GroupByItems { get; set; }
Property Value
- GroupByItems
HavingItems
public FilterItems HavingItems { get; set; }
Property Value
- FilterItems
JoinEntities
public JoinEntities JoinEntities { get; set; }
Property Value
- JoinEntities
Limit
public int Limit { get; set; }
Property Value
- int
Offset
public int Offset { get; set; }
Property Value
- int
OrderByItems
public OrderByItems OrderByItems { get; set; }
Property Value
- OrderByItems
RunQueryByRawMode
public bool RunQueryByRawMode { get; set; }
Property Value
- bool
SubSelect
public string SubSelect { get; set; }
Property Value
- string
UnionsItems
public UnionsItems UnionsItems { get; set; }
Property Value
- UnionsItems
UseParcialLoad
public bool UseParcialLoad { get; set; }
Property Value
- bool
UseRowNumber
If we want to get a range, then the result will be like previous 'limit' records, middle record, next 'limit' records.
public bool UseRowNumber { get; set; }
Property Value
- bool
Examples
If we want record in position 50 and limit is 5, then we bring the records from position 45 to 55
Methods
AddJoin(string, string, JoinsType)
public JoinEntity AddJoin(string tableName, string aliasName = "", JoinsType _joinType = JoinsType.Inner)
Parameters
Returns
- JoinEntity
Clone()
public DBCmdSelect Clone()
Returns
- DBCmdSelect
Clone<T>(T)
public T Clone<T>(T cloneItem) where T : DBCmdSelect
Parameters
| Nome |
Tipo |
Descrição |
cloneItem |
T |
|
Returns
- T
Type Parameters
T
ExistRecord()
public bool ExistRecord()
Returns
- bool
ExistServer()
public bool ExistServer()
Returns
- bool
public List<SqlFieldMetadata> GetFieldsMetadata()
Returns
- List<SqlFieldMetadata>
GetNumRecords()
public int GetNumRecords()
Returns
- int
GetValue<T>()
Returns
- T
Type Parameters
T
GetValue<T>(string)
public T GetValue<T>(string field)
Parameters
| Nome |
Tipo |
Descrição |
field |
string |
|
Returns
- T
Type Parameters
T
GetValue<T>(string, Aggregate)
public T GetValue<T>(string field, Aggregate AggregateType)
Parameters
Returns
- T
Type Parameters
T
OnApplyFilter()
public virtual void OnApplyFilter()
OnApplyOrder()
public virtual void OnApplyOrder()
OnApplySelect()
public virtual void OnApplySelect()
Parse()
public override string Parse()
Returns
- string
Query()
public List<object> Query()
Returns
- List<object>
Query(Type)
public List<GenericVO> Query(Type entityType)
Parameters
| Nome |
Tipo |
Descrição |
entityType |
Type |
|
Returns
- List<GenericVO>
QueryAbstract()
public List<object> QueryAbstract()
Returns
- List<object>
QueryAbstractRaw()
public List<object> QueryAbstractRaw()
Returns
- List<object>
QueryArrayList()
public ArrayList QueryArrayList()
Returns
- ArrayList
QueryByTarget<T>()
public List<T> QueryByTarget<T>()
Returns
- List<T>
Type Parameters
T
QueryDataTable()
public DataTable QueryDataTable()
Returns
- DataTable
QueryDynamic()
public List<object> QueryDynamic()
Returns
- List<object>
QueryDynamic(Type)
public List<object> QueryDynamic(Type entityType)
Parameters
| Nome |
Tipo |
Descrição |
entityType |
Type |
|
Returns
- List<object>
QueryList<T>()
public List<T> QueryList<T>()
Returns
- List<T>
Type Parameters
T
QueryScalar<T>()
public T QueryScalar<T>()
Returns
- T
Type Parameters
T
Query<T>()
public List<T> Query<T>()
Returns
- List<T>
Type Parameters
T
RunQuery(DataReaderConverter)
protected IList RunQuery(DbCmd.DataReaderConverter converterType)
Parameters
Returns
- IList
RunQueryAbstract(DataReaderConverter)
protected IList RunQueryAbstract(DbCmd.DataReaderConverter converterType)
Parameters
Returns
- IList
RunQueryDataTable()
protected DataTable RunQueryDataTable()
Returns
- DataTable
RunQueryRaw(DataReaderConverter)
protected IList RunQueryRaw(DbCmd.DataReaderConverter converterType)
Parameters
Returns
- IList
RunQueryScalar()
protected object RunQueryScalar()
Returns
- object
Events
OnTryGetFromCache
public event DBCmdSelect.OnTryGetFromCacheEventHandler OnTryGetFromCache
Event Type
- DBCmdSelect.OnTryGetFromCacheEventHandler
Explicit Interface Implementations
SelectItems
SelectItems SelectItems { get; set; }
Returns
- SelectItems