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

/// <summary>
/// 条码规则主数据（复刻 BarCodeNbr）。
/// DB 存在新旧两套列：业务真实数据落在旧 PascalCase 列；snake_case 列由历史 CodeFirst 阶段补加但当前唯一 1 行全空。
/// 本 Entity 将业务字段 ColumnName 改回 DB 真实 PascalCase 列；组织字段保留 snake_case 映射。
/// 加 [IgnoreTable] 防止 CodeFirst 继续 ALTER；移除 snake_case 唯一索引（DB 现有索引保持不变）。
/// </summary>
[IgnoreTable]
[SugarTable("BarCodeNbr", "条码规则主数据（复刻 BarCodeNbr）")]
public class AdoS0BarCodeNbr
{
    [SugarColumn(ColumnName = "RecID", ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true)]
    public long Id { get; set; }

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

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

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

    [SugarColumn(ColumnName = "Customer", ColumnDescription = "客户/供应商编码", Length = 50, IsNullable = true)]
    public string? Customer { get; set; }

    [SugarColumn(ColumnName = "Type", ColumnDescription = "条码类型", Length = 30, IsNullable = true)]
    public string? Type { get; set; }

    [SugarColumn(ColumnName = "WaterRules", ColumnDescription = "流水规则", Length = 8, IsNullable = true)]
    public string? WaterRules { get; set; }

    [SugarColumn(ColumnName = "WaterLen", ColumnDescription = "流水长度", IsNullable = true)]
    public int? WaterLen { get; set; }

    [SugarColumn(ColumnName = "Separator", ColumnDescription = "分隔符", Length = 8, IsNullable = true)]
    public string? Separator { get; set; }

    [SugarColumn(ColumnName = "FirmLength", ColumnDescription = "固定长度", IsNullable = true)]
    public int? FirmLength { get; set; }

    [SugarColumn(ColumnName = "FirmString1", Length = 20, IsNullable = true)] public string? FirmString1 { get; set; }
    [SugarColumn(ColumnName = "FirmStringLen1", IsNullable = true)] public int? FirmStringLen1 { get; set; }
    [SugarColumn(ColumnName = "FirmString1Note", Length = 30, IsNullable = true)] public string? FirmString1Note { get; set; }

    [SugarColumn(ColumnName = "FirmString2", Length = 20, IsNullable = true)] public string? FirmString2 { get; set; }
    [SugarColumn(ColumnName = "FirmStringLen2", IsNullable = true)] public int? FirmStringLen2 { get; set; }
    [SugarColumn(ColumnName = "FirmString2Note", Length = 30, IsNullable = true)] public string? FirmString2Note { get; set; }

    [SugarColumn(ColumnName = "FirmString3", Length = 20, IsNullable = true)] public string? FirmString3 { get; set; }
    [SugarColumn(ColumnName = "FirmStringLen3", IsNullable = true)] public int? FirmStringLen3 { get; set; }
    [SugarColumn(ColumnName = "FirmString3Note", Length = 30, IsNullable = true)] public string? FirmString3Note { get; set; }

    [SugarColumn(ColumnName = "FirmString4", Length = 20, IsNullable = true)] public string? FirmString4 { get; set; }
    [SugarColumn(ColumnName = "FirmStringLen4", IsNullable = true)] public int? FirmStringLen4 { get; set; }
    [SugarColumn(ColumnName = "FirmString4Note", Length = 30, IsNullable = true)] public string? FirmString4Note { get; set; }

    [SugarColumn(ColumnName = "FirmString5", Length = 20, IsNullable = true)] public string? FirmString5 { get; set; }
    [SugarColumn(ColumnName = "FirmStringLen5", IsNullable = true)] public int? FirmStringLen5 { get; set; }
    [SugarColumn(ColumnName = "FirmString5Note", Length = 30, IsNullable = true)] public string? FirmString5Note { get; set; }

    [SugarColumn(ColumnName = "FirmString6", Length = 20, IsNullable = true)] public string? FirmString6 { get; set; }
    [SugarColumn(ColumnName = "FirmStringLen6", IsNullable = true)] public int? FirmStringLen6 { get; set; }
    [SugarColumn(ColumnName = "FirmString6Note", Length = 30, IsNullable = true)] public string? FirmString6Note { get; set; }

    [SugarColumn(ColumnName = "FirmString7", Length = 20, IsNullable = true)] public string? FirmString7 { get; set; }
    [SugarColumn(ColumnName = "FirmStringLen7", IsNullable = true)] public int? FirmStringLen7 { get; set; }
    [SugarColumn(ColumnName = "FirmString7Note", Length = 30, IsNullable = true)] public string? FirmString7Note { get; set; }

    [SugarColumn(ColumnName = "FirmString8", Length = 20, IsNullable = true)] public string? FirmString8 { get; set; }
    [SugarColumn(ColumnName = "FirmStringLen8", IsNullable = true)] public int? FirmStringLen8 { get; set; }
    [SugarColumn(ColumnName = "FirmString8Note", Length = 30, IsNullable = true)] public string? FirmString8Note { get; set; }

    [SugarColumn(ColumnName = "FirmString9", Length = 20, IsNullable = true)] public string? FirmString9 { get; set; }
    [SugarColumn(ColumnName = "FirmStringLen9", IsNullable = true)] public int? FirmStringLen9 { get; set; }
    [SugarColumn(ColumnName = "FirmString9Note", Length = 30, IsNullable = true)] public string? FirmString9Note { get; set; }

    [SugarColumn(ColumnName = "FirmString10", Length = 20, IsNullable = true)] public string? FirmString10 { get; set; }
    [SugarColumn(ColumnName = "FirmStringLen10", IsNullable = true)] public int? FirmStringLen10 { get; set; }
    [SugarColumn(ColumnName = "FirmString10Note", Length = 30, IsNullable = true)] public string? FirmString10Note { get; set; }

    [SugarColumn(ColumnName = "FirmString11", Length = 20, IsNullable = true)] public string? FirmString11 { get; set; }
    [SugarColumn(ColumnName = "FirmStringLen11", IsNullable = true)] public int? FirmStringLen11 { get; set; }
    [SugarColumn(ColumnName = "FirmString11Note", Length = 30, IsNullable = true)] public string? FirmString11Note { get; set; }

    [SugarColumn(ColumnName = "FirmString12", Length = 20, IsNullable = true)] public string? FirmString12 { get; set; }
    [SugarColumn(ColumnName = "FirmStringLen12", IsNullable = true)] public int? FirmStringLen12 { get; set; }
    [SugarColumn(ColumnName = "FirmString12Note", Length = 30, IsNullable = true)] public string? FirmString12Note { get; set; }

    [SugarColumn(ColumnName = "ItemNum", ColumnDescription = "物料编码", Length = 30, IsNullable = true)]
    public string? ItemNum { get; set; }

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

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

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

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

    /// <summary>列表展示：供应商简称（不落库，来自 SuppMaster 关联）</summary>
    [SugarColumn(IsIgnore = true)]
    public string? SuppName { get; set; }
}