SQLSugar中查询DataTable

SQLSugar中查询DataTable

public class BaseRespository : IBaseRespository
{
    private readonly ISqlSugarClient _dbOracleSAPSR3;
    private readonly ILogger<BaseRespository> _logger;

    public BaseRespository(ILogger<BaseRespository> logger)
    {
        _dbOracleSAPSR3 = DbScoped.SugarScope.GetConnectionScope("xxxx");
        _logger = logger;
    }

    public int Excute(string sql)
    {
        try
        {
            _dbOracleSAPSR3.Ado.BeginTran();
            int v = _dbOracleSAPSR3.Ado.ExecuteCommand(sql);
            _dbOracleSAPSR3.Ado.CommitTran();
            return v;
        }
        catch (System.Exception ex)
        {
            _logger.LogError(ex.Message);
            _dbOracleSAPSR3.Ado.RollbackTran();
            return -1;
        }
    }

    public DataTable QueryDataTable(string sql)
    {
        // ❌:                                            👇👇👇👇👇👇👇
        // List<DataTable> dataTable = _dbOracleSAPSR3.Ado.SqlQuery<DataTable>(sql);
        //✅:                                    👇👇👇👇👇👇👇
        DataTable dataTable = _dbOracleSAPSR3.Ado.GetDataTable(sql);
        return dataTable;
    }

    public List<T> Query<T>(string sql)
    {

        List<T> dataTable = _dbOracleSAPSR3.Ado.SqlQuery<T>(sql);
        return dataTable;
    }
}