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