base_material.cs 4.69 KB
using System;
using SqlSugar;
using System.ComponentModel.DataAnnotations.Schema;

namespace Hh.Mes.POJO.Entity
{
    public partial class base_material : base_Entity
    {
        /// <summary>
        /// 主键
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        public int id { get; set; }

        /// <summary>
        /// Key值
        /// </summary>
        [SugarColumn(ColumnDescription = "Key值", IsNullable = true)]
        public Guid keys { get; set; }

        /// <summary>
        /// 物料编码
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "物料编码", IsNullable = true)]
        public string materialCode { get; set; }

        /// <summary>
        /// 物料名称
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "物料名称", IsNullable = true)]
        public string materialName { get; set; }

        /// <summary>
        /// 物料对应的PLC编码
        /// </summary>
        [SugarColumn(ColumnDescription = "物料对应的PLC编码", IsNullable = true)]
        public int typesPlcCode { get; set; }

        /// <summary>
        /// 物料类别 物料类别 对应 base_material_type
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "物料类别", IsNullable = true)]
        public string mtTypeCode { get; set; }


        /// <summary>
        /// 物料分类 法兰、管件、弯通等等
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "物料分类", IsNullable = true)]
        public string mtClassify { get; set; }

        /// <summary>
        /// 物料 材质
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "材质", IsNullable = true)]
        public string types { get; set; }

        /// <summary>
        /// 物料 直径
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "直径", IsNullable = true)]
        public string diameter { get; set; }

        /// <summary>
        /// 物料 壁厚
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "壁厚", IsNullable = true)]
        public string thickness { get; set; }

        /// <summary>
        /// 单位
        /// </summary>
        [SugarColumn(Length = 100, IsNullable = true)]
        public string unitCode { get; set; }

        /// <summary>
        /// 唯一标识
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "唯一标识", IsNullable = true)]
        public string plmeId { get; set; }

        /// <summary>
        /// 工厂编码/供应商编码
        /// </summary>
        [SugarColumn(Length = 50, ColumnDescription = "工厂编码/供应商编码", IsNullable = true)]
        public string factoryCode { get; set; }

        /// <summary>
        /// 规格
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "规格", IsNullable = true)]
        public string specifications { get; set; }

        /// <summary>
        /// 扩展字段
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "扩展字段", IsNullable = true)]
        public string extend1 { get; set; }

        /// <summary>
        /// 扩展字段
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "扩展字段", IsNullable = true)]
        public string extend2 { get; set; }

        /// <summary>
        /// 精追件标识
        /// </summary>
        public string crux { get; set; }

        /// <summary>
        /// 实际重量
        /// </summary>
        public string weight { get; set; }


        /// <summary>
        /// 生协/采购属性
        /// <code>
        /// F:采购
        /// E:自制
        /// 自制/采购:E/F
        /// 虚拟件:X
        /// 非库存:N
        /// 外协:W
        /// </code>
        public string procurement { get; set; }

        /// <summary>
        /// 外部编码
        /// </summary>
        public string otherCode { get; set; }


        /// <summary>
        /// 工序  生产计划用于生产工序任务明细匹配
        /// </summary>
        //public string oprSequenceCode { get; set; }


        /// <summary>
        /// 是否有效 : 1=有效, 0=无效
        /// </summary>
        [SugarColumn(ColumnDescription = "是否有效 : 1=有效, 0=无效", IsNullable = true)]
        public int isDelete { get; set; }

        [SugarColumn(IsNullable = true)]
        public DateTime createTime { get; set; }

        [SugarColumn(Length = 80, IsNullable = true)]
        public string createBy { get; set; }

        [SugarColumn(IsNullable = true)]
        public DateTime updateTime { get; set; }

        [SugarColumn(Length = 80, IsNullable = true)]
        public string updateBy { get; set; }

        [SugarColumn(Length = 80, IsNullable = true)]
        public string materialType { get; set; }
    }
}