From fc6dd85a865c4cadae0b9a07d56e2988d2262f10 Mon Sep 17 00:00:00 2001
From: kazelee <1847801760@qq.com>
Date: 星期二, 22 七月 2025 17:28:52 +0800
Subject: [PATCH] 优化数据库事务帮助类 , 查询/日志生成类
---
models/TN_Task.cs | 55 +++++++++++++------------------------------------------
1 files changed, 13 insertions(+), 42 deletions(-)
diff --git a/models/TN_Task.cs b/models/TN_Task.cs
index 5e7656d..306655e 100644
--- a/models/TN_Task.cs
+++ b/models/TN_Task.cs
@@ -3,51 +3,16 @@
using SqlSugar;
namespace HH.WCS.Mobox3.DSZSH.models {
- /// <summary>
- /// 銆愭鏋躲�浠诲姟琛�- /// </summary>
[SugarTable("TN_Task")]
public class TN_Task : BaseModel {
- /// <summary>
- /// 浠诲姟鍙�- /// </summary>
public string S_CODE { get; set; }
-
- /// <summary>
- /// 浠诲姟绫诲瀷/鍚嶇О
- /// </summary>
public string S_TYPE { get; set; }
-
- /// <summary>
- /// 璧峰璐у尯
- /// </summary>
public string S_START_AREA { get; set; }
-
- /// <summary>
- /// 缁堢偣璐у尯
- /// </summary>
public string S_END_AREA { get; set; }
-
- /// <summary>
- /// 璧峰璐т綅
- /// </summary>
public string S_START_LOC { get; set; }
-
- /// <summary>
- /// 缁堢偣璐т綅
- /// </summary>
public string S_END_LOC { get; set; }
-
- /// <summary>
- /// 寮�鏃堕棿
- /// </summary>
- public DateTime? T_START_TIME { get; set; }
-
- /// <summary>
- /// 瀹屾垚鏃堕棿
- /// </summary>
- [SugarColumn(IsNullable = true)]
- public DateTime? T_END_TIME { get; set; }
+ public DateTime T_START_TIME { get; set; }
+ public DateTime T_END_TIME { get; set; }
/// <summary>
/// AGV 杞﹀彿
@@ -55,14 +20,14 @@
public string S_EQ_NO { get; set; }
/// <summary>
- /// 浠诲姟鐘舵�锛�绛夊緟 1宸叉帹閫�2鎵ц 3瀹屾垚 4閿欒
+ /// 浠诲姟鐘舵�: 0绛夊緟 1宸叉帹閫�2鎵ц 3瀹屾垚 4閿欒
/// </summary>
public string S_B_STATE { get; set; } = "绛夊緟";
/// <summary>
- /// 浠诲姟鐘舵�锛�绛夊緟 1宸叉帹閫�2鎵ц 3瀹屾垚 4閿欒
+ /// 浠诲姟鐘舵�: 0绛夊緟 1宸叉帹閫�2鎵ц 3瀹屾垚 4閿欒
/// </summary>
- public int N_B_STATE { get; set; }
+ public int N_B_STATE { get; set; } = 0;
/// <summary>
/// 0鏃�1NDC 2澶╃洰 3鍥借嚜 4PLC 5鏉ゥ
@@ -78,6 +43,10 @@
public string S_EQ_TASK_CODE { get; set; }
public string S_CNTR_CODE { get; set; }
+ /// <summary>
+ /// 浣滀笟缂栫爜
+ /// </summary>
+ public string S_OP_CODE { get; set; }
public string S_OP_NAME { get; set; }
public int N_START_LAYER { get; internal set; }
@@ -88,11 +57,12 @@
public string S_BS_TYPE { get; set; } = string.Empty;
///// <summary>
- ///// 鏄惁寮哄埗鍑哄簱锛�涓嶅己鍒�1寮哄埗
+ ///// 鏄惁寮哄埗鍑哄簱:0涓嶅己鍒�1寮哄埗
///// </summary>
//public int N_FORCE { get; set; } = 0;
- internal static string GetStateStr(int state) {
+ #region 闈炲瓧娈甸儴鍒�+ public static string GetStateStr(int state) {
// 0绛夊緟 1宸叉帹閫�2鎵ц 3瀹屾垚 4閿欒
var status = "";
switch (state) {
@@ -104,5 +74,6 @@
}
return status;
}
+ #endregion
}
}
--
Gitblit v1.9.1