From e2988c27cb7e250d8834e3097b4821c7dbff6b64 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 31 十二月 2024 13:01:20 +0800
Subject: [PATCH] 1
---
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