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] プロジェクトファイルを追加。
---
ProtosExpan/Master/RoomType.cs | 287 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 287 insertions(+), 0 deletions(-)
diff --git a/ProtosExpan/Master/RoomType.cs b/ProtosExpan/Master/RoomType.cs
new file mode 100644
index 0000000..0592fce
--- /dev/null
+++ b/ProtosExpan/Master/RoomType.cs
@@ -0,0 +1,287 @@
+using System;
+using System.Collections.Concurrent;
+using System.Collections.Generic;
+using System.Data.SqlClient;
+using System.Text;
+using HotelPms.Share.Data;
+using HotelPms.Share.Util;
+using Google.Protobuf.WellKnownTypes;
+using customTypes;
+using System.Data.Common;
+
+namespace HotelPms.Data.Master;
+
+/// ****************************** Description *******************************
+/// ◇システム名称
+/// ホテルPMS
+/// ◇概要
+///
+/// ◇履歴
+/// 2021/05/14 コード作成ツール 自動作成
+/// ****************************** Declarations ******************************
+[Serializable()]
+public partial class RoomType : RecordBase
+{
+ #region ★★★★★ Property ★★★★★
+
+ public static ConcurrentDictionary<string, int> PrimaryKey { get; } = new ConcurrentDictionary<string, int>();
+
+ #endregion
+
+ partial void OnConstruction()
+ {
+ if (PrimaryKey.Count == 0)
+ {
+ PrimaryKey.TryAdd("ID", 0);
+
+ }
+ }
+
+ #region ★★★★★ Function ★★★★★
+
+ public bool CompareTo(RoomType item)
+ {
+ if (ID.CompareTo(item.ID) != 0
+ || Name.CompareTo(item.Name) != 0
+ || ShortName.CompareTo(item.ShortName) != 0
+ || Kind.CompareTo(item.Kind) != 0
+ || SortID.CompareTo(item.SortID) != 0
+ || Visible.CompareTo(item.Visible) != 0
+ || TypeListVisible.CompareTo(item.TypeListVisible) != 0
+ || TypeListAlertCount.CompareTo(item.TypeListAlertCount) != 0
+ || TypeListAlertColor.CompareTo(item.TypeListAlertColor) != 0
+ || WebType.CompareTo(item.WebType) != 0
+ || SendRate.CompareTo(item.SendRate) != 0
+ || SendLimit.CompareTo(item.SendLimit) != 0
+ || Memo.CompareTo(item.Memo) != 0
+ || UpdateDate.CompareTo(item.UpdateDate) != 0
+ || UpdateLoginID.CompareTo(item.UpdateLoginID) != 0
+ || UpdatePcName.CompareTo(item.UpdatePcName) != 0
+ || UpdateID.CompareTo(item.UpdateID) != 0
+)
+ {
+ return false;
+ }
+ return true;
+ }
+
+
+ public override void CopyTo(object dest)
+ {
+ RoomType item = dest as RoomType;
+ item.ID = ID;
+ item.Name = Name;
+ item.ShortName = ShortName;
+ item.Kind = Kind;
+ item.SortID = SortID;
+ item.Visible = Visible;
+ item.TypeListVisible = TypeListVisible;
+ item.TypeListAlertCount = TypeListAlertCount;
+ item.TypeListAlertColor = TypeListAlertColor;
+ item.WebType = WebType;
+ item.SendRate = SendRate;
+ item.SendLimit = SendLimit;
+ item.Memo = Memo;
+ item.UpdateDate = UpdateDate;
+ item.UpdateLoginID = UpdateLoginID;
+ item.UpdatePcName = UpdatePcName;
+ item.UpdateID = UpdateID;
+
+ }
+
+ public override void Clear()
+ {
+ ID = 0;
+ Name = string.Empty;
+ ShortName = string.Empty;
+ Kind = 0;
+ SortID = 0;
+ Visible = false;
+ TypeListVisible = false;
+ TypeListAlertCount = 0;
+ TypeListAlertColor = string.Empty;
+ WebType = string.Empty;
+ SendRate = 0;
+ SendLimit = 0;
+ Memo = string.Empty;
+ UpdateDate = CConvert.ToTimestamp(DateTime.MinValue);
+ UpdateLoginID = 0;
+ UpdatePcName = string.Empty;
+ UpdateID = 0;
+
+ }
+
+ public RoomType DeepClone()
+ {
+ RoomType item = new RoomType();
+ item.ID = ID;
+ item.Name = Name;
+ item.ShortName = ShortName;
+ item.Kind = Kind;
+ item.SortID = SortID;
+ item.Visible = Visible;
+ item.TypeListVisible = TypeListVisible;
+ item.TypeListAlertCount = TypeListAlertCount;
+ item.TypeListAlertColor = TypeListAlertColor;
+ item.WebType = WebType;
+ item.SendRate = SendRate;
+ item.SendLimit = SendLimit;
+ item.Memo = Memo;
+ item.UpdateDate = UpdateDate;
+ item.UpdateLoginID = UpdateLoginID;
+ item.UpdatePcName = UpdatePcName;
+ item.UpdateID = UpdateID;
+
+ return item;
+ }
+
+ public override bool ConvertDataRow(System.Data.DataRow row)
+ {
+ ID = CConvert.ToInt(row["ID"],ID);
+ Name = row["Name"].ToString();
+ ShortName = row["ShortName"].ToString();
+ Kind = CConvert.ToInt(row["Kind"],Kind);
+ SortID = CConvert.ToInt(row["SortID"],SortID);
+ Visible = CConvert.ToBool(row["Visible"]);
+ TypeListVisible = CConvert.ToBool(row["TypeListVisible"]);
+ TypeListAlertCount = CConvert.ToInt(row["TypeListAlertCount"],TypeListAlertCount);
+ TypeListAlertColor = row["TypeListAlertColor"].ToString();
+ WebType = row["WebType"].ToString();
+ SendRate = CConvert.ToInt(row["SendRate"],SendRate);
+ SendLimit = CConvert.ToInt(row["SendLimit"],SendLimit);
+ Memo = row["Memo"].ToString();
+ UpdateDate = CConvert.ToTimestamp(row.IsNull("UpdateDate") ? DateTime.MinValue : (System.DateTime)row["UpdateDate"]);
+ UpdateLoginID = CConvert.ToInt(row["UpdateLoginID"],UpdateLoginID);
+ UpdatePcName = row["UpdatePcName"].ToString();
+ UpdateID = CConvert.ToInt(row["UpdateID"],UpdateID);
+
+ return true;
+ }
+
+ public void ToDataRow(System.Data.DataRow row)
+ {
+ row["ID"] = ID;
+ row["Name"] = Name;
+ row["ShortName"] = ShortName;
+ row["Kind"] = Kind;
+ row["SortID"] = SortID;
+ row["Visible"] = Visible;
+ row["TypeListVisible"] = TypeListVisible;
+ row["TypeListAlertCount"] = TypeListAlertCount;
+ row["TypeListAlertColor"] = TypeListAlertColor;
+ row["WebType"] = WebType;
+ row["SendRate"] = SendRate;
+ row["SendLimit"] = SendLimit;
+ row["Memo"] = Memo;
+ row["UpdateDate"] = UpdateDate.ToDateTime();
+ row["UpdateLoginID"] = UpdateLoginID;
+ row["UpdatePcName"] = UpdatePcName;
+ row["UpdateID"] = UpdateID;
+
+ }
+
+ public void ConvertReader(DbDataReader row)
+ {
+ int i = 0;
+ ID = (int)(row.IsDBNull(i) ? 0 : row.GetInt16(i)); i++;
+ Name = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ ShortName = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ Kind = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++;
+ SortID = (int)(row.IsDBNull(i) ? 0 : row.GetInt16(i)); i++;
+ Visible = (bool)(row.IsDBNull(i) ? false : row.GetBoolean(i)); i++;
+ TypeListVisible = (bool)(row.IsDBNull(i) ? false : row.GetBoolean(i)); i++;
+ TypeListAlertCount = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ TypeListAlertColor = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ WebType = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ SendRate = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ SendLimit = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ Memo = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ UpdateDate = CConvert.ToTimestamp(row.IsDBNull(i) ? DateTime.MinValue : row.GetDateTime(i)); i++;
+ UpdateLoginID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ UpdatePcName = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ UpdateID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+
+ }
+
+ public string AddSql()
+ {
+ return $@"INSERT INTO M_RoomType(ID,Name,ShortName,Kind,SortID,Visible,TypeListVisible,TypeListAlertCount,TypeListAlertColor,WebType,SendRate,SendLimit,Memo,UpdateDate,UpdateLoginID,UpdatePcName,UpdateID) VALUES({ID},N'{Name}',N'{ShortName}',{Kind},{SortID},{(Visible ? 1 : 0)},{(TypeListVisible ? 1 : 0)},{TypeListAlertCount},N'{TypeListAlertColor}',N'{WebType}',{SendRate},{SendLimit},N'{Memo}',GETDATE(),{UpdateLoginID},N'{UpdatePcName}',{UpdateID});";
+ }
+
+ public string UpdateSql()
+ {
+ return $@"UPDATE M_RoomType SET Name = N'{Name}',ShortName = N'{ShortName}',Kind = {Kind},SortID = {SortID},Visible = {(Visible ? 1 : 0)},TypeListVisible = {(TypeListVisible ? 1 : 0)},TypeListAlertCount = {TypeListAlertCount},TypeListAlertColor = N'{TypeListAlertColor}',WebType = N'{WebType}',SendRate = {SendRate},SendLimit = {SendLimit},Memo = N'{Memo}',UpdateDate = GETDATE(),UpdateLoginID = {UpdateLoginID},UpdatePcName = N'{UpdatePcName}',UpdateID = {UpdateID} WHERE ID = {ID};";
+ }
+
+ public string ToText()
+ {
+ StringBuilder text = new StringBuilder();
+ text.AppendFormat("ID={0};", ID);
+ text.AppendFormat("Name={0};", Name);
+ text.AppendFormat("ShortName={0};", ShortName);
+ text.AppendFormat("Kind={0};", Kind);
+ text.AppendFormat("SortID={0};", SortID);
+ text.AppendFormat("Visible={0};", Visible);
+ text.AppendFormat("TypeListVisible={0};", TypeListVisible);
+ text.AppendFormat("TypeListAlertCount={0};", TypeListAlertCount);
+ text.AppendFormat("TypeListAlertColor={0};", TypeListAlertColor);
+ text.AppendFormat("WebType={0};", WebType);
+ text.AppendFormat("SendRate={0};", SendRate);
+ text.AppendFormat("SendLimit={0};", SendLimit);
+ text.AppendFormat("Memo={0};", Memo);
+ text.AppendFormat("UpdateDate={0};", UpdateDate);
+ text.AppendFormat("UpdateLoginID={0};", UpdateLoginID);
+ text.AppendFormat("UpdatePcName={0};", UpdatePcName);
+ text.AppendFormat("UpdateID={0};", UpdateID);
+
+ return text.ToString();
+ }
+
+ public override object GetField(string name)
+ {
+
+ if (name == "ID") { return ID; }
+ else if (name == "Name") { return Name; }
+ else if (name == "ShortName") { return ShortName; }
+ else if (name == "Kind") { return Kind; }
+ else if (name == "SortID") { return SortID; }
+ else if (name == "Visible") { return Visible; }
+ else if (name == "TypeListVisible") { return TypeListVisible; }
+ else if (name == "TypeListAlertCount") { return TypeListAlertCount; }
+ else if (name == "TypeListAlertColor") { return TypeListAlertColor; }
+ else if (name == "WebType") { return WebType; }
+ else if (name == "SendRate") { return SendRate; }
+ else if (name == "SendLimit") { return SendLimit; }
+ else if (name == "Memo") { return Memo; }
+ else if (name == "UpdateDate") { return UpdateDate; }
+ else if (name == "UpdateLoginID") { return UpdateLoginID; }
+ else if (name == "UpdatePcName") { return UpdatePcName; }
+ else if (name == "UpdateID") { return UpdateID; }
+ else { return null; }
+ }
+
+ public override bool SetField(string name, object value)
+ {
+
+ if (name == "ID") { ID = CConvert.ToInt(value); return true; }
+ else if (name == "Name") { Name = value.ToString(); return true; }
+ else if (name == "ShortName") { ShortName = value.ToString(); return true; }
+ else if (name == "Kind") { Kind = CConvert.ToInt(value); return true; }
+ else if (name == "SortID") { SortID = CConvert.ToInt(value); return true; }
+ else if (name == "Visible") { Visible = CConvert.ToBool(value); return true; }
+ else if (name == "TypeListVisible") { TypeListVisible = CConvert.ToBool(value); return true; }
+ else if (name == "TypeListAlertCount") { TypeListAlertCount = CConvert.ToInt(value); return true; }
+ else if (name == "TypeListAlertColor") { TypeListAlertColor = value.ToString(); return true; }
+ else if (name == "WebType") { WebType = value.ToString(); return true; }
+ else if (name == "SendRate") { SendRate = CConvert.ToInt(value); return true; }
+ else if (name == "SendLimit") { SendLimit = CConvert.ToInt(value); return true; }
+ else if (name == "Memo") { Memo = value.ToString(); return true; }
+ else if (name == "UpdateDate") { UpdateDate = CConvert.ToTimestamp(CConvert.ToDateTime(value)); return true; }
+ else if (name == "UpdateLoginID") { UpdateLoginID = CConvert.ToInt(value); return true; }
+ else if (name == "UpdatePcName") { UpdatePcName = value.ToString(); return true; }
+ else if (name == "UpdateID") { UpdateID = CConvert.ToInt(value); return true; }
+ else { return false; }
+ }
+
+ #endregion
+}
\ No newline at end of file
--
Gitblit v1.10.0