/// <summary>
/// 设置查询列和分页参数执行查询，并且将结果集转成DataTable
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="sqlable"></param>
/// <param name="fileds">查询列</param>
/// <param name="orderByFiled">Order By字段，可以多个</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">每页显示数量</param>
/// <param name="whereObj">SQL参数,例如:new{id=1,name="张三"}</param>
/// <returns></returns>
public static DataTable SelectToPageTable(this Sqlable sqlable, string fileds, string orderByFiled, int pageIndex, int pageSize, object whereObj = null)
{
StringBuilder sbSql = new StringBuilder(sqlable.Sql.ToString());
try
{
if (pageIndex == 0)
{
pageIndex = 1;
}
Check.ArgumentNullException(sqlable.Sql, "语法错误，SelectToSql必需要在.Form后面使用");
SqlSugarTool.GetSqlableSql(sqlable, fileds, orderByFiled, pageIndex, pageSize, sbSql);
var sqlParams = GetAllParas(sqlable, whereObj);
var reval = sqlable.DB.GetDataTable(sbSql.ToString(), sqlParams);
return(reval);
}
catch (Exception ex)
{
Check.Exception(true, "sql:{0} \r\n message:{1}", sbSql.ToString(), ex.Message);
throw;
}
finally
{
sbSql = null;
sqlable = null;
}
}