public DeptModel Get(
SiteSettings ss,
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(ss, Rds.ExecuteTable(statements: Rds.SelectDepts(
tableType: tableType,
column: column ?? Rds.DeptsDefaultColumns(),
join: join ?? Rds.DeptsJoinDefault(),
where : where ?? Rds.DeptsWhereDefault(this),
orderBy: orderBy,
param: param,
distinct: distinct,
top: top)));
return(this);
}
private IEnumerable <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.SelectDepts(
dataTableName: "Main",
column: column ?? Rds.DeptsDefaultColumns(),
join: join ?? Rds.DeptsJoinDefault(),
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());
}
