/// <summary>
/// 分页查询(为什么不用out，请参考：http://www.cnblogs.com/dunitian/p/5556909.html)
/// </summary>
/// <param name="sql">查询语句</param>
/// <param name="p">动态参数</param>
/// <param name="sqlTotal">total语句</param>
/// <param name="p2">Total动态参数</param>
/// <returns></returns>
public async Task <PageData <T> > PageLoadAsync <T>(string sql, object p = null, string sqlTotal = "", object p2 = null)
{
var pageData = new PageData <T>()
{
rows = await DapperDataAsync.QueryAsync <T>(sql.ToString(), p)
};
if (!sqlTotal.IsNullOrWhiteSpace())
{
pageData.total = await DapperDataAsync.ExecuteScalarAsync <int>(sqlTotal, p2);
}
return(pageData);
}
/// <summary>
/// 动态类型查询 | 多映射动态查询
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <param name="transaction"></param>
/// <param name="buffered"></param>
/// <returns></returns>
public async Task <IEnumerable <dynamic> > QueryAsyncDynamic(string sql, object param = null, IDbTransaction transaction = null, int?commandTimeout = default(int?), CommandType?commandType = default(CommandType?))
{
return(await DapperDataAsync.QueryAsync(sql, param, transaction, commandTimeout, commandType));
}
