From 554fa8ad99c42b6c0e3ed2c56358a3d7dd9ded6e Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期五, 13 十二月 2024 14:11:45 +0800
Subject: [PATCH] 11

---
 MES.Service/Modes/Womcab.cs |  325 ++++++++++++++++++++++++++++++-----------------------
 1 files changed, 184 insertions(+), 141 deletions(-)

diff --git a/MES.Service/Modes/Womcab.cs b/MES.Service/Modes/Womcab.cs
index 320f88b..46ec80d 100644
--- a/MES.Service/Modes/Womcab.cs
+++ b/MES.Service/Modes/Womcab.cs
@@ -1,206 +1,249 @@
-锘縰sing System;
-using System.Collections.Generic;
-using System.Linq;
-using SqlSugar;
+锘縰sing SqlSugar;
 
 namespace MES.Service.Modes;
 
 /// <summary>
-/// 浠诲姟鍗曠墿鏂欒〃
-///</summary>
+///     浠诲姟鍗曠墿鏂欒〃bom
+/// </summary>
 [SugarTable("WOMCAB")]
 public class Womcab
 {
-    /// <summary>
-    ///     鑷鍒�
-    /// </summary>
-    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
-        OracleSequenceName = "SEQ_AOI")]
-    public decimal? Id { get; set; }
+ /// <summary>
+ ///     榛樿鍊�: (newid())
+ /// </summary>
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+    public Guid Guid { get; set; }
 
-    /// <summary>
-    /// ERPID 
-    ///</summary>
-    [SugarColumn(ColumnName = "ERPID")]
-    public decimal? Erpid { get; set; }
+ /// <summary>
+ ///     ERPID
+ /// </summary>
+ [SugarColumn(ColumnName = "ERPID")]
+    public int? Erpid { get; set; }
 
-    /// <summary>
-    /// 宸ュ崟鍗曞彿 
-    ///</summary>
-    [SugarColumn(ColumnName = "CAB001")]
+ /// <summary>
+ ///     宸ュ崟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CAB001")]
     public string Cab001 { get; set; }
 
-    /// <summary>
-    /// 搴忓彿 
-    ///</summary>
-    [SugarColumn(ColumnName = "CAB002")]
-    public string Cab002 { get; set; }
+ /// <summary>
+ ///     搴忓彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CAB002")]
+    public int? Cab002 { get; set; }
 
-    /// <summary>
-    /// 鏉愭枡缂栫爜 
-    ///</summary>
-    [SugarColumn(ColumnName = "CAB003")]
+ /// <summary>
+ ///     鏉愭枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "CAB003")]
     public string Cab003 { get; set; }
 
-    /// <summary>
-    /// 闇�棰嗙敤閲� 
-    ///</summary>
-    [SugarColumn(ColumnName = "CAB006")]
+ /// <summary>
+ ///     闇�棰嗙敤閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "CAB006")]
     public decimal? Cab006 { get; set; }
 
-    /// <summary>
-    /// 宸查鐢ㄩ噺 
-    ///</summary>
-    [SugarColumn(ColumnName = "CAB007")]
+ /// <summary>
+ ///     宸查鐢ㄩ噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CAB007")]
     public decimal? Cab007 { get; set; }
 
-    /// <summary>
-    /// 宸ヨ壓 
-    ///</summary>
-    [SugarColumn(ColumnName = "CAB008")]
+ /// <summary>
+ ///     宸ヨ壓
+ /// </summary>
+ [SugarColumn(ColumnName = "CAB008")]
     public string Cab008 { get; set; }
 
-    /// <summary>
-    /// 鍗曚綅 
-    ///</summary>
-    [SugarColumn(ColumnName = "CAB009")]
+ /// <summary>
+ ///     鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "CAB009")]
     public string Cab009 { get; set; }
 
-    /// <summary>
-    /// 缁勬垚鐢ㄩ噺 
-    ///</summary>
-    [SugarColumn(ColumnName = "CAB012")]
+ /// <summary>
+ ///     缁勬垚鐢ㄩ噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CAB012")]
     public decimal? Cab012 { get; set; }
 
-    /// <summary>
-    /// 鏄惁鏇挎枡 
-    ///</summary>
-    [SugarColumn(ColumnName = "CAB014")]
+ /// <summary>
+ ///     鏄惁鏇挎枡
+ /// </summary>
+ [SugarColumn(ColumnName = "CAB014")]
     public string Cab014 { get; set; }
 
-    /// <summary>
-    /// PID 
-    ///</summary>
-    [SugarColumn(ColumnName = "PID")]
-    public decimal? Pid { get; set; }
+ /// <summary>
+ ///     PID
+ /// </summary>
+ [SugarColumn(ColumnName = "PID")]
+    public int? Pid { get; set; }
 
-    /// <summary>
-    /// ERP澶碔D 
-    ///</summary>
-    [SugarColumn(ColumnName = "EID")]
-    public decimal? Eid { get; set; }
+ /// <summary>
+ ///     ERP澶碔D
+ /// </summary>
+ [SugarColumn(ColumnName = "EID")]
+    public int? Eid { get; set; }
 
-    /// <summary>
-    /// 浣嶇疆鍙� 
-    ///</summary>
-    [SugarColumn(ColumnName = "POSITION_NO")]
+ /// <summary>
+ ///     浣嶇疆鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "POSITION_NO")]
     public string PositionNo { get; set; }
 
-    /// <summary>
-    /// 鍙戞枡缁勭粐 
-    ///</summary>
-    [SugarColumn(ColumnName = "ISSUING_ORGANIZATION")]
+ /// <summary>
+ ///     鍙戞枡缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "ISSUING_ORGANIZATION")]
     public string IssuingOrganization { get; set; }
 
