From ad75e6017901835df1cb3e18e4cc3a6d3460cbeb Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 30 十月 2024 19:44:50 +0800
Subject: [PATCH] 111

---
 MES.Service/Modes/MesRohInData.cs |  372 +++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 372 insertions(+), 0 deletions(-)

diff --git a/MES.Service/Modes/MesRohInData.cs b/MES.Service/Modes/MesRohInData.cs
new file mode 100644
index 0000000..62a7b64
--- /dev/null
+++ b/MES.Service/Modes/MesRohInData.cs
@@ -0,0 +1,372 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+///     閲囪喘璁㈠崟鏄庣粏琛�
+/// </summary>
+[SugarTable("MES_ROH_IN_DATA")]
+public class MesRohInData
+{
+    /// <summary>
+    ///  
+    /// 榛樿鍊�: (newid())
+    ///</summary>
+    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+    public Guid Guid { get; set; }
+
+    /// <summary>
+    /// 閲囪喘鍗曞彿 
+    ///</summary>
+    [SugarColumn(ColumnName = "BILL_NO")]
+    public string? BillNo { get; set; }
+
+    /// <summary>
+    /// 閿�鍞鍗曞彿 
+    ///</summary>
+    [SugarColumn(ColumnName = "SALES_ORDER_ID")]
+    public string? SalesOrderId { get; set; }
+
+    /// <summary>
+    /// 閲囪喘璁㈠崟琛屽彿 
+    ///</summary>
+    [SugarColumn(ColumnName = "ORDER_LINE_ID")]
+    public string? OrderLineId { get; set; }
+
+    /// <summary>
+    /// 鐗╂枡缂栫爜 
+    ///</summary>
+    [SugarColumn(ColumnName = "ITEM_ID")]
+    public string? ItemId { get; set; }
+
+    /// <summary>
+    /// 閲囪喘鍗曚綅 
+    ///</summary>
+    [SugarColumn(ColumnName = "PURCHASE_UNIT")]
+    public string? PurchaseUnit { get; set; }
+
+    /// <summary>
+    /// 閲囪喘鏁伴噺 
+    ///</summary>
+    [SugarColumn(ColumnName = "PURCHASE_QTY")]
+    public decimal? PurchaseQty { get; set; }
+
+    /// <summary>
+    /// 搴撳瓨鍗曚綅 
+    ///</summary>
+    [SugarColumn(ColumnName = "INVENTORY_UNIT")]
+    public string? InventoryUnit { get; set; }
+
+    /// <summary>
+    /// 璁′环鍗曚綅 
+    ///</summary>
+    [SugarColumn(ColumnName = "PRICING_UNIT")]
+    public string? PricingUnit { get; set; }
+
+    /// <summary>
+    /// 璁′环鏁伴噺 
+    ///</summary>
+    [SugarColumn(ColumnName = "PRICING_QTY")]
+    public decimal? PricingQty { get; set; }
+
+    /// <summary>
+    /// 浜よ揣鏃ユ湡 
+    ///</summary>
+    [SugarColumn(ColumnName = "DELIVERY_DATE")]
+    public DateTime? DeliveryDate { get; set; }
+
+    /// <summary>
+    /// 鏈�鏃╀氦璐ф棩鏈� 
+    ///</summary>
+    [SugarColumn(ColumnName = "EARLIEST_DELIVERY_DATE")]
+    public DateTime? EarliestDeliveryDate { get; set; }
+
+    /// <summary>
+    /// 鏈�鏅氫氦璐ф棩鏈� 
+    ///</summary>
+    [SugarColumn(ColumnName = "LATEST_DELIVERY_DATE")]
+    public DateTime? LatestDeliveryDate { get; set; }
+
+    /// <summary>
+    /// 闇�姹傜粍缁� 
+    ///</summary>
+    [SugarColumn(ColumnName = "DEMAND_ORG")]
+    public string? DemandOrg { get; set; }
+
+    /// <summary>
+    /// 鏀舵枡缁勭粐 
+    ///</summary>
+    [SugarColumn(ColumnName = "RECEIVING_ORG")]
+    public string? ReceivingOrg { get; set; }
+
+    /// <summary>
+    /// 缁撶畻缁勭粐 
+    ///</summary>
+    [SugarColumn(ColumnName = "SETTLEMENT_ORG")]
+    public string? SettlementOrg { get; set; }
+
+    /// <summary>
+    /// 鏄惁璧犲搧 
+    ///</summary>
+    [SugarColumn(ColumnName = "IS_GIFT")]
+    public string? IsGift { get; set; }
+
+    /// <summary>
+    /// 澶囨敞 
+    ///</summary>
+    [SugarColumn(ColumnName = "REMARKS")]
+    public string? Remarks { get; set; }
+
+    /// <summary>
+    /// 渚涘簲鍟嗙墿鏂欑紪鐮� 
+    ///</summary>
+    [SugarColumn(ColumnName = "SUPPLIER_ITEM_CODE")]
+    public string? SupplierItemCode { get; set; }
+
+    /// <summary>
+    /// 渚涘簲鍟嗙墿鏂欏悕绉� 
+    ///</summary>
+    [SugarColumn(ColumnName = "SUPPLIER_ITEM_NAME")]
+    public string? SupplierItemName { get; set; }
+
+    /// <summary>
+    /// 濮斿璁㈠崟缂栧彿 
+    ///</summary>
+    [SugarColumn(ColumnName = "OUTSOURCING_ORDER_ID")]
+    public string? OutsourcingOrderId { get; set; }
+
+    /// <summary>
+    /// 鎵瑰彿 
+    ///</summary>
+    [SugarColumn(ColumnName = "BATCH_NUMBER")]
+    public string? BatchNumber { get; set; }
+
+    /// <summary>
+    /// 涓氬姟鍏抽棴 
+    ///</summary>
+    [SugarColumn(ColumnName = "BUSINESS_CLOSE")]
+    public string? BusinessClose { get; set; }
+
+    /// <summary>
+    /// 涓氬姟鍐荤粨 
+    ///</summary>
+    [SugarColumn(ColumnName = "BUSINESS_FREEZE")]
+    public string? BusinessFreeze { get; set; }
+
+    /// <summary>
+    /// 鍐荤粨浜� 
+    ///</summary>
+    [SugarColumn(ColumnName = "FREEZER")]
+    public string? Freezer { get; set; }
+
+    /// <summary>
+    /// 鍐荤粨鏃堕棿 
+    ///</summary>
+    [SugarColumn(ColumnName = "FREEZE_TIME")]
+    public DateTime? FreezeTime { get; set; }
+
+    /// <summary>
+    /// 涓氬姟缁堟 
+    ///</summary>
+    [SugarColumn(ColumnName = "BUSINESS_TERMINATE")]
+    public string? BusinessTerminate { get; set; }
+
+    /// <summary>
+    /// 缁堟浜� 
+    ///</summary>
+    [SugarColumn(ColumnName = "TERMINATOR")]
+    public string? Terminator { get; set; }
+
+    /// <summary>
+    /// 缁堟鏃堕棿 
+    ///</summary>
+    [SugarColumn(ColumnName = "TERMINATE_TIME")]
+    public DateTime? TerminateTime { get; set; }
+
+    /// <summary>
+    /// 绱鏀舵枡鏁伴噺 
+    ///</summary>
+    [SugarColumn(ColumnName = "TOTAL_RECEIVED_QTY")]
+    public decimal? TotalReceivedQty { get; set; }
+
+    /// <summary>
+    /// 鍓╀綑鏀舵枡鏁伴噺 
+    ///</summary>
+    [SugarColumn(ColumnName = "REMAINING_RECEIVED_QTY")]
+    public decimal? RemainingReceivedQty { get; set; }
+
+    /// <summary>
+    /// 绱鍏ュ簱鏁伴噺 
+    ///</summary>
+    [SugarColumn(ColumnName = "TOTAL_STORED_QTY")]
+    public decimal? TotalStoredQty { get; set; }
+
+    /// <summary>
+    /// 鍓╀綑鍏ュ簱鏁伴噺 
+    ///</summary>
+    [SugarColumn(ColumnName = "REMAINING_STORED_QTY")]
+    public decimal? RemainingStoredQty { get; set; }
+
+    /// <summary>
+    /// 绱閫�鏂欐暟閲� 
+    ///</summary>
+    [SugarColumn(ColumnName = "TOTAL_RETURNED_QTY")]
+    public decimal? TotalReturnedQty { get; set; }
+
+    /// <summary>
+    /// 鏀舵枡鍙��鏁伴噺 
+    ///</summary>
+    [SugarColumn(ColumnName = "RETURNABLE_RECEIVED_QTY")]
+    public decimal? ReturnableReceivedQty { get; set; }
+
+    /// <summary>
+    /// 搴撳瓨鍙��鏁伴噺 
+    ///</summary>
+    [SugarColumn(ColumnName = "RETURNABLE_STORED_QTY")]
+    public decimal? ReturnableStoredQty { get; set; }
+
+    /// <summary>
+    /// 婧愬崟绫诲瀷 
+    ///</summary>
+    [SugarColumn(ColumnName = "SOURCE_DOCUMENT_TYPE")]
+    public string? SourceDocumentType { get; set; }
+
+    /// <summary>
+    /// 婧愬崟鍗曞彿 
+    ///</summary>
+    [SugarColumn(ColumnName = "SOURCE_DOCUMENT_ID")]
+    public string? SourceDocumentId { get; set; }
+
+    /// <summary>
+    /// 闇�姹傝窡韪彿 
+    ///</summary>
+    [SugarColumn(ColumnName = "DEMAND_TRACKING_ID")]
+    public string? DemandTrackingId { get; set; }
+
+    /// <summary>
+    /// 璁″垝璺熻釜鍙� 
+    ///</summary>
+    [SugarColumn(ColumnName = "PLAN_TRACKING_ID")]
+    public string? PlanTrackingId { get; set; }
+
+    /// <summary>
+    /// 鍙樻洿鏍囧織 
+    ///</summary>
+    [SugarColumn(ColumnName = "CHANGE_FLAG")]
+    public string? ChangeFlag { get; set; }
+
+    /// <summary>
+    /// 闇�姹傛潵婧� 
+    ///</summary>
+    [SugarColumn(ColumnName = "DEMAND_SOURCE")]
+    public string? DemandSource { get; set; }
+
+    /// <summary>
+    /// 闇�姹傚崟鎹紪鍙� 
+    ///</summary>
+    [SugarColumn(ColumnName = "DEMAND_DOCUMENT_ID")]
+    public string? DemandDocumentId { get; set; }
+
+    /// <summary>
+    /// 闇�姹傚崟鎹鍙� 
+    ///</summary>
+    [SugarColumn(ColumnName = "DEMAND_DOCUMENT_LINE_ID")]
+    public string? DemandDocumentLineId { get; set; }
+
+    /// <summary>
+    /// ERP鐨処D鍙� 
+    ///</summary>
+    [SugarColumn(ColumnName = "EBELN_K3ID")]
+    public decimal? EbelnK3id { get; set; }
+
+    /// <summary>
+    /// 瀹㈡埛璐у彿 
+    ///</summary>
+    [SugarColumn(ColumnName = "REMARK1")]
+    public string? Remark1 { get; set; }
+
+    /// <summary>
+    /// 鍖呰鍗曞彿 
+    ///</summary>
+    [SugarColumn(ColumnName = "REMARK2")]
+    public string? Remark2 { get; set; }
+
+    /// <summary>
+    /// 涓讳骇鍝� 
+    ///</summary>
+    [SugarColumn(ColumnName = "REMARK3")]
+    public string? Remark3 { get; set; }
+
+    /// <summary>
+    /// SMT澶囨敞 
+    ///</summary>
+    [SugarColumn(ColumnName = "REMARK4")]
+    public string? Remark4 { get; set; }
+
+    /// <summary>
+    ///  
+    ///</summary>
+    [SugarColumn(ColumnName = "ID")]
+    public decimal? Id { get; set; }
+
+    /// <summary>
+    ///  
+    ///</summary>
+    [SugarColumn(ColumnName = "ERP_ID")]
+    public decimal? ErpId { get; set; }
+
+    /// <summary>
+    ///  
+    ///</summary>
+    [SugarColumn(ColumnName = "PURCHASE_ORDER_LINE_NUMBER")]
+    public string? PurchaseOrderLineNumber { get; set; }
+
+    /// <summary>
+    ///  
+    ///</summary>
+    [SugarColumn(ColumnName = "DEMAND")]
+    public string? Demand { get; set; }
+
+    /// <summary>
+    ///  
+    ///</summary>
+    [SugarColumn(ColumnName = "RECEIVING")]
+    public string? Receiving { get; set; }
+
+    /// <summary>
+    ///  
+    ///</summary>
+    [SugarColumn(ColumnName = "SETTLEMENT")]
+    public string? Settlement { get; set; }
+
+    /// <summary>
+    ///  
+    /// 榛樿鍊�: ((0))
+    ///</summary>
+    [SugarColumn(ColumnName = "CGB014")]
+    public decimal? Cgb014 { get; set; }
+
+    /// <summary>
+    ///  
+    ///</summary>
+    [SugarColumn(ColumnName = "DEMAND_DEPARTMENT")]
+    public string? DemandDepartment { get; set; }
+
+    /// <summary>
+    ///     鏀舵枡閮ㄩ棬
+    /// </summary>
+    [SugarColumn(ColumnName = "RECEIVING_DEPARTMENT")]
+    public string? ReceivingDepartment { get; set; }
+
+    /// <summary>
+    ///  
+    ///</summary>
+    [SugarColumn(ColumnName = "FPREARRIVALDATE")]
+    public DateTime? Fprearrivaldate { get; set; }
+
+    /// <summary>
+    ///  
+    ///</summary>
+    [SugarColumn(ColumnName = "FDEMANDBILLNO_LINE")]
+    public string? FdemandbillnoLine { get; set; }
+}
\ No newline at end of file

--
Gitblit v1.9.3