From c9d9aacd884e9d730d47982e7f65ecc1bb836268 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期五, 16 八月 2024 17:54:52 +0800
Subject: [PATCH] 修改三个检验，适配WOMDAA表
---
MES.Service/Modes/Womdaa.cs | 472 +++++++++++++++++++++++++++++++++++------------------------
1 files changed, 280 insertions(+), 192 deletions(-)
diff --git a/MES.Service/Modes/Womdaa.cs b/MES.Service/Modes/Womdaa.cs
index 8f613a1..b6d9bc2 100644
--- a/MES.Service/Modes/Womdaa.cs
+++ b/MES.Service/Modes/Womdaa.cs
@@ -1,232 +1,320 @@
-锘縰sing SqlSugar;
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using SqlSugar;
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 宸ュ崟鎸囦护琛�
-/// </summary>
-[SugarTable("WOMDAA")]
-public class Womdaa
+namespace MES.Service.Modes
{
/// <summary>
- /// 鑷鍒�
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, IsIdentity = true)]
- public decimal Id { get; set; }
+ /// 宸ュ崟鎸囦护琛�
+ ///</summary>
+ [SugarTable("WOMDAA")]
+ public class Womdaa
+ {
+ /// <summary>
+ /// 鑷鍒�
+ ///</summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal? Id { get; set; }
- /// <summary>
- /// PID
- /// </summary>
- [SugarColumn(ColumnName = "PID")]
- public decimal? Pid { get; set; }
+ /// <summary>
+ /// 鎺掍骇ID
+ ///</summary>
+ [SugarColumn(ColumnName = "PID")]
+ public decimal? Pid { get; set; }
- /// <summary>
- /// 鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DAA001")]
- public string? Daa001 { get; set; }
+ /// <summary>
+ /// 鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA001")]
+ public string? Daa001 { get; set; }
- /// <summary>
- /// 浜у搧缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DAA002")]
- public string? Daa002 { get; set; }
+ /// <summary>
+ /// 浜у搧ID
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA002")]
+ public string? Daa002 { get; set; }
- /// <summary>
- /// 浜у搧鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "DAA003")]
- public string? Daa003 { get; set; }
+ /// <summary>
+ /// 浜у搧鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA003")]
+ public string? Daa003 { get; set; }
- /// <summary>
- /// 浜у搧瑙勬牸
- /// </summary>
- [SugarColumn(ColumnName = "DAA004")]
- public string? Daa004 { get; set; }
+ /// <summary>
+ /// 浜у搧瑙勬牸
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA004")]
+ public string? Daa004 { get; set; }
- /// <summary>
- /// 鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "DAA005")]
- public string? Daa005 { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA005")]
+ public string? Daa005 { get; set; }
- /// <summary>
- /// 棰勮寮�宸ユ椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "DAA006")]
- public DateTime? Daa006 { get; set; }
+ /// <summary>
+ /// ERP棰勮寮�宸ユ椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA006")]
+ public DateTime? Daa006 { get; set; }
- /// <summary>
- /// 棰勮瀹屽伐鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "DAA007")]
- public DateTime? Daa007 { get; set; }
+ /// <summary>
+ /// ERP棰勮瀹屽伐鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA007")]
+ public DateTime? Daa007 { get; set; }
- /// <summary>
- /// 宸ュ崟鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DAA008")]
- public decimal? Daa008 { get; set; }
+ /// <summary>
+ /// 宸ュ崟鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA008")]
+ public decimal? Daa008 { get; set; }
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "DAA009")]
- public string? Daa009 { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA009")]
+ public string? Daa009 { get; set; }
- /// <summary>
- /// 鍏ュ簱鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DAA010")]
- public decimal? Daa010 { get; set; }
+ /// <summary>
+ /// 鍏ュ簱鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA010")]
+ public decimal? Daa010 { get; set; }
- /// <summary>
- /// 宸茬敓浜ч噺
- /// </summary>
- [SugarColumn(ColumnName = "DAA011")]
- public decimal? Daa011 { get; set; }
+ /// <summary>
+ /// 宸茬敓浜ч噺
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA011")]
+ public decimal? Daa011 { get; set; }
- /// <summary>
- /// 鎶ュ簾鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DAA012")]
- public decimal? Daa012 { get; set; }
+ /// <summary>
+ /// 鎶ュ簾鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA012")]
+ public decimal? Daa012 { get; set; }
- /// <summary>
- /// 宸ヤ綔杞﹂棿
- /// </summary>
- [SugarColumn(ColumnName = "DAA013")]
- public string? Daa013 { get; set; }
+ /// <summary>
+ /// 宸ヤ綔杞﹂棿
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA013")]
+ public string? Daa013 { get; set; }
- /// <summary>
- /// 鎶曟枡鍗曞崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "DAA014")]
- public string? Daa014 { get; set; }
+ /// <summary>
+ /// 鎶曟枡鍗曞崟鍙�
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA014")]
+ public string? Daa014 { get; set; }
- /// <summary>
- /// 鐢熶骇绾垮埆
- /// </summary>
- [SugarColumn(ColumnName = "DAA015")]
- public string? Daa015 { get; set; }
+ /// <summary>
+ /// 鐢熶骇绾垮埆
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA015")]
+ public string? Daa015 { get; set; }
- /// <summary>
- /// 瀹為檯寮�宸ユ棩
- /// </summary>
- [SugarColumn(ColumnName = "DAA016")]
- public DateTime? Daa016 { get; set; }
+ /// <summary>
+ /// 瀹為檯寮�宸ユ棩
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA016")]
+ public DateTime? Daa016 { get; set; }
- /// <summary>
- /// 瀹為檯瀹屽伐鏃�
- /// </summary>
- [SugarColumn(ColumnName = "DAA017")]
- public DateTime? Daa017 { get; set; }
+ /// <summary>
+ /// 瀹為檯瀹屽伐鏃�
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA017")]
+ public DateTime? Daa017 { get; set; }
- /// <summary>
- /// 宸ュ崟鐘舵��
- /// </summary>
- [SugarColumn(ColumnName = "DAA018")]
- public string? Daa018 { get; set; }
+ /// <summary>
+ /// 宸ュ崟鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA018")]
+ public string? Daa018 { get; set; }
- /// <summary>
- /// 榻愬鐘舵��
- /// </summary>
- [SugarColumn(ColumnName = "DAA019")]
- public string? Daa019 { get; set; }
+ /// <summary>
+ /// 榻愬鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA019")]
+ public string? Daa019 { get; set; }
- /// <summary>
- /// 瀹℃牳鐮�
- /// </summary>
- [SugarColumn(ColumnName = "FSTATUS")]
- public decimal? Fstatus { get; set; }
+ /// <summary>
+ /// 瀹℃牳鐮�
+ ///</summary>
+ [SugarColumn(ColumnName = "FSTATUS")]
+ public decimal? Fstatus { get; set; }
- /// <summary>
- /// 瀹℃牳鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_DATE")]
- public DateTime? CheckDate { get; set; }
+ /// <summary>
+ /// 瀹℃牳鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName = "CHECK_DATE")]
+ public DateTime? CheckDate { get; set; }
- /// <summary>
- /// 瀹℃牳浜�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_USER")]
- public string? CheckUser { get; set; }
+ /// <summary>
+ /// 瀹℃牳浜�
+ ///</summary>
+ [SugarColumn(ColumnName = "CHECK_USER")]
+ public string? CheckUser { get; set; }
- /// <summary>
- /// 绾垮埆缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DAA020")]
- public string? Daa020 { get; set; }
+ /// <summary>
+ /// 绾垮埆缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA020")]
+ public string? Daa020 { get; set; }
- /// <summary>
- /// 浠诲姟鍗曞崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "DAA021")]
- public string? Daa021 { get; set; }
+ /// <summary>
+ /// 浠诲姟鍗曞崟鍙�
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA021")]
+ public string? Daa021 { get; set; }
- /// <summary>
- /// 閫氱煡澶囨枡锛�0-鏈�氱煡锛�1-閫氱煡
- /// </summary>
- [SugarColumn(ColumnName = "DAA022")]
- public decimal? Daa022 { get; set; }
+ /// <summary>
+ /// 閫氱煡澶囨枡锛�0-鏈�氱煡锛�1-閫氱煡
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA022")]
+ public decimal? Daa022 { get; set; }
- /// <summary>
- /// 鐢熶骇搴忓彿
- /// </summary>
- [SugarColumn(ColumnName = "DAA023")]
- public decimal? Daa023 { get; set; }
+ /// <summary>
+ /// 鐢熶骇搴忓彿
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA023")]
+ public decimal? Daa023 { get; set; }
- /// <summary>
- /// 鎺掍骇鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "DAA024")]
- public string? Daa024 { get; set; }
+ /// <summary>
+ /// 鎺掍骇鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA024")]
+ public string? Daa024 { get; set; }
- /// <summary>
- /// 棣栦欢鏄惁妫�楠�1-妫�楠岋紝0鏈楠�
- /// </summary>
- [SugarColumn(ColumnName = "DAA025")]
- public string? Daa025 { get; set; }
+ /// <summary>
+ /// 棣栦欢鏄惁妫�楠�1-妫�楠岋紝0鏈楠�
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA025")]
+ public string? Daa025 { get; set; }
- /// <summary>
- /// 棣栦欢妫�楠岀粨鏋�
- /// </summary>
- [SugarColumn(ColumnName = "DAA026")]
- public string? Daa026 { get; set; }
+ /// <summary>
+ /// 棣栦欢妫�楠岀粨鏋�
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA026")]
+ public string? Daa026 { get; set; }
- /// <summary>
- /// 宸叉姤妫�锛�0-鏈姤妫�锛�1-宸叉姤妫�
- /// </summary>
- [SugarColumn(ColumnName = "IS_REPORTCHECK")]
- public decimal? IsReportcheck { get; set; }
+ /// <summary>
+ /// 宸叉姤妫�锛�0-鏈姤妫�锛�1-宸叉姤妫�
+ ///</summary>
+ [SugarColumn(ColumnName = "IS_REPORTCHECK")]
+ public decimal? IsReportcheck { get; set; }
- /// <summary>
- /// 鎶ユ浜�
- /// </summary>
- [SugarColumn(ColumnName = "USNAME")]
- public string? Usname { get; set; }
+ /// <summary>
+ /// 鎶ユ浜�
+ ///</summary>
+ [SugarColumn(ColumnName = "USNAME")]
+ public string? Usname { get; set; }
- /// <summary>
- /// 鎶ユ鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "REPORTTIME")]
- public DateTime? Reporttime { get; set; }
+ /// <summary>
+ /// 鎶ユ鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "REPORTTIME")]
+ public DateTime? Reporttime { get; set; }
- /// <summary>
- /// 鏈哄彴缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "MACHINE_NO")]
- public string? MachineNo { get; set; }
+ /// <summary>
+ /// 鏈哄彴缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName = "MACHINE_NO")]
+ public string? MachineNo { get; set; }
- /// <summary>
- /// 澶囨枡瀹屾垚1-瀹屾垚锛�0鏈畬鎴�
- /// </summary>
- [SugarColumn(ColumnName = "DAA027")]
- public decimal? Daa027 { get; set; }
+ /// <summary>
+ /// 澶囨枡瀹屾垚1-瀹屾垚锛�0鏈畬鎴�
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA027")]
+ public decimal? Daa027 { get; set; }
- /// <summary>
- /// 澶囨枡瀹屾垚鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "DAA028")]
- public string? Daa028 { get; set; }
+ /// <summary>
+ /// 澶囨枡瀹屾垚鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "DAA028")]
+ 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; }
+ }
}
\ No newline at end of file
--
Gitblit v1.9.3