public static DataTable BulkGetEmptyDataTable(this DbAccessor db, string tableName)
{
DataTable dt = db.QueryDataTable(string.Format("select * from {0} where 1=2", tableName));
dt.TableName = tableName;
return(dt);
}
public static DataTable PageQueryDataTable(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.QueryDataTable(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.QueryDataTable(paging.GetPageSql(sql, orderClause, startRowIndex, rowCount), objParameters));
}
}
