AdoS0MaterialPlanCycle.cs 2.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. namespace Admin.NET.Plugin.AiDOP.Entity.S0.Supply;
  2. /// <summary>
  3. /// 物料计划周期标准(工厂 + 订单类型维度,标准小时;与 S3 物料计划周期指标对比时需在业务层约定小时↔天换算)。
  4. /// </summary>
  5. [SugarTable("S0MaterialPlanCycle", "物料计划周期标准")]
  6. [SugarIndex("uk_S0MaterialPlanCycle_factory_ordertype",
  7. nameof(TenantId), OrderByType.Asc,
  8. nameof(FactoryRefId), OrderByType.Asc,
  9. nameof(OrderType), OrderByType.Asc,
  10. IsUnique = true)]
  11. public class AdoS0MaterialPlanCycle : ITenantIdFilter
  12. {
  13. [SugarColumn(ColumnName = "rec_id", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
  14. public long Id { get; set; }
  15. [SugarColumn(ColumnName = "company_ref_id", ColumnDataType = "bigint")]
  16. public long CompanyRefId { get; set; }
  17. [SugarColumn(ColumnName = "factory_ref_id", ColumnDataType = "bigint")]
  18. public long FactoryRefId { get; set; }
  19. [SugarColumn(ColumnName = "domain_code", Length = 50, IsNullable = true)]
  20. public string? DomainCode { get; set; }
  21. /// <summary>订单类型;空字符串表示默认/不限。</summary>
  22. [SugarColumn(ColumnName = "order_type", Length = 100)]
  23. public string OrderType { get; set; } = string.Empty;
  24. [SugarColumn(ColumnName = "std_hours")]
  25. public int StdHours { get; set; }
  26. [SugarColumn(ColumnName = "remarks", Length = 500, IsNullable = true)]
  27. public string? Remarks { get; set; }
  28. [SugarColumn(ColumnName = "is_active", ColumnDataType = "boolean")]
  29. public bool IsActive { get; set; } = true;
  30. [SugarColumn(ColumnName = "create_user", Length = 100, IsNullable = true)]
  31. public string? CreateUser { get; set; }
  32. [SugarColumn(ColumnName = "create_time")]
  33. public DateTime CreateTime { get; set; } = DateTime.Now;
  34. [SugarColumn(ColumnName = "update_user", Length = 100, IsNullable = true)]
  35. public string? UpdateUser { get; set; }
  36. [SugarColumn(ColumnName = "update_time", IsNullable = true)]
  37. public DateTime? UpdateTime { get; set; }
  38. [SugarColumn(ColumnName = "tenant_id", IsNullable = true)]
  39. public long? TenantId { get; set; }
  40. }