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
}