From 1a1c8e71fcd14858f595029f089b2d4a00202b32 Mon Sep 17 00:00:00 2001
From: ogi <Administrator@S-OGI-PC>
Date: Fri, 05 Dec 2025 09:24:16 +0900
Subject: [PATCH] プロジェクトファイルを追加。
---
ProtosExpan/UseInfo/SaleDiv.cs | 294 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 294 insertions(+), 0 deletions(-)
diff --git a/ProtosExpan/UseInfo/SaleDiv.cs b/ProtosExpan/UseInfo/SaleDiv.cs
new file mode 100644
index 0000000..6fb666b
--- /dev/null
+++ b/ProtosExpan/UseInfo/SaleDiv.cs
@@ -0,0 +1,294 @@
+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;
+
+namespace HotelPms.Data.UseInfo
+{
+ /// ****************************** Description *******************************
+ /// ◇システム名称
+ /// ホテルPMS
+ /// ◇概要
+ ///
+ /// ◇履歴
+ /// 2021/05/14 コード作成ツール 自動作成
+ /// ****************************** Declarations ******************************
+ [Serializable()]
+ public partial class SaleDiv : 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);
+ PrimaryKey.TryAdd("SaleID", 0);
+ PrimaryKey.TryAdd("RowNo", 0);
+
+ }
+ }
+
+ #region ★★★★★ Function ★★★★★
+
+ private Timestamp ToTimestamp(DateTime dateTime)
+ {
+ return Timestamp.FromDateTime(DateTime.SpecifyKind(dateTime, DateTimeKind.Utc));
+ }
+
+ public bool CompareTo(SaleDiv item)
+ {
+ if (ID.CompareTo(item.ID) != 0
+ || DetailID.CompareTo(item.DetailID) != 0
+ || UseDate.CompareTo(item.UseDate) != 0
+ || SaleID.CompareTo(item.SaleID) != 0
+ || RowNo.CompareTo(item.RowNo) != 0
+ || ReceiptID.CompareTo(item.ReceiptID) != 0
+ || Price.CompareTo(item.Price) != 0
+ || Amount.CompareTo(item.Amount) != 0
+ || Summary.CompareTo(item.Summary) != 0
+ || ServiceSummary.CompareTo(item.ServiceSummary) != 0
+ || TaxSummary.CompareTo(item.TaxSummary) != 0
+ || BathTaxSummary.CompareTo(item.BathTaxSummary) != 0
+ || AccTaxSummary.CompareTo(item.AccTaxSummary) != 0
+ || TotalSummary.CompareTo(item.TotalSummary) != 0
+ || DiscountSummary.CompareTo(item.DiscountSummary) != 0
+ || ReceiptPrtType.CompareTo(item.ReceiptPrtType) != 0
+ || ReceiptPage.CompareTo(item.ReceiptPage) != 0
+)
+ {
+ return false;
+ }
+ return true;
+ }
+
+
+ public override void CopyTo(object dest)
+ {
+ SaleDiv item = dest as SaleDiv;
+ item.ID = ID;
+ item.DetailID = DetailID;
+ item.UseDate = UseDate;
+ item.SaleID = SaleID;
+ item.RowNo = RowNo;
+ item.ReceiptID = ReceiptID;
+ item.Price = Price;
+ item.Amount = Amount;
+ item.Summary = Summary;
+ item.ServiceSummary = ServiceSummary;
+ item.TaxSummary = TaxSummary;
+ item.BathTaxSummary = BathTaxSummary;
+ item.AccTaxSummary = AccTaxSummary;
+ item.TotalSummary = TotalSummary;
+ item.DiscountSummary = DiscountSummary;
+ item.ReceiptPrtType = ReceiptPrtType;
+ item.ReceiptPage = ReceiptPage;
+
+ }
+
+ public override void Clear()
+ {
+ ID = 0;
+ DetailID = 0;
+ UseDate = ToTimestamp(DateTime.MinValue);
+ SaleID = 0;
+ RowNo = 0;
+ ReceiptID = 0;
+ Price = 0;
+ Amount = 0;
+ Summary = 0;
+ ServiceSummary = 0;
+ TaxSummary = 0;
+ BathTaxSummary = 0;
+ AccTaxSummary = 0;
+ TotalSummary = 0;
+ DiscountSummary = 0;
+ ReceiptPrtType = 0;
+ ReceiptPage = 0;
+
+ }
+
+ public SaleDiv DeepClone()
+ {
+ SaleDiv item = new SaleDiv();
+ item.ID = ID;
+ item.DetailID = DetailID;
+ item.UseDate = UseDate;
+ item.SaleID = SaleID;
+ item.RowNo = RowNo;
+ item.ReceiptID = ReceiptID;
+ item.Price = Price;
+ item.Amount = Amount;
+ item.Summary = Summary;
+ item.ServiceSummary = ServiceSummary;
+ item.TaxSummary = TaxSummary;
+ item.BathTaxSummary = BathTaxSummary;
+ item.AccTaxSummary = AccTaxSummary;
+ item.TotalSummary = TotalSummary;
+ item.DiscountSummary = DiscountSummary;
+ item.ReceiptPrtType = ReceiptPrtType;
+ item.ReceiptPage = ReceiptPage;
+
+ return item;
+ }
+
+ public override bool ConvertDataRow(System.Data.DataRow row)
+ {
+ ID = CConvert.ToInt(row["ID"],ID);
+ DetailID = CConvert.ToInt(row["DetailID"],DetailID);
+ UseDate = ToTimestamp(row.IsNull("UseDate") ? DateTime.MinValue : (System.DateTime)row["UseDate"]);
+ SaleID = CConvert.ToInt(row["SaleID"],SaleID);
+ RowNo = CConvert.ToInt(row["RowNo"],RowNo);
+ ReceiptID = CConvert.ToInt(row["ReceiptID"],ReceiptID);
+ Price = CConvert.ToDecimal(row["Price"]);
+ Amount = CConvert.ToInt(row["Amount"],Amount);
+ Summary = CConvert.ToDecimal(row["Summary"]);
+ ServiceSummary = CConvert.ToDecimal(row["ServiceSummary"]);
+ TaxSummary = CConvert.ToDecimal(row["TaxSummary"]);
+ BathTaxSummary = CConvert.ToDecimal(row["BathTaxSummary"]);
+ AccTaxSummary = CConvert.ToDecimal(row["AccTaxSummary"]);
+ TotalSummary = CConvert.ToDecimal(row["TotalSummary"]);
+ DiscountSummary = CConvert.ToDecimal(row["DiscountSummary"]);
+ ReceiptPrtType = CConvert.ToInt(row["ReceiptPrtType"],ReceiptPrtType);
+ ReceiptPage = CConvert.ToInt(row["ReceiptPage"],ReceiptPage);
+
+ return true;
+ }
+
+ public void ToDataRow(System.Data.DataRow row)
+ {
+ row["ID"] = ID;
+ row["DetailID"] = DetailID;
+ row["UseDate"] = UseDate;
+ row["SaleID"] = SaleID;
+ row["RowNo"] = RowNo;
+ row["ReceiptID"] = ReceiptID;
+ row["Price"] = Price;
+ row["Amount"] = Amount;
+ row["Summary"] = Summary;
+ row["ServiceSummary"] = ServiceSummary;
+ row["TaxSummary"] = TaxSummary;
+ row["BathTaxSummary"] = BathTaxSummary;
+ row["AccTaxSummary"] = AccTaxSummary;
+ row["TotalSummary"] = TotalSummary;
+ row["DiscountSummary"] = DiscountSummary;
+ row["ReceiptPrtType"] = ReceiptPrtType;
+ row["ReceiptPage"] = ReceiptPage;
+
+ }
+
+ public void ConvertReader(SqlDataReader row)
+ {
+ ID = CConvert.ToInt(row["ID"],ID);
+ DetailID = CConvert.ToInt(row["DetailID"],DetailID);
+ UseDate = ToTimestamp(row.IsNull("UseDate") ? DateTime.MinValue : (System.DateTime)row["UseDate"]);
+ SaleID = CConvert.ToInt(row["SaleID"],SaleID);
+ RowNo = CConvert.ToInt(row["RowNo"],RowNo);
+ ReceiptID = CConvert.ToInt(row["ReceiptID"],ReceiptID);
+ Price = CConvert.ToDecimal(row["Price"]);
+ Amount = CConvert.ToInt(row["Amount"],Amount);
+ Summary = CConvert.ToDecimal(row["Summary"]);
+ ServiceSummary = CConvert.ToDecimal(row["ServiceSummary"]);
+ TaxSummary = CConvert.ToDecimal(row["TaxSummary"]);
+ BathTaxSummary = CConvert.ToDecimal(row["BathTaxSummary"]);
+ AccTaxSummary = CConvert.ToDecimal(row["AccTaxSummary"]);
+ TotalSummary = CConvert.ToDecimal(row["TotalSummary"]);
+ DiscountSummary = CConvert.ToDecimal(row["DiscountSummary"]);
+ ReceiptPrtType = CConvert.ToInt(row["ReceiptPrtType"],ReceiptPrtType);
+ ReceiptPage = CConvert.ToInt(row["ReceiptPage"],ReceiptPage);
+
+ }
+
+ public string AddSql()
+ {
+ return $@"INSERT INTO D_SaleDiv(ID,DetailID,UseDate,SaleID,RowNo,ReceiptID,Price,Amount,Summary,ServiceSummary,TaxSummary,BathTaxSummary,AccTaxSummary,TotalSummary,DiscountSummary,ReceiptPrtType,ReceiptPage) VALUES({ID},{DetailID},{CConvert.ToSqlValue(UseDate)},{SaleID},{RowNo},{ReceiptID},{Price},{Amount},{Summary},{ServiceSummary},{TaxSummary},{BathTaxSummary},{AccTaxSummary},{TotalSummary},{DiscountSummary},{ReceiptPrtType},{ReceiptPage});";
+ }
+
+ public string UpdateSql()
+ {
+ return $@"UPDATE D_SaleDiv SET ReceiptID = {ReceiptID},Price = {Price},Amount = {Amount},Summary = {Summary},ServiceSummary = {ServiceSummary},TaxSummary = {TaxSummary},BathTaxSummary = {BathTaxSummary},AccTaxSummary = {AccTaxSummary},TotalSummary = {TotalSummary},DiscountSummary = {DiscountSummary},ReceiptPrtType = {ReceiptPrtType},ReceiptPage = {ReceiptPage} WHERE ID = {ID} AND DetailID = {DetailID} AND UseDate = {CConvert.ToSqlValue(UseDate)} AND SaleID = {SaleID} AND RowNo = {RowNo};";
+ }
+
+ public string ToText()
+ {
+ StringBuilder text = new StringBuilder();
+ text.AppendFormat("ID={0};", ID);
+ text.AppendFormat("DetailID={0};", DetailID);
+ text.AppendFormat("UseDate={0};", UseDate);
+ text.AppendFormat("SaleID={0};", SaleID);
+ text.AppendFormat("RowNo={0};", RowNo);
+ text.AppendFormat("ReceiptID={0};", ReceiptID);
+ text.AppendFormat("Price={0};", Price);
+ text.AppendFormat("Amount={0};", Amount);
+ text.AppendFormat("Summary={0};", Summary);
+ text.AppendFormat("ServiceSummary={0};", ServiceSummary);
+ text.AppendFormat("TaxSummary={0};", TaxSummary);
+ text.AppendFormat("BathTaxSummary={0};", BathTaxSummary);
+ text.AppendFormat("AccTaxSummary={0};", AccTaxSummary);
+ text.AppendFormat("TotalSummary={0};", TotalSummary);
+ text.AppendFormat("DiscountSummary={0};", DiscountSummary);
+ text.AppendFormat("ReceiptPrtType={0};", ReceiptPrtType);
+ text.AppendFormat("ReceiptPage={0};", ReceiptPage);
+
+ 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 == "SaleID") { return SaleID; }
+ else if (name == "RowNo") { return RowNo; }
+ else if (name == "ReceiptID") { return ReceiptID; }
+ else if (name == "Price") { return Price; }
+ else if (name == "Amount") { return Amount; }
+ else if (name == "Summary") { return Summary; }
+ else if (name == "ServiceSummary") { return ServiceSummary; }
+ else if (name == "TaxSummary") { return TaxSummary; }
+ else if (name == "BathTaxSummary") { return BathTaxSummary; }
+ else if (name == "AccTaxSummary") { return AccTaxSummary; }
+ else if (name == "TotalSummary") { return TotalSummary; }
+ else if (name == "DiscountSummary") { return DiscountSummary; }
+ else if (name == "ReceiptPrtType") { return ReceiptPrtType; }
+ else if (name == "ReceiptPage") { return ReceiptPage; }
+ 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 = ToTimestamp(CConvert.ToDateTime(value)); return true; }
+ else if (name == "SaleID") { SaleID = CConvert.ToInt(value); return true; }
+ else if (name == "RowNo") { RowNo = CConvert.ToInt(value); return true; }
+ else if (name == "ReceiptID") { ReceiptID = CConvert.ToInt(value); return true; }
+ else if (name == "Price") { Price = CConvert.ToDecimal(value); return true; }
+ else if (name == "Amount") { Amount = CConvert.ToInt(value); return true; }
+ else if (name == "Summary") { Summary = CConvert.ToDecimal(value); return true; }
+ else if (name == "ServiceSummary") { ServiceSummary = CConvert.ToDecimal(value); return true; }
+ else if (name == "TaxSummary") { TaxSummary = CConvert.ToDecimal(value); return true; }
+ else if (name == "BathTaxSummary") { BathTaxSummary = CConvert.ToDecimal(value); return true; }
+ else if (name == "AccTaxSummary") { AccTaxSummary = CConvert.ToDecimal(value); return true; }
+ else if (name == "TotalSummary") { TotalSummary = CConvert.ToDecimal(value); return true; }
+ else if (name == "DiscountSummary") { DiscountSummary = CConvert.ToDecimal(value); return true; }
+ else if (name == "ReceiptPrtType") { ReceiptPrtType = CConvert.ToInt(value); return true; }
+ else if (name == "ReceiptPage") { ReceiptPage = CConvert.ToInt(value); return true; }
+ else { return false; }
+ }
+
+ #endregion
+ }
+}
\ No newline at end of file
--
Gitblit v1.10.0