using System.Data;

namespace HotelPms.Share.Data;

public abstract class TableAccessBase : IDisposable
{
    /// <summary>
    /// 同期用
    /// </summary>
    public static object SyncRoot { get; set; } = new object();

    /// <summary>
    /// テーブル名
    /// </summary>
    public string TableName { get; set; } = string.Empty;

    /// <summary>
    /// 追加SQL
    /// SourceFactoryより自動で生成可能
    /// </summary>
    public string InsertSql { get; set; } = string.Empty;

    /// <summary>
    /// 更新SQL
    /// SourceFactoryより自動で生成可能
    /// </summary>
    public string UpdateSql { get; set; } = string.Empty;

    public TableAccessBase(string tableName)
    {
        TableName = tableName;
    }

    public abstract System.Data.DataTable GetPopUpList(DataAccess access);

    public abstract System.Data.DataTable GetPopUpList(DataAccess access, object[] key);

    /// <summary> 項目値を返す
    /// </summary>
    /// <param name="msSqlNet"></param>
    /// <param name="pHotelCode"></param>
    /// <param name="field"></param>
    /// <returns></returns>
    public object GetFieldValue(DataAccess access, string field, string where)
    {
        return access.ExecuteScalar(string.Format("Select {1} From {0} {2}", TableName, field, where));
    }

    /// <summary> 複数項目値を返す
    /// </summary>
    /// <param name="msSqlNet"></param>
    /// <param name="pHotelCode"></param>
    /// <param name="fields">Name1,Name2,Name3…</param>
    /// <returns></returns>
    public DataTable GetFields(DataAccess access, string fields, string where)
    {
        return access.GetDataTable(string.Format("Select {1} From {0} {2}", TableName, fields, where));
    }

    /// <summary> 項目更新
    /// </summary>
    /// <param name="msSqlNet"></param>
    /// <param name="pHotelCode"></param>
    /// <param name="field"></param>
    /// <returns></returns>
    public bool SetFieldValue(DataAccess access, string field, string value, string where)
    {
        return access.ExecuteNonQuery(string.Format(" UPDATE {0} SET {1} = '{2}' {3}", TableName, field, value, where)) > 0;
    }

    public virtual void Dispose()
    {

    }
}