FactorySystemApi/FactorySystemModel/SqlSugarModel/TFS_Material.cs

using System;
using System.Linq;
using System.Text;
using SqlSugar;

namespace FactorySystemModel.SqlSugarModel
{
    ///<summary>
    ///物料表
    ///</summary>
    [SugarTable("TFS_Material")]
    public partial class TFS_Material
    {
        public TFS_Material()
        {


        }
        /// <summary>
        /// Desc:唯一标识
        /// Default:
        /// Nullable:False
        /// </summary>           
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        public int FID { get; set; }

        /// <summary>
        /// Desc:名称
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FName { get; set; }


        /// <summary>
        /// Desc:一级分类
        /// Default:
        /// Nullable:False
        /// </summary>           
        public int FTypeID1 { get; set; }

        /// <summary>
        /// Desc:二级分类
        /// Default:
        /// Nullable:False
        /// </summary>           
        public int FTypeID2 { get; set; }
        /// <summary>
        /// Desc:一级分类
        /// </summary>       
        [SugarColumn(IsIgnore = true)]
        public string FTypeName1 { get; set; }
        /// <summary>
        /// Desc:二级分类
        /// </summary>       
        [SugarColumn(IsIgnore = true)]
        public string FTypeName2 { get; set; }
        /// <summary>
        /// Desc:描述
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FDesc { get; set; }

        /// <summary>
        /// Desc:物料类型（产品分类）：TBasicCode.FType=32
        /// Default:-1
        /// Nullable:False
        /// </summary>           
        public string FType { get; set; }

        /// <summary>
        /// Desc:物料编码
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FCode { get; set; }

        /// <summary>
        /// Desc:试验号
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FTestCode { get; set; }

        /// <summary>
        /// Desc:版本号
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FVersionCode { get; set; }

        /// <summary>
        /// Desc:工厂ID
        /// Default:-1
        /// Nullable:False
        /// </summary>           
        public int FFactoryID { get; set; }

        /// <summary>
        /// Desc:工厂标识
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FFactoryCode { get; set; }

        /// <summary>
        /// Desc:替代料ID
        /// Default:-1
        /// Nullable:False
        /// </summary>           
        public int FSuccedaneumID { get; set; }

        /// <summary>
        /// Desc:替代品描述
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FSuccedaneumInfo { get; set; }

        /// <summary>
        /// Desc:替代品分类
        /// Default:-1
        /// Nullable:False
        /// </summary>           
        public string FSuccedaneumType { get; set; }

        /// <summary>
        /// Desc:替代品编码
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FSuccedaneumCode { get; set; }

        /// <summary>
        /// Desc:副产物ID
        /// Default:
        /// Nullable:False
        /// </summary>           
        public int FFuProductsID { get; set; }

        /// <summary>
        /// Desc:副产物信息
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FFuProductsInfo { get; set; }

        /// <summary>
        /// Desc:副产物分类
        /// Default:-1
        /// Nullable:False
        /// </summary>           
        public string FFuProductsType { get; set; }

        /// <summary>
        /// Desc:副产物数量
        /// Default:-1
        /// Nullable:False
        /// </summary>           
        public string FFuProductsCount { get; set; }

        /// <summary>
        /// Desc:副产物编码
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FFuProductsCode { get; set; }

        /// <summary>
        /// Desc:副产物单位
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FFuProductsUnit { get; set; }

        /// <summary>
        /// Desc:PLM内码
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FPlmCode { get; set; }

        /// <summary>
        /// Desc:PLM名称
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FPlmName { get; set; }

        /// <summary>
        /// Desc:物料供应标识
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FSupplyCode { get; set; }

        /// <summary>
        /// Desc:总仓地址
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FStoreHouse { get; set; }

        /// <summary>
        /// Desc:组件损耗率
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FAssemblyLost { get; set; }

        /// <summary>
        /// Desc:工作中心
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FWorkCenter { get; set; }

        /// <summary>
        /// Desc:工艺路线描述
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FCraftPathDesc { get; set; }

        /// <summary>
        /// Desc:工艺描述
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FCraftDesc { get; set; }

