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/UsePerson.cs | 428 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 428 insertions(+), 0 deletions(-)
diff --git a/ProtosExpan/UseInfo/UsePerson.cs b/ProtosExpan/UseInfo/UsePerson.cs
new file mode 100644
index 0000000..fc3c59b
--- /dev/null
+++ b/ProtosExpan/UseInfo/UsePerson.cs
@@ -0,0 +1,428 @@
+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 UsePerson : 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("PersonID", 0);
+
+ }
+ }
+
+ #region ★★★★★ Function ★★★★★
+
+ public bool CompareTo(UsePerson item)
+ {
+ if (ID.CompareTo(item.ID) != 0
+ || PersonID.CompareTo(item.PersonID) != 0
+ || CustomerID.CompareTo(item.CustomerID) != 0
+ || MemberNo.CompareTo(item.MemberNo) != 0
+ || Kana.CompareTo(item.Kana) != 0
+ || Name.CompareTo(item.Name) != 0
+ || ReceiptName.CompareTo(item.ReceiptName) != 0
+ || ZipCode.CompareTo(item.ZipCode) != 0
+ || Prefecture.CompareTo(item.Prefecture) != 0
+ || Address2.CompareTo(item.Address2) != 0
+ || Address3.CompareTo(item.Address3) != 0
+ || Address4.CompareTo(item.Address4) != 0
+ || Mail.CompareTo(item.Mail) != 0
+ || PassportNo.CompareTo(item.PassportNo) != 0
+ || Sex.CompareTo(item.Sex) != 0
+ || BirthDay.CompareTo(item.BirthDay) != 0
+ || Anniversary.CompareTo(item.Anniversary) != 0
+ || CharacterType.CompareTo(item.CharacterType) != 0
+ || RankID.CompareTo(item.RankID) != 0
+ || CorpID.CompareTo(item.CorpID) != 0
+ || CorpKana.CompareTo(item.CorpKana) != 0
+ || CorpName.CompareTo(item.CorpName) != 0
+ || CorpZipCode.CompareTo(item.CorpZipCode) != 0
+ || CorpPrefecture.CompareTo(item.CorpPrefecture) != 0
+ || CorpAddress2.CompareTo(item.CorpAddress2) != 0
+ || CorpAddress3.CompareTo(item.CorpAddress3) != 0
+ || CorpAddress4.CompareTo(item.CorpAddress4) != 0
+ || CorpMail.CompareTo(item.CorpMail) != 0
+ || HonorificTitleID.CompareTo(item.HonorificTitleID) != 0
+ || Memo.CompareTo(item.Memo) != 0
+ || AreaID.CompareTo(item.AreaID) != 0
+)
+ {
+ return false;
+ }
+ return true;
+ }
+
+
+ public override void CopyTo(object dest)
+ {
+ UsePerson item = dest as UsePerson;
+ item.ID = ID;
+ item.PersonID = PersonID;
+ item.CustomerID = CustomerID;
+ item.MemberNo = MemberNo;
+ item.Kana = Kana;
+ item.Name = Name;
+ item.ReceiptName = ReceiptName;
+ item.ZipCode = ZipCode;
+ item.Prefecture = Prefecture;
+ item.Address2 = Address2;
+ item.Address3 = Address3;
+ item.Address4 = Address4;
+ item.Mail = Mail;
+ item.PassportNo = PassportNo;
+ item.Sex = Sex;
+ item.BirthDay = BirthDay;
+ item.Anniversary = Anniversary;
+ item.CharacterType = CharacterType;
+ item.RankID = RankID;
+ item.CorpID = CorpID;
+ item.CorpKana = CorpKana;
+ item.CorpName = CorpName;
+ item.CorpZipCode = CorpZipCode;
+ item.CorpPrefecture = CorpPrefecture;
+ item.CorpAddress2 = CorpAddress2;
+ item.CorpAddress3 = CorpAddress3;
+ item.CorpAddress4 = CorpAddress4;
+ item.CorpMail = CorpMail;
+ item.HonorificTitleID = HonorificTitleID;
+ item.Memo = Memo;
+ item.AreaID = AreaID;
+
+ }
+
+ public override void Clear()
+ {
+ ID = 0;
+ PersonID = 0;
+ CustomerID = 0;
+ MemberNo = string.Empty;
+ Kana = string.Empty;
+ Name = string.Empty;
+ ReceiptName = string.Empty;
+ ZipCode = string.Empty;
+ Prefecture = string.Empty;
+ Address2 = string.Empty;
+ Address3 = string.Empty;
+ Address4 = string.Empty;
+ Mail = string.Empty;
+ PassportNo = string.Empty;
+ Sex = 0;
+ BirthDay = Date.Default;
+ Anniversary = Date.Default;
+ CharacterType = 0;
+ RankID = 0;
+ CorpID = 0;
+ CorpKana = string.Empty;
+ CorpName = string.Empty;
+ CorpZipCode = string.Empty;
+ CorpPrefecture = string.Empty;
+ CorpAddress2 = string.Empty;
+ CorpAddress3 = string.Empty;
+ CorpAddress4 = string.Empty;
+ CorpMail = string.Empty;
+ HonorificTitleID = 0;
+ Memo = string.Empty;
+ AreaID = 0;
+
+ }
+
+ public UsePerson DeepClone()
+ {
+ UsePerson item = new UsePerson();
+ item.ID = ID;
+ item.PersonID = PersonID;
+ item.CustomerID = CustomerID;
+ item.MemberNo = MemberNo;
+ item.Kana = Kana;
+ item.Name = Name;
+ item.ReceiptName = ReceiptName;
+ item.ZipCode = ZipCode;
+ item.Prefecture = Prefecture;
+ item.Address2 = Address2;
+ item.Address3 = Address3;
+ item.Address4 = Address4;
+ item.Mail = Mail;
+ item.PassportNo = PassportNo;
+ item.Sex = Sex;
+ item.BirthDay = BirthDay;
+ item.Anniversary = Anniversary;
+ item.CharacterType = CharacterType;
+ item.RankID = RankID;
+ item.CorpID = CorpID;
+ item.CorpKana = CorpKana;
+ item.CorpName = CorpName;
+ item.CorpZipCode = CorpZipCode;
+ item.CorpPrefecture = CorpPrefecture;
+ item.CorpAddress2 = CorpAddress2;
+ item.CorpAddress3 = CorpAddress3;
+ item.CorpAddress4 = CorpAddress4;
+ item.CorpMail = CorpMail;
+ item.HonorificTitleID = HonorificTitleID;
+ item.Memo = Memo;
+ item.AreaID = AreaID;
+
+ return item;
+ }
+
+ public override bool ConvertDataRow(System.Data.DataRow row)
+ {
+ ID = CConvert.ToInt(row["ID"],ID);
+ PersonID = CConvert.ToInt(row["PersonID"],PersonID);
+ CustomerID = CConvert.ToInt(row["CustomerID"],CustomerID);
+ MemberNo = row["MemberNo"].ToString();
+ Kana = row["Kana"].ToString();
+ Name = row["Name"].ToString();
+ ReceiptName = row["ReceiptName"].ToString();
+ ZipCode = row["ZipCode"].ToString();
+ Prefecture = row["Prefecture"].ToString();
+ Address2 = row["Address2"].ToString();
+ Address3 = row["Address3"].ToString();
+ Address4 = row["Address4"].ToString();
+ Mail = row["Mail"].ToString();
+ PassportNo = row["PassportNo"].ToString();
+ Sex = CConvert.ToInt(row["Sex"],Sex);
+ BirthDay = new Date(row.IsNull("BirthDay") ? 0 : CConvert.ToDateInt((System.DateTime)row["BirthDay"]));
+ Anniversary = new Date(row.IsNull("Anniversary") ? 0 : CConvert.ToDateInt((System.DateTime)row["Anniversary"]));
+ CharacterType = CConvert.ToInt(row["CharacterType"],CharacterType);
+ RankID = CConvert.ToInt(row["RankID"],RankID);
+ CorpID = CConvert.ToInt(row["CorpID"],CorpID);
+ CorpKana = row["CorpKana"].ToString();
+ CorpName = row["CorpName"].ToString();
+ CorpZipCode = row["CorpZipCode"].ToString();
+ CorpPrefecture = row["CorpPrefecture"].ToString();
+ CorpAddress2 = row["CorpAddress2"].ToString();
+ CorpAddress3 = row["CorpAddress3"].ToString();
+ CorpAddress4 = row["CorpAddress4"].ToString();
+ CorpMail = row["CorpMail"].ToString();
+ HonorificTitleID = CConvert.ToInt(row["HonorificTitleID"],HonorificTitleID);
+ Memo = row["Memo"].ToString();
+ AreaID = CConvert.ToInt(row["AreaID"],AreaID);
+
+ return true;
+ }
+
+ public void ToDataRow(System.Data.DataRow row)
+ {
+ row["ID"] = ID;
+ row["PersonID"] = PersonID;
+ row["CustomerID"] = CustomerID;
+ row["MemberNo"] = MemberNo;
+ row["Kana"] = Kana;
+ row["Name"] = Name;
+ row["ReceiptName"] = ReceiptName;
+ row["ZipCode"] = ZipCode;
+ row["Prefecture"] = Prefecture;
+ row["Address2"] = Address2;
+ row["Address3"] = Address3;
+ row["Address4"] = Address4;
+ row["Mail"] = Mail;
+ row["PassportNo"] = PassportNo;
+ row["Sex"] = Sex;
+ row["BirthDay"] = BirthDay.ToDateTime();
+ row["Anniversary"] = Anniversary.ToDateTime();
+ row["CharacterType"] = CharacterType;
+ row["RankID"] = RankID;
+ row["CorpID"] = CorpID;
+ row["CorpKana"] = CorpKana;
+ row["CorpName"] = CorpName;
+ row["CorpZipCode"] = CorpZipCode;
+ row["CorpPrefecture"] = CorpPrefecture;
+ row["CorpAddress2"] = CorpAddress2;
+ row["CorpAddress3"] = CorpAddress3;
+ row["CorpAddress4"] = CorpAddress4;
+ row["CorpMail"] = CorpMail;
+ row["HonorificTitleID"] = HonorificTitleID;
+ row["Memo"] = Memo;
+ row["AreaID"] = AreaID;
+
+ }
+
+ public void ConvertReader(DbDataReader row)
+ {
+ int i = 0;
+ ID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ PersonID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ CustomerID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ MemberNo = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ Kana = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ Name = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ ReceiptName = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ ZipCode = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ Prefecture = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ Address2 = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ Address3 = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ Address4 = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ Mail = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ PassportNo = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ Sex = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++;
+ BirthDay = new Date(row.IsDBNull(i) ? 0 : CConvert.ToDateInt(row.GetDateTime(i))); i++;
+ Anniversary = new Date(row.IsDBNull(i) ? 0 : CConvert.ToDateInt(row.GetDateTime(i))); i++;
+ CharacterType = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ RankID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ CorpID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+ CorpKana = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ CorpName = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ CorpZipCode = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ CorpPrefecture = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ CorpAddress2 = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ CorpAddress3 = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ CorpAddress4 = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ CorpMail = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ HonorificTitleID = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++;
+ Memo = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++;
+ AreaID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
+
+ }
+
+ public string AddSql()
+ {
+ return $@"INSERT INTO D_UsePerson(ID,PersonID,CustomerID,MemberNo,Kana,Name,ReceiptName,ZipCode,Prefecture,Address2,Address3,Address4,Mail,PassportNo,Sex,BirthDay,Anniversary,CharacterType,RankID,CorpID,CorpKana,CorpName,CorpZipCode,CorpPrefecture,CorpAddress2,CorpAddress3,CorpAddress4,CorpMail,HonorificTitleID,Memo,AreaID) VALUES({ID},{PersonID},{CustomerID},N'{MemberNo}',N'{Kana}',N'{Name}',N'{ReceiptName}',N'{ZipCode}',N'{Prefecture}',N'{Address2}',N'{Address3}',N'{Address4}',N'{Mail}',N'{PassportNo}',{Sex},{(BirthDay == null ? "NULL" : BirthDay.ToSqlValue())},{(Anniversary == null ? "NULL" : Anniversary.ToSqlValue())},{CharacterType},{RankID},{CorpID},N'{CorpKana}',N'{CorpName}',N'{CorpZipCode}',N'{CorpPrefecture}',N'{CorpAddress2}',N'{CorpAddress3}',N'{CorpAddress4}',N'{CorpMail}',{HonorificTitleID},N'{Memo}',{AreaID});";
+ }
+
+ public string UpdateSql()
+ {
+ return $@"UPDATE D_UsePerson SET CustomerID = {CustomerID},MemberNo = N'{MemberNo}',Kana = N'{Kana}',Name = N'{Name}',ReceiptName = N'{ReceiptName}',ZipCode = N'{ZipCode}',Prefecture = N'{Prefecture}',Address2 = N'{Address2}',Address3 = N'{Address3}',Address4 = N'{Address4}',Mail = N'{Mail}',PassportNo = N'{PassportNo}',Sex = {Sex},BirthDay = {(BirthDay == null ? "NULL" : BirthDay.ToSqlValue())},Anniversary = {(Anniversary == null ? "NULL" : Anniversary.ToSqlValue())},CharacterType = {CharacterType},RankID = {RankID},CorpID = {CorpID},CorpKana = N'{CorpKana}',CorpName = N'{CorpName}',CorpZipCode = N'{CorpZipCode}',CorpPrefecture = N'{CorpPrefecture}',CorpAddress2 = N'{CorpAddress2}',CorpAddress3 = N'{CorpAddress3}',CorpAddress4 = N'{CorpAddress4}',CorpMail = N'{CorpMail}',HonorificTitleID = {HonorificTitleID},Memo = N'{Memo}',AreaID = {AreaID} WHERE ID = {ID} AND PersonID = {PersonID};";
+ }
+
+ public string ToText()
+ {
+ StringBuilder text = new StringBuilder();
+ text.AppendFormat("ID={0};", ID);
+ text.AppendFormat("PersonID={0};", PersonID);
+ text.AppendFormat("CustomerID={0};", CustomerID);
+ text.AppendFormat("MemberNo={0};", MemberNo);
+ text.AppendFormat("Kana={0};", Kana);
+ text.AppendFormat("Name={0};", Name);
+ text.AppendFormat("ReceiptName={0};", ReceiptName);
+ text.AppendFormat("ZipCode={0};", ZipCode);
+ text.AppendFormat("Prefecture={0};", Prefecture);
+ text.AppendFormat("Address2={0};", Address2);
+ text.AppendFormat("Address3={0};", Address3);
+ text.AppendFormat("Address4={0};", Address4);
+ text.AppendFormat("Mail={0};", Mail);
+ text.AppendFormat("PassportNo={0};", PassportNo);
+ text.AppendFormat("Sex={0};", Sex);
+ text.AppendFormat("BirthDay={0};", BirthDay);
+ text.AppendFormat("Anniversary={0};", Anniversary);
+ text.AppendFormat("CharacterType={0};", CharacterType);
+ text.AppendFormat("RankID={0};", RankID);
+ text.AppendFormat("CorpID={0};", CorpID);
+ text.AppendFormat("CorpKana={0};", CorpKana);
+ text.AppendFormat("CorpName={0};", CorpName);
+ text.AppendFormat("CorpZipCode={0};", CorpZipCode);
+ text.AppendFormat("CorpPrefecture={0};", CorpPrefecture);
+ text.AppendFormat("CorpAddress2={0};", CorpAddress2);
+ text.AppendFormat("CorpAddress3={0};", CorpAddress3);
+ text.AppendFormat("CorpAddress4={0};", CorpAddress4);
+ text.AppendFormat("CorpMail={0};", CorpMail);
+ text.AppendFormat("HonorificTitleID={0};", HonorificTitleID);
+ text.AppendFormat("Memo={0};", Memo);
+ text.AppendFormat("AreaID={0};", AreaID);
+
+ return text.ToString();
+ }
+
+ public override object GetField(string name)
+ {
+
+ if (name == "ID") { return ID; }
+ else if (name == "PersonID") { return PersonID; }
+ else if (name == "CustomerID") { return CustomerID; }
+ else if (name == "MemberNo") { return MemberNo; }
+ else if (name == "Kana") { return Kana; }
+ else if (name == "Name") { return Name; }
+ else if (name == "ReceiptName") { return ReceiptName; }
+ else if (name == "ZipCode") { return ZipCode; }
+ else if (name == "Prefecture") { return Prefecture; }
+ else if (name == "Address2") { return Address2; }
+ else if (name == "Address3") { return Address3; }
+ else if (name == "Address4") { return Address4; }
+ else if (name == "Mail") { return Mail; }
+ else if (name == "PassportNo") { return PassportNo; }
+ else if (name == "Sex") { return Sex; }
+ else if (name == "BirthDay") { return BirthDay; }
+ else if (name == "Anniversary") { return Anniversary; }
+ else if (name == "CharacterType") { return CharacterType; }
+ else if (name == "RankID") { return RankID; }
+ else if (name == "CorpID") { return CorpID; }
+ else if (name == "CorpKana") { return CorpKana; }
+ else if (name == "CorpName") { return CorpName; }
+ else if (name == "CorpZipCode") { return CorpZipCode; }
+ else if (name == "CorpPrefecture") { return CorpPrefecture; }
+ else if (name == "CorpAddress2") { return CorpAddress2; }
+ else if (name == "CorpAddress3") { return CorpAddress3; }
+ else if (name == "CorpAddress4") { return CorpAddress4; }
+ else if (name == "CorpMail") { return CorpMail; }
+ else if (name == "HonorificTitleID") { return HonorificTitleID; }
+ else if (name == "Memo") { return Memo; }
+ else if (name == "AreaID") { return AreaID; }
+ else { return null; }
+ }
+
+ public override bool SetField(string name, object value)
+ {
+
+ if (name == "ID") { ID = CConvert.ToInt(value); return true; }
+ else if (name == "PersonID") { PersonID = CConvert.ToInt(value); return true; }
+ else if (name == "CustomerID") { CustomerID = CConvert.ToInt(value); return true; }
+ else if (name == "MemberNo") { MemberNo = value.ToString(); return true; }
+ else if (name == "Kana") { Kana = value.ToString(); return true; }
+ else if (name == "Name") { Name = value.ToString(); return true; }
+ else if (name == "ReceiptName") { ReceiptName = value.ToString(); return true; }
+ else if (name == "ZipCode") { ZipCode = value.ToString(); return true; }
+ else if (name == "Prefecture") { Prefecture = value.ToString(); return true; }
+ else if (name == "Address2") { Address2 = value.ToString(); return true; }
+ else if (name == "Address3") { Address3 = value.ToString(); return true; }
+ else if (name == "Address4") { Address4 = value.ToString(); return true; }
+ else if (name == "Mail") { Mail = value.ToString(); return true; }
+ else if (name == "PassportNo") { PassportNo = value.ToString(); return true; }
+ else if (name == "Sex") { Sex = CConvert.ToInt(value); return true; }
+ else if (name == "BirthDay") { BirthDay = new Date(CConvert.ToDateInt(value)); return true; }
+ else if (name == "Anniversary") { Anniversary = new Date(CConvert.ToDateInt(value)); return true; }
+ else if (name == "CharacterType") { CharacterType = CConvert.ToInt(value); return true; }
+ else if (name == "RankID") { RankID = CConvert.ToInt(value); return true; }
+ else if (name == "CorpID") { CorpID = CConvert.ToInt(value); return true; }
+ else if (name == "CorpKana") { CorpKana = value.ToString(); return true; }
+ else if (name == "CorpName") { CorpName = value.ToString(); return true; }
+ else if (name == "CorpZipCode") { CorpZipCode = value.ToString(); return true; }
+ else if (name == "CorpPrefecture") { CorpPrefecture = value.ToString(); return true; }
+ else if (name == "CorpAddress2") { CorpAddress2 = value.ToString(); return true; }
+ else if (name == "CorpAddress3") { CorpAddress3 = value.ToString(); return true; }
+ else if (name == "CorpAddress4") { CorpAddress4 = value.ToString(); return true; }
+ else if (name == "CorpMail") { CorpMail = value.ToString(); return true; }
+ else if (name == "HonorificTitleID") { HonorificTitleID = CConvert.ToInt(value); return true; }
+ else if (name == "Memo") { Memo = value.ToString(); return true; }
+ else if (name == "AreaID") { AreaID = CConvert.ToInt(value); return true; }
+ else { return false; }
+ }
+
+ #endregion
+}
\ No newline at end of file
--
Gitblit v1.10.0