格式化清理代码

tjx

2025-11-13 2f4699ff377f0e5ea3640bb3670b2fbfbd56e3fb

 StandardPda/MES.Service/Modes/MesRohIn.cs

@@ -1,316 +1,312 @@
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
using SqlSugar;

namespace MES.Service.Modes
namespace MES.Service.Modes;

/// <summary>
///     采购订单表
/// </summary>
[SugarTable("MES_ROH_IN")]
public class MesRohIn
{
    /// <summary>
    /// 采购订单表
    ///</summary>
    [SugarTable("MES_ROH_IN")]
    public class MesRohIn
    {
        /// <summary>
        ///     SEQ_BASEINFO_ID
        /// </summary>
        [SugarColumn(ColumnName = "ID",
            OracleSequenceName = "SEQ_BASEINFO_ID",
            IsPrimaryKey = true)]
        public decimal Id { get; set; }
    ///     SEQ_BASEINFO_ID
    /// </summary>
    [SugarColumn(ColumnName = "ID",
        OracleSequenceName = "SEQ_BASEINFO_ID",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

        /// <summary>
        /// 采购单号 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_NO")]
        public string? BillNo { get; set; }
    /// <summary>
    ///     采购单号
    /// </summary>
    [SugarColumn(ColumnName = "BILL_NO")]
    public string? BillNo { get; set; }

        /// <summary>
        /// 单据状态 
        ///</summary>
        [SugarColumn(ColumnName = "DOCUMENT_STATUS")]
        public string? DocumentStatus { get; set; }
    /// <summary>
    ///     单据状态
    /// </summary>
    [SugarColumn(ColumnName = "DOCUMENT_STATUS")]
    public string? DocumentStatus { get; set; }

        /// <summary>
        /// 单据类型 
        ///</summary>
        [SugarColumn(ColumnName = "DOCUMENT_TYPE")]
        public string? DocumentType { get; set; }
    /// <summary>
    ///     单据类型
    /// </summary>
    [SugarColumn(ColumnName = "DOCUMENT_TYPE")]
    public string? DocumentType { get; set; }

        /// <summary>
        /// 业务类型 
        ///</summary>
        [SugarColumn(ColumnName = "BUSINESS_TYPE")]
        public string? BusinessType { get; set; }
    /// <summary>
    ///     业务类型
    /// </summary>
    [SugarColumn(ColumnName = "BUSINESS_TYPE")]
    public string? BusinessType { get; set; }

        /// <summary>
        /// 采购日期 
        ///</summary>
        [SugarColumn(ColumnName = "PURCHASE_DATE")]
        public DateTime? PurchaseDate { get; set; }
    /// <summary>
    ///     采购日期
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_DATE")]
    public DateTime? PurchaseDate { get; set; }

        /// <summary>
        /// 供应商 
        ///</summary>
        [SugarColumn(ColumnName = "SUPPLIER")]
        public string? Supplier { get; set; }
    /// <summary>
    ///     供应商
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLIER")]
    public string? Supplier { get; set; }

        /// <summary>
        /// 取业务关闭字段 0==未关闭 1==业务关闭 
        ///</summary>
        [SugarColumn(ColumnName = "CLOSE_STATUS")]
        public string? CloseStatus { get; set; }
    /// <summary>
    ///     取业务关闭字段 0==未关闭 1==业务关闭
    /// </summary>
    [SugarColumn(ColumnName = "CLOSE_STATUS")]
    public string? CloseStatus { get; set; }

        /// <summary>
        /// 采购组织 
        ///</summary>
        [SugarColumn(ColumnName = "PURCHASE_ORG")]
        public string? PurchaseOrg { get; set; }
    /// <summary>
    ///     采购组织
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_ORG")]
    public string? PurchaseOrg { get; set; }

        /// <summary>
        /// 采购部门 
        ///</summary>
        [SugarColumn(ColumnName = "PURCHASE_DEPT")]
        public string? PurchaseDept { get; set; }
    /// <summary>
    ///     采购部门
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_DEPT")]
    public string? PurchaseDept { get; set; }

        /// <summary>
        /// 采购组 
        ///</summary>
        [SugarColumn(ColumnName = "PURCHASE_GROUP")]
        public string? PurchaseGroup { get; set; }
    /// <summary>
    ///     采购组
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_GROUP")]
    public string? PurchaseGroup { get; set; }

        /// <summary>
        /// 数量验收 
        ///</summary>
        [SugarColumn(ColumnName = "QTY_ACCEPTANCE")]
        public string? QtyAcceptance { get; set; }
    /// <summary>
    ///     数量验收
    /// </summary>
    [SugarColumn(ColumnName = "QTY_ACCEPTANCE")]
    public string? QtyAcceptance { get; set; }

        /// <summary>
        /// 采购员 
        ///</summary>
        [SugarColumn(ColumnName = "PURCHASER")]
        public string? Purchaser { get; set; }
    /// <summary>
    ///     采购员
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASER")]
    public string? Purchaser { get; set; }

        /// <summary>
        /// 质量要求 
        ///</summary>
        [SugarColumn(ColumnName = "QUALITY_REQ")]
        public string? QualityReq { get; set; }
    /// <summary>
    ///     质量要求
    /// </summary>
    [SugarColumn(ColumnName = "QUALITY_REQ")]
    public string? QualityReq { get; set; }

        /// <summary>
        /// 结算方 
        ///</summary>
        [SugarColumn(ColumnName = "SETTLEMENT_PARTY")]
        public string? SettlementParty { get; set; }
    /// <summary>
    ///     结算方
    /// </summary>
    [SugarColumn(ColumnName = "SETTLEMENT_PARTY")]
    public string? SettlementParty { get; set; }

        /// <summary>
        /// 收款方 
        ///</summary>
        [SugarColumn(ColumnName = "PAYMENT_PARTY")]
        public string? PaymentParty { get; set; }
    /// <summary>
    ///     收款方
    /// </summary>
    [SugarColumn(ColumnName = "PAYMENT_PARTY")]
    public string? PaymentParty { get; set; }

        /// <summary>
        /// 邮箱 
        ///</summary>
        [SugarColumn(ColumnName = "EMAIL")]
        public string? Email { get; set; }
    /// <summary>
    ///     邮箱
    /// </summary>
    [SugarColumn(ColumnName = "EMAIL")]
    public string? Email { get; set; }

        /// <summary>
        /// 运输方式 
        ///</summary>
        [SugarColumn(ColumnName = "TRANSPORT_METHOD")]
        public string? TransportMethod { get; set; }
    /// <summary>
    ///     运输方式
    /// </summary>
    [SugarColumn(ColumnName = "TRANSPORT_METHOD")]
    public string? TransportMethod { 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 = "FIXTURE_MOLD_PROCUREMENT")]
        public string? FixtureMoldProcurement { get; set; }
    /// <summary>
    ///     治具丶模具加工及采购
    /// </summary>
    [SugarColumn(ColumnName = "FIXTURE_MOLD_PROCUREMENT")]
    public string? FixtureMoldProcurement { get; set; }

        /// <summary>
        /// 作废状态 
        ///</summary>
        [SugarColumn(ColumnName = "CANCELLATION_STATUS")]
        public string? CancellationStatus { get; set; }
    /// <summary>
    ///     作废状态
    /// </summary>
    [SugarColumn(ColumnName = "CANCELLATION_STATUS")]
    public string? CancellationStatus { get; set; }

        /// <summary>
        /// 作废人 
        ///</summary>
        [SugarColumn(ColumnName = "CANCELLATION_PERSON")]
        public string? CancellationPerson { get; set; }
    /// <summary>
    ///     作废人
    /// </summary>
    [SugarColumn(ColumnName = "CANCELLATION_PERSON")]
    public string? CancellationPerson { get; set; }

        /// <summary>
        /// 作废日期 
        ///</summary>
        [SugarColumn(ColumnName = "CANCELLATION_DATE")]
        public DateTime? CancellationDate { get; set; }
    /// <summary>
    ///     作废日期
    /// </summary>
    [SugarColumn(ColumnName = "CANCELLATION_DATE")]
    public DateTime? CancellationDate { 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_DATE")]
        public DateTime? LastupdateDate { get; set; }
    /// <summary>
    ///     最后修改时间
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
    public DateTime? LastupdateDate { 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 = "ERP_CHECK_BY")]
        public string? ErpCheckBy { get; set; }
    /// <summary>
    ///     审核人
    /// </summary>
    [SugarColumn(ColumnName = "ERP_CHECK_BY")]
    public string? ErpCheckBy { get; set; }

        /// <summary>
        /// 审核时间 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_CHECK_DATE")]
        public string? ErpCheckDate { get; set; }
    /// <summary>
    ///     审核时间
    /// </summary>
    [SugarColumn(ColumnName = "ERP_CHECK_DATE")]
    public string? ErpCheckDate { get; set; }

        /// <summary>
        /// ERP的ID号 
        ///</summary>
        [SugarColumn(ColumnName = "EBELN_K3ID")]
        public string? EbelnK3id { get; set; }
    /// <summary>
    ///     ERP的ID号
    /// </summary>
    [SugarColumn(ColumnName = "EBELN_K3ID")]
    public string? EbelnK3id { 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 = "CHECK_BY")]
        public string? CheckBy { get; set; }
    /// <summary>
    ///     审核人
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_BY")]
    public string? CheckBy { get; set; }

