From fbd1dae61bb8eeccd303341ff3b5290d805a8155 Mon Sep 17 00:00:00 2001
From: tjx <t2856754968@163.com>
Date: 星期五, 19 十二月 2025 18:40:25 +0800
Subject: [PATCH] 111

---
 StandardPda/MES.Service/Modes/XbRackingTaskSyxtLog.cs |   98 +++++++++++++++++++++++++++---------------------
 1 files changed, 55 insertions(+), 43 deletions(-)

diff --git a/StandardPda/MES.Service/Modes/XbRackingTaskSyxtLog.cs b/StandardPda/MES.Service/Modes/XbRackingTaskSyxtLog.cs
index cc8240e..687291b 100644
--- a/StandardPda/MES.Service/Modes/XbRackingTaskSyxtLog.cs
+++ b/StandardPda/MES.Service/Modes/XbRackingTaskSyxtLog.cs
@@ -3,123 +3,135 @@
 namespace MES.Service.Modes;
 
 /// <summary>
-///     鍏ュ簱浠诲姟琛�
+///     鍏ュ簱浠诲姟琛� SEQ_XB_RACKING_TASK_SYXT_LOG
 /// </summary>
-[SugarTable("XB_RACKING_TASK_SYXT_LOG")]
+[SugarTable("XB_RACKING_TASK_SYXT_LOG")] 
 public class XbRackingTaskSyxtLog
 {
     /// <summary>
     ///     涓婚敭ID
     /// </summary>
-    [SugarColumn(IsPrimaryKey = true, IsNullable = false,
-        ColumnDataType = "NUMBER(20)")]
+    [SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_XB_RACKING_TASK_SYXT_LOG1",
+        ColumnName = "ID")]
     public decimal Id { get; set; }
 
     /// <summary>
     ///     鍒涘缓浜�
     /// </summary>
-    [SugarColumn(IsNullable = true, Length = 30, ColumnDataType = "VARCHAR2")]
-    public string CreateBy { get; set; }
+    [SugarColumn(ColumnName = "CREATE_BY")]
+    public string? CreateBy { get; set; }
 
     /// <summary>
     ///     鍒涘缓鏃堕棿
     /// </summary>
-    [SugarColumn(IsNullable = true, ColumnDataType = "DATE")]
+    [SugarColumn(ColumnName = "CREATE_DATE")]
     public DateTime? CreateDate { get; set; }
 
     /// <summary>
     ///     浠诲姟鍙�
     /// </summary>
-    [SugarColumn(IsNullable = true, Length = 50, ColumnDataType = "VARCHAR2")]
-    public string TaskCode { get; set; }
+    [SugarColumn(ColumnName = "TASKCODE")]
+    public string? TaskCode { get; set; }
 
     /// <summary>
     ///     浠诲姟涓嬪彂绫诲瀷
     /// </summary>
-    [SugarColumn(IsNullable = true, Length = 50, ColumnDataType = "VARCHAR2")]
-    public string TaskType { get; set; }
+    [SugarColumn(ColumnName = "TASKTYPE")]
+    public string? TaskType { get; set; }
 
     /// <summary>
     ///     鎵樼洏
     /// </summary>
-    [SugarColumn(IsNullable = false, Length = 50, ColumnDataType = "VARCHAR2")]
-    public string PalletCode { get; set; }
+    [SugarColumn(ColumnName = "PALLETCODE")]
+    public string? PalletCode { get; set; }
 
     /// <summary>
     ///     璐х墿绫诲瀷
     /// </summary>
-    [SugarColumn(IsNullable = true, ColumnDataType = "NUMBER(20)")]
+    [SugarColumn(ColumnName = "WIDTHTYPE")]
     public decimal? WidthType { get; set; }
 
     /// <summary>
     ///     鐗╂枡鍚嶇О
     /// </summary>
-    [SugarColumn(IsNullable = true, Length = 100, ColumnDataType = "VARCHAR2")]
-    public string MaterialName { get; set; }
+    [SugarColumn(ColumnName = "MATERIALNAME")]
+    public string? MaterialName { get; set; }
 
     /// <summary>
     ///     鐗╂枡缂栫爜
     /// </summary>
