/// <summary>
/// 分页获取数据
/// </summary>
/// <param name="data">分页数据</param>
/// <param name="count">总条数</param>
/// <param name="sqlp">参数</param>
/// <returns>实体列表数据</returns>
public virtual List <T> GetQueryManyForPage(SelectBuilderData data, out int count, List <SqlParameter> sqlp)
{
List <SqlParameter> temp = new List <SqlParameter>();
string sqlStr = SqlServerProvider.GetSqlForSelectBuilder(data);
string sqlStr2 = SqlServerProvider.GetSqlForTotalBuilder(data);
object totalCount = SqlQueryForScalar(sqlStr2, sqlp);
count = ZConvert.StrToInt(totalCount, 0);
return(SqlQuery(sqlStr, sqlp).ToList <T>());
}
private IDbCommand GetPreparedDbCommand(SelectBuilderData data)
{
if (data.PagingItemsPerPage > 0 &&
string.IsNullOrEmpty(data.OrderBy))
{
Logger("[SQL] Order by must defined when using Paging.", null);
return(null);
//throw new FluentDataException("Order by must defined when using Paging.");
}
data.Command.ClearSql.Sql(data.Command.Data.Context.Data.FluentDataProvider.GetSqlForSelectBuilder(data));
return(data.Command);
}
