WCS_TaskDtl.cs 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475
  1. using SqlSugar;
  2. using System;
  3. using System.ComponentModel.DataAnnotations.Schema;
  4. using wms.sqlsugar;
  5. using wms.sqlsugar.model;
  6. namespace WCS.Entity.fj
  7. {
  8. /// <summary>
  9. /// 任务流转表
  10. /// </summary>
  11. [Tenant("fj")]
  12. [SugarTable(nameof(WCS_TaskDtl) + "_{year}{month}{day}", "任务流转表")]
  13. [SplitTable(SplitType.Month)]//按年分表 (自带分表支持 年、季、月、周、日)
  14. public class WCS_TaskDtl: BaseModel1
  15. {
  16. /// <summary>
  17. /// ID
  18. /// </summary>
  19. [SugarColumn(IsPrimaryKey = true, ColumnDescription = "ID")]
  20. [Column(Order = 0)]
  21. public Guid ID { get; set; }
  22. /// <summary>
  23. /// 父级任务号
  24. /// </summary>
  25. [SugarColumn(ColumnDescription = "父级任务号")]
  26. public int ParentTaskCode { get; set; }
  27. /// <summary>
  28. /// 当前位置
  29. /// </summary>
  30. [SugarColumn(ColumnDescription = "当前位置")]
  31. public string CurPoint { get; set; }
  32. /// <summary>
  33. /// 下一个地址
  34. /// </summary>
  35. [SugarColumn(ColumnDescription = "下一个地址", IsNullable = true)]
  36. public string NextPoint { get; set; }
  37. /// <summary>
  38. /// 描述
  39. /// </summary>
  40. [SugarColumn(ColumnDescription = "描述")]
  41. public string Desc { get; set; }
  42. /// <summary>
  43. /// 是否可用
  44. /// </summary>
  45. [SugarColumn(ColumnDescription = "是否可用")]
  46. public bool Enabled { get; set; } = true;
  47. /// <summary>
  48. /// 创建用户
  49. /// 仅记录用户ID
  50. /// </summary>
  51. [SugarColumn(ColumnDescription = "创建用户", Length = 50)]
  52. public string AddWho { get; set; }
  53. /// <summary>
  54. /// 创建时间
  55. /// 新增数据时自动获取服务器时间
  56. /// </summary>
  57. [SugarColumn(ColumnDescription = "创建时间", InsertServerTime = true)]
  58. [SplitField]
  59. public DateTime AddTime { get; set; }
  60. /// <summary>
  61. /// 版本号
  62. /// </summary>
  63. [SugarColumn(ColumnDescription = "版本号", ColumnDataType = "timestamp", IsNullable = true, IsOnlyIgnoreInsert = true, IsOnlyIgnoreUpdate = true)]
  64. public byte[] VER { get; set; }
  65. }
  66. }