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.Master; /// ****************************** Description ******************************* /// ◇システム名称 /// 　ホテルPMS /// ◇概要 /// 　 /// ◇履歴 /// 　2021/05/14 コード作成ツール 自動作成 /// ****************************** Declarations ****************************** [Serializable()] public partial class Item : RecordBase { #region ★★★★★　Property　★★★★★ public static ConcurrentDictionary PrimaryKey { get; } = new ConcurrentDictionary(); #endregion partial void OnConstruction() { if (PrimaryKey.Count == 0) { PrimaryKey.TryAdd("ID", 0); } } #region ★★★★★　Function　★★★★★ public bool CompareTo(Item item) { if (ID.CompareTo(item.ID) != 0 || Name.CompareTo(item.Name) != 0 || EnName.CompareTo(item.EnName) != 0 || Name2.CompareTo(item.Name2) != 0 || ReceiptName.CompareTo(item.ReceiptName) != 0 || RoomTypeID.CompareTo(item.RoomTypeID) != 0 || PersonCount.CompareTo(item.PersonCount) != 0 || Price.CompareTo(item.Price) != 0 || DiscountRate.CompareTo(item.DiscountRate) != 0 || DiscountSummary.CompareTo(item.DiscountSummary) != 0 || DiscountID.CompareTo(item.DiscountID) != 0 || ServiceIOType.CompareTo(item.ServiceIOType) != 0 || ServiceRate.CompareTo(item.ServiceRate) != 0 || TaxType.CompareTo(item.TaxType) != 0 || TaxIOType.CompareTo(item.TaxIOType) != 0 || BathTaxIOType.CompareTo(item.BathTaxIOType) != 0 || AccTaxIOType.CompareTo(item.AccTaxIOType) != 0 || SaleSectionID.CompareTo(item.SaleSectionID) != 0 || SumSectionID.CompareTo(item.SumSectionID) != 0 || Kind.CompareTo(item.Kind) != 0 || NextDay.CompareTo(item.NextDay) != 0 || AgentID.CompareTo(item.AgentID) != 0 || AgentBranchID.CompareTo(item.AgentBranchID) != 0 || PointFlg.CompareTo(item.PointFlg) != 0 || PointInTax.CompareTo(item.PointInTax) != 0 || PointRate.CompareTo(item.PointRate) != 0 || PointPrice.CompareTo(item.PointPrice) != 0 || PointSumType.CompareTo(item.PointSumType) != 0 || Point.CompareTo(item.Point) != 0 || DayUse.CompareTo(item.DayUse) != 0 || ReceiptPrtType.CompareTo(item.ReceiptPrtType) != 0 || LongStayFlg.CompareTo(item.LongStayFlg) != 0 || RentalType.CompareTo(item.RentalType) != 0 || TraderID.CompareTo(item.TraderID) != 0 || TraderMemo.CompareTo(item.TraderMemo) != 0 || PackFlg.CompareTo(item.PackFlg) != 0 || SortID.CompareTo(item.SortID) != 0 || Fraction.CompareTo(item.Fraction) != 0 || InRoomSales.CompareTo(item.InRoomSales) != 0 || MealType.CompareTo(item.MealType) != 0 || UseType.CompareTo(item.UseType) != 0 || PersonType.CompareTo(item.PersonType) != 0 || Parking.CompareTo(item.Parking) != 0 || HallFee.CompareTo(item.HallFee) != 0 || UpdateDate.CompareTo(item.UpdateDate) != 0 || UpdateLoginID.CompareTo(item.UpdateLoginID) != 0 || UpdatePcName.CompareTo(item.UpdatePcName) != 0 || UpdateID.CompareTo(item.UpdateID) != 0 ) { return false; } return true; } public override void CopyTo(object dest) { Item item = dest as Item; item.ID = ID; item.Name = Name; item.EnName = EnName; item.Name2 = Name2; item.ReceiptName = ReceiptName; item.RoomTypeID = RoomTypeID; item.PersonCount = PersonCount; item.Price = Price; item.DiscountRate = DiscountRate; item.DiscountSummary = DiscountSummary; item.DiscountID = DiscountID; item.ServiceIOType = ServiceIOType; item.ServiceRate = ServiceRate; item.TaxType = TaxType; item.TaxIOType = TaxIOType; item.BathTaxIOType = BathTaxIOType; item.AccTaxIOType = AccTaxIOType; item.SaleSectionID = SaleSectionID; item.SumSectionID = SumSectionID; item.Kind = Kind; item.NextDay = NextDay; item.AgentID = AgentID; item.AgentBranchID = AgentBranchID; item.PointFlg = PointFlg; item.PointInTax = PointInTax; item.PointRate = PointRate; item.PointPrice = PointPrice; item.PointSumType = PointSumType; item.Point = Point; item.DayUse = DayUse; item.ReceiptPrtType = ReceiptPrtType; item.LongStayFlg = LongStayFlg; item.RentalType = RentalType; item.TraderID = TraderID; item.TraderMemo = TraderMemo; item.PackFlg = PackFlg; item.SortID = SortID; item.Fraction = Fraction; item.InRoomSales = InRoomSales; item.MealType = MealType; item.UseType = UseType; item.PersonType = PersonType; item.Parking = Parking; item.HallFee = HallFee; item.UpdateDate = UpdateDate; item.UpdateLoginID = UpdateLoginID; item.UpdatePcName = UpdatePcName; item.UpdateID = UpdateID; } public override void Clear() { ID = string.Empty; Name = string.Empty; EnName = string.Empty; Name2 = string.Empty; ReceiptName = string.Empty; RoomTypeID = 0; PersonCount = 0; Price = 0; DiscountRate = 0; DiscountSummary = 0; DiscountID = 0; ServiceIOType = 0; ServiceRate = 0; TaxType = 0; TaxIOType = 0; BathTaxIOType = 0; AccTaxIOType = 0; SaleSectionID = 0; SumSectionID = 0; Kind = 0; NextDay = false; AgentID = 0; AgentBranchID = 0; PointFlg = false; PointInTax = false; PointRate = 0; PointPrice = 0; PointSumType = 0; Point = 0; DayUse = false; ReceiptPrtType = 0; LongStayFlg = false; RentalType = 0; TraderID = 0; TraderMemo = string.Empty; PackFlg = false; SortID = 0; Fraction = 0; InRoomSales = false; MealType = 0; UseType = 0; PersonType = 0; Parking = false; HallFee = false; UpdateDate = CConvert.ToTimestamp(DateTime.MinValue); UpdateLoginID = 0; UpdatePcName = string.Empty; UpdateID = 0; } public Item DeepClone() { Item item = new Item(); item.ID = ID; item.Name = Name; item.EnName = EnName; item.Name2 = Name2; item.ReceiptName = ReceiptName; item.RoomTypeID = RoomTypeID; item.PersonCount = PersonCount; item.Price = Price; item.DiscountRate = DiscountRate; item.DiscountSummary = DiscountSummary; item.DiscountID = DiscountID; item.ServiceIOType = ServiceIOType; item.ServiceRate = ServiceRate; item.TaxType = TaxType; item.TaxIOType = TaxIOType; item.BathTaxIOType = BathTaxIOType; item.AccTaxIOType = AccTaxIOType; item.SaleSectionID = SaleSectionID; item.SumSectionID = SumSectionID; item.Kind = Kind; item.NextDay = NextDay; item.AgentID = AgentID; item.AgentBranchID = AgentBranchID; item.PointFlg = PointFlg; item.PointInTax = PointInTax; item.PointRate = PointRate; item.PointPrice = PointPrice; item.PointSumType = PointSumType; item.Point = Point; item.DayUse = DayUse; item.ReceiptPrtType = ReceiptPrtType; item.LongStayFlg = LongStayFlg; item.RentalType = RentalType; item.TraderID = TraderID; item.TraderMemo = TraderMemo; item.PackFlg = PackFlg; item.SortID = SortID; item.Fraction = Fraction; item.InRoomSales = InRoomSales; item.MealType = MealType; item.UseType = UseType; item.PersonType = PersonType; item.Parking = Parking; item.HallFee = HallFee; item.UpdateDate = UpdateDate; item.UpdateLoginID = UpdateLoginID; item.UpdatePcName = UpdatePcName; item.UpdateID = UpdateID; return item; } public override bool ConvertDataRow(System.Data.DataRow row) { ID = row["ID"].ToString(); Name = row["Name"].ToString(); EnName = row["EnName"].ToString(); Name2 = row["Name2"].ToString(); ReceiptName = row["ReceiptName"].ToString(); RoomTypeID = CConvert.ToInt(row["RoomTypeID"],RoomTypeID); PersonCount = CConvert.ToInt(row["PersonCount"],PersonCount); Price = CConvert.ToDecimal(row["Price"]); DiscountRate = CConvert.ToDecimal(row["DiscountRate"]); DiscountSummary = CConvert.ToDecimal(row["DiscountSummary"]); DiscountID = CConvert.ToInt(row["DiscountID"],DiscountID); ServiceIOType = CConvert.ToInt(row["ServiceIOType"],ServiceIOType); ServiceRate = CConvert.ToDecimal(row["ServiceRate"]); TaxType = CConvert.ToInt(row["TaxType"],TaxType); TaxIOType = CConvert.ToInt(row["TaxIOType"],TaxIOType); BathTaxIOType = CConvert.ToInt(row["BathTaxIOType"],BathTaxIOType); AccTaxIOType = CConvert.ToInt(row["AccTaxIOType"],AccTaxIOType); SaleSectionID = CConvert.ToInt(row["SaleSectionID"],SaleSectionID); SumSectionID = CConvert.ToInt(row["SumSectionID"],SumSectionID); Kind = CConvert.ToInt(row["Kind"],Kind); NextDay = CConvert.ToBool(row["NextDay"]); AgentID = CConvert.ToInt(row["AgentID"],AgentID); AgentBranchID = CConvert.ToInt(row["AgentBranchID"],AgentBranchID); PointFlg = CConvert.ToBool(row["PointFlg"]); PointInTax = CConvert.ToBool(row["PointInTax"]); PointRate = CConvert.ToDecimal(row["PointRate"]); PointPrice = CConvert.ToInt(row["PointPrice"],PointPrice); PointSumType = CConvert.ToInt(row["PointSumType"],PointSumType); Point = CConvert.ToInt(row["Point"],Point); DayUse = CConvert.ToBool(row["DayUse"]); ReceiptPrtType = CConvert.ToInt(row["ReceiptPrtType"],ReceiptPrtType); LongStayFlg = CConvert.ToBool(row["LongStayFlg"]); RentalType = CConvert.ToInt(row["RentalType"],RentalType); TraderID = CConvert.ToInt(row["TraderID"],TraderID); TraderMemo = row["TraderMemo"].ToString(); PackFlg = CConvert.ToBool(row["PackFlg"]); SortID = CConvert.ToInt(row["SortID"],SortID); Fraction = CConvert.ToInt(row["Fraction"],Fraction); InRoomSales = CConvert.ToBool(row["InRoomSales"]); MealType = CConvert.ToInt(row["MealType"],MealType); UseType = CConvert.ToInt(row["UseType"],UseType); PersonType = CConvert.ToInt(row["PersonType"],PersonType); Parking = CConvert.ToBool(row["Parking"]); HallFee = CConvert.ToBool(row["HallFee"]); UpdateDate = CConvert.ToTimestamp(row.IsNull("UpdateDate") ? DateTime.MinValue : (System.DateTime)row["UpdateDate"]); UpdateLoginID = CConvert.ToInt(row["UpdateLoginID"],UpdateLoginID); UpdatePcName = row["UpdatePcName"].ToString(); UpdateID = CConvert.ToInt(row["UpdateID"],UpdateID); return true; } public void ToDataRow(System.Data.DataRow row) { row["ID"] = ID; row["Name"] = Name; row["EnName"] = EnName; row["Name2"] = Name2; row["ReceiptName"] = ReceiptName; row["RoomTypeID"] = RoomTypeID; row["PersonCount"] = PersonCount; row["Price"] = Price.ToDecimal(); row["DiscountRate"] = DiscountRate.ToDecimal(); row["DiscountSummary"] = DiscountSummary.ToDecimal(); row["DiscountID"] = DiscountID; row["ServiceIOType"] = ServiceIOType; row["ServiceRate"] = ServiceRate.ToDecimal(); row["TaxType"] = TaxType; row["TaxIOType"] = TaxIOType; row["BathTaxIOType"] = BathTaxIOType; row["AccTaxIOType"] = AccTaxIOType; row["SaleSectionID"] = SaleSectionID; row["SumSectionID"] = SumSectionID; row["Kind"] = Kind; row["NextDay"] = NextDay; row["AgentID"] = AgentID; row["AgentBranchID"] = AgentBranchID; row["PointFlg"] = PointFlg; row["PointInTax"] = PointInTax; row["PointRate"] = PointRate.ToDecimal(); row["PointPrice"] = PointPrice; row["PointSumType"] = PointSumType; row["Point"] = Point; row["DayUse"] = DayUse; row["ReceiptPrtType"] = ReceiptPrtType; row["LongStayFlg"] = LongStayFlg; row["RentalType"] = RentalType; row["TraderID"] = TraderID; row["TraderMemo"] = TraderMemo; row["PackFlg"] = PackFlg; row["SortID"] = SortID; row["Fraction"] = Fraction; row["InRoomSales"] = InRoomSales; row["MealType"] = MealType; row["UseType"] = UseType; row["PersonType"] = PersonType; row["Parking"] = Parking; row["HallFee"] = HallFee; row["UpdateDate"] = UpdateDate.ToDateTime(); row["UpdateLoginID"] = UpdateLoginID; row["UpdatePcName"] = UpdatePcName; row["UpdateID"] = UpdateID; } public void ConvertReader(DbDataReader row) { int i = 0; ID = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++; Name = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++; EnName = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++; Name2 = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++; ReceiptName = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++; RoomTypeID = (int)(row.IsDBNull(i) ? 0 : row.GetInt16(i)); i++; PersonCount = (int)(row.IsDBNull(i) ? 0 : row.GetInt16(i)); i++; Price = (decimal)(row.IsDBNull(i) ? 0M : row.GetDecimal(i)); i++; DiscountRate = (decimal)(row.IsDBNull(i) ? 0M : row.GetDecimal(i)); i++; DiscountSummary = (decimal)(row.IsDBNull(i) ? 0M : row.GetDecimal(i)); i++; DiscountID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++; ServiceIOType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; ServiceRate = (decimal)(row.IsDBNull(i) ? 0M : row.GetDecimal(i)); i++; TaxType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; TaxIOType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; BathTaxIOType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; AccTaxIOType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; SaleSectionID = (int)(row.IsDBNull(i) ? 0 : row.GetInt16(i)); i++; SumSectionID = (int)(row.IsDBNull(i) ? 0 : row.GetInt16(i)); i++; Kind = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; NextDay = (bool)(row.IsDBNull(i) ? false : row.GetBoolean(i)); i++; AgentID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++; AgentBranchID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++; PointFlg = (bool)(row.IsDBNull(i) ? false : row.GetBoolean(i)); i++; PointInTax = (bool)(row.IsDBNull(i) ? false : row.GetBoolean(i)); i++; PointRate = (decimal)(row.IsDBNull(i) ? 0M : row.GetDecimal(i)); i++; PointPrice = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++; PointSumType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; Point = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++; DayUse = (bool)(row.IsDBNull(i) ? false : row.GetBoolean(i)); i++; ReceiptPrtType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; LongStayFlg = (bool)(row.IsDBNull(i) ? false : row.GetBoolean(i)); i++; RentalType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; TraderID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++; TraderMemo = (row.IsDBNull(i) ? string.Empty : row.GetString(i)); i++; PackFlg = (bool)(row.IsDBNull(i) ? false : row.GetBoolean(i)); i++; SortID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++; Fraction = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; InRoomSales = (bool)(row.IsDBNull(i) ? false : row.GetBoolean(i)); i++; MealType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; UseType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; PersonType = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++; Parking = (bool)(row.IsDBNull(i) ? false : row.GetBoolean(i)); i++; HallFee = (bool)(row.IsDBNull(i) ? false : row.GetBoolean(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++; UpdateID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++; } public string AddSql() { return $@"INSERT INTO M_Item(ID,Name,EnName,Name2,ReceiptName,RoomTypeID,PersonCount,Price,DiscountRate,DiscountSummary,DiscountID,ServiceIOType,ServiceRate,TaxType,TaxIOType,BathTaxIOType,AccTaxIOType,SaleSectionID,SumSectionID,Kind,NextDay,AgentID,AgentBranchID,PointFlg,PointInTax,PointRate,PointPrice,PointSumType,Point,DayUse,ReceiptPrtType,LongStayFlg,RentalType,TraderID,TraderMemo,PackFlg,SortID,Fraction,InRoomSales,MealType,UseType,PersonType,Parking,HallFee,UpdateDate,UpdateLoginID,UpdatePcName,UpdateID) VALUES(N'{ID}',N'{Name}',N'{EnName}',N'{Name2}',N'{ReceiptName}',{RoomTypeID},{PersonCount},{(Price == null ? "0" : Price.ToSqlValue())},{(DiscountRate == null ? "0" : DiscountRate.ToSqlValue())},{(DiscountSummary == null ? "0" : DiscountSummary.ToSqlValue())},{DiscountID},{ServiceIOType},{(ServiceRate == null ? "0" : ServiceRate.ToSqlValue())},{TaxType},{TaxIOType},{BathTaxIOType},{AccTaxIOType},{SaleSectionID},{SumSectionID},{Kind},{(NextDay ? 1 : 0)},{AgentID},{AgentBranchID},{(PointFlg ? 1 : 0)},{(PointInTax ? 1 : 0)},{(PointRate == null ? "0" : PointRate.ToSqlValue())},{PointPrice},{PointSumType},{Point},{(DayUse ? 1 : 0)},{ReceiptPrtType},{(LongStayFlg ? 1 : 0)},{RentalType},{TraderID},N'{TraderMemo}',{(PackFlg ? 1 : 0)},{SortID},{Fraction},{(InRoomSales ? 1 : 0)},{MealType},{UseType},{PersonType},{(Parking ? 1 : 0)},{(HallFee ? 1 : 0)},GETDATE(),{UpdateLoginID},N'{UpdatePcName}',{UpdateID});"; } public string UpdateSql() { return $@"UPDATE M_Item SET Name = N'{Name}',EnName = N'{EnName}',Name2 = N'{Name2}',ReceiptName = N'{ReceiptName}',RoomTypeID = {RoomTypeID},PersonCount = {PersonCount},Price = {(Price == null ? "0" : Price.ToSqlValue())},DiscountRate = {(DiscountRate == null ? "0" : DiscountRate.ToSqlValue())},DiscountSummary = {(DiscountSummary == null ? "0" : DiscountSummary.ToSqlValue())},DiscountID = {DiscountID},ServiceIOType = {ServiceIOType},ServiceRate = {(ServiceRate == null ? "0" : ServiceRate.ToSqlValue())},TaxType = {TaxType},TaxIOType = {TaxIOType},BathTaxIOType = {BathTaxIOType},AccTaxIOType = {AccTaxIOType},SaleSectionID = {SaleSectionID},SumSectionID = {SumSectionID},Kind = {Kind},NextDay = {(NextDay ? 1 : 0)},AgentID = {AgentID},AgentBranchID = {AgentBranchID},PointFlg = {(PointFlg ? 1 : 0)},PointInTax = {(PointInTax ? 1 : 0)},PointRate = {(PointRate == null ? "0" : PointRate.ToSqlValue())},PointPrice = {PointPrice},PointSumType = {PointSumType},Point = {Point},DayUse = {(DayUse ? 1 : 0)},ReceiptPrtType = {ReceiptPrtType},LongStayFlg = {(LongStayFlg ? 1 : 0)},RentalType = {RentalType},TraderID = {TraderID},TraderMemo = N'{TraderMemo}',PackFlg = {(PackFlg ? 1 : 0)},SortID = {SortID},Fraction = {Fraction},InRoomSales = {(InRoomSales ? 1 : 0)},MealType = {MealType},UseType = {UseType},PersonType = {PersonType},Parking = {(Parking ? 1 : 0)},HallFee = {(HallFee ? 1 : 0)},UpdateDate = GETDATE(),UpdateLoginID = {UpdateLoginID},UpdatePcName = N'{UpdatePcName}',UpdateID = {UpdateID} WHERE ID = N'{ID}';"; } public string ToText() { StringBuilder text = new StringBuilder(); text.AppendFormat("ID={0};", ID); text.AppendFormat("Name={0};", Name); text.AppendFormat("EnName={0};", EnName); text.AppendFormat("Name2={0};", Name2); text.AppendFormat("ReceiptName={0};", ReceiptName); text.AppendFormat("RoomTypeID={0};", RoomTypeID); text.AppendFormat("PersonCount={0};", PersonCount); text.AppendFormat("Price={0};", Price); text.AppendFormat("DiscountRate={0};", DiscountRate); text.AppendFormat("DiscountSummary={0};", DiscountSummary); text.AppendFormat("DiscountID={0};", DiscountID); text.AppendFormat("ServiceIOType={0};", ServiceIOType); text.AppendFormat("ServiceRate={0};", ServiceRate); text.AppendFormat("TaxType={0};", TaxType); text.AppendFormat("TaxIOType={0};", TaxIOType); text.AppendFormat("BathTaxIOType={0};", BathTaxIOType); text.AppendFormat("AccTaxIOType={0};", AccTaxIOType); text.AppendFormat("SaleSectionID={0};", SaleSectionID); text.AppendFormat("SumSectionID={0};", SumSectionID); text.AppendFormat("Kind={0};", Kind); text.AppendFormat("NextDay={0};", NextDay); text.AppendFormat("AgentID={0};", AgentID); text.AppendFormat("AgentBranchID={0};", AgentBranchID); text.AppendFormat("PointFlg={0};", PointFlg); text.AppendFormat("PointInTax={0};", PointInTax); text.AppendFormat("PointRate={0};", PointRate); text.AppendFormat("PointPrice={0};", PointPrice); text.AppendFormat("PointSumType={0};", PointSumType); text.AppendFormat("Point={0};", Point); text.AppendFormat("DayUse={0};", DayUse); text.AppendFormat("ReceiptPrtType={0};", ReceiptPrtType); text.AppendFormat("LongStayFlg={0};", LongStayFlg); text.AppendFormat("RentalType={0};", RentalType); text.AppendFormat("TraderID={0};", TraderID); text.AppendFormat("TraderMemo={0};", TraderMemo); text.AppendFormat("PackFlg={0};", PackFlg); text.AppendFormat("SortID={0};", SortID); text.AppendFormat("Fraction={0};", Fraction); text.AppendFormat("InRoomSales={0};", InRoomSales); text.AppendFormat("MealType={0};", MealType); text.AppendFormat("UseType={0};", UseType); text.AppendFormat("PersonType={0};", PersonType); text.AppendFormat("Parking={0};", Parking); text.AppendFormat("HallFee={0};", HallFee); text.AppendFormat("UpdateDate={0};", UpdateDate); text.AppendFormat("UpdateLoginID={0};", UpdateLoginID); text.AppendFormat("UpdatePcName={0};", UpdatePcName); text.AppendFormat("UpdateID={0};", UpdateID); return text.ToString(); } public override object GetField(string name) { if (name == "ID") { return ID; } else if (name == "Name") { return Name; } else if (name == "EnName") { return EnName; } else if (name == "Name2") { return Name2; } else if (name == "ReceiptName") { return ReceiptName; } else if (name == "RoomTypeID") { return RoomTypeID; } else if (name == "PersonCount") { return PersonCount; } else if (name == "Price") { return Price; } else if (name == "DiscountRate") { return DiscountRate; } else if (name == "DiscountSummary") { return DiscountSummary; } else if (name == "DiscountID") { return DiscountID; } else if (name == "ServiceIOType") { return ServiceIOType; } else if (name == "ServiceRate") { return ServiceRate; } else if (name == "TaxType") { return TaxType; } else if (name == "TaxIOType") { return TaxIOType; } else if (name == "BathTaxIOType") { return BathTaxIOType; } else if (name == "AccTaxIOType") { return AccTaxIOType; } else if (name == "SaleSectionID") { return SaleSectionID; } else if (name == "SumSectionID") { return SumSectionID; } else if (name == "Kind") { return Kind; } else if (name == "NextDay") { return NextDay; } else if (name == "AgentID") { return AgentID; } else if (name == "AgentBranchID") { return AgentBranchID; } else if (name == "PointFlg") { return PointFlg; } else if (name == "PointInTax") { return PointInTax; } else if (name == "PointRate") { return PointRate; } else if (name == "PointPrice") { return PointPrice; } else if (name == "PointSumType") { return PointSumType; } else if (name == "Point") { return Point; } else if (name == "DayUse") { return DayUse; } else if (name == "ReceiptPrtType") { return ReceiptPrtType; } else if (name == "LongStayFlg") { return LongStayFlg; } else if (name == "RentalType") { return RentalType; } else if (name == "TraderID") { return TraderID; } else if (name == "TraderMemo") { return TraderMemo; } else if (name == "PackFlg") { return PackFlg; } else if (name == "SortID") { return SortID; } else if (name == "Fraction") { return Fraction; } else if (name == "InRoomSales") { return InRoomSales; } else if (name == "MealType") { return MealType; } else if (name == "UseType") { return UseType; } else if (name == "PersonType") { return PersonType; } else if (name == "Parking") { return Parking; } else if (name == "HallFee") { return HallFee; } else if (name == "UpdateDate") { return UpdateDate; } else if (name == "UpdateLoginID") { return UpdateLoginID; } else if (name == "UpdatePcName") { return UpdatePcName; } else if (name == "UpdateID") { return UpdateID; } else { return null; } } public override bool SetField(string name, object value) { if (name == "ID") { ID = value.ToString(); return true; } else if (name == "Name") { Name = value.ToString(); return true; } else if (name == "EnName") { EnName = value.ToString(); return true; } else if (name == "Name2") { Name2 = value.ToString(); return true; } else if (name == "ReceiptName") { ReceiptName = value.ToString(); return true; } else if (name == "RoomTypeID") { RoomTypeID = CConvert.ToInt(value); return true; } else if (name == "PersonCount") { PersonCount = CConvert.ToInt(value); return true; } else if (name == "Price") { Price = CConvert.ToDecimal(value); return true; } else if (name == "DiscountRate") { DiscountRate = CConvert.ToDecimal(value); return true; } else if (name == "DiscountSummary") { DiscountSummary = CConvert.ToDecimal(value); return true; } else if (name == "DiscountID") { DiscountID = CConvert.ToInt(value); return true; } else if (name == "ServiceIOType") { ServiceIOType = CConvert.ToInt(value); return true; } else if (name == "ServiceRate") { ServiceRate = CConvert.ToDecimal(value); return true; } else if (name == "TaxType") { TaxType = CConvert.ToInt(value); return true; } else if (name == "TaxIOType") { TaxIOType = CConvert.ToInt(value); return true; } else if (name == "BathTaxIOType") { BathTaxIOType = CConvert.ToInt(value); return true; } else if (name == "AccTaxIOType") { AccTaxIOType = CConvert.ToInt(value); return true; } else if (name == "SaleSectionID") { SaleSectionID = CConvert.ToInt(value); return true; } else if (name == "SumSectionID") { SumSectionID = CConvert.ToInt(value); return true; } else if (name == "Kind") { Kind = CConvert.ToInt(value); return true; } else if (name == "NextDay") { NextDay = CConvert.ToBool(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 == "PointFlg") { PointFlg = CConvert.ToBool(value); return true; } else if (name == "PointInTax") { PointInTax = CConvert.ToBool(value); return true; } else if (name == "PointRate") { PointRate = CConvert.ToDecimal(value); return true; } else if (name == "PointPrice") { PointPrice = CConvert.ToInt(value); return true; } else if (name == "PointSumType") { PointSumType = CConvert.ToInt(value); return true; } else if (name == "Point") { Point = CConvert.ToInt(value); return true; } else if (name == "DayUse") { DayUse = CConvert.ToBool(value); return true; } else if (name == "ReceiptPrtType") { ReceiptPrtType = CConvert.ToInt(value); return true; } else if (name == "LongStayFlg") { LongStayFlg = CConvert.ToBool(value); return true; } else if (name == "RentalType") { RentalType = CConvert.ToInt(value); return true; } else if (name == "TraderID") { TraderID = CConvert.ToInt(value); return true; } else if (name == "TraderMemo") { TraderMemo = value.ToString(); return true; } else if (name == "PackFlg") { PackFlg = CConvert.ToBool(value); return true; } else if (name == "SortID") { SortID = CConvert.ToInt(value); return true; } else if (name == "Fraction") { Fraction = CConvert.ToInt(value); return true; } else if (name == "InRoomSales") { InRoomSales = CConvert.ToBool(value); return true; } else if (name == "MealType") { MealType = CConvert.ToInt(value); return true; } else if (name == "UseType") { UseType = CConvert.ToInt(value); return true; } else if (name == "PersonType") { PersonType = CConvert.ToInt(value); return true; } else if (name == "Parking") { Parking = CConvert.ToBool(value); return true; } else if (name == "HallFee") { HallFee = CConvert.ToBool(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 == "UpdateID") { UpdateID = CConvert.ToInt(value); return true; } else { return false; } } #endregion }