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
|
}
|
