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/MesRohIn.cs | 550 +++++++++++++++++++++++++++++-------------------------
1 files changed, 296 insertions(+), 254 deletions(-)
diff --git a/entity/MesRohIn.cs b/entity/MesRohIn.cs
index 0822787..5d166b1 100644
--- a/entity/MesRohIn.cs
+++ b/entity/MesRohIn.cs
@@ -1,258 +1,300 @@
锘縰sing SqlSugar;
-namespace NewPdaSqlServer.entity
+namespace NewPdaSqlServer.entity;
+
+/// <summary>
+/// 閲囪喘璁㈠崟琛�
+/// </summary>
+[SugarTable("MES_ROH_IN")]
+public class MesRohIn
{
/// <summary>
- /// 閲囪喘璁㈠崟琛�
- ///</summary>
- [SugarTable("MES_ROH_IN")]
- public class MesRohIn
- {
- /// <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="DOCUMENT_STATUS" )]
- public string DocumentStatus { get; set; }
- /// <summary>
- /// 鍗曟嵁绫诲瀷
- ///</summary>
- [SugarColumn(ColumnName="DOCUMENT_TYPE" )]
- public string DocumentType { get; set; }
- /// <summary>
- /// 涓氬姟绫诲瀷
- ///</summary>
- [SugarColumn(ColumnName="BUSINESS_TYPE" )]
- public string BusinessType { get; set; }
- /// <summary>
- /// 閲囪喘鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName="PURCHASE_DATE" )]
- public DateTime? PurchaseDate { get; set; }
- /// <summary>
- /// 渚涘簲鍟�
- ///</summary>
- [SugarColumn(ColumnName="SUPPLIER" )]
- public string Supplier { get; set; }
- /// <summary>
- /// 鍏抽棴鐘舵��
- ///</summary>
- [SugarColumn(ColumnName="CLOSE_STATUS" )]
- public string CloseStatus { get; set; }
- /// <summary>
- /// 閲囪喘缁勭粐
- ///</summary>
- [SugarColumn(ColumnName="PURCHASE_ORG" )]
- public string PurchaseOrg { get; set; }
- /// <summary>
- /// 閲囪喘閮ㄩ棬
- ///</summary>
- [SugarColumn(ColumnName="PURCHASE_DEPT" )]
- public string PurchaseDept { get; set; }
- /// <summary>
- /// 閲囪喘缁�
- ///</summary>
- [SugarColumn(ColumnName="PURCHASE_GROUP" )]
- public string PurchaseGroup { get; set; }
- /// <summary>
- /// 鏁伴噺楠屾敹
- ///</summary>
- [SugarColumn(ColumnName="QTY_ACCEPTANCE" )]
- public string QtyAcceptance { get; set; }
- /// <summary>
- /// 閲囪喘鍛�
- ///</summary>
- [SugarColumn(ColumnName="PURCHASER" )]
- public string Purchaser { get; set; }
- /// <summary>
- /// 璐ㄩ噺瑕佹眰
- ///</summary>
- [SugarColumn(ColumnName="QUALITY_REQ" )]
- public string QualityReq { get; set; }
- /// <summary>
- /// 缁撶畻鏂�
- ///</summary>
- [SugarColumn(ColumnName="SETTLEMENT_PARTY" )]
- public string SettlementParty { get; set; }
- /// <summary>
- /// 鏀舵鏂�
- ///</summary>
- [SugarColumn(ColumnName="PAYMENT_PARTY" )]
- public string PaymentParty { get; set; }
- /// <summary>
- /// 閭
- ///</summary>
- [SugarColumn(ColumnName="EMAIL" )]
- public string Email { get; set; }
- /// <summary>
- /// 杩愯緭鏂瑰紡
- ///</summary>
- [SugarColumn(ColumnName="TRANSPORT_METHOD" )]
- public string TransportMethod { get; set; }
- /// <summary>
- /// 澶囨敞
- ///</summary>
- [SugarColumn(ColumnName="REMARKS" )]
- public string Remarks { get; set; }
- /// <summary>
- /// 娌诲叿涓舵ā鍏峰姞宸ュ強閲囪喘
- ///</summary>
- [SugarColumn(ColumnName="FIXTURE_MOLD_PROCUREMENT" )]
- public string FixtureMoldProcurement { get; set; }
- /// <summary>
- /// 浣滃簾鐘舵��
- ///</summary>
- [SugarColumn(ColumnName="CANCELLATION_STATUS" )]
- public string CancellationStatus { get; set; }
- /// <summary>
- /// 浣滃簾浜�
- ///</summary>
- [SugarColumn(ColumnName="CANCELLATION_PERSON" )]
- public string CancellationPerson { get; set; }
- /// <summary>
- /// 浣滃簾鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName="CANCELLATION_DATE" )]
- public DateTime? CancellationDate { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- ///</summary>
- [SugarColumn(ColumnName="CREATE_BY" )]
- public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName="CREATE_DATE" )]
- public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏈�鍚庝慨鏀规椂闂�
- ///</summary>
- [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
- public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 鏈�鍚庝慨鏀逛汉
- ///</summary>
- [SugarColumn(ColumnName="LASTUPDATE_BY" )]
- public string LastupdateBy { get; set; }
- /// <summary>
- /// 瀹℃牳浜�
- ///</summary>
- [SugarColumn(ColumnName="ERP_CHECK_BY" )]
- public string ErpCheckBy { get; set; }
- /// <summary>
- /// 瀹℃牳鏃堕棿
- ///</summary>
- [SugarColumn(ColumnName="ERP_CHECK_DATE" )]
- public string ErpCheckDate { get; set; }
- /// <summary>
- /// ERP鐨処D鍙�
- ///</summary>
- [SugarColumn(ColumnName="EBELN_K3ID" )]
- public long? EbelnK3id { get; set; }
- /// <summary>
- /// 瀹℃牳鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName="CHECK_DATE" )]
- public DateTime? CheckDate { get; set; }
- /// <summary>
- /// 瀹℃牳浜�
- ///</summary>
- [SugarColumn(ColumnName="CHECK_BY" )]
- public string CheckBy { get; set; }
- /// <summary>
- /// 瀹℃牳鏍囪瘑
- ///</summary>
- [SugarColumn(ColumnName="CHECK_FALG" )]
- public int? CheckFalg { get; set; }
- /// <summary>
- /// 鎵撳嵃娆℃暟
- ///</summary>
- [SugarColumn(ColumnName="REMARK1" )]
- public string Remark1 { get; set; }
- /// <summary>
- /// 鑷畾涔夊瓧娈�2
- ///</summary>
- [SugarColumn(ColumnName="REMARK2" )]
- public string Remark2 { get; set; }
- /// <summary>
- /// 鑷畾涔夊瓧娈�3
- ///</summary>
- [SugarColumn(ColumnName="REMARK3" )]
- public string Remark3 { get; set; }
- /// <summary>
- /// 鑷畾涔夊瓧娈�4
- ///</summary>
- [SugarColumn(ColumnName="REMARK4" )]
- public string Remark4 { get; set; }
- /// <summary>
- /// 鑷畾涔夊瓧娈�5
- ///</summary>
- [SugarColumn(ColumnName="REMARK5" )]
- public string Remark5 { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName="CHANGEREASON" )]
- public string Changereason { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName="FACTORY" )]
- public string Factory { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName="COMPANY" )]
- public string Company { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName="Prearrivaldate" )]
- public DateTime? Prearrivaldate { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName="ReceiveOrgId" )]
- public string ReceiveOrgId { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName="Provider_Id" )]
- public string ProviderId { get; set; }
- /// <summary>
- /// 鑱旂郴浜�
- ///</summary>
- [SugarColumn(ColumnName="anred" )]
- public string Anred { get; set; }
- /// <summary>
- /// 鐢佃瘽
- ///</summary>
- [SugarColumn(ColumnName="telf1" )]
- public string Telf1 { get; set; }
- /// <summary>
- /// 鍥哄畾鐢佃瘽
- ///</summary>
- [SugarColumn(ColumnName="Fixed_Telephone" )]
- public string FixedTelephone { get; set; }
- /// <summary>
- /// 閫氳鍦板潃
- ///</summary>
- [SugarColumn(ColumnName="Address" )]
- public string Address { get; set; }
- /// <summary>
- /// 楠屾敹鏂瑰紡
- ///</summary>
- [SugarColumn(ColumnName="Acctype" )]
- public string Acctype { 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 = "DOCUMENT_STATUS")]
+ public string? DocumentStatus { get; set; }
+
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "DOCUMENT_TYPE")]
+ public string? DocumentType { get; set; }
+
+ /// <summary>
+ /// 涓氬姟绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "BUSINESS_TYPE")]
+ public string? BusinessType { get; set; }
+
+ /// <summary>
+ /// 閲囪喘鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "PURCHASE_DATE")]
+ public DateTime? PurchaseDate { get; set; }
+
+ /// <summary>
+ /// 渚涘簲鍟�
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPPLIER")]
+ public string? Supplier { get; set; }
+
+ /// <summary>
+ /// 鍏抽棴鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "CLOSE_STATUS")]
+ public string? CloseStatus { get; set; }
+
+ /// <summary>
+ /// 閲囪喘缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "PURCHASE_ORG")]
+ public string? PurchaseOrg { get; set; }
+
+ /// <summary>
+ /// 閲囪喘閮ㄩ棬
+ /// </summary>
+ [SugarColumn(ColumnName = "PURCHASE_DEPT")]
+ public string? PurchaseDept { get; set; }
+
+ /// <summary>
+ /// 閲囪喘缁�
+ /// </summary>
+ [SugarColumn(ColumnName = "PURCHASE_GROUP")]
+ public string? PurchaseGroup { get; set; }
+
+ /// <summary>
+ /// 鏁伴噺楠屾敹
+ /// </summary>
+ [SugarColumn(ColumnName = "QTY_ACCEPTANCE")]
+ public string? QtyAcceptance { get; set; }
+
+ /// <summary>
+ /// 閲囪喘鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "PURCHASER")]
+ public string? Purchaser { get; set; }
+
+ /// <summary>
+ /// 璐ㄩ噺瑕佹眰
+ /// </summary>
+ [SugarColumn(ColumnName = "QUALITY_REQ")]
+ public string? QualityReq { get; set; }
+
+ /// <summary>
+ /// 缁撶畻鏂�
+ /// </summary>
+ [SugarColumn(ColumnName = "SETTLEMENT_PARTY")]
+ public string? SettlementParty { get; set; }
+
+ /// <summary>
+ /// 鏀舵鏂�
+ /// </summary>
+ [SugarColumn(ColumnName = "PAYMENT_PARTY")]
+ public string? PaymentParty { get; set; }
+
+ /// <summary>
+ /// 閭
+ /// </summary>
+ [SugarColumn(ColumnName = "EMAIL")]
+ public string? Email { get; set; }
+
+ /// <summary>
+ /// 杩愯緭鏂瑰紡
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSPORT_METHOD")]
+ public string? TransportMethod { get; set; }
+
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARKS")]
+ public string? Remarks { get; set; }
+
+ /// <summary>
+ /// 娌诲叿涓舵ā鍏峰姞宸ュ強閲囪喘
+ /// </summary>
+ [SugarColumn(ColumnName = "FIXTURE_MOLD_PROCUREMENT")]
+ public string? FixtureMoldProcurement { get; set; }
+
+ /// <summary>
+ /// 浣滃簾鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "CANCELLATION_STATUS")]
+ public string? CancellationStatus { get; set; }
+
+ /// <summary>
+ /// 浣滃簾浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CANCELLATION_PERSON")]
+ public string? CancellationPerson { get; set; }
+
+ /// <summary>
+ /// 浣滃簾鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CANCELLATION_DATE")]
+ public DateTime? CancellationDate { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
+ public string? CreateBy { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
+ public DateTime? CreateDate { get; set; }
+
+ /// <summary>
+ /// 鏈�鍚庝慨鏀规椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ public DateTime? LastupdateDate { get; set; }
+
+ /// <summary>
+ /// 鏈�鍚庝慨鏀逛汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ public string? LastupdateBy { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_CHECK_BY")]
+ public string? ErpCheckBy { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_CHECK_DATE")]
+ public string? ErpCheckDate { get; set; }
+
+ /// <summary>
+ /// ERP鐨処D鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN_K3ID")]
+ public long? EbelnK3id { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_DATE")]
+ public DateTime? CheckDate { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_BY")]
+ public string? CheckBy { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_FALG")]
+ public int? CheckFalg { get; set; }
+
+ /// <summary>
+ /// 鎵撳嵃娆℃暟
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK1")]
+ public string? Remark1 { get; set; }
+
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�2
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK2")]
+ public string? Remark2 { get; set; }
+
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�3
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK3")]
+ public string? Remark3 { get; set; }
+
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�4
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK4")]
+ public string? Remark4 { get; set; }
+
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�5
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK5")]
+ public string? Remark5 { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "CHANGEREASON")]
+ public string? Changereason { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+ public string? Factory { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+ public string? Company { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "Prearrivaldate")]
+ public DateTime? Prearrivaldate { get; set; }
+
+ /// <summary>
+ /// 鏀舵枡缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "ReceiveOrgId")]
+ public string? ReceiveOrgId { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "Provider_Id")]
+ public string? ProviderId { get; set; }
+
+ /// <summary>
+ /// 鑱旂郴浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "anred")]
+ public string? Anred { get; set; }
+
+ /// <summary>
+ /// 鐢佃瘽
+ /// </summary>
+ [SugarColumn(ColumnName = "telf1")]
+ public string? Telf1 { get; set; }
+
+ /// <summary>
+ /// 鍥哄畾鐢佃瘽
+ /// </summary>
+ [SugarColumn(ColumnName = "Fixed_Telephone")]
+ public string? FixedTelephone { get; set; }
+
+ /// <summary>
+ /// 閫氳鍦板潃
+ /// </summary>
+ [SugarColumn(ColumnName = "Address")]
+ public string? Address { get; set; }
+
+ /// <summary>
+ /// 楠屾敹鏂瑰紡
+ /// </summary>
+ [SugarColumn(ColumnName = "Acctype")]
+ public string? Acctype { get; set; }
+}
\ No newline at end of file
--
Gitblit v1.9.3