using System.Data;
using System.Data.Common;

namespace HotelPms.Share.Data;

public abstract class DataAccess : IDisposable
{
    public abstract string UseID { get; set; }

    /// <summary>パスワード</summary>
    public abstract string PassWord { get; set; }

    /// <summary>データベース所在のパソコン名</summary>
    public abstract string DataSource { get; set; }

    /// <summary>データベース名</summary>
    public abstract string Catalog { get; set; }

    public abstract string Schema { get; set; }

    public abstract int Port { get; set; }

    public abstract int ErrNo { get; set; }

    public abstract string ErrInfo { get; set; }

    public abstract System.Data.DataSet GetDataSet(string sql);
    public abstract System.Data.DataSet GetDataSetWithTran(string sql);

    public abstract System.Data.DataTable GetDataTable(string sql);
    public abstract object ExecuteScalar(string sql);
    public abstract int ExecuteGetID(string sql);

    public abstract int ExecuteNonQuery(string sql);

    public abstract bool ExecuteNonQueryWithTran(string sql);

    public abstract void Dispose();

    public abstract DataTable GetTableList();

    public abstract DataTable GetTableList(string whereAdding);

    public abstract T GetDataReader<T>(string sql, Action<DbDataReader, T> Fetch) where T : new();
}