AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Entity/S0/Manufacturing/AdoS0MfgBomAndRouting.cs

namespace Admin.NET.Plugin.AiDOP.Entity.S0.Manufacturing;

[SugarTable("ado_s0_mfg_bom", "S0 标准 BOM 头")]
[SugarIndex("uk_ado_s0_mfg_bom_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgBom
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "编码", Length = 100)]
    public string Code { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "名称", Length = 200)]
    public string Name { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "父物料", ColumnDataType = "bigint", IsNullable = true)]
    public long? MaterialId { get; set; }

    [SugarColumn(ColumnDescription = "业务版本", Length = 50)]
    public string BizVersion { get; set; } = "1.0";

    [SugarColumn(ColumnDescription = "文档状态", Length = 50)]
    public string DocStatus { get; set; } = "draft";

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_bom_item", "S0 BOM 行")]
public class AdoS0MfgBomItem
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "BOM 头", ColumnDataType = "bigint")]
    public long BomId { get; set; }

    [SugarColumn(ColumnDescription = "子物料", ColumnDataType = "bigint")]
    public long MaterialId { get; set; }

    [SugarColumn(ColumnDescription = "数量", DecimalDigits = 5, Length = 18)]
    public decimal Qty { get; set; } = 1m;

    [SugarColumn(ColumnDescription = "数量分子", DecimalDigits = 5, Length = 18)]
    public decimal QtyNumerator { get; set; } = 1m;

    [SugarColumn(ColumnDescription = "数量分母", DecimalDigits = 5, Length = 18)]
    public decimal QtyDenominator { get; set; } = 1m;

    [SugarColumn(ColumnDescription = "损耗率", DecimalDigits = 5, Length = 18)]
    public decimal LossRate { get; set; }

    [SugarColumn(ColumnDescription = "固定损耗量", DecimalDigits = 5, Length = 18)]
    public decimal FixedLossQty { get; set; }

    [SugarColumn(ColumnDescription = "工序", ColumnDataType = "bigint", IsNullable = true)]
    public long? OperationId { get; set; }

    [SugarColumn(ColumnDescription = "虚拟件", ColumnDataType = "boolean")]
    public bool IsPhantom { get; set; }

    [SugarColumn(ColumnDescription = "单位", Length = 50, IsNullable = true)]
    public string? Unit { get; set; }

    [SugarColumn(ColumnDescription = "排序")]
    public int SortNo { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 200, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_standard_operation", "S0 标准工序")]
[SugarIndex("uk_ado_s0_mfg_std_op_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgStandardOperation
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "编码", Length = 100)]
    public string Code { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "名称", Length = 200)]
    public string Name { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "关键工序", ColumnDataType = "boolean")]
    public bool IsKeyOperation { get; set; }

    [SugarColumn(ColumnDescription = "工序类型", Length = 50, IsNullable = true)]
    public string? OperationType { get; set; }

    [SugarColumn(ColumnDescription = "标准工时", DecimalDigits = 5, Length = 18, IsNullable = true)]
    public decimal? StdTime { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_production_line", "S0 产线")]
[SugarIndex("uk_ado_s0_mfg_pl_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgProductionLine
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "编码", Length = 100)]
    public string Code { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "名称", Length = 200)]
    public string Name { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "线体类型", Length = 50, IsNullable = true)]
    public string? LineType { get; set; }

    [SugarColumn(ColumnDescription = "线体分类", Length = 50, IsNullable = true)]
    public string? LineCategory { get; set; }

    [SugarColumn(ColumnDescription = "库位", ColumnDataType = "bigint", IsNullable = true)]
    public long? LocationId { get; set; }

    [SugarColumn(ColumnDescription = "车间", ColumnDataType = "bigint", IsNullable = true)]
    public long? WorkshopId { get; set; }

    [SugarColumn(ColumnDescription = "产能", DecimalDigits = 5, Length = 18, IsNullable = true)]
    public decimal? Capacity { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_routing", "S0 工艺路线头")]
[SugarIndex("uk_ado_s0_mfg_routing_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgRouting
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "编码", Length = 100)]
    public string Code { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "名称", Length = 200)]
    public string Name { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "物料", ColumnDataType = "bigint", IsNullable = true)]
    public long? MaterialId { get; set; }

    [SugarColumn(ColumnDescription = "业务版本", Length = 50)]
    public string BizVersion { get; set; } = "1.0";

    [SugarColumn(ColumnDescription = "文档状态", Length = 50)]
    public string DocStatus { get; set; } = "draft";

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_routing_operation", "S0 工艺路线工序行")]
public class AdoS0MfgRoutingOperation
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "路线", ColumnDataType = "bigint")]
    public long RoutingId { get; set; }

    [SugarColumn(ColumnDescription = "工序", ColumnDataType = "bigint")]
    public long OperationId { get; set; }

    [SugarColumn(ColumnDescription = "排序")]
    public int SortNo { get; set; }

    [SugarColumn(ColumnDescription = "工作中心", ColumnDataType = "bigint", IsNullable = true)]
    public long? WorkCenterId { get; set; }

    [SugarColumn(ColumnDescription = "产线", ColumnDataType = "bigint", IsNullable = true)]
    public long? ProductionLineId { get; set; }

    [SugarColumn(ColumnDescription = "标准工时", DecimalDigits = 5, Length = 18, IsNullable = true)]
    public decimal? StdTime { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "报工工序", ColumnDataType = "boolean")]
    public bool IsReportOperation { get; set; }

    [SugarColumn(ColumnDescription = "活动1", Length = 100, IsNullable = true)]
    public string? Activity1 { get; set; }

    [SugarColumn(ColumnDescription = "活动1数量", DecimalDigits = 5, Length = 18, IsNullable = true)]
    public decimal? Activity1Qty { get; set; }

    [SugarColumn(ColumnDescription = "活动1单位", Length = 50, IsNullable = true)]
    public string? Activity1Unit { get; set; }

    [SugarColumn(ColumnDescription = "活动2", Length = 100, IsNullable = true)]
    public string? Activity2 { get; set; }

    [SugarColumn(ColumnDescription = "活动2数量", DecimalDigits = 5, Length = 18, IsNullable = true)]
    public decimal? Activity2Qty { get; set; }

    [SugarColumn(ColumnDescription = "活动2单位", Length = 50, IsNullable = true)]
    public string? Activity2Unit { get; set; }

    [SugarColumn(ColumnDescription = "活动3", Length = 100, IsNullable = true)]
    public string? Activity3 { get; set; }

    [SugarColumn(ColumnDescription = "活动3数量", DecimalDigits = 5, Length = 18, IsNullable = true)]
    public decimal? Activity3Qty { get; set; }

    [SugarColumn(ColumnDescription = "活动3单位", Length = 50, IsNullable = true)]
    public string? Activity3Unit { get; set; }

    [SugarColumn(ColumnDescription = "基准数量", DecimalDigits = 5, Length = 18)]
    public decimal BaseQty { get; set; } = 1m;

    [SugarColumn(ColumnDescription = "委外", ColumnDataType = "boolean")]
    public bool IsOutsourced { get; set; }

    [SugarColumn(ColumnDescription = "供应商", ColumnDataType = "bigint", IsNullable = true)]
    public long? SupplierId { get; set; }

    [SugarColumn(ColumnDescription = "委外提前期")]
    public int OutsourcedLeadTime { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}