public BinaryModel Get( Context context, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlColumnCollection column = null, SqlJoinCollection join = null, SqlWhereCollection where = null, SqlOrderByCollection orderBy = null, SqlParamCollection param = null, bool distinct = false, int top = 0) { where = where ?? Rds.BinariesWhereDefault( context: context, binaryModel: this); column = (column ?? Rds.BinariesDefaultColumns()); join = join ?? Rds.BinariesJoinDefault(); Set(context, Repository.ExecuteTable( context: context, statements: Rds.SelectBinaries( tableType: tableType, column: column, join: join, where : where, orderBy: orderBy, param: param, distinct: distinct, top: top))); return(this); }
private EnumerableRowCollection <DataRow> Get( SqlColumnCollection column = null, SqlJoinCollection join = null, SqlWhereCollection where = null, SqlOrderByCollection orderBy = null, SqlParamCollection param = null, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, bool distinct = false, int top = 0, int offset = 0, int pageSize = 0, bool history = false, bool countRecord = false, IEnumerable <Aggregation> aggregations = null) { var statements = new List <SqlStatement> { Rds.SelectBinaries( dataTableName: "Main", column: column ?? Rds.BinariesDefaultColumns(), join: join ?? Rds.BinariesJoinDefault(), where : where, orderBy: orderBy, param: param, tableType: tableType, distinct: distinct, top: top, offset: offset, pageSize: pageSize, countRecord: countRecord) }; if (aggregations != null) { statements.AddRange(Rds.BinariesAggregations( aggregations: aggregations, join: join ?? Rds.BinariesJoinDefault(), where : where)); } var dataSet = Rds.ExecuteDataSet( transactional: false, statements: statements.ToArray()); Aggregations.Set(dataSet, aggregations); return(dataSet.Tables["Main"].AsEnumerable()); }
private EnumerableRowCollection <DataRow> Get( Context context, SqlColumnCollection column = null, SqlJoinCollection join = null, SqlWhereCollection where = null, SqlOrderByCollection orderBy = null, SqlParamCollection param = null, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, bool distinct = false, int top = 0, int offset = 0, int pageSize = 0) { var statements = new List <SqlStatement> { Rds.SelectBinaries( dataTableName: "Main", column: column ?? Rds.BinariesDefaultColumns(), join: join ?? Rds.BinariesJoinDefault(), where : where, orderBy: orderBy, param: param, tableType: tableType, distinct: distinct, top: top, offset: offset, pageSize: pageSize), Rds.SelectCount( tableName: "Binaries", tableType: tableType, join: join ?? Rds.BinariesJoinDefault(), where : where) }; var dataSet = Rds.ExecuteDataSet( context: context, transactional: false, statements: statements.ToArray()); TotalCount = Rds.Count(dataSet); return(dataSet.Tables["Main"].AsEnumerable()); }
public BinaryModel Get( Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlColumnCollection column = null, SqlJoinCollection join = null, SqlWhereCollection where = null, SqlOrderByCollection orderBy = null, SqlParamCollection param = null, bool distinct = false, int top = 0) { Set(Rds.ExecuteTable(statements: Rds.SelectBinaries( tableType: tableType, column: column ?? Rds.BinariesDefaultColumns(), join: join ?? Rds.BinariesJoinDefault(), where : where ?? Rds.BinariesWhereDefault(this), orderBy: orderBy, param: param, distinct: distinct, top: top))); return(this); }