using System.Data;

namespace Web.Core.Common.Dapper;

public interface IDapperHelper
{
    public T QueryFirstOrDefault<T>(DapperHelper.SysName sysName,string sql, object param = null);
    
    public Task<T> QueryFirstOrDefaultAsync<T>(DapperHelper.SysName sysName,string sql, object param = null);

    public IEnumerable<T> Query<T>(DapperHelper.SysName sysName,string sql, object param = null, IDbTransaction transaction = null,
        bool buffered = true, int? commandTimeout = null, CommandType? commandType = null);

    public  Task<IEnumerable<T>> QueryAsync<T>(DapperHelper.SysName sysName,string sql, object param = null, IDbTransaction transaction = null,
        int? commandTimeout = null, CommandType? commandType = null);

    public int Execute(DapperHelper.SysName sysName, string sql, object param = null, IDbTransaction transaction = null,
        int? commandTimeout = null, CommandType? commandType = null);

    public  Task<int> ExecuteAsync(DapperHelper.SysName sysName, string sql, object param = null,
        IDbTransaction transaction = null, int? commandTimeout = null, CommandType? commandType = null);

    public T ExecuteScalar<T>(DapperHelper.SysName sysName, string sql, object param = null, IDbTransaction transaction = null,
        int? commandTimeout = null, CommandType? commandType = null);

    public  Task<T> ExecuteScalarAsync<T>(DapperHelper.SysName sysName, string sql, object param = null,
        IDbTransaction transaction = null, int? commandTimeout = null, CommandType? commandType = null);
}