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