SYS_SEQUENCE.cs 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104
  1. using System;
  2. //Nhibernate Code Generation Template 1.0
  3. //author:MythXin
  4. //blog:www.cnblogs.com/MythXin
  5. //Entity Code Generation Template
  6. namespace NXWMS.DataAccess.Entity
  7. {
  8. //系统序列表(主键管理)
  9. public class SYS_SEQUENCE
  10. {
  11. /// <summary>
  12. /// 系统主键
  13. /// </summary>
  14. public int SQ_ID{get;set;}
  15. /// <summary>
  16. /// NewId主键
  17. /// </summary>
  18. public string NEWID{get;set;}
  19. /// <summary>
  20. /// 序列编码
  21. /// </summary>
  22. public string SQ_CODE{get;set;}
  23. /// <summary>
  24. /// 序列描述
  25. /// </summary>
  26. public string SQ_DESC{get;set;}
  27. /// <summary>
  28. /// 序列当前ID值
  29. /// </summary>
  30. public int SQ_NOW_ID{get;set;}
  31. /// <summary>
  32. /// 序列类型。
  33. //1是普通ID每次累加1且不循环
  34. //2为循环ID到达最大值后会从新重1开始
  35. //3为固定长度id每次生成id会按照ID长度生成不足就左边补0
  36. //4为带前缀固定长度ID与类型3相同,只是会增加一个前缀字段
  37. //5为带日期的固定长度ID,每天从1开始更新
  38. /// </summary>
  39. public int SQ_TYPE{get;set;}
  40. /// <summary>
  41. /// 序列ID最小值
  42. /// </summary>
  43. public int? SQ_MIN_ID{get;set;}
  44. /// <summary>
  45. /// 序列ID最大值
  46. /// </summary>
  47. public int? SQ_MAX_ID{get;set;}
  48. /// <summary>
  49. /// 序列长度
  50. /// </summary>
  51. public int? SQ_LENGTH{get;set;}
  52. /// <summary>
  53. /// 序列前缀
  54. /// </summary>
  55. public string SQ_PREFIX{get;set;}
  56. /// <summary>
  57. /// 最后获取序列的日期
  58. /// </summary>
  59. public string SQ_LAST_DATE{get;set;}
  60. /// <summary>
  61. /// 序列数据版本号。时间戳类型保证操作的原子性。
  62. /// </summary>
  63. public DateTime SQ_VERSION{get;set;}
  64. /// <summary>
  65. /// 创建人
  66. /// </summary>
  67. public int CREATE_BY{get;set;}
  68. /// <summary>
  69. /// 创建时间
  70. /// </summary>
  71. public DateTime CREATE_TIME{get;set;}
  72. /// <summary>
  73. /// 更新人
  74. /// </summary>
  75. public int UPDATE_BY{get;set;}
  76. /// <summary>
  77. /// 更新时间
  78. /// </summary>
  79. public DateTime UPDATE_TIME{get;set;}
  80. /// <summary>
  81. /// 备用字段1
  82. /// </summary>
  83. public string REMARKS1{get;set;}
  84. /// <summary>
  85. /// 备用字段2
  86. /// </summary>
  87. public string REMARKS2{get;set;}
  88. /// <summary>
  89. /// 备用字段3
  90. /// </summary>
  91. public string REMARKS3{get;set;}
  92. /// <summary>
  93. /// 备用字段4
  94. /// </summary>
  95. public string REMARKS4{get;set;}
  96. /// <summary>
  97. /// 备用字段5
  98. /// </summary>
  99. public string REMARKS5{get;set;}
  100. }
  101. }