1.OA->MES审批接口开发。 2.OA->MES退回接口开发。 3.MES->OA由同步调整为异步。

南骏 池

2025-05-15 7883316c61d4f8fa70fe6cde0c0f53e9e3d8d1d0

 entity/MesInvItemIns.cs

@@ -1,329 +1,326 @@
using 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>
        /// 是否已回写SAP 
        /// 默认值: ((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; }
}