        /// <summary>
        /// Desc:工艺说明
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FCraftExplain { get; set; }

        /// <summary>
        /// Desc:线边仓
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FLineHouse { get; set; }

        /// <summary>
        /// Desc:固定损耗
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FFixedLoss { get; set; }

        /// <summary>
        /// Desc:基本计量单位
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FBaseUnit { get; set; }

        /// <summary>
        /// Desc:物料组
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FMaterialGroup { get; set; }

        /// <summary>
        /// Desc:删除状态：1删除，0未删除
        /// Default:0
        /// Nullable:False
        /// </summary>           
        public int FDeleted { get; set; }

        /// <summary>
        /// Desc:添加时间
        /// Default:DateTime.Now
        /// Nullable:False
        /// </summary>           
        public DateTime? FAddDate { get; set; }

        /// <summary>
        /// Desc:修改人
        /// Default:-1
        /// Nullable:False
        /// </summary>           
        public int FEditUser { get; set; }

        /// <summary>
        /// Desc:修改时间
        /// Default:DateTime.Now
        /// Nullable:False
        /// </summary>           
        public DateTime? FEditDate { get; set; }

        /// <summary>
        /// Desc:物料类型
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FMaterialType { get; set; }

        /// <summary>
        /// Desc:Fame号
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FFameCode { get; set; }

        /// <summary>
        /// Desc:K3系统代码
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FK3Code { get; set; }

        /// <summary>
        /// Desc:K3系统名称
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FK3Name { get; set; }

        /// <summary>
        /// Desc:K3系统短代码
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FK3ShortCode { get; set; }

        /// <summary>
        /// Desc:主产物数量
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FMainProductsCount { get; set; }

        /// <summary>
        /// Desc:主产物单位
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FMainProductsUnit { get; set; }

        /// <summary>
        /// 父物料ID（仅下载BOM使用、梳理值）
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public int FParentID { get; set; }
        /// <summary>
        /// 旧物料ID（仅下载BOM使用、梳理值）
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public int FOldID { get; set; }
        /// <summary>
        /// 是否是新（仅下载BOM使用、判断值）
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public bool FIsNew { get; set; }
        /// <summary>
        /// 层级数据（仅下载BOM使用、梳理值）
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public int FLevelID { get; set; }

        /// <summary>
        /// Desc:客供料标识
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FCustomerCode { get; set; }

        /// <summary>
        /// Desc:BOM录入情况
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FBomEntry { get; set; }

        /// <summary>
        /// Desc:产品说明
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FProductDesc { get; set; }

        /// <summary>
        /// Desc:标识符
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FIidentifier { get; set; }

        /// <summary>
        /// Desc:保质期
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FGuaranteePeriod { get; set; }

        /// <summary>
        /// Desc:存储条件
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FBStorageConditions { get; set; }

        /// <summary>
        /// Desc:安全库存
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FSafetyStock { get; set; }

        /// <summary>
        /// Desc:触发比例
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FTriggerRatio { get; set; }

        /// <summary>
        /// Desc:最小量
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FMinAmount { get; set; }

        /// <summary>
        /// Desc:最大量
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FMaxAmount { get; set; }

        /// <summary>
        /// Desc:得率
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FYield { get; set; }

        /// <summary>
        /// Desc:理论得率
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FTheoryYield { get; set; }

        /// <summary>
        /// Desc:品质检验1
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FQualityTest1 { get; set; }

        /// <summary>
        /// Desc:品质检验2
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FQualityTest2 { get; set; }

        /// <summary>
        /// Desc:关联物料代码
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FRelationCode { get; set; }

        /// <summary>
        /// Desc:关联物料名称
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FRelationName { get; set; }

        /// <summary>
        /// Desc:SAP系统代码
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FSAPCode { get; set; }

        /// <summary>
        /// Desc:SAP系统描述
        /// Default:
        /// Nullable:False
        /// </summary>           
        public string FSAPDescription { get; set; }
        /// <summary>
        /// 接收旧码字段
        /// </summary>
        public string OldCode { get; set; }
    }
}