DEMOMySql/MicroServices/Business/Business.Application.Contracts/ResourceExamineManagement/Dto/BomChildExamineDto.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Business.ResourceExamineManagement.Dto
{
    public class BomChildExamineDto
    {
        /// <summary>
        /// 数据库主键
        /// </summary>
        public long id { get; set; }

        /// <summary>
        /// 本级id
        /// </summary>
        public long fid { get; set; }

        /// <summary>
        /// 父级
        /// </summary>
        public long? parent_id { get; set; }

        /// <summary>
        /// bom明细主键
        /// </summary>
        public long? bom_child_id { get; set; }

        /// <summary>
        /// 版本
        /// </summary>
        public string version { get; set; }

        /// <summary>
        /// bom编号
        /// </summary>
        public string bom_number { get; set; }

        /// <summary>
        /// 物料编号
        /// </summary>
        public string item_number { get; set; }

        /// <summary>
        /// level
        /// </summary>
        public int level { get; set; }

        /// <summary>
        /// 订单行ID
        /// </summary>
        public long sentry_id { get; set; }

        /// <summary>
        /// BOMid
        /// </summary>
        public long? bom_id { get; set; }

        /// <summary>
        /// 项次号
        /// </summary>
        public string num { get; set; }

        /// <summary>
        /// 供排序使用
        /// </summary>
        public long num_order { get; set; }

        /// <summary>
        /// 类型 0标准件，1替代件
        /// </summary>
        public int type { get; set; }

        /// <summary>
        /// 物料id
        /// </summary>
        public long item_id { get; set; }

        /// <summary>
        /// 物料名称
        /// </summary>
        public string item_name { get; set; }

        /// <summary>
        /// 规格型号
        /// </summary>
        public string model { get; set; }

        /// <summary>
        /// 单位
        /// </summary>
        public string unit { get; set; }

        /// <summary>
        /// 物料属性 0.配置类 1.自制 2.委外加工 3.外购 4.虚拟件
        /// </summary>
        public int erp_cls { get; set; }

        /// <summary>
        /// 物料属性名称
        /// </summary>
        public string erp_cls_name { get; set; }

        /// <summary>
        /// 是否倒冲
        /// </summary>
        public int backflush { get; set; }

        /// <summary>
        /// 单位用量
        /// </summary>
        public decimal qty { get; set; }

        /// <summary>
        /// 库存数量
        /// </summary>
        public decimal sqty { get; set; }

        /// <summary>
        /// 库存占用数量
        /// </summary>
        public decimal use_qty { get; set; }

        /// <summary>
        /// 本级缺料数量
        /// </summary>
        public decimal self_lack_qty { get; set; }

        /// <summary>
        /// 缺料数量
        /// </summary>
        public decimal lack_qty { get; set; }

        /// <summary>
        /// 在制占用数量
        /// </summary>
        public decimal mo_qty { get; set; }

        /// <summary>
        /// 在制工单占用明细
        /// </summary>
        public List<mo_occupy> mo_occupy_list { get; set; }

        /// <summary>
        /// 自制数量
        /// </summary>
        public decimal make_qty { get; set; }

        /// <summary>
        /// 自制工单明细
        /// </summary>
        public List<moorder> make_list { get; set; }

        /// <summary>
        /// 采购数量
        /// </summary>
        public decimal purchase_qty { get; set; }

        /// <summary>
        /// 采购明细
        /// </summary>
        public List<purchase> purchase_list { get; set; }

        /// <summary>
        /// 采购明细占用数量
        /// </summary>
        public decimal purchase_occupy_qty { get; set; }

        /// <summary>
        /// 采购占用明细
        /// </summary>
        public List<purchase_occupy> purchase_occupy_list { get; set; }

        /// <summary>
        /// 在检占用数量
        /// </summary>
        public decimal fqc_occupy_qty { get; set; }

        /// <summary>
        /// 在检占用明细
        /// </summary>
        public List<purchase_occupy> fqc_occupy_list { get; set; }

        /// <summary>
        /// 委外数量
        /// </summary>
        public decimal subcontracting_qty { get; set; }

        /// <summary>
        /// 委外工单明细
        /// </summary>
        public List<ooder> subcontracting_list { get; set; }

        /// <summary>
        /// 齐套时间
        /// </summary>
        public DateTime? kitting_time { get; set; }

        /// <summary>
        /// 满足时间
        /// </summary>
        public DateTime? satisfy_time { get; set; }

        /// <summary>
        /// 生产准备提前期
        /// </summary>
        public int? make_time { get; set; }

        /// <summary>
        /// 供应欠缺时间
        /// </summary>
        public int? pre_time { get; set; }

        /// <summary>
        /// 是否BOM
        /// </summary>
        public int isbom { get; set; }

        /// <summary>
        /// 存在替代关系
        /// </summary>
        public int haveicsubs { get; set; }

        /// <summary>
        /// 群组代码
        /// </summary>
        public string substitute_code { get; set; }

        /// <summary>
        /// 是否群组替代
        /// </summary>
        public int is_replace { get; set; }

        /// <summary>
        /// 群组ids
        /// </summary>
        public string icitem_ids { get; set; }

        /// <summary>
        /// 群组优先级
        /// </summary>
        public int? substitute_all_num { get; set; }

        /// <summary>
        /// 替代策略
        /// </summary>
        public int substitute_strategy { get; set; }

        /// <summary>
        /// 替代方式
        /// </summary>
        public int substitute_mode { get; set; }

        /// <summary>
        /// 物料状态-- -1.无需求 0.缺料 1.充足 2.可制,时间满足 3.可制，时间不满足 4.采购 5.委外 99,无货源清单
        /// </summary>
        public int stock_state { get; set; }

        /// <summary>
        /// 物料齐套状态-- -1.库存可满足 2.在途可满足 3.在制可满足 4.承诺交期可满足 5.不齐套
        /// </summary>
        public int kitting_state { get; set; }

        /// <summary>
        /// 单个产品总需要用量（含损耗率+固定损耗量）
        /// </summary>
        public decimal needCount { get; set; }

        /// <summary>
        /// 单个产品总需要用量（不含损耗率和固定损耗量）
        /// </summary>
        public decimal? needCountNoloss { get; set; }

        /// <summary>
        /// 是否使用此物料
        /// </summary>
        public bool is_use { get; set; }

        /// <summary>
        /// 工序
        /// </summary>
        public int Op { get; set; }

        /// <summary>
        /// 物料前处理天数
        /// </summary>
        public decimal? clean_leadtime { get; set; }

        /// <summary>
        /// 供应提前期
        /// </summary>
        public int PurLT { get; set; }

        /// <summary>
        /// bom设计时间
        /// </summary>
        public decimal? BOMDesignTime { get; set; }

        /// <summary>
        /// 工艺设计时间
        /// </summary>
        public decimal? RoutingDesignTime { get; set; }

        /// <summary>
        /// 损耗率
        /// </summary>
        [Comment("损耗率")]
        public decimal? scrap { get; set; }

        /// <summary>
        /// 固定损耗量
        /// </summary>
        [Comment("固定损耗量")]
        public decimal? wastage { get; set; }

        /// <summary>
        /// 安全库存
        /// </summary>
        [Comment("安全库存")]
        public decimal security_stock { get; set; }
    }

    /// <summary>
    /// 生产工单信息
    /// </summary>
    public class moorder
    {
        /// <summary>
        /// 主键
        /// </summary>
        public long? Id { get; set; }

        /// <summary>
        /// 生产工单编号
        /// </summary>
        public string? morder_no { get; set; }
        /// <summary>
        /// 生产组织名称
        /// </summary>
        public string? moentry_prdname { get; set; }
        /// <summary>
        /// 工作中心名称
        /// </summary>
        public string? moentry_wrkcname { get; set; }
        /// <summary>
        /// 生产工单开始日期
        /// </summary>
        public DateTime? moentry_stime { get; set; }
        /// <summary>
        /// 生产工单结束日期
        /// </summary>
        public DateTime? moentry_etime { get; set; }
        /// <summary>
        /// 系统建议开工时间
        /// </summary>
        public DateTime? moentry_sys_stime { get; set; }
        /// <summary>
        /// 系统建议完工时间
        /// </summary>
        public DateTime? moentry_sys_etime { get; set; }
        /// <summary>
        /// 实际开始时间
        /// </summary>
        public DateTime? reality_start_time { get; set; }
        /// <summary>
        /// 实际结束时间
        /// </summary>
        public DateTime? reality_end_time { get; set; }
        /// <summary>
        /// 工单所需工时
        /// </summary>
        public decimal? morder_need_time { get; set; }
        /// <summary>
        /// 工单生产数量(计划数量)
        /// </summary>
        public decimal? morder_production_number { get; set; }
        /// <summary>
        /// 需求数量
        /// </summary>
        public decimal? need_number { get; set; }
    }

    /// <summary>
    /// 在制占用明细
    /// </summary>
    public class mo_occupy
    {
        /// <summary>
        /// 主键
        /// </summary>
        public long? id { get; set; }

        /// <summary>
        /// 工单号
        /// </summary>
        public string? moo_mo { get; set; }

        /// <summary>
        /// 占用量
        /// </summary>
        public decimal? moo_qty { get; set; }

        /// <summary>
        /// 开始时间
        /// </summary>
        public DateTime? moo_stime { get; set; }

        /// <summary>
        /// 结束时间
        /// </summary>
        public DateTime? moo_etime { get; set; }
    }

    /// <summary>
    /// 采购明细信息
    /// </summary>
    public class purchase
    {
        /// <summary>
        /// 主键
        /// </summary>
        public long? Id { get; set; }

        /// <summary>
        /// pr单号
        /// </summary>
        public string? pr_billno { get; set; }

        /// <summary>
        /// 供应商编码
        /// </summary>
        public string? pr_purchasenumber { get; set; }
        /// <summary>
        /// 供应商名称
        /// </summary>
        public string? pr_purchasename { get; set; }
        /// <summary>
        /// 需求数量
        /// </summary>
        public decimal? pr_rqty { get; set; }
        /// <summary>
        /// 申请数量
        /// </summary>
        public decimal? pr_aqty { get; set; }
        /// <summary>
        /// 建议数量
        /// </summary>
        public decimal? pr_sqty { get; set; }
        /// <summary>
        /// 计划到达日期
        /// </summary>
        public DateTime? pr_parrive_date { get; set; }
        /// <summary>
        /// 需求到货日期
        /// </summary>
        public DateTime? pr_rarrive_date { get; set; }
        /// <summary>
        /// 采购确认到货日期
        /// </summary>
        public DateTime? pr_pur_affirm_date { get; set; }
        /// <summary>
        /// 系统价格（含税）
        /// </summary>
        public decimal? pr_sysprice { get; set; }
        /// <summary>
        /// 订单价格（含税）
        /// </summary>
        public decimal? pr_orderprice { get; set; }
        /// <summary>
        /// 采购净价（不含税）
        /// </summary>
        public decimal? pr_price { get; set; }
        /// <summary>
        /// 税率
        /// </summary>
        public decimal? pr_rate { get; set; }

        public bool isbestoptions { get; set; }
    }

    /// <summary>
    /// 采购占用明细
    /// </summary>
    public class purchase_occupy
    {
        /// <summary>
        /// 主键
        /// </summary>
        public long? id { get; set; }

        /// <summary>
        /// 采购订单单号
        /// </summary>
        public string? po_billno { get; set; }
        /// <summary>
        /// 类型
        /// </summary>
        public string? type { get; set; }
        /// <summary>
        /// 占用量
        /// </summary>
        public decimal? qty { get; set; }
        /// <summary>
        /// 开始时间
        /// </summary>
        public DateTime? stime { get; set; }
        /// <summary>
        /// 结束时间
        /// </summary>
        public DateTime? etime { get; set; }
    }
    /// <summary>
    /// 委外工单信息
    /// </summary>
    public class ooder {
        /// <summary>
        /// 主键
        /// </summary>
        public long? Id { get; set; }

        /// <summary>
        /// 工单编号
        /// </summary>
        public string? oorder_no { get; set; }
        /// <summary>
        /// 委外订单日期
        /// </summary>
        public DateTime? oorder_date { get; set; }
        /// <summary>
        /// 生产组织名称
        /// </summary>
        public string? ooentry_prdname { get; set; }
        /// <summary>
        /// 计划开工日期
        /// </summary>
        public DateTime? ooentry_stime { get; set; }
        /// <summary>
        /// 计划完工日期
        /// </summary>
        public DateTime? ooentry_etime { get; set; }
        /// <summary>
        /// 工单生产数量(计划数量)
        /// </summary>
        public decimal? morder_production_number { get; set; }
        /// <summary>
        /// 加工单位
        /// </summary>
        public string? production_unit { get; set; }
        /// <summary>
        /// 加工单位编码
        /// </summary>
        public string? production_unit_code { get; set; }

    }

}