From 4f88a7d41fea9435c859e256c906a8daeed9953f Mon Sep 17 00:00:00 2001
From: wbc <2597324127@qq.com>
Date: 星期六, 15 三月 2025 16:37:15 +0800
Subject: [PATCH] 首件巡检优化更改

---
 MES.Service/Modes/MesItems.cs |  530 +++++++++++++++++++++++++++++-----------------------------
 1 files changed, 263 insertions(+), 267 deletions(-)

diff --git a/MES.Service/Modes/MesItems.cs b/MES.Service/Modes/MesItems.cs
index b82d99c..9e33027 100644
--- a/MES.Service/Modes/MesItems.cs
+++ b/MES.Service/Modes/MesItems.cs
@@ -1,322 +1,318 @@
-锘縰sing System;
-using System.Collections.Generic;
-using System.Linq;
-using SqlSugar;
+锘縰sing SqlSugar;
 
-namespace MES.Service.Modes
+namespace MES.Service.Modes;
+
+/// <summary>
+///     鐗╂枡淇℃伅
+/// </summary>
+[SugarTable("MES_ITEMS")]
+public class MesItems
 {
     /// <summary>
-    /// 鐗╂枡淇℃伅
-    ///</summary>
-    [SugarTable("MES_ITEMS")]
-    public class MesItems
-    {
-        /// <summary>
-        /// 鐗╂枡ID 
-        ///</summary>
-        [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
-        public decimal Id { get; set; }
+    ///     鐗╂枡ID
+    /// </summary>
+    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+    public decimal Id { get; set; }
 
-        /// <summary>
-        /// 宸ュ巶 
-        ///</summary>
-        [SugarColumn(ColumnName = "FACTORY")]
-        public string Factory { get; set; }
+    /// <summary>
+    ///     宸ュ巶
+    /// </summary>
+    [SugarColumn(ColumnName = "FACTORY")]
+    public string Factory { get; set; }
 
-        /// <summary>
-        /// 鍏徃缂栧彿 
-        ///</summary>
-        [SugarColumn(ColumnName = "COMPANY")]
-        public string Company { get; set; }
+    /// <summary>
+    ///     鍏徃缂栧彿
+    /// </summary>
+    [SugarColumn(ColumnName = "COMPANY")]
+    public string Company { get; set; }
 
-        /// <summary>
-        /// 鐗╂枡缂栫爜 = ERP鐗╂枡缂栧彿||棰滆壊缂栧彿 
-        ///</summary>
-        [SugarColumn(ColumnName = "ITEM_NO")]
-        public string ItemNo { get; set; }
+    /// <summary>
+    ///     鐗╂枡缂栫爜 = ERP鐗╂枡缂栧彿||棰滆壊缂栧彿
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_NO")]
+    public string ItemNo { get; set; }
 
-        /// <summary>
-        /// 鐗╂枡鍚嶇О 
-        ///</summary>
-        [SugarColumn(ColumnName = "ITEM_NAME")]
-        public string ItemName { get; set; }
+    /// <summary>
+    ///     鐗╂枡鍚嶇О
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_NAME")]
+    public string ItemName { get; set; }
 
-        /// <summary>
-        /// 鐗╂枡绠�绉� 
-        ///</summary>
-        [SugarColumn(ColumnName = "ITEM_SNAME")]
-        public string ItemSname { get; set; }
+    /// <summary>
+    ///     鐗╂枡绠�绉�
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_SNAME")]
+    public string ItemSname { get; set; }
 
-        /// <summary>
-        /// 瑙勬牸鍨嬪彿 
-        ///</summary>
-        [SugarColumn(ColumnName = "ITEM_MODEL")]
-        public string ItemModel { get; set; }
+    /// <summary>
+    ///     瑙勬牸鍨嬪彿
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_MODEL")]
+    public string ItemModel { get; set; }
 
-        /// <summary>
-        /// 鐗╂枡鎻忚堪 
-        ///</summary>
-        [SugarColumn(ColumnName = "ITEM_DESCRIPTION")]
-        public string ItemDescription { get; set; }
+    /// <summary>
+    ///     鐗╂枡鎻忚堪
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_DESCRIPTION")]
+    public string ItemDescription { get; set; }
 
-        /// <summary>
-        /// 鐗╂枡鍗曚綅 
-        ///</summary>
-        [SugarColumn(ColumnName = "ITEM_UNIT")]
-        public string ItemUnit { get; set; }
+    /// <summary>
+    ///     鐗╂枡鍗曚綅
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_UNIT")]
+    public string ItemUnit { get; set; }
 
-        /// <summary>
-        /// 鐗╂枡绫诲瀷 
-        ///</summary>
-        [SugarColumn(ColumnName = "ITEM_TYPE")]
-        public string ItemType { get; set; }
+    /// <summary>
+    ///     鐗╂枡绫诲瀷
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_TYPE")]
+    public string ItemType { get; set; }
 
-        /// <summary>
-        /// 浜у搧鐗堟湰 
-        ///</summary>
-        [SugarColumn(ColumnName = "ITEM_VERSION")]
-        public string ItemVersion { get; set; }
+    /// <summary>
+    ///     浜у搧鐗堟湰
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_VERSION")]
+    public string ItemVersion { get; set; }
 
-        /// <summary>
-        /// 瀹㈡埛缂栧彿 
-        ///</summary>
-        [SugarColumn(ColumnName = "CUST_NO")]
-        public string CustNo { get; set; }
+    /// <summary>
+    ///     瀹㈡埛缂栧彿
+    /// </summary>
+    [SugarColumn(ColumnName = "CUST_NO")]
+    public string CustNo { get; set; }
 
-        /// <summary>
-        /// 鍒涘缓浜� 
-        ///</summary>
-        [SugarColumn(ColumnName = "CREATE_BY")]
-        public string CreateBy { get; set; }
+    /// <summary>
+    ///     鍒涘缓浜�
+    /// </summary>
+    [SugarColumn(ColumnName = "CREATE_BY")]
+    public string CreateBy { get; set; }
 
-        /// <summary>
-        /// 鍒涘缓鏃堕棿 
-        ///</summary>
-        [SugarColumn(ColumnName = "CREATE_DATE")]
-        public DateTime? CreateDate { get; set; }
+    /// <summary>
+    ///     鍒涘缓鏃堕棿
+    /// </summary>
+    [SugarColumn(ColumnName = "CREATE_DATE")]
+    public DateTime? CreateDate { get; set; }
 
-        /// <summary>
-        /// 鏈�鍚庢洿鏂颁汉 
-        ///</summary>
-        [SugarColumn(ColumnName = "LASTUPDATE_BY")]
-        public string LastupdateBy { get; set; }
+    /// <summary>
+    ///     鏈�鍚庢洿鏂颁汉
+    /// </summary>
+    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+    public string LastupdateBy { get; set; }
 
-        /// <summary>
-        /// 鏈�鍚庢洿鏂版椂闂� 
-        ///</summary>
-        [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
-        public DateTime? LastupdateDate { get; set; }
+    /// <summary>
+    ///     鏈�鍚庢洿鏂版椂闂�
+    /// </summary>
+    [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+    public DateTime? LastupdateDate { get; set; }
 
-        /// <summary>
-        /// 鏈�浣庡簱瀛� 
-        ///</summary>
-        [SugarColumn(ColumnName = "LOWLIMIT")]
-        public double? Lowlimit { get; set; }
+    /// <summary>
+    ///     鏈�浣庡簱瀛�
+    /// </summary>
+    [SugarColumn(ColumnName = "LOWLIMIT")]
+    public double? Lowlimit { get; set; }
 
-        /// <summary>
-        /// 鏈�澶у簱瀛� 
-        ///</summary>
-        [SugarColumn(ColumnName = "HIGHLIMIT")]
-        public double? Highlimit { get; set; }
+    /// <summary>
+    ///     鏈�澶у簱瀛�
+    /// </summary>
+    [SugarColumn(ColumnName = "HIGHLIMIT")]
+    public double? Highlimit { get; set; }
 
-        /// <summary>
-        /// 鏈�灏忓寘瑁呮暟 
-        ///</summary>
-        [SugarColumn(ColumnName = "PRD_PACK")]
-        public double? PrdPack { get; set; }
+    /// <summary>
+    ///     鏈�灏忓寘瑁呮暟
+    /// </summary>
+    [SugarColumn(ColumnName = "PRD_PACK")]
+    public double? PrdPack { get; set; }
 
-        /// <summary>
-        /// 璁㈠崟鍗曚綅 
-        ///</summary>
-        [SugarColumn(ColumnName = "ORDERUNIT")]
-        public string Orderunit { get; set; }
+    /// <summary>
+    ///     璁㈠崟鍗曚綅
+    /// </summary>
+    [SugarColumn(ColumnName = "ORDERUNIT")]
+    public string Orderunit { get; set; }
 
-        /// <summary>
-        /// 閿�鍞崟浣� 
-        ///</summary>
-        [SugarColumn(ColumnName = "SALEUNIT")]
-        public string Saleunit { get; set; }
+    /// <summary>
+    ///     閿�鍞崟浣�
+    /// </summary>
+    [SugarColumn(ColumnName = "SALEUNIT")]
+    public string Saleunit { get; set; }
 
-        /// <summary>
-        /// 搴撴埧鍗曚綅 
-        ///</summary>
-        [SugarColumn(ColumnName = "STOREUNIT")]
-        public string Storeunit { get; set; }
+    /// <summary>
+    ///     搴撴埧鍗曚綅
+    /// </summary>
+    [SugarColumn(ColumnName = "STOREUNIT")]
+    public string Storeunit { get; set; }
 
-        /// <summary>
-        /// 鐢熶骇鍗曚綅 
-        ///</summary>
-        [SugarColumn(ColumnName = "PRODUCTUNIT")]
-        public string Productunit { get; set; }
+    /// <summary>
+    ///     鐢熶骇鍗曚綅
+    /// </summary>
+    [SugarColumn(ColumnName = "PRODUCTUNIT")]
+    public string Productunit { get; set; }
 
-        /// <summary>
-        /// 鐗╂枡ID 
-        ///</summary>
-        [SugarColumn(ColumnName = "E_ITEM_ID")]
-        public decimal? EItemId { get; set; }
+    /// <summary>
+    ///     鐗╂枡ID
+    /// </summary>
+    [SugarColumn(ColumnName = "E_ITEM_ID")]
+    public decimal? EItemId { get; set; }
 
-        /// <summary>
-        /// ERP鏂欏彿 
-        ///</summary>
-        [SugarColumn(ColumnName = "ERP_ITEM_NO")]
-        public string ErpItemNo { get; set; }
+    /// <summary>
+    ///     ERP鏂欏彿
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_ITEM_NO")]
+    public string ErpItemNo { get; set; }
 
-        /// <summary>
-        /// 榛樿浠撳簱 
-        ///</summary>
-        [SugarColumn(ColumnName = "DEPOT_CODE")]
-        public string DepotCode { get; set; }
+    /// <summary>
+    ///     榛樿浠撳簱
+    /// </summary>
+    [SugarColumn(ColumnName = "DEPOT_CODE")]
+    public string DepotCode { get; set; }
 
-        /// <summary>
-        /// 鐗╂枡鍒嗙被缂栧彿 
-        ///</summary>
-        [SugarColumn(ColumnName = "PPBOM00019124")]
-        public string Ppbom00019124 { get; set; }
+    /// <summary>
+    ///     鐗╂枡鍒嗙被缂栧彿
+    /// </summary>
+    [SugarColumn(ColumnName = "PPBOM00019124")]
+    public string Ppbom00019124 { get; set; }
 
-        /// <summary>
-        /// 鐗╂枡鍒嗙粍 
-        ///</summary>
-        [SugarColumn(ColumnName = "REMARKS")]
-        public string Remarks { get; set; }
+    /// <summary>
+    ///     鐗╂枡鍒嗙粍
+    /// </summary>
+    [SugarColumn(ColumnName = "REMARKS")]
+    public string Remarks { get; set; }
 
-        /// <summary>
-        /// 閲囪喘鍛� 
-        ///</summary>
-        [SugarColumn(ColumnName = "FPURCHASERID")]
-        public string Fpurchaserid { get; set; }
+    /// <summary>
+    ///     閲囪喘鍛�
+    /// </summary>
+    [SugarColumn(ColumnName = "FPURCHASERID")]
+    public string Fpurchaserid { get; set; }
 
-        /// <summary>
-        /// 绂佺敤鐘舵�� 
-        ///</summary>
-        [SugarColumn(ColumnName = "FFORBIDSTATUS")]
-        public string Fforbidstatus { get; set; }
+    /// <summary>
+    ///     绂佺敤鐘舵��
+    /// </summary>
+    [SugarColumn(ColumnName = "FFORBIDSTATUS")]
+    public string Fforbidstatus { get; set; }
 
-        /// <summary>
-        /// 鐗╂枡鍒嗙粍 
-        ///</summary>
-        [SugarColumn(ColumnName = "FMATERIALGROUP")]
-        public string Fmaterialgroup { get; set; }
+    /// <summary>
+    ///     鐗╂枡鍒嗙粍
+    /// </summary>
+    [SugarColumn(ColumnName = "FMATERIALGROUP")]
+    public string Fmaterialgroup { get; set; }
 
-        /// <summary>
-        /// 瀹屽伐瓒呮敹姣斾緥 
-        ///</summary>
-        [SugarColumn(ColumnName = "FFINISHRECEIPTOVERRATE")]
-        public decimal? Ffinishreceiptoverrate { get; set; }
+    /// <summary>
+    ///     瀹屽伐瓒呮敹姣斾緥
+    /// </summary>
+    [SugarColumn(ColumnName = "FFINISHRECEIPTOVERRATE")]
+    public decimal? Ffinishreceiptoverrate { get; set; }
 
-        /// <summary>
-        /// 鍙戞枡鏂瑰紡 
-        ///</summary>
-        [SugarColumn(ColumnName = "FISSUETYPE")]
-        public string Fissuetype { get; set; }
+    /// <summary>
+    ///     鍙戞枡鏂瑰紡
+    /// </summary>
+    [SugarColumn(ColumnName = "FISSUETYPE")]
+    public string Fissuetype { get; set; }
 
-        /// <summary>
-        /// 鍚敤鎵瑰彿绠＄悊 
-        ///</summary>
-        [SugarColumn(ColumnName = "FISBATCHMANAGE")]
-        public decimal? Fisbatchmanage { get; set; }
+    /// <summary>
+    ///     鍚敤鎵瑰彿绠＄悊
+    /// </summary>
+    [SugarColumn(ColumnName = "FISBATCHMANAGE")]
+    public decimal? Fisbatchmanage { get; set; }
 
-        /// <summary>
-        /// 閲囪喘鍗曚綅 
-        ///</summary>
-        [SugarColumn(ColumnName = "FPURCHASEUNITID")]
-        public string Fpurchaseunitid { get; set; }
+    /// <summary>
+    ///     閲囪喘鍗曚綅
+    /// </summary>
+    [SugarColumn(ColumnName = "FPURCHASEUNITID")]
+    public string Fpurchaseunitid { get; set; }
 
-        /// <summary>
-        /// 鑷畾涔夊瓧娈�1 
-        ///</summary>
-        [SugarColumn(ColumnName = "REMARK1")]
-        public string Remark1 { get; set; }
+    /// <summary>
+    ///     鏄惁鍖呰
+    /// </summary>
+    [SugarColumn(ColumnName = "CHECKBOX_SFBZ")]
+    public string CheckbosSFBZ { get; set; }
 
-        /// <summary>
-        /// 鑷畾涔夊瓧娈�2 
-        ///</summary>
-        [SugarColumn(ColumnName = "REMARK2")]
-        public string Remark2 { get; set; }
+    /// <summary>
+    ///     鏄惁鎵撴爣
+    /// </summary>
+    [SugarColumn(ColumnName = "CHECKBOX_SFDB")]
+    public string CheckbosSFDB { get; set; }
 
-        /// <summary>
-        /// 鑷畾涔夊瓧娈�3 
-        ///</summary>
-        [SugarColumn(ColumnName = "REMARK3")]
-        public string Remark3 { get; set; }
+    /// <summary>
+    ///     鑷畾涔夊瓧娈�3
+    /// </summary>
+    [SugarColumn(ColumnName = "REMARK3")]
+    public string Remark3 { get; set; }
 
-        /// <summary>
-        /// 鑷畾涔夊瓧娈�4 
-        ///</summary>
-        [SugarColumn(ColumnName = "REMARK4")]
-        public string Remark4 { get; set; }
+    /// <summary>
+    ///     鑷畾涔夊瓧娈�4
+    /// </summary>
+    [SugarColumn(ColumnName = "REMARK4")]
+    public string Remark4 { get; set; }
 
-        /// <summary>
-        /// 鑷畾涔夊瓧娈�5 
-        ///</summary>
-        [SugarColumn(ColumnName = "REMARK5")]
-        public string Remark5 { get; set; }
+    /// <summary>
+    ///     鑷畾涔夊瓧娈�5
+    /// </summary>
+    [SugarColumn(ColumnName = "REMARK5")]
+    public string Remark5 { get; set; }
 
-        /// <summary>
-        /// 鐢熶骇杞﹂棿 
-        ///</summary>
-        [SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")]
-        public string ProductionWorkshop { get; set; }
+    /// <summary>
+    ///     鐢熶骇杞﹂棿
+    /// </summary>
+    [SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")]
+    public string ProductionWorkshop { get; set; }
 
-        /// <summary>
-        /// 鐗╂枡灞炴�� 
-        ///</summary>
-        [SugarColumn(ColumnName = "MATERIAL_PROPERTI")]
-        public string MaterialProperti { get; set; }
+    /// <summary>
+    ///     鐗╂枡灞炴��
+    /// </summary>
+    [SugarColumn(ColumnName = "MATERIAL_PROPERTI")]
+    public string MaterialProperti { get; set; }
 
-        /// <summary>
-        /// 鐢熶骇鍗曚綅 
-        ///</summary>
-        [SugarColumn(ColumnName = "PRODUCE_UNIT")]
-        public string ProduceUnit { get; set; }
+    /// <summary>
+    ///     鐢熶骇鍗曚綅
+    /// </summary>
+    [SugarColumn(ColumnName = "PRODUCE_UNIT")]
+    public string ProduceUnit { get; set; }
 
-        /// <summary>
-        /// 濮斿鍗曚綅 
-        ///</summary>
-        [SugarColumn(ColumnName = "SUBCON_UNIT")]
-        public string SubconUnit { get; set; }
+    /// <summary>
+    ///     濮斿鍗曚綅
+    /// </summary>
+    [SugarColumn(ColumnName = "SUBCON_UNIT")]
+    public string SubconUnit { get; set; }
 
-        /// <summary>
-        /// 鍥剧墖1 
-        ///</summary>
-        [SugarColumn(ColumnName = "BZ06")]
-        public string Bz06 { get; set; }
+    /// <summary>
+    ///     鍥剧墖1
+    /// </summary>
+    [SugarColumn(ColumnName = "BZ06")]
+    public string Bz06 { get; set; }
 
-        /// <summary>
-        /// 鍥剧墖2 
-        ///</summary>
-        [SugarColumn(ColumnName = "BZ07")]
-        public string Bz07 { get; set; }
+    /// <summary>
+    ///     鍥剧墖2
+    /// </summary>
+    [SugarColumn(ColumnName = "BZ07")]
+    public string Bz07 { get; set; }
 
-        /// <summary>
-        /// 鍥剧墖3 
-        ///</summary>
-        [SugarColumn(ColumnName = "BZ08")]
-        public string Bz08 { get; set; }
+    /// <summary>
+    ///     鍥剧墖3
+    /// </summary>
+    [SugarColumn(ColumnName = "BZ08")]
+    public string Bz08 { get; set; }
 
-        /// <summary>
-        /// 鍥剧墖4 
-        ///</summary>
-        [SugarColumn(ColumnName = "BZ09")]
-        public string Bz09 { get; set; }
+    /// <summary>
+    ///     鍥剧墖4
+    /// </summary>
+    [SugarColumn(ColumnName = "BZ09")]
+    public string Bz09 { get; set; }
 
-        /// <summary>
-        /// 鍥剧墖5 
-        ///</summary>
-        [SugarColumn(ColumnName = "BZ10")]
-        public string Bz10 { get; set; }
+    /// <summary>
+    ///     鍥剧墖5
+    /// </summary>
+    [SugarColumn(ColumnName = "BZ10")]
+    public string Bz10 { get; set; }
 
-        /// <summary>
-        /// QC鍒嗙粍ID 
-        ///</summary>
-        [SugarColumn(ColumnName = "QC_TEAMID")]
-        public string QcTeamid { get; set; }
+    /// <summary>
+    ///     QC鍒嗙粍ID
+    /// </summary>
+    [SugarColumn(ColumnName = "QC_TEAMID")]
+    public string QcTeamid { get; set; }
 
-        /// <summary>
-        /// 鐗╂枡ID 
-        ///</summary>
-        [SugarColumn(ColumnName = "ITEM_ID")]
-        public decimal? ItemId { get; set; }
+    /// <summary>
+    ///     鐗╂枡ID
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_ID")]
+    public decimal? ItemId { get; set; }
 
-        [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
-    }
+    [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
 }
\ No newline at end of file

--
Gitblit v1.9.3