破坏实验添加

xwt

2025-06-27 c9481ef82ebf4095605f68695a1d02a252d33ff3

 StandardInterface/MES.Service/Modes/Womcab.cs

@@ -1,292 +1,313 @@
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     工单子表
/// </summary>
[SugarTable("WOMCAB")]
public class Womcab
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace MES.Service.Modes
{
    /// <summary>
    ///     自增列
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
        OracleSequenceName = "SEQ_CAB")]
    public decimal? Id { get; set; }
    /// 任务单物料表
    ///</summary>
    [SugarTable("WOMCAB")]
    public class Womcab
    {
        /// <summary>
        /// 自增列 
        ///</summary>
         [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true,  OracleSequenceName = "SEQ_CAB")]
         public decimal Id { get; set; }
        /// <summary>
        /// 生产用料清单行内码 
        ///</summary>
         [SugarColumn(ColumnName="ERPID"    )]
         public decimal? Erpid { get; set; }
        /// <summary>
        /// 工单单号 
        ///</summary>
         [SugarColumn(ColumnName="CAB001"    )]
         public string Cab001 { get; set; }
        /// <summary>
        /// 序号 
        ///</summary>
         [SugarColumn(ColumnName="CAB002"    )]
         public string Cab002 { get; set; }
        /// <summary>
        /// 材料编码 
        ///</summary>
         [SugarColumn(ColumnName="CAB003"    )]
         public string Cab003 { get; set; }
        /// <summary>
        /// 需领用量 
        ///</summary>
         [SugarColumn(ColumnName="CAB006"    )]
         public decimal? Cab006 { get; set; }
        /// <summary>
        /// 已领用量 
        ///</summary>
         [SugarColumn(ColumnName="CAB007"    )]
         public decimal? Cab007 { get; set; }
        /// <summary>
        /// 工艺 
        ///</summary>
         [SugarColumn(ColumnName="CAB008"    )]
         public string Cab008 { get; set; }
        /// <summary>
        /// 单位 
        ///</summary>
         [SugarColumn(ColumnName="CAB009"    )]
         public string Cab009 { get; set; }
        /// <summary>
        /// 组成用量 
        ///</summary>
         [SugarColumn(ColumnName="CAB012"    )]
         public decimal? Cab012 { get; set; }
        /// <summary>
        /// 是否替料 
        ///</summary>
         [SugarColumn(ColumnName="CAB014"    )]
         public decimal? Cab014 { get; set; }
        /// <summary>
        /// 生产订单行内码 
        ///</summary>
         [SugarColumn(ColumnName="PID"    )]
         public decimal? Pid { get; set; }
        /// <summary>
        /// 生产订单行内码 
        ///</summary>
         [SugarColumn(ColumnName="EID"    )]
         public decimal? Eid { get; set; }
        /// <summary>
        /// 位置号 
        ///</summary>
         [SugarColumn(ColumnName="POSITION_NO"    )]
         public string PositionNo { get; set; }
        /// <summary>
        /// 发料组织 
        ///</summary>
         [SugarColumn(ColumnName="ISSUING_ORGANIZATION"    )]
         public string IssuingOrganization { get; set; }
        /// <summary>
        /// 供应组织 
        ///</summary>
         [SugarColumn(ColumnName="SUPPLY_ORGANIZATION"    )]
         public string SupplyOrganization { get; set; }
        /// <summary>
        /// 货主 
        ///</summary>
         [SugarColumn(ColumnName="OWNER_ID"    )]
         public string OwnerId { get; set; }
        /// <summary>
        /// 计划跟踪号 
        ///</summary>
         [SugarColumn(ColumnName="MTONO"    )]
         public string Mtono { get; set; }
        /// <summary>
        /// 批号 
        ///</summary>
         [SugarColumn(ColumnName="LOT"    )]
         public string Lot { get; set; }
        /// <summary>
        /// 仓库 
        ///</summary>
         [SugarColumn(ColumnName="DEPOT_CODE"    )]
         public string DepotCode { get; set; }
        /// <summary>
        /// 发料方式 
        ///</summary>
         [SugarColumn(ColumnName="ISSUE_TYPE"    )]
         public string IssueType { get; set; }
        /// <summary>
        /// 供应类型 C采购 Z自制 W委外 
        ///</summary>
         [SugarColumn(ColumnName="SUPPLY_TYPE"    )]
         public string SupplyType { get; set; }
        /// <summary>
        /// 分子 
        ///</summary>
         [SugarColumn(ColumnName="NUMERATOR"    )]
         public decimal? Numerator { get; set; }
        /// <summary>
        /// 分母 
        ///</summary>
         [SugarColumn(ColumnName="DENOMINATOR"    )]
         public decimal? Denominator { get; set; }
        /// <summary>
        /// 固定损耗 
        ///</summary>
         [SugarColumn(ColumnName="SCRAPQTY"    )]
         public decimal? Scrapqty { get; set; }
        /// <summary>
        /// 变动损耗率 
        ///</summary>
         [SugarColumn(ColumnName="SCRAPRATE"    )]
         public decimal? Scraprate { get; set; }
        /// <summary>
        /// 销售订单号 
        ///</summary>
         [SugarColumn(ColumnName="SALES_ORDER"    )]
         public string SalesOrder { get; set; }
        /// <summary>
        /// 需求单据 
        ///</summary>
         [SugarColumn(ColumnName="F_WWC_TEXT1"    )]
         public string FWwcText1 { get; set; }
        /// <summary>
        /// 计划完工日期 
        ///</summary>
         [SugarColumn(ColumnName="F_WWC_DATE"    )]
         public DateTime? FWwcDate { get; set; }
        /// <summary>
        /// 旧物料编码 
        ///</summary>
         [SugarColumn(ColumnName="F_WWC_BASEPROPERTY"    )]
         public string FWwcBaseproperty { get; set; }
        /// <summary>
        /// 使用比例 
        ///</summary>
         [SugarColumn(ColumnName="FUSERATE"    )]
         public decimal? Fuserate { get; set; }
        /// <summary>
        /// 子项类型 1标准件 2返还件 3替代件 
        ///</summary>
         [SugarColumn(ColumnName="FMATERIALTYPE"    )]
         public decimal? Fmaterialtype { get; set; }
        /// <summary>
        /// 子项单位 
        ///</summary>
         [SugarColumn(ColumnName="FUNITID3"    )]
         public string Funitid3 { get; set; }
        /// <summary>
        /// 子项单位 
        ///</summary>
         [SugarColumn(ColumnName="FUNITID2"    )]
         public string Funitid2 { get; set; }
        /// <summary>
        /// 生产通知单 
        ///</summary>
         [SugarColumn(ColumnName="F_XIFG_BASE_RE5"    )]
         public string FXifgBaseRe5 { get; set; }
        /// <summary>
        /// 货主类型 
        ///</summary>
         [SugarColumn(ColumnName="FOWNERTYPEID"    )]
         public string Fownertypeid { get; set; }
        /// <summary>
        /// ERP生产订单分录内码 -- 委外新增 
        ///</summary>
         [SugarColumn(ColumnName="ERP_PRODUCTION_ENTRY_CODE"    )]
         public string ErpProductionEntryCode { get; set; }
        /// <summary>
        /// 用料清单备注 -- 委外新增 
        ///</summary>
         [SugarColumn(ColumnName="FMEMO"    )]
         public string Fmemo { get; set; }
        /// <summary>
        /// 预留类型 -- 委外新增 
        ///</summary>
         [SugarColumn(ColumnName="FRESERVETYPE"    )]
         public string Freservetype { get; set; }
        /// <summary>
        /// 需求日期 -- 委外新增 
        ///</summary>
         [SugarColumn(ColumnName="FNEEDDATE"    )]
         public DateTime? Fneeddate { get; set; }
        /// <summary>
        /// 库存状态 -- 委外新增 
        ///</summary>
         [SugarColumn(ColumnName="FSTOCKSTATUSID"    )]
         public string Fstockstatusid { get; set; }
        /// <summary>
        /// 拨出仓库 -- 委外新增 
        ///</summary>
         [SugarColumn(ColumnName="FSRCTRANSSTOCKID"    )]
         public string Fsrctransstockid { get; set; }
        /// <summary>
        /// 拨出组织 -- 委外新增 
        ///</summary>
         [SugarColumn(ColumnName="FSRCTRANSORGID"    )]
         public string Fsrctransorgid { get; set; }
        /// <summary>
        /// 是否关键件 -- 委外新增 
        ///</summary>
         [SugarColumn(ColumnName="FISKEYCOMPONENT"    )]
         public string Fiskeycomponent { get; set; }
        /// <summary>
        /// 是否发损耗 -- 委外新增 
        ///</summary>
         [SugarColumn(ColumnName="FISGETSCRAP"    )]
         public string Fisgetscrap { get; set; }
        /// <summary>
        /// 状态 
        ///</summary>
         [SugarColumn(ColumnName="WR_F_XIFG_BASE_83G"    )]
         public string WrFXifgBase83g { get; set; }
        /// <summary>
        /// 状态 
        ///</summary>
         [SugarColumn(ColumnName="WR_F_XIFG_BASE_QTR"    )]
         public string WrFXifgBaseQtr { get; set; }
        /// <summary>
        /// 状态 
        ///</summary>
         [SugarColumn(ColumnName="TYPEB"    )]
         public string Typeb { get; set; }
        /// <summary>
        /// 子项类型 1标准件 2返还件 3替代件 
        ///</summary>
         [SugarColumn(ColumnName="MATERIAL_TYPE"    )]
         public string MaterialType { get; set; }
        /// <summary>
        /// 使用比例（%） 
        ///</summary>
         [SugarColumn(ColumnName="USE_RATE"    )]
         public decimal? UseRate { get; set; }
        /// <summary>
        /// 项次号 
        ///</summary>
         [SugarColumn(ColumnName="FREPLACEGROUP"    )]
         public decimal? Freplacegroup { get; set; }
        /// <summary>
        /// 应发数量 
        ///</summary>
         [SugarColumn(ColumnName="MUST_QTY"    )]
         public decimal? MustQty { get; set; }
        /// <summary>
        /// 未领数 
        ///</summary>
         [SugarColumn(ColumnName="WLSL"    )]
         public string Wlsl { get; set; }

    /// <summary>
    ///     ERPID
    /// </summary>
    [SugarColumn(ColumnName = "ERPID")]
    public decimal? Erpid { get; set; }
        /// <summary>
        /// 客户物料代码 
        ///</summary>
        [SugarColumn(ColumnName = "KHWLBM")]
        public string Khwlbm { get; set; }

    /// <summary>
    ///     单号
    /// </summary>
    [SugarColumn(ColumnName = "CAB001")]
    public string? Cab001 { get; set; }
        /// <summary>
        /// 客户物料名称 
        ///</summary>
        [SugarColumn(ColumnName = "KHWLMC")]
        public string Khwlmc { get; set; }

    /// <summary>
    ///     序号
    /// </summary>
    [SugarColumn(ColumnName = "CAB002")]
    public string? Cab002 { get; set; }
        /// <summary>
        /// 需求组织 
        ///</summary>
        [SugarColumn(ColumnName = "XQZZ")]
        public string Xqzz { get; set; }

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

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

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

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

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

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

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

    /// <summary>
    ///     PID
    /// </summary>
    [SugarColumn(ColumnName = "PID")]
    public decimal? Pid { get; set; }

    /// <summary>
    ///     ERP头ID
    /// </summary>
    [SugarColumn(ColumnName = "EID")]
    public decimal? Eid { get; set; }

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

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

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

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

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

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

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

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

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

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

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

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

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


    /// <summary>
    ///     应发数量
    /// </summary>
    [SugarColumn(ColumnName = "Must_Qty")]
    public decimal? MustQty { get; set; }

    /// <summary>
    ///     项次号
    /// </summary>
    [SugarColumn(ColumnName = "FREPLACEGROUP")]
    public int? Freplacegroup { get; set; }

    /// <summary>
    ///     使用比例（%）
    /// </summary>
    [SugarColumn(ColumnName = "USE_RATE")]
    public decimal? UseRate { get; set; }

    /// <summary>
    ///     子项类型 1标准件 2返还件 3替代件
    /// </summary>
    [SugarColumn(ColumnName = "MATERIAL_TYPE")]
    public string? MaterialType { get; set; }

    /// <summary>
    ///     A，创建 B，审核中 C，已审核 D，重新审核 Z，暂存
    /// </summary>
    [SugarColumn(ColumnName = "TYPEB")]
    public string? Typeb { get; set; }


    /// <summary>
    ///     A，创建 B，审核中 C，已审核 D，重新审核 Z，暂存
    /// </summary>
    [SugarColumn(ColumnName = "WR_F_XIFG_BASE_QTR")]
    public string? WR_F_XIFG_Base_qtr { get; set; }

    /// <summary>
    ///     A，创建 B，审核中 C，已审核 D，重新审核 Z，暂存
    /// </summary>
    [SugarColumn(ColumnName = "WR_F_XIFG_BASE_83G")]
    public string? WR_F_XIFG_Base_83g { get; set; }


    /////----委外新增

    /// <summary>
    ///     是否发损耗 -- 委外新增
    /// </summary>
    [SugarColumn(ColumnName = "FISGETSCRAP")]
    public string? Fisgetscrap { get; set; }

    /// <summary>
    ///     是否关键件 -- 委外新增
    /// </summary>
    [SugarColumn(ColumnName = "FISKEYCOMPONENT")]
    public string? Fiskeycomponent { get; set; }

    /// <summary>
    ///     拨出组织 -- 委外新增
    /// </summary>
    [SugarColumn(ColumnName = "FSRCTRANSORGID")]
    public string? Fsrctransorgid { get; set; }

    /// <summary>
    ///     拨出仓库 -- 委外新增
    /// </summary>
    [SugarColumn(ColumnName = "FSRCTRANSSTOCKID")]
    public string? Fsrctransstockid { get; set; }

    /// <summary>
    ///     库存状态 -- 委外新增
    /// </summary>
    [SugarColumn(ColumnName = "FSTOCKSTATUSID")]
    public string? Fstockstatusid { get; set; }

    /// <summary>
    ///     需求日期 -- 委外新增
    /// </summary>
    [SugarColumn(ColumnName = "FNEEDDATE")]
    public DateTime? Fneeddate { get; set; }

    /// <summary>
    ///     预留类型 -- 委外新增
    /// </summary>
    [SugarColumn(ColumnName = "FRESERVETYPE")]
    public string? Freservetype { get; set; }

    /// <summary>
    ///     用料清单备注 -- 委外新增
    /// </summary>
    [SugarColumn(ColumnName = "FMEMO")]
    public string? Fmemo { get; set; }

    /// <summary>
    ///     ERP生产订单分录内码 -- 委外新增
    /// </summary>
    [SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
    public string? ErpProductionEntryCode { get; set; }

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

    /// <summary>
    ///     生产通知单
    /// </summary>
    [SugarColumn(ColumnName = "F_XIFG_BASE_RE5")]
    public string? F_XIFG_BASE_RE5 { get; set; }

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

    /// <summary>
    ///     子项单位
    /// </summary>
    [SugarColumn(ColumnName = "FUNITID3")]
    public string? FUNITID3 { get; set; }
}
        /// <summary>
        ///  需求部门
        ///</summary>
        [SugarColumn(ColumnName = "XQBM")]
        public string Xqbm { get; set; }
        /// <summary>
        ///  收料组织
        ///</summary>
        [SugarColumn(ColumnName = "SLZZ")]
        public string Slzz { get; set; }
        /// <summary>
        ///  收料部门
        ///</summary>
        [SugarColumn(ColumnName = "SLBM")]
        public string Slbm { get; set; }
    }
}