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

/// <summary>
/// 前处理要素独立表。
/// </summary>
[SugarTable("PreprocessElement", "前处理要素表")]
public class AdoS0MfgPreprocessElement
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "前处理要素主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "item_num", ColumnDescription = "物料编码", Length = 100)]
    public string ItemNum { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "op", ColumnDescription = "工序编码", Length = 100, IsNullable = true)]
    public string? Op { get; set; }

    [SugarColumn(ColumnName = "line", ColumnDescription = "生产线编码", Length = 100, IsNullable = true)]
    public string? Line { get; set; }

    [SugarColumn(ColumnName = "typed", ColumnDescription = "类型编码", Length = 100, IsNullable = true)]
    public string? Typed { get; set; }

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

    [SugarColumn(ColumnName = "descr", ColumnDescription = "描述", Length = 255, IsNullable = true)]
    public string? Descr { get; set; }

    [SugarColumn(ColumnName = "is_main", ColumnDescription = "是否关键", ColumnDataType = "boolean")]
    public bool IsMain { get; set; }

    [SugarColumn(ColumnName = "domain", ColumnDescription = "工厂域编码", Length = 50)]
    public string Domain { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "create_user", ColumnDescription = "创建人", Length = 64, IsNullable = true)]
    public string? CreateUser { get; set; }

    [SugarColumn(ColumnName = "create_time", ColumnDescription = "创建时间", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "update_user", ColumnDescription = "更新人", Length = 64, IsNullable = true)]
    public string? UpdateUser { get; set; }

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

/// <summary>
/// 前处理要素参数独立表。
/// </summary>
[SugarTable("PreprocessElementParam", "前处理要素参数表")]
public class AdoS0MfgPreprocessElementParam
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "前处理要素参数主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "device_number", ColumnDescription = "要素编码", Length = 100)]
    public string DeviceNumber { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "device_descr", ColumnDescription = "要素描述", Length = 255, IsNullable = true)]
    public string? DeviceDescr { get; set; }

    [SugarColumn(ColumnName = "message_code", ColumnDescription = "参数编码", Length = 100)]
    public string MessageCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "code_descr", ColumnDescription = "参数描述", Length = 255, IsNullable = true)]
    public string? CodeDescr { get; set; }

    [SugarColumn(ColumnName = "value_type", ColumnDescription = "值类型", Length = 50, IsNullable = true)]
    public string? ValueType { get; set; }

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

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

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

    [SugarColumn(ColumnName = "ufld1", ColumnDescription = "值选择数据", Length = 1000, IsNullable = true)]
    public string? Ufld1 { get; set; }

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

    [SugarColumn(ColumnName = "domain", ColumnDescription = "工厂域编码", Length = 50)]
    public string Domain { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "create_user", ColumnDescription = "创建人", Length = 64, IsNullable = true)]
    public string? CreateUser { get; set; }

    [SugarColumn(ColumnName = "create_time", ColumnDescription = "创建时间", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "update_user", ColumnDescription = "更新人", Length = 64, IsNullable = true)]
    public string? UpdateUser { get; set; }

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