-    [SugarColumn(IsNullable = true, Length = 50, ColumnDataType = "VARCHAR2")]
-    public string MaterialCode { get; set; }
+    [SugarColumn(ColumnName = "MATERIALCODE")]
+    public string? MaterialCode { get; set; }
 
     /// <summary>
     ///     鎵瑰彿
     /// </summary>
-    [SugarColumn(IsNullable = true, Length = 50, ColumnDataType = "VARCHAR2")]
-    public string BatchNo { get; set; }
+    [SugarColumn(ColumnName = "BATCHNO")]
+    public string? BatchNo { get; set; }
 
     /// <summary>
     ///     鏁伴噺
     /// </summary>
-    [SugarColumn(IsNullable = true, ColumnDataType = "NUMBER(20)")]
+    [SugarColumn(ColumnName = "QUANTITY")]
     public decimal? Quantity { get; set; }
 
     /// <summary>
     ///     浠诲姟涓嬪彂鎺ユ敹鏁版嵁
     /// </summary>
-    [SugarColumn(IsNullable = true, ColumnDataType = "CLOB")]
-    public string WarehousingJson { get; set; }
+    [SugarColumn(ColumnName = "WAREHOUSINGJSON")]
+    public string? WarehousingJson { get; set; }
 
     /// <summary>
     ///     宸ヤ綅鐐�
     /// </summary>
-    [SugarColumn(IsNullable = true, Length = 50, ColumnDataType = "VARCHAR2")]
-    public string Station { get; set; }
+    [SugarColumn(ColumnName = "STATION")]
+    public string? Station { get; set; }
 
     /// <summary>
-    ///     浠诲姟涓婃姤绫诲瀷
+    ///     200浠h〃鎴愬姛500浠h〃澶辫触
     /// </summary>
-    [SugarColumn(IsNullable = true, Length = 50, ColumnDataType = "VARCHAR2")]
-    public string TaskReporting { get; set; }
+    [SugarColumn(ColumnName = "CODE")]
+    public string? Code { get; set; }
 
     /// <summary>
-    ///     搴撲綅
+    ///     娑堟伅鍐呭
     /// </summary>
-    [SugarColumn(IsNullable = true, Length = 20, ColumnDataType = "VARCHAR2")]
-    public string LocCode { get; set; }
+    [SugarColumn(ColumnName = "JSON_MESSAGE")]
+    public string? JsonMessage { get; set; }
 
     /// <summary>
-    ///     寮傚父浠g爜
+    ///  鍙嶉缁撴灉琛ュ厖璇存槑
     /// </summary>
-    [SugarColumn(IsNullable = true, Length = 50, ColumnDataType = "VARCHAR2")]
-    public string ErrorCode { get; set; }
+    [SugarColumn(ColumnName = "CODE_MESSAGE")]
+    public string? CodeMessage { get; set; }
 
     /// <summary>
-    ///     寮傚父鎻忚堪
+    ///     琛ュ厖
     /// </summary>
-    [SugarColumn(IsNullable = true, Length = 200, ColumnDataType = "VARCHAR2")]
-    public string ErrorMessage { get; set; }
+    [SugarColumn(ColumnName = "DATA")]
+    public string? Data { get; set; }
 
     /// <summary>
-    ///     浠诲姟涓婃姤鎺ユ敹鏁版嵁
+    ///     搴撲綅缂栫爜
     /// </summary>
-    [SugarColumn(IsNullable = true, ColumnDataType = "CLOB")]
-    public string MissionAccomplishedJson { get; set; }
+    [SugarColumn(ColumnName = "LOCCODE")]
+    public string? LocCode { get; set; }
 
     /// <summary>
-    ///     涓氬姟绫诲瀷
+    ///     搴撲綅涓枃鍚嶇О
     /// </summary>
-    [SugarColumn(IsNullable = true, Length = 50, ColumnDataType = "VARCHAR2")]
-    public string BusinessType { get; set; }
+    [SugarColumn(ColumnName = "LOCCODECHINESE")]
+    public string? LocCodeChinese { get; set; }
+
+    /// <summary>
+    ///     璐ㄦ鐘舵��
+    /// </summary>
+    [SugarColumn(ColumnName = "QCSTATUS")]
+    public decimal? QcStatus { get; set; }
+
+    /// <summary>
+    ///     鐗╂枡鏉$爜
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_BARCODE")]
+    public string? ItemBarcode { get; set; }
 }
\ No newline at end of file

--
Gitblit v1.9.3