From fcd41558f0e07ea4c082a1b5e073686d91e09505 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 20 十一月 2024 09:26:54 +0800
Subject: [PATCH] 委外订单接口
---
MES.Service/Modes/Womcaa.cs | 215 +++++++++++++++++++++++++++++++++++++----------------
1 files changed, 148 insertions(+), 67 deletions(-)
diff --git a/MES.Service/Modes/Womcaa.cs b/MES.Service/Modes/Womcaa.cs
index 869e76a..697634d 100644
--- a/MES.Service/Modes/Womcaa.cs
+++ b/MES.Service/Modes/Womcaa.cs
@@ -9,33 +9,31 @@
public class Womcaa
{
/// <summary>
- /// 鑷鍒� SEQ_AOI
+ /// 榛樿鍊�: (newid())
/// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
- OracleSequenceName = "SEQ_AOI")]
- public decimal? Id { get; set; }
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
/// <summary>
/// ERPID
/// </summary>
[SugarColumn(ColumnName = "ERPID")]
- public decimal? Erpid { get; set; }
+ public int? Erpid { get; set; }
/// <summary>
- /// 鍗曞彿
+ /// 鍗曟嵁缂栧彿
/// </summary>
[SugarColumn(ColumnName = "CAA001")]
public string? Caa001 { get; set; }
/// <summary>
- /// 鍗曟嵁绫诲瀷 1銆佺洿鎺ュ叆搴�-鏅�氱敓浜� SCDD03_SYS2銆佺洿鎺ュ叆搴�-杩斿伐鐢熶骇 SCDD04_SYS3銆佸伐搴忔眹鎶�-鏅�氱敓浜�
- /// SCDD01_SYS4銆佸伐搴忔眹鎶�-杩斿伐鐢熶骇 SCDD02_SYS
+ /// 鍗曟嵁绫诲瀷("1銆佺洿鎺ュ叆搴�-鏅�氱敓浜� 2銆佺洿鎺ュ叆搴�-杩斿伐鐢熶骇 3銆佸伐搴忔眹鎶�-鏅�氱敓浜� 4銆佸伐搴忔眹鎶�-杩斿伐鐢熶骇")
/// </summary>
[SugarColumn(ColumnName = "CAA004")]
public string? Caa004 { get; set; }
/// <summary>
- /// 寮�鍗曟棩鏈�
+ /// 璁″垝涓嬭揪鏃ユ湡
/// </summary>
[SugarColumn(ColumnName = "CAA005")]
public string? Caa005 { get; set; }
@@ -65,7 +63,7 @@
public string? Caa011 { get; set; }
/// <summary>
- /// 鏁伴噺
+ /// 宸ュ崟鏁伴噺
/// </summary>
[SugarColumn(ColumnName = "CAA012")]
public decimal? Caa012 { get; set; }
@@ -76,11 +74,11 @@
[SugarColumn(ColumnName = "CAA013")]
public string? Caa013 { get; set; }
- /// <summary>
- /// 閿�鍞鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "CAA015")]
- public string? Caa015 { get; set; }
+ // /// <summary>
+ // /// 閿�鍞鍗曞彿
+ // /// </summary>
+ // [SugarColumn(ColumnName = "CAA015")]
+ // public string? Caa015 { get; set; }
/// <summary>
/// 澶囨敞
@@ -89,31 +87,31 @@
public string? Caa016 { get; set; }
/// <summary>
- /// 宸叉帓鏁伴噺
+ /// 宸叉帓鏁伴噺锛堝純鐢級
/// </summary>
[SugarColumn(ColumnName = "CAA017")]
- public decimal? Caa017 { get; set; }
+ public int? Caa017 { get; set; }
/// <summary>
- /// ERP婧愬崟ID
+ /// ERP鐢熶骇璁㈠崟ID
/// </summary>
[SugarColumn(ColumnName = "CAA018")]
- public decimal? Caa018 { get; set; }
+ public int? Caa018 { get; set; }
/// <summary>
- /// ERP婧愬崟琛屽彿
+ /// ERP鐢熶骇璁㈠崟搴忓彿
/// </summary>
[SugarColumn(ColumnName = "CAA019")]
- public decimal? Caa019 { get; set; }
+ public int? Caa019 { get; set; }
/// <summary>
- /// ERP婧愬崟鍗曞彿(浠诲姟鍗曞彿)
+ /// ERP鐢熶骇璁㈠崟鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "CAA020")]
public string? Caa020 { get; set; }
/// <summary>
- /// 宸ヤ綔杞﹂棿
+ /// 鐢熶骇杞﹂棿
/// </summary>
[SugarColumn(ColumnName = "CAA021")]
public string? Caa021 { get; set; }
@@ -122,7 +120,7 @@
/// 瀹℃牳鐮�
/// </summary>
[SugarColumn(ColumnName = "FSTATUS")]
- public decimal? Fstatus { get; set; }
+ public int? Fstatus { get; set; }
/// <summary>
/// 瀹℃牳鏃ユ湡
@@ -137,13 +135,13 @@
public string? CheckUser { get; set; }
/// <summary>
- /// 鏈帓鏁伴噺
+ /// 鏈帓鏁伴噺锛堝純鐢級
/// </summary>
[SugarColumn(ColumnName = "CAA022")]
- public decimal? Caa022 { get; set; }
+ public int? Caa022 { get; set; }
/// <summary>
- /// 鐘舵�� 瀹屽伐锛屾湭瀹屽伐
+ /// 涓氬姟鐘舵��("1锛岃鍒掞紝2銆佽鍒掔‘璁� 2銆佷笅杈� 4銆佸紑宸� 5銆佸畬宸� 6銆佺粨妗堬紝7銆佺粨绠�")
/// </summary>
[SugarColumn(ColumnName = "CAA023")]
public string? Caa023 { get; set; }
@@ -152,7 +150,7 @@
/// 宸插叆搴撴暟閲�
/// </summary>
[SugarColumn(ColumnName = "CAA024")]
- public decimal? Caa024 { get; set; }
+ public int? Caa024 { get; set; }
/// <summary>
/// 宸ヨ壓璺嚎
@@ -203,123 +201,206 @@
public string? StockInlimitl { 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 = "CAA015_HEAD")]
- public string? Caa015Head { get; set; }
+ // /// <summary>
+ // /// 寮曠敤鍗曞彿
+ // /// </summary>
+ // [SugarColumn(ColumnName = "CAA015_HEAD")]
+ // public string? Caa015Head { get; set; }
/// <summary>
- /// 鐢熸垚鏂瑰紡
+ /// 鍒跺崟绫诲瀷
/// </summary>
[SugarColumn(ColumnName = "CREATE_TYPE")]
public string? CreateType { get; set; }
/// <summary>
- /// 婧愬崟绫诲瀷
+ /// 鏉ユ簮鍗曟嵁绫诲瀷
/// </summary>
[SugarColumn(ColumnName = "SRC_BILL_TYPE")]
public string? SrcBillType { get; set; }
/// <summary>
- /// 婧愬崟缂栧彿
+ /// 鏉ユ簮鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "SRC_BILL_NO")]
public string? SrcBillNo { get; set; }
/// <summary>
- /// 婧愬崟鍒嗗綍琛屽彿
+ /// 鏉ユ簮琛屽彿
/// </summary>
[SugarColumn(ColumnName = "SRC_BILLENTRYSEQ")]
public string? SrcBillentryseq { get; set; }
/// <summary>
- /// 闇�姹傚崟鎹彿
+ /// 閿�鍞鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "SALE_ORDER_NO")]
public string? SaleOrderNo { get; set; }
/// <summary>
- /// 闇�姹傚崟鎹鍙�
+ /// 閿�鍞鍗曡鍙�
/// </summary>
[SugarColumn(ColumnName = "SALE_ORDER_ENTRYSEQ")]
public string? SaleOrderEntryseq { get; set; }
/// <summary>
- /// 缁撴浜�
+ /// 寮哄埗鍏抽棴浜�
/// </summary>
[SugarColumn(ColumnName = "FORCE_CLOSERID")]
public string? ForceCloserid { get; set; }
/// <summary>
- /// 缁撴绫诲瀷
+ /// 鍏抽棴绫诲瀷
/// </summary>
[SugarColumn(ColumnName = "CLOSE_TYPE")]
public string? CloseType { get; set; }
/// <summary>
- /// 婧愭媶鍒嗚鍗曠紪鍙�
+ /// 鍒嗗崟鍙�
/// </summary>
[SugarColumn(ColumnName = "SRC_SPLIT_BILLNO")]
public string? SrcSplitBillno { get; set; }
-
/// <summary>
- /// 鐢熶骇缁勭粐ID
+ /// 鏄惁绠℃帶
/// </summary>
[SugarColumn(ColumnName = "ERP_SCZZ")]
- public string? EerSczz { get; set; }
+ public int? ErpSczz { get; set; }
/// <summary>
- /// 濮旀墭缁勭粐ID
+ /// 鏄惁濮旀墭
/// </summary>
[SugarColumn(ColumnName = "ERP_WTZZ")]
- public string? EerWtzz { get; set; }
+ public int? ErpWtzz { get; set; }
+
+ // /// <summary>
+ // /// </summary>
+ // [SugarColumn(ColumnName = "MAIN_PRODUCT_NO")]
+ // public string? MainProductNo { get; set; }
+
+ // /// <summary>
+ // /// </summary>
+ // [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")]
+ // public int? MainProductQty { 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 = "CUSTOMER_NAME")]
+ // public string? CustomerName { get; set; }
+
+ // /// <summary>
+ // /// </summary>
+ // [SugarColumn(ColumnName = "CUSTOMER")]
+ // public string? Customer { get; set; }
/// <summary>
- /// 涓讳骇鍝佺紪鐮�
/// </summary>
- [SugarColumn(ColumnName = "MAIN_PRODUCT_NO")]
- public string? MainProductNo { get; set; }
+ [SugarColumn(ColumnName = "TYPE")]
+ public string? Type { get; set; }
/// <summary>
- /// 涓讳骇鍝佺敓浜ф暟閲�
/// </summary>
- [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")]
- public string? MainProductQty { get; set; }
+ [SugarColumn(ColumnName = "JA_BS")]
+ public string? JaBs { get; set; }
/// <summary>
- /// 瀹㈡埛璐у彿
/// </summary>
- [SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")]
- public string? CustomerItemNumber { get; set; }
+ [SugarColumn(ColumnName = "JA_TIME")]
+ public DateTime? JaTime { get; set; }
/// <summary>
- /// 鍖呰鍗曞彿
/// </summary>
- [SugarColumn(ColumnName = "PACKING_LIST_NUMBER")]
- public string? PackingListNumber { get; set; }
+ [SugarColumn(ColumnName = "YP_NUM")]
+ public int? YpNum { get; set; }
/// <summary>
- /// 瀹㈡埛鍚嶇О
+ /// 棰勮瀹屽伐鏃堕棿澶囦唤
/// </summary>
- [SugarColumn(ColumnName = "CUSTOMER_NAME")]
- public string? CustomerName { get; set; }
+ [SugarColumn(ColumnName = "CAA011_1")]
+ public string? Caa0111 { get; set; }
/// <summary>
- /// 瀹㈡埛
/// </summary>
- [SugarColumn(ColumnName = "CUSTOMER")]
- public string? Customer { get; set; }
+ [SugarColumn(ColumnName = "ERP_GYZZ")]
+ public int? ErpGyzz { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_FLZZ")]
+ public int? ErpFlzz { get; set; }
+
+ /// <summary>
+ /// 鏄惁鍏ュ簱
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_SLZZ")]
+ public int? ErpSlzz { get; set; }
+
+ /// <summary>
+ /// 鏄惁閫�搴�
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_RKZZ")]
+ public int? ErpRkzz { get; set; }
+
+ /// <summary>
+ /// 鏄惁鎹㈣揣
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_RKHZ")]
+ public int? ErpRkhz { get; set; }
+
+ /// <summary>
+ /// 鏄惁瀵勫敭
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_JJDS")]
+ public int? ErpJjds { get; set; }
+
+ /// <summary>
+ /// 鏄惁鎸夋
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_BZDS")]
+ public int? ErpBzds { get; set; }
+
+ /// <summary>
+ /// 鏄惁鏂板缓
+ /// </summary>
+ [SugarColumn(ColumnName = "CAA025")]
+ public int? Caa025 { get; set; }
+
+ /// <summary>
+ /// 閲囪喘璁㈠崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "FPURORDERNO")]
+ public string? Fpurorderno { get; set; }
+
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "FPURORDERENTRYSEQ")]
+ public string? Fpurorderentryseq { get; set; }
+
+ /// <summary>
+ /// 澶囨敞锛堣〃浣擄級
+ /// </summary>
+ [SugarColumn(ColumnName = "Btbz")]
+ public string? Btbz { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3