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/Use.cs | 336 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 336 insertions(+), 0 deletions(-)
diff --git a/ProtosExpan/UseInfo/Use.cs b/ProtosExpan/UseInfo/Use.cs
new file mode 100644
index 0000000..4d63573
--- /dev/null
+++ b/ProtosExpan/UseInfo/Use.cs
@@ -0,0 +1,336 @@
+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 Use : 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(Use item)
+ {
+ if (ID.CompareTo(item.ID) != 0
+ || DetailID.CompareTo(item.DetailID) != 0
+ || ResvType.CompareTo(item.ResvType) != 0
+ || GroupType.CompareTo(item.GroupType) != 0
+ || GroupName.CompareTo(item.GroupName) != 0
+ || GroupKana.CompareTo(item.GroupKana) != 0
+ || ReceiptPrtWay.CompareTo(item.ReceiptPrtWay) != 0
+ || PayWay.CompareTo(item.PayWay) != 0
+ || CancelHotelDate.CompareTo(item.CancelHotelDate) != 0
+ || CancelDate.CompareTo(item.CancelDate) != 0
+ || CancelLoginID.CompareTo(item.CancelLoginID) != 0
+ || CancelName.CompareTo(item.CancelName) != 0
+ || CancelReason.CompareTo(item.CancelReason) != 0
+ || CreateDate.CompareTo(item.CreateDate) != 0
+ || CreateLoginID.CompareTo(item.CreateLoginID) != 0
+ || CreatePcName.CompareTo(item.CreatePcName) != 0
+ || CreateClass.CompareTo(item.CreateClass) != 0
+ || UpdateDate.CompareTo(item.UpdateDate) != 0
+ || UpdateLoginID.CompareTo(item.UpdateLoginID) != 0
+ || UpdatePcName.CompareTo(item.UpdatePcName) != 0
+ || UpdateClass.CompareTo(item.UpdateClass) != 0
+ || UpdateID.CompareTo(item.UpdateID) != 0
+)
+ {
+ return false;
+ }
+ return true;
+ }
+
+
+ public override void CopyTo(object dest)
+ {
+ Use item = dest as Use;
+ item.ID = ID;
+ item.DetailID = DetailID;
+ item.ResvType = ResvType;
+ item.GroupType = GroupType;
+ item.GroupName = GroupName;
+ item.GroupKana = GroupKana;
+ item.ReceiptPrtWay = ReceiptPrtWay;
+ item.PayWay = PayWay;
+ item.CancelHotelDate = CancelHotelDate;
+ item.CancelDate = CancelDate;
+ item.CancelLoginID = CancelLoginID;
+ item.CancelName = CancelName;
+ item.CancelReason = CancelReason;
+ item.CreateDate = CreateDate;
+ item.CreateLoginID = CreateLoginID;
+ item.CreatePcName = CreatePcName;
+ item.CreateClass = CreateClass;
+ item.UpdateDate = UpdateDate;
+ item.UpdateLoginID = UpdateLoginID;
+ item.UpdatePcName = UpdatePcName;
+ item.UpdateClass = UpdateClass;
+ item.UpdateID = UpdateID;
+
+ }
+
+ public override void Clear()
+ {
+ ID = 0;
+ DetailID = 0;
+ ResvType = 0;
+ GroupType = 0;
+ GroupName = string.Empty;
+ GroupKana = string.Empty;
+ ReceiptPrtWay = 0;
+ PayWay = 0;
+ CancelHotelDate = Date.Default;
+ CancelDate = CConvert.ToTimestamp(DateTime.MinValue);
+ CancelLoginID = 0;
+ CancelName = string.Empty;
+ CancelReason = string.Empty;
+ CreateDate = CConvert.ToTimestamp(DateTime.MinValue);
+ CreateLoginID = 0;
+ CreatePcName = string.Empty;
+ CreateClass = 0;
+ UpdateDate = CConvert.ToTimestamp(DateTime.MinValue);
+ UpdateLoginID = 0;
+ UpdatePcName = string.Empty;
+ UpdateClass = 0;
+ UpdateID = 0;
+
+ }
+
+ public Use DeepClone()
+ {
+ Use item = new Use();
+ item.ID = ID;
+ item.DetailID = DetailID;
+ item.ResvType = ResvType;
+ item.GroupType = GroupType;
+ item.GroupName = GroupName;
+ item.GroupKana = GroupKana;
+ item.ReceiptPrtWay = ReceiptPrtWay;
+ item.PayWay = PayWay;
+ item.CancelHotelDate = CancelHotelDate;
+ item.CancelDate = CancelDate;
+ item.CancelLoginID = CancelLoginID;
+ item.CancelName = CancelName;
+ item.CancelReason = CancelReason;
+ item.CreateDate = CreateDate;
+ item.CreateLoginID = CreateLoginID;
+ item.CreatePcName = CreatePcName;
+ item.CreateClass = CreateClass;
+ item.UpdateDate = UpdateDate;
+ item.UpdateLoginID = UpdateLoginID;
+ item.UpdatePcName = UpdatePcName;
+ item.UpdateClass = UpdateClass;
+ item.UpdateID = UpdateID;
+
+ return item;
+ }
+
+ public override bool ConvertDataRow(System.Data.DataRow row)
+ {
+ ID = CConvert.ToInt(row["ID"], ID);
+ DetailID = CConvert.ToInt(row["DetailID"], DetailID);
+ ResvType = CConvert.ToInt(row["ResvType"], ResvType);
+ GroupType = CConvert.ToInt(row["GroupType"], GroupType);
+ GroupName = row["GroupName"].ToString();
+ GroupKana = row["GroupKana"].ToString();
+ ReceiptPrtWay = CConvert.ToInt(row["ReceiptPrtWay"], ReceiptPrtWay);
+ PayWay = CConvert.ToInt(row["PayWay"], PayWay);
+ CancelHotelDate = new Date(row.IsNull("CancelHotelDate") ? 0 : CConvert.ToDateInt((System.DateTime)row["CancelHotelDate"]));
+ CancelDate = CConvert.ToTimestamp(row.IsNull("CancelDate") ? DateTime.MinValue : (System.DateTime)row["CancelDate"]);
+ CancelLoginID = CConvert.ToInt(row["CancelLoginID"], CancelLoginID);
+ CancelName = row["CancelName"].ToString();
+ CancelReason = row["CancelReason"].ToString();
+ CreateDate = CConvert.ToTimestamp(row.IsNull("CreateDate") ? DateTime.MinValue : (System.DateTime)row["CreateDate"]);
+ CreateLoginID = CConvert.ToInt(row["CreateLoginID"], CreateLoginID);
+ CreatePcName = row["CreatePcName"].ToString();
+ CreateClass = CConvert.ToInt(row["CreateClass"], CreateClass);
+ UpdateDate = CConvert.ToTimestamp(row.IsNull("UpdateDate") ? DateTime.MinValue : (System.DateTime)row["UpdateDate"]);
+ UpdateLoginID = CConvert.ToInt(row["UpdateLoginID"], UpdateLoginID);
+ UpdatePcName = row["UpdatePcName"].ToString();
+ UpdateClass = CConvert.ToInt(row["UpdateClass"], UpdateClass);
+ UpdateID = CConvert.ToInt(row["UpdateID"], UpdateID);
+
+ return true;
+ }
+
+ public void ToDataRow(System.Data.DataRow row)
+ {
+ row["ID"] = ID;
+ row["DetailID"] = DetailID;
+ row["ResvType"] = ResvType;
+ row["GroupType"] = GroupType;
+ row["GroupName"] = GroupName;
+ row["GroupKana"] = GroupKana;
+ row["ReceiptPrtWay"] = ReceiptPrtWay;
+ row["PayWay"] = PayWay;
+ row["CancelHotelDate"] = CancelHotelDate.ToDateTime();
+ row["CancelDate"] = CancelDate.ToDateTime();
+ row["CancelLoginID"] = CancelLoginID;
+ row["CancelName"] = CancelName;
+ row["CancelReason"] = CancelReason;
+ row["CreateDate"] = CreateDate.ToDateTime();
+ row["CreateLoginID"] = CreateLoginID;
+ row["CreatePcName"] = CreatePcName;
+ row["CreateClass"] = CreateClass;
+ row["UpdateDate"] = UpdateDate.ToDateTime();
+ row["UpdateLoginID"] = UpdateLoginID;
+ row["UpdatePcName"] = UpdatePcName;
+ row["UpdateClass"] = UpdateClass;
+ row["UpdateID"] = UpdateID;
+
+ }
+
+ 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++;
+ ResvType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++;
+ GroupType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++;
+ GroupName = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ GroupKana = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ ReceiptPrtWay = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++;
+ PayWay = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++;
+ CancelHotelDate = new Date(row.IsDBNull(i) ? 0 : CConvert.ToDateInt(row.GetDateTime(i))); i++;
+ CancelDate = CConvert.ToTimestamp(row.IsDBNull(i) ? DateTime.MinValue : row.GetDateTime(i)); i++;
+ CancelLoginID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ CancelName = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ CancelReason = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ CreateDate = CConvert.ToTimestamp(row.IsDBNull(i) ? DateTime.MinValue : row.GetDateTime(i)); i++;
+ CreateLoginID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ CreatePcName = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ CreateClass = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(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++;
+ UpdateClass = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ UpdateID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ }
+
+ public string AddSql()
+ {
+ return $@"INSERT INTO D_Use(ID,DetailID,ResvType,GroupType,GroupName,GroupKana,ReceiptPrtWay,PayWay,CancelHotelDate,CancelDate,CancelLoginID,CancelName,CancelReason,CreateDate,CreateLoginID,CreatePcName,CreateClass,UpdateDate,UpdateLoginID,UpdatePcName,UpdateClass,UpdateID) VALUES({ID},{DetailID},{ResvType},{GroupType},N'{GroupName}',N'{GroupKana}',{ReceiptPrtWay},{PayWay},{(CancelHotelDate == null ? "NULL" : CancelHotelDate.ToSqlValue())},{(CancelDate == null ? "NULL" : CConvert.ToSqlValue(CancelDate.ToDateTime()))},{CancelLoginID},N'{CancelName}',N'{CancelReason}',{(CreateDate == null ? "NULL" : CConvert.ToSqlValue(CreateDate.ToDateTime()))},{CreateLoginID},N'{CreatePcName}',{CreateClass},GETDATE(),{UpdateLoginID},N'{UpdatePcName}',{UpdateClass},{UpdateID});";
+ }
+
+ public string UpdateSql()
+ {
+ return $@"UPDATE D_Use SET DetailID = {DetailID},ResvType = {ResvType},GroupType = {GroupType},GroupName = N'{GroupName}',GroupKana = N'{GroupKana}',ReceiptPrtWay = {ReceiptPrtWay},PayWay = {PayWay},CancelHotelDate = {(CancelHotelDate == null ? "NULL" : CancelHotelDate.ToSqlValue())},CancelDate = {(CancelDate == null ? "NULL" : CConvert.ToSqlValue(CancelDate.ToDateTime()))},CancelLoginID = {CancelLoginID},CancelName = N'{CancelName}',CancelReason = N'{CancelReason}',CreateDate = {(CreateDate == null ? "NULL" : CConvert.ToSqlValue(CreateDate.ToDateTime()))},CreateLoginID = {CreateLoginID},CreatePcName = N'{CreatePcName}',CreateClass = {CreateClass},UpdateDate = GETDATE(),UpdateLoginID = {UpdateLoginID},UpdatePcName = N'{UpdatePcName}',UpdateClass = {UpdateClass},UpdateID = {UpdateID} WHERE ID = {ID};";
+ }
+
+ public string ToText()
+ {
+ StringBuilder text = new StringBuilder();
+ text.AppendFormat("ID={0};", ID);
+ text.AppendFormat("DetailID={0};", DetailID);
+ text.AppendFormat("ResvType={0};", ResvType);
+ text.AppendFormat("GroupType={0};", GroupType);
+ text.AppendFormat("GroupName={0};", GroupName);
+ text.AppendFormat("GroupKana={0};", GroupKana);
+ text.AppendFormat("ReceiptPrtWay={0};", ReceiptPrtWay);
+ text.AppendFormat("PayWay={0};", PayWay);
+ text.AppendFormat("CancelHotelDate={0};", CancelHotelDate);
+ text.AppendFormat("CancelDate={0};", CancelDate);
+ text.AppendFormat("CancelLoginID={0};", CancelLoginID);
+ text.AppendFormat("CancelName={0};", CancelName);
+ text.AppendFormat("CancelReason={0};", CancelReason);
+ text.AppendFormat("CreateDate={0};", CreateDate);
+ text.AppendFormat("CreateLoginID={0};", CreateLoginID);
+ text.AppendFormat("CreatePcName={0};", CreatePcName);
+ text.AppendFormat("CreateClass={0};", CreateClass);
+ text.AppendFormat("UpdateDate={0};", UpdateDate);
+ text.AppendFormat("UpdateLoginID={0};", UpdateLoginID);
+ text.AppendFormat("UpdatePcName={0};", UpdatePcName);
+ text.AppendFormat("UpdateClass={0};", UpdateClass);
+ text.AppendFormat("UpdateID={0};", UpdateID);
+
+ return text.ToString();
+ }
+
+ public override object GetField(string name)
+ {
+
+ if (name == "ID") { return ID; }
+ else if (name == "DetailID") { return DetailID; }
+ else if (name == "ResvType") { return ResvType; }
+ else if (name == "GroupType") { return GroupType; }
+ else if (name == "GroupName") { return GroupName; }
+ else if (name == "GroupKana") { return GroupKana; }
+ else if (name == "ReceiptPrtWay") { return ReceiptPrtWay; }
+ else if (name == "PayWay") { return PayWay; }
+ else if (name == "CancelHotelDate") { return CancelHotelDate; }
+ else if (name == "CancelDate") { return CancelDate; }
+ else if (name == "CancelLoginID") { return CancelLoginID; }
+ else if (name == "CancelName") { return CancelName; }
+ else if (name == "CancelReason") { return CancelReason; }
+ else if (name == "CreateDate") { return CreateDate; }
+ else if (name == "CreateLoginID") { return CreateLoginID; }
+ else if (name == "CreatePcName") { return CreatePcName; }
+ else if (name == "CreateClass") { return CreateClass; }
+ else if (name == "UpdateDate") { return UpdateDate; }
+ else if (name == "UpdateLoginID") { return UpdateLoginID; }
+ else if (name == "UpdatePcName") { return UpdatePcName; }
+ else if (name == "UpdateClass") { return UpdateClass; }
+ 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 == "DetailID") { DetailID = CConvert.ToInt(value); return true; }
+ else if (name == "ResvType") { ResvType = CConvert.ToInt(value); return true; }
+ else if (name == "GroupType") { GroupType = CConvert.ToInt(value); return true; }
+ else if (name == "GroupName") { GroupName = value.ToString(); return true; }
+ else if (name == "GroupKana") { GroupKana = value.ToString(); return true; }
+ else if (name == "ReceiptPrtWay") { ReceiptPrtWay = CConvert.ToInt(value); return true; }
+ else if (name == "PayWay") { PayWay = CConvert.ToInt(value); return true; }
+ else if (name == "CancelHotelDate") { CancelHotelDate = new Date(CConvert.ToDateInt(value)); return true; }
+ else if (name == "CancelDate") { CancelDate = CConvert.ToTimestamp(CConvert.ToDateTime(value)); return true; }
+ else if (name == "CancelLoginID") { CancelLoginID = CConvert.ToInt(value); return true; }
+ else if (name == "CancelName") { CancelName = value.ToString(); return true; }
+ else if (name == "CancelReason") { CancelReason = value.ToString(); return true; }
+ else if (name == "CreateDate") { CreateDate = CConvert.ToTimestamp(CConvert.ToDateTime(value)); return true; }
+ else if (name == "CreateLoginID") { CreateLoginID = CConvert.ToInt(value); return true; }
+ else if (name == "CreatePcName") { CreatePcName = value.ToString(); return true; }
+ else if (name == "CreateClass") { CreateClass = CConvert.ToInt(value); 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 == "UpdateClass") { UpdateClass = CConvert.ToInt(value); 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