/// <summary>
/// 列表查询分页-sql通用查询
/// </summary>
/// <typeparam name="TEnity"> 根据sql定义Model</typeparam>
/// <param name="sql"></param>
/// <param name="param">@totalCoun 返回行数</param>
/// <param name="isCommandTypeText"></param>
/// <returns></returns>
public async Task <Tuple <IEnumerable <TEnity>, int> > SQLQueryWithReturnAsync <TEnity>(string sql, object param = null, bool isCommandTypeText = true)
{
var gridReader = await _context.QueryMultipleAsync(sql, param, isCommandTypeText?CommandType.Text : CommandType.StoredProcedure);
var list = await gridReader.ReadAsync <TEnity>();
var count = await gridReader.ReadAsync <long>();
return(new Tuple <IEnumerable <TEnity>, int>(list, (int)count.FirstOrDefault()));
}