From b64efba9b005c074b3963c9d650091c70e46108b Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期四, 01 八月 2024 14:53:18 +0800
Subject: [PATCH] 采购入库单和消息中心重推送
---
MES.Service/Modes/MesInvItemIns.cs | 591 ++++++++++++++++++++++++----------------------------------
1 files changed, 248 insertions(+), 343 deletions(-)
diff --git a/MES.Service/Modes/MesInvItemIns.cs b/MES.Service/Modes/MesInvItemIns.cs
index 9392c4f..b38b2cd 100644
--- a/MES.Service/Modes/MesInvItemIns.cs
+++ b/MES.Service/Modes/MesInvItemIns.cs
@@ -1,5 +1,3 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
using SqlSugar;
namespace MES.Service.Modes;
@@ -7,404 +5,311 @@
/// <summary>
/// 鐗╂枡鍏ュ簱涓昏〃
/// </summary>
-[Table("MES_INV_ITEM_INS")]
-[SugarTable("MES_INV_ITEM_INS")] //鐢ㄤ簬SqlSugar
+[SugarTable("MES_INV_ITEM_INS")]
public class MesInvItemIns
{
/// <summary>
/// ID(SEQ_INV_ID)
/// </summary>
- [Key]
- [Column("ID")]
- [SugarColumn(ColumnName = "ID")] //鐢ㄤ簬SqlSugar
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
/// <summary>
/// 鍏ュ簱鍗曞彿
/// </summary>
- [Column("BILL_NO")]
- [SugarColumn(ColumnName = "BILL_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(100, ErrorMessage = "鍏ュ簱鍗曞彿闀垮害涓嶈兘瓒呭嚭100")]
+ [SugarColumn(ColumnName = "BILL_NO")]
public string BillNo { get; set; }
/// <summary>
- /// 鍗曟嵁绫诲瀷ID
+ /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
/// </summary>
- [Column("BILL_TYPE_ID")]
- [SugarColumn(ColumnName = "BILL_TYPE_ID")] //鐢ㄤ簬SqlSugar
- public decimal? BillTypeId { get; set; }
+ [SugarColumn(ColumnName = "STATUS")]
+ public short? Status { get; set; }
/// <summary>
- /// 鍒拌揣鍗曞彿/璁″垝鍗曞彿
+ /// 浠撳簱
/// </summary>
- [Column("CBILL_NO")]
- [SugarColumn(ColumnName = "CBILL_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "鍒拌揣鍗曞彿/璁″垝鍗曞彿闀垮害涓嶈兘瓒呭嚭50")]
- public string CbillNo { get; set; }
+ [SugarColumn(ColumnName = "DEPOTS_ID")]
+ public decimal? DepotsId { get; set; }
/// <summary>
- /// 瀹℃牳鏃ユ湡
+ /// 鍘熷洜
/// </summary>
- [Column("CHECK_DATE")]
- [SugarColumn(ColumnName = "CHECK_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? CheckDate { get; set; }
-
- /// <summary>
- /// 宸叉崱鏁伴噺
- /// </summary>
- [Column("CHECK_QTY")]
- [SugarColumn(ColumnName = "CHECK_QTY")] //鐢ㄤ簬SqlSugar
- public decimal? CheckQty { get; set; }
-
- /// <summary>
- /// 妫�楠岀粨鏋�
- /// </summary>
- [Column("CHECK_RES")]
- [SugarColumn(ColumnName = "CHECK_RES")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "妫�楠岀粨鏋滈暱搴︿笉鑳借秴鍑�50")]
- public string CheckRes { get; set; }
-
- /// <summary>
- /// 瀹℃牳浜�
- /// </summary>
- [Column("CHECK_USER")]
- [SugarColumn(ColumnName = "CHECK_USER")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "瀹℃牳浜洪暱搴︿笉鑳借秴鍑�32")]
- public string CheckUser { get; set; }
-
- /// <summary>
- /// 鍏徃浠ｇ爜
- /// </summary>
- [Column("COMPANY")]
- [SugarColumn(ColumnName = "COMPANY")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "鍏徃浠ｇ爜闀垮害涓嶈兘瓒呭嚭20")]
- public string Company { get; set; }
+ [SugarColumn(ColumnName = "REASON")]
+ public string Reason { get; set; }
/// <summary>
/// 鍒涘缓浜�
/// </summary>
- [Column("CREATE_BY")]
- [SugarColumn(ColumnName = "CREATE_BY")] //鐢ㄤ簬SqlSugar
- [StringLength(30, ErrorMessage = "鍒涘缓浜洪暱搴︿笉鑳借秴鍑�30")]
+ [SugarColumn(ColumnName = "CREATE_BY")]
public string CreateBy { get; set; }
/// <summary>
/// 鍒涘缓鏃堕棿
/// </summary>
- [Column("CREATE_DATE")]
- [SugarColumn(ColumnName = "CREATE_DATE")] //鐢ㄤ簬SqlSugar
+ [SugarColumn(ColumnName = "CREATE_DATE")]
public DateTime? CreateDate { get; set; }
-
- /// <summary>
- /// 瀹㈡埛鍚嶇О
- /// </summary>
- [Column("CUST_NAME")]
- [SugarColumn(ColumnName = "CUST_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(300, ErrorMessage = "瀹㈡埛鍚嶇О闀垮害涓嶈兘瓒呭嚭300")]
- public string CustName { get; set; }
-
- /// <summary>
- /// 瀹㈡埛缂栧彿
- /// </summary>
- [Column("CUST_NO")]
- [SugarColumn(ColumnName = "CUST_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "瀹㈡埛缂栧彿闀垮害涓嶈兘瓒呭嚭50")]
- public string CustNo { get; set; }
-
- /// <summary>
- /// 浠撳簱缂栫爜
- /// </summary>
- [Column("DEPOTS_CODE")]
- [SugarColumn(ColumnName = "DEPOTS_CODE")] //鐢ㄤ簬SqlSugar
- [StringLength(30, ErrorMessage = "浠撳簱缂栫爜闀垮害涓嶈兘瓒呭嚭30")]
- public string DepotsCode { get; set; }
-
- /// <summary>
- /// 浠撳簱
- /// </summary>
- [Column("DEPOTS_ID")]
- [SugarColumn(ColumnName = "DEPOTS_ID")] //鐢ㄤ簬SqlSugar
- public decimal? DepotsId { get; set; }
-
- /// <summary>
- /// SAP閲囪喘璁㈠崟鍙�
- /// </summary>
- [Column("EBELN")]
- [SugarColumn(ColumnName = "EBELN")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "SAP閲囪喘璁㈠崟鍙烽暱搴︿笉鑳借秴鍑�50")]
- public string Ebeln { get; set; }
-
- /// <summary>
- /// 宸ュ巶缂栫爜
- /// </summary>
- [Column("FACTORY")]
- [SugarColumn(ColumnName = "FACTORY")] //鐢ㄤ簬SqlSugar
- [StringLength(10, ErrorMessage = "宸ュ巶缂栫爜闀垮害涓嶈兘瓒呭嚭10")]
- public string Factory { get; set; }
-
- /// <summary>
- /// 鎶曟枡鍗曡鍙�
- /// </summary>
- [Column("FBILL_LINO")]
- [SugarColumn(ColumnName = "FBILL_LINO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "鎶曟枡鍗曡鍙烽暱搴︿笉鑳借秴鍑�50")]
- public string FbillLino { get; set; }
-
- /// <summary>
- /// 鎶曟枡閫氱煡鍗曞崟鍙�
- /// </summary>
- [Column("FBILLNO")]
- [SugarColumn(ColumnName = "FBILLNO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "鎶曟枡閫氱煡鍗曞崟鍙烽暱搴︿笉鑳借秴鍑�50")]
- public string Fbillno { get; set; }
-
- /// <summary>
- /// 鍏ュ簱瀹℃牳鏃ユ湡
- /// </summary>
- [Column("FCHECK_DATE")]
- [SugarColumn(ColumnName = "FCHECK_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? FcheckDate { get; set; }
-
- /// <summary>
- /// 鍏ュ簱瀹℃牳浜�
- /// </summary>
- [Column("FCHECK_USER")]
- [SugarColumn(ColumnName = "FCHECK_USER")] //鐢ㄤ簬SqlSugar
- [StringLength(10, ErrorMessage = "鍏ュ簱瀹℃牳浜洪暱搴︿笉鑳借秴鍑�10")]
- public string FcheckUser { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鐘舵��
- /// </summary>
- [Column("FSTATUS")]
- [SugarColumn(ColumnName = "FSTATUS")] //鐢ㄤ簬SqlSugar
- public decimal? Fstatus { get; set; }
-
- /// <summary>
- /// 瀹℃牳鍏ュ簱浜�
- /// </summary>
- [Column("INSBY")]
- [SugarColumn(ColumnName = "INSBY")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "瀹℃牳鍏ュ簱浜洪暱搴︿笉鑳借秴鍑�32")]
- public string Insby { get; set; }
-
- /// <summary>
- /// 纭鍏ュ簱鏃ユ湡
- /// </summary>
- [Column("INSDATE")]
- [SugarColumn(ColumnName = "INSDATE")] //鐢ㄤ簬SqlSugar
- public DateTime? Insdate { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鏃ユ湡
- /// </summary>
- [Column("INS_DATE")]
- [SugarColumn(ColumnName = "INS_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? InsDate { get; set; }
-
- /// <summary>
- /// IQC妫�楠屽崟鍙�
- /// </summary>
- [Column("IQC_RELEASE_NO")]
- [SugarColumn(ColumnName = "IQC_RELEASE_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(300, ErrorMessage = "IQC妫�楠屽崟鍙烽暱搴︿笉鑳借秴鍑�300")]
- public string IqcReleaseNo { get; set; }
-
- /// <summary>
- /// 鏄惁妫�楠�
- /// </summary>
- [Column("ISCHECK")]
- [SugarColumn(ColumnName = "ISCHECK")] //鐢ㄤ簬SqlSugar
- public decimal? Ischeck { get; set; }
-
- /// <summary>
- /// 鏄惁鏄剧ず
- /// </summary>
- [Column("IS_VISUAL")]
- [SugarColumn(ColumnName = "IS_VISUAL")] //鐢ㄤ簬SqlSugar
- public decimal? IsVisual { get; set; }
-
- /// <summary>
- /// 鍗婃垚鍝佺紪鍙�
- /// </summary>
- [Column("ITEM_NO")]
- [SugarColumn(ColumnName = "ITEM_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "鍗婃垚鍝佺紪鍙烽暱搴︿笉鑳借秴鍑�50")]
- public string ItemNo { get; set; }
/// <summary>
/// 鏈�鍚庢洿鏂颁汉
/// </summary>
- [Column("LASTUPDATE_BY")]
- [SugarColumn(ColumnName = "LASTUPDATE_BY")] //鐢ㄤ簬SqlSugar
- [StringLength(30, ErrorMessage = "鏈�鍚庢洿鏂颁汉闀垮害涓嶈兘瓒呭嚭30")]
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string LastupdateBy { get; set; }
/// <summary>
/// 鏈�鍚庢洿鏂版椂闂�
/// </summary>
- [Column("LASTUPDATE_DATE")]
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")] //鐢ㄤ簬SqlSugar
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
public DateTime? LastupdateDate { get; set; }
/// <summary>
- /// 閲囪喘鍗曡鍙�
+ /// 鍗曟嵁绫诲瀷ID
/// </summary>
- [Column("LINE_NO")]
- [SugarColumn(ColumnName = "LINE_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "閲囪喘鍗曡鍙烽暱搴︿笉鑳借秴鍑�20")]
- public string LineNo { get; set; }
-
- /// <summary>
- /// 棰嗘枡宸ユ
- /// </summary>
- [Column("MMLIST")]
- [SugarColumn(ColumnName = "MMLIST")] //鐢ㄤ簬SqlSugar
- [StringLength(30, ErrorMessage = "棰嗘枡宸ユ闀垮害涓嶈兘瓒呭嚭30")]
- public string Mmlist { get; set; }
-
- /// <summary>
- /// 鐢熶骇璁㈠崟
- /// </summary>
- [Column("MOCODE")]
- [SugarColumn(ColumnName = "MOCODE")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "鐢熶骇璁㈠崟闀垮害涓嶈兘瓒呭嚭50")]
- public string Mocode { get; set; }
-
- /// <summary>
- /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
- /// </summary>
- [Column("MTTRANSCTION_NO")]
- [SugarColumn(ColumnName = "MTTRANSCTION_NO")] //鐢ㄤ簬SqlSugar
- public decimal? MttransctionNo { get; set; }
-
- /// <summary>
- /// 閫佽揣鍗曞彿
- /// </summary>
- [Column("PAPER_BILL_NO")]
- [SugarColumn(ColumnName = "PAPER_BILL_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "閫佽揣鍗曞彿闀垮害涓嶈兘瓒呭嚭50")]
- public string PaperBillNo { get; set; }
-
- /// <summary>
- /// 0 鐢宠鍗曪紝1鍏ュ簱鍗曟爣璇�
- /// </summary>
- [Column("PICK_INS")]
- [SugarColumn(ColumnName = "PICK_INS")] //鐢ㄤ簬SqlSugar
- public decimal? PickIns { get; set; }
-
- /// <summary>
- /// 鍘熷洜
- /// </summary>
- [Column("REASON")]
- [SugarColumn(ColumnName = "REASON")] //鐢ㄤ簬SqlSugar
- [StringLength(1000, ErrorMessage = "鍘熷洜闀垮害涓嶈兘瓒呭嚭1000")]
- public string Reason { get; set; }
-
- /// <summary>
- /// 閫�鏂欏師鍥�
- /// </summary>
- [Column("REM")]
- [SugarColumn(ColumnName = "REM")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "閫�鏂欏師鍥犻暱搴︿笉鑳借秴鍑�50")]
- public string Rem { get; set; }
-
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [Column("REMARK")]
- [SugarColumn(ColumnName = "REMARK")] //鐢ㄤ簬SqlSugar
- [StringLength(255, ErrorMessage = "澶囨敞闀垮害涓嶈兘瓒呭嚭255")]
- public string Remark { get; set; }
-
- /// <summary>
- /// SAP杩斿洖鍗曟嵁
- /// </summary>
- [Column("SAPNO")]
- [SugarColumn(ColumnName = "SAPNO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "SAP杩斿洖鍗曟嵁闀垮害涓嶈兘瓒呭嚭50")]
- public string Sapno { get; set; }
-
- /// <summary>
- /// 鏄惁宸插洖鍐橲AP
- /// </summary>
- [Column("SAPSTATUS")]
- [SugarColumn(ColumnName = "SAPSTATUS")] //鐢ㄤ簬SqlSugar
- public decimal? Sapstatus { get; set; }
-
- /// <summary>
- /// SAP杩斿洖淇℃伅
- /// </summary>
- [Column("SAPTEXT")]
- [SugarColumn(ColumnName = "SAPTEXT")] //鐢ㄤ簬SqlSugar
- [StringLength(200, ErrorMessage = "SAP杩斿洖淇℃伅闀垮害涓嶈兘瓒呭嚭200")]
- public string Saptext { get; set; }
-
- /// <summary>
- /// SAP杩斿洖骞翠唤
- /// </summary>
- [Column("SAPYEAR")]
- [SugarColumn(ColumnName = "SAPYEAR")] //鐢ㄤ簬SqlSugar
- public decimal? Sapyear { get; set; }
-
- /// <summary>
- /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
- /// </summary>
- [Column("STATUS")]
- [SugarColumn(ColumnName = "STATUS")] //鐢ㄤ簬SqlSugar
- public decimal? Status { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟嗙紪鐮�
- /// </summary>
- [Column("SUPP_NO")]
- [SugarColumn(ColumnName = "SUPP_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(30, ErrorMessage = "渚涘簲鍟嗙紪鐮侀暱搴︿笉鑳借秴鍑�30")]
- public string SuppNo { get; set; }
-
- /// <summary>
- /// 宸ュ崟琛屽彿
- /// </summary>
- [Column("TASK_LINO")]
- [SugarColumn(ColumnName = "TASK_LINO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "宸ュ崟琛屽彿闀垮害涓嶈兘瓒呭嚭50")]
- public string TaskLino { get; set; }
-
- /// <summary>
- /// 浠诲姟鍗曞彿
- /// </summary>
- [Column("TASK_NO")]
- [SugarColumn(ColumnName = "TASK_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "浠诲姟鍗曞彿闀垮害涓嶈兘瓒呭嚭50")]
- public string TaskNo { get; set; }
+ [SugarColumn(ColumnName = "BILL_TYPE_ID")]
+ public decimal? BillTypeId { get; set; }
/// <summary>
/// 浜嬪姟绫诲瀷ID
/// </summary>
- [Column("TRANSACTION_ID")]
- [SugarColumn(ColumnName = "TRANSACTION_ID")] //鐢ㄤ簬SqlSugar
+ [SugarColumn(ColumnName = "TRANSACTION_ID")]
public decimal? TransactionId { get; set; }
/// <summary>
- /// 浜嬪姟绫诲瀷缂栫爜
+ /// 澶囨敞
/// </summary>
- [Column("TRANSCTION_NO")]
- [SugarColumn(ColumnName = "TRANSCTION_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(30, ErrorMessage = "浜嬪姟绫诲瀷缂栫爜闀垮害涓嶈兘瓒呭嚭30")]
- public string TransctionNo { get; set; }
+ [SugarColumn(ColumnName = "REMARK")]
+ public string Remark { get; set; }
/// <summary>
- /// 鎬ユ枡鏍囪瘑
+ /// 閫佽揣鍗曞彿
/// </summary>
- [Column("URGENT_FLAG")]
- [SugarColumn(ColumnName = "URGENT_FLAG")] //鐢ㄤ簬SqlSugar
- public decimal? UrgentFlag { get; set; }
+ [SugarColumn(ColumnName = "PAPER_BILL_NO")]
+ public string PaperBillNo { get; set; }
/// <summary>
/// 閫�鏂欎汉宸ュ彿
/// </summary>
- [Column("USER_NO_BACK")]
- [SugarColumn(ColumnName = "USER_NO_BACK")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "閫�鏂欎汉宸ュ彿闀垮害涓嶈兘瓒呭嚭20")]
+ [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_DATE")]
+ public DateTime? CheckDate { 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 = "CHECK_RES")]
+ public string CheckRes { get; set; }
+
+ /// <summary>
+ /// 宸叉崱鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QTY")]
+ public decimal? CheckQty { 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 = "DEPOTS_CODE")]
+ public string DepotsCode { 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 = "FSTATUS")]
+ public short? Fstatus { get; set; }
+
+ /// <summary>
+ /// 宸ュ巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+ public string Factory { get; set; }
+
+ /// <summary>
+ /// 鏄惁宸插洖鍐橲AP
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPSTATUS")]
+ public short? Sapstatus { get; set; }
+
+ /// <summary>
+ /// SAP杩斿洖鍗曟嵁
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPNO")]
+ public string Sapno { get; set; }
+
+ /// <summary>
+ /// SAP杩斿洖骞翠唤
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPYEAR")]
+ public short? Sapyear { get; set; }
+
+ /// <summary>
+ /// SAP杩斿洖淇℃伅
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPTEXT")]
+ public string Saptext { get; set; }
+
+ /// <summary>
+ /// 纭鍏ュ簱鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "INSDATE")]
+ public DateTime? InsdateA { get; set; }
+
+ /// <summary>
+ /// 鏄惁妫�楠�
+ /// </summary>
+ [SugarColumn(ColumnName = "ISCHECK")]
+ public decimal? Ischeck { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳鍏ュ簱浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "INSBY")]
+ public string Insby { get; set; }
+
+ /// <summary>
+ /// 鏄惁鏄剧ず
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_VISUAL")]
+ public decimal? IsVisual { get; set; }
+
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+ public string Company { get; set; }
+
+ /// <summary>
+ /// 鎬ユ枡鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "URGENT_FLAG")]
+ public short? UrgentFlag { get; set; }
+
+ /// <summary>
+ /// 閲囪喘鍗曡鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_NO")]
+ public string LineNo { get; set; }
+
+ /// <summary>
+ /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
+ public decimal? MttransctionNo { 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 = "FBILL_LINO")]
+ public string FbillLino { 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>
+ /// IQC妫�楠屽崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
+ public string IqcReleaseNo { get; set; }
+
+ /// <summary>
+ /// 鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CBILL_NO")]
+ public string CbillNo { get; set; }
+
+ /// <summary>
+ /// 0 鐢宠鍗曪紝1鍏ュ簱鍗曟爣璇�
+ /// </summary>
+ [SugarColumn(ColumnName = "PICK_INS")]
+ public decimal? PickIns { 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 = "RBILL_NO")]
+ public string RbillNo { 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