DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/MES/IC/ic_item.cs

using Business.Core.Attributes;
using Microsoft.EntityFrameworkCore;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;

namespace Business.Domain
{
    /// <summary>
    /// 物料详情
    /// </summary>
    [CollectionName("dopbase", "ic_item")]
    [Comment("物料详情")]
    [Index(nameof(number), nameof(fversion), nameof(tenant_id), nameof(company_id), nameof(factory_id), IsUnique = true)]
    public class ic_item : BaseEntity
    {
        public ic_item(long Id) : base(Id)
        {
        }
        /// <summary>
        /// 物料编码
        /// </summary>
        [StringLength(80)]
        [Comment("物料编码")]
        public string number { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        [StringLength(80)]
        [Comment("物料名称")]
        public string name { get; set; }
        /// <summary>
        /// 规格型号
        /// </summary>
        [StringLength(200)]
        [Comment("规格型号")]
        public string model { get; set; }
        /// <summary>
        /// 全名
        /// </summary>
        [StringLength(255)]
        [Comment("全名")]
        public string full_name { get; set; }
        /// <summary>
        /// fms旧料号
        /// </summary>
        [StringLength(80)]
        [Comment("fms旧料号")]
        public string fms_number { get; set; }
        /// <summary>
        /// erp旧料号
        /// </summary>
        [StringLength(80)]
        [Comment("erp旧料号")]
        public string erp_oldnumber { get; set; }
        /// <summary>
        /// 图号
        /// </summary>
        [StringLength(80)]
        [Comment("图号")]
        public string chart_number { get; set; }
        /// <summary>
        /// 版本号
        /// </summary>
        [StringLength(80)]
        [Comment("版本号")]
        public string fversion { get; set; }
        /// <summary>
        /// 盒贴规格
        /// </summary>
        [StringLength(200)]
        [Comment("盒贴规格")]
        public string box_model { get; set; }
        /// <summary>
        /// 物料属性
        /// </summary>
        [Comment("物料属性")]
        public int? erp_cls { get; set; }
        /// <summary>
        /// 物料属性名称
        /// </summary>
        [StringLength(80)]
        [Comment("物料属性")]
        public string erp_cls_name { get; set; }
        /// <summary>
        /// 单位
        /// </summary>
        [StringLength(80)]
        [Comment("单位")]
        public string unit { get; set; }
        /// <summary>
        /// 物料等级
        /// </summary>
        [Comment("物料等级")]
        public long? item_level { get; set; }

        /// <summary>
        /// 单位标准工时_小时
        /// </summary>
        [Precision(23, 10)]
        [Comment("单位标准工时_小时")]
        public decimal? standard_manhour { get; set; }
        /// <summary>
        /// 单位材料定额_元
        /// </summary>
        [Precision(23, 10)]
        [Comment("单位材料定额_元")]
        public decimal? unititem_amount { get; set; }
        /// <summary>
        /// 来源
        /// </summary>
        [StringLength(200)]
        [Comment("来源")]
        public string source { get; set; }
        /// <summary>
        /// 是否为设备
        /// </summary>
        [Comment("是否为设备")]
        public int? is_equipment { get; set; }
        /// <summary>
        /// 单位包装数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("单位包装数量")]
        public decimal? unit_qty { get; set; }

        /// <summary>
        /// 是否关键件
        /// </summary>
        [Comment("是否关键件")]
        public int? iskeyitem { get; set; }
        /// <summary>
        /// 毛重
        /// </summary>
        [Precision(23, 10)]
        [Comment("毛重")]
        public decimal? gross_weight { get; set; }
        /// <summary>
        /// 净重
        /// </summary>
        [Precision(23, 10)]
        [Comment("净重")]
        public decimal? net_weight { get; set; }
        /// <summary>
        /// 重量单位
        /// </summary>
        [StringLength(80)]
        [Comment("重量单位")]
        public string maund { get; set; }
        /// <summary>
        /// 长度
        /// </summary>
        [Precision(23, 10)]
        [Comment("长度")]
        public decimal? length { get; set; }
        /// <summary>
        /// 长度单位
        /// </summary>
        [StringLength(80)]
        [Comment("长度单位")]
        public string cubic_measure { get; set; }
        /// <summary>
        /// 宽度
        /// </summary>
        [Precision(23, 10)]
        [Comment("宽度")]
        public decimal? width { get; set; }
        /// <summary>
        /// 高度
        /// </summary>
        [Precision(23, 10)]
        [Comment("高度")]
        public decimal? height { get; set; }
        /// <summary>
        /// 体积
        /// </summary>
        [Precision(23, 10)]
        [Comment("体积")]
        public decimal? size { get; set; }

        /// <summary>
        /// 允许采购
        /// </summary>
        [Comment("允许采购")]
        public int? allowpur { get; set; }
        /// <summary>
        /// 允许销售
        /// </summary>
        [Comment("允许销售")]
        public int? allowsale { get; set; }
        /// <summary>
        /// 允许生产
        /// </summary>
        [Comment("允许生产")]
        public int? allowmanu { get; set; }
        /// <summary>
        /// 允许委外
        /// </summary>
        [Comment("允许委外")]
        public int? allowout { get; set; }
        /// <summary>
        /// 批号管理
        /// </summary>
        [Comment("批号管理")]
        public int? allowbatch { get; set; }
        /// <summary>
        /// 序列号管理
        /// </summary>
        [Comment("序列号管理")]
        public int? allowserial { get; set; }
        /// <summary>
        /// 图片
        /// </summary>
        [StringLength(80)]
        [Comment("图片")]
        public string photo { get; set; }
        /// <summary>
        /// 领料类型
        /// </summary>
        [Comment("领料类型")]
        public long? picktype { get; set; }
        /// <summary>
        /// 出库类型
        /// </summary>
        [Comment("出库类型")]
        public long? output_type_id { get; set; }
        /// <summary>
        /// 启用预警
        /// </summary>
        [Comment("启用预警")]
        public int? enable_warning { get; set; }

        /// <summary>
        /// 生命周期状态:1-成熟品,2-新品,3-重点新品,4-退市
        /// </summary>
        [Comment("生命周期状态")]
        public int? life_state { get; set; }

        /// <summary>
        /// 经济生产批量
        /// </summary>
        [Comment("经济生产批量")]
        [Precision(23, 10)]
        public decimal? moq { get; set; }

        /// <summary>
        /// 最大生产批量
        /// </summary>
        [Comment("最大生产批量")]
        [Precision(23, 10)]
        public decimal? maq { get; set; }

        /// <summary>
        /// 是否备料前预处理
        /// </summary>
        [Comment("是否备料前预处理")]
        public int? is_clean { get; set; }

        /// <summary>
        /// 预处理提前期(天)
        /// </summary>
        [Comment("预处理提前期")]
        [Precision(23, 10)]
        public decimal? clean_leadtime { get; set; }

        /// <summary>
        /// 工序委外提前期/灭菌提前期(天)
        /// </summary>
        [Comment("工序委外提前期")]
        [Precision(23, 10)]
        public decimal? sterilize_leadtime { get; set; }

        /// <summary>
        /// 平台调拨提前期(天)
        /// </summary>
        [Comment("平台调拨提前期")]
        [Precision(23, 10)]
        public decimal? transfer_leadtime { get; set; }

        /// <summary>
        /// 标准工期(天)
        /// </summary>
        [Comment("标准工期")]
        [Precision(23, 10)]
        public decimal? standard_period { get; set; }

        /// <summary>
        /// FMR分类:F-F类,M-M类,R-R类
        /// </summary>
        [Comment("FMR分类")]
        public string fmr { get; set; }

        /// <summary>
        /// ABC分类:A-A类,B-B类,C-C类
        /// </summary>
        [Comment("ABC分类")]
        public string abc { get; set; }


        //ic_plan
        ///// <summary>
        ///// 物料id
        ///// </summary>
        //[Required]
        //[Comment("物料id")]
        //public long icitem_id { get; set; }
        ///// <summary>
        ///// 物料名称
        ///// </summary>
        //[StringLength(80)]
        //[Comment("物料名称")]
        //public string? icitem_name { get; set; }
        ///// <summary>
        ///// 计划员
        ///// </summary>
        //[StringLength(80)]
        //[Comment("计划员")]
        //public string? planner_name { get; set; }
        ///// <summary>
        ///// 计划员_工号
        ///// </summary>
        //[StringLength(80)]
        //[Comment("计划员_工号")]
        //public string? planner_num { get; set; }
        ///// <summary>
        ///// 工厂编码
        ///// </summary>
        //[StringLength(80)]
        //[Comment("工厂编码")]
        //public string? factory_code { get; set; }
        /// <summary>
        /// 固定提前期(天)
        /// </summary>
        [Precision(23, 10)]
        [Comment("固定提前期(天)")]
        public decimal? fix_leadtime { get; set; }
        /// <summary>
        /// 计划策略
        /// </summary>
        [Comment("计划策略")]
        public int? plan_trategy { get; set; }
        /// <summary>
        /// 订货策略
        /// </summary>
        [Comment("订货策略")]
        public int? order_trategy { get; set; }
        /// <summary>
        /// 订货间隔期_天
        /// </summary>
        [Precision(23, 10)]
        [Comment("订货间隔期_天")]
        public decimal? order_inter_val { get; set; }
        /// <summary>
        /// 变动提前期
        /// </summary>
        [Precision(23, 10)]
        [Comment("变动提前期")]
        public decimal? lead_time { get; set; }
        /// <summary>
        /// 变动提前期批量
        /// </summary>
        [Precision(23, 10)]
        [Comment("变动提前期批量")]
        public decimal? bat_change_economy { get; set; }
        /// <summary>
        /// 累计提前期
        /// </summary>
        [Precision(23, 10)]
        [Comment("累计提前期")]
        public decimal? total_tqq { get; set; }
        /// <summary>
        /// 再订货点
        /// </summary>
        [Precision(23, 10)]
        [Comment("再订货点")]
        public decimal? order_point { get; set; }
        /// <summary>
        /// 设置为固定再订货点
        /// </summary>
        [Comment("设置为固定再订货点")]
        public int? isfixedreorder { get; set; }
        /// <summary>
        /// 安全库存数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("安全库存数量")]
        public decimal? secinv { get; set; }
        /// <summary>
        /// 安全库存触发采购比例
        /// </summary>
        [Precision(23, 10)]
        [Comment("安全库存触发采购比例")]
        public decimal? secinv_ratio { get; set; }
        /// <summary>
        /// 是否需要进行订补货计划的运算
        /// </summary>
        //[Comment("是否需要进行订补货计划的运算")]
        //public int? book_plan { get; set; }
        /// <summary>
        /// 辅助属性参与计划运算
        /// </summary>
        //[Comment("辅助属性参与计划运算")]
        //public int? aux_prop_plan { get; set; }
        /// <summary>
        /// 计划备注
        /// </summary>
        //[StringLength(1000)]
        //[Comment("计划备注")]
        //public string? plannote { get; set; }

        /// <summary>
        /// 计算ID
        /// </summary>
        //[Comment("计算id")]
        //[NotMapped]
        //public long? bang_id { get; set; }
        /// <summary>
        /// 自检提前期
        /// </summary>
        [Precision(23, 10)]
        [Comment("自检提前期")]
        public decimal? self_inspection_date { get; set; }
        /// <summary>
        /// 入库提前期
        /// </summary>
        [Precision(23, 10)]
        [Comment("入库提前期")]
        public decimal? Warehousing_date { get; set; }
        /// <summary>
        /// 发运提前期
        /// </summary>
        [Precision(23, 10)]
        [Comment("发运提前期")]
        public decimal? Shipping_date { get; set; }

        //ic_factory_details
        /// <summary>
        /// 物料id
        /// </summary>
        //[Required]
        //[Comment("物料id")]
        //public long icitem_id { get; set; }
        ///// <summary>
        ///// 物料名称
        ///// </summary>
        //[StringLength(80)]
        //[Comment("物料名称")]
        //public string? icitem_name { get; set; }
        /// <summary>
        /// 工厂编码
        /// </summary>
        //[StringLength(80)]
        //[Comment("工厂编码")]
        //public string? factory_fode { get; set; }
        /// <summary>
        /// 特殊备注
        /// </summary>
        //[StringLength(1000)]
        //[Comment("特殊备注")]
        //public string? note { get; set; }
        /// <summary>
        /// 产品线
        /// </summary>
        [StringLength(80)]
        [Comment("产品线")]
        public string product_line { get; set; }
        /// <summary>
        /// 领料类型
        /// </summary>
        //[Required]
        //[Comment("领料类型")]
        //public long pick_type { get; set; }
        /// <summary>
        /// 是否采用业务批次管理
        /// </summary>
        [Comment("是否采用业务批次管理")]
        public int batch_manager { get; set; }
        /// <summary>
        /// 是否需要库龄管理
        /// </summary>
        //[Comment("是否需要库龄管理")]
        //public int stock_time { get; set; }
        /// <summary>
        /// 盘点周期单位
        /// </summary>
        //[StringLength(80)]
        //[Comment("盘点周期单位")]
        //public string? check_cycunit { get; set; }
        /// <summary>
        /// 盘点周期
        /// </summary>
        //[Precision(23, 10)]
        //[Comment("盘点周期")]
        //public decimal? check_cycle { get; set; }
        /// <summary>
        /// 每周_月第天
        /// </summary>
        //[Comment("每周_月第天")]
        //public int days_per { get; set; }
        /// <summary>
        /// 上次盘点日期
        /// </summary>
        //[Comment("上次盘点日期")]
        //public DateTime? last_checkdate { get; set; }
        ///// <summary>
        /// 默认待检仓库
        /// </summary>
        //[Required]
        //[Comment("默认待检仓库")]
        //public long default_chkloc { get; set; }
        /// <summary>
        /// 默认待检仓位
        /// </summary>
        //[Required]
        //[Comment("默认待检仓位")]
        //public long default_chksp { get; set; }
        /// <summary>
        /// 默认仓库
        /// </summary>
        //[Required]
        //[Comment("默认仓库")]
        //public long default_loc { get; set; }
        /// <summary>
        /// 默认仓位
        /// </summary>
        //[Required]
        //[Comment("默认仓位")]
        //public long default_sp { get; set; }
        /// <summary>
        /// 货架信息
        /// </summary>
        //[StringLength(80)]
        //[Comment("货架信息")]
        //public string? item_shelve { get; set; }
        /// <summary>
        /// 默认仓管员
        /// </summary>
        //[StringLength(80)]
        //[Comment("默认仓管员")]
        //public string? default_manager { get; set; }
        /// <summary>
        /// 最低存量
        /// </summary>
        //[Precision(23, 10)]
        //[Comment("最低存量")]
        //public decimal? low_limit { get; set; }
        /// <summary>
        /// 最高存量
        /// </summary>
        //[Precision(23, 10)]
        //[Comment("最高存量")]
        //public decimal? high_limit { get; set; }
        /// <summary>
        /// 最大订货量
        /// </summary>
        //[Precision(23, 10)]
        //[Comment("最大订货量")]
        //public decimal? qty_max { get; set; }
        /// <summary>
        /// 日消耗量
        /// </summary>
        //[Precision(23, 10)]
        //[Comment("日消耗量")]
        //public decimal? daily_consume { get; set; }
        /// <summary>
        /// 库存备注
        /// </summary>
        //[StringLength(1000)]
        //[Comment("库存备注")]
        //public string? warehouse_note { get; set; }
        /// <summary>
        /// 工单发料时间/天
        /// </summary>
        [Precision(23, 10)]
        [Comment("工单发料时间/天")]
        public decimal? ordissu_days { get; set; }
        ///// <summary>
        ///// 原材料收货处理时间/天
        ///// </summary>
        //[Precision(23, 10)]
        //[Comment("原材料收货处理时间/天")]
        //public decimal? raw_matreceiv_days { get; set; }
        ///// <summary>
        ///// 成品入库时间/天
        ///// </summary>
        //[Precision(23, 10)]
        //[Comment("成品入库时间/天")]
        //public decimal? prdenter_days { get; set; }
        ///// <summary>
        ///// 原材料入库时间/天
        ///// </summary>
        //[Precision(23, 10)]
        //[Comment("原材料入库时间/天")]
        //public decimal? mat_enter_days { get; set; }
        ///// <summary>
        ///// 成品发货时间/天
        ///// </summary>
        //[Precision(23, 10)]
        //[Comment("成品发货时间/天")]
        //public decimal? prd_out_days { get; set; }

        /// <summary>
        /// 运输中提前期_天
        /// </summary>
        [Comment("运输中提前期_天")]
        [Required]
        [DefaultValue(0)]
        [Precision(23, 10)]
        public decimal? transportation_leadtime { get; set; }

        /// <summary>
        /// 仓库中提前期_天
        /// </summary>
        [Comment("仓库中提前期_天")]
        [Required]
        [DefaultValue(0)]
        [Precision(23, 10)]
        public decimal? stock_leadtime { get; set; }

        /// <summary>
        /// 生产中提前期_天
        /// </summary>
        [Comment("生产中提前期_天")]
        [Required]
        [DefaultValue(0)]
        [Precision(23, 10)]
        public decimal? production_leadtime { get; set; }

        /// <summary>
        /// 下单前置期_天
        /// </summary>
        [Comment("下单前置期_天")]
        [Required]
        [DefaultValue(0)]
        [Precision(23, 10)]
        public decimal? order_leadtime { get; set; }

        /// <summary>
        /// 最小包装量
        /// </summary>
        [Comment("最小包装量")]
        [Required]
        [DefaultValue(0)]
        [Precision(23, 10)]
        public decimal? minpackqty { get; set; }

        /// <summary>
        /// 最小订单量
        /// </summary>
        [Comment("最小订单量")]
        [Required]
        [DefaultValue(0)]
        [Precision(23, 10)]
        public decimal? minorderqty { get; set; }

        /// <summary>
        /// 是否倒冲
        /// </summary>
        [Comment("是否倒冲")]
        public int? isbackflush { get; set; }
        /// <summary>
        /// 生产负责人
        /// </summary>
        //[StringLength(80)]
        //[Comment("生产负责人")]
        //public string? product_principal { get; set; }
        /// <summary>
        /// 倒冲仓库
        /// </summary>
        //[StringLength(80)]
        //[Comment("倒冲仓库")]
        //public string? back_flush_stock { get; set; }
        /// <summary>
        /// 倒冲仓位
        /// </summary>
        //[StringLength(80)]
        //[Comment("倒冲仓位")]
        //public string? back_flush_sp { get; set; }
        /// <summary>
        /// 投料自动取整
        /// </summary>
        [Comment("投料自动取整")]
        public int? put_integer { get; set; }

        /// <summary>
        /// RS50成品  RS30 组件  RS11 原材料 RS12 零件 RS13 包装材料 RS14 辅料 RS15 低值易耗品 RS99 虚拟物料
        /// </summary>
        [StringLength(80)]
        [Comment("物料类型")]
        public string item_type { get; set; }

        /// <summary>
        /// 供应提前期
        /// </summary>
        [Comment("供应提前期")]
        [Required]
        [DefaultValue(0)]
        [Precision(23, 10)]
        public int PurLT { get; set; }
    }
}