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/UseInfo/UseRoom.cs | 389 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 389 insertions(+), 0 deletions(-)
diff --git a/ProtosExpan/UseInfo/UseRoom.cs b/ProtosExpan/UseInfo/UseRoom.cs
new file mode 100644
index 0000000..0425696
--- /dev/null
+++ b/ProtosExpan/UseInfo/UseRoom.cs
@@ -0,0 +1,389 @@
+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.UseInfo;
+
+/// ****************************** Description *******************************
+/// ◇システム名称
+/// ホテルPMS
+/// ◇概要
+///
+/// ◇履歴
+/// 2021/05/14 コード作成ツール 自動作成
+/// ****************************** Declarations ******************************
+[Serializable()]
+public partial class UseRoom : 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);
+ PrimaryKey.TryAdd("DetailID", 0);
+ PrimaryKey.TryAdd("UseDate", 0);
+
+ }
+ }
+
+ #region ★★★★★ Function ★★★★★
+
+ public bool CompareTo(UseRoom item)
+ {
+ if (ID.CompareTo(item.ID) != 0
+ || DetailID.CompareTo(item.DetailID) != 0
+ || UseDate.CompareTo(item.UseDate) != 0
+ || BeginTime.CompareTo(item.BeginTime) != 0
+ || EndTime.CompareTo(item.EndTime) != 0
+ || RoomTypeID.CompareTo(item.RoomTypeID) != 0
+ || RoomKind.CompareTo(item.RoomKind) != 0
+ || RoomID.CompareTo(item.RoomID) != 0
+ || AgentID.CompareTo(item.AgentID) != 0
+ || AgentBranchID.CompareTo(item.AgentBranchID) != 0
+ || PersionCount.CompareTo(item.PersionCount) != 0
+ || Adult.CompareTo(item.Adult) != 0
+ || ChildA.CompareTo(item.ChildA) != 0
+ || ChildB.CompareTo(item.ChildB) != 0
+ || ChildC.CompareTo(item.ChildC) != 0
+ || ChildD.CompareTo(item.ChildD) != 0
+ || ChildE.CompareTo(item.ChildE) != 0
+ || ChildF.CompareTo(item.ChildF) != 0
+ || Infant.CompareTo(item.Infant) != 0
+ || InFemaleAdult.CompareTo(item.InFemaleAdult) != 0
+ || InFemaleChildA.CompareTo(item.InFemaleChildA) != 0
+ || InFemaleChildB.CompareTo(item.InFemaleChildB) != 0
+ || InFemaleChildC.CompareTo(item.InFemaleChildC) != 0
+ || InFemaleChildD.CompareTo(item.InFemaleChildD) != 0
+ || InFemaleChildE.CompareTo(item.InFemaleChildE) != 0
+ || InFemaleChildF.CompareTo(item.InFemaleChildF) != 0
+ || InFemaleInfant.CompareTo(item.InFemaleInfant) != 0
+)
+ {
+ return false;
+ }
+ return true;
+ }
+
+
+ public override void CopyTo(object dest)
+ {
+ UseRoom item = dest as UseRoom;
+ item.ID = ID;
+ item.DetailID = DetailID;
+ item.UseDate = UseDate;
+ item.BeginTime = BeginTime;
+ item.EndTime = EndTime;
+ item.RoomTypeID = RoomTypeID;
+ item.RoomKind = RoomKind;
+ item.RoomID = RoomID;
+ item.AgentID = AgentID;
+ item.AgentBranchID = AgentBranchID;
+ item.PersionCount = PersionCount;
+ item.Adult = Adult;
+ item.ChildA = ChildA;
+ item.ChildB = ChildB;
+ item.ChildC = ChildC;
+ item.ChildD = ChildD;
+ item.ChildE = ChildE;
+ item.ChildF = ChildF;
+ item.Infant = Infant;
+ item.InFemaleAdult = InFemaleAdult;
+ item.InFemaleChildA = InFemaleChildA;
+ item.InFemaleChildB = InFemaleChildB;
+ item.InFemaleChildC = InFemaleChildC;
+ item.InFemaleChildD = InFemaleChildD;
+ item.InFemaleChildE = InFemaleChildE;
+ item.InFemaleChildF = InFemaleChildF;
+ item.InFemaleInfant = InFemaleInfant;
+
+ }
+
+ public override void Clear()
+ {
+ ID = 0;
+ DetailID = 0;
+ UseDate = Date.Default;
+ BeginTime = 0;
+ EndTime = 0;
+ RoomTypeID = 0;
+ RoomKind = 0;
+ RoomID = 0;
+ AgentID = 0;
+ AgentBranchID = 0;
+ PersionCount = 0;
+ Adult = 0;
+ ChildA = 0;
+ ChildB = 0;
+ ChildC = 0;
+ ChildD = 0;
+ ChildE = 0;
+ ChildF = 0;
+ Infant = 0;
+ InFemaleAdult = 0;
+ InFemaleChildA = 0;
+ InFemaleChildB = 0;
+ InFemaleChildC = 0;
+ InFemaleChildD = 0;
+ InFemaleChildE = 0;
+ InFemaleChildF = 0;
+ InFemaleInfant = 0;
+
+ }
+
+ public UseRoom DeepClone()
+ {
+ UseRoom item = new UseRoom();
+ item.ID = ID;
+ item.DetailID = DetailID;
+ item.UseDate = UseDate;
+ item.BeginTime = BeginTime;
+ item.EndTime = EndTime;
+ item.RoomTypeID = RoomTypeID;
+ item.RoomKind = RoomKind;
+ item.RoomID = RoomID;
+ item.AgentID = AgentID;
+ item.AgentBranchID = AgentBranchID;
+ item.PersionCount = PersionCount;
+ item.Adult = Adult;
+ item.ChildA = ChildA;
+ item.ChildB = ChildB;
+ item.ChildC = ChildC;
+ item.ChildD = ChildD;
+ item.ChildE = ChildE;
+ item.ChildF = ChildF;
+ item.Infant = Infant;
+ item.InFemaleAdult = InFemaleAdult;
+ item.InFemaleChildA = InFemaleChildA;
+ item.InFemaleChildB = InFemaleChildB;
+ item.InFemaleChildC = InFemaleChildC;
+ item.InFemaleChildD = InFemaleChildD;
+ item.InFemaleChildE = InFemaleChildE;
+ item.InFemaleChildF = InFemaleChildF;
+ item.InFemaleInfant = InFemaleInfant;
+
+ return item;
+ }
+
+ public override bool ConvertDataRow(System.Data.DataRow row)
+ {
+ ID = CConvert.ToInt(row["ID"],ID);
+ DetailID = CConvert.ToInt(row["DetailID"],DetailID);
+ UseDate = new Date(row.IsNull("UseDate") ? 0 : CConvert.ToDateInt((System.DateTime)row["UseDate"]));
+ BeginTime = CConvert.ToInt(row["BeginTime"],BeginTime);
+ EndTime = CConvert.ToInt(row["EndTime"],EndTime);
+ RoomTypeID = CConvert.ToInt(row["RoomTypeID"],RoomTypeID);
+ RoomKind = CConvert.ToInt(row["RoomKind"],RoomKind);
+ RoomID = CConvert.ToInt(row["RoomID"],RoomID);
+ AgentID = CConvert.ToInt(row["AgentID"],AgentID);
+ AgentBranchID = CConvert.ToInt(row["AgentBranchID"],AgentBranchID);
+ PersionCount = CConvert.ToInt(row["PersionCount"],PersionCount);
+ Adult = CConvert.ToInt(row["Adult"],Adult);
+ ChildA = CConvert.ToInt(row["ChildA"],ChildA);
+ ChildB = CConvert.ToInt(row["ChildB"],ChildB);
+ ChildC = CConvert.ToInt(row["ChildC"],ChildC);
+ ChildD = CConvert.ToInt(row["ChildD"],ChildD);
+ ChildE = CConvert.ToInt(row["ChildE"],ChildE);
+ ChildF = CConvert.ToInt(row["ChildF"],ChildF);
+ Infant = CConvert.ToInt(row["Infant"],Infant);
+ InFemaleAdult = CConvert.ToInt(row["InFemaleAdult"],InFemaleAdult);
+ InFemaleChildA = CConvert.ToInt(row["InFemaleChildA"],InFemaleChildA);
+ InFemaleChildB = CConvert.ToInt(row["InFemaleChildB"],InFemaleChildB);
+ InFemaleChildC = CConvert.ToInt(row["InFemaleChildC"],InFemaleChildC);
+ InFemaleChildD = CConvert.ToInt(row["InFemaleChildD"],InFemaleChildD);
+ InFemaleChildE = CConvert.ToInt(row["InFemaleChildE"],InFemaleChildE);
+ InFemaleChildF = CConvert.ToInt(row["InFemaleChildF"],InFemaleChildF);
+ InFemaleInfant = CConvert.ToInt(row["InFemaleInfant"],InFemaleInfant);
+
+ return true;
+ }
+
+ public void ToDataRow(System.Data.DataRow row)
+ {
+ row["ID"] = ID;
+ row["DetailID"] = DetailID;
+ row["UseDate"] = UseDate.ToDateTime();
+ row["BeginTime"] = BeginTime;
+ row["EndTime"] = EndTime;
+ row["RoomTypeID"] = RoomTypeID;
+ row["RoomKind"] = RoomKind;
+ row["RoomID"] = RoomID;
+ row["AgentID"] = AgentID;
+ row["AgentBranchID"] = AgentBranchID;
+ row["PersionCount"] = PersionCount;
+ row["Adult"] = Adult;
+ row["ChildA"] = ChildA;
+ row["ChildB"] = ChildB;
+ row["ChildC"] = ChildC;
+ row["ChildD"] = ChildD;
+ row["ChildE"] = ChildE;
+ row["ChildF"] = ChildF;
+ row["Infant"] = Infant;
+ row["InFemaleAdult"] = InFemaleAdult;
+ row["InFemaleChildA"] = InFemaleChildA;
+ row["InFemaleChildB"] = InFemaleChildB;
+ row["InFemaleChildC"] = InFemaleChildC;
+ row["InFemaleChildD"] = InFemaleChildD;
+ row["InFemaleChildE"] = InFemaleChildE;
+ row["InFemaleChildF"] = InFemaleChildF;
+ row["InFemaleInfant"] = InFemaleInfant;
+
+ }
+
+ public void ConvertReader(DbDataReader row)
+ {
+ int i = 0;
+ ID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ DetailID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ UseDate = new Date(row.IsDBNull(i) ? 0 : CConvert.ToDateInt(row.GetDateTime(i))); i++;
+ BeginTime = (int)(row.IsDBNull(i) ? 0 : row.GetInt16(i)); i++;
+ EndTime = (int)(row.IsDBNull(i) ? 0 : row.GetInt16(i)); i++;
+ RoomTypeID = (int)(row.IsDBNull(i) ? 0 : row.GetInt16(i)); i++;
+ RoomKind = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++;
+ RoomID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ AgentID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ AgentBranchID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ PersionCount = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ Adult = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ ChildA = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ ChildB = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ ChildC = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ ChildD = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ ChildE = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ ChildF = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ Infant = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ InFemaleAdult = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ InFemaleChildA = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ InFemaleChildB = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ InFemaleChildC = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ InFemaleChildD = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ InFemaleChildE = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ InFemaleChildF = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ InFemaleInfant = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+
+ }
+
+ public string AddSql()
+ {
+ return $@"INSERT INTO D_UseRoom(ID,DetailID,UseDate,BeginTime,EndTime,RoomTypeID,RoomKind,RoomID,AgentID,AgentBranchID,PersionCount,Adult,ChildA,ChildB,ChildC,ChildD,ChildE,ChildF,Infant,InFemaleAdult,InFemaleChildA,InFemaleChildB,InFemaleChildC,InFemaleChildD,InFemaleChildE,InFemaleChildF,InFemaleInfant) VALUES({ID},{DetailID},{(UseDate == null ? "NULL" : UseDate.ToSqlValue())},{BeginTime},{EndTime},{RoomTypeID},{RoomKind},{RoomID},{AgentID},{AgentBranchID},{PersionCount},{Adult},{ChildA},{ChildB},{ChildC},{ChildD},{ChildE},{ChildF},{Infant},{InFemaleAdult},{InFemaleChildA},{InFemaleChildB},{InFemaleChildC},{InFemaleChildD},{InFemaleChildE},{InFemaleChildF},{InFemaleInfant});";
+ }
+
+ public string UpdateSql()
+ {
+ return $@"UPDATE D_UseRoom SET BeginTime = {BeginTime},EndTime = {EndTime},RoomTypeID = {RoomTypeID},RoomKind = {RoomKind},RoomID = {RoomID},AgentID = {AgentID},AgentBranchID = {AgentBranchID},PersionCount = {PersionCount},Adult = {Adult},ChildA = {ChildA},ChildB = {ChildB},ChildC = {ChildC},ChildD = {ChildD},ChildE = {ChildE},ChildF = {ChildF},Infant = {Infant},InFemaleAdult = {InFemaleAdult},InFemaleChildA = {InFemaleChildA},InFemaleChildB = {InFemaleChildB},InFemaleChildC = {InFemaleChildC},InFemaleChildD = {InFemaleChildD},InFemaleChildE = {InFemaleChildE},InFemaleChildF = {InFemaleChildF},InFemaleInfant = {InFemaleInfant} WHERE ID = {ID} AND DetailID = {DetailID} AND UseDate = {(UseDate == null ? "NULL" : UseDate.ToSqlValue())};";
+ }
+
+ public string ToText()
+ {
+ StringBuilder text = new StringBuilder();
+ text.AppendFormat("ID={0};", ID);
+ text.AppendFormat("DetailID={0};", DetailID);
+ text.AppendFormat("UseDate={0};", UseDate);
+ text.AppendFormat("BeginTime={0};", BeginTime);
+ text.AppendFormat("EndTime={0};", EndTime);
+ text.AppendFormat("RoomTypeID={0};", RoomTypeID);
+ text.AppendFormat("RoomKind={0};", RoomKind);
+ text.AppendFormat("RoomID={0};", RoomID);
+ text.AppendFormat("AgentID={0};", AgentID);
+ text.AppendFormat("AgentBranchID={0};", AgentBranchID);
+ text.AppendFormat("PersionCount={0};", PersionCount);
+ text.AppendFormat("Adult={0};", Adult);
+ text.AppendFormat("ChildA={0};", ChildA);
+ text.AppendFormat("ChildB={0};", ChildB);
+ text.AppendFormat("ChildC={0};", ChildC);
+ text.AppendFormat("ChildD={0};", ChildD);
+ text.AppendFormat("ChildE={0};", ChildE);
+ text.AppendFormat("ChildF={0};", ChildF);
+ text.AppendFormat("Infant={0};", Infant);
+ text.AppendFormat("InFemaleAdult={0};", InFemaleAdult);
+ text.AppendFormat("InFemaleChildA={0};", InFemaleChildA);
+ text.AppendFormat("InFemaleChildB={0};", InFemaleChildB);
+ text.AppendFormat("InFemaleChildC={0};", InFemaleChildC);
+ text.AppendFormat("InFemaleChildD={0};", InFemaleChildD);
+ text.AppendFormat("InFemaleChildE={0};", InFemaleChildE);
+ text.AppendFormat("InFemaleChildF={0};", InFemaleChildF);
+ text.AppendFormat("InFemaleInfant={0};", InFemaleInfant);
+
+ return text.ToString();
+ }
+
+ public override object GetField(string name)
+ {
+
+ if (name == "ID") { return ID; }
+ else if (name == "DetailID") { return DetailID; }
+ else if (name == "UseDate") { return UseDate; }
+ else if (name == "BeginTime") { return BeginTime; }
+ else if (name == "EndTime") { return EndTime; }
+ else if (name == "RoomTypeID") { return RoomTypeID; }
+ else if (name == "RoomKind") { return RoomKind; }
+ else if (name == "RoomID") { return RoomID; }
+ else if (name == "AgentID") { return AgentID; }
+ else if (name == "AgentBranchID") { return AgentBranchID; }
+ else if (name == "PersionCount") { return PersionCount; }
+ else if (name == "Adult") { return Adult; }
+ else if (name == "ChildA") { return ChildA; }
+ else if (name == "ChildB") { return ChildB; }
+ else if (name == "ChildC") { return ChildC; }
+ else if (name == "ChildD") { return ChildD; }
+ else if (name == "ChildE") { return ChildE; }
+ else if (name == "ChildF") { return ChildF; }
+ else if (name == "Infant") { return Infant; }
+ else if (name == "InFemaleAdult") { return InFemaleAdult; }
+ else if (name == "InFemaleChildA") { return InFemaleChildA; }
+ else if (name == "InFemaleChildB") { return InFemaleChildB; }
+ else if (name == "InFemaleChildC") { return InFemaleChildC; }
+ else if (name == "InFemaleChildD") { return InFemaleChildD; }
+ else if (name == "InFemaleChildE") { return InFemaleChildE; }
+ else if (name == "InFemaleChildF") { return InFemaleChildF; }
+ else if (name == "InFemaleInfant") { return InFemaleInfant; }
+ else { return null; }
+ }
+
+ public override bool SetField(string name, object value)
+ {
+
+ if (name == "ID") { ID = CConvert.ToInt(value); return true; }
+ else if (name == "DetailID") { DetailID = CConvert.ToInt(value); return true; }
+ else if (name == "UseDate") { UseDate = new Date(CConvert.ToDateInt(value)); return true; }
+ else if (name == "BeginTime") { BeginTime = CConvert.ToInt(value); return true; }
+ else if (name == "EndTime") { EndTime = CConvert.ToInt(value); return true; }
+ else if (name == "RoomTypeID") { RoomTypeID = CConvert.ToInt(value); return true; }
+ else if (name == "RoomKind") { RoomKind = CConvert.ToInt(value); return true; }
+ else if (name == "RoomID") { RoomID = CConvert.ToInt(value); return true; }
+ else if (name == "AgentID") { AgentID = CConvert.ToInt(value); return true; }
+ else if (name == "AgentBranchID") { AgentBranchID = CConvert.ToInt(value); return true; }
+ else if (name == "PersionCount") { PersionCount = CConvert.ToInt(value); return true; }
+ else if (name == "Adult") { Adult = CConvert.ToInt(value); return true; }
+ else if (name == "ChildA") { ChildA = CConvert.ToInt(value); return true; }
+ else if (name == "ChildB") { ChildB = CConvert.ToInt(value); return true; }
+ else if (name == "ChildC") { ChildC = CConvert.ToInt(value); return true; }
+ else if (name == "ChildD") { ChildD = CConvert.ToInt(value); return true; }
+ else if (name == "ChildE") { ChildE = CConvert.ToInt(value); return true; }
+ else if (name == "ChildF") { ChildF = CConvert.ToInt(value); return true; }
+ else if (name == "Infant") { Infant = CConvert.ToInt(value); return true; }
+ else if (name == "InFemaleAdult") { InFemaleAdult = CConvert.ToInt(value); return true; }
+ else if (name == "InFemaleChildA") { InFemaleChildA = CConvert.ToInt(value); return true; }
+ else if (name == "InFemaleChildB") { InFemaleChildB = CConvert.ToInt(value); return true; }
+ else if (name == "InFemaleChildC") { InFemaleChildC = CConvert.ToInt(value); return true; }
+ else if (name == "InFemaleChildD") { InFemaleChildD = CConvert.ToInt(value); return true; }
+ else if (name == "InFemaleChildE") { InFemaleChildE = CConvert.ToInt(value); return true; }
+ else if (name == "InFemaleChildF") { InFemaleChildF = CConvert.ToInt(value); return true; }
+ else if (name == "InFemaleInfant") { InFemaleInfant = CConvert.ToInt(value); return true; }
+ else { return false; }
+ }
+
+ #endregion
+}
\ No newline at end of file
--
Gitblit v1.10.0