        /// <summary>
        /// 审核标识 
        ///</summary>
        [SugarColumn(ColumnName = "CHECK_FALG")]
        public short? CheckFalg { get; set; }
    /// <summary>
    ///     审核标识
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_FALG")]
    public short? CheckFalg { 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 = "CHANGEREASON")]
        public string? Changereason { get; set; }
    /// <summary>
    ///     变更原因
    /// </summary>
    [SugarColumn(ColumnName = "CHANGEREASON")]
    public string? Changereason { get; set; }

        /// <summary>
        /// 预计到达时间 
        ///</summary>
        [SugarColumn(ColumnName = "ARRIVE_DATE")]
        public DateTime? ArriveDate { get; set; }
    /// <summary>
    ///     预计到达时间
    /// </summary>
    [SugarColumn(ColumnName = "ARRIVE_DATE")]
    public DateTime? ArriveDate { get; set; }

        /// <summary>
        /// 收料组织 
        ///</summary>
        [SugarColumn(ColumnName = "RECEIVE_ORG")]
        public string? ReceiveOrg { get; set; }
    /// <summary>
    ///     收料组织
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVE_ORG")]
    public string? ReceiveOrg { get; set; }

        /// <summary>
        /// 审批意见 
        ///</summary>
        [SugarColumn(ColumnName = "F_WWC_TEXT")]
        public string? FWwcText { get; set; }
    /// <summary>
    ///     审批意见
    /// </summary>
    [SugarColumn(ColumnName = "F_WWC_TEXT")]
    public string? FWwcText { get; set; }

