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

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

[SugarTable("PersonSkillAssignment", "S0 人员技能分配")]
public class AdoS0MfgPersonSkillAssignment
{
    [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 PersonCode { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "工作组", Length = 100, IsNullable = true)]
    public string? WorkGroup { get; set; }

    [SugarColumn(ColumnDescription = "技能", ColumnDataType = "bigint")]
    public long SkillId { get; set; }

    [SugarColumn(ColumnDescription = "技能等级")]
    public int SkillLevel { get; set; }

    [SugarColumn(ColumnDescription = "生产效率", DecimalDigits = 5, Length = 18)]
    public decimal ProductionEfficiency { get; set; } = 1m;

    [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("WorkOrderControl", "S0 工单控制参数")]
[SugarIndex("uk_WorkOrderControl_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgWorkOrderControl
{
    [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? ControlType { get; set; }

    [SugarColumn(ColumnDescription = "参数值", Length = 500, IsNullable = true)]
    public string? ParamValue { 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("PersonSkill", "S0 人员技能主数据")]
[SugarIndex("uk_PersonSkill_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgPersonSkill
{
    [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? SkillLevel { 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("LinePost", "S0 线体岗位")]
[SugarIndex("uk_LinePost_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgLinePost
{
    [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? ProductionLineId { 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("WorkCenter", "S0 工作中心")]
[SugarIndex("uk_WorkCenter_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgWorkCenter
{
    [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? CenterType { get; set; }

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

    [SugarColumn(ColumnDescription = "部门", ColumnDataType = "bigint", IsNullable = true)]
    public long? DepartmentId { 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("LineMaterial", "S0 线边物料")]
public class AdoS0MfgLineMaterial
{
    [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", IsNullable = true)]
    public long? ProductionLineId { get; set; }

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

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

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

    [SugarColumn(ColumnDescription = "设备编码", Length = 100, IsNullable = true)]
    public string? EquipmentCode { get; set; }

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

    [SugarColumn(ColumnDescription = "换型时间", DecimalDigits = 5, Length = 18, IsNullable = true)]
    public decimal? ChangeoverTime { get; set; }

    [SugarColumn(ColumnDescription = "设备类型", Length = 50, IsNullable = true)]
    public string? EquipmentTypeCode { get; set; }

    [SugarColumn(ColumnDescription = "模具类型", Length = 50, IsNullable = true)]
    public string? MoldTypeCode { get; set; }

    [SugarColumn(ColumnDescription = "要求技能编码", Length = 100, IsNullable = true)]
    public string? RequiredSkillCode { get; set; }

    [SugarColumn(ColumnDescription = "物料角色", Length = 50, IsNullable = true)]
    public string? MaterialRole { 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("ElementParam", "S0 生产要素参数")]
[SugarIndex("uk_ElementParam_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(ElementCategory), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgElementParam
{
    [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, IsNullable = true)]
    public string? ElementCode { get; set; }

    [SugarColumn(ColumnDescription = "要素名称", Length = 200, IsNullable = true)]
    public string? ElementName { get; set; }

    [SugarColumn(ColumnDescription = "要素分类", Length = 50, IsNullable = true)]
    public string? ElementCategory { 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? ParamType { get; set; }

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

    [SugarColumn(ColumnDescription = "标准值", Length = 200, IsNullable = true)]
    public string? StdValue { get; set; }

    [SugarColumn(ColumnDescription = "上限", DecimalDigits = 6, Length = 18, IsNullable = true)]
    public decimal? UpperLimit { get; set; }

    [SugarColumn(ColumnDescription = "下限", DecimalDigits = 6, Length = 18, IsNullable = true)]
    public decimal? LowerLimit { get; set; }

    [SugarColumn(ColumnDescription = "枚举选项", Length = 2000, IsNullable = true)]
    public string? EnumOptions { 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("MaterialProcessElement", "S0 物料工艺要素")]
public class AdoS0MfgMaterialProcessElement
{
    [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 MaterialId { get; set; }

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

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

    [SugarColumn(ColumnDescription = "要素类型", Length = 50, IsNullable = true)]
    public string? ElementType { get; set; }

    [SugarColumn(ColumnDescription = "要素编码", Length = 100, IsNullable = true)]
    public string? ElementCode { get; set; }

    [SugarColumn(ColumnDescription = "要素名称", Length = 200, IsNullable = true)]
    public string? ElementName { get; set; }

    [SugarColumn(ColumnDescription = "要素参数", ColumnDataType = "bigint")]
    public long ElementParamId { get; set; }

    [SugarColumn(ColumnDescription = "参数值", Length = 500, IsNullable = true)]
    public string? ParamValue { get; set; }

    [SugarColumn(ColumnDescription = "关键要素", ColumnDataType = "boolean")]
    public bool IsKeyElement { 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; }
}