public static IList <T> SelectList <T>(this DbAccessor db, object objParameters)
{
var tableMapping = new TableMapping(typeof(T));
ISqlBuilder sqlBuilder = new DefaultSqlBuilder(tableMapping);
return(db.QueryEntities <T>(sqlBuilder.BuildSelectList(), objParameters));
}
public static IList <T> PageQueryEntities <T>(this DbAccessor db,
string sql, string orderClause, int pageIndex, int rowCount, out int totalRowCount,
object objParameters = null)
{
DbPaging paging = DbPagingFactory.GetDbPaging(db);
if (objParameters == null)
{
object objTotalRowCount = db.ExecuteScalar <object>(paging.GetCountSql(sql));
totalRowCount = Convert.ToInt32(objTotalRowCount);
int startRowIndex = 1 + (pageIndex - 1) * rowCount;
return(db.QueryEntities <T>(paging.GetPageSql(sql, orderClause, startRowIndex, rowCount)));
}
else
{
object objTotalRowCount = db.ExecuteScalar <object>(paging.GetCountSql(sql), objParameters);
totalRowCount = Convert.ToInt32(objTotalRowCount);
int startRowIndex = 1 + (pageIndex - 1) * rowCount;
return(db.QueryEntities <T>(paging.GetPageSql(sql, orderClause, startRowIndex, rowCount), objParameters));
}
}
