From 13b875793c17b3eb9437a8d2db65bab04f027e39 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 18 三月 2025 14:00:54 +0800
Subject: [PATCH] 111
---
StandardPda/MES.Service/Modes/MesStaff.cs | 104
StandardPda/MES.Service/Modes/VLineUser.cs | 33
StandardPda/MES.Service/service/BasicData/ProductionOrderManager.cs | 78
StandardPda/MES.Service/Modes/MesBarcodeType.cs | 320 +-
StandardPda/MES.Service/Modes/IqcBefore.cs | 61
StandardPda/MES.Service/Modes/Purdhb.cs | 352 +-
StandardPda/MES.Service/Modes/MesInvTransaction.cs | 96
StandardPda/MES.Service/Modes/MesInvItemIns.cs | 200 +-
StandardPda/MES.Service/Modes/MesDeptUser.cs | 127
StandardPda/MES.Service/Modes/MesDepTaskInfo.cs | 448 ++--
StandardPda/MES.Service/Modes/Womcaa.cs | 202 -
StandardPda/MES.Service/Modes/MesInvItemMoves.cs | 224 +-
StandardPda/MES.Service/Modes/MesQaItemsDetectDetail12.cs | 133
StandardPda/MES.Service/Modes/MesScgdGx.cs | 206 +-
StandardPda/MES.Service/Modes/Purdka.cs | 160
StandardPda/MES.Service/service/QC/RKJService.cs | 58
StandardPda/MES.Service/Modes/MesQaItemsDetect01.cs | 804 ++++----
StandardPda/MES.Service/service/BasicData/MesRohInManager.cs | 17
StandardPda/MES.Service/Modes/VMesQaItemsDetect01.cs | 71
StandardPda/MES.Service/service/WomcabManager.cs | 8
StandardPda/MES.Service/Modes/MesInvItemInCItems.cs | 184
StandardPda/MES.Service/Modes/MesQaItemsDetectDetail5.cs | 296 +-
StandardPda/MES.Service/service/BasicData/MesStaffManager.cs | 15
StandardPda/MES.Service/service/QC/LljService.cs | 93
StandardPda/MES.Service/Modes/MesInvItemArn.cs | 304 +-
StandardPda/MES.Service/Dto/service/XJPageResult.cs | 3
StandardPda/MES.Service/Dto/service/RkDaa002.cs | 3
StandardPda/MES.Service/Modes/MesInvItemInCDetails2.cs | 608 +++---
StandardPda/MES.Service/Modes/Womcab.cs | 134 -
StandardPda/MES.Service/service/WomcaaManager.cs | 184 +
StandardPda/MES.Service/Dto/webApi/ErpRohinData.cs | 2
StandardPda/MES.Service/Dto/webApi/ErpStaff.cs | 24
StandardPda/MES.Service/Modes/LtsLlj.cs | 27
StandardPda/MES.Service/Modes/IqcBeforeFrom.cs | 83
34 files changed, 2,825 insertions(+), 2,837 deletions(-)
diff --git a/StandardPda/MES.Service/Dto/service/RkDaa002.cs b/StandardPda/MES.Service/Dto/service/RkDaa002.cs
index 2080108..3a9eee4 100644
--- a/StandardPda/MES.Service/Dto/service/RkDaa002.cs
+++ b/StandardPda/MES.Service/Dto/service/RkDaa002.cs
@@ -25,6 +25,5 @@
[SugarColumn(ColumnName = "ITEM_NAME")]
public string? ItemName { get; set; }
- [SugarColumn(ColumnName = "DAA020")]
- public string? Daa020 { get; set; }
+ [SugarColumn(ColumnName = "DAA020")] public string? Daa020 { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Dto/service/XJPageResult.cs b/StandardPda/MES.Service/Dto/service/XJPageResult.cs
index 6eb7485..e511381 100644
--- a/StandardPda/MES.Service/Dto/service/XJPageResult.cs
+++ b/StandardPda/MES.Service/Dto/service/XJPageResult.cs
@@ -8,8 +8,9 @@
public string? result { get; set; }
public string? id { get; set; }
+
/// <summary>
- /// 鎼滅储鏉′欢锛屾牴鎹鏉′欢绛涢�変緵搴斿晢 鐗╂枡缂栫爜 鐗╂枡鍚嶇О鐨勬暟鎹�
+ /// 鎼滅储鏉′欢锛屾牴鎹鏉′欢绛涢�変緵搴斿晢 鐗╂枡缂栫爜 鐗╂枡鍚嶇О鐨勬暟鎹�
/// </summary>
public string? SearchValue { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Dto/webApi/ErpRohinData.cs b/StandardPda/MES.Service/Dto/webApi/ErpRohinData.cs
index 0e5cfb7..a0d35a5 100644
--- a/StandardPda/MES.Service/Dto/webApi/ErpRohinData.cs
+++ b/StandardPda/MES.Service/Dto/webApi/ErpRohinData.cs
@@ -33,6 +33,6 @@
public string? FCHECKRETQTY { get; set; } //鏀舵枡鍙��鏁�
public string? FSTOCKRETQTY { get; set; } //搴撳瓨鍙��鏁�
public string? FEntryNote { get; set; }
-
+
public string? FDeliveryDate { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Dto/webApi/ErpStaff.cs b/StandardPda/MES.Service/Dto/webApi/ErpStaff.cs
index e736de1..78a97db 100644
--- a/StandardPda/MES.Service/Dto/webApi/ErpStaff.cs
+++ b/StandardPda/MES.Service/Dto/webApi/ErpStaff.cs
@@ -2,16 +2,16 @@
public class ErpStaff
{
- public string? Id{ get; set; }
- public string? Type{ get; set; }
- public string? FStaffNumber{ get; set; }
- public string? FName{ get; set; }
- public string? FPostId{ get; set; }
- public string? KeyPosts{ get; set; }
- public string? FStaffStartDate{ get; set; }
- public string? SeparationTime{ get; set; }
- public string? FforbidStatus{ get; set; }
- public string? DepartmentName{ get; set; }
- public string? FUseOrgId{ get; set; }
- public string? Remark{ get; set; }
+ public string? Id { get; set; }
+ public string? Type { get; set; }
+ public string? FStaffNumber { get; set; }
+ public string? FName { get; set; }
+ public string? FPostId { get; set; }
+ public string? KeyPosts { get; set; }
+ public string? FStaffStartDate { get; set; }
+ public string? SeparationTime { get; set; }
+ public string? FforbidStatus { get; set; }
+ public string? DepartmentName { get; set; }
+ public string? FUseOrgId { get; set; }
+ public string? Remark { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/IqcBefore.cs b/StandardPda/MES.Service/Modes/IqcBefore.cs
index 3c5cac6..3f7555b 100644
--- a/StandardPda/MES.Service/Modes/IqcBefore.cs
+++ b/StandardPda/MES.Service/Modes/IqcBefore.cs
@@ -1,33 +1,34 @@
-锘�
-using SqlSugar;
-namespace MES.Service.Modes
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 鐢ㄦ埛瀵瑰簲鐨勭墿鏂欐楠岃〃
+/// </summary>
+[SugarTable("IQC_BEFORE")]
+public class IqcBefore
{
/// <summary>
- /// 鐢ㄦ埛瀵瑰簲鐨勭墿鏂欐楠岃〃
- ///</summary>
- [SugarTable("IQC_BEFORE")]
- public class IqcBefore
- {
- /// <summary>
- /// SEQ_IQC_Before
- ///</summary>
- [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )]
- public decimal Id { get; set; }
- /// <summary>
- /// 鐢ㄦ埛id
- ///</summary>
- [SugarColumn(ColumnName="SID" )]
- public decimal Sid { get; set; }
- /// <summary>
- /// 鐗╂枡id
- ///</summary>
- [SugarColumn(ColumnName="ITEM_ID" )]
- public decimal ItemId { get; set; }
+ /// SEQ_IQC_Before
+ /// </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 = "SID")]
+ public decimal Sid { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡id
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_ID")]
+ public decimal ItemId { get; set; }
+
+ /// <summary>
+ /// PID
+ /// </summary>
+ [SugarColumn(ColumnName = "PID")]
+ public decimal PID { get; set; }
+}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/IqcBeforeFrom.cs b/StandardPda/MES.Service/Modes/IqcBeforeFrom.cs
index 1339ecc..438afca 100644
--- a/StandardPda/MES.Service/Modes/IqcBeforeFrom.cs
+++ b/StandardPda/MES.Service/Modes/IqcBeforeFrom.cs
@@ -1,53 +1,52 @@
锘縰sing SqlSugar;
-namespace MES.Service.Modes
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 鐢ㄦ埛瀵瑰簲鐨勭墿鏂欐楠屼富琛�
+/// </summary>
+[SugarTable("IQC_BEFORE_FROM")]
+public class IqcBeforeFrom
{
/// <summary>
- /// 鐢ㄦ埛瀵瑰簲鐨勭墿鏂欐楠屼富琛�
- ///</summary>
- [SugarTable("IQC_BEFORE_FROM")]
- public class IqcBeforeFrom
- {
- /// <summary>
- /// SEQ_IQC_Before
- ///</summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
- public decimal Id { get; set; }
+ /// SEQ_IQC_Before
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
- /// <summary>
- /// 鐢ㄦ埛id
- ///</summary>
- [SugarColumn(ColumnName = "SID")]
- public decimal? Sid { get; set; }
+ /// <summary>
+ /// 鐢ㄦ埛id
+ /// </summary>
+ [SugarColumn(ColumnName = "SID")]
+ public decimal? Sid { get; set; }
- /// <summary>
- /// 鐢ㄦ埛鍚�
- ///</summary>
- [SugarColumn(ColumnName = "USER_NAME")]
- public string? UserName { get; set; }
+ /// <summary>
+ /// 鐢ㄦ埛鍚�
+ /// </summary>
+ [SugarColumn(ColumnName = "USER_NAME")]
+ public string? UserName { get; set; }
- /// <summary>
- /// 缁勭粐id
- ///</summary>
- [SugarColumn(ColumnName = "ORGANIZE_ID")]
- public string? OrganizeId { get; set; }
+ /// <summary>
+ /// 缁勭粐id
+ /// </summary>
+ [SugarColumn(ColumnName = "ORGANIZE_ID")]
+ public string? OrganizeId { 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 = "CHECK_DATE")]
- public DateTime? CheckDate { get; set; }
+ /// <summary>
+ /// 瀹℃牳鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_DATE")]
+ public DateTime? CheckDate { get; set; }
- /// <summary>
- /// 瀹℃牳鐘舵��(榛樿鍊硷細0)
- ///</summary>
- [SugarColumn(ColumnName = "STATUS")]
- public short? Status { get; set; }
- }
+ /// <summary>
+ /// 瀹℃牳鐘舵��(榛樿鍊硷細0)
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
+ public short? Status { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/LtsLlj.cs b/StandardPda/MES.Service/Modes/LtsLlj.cs
index 6a89652..0e7f4eb 100644
--- a/StandardPda/MES.Service/Modes/LtsLlj.cs
+++ b/StandardPda/MES.Service/Modes/LtsLlj.cs
@@ -169,19 +169,24 @@
/// </summary>
[SugarColumn(ColumnName = "F_TYPE")]
public int Ftype { get; set; }
-
+
[SugarColumn(IsIgnore = true)] public string? UserName { get; set; }
- /// <summary>
- /// 鐗╂枡鏍囪瘑锛�0锛氶潪棣栨銆�1锛氶娆★級
- /// </summary>
- [SugarColumn(IsIgnore = true)] public int? FIRST { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- /// </summary>
- [SugarColumn(IsIgnore = true)] public string? CreateUserName { get; set; }
/// <summary>
- /// 涓婃涓嶈壇鎻忚堪
+ /// 鐗╂枡鏍囪瘑锛�0锛氶潪棣栨銆�1锛氶娆★級
/// </summary>
- [SugarColumn(IsIgnore = true)] public string? NewFngDesc { get; set; }
+ [SugarColumn(IsIgnore = true)]
+ public int? FIRST { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(IsIgnore = true)]
+ public string? CreateUserName { get; set; }
+
+ /// <summary>
+ /// 涓婃涓嶈壇鎻忚堪
+ /// </summary>
+ [SugarColumn(IsIgnore = true)]
+ public string? NewFngDesc { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesBarcodeType.cs b/StandardPda/MES.Service/Modes/MesBarcodeType.cs
index a48ca15..2a8c96a 100644
--- a/StandardPda/MES.Service/Modes/MesBarcodeType.cs
+++ b/StandardPda/MES.Service/Modes/MesBarcodeType.cs
@@ -8,243 +8,243 @@
[SugarTable("MES_BARCODE_TYPE")]
public class MesBarcodeType
{
- /// <summary>
- /// 鏉＄爜绫诲瀷ID(seq_me_id)
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ /// 鏉＄爜绫诲瀷ID(seq_me_id)
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
- /// <summary>
- /// 浣跨敤鍦烘墍
- /// </summary>
- [SugarColumn(ColumnName = "USE_SITE")]
+ /// <summary>
+ /// 浣跨敤鍦烘墍
+ /// </summary>
+ [SugarColumn(ColumnName = "USE_SITE")]
public string UseSite { get; set; }
- /// <summary>
- /// 鏉＄爜绫诲瀷鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_TYPE_NAME")]
+ /// <summary>
+ /// 鏉＄爜绫诲瀷鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_TYPE_NAME")]
public string BarcodeTypeName { get; set; }
- /// <summary>
- /// 鐮佸埗
- /// </summary>
- [SugarColumn(ColumnName = "CODE")]
+ /// <summary>
+ /// 鐮佸埗
+ /// </summary>
+ [SugarColumn(ColumnName = "CODE")]
public string Code { get; set; }
- /// <summary>
- /// 鏉＄爜绾稿
- /// </summary>
- [SugarColumn(ColumnName = "PAPER_WIDTH")]
+ /// <summary>
+ /// 鏉＄爜绾稿
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_WIDTH")]
public decimal? PaperWidth { get; set; }
- /// <summary>
- /// 鏉＄爜绾搁珮
- /// </summary>
- [SugarColumn(ColumnName = "PAPER_HEIGHT")]
+ /// <summary>
+ /// 鏉＄爜绾搁珮
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_HEIGHT")]
public decimal? PaperHeight { get; set; }
- /// <summary>
- /// 鏉＄爜寮�濮嬩綅缃甔
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_BEGIN_POSITION_X")]
+ /// <summary>
+ /// 鏉＄爜寮�濮嬩綅缃甔
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_BEGIN_POSITION_X")]
public decimal? BarcodeBeginPositionX { get; set; }
- /// <summary>
- /// 鏉＄爜寮�濮嬩綅缃甕
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_BEGIN_POSITION_Y")]
+ /// <summary>
+ /// 鏉＄爜寮�濮嬩綅缃甕
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_BEGIN_POSITION_Y")]
public decimal? BarcodeBeginPositionY { get; set; }
- /// <summary>
- /// 涓�寮犳潯鐮佺焊涓婃潯鐮佷釜鏁�
- /// </summary>
- [SugarColumn(ColumnName = "PAPER_NUM")]
+ /// <summary>
+ /// 涓�寮犳潯鐮佺焊涓婃潯鐮佷釜鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_NUM")]
public decimal? PaperNum { get; set; }
- /// <summary>
- /// 涓�寮犳潯鐮佺焊涓婃瘡琛屾潯鐮佷釜鏁�
- /// </summary>
- [SugarColumn(ColumnName = "PAPER_ROW_NUM")]
+ /// <summary>
+ /// 涓�寮犳潯鐮佺焊涓婃瘡琛屾潯鐮佷釜鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_ROW_NUM")]
public decimal? PaperRowNum { get; set; }
- /// <summary>
- /// 涓�寮犳潯鐮佺焊涓婃潯鐮佸垪鏁�
- /// </summary>
- [SugarColumn(ColumnName = "PAPER_COLUMN_NUM")]
+ /// <summary>
+ /// 涓�寮犳潯鐮佺焊涓婃潯鐮佸垪鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_COLUMN_NUM")]
public decimal? PaperColumnNum { get; set; }
- /// <summary>
- /// 鏉＄爜娴佹按鍙峰惊鐜被鍨�(鎺у埗鏉＄爜娴佹按鍙�)
- /// </summary>
- [SugarColumn(ColumnName = "CYCLE_TYPE")]
+ /// <summary>
+ /// 鏉＄爜娴佹按鍙峰惊鐜被鍨�(鎺у埗鏉＄爜娴佹按鍙�)
+ /// </summary>
+ [SugarColumn(ColumnName = "CYCLE_TYPE")]
public string CycleType { get; set; }
- /// <summary>
- /// 鏄惁鏈夋晥(0-鏃犳晥,1-鏈夋晥)
- /// </summary>
- [SugarColumn(ColumnName = "AVAILABLE_FLAG")]
+ /// <summary>
+ /// 鏄惁鏈夋晥(0-鏃犳晥,1-鏈夋晥)
+ /// </summary>
+ [SugarColumn(ColumnName = "AVAILABLE_FLAG")]
public decimal? AvailableFlag { get; set; }
- /// <summary>
- /// 鏉＄爜楂樺害
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_HEIGHT")]
+ /// <summary>
+ /// 鏉＄爜楂樺害
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_HEIGHT")]
public decimal? BarcodeHeight { get; set; }
- /// <summary>
- /// 鏉＄爜瀛椾綋鏂瑰悜
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_ORIENTATION")]
+ /// <summary>
+ /// 鏉＄爜瀛椾綋鏂瑰悜
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_ORIENTATION")]
public string BarcodeOrientation { get; set; }
- /// <summary>
- /// 鏉＄爜鎵撳嵃娉ㄩ噴琛�(1-鎵撳嵃锛�0-涓嶆墦鍗�)
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_INTERPRETATION")]
+ /// <summary>
+ /// 鏉＄爜鎵撳嵃娉ㄩ噴琛�(1-鎵撳嵃锛�0-涓嶆墦鍗�)
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_INTERPRETATION")]
public decimal? BarcodeInterpretation { get; set; }
- /// <summary>
- /// 鏉＄爜鎵撳嵃娉ㄩ噴琛屾墦鍦ㄦ潯鐮佷笂鏂�(1-鎵撳嵃鍦ㄦ潯鐮佷笂鏂癸紝0-涓嶆墦鍗板湪鏉＄爜涓婃柟)
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_INTERPRETATION_ABOVE")]
+ /// <summary>
+ /// 鏉＄爜鎵撳嵃娉ㄩ噴琛屾墦鍦ㄦ潯鐮佷笂鏂�(1-鎵撳嵃鍦ㄦ潯鐮佷笂鏂癸紝0-涓嶆墦鍗板湪鏉＄爜涓婃柟)
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_INTERPRETATION_ABOVE")]
public decimal? BarcodeInterpretationAbove { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_BY")]
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_DATE")]
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string LastupdateBy { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 鏉＄爜瀹藉害
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_WIDTH")]
+ /// <summary>
+ /// 鏉＄爜瀹藉害
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_WIDTH")]
public decimal? BarcodeWidth { get; set; }
- /// <summary>
- /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]妯″潡锛堢獎鏉★級瀹�
- /// </summary>
- [SugarColumn(ColumnName = "BY_W")]
+ /// <summary>
+ /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]妯″潡锛堢獎鏉★級瀹�
+ /// </summary>
+ [SugarColumn(ColumnName = "BY_W")]
public decimal? ByW { get; set; }
- /// <summary>
- /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]瀹芥潯涓庣獎鏉＄殑姣斾緥
- /// </summary>
- [SugarColumn(ColumnName = "BY_R")]
+ /// <summary>
+ /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]瀹芥潯涓庣獎鏉＄殑姣斾緥
+ /// </summary>
+ [SugarColumn(ColumnName = "BY_R")]
public decimal? ByR { get; set; }
- /// <summary>
- /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]鏉＄爜楂樺害
- /// </summary>
- [SugarColumn(ColumnName = "BY_H")]
+ /// <summary>
+ /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]鏉＄爜楂樺害
+ /// </summary>
+ [SugarColumn(ColumnName = "BY_H")]
public decimal? ByH { get; set; }
- /// <summary>
- /// 鐐规暟/姣背
- /// </summary>
- [SugarColumn(ColumnName = "JM")]
+ /// <summary>
+ /// 鐐规暟/姣背
+ /// </summary>
+ [SugarColumn(ColumnName = "JM")]
public string Jm { get; set; }
- /// <summary>
- /// 铏氭嫙鏁版嵁鏍囧織(1-鏄紝0锛嶅惁)
- /// </summary>
- [SugarColumn(ColumnName = "JVM_DATA_FLAG")]
+ /// <summary>
+ /// 铏氭嫙鏁版嵁鏍囧織(1-鏄紝0锛嶅惁)
+ /// </summary>
+ [SugarColumn(ColumnName = "JVM_DATA_FLAG")]
public decimal? JvmDataFlag { get; set; }
- /// <summary>
- /// 铏氭嫙鏁版嵁娴佹按鍙蜂綅鏁�
- /// </summary>
- [SugarColumn(ColumnName = "JVM_SERIAL_DIGIT")]
+ /// <summary>
+ /// 铏氭嫙鏁版嵁娴佹按鍙蜂綅鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "JVM_SERIAL_DIGIT")]
public decimal? JvmSerialDigit { get; set; }
- /// <summary>
- /// 铏氭嫙鏁版嵁鏉＄爜闀垮害
- /// </summary>
- [SugarColumn(ColumnName = "JVM_BARCODE_LENGTH")]
+ /// <summary>
+ /// 铏氭嫙鏁版嵁鏉＄爜闀垮害
+ /// </summary>
+ [SugarColumn(ColumnName = "JVM_BARCODE_LENGTH")]
public decimal? JvmBarcodeLength { get; set; }
- /// <summary>
- /// 鎵撳嵃鍛戒护
- /// </summary>
- [SugarColumn(ColumnName = "PRINT_COMMAND")]
+ /// <summary>
+ /// 鎵撳嵃鍛戒护
+ /// </summary>
+ [SugarColumn(ColumnName = "PRINT_COMMAND")]
public string PrintCommand { get; set; }
- /// <summary>
- /// 鎵撳嵃鍛戒护寮�濮�
- /// </summary>
- [SugarColumn(ColumnName = "PRINT_COMMAND_BEGIN")]
+ /// <summary>
+ /// 鎵撳嵃鍛戒护寮�濮�
+ /// </summary>
+ [SugarColumn(ColumnName = "PRINT_COMMAND_BEGIN")]
public string PrintCommandBegin { get; set; }
- /// <summary>
- /// 鎵撳嵃鍛戒护缁撴潫
- /// </summary>
- [SugarColumn(ColumnName = "PRINT_COMMAND_END")]
+ /// <summary>
+ /// 鎵撳嵃鍛戒护缁撴潫
+ /// </summary>
+ [SugarColumn(ColumnName = "PRINT_COMMAND_END")]
public string PrintCommandEnd { get; set; }
- /// <summary>
- /// 鏉＄爜娉ㄩ噴琛屾暟
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_INTERPRETATION_ROW")]
+ /// <summary>
+ /// 鏉＄爜娉ㄩ噴琛屾暟
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_INTERPRETATION_ROW")]
public decimal? BarcodeInterpretationRow { get; set; }
- /// <summary>
- /// 鏉＄爜鍊煎甫鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_ITEM")]
+ /// <summary>
+ /// 鏉＄爜鍊煎甫鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_ITEM")]
public decimal? BarcodeItem { get; set; }
- /// <summary>
- /// 鏉＄爜绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "TYPE_CODE")]
+ /// <summary>
+ /// 鏉＄爜绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "TYPE_CODE")]
public decimal TypeCode { get; set; }
- /// <summary>
- /// 鏄惁浣跨敤
- /// </summary>
- [SugarColumn(ColumnName = "ISUSED")]
+ /// <summary>
+ /// 鏄惁浣跨敤
+ /// </summary>
+ [SugarColumn(ColumnName = "ISUSED")]
public short? Isused { get; set; }
- /// <summary>
- /// 鎵撳嵃妯℃澘
- /// </summary>
- [SugarColumn(ColumnName = "MBTYPE")]
+ /// <summary>
+ /// 鎵撳嵃妯℃澘
+ /// </summary>
+ [SugarColumn(ColumnName = "MBTYPE")]
public decimal? Mbtype { get; set; }
- /// <summary>
- /// 鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ /// 鍒嗗巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
public string Factory { get; set; }
- /// <summary>
- /// 鍏徃浠ｇ爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
public string Company { get; set; }
- /// <summary>
- /// 娴佹按鍙蜂綅鏁�
- /// </summary>
- [SugarColumn(ColumnName = "ORDER_NUM")]
+ /// <summary>
+ /// 娴佹按鍙蜂綅鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "ORDER_NUM")]
public decimal? OrderNum { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesDepTaskInfo.cs b/StandardPda/MES.Service/Modes/MesDepTaskInfo.cs
index f082e04..49b445b 100644
--- a/StandardPda/MES.Service/Modes/MesDepTaskInfo.cs
+++ b/StandardPda/MES.Service/Modes/MesDepTaskInfo.cs
@@ -8,339 +8,339 @@
[SugarTable("MES_DEP_TASK_INFO")]
public class MesDepTaskInfo
{
- /// <summary>
- /// 閮ㄩ棬鐢熶骇璁㈠崟ID
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ /// 閮ㄩ棬鐢熶骇璁㈠崟ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
- /// <summary>
- /// 璁㈠崟缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
+ /// <summary>
+ /// 璁㈠崟缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "TASK_NO")]
public string TaskNo { get; set; }
- /// <summary>
- /// ERP鐗╂枡缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "ERP_ITEM_NO")]
+ /// <summary>
+ /// ERP鐗╂枡缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_ITEM_NO")]
public string ErpItemNo { get; set; }
- /// <summary>
- /// 宸ュ崟鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "PLAN_QTY")]
+ /// <summary>
+ /// 宸ュ崟鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "PLAN_QTY")]
public decimal? PlanQty { get; set; }
- /// <summary>
- /// 宸茬敓浜ч噺
- /// </summary>
- [SugarColumn(ColumnName = "COMPLETE_QTY")]
+ /// <summary>
+ /// 宸茬敓浜ч噺
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPLETE_QTY")]
public decimal? CompleteQty { get; set; }
- /// <summary>
- /// 澶囨崯鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "BACKUP_QTY")]
+ /// <summary>
+ /// 澶囨崯鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "BACKUP_QTY")]
public decimal? BackupQty { get; set; }
- /// <summary>
- /// 涓嬭浇鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "DOWN_TIME")]
+ /// <summary>
+ /// 涓嬭浇鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "DOWN_TIME")]
public DateTime? DownTime { get; set; }
- /// <summary>
- /// 璁″垝寮�濮嬫椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "PLAN_BEGIN_TIME")]
+ /// <summary>
+ /// 璁″垝寮�濮嬫椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "PLAN_BEGIN_TIME")]
public DateTime? PlanBeginTime { get; set; }
- /// <summary>
- /// 璁″垝缁撴潫鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "PLAN_FINISH_TIME")]
+ /// <summary>
+ /// 璁″垝缁撴潫鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "PLAN_FINISH_TIME")]
public DateTime? PlanFinishTime { get; set; }
- /// <summary>
- /// 瀹為檯瀹屽伐鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "REAL_FINISH_TIME")]
+ /// <summary>
+ /// 瀹為檯瀹屽伐鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "REAL_FINISH_TIME")]
public DateTime? RealFinishTime { get; set; }
- /// <summary>
- /// 鐢熶骇鐘舵��(寰呬骇\鐢熶骇\鎸傝捣\瀹屽伐)
- /// </summary>
- [SugarColumn(ColumnName = "PRODUCE_STATE")]
+ /// <summary>
+ /// 鐢熶骇鐘舵��(寰呬骇\鐢熶骇\鎸傝捣\瀹屽伐)
+ /// </summary>
+ [SugarColumn(ColumnName = "PRODUCE_STATE")]
public string ProduceState { get; set; }
- /// <summary>
- /// 瀹為檯寮�宸ユ椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "REAL_BEGIN_TIME")]
+ /// <summary>
+ /// 瀹為檯寮�宸ユ椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "REAL_BEGIN_TIME")]
public DateTime? RealBeginTime { get; set; }
- /// <summary>
- /// 鏄惁鎸傝捣
- /// </summary>
- [SugarColumn(ColumnName = "HANG_UP")]
+ /// <summary>
+ /// 鏄惁鎸傝捣
+ /// </summary>
+ [SugarColumn(ColumnName = "HANG_UP")]
public string HangUp { get; set; }
- /// <summary>
- /// 浠撳簱缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_CODE")]
+ /// <summary>
+ /// 浠撳簱缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_CODE")]
public string DepotCode { get; set; }
- /// <summary>
- /// 鎶ュ簾鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DISCARD_QTY")]
+ /// <summary>
+ /// 鎶ュ簾鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "DISCARD_QTY")]
public decimal? DiscardQty { get; set; }
- /// <summary>
- /// 濮嬫敹鏂欐椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "FIRST_ITEM_RECEIPT_TIME")]
+ /// <summary>
+ /// 濮嬫敹鏂欐椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "FIRST_ITEM_RECEIPT_TIME")]
public DateTime? FirstItemReceiptTime { get; set; }
- /// <summary>
- /// 濮嬮綈鏂欐椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "FIRST_ITEM_READY_TIME")]
+ /// <summary>
+ /// 濮嬮綈鏂欐椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "FIRST_ITEM_READY_TIME")]
public DateTime? FirstItemReadyTime { get; set; }
- /// <summary>
- /// 瀹㈡埛缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "CUST_NO")]
+ /// <summary>
+ /// 瀹㈡埛缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CUST_NO")]
public string CustNo { get; set; }
- /// <summary>
- /// 鍑鸿揣鍖呰鏂瑰紡
- /// </summary>
- [SugarColumn(ColumnName = "PACK_SHIP_TYPE")]
+ /// <summary>
+ /// 鍑鸿揣鍖呰鏂瑰紡
+ /// </summary>
+ [SugarColumn(ColumnName = "PACK_SHIP_TYPE")]
public string PackShipType { get; set; }
- /// <summary>
- /// 鍖呰娉ㄦ剰浜嬮」
- /// </summary>
- [SugarColumn(ColumnName = "PACK_SHIP_MEMO")]
+ /// <summary>
+ /// 鍖呰娉ㄦ剰浜嬮」
+ /// </summary>
+ [SugarColumn(ColumnName = "PACK_SHIP_MEMO")]
public string PackShipMemo { get; set; }
- /// <summary>
- /// 鏄惁宸叉帓浜�
- /// </summary>
- [SugarColumn(ColumnName = "ISSCHEME")]
+ /// <summary>
+ /// 鏄惁宸叉帓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "ISSCHEME")]
public short? Isscheme { get; set; }
- /// <summary>
- /// 鏉＄爜绫诲瀷ID
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_TYPE_ID")]
+ /// <summary>
+ /// 鏉＄爜绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_TYPE_ID")]
public decimal? BarcodeTypeId { get; set; }
- /// <summary>
- /// 鍙戝竷鐘舵��
- /// </summary>
- [SugarColumn(ColumnName = "ISSUE_STATUS")]
+ /// <summary>
+ /// 鍙戝竷鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "ISSUE_STATUS")]
public short? IssueStatus { get; set; }
- /// <summary>
- /// 鐘舵�侊紙0=鎺掍骇鏈彂甯冦��1=鎺掍骇宸插彂甯冦��2=宸查鏂欍��3=宸茬敓浜с��4=鏆傚仠銆�8=宸插畬宸ャ��9=寮傚父锛�
- /// </summary>
- [SugarColumn(ColumnName = "FLAG")]
+ /// <summary>
+ /// 鐘舵�侊紙0=鎺掍骇鏈彂甯冦��1=鎺掍骇宸插彂甯冦��2=宸查鏂欍��3=宸茬敓浜с��4=鏆傚仠銆�8=宸插畬宸ャ��9=寮傚父锛�
+ /// </summary>
+ [SugarColumn(ColumnName = "FLAG")]
public short? Flag { get; set; }
- /// <summary>
- /// 棰嗘枡鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "MAT_DATE")]
+ /// <summary>
+ /// 棰嗘枡鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "MAT_DATE")]
public DateTime? MatDate { get; set; }
- /// <summary>
- /// 宸ヤ綔涓績
- /// </summary>
- [SugarColumn(ColumnName = "WORKCENTER_NO")]
+ /// <summary>
+ /// 宸ヤ綔涓績
+ /// </summary>
+ [SugarColumn(ColumnName = "WORKCENTER_NO")]
public string WorkcenterNo { get; set; }
- /// <summary>
- /// 宸蹭笅杞借鍗曟爣璇哬-宸蹭笅杞�,N-鏈笅杞�
- /// </summary>
- [SugarColumn(ColumnName = "DOWN_FLAG")]
+ /// <summary>
+ /// 宸蹭笅杞借鍗曟爣璇哬-宸蹭笅杞�,N-鏈笅杞�
+ /// </summary>
+ [SugarColumn(ColumnName = "DOWN_FLAG")]
public short? DownFlag { get; set; }
- /// <summary>
- /// 鐜繚浠ｇ爜
- /// </summary>
- [SugarColumn(ColumnName = "ROHSE_CODE")]
+ /// <summary>
+ /// 鐜繚浠ｇ爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ROHSE_CODE")]
public string RohseCode { get; set; }
- /// <summary>
- /// 瀹㈡埛PO
- /// </summary>
- [SugarColumn(ColumnName = "CUST_PO")]
+ /// <summary>
+ /// 瀹㈡埛PO
+ /// </summary>
+ [SugarColumn(ColumnName = "CUST_PO")]
public string CustPo { get; set; }
- /// <summary>
- /// 瀹㈡埛鍨嬪彿
- /// </summary>
- [SugarColumn(ColumnName = "CUST_STYLE")]
+ /// <summary>
+ /// 瀹㈡埛鍨嬪彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CUST_STYLE")]
public string CustStyle { get; set; }
- /// <summary>
- /// 浜у搧鎵撳嵃鍥哄畾鍊�
- /// </summary>
- [SugarColumn(ColumnName = "PROC_PRINT_VALUE")]
+ /// <summary>
+ /// 浜у搧鎵撳嵃鍥哄畾鍊�
+ /// </summary>
+ [SugarColumn(ColumnName = "PROC_PRINT_VALUE")]
public string ProcPrintValue { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_BY")]
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_DATE")]
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏇存柊浜�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ /// <summary>
+ /// 鏇存柊浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string LastupdateBy { get; set; }
- /// <summary>
- /// 鏇存柊鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ /// <summary>
+ /// 鏇存柊鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "MEMO")]
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "MEMO")]
public string Memo { get; set; }
- /// <summary>
- /// 瀹℃壒鐘舵��
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_STATUS")]
+ /// <summary>
+ /// 瀹℃壒鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_STATUS")]
public string FcheckStatus { get; set; }
- /// <summary>
- /// 瀹℃牳浜�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_BY")]
+ /// <summary>
+ /// 瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_BY")]
public string FcheckBy { get; set; }
- /// <summary>
- /// 瀹℃牳鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_DATE")]
+ /// <summary>
+ /// 瀹℃牳鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_DATE")]
public DateTime? FcheckDate { get; set; }
- /// <summary>
- /// 宸ュ巶
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ /// 宸ュ巶
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
public string Factory { get; set; }
- /// <summary>
- /// 鍏徃
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ /// 鍏徃
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
public string Company { get; set; }
- /// <summary>
- /// 鏁版嵁鏉ユ簮
- /// </summary>
- [SugarColumn(ColumnName = "DATA_FROM")]
+ /// <summary>
+ /// 鏁版嵁鏉ユ簮
+ /// </summary>
+ [SugarColumn(ColumnName = "DATA_FROM")]
public string DataFrom { get; set; }
- /// <summary>
- /// 鐢熶骇璁㈠崟琛ㄥごID
- /// </summary>
- [SugarColumn(ColumnName = "MOID")]
+ /// <summary>
+ /// 鐢熶骇璁㈠崟琛ㄥごID
+ /// </summary>
+ [SugarColumn(ColumnName = "MOID")]
public decimal? Moid { get; set; }
- /// <summary>
- /// 鐗╂枡ID
- /// </summary>
- [SugarColumn(ColumnName = "PARTID")]
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "PARTID")]
public decimal? Partid { get; set; }
- /// <summary>
- /// ERP宸ュ崟鐘舵�� 鐘舵�侊紙NA-寮�绔�/FM-閿佸畾/OP-瀹℃牳/CL-鍏抽棴锛�
- /// </summary>
- [SugarColumn(ColumnName = "STATUS")]
+ /// <summary>
+ /// ERP宸ュ崟鐘舵�� 鐘舵�侊紙NA-寮�绔�/FM-閿佸畾/OP-瀹℃牳/CL-鍏抽棴锛�
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
public string Status { get; set; }
- /// <summary>
- /// 鐢熶骇宸ュ崟
- /// </summary>
- [SugarColumn(ColumnName = "MOCODE")]
+ /// <summary>
+ /// 鐢熶骇宸ュ崟
+ /// </summary>
+ [SugarColumn(ColumnName = "MOCODE")]
public string Mocode { get; set; }
- /// <summary>
- /// 鍒涘缓鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "CREATEDATE")]
+ /// <summary>
+ /// 鍒涘缓鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATEDATE")]
public DateTime? Createdate { get; set; }
- /// <summary>
- /// 棰滆壊
- /// </summary>
- [SugarColumn(ColumnName = "COLOR_NAME")]
+ /// <summary>
+ /// 棰滆壊
+ /// </summary>
+ [SugarColumn(ColumnName = "COLOR_NAME")]
public string ColorName { get; set; }
- /// <summary>
- /// 鍏抽棴鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CLOSETIME")]
+ /// <summary>
+ /// 鍏抽棴鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CLOSETIME")]
public DateTime? Closetime { get; set; }
- /// <summary>
- /// 鐗╂枡缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
+ /// <summary>
+ /// 鐗╂枡缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
public string ItemNo { get; set; }
- /// <summary>
- /// 浠庤〃ID
- /// </summary>
- [SugarColumn(ColumnName = "MODID")]
+ /// <summary>
+ /// 浠庤〃ID
+ /// </summary>
+ [SugarColumn(ColumnName = "MODID")]
public decimal? Modid { get; set; }
- /// <summary>
- /// 鏈�鏂颁笅杞芥洿鏂版爣璇�
- /// </summary>
- [SugarColumn(ColumnName = "UPDATE_FLG")]
+ /// <summary>
+ /// 鏈�鏂颁笅杞芥洿鏂版爣璇�
+ /// </summary>
+ [SugarColumn(ColumnName = "UPDATE_FLG")]
public decimal? UpdateFlg { get; set; }
- /// <summary>
- /// 鐢熶骇宸ュ崟琛屽彿
- /// </summary>
- [SugarColumn(ColumnName = "MOCODE_LINE")]
+ /// <summary>
+ /// 鐢熶骇宸ュ崟琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "MOCODE_LINE")]
public decimal? MocodeLine { get; set; }
- /// <summary>
- /// 涓濆嵃鎬绘暟
- /// </summary>
- [SugarColumn(ColumnName = "SILK_QTY")]
+ /// <summary>
+ /// 涓濆嵃鎬绘暟
+ /// </summary>
+ [SugarColumn(ColumnName = "SILK_QTY")]
public decimal? SilkQty { get; set; }
- /// <summary>
- /// 涓濆嵃鍗曚环
- /// </summary>
- [SugarColumn(ColumnName = "SILK_PRICE")]
+ /// <summary>
+ /// 涓濆嵃鍗曚环
+ /// </summary>
+ [SugarColumn(ColumnName = "SILK_PRICE")]
public decimal? SilkPrice { get; set; }
- /// <summary>
- /// 鐗╂枡ID
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_ID")]
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_ID")]
public decimal? ItemId { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesDeptUser.cs b/StandardPda/MES.Service/Modes/MesDeptUser.cs
index 287728a..ae41f39 100644
--- a/StandardPda/MES.Service/Modes/MesDeptUser.cs
+++ b/StandardPda/MES.Service/Modes/MesDeptUser.cs
@@ -1,80 +1,75 @@
-锘縰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_DEPT_USER")]
+public class MesDeptUser
{
/// <summary>
- ///
- ///</summary>
- [SugarTable("MES_DEPT_USER")]
- public class MesDeptUser
- {
- /// <summary>
- /// SEQ_USER
- ///</summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
- public decimal Id { get; set; }
+ /// SEQ_USER
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
- /// <summary>
- /// 杞﹂棿
- ///</summary>
- [SugarColumn(ColumnName = "WORKSHOP")]
- public string Workshop { get; set; }
+ /// <summary>
+ /// 杞﹂棿
+ /// </summary>
+ [SugarColumn(ColumnName = "WORKSHOP")]
+ public string Workshop { get; set; }
- /// <summary>
- /// 缂栫爜
- ///</summary>
- [SugarColumn(ColumnName = "CODE")]
- public string Code { get; set; }
+ /// <summary>
+ /// 缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "CODE")]
+ public string Code { get; set; }
- /// <summary>
- /// 鐢ㄦ埛
- ///</summary>
- [SugarColumn(ColumnName = "USER_NO")]
- public string UserNo { get; set; }
+ /// <summary>
+ /// 鐢ㄦ埛
+ /// </summary>
+ [SugarColumn(ColumnName = "USER_NO")]
+ public string UserNo { get; set; }
- /// <summary>
- /// 宀椾綅
- ///</summary>
- [SugarColumn(ColumnName = "POST")]
- public string Post { get; set; }
+ /// <summary>
+ /// 宀椾綅
+ /// </summary>
+ [SugarColumn(ColumnName = "POST")]
+ public string Post { get; set; }
- /// <summary>
- /// 鐢佃瘽
- ///</summary>
- [SugarColumn(ColumnName = "PHONE")]
- public string Phone { get; set; }
+ /// <summary>
+ /// 鐢佃瘽
+ /// </summary>
+ [SugarColumn(ColumnName = "PHONE")]
+ public string Phone { get; set; }
- /// <summary>
- /// 鏄惁绂昏亴
- ///</summary>
- [SugarColumn(ColumnName = "IS_DEPARTURE")]
- public short? IsDeparture { get; set; }
+ /// <summary>
+ /// 鏄惁绂昏亴
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_DEPARTURE")]
+ public short? IsDeparture { get; set; }
- /// <summary>
- /// 0鏈鏍� 1瀹℃牳
- ///</summary>
- [SugarColumn(ColumnName = "STATUS")]
- public decimal? Status { get; set; }
+ /// <summary>
+ /// 0鏈鏍� 1瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
+ public decimal? Status { get; set; }
- /// <summary>
- /// 瀹℃牳浜�
- ///</summary>
- [SugarColumn(ColumnName = "ISSUED_BY")]
- public string IssuedBy { get; set; }
+ /// <summary>
+ /// 瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "ISSUED_BY")]
+ public string IssuedBy { get; set; }
- /// <summary>
- /// 瀹℃牳鏃堕棿
- ///</summary>
- [SugarColumn(ColumnName = "ISSUED_DATE")]
- public DateTime? IssuedDate { get; set; }
+ /// <summary>
+ /// 瀹℃牳鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "ISSUED_DATE")]
+ public DateTime? IssuedDate { get; set; }
- /// <summary>
- /// 鐢ㄦ埛鍚�
- ///</summary>
- [SugarColumn(ColumnName = "USER_NAME")]
- public string UserName { get; set; }
- }
+ /// <summary>
+ /// 鐢ㄦ埛鍚�
+ /// </summary>
+ [SugarColumn(ColumnName = "USER_NAME")]
+ public string UserName { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesInvItemArn.cs b/StandardPda/MES.Service/Modes/MesInvItemArn.cs
index 518f09f..bf0d207 100644
--- a/StandardPda/MES.Service/Modes/MesInvItemArn.cs
+++ b/StandardPda/MES.Service/Modes/MesInvItemArn.cs
@@ -8,232 +8,232 @@
[SugarTable("MES_INV_ITEM_ARN")]
public class MesInvItemArn
{
- /// <summary>
- /// ID(SEQ_INV_ID)
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ /// ID(SEQ_INV_ID)
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
- /// <summary>
- /// 鍒拌揣鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "BILL_NO")]
+ /// <summary>
+ /// 鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
public string BillNo { get; set; }
- /// <summary>
- /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
- /// </summary>
- [SugarColumn(ColumnName = "STATUS")]
+ /// <summary>
+ /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
public short? Status { get; set; }
- /// <summary>
- /// 鍘熷洜
- /// </summary>
- [SugarColumn(ColumnName = "REASON")]
+ /// <summary>
+ /// 鍘熷洜
+ /// </summary>
+ [SugarColumn(ColumnName = "REASON")]
public string Reason { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_BY")]
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_DATE")]
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string LastupdateBy { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 鍗曟嵁绫诲瀷ID
- /// </summary>
- [SugarColumn(ColumnName = "BILL_TYPE_ID")]
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_TYPE_ID")]
public decimal? BillTypeId { get; set; }
- /// <summary>
- /// 浜嬪姟绫诲瀷ID
- /// </summary>
- [SugarColumn(ColumnName = "TRANSACTION_ID")]
+ /// <summary>
+ /// 浜嬪姟绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_ID")]
public decimal? TransactionId { get; set; }
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK")]
public string Remark { get; set; }
- /// <summary>
- /// 閫佽揣鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "PAPER_BILL_NO")]
+ /// <summary>
+ /// 閫佽揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_BILL_NO")]
public string PaperBillNo { get; set; }
- /// <summary>
- /// 閫�鏂欎汉宸ュ彿
- /// </summary>
- [SugarColumn(ColumnName = "USER_NO_BACK")]
+ /// <summary>
+ /// 閫�鏂欎汉宸ュ彿
+ /// </summary>
+ [SugarColumn(ColumnName = "USER_NO_BACK")]
public string UserNoBack { get; set; }
- /// <summary>
- /// 鎻愪氦浜�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_USER")]
+ /// <summary>
+ /// 鎻愪氦浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_USER")]
public string CheckUser { get; set; }
- /// <summary>
- /// 鎻愪氦鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_DATE")]
+ /// <summary>
+ /// 鎻愪氦鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_DATE")]
public DateTime? CheckDate { get; set; }
- /// <summary>
- /// 鍏ュ簱鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "INS_DATE")]
+ /// <summary>
+ /// 鍏ュ簱鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "INS_DATE")]
public DateTime? InsDate { get; set; }
- /// <summary>
- /// 妫�楠岀粨鏋�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_RES")]
+ /// <summary>
+ /// 妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_RES")]
public string CheckRes { get; set; }
- /// <summary>
- /// 宸叉崱鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_QTY")]
+ /// <summary>
+ /// 宸叉崱鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QTY")]
public decimal? CheckQty { get; set; }
- /// <summary>
- /// 浠撳簱缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DEPOTS_CODE")]
+ /// <summary>
+ /// 浠撳簱缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOTS_CODE")]
public string DepotsCode { get; set; }
- /// <summary>
- /// 浜嬪姟绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "TRANSCTION_NO")]
+ /// <summary>
+ /// 浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSCTION_NO")]
public string TransctionNo { get; set; }
- /// <summary>
- /// 渚涘簲鍟嗙紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
+ /// <summary>
+ /// 渚涘簲鍟嗙紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
public string SuppNo { get; set; }
- /// <summary>
- /// 鎻愪氦鐘舵��
- /// </summary>
- [SugarColumn(ColumnName = "FSTATUS")]
+ /// <summary>
+ /// 鎻愪氦鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "FSTATUS")]
public short? Fstatus { get; set; }
- /// <summary>
- /// 宸ュ巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ /// 宸ュ巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
public string Factory { get; set; }
- /// <summary>
- /// 鏄惁宸插洖鍐橲AP
- /// </summary>
- [SugarColumn(ColumnName = "SAPSTATUS")]
+ /// <summary>
+ /// 鏄惁宸插洖鍐橲AP
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPSTATUS")]
public short? Sapstatus { get; set; }
- /// <summary>
- /// 纭鍏ュ簱鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "INS_DATE")]
+ /// <summary>
+ /// 纭鍏ュ簱鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "INS_DATE")]
public DateTime? Insdate { get; set; }
- /// <summary>
- /// 鏄惁妫�楠�
- /// </summary>
- [SugarColumn(ColumnName = "ISCHECK")]
+ /// <summary>
+ /// 鏄惁妫�楠�
+ /// </summary>
+ [SugarColumn(ColumnName = "ISCHECK")]
public decimal? Ischeck { get; set; }
- /// <summary>
- /// 瀹℃牳鍏ュ簱浜�
- /// </summary>
- [SugarColumn(ColumnName = "INSBY")]
+ /// <summary>
+ /// 瀹℃牳鍏ュ簱浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "INSBY")]
public string Insby { get; set; }
- /// <summary>
- /// 鍏徃浠ｇ爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
public string Company { get; set; }
- /// <summary>
- /// 鎬ユ枡鏍囪瘑
- /// </summary>
- [SugarColumn(ColumnName = "URGENT_FLAG")]
+ /// <summary>
+ /// 鎬ユ枡鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "URGENT_FLAG")]
public short? UrgentFlag { get; set; }
- /// <summary>
- /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
+ /// <summary>
+ /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
public decimal? MttransctionNo { get; set; }
- /// <summary>
- /// IQC妫�楠屽崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
+ /// <summary>
+ /// IQC妫�楠屽崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
public string IqcReleaseNo { get; set; }
- /// <summary>
- /// 鏄惁鏄剧ず
- /// </summary>
- [SugarColumn(ColumnName = "IS_VISUAL")]
+ /// <summary>
+ /// 鏄惁鏄剧ず
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_VISUAL")]
public decimal? IsVisual { get; set; }
- /// <summary>
- /// 0=閲囪喘锛�1=濮斿
- /// </summary>
- [SugarColumn(ColumnName = "F_TYPE")]
+ /// <summary>
+ /// 0=閲囪喘锛�1=濮斿
+ /// </summary>
+ [SugarColumn(ColumnName = "F_TYPE")]
public decimal? FType { get; set; }
- /// <summary>
- /// ERP鍒拌揣鍗旾D
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_K3ID")]
+ /// <summary>
+ /// ERP鍒拌揣鍗旾D
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN_K3ID")]
public string EbelnK3id { get; set; }
- /// <summary>
- /// 鏉＄爜鏉″嵃杩涘害
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_RATIO")]
+ /// <summary>
+ /// 鏉＄爜鏉″嵃杩涘害
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_RATIO")]
public decimal? BarcodeRatio { get; set; }
- /// <summary>
- /// ERP鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "ERPNO")]
+ /// <summary>
+ /// ERP鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ERPNO")]
public string Erpno { get; set; }
- /// <summary>
- /// 鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐�
- /// </summary>
- [SugarColumn(ColumnName = "THSTATUS")]
+ /// <summary>
+ /// 鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐�
+ /// </summary>
+ [SugarColumn(ColumnName = "THSTATUS")]
public short? Thstatus { get; set; }
- /// <summary>
- /// ERP閫�璐у崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "ERPTHNO")]
+ /// <summary>
+ /// ERP閫�璐у崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "ERPTHNO")]
public string Erpthno { get; set; }
diff --git a/StandardPda/MES.Service/Modes/MesInvItemInCDetails2.cs b/StandardPda/MES.Service/Modes/MesInvItemInCDetails2.cs
index 4d50f32..e961dce 100644
--- a/StandardPda/MES.Service/Modes/MesInvItemInCDetails2.cs
+++ b/StandardPda/MES.Service/Modes/MesInvItemInCDetails2.cs
@@ -1,368 +1,364 @@
-锘縰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_INV_ITEM_IN_C_DETAILS2")]
+public class MesInvItemInCDetails2
{
/// <summary>
- /// 鐗╂枡鎴愬搧鍏ュ簱鐢宠鏉＄爜鏄庣粏
- ///</summary>
- [SugarTable("MES_INV_ITEM_IN_C_DETAILS2")]
- public class MesInvItemInCDetails2
- {
- /// <summary>
- /// SEQ_OUT
- ///</summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
- public decimal Id { get; set; }
+ /// SEQ_OUT
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
- /// <summary>
- /// 鍏ュ簱鍗昳d
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)]
- public decimal ItemInId { get; set; }
+ /// <summary>
+ /// 鍏ュ簱鍗昳d
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)]
+ public decimal ItemInId { get; set; }
- /// <summary>
- /// 鐗╂枡鏉＄爜PSN
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
- public string ItemBarcode { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏉＄爜PSN
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE")]
+ public string ItemBarcode { get; set; }
- /// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- ///</summary>
- [SugarColumn(ColumnName = "C_ITEM_CODE")]
- public string CItemCode { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
+ /// </summary>
+ [SugarColumn(ColumnName = "C_ITEM_CODE")]
+ public string CItemCode { get; set; }
- /// <summary>
- /// 瀹㈡埛鐗╂枡鏉＄爜
- ///</summary>
- [SugarColumn(ColumnName = "C_ITEM_BARCODE")]
- public string CItemBarcode { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡鏉＄爜
+ /// </summary>
+ [SugarColumn(ColumnName = "C_ITEM_BARCODE")]
+ public string CItemBarcode { get; set; }
- /// <summary>
- /// 楠屾敹鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "QUANTITY")]
- public decimal? Quantity { get; set; }
+ /// <summary>
+ /// 楠屾敹鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "QUANTITY")]
+ public decimal? Quantity { get; set; }
- /// <summary>
- /// 鍏ュ簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�)
- ///</summary>
- [SugarColumn(ColumnName = "BARCODE_FLAG")]
- public short? BarcodeFlag { get; set; }
+ /// <summary>
+ /// 鍏ュ簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�)
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_FLAG")]
+ public short? BarcodeFlag { get; set; }
- /// <summary>
- /// 鐜繚鏍囧織锛�0-闈炵幆淇�,1-鐜繚.鏃犳潯鐮佹墜宸ュ綍鍏ワ紝鏈夋潯鐮佷负鍐椾綑瀛楁锛�
- ///</summary>
- [SugarColumn(ColumnName = "EP_FLAG")]
- public short? EpFlag { get; set; }
+ /// <summary>
+ /// 鐜繚鏍囧織锛�0-闈炵幆淇�,1-鐜繚.鏃犳潯鐮佹墜宸ュ綍鍏ワ紝鏈夋潯鐮佷负鍐椾綑瀛楁锛�
+ /// </summary>
+ [SugarColumn(ColumnName = "EP_FLAG")]
+ public short? EpFlag { 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>
- /// 浣滀笟鏂瑰紡0-鏈夌嚎鏉＄爜鏋�1-鏃犵嚎鏉＄爜鏋�
- ///</summary>
- [SugarColumn(ColumnName = "WORK_TYPE")]
- public decimal? WorkType { get; set; }
+ /// <summary>
+ /// 浣滀笟鏂瑰紡0-鏈夌嚎鏉＄爜鏋�1-鏃犵嚎鏉＄爜鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_TYPE")]
+ public decimal? WorkType { get; set; }
- /// <summary>
- /// 鏈徃鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
- public string ItemNo { get; set; }
+ /// <summary>
+ /// 鏈徃鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
+ public string ItemNo { get; set; }
- /// <summary>
- /// 鍘傚鎵规
- ///</summary>
- [SugarColumn(ColumnName = "LOT_NO")]
- public string LotNo { get; set; }
+ /// <summary>
+ /// 鍘傚鎵规
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO")]
+ public string LotNo { get; set; }
- /// <summary>
- /// 鏄惁鍏辩鐗╂枡(0:鍚︼紝1:鏄�)
- ///</summary>
- [SugarColumn(ColumnName = "COMANAGEMENT_FLAG")]
- public short? ComanagementFlag { get; set; }
+ /// <summary>
+ /// 鏄惁鍏辩鐗╂枡(0:鍚︼紝1:鏄�)
+ /// </summary>
+ [SugarColumn(ColumnName = "COMANAGEMENT_FLAG")]
+ public short? ComanagementFlag { 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 = "CHECK_RES")]
- public string CheckRes { get; set; }
+ /// <summary>
+ /// 妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_RES")]
+ public string CheckRes { get; set; }
- /// <summary>
- /// 杩涜揣鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "CHECK_QTY")]
- public decimal? CheckQty { get; set; }
+ /// <summary>
+ /// 杩涜揣鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QTY")]
+ public decimal? CheckQty { get; set; }
- /// <summary>
- /// 妫�楠岀姸鎬�
- ///</summary>
- [SugarColumn(ColumnName = "CHECK_STATES")]
- public string CheckStates { get; set; }
+ /// <summary>
+ /// 妫�楠岀姸鎬�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_STATES")]
+ public string CheckStates { get; set; }
- /// <summary>
- /// 寮哄埗鍏ュ簱鏍囪0鏃狅紝1-寮哄埗鍏ュ簱 閫�鏂欏崟浣跨敤
- ///</summary>
- [SugarColumn(ColumnName = "FORCE_IN_FLAG")]
- public short? ForceInFlag { get; set; }
+ /// <summary>
+ /// 寮哄埗鍏ュ簱鏍囪0鏃狅紝1-寮哄埗鍏ュ簱 閫�鏂欏崟浣跨敤
+ /// </summary>
+ [SugarColumn(ColumnName = "FORCE_IN_FLAG")]
+ public short? ForceInFlag { 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 = "DEPOT_SECTION_CODE")]
- public string DepotSectionCode { get; set; }
+ /// <summary>
+ /// 璐т綅缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
+ public string DepotSectionCode { get; set; }
- /// <summary>
- /// 鐗硅浜嬮」
- ///</summary>
- [SugarColumn(ColumnName = "REMARK")]
- public string Remark { get; set; }
+ /// <summary>
+ /// 鐗硅浜嬮」
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK")]
+ public string Remark { get; set; }
- /// <summary>
- /// 鐗╂枡鏉＄爜
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE2")]
- public string ItemBarcode2 { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏉＄爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE2")]
+ public string ItemBarcode2 { get; set; }
- /// <summary>
- /// 鏂版潯鐮�
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE3")]
- public string ItemBarcode3 { get; set; }
+ /// <summary>
+ /// 鏂版潯鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE3")]
+ public string ItemBarcode3 { get; set; }
- /// <summary>
- /// 浣跨敤鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "USE_QTY")]
- public decimal? UseQty { get; set; }
+ /// <summary>
+ /// 浣跨敤鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "USE_QTY")]
+ public decimal? UseQty { get; set; }
- /// <summary>
- /// 棰嗘枡鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "OUT_QTY")]
- public decimal? OutQty { get; set; }
+ /// <summary>
+ /// 棰嗘枡鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "OUT_QTY")]
+ public decimal? OutQty { 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 = "SPOSTION")]
- public decimal? Spostion { get; set; }
+ /// <summary>
+ /// 妗ｄ綅浣庡��
+ /// </summary>
+ [SugarColumn(ColumnName = "SPOSTION")]
+ public decimal? Spostion { get; set; }
- /// <summary>
- /// 妗ｄ綅楂樺��
- ///</summary>
- [SugarColumn(ColumnName = "EPOSTION")]
- public decimal? Epostion { get; set; }
+ /// <summary>
+ /// 妗ｄ綅楂樺��
+ /// </summary>
+ [SugarColumn(ColumnName = "EPOSTION")]
+ public decimal? Epostion { 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 = "UNIT")]
- public string Unit { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "UNIT")]
+ public string Unit { get; set; }
- /// <summary>
- /// 鏄惁妫�楠�
- ///</summary>
- [SugarColumn(ColumnName = "ISCHECK")]
- public decimal? Ischeck { get; set; }
+ /// <summary>
+ /// 鏄惁妫�楠�
+ /// </summary>
+ [SugarColumn(ColumnName = "ISCHECK")]
+ public decimal? Ischeck { get; set; }
- /// <summary>
- /// 閲囪喘璁㈠崟
- ///</summary>
- [SugarColumn(ColumnName = "EBELN")]
- public string Ebeln { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN")]
+ public string Ebeln { get; set; }
- /// <summary>
- /// 鐢熶骇鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName = "LOT_DATE")]
- public string LotDate { get; set; }
+ /// <summary>
+ /// 鐢熶骇鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_DATE")]
+ public string LotDate { get; set; }
- /// <summary>
- /// 鍏ュ簱鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "BILL_NO")]
- public string BillNo { get; set; }
+ /// <summary>
+ /// 鍏ュ簱鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
+ public string BillNo { get; set; }
- /// <summary>
- /// 鍏ュ簱瀹℃牳鏍囧織
- ///</summary>
- [SugarColumn(ColumnName = "STOCK_OK")]
- public short? StockOk { get; set; }
+ /// <summary>
+ /// 鍏ュ簱瀹℃牳鏍囧織
+ /// </summary>
+ [SugarColumn(ColumnName = "STOCK_OK")]
+ public short? StockOk { 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>
- /// 鍗℃澘缂栫爜
- ///</summary>
- [SugarColumn(ColumnName = "CB_NO")]
- public string CbNo { get; set; }
+ /// <summary>
+ /// 鍗℃澘缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "CB_NO")]
+ public string CbNo { get; set; }
- /// <summary>
- /// 绠卞彿
- ///</summary>
- [SugarColumn(ColumnName = "BOX_NO")]
- public string BoxNo { get; set; }
+ /// <summary>
+ /// 绠卞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BOX_NO")]
+ public string BoxNo { get; set; }
- /// <summary>
- /// 浠撳簱ID
- ///</summary>
- [SugarColumn(ColumnName = "DEPOT_ID")]
- public decimal? DepotId { get; set; }
+ /// <summary>
+ /// 浠撳簱ID
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_ID")]
+ public decimal? DepotId { get; set; }
- /// <summary>
- /// 璐т綅ID
- ///</summary>
- [SugarColumn(ColumnName = "DEPOT_SECTION_ID")]
- public decimal? DepotSectionId { get; set; }
+ /// <summary>
+ /// 璐т綅ID
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_SECTION_ID")]
+ public decimal? DepotSectionId { get; set; }
- /// <summary>
- /// 琛屽彿
- ///</summary>
- [SugarColumn(ColumnName = "LINE_NUM")]
- public string LineNum { get; set; }
+ /// <summary>
+ /// 琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_NUM")]
+ public string LineNum { get; set; }
- /// <summary>
- /// 鎵爜鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "SM_QTY")]
- public decimal? SmQty { get; set; }
+ /// <summary>
+ /// 鎵爜鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "SM_QTY")]
+ public decimal? SmQty { get; set; }
- /// <summary>
- /// 閿�鍞鍗�
- ///</summary>
- [SugarColumn(ColumnName = "VGBEL")]
- public string Vgbel { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗�
+ /// </summary>
+ [SugarColumn(ColumnName = "VGBEL")]
+ public string Vgbel { get; set; }
- /// <summary>
- /// 閿�鍞鍗曡鍙�
- ///</summary>
- [SugarColumn(ColumnName = "KDPOS")]
- public decimal? Kdpos { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗曡鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "KDPOS")]
+ public decimal? Kdpos { get; set; }
- /// <summary>
- /// 浠诲姟鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "WORK_NO")]
- public string WorkNo { get; set; }
+ /// <summary>
+ /// 浠诲姟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_NO")]
+ public string WorkNo { get; set; }
- /// <summary>
- /// 琛屽彿
- ///</summary>
- [SugarColumn(ColumnName = "EBELN_LINE_NO")]
- public decimal? EbelnLineNo { get; set; }
+ /// <summary>
+ /// 琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN_LINE_NO")]
+ public decimal? EbelnLineNo { get; set; }
- /// <summary>
- /// 鍒拌揣鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "CBILL_NO")]
- public string CbillNo { get; set; }
+ /// <summary>
+ /// 鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CBILL_NO")]
+ public string CbillNo { get; set; }
- /// <summary>
- /// 鎬ユ枡鏍囪瘑
- ///</summary>
- [SugarColumn(ColumnName = "URGENT_FLAG")]
- public decimal? UrgentFlag { get; set; }
+ /// <summary>
+ /// 鎬ユ枡鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "URGENT_FLAG")]
+ public decimal? UrgentFlag { get; set; }
- /// <summary>
- /// 浜у搧鍨嬪彿
- ///</summary>
- [SugarColumn(ColumnName = "BOARD_STYLE")]
- public string BoardStyle { get; set; }
+ /// <summary>
+ /// 浜у搧鍨嬪彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BOARD_STYLE")]
+ public string BoardStyle { get; set; }
- /// <summary>
- /// 浠诲姟鍗曡鍙�
- ///</summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
- public decimal? WorkLine { get; set; }
+ /// <summary>
+ /// 浠诲姟鍗曡鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_LINE")]
+ public decimal? WorkLine { get; set; }
- /// <summary>
- /// 鐢熶骇宸ュ崟
- ///</summary>
- [SugarColumn(ColumnName = "TASK_NO")]
- public string TaskNo { get; set; }
+ /// <summary>
+ /// 鐢熶骇宸ュ崟
+ /// </summary>
+ [SugarColumn(ColumnName = "TASK_NO")]
+ public string TaskNo { get; set; }
- /// <summary>
- /// 渚涘簲鍟�
- ///</summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
- public string SuppNo { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟�
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
+ public string SuppNo { get; set; }
- /// <summary>
- /// 浠诲姟姹囨姤鍗�
- ///</summary>
- [SugarColumn(ColumnName = "RBILL_NO")]
- public string RbillNo { get; set; }
+ /// <summary>
+ /// 浠诲姟姹囨姤鍗�
+ /// </summary>
+ [SugarColumn(ColumnName = "RBILL_NO")]
+ public string RbillNo { 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; }
- /// <summary>
- /// 宸ュ崟鎶ュ伐ID (鐢ㄤ簬妫�楠屽崟鏇存柊鎶ュ伐琛ㄤ笂鐨勬楠岀粨鏋�)
- ///</summary>
- [SugarColumn(ColumnName = "MES_SCGD_GX_ID")]
- public decimal? MesScgdGxId { get; set; }
- }
+ /// <summary>
+ /// 宸ュ崟鎶ュ伐ID (鐢ㄤ簬妫�楠屽崟鏇存柊鎶ュ伐琛ㄤ笂鐨勬楠岀粨鏋�)
+ /// </summary>
+ [SugarColumn(ColumnName = "MES_SCGD_GX_ID")]
+ public decimal? MesScgdGxId { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesInvItemInCItems.cs b/StandardPda/MES.Service/Modes/MesInvItemInCItems.cs
index 05e3293..9c3eb27 100644
--- a/StandardPda/MES.Service/Modes/MesInvItemInCItems.cs
+++ b/StandardPda/MES.Service/Modes/MesInvItemInCItems.cs
@@ -8,141 +8,141 @@
[SugarTable("MES_INV_ITEM_IN_C_ITEMS")]
public class MesInvItemInCItems
{
- /// <summary>
- /// SEQ_OUT
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ /// SEQ_OUT
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
- /// <summary>
- /// 鍏ュ簱鍗昳d
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)]
+ /// <summary>
+ /// 鍏ュ簱鍗昳d
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)]
public decimal ItemInId { get; set; }
- /// <summary>
- /// 楠屾敹鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
+ /// <summary>
+ /// 楠屾敹鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "QUANTITY")]
public decimal? Quantity { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_BY")]
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_DATE")]
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string LastupdateBy { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
public string ItemNo { get; set; }
- /// <summary>
- /// 浠撳簱缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_CODE")]
+ /// <summary>
+ /// 浠撳簱缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_CODE")]
public string DepotCode { get; set; }
- /// <summary>
- /// 璐т綅缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
+ /// <summary>
+ /// 璐т綅缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
public string DepotSectionCode { get; set; }
- /// <summary>
- /// 鐗硅浜嬮」
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
+ /// <summary>
+ /// 鐗硅浜嬮」
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK")]
public string Remark { get; set; }
- /// <summary>
- /// 鐗╂枡绠�绉�
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_SNAME")]
+ /// <summary>
+ /// 鐗╂枡绠�绉�
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_SNAME")]
public string ItemSname { get; set; }
- /// <summary>
- /// 鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "UNIT")]
+ /// <summary>
+ /// 鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "UNIT")]
public string Unit { get; set; }
- /// <summary>
- /// 閲囪喘璁㈠崟
- /// </summary>
- [SugarColumn(ColumnName = "EBELN")]
+ /// <summary>
+ /// 閲囪喘璁㈠崟
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN")]
public string Ebeln { get; set; }
- /// <summary>
- /// 鍏ュ簱鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "BILL_NO")]
+ /// <summary>
+ /// 鍏ュ簱鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
public string BillNo { get; set; }
- /// <summary>
- /// 鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ /// 鍒嗗巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
public string Factory { get; set; }
- /// <summary>
- /// 鍏徃浠ｇ爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
public string Company { get; set; }
- /// <summary>
- /// 浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
+ /// <summary>
+ /// 浠诲姟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_NO")]
public string WorkNo { get; set; }
- /// <summary>
- /// 琛屽彿
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_LINE_NO")]
+ /// <summary>
+ /// 琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN_LINE_NO")]
public decimal? EbelnLineNo { get; set; }
- /// <summary>
- /// 鍒拌揣鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "CBILL_NO")]
+ /// <summary>
+ /// 鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CBILL_NO")]
public string CbillNo { get; set; }
- /// <summary>
- /// 浠诲姟鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
+ /// <summary>
+ /// 浠诲姟鍗曡鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_LINE")]
public decimal? WorkLine { get; set; }
- /// <summary>
- /// 鐢熶骇宸ュ崟
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
+ /// <summary>
+ /// 鐢熶骇宸ュ崟
+ /// </summary>
+ [SugarColumn(ColumnName = "TASK_NO")]
public string TaskNo { get; set; }
- /// <summary>
- /// 渚涘簲鍟�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
+ /// <summary>
+ /// 渚涘簲鍟�
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
public string SuppNo { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesInvItemIns.cs b/StandardPda/MES.Service/Modes/MesInvItemIns.cs
index a65fee7..f88c333 100644
--- a/StandardPda/MES.Service/Modes/MesInvItemIns.cs
+++ b/StandardPda/MES.Service/Modes/MesInvItemIns.cs
@@ -16,302 +16,302 @@
public decimal Id { get; set; }
/// <summary>
- /// 鍏ュ簱鍗曞彿
- ///</summary>
+ /// 鍏ュ簱鍗曞彿
+ /// </summary>
[SugarColumn(ColumnName = "BILL_NO")]
public string BillNo { get; set; }
/// <summary>
- /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
- ///</summary>
+ /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
+ /// </summary>
[SugarColumn(ColumnName = "STATUS")]
public short? Status { get; set; }
/// <summary>
- /// 浠撳簱
- ///</summary>
+ /// 浠撳簱
+ /// </summary>
[SugarColumn(ColumnName = "DEPOTS_ID")]
public decimal? DepotsId { get; set; }
/// <summary>
- /// 鍘熷洜
- ///</summary>
+ /// 鍘熷洜
+ /// </summary>
[SugarColumn(ColumnName = "REASON")]
public string Reason { get; set; }
/// <summary>
- /// 鍒涘缓浜�
- ///</summary>
+ /// 鍒涘缓浜�
+ /// </summary>
[SugarColumn(ColumnName = "CREATE_BY")]
public string CreateBy { get; set; }
/// <summary>
- /// 鍒涘缓鏃堕棿
- ///</summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
[SugarColumn(ColumnName = "CREATE_DATE")]
public DateTime? CreateDate { get; set; }
/// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- ///</summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ /// </summary>
[SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string LastupdateBy { get; set; }
/// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- ///</summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
[SugarColumn(ColumnName = "LASTUPDATE_DATE")]
public DateTime? LastupdateDate { get; set; }
/// <summary>
- /// 鍗曟嵁绫诲瀷ID
- ///</summary>
+ /// 鍗曟嵁绫诲瀷ID
+ /// </summary>
[SugarColumn(ColumnName = "BILL_TYPE_ID")]
public decimal? BillTypeId { get; set; }
/// <summary>
- /// 浜嬪姟绫诲瀷ID
- ///</summary>
+ /// 浜嬪姟绫诲瀷ID
+ /// </summary>
[SugarColumn(ColumnName = "TRANSACTION_ID")]
public decimal? TransactionId { get; set; }
/// <summary>
- /// 澶囨敞
- ///</summary>
+ /// 澶囨敞
+ /// </summary>
[SugarColumn(ColumnName = "REMARK")]
public string Remark { get; set; }
/// <summary>
- /// 閫佽揣鍗曞彿
- ///</summary>
+ /// 閫佽揣鍗曞彿
+ /// </summary>
[SugarColumn(ColumnName = "PAPER_BILL_NO")]
public string PaperBillNo { get; set; }
/// <summary>
- /// 閫�鏂欎汉宸ュ彿
- ///</summary>
+ /// 閫�鏂欎汉宸ュ彿
+ /// </summary>
[SugarColumn(ColumnName = "USER_NO_BACK")]
public string UserNoBack { get; set; }
/// <summary>
- /// 瀹℃牳浜�
- ///</summary>
+ /// 瀹℃牳浜�
+ /// </summary>
[SugarColumn(ColumnName = "CHECK_USER")]
public string CheckUser { get; set; }
/// <summary>
- /// 瀹℃牳鏃ユ湡
- ///</summary>
+ /// 瀹℃牳鏃ユ湡
+ /// </summary>
[SugarColumn(ColumnName = "CHECK_DATE")]
public DateTime? CheckDate { get; set; }
/// <summary>
- /// 鐢熶骇璁㈠崟鍙�
- ///</summary>
+ /// 鐢熶骇璁㈠崟鍙�
+ /// </summary>
[SugarColumn(ColumnName = "TASK_NO")]
public string TaskNo { get; set; }
/// <summary>
- /// 鍏ュ簱鏃ユ湡
- ///</summary>
+ /// 鍏ュ簱鏃ユ湡
+ /// </summary>
[SugarColumn(ColumnName = "INS_DATE")]
public DateTime? InsDate { get; set; }
/// <summary>
- /// 妫�楠岀粨鏋�
- ///</summary>
+ /// 妫�楠岀粨鏋�
+ /// </summary>
[SugarColumn(ColumnName = "CHECK_RES")]
public string CheckRes { get; set; }
/// <summary>
- /// 宸叉崱鏁伴噺
- ///</summary>
+ /// 宸叉崱鏁伴噺
+ /// </summary>
[SugarColumn(ColumnName = "CHECK_QTY")]
public decimal? CheckQty { get; set; }
/// <summary>
- /// 棰嗘枡宸ユ
- ///</summary>
+ /// 棰嗘枡宸ユ
+ /// </summary>
[SugarColumn(ColumnName = "MMLIST")]
public string Mmlist { get; set; }
/// <summary>
- /// SAP閲囪喘璁㈠崟鍙�
- ///</summary>
+ /// SAP閲囪喘璁㈠崟鍙�
+ /// </summary>
[SugarColumn(ColumnName = "EBELN")]
public string Ebeln { get; set; }
/// <summary>
- /// 浠撳簱缂栫爜
- ///</summary>
+ /// 浠撳簱缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "DEPOTS_CODE")]
public string DepotsCode { get; set; }
/// <summary>
- /// 浜嬪姟绫诲瀷缂栫爜
- ///</summary>
+ /// 浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "TRANSCTION_NO")]
public string TransctionNo { get; set; }
/// <summary>
- /// 渚涘簲鍟嗙紪鐮�
- ///</summary>
+ /// 渚涘簲鍟嗙紪鐮�
+ /// </summary>
[SugarColumn(ColumnName = "SUPP_NO")]
public string SuppNo { get; set; }
/// <summary>
- /// 鍏ュ簱鐘舵��
- ///</summary>
+ /// 鍏ュ簱鐘舵��
+ /// </summary>
[SugarColumn(ColumnName = "FSTATUS")]
public short? Fstatus { get; set; }
/// <summary>
- /// 宸ュ巶缂栫爜
- ///</summary>
+ /// 宸ュ巶缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "FACTORY")]
public string Factory { get; set; }
/// <summary>
- /// 鏄惁宸插洖鍐橲AP
- ///</summary>
+ /// 鏄惁宸插洖鍐橲AP
+ /// </summary>
[SugarColumn(ColumnName = "SAPSTATUS")]
public short? Sapstatus { get; set; }
/// <summary>
- /// SAP杩斿洖鍗曟嵁
- ///</summary>
+ /// SAP杩斿洖鍗曟嵁
+ /// </summary>
[SugarColumn(ColumnName = "SAPNO")]
public string Sapno { get; set; }
/// <summary>
- /// SAP杩斿洖骞翠唤
- ///</summary>
+ /// SAP杩斿洖骞翠唤
+ /// </summary>
[SugarColumn(ColumnName = "SAPYEAR")]
public short? Sapyear { get; set; }
/// <summary>
- /// SAP杩斿洖淇℃伅
- ///</summary>
+ /// SAP杩斿洖淇℃伅
+ /// </summary>
[SugarColumn(ColumnName = "SAPTEXT")]
public string Saptext { get; set; }
/// <summary>
- /// 纭鍏ュ簱鏃ユ湡
- ///</summary>
+ /// 纭鍏ュ簱鏃ユ湡
+ /// </summary>
[SugarColumn(ColumnName = "INSDATE")]
public DateTime? Insdate { get; set; }
/// <summary>
- /// 鏄惁妫�楠�
- ///</summary>
+ /// 鏄惁妫�楠�
+ /// </summary>
[SugarColumn(ColumnName = "ISCHECK")]
public decimal? Ischeck { get; set; }
/// <summary>
- /// 瀹℃牳鍏ュ簱浜�
- ///</summary>
+ /// 瀹℃牳鍏ュ簱浜�
+ /// </summary>
[SugarColumn(ColumnName = "INSBY")]
public string Insby { get; set; }
/// <summary>
- /// 鏄惁鏄剧ず
- ///</summary>
+ /// 鏄惁鏄剧ず
+ /// </summary>
[SugarColumn(ColumnName = "IS_VISUAL")]
public decimal? IsVisual { get; set; }
/// <summary>
- /// 鍏徃浠ｇ爜
- ///</summary>
+ /// 鍏徃浠ｇ爜
+ /// </summary>
[SugarColumn(ColumnName = "COMPANY")]
public string Company { get; set; }
/// <summary>
- /// 鎬ユ枡鏍囪瘑
- ///</summary>
+ /// 鎬ユ枡鏍囪瘑
+ /// </summary>
[SugarColumn(ColumnName = "URGENT_FLAG")]
public short? UrgentFlag { get; set; }
/// <summary>
- /// 閲囪喘鍗曡鍙�
- ///</summary>
+ /// 閲囪喘鍗曡鍙�
+ /// </summary>
[SugarColumn(ColumnName = "LINE_NO")]
public string LineNo { get; set; }
/// <summary>
- /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
- ///</summary>
+ /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "MTTRANSCTION_NO")]
public decimal? MttransctionNo { get; set; }
/// <summary>
- /// 宸ュ崟琛屽彿
- ///</summary>
+ /// 宸ュ崟琛屽彿
+ /// </summary>
[SugarColumn(ColumnName = "TASK_LINO")]
public string TaskLino { get; set; }
/// <summary>
- /// 鎶曟枡閫氱煡鍗曞崟鍙�
- ///</summary>
+ /// 鎶曟枡閫氱煡鍗曞崟鍙�
+ /// </summary>
[SugarColumn(ColumnName = "FBILLNO")]
public string Fbillno { get; set; }
/// <summary>
- /// 鎶曟枡鍗曡鍙�
- ///</summary>
+ /// 鎶曟枡鍗曡鍙�
+ /// </summary>
[SugarColumn(ColumnName = "FBILL_LINO")]
public string FbillLino { get; set; }
/// <summary>
- /// 瀹㈡埛缂栧彿
- ///</summary>
+ /// 瀹㈡埛缂栧彿
+ /// </summary>
[SugarColumn(ColumnName = "CUST_NO")]
public string CustNo { get; set; }
/// <summary>
- /// 瀹㈡埛鍚嶇О
- ///</summary>
+ /// 瀹㈡埛鍚嶇О
+ /// </summary>
[SugarColumn(ColumnName = "CUST_NAME")]
public string CustName { get; set; }
/// <summary>
- /// IQC妫�楠屽崟鍙�
- ///</summary>
+ /// IQC妫�楠屽崟鍙�
+ /// </summary>
[SugarColumn(ColumnName = "IQC_RELEASE_NO")]
public string IqcReleaseNo { get; set; }
/// <summary>
- /// 鍒拌揣鍗曞彿
- ///</summary>
+ /// 鍒拌揣鍗曞彿
+ /// </summary>
[SugarColumn(ColumnName = "CBILL_NO")]
public string CbillNo { get; set; }
/// <summary>
- /// 0 鐢宠鍗曪紝1鍏ュ簱鍗曟爣璇�
- ///</summary>
+ /// 0 鐢宠鍗曪紝1鍏ュ簱鍗曟爣璇�
+ /// </summary>
[SugarColumn(ColumnName = "PICK_INS")]
public decimal? PickIns { get; set; }
/// <summary>
- /// 鍏ュ簱瀹℃牳浜�
- ///</summary>
+ /// 鍏ュ簱瀹℃牳浜�
+ /// </summary>
[SugarColumn(ColumnName = "FCHECK_USER")]
public string FcheckUser { get; set; }
/// <summary>
- /// 鍏ュ簱瀹℃牳鏃ユ湡
- ///</summary>
+ /// 鍏ュ簱瀹℃牳鏃ユ湡
+ /// </summary>
[SugarColumn(ColumnName = "FCHECK_DATE")]
public DateTime? FcheckDate { get; set; }
/// <summary>
- /// 浠诲姟姹囨姤鍗�/宸ュ崟鍙凤紙鎴愬搧鍏ュ簱锛�
- ///</summary>
+ /// 浠诲姟姹囨姤鍗�/宸ュ崟鍙凤紙鎴愬搧鍏ュ簱锛�
+ /// </summary>
[SugarColumn(ColumnName = "RBILL_NO")]
public string RbillNo { get; set; }
/// <summary>
- /// 鎶ュ伐浜�
- ///</summary>
+ /// 鎶ュ伐浜�
+ /// </summary>
[SugarColumn(ColumnName = "BGR")]
public string Bgr { get; set; }
diff --git a/StandardPda/MES.Service/Modes/MesInvItemMoves.cs b/StandardPda/MES.Service/Modes/MesInvItemMoves.cs
index b65928e..07b4ba6 100644
--- a/StandardPda/MES.Service/Modes/MesInvItemMoves.cs
+++ b/StandardPda/MES.Service/Modes/MesInvItemMoves.cs
@@ -8,171 +8,171 @@
[SugarTable("MES_INV_ITEM_MOVES")]
public class MesInvItemMoves
{
- /// <summary>
- /// SEQ_INV_ID
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ /// SEQ_INV_ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
- /// <summary>
- /// 绉诲簱鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "BILL_NO")]
+ /// <summary>
+ /// 绉诲簱鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
public string BillNo { get; set; }
- /// <summary>
- /// 绉诲叆瀛愬簱id
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
+ /// <summary>
+ /// 绉诲叆瀛愬簱id
+ /// </summary>
+ [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
public decimal? InvDepotsId { get; set; }
- /// <summary>
- /// 绉诲叆璐т綅id
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
+ /// <summary>
+ /// 绉诲叆璐т綅id
+ /// </summary>
+ [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
public decimal? InvDepotSectionsId { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_BY")]
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_DATE")]
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string LastupdateBy { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 鐘舵�亅0-鍒跺崟1-杩囪处
- /// </summary>
- [SugarColumn(ColumnName = "STATUS")]
+ /// <summary>
+ /// 鐘舵�亅0-鍒跺崟1-杩囪处
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
public decimal? Status { get; set; }
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK")]
public string Remark { get; set; }
- /// <summary>
- /// 鍗曟嵁绫诲瀷ID
- /// </summary>
- [SugarColumn(ColumnName = "BILL_TYPE_ID")]
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_TYPE_ID")]
public decimal? BillTypeId { get; set; }
- /// <summary>
- /// 浜嬪姟绫诲瀷ID
- /// </summary>
- [SugarColumn(ColumnName = "TRANSACTION_ID")]
+ /// <summary>
+ /// 浜嬪姟绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_ID")]
public decimal? TransactionId { get; set; }
- /// <summary>
- /// 瀹℃牳浜�
- /// </summary>
- [SugarColumn(ColumnName = "CHECKUSER")]
+ /// <summary>
+ /// 瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECKUSER")]
public string Checkuser { get; set; }
- /// <summary>
- /// 瀹℃牳鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "CHECKDATE")]
+ /// <summary>
+ /// 瀹℃牳鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECKDATE")]
public DateTime? Checkdate { get; set; }
- /// <summary>
- /// 绉诲叆瀛愬簱code
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
+ /// <summary>
+ /// 绉诲叆瀛愬簱code
+ /// </summary>
+ [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
public string InvDepotsCode { get; set; }
- /// <summary>
- /// 绉诲叆璐т綅code
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
+ /// <summary>
+ /// 绉诲叆璐т綅code
+ /// </summary>
+ [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
public string InvDepotSectionsCode { get; set; }
- /// <summary>
- /// 浜嬪姟绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "TRANSACTION_NO")]
+ /// <summary>
+ /// 浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_NO")]
public decimal? TransactionNo { get; set; }
- /// <summary>
- /// 绉诲嚭瀛愬簱code
- /// </summary>
- [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
+ /// <summary>
+ /// 绉诲嚭瀛愬簱code
+ /// </summary>
+ [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
public string FromDepotsCode { get; set; }
- /// <summary>
- /// 宸ュ巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY_CODE")]
+ /// <summary>
+ /// 宸ュ巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY_CODE")]
public string FactoryCode { get; set; }
- /// <summary>
- /// SAP杩斿洖鍗曟嵁
- /// </summary>
- [SugarColumn(ColumnName = "SAPNO")]
+ /// <summary>
+ /// SAP杩斿洖鍗曟嵁
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPNO")]
public string Sapno { get; set; }
- /// <summary>
- /// 宸插洖鍐橲AP
- /// </summary>
- [SugarColumn(ColumnName = "SAPSTATUS")]
+ /// <summary>
+ /// 宸插洖鍐橲AP
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPSTATUS")]
public short? Sapstatus { get; set; }
- /// <summary>
- /// SAP杩斿洖骞翠唤
- /// </summary>
- [SugarColumn(ColumnName = "SAPYEAR")]
+ /// <summary>
+ /// SAP杩斿洖骞翠唤
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPYEAR")]
public short? Sapyear { get; set; }
- /// <summary>
- /// SAP杩斿洖淇℃伅
- /// </summary>
- [SugarColumn(ColumnName = "SAPTEXT")]
+ /// <summary>
+ /// SAP杩斿洖淇℃伅
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPTEXT")]
public string Saptext { get; set; }
- /// <summary>
- /// 鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ /// 鍒嗗巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
public string Factory { get; set; }
- /// <summary>
- /// 鍏徃浠ｇ爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
public string Company { get; set; }
- /// <summary>
- /// 鍙嶅鏍镐簨鍔＄被鍨嬬紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "MTRANSACTION_NO")]
+ /// <summary>
+ /// 鍙嶅鏍镐簨鍔＄被鍨嬬紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "MTRANSACTION_NO")]
public decimal? MtransactionNo { get; set; }
- /// <summary>
- /// 鑷姩淇濆瓨瀛楁
- /// </summary>
- [SugarColumn(ColumnName = "ZD_NUM")]
+ /// <summary>
+ /// 鑷姩淇濆瓨瀛楁
+ /// </summary>
+ [SugarColumn(ColumnName = "ZD_NUM")]
public decimal? ZdNum { get; set; }
- /// <summary>
- /// 鏄惁鎺ㄩ�丒RP1-鏄紝2-鍚�
- /// </summary>
- [SugarColumn(ColumnName = "TS")]
+ /// <summary>
+ /// 鏄惁鎺ㄩ�丒RP1-鏄紝2-鍚�
+ /// </summary>
+ [SugarColumn(ColumnName = "TS")]
public decimal? Ts { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesInvTransaction.cs b/StandardPda/MES.Service/Modes/MesInvTransaction.cs
index 6b3aeae..635c014 100644
--- a/StandardPda/MES.Service/Modes/MesInvTransaction.cs
+++ b/StandardPda/MES.Service/Modes/MesInvTransaction.cs
@@ -8,75 +8,75 @@
[SugarTable("MES_INV_TRANSACTION")]
public class MesInvTransaction
{
- /// <summary>
- /// ID
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ /// ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
- /// <summary>
- /// 浜嬪姟绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "TRANSACTION_NAME")]
+ /// <summary>
+ /// 浜嬪姟绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_NAME")]
public string TransactionName { get; set; }
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK")]
public string Remark { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_BY")]
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_DATE")]
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string LastupdateBy { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 鍗曟嵁ID
- /// </summary>
- [SugarColumn(ColumnName = "BUSINESS_ID")]
+ /// <summary>
+ /// 鍗曟嵁ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BUSINESS_ID")]
public decimal? BusinessId { get; set; }
- /// <summary>
- /// 浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱
- /// </summary>
- [SugarColumn(ColumnName = "BUSINESS_TYPE")]
+ /// <summary>
+ /// 浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱
+ /// </summary>
+ [SugarColumn(ColumnName = "BUSINESS_TYPE")]
public decimal? BusinessType { get; set; }
- /// <summary>
- /// 浜嬪姟缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "TRANSACTION_NO")]
+ /// <summary>
+ /// 浜嬪姟缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_NO")]
public decimal? TransactionNo { get; set; }
- /// <summary>
- /// 鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ /// 鍒嗗巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
public string Factory { get; set; }
- /// <summary>
- /// 鍏徃浠ｇ爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
public string Company { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesQaItemsDetect01.cs b/StandardPda/MES.Service/Modes/MesQaItemsDetect01.cs
index ff63c5d..87de6a7 100644
--- a/StandardPda/MES.Service/Modes/MesQaItemsDetect01.cs
+++ b/StandardPda/MES.Service/Modes/MesQaItemsDetect01.cs
@@ -1,488 +1,480 @@
-锘縰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_QA_ITEMS_DETECT_01")]
+public class MesQaItemsDetect01
{
/// <summary>
- /// 鏉ユ枡鍏ュ簱妫�楠岃〃澶�
- ///</summary>
- [SugarTable("MES_QA_ITEMS_DETECT_01")]
- public class MesQaItemsDetect01
- {
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
- public decimal Id { get; set; }
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
- /// <summary>
- /// 妫�楠屽崟鍙�
- ///</summary>
- [SugarColumn(ColumnName = "RELEASE_NO")]
- public string ReleaseNo { get; set; }
+ /// <summary>
+ /// 妫�楠屽崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "RELEASE_NO")]
+ public string ReleaseNo { get; set; }
- /// <summary>
- /// 妫�楠屾棩鏈�
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_DATE")]
- public DateTime? FcheckDate { get; set; }
+ /// <summary>
+ /// 妫�楠屾棩鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_DATE")]
+ public DateTime? FcheckDate { get; set; }
- /// <summary>
- /// 妫�楠屼汉鍛�
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_BY")]
- public string FcheckBy { get; set; }
+ /// <summary>
+ /// 妫�楠屼汉鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_BY")]
+ public string FcheckBy { get; set; }
- /// <summary>
- /// 鐗╂枡缂栫爜
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
- public string ItemNo { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
+ public string ItemNo { get; set; }
- /// <summary>
- /// 鏉ユ枡鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "FBATCH_QTY")]
- public decimal? FbatchQty { get; set; }
+ /// <summary>
+ /// 鏉ユ枡鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FBATCH_QTY")]
+ public decimal? FbatchQty { get; set; }
- /// <summary>
- /// 鎺ユ敹鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "FRECE_QTY")]
- public string FreceQty { get; set; }
+ /// <summary>
+ /// 鎺ユ敹鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FRECE_QTY")]
+ public string FreceQty { get; set; }
- /// <summary>
- /// 渚涘簲鍟嗙紪鍙�
- ///</summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
- public string SuppNo { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗙紪鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
+ public string SuppNo { get; set; }
- /// <summary>
- /// 澶囨敞
- ///</summary>
- [SugarColumn(ColumnName = "FNG_DESC")]
- public string? FngDesc { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_DESC")]
+ public string? FngDesc { get; set; }
- /// <summary>
- /// 妫�楠岀粨鏋�
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_RESU")]
- public string FcheckResu { get; set; }
+ /// <summary>
+ /// 妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_RESU")]
+ public string FcheckResu { get; set; }
- /// <summary>
- /// OA璇勫鍙嶉
- ///</summary>
- [SugarColumn(ColumnName = "FREVIEW")]
- public string Freview { get; set; }
+ /// <summary>
+ /// OA璇勫鍙嶉
+ /// </summary>
+ [SugarColumn(ColumnName = "FREVIEW")]
+ public string Freview { get; set; }
- /// <summary>
- /// 妫�楠屾按鍑�
- ///</summary>
- [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
- public string SampleSizeNo { get; set; }
+ /// <summary>
+ /// 妫�楠屾按鍑�
+ /// </summary>
+ [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
+ public string SampleSizeNo { get; set; }
- /// <summary>
- /// 妫�楠屾按骞�
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_LEVEL")]
- public string FcheckLevel { get; set; }
+ /// <summary>
+ /// 妫�楠屾按骞�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_LEVEL")]
+ public string FcheckLevel { get; set; }
- /// <summary>
- /// 鎷掓敹姘村钩
- ///</summary>
- [SugarColumn(ColumnName = "FAC_LEVEL")]
- public string FacLevel { get; set; }
+ /// <summary>
+ /// 鎷掓敹姘村钩
+ /// </summary>
+ [SugarColumn(ColumnName = "FAC_LEVEL")]
+ public string FacLevel { get; set; }
- /// <summary>
- /// 鎶芥鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "CHECK_QTY")]
- public string CheckQty { get; set; }
+ /// <summary>
+ /// 鎶芥鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QTY")]
+ public string CheckQty { get; set; }
- /// <summary>
- /// 鎵规鍙� --鍒拌揣鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "LOT_NO")]
- public string LotNo { get; set; }
+ /// <summary>
+ /// 鎵规鍙� --鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO")]
+ public string LotNo { get; set; }
- /// <summary>
- /// 鏄惁鎺ㄩ��
- ///</summary>
- [SugarColumn(ColumnName = "FMOVE")]
- public string Fmove { get; set; }
+ /// <summary>
+ /// 鏄惁鎺ㄩ��
+ /// </summary>
+ [SugarColumn(ColumnName = "FMOVE")]
+ public string Fmove { get; set; }
- /// <summary>
- /// 鏄惁澶勭悊
- ///</summary>
- [SugarColumn(ColumnName = "FHANDLE")]
- public string Fhandle { get; set; }
+ /// <summary>
+ /// 鏄惁澶勭悊
+ /// </summary>
+ [SugarColumn(ColumnName = "FHANDLE")]
+ public string Fhandle { 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 = "MODIFY1_FLAG")]
- public decimal? Modify1Flag { get; set; }
+ /// <summary>
+ /// 鏄惁瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_FLAG")]
+ public decimal? Modify1Flag { get; set; }
- /// <summary>
- /// 瀹℃牳浜�
- ///</summary>
- [SugarColumn(ColumnName = "MODIFY1_BY")]
- public string Modify1By { get; set; }
+ /// <summary>
+ /// 瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_BY")]
+ public string Modify1By { get; set; }
- /// <summary>
- /// 瀹℃牳鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName = "MODIFY1_DATE")]
- public DateTime? Modify1Date { get; set; }
+ /// <summary>
+ /// 瀹℃牳鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_DATE")]
+ public DateTime? Modify1Date { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string Factory { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+ public string Factory { get; set; }
- /// <summary>
- /// XRF娴嬭瘯鎶ュ憡缂栧彿
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_REPNO")]
- public string FcheckRepno { get; set; }
+ /// <summary>
+ /// XRF娴嬭瘯鎶ュ憡缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_REPNO")]
+ public string FcheckRepno { get; set; }
- /// <summary>
- /// 绗笁鏂规姤鍛�
- ///</summary>
- [SugarColumn(ColumnName = "FTHIRD_REP")]
- public string FthirdRep { get; set; }
+ /// <summary>
+ /// 绗笁鏂规姤鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "FTHIRD_REP")]
+ public string FthirdRep { get; set; }
- /// <summary>
- /// 鏄惁浣滃簾
- ///</summary>
- [SugarColumn(ColumnName = "FCANCEL")]
- public decimal? Fcancel { get; set; }
+ /// <summary>
+ /// 鏄惁浣滃簾
+ /// </summary>
+ [SugarColumn(ColumnName = "FCANCEL")]
+ public decimal? Fcancel { get; set; }
- /// <summary>
- /// 鎻愪氦鏍囪瘑
- ///</summary>
- [SugarColumn(ColumnName = "FSUBMIT")]
- public decimal? Fsubmit { get; set; }
+ /// <summary>
+ /// 鎻愪氦鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "FSUBMIT")]
+ public decimal? Fsubmit { get; set; }
- /// <summary>
- /// 妫�楠屼緷鎹�
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_ACCORD")]
- public string FcheckAccord { get; set; }
+ /// <summary>
+ /// 妫�楠屼緷鎹�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ACCORD")]
+ public string FcheckAccord { get; set; }
- /// <summary>
- /// 绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱)
- ///</summary>
- [SugarColumn(ColumnName = "FTYPE")]
- public short? Ftype { get; set; }
+ /// <summary>
+ /// 绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱)
+ /// </summary>
+ [SugarColumn(ColumnName = "FTYPE")]
+ public short? Ftype { 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 = "OUT_DATE")]
- public string OutDate { get; set; }
+ /// <summary>
+ /// 鍑鸿揣鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "OUT_DATE")]
+ public string OutDate { get; set; }
- /// <summary>
- /// 鏄惁鍏嶆
- ///</summary>
- [SugarColumn(ColumnName = "FEXEMPTION")]
- public decimal? Fexemption { get; set; }
+ /// <summary>
+ /// 鏄惁鍏嶆
+ /// </summary>
+ [SugarColumn(ColumnName = "FEXEMPTION")]
+ public decimal? Fexemption { get; set; }
- /// <summary>
- /// 妗ｄ綅鏍囧噯
- ///</summary>
- [SugarColumn(ColumnName = "FGEAR_STAND")]
- public string FgearStand { get; set; }
+ /// <summary>
+ /// 妗ｄ綅鏍囧噯
+ /// </summary>
+ [SugarColumn(ColumnName = "FGEAR_STAND")]
+ public string FgearStand { get; set; }
- /// <summary>
- /// 涓嶈壇鏈�缁堝鐞嗘柟寮�
- ///</summary>
- [SugarColumn(ColumnName = "FNG_HANDLE")]
- public string FngHandle { get; set; }
+ /// <summary>
+ /// 涓嶈壇鏈�缁堝鐞嗘柟寮�
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_HANDLE")]
+ public string FngHandle { get; set; }
- /// <summary>
- /// 绠＄悊缂栧彿
- ///</summary>
- [SugarColumn(ColumnName = "FMANAGE_NO")]
- public string FmanageNo { get; set; }
+ /// <summary>
+ /// 绠＄悊缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "FMANAGE_NO")]
+ public string FmanageNo { get; set; }
- /// <summary>
- /// 杞崲鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "FCOVERT_QTY")]
- public string FcovertQty { get; set; }
+ /// <summary>
+ /// 杞崲鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FCOVERT_QTY")]
+ public string FcovertQty { get; set; }
- /// <summary>
- /// 鐗堟湰
- ///</summary>
- [SugarColumn(ColumnName = "FVERSION")]
- public decimal? Fversion { get; set; }
+ /// <summary>
+ /// 鐗堟湰
+ /// </summary>
+ [SugarColumn(ColumnName = "FVERSION")]
+ public decimal? Fversion { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string Company { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+ public string Company { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "FSECOND_RESU")]
- public string FsecondResu { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FSECOND_RESU")]
+ public string FsecondResu { get; set; }
- /// <summary>
- /// 鏈�澶ф娊妫�鏁�
- ///</summary>
- [SugarColumn(ColumnName = "MAX_CHECK_QTY")]
- public decimal? MaxCheckQty { get; set; }
+ /// <summary>
+ /// 鏈�澶ф娊妫�鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "MAX_CHECK_QTY")]
+ public decimal? MaxCheckQty { get; set; }
- /// <summary>
- /// 鐗瑰畾淇敼鏄惁瀹℃牳
- ///</summary>
- [SugarColumn(ColumnName = "MODIFY1_FLAG1")]
- public decimal? Modify1Flag1 { get; set; }
+ /// <summary>
+ /// 鐗瑰畾淇敼鏄惁瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_FLAG1")]
+ public decimal? Modify1Flag1 { get; set; }
- /// <summary>
- /// 鐗瑰畾淇敼瀹℃牳浜�
- ///</summary>
- [SugarColumn(ColumnName = "MODIFY1_BY1")]
- public string Modify1By1 { get; set; }
+ /// <summary>
+ /// 鐗瑰畾淇敼瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_BY1")]
+ public string Modify1By1 { get; set; }
- /// <summary>
- /// 鐗瑰畾淇敼瀹℃牳鏃堕棿
- ///</summary>
- [SugarColumn(ColumnName = "MODIFY1_DATE1")]
- public DateTime? Modify1Date1 { get; set; }
+ /// <summary>
+ /// 鐗瑰畾淇敼瀹℃牳鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_DATE1")]
+ public DateTime? Modify1Date1 { get; set; }
- /// <summary>
- /// 灏忔壒娆″彿
- ///</summary>
- [SugarColumn(ColumnName = "LOT_NO1")]
- public string LotNo1 { get; set; }
+ /// <summary>
+ /// 灏忔壒娆″彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO1")]
+ public string LotNo1 { get; set; }
- /// <summary>
- /// 閲囪喘鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "LOT_NO2")]
- public string LotNo2 { get; set; }
+ /// <summary>
+ /// 閲囪喘鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO2")]
+ public string LotNo2 { get; set; }
- /// <summary>
- /// 浜у搧鍨嬪彿
- ///</summary>
- [SugarColumn(ColumnName = "BOARD_STYLE")]
- public string BoardStyle { get; set; }
+ /// <summary>
+ /// 浜у搧鍨嬪彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BOARD_STYLE")]
+ public string BoardStyle { get; set; }
- /// <summary>
- /// 浠诲姟鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "WORK_NO")]
- public string WorkNo { get; set; }
+ /// <summary>
+ /// 浠诲姟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_NO")]
+ public string WorkNo { get; set; }
- /// <summary>
- /// 鍒拌揣鏃堕棿
- ///</summary>
- [SugarColumn(ColumnName = "DHA018")]
- public string Dha018 { get; set; }
+ /// <summary>
+ /// 鍒拌揣鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHA018")]
+ public string Dha018 { get; set; }
- /// <summary>
- /// 琛屽彿
- ///</summary>
- [SugarColumn(ColumnName = "DHB002")]
- public decimal? Dhb002 { get; set; }
+ /// <summary>
+ /// 琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB002")]
+ public decimal? Dhb002 { get; set; }
- /// <summary>
- /// 鍒拌揣鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "DHB001")]
- public string Dhb001 { get; set; }
+ /// <summary>
+ /// 鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB001")]
+ public string Dhb001 { get; set; }
- /// <summary>
- /// 渚涘簲鍟�
- ///</summary>
- [SugarColumn(ColumnName = "LIFNR")]
- public string Lifnr { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟�
+ /// </summary>
+ [SugarColumn(ColumnName = "LIFNR")]
+ public string Lifnr { get; set; }
- /// <summary>
- /// 閫�鏂欐柟寮�
- ///</summary>
- [SugarColumn(ColumnName = "FMRMODE")]
- public string Fmrmode { get; set; }
+ /// <summary>
+ /// 閫�鏂欐柟寮�
+ /// </summary>
+ [SugarColumn(ColumnName = "FMRMODE")]
+ public string Fmrmode { get; set; }
- /// <summary>
- /// erp杩斿洖淇℃伅
- ///</summary>
- [SugarColumn(ColumnName = "MSG")]
- public string Msg { get; set; }
+ /// <summary>
+ /// erp杩斿洖淇℃伅
+ /// </summary>
+ [SugarColumn(ColumnName = "MSG")]
+ public string Msg { get; set; }
- /// <summary>
- /// 鐘舵��
- ///</summary>
- [SugarColumn(ColumnName = "STATES")]
- public string States { get; set; }
+ /// <summary>
+ /// 鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "STATES")]
+ public string States { get; set; }
- /// <summary>
- /// IQC鎻愪氦鏃堕棿
- ///</summary>
- [SugarColumn(ColumnName = "IQC_DATE")]
- public DateTime? IqcDate { get; set; }
+ /// <summary>
+ /// IQC鎻愪氦鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "IQC_DATE")]
+ public DateTime? IqcDate { get; set; }
- /// <summary>
- /// 閲囪喘璁㈠崟ID
- ///</summary>
- [SugarColumn(ColumnName = "EBELN_K3ID")]
- public decimal? EbelnK3id { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟ID
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN_K3ID")]
+ public decimal? EbelnK3id { get; set; }
- /// <summary>
- /// 閲囪喘璁㈠崟琛孖D
- ///</summary>
- [SugarColumn(ColumnName = "LINE_K3ID")]
- public decimal? LineK3id { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛孖D
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_K3ID")]
+ public decimal? LineK3id { get; set; }
- /// <summary>
- /// 鍝佽川瀹℃牳鏍囪瘑
- ///</summary>
- [SugarColumn(ColumnName = "QUALITY_AUDIT")]
- public decimal? QualityAudit { get; set; }
+ /// <summary>
+ /// 鍝佽川瀹℃牳鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "QUALITY_AUDIT")]
+ public decimal? QualityAudit { 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; }
- /// <summary>
- /// 楠屾敹鏁�
- ///</summary>
- [SugarColumn(ColumnName = "YANS_NUM")]
- public decimal? YansNum { get; set; }
+ /// <summary>
+ /// 楠屾敹鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "YANS_NUM")]
+ public decimal? YansNum { get; set; }
- /// <summary>
- /// 楠岄��鏁�
- ///</summary>
- [SugarColumn(ColumnName = "YANT_NUM")]
- public decimal? YantNum { get; set; }
+ /// <summary>
+ /// 楠岄��鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "YANT_NUM")]
+ public decimal? YantNum { get; set; }
- /// <summary>
- /// 閲囪喘瀹℃牳鏍囪瘑
- ///</summary>
- [SugarColumn(ColumnName = "CG_AUDIT")]
- public decimal? CgAudit { get; set; }
+ /// <summary>
+ /// 閲囪喘瀹℃牳鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "CG_AUDIT")]
+ public decimal? CgAudit { get; set; }
- /// <summary>
- /// 閲囪喘鎰忚
- ///</summary>
- [SugarColumn(ColumnName = "CG_OPINION")]
- public string CgOpinion { get; set; }
+ /// <summary>
+ /// 閲囪喘鎰忚
+ /// </summary>
+ [SugarColumn(ColumnName = "CG_OPINION")]
+ public string CgOpinion { get; set; }
- /// <summary>
- /// 閲囪喘澶勭悊鏂瑰紡
- ///</summary>
- [SugarColumn(ColumnName = "CG_HANDLE")]
- public string CgHandle { get; set; }
+ /// <summary>
+ /// 閲囪喘澶勭悊鏂瑰紡
+ /// </summary>
+ [SugarColumn(ColumnName = "CG_HANDLE")]
+ public string CgHandle { get; set; }
- /// <summary>
- /// 鍝佽川鎰忚
- ///</summary>
- [SugarColumn(ColumnName = "QC_OPINION")]
- public string QcOpinion { get; set; }
+ /// <summary>
+ /// 鍝佽川鎰忚
+ /// </summary>
+ [SugarColumn(ColumnName = "QC_OPINION")]
+ public string QcOpinion { get; set; }
- /// <summary>
- /// 鍝佽川澶勭悊鏂瑰紡
- ///</summary>
- [SugarColumn(ColumnName = "QC_HANDLE")]
- public string QcHandle { get; set; }
+ /// <summary>
+ /// 鍝佽川澶勭悊鏂瑰紡
+ /// </summary>
+ [SugarColumn(ColumnName = "QC_HANDLE")]
+ public string QcHandle { get; set; }
- /// <summary>
- /// 缁忕悊瀹℃牳鏍囪瘑
- ///</summary>
- [SugarColumn(ColumnName = "MANAGER_AUDIT")]
- public decimal? ManagerAudit { get; set; }
+ /// <summary>
+ /// 缁忕悊瀹℃牳鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "MANAGER_AUDIT")]
+ public decimal? ManagerAudit { get; set; }
- /// <summary>
- /// 缁忕悊鎰忚
- ///</summary>
- [SugarColumn(ColumnName = "MANAGER_OPINION")]
- public string ManagerOpinion { get; set; }
+ /// <summary>
+ /// 缁忕悊鎰忚
+ /// </summary>
+ [SugarColumn(ColumnName = "MANAGER_OPINION")]
+ public string ManagerOpinion { get; set; }
- /// <summary>
- /// 缁忕悊澶勭悊鏂瑰紡
- ///</summary>
- [SugarColumn(ColumnName = "MANAGER_HANDLE")]
- public string ManagerHandle { get; set; }
+ /// <summary>
+ /// 缁忕悊澶勭悊鏂瑰紡
+ /// </summary>
+ [SugarColumn(ColumnName = "MANAGER_HANDLE")]
+ public string ManagerHandle { get; set; }
- /// <summary>
- /// 閿�鍞鍗�
- ///</summary>
- [SugarColumn(ColumnName = "SALES_ORDER")]
- public string SalesOrder { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗�
+ /// </summary>
+ [SugarColumn(ColumnName = "SALES_ORDER")]
+ public string SalesOrder { get; set; }
- /// <summary>
- /// 閲囪喘瀹℃牳浜�
- ///</summary>
- [SugarColumn(ColumnName = "CG_USER")]
- public string CgUser { get; set; }
+ /// <summary>
+ /// 閲囪喘瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CG_USER")]
+ public string CgUser { get; set; }
- /// <summary>
- /// 鍝佽川瀹℃牳浜�
- ///</summary>
- [SugarColumn(ColumnName = "QC_USER")]
- public string QcUser { get; set; }
+ /// <summary>
+ /// 鍝佽川瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "QC_USER")]
+ public string QcUser { get; set; }
- /// <summary>
- /// 缁忕悊瀹℃牳浜�
- ///</summary>
- [SugarColumn(ColumnName = "MANAGER_USER")]
- public string ManagerUser { get; set; }
+ /// <summary>
+ /// 缁忕悊瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "MANAGER_USER")]
+ public string ManagerUser { get; set; }
- /// <summary>
- /// 璁″垝璺熻釜鍙�
- ///</summary>
- [SugarColumn(ColumnName = "FMTONO")]
- public string Fmtono { get; set; }
+ /// <summary>
+ /// 璁″垝璺熻釜鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "FMTONO")]
+ public string Fmtono { get; set; }
- /// <summary>
- /// 瀹為獙瀹ら�佹鏍囪瘑
- ///</summary>
- [SugarColumn(ColumnName = "IS_SJ")]
- public decimal? IsSj { get; set; }
+ /// <summary>
+ /// 瀹為獙瀹ら�佹鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_SJ")]
+ public decimal? IsSj { get; set; }
- /// <summary>
- /// 瀹為獙瀹ら�佹鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "SJ_NO")]
- public string SjNo { get; set; }
- }
+ /// <summary>
+ /// 瀹為獙瀹ら�佹鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "SJ_NO")]
+ public string SjNo { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesQaItemsDetectDetail12.cs b/StandardPda/MES.Service/Modes/MesQaItemsDetectDetail12.cs
index 89bbddd..4eec2b0 100644
--- a/StandardPda/MES.Service/Modes/MesQaItemsDetectDetail12.cs
+++ b/StandardPda/MES.Service/Modes/MesQaItemsDetectDetail12.cs
@@ -1,88 +1,77 @@
-锘縰sing System;
-using System.Collections.Generic;
-using System.Linq;
-using SqlSugar;
+锘縰sing SqlSugar;
-namespace MES.Service.Modes
+namespace MES.Service.Modes;
+
+/// <summary>
+/// IQC妫�楠�
+/// </summary>
+[SugarTable("MES_QA_ITEMS_DETECT_DETAIL12")]
+public class MesQaItemsDetectDetail12
{
/// <summary>
- /// IQC妫�楠�
- ///</summary>
- [SugarTable("MES_QA_ITEMS_DETECT_DETAIL12")]
- public class MesQaItemsDetectDetail12
- {
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_QM_ID", IsPrimaryKey = true)]
- public decimal Id { get; set; }
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_QM_ID",
+ IsPrimaryKey = true)]
+ public decimal Id { get; set; }
- /// <summary>
- /// 妫�楠岀粨鏋�
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_RESU")]
- public string? FcheckResu { get; set; }
+ /// <summary>
+ /// 妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_RESU")]
+ public string? FcheckResu { get; set; }
- /// <summary>
- /// 妫�楠岄」鐩�
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_ITEM")]
- public string? FcheckItem { get; set; }
+ /// <summary>
+ /// 妫�楠岄」鐩�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ITEM")]
+ public string? FcheckItem { get; set; }
- /// <summary>
- /// 鐗╂枡鏉＄爜
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
- public string? ItemBarcode { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏉＄爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE")]
+ public string? ItemBarcode { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "RELEASE_NO")]
- public string? ReleaseNo { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "RELEASE_NO")]
+ public string? ReleaseNo { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "MAIN_ID")]
- public decimal? MainId { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "MAIN_ID")]
+ public decimal? MainId { 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 = "COMPANY")]
- public string? Company { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+ public string? Company { 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 = "FSTAND")]
- public string? Fstand { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FSTAND")]
+ public string? Fstand { 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 = "CREATE_BY")]
- public string? CreateBy { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
+ public string? CreateBy { get; set; }
- [SugarColumn(IsIgnore = true)] public int? count { get; set; }
- }
+ [SugarColumn(IsIgnore = true)] public int? count { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesQaItemsDetectDetail5.cs b/StandardPda/MES.Service/Modes/MesQaItemsDetectDetail5.cs
index ba13fce..d49b200 100644
--- a/StandardPda/MES.Service/Modes/MesQaItemsDetectDetail5.cs
+++ b/StandardPda/MES.Service/Modes/MesQaItemsDetectDetail5.cs
@@ -1,184 +1,176 @@
-锘縰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_QA_ITEMS_DETECT_DETAIL5")]
+public class MesQaItemsDetectDetail5
{
/// <summary>
- /// 鏉ユ枡妫�楠屼粠琛�
- ///</summary>
- [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")]
- public class MesQaItemsDetectDetail5
- {
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
- public decimal Id { get; set; }
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
- /// <summary>
- /// 鏍囧噯鍊肩被鍨�
- ///</summary>
- [SugarColumn(ColumnName = "FTEXT_TYPE")]
- public string FtextType { get; set; }
+ /// <summary>
+ /// 鏍囧噯鍊肩被鍨�
+ /// </summary>
+ [SugarColumn(ColumnName = "FTEXT_TYPE")]
+ public string FtextType { get; set; }
- /// <summary>
- /// 鏍囧噯鍊�
- ///</summary>
- [SugarColumn(ColumnName = "FSTAND")]
- public decimal? Fstand { get; set; }
+ /// <summary>
+ /// 鏍囧噯鍊�
+ /// </summary>
+ [SugarColumn(ColumnName = "FSTAND")]
+ public decimal? Fstand { get; set; }
- /// <summary>
- /// 涓婂叕宸�
- ///</summary>
- [SugarColumn(ColumnName = "FUP_ALLOW")]
- public string FupAllow { get; set; }
+ /// <summary>
+ /// 涓婂叕宸�
+ /// </summary>
+ [SugarColumn(ColumnName = "FUP_ALLOW")]
+ public string FupAllow { get; set; }
- /// <summary>
- /// 涓嬪叕宸�
- ///</summary>
- [SugarColumn(ColumnName = "FDOWN_ALLOW")]
- public string FdownAllow { get; set; }
+ /// <summary>
+ /// 涓嬪叕宸�
+ /// </summary>
+ [SugarColumn(ColumnName = "FDOWN_ALLOW")]
+ public string FdownAllow { get; set; }
- /// <summary>
- /// 妫�楠屾按鍑�
- ///</summary>
- [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
- public string SampleSizeNo { get; set; }
+ /// <summary>
+ /// 妫�楠屾按鍑�
+ /// </summary>
+ [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
+ public string SampleSizeNo { get; set; }
- /// <summary>
- /// 妫�楠屾按骞�
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_LEVEL")]
- public string FcheckLevel { get; set; }
+ /// <summary>
+ /// 妫�楠屾按骞�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_LEVEL")]
+ public string FcheckLevel { get; set; }
- /// <summary>
- /// 鎷掓敹姘村钩
- ///</summary>
- [SugarColumn(ColumnName = "FAC_LEVEL")]
- public string FacLevel { get; set; }
+ /// <summary>
+ /// 鎷掓敹姘村钩
+ /// </summary>
+ [SugarColumn(ColumnName = "FAC_LEVEL")]
+ public string FacLevel { get; set; }
- /// <summary>
- /// 妫�楠岄」鐩�
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_ITEM")]
- public string FcheckItem { get; set; }
+ /// <summary>
+ /// 妫�楠岄」鐩�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ITEM")]
+ public string FcheckItem { get; set; }
- /// <summary>
- /// 瑙勬牸瑕佹眰
- ///</summary>
- [SugarColumn(ColumnName = "FSPEC_REQU")]
- public string FspecRequ { get; set; }
+ /// <summary>
+ /// 瑙勬牸瑕佹眰
+ /// </summary>
+ [SugarColumn(ColumnName = "FSPEC_REQU")]
+ public string FspecRequ { get; set; }
- /// <summary>
- /// 鎶芥鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "CHECK_QYT")]
- public decimal? CheckQyt { get; set; }
+ /// <summary>
+ /// 鎶芥鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QYT")]
+ public decimal? CheckQyt { get; set; }
- /// <summary>
- /// 妫�楠岀粨鏋�
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_RESU")]
- public string FcheckResu { get; set; }
+ /// <summary>
+ /// 妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_RESU")]
+ public string FcheckResu { get; set; }
- /// <summary>
- /// AC鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "FAC_QTY")]
- public decimal? FacQty { get; set; }
+ /// <summary>
+ /// AC鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FAC_QTY")]
+ public decimal? FacQty { get; set; }
- /// <summary>
- /// RE鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "FRE_QTY")]
- public decimal? FreQty { get; set; }
+ /// <summary>
+ /// RE鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FRE_QTY")]
+ public decimal? FreQty { get; set; }
- /// <summary>
- /// 涓嶅悎鏍兼暟
- ///</summary>
- [SugarColumn(ColumnName = "FNG_QTY")]
- public decimal? FngQty { get; set; }
+ /// <summary>
+ /// 涓嶅悎鏍兼暟
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_QTY")]
+ public decimal? FngQty { get; set; }
- /// <summary>
- /// 涓嶈壇鐜�
- ///</summary>
- [SugarColumn(ColumnName = "FNG_RATE")]
- public decimal? FngRate { get; set; }
+ /// <summary>
+ /// 涓嶈壇鐜�
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_RATE")]
+ public decimal? FngRate { get; set; }
- /// <summary>
- /// 宸插綍鍏ユ暟閲�
- ///</summary>
- [SugarColumn(ColumnName = "FENTER_QTY")]
- public decimal? FenterQty { get; set; }
+ /// <summary>
+ /// 宸插綍鍏ユ暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "FENTER_QTY")]
+ public decimal? FenterQty { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "RELEASE_NO")]
- public string ReleaseNo { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "RELEASE_NO")]
+ public string ReleaseNo { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string Company { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+ public string Company { 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 = "FCHECK_ITEM_DESC")]
- public string FcheckItemDesc { get; set; }
+ /// <summary>
+ /// 妫�楠岄」鐩弿杩�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")]
+ public string FcheckItemDesc { get; set; }
- /// <summary>
- /// 宸ュ簭鍙�
- ///</summary>
- [SugarColumn(ColumnName = "PROC_NO")]
- public string ProcNo { get; set; }
+ /// <summary>
+ /// 宸ュ簭鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "PROC_NO")]
+ public string ProcNo { get; set; }
- /// <summary>
- /// 宸ヤ綔涓績缂栫爜
- ///</summary>
- [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")]
- public string WorkshopCenterCode { get; set; }
+ /// <summary>
+ /// 宸ヤ綔涓績缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")]
+ public string WorkshopCenterCode { get; set; }
- /// <summary>
- /// 鍗曚綅
- ///</summary>
- [SugarColumn(ColumnName = "FUNIT")]
- public string Funit { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "FUNIT")]
+ public string Funit { get; set; }
- /// <summary>
- /// 鐗瑰畾淇敼
- ///</summary>
- [SugarColumn(ColumnName = "GIVEN_MODIFY")]
- public short? GivenModify { get; set; }
+ /// <summary>
+ /// 鐗瑰畾淇敼
+ /// </summary>
+ [SugarColumn(ColumnName = "GIVEN_MODIFY")]
+ public short? GivenModify { get; set; }
- /// <summary>
- /// 妫�楠屽伐鍏�
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_TOOL")]
- public string FcheckTool { get; set; }
+ /// <summary>
+ /// 妫�楠屽伐鍏�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_TOOL")]
+ public string FcheckTool { 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; }
- [SugarColumn(IsIgnore = true)] public int? Unqualified { get; set; }
- }
+ [SugarColumn(IsIgnore = true)] public int? Unqualified { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesScgdGx.cs b/StandardPda/MES.Service/Modes/MesScgdGx.cs
index 783ac1e..1543c09 100644
--- a/StandardPda/MES.Service/Modes/MesScgdGx.cs
+++ b/StandardPda/MES.Service/Modes/MesScgdGx.cs
@@ -1,128 +1,122 @@
-锘縰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_SCGD_GX")]
+public class MesScgdGx
{
/// <summary>
- /// 宸ュ崟鎶ュ伐淇℃伅琛�
- ///</summary>
- [SugarTable("MES_SCGD_GX")]
- public class MesScgdGx
- {
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
- public decimal? Id { get; set; }
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal? Id { get; set; }
- /// <summary>
- /// 鐢熶骇宸ュ崟
- ///</summary>
- [SugarColumn(ColumnName = "TASK_NO")]
- public string TaskNo { get; set; }
+ /// <summary>
+ /// 鐢熶骇宸ュ崟
+ /// </summary>
+ [SugarColumn(ColumnName = "TASK_NO")]
+ public string TaskNo { get; set; }
- /// <summary>
- /// 鐢熶骇鏉＄爜
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
- public string ItemBarcode { get; set; }
+ /// <summary>
+ /// 鐢熶骇鏉＄爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE")]
+ public string ItemBarcode { get; set; }
- /// <summary>
- /// 鏉＄爜鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "QUANTITY")]
- public decimal? Quantity { get; set; }
+ /// <summary>
+ /// 鏉＄爜鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "QUANTITY")]
+ public decimal? Quantity { get; set; }
- /// <summary>
- /// 鎶ュ伐鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "QUANT")]
- public decimal? Quant { get; set; }
+ /// <summary>
+ /// 鎶ュ伐鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "QUANT")]
+ public decimal? Quant { get; set; }
- /// <summary>
- /// 宸ュ簭
- ///</summary>
- [SugarColumn(ColumnName = "GX")]
- public string Gx { get; set; }
+ /// <summary>
+ /// 宸ュ簭
+ /// </summary>
+ [SugarColumn(ColumnName = "GX")]
+ public string Gx { get; set; }
- /// <summary>
- /// 宸ュ簭ID
- ///</summary>
- [SugarColumn(ColumnName = "GX_ID")]
- public string GxId { get; set; }
+ /// <summary>
+ /// 宸ュ簭ID
+ /// </summary>
+ [SugarColumn(ColumnName = "GX_ID")]
+ public string GxId { 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_BY_DATE")]
- public DateTime? CreateByDate { get; set; }
+ /// <summary>
+ /// 鎶ュ伐鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY_DATE")]
+ public DateTime? CreateByDate { get; set; }
- /// <summary>
- /// 鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "BILL_NO")]
- public string BillNo { get; set; }
+ /// <summary>
+ /// 鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
+ public string BillNo { get; set; }
- /// <summary>
- /// 鐝
- ///</summary>
- [SugarColumn(ColumnName = "F_BC")]
- public string FBc { get; set; }
+ /// <summary>
+ /// 鐝
+ /// </summary>
+ [SugarColumn(ColumnName = "F_BC")]
+ public string FBc { get; set; }
- /// <summary>
- /// 宸ュ簭瀹屾瘯鏍囪瘑
- ///</summary>
- [SugarColumn(ColumnName = "GX_FLAE")]
- public decimal? GxFlae { get; set; }
+ /// <summary>
+ /// 宸ュ簭瀹屾瘯鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "GX_FLAE")]
+ public decimal? GxFlae { get; set; }
- /// <summary>
- /// 鎶ュ伐鏃堕棿锛堝勾鏈堟棩锛�
- ///</summary>
- [SugarColumn(ColumnName = "CREATE_BY1")]
- public string CreateBy1 { get; set; }
+ /// <summary>
+ /// 鎶ュ伐鏃堕棿锛堝勾鏈堟棩锛�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY1")]
+ public string CreateBy1 { get; set; }
- /// <summary>
- /// 鎷嗗垎鏁�
- ///</summary>
- [SugarColumn(ColumnName = "C_QUANT")]
- public decimal? CQuant { get; set; }
+ /// <summary>
+ /// 鎷嗗垎鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "C_QUANT")]
+ public decimal? CQuant { get; set; }
- /// <summary>
- /// 寮�宸ユ椂闂�
- ///</summary>
- [SugarColumn(ColumnName = "KG_TIME")]
- public string KgTime { get; set; }
+ /// <summary>
+ /// 寮�宸ユ椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "KG_TIME")]
+ public string KgTime { get; set; }
- /// <summary>
- /// 瀹屽伐鏃堕棿
- ///</summary>
- [SugarColumn(ColumnName = "WG_TIME")]
- public string WgTime { get; set; }
+ /// <summary>
+ /// 瀹屽伐鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "WG_TIME")]
+ public string WgTime { get; set; }
- /// <summary>
- /// 鏈哄彴
- ///</summary>
- [SugarColumn(ColumnName = "JT")]
- public string Jt { get; set; }
+ /// <summary>
+ /// 鏈哄彴
+ /// </summary>
+ [SugarColumn(ColumnName = "JT")]
+ public string Jt { get; set; }
- /// <summary>
- /// 鎶ュ伐浜虹紪鐮�
- ///</summary>
- [SugarColumn(ColumnName = "CREATE_CODE")]
- public string CreateCode { get; set; }
+ /// <summary>
+ /// 鎶ュ伐浜虹紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_CODE")]
+ public string CreateCode { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "CHECK_FLAG")]
- public string CheckFlag { get; set; }
- }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_FLAG")]
+ public string CheckFlag { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesStaff.cs b/StandardPda/MES.Service/Modes/MesStaff.cs
index 83471e2..e8b1776 100644
--- a/StandardPda/MES.Service/Modes/MesStaff.cs
+++ b/StandardPda/MES.Service/Modes/MesStaff.cs
@@ -9,158 +9,158 @@
public class MesStaff
{
/// <summary>
- /// ID
- ///</summary>
+ /// ID
+ /// </summary>
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
/// <summary>
- /// 鍛樺伐缂栫爜
- ///</summary>
+ /// 鍛樺伐缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "STAFF_NO")]
public string? StaffNo { get; set; }
/// <summary>
- /// 鍛樺伐濮撳悕
- ///</summary>
+ /// 鍛樺伐濮撳悕
+ /// </summary>
[SugarColumn(ColumnName = "STAFF_NAME")]
public string? StaffName { get; set; }
/// <summary>
- /// 閮ㄩ棬缂栫爜
- ///</summary>
+ /// 閮ㄩ棬缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "DEPARTMENT_NO")]
public string? DepartmentNo { get; set; }
/// <summary>
- /// 閮ㄩ棬鍚嶇О
- ///</summary>
+ /// 閮ㄩ棬鍚嶇О
+ /// </summary>
[SugarColumn(ColumnName = "DEPARTMENT_NAME")]
public string? DepartmentName { get; set; }
/// <summary>
- /// 宀椾綅缂栫爜
- ///</summary>
+ /// 宀椾綅缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "POSITION_CODE")]
public string? PositionCode { get; set; }
/// <summary>
- /// 宀椾綅鍚嶇О
- ///</summary>
+ /// 宀椾綅鍚嶇О
+ /// </summary>
[SugarColumn(ColumnName = "POSITION_NAME")]
public string? PositionName { get; set; }
/// <summary>
- /// 鎵嬫満鍙�
- ///</summary>
+ /// 鎵嬫満鍙�
+ /// </summary>
[SugarColumn(ColumnName = "PHONE_NUMBER")]
public string? PhoneNumber { get; set; }
/// <summary>
- /// 浠诲矖寮�濮嬫棩鏈�
- ///</summary>
+ /// 浠诲矖寮�濮嬫棩鏈�
+ /// </summary>
[SugarColumn(ColumnName = "START_DATE")]
public DateTime? StartDate { get; set; }
/// <summary>
- /// 澶囨敞 浜哄憳绫诲瀷锛�1锛氭寮忓伐锛�2锛氭淳閬ｅ伐
- ///</summary>
+ /// 澶囨敞 浜哄憳绫诲瀷锛�1锛氭寮忓伐锛�2锛氭淳閬ｅ伐
+ /// </summary>
[SugarColumn(ColumnName = "REMARK")]
public string? Remark { get; set; }
/// <summary>
- /// 鍒涘缓缁勭粐
- ///</summary>
+ /// 鍒涘缓缁勭粐
+ /// </summary>
[SugarColumn(ColumnName = "CREATE_ORG")]
public decimal? CreateOrg { get; set; }
/// <summary>
- /// 浣跨敤缁勭粐
- ///</summary>
+ /// 浣跨敤缁勭粐
+ /// </summary>
[SugarColumn(ColumnName = "USE_ORG")]
public string? UseOrg { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�3
- ///</summary>
+ /// 鑷畾涔夊瓧娈�3
+ /// </summary>
[SugarColumn(ColumnName = "REMARK3")]
public string? Remark3 { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�4
- ///</summary>
+ /// 鑷畾涔夊瓧娈�4
+ /// </summary>
[SugarColumn(ColumnName = "REMARK4")]
public string? Remark4 { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�5
- ///</summary>
+ /// 鑷畾涔夊瓧娈�5
+ /// </summary>
[SugarColumn(ColumnName = "REMARK5")]
public string? Remark5 { get; set; }
/// <summary>
- /// 鍒涘缓浜�
- ///</summary>
+ /// 鍒涘缓浜�
+ /// </summary>
[SugarColumn(ColumnName = "CREATE_BY")]
public string? CreateBy { get; set; }
/// <summary>
- /// 鍒涘缓鏃堕棿
- ///</summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
[SugarColumn(ColumnName = "CREATE_DATE")]
public DateTime? CreateDate { get; set; }
/// <summary>
- /// 鏇存柊浜�
- ///</summary>
+ /// 鏇存柊浜�
+ /// </summary>
[SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string? LastupdateBy { get; set; }
/// <summary>
- /// 鏇存柊鏃堕棿
- ///</summary>
+ /// 鏇存柊鏃堕棿
+ /// </summary>
[SugarColumn(ColumnName = "LASTUPDATE_DATE")]
public DateTime? LastupdateDate { get; set; }
/// <summary>
- /// 澶囨敞
- ///</summary>
+ /// 澶囨敞
+ /// </summary>
[SugarColumn(ColumnName = "MEMO")]
public string? Memo { get; set; }
/// <summary>
- /// 鐢熶骇绾�
- ///</summary>
+ /// 鐢熶骇绾�
+ /// </summary>
[SugarColumn(ColumnName = "LINE_NO")]
public string? LineNo { get; set; }
/// <summary>
- /// 鐢熶骇鍛樺伐鏍囪瘑
- ///</summary>
+ /// 鐢熶骇鍛樺伐鏍囪瘑
+ /// </summary>
[SugarColumn(ColumnName = "WORK_MK")]
public decimal? WorkMk { get; set; }
/// <summary>
- /// 鏄惁绂佺敤 宸ヤ綔鐘舵�侊紝1锛氬湪鑱岋紱2锛氱鑱�
- ///</summary>
+ /// 鏄惁绂佺敤 宸ヤ綔鐘舵�侊紝1锛氬湪鑱岋紱2锛氱鑱�
+ /// </summary>
[SugarColumn(ColumnName = "FFORBID_STATUS")]
public string? FforbidStatus { get; set; }
/// <summary>
- /// 涓氬姟鍛樼被鍨�
- ///</summary>
+ /// 涓氬姟鍛樼被鍨�
+ /// </summary>
[SugarColumn(ColumnName = "OPERATOR_TYPE")]
public string? OperatorType { get; set; }
/// <summary>
- /// 鏄惁鏄叧閿矖浣� 0锛氬惁锛�1锛氭槸
- ///</summary>
+ /// 鏄惁鏄叧閿矖浣� 0锛氬惁锛�1锛氭槸
+ /// </summary>
[SugarColumn(ColumnName = "KEY_POSTS")]
public string? KeyPosts { get; set; }
/// <summary>
- /// 绂昏亴鏃堕棿
- ///</summary>
+ /// 绂昏亴鏃堕棿
+ /// </summary>
[SugarColumn(ColumnName = "SEPARATION_TIME")]
public DateTime? SeparationTime { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/Purdhb.cs b/StandardPda/MES.Service/Modes/Purdhb.cs
index 7fff6ee..b8de0cc 100644
--- a/StandardPda/MES.Service/Modes/Purdhb.cs
+++ b/StandardPda/MES.Service/Modes/Purdhb.cs
@@ -8,267 +8,267 @@
[SugarTable("PURDHB")]
public class Purdhb
{
- /// <summary>
- /// 鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB001")]
+ /// <summary>
+ /// 鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB001")]
public string Dhb001 { get; set; }
- /// <summary>
- /// 搴忓彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB002")]
+ /// <summary>
+ /// 搴忓彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB002")]
public string Dhb002 { get; set; }
- /// <summary>
- /// 鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DHB003")]
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB003")]
public string Dhb003 { get; set; }
- /// <summary>
- /// 鐗╂枡鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "DHB004")]
+ /// <summary>
+ /// 鐗╂枡鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB004")]
public string Dhb004 { get; set; }
- /// <summary>
- /// 鐗╂枡瑙勬牸
- /// </summary>
- [SugarColumn(ColumnName = "DHB005")]
+ /// <summary>
+ /// 鐗╂枡瑙勬牸
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB005")]
public string Dhb005 { get; set; }
- /// <summary>
- /// 浜よ揣鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB006")]
+ /// <summary>
+ /// 浜よ揣鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB006")]
public decimal? Dhb006 { get; set; }
- /// <summary>
- /// 鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "DHB007")]
+ /// <summary>
+ /// 鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB007")]
public string Dhb007 { get; set; }
- /// <summary>
- /// 浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "DHB008")]
+ /// <summary>
+ /// 浠撳簱
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB008")]
public string Dhb008 { get; set; }
- /// <summary>
- /// 浠撳簱鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "DHB009")]
+ /// <summary>
+ /// 浠撳簱鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB009")]
public string Dhb009 { get; set; }
- /// <summary>
- /// 鎵瑰彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB010")]
+ /// <summary>
+ /// 鎵瑰彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB010")]
public string Dhb010 { get; set; }
- /// <summary>
- /// 鏉ユ簮鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB011")]
+ /// <summary>
+ /// 鏉ユ簮鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB011")]
public string Dhb011 { get; set; }
- /// <summary>
- /// 鏉ユ簮搴忓彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB012")]
+ /// <summary>
+ /// 鏉ユ簮搴忓彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB012")]
public decimal? Dhb012 { get; set; }
- /// <summary>
- /// 娓呯偣鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB013")]
+ /// <summary>
+ /// 娓呯偣鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB013")]
public decimal? Dhb013 { get; set; }
- /// <summary>
- /// 鍒板巶鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "DHB014")]
+ /// <summary>
+ /// 鍒板巶鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB014")]
public string Dhb014 { get; set; }
- /// <summary>
- /// 楠屾敹鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB015")]
+ /// <summary>
+ /// 楠屾敹鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB015")]
public decimal? Dhb015 { get; set; }
- /// <summary>
- /// 楠岄��鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB016")]
+ /// <summary>
+ /// 楠岄��鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB016")]
public decimal? Dhb016 { get; set; }
- /// <summary>
- /// 杩涜揣鍗曚环
- /// </summary>
- [SugarColumn(ColumnName = "DHB017")]
+ /// <summary>
+ /// 杩涜揣鍗曚环
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB017")]
public decimal? Dhb017 { get; set; }
- /// <summary>
- /// 杩涜揣閲戦
- /// </summary>
- [SugarColumn(ColumnName = "DHB018")]
+ /// <summary>
+ /// 杩涜揣閲戦
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB018")]
public decimal? Dhb018 { get; set; }
- /// <summary>
- /// 瀹㈡埛鏂欏彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB019")]
+ /// <summary>
+ /// 瀹㈡埛鏂欏彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB019")]
public string Dhb019 { get; set; }
- /// <summary>
- /// 閮ㄩ棬缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB020")]
+ /// <summary>
+ /// 閮ㄩ棬缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB020")]
public string Dhb020 { get; set; }
- /// <summary>
- /// 璧犲搧鏁�
- /// </summary>
- [SugarColumn(ColumnName = "DHB021")]
+ /// <summary>
+ /// 璧犲搧鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB021")]
public decimal? Dhb021 { get; set; }
- /// <summary>
- /// 鏇存柊ERP
- /// </summary>
- [SugarColumn(ColumnName = "DHB022")]
+ /// <summary>
+ /// 鏇存柊ERP
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB022")]
public string Dhb022 { get; set; }
- /// <summary>
- /// 妫�楠岀姸鎬�
- /// </summary>
- [SugarColumn(ColumnName = "DHB023")]
+ /// <summary>
+ /// 妫�楠岀姸鎬�
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB023")]
public string Dhb023 { get; set; }
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "DHB024")]
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB024")]
public string Dhb024 { get; set; }
- /// <summary>
- /// 瀹℃牳
- /// </summary>
- [SugarColumn(ColumnName = "AUDITING")]
+ /// <summary>
+ /// 瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "AUDITING")]
public decimal? Auditing { get; set; }
- /// <summary>
- /// ERP閲囪喘鍗曞彿ID
- /// </summary>
- [SugarColumn(ColumnName = "DHB026")]
+ /// <summary>
+ /// ERP閲囪喘鍗曞彿ID
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB026")]
public decimal? Dhb026 { get; set; }
- /// <summary>
- /// ERP閲囪喘搴忓彿ID
- /// </summary>
- [SugarColumn(ColumnName = "DHB027")]
+ /// <summary>
+ /// ERP閲囪喘搴忓彿ID
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB027")]
public decimal? Dhb027 { get; set; }
- /// <summary>
- /// ERP鐗╂枡ID
- /// </summary>
- [SugarColumn(ColumnName = "DHB028")]
+ /// <summary>
+ /// ERP鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB028")]
public decimal? Dhb028 { get; set; }
- /// <summary>
- /// 寰呮鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB029")]
+ /// <summary>
+ /// 寰呮鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB029")]
public decimal? Dhb029 { get; set; }
- /// <summary>
- /// 妫�楠屾棩鏈�
- /// </summary>
- [SugarColumn(ColumnName = "DHB030")]
+ /// <summary>
+ /// 妫�楠屾棩鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB030")]
public string Dhb030 { get; set; }
- /// <summary>
- /// 妫�楠屽憳
- /// </summary>
- [SugarColumn(ColumnName = "DHB031")]
+ /// <summary>
+ /// 妫�楠屽憳
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB031")]
public string Dhb031 { get; set; }
- /// <summary>
- /// 鍏ュ簱鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB032")]
+ /// <summary>
+ /// 鍏ュ簱鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB032")]
public decimal? Dhb032 { get; set; }
- /// <summary>
- /// 鍏ュ簱浜�
- /// </summary>
- [SugarColumn(ColumnName = "DHB033")]
+ /// <summary>
+ /// 鍏ュ簱浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB033")]
public string Dhb033 { get; set; }
- /// <summary>
- /// 鍏ュ簱鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "DHB034")]
+ /// <summary>
+ /// 鍏ュ簱鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB034")]
public string Dhb034 { get; set; }
- /// <summary>
- /// 閫�璐ф暟閲�
- /// </summary>
- [SugarColumn(ColumnName = "DHB035")]
+ /// <summary>
+ /// 閫�璐ф暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB035")]
public decimal? Dhb035 { get; set; }
- /// <summary>
- /// ERPID
- /// </summary>
- [SugarColumn(ColumnName = "DHB037")]
+ /// <summary>
+ /// ERPID
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB037")]
public decimal? Dhb037 { get; set; }
- /// <summary>
- /// 閫�璐т汉
- /// </summary>
- [SugarColumn(ColumnName = "DHB036")]
+ /// <summary>
+ /// 閫�璐т汉
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB036")]
public string Dhb036 { get; set; }
- /// <summary>
- /// ERP鍘熷垎褰曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB038")]
+ /// <summary>
+ /// ERP鍘熷垎褰曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB038")]
public decimal? Dhb038 { get; set; }
- /// <summary>
- /// ERP婧愬崟鍐呯爜
- /// </summary>
- [SugarColumn(ColumnName = "DHB039")]
+ /// <summary>
+ /// ERP婧愬崟鍐呯爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB039")]
public decimal? Dhb039 { get; set; }
- /// <summary>
- /// ERP婧愬崟绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "DHB040")]
+ /// <summary>
+ /// ERP婧愬崟绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB040")]
public decimal? Dhb040 { get; set; }
- /// <summary>
- /// ERP璁㈠崟鍐呯爜
- /// </summary>
- [SugarColumn(ColumnName = "DHB041")]
+ /// <summary>
+ /// ERP璁㈠崟鍐呯爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB041")]
public decimal? Dhb041 { get; set; }
- /// <summary>
- /// 鑷鍒�
- /// </summary>
- [SugarColumn(ColumnName = "ID")]
+ /// <summary>
+ /// 鑷鍒�
+ /// </summary>
+ [SugarColumn(ColumnName = "ID")]
public decimal? Id { get; set; }
- /// <summary>
- /// 鏄惁妫�楠岋紝1涓哄凡妫�
- /// </summary>
- [SugarColumn(ColumnName = "ISCHECK")]
+ /// <summary>
+ /// 鏄惁妫�楠岋紝1涓哄凡妫�
+ /// </summary>
+ [SugarColumn(ColumnName = "ISCHECK")]
public decimal? Ischeck { get; set; }
- /// <summary>
- /// 浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "DHB042")]
+ /// <summary>
+ /// 浠撳簱
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB042")]
public string Dhb042 { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/Purdka.cs b/StandardPda/MES.Service/Modes/Purdka.cs
index 1c3ea40..4330c13 100644
--- a/StandardPda/MES.Service/Modes/Purdka.cs
+++ b/StandardPda/MES.Service/Modes/Purdka.cs
@@ -8,123 +8,123 @@
[SugarTable("PURDKA")]
public class Purdka
{
- /// <summary>
- /// 鑷鍒�
- /// </summary>
- [SugarColumn(ColumnName = "ID")]
+ /// <summary>
+ /// 鑷鍒�
+ /// </summary>
+ [SugarColumn(ColumnName = "ID")]
public decimal? Id { get; set; }
- /// <summary>
- /// 鍒涘缓浜哄憳
- /// </summary>
- [SugarColumn(ColumnName = "CREATEUSER")]
+ /// <summary>
+ /// 鍒涘缓浜哄憳
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATEUSER")]
public string Createuser { get; set; }
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATETIME")]
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATETIME")]
public string Createtime { get; set; }
- /// <summary>
- /// 淇敼鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "MODIFYTIME")]
+ /// <summary>
+ /// 淇敼鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFYTIME")]
public string Modifytime { get; set; }
- /// <summary>
- /// 淇敼浜哄憳
- /// </summary>
- [SugarColumn(ColumnName = "MODIFYUSER")]
+ /// <summary>
+ /// 淇敼浜哄憳
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFYUSER")]
public string Modifyuser { get; set; }
- /// <summary>
- /// 瀹℃牳
- /// </summary>
- [SugarColumn(ColumnName = "AUDITING")]
+ /// <summary>
+ /// 瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "AUDITING")]
public string Auditing { get; set; }
- /// <summary>
- /// 閫�璐у崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "DKA001")]
+ /// <summary>
+ /// 閫�璐у崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA001")]
public string Dka001 { get; set; }
- /// <summary>
- /// 閫�璐х被鍨�
- /// </summary>
- [SugarColumn(ColumnName = "DKA002")]
+ /// <summary>
+ /// 閫�璐х被鍨�
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA002")]
public string Dka002 { get; set; }
- /// <summary>
- /// 閫�璐ф棩鏈�
- /// </summary>
- [SugarColumn(ColumnName = "DKA003")]
+ /// <summary>
+ /// 閫�璐ф棩鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA003")]
public string Dka003 { get; set; }
- /// <summary>
- /// 閫�璐ф椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "DKA004")]
+ /// <summary>
+ /// 閫�璐ф椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA004")]
public string Dka004 { get; set; }
- /// <summary>
- /// 渚涘簲鍟�
- /// </summary>
- [SugarColumn(ColumnName = "DKA005")]
+ /// <summary>
+ /// 渚涘簲鍟�
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA005")]
public string Dka005 { get; set; }
- /// <summary>
- /// 渚涘簲鍟嗗悕绉�
- /// </summary>
- [SugarColumn(ColumnName = "DKA006")]
+ /// <summary>
+ /// 渚涘簲鍟嗗悕绉�
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA006")]
public string Dka006 { get; set; }
- /// <summary>
- /// 閮ㄩ棬
- /// </summary>
- [SugarColumn(ColumnName = "DKA007")]
+ /// <summary>
+ /// 閮ㄩ棬
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA007")]
public string Dka007 { get; set; }
- /// <summary>
- /// 瀹℃牳鑰�
- /// </summary>
- [SugarColumn(ColumnName = "DKA008")]
+ /// <summary>
+ /// 瀹℃牳鑰�
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA008")]
public string Dka008 { get; set; }
- /// <summary>
- /// 瀹℃牳鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "DKA009")]
+ /// <summary>
+ /// 瀹℃牳鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA009")]
public string Dka009 { get; set; }
- /// <summary>
- /// 閫�璐х姸鎬侊紝0鎴栫┖涓烘湭閫�璐э紝1涓哄凡閫�瀹�
- /// </summary>
- [SugarColumn(ColumnName = "DKA010")]
+ /// <summary>
+ /// 閫�璐х姸鎬侊紝0鎴栫┖涓烘湭閫�璐э紝1涓哄凡閫�瀹�
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA010")]
public string Dka010 { get; set; }
- /// <summary>
- /// ERPID
- /// </summary>
- [SugarColumn(ColumnName = "ERPID")]
+ /// <summary>
+ /// ERPID
+ /// </summary>
+ [SugarColumn(ColumnName = "ERPID")]
public decimal? Erpid { get; set; }
- /// <summary>
- /// 淇濈鍛樼紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "DKA011")]
+ /// <summary>
+ /// 淇濈鍛樼紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA011")]
public string Dka011 { get; set; }
- /// <summary>
- /// 楠屾敹鍛樼紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "DKA012")]
+ /// <summary>
+ /// 楠屾敹鍛樼紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA012")]
public string Dka012 { get; set; }
- /// <summary>
- /// 鏄惁鎺ㄩ�佺孩瀛楀叆搴�1-鎺ㄩ�侊紝0-鏈帹閫�
- /// </summary>
- [SugarColumn(ColumnName = "DKA013")]
+ /// <summary>
+ /// 鏄惁鎺ㄩ�佺孩瀛楀叆搴�1-鎺ㄩ�侊紝0-鏈帹閫�
+ /// </summary>
+ [SugarColumn(ColumnName = "DKA013")]
public decimal? Dka013 { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/VLineUser.cs b/StandardPda/MES.Service/Modes/VLineUser.cs
index 300b3bc..1a645f6 100644
--- a/StandardPda/MES.Service/Modes/VLineUser.cs
+++ b/StandardPda/MES.Service/Modes/VLineUser.cs
@@ -1,23 +1,22 @@
锘縰sing SqlSugar;
-namespace MES.Service.Modes
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 浜х嚎涓庣敤鎴峰鐓�
+/// </summary>
+[SugarTable("V_LINE_USER")]
+public class VLineUser
{
/// <summary>
- /// 浜х嚎涓庣敤鎴峰鐓�
- ///</summary>
- [SugarTable("V_LINE_USER")]
- public class VLineUser
- {
- /// <summary>
- /// 浜х嚎鍚�
- ///</summary>
- [SugarColumn(ColumnName = "LINE_NO")]
- public string? LineNo { get; set; }
+ /// 浜х嚎鍚�
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_NO")]
+ public string? LineNo { get; set; }
- /// <summary>
- /// 鐢ㄦ埛鍚�
- ///</summary>
- [SugarColumn(ColumnName = "FNAME")]
- public string? FName { get; set; }
- }
+ /// <summary>
+ /// 鐢ㄦ埛鍚�
+ /// </summary>
+ [SugarColumn(ColumnName = "FNAME")]
+ public string? FName { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/VMesQaItemsDetect01.cs b/StandardPda/MES.Service/Modes/VMesQaItemsDetect01.cs
index 3fe9ac5..f1847a0 100644
--- a/StandardPda/MES.Service/Modes/VMesQaItemsDetect01.cs
+++ b/StandardPda/MES.Service/Modes/VMesQaItemsDetect01.cs
@@ -1,47 +1,38 @@
锘縰sing SqlSugar;
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
-using System.Threading.Tasks;
-using SqlSugar;
-namespace MES.Service.Modes
+
+namespace MES.Service.Modes;
+
+[SugarTable("V_MES_QA_ITEMS_DETECT_01")]
+public class VMesQaItemsDetect01
{
+ /// <summary>
+ /// 瀵瑰簲瑙嗗浘涓殑 id 瀛楁
+ /// </summary>
+ [SugarColumn(ColumnName = "id")]
+ public int Id { get; set; }
- [SugarTable("V_MES_QA_ITEMS_DETECT_01")]
- public class VMesQaItemsDetect01
- {
- /// <summary>
- /// 瀵瑰簲瑙嗗浘涓殑 id 瀛楁
- /// </summary>
- [SugarColumn(ColumnName = "id")]
- public int Id { get; set; }
+ /// <summary>
+ /// 瀵瑰簲瑙嗗浘涓殑 ITEM_ID 瀛楁
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_ID")]
+ public string ItemId { get; set; }
- /// <summary>
- /// 瀵瑰簲瑙嗗浘涓殑 ITEM_ID 瀛楁
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_ID")]
- public string ItemId { get; set; }
+ /// <summary>
+ /// 瀵瑰簲瑙嗗浘涓殑 SUPP_NO 瀛楁
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
+ public string SuppNo { get; set; }
- /// <summary>
- /// 瀵瑰簲瑙嗗浘涓殑 SUPP_NO 瀛楁
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
- public string SuppNo { get; set; }
-
- /// <summary>
- /// 瀵瑰簲瑙嗗浘涓殑 first 瀛楁
- /// </summary>
- [SugarColumn(ColumnName = "first")]
- public int First { get; set; }
+ /// <summary>
+ /// 瀵瑰簲瑙嗗浘涓殑 first 瀛楁
+ /// </summary>
+ [SugarColumn(ColumnName = "first")]
+ public int First { get; set; }
- /// <summary>
- /// 瀵瑰簲瑙嗗浘涓殑 NEW_FNG_DESC 瀛楁
- /// </summary>
- [SugarColumn(ColumnName = "NEW_FNG_DESC")]
- public string NewFngDesc { get; set; }
- }
-
-}
-
+ /// <summary>
+ /// 瀵瑰簲瑙嗗浘涓殑 NEW_FNG_DESC 瀛楁
+ /// </summary>
+ [SugarColumn(ColumnName = "NEW_FNG_DESC")]
+ public string NewFngDesc { get; set; }
+}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/Womcaa.cs b/StandardPda/MES.Service/Modes/Womcaa.cs
index 86b5acb..da8ff86 100644
--- a/StandardPda/MES.Service/Modes/Womcaa.cs
+++ b/StandardPda/MES.Service/Modes/Womcaa.cs
@@ -3,39 +3,37 @@
namespace MES.Service.Modes;
/// <summary>
-/// 宸ュ崟琛�
+/// 浠诲姟鍗曡〃
/// </summary>
[SugarTable("WOMCAA")]
public class Womcaa
{
/// <summary>
- /// 鑷鍒� SEQ_AOI
+ /// 鑷鍒�
/// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
- OracleSequenceName = "SEQ_CAA")]
- public decimal? Id { get; set; }
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
/// <summary>
- /// ERPID
+ /// 鐢熶骇璁㈠崟琛屽唴鐮�
/// </summary>
[SugarColumn(ColumnName = "ERPID")]
public decimal? Erpid { get; set; }
/// <summary>
- /// 鍗曞彿
+ /// 鍗曟嵁缂栧彿
/// </summary>
[SugarColumn(ColumnName = "CAA001")]
public string? Caa001 { get; set; }
/// <summary>
- /// 鍗曟嵁绫诲瀷 1銆佺洿鎺ュ叆搴�-鏅�氱敓浜� SCDD03_SYS2銆佺洿鎺ュ叆搴�-杩斿伐鐢熶骇 SCDD04_SYS3銆佸伐搴忔眹鎶�-鏅�氱敓浜�
- /// SCDD01_SYS4銆佸伐搴忔眹鎶�-杩斿伐鐢熶骇 SCDD02_SYS
+ /// 鍗曟嵁绫诲瀷
/// </summary>
[SugarColumn(ColumnName = "CAA004")]
public string? Caa004 { get; set; }
/// <summary>
- /// 寮�鍗曟棩鏈�
+ /// 璁″垝涓嬭揪鏃ユ湡
/// </summary>
[SugarColumn(ColumnName = "CAA005")]
public string? Caa005 { get; set; }
@@ -65,7 +63,7 @@
public string? Caa011 { get; set; }
/// <summary>
- /// 鏁伴噺
+ /// 宸ュ崟鏁伴噺
/// </summary>
[SugarColumn(ColumnName = "CAA012")]
public decimal? Caa012 { get; set; }
@@ -95,25 +93,25 @@
public decimal? Caa017 { get; set; }
/// <summary>
- /// ERP婧愬崟ID
+ /// ERP鐢熶骇璁㈠崟ID
/// </summary>
[SugarColumn(ColumnName = "CAA018")]
public decimal? Caa018 { get; set; }
/// <summary>
- /// ERP婧愬崟琛屽彿
+ /// ERP鐢熶骇璁㈠崟搴忓彿
/// </summary>
[SugarColumn(ColumnName = "CAA019")]
- public string? Caa019 { get; set; }
+ public decimal? Caa019 { get; set; }
/// <summary>
- /// ERP婧愬崟鍗曞彿(浠诲姟鍗曞彿)
+ /// ERP鐢熶骇璁㈠崟鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "CAA020")]
public string? Caa020 { get; set; }
/// <summary>
- /// 宸ヤ綔杞﹂棿
+ /// 鐢熶骇杞﹂棿
/// </summary>
[SugarColumn(ColumnName = "CAA021")]
public string? Caa021 { get; set; }
@@ -143,7 +141,7 @@
public decimal? Caa022 { get; set; }
/// <summary>
- /// 鐘舵�� 瀹屽伐锛屾湭瀹屽伐
+ /// 涓氬姟鐘舵��
/// </summary>
[SugarColumn(ColumnName = "CAA023")]
public string? Caa023 { get; set; }
@@ -233,7 +231,7 @@
public string? SrcBillType { get; set; }
/// <summary>
- /// 婧愬崟缂栧彿
+ /// 婧愬崟缂栫爜
/// </summary>
[SugarColumn(ColumnName = "SRC_BILL_NO")]
public string? SrcBillNo { get; set; }
@@ -275,18 +273,6 @@
public string? SrcSplitBillno { get; set; }
/// <summary>
- /// 瀹㈡埛
- /// </summary>
- [SugarColumn(ColumnName = "F_ZSXG_KH")]
- public string? F_ZSXG_KH { get; set; }
-
- /// <summary>
- /// 瑕佽揣鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "F_ZJXF_YHRQ")]
- public string? F_ZJXF_YHRQ { get; set; }
-
- /// <summary>
/// 鐢熶骇缁勭粐
/// </summary>
[SugarColumn(ColumnName = "PRD_ORG")]
@@ -314,7 +300,49 @@
/// 缁撴鏍囪瘑
/// </summary>
[SugarColumn(ColumnName = "JA_BS")]
- public string? JaBs { get; set; }
+ public decimal? JaBs { get; set; }
+
+ /// <summary>
+ /// 鏃х墿鏂欑紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_BASEPROPERTY")]
+ public string? FWwcBaseproperty { get; set; }
+
+ /// <summary>
+ /// 璁″垝瀹屽伐鎼哄甫鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_DATETIME")]
+ public DateTime? FWwcDatetime { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇鍏ュ簱鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_SCRKRQ")]
+ public DateTime? FWwcScrkrq { get; set; }
+
+ /// <summary>
+ /// 宸ユ椂
+ /// </summary>
+ [SugarColumn(ColumnName = "FGS")]
+ public decimal? Fgs { get; set; }
+
+ /// <summary>
+ /// 浜х嚎浜烘暟
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_DECIMAL")]
+ public decimal? FWwcDecimal { get; set; }
+
+ /// <summary>
+ /// 绾垮埆
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_XB")]
+ public string? FWwcXb { get; set; }
+
+ /// <summary>
+ /// 閿�鍞憳
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_BASE")]
+ public string? FWwcBase { get; set; }
/// <summary>
/// 淇敼鏍囪瘑
@@ -323,118 +351,32 @@
public decimal? IsXg { get; set; }
/// <summary>
- /// 1锛屾柊澧烇紱2锛屽彉鏇�
- /// </summary>
- [SugarColumn(ColumnName = "TYPEA")]
- public string? Typea { get; set; }
-
-
- /// <summary>
- /// 鐢熶骇閫氱煡鍗� 锛堟矁灏旀柊澧烇級
- /// </summary>
- [SugarColumn(ColumnName = "WR_F_SCDD_SCTZD")]
- public string? WR_F_SCDD_SCTZD { get; set; }
-
- /// <summary>
- /// 鍨嬪彿 锛堟矁灏旀柊澧烇級
- /// </summary>
- [SugarColumn(ColumnName = "WR_F_SCDD_XH")]
- public string? WR_F_SCDD_XH { get; set; }
-
- /// <summary>
- /// 澶囨敞(琛ㄤ綋)
- /// </summary>
- [SugarColumn(ColumnName = "BTBZ")]
- public string? BTBZ { get; set; }
-
-
- /// <summary>
- /// 璁″垝纭鏃堕棿锛堟墽琛屾棩鏈燂級 --濮斿
- /// </summary>
- [SugarColumn(ColumnName = "PLANCONFIRMATION")]
- public string? PLANCONFIRMATION { get; set; }
-
- /// <summary>
- /// ERP鐢熶骇璁㈠崟ID --濮斿
- /// </summary>
- [SugarColumn(ColumnName = "FSUBID")]
- public string? FSUBID { get; set; }
-
- /// <summary>
- /// ERP鐢熶骇璁㈠崟搴忓彿 --濮斿
- /// </summary>
- [SugarColumn(ColumnName = "FSUBBILLNOSEQ")]
- public string? FSUBBILLNOSEQ { get; set; }
-
- /// <summary>
- /// ERP鐢熶骇璁㈠崟鍗曞彿 --濮斿
- /// </summary>
- [SugarColumn(ColumnName = "FSUBBILLNO")]
- public string? FSUBBILLNO { get; set; }
-
- /// <summary>
- /// 闇�姹傛潵婧� --濮斿
- /// </summary>
- [SugarColumn(ColumnName = "FREQSRC")]
- public string? FREQSRC { get; set; }
-
- /// <summary>
- /// 婧愭媶鍒嗚鍗曡鍙� --濮斿
- /// </summary>
- [SugarColumn(ColumnName = "SRCSPLITSEQ")]
- public string? SRCSPLITSEQ { get; set; }
-
- /// <summary>
- /// ERP濮斿璁㈠崟鍒嗗綍鍐呯爜 -- 濮斿
- /// </summary>
- [SugarColumn(ColumnName = "FSUBENTRYID")]
- public string? FSUBENTRYID { get; set; }
-
- /// <summary>
- /// ERP濮斿璁㈠崟鍒嗗綍鍐呯爜 -- 濮斿
+ /// 濮斿閲囪喘璁㈠崟
/// </summary>
[SugarColumn(ColumnName = "FPURORDERNO")]
- public string? FPURORDERNO { get; set; }
+ public string? Fpurorderno { get; set; }
/// <summary>
- /// 閲囪喘璁㈠崟琛屽彿 -- 濮斿
+ /// 濮斿閲囪喘璁㈠崟琛屽彿
/// </summary>
[SugarColumn(ColumnName = "FPURORDERENTRYSEQ")]
- public string? FPURORDERENTRYSEQ { get; set; }
+ public decimal? Fpurorderentryseq { get; set; }
/// <summary>
- /// 鍩烘湰鍗曚綅鍏ュ簱鏁伴噺 -- 濮斿
+ /// 濮斿璁㈠崟鍒嗗綍鍐呯爜
/// </summary>
- [SugarColumn(ColumnName = "FBASESTOCKINQTY")]
- public decimal? FBASESTOCKINQTY { get; set; }
+ [SugarColumn(ColumnName = "FSUBENTRYID")]
+ public decimal? Fsubentryid { get; set; }
/// <summary>
- /// 鍩烘湰鍗曚綅鏈叆搴撴暟閲� -- 濮斿
+ /// 濮斿鍏ュ簱鏁�
/// </summary>
- [SugarColumn(ColumnName = "FBASENOSTOCKINQTY")]
- public decimal? FBASENOSTOCKINQTY { get; set; }
+ [SugarColumn(ColumnName = "FSTOCKINQTY")]
+ public decimal? Fstockinqty { get; set; }
/// <summary>
- /// 鍏ュ簱璐т富 -- 濮斿
+ /// 濮斿鏈叆搴撴暟
/// </summary>
- [SugarColumn(ColumnName = "FINSTOCKOWNERID")]
- public string? FINSTOCKOWNERID { get; set; }
-
- /// <summary>
- /// 鐢熶骇閫氱煡鍗� -- 濮斿
- /// </summary>
- [SugarColumn(ColumnName = "F_WWDD_SCTZD")]
- public string? F_WWDD_SCTZD { get; set; }
-
- /// <summary>
- /// 鍨嬪彿 -- 濮斿
- /// </summary>
- [SugarColumn(ColumnName = "F_WWDD_XH")]
- public string? F_WWDD_XH { get; set; }
-
- /// <summary>
- /// BOM澶囨敞 -- 濮斿
- /// </summary>
- [SugarColumn(ColumnName = "F_XIFG_TEXT_TZK")]
- public string? F_XIFG_TEXT_TZK { get; set; }
+ [SugarColumn(ColumnName = "FNOSTOCKINQTY")]
+ public decimal? Fnostockinqty { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/Womcab.cs b/StandardPda/MES.Service/Modes/Womcab.cs
index c5aae98..cb15d19 100644
--- a/StandardPda/MES.Service/Modes/Womcab.cs
+++ b/StandardPda/MES.Service/Modes/Womcab.cs
@@ -3,7 +3,7 @@
namespace MES.Service.Modes;
/// <summary>
-/// 宸ュ崟瀛愯〃
+/// 浠诲姟鍗曠墿鏂欒〃
/// </summary>
[SugarTable("WOMCAB")]
public class Womcab
@@ -11,18 +11,17 @@
/// <summary>
/// 鑷鍒�
/// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
- OracleSequenceName = "SEQ_CAB")]
- public decimal? Id { get; set; }
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
/// <summary>
- /// ERPID
+ /// 鐢熶骇鐢ㄦ枡娓呭崟琛屽唴鐮�
/// </summary>
[SugarColumn(ColumnName = "ERPID")]
public decimal? Erpid { get; set; }
/// <summary>
- /// 鍗曞彿
+ /// 宸ュ崟鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "CAB001")]
public string? Cab001 { get; set; }
@@ -73,16 +72,16 @@
/// 鏄惁鏇挎枡
/// </summary>
[SugarColumn(ColumnName = "CAB014")]
- public string? Cab014 { get; set; }
+ public decimal? Cab014 { get; set; }
/// <summary>
- /// PID
+ /// 鐢熶骇璁㈠崟琛屽唴鐮�
/// </summary>
[SugarColumn(ColumnName = "PID")]
public decimal? Pid { get; set; }
/// <summary>
- /// ERP澶碔D
+ /// 鐢熶骇璁㈠崟琛屽唴鐮�
/// </summary>
[SugarColumn(ColumnName = "EID")]
public decimal? Eid { get; set; }
@@ -136,7 +135,7 @@
public string? IssueType { get; set; }
/// <summary>
- /// 渚涘簲绫诲瀷
+ /// 渚涘簲绫诲瀷 C閲囪喘 Z鑷埗 W濮斿
/// </summary>
[SugarColumn(ColumnName = "SUPPLY_TYPE")]
public string? SupplyType { get; set; }
@@ -157,112 +156,47 @@
/// 鍥哄畾鎹熻��
/// </summary>
[SugarColumn(ColumnName = "SCRAPQTY")]
- public decimal? SCRAPQTY { get; set; }
+ public decimal? Scrapqty { get; set; }
/// <summary>
/// 鍙樺姩鎹熻�楃巼
/// </summary>
[SugarColumn(ColumnName = "SCRAPRATE")]
- public decimal? SCRAPRATE { get; set; }
-
+ public decimal? Scraprate { get; set; }
/// <summary>
- /// 搴斿彂鏁伴噺
+ /// 閿�鍞鍗曞彿
/// </summary>
- [SugarColumn(ColumnName = "Must_Qty")]
- public decimal? MustQty { get; set; }
+ [SugarColumn(ColumnName = "SALES_ORDER")]
+ public string? SalesOrder { get; set; }
/// <summary>
- /// 椤规鍙�
+ /// 闇�姹傚崟鎹�
/// </summary>
- [SugarColumn(ColumnName = "FREPLACEGROUP")]
- public int? Freplacegroup { get; set; }
+ [SugarColumn(ColumnName = "F_WWC_TEXT1")]
+ public string? FWwcText1 { get; set; }
/// <summary>
- /// 浣跨敤姣斾緥锛�%锛�
+ /// 璁″垝瀹屽伐鏃ユ湡
/// </summary>
- [SugarColumn(ColumnName = "USE_RATE")]
- public decimal? UseRate { get; set; }
+ [SugarColumn(ColumnName = "F_WWC_DATE")]
+ public DateTime? FWwcDate { get; set; }
+
+ /// <summary>
+ /// 鏃х墿鏂欑紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_BASEPROPERTY")]
+ public string? FWwcBaseproperty { get; set; }
+
+ /// <summary>
+ /// 浣跨敤姣斾緥
+ /// </summary>
+ [SugarColumn(ColumnName = "FUSERATE")]
+ public decimal? Fuserate { get; set; }
/// <summary>
/// 瀛愰」绫诲瀷 1鏍囧噯浠� 2杩旇繕浠� 3鏇夸唬浠�
/// </summary>
- [SugarColumn(ColumnName = "MATERIAL_TYPE")]
- public string? MaterialType { get; set; }
-
- /// <summary>
- /// A锛屽垱寤� B锛屽鏍镐腑 C锛屽凡瀹℃牳 D锛岄噸鏂板鏍� Z锛屾殏瀛�
- /// </summary>
- [SugarColumn(ColumnName = "TYPEB")]
- public string? Typeb { get; set; }
-
-
- /// <summary>
- /// A锛屽垱寤� B锛屽鏍镐腑 C锛屽凡瀹℃牳 D锛岄噸鏂板鏍� Z锛屾殏瀛�
- /// </summary>
- [SugarColumn(ColumnName = "WR_F_XIFG_BASE_QTR")]
- public string? WR_F_XIFG_Base_qtr { get; set; }
-
- /// <summary>
- /// A锛屽垱寤� B锛屽鏍镐腑 C锛屽凡瀹℃牳 D锛岄噸鏂板鏍� Z锛屾殏瀛�
- /// </summary>
- [SugarColumn(ColumnName = "WR_F_XIFG_BASE_83G")]
- public string? WR_F_XIFG_Base_83g { get; set; }
-
-
- /////----濮斿鏂板
-
- /// <summary>
- /// 鏄惁鍙戞崯鑰� -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FISGETSCRAP")]
- public string? Fisgetscrap { get; set; }
-
- /// <summary>
- /// 鏄惁鍏抽敭浠� -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FISKEYCOMPONENT")]
- public string? Fiskeycomponent { get; set; }
-
- /// <summary>
- /// 鎷ㄥ嚭缁勭粐 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FSRCTRANSORGID")]
- public string? Fsrctransorgid { get; set; }
-
- /// <summary>
- /// 鎷ㄥ嚭浠撳簱 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FSRCTRANSSTOCKID")]
- public string? Fsrctransstockid { get; set; }
-
- /// <summary>
- /// 搴撳瓨鐘舵�� -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FSTOCKSTATUSID")]
- public string? Fstockstatusid { get; set; }
-
- /// <summary>
- /// 闇�姹傛棩鏈� -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FNEEDDATE")]
- public DateTime? Fneeddate { get; set; }
-
- /// <summary>
- /// 棰勭暀绫诲瀷 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FRESERVETYPE")]
- public string? Freservetype { get; set; }
-
- /// <summary>
- /// 鐢ㄦ枡娓呭崟澶囨敞 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FMEMO")]
- public string? Fmemo { get; set; }
-
- /// <summary>
- /// ERP鐢熶骇璁㈠崟鍒嗗綍鍐呯爜 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
- public string? ErpProductionEntryCode { get; set; }
+ [SugarColumn(ColumnName = "FMATERIALTYPE")]
+ public decimal? Fmaterialtype { get; set; }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/service/BasicData/MesRohInManager.cs b/StandardPda/MES.Service/service/BasicData/MesRohInManager.cs
index bb4947a..f185e91 100644
--- a/StandardPda/MES.Service/service/BasicData/MesRohInManager.cs
+++ b/StandardPda/MES.Service/service/BasicData/MesRohInManager.cs
@@ -102,10 +102,7 @@
&& s.OrgId == rohIn.FReceiveOrgId
&& s.TableType == "MES_SUPPLIER").First();
- if (mesLinkU9 != null)
- {
- mesRohIn.Supplier = mesLinkU9.MesId;
- }
+ if (mesLinkU9 != null) mesRohIn.Supplier = mesLinkU9.MesId;
mesRohIn.EbelnK3id = eid;
mesRohIn.BillNo = rohIn.FBillNo;
@@ -203,7 +200,7 @@
RdProject = s.RdProject,
ProjectPurchaser = s.ProjectPurchaser
};
-
+
if (s.FDeliveryDate != null)
entity.DeliveryDate =
DateTime.ParseExact(s.FDeliveryDate,
@@ -219,10 +216,7 @@
&& x.OrgId == s.FReceiveOrgId
&& x.TableType == "MES_ITEMS").First();
- if (mesLinkU9 != null)
- {
- entity.ItemId = mesLinkU9.MesId;
- }
+ if (mesLinkU9 != null) entity.ItemId = mesLinkU9.MesId;
var mesLinkU92 = Db.Queryable<MesLinkU9>()
@@ -230,10 +224,7 @@
&& x.OrgId == s.FReceiveOrgId
&& x.TableType == "MES_PROJECT").First();
- if (mesLinkU92 != null)
- {
- entity.Project = mesLinkU92.MesId;
- }
+ if (mesLinkU92 != null) entity.Project = mesLinkU92.MesId;
return entity;
}).ToList();
diff --git a/StandardPda/MES.Service/service/BasicData/MesStaffManager.cs b/StandardPda/MES.Service/service/BasicData/MesStaffManager.cs
index 075b229..1dfeaf9 100644
--- a/StandardPda/MES.Service/service/BasicData/MesStaffManager.cs
+++ b/StandardPda/MES.Service/service/BasicData/MesStaffManager.cs
@@ -62,11 +62,8 @@
MesStaff entity)
{
var exists = db.Queryable<SysUser>().Any(u => u.Sid == sysUser.Sid);
- if (!exists)
- {
- db.Insertable(sysUser).ExecuteCommand();
- }
-
+ if (!exists) db.Insertable(sysUser).ExecuteCommand();
+
db.Deleteable<MesStaff>()
.Where(s => s.Id == entity.Id)
.ExecuteCommand();
@@ -78,12 +75,12 @@
}
/// <summary>
- /// "鍒犻櫎鍛樺伐鐨勬柟娉�"璋冩暣锛氳皟鏁翠紶鍏ュ弬鏁帮紝灏唅d鏀逛负MesStaff绫伙紝鍒犻櫎浣跨敤id鍜孭ositionCode浣滀负鍒ゆ柇渚濇嵁
+ /// "鍒犻櫎鍛樺伐鐨勬柟娉�"璋冩暣锛氳皟鏁翠紶鍏ュ弬鏁帮紝灏唅d鏀逛负MesStaff绫伙紝鍒犻櫎浣跨敤id鍜孭ositionCode浣滀负鍒ゆ柇渚濇嵁
/// </summary>
/// <remarks>
- /// 淇敼浜猴細姹犲崡楠�
- /// 淇敼鏃ユ湡锛�2024-12-30
- /// 淇敼璇存槑锛歚
+ /// 淇敼浜猴細姹犲崡楠�
+ /// 淇敼鏃ユ湡锛�2024-12-30
+ /// 淇敼璇存槑锛歚
/// </remarks>
private bool DeleteStaff(SqlSugarScope db, SysUser sysUser, MesStaff entity)
{
diff --git a/StandardPda/MES.Service/service/BasicData/ProductionOrderManager.cs b/StandardPda/MES.Service/service/BasicData/ProductionOrderManager.cs
index c2776c7..a336849 100644
--- a/StandardPda/MES.Service/service/BasicData/ProductionOrderManager.cs
+++ b/StandardPda/MES.Service/service/BasicData/ProductionOrderManager.cs
@@ -128,7 +128,7 @@
Caa011 = erpDto.FPlanFinishDate,
//ParseDateTime(erpDto.FPlanFinishDate) ?? null,
- PLANCONFIRMATION = erpDto.PlanConfirmation,
+ //PLANCONFIRMATION = erpDto.PlanConfirmation,
StockInlimith =
erpDto
.FStockInLimitH, //Convert.ToDecimal(erpDto.FStockInLimitH),
@@ -140,36 +140,36 @@
Caa013 = erpDto.FBomId,
//SalesOrderNo = erpDto.F_UNW_XSDDH,
CreateType = erpDto.FCreateType,
- FSUBID = erpDto.FSUBID,
- FSUBBILLNOSEQ = erpDto.FSUBBILLNOSEQ,
- FSUBBILLNO = erpDto.FSUBBILLNO,
+ //FSUBID = erpDto.FSUBID,
+ //FSUBBILLNOSEQ = erpDto.FSUBBILLNOSEQ,
+ //FSUBBILLNO = erpDto.FSUBBILLNO,
SrcBillType = erpDto.FSrcBillType,
SrcBillNo = erpDto.FSrcBillNo,
SrcBillentryseq = erpDto.FSrcBillEntrySeq,
- FREQSRC = erpDto.FReqSrc,
+ //FREQSRC = erpDto.FReqSrc,
SaleOrderNo = erpDto.FSALEORDERNO,
SaleOrderEntryseq = erpDto.FSaleOrderEntrySeq,
ForceCloserid = erpDto.FFORCECLOSERID,
CloseType = erpDto.FCloseType,
SrcSplitBillno = erpDto.FDescription,
- SRCSPLITSEQ = erpDto.SrcSplitSeq,
- Erpid = Convert.ToDecimal(erpDto.FID),
- FSUBENTRYID = erpDto.FSUBENTRYID,
- FPURORDERNO = erpDto.FPurOrderNo,
- FPURORDERENTRYSEQ =
- erpDto
- .FPurOrderEntrySeq, //Convert.ToInt32(erpDto.FPurOrderEntrySeq),
- FBASESTOCKINQTY = Convert.ToDecimal(erpDto.FBaseStockInQty),
- FBASENOSTOCKINQTY = Convert.ToDecimal(erpDto.FBaseNoStockInQty),
- FINSTOCKOWNERID = erpDto.FInStockOwnerId,
+ //SRCSPLITSEQ = erpDto.SrcSplitSeq,
+ Erpid = Convert.ToDecimal(erpDto.FID)
+ //FSUBENTRYID = erpDto.FSUBENTRYID,
+ //FPURORDERNO = erpDto.FPurOrderNo,
+ //FPURORDERENTRYSEQ =
+ //erpDto
+ // .FPurOrderEntrySeq, //Convert.ToInt32(erpDto.FPurOrderEntrySeq),
+ //FBASESTOCKINQTY = Convert.ToDecimal(erpDto.FBaseStockInQty),
+ //FBASENOSTOCKINQTY = Convert.ToDecimal(erpDto.FBaseNoStockInQty),
+ //FINSTOCKOWNERID = erpDto.FInStockOwnerId,
//PlanConfirmation = erpDto.PlanConfirmation != null
// ? DateTime.ParseExact(erpDto.PlanConfirmation,
// "yyyy-MM-dd HH:mm:ss", null)
// : null,
- Typea = erpDto.TypeA,
- F_WWDD_SCTZD = erpDto.F_WWDD_SCTZD,
- F_WWDD_XH = erpDto.F_WWDD_XH,
- F_XIFG_TEXT_TZK = erpDto.F_XIFG_Text_tzk
+ // Typea = erpDto.TypeA,
+ // F_WWDD_SCTZD = erpDto.F_WWDD_SCTZD,
+ // F_WWDD_XH = erpDto.F_WWDD_XH,
+ // F_XIFG_TEXT_TZK = erpDto.F_XIFG_Text_tzk
};
var single = base.GetSingle(it => it.Erpid == entity.Erpid);
@@ -191,7 +191,7 @@
Cab001 = erpDto.FBillNo,
Cab002 = erpDto.FSEQ, //Convert.ToInt32(erpDto.FSEQ),
Cab003 = erpDto.FMaterialID2,
- MustQty = Convert.ToDecimal(erpDto.FMustQty),
+ // MustQty = Convert.ToDecimal(erpDto.FMustQty),
Cab006 = Convert.ToDecimal(erpDto.FMustQty),
Cab007 = Convert.ToDecimal(erpDto.FPickedQty),
PositionNo = erpDto.FPositionNO,
@@ -207,28 +207,28 @@
Numerator = Convert.ToDecimal(erpDto.FNumerator),
Denominator = Convert.ToDecimal(erpDto.FDenominator),
Erpid = Convert.ToDecimal(erpDto.FPPOMENTRYID),
- Eid = Convert.ToDecimal(erpDto.FPPOMID),
- SCRAPQTY = Convert.ToDecimal(erpDto.FFixScrapQty),
- SCRAPRATE = Convert.ToDecimal(erpDto.FScrapRate),
- MaterialType = erpDto.FMaterialType,
- //Unit2 = erpDto.FUnitID3,
- Freplacegroup = Convert.ToInt32(erpDto.FReplaceGroup),
+ Eid = Convert.ToDecimal(erpDto.FPPOMID)
+ // SCRAPQTY = Convert.ToDecimal(erpDto.FFixScrapQty),
+ // SCRAPRATE = Convert.ToDecimal(erpDto.FScrapRate),
+ // MaterialType = erpDto.FMaterialType,
+ // //Unit2 = erpDto.FUnitID3,
+ // Freplacegroup = Convert.ToInt32(erpDto.FReplaceGroup),
//OwnerType = erpDto.FOwnerTypeId,
//Owner = erpDto.FOwnerID2,
- Fisgetscrap = erpDto.FISGETSCRAP,
- Fiskeycomponent = erpDto.FISKEYCOMPONENT,
- Fsrctransorgid = erpDto.FSRCTRANSORGID,
- Fsrctransstockid = erpDto.FSRCTRANSSTOCKID,
- Fstockstatusid = erpDto.FSTOCKSTATUSID,
- Fneeddate = erpDto.FNEEDDATE != null
- ? DateTime.ParseExact(erpDto.FNEEDDATE,
- "yyyy-MM-dd HH:mm:ss", null)
- : null,
- Freservetype = erpDto.FRESERVETYPE,
- Fmemo = erpDto.FMEMO,
- Typeb = erpDto.TypeB,
- ErpProductionEntryCode = erpDto.FSUBENTRYID
+ // Fisgetscrap = erpDto.FISGETSCRAP,
+ // Fiskeycomponent = erpDto.FISKEYCOMPONENT,
+ // Fsrctransorgid = erpDto.FSRCTRANSORGID,
+ // Fsrctransstockid = erpDto.FSRCTRANSSTOCKID,
+ // Fstockstatusid = erpDto.FSTOCKSTATUSID,
+ // Fneeddate = erpDto.FNEEDDATE != null
+ // ? DateTime.ParseExact(erpDto.FNEEDDATE,
+ // "yyyy-MM-dd HH:mm:ss", null)
+ // : null,
+ // Freservetype = erpDto.FRESERVETYPE,
+ // Fmemo = erpDto.FMEMO,
+ // Typeb = erpDto.TypeB,
+ // ErpProductionEntryCode = erpDto.FSUBENTRYID
};
var single =
diff --git a/StandardPda/MES.Service/service/QC/LljService.cs b/StandardPda/MES.Service/service/QC/LljService.cs
index 34826a8..3377af4 100644
--- a/StandardPda/MES.Service/service/QC/LljService.cs
+++ b/StandardPda/MES.Service/service/QC/LljService.cs
@@ -4,25 +4,20 @@
using MES.Service.Dto.service;
using MES.Service.Modes;
using MES.Service.util;
-using Microsoft.EntityFrameworkCore.Metadata.Internal;
using Newtonsoft.Json;
using SqlSugar;
using DbType = System.Data.DbType;
-using System.Net.Http;
-using System.Threading.Tasks;
-
namespace MES.Service.service.QC;
public class LljService
{
+ private static readonly HttpClient client = new();
+
public (List<LtsLlj> item, int TotalCount) GetPage(XJPageResult queryObj)
{
- if (queryObj.createUser.IsNullOrEmpty())
- {
- return ([], 0);
- }
+ if (queryObj.createUser.IsNullOrEmpty()) return ([], 0);
var db = SqlSugarHelper.GetInstance();
@@ -32,18 +27,19 @@
//var itemIds = GetQaItem(db, queryObj.createUser);
- var pageList = db.Queryable<LtsLlj, IqcBefore, VMesQaItemsDetect01, SysUser, IqcBeforeFrom, SysUser>((a, b,d,e,f,g) =>
+ var pageList = db
+ .Queryable<LtsLlj, IqcBefore, VMesQaItemsDetect01, SysUser,
+ IqcBeforeFrom, SysUser>((a, b, d, e, f, g) =>
new JoinQueryInfos(JoinType.Left, a.ItemId == b.ItemId,
-
JoinType.Inner, a.Id == d.Id,
- JoinType.Left, a.CreateBy == e.Fcode,
- JoinType.Left,f.Id==b.PID,
- JoinType.Left, f.Sid == g.Fid
+ JoinType.Left, a.CreateBy == e.Fcode,
+ JoinType.Left, f.Id == b.PID,
+ JoinType.Left, f.Sid == g.Fid
))
.WhereIF(
StringUtil.IsNotNullOrEmpty(queryObj.result) &&
"鏈畬鎴�".Equals(queryObj.result),
- (a, b, d) => a.FcheckResu == null )
+ (a, b, d) => a.FcheckResu == null)
.WhereIF(
StringUtil.IsNotNullOrEmpty(queryObj.result) &&
!"鏈畬鎴�".Equals(queryObj.result),
@@ -60,17 +56,16 @@
|| a.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower())
|| a.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower())))
.OrderByDescending((a, b, d) => a.Id)
- .Select((a, b, d,e,f,g) => new LtsLlj
+ .Select((a, b, d, e, f, g) => new LtsLlj
{
UserName = g.Fname,
- FIRST=d.First,
- CreateUserName=e.Fname,
- NewFngDesc=d.NewFngDesc
-
+ FIRST = d.First,
+ CreateUserName = e.Fname,
+ NewFngDesc = d.NewFngDesc
}, true)
.ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount);
-
+
return (pageList, totalCount);
}
@@ -142,7 +137,7 @@
mesQaIqcItem.ForEach(item =>
{
- string LEV = item.FcheckLevel switch
+ var LEV = item.FcheckLevel switch
{
null => "" // 榛樿鍊�
,
@@ -302,7 +297,7 @@
Company = "1000",
FenterQty = SqlFunc.AggregateCount(b.Id),
FcheckResu = a.FcheckResu,
- FcheckItemDesc=a.FcheckItemDesc
+ FcheckItemDesc = a.FcheckItemDesc
}).ToList();
}
@@ -562,8 +557,8 @@
return SqlSugarHelper.UseTransactionWithOracle(db =>
{
return db.Updateable<MesQaItemsDetect01>()
- .SetColumns(it =>
- it.FngDesc == dto.Remarks) //SetColumns鏄彲浠ュ彔鍔犵殑 鍐�2涓氨2涓瓧娈佃祴鍊�
+ .SetColumns(it =>
+ it.FngDesc == dto.Remarks) //SetColumns鏄彲浠ュ彔鍔犵殑 鍐�2涓氨2涓瓧娈佃祴鍊�
.Where(it => it.ReleaseNo == dto.releaseNo)
.ExecuteCommand();
});
@@ -655,51 +650,47 @@
throw new Exception(ex.Message);
}
}
+
/// <summary>
- /// 鏂欏彿鍥剧焊鎺ュ彛杩斿洖瀵硅薄
- /// </summary>
- public class ApiResponse
- {
- [JsonProperty("status")]
- public int Status { get; set; }
- [JsonProperty("message")]
- public string Message { get; set; }
- [JsonProperty("data")]
- public string[] Data { get; set; }
- [JsonProperty("totalCount")]
- public int TotalCount { get; set; }
- }
- private static readonly HttpClient client = new HttpClient();
- /// <summary>
- /// 浠嶶9鑾峰彇鏂欏彿鍥剧焊鍒楄〃
+ /// 浠嶶9鑾峰彇鏂欏彿鍥剧焊鍒楄〃
/// </summary>
/// <param name="Type">u9No锛歶9鐗╂枡缂栧彿</param>
/// <param name="U9No">type锛�1锛氬浘绾歌鏍间功 2锛氳繘鏂欐楠屾枃浠� </param>
/// <returns></returns>
/// <exception cref="Exception"></exception>
- public async Task<string[]> GetFileUrlByU9List(string Type,string U9No)
+ public async Task<string[]> GetFileUrlByU9List(string Type, string U9No)
{
try
{
- var requestUrl = $"https://erp.dream-maker.com/api/public/getFileUrlByU9No?u9No={Uri.EscapeDataString(U9No)}&type={Type}";
+ var requestUrl =
+ $"https://erp.dream-maker.com/api/public/getFileUrlByU9No?u9No={Uri.EscapeDataString(U9No)}&type={Type}";
var response = await client.GetAsync(requestUrl);
response.EnsureSuccessStatusCode(); // 妫�鏌TTP鐘舵�佺爜
var responseContent = await response.Content.ReadAsStringAsync();
- var result = JsonConvert.DeserializeObject<ApiResponse>(responseContent);
+ var result =
+ JsonConvert.DeserializeObject<ApiResponse>(responseContent);
- if (result.Status == 0 && result.Data != null)
- {
- return result.Data;
- }
- else
- {
- return null;
- }
+ if (result.Status == 0 && result.Data != null) return result.Data;
+ return null;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
+
+ /// <summary>
+ /// 鏂欏彿鍥剧焊鎺ュ彛杩斿洖瀵硅薄
+ /// </summary>
+ public class ApiResponse
+ {
+ [JsonProperty("status")] public int Status { get; set; }
+
+ [JsonProperty("message")] public string Message { get; set; }
+
+ [JsonProperty("data")] public string[] Data { get; set; }
+
+ [JsonProperty("totalCount")] public int TotalCount { get; set; }
+ }
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/service/QC/RKJService.cs b/StandardPda/MES.Service/service/QC/RKJService.cs
index 6ad9bb9..20008bb 100644
--- a/StandardPda/MES.Service/service/QC/RKJService.cs
+++ b/StandardPda/MES.Service/service/QC/RKJService.cs
@@ -319,15 +319,10 @@
.Where(o => o.Id == detail.Gid)
.First();
- if (qsItemOqcReq == null)
- {
- throw new Exception("璇ユ楠屽崟涓嶅瓨鍦紝璇峰洖鍒板叆搴撴鍒楄〃閲嶆柊鏌ョ湅");
- }
+ if (qsItemOqcReq == null) throw new Exception("璇ユ楠屽崟涓嶅瓨鍦紝璇峰洖鍒板叆搴撴鍒楄〃閲嶆柊鏌ョ湅");
if (!string.IsNullOrEmpty(qsItemOqcReq.FcheckResu))
- {
throw new Exception("璇ユ楠屽崟宸�" + qsItemOqcReq.FcheckResu + "锛屼笉杩愯淇敼缁撴灉");
- }
var oracle = SqlSugarHelper.UseTransactionWithOracle(db =>
{
@@ -439,12 +434,12 @@
}
/// <summary>
- /// 褰撴楠屽崟涓嶅悎鏍兼椂锛�
- /// 鍙栨秷mes_inv_item_barcodes 鐨勬姤宸ユ爣璇� WORK_FLG
- /// womdaa 宸茬敓浜ч噺 DAA011鍔犲洖鏉＄爜鎶ュ伐鏁伴噺
- /// MES_SCGD_GX 妫�楠屾爣璇� CHECK_FLAG锛�('鈭�','脳')
- /// 閫氳繃mes_inv_item_in_c_details2鐨凪ES_SCGD_GX_ID杩炴帴
- ///</summary>
+ /// 褰撴楠屽崟涓嶅悎鏍兼椂锛�
+ /// 鍙栨秷mes_inv_item_barcodes 鐨勬姤宸ユ爣璇� WORK_FLG
+ /// womdaa 宸茬敓浜ч噺 DAA011鍔犲洖鏉＄爜鎶ュ伐鏁伴噺
+ /// MES_SCGD_GX 妫�楠屾爣璇� CHECK_FLAG锛�('鈭�','脳')
+ /// 閫氳繃mes_inv_item_in_c_details2鐨凪ES_SCGD_GX_ID杩炴帴
+ /// </summary>
private void setBarCodes(string? FcheckResu, QsItemOqcItemDetail detail,
SqlSugarClient db)
{
@@ -462,10 +457,7 @@
})
.ToList();
- if (oqcReqList.Count <= 0)
- {
- return;
- }
+ if (oqcReqList.Count <= 0) return;
var qsItemOqcReq = oqcReqList.First(); // 鑾峰彇绗竴涓厓绱�
@@ -499,7 +491,7 @@
.ExecuteCommand();
if (count <= 0) return;
-
+
//鍙栨秷mes_inv_item_barcodes 鐨勬姤宸ユ爣璇� WORK_FLG 浣跨敤鏉＄爜
var executeCommand = db.Updateable<MesInvItemBarcodes>()
.SetColumns(a => a.WorkFlg == 1)
@@ -507,13 +499,11 @@
.ExecuteCommand();
if (executeCommand > 0)
- {
//womdaa 宸茬敓浜ч噺 DAA011鍔犲洖鏉＄爜鎶ュ伐鏁伴噺
db.Updateable<Womdaa>()
.SetColumns(b => b.Daa011 == b.Daa011 + sumQty)
.Where(b => b.Daa001 == qsItemOqcReq.Daa001)
.ExecuteCommand();
- }
}
else if ("涓嶅悎鏍�".Equals(FcheckResu))
{
@@ -530,13 +520,11 @@
.ExecuteCommand();
if (executeCommand > 0)
- {
//womdaa 宸茬敓浜ч噺 DAA011鍔犲洖鏉＄爜鎶ュ伐鏁伴噺
db.Updateable<Womdaa>()
.SetColumns(b => b.Daa011 == b.Daa011 - sumQty)
.Where(b => b.Daa001 == qsItemOqcReq.Daa001)
.ExecuteCommand();
- }
}
}
@@ -609,7 +597,7 @@
c.Factory == ca.Factory,
JoinType.Left, c.Id == m.ItemInId && a.ItemNo == m.ItemNo,
JoinType.Left, da.Daa001 == c.RbillNo,
- JoinType.Left, da.Daa015 == z.LineNo//,
+ JoinType.Left, da.Daa015 == z.LineNo //,
//JoinType.Left,c.Bgr == d.UserNo
))
// .WhereIF(lineNo != null && lineNo.Length > 0,
@@ -629,8 +617,11 @@
//鍔犵瓫閫夋潯浠�,鏍规嵁渚涘簲鍟嗭紝鐗╂枡缂栫爜锛岀墿鏂欏悕绉版悳绱�
//.WhereIF(queryObj.SearchValue!=null && queryObj.SearchValue!="", (a) => a.SuppName == queryObj.SearchValue|| a.ItemName == queryObj.SearchValue || a.ItemNo == queryObj.SearchValue )
.WhereIF(queryObj.SearchValue != null && queryObj.SearchValue != "",
- (a, b, c, ca, m, da, z) => b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower())
- || a.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower()))
+ (a, b, c, ca, m, da, z) =>
+ b.ItemName.ToLower()
+ .Contains(queryObj.SearchValue.ToLower())
+ || a.ItemNo.ToLower()
+ .Contains(queryObj.SearchValue.ToLower()))
.Select((a, b, c, ca, m, da, z) => new QsItemOqcReq
{
BillNo = a.BillNo,
@@ -650,7 +641,7 @@
ItemInId = m.ItemInId,
Daa015 = da.Daa015,
LineNo = c.LineNo,
- Quantity = m.Quantity,
+ Quantity = m.Quantity
//Bgr = d.UserName
})
.OrderBy(a => a.CreateDate, OrderByType.Desc)
@@ -727,15 +718,10 @@
.Where(o => o.Id == detail.Gid)
.First();
- if (qsItemOqcReq == null)
- {
- throw new Exception("璇ユ楠屽崟涓嶅瓨鍦紝璇峰洖鍒板叆搴撴鍒楄〃閲嶆柊鏌ョ湅");
- }
+ if (qsItemOqcReq == null) throw new Exception("璇ユ楠屽崟涓嶅瓨鍦紝璇峰洖鍒板叆搴撴鍒楄〃閲嶆柊鏌ョ湅");
if (!string.IsNullOrEmpty(qsItemOqcReq.FcheckResu))
- {
throw new Exception("璇ユ楠屽崟宸�" + qsItemOqcReq.FcheckResu + "锛屼笉杩愯淇敼缁撴灉");
- }
var withOracle = SqlSugarHelper.UseTransactionWithOracle(db =>
{
@@ -852,13 +838,15 @@
private bool isRk(int? gid)
{
var db = SqlSugarHelper.GetInstance();
- return db.Queryable<QsItemOqcReq, MesInvItemIns, MesInvItemInCDetails2,MesInvItemStocks>(
- (a, b, c,d) => new JoinQueryInfos(
+ return db
+ .Queryable<QsItemOqcReq, MesInvItemIns, MesInvItemInCDetails2,
+ MesInvItemStocks>(
+ (a, b, c, d) => new JoinQueryInfos(
JoinType.Inner, a.BillNo == b.BillNo,
JoinType.Inner, b.Id == c.ItemInId,
- JoinType.Inner,c.ItemBarcode == d.ItemBarcode
+ JoinType.Inner, c.ItemBarcode == d.ItemBarcode
))
- .Where((a, b, c,d) => a.Id == gid)
+ .Where((a, b, c, d) => a.Id == gid)
.Count() > 0;
}
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/service/WomcaaManager.cs b/StandardPda/MES.Service/service/WomcaaManager.cs
new file mode 100644
index 0000000..91db2b7
--- /dev/null
+++ b/StandardPda/MES.Service/service/WomcaaManager.cs
@@ -0,0 +1,184 @@
+锘縰sing MES.Service.DB;
+using MES.Service.Dto.webApi;
+using MES.Service.Modes;
+using SqlSugar;
+
+namespace MES.Service.service;
+
+public class WomcaaManager : Repository<Womcaa>
+{
+ private readonly WomcabManager _womcabManager = new();
+
+ public bool SaveList(List<ErpWOM> rohIns)
+ {
+ var result = rohIns.Select(Save).ToList();
+ return result.All(b => b);
+ }
+
+ public bool Save(ErpWOM wom)
+ {
+ var womErpCaa = wom.ErpCaa;
+ var mesWomcaa = MapErpCAAtoWomcaa(womErpCaa);
+ var mesWomcabs =
+ MapErpCABtoWomcab(wom.ErpCabs);
+
+ return UseTransaction(db =>
+ {
+ switch (womErpCaa.Type)
+ {
+ case "3":
+ return UpdateData(db, mesWomcaa, mesWomcabs) ? 1 : 0;
+ case "2":
+ case "4":
+ case "5":
+ return SaveOrUpdateData(db, mesWomcaa, mesWomcabs)
+ ? 1
+ : 0;
+ default:
+ throw new NotImplementedException(
+ $"type绫诲瀷涓簕womErpCaa.Type}鐨勪笉瀛樺湪");
+ }
+ }) > 0;
+ }
+
+ private bool SaveOrUpdateData(SqlSugarScope db, Womcaa mesWomcaa,
+ List<Womcab> mesWomcabs)
+ {
+ if (mesWomcaa.Id != null) base.DeleteById(mesWomcaa.Id);
+
+ if (mesWomcabs.Count > 0)
+ db.Deleteable<Womcab>()
+ .Where(s => s.Eid == mesWomcaa.Erpid).ExecuteCommand();
+
+ var orUpdate = db.Insertable(mesWomcaa)
+ .IgnoreColumns(true).ExecuteCommand() > 0;
+
+ var baOrUpdate = db.Insertable(mesWomcabs).PageSize(1)
+ .IgnoreColumnsNull()
+ .ExecuteCommand() > 0;
+
+ if (orUpdate && baOrUpdate) return true;
+ throw new NotImplementedException("鏇存柊澶辫触");
+ }
+
+ private bool UpdateData(SqlSugarScope db, Womcaa mesWomcaa,
+ List<Womcab> mesWomcabs)
+ {
+ var decimals = mesWomcabs.Select(s => s.Id).ToArray();
+ var update = base.DeleteById(mesWomcaa.Id);
+ var insertOrUpdate = db
+ .Deleteable<Womcab>().In(decimals)
+ .ExecuteCommand() > 0;
+
+ if (update && insertOrUpdate) return true;
+ throw new NotImplementedException("鏇存柊澶辫触");
+ }
+
+ private Womcaa MapErpCAAtoWomcaa(ErpCAA dto)
+ {
+ var entity = new Womcaa
+ {
+ Erpid = Convert.ToInt32(dto.Id),
+ Caa001 = dto.FBillNo,
+ Caa021 = dto.FWorkShopID,
+ RoutingId = dto.FRoutingId,
+ WorkShopId = dto.FREMWorkShopId,
+ DepotCode = dto.FStockId,
+ CreateDate = dto.FDate,
+ Caa004 = dto.FBillType,
+ Caa023 = dto.FStatus,
+ Caa006 = dto.FMaterialId,
+ Caa009 = dto.FUnitId,
+ Caa012 = !string.IsNullOrEmpty(dto.FQty)
+ ? Convert.ToDecimal(dto.FQty)
+ : null,
+ WorkGroupId = dto.FWorkGroupId,
+ PlanId = dto.FPlannerID,
+ Caa010 = dto.FPlanStartDate,
+ Caa011 = dto.FPlanFinishDate,
+ Caa005 = dto.FConveyDate,
+ StockInlimith = dto.FStockInLimitH,
+ StockInlimitl = dto.FStockInLimitL,
+ Mtono = dto.FMTONO,
+ Lot = dto.FLot,
+ Caa013 = dto.FBomId,
+
+ CreateType = dto.FCreateType,
+ Caa018 = !string.IsNullOrEmpty(dto.PLAN_ID)
+ ? Convert.ToInt32(dto.PLAN_ID)
+ : null,
+ Caa019 = Convert.ToInt32(dto.PLAN_SEQ),
+ Caa020 = dto.PLAN_NUM,
+ SrcBillType = dto.FSrcBillType,
+ SrcBillNo = dto.FSrcBillNo,
+ SrcBillentryseq = dto.FSrcBillEntrySeq,
+ SaleOrderNo = dto.FSaleOrderNo,
+ SaleOrderEntryseq = dto.FSaleOrderEntrySeq,
+ ForceCloserid = dto.FForceCloserId,
+ CloseType = dto.FCloseType,
+ SrcSplitBillno = dto.FSrcSplitBillNo,
+ Caa016 = dto.FDescription,
+ //BTBZ = dto.BTBZ,
+ PrdOrg = dto.FPrdOrgId,
+ TrustOrg = dto.FEnTrustOrgId
+ //Typea = dto.TypeA
+ };
+
+
+ var single = base.GetSingle(it => it.Erpid == entity.Erpid);
+ if (single != null) entity.Id = single.Id;
+
+ return entity;
+ }
+
+ private List<Womcab> MapErpCABtoWomcab(List<ErpCAB> dtoList)
+ {
+ var womcabList = new List<Womcab>();
+
+ foreach (var dto in dtoList)
+ {
+ var womcab = new Womcab
+ {
+ Erpid = Convert.ToDecimal(dto.ID),
+ Cab001 = dto.FBillNo,
+ Cab002 = dto.FSeq,
+ Cab003 = dto.FMaterialID,
+ Cab006 = Convert.ToDecimal(dto.FNeedQty),
+ //MustQty = Convert.ToDecimal(dto.FMustQty),
+ Cab007 = Convert.ToDecimal(dto.FPickedQty),
+ PositionNo = dto.FPositionNO,
+ SupplyOrganization = dto.FChildSupplyOrgId,
+ IssuingOrganization = dto.FSupplyOrg,
+ OwnerId = dto.FOwnerID,
+ Mtono = dto.FMTONO,
+ Lot = dto.FLot,
+ DepotCode = dto.FStockID,
+ IssueType = dto.FIssueType,
+ Cab009 = dto.FUnitID,
+ SupplyType = dto.FSupplyType,
+ Cab012 = Convert.ToDecimal(dto.FStdQty),
+ // Freplacegroup = Convert.ToInt32(dto.FReplaceGroup),
+ // UseRate = Convert.ToDecimal(dto.FUseRate),
+ // MaterialType = dto.FMaterialType,
+ Cab014 = Convert.ToInt32(dto.FIsKeyItem),
+ Numerator = Convert.ToDecimal(dto.FNumerator),
+ Denominator = Convert.ToDecimal(dto.FDenominator),
+ Pid = Convert.ToDecimal(dto.FID),
+ Eid = Convert.ToDecimal(dto.FID)
+ // SCRAPQTY = Convert.ToDecimal(dto.FFixScrapQty),
+ // SCRAPRATE = Convert.ToDecimal(dto.FScrapRate),
+ // Typeb = dto.TypeB,
+ // WR_F_XIFG_Base_qtr = dto.F_XIFG_Base_qtr,
+ // WR_F_XIFG_Base_83g = dto.F_XIFG_Base_83g
+ };
+
+ var entity = Db.Queryable<Womcab>()
+ .Where(s => s.Erpid == womcab.Erpid).Single();
+ if (entity != null) womcab.Id = entity.Id;
+
+ womcabList.Add(womcab);
+ }
+
+ return womcabList;
+ }
+}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/service/WomcabManager.cs b/StandardPda/MES.Service/service/WomcabManager.cs
new file mode 100644
index 0000000..32545ea
--- /dev/null
+++ b/StandardPda/MES.Service/service/WomcabManager.cs
@@ -0,0 +1,8 @@
+锘縰sing MES.Service.DB;
+using MES.Service.Modes;
+
+namespace MES.Service.service;
+
+public class WomcabManager : Repository<Womcab>
+{
+}
\ No newline at end of file
--
Gitblit v1.9.3