From 481e4bef4be32a5a9754d01faf80bf0bc4e14951 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 28 八月 2024 14:23:16 +0800
Subject: [PATCH] 生产领料单
---
MES.Service/Modes/MesDepTaskInfo.cs | 346 ++++
MES.Service/Modes/Womdab.cs | 267 +-
MESApplication/bin/Debug/net8.0/MES.Service.pdb | 0
MES.Service/Modes/MesBarcodeType.cs | 462 ++--
MESApplication/bin/Debug/net8.0/MES.Service.dll | 0
MES.Service/Modes/MesInvItemBarcodes.cs | 319 +-
MES.Service/Modes/MesInvItemInCItems.cs | 184 +-
MES.Service/service/Warehouse/MesInvItemOutsManager.cs | 262 +++
MES.Service/Modes/Purdhb.cs | 352 ++--
MESApplication/bin/Debug/net8.0/MESApplication.pdb | 0
MESApplication/Controllers/Warehouse/MesInvItemOutCDetailsController.cs | 13
MES.Service/Modes/MesInvItemOutItems.cs | 16
MES.Service/service/Warehouse/MesInvItemOutCDetailsManager.cs | 77
MES.Service/Modes/MesInvItemArn.cs | 304 +-
MES.Service/service/Warehouse/OrganizeService.cs | 57
MESApplication/Controllers/BasicData/MesItemsController.cs | 4
MES.Service/Modes/QsItemOqcReq.cs | 68
MES.Service/DB/OracleSQLHelper.cs | 7
MES.Service/Modes/Purdka.cs | 160
MES.Service/bin/Debug/net8.0/MES.Service.pdb | 0
MES.Service/Modes/MesInvItemMoves.cs | 224 +-
MES.Service/Modes/MesInvTransaction.cs | 154
MES.Service/service/QC/XJService.cs | 2
MESApplication/bin/Debug/net8.0/MESApplication.dll | 0
MES.Service/Dto/service/MaterialReceipt.cs | 5
MES.Service/bin/Debug/net8.0/MES.Service.dll | 0
MES.Service/Modes/MesItems.cs | 530 +++---
MES.Service/Modes/QsQaItemXj.cs | 72
MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs | 3
MES.Service/Modes/MesQaItemsDetect01.cs | 422 ++--
MES.Service/Modes/MesInvBusiness2.cs | 288 +-
MES.Service/Modes/MesQaItemsDetectDetail5.cs | 216 +-
MES.Service/Modes/MesRfPrnbarcode.cs | 253 +-
MESApplication/bin/Debug/net8.0/MESApplication.exe | 0
MESApplication/Controllers/Warehouse/MesInvItemOutsController.cs | 83
MES.Service/Modes/MesInvItemOutCDetails.cs | 2
MES.Service/Dto/service/WarehouseQuery.cs | 4
MES.Service/Modes/Organize.cs | 3
38 files changed, 2,926 insertions(+), 2,233 deletions(-)
diff --git a/MES.Service/DB/OracleSQLHelper.cs b/MES.Service/DB/OracleSQLHelper.cs
index 4b5eaa7..9a36dba 100644
--- a/MES.Service/DB/OracleSQLHelper.cs
+++ b/MES.Service/DB/OracleSQLHelper.cs
@@ -9,10 +9,11 @@
/// </summary>
public class OracleSQLHelper
{
- private readonly string ConnectionString =AppsettingsUtility.Settings.DataBaseConn;
-
private readonly string _connectionString;
-
+
+ private readonly string ConnectionString =
+ AppsettingsUtility.Settings.DataBaseConn;
+
public OracleSQLHelper()
{
_connectionString = ConnectionString;
diff --git a/MES.Service/Dto/service/MaterialReceipt.cs b/MES.Service/Dto/service/MaterialReceipt.cs
index 680ada2..2bffa77 100644
--- a/MES.Service/Dto/service/MaterialReceipt.cs
+++ b/MES.Service/Dto/service/MaterialReceipt.cs
@@ -4,12 +4,9 @@
public class MaterialReceipt
{
-
+ public List<MesInvItemOutItems>? ItemsList { get; set; }
-
public List<MesInvItemOutCDetails>? InvItemoutCDetails { get; set; }
public MesInvItemOuts? ItemOuts { get; set; }
-
-
}
\ No newline at end of file
diff --git a/MES.Service/Dto/service/WarehouseQuery.cs b/MES.Service/Dto/service/WarehouseQuery.cs
index 925d2e2..218b284 100644
--- a/MES.Service/Dto/service/WarehouseQuery.cs
+++ b/MES.Service/Dto/service/WarehouseQuery.cs
@@ -24,12 +24,12 @@
public string? Company { get; set; }
public string? ItemNo { get; set; }
-
+
public string? ItemModel { get; set; }
public string? OrgName { get; set; }
public string? OrgOwner { get; set; }
public string? ItemNum { get; set; }
public string? Printnumn { get; set; }
-
+
public string? ItemName { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesBarcodeType.cs b/MES.Service/Modes/MesBarcodeType.cs
index f11c46e..2a8c96a 100644
--- a/MES.Service/Modes/MesBarcodeType.cs
+++ b/MES.Service/Modes/MesBarcodeType.cs
@@ -1,214 +1,250 @@
-锘縰sing System;
-using System.Collections.Generic;
-using System.Linq;
-using SqlSugar;
-namespace MES.Service.Modes
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 鏉＄爜绫诲瀷琛�
+/// </summary>
+[SugarTable("MES_BARCODE_TYPE")]
+public class MesBarcodeType
{
- /// <summary>
- /// 鏉＄爜绫诲瀷琛�
- ///</summary>
- [SugarTable("MES_BARCODE_TYPE")]
- public class MesBarcodeType
- {
- /// <summary>
- /// 鏉＄爜绫诲瀷ID(seq_me_id)
- ///</summary>
- [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )]
- public decimal Id { get; set; }
- /// <summary>
- /// 浣跨敤鍦烘墍
- ///</summary>
- [SugarColumn(ColumnName="USE_SITE" )]
- public string UseSite { get; set; }
- /// <summary>
- /// 鏉＄爜绫诲瀷鍚嶇О
- ///</summary>
- [SugarColumn(ColumnName="BARCODE_TYPE_NAME" )]
- public string BarcodeTypeName { get; set; }
- /// <summary>
- /// 鐮佸埗
- ///</summary>
- [SugarColumn(ColumnName="CODE" )]
- public string Code { get; set; }
- /// <summary>
- /// 鏉＄爜绾稿
- ///</summary>
- [SugarColumn(ColumnName="PAPER_WIDTH" )]
- public decimal? PaperWidth { get; set; }
- /// <summary>
- /// 鏉＄爜绾搁珮
- ///</summary>
- [SugarColumn(ColumnName="PAPER_HEIGHT" )]
- public decimal? PaperHeight { get; set; }
- /// <summary>
- /// 鏉＄爜寮�濮嬩綅缃甔
- ///</summary>
- [SugarColumn(ColumnName="BARCODE_BEGIN_POSITION_X" )]
- public decimal? BarcodeBeginPositionX { get; set; }
- /// <summary>
- /// 鏉＄爜寮�濮嬩綅缃甕
- ///</summary>
- [SugarColumn(ColumnName="BARCODE_BEGIN_POSITION_Y" )]
- public decimal? BarcodeBeginPositionY { get; set; }
- /// <summary>
- /// 涓�寮犳潯鐮佺焊涓婃潯鐮佷釜鏁�
- ///</summary>
- [SugarColumn(ColumnName="PAPER_NUM" )]
- public decimal? PaperNum { get; set; }
- /// <summary>
- /// 涓�寮犳潯鐮佺焊涓婃瘡琛屾潯鐮佷釜鏁�
- ///</summary>
- [SugarColumn(ColumnName="PAPER_ROW_NUM" )]
- public decimal? PaperRowNum { get; set; }
- /// <summary>
- /// 涓�寮犳潯鐮佺焊涓婃潯鐮佸垪鏁�
- ///</summary>
- [SugarColumn(ColumnName="PAPER_COLUMN_NUM" )]
- public decimal? PaperColumnNum { get; set; }
- /// <summary>
- /// 鏉＄爜娴佹按鍙峰惊鐜被鍨�(鎺у埗鏉＄爜娴佹按鍙�)
- ///</summary>
- [SugarColumn(ColumnName="CYCLE_TYPE" )]
- public string CycleType { get; set; }
- /// <summary>
- /// 鏄惁鏈夋晥(0-鏃犳晥,1-鏈夋晥)
- ///</summary>
- [SugarColumn(ColumnName="AVAILABLE_FLAG" )]
- public decimal? AvailableFlag { get; set; }
- /// <summary>
- /// 鏉＄爜楂樺害
- ///</summary>
- [SugarColumn(ColumnName="BARCODE_HEIGHT" )]
- public decimal? BarcodeHeight { get; set; }
- /// <summary>
- /// 鏉＄爜瀛椾綋鏂瑰悜
- ///</summary>
- [SugarColumn(ColumnName="BARCODE_ORIENTATION" )]
- public string BarcodeOrientation { get; set; }
- /// <summary>
- /// 鏉＄爜鎵撳嵃娉ㄩ噴琛�(1-鎵撳嵃锛�0-涓嶆墦鍗�)
- ///</summary>
- [SugarColumn(ColumnName="BARCODE_INTERPRETATION" )]
- public decimal? BarcodeInterpretation { get; set; }
- /// <summary>
- /// 鏉＄爜鎵撳嵃娉ㄩ噴琛屾墦鍦ㄦ潯鐮佷笂鏂�(1-鎵撳嵃鍦ㄦ潯鐮佷笂鏂癸紝0-涓嶆墦鍗板湪鏉＄爜涓婃柟)
- ///</summary>
- [SugarColumn(ColumnName="BARCODE_INTERPRETATION_ABOVE" )]
- public decimal? BarcodeInterpretationAbove { 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="LASTUPDATE_BY" )]
- public string LastupdateBy { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- ///</summary>
- [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
- public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 鏉＄爜瀹藉害
- ///</summary>
- [SugarColumn(ColumnName="BARCODE_WIDTH" )]
- public decimal? BarcodeWidth { get; set; }
- /// <summary>
- /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]妯″潡锛堢獎鏉★級瀹�
- ///</summary>
- [SugarColumn(ColumnName="BY_W" )]
- public decimal? ByW { get; set; }
- /// <summary>
- /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]瀹芥潯涓庣獎鏉＄殑姣斾緥
- ///</summary>
- [SugarColumn(ColumnName="BY_R" )]
- public decimal? ByR { get; set; }
- /// <summary>
- /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]鏉＄爜楂樺害
- ///</summary>
- [SugarColumn(ColumnName="BY_H" )]
- public decimal? ByH { get; set; }
- /// <summary>
- /// 鐐规暟/姣背
- ///</summary>
- [SugarColumn(ColumnName="JM" )]
- public string Jm { get; set; }
- /// <summary>
- /// 铏氭嫙鏁版嵁鏍囧織(1-鏄紝0锛嶅惁)
- ///</summary>
- [SugarColumn(ColumnName="JVM_DATA_FLAG" )]
- public decimal? JvmDataFlag { get; set; }
- /// <summary>
- /// 铏氭嫙鏁版嵁娴佹按鍙蜂綅鏁�
- ///</summary>
- [SugarColumn(ColumnName="JVM_SERIAL_DIGIT" )]
- public decimal? JvmSerialDigit { get; set; }
- /// <summary>
- /// 铏氭嫙鏁版嵁鏉＄爜闀垮害
- ///</summary>
- [SugarColumn(ColumnName="JVM_BARCODE_LENGTH" )]
- public decimal? JvmBarcodeLength { get; set; }
- /// <summary>
- /// 鎵撳嵃鍛戒护
- ///</summary>
- [SugarColumn(ColumnName="PRINT_COMMAND" )]
- public string PrintCommand { get; set; }
- /// <summary>
- /// 鎵撳嵃鍛戒护寮�濮�
- ///</summary>
- [SugarColumn(ColumnName="PRINT_COMMAND_BEGIN" )]
- public string PrintCommandBegin { get; set; }
- /// <summary>
- /// 鎵撳嵃鍛戒护缁撴潫
- ///</summary>
- [SugarColumn(ColumnName="PRINT_COMMAND_END" )]
- public string PrintCommandEnd { get; set; }
- /// <summary>
- /// 鏉＄爜娉ㄩ噴琛屾暟
- ///</summary>
- [SugarColumn(ColumnName="BARCODE_INTERPRETATION_ROW" )]
- public decimal? BarcodeInterpretationRow { get; set; }
- /// <summary>
- /// 鏉＄爜鍊煎甫鐗╂枡缂栫爜
- ///</summary>
- [SugarColumn(ColumnName="BARCODE_ITEM" )]
- public decimal? BarcodeItem { get; set; }
- /// <summary>
- /// 鏉＄爜绫诲瀷缂栫爜
- ///</summary>
- [SugarColumn(ColumnName="TYPE_CODE" )]
- public decimal TypeCode { get; set; }
- /// <summary>
- /// 鏄惁浣跨敤
- ///</summary>
- [SugarColumn(ColumnName="ISUSED" )]
- public short? Isused { get; set; }
- /// <summary>
- /// 鎵撳嵃妯℃澘
- ///</summary>
- [SugarColumn(ColumnName="MBTYPE" )]
- public decimal? Mbtype { 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="ORDER_NUM" )]
- public decimal? OrderNum { get; set; }
- }
-}
+ /// <summary>
+ /// 鏉＄爜绫诲瀷ID(seq_me_id)
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
+
+ /// <summary>
+ /// 浣跨敤鍦烘墍
+ /// </summary>
+ [SugarColumn(ColumnName = "USE_SITE")]
+ public string UseSite { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜绫诲瀷鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_TYPE_NAME")]
+ public string BarcodeTypeName { get; set; }
+
+ /// <summary>
+ /// 鐮佸埗
+ /// </summary>
+ [SugarColumn(ColumnName = "CODE")]
+ public string Code { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜绾稿
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_WIDTH")]
+ public decimal? PaperWidth { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜绾搁珮
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_HEIGHT")]
+ public decimal? PaperHeight { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜寮�濮嬩綅缃甔
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_BEGIN_POSITION_X")]
+ public decimal? BarcodeBeginPositionX { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜寮�濮嬩綅缃甕
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_BEGIN_POSITION_Y")]
+ public decimal? BarcodeBeginPositionY { get; set; }
+
+ /// <summary>
+ /// 涓�寮犳潯鐮佺焊涓婃潯鐮佷釜鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_NUM")]
+ public decimal? PaperNum { get; set; }
+
+ /// <summary>
+ /// 涓�寮犳潯鐮佺焊涓婃瘡琛屾潯鐮佷釜鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_ROW_NUM")]
+ public decimal? PaperRowNum { get; set; }
+
+ /// <summary>
+ /// 涓�寮犳潯鐮佺焊涓婃潯鐮佸垪鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_COLUMN_NUM")]
+ public decimal? PaperColumnNum { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜娴佹按鍙峰惊鐜被鍨�(鎺у埗鏉＄爜娴佹按鍙�)
+ /// </summary>
+ [SugarColumn(ColumnName = "CYCLE_TYPE")]
+ public string CycleType { get; set; }
+
+ /// <summary>
+ /// 鏄惁鏈夋晥(0-鏃犳晥,1-鏈夋晥)
+ /// </summary>
+ [SugarColumn(ColumnName = "AVAILABLE_FLAG")]
+ public decimal? AvailableFlag { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜楂樺害
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_HEIGHT")]
+ public decimal? BarcodeHeight { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜瀛椾綋鏂瑰悜
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_ORIENTATION")]
+ public string BarcodeOrientation { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜鎵撳嵃娉ㄩ噴琛�(1-鎵撳嵃锛�0-涓嶆墦鍗�)
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_INTERPRETATION")]
+ public decimal? BarcodeInterpretation { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜鎵撳嵃娉ㄩ噴琛屾墦鍦ㄦ潯鐮佷笂鏂�(1-鎵撳嵃鍦ㄦ潯鐮佷笂鏂癸紝0-涓嶆墦鍗板湪鏉＄爜涓婃柟)
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_INTERPRETATION_ABOVE")]
+ public decimal? BarcodeInterpretationAbove { 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 = "LASTUPDATE_BY")]
+ public string LastupdateBy { get; set; }
+
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ public DateTime? LastupdateDate { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜瀹藉害
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_WIDTH")]
+ public decimal? BarcodeWidth { get; set; }
+
+ /// <summary>
+ /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]妯″潡锛堢獎鏉★級瀹�
+ /// </summary>
+ [SugarColumn(ColumnName = "BY_W")]
+ public decimal? ByW { get; set; }
+
+ /// <summary>
+ /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]瀹芥潯涓庣獎鏉＄殑姣斾緥
+ /// </summary>
+ [SugarColumn(ColumnName = "BY_R")]
+ public decimal? ByR { get; set; }
+
+ /// <summary>
+ /// [鏀瑰彉鏉＄爜榛樿鍙傛暟]鏉＄爜楂樺害
+ /// </summary>
+ [SugarColumn(ColumnName = "BY_H")]
+ public decimal? ByH { get; set; }
+
+ /// <summary>
+ /// 鐐规暟/姣背
+ /// </summary>
+ [SugarColumn(ColumnName = "JM")]
+ public string Jm { get; set; }
+
+ /// <summary>
+ /// 铏氭嫙鏁版嵁鏍囧織(1-鏄紝0锛嶅惁)
+ /// </summary>
+ [SugarColumn(ColumnName = "JVM_DATA_FLAG")]
+ public decimal? JvmDataFlag { get; set; }
+
+ /// <summary>
+ /// 铏氭嫙鏁版嵁娴佹按鍙蜂綅鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "JVM_SERIAL_DIGIT")]
+ public decimal? JvmSerialDigit { get; set; }
+
+ /// <summary>
+ /// 铏氭嫙鏁版嵁鏉＄爜闀垮害
+ /// </summary>
+ [SugarColumn(ColumnName = "JVM_BARCODE_LENGTH")]
+ public decimal? JvmBarcodeLength { get; set; }
+
+ /// <summary>
+ /// 鎵撳嵃鍛戒护
+ /// </summary>
+ [SugarColumn(ColumnName = "PRINT_COMMAND")]
+ public string PrintCommand { get; set; }
+
+ /// <summary>
+ /// 鎵撳嵃鍛戒护寮�濮�
+ /// </summary>
+ [SugarColumn(ColumnName = "PRINT_COMMAND_BEGIN")]
+ public string PrintCommandBegin { get; set; }
+
+ /// <summary>
+ /// 鎵撳嵃鍛戒护缁撴潫
+ /// </summary>
+ [SugarColumn(ColumnName = "PRINT_COMMAND_END")]
+ public string PrintCommandEnd { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜娉ㄩ噴琛屾暟
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_INTERPRETATION_ROW")]
+ public decimal? BarcodeInterpretationRow { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜鍊煎甫鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_ITEM")]
+ public decimal? BarcodeItem { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "TYPE_CODE")]
+ public decimal TypeCode { get; set; }
+
+ /// <summary>
+ /// 鏄惁浣跨敤
+ /// </summary>
+ [SugarColumn(ColumnName = "ISUSED")]
+ public short? Isused { get; set; }
+
+ /// <summary>
+ /// 鎵撳嵃妯℃澘
+ /// </summary>
+ [SugarColumn(ColumnName = "MBTYPE")]
+ public decimal? Mbtype { 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 = "ORDER_NUM")]
+ public decimal? OrderNum { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesDepTaskInfo.cs b/MES.Service/Modes/MesDepTaskInfo.cs
new file mode 100644
index 0000000..49b445b
--- /dev/null
+++ b/MES.Service/Modes/MesDepTaskInfo.cs
@@ -0,0 +1,346 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 閮ㄩ棬鐢熶骇璁㈠崟淇℃伅琛�
+/// </summary>
+[SugarTable("MES_DEP_TASK_INFO")]
+public class MesDepTaskInfo
+{
+ /// <summary>
+ /// 閮ㄩ棬鐢熶骇璁㈠崟ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
+
+ /// <summary>
+ /// 璁㈠崟缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "TASK_NO")]
+ public string TaskNo { get; set; }
+
+ /// <summary>
+ /// ERP鐗╂枡缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_ITEM_NO")]
+ public string ErpItemNo { get; set; }
+
+ /// <summary>
+ /// 宸ュ崟鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "PLAN_QTY")]
+ public decimal? PlanQty { get; set; }
+
+ /// <summary>
+ /// 宸茬敓浜ч噺
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPLETE_QTY")]
+ public decimal? CompleteQty { get; set; }
+
+ /// <summary>
+ /// 澶囨崯鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "BACKUP_QTY")]
+ public decimal? BackupQty { get; set; }
+
+ /// <summary>
+ /// 涓嬭浇鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "DOWN_TIME")]
+ public DateTime? DownTime { get; set; }
+
+ /// <summary>
+ /// 璁″垝寮�濮嬫椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "PLAN_BEGIN_TIME")]
+ public DateTime? PlanBeginTime { get; set; }
+
+ /// <summary>
+ /// 璁″垝缁撴潫鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "PLAN_FINISH_TIME")]
+ public DateTime? PlanFinishTime { get; set; }
+
+ /// <summary>
+ /// 瀹為檯瀹屽伐鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "REAL_FINISH_TIME")]
+ public DateTime? RealFinishTime { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇鐘舵��(寰呬骇\鐢熶骇\鎸傝捣\瀹屽伐)
+ /// </summary>
+ [SugarColumn(ColumnName = "PRODUCE_STATE")]
+ public string ProduceState { get; set; }
+
+ /// <summary>
+ /// 瀹為檯寮�宸ユ椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "REAL_BEGIN_TIME")]
+ public DateTime? RealBeginTime { get; set; }
+
+ /// <summary>
+ /// 鏄惁鎸傝捣
+ /// </summary>
+ [SugarColumn(ColumnName = "HANG_UP")]
+ public string HangUp { get; set; }
+
+ /// <summary>
+ /// 浠撳簱缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_CODE")]
+ public string DepotCode { get; set; }
+
+ /// <summary>
+ /// 鎶ュ簾鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "DISCARD_QTY")]
+ public decimal? DiscardQty { get; set; }
+
+ /// <summary>
+ /// 濮嬫敹鏂欐椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "FIRST_ITEM_RECEIPT_TIME")]
+ public DateTime? FirstItemReceiptTime { get; set; }
+
+ /// <summary>
+ /// 濮嬮綈鏂欐椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "FIRST_ITEM_READY_TIME")]
+ public DateTime? FirstItemReadyTime { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CUST_NO")]
+ public string CustNo { get; set; }
+
+ /// <summary>
+ /// 鍑鸿揣鍖呰鏂瑰紡
+ /// </summary>
+ [SugarColumn(ColumnName = "PACK_SHIP_TYPE")]
+ public string PackShipType { get; set; }
+
+ /// <summary>
+ /// 鍖呰娉ㄦ剰浜嬮」
+ /// </summary>
+ [SugarColumn(ColumnName = "PACK_SHIP_MEMO")]
+ public string PackShipMemo { get; set; }
+
+ /// <summary>
+ /// 鏄惁宸叉帓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "ISSCHEME")]
+ public short? Isscheme { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_TYPE_ID")]
+ public decimal? BarcodeTypeId { get; set; }
+
+ /// <summary>
+ /// 鍙戝竷鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "ISSUE_STATUS")]
+ public short? IssueStatus { get; set; }
+
+ /// <summary>
+ /// 鐘舵�侊紙0=鎺掍骇鏈彂甯冦��1=鎺掍骇宸插彂甯冦��2=宸查鏂欍��3=宸茬敓浜с��4=鏆傚仠銆�8=宸插畬宸ャ��9=寮傚父锛�
+ /// </summary>
+ [SugarColumn(ColumnName = "FLAG")]
+ public short? Flag { get; set; }
+
+ /// <summary>
+ /// 棰嗘枡鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "MAT_DATE")]
+ public DateTime? MatDate { get; set; }
+
+ /// <summary>
+ /// 宸ヤ綔涓績
+ /// </summary>
+ [SugarColumn(ColumnName = "WORKCENTER_NO")]
+ public string WorkcenterNo { get; set; }
+
+ /// <summary>
+ /// 宸蹭笅杞借鍗曟爣璇哬-宸蹭笅杞�,N-鏈笅杞�
+ /// </summary>
+ [SugarColumn(ColumnName = "DOWN_FLAG")]
+ public short? DownFlag { get; set; }
+
+ /// <summary>
+ /// 鐜繚浠ｇ爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ROHSE_CODE")]
+ public string RohseCode { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛PO
+ /// </summary>
+ [SugarColumn(ColumnName = "CUST_PO")]
+ public string CustPo { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛鍨嬪彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CUST_STYLE")]
+ public string CustStyle { get; set; }
+
+ /// <summary>
+ /// 浜у搧鎵撳嵃鍥哄畾鍊�
+ /// </summary>
+ [SugarColumn(ColumnName = "PROC_PRINT_VALUE")]
+ public string ProcPrintValue { 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 = "LASTUPDATE_BY")]
+ public string LastupdateBy { get; set; }
+
+ /// <summary>
+ /// 鏇存柊鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ public DateTime? LastupdateDate { get; set; }
+
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "MEMO")]
+ public string Memo { get; set; }
+
+ /// <summary>
+ /// 瀹℃壒鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_STATUS")]
+ public string FcheckStatus { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_BY")]
+ public string FcheckBy { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_DATE")]
+ public DateTime? FcheckDate { 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 = "DATA_FROM")]
+ public string DataFrom { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇璁㈠崟琛ㄥごID
+ /// </summary>
+ [SugarColumn(ColumnName = "MOID")]
+ public decimal? Moid { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "PARTID")]
+ public decimal? Partid { get; set; }
+
+ /// <summary>
+ /// ERP宸ュ崟鐘舵�� 鐘舵�侊紙NA-寮�绔�/FM-閿佸畾/OP-瀹℃牳/CL-鍏抽棴锛�
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
+ public string Status { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇宸ュ崟
+ /// </summary>
+ [SugarColumn(ColumnName = "MOCODE")]
+ public string Mocode { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATEDATE")]
+ public DateTime? Createdate { get; set; }
+
+ /// <summary>
+ /// 棰滆壊
+ /// </summary>
+ [SugarColumn(ColumnName = "COLOR_NAME")]
+ public string ColorName { get; set; }
+
+ /// <summary>
+ /// 鍏抽棴鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CLOSETIME")]
+ public DateTime? Closetime { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
+ public string ItemNo { get; set; }
+
+ /// <summary>
+ /// 浠庤〃ID
+ /// </summary>
+ [SugarColumn(ColumnName = "MODID")]
+ public decimal? Modid { get; set; }
+
+ /// <summary>
+ /// 鏈�鏂颁笅杞芥洿鏂版爣璇�
+ /// </summary>
+ [SugarColumn(ColumnName = "UPDATE_FLG")]
+ public decimal? UpdateFlg { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇宸ュ崟琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "MOCODE_LINE")]
+ public decimal? MocodeLine { get; set; }
+
+ /// <summary>
+ /// 涓濆嵃鎬绘暟
+ /// </summary>
+ [SugarColumn(ColumnName = "SILK_QTY")]
+ public decimal? SilkQty { get; set; }
+
+ /// <summary>
+ /// 涓濆嵃鍗曚环
+ /// </summary>
+ [SugarColumn(ColumnName = "SILK_PRICE")]
+ public decimal? SilkPrice { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_ID")]
+ public decimal? ItemId { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesInvBusiness2.cs b/MES.Service/Modes/MesInvBusiness2.cs
index 89ddce5..9ca8594 100644
--- a/MES.Service/Modes/MesInvBusiness2.cs
+++ b/MES.Service/Modes/MesInvBusiness2.cs
@@ -8,220 +8,220 @@
[SugarTable("MES_INV_BUSINESS2")]
public class MesInvBusiness2
{
- /// <summary>
- /// ID(seq_inv_id)
- /// </summary>
- [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID",
+ /// <summary>
+ /// ID(seq_inv_id)
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID",
IsPrimaryKey = true)]
public decimal Id { get; set; }
- /// <summary>
- /// 鐘舵�亅0-鏈氦鏄�1-宸蹭氦鏄�
- /// </summary>
- [SugarColumn(ColumnName = "STATUS")]
+ /// <summary>
+ /// 鐘舵�亅0-鏈氦鏄�1-宸蹭氦鏄�
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
public decimal? Status { get; set; }
- /// <summary>
- /// 鍗曟嵁绫诲瀷ID
- /// </summary>
- [SugarColumn(ColumnName = "BILL_TYPE_ID")]
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_TYPE_ID")]
public decimal? BillTypeId { get; set; }
- /// <summary>
- /// 浜嬪姟绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "TRANSACTION_CODE")]
+ /// <summary>
+ /// 浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_CODE")]
public string TransactionCode { 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>
- /// 鍗曟嵁ID
- /// </summary>
- [SugarColumn(ColumnName = "BILL_ID")]
+ /// <summary>
+ /// 鍗曟嵁ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_ID")]
public decimal? BillId { get; set; }
- /// <summary>
- /// 鍗曟嵁缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "BILL_NO")]
+ /// <summary>
+ /// 鍗曟嵁缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
public string BillNo { get; set; }
- /// <summary>
- /// 鐢熶骇璁㈠崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
+ /// <summary>
+ /// 鐢熶骇璁㈠崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "TASK_NO")]
public string TaskNo { get; set; }
- /// <summary>
- /// 瀹㈡埛缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "CUSTOMER_NO")]
+ /// <summary>
+ /// 瀹㈡埛缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CUSTOMER_NO")]
public string CustomerNo { get; set; }
- /// <summary>
- /// 鍗曟嵁琛孖D
- /// </summary>
- [SugarColumn(ColumnName = "BILL_LINE_ID")]
+ /// <summary>
+ /// 鍗曟嵁琛孖D
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_LINE_ID")]
public decimal? BillLineId { get; set; }
- /// <summary>
- /// 鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
+ /// <summary>
+ /// 鐗╂枡鏉＄爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE")]
public string ItemBarcode { get; set; }
- /// <summary>
- /// 鏈徃鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
+ /// <summary>
+ /// 鏈徃鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
public string ItemNo { get; set; }
- /// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_CODE")]
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "C_ITEM_CODE")]
public string CItemCode { get; set; }
- /// <summary>
- /// 鍘傚鎵规
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO")]
+ /// <summary>
+ /// 鍘傚鎵规
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO")]
public string LotNo { get; set; }
- /// <summary>
- /// 鏄惁鐜繚(0:鍚�,1:鏄�)
- /// </summary>
- [SugarColumn(ColumnName = "EP_FLAG")]
+ /// <summary>
+ /// 鏄惁鐜繚(0:鍚�,1:鏄�)
+ /// </summary>
+ [SugarColumn(ColumnName = "EP_FLAG")]
public short? EpFlag { get; set; }
- /// <summary>
- /// 鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
+ /// <summary>
+ /// 鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "QUANTITY")]
public decimal? Quantity { get; set; }
- /// <summary>
- /// 婧愬瓙搴揅ODE
- /// </summary>
- [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")]
+ /// <summary>
+ /// 婧愬瓙搴揅ODE
+ /// </summary>
+ [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")]
public string FromInvDepotsCode { get; set; }
- /// <summary>
- /// 婧愯揣浣岰ODE
- /// </summary>
- [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")]
+ /// <summary>
+ /// 婧愯揣浣岰ODE
+ /// </summary>
+ [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")]
public string FromInvDepotSectionsCode { get; set; }
- /// <summary>
- /// 鐩殑瀛愬簱CODE
- /// </summary>
- [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")]
+ /// <summary>
+ /// 鐩殑瀛愬簱CODE
+ /// </summary>
+ [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")]
public string ToInvDepotsCode { get; set; }
- /// <summary>
- /// 鐩殑璐т綅CODE
- /// </summary>
- [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")]
+ /// <summary>
+ /// 鐩殑璐т綅CODE
+ /// </summary>
+ [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")]
public string ToInvDepotSectionsCode { get; set; }
- /// <summary>
- /// 浜ゆ槗寮傚父淇℃伅
- /// </summary>
- [SugarColumn(ColumnName = "DESCRIPTION")]
+ /// <summary>
+ /// 浜ゆ槗寮傚父淇℃伅
+ /// </summary>
+ [SugarColumn(ColumnName = "DESCRIPTION")]
public string Description { 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 = "ULLAGE_STAT_FLAG")]
+ /// <summary>
+ /// 瓒呮崯缁熻鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")]
public short? UllageStatFlag { 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 = "ITEM_BARCODE2")]
+ /// <summary>
+ /// 绠卞彿鏉＄爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE2")]
public string ItemBarcode2 { get; set; }
- /// <summary>
- /// 鍗℃澘鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE3")]
+ /// <summary>
+ /// 鍗℃澘鏉＄爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE3")]
public string ItemBarcode3 { get; set; }
- /// <summary>
- /// 浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
+ /// <summary>
+ /// 浠诲姟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_NO")]
public string WorkNo { get; set; }
- /// <summary>
- /// 浠诲姟鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
+ /// <summary>
+ /// 浠诲姟鍗曡鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_LINE")]
public decimal? WorkLine { get; set; }
- /// <summary>
- /// 渚涘簲鍟�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
+ /// <summary>
+ /// 渚涘簲鍟�
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
public string SuppNo { get; set; }
- /// <summary>
- /// 鐢熶骇绾�
- /// </summary>
- [SugarColumn(ColumnName = "LINE_NO")]
+ /// <summary>
+ /// 鐢熶骇绾�
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_NO")]
public string LineNo { get; set; }
- /// <summary>
- /// 閲囪喘璁㈠崟id
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_K3ID")]
+ /// <summary>
+ /// 閲囪喘璁㈠崟id
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN_K3ID")]
public decimal? EbelnK3id { get; set; }
- /// <summary>
- /// 閲囪喘璁㈠崟琛宨d
- /// </summary>
- [SugarColumn(ColumnName = "LINE_K3ID")]
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛宨d
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_K3ID")]
public decimal? LineK3id { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesInvItemArn.cs b/MES.Service/Modes/MesInvItemArn.cs
index 518f09f..bf0d207 100644
--- a/MES.Service/Modes/MesInvItemArn.cs
+++ b/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/MES.Service/Modes/MesInvItemBarcodes.cs b/MES.Service/Modes/MesInvItemBarcodes.cs
index 11af555..99458c0 100644
--- a/MES.Service/Modes/MesInvItemBarcodes.cs
+++ b/MES.Service/Modes/MesInvItemBarcodes.cs
@@ -16,482 +16,481 @@
public decimal Id { get; set; }
/// <summary>
- /// 鐗╂枡鏉＄爜
- ///</summary>
+ /// 鐗╂枡鏉＄爜
+ /// </summary>
[SugarColumn(ColumnName = "ITEM_BARCODE")]
public string ItemBarcode { get; set; }
/// <summary>
- /// 瀹㈡埛鎴愬搧缂栫爜
- ///</summary>
+ /// 瀹㈡埛鎴愬搧缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "C_PRODUCT_CODE")]
public string CProductCode { get; set; }
/// <summary>
- /// 瀹㈡埛鐗╂枡鏉＄爜
- ///</summary>
+ /// 瀹㈡埛鐗╂枡鏉＄爜
+ /// </summary>
[SugarColumn(ColumnName = "C_ITEM_BARCODE")]
public string CItemBarcode { get; set; }
/// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜
- ///</summary>
+ /// 瀹㈡埛鐗╂枡缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "C_ITEM_CODE")]
public string CItemCode { get; set; }
/// <summary>
- /// 鏈徃鐗╂枡缂栫爜
- ///</summary>
+ /// 鏈徃鐗╂枡缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "ITEM_NO")]
public string ItemNo { get; set; }
/// <summary>
- /// 鍘傚鎵规
- ///</summary>
+ /// 鍘傚鎵规
+ /// </summary>
[SugarColumn(ColumnName = "LOT_NO")]
public string LotNo { get; set; }
/// <summary>
- /// 鏁伴噺
- ///</summary>
+ /// 鏁伴噺
+ /// </summary>
[SugarColumn(ColumnName = "QUANTITY")]
public decimal? Quantity { get; set; }
/// <summary>
- /// 鏄惁鐜繚(0:鍚�,1:鏄�)
- ///</summary>
+ /// 鏄惁鐜繚(0:鍚�,1:鏄�)
+ /// </summary>
[SugarColumn(ColumnName = "EP_FLAG")]
public short? EpFlag { get; set; }
/// <summary>
- /// 鐢熶骇宸ュ崟
- ///</summary>
+ /// 鐢熶骇宸ュ崟
+ /// </summary>
[SugarColumn(ColumnName = "TASK_NO")]
public string TaskNo { 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 = "CUST_NO")]
public string CustNo { get; set; }
/// <summary>
- /// 鐗╂枡鏉＄爜娉ㄩ噴琛孾鍐椾綑锛屾潯鐮侀噸鎵撲娇鐢╙
- ///</summary>
+ /// 鐗╂枡鏉＄爜娉ㄩ噴琛孾鍐椾綑锛屾潯鐮侀噸鎵撲娇鐢╙
+ /// </summary>
[SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")]
public string ItemBarcodeText { get; set; }
/// <summary>
- /// 鍘烶SN鐗╂枡鏉＄爜
- ///</summary>
+ /// 鍘烶SN鐗╂枡鏉＄爜
+ /// </summary>
[SugarColumn(ColumnName = "OLD_ITEM_BARCODE")]
public string OldItemBarcode { get; set; }
/// <summary>
- /// SAP鏀惰揣鐗╂枡鍑瘉鍙� --閲囪喘鍗曞彿
- ///</summary>
+ /// SAP鏀惰揣鐗╂枡鍑瘉鍙� --閲囪喘鍗曞彿
+ /// </summary>
[SugarColumn(ColumnName = "MBLNR")]
public string Mblnr { get; set; }
/// <summary>
- /// SAP鏀惰揣鐗╂枡鍑瘉琛屽彿 --閲囪喘鍗曡鍙�
- ///</summary>
+ /// SAP鏀惰揣鐗╂枡鍑瘉琛屽彿 --閲囪喘鍗曡鍙�
+ /// </summary>
[SugarColumn(ColumnName = "ZEILE")]
public decimal? Zeile { get; set; }
/// <summary>
- /// 鏀舵枡琛↖D
- ///</summary>
+ /// 鏀舵枡琛↖D
+ /// </summary>
[SugarColumn(ColumnName = "ROH_IN_ID")]
public decimal? RohInId { get; set; }
/// <summary>
- /// 0涓烘湁鏁堟潯鐮侊紱1涓烘棤鏁堟潯鐮�
- ///</summary>
+ /// 0涓烘湁鏁堟潯鐮侊紱1涓烘棤鏁堟潯鐮�
+ /// </summary>
[SugarColumn(ColumnName = "BARCODESTATUS")]
public short? Barcodestatus { get; set; }
/// <summary>
- /// 鍘熷鏁伴噺
- ///</summary>
+ /// 鍘熷鏁伴噺
+ /// </summary>
[SugarColumn(ColumnName = "OLDQTY")]
public decimal? Oldqty { get; set; }
/// <summary>
- /// 浣跨敤鏁伴噺
- ///</summary>
+ /// 浣跨敤鏁伴噺
+ /// </summary>
[SugarColumn(ColumnName = "USEQTY")]
public decimal? Useqty { get; set; }
/// <summary>
- /// 0鍦ㄥ簱锛�1鍦ㄧ嚎锛�2浣滃簾
- ///</summary>
+ /// 0鍦ㄥ簱锛�1鍦ㄧ嚎锛�2浣滃簾
+ /// </summary>
[SugarColumn(ColumnName = "LOCATION")]
public short? Location { get; set; }
/// <summary>
- /// 鍗曚綅
- ///</summary>
+ /// 鍗曚綅
+ /// </summary>
[SugarColumn(ColumnName = "UNIT")]
public string Unit { get; set; }
/// <summary>
- /// 閲嶉噺锛堝崟浣嶏細鍏枻锛�
- ///</summary>
+ /// 閲嶉噺锛堝崟浣嶏細鍏枻锛�
+ /// </summary>
[SugarColumn(ColumnName = "WEIGHT_UNIT")]
public decimal? WeightUnit { get; set; }
/// <summary>
- /// 鍗曚环
- ///</summary>
+ /// 鍗曚环
+ /// </summary>
[SugarColumn(ColumnName = "PRICE")]
public decimal? Price { get; set; }
/// <summary>
- /// 鍘熸潯鐮佹暟閲�
- ///</summary>
+ /// 鍘熸潯鐮佹暟閲�
+ /// </summary>
[SugarColumn(ColumnName = "OLD_BAR_QUANTITY")]
public decimal? OldBarQuantity { get; set; }
/// <summary>
- /// 姹囨�绘潯鐮�
- ///</summary>
+ /// 姹囨�绘潯鐮�
+ /// </summary>
[SugarColumn(ColumnName = "SUM_BARCODE")]
public string SumBarcode { get; set; }
/// <summary>
- /// 鐢熶骇鏃ユ湡
- ///</summary>
+ /// 鐢熶骇鏃ユ湡
+ /// </summary>
[SugarColumn(ColumnName = "LOT_DATE")]
public string LotDate { get; set; }
/// <summary>
- /// 妯″彿
- ///</summary>
+ /// 妯″彿
+ /// </summary>
[SugarColumn(ColumnName = "MOCODE")]
public string Mocode { get; set; }
/// <summary>
- /// 鏉ユ簮
- ///</summary>
+ /// 鏉ユ簮
+ /// </summary>
[SugarColumn(ColumnName = "MEMO")]
public string Memo { get; set; }
/// <summary>
- /// 渚涘簲鍟嗙紪鐮�
- ///</summary>
+ /// 渚涘簲鍟嗙紪鐮�
+ /// </summary>
[SugarColumn(ColumnName = "SUPP_NO")]
public string SuppNo { get; set; }
/// <summary>
- /// 妗ｄ綅浣庡��
- ///</summary>
+ /// 妗ｄ綅浣庡��
+ /// </summary>
[SugarColumn(ColumnName = "SPOSTION")]
public string Spostion { get; set; }
/// <summary>
- /// 妗ｄ綅楂樺��
- ///</summary>
+ /// 妗ｄ綅楂樺��
+ /// </summary>
[SugarColumn(ColumnName = "EPOSTION")]
public string Epostion { get; set; }
/// <summary>
- /// 鐗╂枡绠�绉�
- ///</summary>
+ /// 鐗╂枡绠�绉�
+ /// </summary>
[SugarColumn(ColumnName = "ITEM_SNAME")]
public string ItemSname { get; set; }
/// <summary>
- /// 鏄惁宸插喕缁�,1鍐荤粨
- ///</summary>
+ /// 鏄惁宸插喕缁�,1鍐荤粨
+ /// </summary>
[SugarColumn(ColumnName = "VISABLE")]
public short? Visable { get; set; }
/// <summary>
- /// 渚涘簲鍟嗘壒娆�
- ///</summary>
+ /// 渚涘簲鍟嗘壒娆�
+ /// </summary>
[SugarColumn(ColumnName = "TR_LOTNO")]
public string TrLotno { get; set; }
/// <summary>
- /// 鍐荤粨鏃堕棿
- ///</summary>
+ /// 鍐荤粨鏃堕棿
+ /// </summary>
[SugarColumn(ColumnName = "FLEZZ_DATE")]
public DateTime? FlezzDate { get; set; }
/// <summary>
- /// 鍐荤粨鍘熷洜
- ///</summary>
+ /// 鍐荤粨鍘熷洜
+ /// </summary>
[SugarColumn(ColumnName = "FLEZZ_REASON")]
public string FlezzReason { get; set; }
/// <summary>
- /// 鍐荤粨浜�
- ///</summary>
+ /// 鍐荤粨浜�
+ /// </summary>
[SugarColumn(ColumnName = "FLEZZ_BY")]
public string FlezzBy { get; set; }
/// <summary>
- /// 寤堕暱淇濊川鏈�
- ///</summary>
+ /// 寤堕暱淇濊川鏈�
+ /// </summary>
[SugarColumn(ColumnName = "DELANY_MONTH")]
public decimal? DelanyMonth { get; set; }
/// <summary>
- /// 鏈�灏忓寘瑁呮爣璇�
- ///</summary>
+ /// 鏈�灏忓寘瑁呮爣璇�
+ /// </summary>
[SugarColumn(ColumnName = "MINPACK_FLAG")]
public short? MinpackFlag { get; set; }
/// <summary>
- /// 鎵撳嵃ID锛岀敤鏉ュ尯鍒嗘墦鍗版鏁�
- ///</summary>
+ /// 鎵撳嵃ID锛岀敤鏉ュ尯鍒嗘墦鍗版鏁�
+ /// </summary>
[SugarColumn(ColumnName = "PRINT_ID")]
public string PrintId { get; set; }
/// <summary>
- /// 鐜繚椤圭洰
- ///</summary>
+ /// 鐜繚椤圭洰
+ /// </summary>
[SugarColumn(ColumnName = "EP_ITEM")]
public string EpItem { get; set; }
/// <summary>
- /// 宸ュ巶缂栧彿
- ///</summary>
+ /// 宸ュ巶缂栧彿
+ /// </summary>
[SugarColumn(ColumnName = "FACTORY")]
public string Factory { get; set; }
/// <summary>
- /// 鍏徃缂栧彿
- ///</summary>
+ /// 鍏徃缂栧彿
+ /// </summary>
[SugarColumn(ColumnName = "COMPANY")]
public string Company { get; set; }
/// <summary>
- /// 鍗℃澘缂栫爜
- ///</summary>
+ /// 鍗℃澘缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "CB_NO")]
public string CbNo { get; set; }
/// <summary>
- /// 鍘傚鐢熶骇绾�
- ///</summary>
+ /// 鍘傚鐢熶骇绾�
+ /// </summary>
[SugarColumn(ColumnName = "LINFLINE")]
public string Linfline { get; set; }
/// <summary>
- /// 鏈夋晥鏈�
- ///</summary>
+ /// 鏈夋晥鏈�
+ /// </summary>
[SugarColumn(ColumnName = "VALID_TIME")]
public DateTime? ValidTime { get; set; }
/// <summary>
- /// 璐ㄦ缁撴灉
- ///</summary>
+ /// 璐ㄦ缁撴灉
+ /// </summary>
[SugarColumn(ColumnName = "IQC_STATUS")]
public string IqcStatus { get; set; }
/// <summary>
- /// 灏忚溅鏉＄爜
- ///</summary>
+ /// 灏忚溅鏉＄爜
+ /// </summary>
[SugarColumn(ColumnName = "FCAR")]
public string Fcar { get; set; }
/// <summary>
- /// 姣涢噸
- ///</summary>
+ /// 姣涢噸
+ /// </summary>
[SugarColumn(ColumnName = "GWEIGHT")]
public string Gweight { get; set; }
/// <summary>
- /// 鍑�閲�
- ///</summary>
+ /// 鍑�閲�
+ /// </summary>
[SugarColumn(ColumnName = "NWEIGHT")]
public string Nweight { get; set; }
/// <summary>
- /// 淇濊川鏈�
- ///</summary>
+ /// 淇濊川鏈�
+ /// </summary>
[SugarColumn(ColumnName = "EXT_DATE")]
public decimal? ExtDate { get; set; }
/// <summary>
- /// 渚涘簲鍟嗐�佽禒鍝併�佸渚涙枡銆佸澶�
- ///</summary>
+ /// 渚涘簲鍟嗐�佽禒鍝併�佸渚涙枡銆佸澶�
+ /// </summary>
[SugarColumn(ColumnName = "BARCODETYPE")]
public string Barcodetype { get; set; }
/// <summary>
- /// 渚涘簲鍟嗗悕绉�
- ///</summary>
+ /// 渚涘簲鍟嗗悕绉�
+ /// </summary>
[SugarColumn(ColumnName = "SUPP_NAME")]
public string SuppName { get; set; }
/// <summary>
- /// 鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿
- ///</summary>
+ /// 鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿
+ /// </summary>
[SugarColumn(ColumnName = "BILL_NO")]
public string BillNo { get; set; }
/// <summary>
- /// 鎬ユ枡鏍囪瘑
- ///</summary>
+ /// 鎬ユ枡鏍囪瘑
+ /// </summary>
[SugarColumn(ColumnName = "URGENT_FLAG")]
public short? UrgentFlag { get; set; }
/// <summary>
- /// 棰滆壊
- ///</summary>
+ /// 棰滆壊
+ /// </summary>
[SugarColumn(ColumnName = "COLOR_NAME")]
public string ColorName { get; set; }
/// <summary>
- /// 浜у搧鍨嬪彿
- ///</summary>
+ /// 浜у搧鍨嬪彿
+ /// </summary>
[SugarColumn(ColumnName = "BOARD_STYLE")]
public string BoardStyle { get; set; }
/// <summary>
- /// 鏉ユ枡鏃ユ湡
- ///</summary>
+ /// 鏉ユ枡鏃ユ湡
+ /// </summary>
[SugarColumn(ColumnName = "INS_DATE")]
public DateTime? InsDate { get; set; }
/// <summary>
- /// 鍒拌揣鍗曡鍙�
- ///</summary>
+ /// 鍒拌揣鍗曡鍙�
+ /// </summary>
[SugarColumn(ColumnName = "WORK_LINE")]
public decimal? WorkLine { get; set; }
/// <summary>
- /// 涓嶈壇鍘熷洜
- ///</summary>
+ /// 涓嶈壇鍘熷洜
+ /// </summary>
[SugarColumn(ColumnName = "MEMO_BAD")]
public string MemoBad { get; set; }
/// <summary>
- /// 浠诲姟鍗曞彿
- ///</summary>
+ /// 浠诲姟鍗曞彿
+ /// </summary>
[SugarColumn(ColumnName = "WORK_NO")]
public string WorkNo { get; set; }
/// <summary>
- /// 鏉＄爜鏉ユ簮鏍囪瘑锛�0-鍒濇湡鐗╂枡,1-閲囪喘鍏ュ簱锛�2銆佺敓浜ч��鏂欙紝3銆佸叾瀹冨叆搴擄紝4-瀹緵鏂�,5-鍦ㄥ簱鍒嗘枡锛�6-鍒剁▼鏉＄爜
- ///</summary>
+ /// 鏉＄爜鏉ユ簮鏍囪瘑锛�0-鍒濇湡鐗╂枡,1-閲囪喘鍏ュ簱锛�2銆佺敓浜ч��鏂欙紝3銆佸叾瀹冨叆搴擄紝4-瀹緵鏂�,5-鍦ㄥ簱鍒嗘枡锛�6-鍒剁▼鏉＄爜
+ /// </summary>
[SugarColumn(ColumnName = "COME_FLG")]
public short? ComeFlg { get; set; }
/// <summary>
- /// 鐢熶骇绾夸綋
- ///</summary>
+ /// 鐢熶骇绾夸綋
+ /// </summary>
[SugarColumn(ColumnName = "LINE_NO")]
public string LineNo { get; set; }
/// <summary>
- /// 涓濆嵃娆℃暟
- ///</summary>
+ /// 涓濆嵃娆℃暟
+ /// </summary>
[SugarColumn(ColumnName = "SILK_PQTY")]
public decimal? SilkPqty { get; set; }
/// <summary>
- /// 涓濆嵃娆℃暟姣�
- ///</summary>
+ /// 涓濆嵃娆℃暟姣�
+ /// </summary>
[SugarColumn(ColumnName = "SILK")]
public string Silk { get; set; }
/// <summary>
- /// 涓濆嵃娲惧伐浠庤〃ID
- ///</summary>
+ /// 涓濆嵃娲惧伐浠庤〃ID
+ /// </summary>
[SugarColumn(ColumnName = "SILK_ID")]
public decimal? SilkId { get; set; }
/// <summary>
- /// 宸叉姤宸ユ爣璇�
- ///</summary>
+ /// 宸叉姤宸ユ爣璇�
+ /// </summary>
[SugarColumn(ColumnName = "WORK_FLG")]
public decimal? WorkFlg { get; set; }
/// <summary>
- /// 鏈�鍚庡伐搴�
- ///</summary>
+ /// 鏈�鍚庡伐搴�
+ /// </summary>
[SugarColumn(ColumnName = "WORK_LAST")]
public decimal? WorkLast { get; set; }
/// <summary>
- /// 0-鏈悎骞舵墦鍗帮紝1-鍚堝苟鎵撳嵃
- ///</summary>
+ /// 0-鏈悎骞舵墦鍗帮紝1-鍚堝苟鎵撳嵃
+ /// </summary>
[SugarColumn(ColumnName = "HBDY")]
public decimal? Hbdy { get; set; }
/// <summary>
- /// 0-鏈夋晥鏉＄爜锛�1-鍚堝苟鎷嗗垎鐨勬潯鐮侊紝鏃犳晥
- ///</summary>
+ /// 0-鏈夋晥鏉＄爜锛�1-鍚堝苟鎷嗗垎鐨勬潯鐮侊紝鏃犳晥
+ /// </summary>
[SugarColumn(ColumnName = "HBDYTM")]
public decimal? Hbdytm { get; set; }
/// <summary>
- /// 鎶ュ伐鏃堕棿
- ///</summary>
+ /// 鎶ュ伐鏃堕棿
+ /// </summary>
[SugarColumn(ColumnName = "WORK_FLGTIME")]
public string WorkFlgtime { get; set; }
/// <summary>
- /// 閲囪喘璁㈠崟ID
- ///</summary>
+ /// 閲囪喘璁㈠崟ID
+ /// </summary>
[SugarColumn(ColumnName = "EBELN_K3ID")]
public decimal? EbelnK3id { get; set; }
/// <summary>
- /// 閲囪喘璁㈠崟琛孖D
- ///</summary>
+ /// 閲囪喘璁㈠崟琛孖D
+ /// </summary>
[SugarColumn(ColumnName = "LINE_K3ID")]
public decimal? LineK3id { get; set; }
/// <summary>
- ///
- ///</summary>
+ /// </summary>
[SugarColumn(ColumnName = "ITEM_ID")]
public decimal? ItemId { get; set; }
/// <summary>
- /// 鐢熶骇宸ュ簭ID
- ///</summary>
+ /// 鐢熶骇宸ュ簭ID
+ /// </summary>
[SugarColumn(ColumnName = "GX_ID")]
public decimal? GxId { get; set; }
/// <summary>
- /// 缁勭粐id
- ///</summary>
+ /// 缁勭粐id
+ /// </summary>
[SugarColumn(ColumnName = "ORG_NAME")]
public string OrgName { get; set; }
/// <summary>
- /// 璐т富id
- ///</summary>
+ /// 璐т富id
+ /// </summary>
[SugarColumn(ColumnName = "ORG_OWNER")]
public string OrgOwner { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesInvItemInCItems.cs b/MES.Service/Modes/MesInvItemInCItems.cs
index 05e3293..9c3eb27 100644
--- a/MES.Service/Modes/MesInvItemInCItems.cs
+++ b/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/MES.Service/Modes/MesInvItemMoves.cs b/MES.Service/Modes/MesInvItemMoves.cs
index b65928e..07b4ba6 100644
--- a/MES.Service/Modes/MesInvItemMoves.cs
+++ b/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/MES.Service/Modes/MesInvItemOutCDetails.cs b/MES.Service/Modes/MesInvItemOutCDetails.cs
index 13835d9..2a20b10 100644
--- a/MES.Service/Modes/MesInvItemOutCDetails.cs
+++ b/MES.Service/Modes/MesInvItemOutCDetails.cs
@@ -239,4 +239,6 @@
[SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
[SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
[SugarColumn(IsIgnore = true)] public string? Unit { get; set; }
+
+ [SugarColumn(IsIgnore = true)] public string DepotSectionName { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesInvItemOutItems.cs b/MES.Service/Modes/MesInvItemOutItems.cs
index 51098b2..41d01b8 100644
--- a/MES.Service/Modes/MesInvItemOutItems.cs
+++ b/MES.Service/Modes/MesInvItemOutItems.cs
@@ -87,11 +87,13 @@
public string? TaskNo { get; set; }
/// <summary>
+ /// 鍒拌揣鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "WORK_NO")]
public string? WorkNo { get; set; }
/// <summary>
+ /// 鍒拌揣鍗曡鍙�
/// </summary>
[SugarColumn(ColumnName = "WORK_LINE")]
public decimal? WorkLine { get; set; }
@@ -179,7 +181,7 @@
public decimal? Allocateid { get; set; }
/// <summary>
- /// 棰嗘枡缂栧彿
+ /// 棰嗘枡缂栧彿/鐢熶骇宸ュ崟
/// </summary>
[SugarColumn(ColumnName = "PBILL_NO")]
public string? PbillNo { get; set; }
@@ -208,7 +210,17 @@
[SugarColumn(ColumnName = "TL_QTY")]
public decimal? TlQty { get; set; }
- [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_ID")]
+ public decimal? ItemId { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡鎶曟枡鍗旾D
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_DABID")]
+ public decimal? ItemDabid { get; set; }
[SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
[SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
diff --git a/MES.Service/Modes/MesInvTransaction.cs b/MES.Service/Modes/MesInvTransaction.cs
index 3c920d9..635c014 100644
--- a/MES.Service/Modes/MesInvTransaction.cs
+++ b/MES.Service/Modes/MesInvTransaction.cs
@@ -1,74 +1,82 @@
-锘縰sing System;
-using System.Collections.Generic;
-using System.Linq;
-using SqlSugar;
-namespace MES.Service.Modes
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 搴撳瓨浜嬪姟澶勭悊琛�
+/// </summary>
+[SugarTable("MES_INV_TRANSACTION")]
+public class MesInvTransaction
{
- /// <summary>
- /// 搴撳瓨浜嬪姟澶勭悊琛�
- ///</summary>
- [SugarTable("MES_INV_TRANSACTION")]
- public class MesInvTransaction
- {
- /// <summary>
- /// ID
- ///</summary>
- [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )]
- public decimal Id { get; set; }
- /// <summary>
- /// 浜嬪姟绫诲瀷
- ///</summary>
- [SugarColumn(ColumnName="TRANSACTION_NAME" )]
- public string TransactionName { get; set; }
- /// <summary>
- /// 澶囨敞
- ///</summary>
- [SugarColumn(ColumnName="REMARK" )]
- public string Remark { 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="LASTUPDATE_BY" )]
- public string LastupdateBy { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- ///</summary>
- [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
- public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 鍗曟嵁ID
- ///</summary>
- [SugarColumn(ColumnName="BUSINESS_ID" )]
- public decimal? BusinessId { get; set; }
- /// <summary>
- /// 浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱
- ///</summary>
- [SugarColumn(ColumnName="BUSINESS_TYPE" )]
- public decimal? BusinessType { get; set; }
- /// <summary>
- /// 浜嬪姟缂栫爜
- ///</summary>
- [SugarColumn(ColumnName="TRANSACTION_NO" )]
- public decimal? TransactionNo { get; set; }
- /// <summary>
- /// 鍒嗗巶缂栫爜
- ///</summary>
- [SugarColumn(ColumnName="FACTORY" )]
- public string Factory { get; set; }
- /// <summary>
- /// 鍏徃浠ｇ爜
- ///</summary>
- [SugarColumn(ColumnName="COMPANY" )]
- public string Company { get; set; }
- }
-}
+ /// <summary>
+ /// ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
+
+ /// <summary>
+ /// 浜嬪姟绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_NAME")]
+ public string TransactionName { get; set; }
+
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK")]
+ public string Remark { 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 = "LASTUPDATE_BY")]
+ public string LastupdateBy { get; set; }
+
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ public DateTime? LastupdateDate { get; set; }
+
+ /// <summary>
+ /// 鍗曟嵁ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BUSINESS_ID")]
+ public decimal? BusinessId { get; set; }
+
+ /// <summary>
+ /// 浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱
+ /// </summary>
+ [SugarColumn(ColumnName = "BUSINESS_TYPE")]
+ public decimal? BusinessType { get; set; }
+
+ /// <summary>
+ /// 浜嬪姟缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_NO")]
+ public decimal? TransactionNo { get; set; }
+
+ /// <summary>
+ /// 鍒嗗巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+ public string Factory { get; set; }
+
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+ public string Company { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesItems.cs b/MES.Service/Modes/MesItems.cs
index b82d99c..f90f8fa 100644
--- a/MES.Service/Modes/MesItems.cs
+++ b/MES.Service/Modes/MesItems.cs
@@ -1,322 +1,318 @@
-锘縰sing System;
-using System.Collections.Generic;
-using System.Linq;
-using SqlSugar;
+锘縰sing SqlSugar;
-namespace MES.Service.Modes
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 鐗╂枡淇℃伅
+/// </summary>
+[SugarTable("MES_ITEMS")]
+public class MesItems
{
/// <summary>
- /// 鐗╂枡淇℃伅
- ///</summary>
- [SugarTable("MES_ITEMS")]
- public class MesItems
- {
- /// <summary>
- /// 鐗╂枡ID
- ///</summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
- public decimal Id { get; set; }
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
- /// <summary>
- /// 宸ュ巶
- ///</summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string Factory { get; set; }
+ /// <summary>
+ /// 宸ュ巶
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+ public string Factory { get; set; }
- /// <summary>
- /// 鍏徃缂栧彿
- ///</summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string Company { get; set; }
+ /// <summary>
+ /// 鍏徃缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+ public string Company { get; set; }
- /// <summary>
- /// 鐗╂枡缂栫爜 = ERP鐗╂枡缂栧彿||棰滆壊缂栧彿
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
- public string ItemNo { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜 = ERP鐗╂枡缂栧彿||棰滆壊缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
+ public string ItemNo { get; set; }
- /// <summary>
- /// 鐗╂枡鍚嶇О
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_NAME")]
- public string ItemName { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NAME")]
+ public string ItemName { get; set; }
- /// <summary>
- /// 鐗╂枡绠�绉�
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_SNAME")]
- public string ItemSname { get; set; }
+ /// <summary>
+ /// 鐗╂枡绠�绉�
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_SNAME")]
+ public string ItemSname { get; set; }
- /// <summary>
- /// 瑙勬牸鍨嬪彿
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_MODEL")]
- public string ItemModel { get; set; }
+ /// <summary>
+ /// 瑙勬牸鍨嬪彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_MODEL")]
+ public string ItemModel { get; set; }
- /// <summary>
- /// 鐗╂枡鎻忚堪
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_DESCRIPTION")]
- public string ItemDescription { get; set; }
+ /// <summary>
+ /// 鐗╂枡鎻忚堪
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_DESCRIPTION")]
+ public string ItemDescription { get; set; }
- /// <summary>
- /// 鐗╂枡鍗曚綅
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_UNIT")]
- public string ItemUnit { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_UNIT")]
+ public string ItemUnit { get; set; }
- /// <summary>
- /// 鐗╂枡绫诲瀷
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_TYPE")]
- public string ItemType { get; set; }
+ /// <summary>
+ /// 鐗╂枡绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_TYPE")]
+ public string ItemType { get; set; }
- /// <summary>
- /// 浜у搧鐗堟湰
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_VERSION")]
- public string ItemVersion { get; set; }
+ /// <summary>
+ /// 浜у搧鐗堟湰
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_VERSION")]
+ public string ItemVersion { get; set; }
- /// <summary>
- /// 瀹㈡埛缂栧彿
- ///</summary>
- [SugarColumn(ColumnName = "CUST_NO")]
- public string CustNo { get; set; }
+ /// <summary>
+ /// 瀹㈡埛缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CUST_NO")]
+ public string CustNo { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- ///</summary>
- [SugarColumn(ColumnName = "CREATE_BY")]
- public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
+ public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓鏃堕棿
- ///</summary>
- [SugarColumn(ColumnName = "CREATE_DATE")]
- public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
+ public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- ///</summary>
- [SugarColumn(ColumnName = "LASTUPDATE_BY")]
- public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ public string LastupdateBy { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- ///</summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
- public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 鏈�浣庡簱瀛�
- ///</summary>
- [SugarColumn(ColumnName = "LOWLIMIT")]
- public double? Lowlimit { get; set; }
+ /// <summary>
+ /// 鏈�浣庡簱瀛�
+ /// </summary>
+ [SugarColumn(ColumnName = "LOWLIMIT")]
+ public double? Lowlimit { get; set; }
- /// <summary>
- /// 鏈�澶у簱瀛�
- ///</summary>
- [SugarColumn(ColumnName = "HIGHLIMIT")]
- public double? Highlimit { get; set; }
+ /// <summary>
+ /// 鏈�澶у簱瀛�
+ /// </summary>
+ [SugarColumn(ColumnName = "HIGHLIMIT")]
+ public double? Highlimit { get; set; }
- /// <summary>
- /// 鏈�灏忓寘瑁呮暟
- ///</summary>
- [SugarColumn(ColumnName = "PRD_PACK")]
- public double? PrdPack { get; set; }
+ /// <summary>
+ /// 鏈�灏忓寘瑁呮暟
+ /// </summary>
+ [SugarColumn(ColumnName = "PRD_PACK")]
+ public double? PrdPack { get; set; }
- /// <summary>
- /// 璁㈠崟鍗曚綅
- ///</summary>
- [SugarColumn(ColumnName = "ORDERUNIT")]
- public string Orderunit { get; set; }
+ /// <summary>
+ /// 璁㈠崟鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "ORDERUNIT")]
+ public string Orderunit { get; set; }
- /// <summary>
- /// 閿�鍞崟浣�
- ///</summary>
- [SugarColumn(ColumnName = "SALEUNIT")]
- public string Saleunit { get; set; }
+ /// <summary>
+ /// 閿�鍞崟浣�
+ /// </summary>
+ [SugarColumn(ColumnName = "SALEUNIT")]
+ public string Saleunit { get; set; }
- /// <summary>
- /// 搴撴埧鍗曚綅
- ///</summary>
- [SugarColumn(ColumnName = "STOREUNIT")]
- public string Storeunit { get; set; }
+ /// <summary>
+ /// 搴撴埧鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "STOREUNIT")]
+ public string Storeunit { get; set; }
- /// <summary>
- /// 鐢熶骇鍗曚綅
- ///</summary>
- [SugarColumn(ColumnName = "PRODUCTUNIT")]
- public string Productunit { get; set; }
+ /// <summary>
+ /// 鐢熶骇鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "PRODUCTUNIT")]
+ public string Productunit { get; set; }
- /// <summary>
- /// 鐗╂枡ID
- ///</summary>
- [SugarColumn(ColumnName = "E_ITEM_ID")]
- public decimal? EItemId { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "E_ITEM_ID")]
+ public decimal? EItemId { get; set; }
- /// <summary>
- /// ERP鏂欏彿
- ///</summary>
- [SugarColumn(ColumnName = "ERP_ITEM_NO")]
- public string ErpItemNo { get; set; }
+ /// <summary>
+ /// ERP鏂欏彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_ITEM_NO")]
+ public string ErpItemNo { get; set; }
- /// <summary>
- /// 榛樿浠撳簱
- ///</summary>
- [SugarColumn(ColumnName = "DEPOT_CODE")]
- public string DepotCode { get; set; }
+ /// <summary>
+ /// 榛樿浠撳簱
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_CODE")]
+ public string DepotCode { get; set; }
- /// <summary>
- /// 鐗╂枡鍒嗙被缂栧彿
- ///</summary>
- [SugarColumn(ColumnName = "PPBOM00019124")]
- public string Ppbom00019124 { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍒嗙被缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "PPBOM00019124")]
+ public string Ppbom00019124 { get; set; }
- /// <summary>
- /// 鐗╂枡鍒嗙粍
- ///</summary>
- [SugarColumn(ColumnName = "REMARKS")]
- public string Remarks { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍒嗙粍
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARKS")]
+ public string Remarks { get; set; }
- /// <summary>
- /// 閲囪喘鍛�
- ///</summary>
- [SugarColumn(ColumnName = "FPURCHASERID")]
- public string Fpurchaserid { get; set; }
+ /// <summary>
+ /// 閲囪喘鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "FPURCHASERID")]
+ public string Fpurchaserid { get; set; }
- /// <summary>
- /// 绂佺敤鐘舵��
- ///</summary>
- [SugarColumn(ColumnName = "FFORBIDSTATUS")]
- public string Fforbidstatus { get; set; }
+ /// <summary>
+ /// 绂佺敤鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "FFORBIDSTATUS")]
+ public string Fforbidstatus { get; set; }
- /// <summary>
- /// 鐗╂枡鍒嗙粍
- ///</summary>
- [SugarColumn(ColumnName = "FMATERIALGROUP")]
- public string Fmaterialgroup { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍒嗙粍
+ /// </summary>
+ [SugarColumn(ColumnName = "FMATERIALGROUP")]
+ public string Fmaterialgroup { get; set; }
- /// <summary>
- /// 瀹屽伐瓒呮敹姣斾緥
- ///</summary>
- [SugarColumn(ColumnName = "FFINISHRECEIPTOVERRATE")]
- public decimal? Ffinishreceiptoverrate { get; set; }
+ /// <summary>
+ /// 瀹屽伐瓒呮敹姣斾緥
+ /// </summary>
+ [SugarColumn(ColumnName = "FFINISHRECEIPTOVERRATE")]
+ public decimal? Ffinishreceiptoverrate { get; set; }
- /// <summary>
- /// 鍙戞枡鏂瑰紡
- ///</summary>
- [SugarColumn(ColumnName = "FISSUETYPE")]
- public string Fissuetype { get; set; }
+ /// <summary>
+ /// 鍙戞枡鏂瑰紡
+ /// </summary>
+ [SugarColumn(ColumnName = "FISSUETYPE")]
+ public string Fissuetype { get; set; }
- /// <summary>
- /// 鍚敤鎵瑰彿绠＄悊
- ///</summary>
- [SugarColumn(ColumnName = "FISBATCHMANAGE")]
- public decimal? Fisbatchmanage { get; set; }
+ /// <summary>
+ /// 鍚敤鎵瑰彿绠＄悊
+ /// </summary>
+ [SugarColumn(ColumnName = "FISBATCHMANAGE")]
+ public decimal? Fisbatchmanage { get; set; }
- /// <summary>
- /// 閲囪喘鍗曚綅
- ///</summary>
- [SugarColumn(ColumnName = "FPURCHASEUNITID")]
- public string Fpurchaseunitid { get; set; }
+ /// <summary>
+ /// 閲囪喘鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "FPURCHASEUNITID")]
+ public string Fpurchaseunitid { get; set; }
- /// <summary>
- /// 鑷畾涔夊瓧娈�1
- ///</summary>
- [SugarColumn(ColumnName = "REMARK1")]
- public string Remark1 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�1
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK1")]
+ public string Remark1 { get; set; }
- /// <summary>
- /// 鑷畾涔夊瓧娈�2
- ///</summary>
- [SugarColumn(ColumnName = "REMARK2")]
- public string Remark2 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�2
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK2")]
+ public string Remark2 { get; set; }
- /// <summary>
- /// 鑷畾涔夊瓧娈�3
- ///</summary>
- [SugarColumn(ColumnName = "REMARK3")]
- public string Remark3 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�3
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK3")]
+ public string Remark3 { get; set; }
- /// <summary>
- /// 鑷畾涔夊瓧娈�4
- ///</summary>
- [SugarColumn(ColumnName = "REMARK4")]
- public string Remark4 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�4
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK4")]
+ public string Remark4 { get; set; }
- /// <summary>
- /// 鑷畾涔夊瓧娈�5
- ///</summary>
- [SugarColumn(ColumnName = "REMARK5")]
- public string Remark5 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�5
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK5")]
+ public string Remark5 { get; set; }
- /// <summary>
- /// 鐢熶骇杞﹂棿
- ///</summary>
- [SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")]
- public string ProductionWorkshop { get; set; }
+ /// <summary>
+ /// 鐢熶骇杞﹂棿
+ /// </summary>
+ [SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")]
+ public string ProductionWorkshop { get; set; }
- /// <summary>
- /// 鐗╂枡灞炴��
- ///</summary>
- [SugarColumn(ColumnName = "MATERIAL_PROPERTI")]
- public string MaterialProperti { get; set; }
+ /// <summary>
+ /// 鐗╂枡灞炴��
+ /// </summary>
+ [SugarColumn(ColumnName = "MATERIAL_PROPERTI")]
+ public string MaterialProperti { get; set; }
- /// <summary>
- /// 鐢熶骇鍗曚綅
- ///</summary>
- [SugarColumn(ColumnName = "PRODUCE_UNIT")]
- public string ProduceUnit { get; set; }
+ /// <summary>
+ /// 鐢熶骇鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "PRODUCE_UNIT")]
+ public string ProduceUnit { get; set; }
- /// <summary>
- /// 濮斿鍗曚綅
- ///</summary>
- [SugarColumn(ColumnName = "SUBCON_UNIT")]
- public string SubconUnit { get; set; }
+ /// <summary>
+ /// 濮斿鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "SUBCON_UNIT")]
+ public string SubconUnit { get; set; }
- /// <summary>
- /// 鍥剧墖1
- ///</summary>
- [SugarColumn(ColumnName = "BZ06")]
- public string Bz06 { get; set; }
+ /// <summary>
+ /// 鍥剧墖1
+ /// </summary>
+ [SugarColumn(ColumnName = "BZ06")]
+ public string Bz06 { get; set; }
- /// <summary>
- /// 鍥剧墖2
- ///</summary>
- [SugarColumn(ColumnName = "BZ07")]
- public string Bz07 { get; set; }
+ /// <summary>
+ /// 鍥剧墖2
+ /// </summary>
+ [SugarColumn(ColumnName = "BZ07")]
+ public string Bz07 { get; set; }
- /// <summary>
- /// 鍥剧墖3
- ///</summary>
- [SugarColumn(ColumnName = "BZ08")]
- public string Bz08 { get; set; }
+ /// <summary>
+ /// 鍥剧墖3
+ /// </summary>
+ [SugarColumn(ColumnName = "BZ08")]
+ public string Bz08 { get; set; }
- /// <summary>
- /// 鍥剧墖4
- ///</summary>
- [SugarColumn(ColumnName = "BZ09")]
- public string Bz09 { get; set; }
+ /// <summary>
+ /// 鍥剧墖4
+ /// </summary>
+ [SugarColumn(ColumnName = "BZ09")]
+ public string Bz09 { get; set; }
- /// <summary>
- /// 鍥剧墖5
- ///</summary>
- [SugarColumn(ColumnName = "BZ10")]
- public string Bz10 { get; set; }
+ /// <summary>
+ /// 鍥剧墖5
+ /// </summary>
+ [SugarColumn(ColumnName = "BZ10")]
+ public string Bz10 { get; set; }
- /// <summary>
- /// QC鍒嗙粍ID
- ///</summary>
- [SugarColumn(ColumnName = "QC_TEAMID")]
- public string QcTeamid { get; set; }
+ /// <summary>
+ /// QC鍒嗙粍ID
+ /// </summary>
+ [SugarColumn(ColumnName = "QC_TEAMID")]
+ public string QcTeamid { get; set; }
- /// <summary>
- /// 鐗╂枡ID
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_ID")]
- public decimal? ItemId { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_ID")]
+ public decimal? ItemId { get; set; }
- [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
- }
+ [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesQaItemsDetect01.cs b/MES.Service/Modes/MesQaItemsDetect01.cs
index 2a26d0c..14760fb 100644
--- a/MES.Service/Modes/MesQaItemsDetect01.cs
+++ b/MES.Service/Modes/MesQaItemsDetect01.cs
@@ -8,324 +8,324 @@
[SugarTable("MES_QA_ITEMS_DETECT_01")]
public class MesQaItemsDetect01
{
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
- /// <summary>
- /// 妫�楠屽崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "RELEASE_NO")]
+ /// <summary>
+ /// 妫�楠屽崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "RELEASE_NO")]
public string ReleaseNo { get; set; }
- /// <summary>
- /// 妫�楠屾棩鏈�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_DATE")]
+ /// <summary>
+ /// 妫�楠屾棩鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_DATE")]
public DateTime? FcheckDate { get; set; }
- /// <summary>
- /// 妫�楠屼汉鍛�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_BY")]
+ /// <summary>
+ /// 妫�楠屼汉鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_BY")]
public string FcheckBy { get; set; }
- /// <summary>
- /// 鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
public string ItemNo { get; set; }
- /// <summary>
- /// 鏉ユ枡鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "FBATCH_QTY")]
+ /// <summary>
+ /// 鏉ユ枡鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FBATCH_QTY")]
public decimal? FbatchQty { get; set; }
- /// <summary>
- /// 鍒ゅ畾缁撴灉
- /// </summary>
- [SugarColumn(ColumnName = "FRECE_QTY")]
+ /// <summary>
+ /// 鍒ゅ畾缁撴灉
+ /// </summary>
+ [SugarColumn(ColumnName = "FRECE_QTY")]
public string FreceQty { get; set; }
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
public string SuppNo { get; set; }
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "FNG_DESC")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_DESC")]
public string FngDesc { get; set; }
- /// <summary>
- /// 妫�楠岀粨鏋�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_RESU")]
+ /// <summary>
+ /// 妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_RESU")]
public string FcheckResu { get; set; }
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "FREVIEW")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FREVIEW")]
public string Freview { get; set; }
- /// <summary>
- /// 妫�楠屾按鍑�
- /// </summary>
- [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
+ /// <summary>
+ /// 妫�楠屾按鍑�
+ /// </summary>
+ [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
public string SampleSizeNo { get; set; }
- /// <summary>
- /// 妫�楠屾按骞�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_LEVEL")]
+ /// <summary>
+ /// 妫�楠屾按骞�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_LEVEL")]
public string FcheckLevel { get; set; }
- /// <summary>
- /// 鎷掓敹姘村钩
- /// </summary>
- [SugarColumn(ColumnName = "FAC_LEVEL")]
+ /// <summary>
+ /// 鎷掓敹姘村钩
+ /// </summary>
+ [SugarColumn(ColumnName = "FAC_LEVEL")]
public string FacLevel { get; set; }
- /// <summary>
- /// 鎶芥鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_QTY")]
+ /// <summary>
+ /// 鎶芥鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QTY")]
public string CheckQty { get; set; }
- /// <summary>
- /// 鎵规鍙� --鍒拌揣鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO")]
+ /// <summary>
+ /// 鎵规鍙� --鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO")]
public string LotNo { get; set; }
- /// <summary>
- /// 鏄惁鎺ㄩ��
- /// </summary>
- [SugarColumn(ColumnName = "FMOVE")]
+ /// <summary>
+ /// 鏄惁鎺ㄩ��
+ /// </summary>
+ [SugarColumn(ColumnName = "FMOVE")]
public string Fmove { get; set; }
- /// <summary>
- /// 鏄惁澶勭悊
- /// </summary>
- [SugarColumn(ColumnName = "FHANDLE")]
+ /// <summary>
+ /// 鏄惁澶勭悊
+ /// </summary>
+ [SugarColumn(ColumnName = "FHANDLE")]
public string Fhandle { 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 = "MODIFY1_FLAG")]
+ /// <summary>
+ /// 鏄惁瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_FLAG")]
public decimal? Modify1Flag { get; set; }
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "MODIFY1_BY")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_BY")]
public string Modify1By { get; set; }
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "MODIFY1_DATE")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_DATE")]
public DateTime? Modify1Date { get; set; }
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
public string Factory { get; set; }
- /// <summary>
- /// XRF娴嬭瘯鎶ュ憡缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_REPNO")]
+ /// <summary>
+ /// XRF娴嬭瘯鎶ュ憡缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_REPNO")]
public string FcheckRepno { get; set; }
- /// <summary>
- /// 绗笁鏂规姤鍛�
- /// </summary>
- [SugarColumn(ColumnName = "FTHIRD_REP")]
+ /// <summary>
+ /// 绗笁鏂规姤鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "FTHIRD_REP")]
public string FthirdRep { get; set; }
- /// <summary>
- /// 鏄惁浣滃簾
- /// </summary>
- [SugarColumn(ColumnName = "FCANCEL")]
+ /// <summary>
+ /// 鏄惁浣滃簾
+ /// </summary>
+ [SugarColumn(ColumnName = "FCANCEL")]
public decimal? Fcancel { get; set; }
- /// <summary>
- /// 鎻愪氦鏍囪瘑
- /// </summary>
- [SugarColumn(ColumnName = "FSUBMIT")]
+ /// <summary>
+ /// 鎻愪氦鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "FSUBMIT")]
public decimal? Fsubmit { get; set; }
- /// <summary>
- /// 妫�楠屼緷鎹�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_ACCORD")]
+ /// <summary>
+ /// 妫�楠屼緷鎹�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ACCORD")]
public string FcheckAccord { get; set; }
- /// <summary>
- /// 绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱)
- /// </summary>
- [SugarColumn(ColumnName = "FTYPE")]
+ /// <summary>
+ /// 绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱)
+ /// </summary>
+ [SugarColumn(ColumnName = "FTYPE")]
public short? Ftype { get; set; }
- /// <summary>
- /// 鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_UNIT")]
+ /// <summary>
+ /// 鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_UNIT")]
public string ItemUnit { get; set; }
- /// <summary>
- /// 鍑鸿揣鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "OUT_DATE")]
+ /// <summary>
+ /// 鍑鸿揣鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "OUT_DATE")]
public string OutDate { get; set; }
- /// <summary>
- /// 鏄惁鍏嶆
- /// </summary>
- [SugarColumn(ColumnName = "FEXEMPTION")]
+ /// <summary>
+ /// 鏄惁鍏嶆
+ /// </summary>
+ [SugarColumn(ColumnName = "FEXEMPTION")]
public decimal? Fexemption { get; set; }
- /// <summary>
- /// 妗ｄ綅鏍囧噯
- /// </summary>
- [SugarColumn(ColumnName = "FGEAR_STAND")]
+ /// <summary>
+ /// 妗ｄ綅鏍囧噯
+ /// </summary>
+ [SugarColumn(ColumnName = "FGEAR_STAND")]
public string FgearStand { get; set; }
- /// <summary>
- /// 涓嶈壇澶勭悊鏂规硶
- /// </summary>
- [SugarColumn(ColumnName = "FNG_HANDLE")]
+ /// <summary>
+ /// 涓嶈壇澶勭悊鏂规硶
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_HANDLE")]
public string FngHandle { get; set; }
- /// <summary>
- /// 绠＄悊缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FMANAGE_NO")]
+ /// <summary>
+ /// 绠＄悊缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "FMANAGE_NO")]
public string FmanageNo { get; set; }
- /// <summary>
- /// 杞崲鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "FCOVERT_QTY")]
+ /// <summary>
+ /// 杞崲鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FCOVERT_QTY")]
public string FcovertQty { get; set; }
- /// <summary>
- /// 鐗堟湰
- /// </summary>
- [SugarColumn(ColumnName = "FVERSION")]
+ /// <summary>
+ /// 鐗堟湰
+ /// </summary>
+ [SugarColumn(ColumnName = "FVERSION")]
public decimal? Fversion { get; set; }
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
public string Company { get; set; }
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "FSECOND_RESU")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FSECOND_RESU")]
public string FsecondResu { get; set; }
- /// <summary>
- /// 鏈�澶ф娊妫�鏁�
- /// </summary>
- [SugarColumn(ColumnName = "MAX_CHECK_QTY")]
+ /// <summary>
+ /// 鏈�澶ф娊妫�鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "MAX_CHECK_QTY")]
public decimal? MaxCheckQty { get; set; }
- /// <summary>
- /// 鐗瑰畾淇敼鏄惁瀹℃牳
- /// </summary>
- [SugarColumn(ColumnName = "MODIFY1_FLAG1")]
+ /// <summary>
+ /// 鐗瑰畾淇敼鏄惁瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_FLAG1")]
public decimal? Modify1Flag1 { get; set; }
- /// <summary>
- /// 鐗瑰畾淇敼瀹℃牳浜�
- /// </summary>
- [SugarColumn(ColumnName = "MODIFY1_BY1")]
+ /// <summary>
+ /// 鐗瑰畾淇敼瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_BY1")]
public string Modify1By1 { get; set; }
- /// <summary>
- /// 鐗瑰畾淇敼瀹℃牳鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "MODIFY1_DATE1")]
+ /// <summary>
+ /// 鐗瑰畾淇敼瀹℃牳鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_DATE1")]
public DateTime? Modify1Date1 { get; set; }
- /// <summary>
- /// 灏忔壒娆″彿
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO1")]
+ /// <summary>
+ /// 灏忔壒娆″彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO1")]
public string LotNo1 { get; set; }
- /// <summary>
- /// 閲囪喘鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO2")]
+ /// <summary>
+ /// 閲囪喘鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO2")]
public string LotNo2 { get; set; }
- /// <summary>
- /// 浜у搧鍨嬪彿
- /// </summary>
- [SugarColumn(ColumnName = "BOARD_STYLE")]
+ /// <summary>
+ /// 浜у搧鍨嬪彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BOARD_STYLE")]
public string BoardStyle { get; set; }
- /// <summary>
- /// 浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
+ /// <summary>
+ /// 浠诲姟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_NO")]
public string WorkNo { get; set; }
- /// <summary>
- /// 鍒拌揣鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "DHA018")]
+ /// <summary>
+ /// 鍒拌揣鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHA018")]
public string Dha018 { get; set; }
- /// <summary>
- /// 琛屽彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB002")]
+ /// <summary>
+ /// 琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB002")]
public decimal? Dhb002 { get; set; }
- /// <summary>
- /// 鍒拌揣鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB001")]
+ /// <summary>
+ /// 鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB001")]
public string Dhb001 { get; set; }
- /// <summary>
- /// 渚涘簲鍟�
- /// </summary>
- [SugarColumn(ColumnName = "LIFNR")]
+ /// <summary>
+ /// 渚涘簲鍟�
+ /// </summary>
+ [SugarColumn(ColumnName = "LIFNR")]
public string Lifnr { get; set; }
- /// <summary>
- /// 閫�鏂欐柟寮�
- /// </summary>
- [SugarColumn(ColumnName = "FMRMODE")]
+ /// <summary>
+ /// 閫�鏂欐柟寮�
+ /// </summary>
+ [SugarColumn(ColumnName = "FMRMODE")]
public string Fmrmode { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesQaItemsDetectDetail5.cs b/MES.Service/Modes/MesQaItemsDetectDetail5.cs
index d6159cc..68ee666 100644
--- a/MES.Service/Modes/MesQaItemsDetectDetail5.cs
+++ b/MES.Service/Modes/MesQaItemsDetectDetail5.cs
@@ -8,167 +8,167 @@
[SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")]
public class MesQaItemsDetectDetail5
{
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
- /// <summary>
- /// 鏍囧噯鍊肩被鍨�
- /// </summary>
- [SugarColumn(ColumnName = "FTEXT_TYPE")]
+ /// <summary>
+ /// 鏍囧噯鍊肩被鍨�
+ /// </summary>
+ [SugarColumn(ColumnName = "FTEXT_TYPE")]
public string FtextType { get; set; }
- /// <summary>
- /// 鏍囧噯鍊�
- /// </summary>
- [SugarColumn(ColumnName = "FSTAND")]
+ /// <summary>
+ /// 鏍囧噯鍊�
+ /// </summary>
+ [SugarColumn(ColumnName = "FSTAND")]
public decimal? Fstand { get; set; }
- /// <summary>
- /// 涓婂叕宸�
- /// </summary>
- [SugarColumn(ColumnName = "FUP_ALLOW")]
+ /// <summary>
+ /// 涓婂叕宸�
+ /// </summary>
+ [SugarColumn(ColumnName = "FUP_ALLOW")]
public string FupAllow { get; set; }
- /// <summary>
- /// 涓嬪叕宸�
- /// </summary>
- [SugarColumn(ColumnName = "FDOWN_ALLOW")]
+ /// <summary>
+ /// 涓嬪叕宸�
+ /// </summary>
+ [SugarColumn(ColumnName = "FDOWN_ALLOW")]
public string FdownAllow { get; set; }
- /// <summary>
- /// 妫�楠屾按鍑�
- /// </summary>
- [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
+ /// <summary>
+ /// 妫�楠屾按鍑�
+ /// </summary>
+ [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
public string SampleSizeNo { get; set; }
- /// <summary>
- /// 妫�楠屾按骞�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_LEVEL")]
+ /// <summary>
+ /// 妫�楠屾按骞�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_LEVEL")]
public string FcheckLevel { get; set; }
- /// <summary>
- /// 鎷掓敹姘村钩
- /// </summary>
- [SugarColumn(ColumnName = "FAC_LEVEL")]
+ /// <summary>
+ /// 鎷掓敹姘村钩
+ /// </summary>
+ [SugarColumn(ColumnName = "FAC_LEVEL")]
public string FacLevel { get; set; }
- /// <summary>
- /// 妫�楠岄」鐩�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_ITEM")]
+ /// <summary>
+ /// 妫�楠岄」鐩�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ITEM")]
public string FcheckItem { get; set; }
- /// <summary>
- /// 瑙勬牸瑕佹眰
- /// </summary>
- [SugarColumn(ColumnName = "FSPEC_REQU")]
+ /// <summary>
+ /// 瑙勬牸瑕佹眰
+ /// </summary>
+ [SugarColumn(ColumnName = "FSPEC_REQU")]
public string FspecRequ { get; set; }
- /// <summary>
- /// 鎶芥鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_QYT")]
+ /// <summary>
+ /// 鎶芥鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QYT")]
public decimal? CheckQyt { get; set; }
- /// <summary>
- /// 妫�楠岀粨鏋�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_RESU")]
+ /// <summary>
+ /// 妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_RESU")]
public string FcheckResu { get; set; }
- /// <summary>
- /// AC鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "FAC_QTY")]
+ /// <summary>
+ /// AC鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FAC_QTY")]
public decimal? FacQty { get; set; }
- /// <summary>
- /// RE鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "FRE_QTY")]
+ /// <summary>
+ /// RE鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FRE_QTY")]
public decimal? FreQty { get; set; }
- /// <summary>
- /// 涓嶅悎鏍兼暟
- /// </summary>
- [SugarColumn(ColumnName = "FNG_QTY")]
+ /// <summary>
+ /// 涓嶅悎鏍兼暟
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_QTY")]
public decimal? FngQty { get; set; }
- /// <summary>
- /// 涓嶈壇鐜�
- /// </summary>
- [SugarColumn(ColumnName = "FNG_RATE")]
+ /// <summary>
+ /// 涓嶈壇鐜�
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_RATE")]
public decimal? FngRate { get; set; }
- /// <summary>
- /// 宸插綍鍏ユ暟閲�
- /// </summary>
- [SugarColumn(ColumnName = "FENTER_QTY")]
+ /// <summary>
+ /// 宸插綍鍏ユ暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "FENTER_QTY")]
public decimal? FenterQty { get; set; }
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "RELEASE_NO")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "RELEASE_NO")]
public string ReleaseNo { get; set; }
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
public string Company { get; set; }
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
public string Factory { get; set; }
- /// <summary>
- /// 妫�楠岄」鐩弿杩�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")]
+ /// <summary>
+ /// 妫�楠岄」鐩弿杩�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")]
public string FcheckItemDesc { get; set; }
- /// <summary>
- /// 宸ュ簭鍙�
- /// </summary>
- [SugarColumn(ColumnName = "PROC_NO")]
+ /// <summary>
+ /// 宸ュ簭鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "PROC_NO")]
public string ProcNo { get; set; }
- /// <summary>
- /// 宸ヤ綔涓績缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")]
+ /// <summary>
+ /// 宸ヤ綔涓績缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")]
public string WorkshopCenterCode { get; set; }
- /// <summary>
- /// 鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "FUNIT")]
+ /// <summary>
+ /// 鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "FUNIT")]
public string Funit { get; set; }
- /// <summary>
- /// 鐗瑰畾淇敼
- /// </summary>
- [SugarColumn(ColumnName = "GIVEN_MODIFY")]
+ /// <summary>
+ /// 鐗瑰畾淇敼
+ /// </summary>
+ [SugarColumn(ColumnName = "GIVEN_MODIFY")]
public short? GivenModify { get; set; }
- /// <summary>
- /// 妫�楠屽伐鍏�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_TOOL")]
+ /// <summary>
+ /// 妫�楠屽伐鍏�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_TOOL")]
public string FcheckTool { 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; }
}
\ No newline at end of file
diff --git a/MES.Service/Modes/MesRfPrnbarcode.cs b/MES.Service/Modes/MesRfPrnbarcode.cs
index ab60c94..042cb57 100644
--- a/MES.Service/Modes/MesRfPrnbarcode.cs
+++ b/MES.Service/Modes/MesRfPrnbarcode.cs
@@ -1,155 +1,154 @@
锘縰sing SqlSugar;
-namespace MES.Service.Modes
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 鎵嬫寔鏉＄爜鎵撳嵃鏆傚瓨琛�
+/// </summary>
+[SugarTable("MES_RF_PRNBARCODE")]
+public class MesRfPrnbarcode
{
/// <summary>
- /// 鎵嬫寔鏉＄爜鎵撳嵃鏆傚瓨琛�
- ///</summary>
- [SugarTable("MES_RF_PRNBARCODE")]
- public class MesRfPrnbarcode
- {
- /// <summary>
- /// ID
- ///</summary>
- [SugarColumn(ColumnName = "ID")]
- public decimal? Id { get; set; }
+ /// ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ID")]
+ public decimal? Id { get; set; }
- /// <summary>
- /// 鎵撳嵃椤哄簭
- ///</summary>
- [SugarColumn(ColumnName = "FORDER")]
- public string? Forder { get; set; }
+ /// <summary>
+ /// 鎵撳嵃椤哄簭
+ /// </summary>
+ [SugarColumn(ColumnName = "FORDER")]
+ public string? Forder { get; set; }
- /// <summary>
- /// 鎵撳嵃浠芥暟
- ///</summary>
- [SugarColumn(ColumnName = "FNO")]
- public string? Fno { get; set; }
+ /// <summary>
+ /// 鎵撳嵃浠芥暟
+ /// </summary>
+ [SugarColumn(ColumnName = "FNO")]
+ public string? Fno { get; set; }
- /// <summary>
- /// 瀛楁1
- ///</summary>
- [SugarColumn(ColumnName = "STRP1")]
- public string? Strp1 { get; set; }
+ /// <summary>
+ /// 瀛楁1
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP1")]
+ public string? Strp1 { get; set; }
- /// <summary>
- /// 瀛楁2
- ///</summary>
- [SugarColumn(ColumnName = "STRP2")]
- public string? Strp2 { get; set; }
+ /// <summary>
+ /// 瀛楁2
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP2")]
+ public string? Strp2 { get; set; }
- /// <summary>
- /// 瀛楁3
- ///</summary>
- [SugarColumn(ColumnName = "STRP3")]
- public string? Strp3 { get; set; }
+ /// <summary>
+ /// 瀛楁3
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP3")]
+ public string? Strp3 { get; set; }
- /// <summary>
- /// 瀛楁4
- ///</summary>
- [SugarColumn(ColumnName = "STRP4")]
- public string? Strp4 { get; set; }
+ /// <summary>
+ /// 瀛楁4
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP4")]
+ public string? Strp4 { get; set; }
- /// <summary>
- /// 瀛楁5
- ///</summary>
- [SugarColumn(ColumnName = "STRP5")]
- public string? Strp5 { get; set; }
+ /// <summary>
+ /// 瀛楁5
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP5")]
+ public string? Strp5 { get; set; }
- /// <summary>
- /// 瀛楁6
- ///</summary>
- [SugarColumn(ColumnName = "STRP6")]
- public string? Strp6 { get; set; }
+ /// <summary>
+ /// 瀛楁6
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP6")]
+ public string? Strp6 { get; set; }
- /// <summary>
- /// 瀛楁7
- ///</summary>
- [SugarColumn(ColumnName = "STRP7")]
- public string? Strp7 { get; set; }
+ /// <summary>
+ /// 瀛楁7
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP7")]
+ public string? Strp7 { get; set; }
- /// <summary>
- /// 瀛楁8
- ///</summary>
- [SugarColumn(ColumnName = "STRP8")]
- public string? Strp8 { get; set; }
+ /// <summary>
+ /// 瀛楁8
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP8")]
+ public string? Strp8 { get; set; }
- /// <summary>
- /// 瀛楁9
- ///</summary>
- [SugarColumn(ColumnName = "STRP9")]
- public string? Strp9 { get; set; }
+ /// <summary>
+ /// 瀛楁9
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP9")]
+ public string? Strp9 { get; set; }
- /// <summary>
- /// 瀛楁10
- ///</summary>
- [SugarColumn(ColumnName = "STRP10")]
- public string? Strp10 { get; set; }
+ /// <summary>
+ /// 瀛楁10
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP10")]
+ public string? Strp10 { get; set; }
- /// <summary>
- /// 瀛楁11
- ///</summary>
- [SugarColumn(ColumnName = "STRP11")]
- public string? Strp11 { get; set; }
+ /// <summary>
+ /// 瀛楁11
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP11")]
+ public string? Strp11 { get; set; }
- /// <summary>
- /// 瀛楁12
- ///</summary>
- [SugarColumn(ColumnName = "STRP12")]
- public string? Strp12 { get; set; }
+ /// <summary>
+ /// 瀛楁12
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP12")]
+ public string? Strp12 { get; set; }
- /// <summary>
- /// 瀛楁13
- ///</summary>
- [SugarColumn(ColumnName = "STRP13")]
- public string? Strp13 { get; set; }
+ /// <summary>
+ /// 瀛楁13
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP13")]
+ public string? Strp13 { get; set; }
- /// <summary>
- /// 瀛楁14
- ///</summary>
- [SugarColumn(ColumnName = "STRP14")]
- public string? Strp14 { get; set; }
+ /// <summary>
+ /// 瀛楁14
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP14")]
+ public string? Strp14 { get; set; }
- /// <summary>
- /// 瀛楁15
- ///</summary>
- [SugarColumn(ColumnName = "STRP15")]
- public string? Strp15 { get; set; }
+ /// <summary>
+ /// 瀛楁15
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP15")]
+ public string? Strp15 { get; set; }
- /// <summary>
- /// 瀛楁16
- ///</summary>
- [SugarColumn(ColumnName = "STRP16")]
- public string? Strp16 { get; set; }
+ /// <summary>
+ /// 瀛楁16
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP16")]
+ public string? Strp16 { get; set; }
- /// <summary>
- /// 瀛楁17
- ///</summary>
- [SugarColumn(ColumnName = "STRP17")]
- public string? Strp17 { get; set; }
+ /// <summary>
+ /// 瀛楁17
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP17")]
+ public string? Strp17 { get; set; }
- /// <summary>
- /// 瀛楁18
- ///</summary>
- [SugarColumn(ColumnName = "STRP18")]
- public string? Strp18 { get; set; }
+ /// <summary>
+ /// 瀛楁18
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP18")]
+ public string? Strp18 { get; set; }
- /// <summary>
- /// 瀛楁19
- ///</summary>
- [SugarColumn(ColumnName = "STRP19")]
- public string? Strp19 { get; set; }
+ /// <summary>
+ /// 瀛楁19
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP19")]
+ public string? Strp19 { get; set; }
- /// <summary>
- /// 瀛楁20
- ///</summary>
- [SugarColumn(ColumnName = "STRP20")]
- public string? Strp20 { get; set; }
+ /// <summary>
+ /// 瀛楁20
+ /// </summary>
+ [SugarColumn(ColumnName = "STRP20")]
+ public string? Strp20 { get; set; }
- /// <summary>
- /// 鐢熸垚鏃堕棿
- ///</summary>
- [SugarColumn(ColumnName = "CREATE_DATE")]
- public DateTime? CreateDate { get; set; }
- }
+ /// <summary>
+ /// 鐢熸垚鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
+ public DateTime? CreateDate { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Modes/Organize.cs b/MES.Service/Modes/Organize.cs
index 50d4342..55205e6 100644
--- a/MES.Service/Modes/Organize.cs
+++ b/MES.Service/Modes/Organize.cs
@@ -8,13 +8,12 @@
public class Organize
{
/// <summary>
- ///
/// </summary>
[SugarColumn(ColumnName = "ID")]
public decimal? Id { get; set; }
/// <summary>
- /// 缁勭粐鑻辨枃
+ /// 缁勭粐鑻辨枃
/// </summary>
[SugarColumn(ColumnName = "FNUMBER")]
public string Fnumber { get; set; }
diff --git a/MES.Service/Modes/Purdhb.cs b/MES.Service/Modes/Purdhb.cs
index 7fff6ee..b8de0cc 100644
--- a/MES.Service/Modes/Purdhb.cs
+++ b/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/MES.Service/Modes/Purdka.cs b/MES.Service/Modes/Purdka.cs
index 1c3ea40..4330c13 100644
--- a/MES.Service/Modes/Purdka.cs
+++ b/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/MES.Service/Modes/QsItemOqcReq.cs b/MES.Service/Modes/QsItemOqcReq.cs
index a934f30..b1fb7b6 100644
--- a/MES.Service/Modes/QsItemOqcReq.cs
+++ b/MES.Service/Modes/QsItemOqcReq.cs
@@ -1,4 +1,3 @@
-using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using SqlSugar;
@@ -20,104 +19,103 @@
public decimal? Id { get; set; }
/// <summary>
- /// 妫�楠屽崟鍙�
- ///</summary>
+ /// 妫�楠屽崟鍙�
+ /// </summary>
[SugarColumn(ColumnName = "RELEASE_NO")]
public string? ReleaseNo { get; set; }
/// <summary>
- /// 妫�楠屾棩鏈�
- ///</summary>
+ /// 妫�楠屾棩鏈�
+ /// </summary>
[SugarColumn(ColumnName = "FCHECK_DATE")]
public DateTime? FcheckDate { get; set; }
/// <summary>
- /// 妫�楠屼汉鍛�
- ///</summary>
+ /// 妫�楠屼汉鍛�
+ /// </summary>
[SugarColumn(ColumnName = "FCHECK_BY")]
public string? FcheckBy { get; set; }
/// <summary>
- /// 鐗╂枡缂栫爜
- ///</summary>
+ /// 鐗╂枡缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "ITEM_NO")]
public string? ItemNo { get; set; }
/// <summary>
- /// 妫�楠岀粨鏋�
- ///</summary>
+ /// 妫�楠岀粨鏋�
+ /// </summary>
[SugarColumn(ColumnName = "FCHECK_RESU")]
public string? FcheckResu { 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 = "MODIFY1_BY")]
public string? Modify1By { get; set; }
/// <summary>
- /// 宸ュ崟鍙�
- ///</summary>
+ /// 宸ュ崟鍙�
+ /// </summary>
[SugarColumn(ColumnName = "BILL_NO")]
public string? BillNo { get; set; }
/// <summary>
- /// 妯″叿鍙�
- ///</summary>
+ /// 妯″叿鍙�
+ /// </summary>
[SugarColumn(ColumnName = "MOID_NUM")]
public string? MoidNum { get; set; }
/// <summary>
- /// 瀹℃牳浜�
- ///</summary>
+ /// 瀹℃牳浜�
+ /// </summary>
[SugarColumn(ColumnName = "FSUBMIT_BY")]
public string? FsubmitBy { get; set; }
/// <summary>
- /// 瀹℃牳鏃堕棿
- ///</summary>
+ /// 瀹℃牳鏃堕棿
+ /// </summary>
[SugarColumn(ColumnName = "FSUBMIT_DATE")]
public DateTime? FsubmitDate { get; set; }
/// <summary>
- /// 瀹℃牳鐘舵��
- ///</summary>
+ /// 瀹℃牳鐘舵��
+ /// </summary>
[SugarColumn(ColumnName = "FSUBMIT")]
public decimal? Fsubmit { get; set; }
/// <summary>
- /// 澶囨敞
- ///</summary>
+ /// 澶囨敞
+ /// </summary>
[SugarColumn(ColumnName = "REMARKS")]
public string? Remarks { get; set; }
/// <summary>
- /// 鐗╂枡ID
- ///</summary>
+ /// 鐗╂枡ID
+ /// </summary>
[SugarColumn(ColumnName = "ITEM_ID")]
public decimal? ItemId { get; set; }
diff --git a/MES.Service/Modes/QsQaItemXj.cs b/MES.Service/Modes/QsQaItemXj.cs
index 77e2cc6..28c435a 100644
--- a/MES.Service/Modes/QsQaItemXj.cs
+++ b/MES.Service/Modes/QsQaItemXj.cs
@@ -21,117 +21,113 @@
public decimal? Id { get; set; }
/// <summary>
- /// 妫�楠屽崟鍙�
- ///</summary>
+ /// 妫�楠屽崟鍙�
+ /// </summary>
[SugarColumn(ColumnName = "RELEASE_NO")]
public string? ReleaseNo { get; set; }
/// <summary>
- /// 妫�楠屾棩鏈�
- ///</summary>
+ /// 妫�楠屾棩鏈�
+ /// </summary>
[SugarColumn(ColumnName = "FCHECK_DATE")]
public DateTime? FcheckDate { get; set; }
/// <summary>
- /// 妫�楠屼汉鍛�
- ///</summary>
+ /// 妫�楠屼汉鍛�
+ /// </summary>
[SugarColumn(ColumnName = "FCHECK_BY")]
public string? FcheckBy { get; set; }
/// <summary>
- /// 鐗╂枡缂栫爜
- ///</summary>
+ /// 鐗╂枡缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "ITEM_NO")]
public string? ItemNo { get; set; }
/// <summary>
- /// 妫�楠岀粨鏋�
- ///</summary>
+ /// 妫�楠岀粨鏋�
+ /// </summary>
[SugarColumn(ColumnName = "FCHECK_RESU")]
public string? FcheckResu { 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 = "MODIFY1_BY")]
public string? Modify1By { get; set; }
/// <summary>
- /// 鍗曚綅
- ///</summary>
+ /// 鍗曚綅
+ /// </summary>
[SugarColumn(ColumnName = "ITEM_UNIT")]
public string? ItemUnit { get; set; }
/// <summary>
- /// 宸ュ崟鍙�
- ///</summary>
+ /// 宸ュ崟鍙�
+ /// </summary>
[SugarColumn(ColumnName = "BILL_NO")]
public string? BillNo { get; set; }
/// <summary>
- /// 妯″叿鍙�
- ///</summary>
+ /// 妯″叿鍙�
+ /// </summary>
[SugarColumn(ColumnName = "MOID_NUM")]
public string? MoidNum { get; set; }
/// <summary>
- ///
- ///</summary>
+ /// </summary>
[SugarColumn(ColumnName = "FSUBMIT_BY")]
public string? FsubmitBy { get; set; }
/// <summary>
- ///
- ///</summary>
+ /// </summary>
[SugarColumn(ColumnName = "FSUBMIT_DATE")]
public DateTime? FsubmitDate { get; set; }
/// <summary>
- ///
- ///</summary>
+ /// </summary>
[SugarColumn(ColumnName = "FSUBMIT")]
public decimal? Fsubmit { get; set; }
/// <summary>
- /// 澶囨敞
- ///</summary>
+ /// 澶囨敞
+ /// </summary>
[SugarColumn(ColumnName = "REMARKS")]
public string? Remarks { get; set; }
/// <summary>
- /// 鐗╂枡ID
- ///</summary>
+ /// 鐗╂枡ID
+ /// </summary>
[SugarColumn(ColumnName = "ITEM_ID")]
public decimal? ItemId { get; set; }
[SugarColumn(IsIgnore = true)] public string? Daa020 { get; set; }
[SugarColumn(IsIgnore = true)] public decimal? PlanQty { get; set; }
-
+
[SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
-
+
[SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
}
\ No newline at end of file
diff --git a/MES.Service/Modes/Womdab.cs b/MES.Service/Modes/Womdab.cs
index 80c6344..aed9181 100644
--- a/MES.Service/Modes/Womdab.cs
+++ b/MES.Service/Modes/Womdab.cs
@@ -1,124 +1,147 @@
-锘縰sing System;
-using System.Collections.Generic;
-using System.Linq;
-using SqlSugar;
-namespace MES.Service.Modes
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 宸ュ崟瀛愯〃
+/// </summary>
+[SugarTable("WOMDAB")]
+public class Womdab
{
/// <summary>
- /// 宸ュ崟瀛愯〃
- ///</summary>
- [SugarTable("WOMDAB")]
- public class Womdab
- {
- /// <summary>
- /// 鑷鍒�
- ///</summary>
- [SugarColumn(ColumnName="ID" )]
- public decimal? Id { get; set; }
- /// <summary>
- /// PID
- ///</summary>
- [SugarColumn(ColumnName="PID" )]
- public decimal? Pid { get; set; }
- /// <summary>
- /// 宸ュ崟鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName="DAB001" )]
- public string Dab001 { get; set; }
- /// <summary>
- /// 搴忓彿
- ///</summary>
- [SugarColumn(ColumnName="DAB002" )]
- public string Dab002 { get; set; }
- /// <summary>
- /// 鏉愭枡缂栫爜
- ///</summary>
- [SugarColumn(ColumnName="DAB003" )]
- public string Dab003 { get; set; }
- /// <summary>
- /// 鏉愭枡鍚嶇О
- ///</summary>
- [SugarColumn(ColumnName="DAB004" )]
- public string Dab004 { get; set; }
- /// <summary>
- /// 鏉愭枡瑙勬牸
- ///</summary>
- [SugarColumn(ColumnName="DAB005" )]
- public string Dab005 { get; set; }
- /// <summary>
- /// 闇�棰嗙敤閲�
- ///</summary>
- [SugarColumn(ColumnName="DAB006" )]
- public decimal? Dab006 { get; set; }
- /// <summary>
- /// 宸查鐢ㄩ噺
- ///</summary>
- [SugarColumn(ColumnName="DAB007" )]
- public decimal? Dab007 { get; set; }
- /// <summary>
- /// 宸ヨ壓
- ///</summary>
- [SugarColumn(ColumnName="DAB008" )]
- public string Dab008 { get; set; }
- /// <summary>
- /// 鍗曚綅
- ///</summary>
- [SugarColumn(ColumnName="DAB009" )]
- public string Dab009 { get; set; }
- /// <summary>
- /// 鏉愭枡绫诲瀷
- ///</summary>
- [SugarColumn(ColumnName="DAB010" )]
- public string Dab010 { get; set; }
- /// <summary>
- /// 涓绘枡
- ///</summary>
- [SugarColumn(ColumnName="DAB011" )]
- public string Dab011 { get; set; }
- /// <summary>
- /// 缁勬垚鐢ㄩ噺
- ///</summary>
- [SugarColumn(ColumnName="DAB012" )]
- public decimal? Dab012 { get; set; }
- /// <summary>
- /// 搴曟暟
- ///</summary>
- [SugarColumn(ColumnName="DAB013" )]
- public decimal? Dab013 { get; set; }
- /// <summary>
- /// 鏄惁鏇挎枡
- ///</summary>
- [SugarColumn(ColumnName="DAB014" )]
- public string Dab014 { get; set; }
- /// <summary>
- /// 鐐逛綅
- ///</summary>
- [SugarColumn(ColumnName="DAB015" )]
- public string Dab015 { get; set; }
- /// <summary>
- /// 鎶曟枡鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName="DAB016" )]
- public string Dab016 { get; set; }
- /// <summary>
- /// 浠撳簱缂栫爜
- ///</summary>
- [SugarColumn(ColumnName="DAB017" )]
- public string Dab017 { get; set; }
- /// <summary>
- /// 浠撳簱鍚嶇О
- ///</summary>
- [SugarColumn(ColumnName="DAB018" )]
- public string Dab018 { get; set; }
- /// <summary>
- /// 棰嗘枡鏂瑰紡
- ///</summary>
- [SugarColumn(ColumnName="DAB019" )]
- public string Dab019 { get; set; }
- /// <summary>
- /// 鍥哄畾鎹熻��
- ///</summary>
- [SugarColumn(ColumnName="SCRAPQTY" )]
- public decimal? Scrapqty { get; set; }
- }
-}
+ /// 鑷鍒�
+ /// </summary>
+ [SugarColumn(ColumnName = "ID")]
+ public decimal? Id { get; set; }
+
+ /// <summary>
+ /// PID
+ /// </summary>
+ [SugarColumn(ColumnName = "PID")]
+ public decimal? Pid { get; set; }
+
+ /// <summary>
+ /// 宸ュ崟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB001")]
+ public string Dab001 { get; set; }
+
+ /// <summary>
+ /// 搴忓彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB002")]
+ public string Dab002 { get; set; }
+
+ /// <summary>
+ /// 鏉愭枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB003")]
+ public string Dab003 { get; set; }
+
+ /// <summary>
+ /// 鏉愭枡鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB004")]
+ public string Dab004 { get; set; }
+
+ /// <summary>
+ /// 鏉愭枡瑙勬牸
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB005")]
+ public string Dab005 { get; set; }
+
+ /// <summary>
+ /// 闇�棰嗙敤閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB006")]
+ public decimal? Dab006 { get; set; }
+
+ /// <summary>
+ /// 宸查鐢ㄩ噺
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB007")]
+ public decimal? Dab007 { get; set; }
+
+ /// <summary>
+ /// 宸ヨ壓
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB008")]
+ public string Dab008 { get; set; }
+
+ /// <summary>
+ /// 鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB009")]
+ public string Dab009 { get; set; }
+
+ /// <summary>
+ /// 鏉愭枡绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB010")]
+ public string Dab010 { get; set; }
+
+ /// <summary>
+ /// 涓绘枡
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB011")]
+ public string Dab011 { get; set; }
+
+ /// <summary>
+ /// 缁勬垚鐢ㄩ噺
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB012")]
+ public decimal? Dab012 { get; set; }
+
+ /// <summary>
+ /// 搴曟暟
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB013")]
+ public decimal? Dab013 { get; set; }
+
+ /// <summary>
+ /// 鏄惁鏇挎枡
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB014")]
+ public string Dab014 { get; set; }
+
+ /// <summary>
+ /// 鐐逛綅
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB015")]
+ public string Dab015 { get; set; }
+
+ /// <summary>
+ /// 鎶曟枡鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB016")]
+ public string Dab016 { get; set; }
+
+ /// <summary>
+ /// 浠撳簱缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB017")]
+ public string Dab017 { get; set; }
+
+ /// <summary>
+ /// 浠撳簱鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB018")]
+ public string Dab018 { get; set; }
+
+ /// <summary>
+ /// 棰嗘枡鏂瑰紡
+ /// </summary>
+ [SugarColumn(ColumnName = "DAB019")]
+ public string Dab019 { get; set; }
+
+ /// <summary>
+ /// 鍥哄畾鎹熻��
+ /// </summary>
+ [SugarColumn(ColumnName = "SCRAPQTY")]
+ public decimal? Scrapqty { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_ID")]
+ public decimal? ErpId { get; set; }
+}
\ No newline at end of file
diff --git a/MES.Service/bin/Debug/net8.0/MES.Service.dll b/MES.Service/bin/Debug/net8.0/MES.Service.dll
index 30d58f8..a444cd4 100644
--- a/MES.Service/bin/Debug/net8.0/MES.Service.dll
+++ b/MES.Service/bin/Debug/net8.0/MES.Service.dll
Binary files differ
diff --git a/MES.Service/bin/Debug/net8.0/MES.Service.pdb b/MES.Service/bin/Debug/net8.0/MES.Service.pdb
index cce69d3..4151104 100644
--- a/MES.Service/bin/Debug/net8.0/MES.Service.pdb
+++ b/MES.Service/bin/Debug/net8.0/MES.Service.pdb
Binary files differ
diff --git a/MES.Service/service/QC/XJService.cs b/MES.Service/service/QC/XJService.cs
index 01603a2..9ed2beb 100644
--- a/MES.Service/service/QC/XJService.cs
+++ b/MES.Service/service/QC/XJService.cs
@@ -102,7 +102,7 @@
Id = b.Id,
ItemNo = b.ItemNo,
ItemName = b.ItemName,
- ItemModel = b.ItemModel,
+ ItemModel = b.ItemModel
}).ToList();
}
diff --git a/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs b/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
index 0aab9dd..73d3732 100644
--- a/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
+++ b/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
@@ -28,7 +28,8 @@
c.ItemNo == t.ItemNo && c.Company == t.Company &&
c.Factory == t.Factory,
JoinType.Left,
- t.Fpurchaseunitid == u.Id.ToString() && t.Factory == u.Factory &&
+ t.Fpurchaseunitid == u.Id.ToString() &&
+ t.Factory == u.Factory &&
t.Company == u.Company
})
.Where((c, t, u) => c.Mid == query.id)
diff --git a/MES.Service/service/Warehouse/MesInvItemOutCDetailsManager.cs b/MES.Service/service/Warehouse/MesInvItemOutCDetailsManager.cs
index 8015c77..6425341 100644
--- a/MES.Service/service/Warehouse/MesInvItemOutCDetailsManager.cs
+++ b/MES.Service/service/Warehouse/MesInvItemOutCDetailsManager.cs
@@ -81,46 +81,36 @@
public MesInvItemOutCDetails GetOutList(WarehouseQuery query)
{
-
-
-
var mesInvItemBarcodes = Db.Queryable<MesInvItemBarcodes>()
.Where(s => s.ItemBarcode == query.barcode).Count();
- if (mesInvItemBarcodes <= 0)
- {
- throw new Exception("鏉＄爜涓嶅瓨鍦�");
- }
+ if (mesInvItemBarcodes <= 0) throw new Exception("鏉＄爜涓嶅瓨鍦�");
var mesInvItemOutCDetails = Db.Queryable<MesInvItemOutCDetails>()
- .Where(s => s.ItemBarcode == query.barcode && s.Receive == 0).Count();
+ .Where(s => s.ItemBarcode == query.barcode && s.Receive == 0)
+ .Count();
-
- if (mesInvItemOutCDetails <= 0)
- {
- throw new Exception("鏉＄爜涓嶇鍚堟帴鏀舵潯浠�,璇锋鏌ワ紒");
- }
+ if (mesInvItemOutCDetails <= 0) throw new Exception("鏉＄爜涓嶇鍚堟帴鏀舵潯浠�,璇锋鏌ワ紒");
-
- var entity = Db.Queryable<MesInvItemOutCDetails, MesInvItemOuts, MesItems>((a, b, c) =>
- new JoinQueryInfos(JoinType.Left, a.ItemOutId == b.Id,
- JoinType.Left, a.ItemNo == c.ItemNo))
- .Where((a, b, c) => a.ItemBarcode == query.barcode)
- .Select((a, b, c) => new MesInvItemOutCDetails
- {
- PbillNo = b.ItemOutNo,
- WorkNo = a.WorkNo,
- ItemNo = a.ItemNo,
- ItemName = c.ItemName,
- Quantity = a.Quantity
- }).First();
+ var entity = Db
+ .Queryable<MesInvItemOutCDetails, MesInvItemOuts, MesItems>(
+ (a, b, c) =>
+ new JoinQueryInfos(JoinType.Left, a.ItemOutId == b.Id,
+ JoinType.Left, a.ItemNo == c.ItemNo))
+ .Where((a, b, c) => a.ItemBarcode == query.barcode)
+ .Select((a, b, c) => new MesInvItemOutCDetails
+ {
+ PbillNo = b.ItemOutNo,
+ WorkNo = a.WorkNo,
+ ItemNo = a.ItemNo,
+ ItemName = c.ItemName,
+ Quantity = a.Quantity
+ }).First();
if (entity == null)
- {
throw new Exception("鍑哄簱鏉＄爜" + query.barcode + " 涓嶅瓨鍦紝璇风‘璁�!");
- }
return entity;
@@ -132,19 +122,16 @@
var mesInvItemBarcodes = Db.Queryable<MesInvItemBarcodes>()
.Where(s => s.ItemBarcode == query.barcode).Count();
- if (mesInvItemBarcodes <= 0)
- {
- throw new Exception("鏉＄爜涓嶅瓨鍦�");
- }
+ if (mesInvItemBarcodes <= 0) throw new Exception("鏉＄爜涓嶅瓨鍦�");
var mesInvItemOutCDetails = Db.Queryable<MesInvItemOutCDetails>()
.Where(s => s.ItemBarcode == query.barcode).First();
- MaterialReceipt entity = new MaterialReceipt
+ var entity = new MaterialReceipt
{
- InvItemoutCDetails = GetMesInvItemOutCDetails(mesInvItemOutCDetails.PbillNo),
+ InvItemoutCDetails =
+ GetMesInvItemOutCDetails(mesInvItemOutCDetails.PbillNo),
ItemOuts = GetMesInvItemOuts(mesInvItemOutCDetails.PbillNo)
-
};
return entity;
@@ -154,40 +141,30 @@
public MesInvItemOutCDetails confirmReceipt(WarehouseQuery query)
{
if (string.IsNullOrWhiteSpace(query.barcode))
- {
throw new Exception("璇锋壂鍑哄簱鏉＄爜锛�");
- }
if (string.IsNullOrWhiteSpace(query.billNo))
- {
throw new Exception("鍑哄簱鍗曟嵁涓嶈兘涓虹┖锛�");
- }
-
-
var barcodeInfo = GetBarcodeInfo(query.barcode);
- if (barcodeInfo.Receive == 1)
- {
- throw new Exception("姝ゆ潯鐮佸凡缁忔帴鏀�,璇锋鏌ワ紒");
- }
+ if (barcodeInfo.Receive == 1) throw new Exception("姝ゆ潯鐮佸凡缁忔帴鏀�,璇锋鏌ワ紒");
UseTransaction(db =>
{
-
var count = db.Updateable<MesInvItemOutCDetails>()
- .SetColumns(s => s.Receive == 1)
- .Where(s => s.ItemBarcode == barcodeInfo.ItemBarcode).ExecuteCommand();
+ .SetColumns(s => s.Receive == 1)
+ .Where(s => s.ItemBarcode == barcodeInfo.ItemBarcode)
+ .ExecuteCommand();
return 1;
});
return barcodeInfo;
}
-
public List<MesInvItemOutCDetails> GetMesInvItemOutCDetails(string billno)
@@ -203,12 +180,10 @@
}
-
private MesInvItemOutCDetails GetBarcodeInfo(string itemBarcode)
{
// Get barcode information
return Db.Queryable<MesInvItemOutCDetails>()
.First(b => b.ItemBarcode == itemBarcode);
}
-
}
\ No newline at end of file
diff --git a/MES.Service/service/Warehouse/MesInvItemOutsManager.cs b/MES.Service/service/Warehouse/MesInvItemOutsManager.cs
index 08b04e2..34788f7 100644
--- a/MES.Service/service/Warehouse/MesInvItemOutsManager.cs
+++ b/MES.Service/service/Warehouse/MesInvItemOutsManager.cs
@@ -3,6 +3,7 @@
using MES.Service.Dto.service;
using MES.Service.Modes;
using MES.Service.util;
+using Newtonsoft.Json;
using SqlSugar;
using DbType = System.Data.DbType;
@@ -12,6 +13,114 @@
{
//褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
//杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesInvItemOutsManager.cs
+
+ public List<MesInvItemOuts> GetProductionPickPage(WarehouseQuery query)
+ {
+ return Db.Queryable<MesInvItemOuts, MesDepots>((a, o) =>
+ new JoinQueryInfos(
+ JoinType.Left,
+ o.DepotCode == a.DepotCode && a.Company == o.Company &&
+ a.Factory == o.Factory
+ ))
+ .Where((a, o) => a.BillTypeId == 200 &&
+ a.TransactionNo == 201 &&
+ a.Factory == "1000" &&
+ a.Company == "1000" &&
+ a.IsVisual == 1)
+ .WhereIF(query.status != null, (a, o) => a.Status == query.status)
+ .WhereIF(query.id != null, (a, o) => a.Id == query.id)
+ .Select((a, o) => new MesInvItemOuts
+ {
+ Id = a.Id,
+ Sapstatus = a.Sapstatus,
+ OutDate = a.OutDate,
+ CheckDate = a.CheckDate,
+ BoardItem = a.BoardItem,
+ WorkNo = a.WorkNo,
+ OutPart = a.OutPart,
+ PbillNo = a.PbillNo,
+ OutType = a.OutType,
+ CreateBy = a.CreateBy,
+ Status = a.Status,
+ CheckUser = a.CheckUser,
+ ItemOutNo = a.ItemOutNo,
+ DepotName = o.DepotName // 闇�瑕佸姩鎬佹坊鍔犵殑瀛楁
+ })
+ .ToPageList(query.PageIndex, query.Limit);
+ }
+
+ public MaterialReceipt GetProductionPick(WarehouseQuery query)
+ {
+ var form = new MaterialReceipt();
+ if (query.id != null)
+ {
+ var mesInvItemOutsList = GetProductionPickPage(query);
+ if (mesInvItemOutsList.Count <= 0) return form;
+
+ form.ItemOuts = mesInvItemOutsList[0];
+ form.ItemsList = getProductionItemsList(query);
+ form.InvItemoutCDetails = GetProductionDetails(query);
+ }
+
+ return form;
+ }
+
+ private List<MesInvItemOutItems> getProductionItemsList(
+ WarehouseQuery query)
+ {
+ return Db.Queryable<MesInvItemOutItems, MesItems, MesDepTaskInfo>(
+ (c, s, f) => new JoinQueryInfos(
+ JoinType.Inner, c.ItemNo == s.ItemNo,
+ JoinType.Left, f.TaskNo == c.TaskNo && f.ItemNo == c.ItemNo
+ ))
+ .Where((c, s, f) => c.ItemOutId == query.id)
+ .OrderBy(c => c.Id)
+ .Select((c, s, f) => new MesInvItemOutItems
+ {
+ Id = c.Id,
+ ItemNo = c.ItemNo,
+ Quantity = c.Quantity,
+ TaskNo = c.TaskNo,
+ Remark = c.Remark,
+ ItemName = s.ItemName, // 鍔ㄦ�佸瓧娈�
+ ItemModel = s.ItemModel, // 鍔ㄦ�佸瓧娈�
+ ItemUnit = SqlFunc.Subqueryable<MesItems>()
+ .Where(si => si.ItemUnit == s.ItemUnit)
+ .Select(si =>
+ SqlFunc.MappingColumn<string>(
+ "F_GETUNITNAME(si.Item_Unit)")) // 鍔ㄦ�佸瓧娈�
+ })
+ .ToList();
+ }
+
+ private List<MesInvItemOutCDetails> GetProductionDetails(
+ WarehouseQuery query)
+ {
+ return Db
+ .Queryable<MesInvItemOutCDetails, MesItems, MesDepots>(
+ (b, c, d) => new JoinQueryInfos(
+ JoinType.Left,
+ b.ItemNo == c.ItemNo && b.Company == c.Company &&
+ b.Factory == c.Factory,
+ JoinType.Left,
+ d.DepotCode == b.DepotCode && b.Company == d.Company &&
+ b.Factory == d.Factory
+ ))
+ .Where((b, c, d) => b.ItemOutId == query.id)
+ .Select((b, c, d) => new MesInvItemOutCDetails
+ {
+ ForceOutFlag = b.ForceOutFlag,
+ DepotSectionCode = b.DepotSectionCode,
+ ItemNo = b.ItemNo,
+ Quantity = b.Quantity,
+ ItemBarcode = b.ItemBarcode,
+ ItemName = c.ItemName,
+ ItemModel = c.ItemModel,
+ DepotName = d.DepotName,
+ DepotCode = b.DepotCode
+ })
+ .ToList();
+ }
public bool ScanCode(WarehouseQuery query)
{
@@ -703,4 +812,157 @@
return ItemOutNos;
}
+ //鐢熶骇棰嗘枡鍗曞鏍稿墠鏍￠獙
+
+
+ public MessageCenter SaveProductionMessageCenter(WarehouseQuery entity)
+ {
+ var message = ProductionMesToErpParam(entity);
+
+ var executeReturnIdentity =
+ Db.Insertable(message).ExecuteReturnIdentity();
+ if (executeReturnIdentity > 0)
+ {
+ message.Id = executeReturnIdentity;
+ message.Pid = executeReturnIdentity;
+ return message;
+ }
+
+ throw new Exception("鑾峰彇鏁版嵁澶辫触");
+ }
+
+ private MessageCenter ProductionMesToErpParam(WarehouseQuery query)
+ {
+ var erpParameters = "";
+ var title = "";
+ var tableName = "INV_ITEM_OUTS_" + query.Type;
+ if ("A".Equals(query.Type))
+ {
+ erpParameters =
+ GetProductionErpParameters(query.billNo, query.userName);
+ title = "鐢熶骇棰嗘枡鍗�" + query.billNo + "瀹℃牳";
+ }
+
+ var ErpUrl = AppsettingsUtility.Settings.ProductionErpUrl;
+ var message = new MessageCenter
+ {
+ TableName = tableName,
+ Url = ErpUrl,
+ Status = 1,
+ CreateBy = query.userName,
+ Route = query.billNo,
+ Title = title,
+ PageName = "Warehouse/ProductionPick/Add?id=" + query.id +
+ "&itemOutNo=" + query.billNo,
+ CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
+ Method = "POST",
+ Seq = 1,
+ Data = erpParameters,
+ IsMessage = 0,
+ ContentType = "application/x-www-form-urlencoded"
+ };
+ return message;
+ }
+
+ private string GetProductionErpParameters(string? queryBillNo,
+ string? userName)
+ {
+ userName ??= "system";
+ var mesInvItemOuts = Db.Queryable<MesInvItemOuts>()
+ .Where(it => it.ItemOutNo == queryBillNo)
+ .First();
+
+ if (mesInvItemOuts == null) throw new Exception("棰嗘枡鍗曞彿涓嶅瓨鍦�");
+
+ var womcaa = Db.Queryable<Womcaa>()
+ .Where(it => it.Caa020 == mesInvItemOuts.WorkNo)
+ .First();
+
+ if (womcaa == null) throw new Exception("浠诲姟鍗曞彿涓嶅瓨鍦�");
+
+ var Departmentcode = Db.Queryable<SysDepartment, MesInvItemOuts>(
+ (a, b) =>
+ new JoinQueryInfos(JoinType.Left,
+ a.Departmentname == b.OutPart
+ )).Where((a, b) =>
+ b.OutPart == mesInvItemOuts.OutPart &&
+ b.ItemOutNo == queryBillNo).Select(a => a.Departmentcode)
+ .First();
+
+ if (string.IsNullOrEmpty(Departmentcode))
+ throw new Exception("閮ㄩ棬淇℃伅涓嶅瓨鍦�");
+
+ // 妫�鏌ラ鏂欏崟鐘舵��
+ if (mesInvItemOuts.Status == 1) throw new Exception("棰嗘枡鍗曞凡瀹℃牳锛屼笉鑳介噸澶嶆帹閫�");
+
+ var C_OUT_ITEMS = Db
+ .Queryable<MesInvItemOutItems, Womdab, Womdaa, Womcaa, Womcab>(
+ (c, b, d, e, f) =>
+ new JoinQueryInfos(
+ JoinType.Left, b.Id == c.ItemDabid,
+ JoinType.Left, d.Id == b.Pid,
+ JoinType.Left, e.Caa001 == d.Daa021,
+ JoinType.Left, f.Eid == e.Erpid
+ ))
+ .Where((c, b, d, e, f) => c.ItemOutId == mesInvItemOuts.Id)
+ .Select((c, b, d, e, f) => new
+ {
+ c.Id,
+ c.ItemNo,
+ c.Quantity,
+ c.DepotCode,
+ c.DepotSectionCode,
+ c.ItemId,
+ erpId = b.ErpId,
+ e.Caa015,
+ f.PositionNo
+ }).ToList();
+
+ var scllentryList = new List<dynamic>();
+
+ foreach (var item in C_OUT_ITEMS)
+ {
+ var sql =
+ "SELECT FNAME FROM MES_UNIT WHERE ID = (SELECT ITEM_UNIT FROM MES_ITEMS WHERE ID = '" +
+ item.ItemId + "')";
+ var C_ITEM_UNIT = Db.Ado.SqlQuerySingle<string>(sql);
+
+ scllentryList.Add(new
+ {
+ FMaterialId = item.ItemNo,
+ FUnitID = C_ITEM_UNIT,
+ FAppQty = item.Quantity,
+ FActualQty = item.Quantity,
+ FStockId = item.DepotCode,
+ FPPBomEntryId = item.erpId,
+ F_UNW_Text_xsddh = item.Caa015,
+ F_UNW_TEXT_WZH = item.PositionNo,
+ F_MES_ENTRYID = item.Id
+ });
+ }
+
+ var dataJson = new
+ {
+ F_MES_ID = mesInvItemOuts.Id,
+ FDate = mesInvItemOuts.CreateBy,
+ FPickerId = userName,
+ F_UNW_LargeText_BZ = " ",
+ F_UNW_KH = " ",
+ F_UNW_DDSL = womcaa.Caa012,
+ F_UNW_Text_CZG = userName,
+ scllentry = scllentryList
+ };
+
+ return "taskname=SCLL&mesid=" + mesInvItemOuts.Id +
+ "&optype=create&datajson=" +
+ JsonConvert.SerializeObject(
+ dataJson);
+ }
+
+ public bool AuditProduction(WarehouseQuery query)
+ {
+ query.status = 1;
+ //瀹℃牳
+ return Update(query);
+ }
}
\ No newline at end of file
diff --git a/MES.Service/service/Warehouse/OrganizeService.cs b/MES.Service/service/Warehouse/OrganizeService.cs
index 1599197..8929dd2 100644
--- a/MES.Service/service/Warehouse/OrganizeService.cs
+++ b/MES.Service/service/Warehouse/OrganizeService.cs
@@ -1,4 +1,5 @@
锘縰sing System.Data;
+using System.Dynamic;
using MES.Service.DB;
using MES.Service.Dto.service;
using MES.Service.Modes;
@@ -28,10 +29,7 @@
var printCommandResult = Db.Queryable<MesBarcodeType>()
.Where(t => t.TypeCode == 108)
.First();
- if (printCommandResult == null)
- {
- throw new Exception("妯＄増ID涓虹┖锛岃璁剧疆鎵撳嵃鏍煎紡锛�");
- }
+ if (printCommandResult == null) throw new Exception("妯＄増ID涓虹┖锛岃璁剧疆鎵撳嵃鏍煎紡锛�");
var cPrintCommand = printCommandResult.Mbtype;
var cBid = printCommandResult.Id;
@@ -41,40 +39,21 @@
s.ItemNo == query.ItemNo && s.Factory == "1000" &&
s.Company == "1000")
.First();
- if (cMesItems == null)
- {
- throw new Exception("鐗╂枡淇℃伅涓嶅瓨鍦ㄨ鐗╂枡缂栫爜锛岃缁存姢锛�");
- }
+ if (cMesItems == null) throw new Exception("鐗╂枡淇℃伅涓嶅瓨鍦ㄨ鐗╂枡缂栫爜锛岃缁存姢锛�");
- if (string.IsNullOrEmpty(query.ItemNo))
- {
- throw new Exception("璇峰綍鍏ョ墿鏂欑紪鐮�");
- }
+ if (string.IsNullOrEmpty(query.ItemNo)) throw new Exception("璇峰綍鍏ョ墿鏂欑紪鐮�");
if (string.IsNullOrEmpty(query.ItemModel))
- {
throw new Exception("璇疯緭鍏ュ畬鐗╂枡缂栫爜鍚庯紝鐐瑰嚮纭鐢熸垚瑙勬牸锛�");
- }
- if (string.IsNullOrEmpty(query.OrgName))
- {
- throw new Exception("璇峰綍鍏ョ粍缁�");
- }
+ if (string.IsNullOrEmpty(query.OrgName)) throw new Exception("璇峰綍鍏ョ粍缁�");
- if (string.IsNullOrEmpty(query.OrgOwner))
- {
- throw new Exception("璇峰綍鍏ヨ揣涓�");
- }
+ if (string.IsNullOrEmpty(query.OrgOwner)) throw new Exception("璇峰綍鍏ヨ揣涓�");
- if (string.IsNullOrEmpty(query.ItemNum))
- {
- throw new Exception("璇峰綍鍏ョ墿鏂欐暟閲�");
- }
+ if (string.IsNullOrEmpty(query.ItemNum)) throw new Exception("璇峰綍鍏ョ墿鏂欐暟閲�");
if (string.IsNullOrEmpty(query.Printnumn))
- {
throw new Exception("璇峰綍鍏ユ潯鐮佹暟閲�");
- }
var cId =
Db.Ado.GetInt(
@@ -89,7 +68,7 @@
.Where(it => it.CreateDate < DateTime.Now.AddDays(-10))
.ExecuteCommand();
- for (int i = 1; i <= int.Parse(query.Printnumn); i++)
+ for (var i = 1; i <= int.Parse(query.Printnumn); i++)
{
var cIndate = DateTime.Now.ToString("yyyyMMdd");
@@ -104,19 +83,12 @@
query.ItemNo + cIndate, query.ItemNo + cIndate, 0);
serial = barcodeResult.Value;
poBarcodeComand = barcodeResult.Msg;
- if (!string.IsNullOrEmpty(poBarcodeComand))
- {
- return null;
- }
+ if (!string.IsNullOrEmpty(poBarcodeComand)) return null;
if (string.IsNullOrEmpty(serial))
- {
cBarcode2 = "9";
- }
else
- {
cBarcode2 = "9" + serial[1..];
- }
itemBarcode = query.ItemNo + cIndate + cBarcode2;
}
else
@@ -135,10 +107,7 @@
query.ItemNo + cIndate, query.ItemNo + cIndate, 0);
serial = barcodeResult.Value;
poBarcodeComand = barcodeResult.Msg;
- if (!string.IsNullOrEmpty(poBarcodeComand))
- {
- return null;
- }
+ if (!string.IsNullOrEmpty(poBarcodeComand)) return null;
cBarcode2 = "9" + serial.Substring(1);
itemBarcode = query.ItemNo + cIndate +
@@ -155,7 +124,6 @@
s.Company == "1000")
.Count();
if (cCount == 0)
- {
// Insert new barcode
Db.Insertable(new MesInvItemBarcodes
{
@@ -174,7 +142,6 @@
OrgName = query.OrgName,
OrgOwner = query.OrgOwner
}).ExecuteCommand();
- }
// Insert record into MES_RF_PRNBARCODE
Db.Insertable(new MesRfPrnbarcode
@@ -196,7 +163,7 @@
Strp11 = poBarcode,
Strp12 = query.ItemName ?? " ",
Strp15 = query.OrgName ?? " ",
- Strp16 = query.OrgOwner ?? " ",
+ Strp16 = query.OrgOwner ?? " "
}).ExecuteCommand();
}
@@ -254,7 +221,7 @@
var resultValue = outputResult.Value?.ToString();
var messageValue = outputMessage.Value?.ToString();
- dynamic m = new System.Dynamic.ExpandoObject();
+ dynamic m = new ExpandoObject();
m.Value = resultValue;
m.Msg = messageValue;
diff --git a/MESApplication/Controllers/BasicData/MesItemsController.cs b/MESApplication/Controllers/BasicData/MesItemsController.cs
index 8792e05..9fce676 100644
--- a/MESApplication/Controllers/BasicData/MesItemsController.cs
+++ b/MESApplication/Controllers/BasicData/MesItemsController.cs
@@ -22,7 +22,7 @@
private readonly string TableName = "MES_ITEMS";
private readonly string URL = "http://localhost:10054/api/MesItems/";
-
+
//GetItemQcPrint
[HttpPost("GetItemQcPrint")]
public ResponseResult GetItemQcPrint(WarehouseQuery query)
@@ -32,7 +32,7 @@
dynamic resultInfos = new ExpandoObject();
var save = m.GetItemQcPrint(query);
resultInfos.tbBillList = save;
-
+
return new ResponseResult
{
status = 0,
diff --git a/MESApplication/Controllers/Warehouse/MesInvItemOutCDetailsController.cs b/MESApplication/Controllers/Warehouse/MesInvItemOutCDetailsController.cs
index 29aa814..cde1ba7 100644
--- a/MESApplication/Controllers/Warehouse/MesInvItemOutCDetailsController.cs
+++ b/MESApplication/Controllers/Warehouse/MesInvItemOutCDetailsController.cs
@@ -14,14 +14,12 @@
private readonly MesInvItemOutCDetailsManager m = new();
/// <summary>
- /// 鑾峰彇鐗╂枡鎺ユ敹淇℃伅
+ /// 鑾峰彇鐗╂枡鎺ユ敹淇℃伅
/// </summary>
/// <returns></returns>
[HttpPost("GetOutItemList")]
-
public ResponseResult GetOutItemList(WarehouseQuery query)
{
-
try
{
dynamic resultInfos = new ExpandoObject();
@@ -37,17 +35,13 @@
{
return ResponseResult.ResponseError(ex);
}
-
-
-
}
/// <summary>
- /// 鑾峰彇鏄庣粏鑿滃崟
+ /// 鑾峰彇鏄庣粏鑿滃崟
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
-
[HttpPost("GetFormList")]
public ResponseResult GetFormList(WarehouseQuery query)
{
@@ -69,7 +63,7 @@
}
/// <summary>
- /// 纭鎺ユ敹
+ /// 纭鎺ユ敹
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
@@ -92,7 +86,6 @@
return ResponseResult.ResponseError(ex);
}
}
-
/***杩涘叆妯＄増绠＄悊鍙互淇敼妯＄増***/
diff --git a/MESApplication/Controllers/Warehouse/MesInvItemOutsController.cs b/MESApplication/Controllers/Warehouse/MesInvItemOutsController.cs
index 908f78a..a106240 100644
--- a/MESApplication/Controllers/Warehouse/MesInvItemOutsController.cs
+++ b/MESApplication/Controllers/Warehouse/MesInvItemOutsController.cs
@@ -13,6 +13,89 @@
{
private readonly MesInvItemOutsManager m = new();
+ //GetProductionPick
+ [HttpPost("GetProductionPick")]
+ public ResponseResult GetProductionPick(WarehouseQuery entity)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetProductionPick(entity);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ //GetProductionPickPage
+ [HttpPost("GetProductionPickPage")]
+ public ResponseResult GetProductionPickPage(WarehouseQuery entity)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetProductionPickPage(entity);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ //AuditProduction
+ [HttpPost("AuditProduction")]
+ public ResponseResult AuditProduction(WarehouseQuery query)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.AuditProduction(query);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ //MesToErp
+ [HttpPost("SaveProductionMessageCenter")]
+ public ResponseResult SaveProductionMessageCenter(WarehouseQuery entity)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.SaveProductionMessageCenter(entity);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
[HttpPost("ScanCode")]
public ResponseResult ScanCode(WarehouseQuery entity)
diff --git a/MESApplication/bin/Debug/net8.0/MES.Service.dll b/MESApplication/bin/Debug/net8.0/MES.Service.dll
index 30d58f8..a444cd4 100644
--- a/MESApplication/bin/Debug/net8.0/MES.Service.dll
+++ b/MESApplication/bin/Debug/net8.0/MES.Service.dll
Binary files differ
diff --git a/MESApplication/bin/Debug/net8.0/MES.Service.pdb b/MESApplication/bin/Debug/net8.0/MES.Service.pdb
index cce69d3..4151104 100644
--- a/MESApplication/bin/Debug/net8.0/MES.Service.pdb
+++ b/MESApplication/bin/Debug/net8.0/MES.Service.pdb
Binary files differ
diff --git a/MESApplication/bin/Debug/net8.0/MESApplication.dll b/MESApplication/bin/Debug/net8.0/MESApplication.dll
index 9845fbb..d3b307d 100644
--- a/MESApplication/bin/Debug/net8.0/MESApplication.dll
+++ b/MESApplication/bin/Debug/net8.0/MESApplication.dll
Binary files differ
diff --git a/MESApplication/bin/Debug/net8.0/MESApplication.exe b/MESApplication/bin/Debug/net8.0/MESApplication.exe
index 31bd773..1b8d978 100644
--- a/MESApplication/bin/Debug/net8.0/MESApplication.exe
+++ b/MESApplication/bin/Debug/net8.0/MESApplication.exe
Binary files differ
diff --git a/MESApplication/bin/Debug/net8.0/MESApplication.pdb b/MESApplication/bin/Debug/net8.0/MESApplication.pdb
index ce4d9f1..8cb3a9c 100644
--- a/MESApplication/bin/Debug/net8.0/MESApplication.pdb
+++ b/MESApplication/bin/Debug/net8.0/MESApplication.pdb
Binary files differ
--
Gitblit v1.9.3