From 7883316c61d4f8fa70fe6cde0c0f53e9e3d8d1d0 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期四, 15 五月 2025 14:22:40 +0800
Subject: [PATCH] 1.OA->MES审批接口开发。 2.OA->MES退回接口开发。 3.MES->OA由同步调整为异步。
---
entity/MesInvItemIns.cs | 541 ++++++++++++++++++++++++++---------------------------
1 files changed, 269 insertions(+), 272 deletions(-)
diff --git a/entity/MesInvItemIns.cs b/entity/MesInvItemIns.cs
index 12b5ef9..8585581 100644
--- a/entity/MesInvItemIns.cs
+++ b/entity/MesInvItemIns.cs
@@ -1,329 +1,326 @@
锘縰sing SqlSugar;
-namespace NewPdaSqlServer.entity
+namespace NewPdaSqlServer.entity;
+
+/// <summary>
+/// 鐗╂枡鍏ュ簱涓昏〃
+/// </summary>
+[SugarTable("MES_INV_ITEM_INS")]
+public class MesInvItemIns
{
/// <summary>
- /// 鐗╂枡鍏ュ簱涓昏〃
- ///</summary>
- [SugarTable("MES_INV_ITEM_INS")]
- public class MesInvItemIns
- {
- /// <summary>
- /// ID(SEQ_INV_ID)
- /// 榛樿鍊�: (newid())
- ///</summary>
- [SugarColumn(ColumnName = "GUID", IsPrimaryKey = true)]
- public Guid Guid { get; set; }
+ /// ID(SEQ_INV_ID)
+ /// 榛樿鍊�: (newid())
+ /// </summary>
+ [SugarColumn(ColumnName = "GUID", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
- /// <summary>
- /// 鍏ュ簱鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "BILL_NO")]
- public string? BillNo { get; set; }
+ /// <summary>
+ /// 鍏ュ簱鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
+ public string? BillNo { get; set; }
- /// <summary>
- /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\\缁撴
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName = "STATUS")]
- public byte? Status { get; set; }
+ /// <summary>
+ /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\\缁撴
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
+ public byte? Status { get; set; }
- /// <summary>
- /// 浠撳簱
- ///</summary>
- [SugarColumn(ColumnName = "DEPOTS_ID")]
- public long? DepotsId { get; set; }
+ /// <summary>
+ /// 浠撳簱
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOTS_ID")]
+ public long? DepotsId { get; set; }
- /// <summary>
- /// 鍘熷洜
- ///</summary>
- [SugarColumn(ColumnName = "REASON")]
- public string? Reason { get; set; }
+ /// <summary>
+ /// 鍘熷洜
+ /// </summary>
+ [SugarColumn(ColumnName = "REASON")]
+ public string? Reason { 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>
- /// 鍗曟嵁绫诲瀷ID
- ///</summary>
- [SugarColumn(ColumnName = "BILL_TYPE_ID")]
- public long? BillTypeId { get; set; }
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_TYPE_ID")]
+ public long? BillTypeId { get; set; }
- /// <summary>
- /// 浜嬪姟绫诲瀷ID
- ///</summary>
- [SugarColumn(ColumnName = "TRANSACTION_ID")]
- public long? TransactionId { get; set; }
+ /// <summary>
+ /// 浜嬪姟绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_ID")]
+ public long? TransactionId { get; set; }
- /// <summary>
- /// 澶囨敞
- ///</summary>
- [SugarColumn(ColumnName = "REMARK")]
- public string? Remark { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK")]
+ public string? Remark { get; set; }
- /// <summary>
- /// 閫佽揣鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "PAPER_BILL_NO")]
- public string? PaperBillNo { get; set; }
+ /// <summary>
+ /// 閫佽揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_BILL_NO")]
+ public string? PaperBillNo { get; set; }
- /// <summary>
- /// 閫�鏂欎汉宸ュ彿
- ///</summary>
- [SugarColumn(ColumnName = "USER_NO_BACK")]
- public string? UserNoBack { get; set; }
+ /// <summary>
+ /// 閫�鏂欎汉宸ュ彿
+ /// </summary>
+ [SugarColumn(ColumnName = "USER_NO_BACK")]
+ public string? UserNoBack { get; set; }
- /// <summary>
- /// 瀹℃牳浜�
- ///</summary>
- [SugarColumn(ColumnName = "CHECK_USER")]
- public string? CheckUser { get; set; }
+ /// <summary>
+ /// 瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_USER")]
+ public string? CheckUser { get; set; }
- /// <summary>
- /// 瀹℃牳鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName = "CHECK_DATE")]
- public DateTime? CheckDate { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_DATE")]
+ public DateTime? CheckDate { get; set; }
- /// <summary>
- /// 鐢熶骇璁㈠崟鍙�
- ///</summary>
- [SugarColumn(ColumnName = "TASK_NO")]
- public string? TaskNo { get; set; }
+ /// <summary>
+ /// 鍏ュ簱鍗曞搴旂殑鐢宠鍗曞彿锛堟病鏈夌敵璇锋祦绋嬬殑灏变负绌猴級
+ /// </summary>
+ [SugarColumn(ColumnName = "TASK_NO")]
+ public string? TaskNo { get; set; }
- /// <summary>
- /// 鍏ュ簱鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName = "INS_DATE")]
- public DateTime? InsDate { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "INS_DATE")]
+ public DateTime? InsDate { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "CHECK_RES")]
- public string? CheckRes { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_RES")]
+ public string? CheckRes { get; set; }
- /// <summary>
- /// 宸叉崱鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "CHECK_QTY")]
- public long? CheckQty { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QTY")]
+ public long? CheckQty { get; set; }
- /// <summary>
- /// 棰嗘枡宸ユ
- ///</summary>
- [SugarColumn(ColumnName = "MMLIST")]
- public string? Mmlist { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "MMLIST")]
+ public string? Mmlist { get; set; }
- /// <summary>
- /// SAP閲囪喘璁㈠崟鍙�
- ///</summary>
- [SugarColumn(ColumnName = "EBELN")]
- public string? Ebeln { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN")]
+ public string? Ebeln { get; set; }
- /// <summary>
- /// 浠撳簱缂栫爜
- ///</summary>
- [SugarColumn(ColumnName = "DEPOTS_CODE")]
- public string? DepotsCode { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOTS_CODE")]
+ public string? DepotsCode { get; set; }
- /// <summary>
- /// 浜嬪姟绫诲瀷缂栫爜
- ///</summary>
- [SugarColumn(ColumnName = "TRANSCTION_NO")]
- public string? TransctionNo { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSCTION_NO")]
+ public string? TransctionNo { get; set; }
- /// <summary>
- /// 渚涘簲鍟嗙紪鐮�
- ///</summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
- public string? SuppNo { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
+ public string? SuppNo { get; set; }
- /// <summary>
- /// 鍏ュ簱鐘舵��
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName = "FSTATUS")]
- public byte? Fstatus { get; set; }
+ /// <summary>
+ /// 鐘舵�� | 0-鏈鏍� 1-瀹℃牳鍏ュ簱/缁撴
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "FSTATUS")]
+ public byte? Fstatus { get; set; }
- /// <summary>
- /// 宸ュ巶缂栫爜
- ///</summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string? Factory { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+ public string? Factory { get; set; }
- /// <summary>
- /// 鏄惁宸插洖鍐橲AP
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName = "SAPSTATUS")]
- public byte? Sapstatus { get; set; }
+ /// <summary>
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPSTATUS")]
+ public byte? Sapstatus { get; set; }
- /// <summary>
- /// SAP杩斿洖鍗曟嵁
- ///</summary>
- [SugarColumn(ColumnName = "SAPNO")]
- public string? Sapno { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPNO")]
+ public string? Sapno { get; set; }
- /// <summary>
- /// SAP杩斿洖骞翠唤
- ///</summary>
- [SugarColumn(ColumnName = "SAPYEAR")]
- public short? Sapyear { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPYEAR")]
+ public short? Sapyear { get; set; }
- /// <summary>
- /// SAP杩斿洖淇℃伅
- ///</summary>
- [SugarColumn(ColumnName = "SAPTEXT")]
- public string? Saptext { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPTEXT")]
+ public string? Saptext { get; set; }
- // /// <summary>
- // /// 纭鍏ュ簱鏃ユ湡
- // ///</summary>
- // [SugarColumn(ColumnName = "INSDATE")]
- // public DateTime? Insdate { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "ISCHECK")]
+ public byte? Ischeck { get; set; }
- /// <summary>
- /// 鏄惁妫�楠�
- ///</summary>
- [SugarColumn(ColumnName = "ISCHECK")]
- public byte? Ischeck { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "INSBY")]
+ public string? Insby { get; set; }
- /// <summary>
- /// 瀹℃牳鍏ュ簱浜�
- ///</summary>
- [SugarColumn(ColumnName = "INSBY")]
- public string? Insby { get; set; }
+ /// <summary>
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_VISUAL")]
+ public byte? IsVisual { get; set; }
- /// <summary>
- /// 鏄惁鏄剧ず
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName = "IS_VISUAL")]
- public byte? IsVisual { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+ public string? Company { get; set; }
- /// <summary>
- /// 鍏徃浠ｇ爜
- ///</summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string? Company { get; set; }
+ /// <summary>
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "URGENT_FLAG")]
+ public string? UrgentFlag { get; set; }
- /// <summary>
- /// 鎬ユ枡鏍囪瘑
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName = "URGENT_FLAG")]
- public int? UrgentFlag { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_NO")]
+ public string? LineNo { get; set; }
- /// <summary>
- /// 閲囪喘鍗曡鍙�
- ///</summary>
- [SugarColumn(ColumnName = "LINE_NO")]
- public string? LineNo { get; set; }
+ /// <summary>
+ /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
+ public long? MttransctionNo { get; set; }
- /// <summary>
- /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
- ///</summary>
- [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
- public long? MttransctionNo { get; set; }
+ /// <summary>
+ /// 宸ュ崟琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "TASK_LINO")]
+ public string? TaskLino { get; set; }
- /// <summary>
- /// 宸ュ崟琛屽彿
- ///</summary>
- [SugarColumn(ColumnName = "TASK_LINO")]
- public string? TaskLino { get; set; }
+ /// <summary>
+ /// 鎶曟枡閫氱煡鍗曞崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "FBILLNO")]
+ public string? Fbillno { get; set; }
- /// <summary>
- /// 鎶曟枡閫氱煡鍗曞崟鍙�
- ///</summary>
- [SugarColumn(ColumnName = "FBILLNO")]
- public string? Fbillno { get; set; }
+ /// <summary>
+ /// 鎶曟枡鍗曡鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "FBILL_LINO")]
+ public string? FbillLino { get; set; }
- /// <summary>
- /// 鎶曟枡鍗曡鍙�
- ///</summary>
- [SugarColumn(ColumnName = "FBILL_LINO")]
- public string? FbillLino { 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 = "CUST_NAME")]
+ public string? CustName { get; set; }
- /// <summary>
- /// 瀹㈡埛鍚嶇О
- ///</summary>
- [SugarColumn(ColumnName = "CUST_NAME")]
- public string? CustName { get; set; }
+ /// <summary>
+ /// IQC妫�楠屽崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
+ public string? IqcReleaseNo { get; set; }
- /// <summary>
- /// IQC妫�楠屽崟鍙�
- ///</summary>
- [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
- public string? IqcReleaseNo { get; set; }
+ /// <summary>
+ /// 鍏ュ簱鍗曠殑鐩稿叧鍗曞彿锛堢敓浜х浉鍏冲瓨 鎸囦护鍗曞彿 -1锛岄噰璐浉鍏崇殑瀛樺埌璐у崟鍙凤級
+ /// </summary>
+ [SugarColumn(ColumnName = "CBILL_NO")]
+ public string? CbillNo { get; set; }
- /// <summary>
- /// 鍒拌揣鍗曞彿/鍏跺畠鍏ュ簱鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "CBILL_NO")]
- public string? CbillNo { get; set; }
+ /// <summary>
+ /// 0 鐢宠鍗曪紝1鍏ュ簱鍗曟爣璇�
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "PICK_INS")]
+ public byte? PickIns { get; set; }
- /// <summary>
- /// 0 鐢宠鍗曪紝1鍏ュ簱鍗曟爣璇�
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName = "PICK_INS")]
- public byte? PickIns { get; set; }
+ /// <summary>
+ /// 鍏ュ簱瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_USER")]
+ public string? FcheckUser { get; set; }
- /// <summary>
- /// 鍏ュ簱瀹℃牳浜�
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_USER")]
- public string? FcheckUser { get; set; }
+ /// <summary>
+ /// 鍏ュ簱瀹℃牳鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_DATE")]
+ public DateTime? FcheckDate { get; set; }
- /// <summary>
- /// 鍏ュ簱瀹℃牳鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName = "FCHECK_DATE")]
- public DateTime? FcheckDate { get; set; }
+ /// <summary>
+ /// 浠诲姟姹囨姤鍗�/宸ュ崟鍙凤紙鎴愬搧鍏ュ簱銆侀��鏂欙級
+ /// </summary>
+ [SugarColumn(ColumnName = "RBILL_NO")]
+ public string? RbillNo { get; set; }
- /// <summary>
- /// 浠诲姟姹囨姤鍗�/宸ュ崟鍙凤紙鎴愬搧鍏ュ簱銆侀��鏂欙級
- ///</summary>
- [SugarColumn(ColumnName = "RBILL_NO")]
- public string? RbillNo { get; set; }
+ /// <summary>
+ /// 鎶ュ伐浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "BGR")]
+ public string? Bgr { get; set; }
- /// <summary>
- /// 鎶ュ伐浜�
- ///</summary>
- [SugarColumn(ColumnName = "BGR")]
- public string? Bgr { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_ID")]
+ public string? SuppId { get; set; }
- //鍦ㄦ暟鎹簱鏌ヨ鏃跺拷鐣ヨ繖涓瓧娈�
- [SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
+ /// <summary>
+ /// 鏀舵枡缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "ReceiveOrgId")]
+ public string? ReceiveOrgId { get; set; }
- [SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
- }
+ /// <summary>
+ /// 鍏ュ簱鍗曠殑鐩稿叧鍗曞彿锛堢敓浜х浉鍏冲瓨 鎸囦护鍗曞彿 -1锛岄噰璐浉鍏崇殑瀛樺埌璐у崟鍙凤級
+ /// </summary>
+ [SugarColumn(ColumnName = "work_no")]
+ public string? WorkNo { get; set; }
+
+ /// <summary>
+ /// 鍏ュ簱绫诲埆锛堜簨鍔＄被鍨嬪悕绉帮級
+ /// </summary>
+ [SugarColumn(ColumnName = "in_type")]
+ public string? InType { get; set; }
+
+
+ //鍦ㄦ暟鎹簱鏌ヨ鏃跺拷鐣ヨ繖涓瓧娈�
+ [SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
+
+ [SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3