public StatusModel 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) { Set(context, Repository.ExecuteTable( context: context, statements: Rds.SelectStatuses( tableType: tableType, column: column ?? Rds.StatusesDefaultColumns(), join: join ?? Rds.StatusesJoinDefault(), where : where ?? Rds.StatusesWhereDefault(this), 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) { var statements = new List<SqlStatement> { Rds.SelectDemos( dataTableName: "Main", column: column ?? Rds.DemosDefaultColumns(), join: join ?? Rds.DemosJoinDefault(), where: where, orderBy: orderBy, param: param, tableType: tableType, distinct: distinct, top: top, offset: offset, pageSize: pageSize, countRecord: countRecord) }; var dataSet = Rds.ExecuteDataSet( transactional: false, statements: statements.ToArray()); TotalCount = Rds.Count(dataSet); return dataSet.Tables["Main"].AsEnumerable(); }
public GridData( SiteSettings ss, View view, SqlColumnCollection column = null, SqlJoinCollection join = null, SqlWhereCollection where = null, int top = 0, int offset = 0, int pageSize = 0, bool countRecord = false, IEnumerable <Aggregation> aggregations = null) { Get( ss: ss, view: view, column: column, join: join, where : where, top: top, offset: offset, pageSize: pageSize, countRecord: countRecord, aggregations: aggregations); }
private void Get( Context context, SiteSettings ss, View view, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlColumnCollection column = null, SqlJoinCollection join = null, SqlWhereCollection where = null, int top = 0, int offset = 0, int pageSize = 0, bool count = true) { column = column ?? ColumnUtilities.SqlColumnCollection( context: context, ss: ss, view: view, columns: ss.GetGridColumns( context: context, view: view, includedColumns: true)); where = view.Where( context: context, ss: ss, where : where); var orderBy = view.OrderBy( context: context, ss: ss); join = join ?? ss.Join( context: context, join: new IJoin[] { column, where, orderBy }); var param = view.Param( context: context, ss: ss); var statements = new List <SqlStatement>(); statements.Add(Rds.Select( tableName: ss.ReferenceType, tableType: tableType, dataTableName: "Main", column: column, join: join, where : where, orderBy: orderBy, param: param, top: top, offset: offset, pageSize: pageSize)); if (count) { statements.Add(Rds.SelectCount( tableName: ss.ReferenceType, tableType: tableType, join: join, where : where)); } DataSet dataSet; try { dataSet = Repository.ExecuteDataSet( context: context, transactional: false, statements: statements.ToArray()); } catch (System.Exception e) { Views.SetSession( context: context, ss: ss, view: new View(), setSession: true, key: "View", useUsersView: ss.SaveViewType == SiteSettings.SaveViewTypes.User); throw e; } DataRows = dataSet.Tables["Main"].AsEnumerable(); TotalCount = Rds.Count(dataSet); ss.SetChoiceHash( context: context, dataRows: DataRows); }
private void Get( Context context, SiteSettings ss, View view, Sqls.TableTypes tableType = Sqls.TableTypes.Normal, SqlColumnCollection column = null, SqlJoinCollection join = null, SqlWhereCollection where = null, int top = 0, int offset = 0, int pageSize = 0) { column = column ?? ColumnUtilities.SqlColumnCollection( context: context, ss: ss, columns: ss.GetGridColumns( context: context, view: view)); where = view.Where( context: context, ss: ss, where : where); var orderBy = view.OrderBy( context: context, ss: ss); join = join ?? ss.Join( context: context, join: new IJoin[] { column, where, orderBy }); var statements = new List <SqlStatement> { Rds.Select( tableName: ss.ReferenceType, tableType: tableType, dataTableName: "Main", column: column, join: join, where : where, orderBy: orderBy, top: top, offset: offset, pageSize: pageSize), Rds.SelectCount( tableName: ss.ReferenceType, tableType: tableType, join: join, where : where) }; var dataSet = Rds.ExecuteDataSet( context: context, transactional: false, statements: statements.ToArray()); DataRows = dataSet.Tables["Main"].AsEnumerable(); TotalCount = Rds.Count(dataSet); ss.SetChoiceHash(dataRows: DataRows); }