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/Womcab.cs |  454 ++++++++++++++++++++++++++++++--------------------------
 1 files changed, 245 insertions(+), 209 deletions(-)

diff --git a/entity/Womcab.cs b/entity/Womcab.cs
index b3d9d77..59cf490 100644
--- a/entity/Womcab.cs
+++ b/entity/Womcab.cs
@@ -1,213 +1,249 @@
 锘縰sing SqlSugar;
 
-namespace NewPdaSqlServer.entity
+namespace NewPdaSqlServer.entity;
+
+/// <summary>
+///     浠诲姟鍗曠墿鏂欒〃bom
+/// </summary>
+[SugarTable("WOMCAB")]
+public class Womcab
 {
     /// <summary>
-    /// 浠诲姟鍗曠墿鏂欒〃
-    ///</summary>
-    [SugarTable("WOMCAB")]
-    public class Womcab
-    {
-        /// <summary>
-        ///  
-        /// 榛樿鍊�: (newid())
-        ///</summary>
-         [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true   )]
-         public Guid Guid { get; set; }
-        /// <summary>
-        /// ERPID 
-        ///</summary>
-         [SugarColumn(ColumnName="ERPID"    )]
-         public int? Erpid { get; set; }
-        /// <summary>
-        /// 宸ュ崟鍗曞彿 
-        ///</summary>
-         [SugarColumn(ColumnName="CAB001"    )]
-         public string Cab001 { get; set; }
-        /// <summary>
-        /// 搴忓彿 
-        ///</summary>
-         [SugarColumn(ColumnName="CAB002"    )]
-         public int? Cab002 { get; set; }
-        /// <summary>
-        /// 鏉愭枡缂栫爜 
-        ///</summary>
-         [SugarColumn(ColumnName="CAB003"    )]
-         public string Cab003 { get; set; }
-        /// <summary>
-        /// 闇�棰嗙敤閲� 
-        ///</summary>
-         [SugarColumn(ColumnName="CAB006"    )]
-         public decimal? Cab006 { get; set; }
-        /// <summary>
-        /// 宸查鐢ㄩ噺 
-        ///</summary>
-         [SugarColumn(ColumnName="CAB007"    )]
-         public decimal? Cab007 { get; set; }
-        /// <summary>
-        /// 宸ヨ壓 
-        ///</summary>
-         [SugarColumn(ColumnName="CAB008"    )]
-         public string Cab008 { get; set; }
-        /// <summary>
-        /// 鍗曚綅 
-        ///</summary>
-         [SugarColumn(ColumnName="CAB009"    )]
-         public string Cab009 { get; set; }
-        /// <summary>
-        /// 缁勬垚鐢ㄩ噺 
-        ///</summary>
-         [SugarColumn(ColumnName="CAB012"    )]
-         public decimal? Cab012 { get; set; }
-        /// <summary>
-        /// 鏄惁鏇挎枡 
-        ///</summary>
-         [SugarColumn(ColumnName="CAB014"    )]
-         public string Cab014 { get; set; }
-        /// <summary>
-        /// PID 
-        ///</summary>
-         [SugarColumn(ColumnName="PID"    )]
-         public int? Pid { get; set; }
-        /// <summary>
-        /// ERP澶碔D 
-        ///</summary>
-         [SugarColumn(ColumnName="EID"    )]
-         public int? Eid { get; set; }
-        /// <summary>
-        /// 浣嶇疆鍙� 
-        ///</summary>
-         [SugarColumn(ColumnName="POSITION_NO"    )]
-         public string PositionNo { get; set; }
-        /// <summary>
-        /// 鍙戞枡缁勭粐 
-        ///</summary>
-         [SugarColumn(ColumnName="ISSUING_ORGANIZATION"    )]
-         public string IssuingOrganization { get; set; }
-        /// <summary>
-        /// 渚涘簲缁勭粐 
-        ///</summary>
-         [SugarColumn(ColumnName="SUPPLY_ORGANIZATION"    )]
-         public string SupplyOrganization { get; set; }
-        /// <summary>
-        /// 璐т富 
-        ///</summary>
-         [SugarColumn(ColumnName="OWNER_ID"    )]
-         public string OwnerId { get; set; }
-        /// <summary>
-        /// 璁″垝璺熻釜鍙� 
-        ///</summary>
-         [SugarColumn(ColumnName="MTONO"    )]
-         public string Mtono { get; set; }
-        /// <summary>
-        /// 鎵瑰彿 
-        ///</summary>
-         [SugarColumn(ColumnName="LOT"    )]
-         public string Lot { get; set; }
-        /// <summary>
-        /// 浠撳簱 
-        ///</summary>
-         [SugarColumn(ColumnName="DEPOT_CODE"    )]
-         public string DepotCode { get; set; }
-        /// <summary>
-        /// 鍙戞枡鏂瑰紡 
-        ///</summary>
-         [SugarColumn(ColumnName="ISSUE_TYPE"    )]
-         public string IssueType { get; set; }
-        /// <summary>
-        /// 渚涘簲绫诲瀷(C閲囪喘 Z鑷埗 W濮斿) 
-        ///</summary>
-         [SugarColumn(ColumnName="SUPPLY_TYPE"    )]
-         public string SupplyType { get; set; }
-        /// <summary>
-        /// 鍒嗗瓙 
-        ///</summary>
-         [SugarColumn(ColumnName="NUMERATOR"    )]
-         public string Numerator { get; set; }
-        /// <summary>
-        /// 鍒嗘瘝 
-        ///</summary>
-         [SugarColumn(ColumnName="DENOMINATOR"    )]
-         public string Denominator { get; set; }
-        /// <summary>
-        /// 鍥哄畾鎹熻�� 
-        ///</summary>
-         [SugarColumn(ColumnName="SCRAPQTY"    )]
-         public string Scrapqty { get; set; }
-        /// <summary>
-        /// 鍙樺姩鎹熻�楃巼 
-        ///</summary>
-         [SugarColumn(ColumnName="SCRAPRATE"    )]
-         public string Scraprate { get; set; }
-        /// <summary>
-        /// 瀹㈡埛璐у彿 
-        ///</summary>
-         [SugarColumn(ColumnName="CUSTOMER_ITEM_NUMBER"    )]
-         public string CustomerItemNumber { get; set; }
-        /// <summary>
-        /// 鍖呰鍗曞彿 
-        ///</summary>
-         [SugarColumn(ColumnName="PACKING_LIST_NUMBER"    )]
-         public string PackingListNumber { get; set; }
-        /// <summary>
-        /// 涓讳骇鍝� 
-        ///</summary>
-         [SugarColumn(ColumnName="MAIN_PRODUCT"    )]
-         public string MainProduct { get; set; }
-        /// <summary>
-        /// 涓讳骇鍝佹暟閲� 
-        ///</summary>
-         [SugarColumn(ColumnName="MAIN_PRODUCT_QTY"    )]
-         public int? MainProductQty { get; set; }
-        /// <summary>
-        /// 鐖堕」鐗╂枡鍚嶇О 
-        ///</summary>
-         [SugarColumn(ColumnName="PARENT_ITEM_NAME"    )]
-         public string ParentItemName { get; set; }
-        /// <summary>
-        /// 閿�鍞鍗� 
-        ///</summary>
-         [SugarColumn(ColumnName="FSALEORDERNO"    )]
-         public string Fsaleorderno { get; set; }
-        /// <summary>
-        /// 璐т富绫诲瀷 
-        ///</summary>
-         [SugarColumn(ColumnName="FOWNERTYPEID"    )]
-         public string Fownertypeid { get; set; }
-        /// <summary>
-        /// 椤规鍙� 
-        ///</summary>
-         [SugarColumn(ColumnName="FREPLACEGROUP"    )]
-         public int? Freplacegroup { get; set; }
-        /// <summary>
-        /// 閿�鍞鍗曞彿 
-        ///</summary>
-         [SugarColumn(ColumnName="ERP_XSDDH"    )]
-         public string ErpXsddh { get; set; }
-        /// <summary>
-        /// 瀛愰」绫诲瀷 
-        ///</summary>
-         [SugarColumn(ColumnName="FMATERIALTYPE"    )]
-         public string Fmaterialtype { get; set; }
-        /// <summary>
-        ///  
-        ///</summary>
-         [SugarColumn(ColumnName="FUNITID"    )]
-         public string Funitid { get; set; }
-        /// <summary>
-        /// 搴斿彂鏁伴噺 
-        ///</summary>
-         [SugarColumn(ColumnName="Must_Qty"    )]
-         public decimal? MustQty { get; set; }
-        /// <summary>
-        /// 浣跨敤姣斾緥锛�%锛� 
-        ///</summary>
-         [SugarColumn(ColumnName="Use_Rate"    )]
-         public decimal? UseRate { get; set; }
-        /// <summary>
-        /// 瀛愰」绫诲瀷 1鏍囧噯浠� 2杩旇繕浠� 3鏇夸唬浠� 
-        ///</summary>
-         [SugarColumn(ColumnName="Material_Type"    )]
-         public string MaterialType { get; set; }
-    }
-}
+    ///     榛樿鍊�: (newid())
+    /// </summary>
+    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+    public Guid Guid { get; set; }
+
+    /// <summary>
+    ///     ERPID
+    /// </summary>
+    [SugarColumn(ColumnName = "ERPID")]
+    public int? Erpid { get; set; }
+
+    /// <summary>
+    ///     宸ュ崟鍗曞彿
+    /// </summary>
+    [SugarColumn(ColumnName = "CAB001")]
+    public string Cab001 { get; set; }
+
+    /// <summary>
+    ///     搴忓彿
+    /// </summary>
+    [SugarColumn(ColumnName = "CAB002")]
+    public int? Cab002 { get; set; }
+
+    /// <summary>
+    ///     鏉愭枡缂栫爜
+    /// </summary>
+    [SugarColumn(ColumnName = "CAB003")]
+    public string Cab003 { get; set; }
+
+    /// <summary>
+    ///     闇�棰嗙敤閲�
+    /// </summary>
+    [SugarColumn(ColumnName = "CAB006")]
+    public decimal? Cab006 { get; set; }
+
+    /// <summary>
+    ///     宸查鐢ㄩ噺
+    /// </summary>
+    [SugarColumn(ColumnName = "CAB007")]
+    public decimal? Cab007 { get; set; }
+
+    /// <summary>
+    ///     宸ヨ壓
+    /// </summary>
+    [SugarColumn(ColumnName = "CAB008")]
+    public string Cab008 { get; set; }
+
+    /// <summary>
+    ///     鍗曚綅
+    /// </summary>
+    [SugarColumn(ColumnName = "CAB009")]
+    public string Cab009 { get; set; }
+
+    /// <summary>
+    ///     缁勬垚鐢ㄩ噺
+    /// </summary>
+    [SugarColumn(ColumnName = "CAB012")]
+    public decimal? Cab012 { get; set; }
+
+    /// <summary>
+    ///     鏄惁鏇挎枡
+    /// </summary>
+    [SugarColumn(ColumnName = "CAB014")]
+    public string Cab014 { get; set; }
+
+    /// <summary>
+    ///     PID
+    /// </summary>
+    [SugarColumn(ColumnName = "PID")]
+    public int? Pid { get; set; }
+
+    /// <summary>
+    ///     ERP澶碔D
+    /// </summary>
+    [SugarColumn(ColumnName = "EID")]
+    public int? Eid { get; set; }
+
+    /// <summary>
+    ///     浣嶇疆鍙�
+    /// </summary>
+    [SugarColumn(ColumnName = "POSITION_NO")]
+    public string PositionNo { get; set; }
+
+    /// <summary>
+    ///     鍙戞枡缁勭粐
+    /// </summary>
+    [SugarColumn(ColumnName = "ISSUING_ORGANIZATION")]
+    public string IssuingOrganization { get; set; }
+
+    /// <summary>
+    ///     渚涘簲缁勭粐
+    /// </summary>
+    [SugarColumn(ColumnName = "SUPPLY_ORGANIZATION")]
+    public string SupplyOrganization { get; set; }
+
+    /// <summary>
+    ///     璐т富
+    /// </summary>
+    [SugarColumn(ColumnName = "OWNER_ID")]
+    public string OwnerId { get; set; }
+
+    /// <summary>
+    ///     璁″垝璺熻釜鍙�
+    /// </summary>
+    [SugarColumn(ColumnName = "MTONO")]
+    public string Mtono { get; set; }
+
+    /// <summary>
+    ///     鎵瑰彿
+    /// </summary>
+    [SugarColumn(ColumnName = "LOT")]
+    public string Lot { get; set; }
+
+    /// <summary>
+    ///     浠撳簱
+    /// </summary>
+    [SugarColumn(ColumnName = "DEPOT_CODE")]
+    public string DepotCode { get; set; }
+
+    /// <summary>
+    ///     鍙戞枡鏂瑰紡 1銆佺洿鎺ラ鏂欙紱2銆佺洿鎺ュ�掑啿锛�3銆佽皟鎷ㄩ鏂欙紱4銆佽皟鎷ㄥ埌鍐诧紱7銆佷笉鍙戞枡
+    /// </summary>
+    [SugarColumn(ColumnName = "ISSUE_TYPE")]
+    public string IssueType { get; set; }
+
+    /// <summary>
+    ///     渚涘簲绫诲瀷(C閲囪喘 Z鑷埗 W濮斿)
+    /// </summary>
+    [SugarColumn(ColumnName = "SUPPLY_TYPE")]
+    public string SupplyType { get; set; }
+
+    /// <summary>
+    ///     鍒嗗瓙
+    /// </summary>
+    [SugarColumn(ColumnName = "NUMERATOR")]
+    public string Numerator { get; set; }
+
+    /// <summary>
+    ///     鍒嗘瘝
+    /// </summary>
+    [SugarColumn(ColumnName = "DENOMINATOR")]
+    public string Denominator { get; set; }
+
+    /// <summary>
+    ///     鍥哄畾鎹熻��
+    /// </summary>
+    [SugarColumn(ColumnName = "SCRAPQTY")]
+    public string Scrapqty { get; set; }
+
+    /// <summary>
+    ///     鍙樺姩鎹熻�楃巼
+    /// </summary>
+    [SugarColumn(ColumnName = "SCRAPRATE")]
+    public string Scraprate { get; set; }
+
+    /// <summary>
+    ///     瀹㈡埛璐у彿
+    /// </summary>
+    [SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")]
+    public string CustomerItemNumber { get; set; }
+
+    /// <summary>
+    ///     鍖呰鍗曞彿
+    /// </summary>
+    [SugarColumn(ColumnName = "PACKING_LIST_NUMBER")]
+    public string PackingListNumber { get; set; }
+
+    /// <summary>
+    ///     涓讳骇鍝�
+    /// </summary>
+    [SugarColumn(ColumnName = "MAIN_PRODUCT")]
+    public string MainProduct { get; set; }
+
+    /// <summary>
+    ///     涓讳骇鍝佹暟閲�
+    /// </summary>
+    [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")]
+    public int? MainProductQty { get; set; }
+
+    /// <summary>
+    ///     鐖堕」鐗╂枡鍚嶇О
+    /// </summary>
+    [SugarColumn(ColumnName = "PARENT_ITEM_NAME")]
+    public string ParentItemName { get; set; }
+
+    /// <summary>
+    ///     閿�鍞鍗�
+    /// </summary>
+    [SugarColumn(ColumnName = "FSALEORDERNO")]
+    public string Fsaleorderno { get; set; }
+
+    /// <summary>
+    ///     璐т富绫诲瀷
+    /// </summary>
+    [SugarColumn(ColumnName = "FOWNERTYPEID")]
+    public string Fownertypeid { get; set; }
+
+    /// <summary>
+    ///     椤规鍙�
+    /// </summary>
+    [SugarColumn(ColumnName = "FREPLACEGROUP")]
+    public int? Freplacegroup { get; set; }
+
+    /// <summary>
+    ///     閿�鍞鍗曞彿
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_XSDDH")]
+    public string ErpXsddh { get; set; }
+
+    /// <summary>
+    ///     瀛愰」绫诲瀷
+    /// </summary>
+    [SugarColumn(ColumnName = "FMATERIALTYPE")]
+    public string Fmaterialtype { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "FUNITID")]
+    public string Funitid { get; set; }
+
+    /// <summary>
+    ///     搴斿彂鏁伴噺
+    /// </summary>
+    [SugarColumn(ColumnName = "Must_Qty")]
+    public decimal? MustQty { get; set; }
+
+    /// <summary>
+    ///     浣跨敤姣斾緥锛�%锛�
+    /// </summary>
+    [SugarColumn(ColumnName = "Use_Rate")]
+    public decimal? UseRate { get; set; }
+
+    /// <summary>
+    ///     瀛愰」绫诲瀷 1鏍囧噯浠� 2杩旇繕浠� 3鏇夸唬浠�
+    /// </summary>
+    [SugarColumn(ColumnName = "Material_Type")]
+    public string MaterialType { get; set; }
+}
\ No newline at end of file

--
Gitblit v1.9.3