public DataTable FindTablePage <T>(string WhereSql, DbParameter[] parameters, string orderField, string orderType, int pageIndex, int pageSize, ref int recordCount) where T : new()
{
StringBuilder builder = DatabaseCommon.SelectSql <T>();
builder.Append(WhereSql);
return(SqlServerHelper.GetPageTable(builder.ToString(), parameters, orderField, orderType, pageIndex, pageSize, ref recordCount));
}
public DataTable FindTablePageBySql(string strSql, DbParameter[] parameters, string orderField, string orderType, int pageIndex, int pageSize, ref int recordCount)
{
return(SqlServerHelper.GetPageTable(strSql, parameters, orderField, orderType, pageIndex, pageSize, ref recordCount));
}
public DataTable FindTablePage <T>(string orderField, string orderType, int pageIndex, int pageSize, ref int recordCount) where T : new()
{
return(SqlServerHelper.GetPageTable(DatabaseCommon.SelectSql <T>().ToString(), orderField, orderType, pageIndex, pageSize, ref recordCount));
}