WCS_TaskDtl.cs 2.3 KB

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