        /// <summary>
        /// 来源类别,0=手工 1=请购单 3=需求接口表 4=采购合同 6=采购订单 7=销售订单 
        ///</summary>
        [SugarColumn(ColumnName = "SRC_DOC_TYPE")]
        public string? SrcDocType { get; set; }
    /// <summary>
    ///     来源类别,0=手工 1=请购单 3=需求接口表 4=采购合同 6=采购订单 7=销售订单
    /// </summary>
    [SugarColumn(ColumnName = "SRC_DOC_TYPE")]
    public string? SrcDocType { get; set; }

        /// <summary>
        /// 来源单据 
        ///</summary>
        [SugarColumn(ColumnName = "SRC_DOC")]
        public string? SrcDoc { get; set; }
    /// <summary>
    ///     来源单据
    /// </summary>
    [SugarColumn(ColumnName = "SRC_DOC")]
    public string? SrcDoc { get; set; }

        /// <summary>
        /// 贸易路径 
        ///</summary>
        [SugarColumn(ColumnName = "TRADE_PATH_NAME")]
        public string? TradePathName { get; set; }
    /// <summary>
    ///     贸易路径
    /// </summary>
    [SugarColumn(ColumnName = "TRADE_PATH_NAME")]
    public string? TradePathName { get; set; }

        /// <summary>
        /// 委外类型字段暂未使用，默认值-1 
        ///</summary>
        [SugarColumn(ColumnName = "SUB_TYPE")]
        public string? SubType { get; set; }
    /// <summary>
    ///     委外类型字段暂未使用，默认值-1
    /// </summary>
    [SugarColumn(ColumnName = "SUB_TYPE")]
    public string? SubType { get; set; }

        /// <summary>
        /// 返工订单 是否勾选项 0==不勾选 1==勾选，默认不勾选 
        ///</summary>
        [SugarColumn(ColumnName = "IS_RE_DO")]
        public short? IsReDo { get; set; }
    /// <summary>
    ///     返工订单 是否勾选项 0==不勾选 1==勾选，默认不勾选
    /// </summary>
    [SugarColumn(ColumnName = "IS_RE_DO")]
    public short? IsReDo { get; set; }

        /// <summary>
        /// 项目采购负责人 
        ///</summary>
        [SugarColumn(ColumnName = "PRIVATE_DESC_SEG1")]
        public string? PrivateDescSeg1 { get; set; }
    /// <summary>
    ///     项目采购负责人
    /// </summary>
    [SugarColumn(ColumnName = "PRIVATE_DESC_SEG1")]
    public string? PrivateDescSeg1 { get; set; }

        /// <summary>
        /// 单据版本 
        ///</summary>
        [SugarColumn(ColumnName = "VERSION")]
        public string? Version { get; set; }
    /// <summary>
    ///     单据版本
    /// </summary>
    [SugarColumn(ColumnName = "VERSION")]
    public string? Version { get; set; }

        /// <summary>
        /// 小米po号 
        ///</summary>
        [SugarColumn(ColumnName = "ZZPO_NO")]
        public string? ZzpoNo { get; set; }
    }
    /// <summary>
    ///     小米po号
    /// </summary>
    [SugarColumn(ColumnName = "ZZPO_NO")]
    public string? ZzpoNo { get; set; }
}