From eda0c8f74ce453b6e43f88fc92b1e651ce5b6095 Mon Sep 17 00:00:00 2001 From: 南骏 池 <chiffly@163.com> Date: 星期四, 13 二月 2025 13:46:33 +0800 Subject: [PATCH] 1.条码表实体类型调整 2.条码库存表实体新增基础字段 3.期初入库新增入库人 --- entity/MesRohInData.cs | 658 ++++++++++++++++++++++++++++++++--------------------------- 1 files changed, 353 insertions(+), 305 deletions(-) diff --git a/entity/MesRohInData.cs b/entity/MesRohInData.cs index 04564ea..ca110d8 100644 --- a/entity/MesRohInData.cs +++ b/entity/MesRohInData.cs @@ -1,309 +1,357 @@ 锘縰sing SqlSugar; -namespace NewPdaSqlServer.entity +namespace NewPdaSqlServer.entity; + +/// <summary> +/// 閲囪喘璁㈠崟鏄庣粏琛� +/// </summary> +[SugarTable("MES_ROH_IN_DATA")] +public class MesRohInData { /// <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 int? TotalReceivedQty { get; set; } - /// <summary> - /// 鍓╀綑鏀舵枡鏁伴噺 - ///</summary> - [SugarColumn(ColumnName="REMAINING_RECEIVED_QTY" )] - public decimal? RemainingReceivedQty { get; set; } - /// <summary> - /// 绱鍏ュ簱鏁伴噺 - ///</summary> - [SugarColumn(ColumnName="TOTAL_STORED_QTY" )] - public int? TotalStoredQty { get; set; } - /// <summary> - /// 鍓╀綑鍏ュ簱鏁伴噺 - ///</summary> - [SugarColumn(ColumnName="REMAINING_STORED_QTY" )] - public decimal? RemainingStoredQty { get; set; } - /// <summary> - /// 绱閫�鏂欐暟閲� - ///</summary> - [SugarColumn(ColumnName="TOTAL_RETURNED_QTY" )] - public int? TotalReturnedQty { get; set; } - /// <summary> - /// 鏀舵枡鍙��鏁伴噺 - ///</summary> - [SugarColumn(ColumnName="RETURNABLE_RECEIVED_QTY" )] - public int? ReturnableReceivedQty { get; set; } - /// <summary> - /// 搴撳瓨鍙��鏁伴噺 - ///</summary> - [SugarColumn(ColumnName="RETURNABLE_STORED_QTY" )] - public int? 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 int? 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> - /// ERP鐨勫ごID鍙� - ///</summary> - [SugarColumn(ColumnName="ERP_ID" )] - public int? 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> - /// erp鎺ㄦ潵鐨勫凡浜よ揣鏁伴噺 - /// 榛樿鍊�: ((0)) - ///</summary> - [SugarColumn(ColumnName="CGB014" )] - public int? 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; } - } -} + /// 榛樿鍊�: (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 int? TotalReceivedQty { get; set; } + + /// <summary> + /// 鍓╀綑鏀舵枡鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "REMAINING_RECEIVED_QTY")] + public decimal? RemainingReceivedQty { get; set; } + + /// <summary> + /// 绱鍏ュ簱鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "TOTAL_STORED_QTY")] + public int? TotalStoredQty { get; set; } + + /// <summary> + /// 鍓╀綑鍏ュ簱鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "REMAINING_STORED_QTY")] + public decimal? RemainingStoredQty { get; set; } + + /// <summary> + /// 绱閫�鏂欐暟閲� + /// </summary> + [SugarColumn(ColumnName = "TOTAL_RETURNED_QTY")] + public int? TotalReturnedQty { get; set; } + + /// <summary> + /// 鏀舵枡鍙��鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "RETURNABLE_RECEIVED_QTY")] + public int? ReturnableReceivedQty { get; set; } + + /// <summary> + /// 搴撳瓨鍙��鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "RETURNABLE_STORED_QTY")] + public int? 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 int? 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> + /// ERP鐨勫ごID鍙� + /// </summary> + [SugarColumn(ColumnName = "ERP_ID")] + public int? 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> + /// erp鎺ㄦ潵鐨勫凡浜よ揣鏁伴噺 + /// 榛樿鍊�: ((0)) + /// </summary> + [SugarColumn(ColumnName = "CGB014")] + public int? 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