1.条码表实体类型调整 2.条码库存表实体新增基础字段 3.期初入库新增入库人

南骏 池

2025-02-13 eda0c8f74ce453b6e43f88fc92b1e651ce5b6095

 entity/Womcab.cs

@@ -1,213 +1,249 @@
using SqlSugar;

namespace NewPdaSqlServer.entity
namespace NewPdaSqlServer.entity;

/// <summary>
///     任务单物料表bom
/// </summary>
[SugarTable("WOMCAB")]
public class Womcab
{
    /// <summary>
    /// 任务单物料表
    ///</summary>
    [SugarTable("WOMCAB")]
    public class Womcab
    {
        /// <summary>
        ///  
        /// 默认值: (newid())
        ///</summary>
         [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true   )]
         public Guid Guid { get; set; }
        /// <summary>
        /// ERPID 
        ///</summary>
         [SugarColumn(ColumnName="ERPID"    )]
         public int? Erpid { get; set; }
        /// <summary>
        /// 工单单号 
        ///</summary>
         [SugarColumn(ColumnName="CAB001"    )]
         public string Cab001 { get; set; }
        /// <summary>
        /// 序号 
        ///</summary>
         [SugarColumn(ColumnName="CAB002"    )]
         public int? 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 string Cab014 { get; set; }
        /// <summary>
        /// PID 
        ///</summary>
         [SugarColumn(ColumnName="PID"    )]
         public int? Pid { get; set; }
        /// <summary>
        /// ERP头ID 
        ///</summary>
         [SugarColumn(ColumnName="EID"    )]
         public int? 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 string Numerator { get; set; }
        /// <summary>
        /// 分母 
        ///</summary>
         [SugarColumn(ColumnName="DENOMINATOR"    )]
         public string Denominator { get; set; }
        /// <summary>
        /// 固定损耗 
        ///</summary>
         [SugarColumn(ColumnName="SCRAPQTY"    )]
         public string Scrapqty { get; set; }
        /// <summary>
        /// 变动损耗率 
        ///</summary>
         [SugarColumn(ColumnName="SCRAPRATE"    )]
         public string Scraprate { get; set; }
        /// <summary>
        /// 客户货号 
        ///</summary>
         [SugarColumn(ColumnName="CUSTOMER_ITEM_NUMBER"    )]
         public string CustomerItemNumber { get; set; }
        /// <summary>
        /// 包装单号 
        ///</summary>
         [SugarColumn(ColumnName="PACKING_LIST_NUMBER"    )]
         public string PackingListNumber { get; set; }
        /// <summary>
        /// 主产品 
        ///</summary>
         [SugarColumn(ColumnName="MAIN_PRODUCT"    )]
         public string MainProduct { get; set; }
        /// <summary>
        /// 主产品数量 
        ///</summary>
         [SugarColumn(ColumnName="MAIN_PRODUCT_QTY"    )]
         public int? MainProductQty { get; set; }
        /// <summary>
        /// 父项物料名称 
        ///</summary>
         [SugarColumn(ColumnName="PARENT_ITEM_NAME"    )]
         public string ParentItemName { get; set; }
        /// <summary>
        /// 销售订单 
        ///</summary>
         [SugarColumn(ColumnName="FSALEORDERNO"    )]
         public string Fsaleorderno { get; set; }
        /// <summary>
        /// 货主类型 
        ///</summary>
         [SugarColumn(ColumnName="FOWNERTYPEID"    )]
         public string Fownertypeid { get; set; }
        /// <summary>
        /// 项次号 
        ///</summary>
         [SugarColumn(ColumnName="FREPLACEGROUP"    )]
         public int? Freplacegroup { get; set; }
        /// <summary>
        /// 销售订单号 
        ///</summary>
         [SugarColumn(ColumnName="ERP_XSDDH"    )]
         public string ErpXsddh { get; set; }
        /// <summary>
        /// 子项类型 
        ///</summary>
         [SugarColumn(ColumnName="FMATERIALTYPE"    )]
         public string Fmaterialtype { get; set; }
        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="FUNITID"    )]
         public string Funitid { get; set; }
        /// <summary>
        /// 应发数量 
        ///</summary>
         [SugarColumn(ColumnName="Must_Qty"    )]
         public decimal? MustQty { 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; }
    }
}
    ///     默认值: (newid())
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid Guid { get; set; }

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

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

    /// <summary>
    ///     序号
    /// </summary>
    [SugarColumn(ColumnName = "CAB002")]
    public int? 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 string Cab014 { get; set; }

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

    /// <summary>
    ///     ERP头ID
    /// </summary>
    [SugarColumn(ColumnName = "EID")]
    public int? 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>
    ///     发料方式 1、直接领料；2、直接倒冲；3、调拨领料；4、调拨到冲；7、不发料
    /// </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 string Numerator { get; set; }

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

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

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

    /// <summary>
    ///     客户货号
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")]
    public string CustomerItemNumber { get; set; }

    /// <summary>
    ///     包装单号
    /// </summary>
    [SugarColumn(ColumnName = "PACKING_LIST_NUMBER")]
    public string PackingListNumber { get; set; }

    /// <summary>
    ///     主产品
    /// </summary>
    [SugarColumn(ColumnName = "MAIN_PRODUCT")]
    public string MainProduct { get; set; }

    /// <summary>
    ///     主产品数量
    /// </summary>
    [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")]
    public int? MainProductQty { get; set; }

    /// <summary>
    ///     父项物料名称
    /// </summary>
    [SugarColumn(ColumnName = "PARENT_ITEM_NAME")]
    public string ParentItemName { get; set; }

    /// <summary>
    ///     销售订单
    /// </summary>
    [SugarColumn(ColumnName = "FSALEORDERNO")]
    public string Fsaleorderno { get; set; }

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

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

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

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

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "FUNITID")]
    public string Funitid { get; set; }

    /// <summary>
    ///     应发数量
    /// </summary>
    [SugarColumn(ColumnName = "Must_Qty")]
    public decimal? MustQty { 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; }
}