From 47d3c9e31edd16c02e3c74ff45e9772f9ca550b2 Mon Sep 17 00:00:00 2001
From: zyf <1071160500@qq.com>
Date: 星期三, 28 五月 2025 19:26:49 +0800
Subject: [PATCH] 采购申请和BOM接口
---
MES.Service/Modes/Womdaa.cs | 375 +++++++++++++++++++++++++++++++++++------------------
1 files changed, 245 insertions(+), 130 deletions(-)
diff --git a/MES.Service/Modes/Womdaa.cs b/MES.Service/Modes/Womdaa.cs
index 8f613a1..a5cad76 100644
--- a/MES.Service/Modes/Womdaa.cs
+++ b/MES.Service/Modes/Womdaa.cs
@@ -11,222 +11,337 @@
/// <summary>
/// 鑷鍒�
/// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, IsIdentity = true)]
- public decimal Id { get; set; }
-
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal? Id { get; set; }
/// <summary>
- /// PID
- /// </summary>
+ /// 鎺掍骇ID
+ ///</summary>
[SugarColumn(ColumnName = "PID")]
public decimal? Pid { get; set; }
-
/// <summary>
- /// 鍗曞彿
- /// </summary>
+ /// 鍗曞彿
+ ///</summary>
[SugarColumn(ColumnName = "DAA001")]
- public string? Daa001 { get; set; }
-
+ public string Daa001 { get; set; }
/// <summary>
- /// 浜у搧缂栫爜
- /// </summary>
+ /// 浜у搧ID
+ ///</summary>
[SugarColumn(ColumnName = "DAA002")]
- public string? Daa002 { get; set; }
-
+ public string Daa002 { get; set; }
/// <summary>
- /// 浜у搧鍚嶇О
- /// </summary>
+ /// 浜у搧鍚嶇О
+ ///</summary>
[SugarColumn(ColumnName = "DAA003")]
- public string? Daa003 { get; set; }
-
+ public string Daa003 { get; set; }
/// <summary>
- /// 浜у搧瑙勬牸
- /// </summary>
+ /// 浜у搧瑙勬牸
+ ///</summary>
[SugarColumn(ColumnName = "DAA004")]
- public string? Daa004 { get; set; }
-
+ public string Daa004 { get; set; }
/// <summary>
- /// 鍗曚綅
- /// </summary>
+ /// 鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "DAA005")]
- public string? Daa005 { get; set; }
-
+ public string Daa005 { get; set; }
/// <summary>
- /// 棰勮寮�宸ユ椂闂�
- /// </summary>
+ /// ERP棰勮寮�宸ユ椂闂�
+ ///</summary>
[SugarColumn(ColumnName = "DAA006")]
public DateTime? Daa006 { get; set; }
-
/// <summary>
- /// 棰勮瀹屽伐鏃堕棿
- /// </summary>
+ /// ERP棰勮瀹屽伐鏃堕棿
+ ///</summary>
[SugarColumn(ColumnName = "DAA007")]
public DateTime? Daa007 { get; set; }
-
/// <summary>
- /// 宸ュ崟鏁伴噺
- /// </summary>
+ /// 宸ュ崟鏁伴噺
+ ///</summary>
[SugarColumn(ColumnName = "DAA008")]
public decimal? Daa008 { get; set; }
-
/// <summary>
- /// 澶囨敞
- /// </summary>
+ /// 澶囨敞
+ ///</summary>
[SugarColumn(ColumnName = "DAA009")]
- public string? Daa009 { get; set; }
-
+ public string Daa009 { get; set; }
/// <summary>
- /// 鍏ュ簱鏁伴噺
- /// </summary>
+ /// 鍏ュ簱鏁伴噺
+ ///</summary>
[SugarColumn(ColumnName = "DAA010")]
public decimal? Daa010 { get; set; }
-
/// <summary>
- /// 宸茬敓浜ч噺
- /// </summary>
+ /// 宸茬敓浜ч噺
+ ///</summary>
[SugarColumn(ColumnName = "DAA011")]
public decimal? Daa011 { get; set; }
-
/// <summary>
- /// 鎶ュ簾鏁伴噺
- /// </summary>
+ /// 鎶ュ簾鏁伴噺
+ ///</summary>
[SugarColumn(ColumnName = "DAA012")]
public decimal? Daa012 { get; set; }
-
/// <summary>
- /// 宸ヤ綔杞﹂棿
- /// </summary>
+ /// 宸ヤ綔杞﹂棿
+ ///</summary>
[SugarColumn(ColumnName = "DAA013")]
- public string? Daa013 { get; set; }
-
+ public string Daa013 { get; set; }
/// <summary>
- /// 鎶曟枡鍗曞崟鍙�
- /// </summary>
+ /// 鎶曟枡鍗曞崟鍙�
+ ///</summary>
[SugarColumn(ColumnName = "DAA014")]
- public string? Daa014 { get; set; }
-
+ public string Daa014 { get; set; }
/// <summary>
- /// 鐢熶骇绾垮埆
- /// </summary>
+ /// 鐢熶骇绾垮埆
+ ///</summary>
[SugarColumn(ColumnName = "DAA015")]
- public string? Daa015 { get; set; }
-
+ public string Daa015 { get; set; }
/// <summary>
- /// 瀹為檯寮�宸ユ棩
- /// </summary>
+ /// 瀹為檯寮�宸ユ棩
+ ///</summary>
[SugarColumn(ColumnName = "DAA016")]
public DateTime? Daa016 { get; set; }
-
/// <summary>
- /// 瀹為檯瀹屽伐鏃�
- /// </summary>
+ /// 瀹為檯瀹屽伐鏃�
+ ///</summary>
[SugarColumn(ColumnName = "DAA017")]
public DateTime? Daa017 { get; set; }
-
/// <summary>
- /// 宸ュ崟鐘舵��
- /// </summary>
+ /// 宸ュ崟鐘舵��
+ ///</summary>
[SugarColumn(ColumnName = "DAA018")]
- public string? Daa018 { get; set; }
-
+ public string Daa018 { get; set; }
/// <summary>
- /// 榻愬鐘舵��
- /// </summary>
+ /// 榻愬鐘舵��
+ ///</summary>
[SugarColumn(ColumnName = "DAA019")]
- public string? Daa019 { get; set; }
-
+ public string Daa019 { get; set; }
/// <summary>
- /// 瀹℃牳鐮�
- /// </summary>
+ /// 瀹℃牳鐮�
+ ///</summary>
[SugarColumn(ColumnName = "FSTATUS")]
public decimal? Fstatus { get; set; }
-
/// <summary>
- /// 瀹℃牳鏃ユ湡
- /// </summary>
+ /// 瀹℃牳鏃ユ湡
+ ///</summary>
[SugarColumn(ColumnName = "CHECK_DATE")]
public DateTime? CheckDate { get; set; }
-
/// <summary>
- /// 瀹℃牳浜�
- /// </summary>
+ /// 瀹℃牳浜�
+ ///</summary>
[SugarColumn(ColumnName = "CHECK_USER")]
- public string? CheckUser { get; set; }
-
+ public string CheckUser { get; set; }
/// <summary>
- /// 绾垮埆缂栫爜
- /// </summary>
+ /// 绾垮埆缂栫爜
+ ///</summary>
[SugarColumn(ColumnName = "DAA020")]
- public string? Daa020 { get; set; }
-
+ public string Daa020 { get; set; }
/// <summary>
- /// 浠诲姟鍗曞崟鍙�
- /// </summary>
+ /// 浠诲姟鍗曞崟鍙�
+ ///</summary>
[SugarColumn(ColumnName = "DAA021")]
- public string? Daa021 { get; set; }
-
+ public string Daa021 { get; set; }
/// <summary>
- /// 閫氱煡澶囨枡锛�0-鏈�氱煡锛�1-閫氱煡
- /// </summary>
+ /// 閫氱煡澶囨枡锛�0-鏈�氱煡锛�1-閫氱煡
+ ///</summary>
[SugarColumn(ColumnName = "DAA022")]
public decimal? Daa022 { get; set; }
-
/// <summary>
- /// 鐢熶骇搴忓彿
- /// </summary>
+ /// 鐢熶骇搴忓彿
+ ///</summary>
[SugarColumn(ColumnName = "DAA023")]
public decimal? Daa023 { get; set; }
-
/// <summary>
- /// 鎺掍骇鏃ユ湡
- /// </summary>
+ /// 鎺掍骇鏃ユ湡
+ ///</summary>
[SugarColumn(ColumnName = "DAA024")]
- public string? Daa024 { get; set; }
-
+ public string Daa024 { get; set; }
/// <summary>
- /// 棣栦欢鏄惁妫�楠�1-妫�楠岋紝0鏈楠�
- /// </summary>
+ /// 棣栦欢鏄惁妫�楠�1-妫�楠岋紝0鏈楠�
+ ///</summary>
[SugarColumn(ColumnName = "DAA025")]
- public string? Daa025 { get; set; }
-
+ public string Daa025 { get; set; }
/// <summary>
- /// 棣栦欢妫�楠岀粨鏋�
- /// </summary>
+ /// 棣栦欢妫�楠岀粨鏋�
+ ///</summary>
[SugarColumn(ColumnName = "DAA026")]
- public string? Daa026 { get; set; }
-
+ public string Daa026 { get; set; }
/// <summary>
- /// 宸叉姤妫�锛�0-鏈姤妫�锛�1-宸叉姤妫�
- /// </summary>
+ /// 宸叉姤妫�锛�0-鏈姤妫�锛�1-宸叉姤妫�
+ ///</summary>
[SugarColumn(ColumnName = "IS_REPORTCHECK")]
public decimal? IsReportcheck { get; set; }
-
/// <summary>
- /// 鎶ユ浜�
- /// </summary>
+ /// 鎶ユ浜�
+ ///</summary>
[SugarColumn(ColumnName = "USNAME")]
- public string? Usname { get; set; }
-
+ public string Usname { get; set; }
/// <summary>
- /// 鎶ユ鏃堕棿
- /// </summary>
+ /// 鎶ユ鏃堕棿
+ ///</summary>
[SugarColumn(ColumnName = "REPORTTIME")]
public DateTime? Reporttime { get; set; }
-
/// <summary>
- /// 鏈哄彴缂栧彿
- /// </summary>
+ /// 鏈哄彴缂栧彿
+ ///</summary>
[SugarColumn(ColumnName = "MACHINE_NO")]
- public string? MachineNo { get; set; }
-
+ public string MachineNo { get; set; }
/// <summary>
- /// 澶囨枡瀹屾垚1-瀹屾垚锛�0鏈畬鎴�
- /// </summary>
+ /// 澶囨枡瀹屾垚1-瀹屾垚锛�0鏈畬鎴�
+ ///</summary>
[SugarColumn(ColumnName = "DAA027")]
public decimal? Daa027 { get; set; }
-
/// <summary>
- /// 澶囨枡瀹屾垚鏃堕棿
- /// </summary>
+ /// 澶囨枡瀹屾垚鏃堕棿
+ ///</summary>
[SugarColumn(ColumnName = "DAA028")]
- public string? Daa028 { get; set; }
+ public string Daa028 { get; set; }
+ /// <summary>
+ /// 鏍囧噯宸ユ椂
+ ///</summary>
+ [SugarColumn(ColumnName = "PROD_HOUR")]
+ public decimal? ProdHour { get; set; }
+ /// <summary>
+ /// 鍗曚汉灏忔椂浜ц兘
+ ///</summary>
+ [SugarColumn(ColumnName = "PERSON_HOUR_CAPACITY")]
+ public decimal? PersonHourCapacity { get; set; }
+ /// <summary>
+ /// 鐞嗚鏍囦骇
+ ///</summary>
+ [SugarColumn(ColumnName = "THE_CAPACITY")]
+ public decimal? TheCapacity { get; set; }
+ /// <summary>
+ /// 璁″垝鐢ㄤ汉鏁�
+ ///</summary>
+ [SugarColumn(ColumnName = "PLAN_PERSONNEL")]
+ public decimal? PlanPersonnel { get; set; }
+ /// <summary>
+ /// 璁″垝鏍囧噯浜ц兘
+ ///</summary>
+ [SugarColumn(ColumnName = "PLAN_CAPACITY")]
+ public decimal? PlanCapacity { get; set; }
+ /// <summary>
+ /// 鐞嗚鐢ㄦ椂/M
+ ///</summary>
+ [SugarColumn(ColumnName = "THE_MIN")]
+ public decimal? TheMin { get; set; }
+ /// <summary>
+ /// 鐞嗚鐢ㄦ椂/H
+ ///</summary>
+ [SugarColumn(ColumnName = "THE_HOUR")]
+ public decimal? TheHour { get; set; }
+ /// <summary>
+ /// 绾夸綋绫诲埆
+ ///</summary>
+ [SugarColumn(ColumnName = "LINE_TYPE")]
+ public string LineType { get; set; }
+ /// <summary>
+ /// 鏍囧噯浜烘暟
+ ///</summary>
+ [SugarColumn(ColumnName = "PERSONNEL")]
+ public decimal? Personnel { get; set; }
+ /// <summary>
+ /// 鎹㈢嚎鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "CHANGE_LINE_TIME")]
+ public decimal? ChangeLineTime { get; set; }
+ /// <summary>
+ /// 浼戞伅鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "REST_TIME")]
+ public decimal? RestTime { get; set; }
+ /// <summary>
+ /// 鎺掍骇搴忓彿
+ ///</summary>
+ [SugarColumn(ColumnName = "SCHEDULE_ORDER")]
+ public decimal? ScheduleOrder { get; set; }
+ /// <summary>
+ /// MES棰勮寮�宸ユ椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName = "MES_START_PROD")]
+ public DateTime? MesStartProd { get; set; }
+ /// <summary>
+ /// MES棰勮瀹屽伐鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "MES_END_PROD")]
+ public DateTime? MesEndProd { get; set; }
+ /// <summary>
+ /// 鎺掍骇鎺ㄩ�佹爣璇�
+ ///</summary>
+ [SugarColumn(ColumnName = "PRODTS")]
+ public decimal? Prodts { get; set; }
+ /// <summary>
+ /// 棰勮澶囨枡鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "PREPARE_TIME")]
+ public DateTime? PrepareTime { get; set; }
+ /// <summary>
+ /// 鎻掍欢鎶曞叆浜烘暟
+ ///</summary>
+ [SugarColumn(ColumnName = "CJ_WORKER")]
+ public decimal? CjWorker { get; set; }
+ /// <summary>
+ /// 鎻掍欢璁″垝鎶曞叆浜烘暟
+ ///</summary>
+ [SugarColumn(ColumnName = "P_CJ_WORKER")]
+ public decimal? PCjWorker { get; set; }
+ /// <summary>
+ /// 鎻掍欢鏃ヤ骇閲�
+ ///</summary>
+ [SugarColumn(ColumnName = "CJ_DAILY_OUT")]
+ public decimal? CjDailyOut { get; set; }
+ /// <summary>
+ /// 鎻掍欢鏍囧噯宸ユ椂
+ ///</summary>
+ [SugarColumn(ColumnName = "CJ_STD_HOUR")]
+ public decimal? CjStdHour { get; set; }
+ /// <summary>
+ /// 閿＄剨鎶曞叆浜烘暟
+ ///</summary>
+ [SugarColumn(ColumnName = "HX_WORKER")]
+ public decimal? HxWorker { get; set; }
+ /// <summary>
+ /// 閿＄剨璁″垝鎶曞叆浜烘暟
+ ///</summary>
+ [SugarColumn(ColumnName = "P_HX_WORKER")]
+ public decimal? PHxWorker { get; set; }
+ /// <summary>
+ /// 閿＄剨鏃ヤ骇閲�
+ ///</summary>
+ [SugarColumn(ColumnName = "HX_DAILY_OUT")]
+ public decimal? HxDailyOut { get; set; }
+ /// <summary>
+ /// 閿＄剨鏍囧噯宸ユ椂
+ ///</summary>
+ [SugarColumn(ColumnName = "HX_STD_HOUR")]
+ public decimal? HxStdHour { get; set; }
+ /// <summary>
+ /// 鎻掍欢鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "CJ_NUM")]
+ public decimal? CjNum { get; set; }
+ /// <summary>
+ /// 瀹㈡埛
+ ///</summary>
+ [SugarColumn(ColumnName = "CUST")]
+ public string Cust { get; set; }
+ /// <summary>
+ /// 鎬昏宸ュ簭 1鎵撴爣 4鍔犲伐 2缁勮 3鍖呰
+ ///</summary>
+ [SugarColumn(ColumnName = "ZZ_GX")]
+ public decimal? ZzGx { get; set; }
+ /// <summary>
+ /// 閫氱煡澶囨枡鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA029")]
+ public DateTime? Daa029 { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗曞彿锛堢洰鍓嶄笁妤煎琛ヤ娇鐢級
+ ///</summary>
+ [SugarColumn(ColumnName = "XSDDH")]
+ public string Xsddh { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "TEST")]
+ public decimal? Test { get; set; }
+
}
\ No newline at end of file
--
Gitblit v1.9.3