AdoS0TaskAssignment.cs 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990
  1. namespace Admin.NET.Plugin.AiDOP.Entity.S0.Warehouse;
  2. /// <summary>
  3. /// 物料状态任务指派(复刻 wms_rwzp)。
  4. /// 租户:wms_rwzp 属租户级业务表 → 实现 ITenantIdFilter,启用全局 AOP 租户隔离;
  5. /// Controller 另显式按 TenantId 收口(兼顾超管未选租户拒绝)。租户内唯一由 UpdateScripts 索引保证。
  6. /// </summary>
  7. [SugarTable("wms_rwzp", "物料状态任务指派(复刻 wms_rwzp)")]
  8. public class AdoS0TaskAssignment : ITenantIdFilter
  9. {
  10. [SugarColumn(ColumnName = "rec_id", ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
  11. public long Id { get; set; }
  12. /// <summary>租户 ID(映射 tenant_id 列;实现 ITenantIdFilter,启用全局 AOP 租户隔离)。</summary>
  13. [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户 ID", ColumnDataType = "bigint", IsNullable = false)]
  14. public long? TenantId { get; set; }
  15. [SugarColumn(ColumnName = "company_ref_id", ColumnDescription = "关联公司 ID", ColumnDataType = "bigint")]
  16. public long CompanyRefId { get; set; }
  17. [SugarColumn(ColumnName = "factory_ref_id", ColumnDescription = "关联工厂 ID", ColumnDataType = "bigint")]
  18. public long FactoryRefId { get; set; }
  19. [SugarColumn(ColumnName = "domain_code", ColumnDescription = "工厂域编码", Length = 50)]
  20. public string DomainCode { get; set; } = string.Empty;
  21. /// <summary>提出日期(tcrq)</summary>
  22. [SugarColumn(ColumnName = "tcrq", ColumnDescription = "提出日期", IsNullable = true)]
  23. public DateTime? Tcrq { get; set; }
  24. /// <summary>申请人(sqr)</summary>
  25. [SugarColumn(ColumnName = "sqr", ColumnDescription = "申请人", Length = 100, IsNullable = true)]
  26. public string? Sqr { get; set; }
  27. /// <summary>任务类型(rwlx)</summary>
  28. [SugarColumn(ColumnName = "rwlx", ColumnDescription = "任务类型", Length = 50, IsNullable = true)]
  29. public string? Rwlx { get; set; }
  30. /// <summary>物料编码(wlbm)</summary>
  31. [SugarColumn(ColumnName = "wlbm", ColumnDescription = "物料编码", Length = 100, IsNullable = true)]
  32. public string? Wlbm { get; set; }
  33. /// <summary>数量(sl)</summary>
  34. [SugarColumn(ColumnName = "sl", ColumnDescription = "数量", IsNullable = true)]
  35. public decimal? Sl { get; set; }
  36. /// <summary>批次(rqpc)</summary>
  37. [SugarColumn(ColumnName = "rqpc", ColumnDescription = "批次", Length = 100, IsNullable = true)]
  38. public string? Rqpc { get; set; }
  39. /// <summary>原始库位(yskw)</summary>
  40. [SugarColumn(ColumnName = "yskw", ColumnDescription = "原始库位", Length = 100, IsNullable = true)]
  41. public string? Yskw { get; set; }
  42. /// <summary>目的库位(mdkw)</summary>
  43. [SugarColumn(ColumnName = "mdkw", ColumnDescription = "目的库位", Length = 100, IsNullable = true)]
  44. public string? Mdkw { get; set; }
  45. /// <summary>需求时间(xqsj)</summary>
  46. [SugarColumn(ColumnName = "xqsj", ColumnDescription = "需求时间", IsNullable = true)]
  47. public DateTime? Xqsj { get; set; }
  48. /// <summary>处理人(clr)</summary>
  49. [SugarColumn(ColumnName = "clr", ColumnDescription = "处理人", Length = 100, IsNullable = true)]
  50. public string? Clr { get; set; }
  51. /// <summary>备注(bz)</summary>
  52. [SugarColumn(ColumnName = "bz", ColumnDescription = "备注", Length = 500, IsNullable = true)]
  53. public string? Bz { get; set; }
  54. /// <summary>状态(zt)</summary>
  55. [SugarColumn(ColumnName = "zt", ColumnDescription = "状态", Length = 50, IsNullable = true)]
  56. public string? Zt { get; set; }
  57. [SugarColumn(ColumnName = "create_user", ColumnDescription = "创建人", Length = 100, IsNullable = true)]
  58. public string? CreateUser { get; set; }
  59. [SugarColumn(ColumnName = "create_time", ColumnDescription = "创建时间")]
  60. public DateTime CreateTime { get; set; } = DateTime.Now;
  61. [SugarColumn(ColumnName = "update_user", ColumnDescription = "更新人", Length = 100, IsNullable = true)]
  62. public string? UpdateUser { get; set; }
  63. [SugarColumn(ColumnName = "update_time", ColumnDescription = "更新时间", IsNullable = true)]
  64. public DateTime? UpdateTime { get; set; }
  65. /// <summary>列表展示:物料名称(不落库,来自 ItemMaster)</summary>
  66. [SugarColumn(IsIgnore = true)]
  67. public string? ItemDescr { get; set; }
  68. }