From 72bfac507775d1c76906ed23c9ccd7ca28549525 Mon Sep 17 00:00:00 2001
From: hao <1836460075@qq.com>
Date: 星期二, 19 八月 2025 11:05:34 +0800
Subject: [PATCH] 直接调拨申请委外类型字段
---
StandardInterface/MES.Service/Modes/Womcab.cs | 593 ++++++++++++++++++++++++++++++----------------------------
1 files changed, 307 insertions(+), 286 deletions(-)
diff --git a/StandardInterface/MES.Service/Modes/Womcab.cs b/StandardInterface/MES.Service/Modes/Womcab.cs
index 50ccc1f..df73f80 100644
--- a/StandardInterface/MES.Service/Modes/Womcab.cs
+++ b/StandardInterface/MES.Service/Modes/Womcab.cs
@@ -1,292 +1,313 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 宸ュ崟瀛愯〃
-/// </summary>
-[SugarTable("WOMCAB")]
-public class Womcab
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using SqlSugar;
+namespace MES.Service.Modes
{
/// <summary>
- /// 鑷鍒�
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
- OracleSequenceName = "SEQ_CAB")]
- public decimal? Id { get; set; }
+ /// 浠诲姟鍗曠墿鏂欒〃
+ ///</summary>
+ [SugarTable("WOMCAB")]
+ public class Womcab
+ {
+ /// <summary>
+ /// 鑷鍒�
+ ///</summary>
+ [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true, OracleSequenceName = "SEQ_CAB")]
+ public decimal Id { get; set; }
+ /// <summary>
+ /// 鐢熶骇鐢ㄦ枡娓呭崟琛屽唴鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="ERPID" )]
+ public decimal? Erpid { get; set; }
+ /// <summary>
+ /// 宸ュ崟鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="CAB001" )]
+ public string Cab001 { get; set; }
+ /// <summary>
+ /// 搴忓彿
+ ///</summary>
+ [SugarColumn(ColumnName="CAB002" )]
+ public string 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 decimal? Cab014 { get; set; }
+ /// <summary>
+ /// 鐢熶骇璁㈠崟琛屽唴鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="PID" )]
+ public decimal? Pid { get; set; }
+ /// <summary>
+ /// 鐢熶骇璁㈠崟琛屽唴鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="EID" )]
+ public decimal? 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 decimal? Numerator { get; set; }
+ /// <summary>
+ /// 鍒嗘瘝
+ ///</summary>
+ [SugarColumn(ColumnName="DENOMINATOR" )]
+ public decimal? Denominator { get; set; }
+ /// <summary>
+ /// 鍥哄畾鎹熻��
+ ///</summary>
+ [SugarColumn(ColumnName="SCRAPQTY" )]
+ public decimal? Scrapqty { get; set; }
+ /// <summary>
+ /// 鍙樺姩鎹熻�楃巼
+ ///</summary>
+ [SugarColumn(ColumnName="SCRAPRATE" )]
+ public decimal? Scraprate { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="SALES_ORDER" )]
+ public string SalesOrder { get; set; }
+ /// <summary>
+ /// 闇�姹傚崟鎹�
+ ///</summary>
+ [SugarColumn(ColumnName="F_WWC_TEXT1" )]
+ public string FWwcText1 { get; set; }
+ /// <summary>
+ /// 璁″垝瀹屽伐鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="F_WWC_DATE" )]
+ public DateTime? FWwcDate { get; set; }
+ /// <summary>
+ /// 鏃х墿鏂欑紪鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="F_WWC_BASEPROPERTY" )]
+ public string FWwcBaseproperty { get; set; }
+ /// <summary>
+ /// 浣跨敤姣斾緥
+ ///</summary>
+ [SugarColumn(ColumnName="FUSERATE" )]
+ public decimal? Fuserate { get; set; }
+ /// <summary>
+ /// 瀛愰」绫诲瀷 1鏍囧噯浠� 2杩旇繕浠� 3鏇夸唬浠�
+ ///</summary>
+ [SugarColumn(ColumnName="FMATERIALTYPE" )]
+ public decimal? Fmaterialtype { get; set; }
+ /// <summary>
+ /// 瀛愰」鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="FUNITID3" )]
+ public string Funitid3 { get; set; }
+ /// <summary>
+ /// 瀛愰」鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="FUNITID2" )]
+ public string Funitid2 { get; set; }
+ /// <summary>
+ /// 鐢熶骇閫氱煡鍗�
+ ///</summary>
+ [SugarColumn(ColumnName="F_XIFG_BASE_RE5" )]
+ public string FXifgBaseRe5 { get; set; }
+ /// <summary>
+ /// 璐т富绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="FOWNERTYPEID" )]
+ public string Fownertypeid { get; set; }
+ /// <summary>
+ /// ERP鐢熶骇璁㈠崟鍒嗗綍鍐呯爜 -- 濮斿鏂板
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_PRODUCTION_ENTRY_CODE" )]
+ public string ErpProductionEntryCode { get; set; }
+ /// <summary>
+ /// 鐢ㄦ枡娓呭崟澶囨敞 -- 濮斿鏂板
+ ///</summary>
+ [SugarColumn(ColumnName="FMEMO" )]
+ public string Fmemo { get; set; }
+ /// <summary>
+ /// 棰勭暀绫诲瀷 -- 濮斿鏂板
+ ///</summary>
+ [SugarColumn(ColumnName="FRESERVETYPE" )]
+ public string Freservetype { get; set; }
+ /// <summary>
+ /// 闇�姹傛棩鏈� -- 濮斿鏂板
+ ///</summary>
+ [SugarColumn(ColumnName="FNEEDDATE" )]
+ public DateTime? Fneeddate { get; set; }
+ /// <summary>
+ /// 搴撳瓨鐘舵�� -- 濮斿鏂板
+ ///</summary>
+ [SugarColumn(ColumnName="FSTOCKSTATUSID" )]
+ public string Fstockstatusid { get; set; }
+ /// <summary>
+ /// 鎷ㄥ嚭浠撳簱 -- 濮斿鏂板
+ ///</summary>
+ [SugarColumn(ColumnName="FSRCTRANSSTOCKID" )]
+ public string Fsrctransstockid { get; set; }
+ /// <summary>
+ /// 鎷ㄥ嚭缁勭粐 -- 濮斿鏂板
+ ///</summary>
+ [SugarColumn(ColumnName="FSRCTRANSORGID" )]
+ public string Fsrctransorgid { get; set; }
+ /// <summary>
+ /// 鏄惁鍏抽敭浠� -- 濮斿鏂板
+ ///</summary>
+ [SugarColumn(ColumnName="FISKEYCOMPONENT" )]
+ public string Fiskeycomponent { get; set; }
+ /// <summary>
+ /// 鏄惁鍙戞崯鑰� -- 濮斿鏂板
+ ///</summary>
+ [SugarColumn(ColumnName="FISGETSCRAP" )]
+ public string Fisgetscrap { get; set; }
+ /// <summary>
+ /// 鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="WR_F_XIFG_BASE_83G" )]
+ public string WrFXifgBase83g { get; set; }
+ /// <summary>
+ /// 鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="WR_F_XIFG_BASE_QTR" )]
+ public string WrFXifgBaseQtr { get; set; }
+ /// <summary>
+ /// 鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="TYPEB" )]
+ public string Typeb { get; set; }
+ /// <summary>
+ /// 瀛愰」绫诲瀷 1鏍囧噯浠� 2杩旇繕浠� 3鏇夸唬浠�
+ ///</summary>
+ [SugarColumn(ColumnName="MATERIAL_TYPE" )]
+ public string MaterialType { get; set; }
+ /// <summary>
+ /// 浣跨敤姣斾緥锛�%锛�
+ ///</summary>
+ [SugarColumn(ColumnName="USE_RATE" )]
+ public decimal? UseRate { get; set; }
+ /// <summary>
+ /// 椤规鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="FREPLACEGROUP" )]
+ public decimal? Freplacegroup { get; set; }
+ /// <summary>
+ /// 搴斿彂鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="MUST_QTY" )]
+ public decimal? MustQty { get; set; }
+ /// <summary>
+ /// 鏈鏁�
+ ///</summary>
+ [SugarColumn(ColumnName="WLSL" )]
+ public string Wlsl { get; set; }
- /// <summary>
- /// ERPID
- /// </summary>
- [SugarColumn(ColumnName = "ERPID")]
- public decimal? Erpid { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡浠ｇ爜
+ ///</summary>
+ [SugarColumn(ColumnName = "KHWLBM")]
+ public string Khwlbm { get; set; }
- /// <summary>
- /// 鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "CAB001")]
- public string? Cab001 { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName = "KHWLMC")]
+ public string Khwlmc { get; set; }
- /// <summary>
- /// 搴忓彿
- /// </summary>
- [SugarColumn(ColumnName = "CAB002")]
- public string? Cab002 { get; set; }
+ /// <summary>
+ /// 闇�姹傜粍缁�
+ ///</summary>
+ [SugarColumn(ColumnName = "XQZZ")]
+ public string Xqzz { 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 decimal? Pid { get; set; }
-
- /// <summary>
- /// ERP澶碔D
- /// </summary>
- [SugarColumn(ColumnName = "EID")]
- public decimal? 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>
- /// 渚涘簲绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "SUPPLY_TYPE")]
- public string? SupplyType { get; set; }
-
- /// <summary>
- /// 鍒嗗瓙
- /// </summary>
- [SugarColumn(ColumnName = "NUMERATOR")]
- public decimal? Numerator { get; set; }
-
- /// <summary>
- /// 鍒嗘瘝
- /// </summary>
- [SugarColumn(ColumnName = "DENOMINATOR")]
- public decimal? Denominator { get; set; }
-
- /// <summary>
- /// 鍥哄畾鎹熻��
- /// </summary>
- [SugarColumn(ColumnName = "SCRAPQTY")]
- public decimal? SCRAPQTY { get; set; }
-
- /// <summary>
- /// 鍙樺姩鎹熻�楃巼
- /// </summary>
- [SugarColumn(ColumnName = "SCRAPRATE")]
- public decimal? SCRAPRATE { get; set; }
-
-
- /// <summary>
- /// 搴斿彂鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "Must_Qty")]
- public decimal? MustQty { get; set; }
-
- /// <summary>
- /// 椤规鍙�
- /// </summary>
- [SugarColumn(ColumnName = "FREPLACEGROUP")]
- public int? Freplacegroup { 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; }
-
- /// <summary>
- /// A锛屽垱寤� B锛屽鏍镐腑 C锛屽凡瀹℃牳 D锛岄噸鏂板鏍� Z锛屾殏瀛�
- /// </summary>
- [SugarColumn(ColumnName = "TYPEB")]
- public string? Typeb { get; set; }
-
-
- /// <summary>
- /// A锛屽垱寤� B锛屽鏍镐腑 C锛屽凡瀹℃牳 D锛岄噸鏂板鏍� Z锛屾殏瀛�
- /// </summary>
- [SugarColumn(ColumnName = "WR_F_XIFG_BASE_QTR")]
- public string? WR_F_XIFG_Base_qtr { get; set; }
-
- /// <summary>
- /// A锛屽垱寤� B锛屽鏍镐腑 C锛屽凡瀹℃牳 D锛岄噸鏂板鏍� Z锛屾殏瀛�
- /// </summary>
- [SugarColumn(ColumnName = "WR_F_XIFG_BASE_83G")]
- public string? WR_F_XIFG_Base_83g { get; set; }
-
-
- /////----濮斿鏂板
-
- /// <summary>
- /// 鏄惁鍙戞崯鑰� -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FISGETSCRAP")]
- public string? Fisgetscrap { get; set; }
-
- /// <summary>
- /// 鏄惁鍏抽敭浠� -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FISKEYCOMPONENT")]
- public string? Fiskeycomponent { get; set; }
-
- /// <summary>
- /// 鎷ㄥ嚭缁勭粐 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FSRCTRANSORGID")]
- public string? Fsrctransorgid { get; set; }
-
- /// <summary>
- /// 鎷ㄥ嚭浠撳簱 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FSRCTRANSSTOCKID")]
- public string? Fsrctransstockid { get; set; }
-
- /// <summary>
- /// 搴撳瓨鐘舵�� -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FSTOCKSTATUSID")]
- public string? Fstockstatusid { get; set; }
-
- /// <summary>
- /// 闇�姹傛棩鏈� -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FNEEDDATE")]
- public DateTime? Fneeddate { get; set; }
-
- /// <summary>
- /// 棰勭暀绫诲瀷 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FRESERVETYPE")]
- public string? Freservetype { get; set; }
-
- /// <summary>
- /// 鐢ㄦ枡娓呭崟澶囨敞 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FMEMO")]
- public string? Fmemo { get; set; }
-
- /// <summary>
- /// ERP鐢熶骇璁㈠崟鍒嗗綍鍐呯爜 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
- public string? ErpProductionEntryCode { get; set; }
-
- /// <summary>
- /// 璐т富绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "FOWNERTYPEID")]
- public string? FOWNERTYPEID { get; set; }
-
- /// <summary>
- /// 鐢熶骇閫氱煡鍗�
- /// </summary>
- [SugarColumn(ColumnName = "F_XIFG_BASE_RE5")]
- public string? F_XIFG_BASE_RE5 { get; set; }
-
- /// <summary>
- /// 瀛愰」鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "FUNITID2")]
- public string? FUNITID2 { get; set; }
-
- /// <summary>
- /// 瀛愰」鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "FUNITID3")]
- public string? FUNITID3 { get; set; }
-}
\ No newline at end of file
+ /// <summary>
+ /// 闇�姹傞儴闂�
+ ///</summary>
+ [SugarColumn(ColumnName = "XQBM")]
+ public string Xqbm { get; set; }
+ /// <summary>
+ /// 鏀舵枡缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "SLZZ")]
+ public string Slzz { get; set; }
+ /// <summary>
+ /// 鏀舵枡閮ㄩ棬
+ ///</summary>
+ [SugarColumn(ColumnName = "SLBM")]
+ public string Slbm { get; set; }
+ }
+}
--
Gitblit v1.9.3