委外订单接口更新

啊鑫

2024-09-25 e08786579903aba72be57fab1024980bf737dfbd

 MES.Service/Modes/ProductionOrderSub.cs

@@ -1,209 +1,209 @@
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     生产订单表(委外)子表
/// </summary>
[SugarTable("PRODUCTION_ORDER_SUB")]
public class ProductionOrderSub
namespace MES.Service.Modes
{
    /// <summary>
    ///     SEQ_ORDER
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ORDER",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }
    /// 生产订单表(委外)子表
    ///</summary>
    [SugarTable("PRODUCTION_ORDER_SUB")]
    public class ProductionOrderSub
    {
        /// <summary>
        /// SEQ_ORDER 
        ///</summary>
        [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_ORDER", IsPrimaryKey = true)]
        public decimal Id { get; set; }

    /// <summary>
    ///     工单单号
    /// </summary>
    [SugarColumn(ColumnName = "WORK_ORDER_NO")]
    public string? WorkOrderNo { get; set; }
        /// <summary>
        /// 工单单号 
        ///</summary>
        [SugarColumn(ColumnName = "WORK_ORDER_NO")]
        public string? WorkOrderNo { get; set; }

    /// <summary>
    ///     序号
    /// </summary>
    [SugarColumn(ColumnName = "SEQUENCE_NO")]
    public long? SequenceNo { get; set; }
        /// <summary>
        /// 序号 
        ///</summary>
        [SugarColumn(ColumnName = "SEQUENCE_NO")]
        public long? SequenceNo { get; set; }

    /// <summary>
    ///     材料编码
    /// </summary>
    [SugarColumn(ColumnName = "MATERIAL_CODE")]
    public string? MaterialCode { get; set; }
        /// <summary>
        /// 材料编码 
        ///</summary>
        [SugarColumn(ColumnName = "MATERIAL_CODE")]
        public string? MaterialCode { get; set; }

    /// <summary>
    ///     需领用量
    /// </summary>
    [SugarColumn(ColumnName = "REQUIRED_QTY")]
    public decimal? RequiredQty { get; set; }
        /// <summary>
        /// 需领用量 
        ///</summary>
        [SugarColumn(ColumnName = "REQUIRED_QTY")]
        public double? RequiredQty { get; set; }

    /// <summary>
    ///     已领用量
    /// </summary>
    [SugarColumn(ColumnName = "ISSUED_QTY")]
    public decimal? IssuedQty { get; set; }
        /// <summary>
        /// 已领用量 
        ///</summary>
        [SugarColumn(ColumnName = "ISSUED_QTY")]
        public decimal? IssuedQty { get; set; }

    /// <summary>
    ///     位置号
    /// </summary>
    [SugarColumn(ColumnName = "LOCATION_NO")]
    public string? LocationNo { get; set; }
        /// <summary>
        /// 位置号 
        ///</summary>
        [SugarColumn(ColumnName = "LOCATION_NO")]
        public string? LocationNo { get; set; }

    /// <summary>
    ///     供应组织
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLYING_ORG")]
    public string? SupplyingOrg { get; set; }
        /// <summary>
        /// 供应组织 
        ///</summary>
        [SugarColumn(ColumnName = "SUPPLYING_ORG")]
        public string? SupplyingOrg { get; set; }

    /// <summary>
    ///     发料组织
    /// </summary>
    [SugarColumn(ColumnName = "ISSUING_ORG")]
    public string? IssuingOrg { get; set; }
        /// <summary>
        /// 发料组织 
        ///</summary>
        [SugarColumn(ColumnName = "ISSUING_ORG")]
        public string? IssuingOrg { get; set; }

    /// <summary>
    ///     货主
    /// </summary>
    [SugarColumn(ColumnName = "STOCK_OWNER")]
    public string? StockOwner { get; set; }
        /// <summary>
        /// 货主 
        ///</summary>
        [SugarColumn(ColumnName = "STOCK_OWNER")]
        public string? StockOwner { get; set; }

    /// <summary>
    ///     计划跟踪号
    /// </summary>
    [SugarColumn(ColumnName = "TRACKING_NO")]
    public string? TrackingNo { get; set; }
        /// <summary>
        /// 计划跟踪号 
        ///</summary>
        [SugarColumn(ColumnName = "TRACKING_NO")]
        public string? TrackingNo { get; set; }

    /// <summary>
    ///     批号
    /// </summary>
    [SugarColumn(ColumnName = "BATCH_NO")]
    public string? BatchNo { get; set; }
        /// <summary>
        /// 批号 
        ///</summary>
        [SugarColumn(ColumnName = "BATCH_NO")]
        public string? BatchNo { get; set; }

    /// <summary>
    ///     仓库
    /// </summary>
    [SugarColumn(ColumnName = "WAREHOUSE")]
    public string? Warehouse { get; set; }
        /// <summary>
        /// 仓库 
        ///</summary>
        [SugarColumn(ColumnName = "WAREHOUSE")]
        public string? Warehouse { get; set; }

    /// <summary>
    ///     发料方式
    /// </summary>
    [SugarColumn(ColumnName = "ISSUING_METHOD")]
    public string? IssuingMethod { get; set; }
        /// <summary>
        /// 发料方式 
        ///</summary>
        [SugarColumn(ColumnName = "ISSUING_METHOD")]
        public string? IssuingMethod { get; set; }

    /// <summary>
    ///     工艺
    /// </summary>
    [SugarColumn(ColumnName = "PROCESS")]
    public string? Process { get; set; }
        /// <summary>
        /// 工艺 
        ///</summary>
        [SugarColumn(ColumnName = "PROCESS")]
        public string? Process { get; set; }

    /// <summary>
    ///     单位
    /// </summary>
    [SugarColumn(ColumnName = "UNIT")]
    public string? Unit { get; set; }
        /// <summary>
        /// 单位 
        ///</summary>
        [SugarColumn(ColumnName = "UNIT")]
        public string? Unit { get; set; }

    /// <summary>
    ///     供应类型
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLYING_TYPE")]
    public string? SupplyingType { get; set; }
        /// <summary>
        /// 供应类型 
        ///</summary>
        [SugarColumn(ColumnName = "SUPPLYING_TYPE")]
        public string? SupplyingType { get; set; }

    /// <summary>
    ///     组成用量
    /// </summary>
    [SugarColumn(ColumnName = "COMPOSITION_QTY")]
    public decimal? CompositionQty { get; set; }
        /// <summary>
        /// 组成用量 
        ///</summary>
        [SugarColumn(ColumnName = "COMPOSITION_QTY")]
        public decimal? CompositionQty { get; set; }

    /// <summary>
    ///     是否替料
    /// </summary>
    [SugarColumn(ColumnName = "IS_SUBSTITUTE")]
    public string? IsSubstitute { get; set; }
        /// <summary>
        /// 是否替料 
        ///</summary>
        [SugarColumn(ColumnName = "IS_SUBSTITUTE")]
        public string? IsSubstitute { get; set; }

    /// <summary>
    ///     分子
    /// </summary>
    [SugarColumn(ColumnName = "NUMERATOR")]
    public long? Numerator { get; set; }
        /// <summary>
        /// 分子 
        ///</summary>
        [SugarColumn(ColumnName = "NUMERATOR")]
        public double? Numerator { get; set; }

    /// <summary>
    ///     分母
    /// </summary>
    [SugarColumn(ColumnName = "DENOMINATOR")]
    public long? Denominator { get; set; }
        /// <summary>
        /// 分母 
        ///</summary>
        [SugarColumn(ColumnName = "DENOMINATOR")]
        public double? Denominator { get; set; }

    /// <summary>
    ///     ERPID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_ID")]
    public string? ErpId { get; set; }
        /// <summary>
        /// ERPID 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_ID")]
        public string? ErpId { get; set; }

    /// <summary>
    ///     ERP头ID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_HEADER_ID")]
    public string? ErpHeaderId { get; set; }
        /// <summary>
        /// ERP头ID 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_HEADER_ID")]
        public string? ErpHeaderId { get; set; }

    /// <summary>
    ///     固定损耗
    /// </summary>
    [SugarColumn(ColumnName = "FIXED_LOSS")]
    public decimal? FixedLoss { get; set; }
        /// <summary>
        /// 固定损耗 
        ///</summary>
        [SugarColumn(ColumnName = "FIXED_LOSS")]
        public decimal? FixedLoss { get; set; }

    /// <summary>
    ///     变动损耗率%
    /// </summary>
    [SugarColumn(ColumnName = "VARIABLE_LOSS_RATE")]
    public string? VariableLossRate { get; set; }
        /// <summary>
        /// 变动损耗率% 
        ///</summary>
        [SugarColumn(ColumnName = "VARIABLE_LOSS_RATE")]
        public string? VariableLossRate { get; set; }

    /// <summary>
    ///     子项类型
    /// </summary>
    [SugarColumn(ColumnName = "SUB_ITEM_TYPE")]
    public string? SubItemType { get; set; }
        /// <summary>
        /// 子项类型 
        ///</summary>
        [SugarColumn(ColumnName = "SUB_ITEM_TYPE")]
        public string? SubItemType { get; set; }

    /// <summary>
    ///     子项单位
    /// </summary>
    [SugarColumn(ColumnName = "SUB_ITEM_UNIT")]
    public string? SubItemUnit { get; set; }
        /// <summary>
        /// 子项单位 
        ///</summary>
        [SugarColumn(ColumnName = "SUB_ITEM_UNIT")]
        public string? SubItemUnit { get; set; }

    /// <summary>
    ///     销售订单号
    /// </summary>
    [SugarColumn(ColumnName = "SALES_ORDER_NO")]
    public string? SalesOrderNo { get; set; }
        /// <summary>
        /// 销售订单号 
        ///</summary>
        [SugarColumn(ColumnName = "SALES_ORDER_NO")]
        public string? SalesOrderNo { get; set; }

    /// <summary>
    ///     项次号
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NO")]
    public string? ItemNo { get; set; }
        /// <summary>
        /// 项次号 
        ///</summary>
        [SugarColumn(ColumnName = "ITEM_NO")]
        public string? ItemNo { get; set; }

    /// <summary>
    ///     发料组织
    /// </summary>
    [SugarColumn(ColumnName = "ISSUING_ORG_2")]
    public string? IssuingOrg2 { get; set; }
        /// <summary>
        /// 发料组织 
        ///</summary>
        [SugarColumn(ColumnName = "ISSUING_ORG_2")]
        public string? IssuingOrg2 { get; set; }

    /// <summary>
    ///     货主类型
    /// </summary>
    [SugarColumn(ColumnName = "OWNER_TYPE")]
    public string? OwnerType { get; set; }
        /// <summary>
        /// 货主类型 
        ///</summary>
        [SugarColumn(ColumnName = "OWNER_TYPE")]
        public string? OwnerType { get; set; }

    /// <summary>
    ///     货主
    /// </summary>
    [SugarColumn(ColumnName = "OWNER")]
    public string? Owner { get; set; }
        /// <summary>
        /// 货主 
        ///</summary>
        [SugarColumn(ColumnName = "OWNER")]
        public string? Owner { get; set; }

    /// <summary>
    ///     供应组织
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLYING_ORG_2")]
    public string? SupplyingOrg2 { get; set; }
        /// <summary>
        /// 供应组织 
        ///</summary>
        [SugarColumn(ColumnName = "SUPPLYING_ORG_2")]
        public string? SupplyingOrg2 { get; set; }
    }
}