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);
}
