AdoS0LocationShelfMaster.cs 2.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. namespace Admin.NET.Plugin.AiDOP.Entity.S0.Warehouse;
  2. /// <summary>
  3. /// 货架主数据(复刻 LocationShelfMaster,从属于 LocationMaster 聚合)
  4. /// </summary>
  5. [SugarTable("LocationShelfMaster", "货架主数据(复刻 LocationShelfMaster)")]
  6. [SugarIndex("uk_LocationShelfMaster_domain_loc_shelf", nameof(DomainCode), OrderByType.Asc, nameof(Location), OrderByType.Asc, nameof(InvShelf), OrderByType.Asc, IsUnique = true)]
  7. public class AdoS0LocationShelfMaster
  8. {
  9. [SugarColumn(ColumnName = "rec_id", ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
  10. public long Id { get; set; }
  11. [SugarColumn(ColumnName = "company_ref_id", ColumnDescription = "关联公司 ID", ColumnDataType = "bigint")]
  12. public long CompanyRefId { get; set; }
  13. [SugarColumn(ColumnName = "factory_ref_id", ColumnDescription = "关联工厂 ID", ColumnDataType = "bigint")]
  14. public long FactoryRefId { get; set; }
  15. [SugarColumn(ColumnName = "domain_code", ColumnDescription = "工厂域编码", Length = 50)]
  16. public string DomainCode { get; set; } = string.Empty;
  17. [SugarColumn(ColumnName = "location", ColumnDescription = "所属库位编码", Length = 100)]
  18. public string Location { get; set; } = string.Empty;
  19. [SugarColumn(ColumnName = "inv_shelf", ColumnDescription = "货架编码", Length = 100)]
  20. public string InvShelf { get; set; } = string.Empty;
  21. [SugarColumn(ColumnName = "descr", ColumnDescription = "货架说明", Length = 255, IsNullable = true)]
  22. public string? Descr { get; set; }
  23. [SugarColumn(ColumnName = "area", ColumnDescription = "区域", Length = 100, IsNullable = true)]
  24. public string? Area { get; set; }
  25. [SugarColumn(ColumnName = "create_user", ColumnDescription = "创建人", Length = 100, IsNullable = true)]
  26. public string? CreateUser { get; set; }
  27. [SugarColumn(ColumnName = "create_time", ColumnDescription = "创建时间")]
  28. public DateTime CreateTime { get; set; } = DateTime.Now;
  29. [SugarColumn(ColumnName = "update_user", ColumnDescription = "更新人", Length = 100, IsNullable = true)]
  30. public string? UpdateUser { get; set; }
  31. [SugarColumn(ColumnName = "update_time", ColumnDescription = "更新时间", IsNullable = true)]
  32. public DateTime? UpdateTime { get; set; }
  33. /// <summary>列表展示:库位说明(不落库,来自 LocationMaster 关联)</summary>
  34. [SugarColumn(IsIgnore = true)]
  35. public string? LocationDescr { get; set; }
  36. /// <summary>列表展示:库位:货架 拼接(不落库)</summary>
  37. [SugarColumn(IsIgnore = true)]
  38. public string? KwhjName { get; set; }
  39. }