cpWCS_TaskDtl.cs 2.2 KB

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