From 2cad690178b5373db94075f9355a390a7eba6a44 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期四, 22 八月 2024 13:53:44 +0800
Subject: [PATCH] 巡检适配
---
MES.Service/Modes/MesItems.cs | 496 ++++++++++++++++++++++++++++++------------------------
1 files changed, 274 insertions(+), 222 deletions(-)
diff --git a/MES.Service/Modes/MesItems.cs b/MES.Service/Modes/MesItems.cs
index c12394c..b82d99c 100644
--- a/MES.Service/Modes/MesItems.cs
+++ b/MES.Service/Modes/MesItems.cs
@@ -1,270 +1,322 @@
-锘縰sing SqlSugar;
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using SqlSugar;
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鐗╂枡淇℃伅
-/// </summary>
-[SugarTable("MES_ITEMS")]
-public class MesItems
+namespace MES.Service.Modes
{
/// <summary>
- /// 鐗╂枡ID
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
- public decimal Id { get; set; }
+ /// 鐗╂枡淇℃伅
+ ///</summary>
+ [SugarTable("MES_ITEMS")]
+ public class MesItems
+ {
+ /// <summary>
+ /// 鐗╂枡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 int? Fisbatchmanage { get; set; }
+ /// <summary>
+ /// 鍚敤鎵瑰彿绠＄悊
+ ///</summary>
+ [SugarColumn(ColumnName = "FISBATCHMANAGE")]
+ public decimal? Fisbatchmanage { get; set; }
- /// <summary>
- /// 閲囪喘鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "FPURCHASEUNITID")]
- public decimal? 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>
+ /// 鑷畾涔夊瓧娈�1
+ ///</summary>
+ [SugarColumn(ColumnName = "REMARK1")]
+ public string Remark1 { get; set; }
- /// <summary>
- /// 鑷畾涔夊瓧娈�2
- /// </summary>
- [SugarColumn(ColumnName = "REMARK2")]
- public string? Remark2 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�2
+ ///</summary>
+ [SugarColumn(ColumnName = "REMARK2")]
+ public string Remark2 { 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; }
- [SugarColumn(ColumnName = "PRODUCE_UNIT")]
- public string? ProduceUnit { get; set; }
+ /// <summary>
+ /// 鐢熶骇鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName = "PRODUCE_UNIT")]
+ public string ProduceUnit { get; set; }
- [SugarColumn(ColumnName = "SUBCON_UNIT")]
- public string? SubconUnit { get; set; }
+ /// <summary>
+ /// 濮斿鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName = "SUBCON_UNIT")]
+ public string SubconUnit { get; set; }
- [SugarColumn(IsIgnore = true)] public string? Type { 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>
+ /// 鍥剧墖3
+ ///</summary>
+ [SugarColumn(ColumnName = "BZ08")]
+ public string Bz08 { 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>
+ /// QC鍒嗙粍ID
+ ///</summary>
+ [SugarColumn(ColumnName = "QC_TEAMID")]
+ public string QcTeamid { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡ID
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_ID")]
+ public decimal? ItemId { get; set; }
+
+ [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
+ }
}
\ No newline at end of file
--
Gitblit v1.9.3