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

/// <summary>
/// 条码规则主数据（复刻 BarCodeNbr）
/// </summary>
[SugarTable("BarCodeNbr", "条码规则主数据（复刻 BarCodeNbr）")]
[SugarIndex("uk_BarCodeNbr_domain_customer_type", nameof(DomainCode), OrderByType.Asc, nameof(Customer), OrderByType.Asc, nameof(Type), OrderByType.Asc, IsUnique = true)]
public class AdoS0BarCodeNbr
{
    [SugarColumn(ColumnName = "rec_id", ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    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_code", ColumnDescription = "工厂域编码", Length = 50)]
    public string DomainCode { get; set; } = string.Empty;

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

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

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

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

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

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

    [SugarColumn(ColumnName = "firm_string1", Length = 100, IsNullable = true)] public string? FirmString1 { get; set; }
    [SugarColumn(ColumnName = "firm_string_len1", IsNullable = true)] public int? FirmStringLen1 { get; set; }
    [SugarColumn(ColumnName = "firm_string1_note", Length = 200, IsNullable = true)] public string? FirmString1Note { get; set; }

    [SugarColumn(ColumnName = "firm_string2", Length = 100, IsNullable = true)] public string? FirmString2 { get; set; }
    [SugarColumn(ColumnName = "firm_string_len2", IsNullable = true)] public int? FirmStringLen2 { get; set; }
    [SugarColumn(ColumnName = "firm_string2_note", Length = 200, IsNullable = true)] public string? FirmString2Note { get; set; }

    [SugarColumn(ColumnName = "firm_string3", Length = 100, IsNullable = true)] public string? FirmString3 { get; set; }
    [SugarColumn(ColumnName = "firm_string_len3", IsNullable = true)] public int? FirmStringLen3 { get; set; }
    [SugarColumn(ColumnName = "firm_string3_note", Length = 200, IsNullable = true)] public string? FirmString3Note { get; set; }

    [SugarColumn(ColumnName = "firm_string4", Length = 100, IsNullable = true)] public string? FirmString4 { get; set; }
    [SugarColumn(ColumnName = "firm_string_len4", IsNullable = true)] public int? FirmStringLen4 { get; set; }
    [SugarColumn(ColumnName = "firm_string4_note", Length = 200, IsNullable = true)] public string? FirmString4Note { get; set; }

    [SugarColumn(ColumnName = "firm_string5", Length = 100, IsNullable = true)] public string? FirmString5 { get; set; }
    [SugarColumn(ColumnName = "firm_string_len5", IsNullable = true)] public int? FirmStringLen5 { get; set; }
    [SugarColumn(ColumnName = "firm_string5_note", Length = 200, IsNullable = true)] public string? FirmString5Note { get; set; }

    [SugarColumn(ColumnName = "firm_string6", Length = 100, IsNullable = true)] public string? FirmString6 { get; set; }
    [SugarColumn(ColumnName = "firm_string_len6", IsNullable = true)] public int? FirmStringLen6 { get; set; }
    [SugarColumn(ColumnName = "firm_string6_note", Length = 200, IsNullable = true)] public string? FirmString6Note { get; set; }

    [SugarColumn(ColumnName = "firm_string7", Length = 100, IsNullable = true)] public string? FirmString7 { get; set; }
    [SugarColumn(ColumnName = "firm_string_len7", IsNullable = true)] public int? FirmStringLen7 { get; set; }
    [SugarColumn(ColumnName = "firm_string7_note", Length = 200, IsNullable = true)] public string? FirmString7Note { get; set; }

    [SugarColumn(ColumnName = "firm_string8", Length = 100, IsNullable = true)] public string? FirmString8 { get; set; }
    [SugarColumn(ColumnName = "firm_string_len8", IsNullable = true)] public int? FirmStringLen8 { get; set; }
    [SugarColumn(ColumnName = "firm_string8_note", Length = 200, IsNullable = true)] public string? FirmString8Note { get; set; }

    [SugarColumn(ColumnName = "firm_string9", Length = 100, IsNullable = true)] public string? FirmString9 { get; set; }
    [SugarColumn(ColumnName = "firm_string_len9", IsNullable = true)] public int? FirmStringLen9 { get; set; }
    [SugarColumn(ColumnName = "firm_string9_note", Length = 200, IsNullable = true)] public string? FirmString9Note { get; set; }

    [SugarColumn(ColumnName = "firm_string10", Length = 100, IsNullable = true)] public string? FirmString10 { get; set; }
    [SugarColumn(ColumnName = "firm_string_len10", IsNullable = true)] public int? FirmStringLen10 { get; set; }
    [SugarColumn(ColumnName = "firm_string10_note", Length = 200, IsNullable = true)] public string? FirmString10Note { get; set; }

    [SugarColumn(ColumnName = "firm_string11", Length = 100, IsNullable = true)] public string? FirmString11 { get; set; }
    [SugarColumn(ColumnName = "firm_string_len11", IsNullable = true)] public int? FirmStringLen11 { get; set; }
    [SugarColumn(ColumnName = "firm_string11_note", Length = 200, IsNullable = true)] public string? FirmString11Note { get; set; }

    [SugarColumn(ColumnName = "firm_string12", Length = 100, IsNullable = true)] public string? FirmString12 { get; set; }
    [SugarColumn(ColumnName = "firm_string_len12", IsNullable = true)] public int? FirmStringLen12 { get; set; }
    [SugarColumn(ColumnName = "firm_string12_note", Length = 200, IsNullable = true)] public string? FirmString12Note { get; set; }

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

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

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

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

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