using Business.Core.Attributes; using Microsoft.EntityFrameworkCore; using System.ComponentModel; using System.ComponentModel.DataAnnotations; namespace Business.Domain { /// /// 物料详情 /// [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) { } /// /// 物料编码 /// [StringLength(80)] [Comment("物料编码")] public string number { get; set; } /// /// 物料名称 /// [StringLength(80)] [Comment("物料名称")] public string name { get; set; } /// /// 规格型号 /// [StringLength(200)] [Comment("规格型号")] public string model { get; set; } /// /// 全名 /// [StringLength(255)] [Comment("全名")] public string full_name { get; set; } /// /// fms旧料号 /// [StringLength(80)] [Comment("fms旧料号")] public string fms_number { get; set; } /// /// erp旧料号 /// [StringLength(80)] [Comment("erp旧料号")] public string erp_oldnumber { get; set; } /// /// 图号 /// [StringLength(80)] [Comment("图号")] public string chart_number { get; set; } /// /// 版本号 /// [StringLength(80)] [Comment("版本号")] public string fversion { get; set; } /// /// 盒贴规格 /// [StringLength(200)] [Comment("盒贴规格")] public string box_model { get; set; } /// /// 物料属性 /// [Comment("物料属性")] public int? erp_cls { get; set; } /// /// 物料属性名称 /// [StringLength(80)] [Comment("物料属性")] public string erp_cls_name { get; set; } /// /// 单位 /// [StringLength(80)] [Comment("单位")] public string unit { get; set; } /// /// 物料等级 /// [Comment("物料等级")] public long? item_level { get; set; } /// /// 单位标准工时_小时 /// [Precision(23, 10)] [Comment("单位标准工时_小时")] public decimal? standard_manhour { get; set; } /// /// 单位材料定额_元 /// [Precision(23, 10)] [Comment("单位材料定额_元")] public decimal? unititem_amount { get; set; } /// /// 来源 /// [StringLength(200)] [Comment("来源")] public string? source { get; set; } /// /// 是否为设备 /// [Comment("是否为设备")] public int? is_equipment { get; set; } /// /// 单位包装数量 /// [Precision(23, 10)] [Comment("单位包装数量")] public decimal? unit_qty { get; set; } /// /// 是否关键件 /// [Comment("是否关键件")] public int? iskeyitem { get; set; } /// /// 毛重 /// [Precision(23, 10)] [Comment("毛重")] public decimal? gross_weight { get; set; } /// /// 净重 /// [Precision(23, 10)] [Comment("净重")] public decimal? net_weight { get; set; } /// /// 重量单位 /// [StringLength(80)] [Comment("重量单位")] public string maund { get; set; } /// /// 长度 /// [Precision(23, 10)] [Comment("长度")] public decimal? length { get; set; } /// /// 长度单位 /// [StringLength(80)] [Comment("长度单位")] public string cubic_measure { get; set; } /// /// 宽度 /// [Precision(23, 10)] [Comment("宽度")] public decimal? width { get; set; } /// /// 高度 /// [Precision(23, 10)] [Comment("高度")] public decimal? height { get; set; } /// /// 体积 /// [Precision(23, 10)] [Comment("体积")] public decimal? size { get; set; } /// /// 允许采购 /// [Comment("允许采购")] public int? allowpur { get; set; } /// /// 允许销售 /// [Comment("允许销售")] public int? allowsale { get; set; } /// /// 允许生产 /// [Comment("允许生产")] public int? allowmanu { get; set; } /// /// 允许委外 /// [Comment("允许委外")] public int? allowout { get; set; } /// /// 批号管理 /// [Comment("批号管理")] public int? allowbatch { get; set; } /// /// 序列号管理 /// [Comment("序列号管理")] public int? allowserial { get; set; } /// /// 图片 /// [StringLength(80)] [Comment("图片")] public string photo { get; set; } /// /// 领料类型 /// [Comment("领料类型")] public long? picktype { get; set; } /// /// 出库类型 /// [Comment("出库类型")] public long? output_type_id { get; set; } /// /// 启用预警 /// [Comment("启用预警")] public int? enable_warning { get; set; } /// /// 生命周期状态:1-成熟品,2-新品,3-重点新品,4-退市 /// [Comment("生命周期状态")] public int? life_state { get; set; } /// /// 经济生产批量 /// [Comment("经济生产批量")] [Precision(23, 10)] public decimal? moq { get; set; } /// /// 最大生产批量 /// [Comment("最大生产批量")] [Precision(23, 10)] public decimal? maq { get; set; } /// /// 是否备料前预处理 /// [Comment("是否备料前预处理")] public int? is_clean { get; set; } /// /// 预处理提前期(天) /// [Comment("预处理提前期")] [Precision(23, 10)] public decimal? clean_leadtime { get; set; } /// /// 工序委外提前期/灭菌提前期(天) /// [Comment("工序委外提前期")] [Precision(23, 10)] public decimal? sterilize_leadtime { get; set; } /// /// 平台调拨提前期(天) /// [Comment("平台调拨提前期")] [Precision(23, 10)] public decimal? transfer_leadtime { get; set; } /// /// 标准工期(天) /// [Comment("标准工期")] [Precision(23, 10)] public decimal? standard_period { get; set; } /// /// FMR分类:F-F类,M-M类,R-R类 /// [Comment("FMR分类")] [StringLength(80)] public string fmr { get; set; } /// /// ABC分类:A-A类,B-B类,C-C类 /// [Comment("ABC分类")] [StringLength(80)] public string abc { get; set; } //ic_plan ///// ///// 物料id ///// //[Required] //[Comment("物料id")] //public long icitem_id { get; set; } ///// ///// 物料名称 ///// //[StringLength(80)] //[Comment("物料名称")] //public string? icitem_name { get; set; } ///// ///// 计划员 ///// //[StringLength(80)] //[Comment("计划员")] //public string? planner_name { get; set; } ///// ///// 计划员_工号 ///// //[StringLength(80)] //[Comment("计划员_工号")] //public string? planner_num { get; set; } ///// ///// 工厂编码 ///// //[StringLength(80)] //[Comment("工厂编码")] //public string? factory_code { get; set; } /// /// 固定提前期(天) /// [Precision(23, 10)] [Comment("固定提前期(天)")] public decimal? fix_leadtime { get; set; } /// /// 计划策略 /// [Comment("计划策略")] public int? plan_trategy { get; set; } /// /// 订货策略 /// [Comment("订货策略")] public int? order_trategy { get; set; } /// /// 订货间隔期_天 /// [Precision(23, 10)] [Comment("订货间隔期_天")] public decimal? order_inter_val { get; set; } /// /// 变动提前期 /// [Precision(23, 10)] [Comment("变动提前期")] public decimal? lead_time { get; set; } /// /// 变动提前期批量 /// [Precision(23, 10)] [Comment("变动提前期批量")] public decimal? bat_change_economy { get; set; } /// /// 累计提前期 /// [Precision(23, 10)] [Comment("累计提前期")] public decimal? total_tqq { get; set; } /// /// 再订货点 /// [Precision(23, 10)] [Comment("再订货点")] public decimal? order_point { get; set; } /// /// 设置为固定再订货点 /// [Comment("设置为固定再订货点")] public int? isfixedreorder { get; set; } /// /// 安全库存数量 /// [Precision(23, 10)] [Comment("安全库存数量")] public decimal? secinv { get; set; } /// /// 安全库存触发采购比例 /// [Precision(23, 10)] [Comment("安全库存触发采购比例")] public decimal? secinv_ratio { get; set; } /// /// 是否需要进行订补货计划的运算 /// //[Comment("是否需要进行订补货计划的运算")] //public int? book_plan { get; set; } /// /// 辅助属性参与计划运算 /// //[Comment("辅助属性参与计划运算")] //public int? aux_prop_plan { get; set; } /// /// 计划备注 /// //[StringLength(1000)] //[Comment("计划备注")] //public string? plannote { get; set; } /// /// 计算ID /// //[Comment("计算id")] //[NotMapped] //public long? bang_id { get; set; } /// /// 自检提前期 /// [Precision(23, 10)] [Comment("自检提前期")] public decimal? self_inspection_date { get; set; } /// /// 入库提前期 /// [Precision(23, 10)] [Comment("入库提前期")] public decimal? Warehousing_date { get; set; } /// /// 发运提前期 /// [Precision(23, 10)] [Comment("发运提前期")] public decimal? Shipping_date { get; set; } //ic_factory_details /// /// 物料id /// //[Required] //[Comment("物料id")] //public long icitem_id { get; set; } ///// ///// 物料名称 ///// //[StringLength(80)] //[Comment("物料名称")] //public string? icitem_name { get; set; } /// /// 工厂编码 /// //[StringLength(80)] //[Comment("工厂编码")] //public string? factory_fode { get; set; } /// /// 特殊备注 /// //[StringLength(1000)] //[Comment("特殊备注")] //public string? note { get; set; } /// /// 产品线 /// [StringLength(80)] [Comment("产品线")] public string product_line { get; set; } /// /// 领料类型 /// //[Required] //[Comment("领料类型")] //public long pick_type { get; set; } /// /// 是否采用业务批次管理 /// [Comment("是否采用业务批次管理")] public int batch_manager { get; set; } /// /// 是否需要库龄管理 /// //[Comment("是否需要库龄管理")] //public int stock_time { get; set; } /// /// 盘点周期单位 /// //[StringLength(80)] //[Comment("盘点周期单位")] //public string? check_cycunit { get; set; } /// /// 盘点周期 /// //[Precision(23, 10)] //[Comment("盘点周期")] //public decimal? check_cycle { get; set; } /// /// 每周_月第天 /// //[Comment("每周_月第天")] //public int days_per { get; set; } /// /// 上次盘点日期 /// //[Comment("上次盘点日期")] //public DateTime? last_checkdate { get; set; } ///// /// 默认待检仓库 /// //[Required] //[Comment("默认待检仓库")] //public long default_chkloc { get; set; } /// /// 默认待检仓位 /// //[Required] //[Comment("默认待检仓位")] //public long default_chksp { get; set; } /// /// 默认仓库 /// //[Required] //[Comment("默认仓库")] //public long default_loc { get; set; } /// /// 默认仓位 /// //[Required] //[Comment("默认仓位")] //public long default_sp { get; set; } /// /// 货架信息 /// //[StringLength(80)] //[Comment("货架信息")] //public string? item_shelve { get; set; } /// /// 默认仓管员 /// //[StringLength(80)] //[Comment("默认仓管员")] //public string? default_manager { get; set; } /// /// 最低存量 /// //[Precision(23, 10)] //[Comment("最低存量")] //public decimal? low_limit { get; set; } /// /// 最高存量 /// //[Precision(23, 10)] //[Comment("最高存量")] //public decimal? high_limit { get; set; } /// /// 最大订货量 /// //[Precision(23, 10)] //[Comment("最大订货量")] //public decimal? qty_max { get; set; } /// /// 日消耗量 /// //[Precision(23, 10)] //[Comment("日消耗量")] //public decimal? daily_consume { get; set; } /// /// 库存备注 /// //[StringLength(1000)] //[Comment("库存备注")] //public string? warehouse_note { get; set; } /// /// 工单发料时间/天 /// [Precision(23, 10)] [Comment("工单发料时间/天")] public decimal? ordissu_days { get; set; } ///// ///// 原材料收货处理时间/天 ///// //[Precision(23, 10)] //[Comment("原材料收货处理时间/天")] //public decimal? raw_matreceiv_days { get; set; } ///// ///// 成品入库时间/天 ///// //[Precision(23, 10)] //[Comment("成品入库时间/天")] //public decimal? prdenter_days { get; set; } ///// ///// 原材料入库时间/天 ///// //[Precision(23, 10)] //[Comment("原材料入库时间/天")] //public decimal? mat_enter_days { get; set; } ///// ///// 成品发货时间/天 ///// //[Precision(23, 10)] //[Comment("成品发货时间/天")] //public decimal? prd_out_days { get; set; } /// /// 运输中提前期_天 /// [Comment("运输中提前期_天")] [Required] [DefaultValue(0)] [Precision(23, 10)] public decimal? transportation_leadtime { get; set; } /// /// 仓库中提前期_天 /// [Comment("仓库中提前期_天")] [Required] [DefaultValue(0)] [Precision(23, 10)] public decimal? stock_leadtime { get; set; } /// /// 生产中提前期_天 /// [Comment("生产中提前期_天")] [Required] [DefaultValue(0)] [Precision(23, 10)] public decimal? production_leadtime { get; set; } /// /// 下单前置期_天 /// [Comment("下单前置期_天")] [Required] [DefaultValue(0)] [Precision(23, 10)] public decimal? order_leadtime { get; set; } /// /// 最小包装量 /// [Comment("最小包装量")] [Required] [DefaultValue(0)] [Precision(23, 10)] public decimal? minpackqty { get; set; } /// /// 最小订单量 /// [Comment("最小订单量")] [Required] [DefaultValue(0)] [Precision(23, 10)] public decimal? minorderqty { get; set; } /// /// 是否倒冲 /// [Comment("是否倒冲")] public int? isbackflush { get; set; } /// /// 生产负责人 /// //[StringLength(80)] //[Comment("生产负责人")] //public string? product_principal { get; set; } /// /// 倒冲仓库 /// //[StringLength(80)] //[Comment("倒冲仓库")] //public string? back_flush_stock { get; set; } /// /// 倒冲仓位 /// //[StringLength(80)] //[Comment("倒冲仓位")] //public string? back_flush_sp { get; set; } /// /// 投料自动取整 /// [Comment("投料自动取整")] public int? put_integer { get; set; } /// /// RS50成品 RS30 组件 RS11 原材料 RS12 零件 RS13 包装材料 RS14 辅料 RS15 低值易耗品 RS99 虚拟物料 /// [StringLength(80)] [Comment("物料类型")] public string? item_type { get; set; } /// /// 供应提前期 /// [Comment("供应提前期")] [Required] [DefaultValue(0)] [Precision(23, 10)] public int PurLT { get; set; } /// /// bom设计时间 /// [Comment("bom设计时间")] [DefaultValue(0)] public decimal? BOMDesignTime { get; set; } /// /// 工艺设计时间 /// [Comment("工艺设计时间")] [DefaultValue(0)] public decimal? RoutingDesignTime { get; set; } } }