From 1a1c8e71fcd14858f595029f089b2d4a00202b32 Mon Sep 17 00:00:00 2001
From: ogi <Administrator@S-OGI-PC>
Date: Fri, 05 Dec 2025 09:24:16 +0900
Subject: [PATCH] プロジェクトファイルを追加。
---
HotelPms.Share/Data/TableAccessBase.cs | 75 +++++++++++++++++++++++++++++++++++++
1 files changed, 75 insertions(+), 0 deletions(-)
diff --git a/HotelPms.Share/Data/TableAccessBase.cs b/HotelPms.Share/Data/TableAccessBase.cs
new file mode 100644
index 0000000..23b7f99
--- /dev/null
+++ b/HotelPms.Share/Data/TableAccessBase.cs
@@ -0,0 +1,75 @@
+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()
+ {
+
+ }
+}
--
Gitblit v1.10.0