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
}