-    /// <summary>
-    /// 渚涘簲缁勭粐 
-    ///</summary>
-    [SugarColumn(ColumnName = "SUPPLY_ORGANIZATION")]
+ /// <summary>
+ ///     渚涘簲缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPPLY_ORGANIZATION")]
     public string SupplyOrganization { get; set; }
 
-    /// <summary>
-    /// 璐т富 
-    ///</summary>
-    [SugarColumn(ColumnName = "OWNER_ID")]
+ /// <summary>
+ ///     璐т富
+ /// </summary>
+ [SugarColumn(ColumnName = "OWNER_ID")]
     public string OwnerId { get; set; }
 
-    /// <summary>
-    /// 璁″垝璺熻釜鍙� 
-    ///</summary>
-    [SugarColumn(ColumnName = "MTONO")]
+ /// <summary>
+ ///     璁″垝璺熻釜鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "MTONO")]
     public string Mtono { get; set; }
 
-    /// <summary>
-    /// 鎵瑰彿 
-    ///</summary>
-    [SugarColumn(ColumnName = "LOT")]
+ /// <summary>
+ ///     鎵瑰彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT")]
     public string Lot { get; set; }
 
-    /// <summary>
-    /// 浠撳簱 
-    ///</summary>
-    [SugarColumn(ColumnName = "DEPOT_CODE")]
+ /// <summary>
+ ///     浠撳簱
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_CODE")]
     public string DepotCode { get; set; }
 
-    /// <summary>
-    /// 鍙戞枡鏂瑰紡 
-    ///</summary>
-    [SugarColumn(ColumnName = "ISSUE_TYPE")]
+ /// <summary>
+ ///     鍙戞枡鏂瑰紡
+ /// </summary>
+ [SugarColumn(ColumnName = "ISSUE_TYPE")]
     public string IssueType { get; set; }
 
-    /// <summary>
-    /// 渚涘簲绫诲瀷(C閲囪喘 Z鑷埗 W濮斿) 
-    ///</summary>
-    [SugarColumn(ColumnName = "SUPPLY_TYPE")]
+ /// <summary>
+ ///     渚涘簲绫诲瀷(C閲囪喘 Z鑷埗 W濮斿)
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPPLY_TYPE")]
     public string SupplyType { get; set; }
 
-    /// <summary>
-    /// 鍒嗗瓙 
-    ///</summary>
-    [SugarColumn(ColumnName = "NUMERATOR")]
+ /// <summary>
+ ///     鍒嗗瓙
+ /// </summary>
+ [SugarColumn(ColumnName = "NUMERATOR")]
     public string Numerator { get; set; }
 
-    /// <summary>
-    /// 鍒嗘瘝 
-    ///</summary>
-    [SugarColumn(ColumnName = "DENOMINATOR")]
+ /// <summary>
+ ///     鍒嗘瘝
+ /// </summary>
+ [SugarColumn(ColumnName = "DENOMINATOR")]
     public string Denominator { get; set; }
 
-    /// <summary>
-    /// 鍥哄畾鎹熻�� 
-    ///</summary>
-    [SugarColumn(ColumnName = "SCRAPQTY")]
+ /// <summary>
+ ///     鍥哄畾鎹熻��
+ /// </summary>
+ [SugarColumn(ColumnName = "SCRAPQTY")]
     public string Scrapqty { get; set; }
 
-    /// <summary>
-    /// 鍙樺姩鎹熻�楃巼 
-    ///</summary>
-    [SugarColumn(ColumnName = "SCRAPRATE")]
+ /// <summary>
+ ///     鍙樺姩鎹熻�楃巼
+ /// </summary>
+ [SugarColumn(ColumnName = "SCRAPRATE")]
     public string Scraprate { get; set; }
 
-    /// <summary>
-    /// 瀹㈡埛璐у彿 
-    ///</summary>
-    [SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")]
+ /// <summary>
+ ///     瀹㈡埛璐у彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")]
     public string CustomerItemNumber { get; set; }
 
-    /// <summary>
-    /// 鍖呰鍗曞彿 
-    ///</summary>
-    [SugarColumn(ColumnName = "PACKING_LIST_NUMBER")]
+ /// <summary>
+ ///     鍖呰鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "PACKING_LIST_NUMBER")]
     public string PackingListNumber { get; set; }
 
-    /// <summary>
-    /// 涓讳骇鍝� 
-    ///</summary>
-    [SugarColumn(ColumnName = "MAIN_PRODUCT")]
+ /// <summary>
+ ///     涓讳骇鍝�
+ /// </summary>
+ [SugarColumn(ColumnName = "MAIN_PRODUCT")]
     public string MainProduct { get; set; }
 
-    /// <summary>
-    /// 涓讳骇鍝佹暟閲� 
-    ///</summary>
-    [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")]
-    public decimal? MainProductQty { get; set; }
+ /// <summary>
+ ///     涓讳骇鍝佹暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")]
+    public int? MainProductQty { get; set; }
 
-    /// <summary>
-    /// 鐖堕」鐗╂枡鍚嶇О 
-    ///</summary>
-    [SugarColumn(ColumnName = "PARENT_ITEM_NAME")]
+ /// <summary>
+ ///     鐖堕」鐗╂枡鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "PARENT_ITEM_NAME")]
     public string ParentItemName { get; set; }
 
-    /// <summary>
-    /// 閿�鍞鍗� 
-    ///</summary>
-    [SugarColumn(ColumnName = "FSALEORDERNO")]
+ /// <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