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