From a376d24964db749ed38a5873d2e6aaa1b82b2e83 Mon Sep 17 00:00:00 2001
From: sjz <1240968267@qq.com>
Date: 星期四, 13 二月 2025 18:04:41 +0800
Subject: [PATCH] 调取plm接口 返回文件流给前端
---
MES.Service/Modes/Womcaa.cs | 181 ++++++++++++++++++++++++++++++++++++---------
1 files changed, 144 insertions(+), 37 deletions(-)
diff --git a/MES.Service/Modes/Womcaa.cs b/MES.Service/Modes/Womcaa.cs
index e6e2a2d..cde91ba 100644
--- a/MES.Service/Modes/Womcaa.cs
+++ b/MES.Service/Modes/Womcaa.cs
@@ -11,8 +11,7 @@
/// <summary>
/// 鑷鍒� SEQ_AOI
/// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
- OracleSequenceName = "SEQ_AOI")]
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,OracleSequenceName = "SEQ_CAA")]
public decimal? Id { get; set; }
/// <summary>
@@ -25,44 +24,44 @@
/// 鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "CAA001")]
- public string Caa001 { get; set; }
+ public string? Caa001 { get; set; }
/// <summary>
/// 鍗曟嵁绫诲瀷 1銆佺洿鎺ュ叆搴�-鏅�氱敓浜� SCDD03_SYS2銆佺洿鎺ュ叆搴�-杩斿伐鐢熶骇 SCDD04_SYS3銆佸伐搴忔眹鎶�-鏅�氱敓浜�
/// SCDD01_SYS4銆佸伐搴忔眹鎶�-杩斿伐鐢熶骇 SCDD02_SYS
/// </summary>
[SugarColumn(ColumnName = "CAA004")]
- public string Caa004 { get; set; }
+ public string? Caa004 { get; set; }
/// <summary>
/// 寮�鍗曟棩鏈�
/// </summary>
[SugarColumn(ColumnName = "CAA005")]
- public string Caa005 { get; set; }
+ public string? Caa005 { get; set; }
/// <summary>
/// 浜у搧缂栫爜
/// </summary>
[SugarColumn(ColumnName = "CAA006")]
- public string Caa006 { get; set; }
+ public string? Caa006 { get; set; }
/// <summary>
/// 鍗曚綅
/// </summary>
[SugarColumn(ColumnName = "CAA009")]
- public string Caa009 { get; set; }
+ public string? Caa009 { get; set; }
/// <summary>
/// 棰勮寮�宸ユ椂闂�
/// </summary>
[SugarColumn(ColumnName = "CAA010")]
- public string Caa010 { get; set; }
+ public string? Caa010 { get; set; }
/// <summary>
/// 棰勮瀹屽伐鏃堕棿
/// </summary>
[SugarColumn(ColumnName = "CAA011")]
- public string Caa011 { get; set; }
+ public string? Caa011 { get; set; }
/// <summary>
/// 鏁伴噺
@@ -74,19 +73,19 @@
/// BOM鐗堟
/// </summary>
[SugarColumn(ColumnName = "CAA013")]
- public string Caa013 { get; set; }
+ public string? Caa013 { get; set; }
/// <summary>
/// 閿�鍞鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "CAA015")]
- public string Caa015 { get; set; }
+ public string? Caa015 { get; set; }
/// <summary>
/// 澶囨敞
/// </summary>
[SugarColumn(ColumnName = "CAA016")]
- public string Caa016 { get; set; }
+ public string? Caa016 { get; set; }
/// <summary>
/// 宸叉帓鏁伴噺
@@ -104,19 +103,19 @@
/// ERP婧愬崟琛屽彿
/// </summary>
[SugarColumn(ColumnName = "CAA019")]
- public decimal? Caa019 { get; set; }
+ public string? Caa019 { get; set; }
/// <summary>
/// ERP婧愬崟鍗曞彿(浠诲姟鍗曞彿)
/// </summary>
[SugarColumn(ColumnName = "CAA020")]
- public string Caa020 { get; set; }
+ public string? Caa020 { get; set; }
/// <summary>
/// 宸ヤ綔杞﹂棿
/// </summary>
[SugarColumn(ColumnName = "CAA021")]
- public string Caa021 { get; set; }
+ public string? Caa021 { get; set; }
/// <summary>
/// 瀹℃牳鐮�
@@ -134,7 +133,7 @@
/// 瀹℃牳浜�
/// </summary>
[SugarColumn(ColumnName = "CHECK_USER")]
- public string CheckUser { get; set; }
+ public string? CheckUser { get; set; }
/// <summary>
/// 鏈帓鏁伴噺
@@ -146,7 +145,7 @@
/// 鐘舵�� 瀹屽伐锛屾湭瀹屽伐
/// </summary>
[SugarColumn(ColumnName = "CAA023")]
- public string Caa023 { get; set; }
+ public string? Caa023 { get; set; }
/// <summary>
/// 宸插叆搴撴暟閲�
@@ -158,119 +157,227 @@
/// 宸ヨ壓璺嚎
/// </summary>
[SugarColumn(ColumnName = "ROUTING_ID")]
- public string RoutingId { get; set; }
+ public string? RoutingId { get; set; }
/// <summary>
/// 浜х嚎
/// </summary>
[SugarColumn(ColumnName = "WORK_SHOP_ID")]
- public string WorkShopId { get; set; }
+ public string? WorkShopId { get; set; }
/// <summary>
/// 浠撳簱
/// </summary>
[SugarColumn(ColumnName = "DEPOT_CODE")]
- public string DepotCode { get; set; }
+ public string? DepotCode { get; set; }
/// <summary>
/// 鍗曟嵁鏃ユ湡
/// </summary>
[SugarColumn(ColumnName = "CREATE_DATE")]
- public string CreateDate { get; set; }
+ public string? CreateDate { get; set; }
/// <summary>
/// 璁″垝缁�
/// </summary>
[SugarColumn(ColumnName = "WORK_GROUP_ID")]
- public string WorkGroupId { get; set; }
+ public string? WorkGroupId { get; set; }
/// <summary>
/// 璁″垝鍛�
/// </summary>
[SugarColumn(ColumnName = "PLAN_ID")]
- public string PlanId { get; set; }
+ public string? PlanId { get; set; }
/// <summary>
/// 鍏ュ簱涓婇檺
/// </summary>
[SugarColumn(ColumnName = "STOCK_INLIMITH")]
- public string StockInlimith { get; set; }
+ public string? StockInlimith { get; set; }
/// <summary>
/// 鍏ュ簱涓嬮檺
/// </summary>
[SugarColumn(ColumnName = "STOCK_INLIMITL")]
- public string StockInlimitl { get; set; }
+ public string? StockInlimitl { get; set; }
/// <summary>
/// 璁″垝璺熻釜鍙�
/// </summary>
[SugarColumn(ColumnName = "MTONO")]
- public string Mtono { get; set; }
+ public string? Mtono { get; set; }
/// <summary>
/// 鎵瑰彿
/// </summary>
[SugarColumn(ColumnName = "LOT")]
- public string Lot { get; set; }
+ public string? Lot { get; set; }
/// <summary>
/// 閿�鍞鍗曡鍙�
/// </summary>
[SugarColumn(ColumnName = "CAA015_HEAD")]
- public string Caa015Head { get; set; }
+ public string? Caa015Head { get; set; }
/// <summary>
/// 鐢熸垚鏂瑰紡
/// </summary>
[SugarColumn(ColumnName = "CREATE_TYPE")]
- public string CreateType { get; set; }
+ public string? CreateType { get; set; }
/// <summary>
/// 婧愬崟绫诲瀷
/// </summary>
[SugarColumn(ColumnName = "SRC_BILL_TYPE")]
- public string SrcBillType { get; set; }
+ public string? SrcBillType { get; set; }
/// <summary>
/// 婧愬崟缂栧彿
/// </summary>
[SugarColumn(ColumnName = "SRC_BILL_NO")]
- public string SrcBillNo { get; set; }
+ public string? SrcBillNo { get; set; }
/// <summary>
/// 婧愬崟鍒嗗綍琛屽彿
/// </summary>
[SugarColumn(ColumnName = "SRC_BILLENTRYSEQ")]
- public string SrcBillentryseq { get; set; }
+ public string? SrcBillentryseq { get; set; }
/// <summary>
/// 闇�姹傚崟鎹彿
/// </summary>
[SugarColumn(ColumnName = "SALE_ORDER_NO")]
- public string SaleOrderNo { get; set; }
+ public string? SaleOrderNo { get; set; }
/// <summary>
/// 闇�姹傚崟鎹鍙�
/// </summary>
[SugarColumn(ColumnName = "SALE_ORDER_ENTRYSEQ")]
- public string SaleOrderEntryseq { get; set; }
+ public string? SaleOrderEntryseq { get; set; }
/// <summary>
/// 缁撴浜�
/// </summary>
[SugarColumn(ColumnName = "FORCE_CLOSERID")]
- public string ForceCloserid { get; set; }
+ public string? ForceCloserid { get; set; }
/// <summary>
/// 缁撴绫诲瀷
/// </summary>
[SugarColumn(ColumnName = "CLOSE_TYPE")]
- public string CloseType { get; set; }
+ public string? CloseType { get; set; }
/// <summary>
/// 婧愭媶鍒嗚鍗曠紪鍙�
/// </summary>
[SugarColumn(ColumnName = "SRC_SPLIT_BILLNO")]
- public string SrcSplitBillno { get; set; }
+ public string? SrcSplitBillno { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "PRD_ORG")]
+ public string? PrdOrg { get; set; }
+
+ /// <summary>
+ /// 濮旀墭缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "TRUST_ORG")]
+ public string? TrustOrg { get; set; }
+
+ /// <summary>
+ /// 鍚屾鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "TB_TIME")]
+ public DateTime? TbTime { get; set; }
+
+ /// <summary>
+ /// 缁撴鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "JA_TIME")]
+ public DateTime? JaTime { get; set; }
+
+ /// <summary>
+ /// 缁撴鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "JA_BS")]
+ public string? JaBs { get; set; }
+
+ /// <summary>
+ /// 鏃х墿鏂欑紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_BASEPROPERTY")]
+ public string? F_WWC_BASEPROPERTY { get; set; }
+
+ /// <summary>
+ /// 璁″垝瀹屽伐鎼哄甫鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_DATETIME")]
+ public DateTime? F_WWC_DATETIME { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇鍏ュ簱鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_SCRKRQ")]
+ public DateTime? F_WWC_SCRKRQ { get; set; }
+
+ /// <summary>
+ /// 宸ユ椂
+ /// </summary>
+ [SugarColumn(ColumnName = "FGS")]
+ public decimal? FGS { get; set; }
+
+ /// <summary>
+ /// 浜х嚎浜烘暟
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_DECIMAL")]
+ public decimal? F_WWC_DECIMAL { get; set; }
+
+ /// <summary>
+ /// 绾垮埆
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_XB")]
+ public string? F_WWC_XB { get; set; }
+
+ /// <summary>
+ /// 閿�鍞憳
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_BASE")]
+ public string? F_WWC_BASE { get; set; }
+
+ /// <summary>
+ /// 淇敼鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_XG")]
+ public decimal? IsXg { get; set; }
+
+ /// <summary>
+ /// 濮斿閲囪喘璁㈠崟
+ /// </summary>
+ [SugarColumn(ColumnName = "FPURORDERNO")]
+ public string? FPURORDERNO { get; set; }
+
+ /// <summary>
+ /// 濮斿閲囪喘璁㈠崟
+ /// </summary>
+ [SugarColumn(ColumnName = "FPURORDERENTRYSEQ")]
+ public decimal? FPURORDERENTRYSEQ { get; set; }
+
+ /// <summary>
+ /// 濮斿璁㈠崟鍒嗗綍鍐呯爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FSUBENTRYID")]
+ public decimal? FSUBENTRYID { get; set; }
+
+ /// <summary>
+ /// 濮斿鍏ュ簱鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "FSTOCKINQTY")]
+ public decimal? FSTOCKINQTY { get; set; }
+
+ /// <summary>
+ /// 濮斿鏈叆搴撴暟
+ /// </summary>
+ [SugarColumn(ColumnName = "FNOSTOCKINQTY")]
+ public decimal? FNOSTOCKINQTY { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3