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