WTJLModel.cs 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333
  1. using QWPlatform.DataIntface.Database;
  2. using QWPlatform.Models;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Linq;
  6. using System.Text;
  7. using System.Threading.Tasks;
  8. namespace PMS.EntityModels.Product
  9. {
  10. /// <summary>
  11. /// 测试实体类
  12. /// </summary>
  13. [Table("问题记录")]
  14. public class WTJLModel : DataModelBase
  15. {
  16. //默认不带数据工厂构造
  17. public WTJLModel()
  18. {
  19. }
  20. //带有数据工厂的实例化,可以直接操作数据
  21. public WTJLModel(DataFactory factory)
  22. : base(factory)
  23. {
  24. }
  25. ///<summary>
  26. ///ID[必填项目],最大长度为:36,数据库类型:VARCHAR2
  27. ///</summary>
  28. [FieldBase("ID", "", "", true, false, "", 36, 0, "VARCHAR2")]
  29. public string ID { get; set; }
  30. ///<summary>
  31. ///编号[可为空],最大长度为:18,数据库类型:NUMBER
  32. ///</summary>
  33. [FieldBase("编号", "", "", false, false, "", 18, 0, "NUMBER")]
  34. public long? BH { get; set; }
  35. ///<summary>
  36. ///渠道ID[可为空],最大长度为:36,数据库类型:VARCHAR2
  37. ///</summary>
  38. [FieldBase("渠道ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
  39. public string QDID { get; set; }
  40. ///<summary>
  41. ///项目ID[可为空],最大长度为:36,数据库类型:VARCHAR2
  42. ///</summary>
  43. [FieldBase("项目ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
  44. public string XMID { get; set; }
  45. ///<summary>
  46. ///产品ID[可为空],最大长度为:36,数据库类型:VARCHAR2
  47. ///</summary>
  48. [FieldBase("产品ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
  49. public string CPID { get; set; }
  50. ///<summary>
  51. ///模块ID[可为空],最大长度为:36,数据库类型:VARCHAR2
  52. ///</summary>
  53. [FieldBase("模块ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
  54. public string MKID { get; set; }
  55. ///<summary>
  56. ///版本号[可为空],最大长度为:36,数据库类型:VARCHAR2
  57. ///</summary>
  58. [FieldBase("版本号", "", "", false, false, "", 36, 0, "VARCHAR2")]
  59. public string BBH { get; set; }
  60. ///<summary>
  61. ///来源代码[可为空],最大长度为:2,数据库类型:VARCHAR2
  62. ///</summary>
  63. [FieldBase("来源代码", "", "", false, false, "", 2, 0, "VARCHAR2")]
  64. public string LYDM { get; set; }
  65. ///<summary>
  66. ///登记人[可为空],最大长度为:50,数据库类型:VARCHAR2
  67. ///</summary>
  68. [FieldBase("登记人", "", "", false, false, "", 50, 0, "VARCHAR2")]
  69. public string DJR { get; set; }
  70. ///<summary>
  71. ///登记人ID[可为空],最大长度为:36,数据库类型:VARCHAR2
  72. ///</summary>
  73. [FieldBase("登记人ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
  74. public string DJRID { get; set; }
  75. ///<summary>
  76. ///登记日期[可为空],最大长度为:7,数据库类型:DATE
  77. ///</summary>
  78. [FieldBase("登记日期", "", "", false, false, "", 7, 0, "DATE")]
  79. public DateTime? DJRJ { get; set; }
  80. ///<summary>
  81. ///紧急代码[可为空],最大长度为:2,数据库类型:VARCHAR2
  82. ///</summary>
  83. [FieldBase("紧急代码", "", "", false, false, "", 2, 0, "VARCHAR2")]
  84. public string JJDM { get; set; }
  85. ///<summary>
  86. ///要求时间[可为空],最大长度为:7,数据库类型:DATE
  87. ///</summary>
  88. [FieldBase("要求时间", "", "", false, false, "", 7, 0, "DATE")]
  89. public DateTime? YQSJ { get; set; }
  90. ///<summary>
  91. ///紧急描述[可为空],最大长度为:500,数据库类型:VARCHAR2
  92. ///</summary>
  93. [FieldBase("紧急描述", "", "", false, false, "", 500, 0, "VARCHAR2")]
  94. public string JJMS { get; set; }
  95. ///<summary>
  96. ///问题标题[可为空],最大长度为:200,数据库类型:VARCHAR2
  97. ///</summary>
  98. [FieldBase("问题标题", "", "", false, false, "", 200, 0, "VARCHAR2")]
  99. public string WTBT { get; set; }
  100. ///<summary>
  101. ///问题描述[可为空],最大长度为:4000,数据库类型:CLOB
  102. ///</summary>
  103. [FieldBase("问题描述", "", "", false, false, "", 4000, 0, "CLOB")]
  104. public string WTMS { get; set; }
  105. ///<summary>
  106. ///反馈人[可为空],最大长度为:50,数据库类型:VARCHAR2
  107. ///</summary>
  108. [FieldBase("反馈人", "", "", false, false, "", 50, 0, "VARCHAR2")]
  109. public string FKR { get; set; }
  110. ///<summary>
  111. ///问题性质[可为空],最大长度为:1,数据库类型:NUMBER(对应问题类型编码:1:Bug2:任务3:需求4:优化)
  112. ///</summary>
  113. [FieldBase("问题性质", "(对应问题类型编码:1:Bug2:任务3:需求4:优化)", "", false, false, "", 1, 0, "NUMBER")]
  114. public int? WTXZ { get; set; }
  115. ///<summary>
  116. ///是否终止[可为空],最大长度为:1,数据库类型:NUMBER(0:正常,1:终止)
  117. ///</summary>
  118. [FieldBase("是否终止", "(0:正常,1:终止)", "", false, false, "", 1, 0, "NUMBER")]
  119. public int? SFZZ { get; set; }
  120. ///<summary>
  121. ///终止说明[可为空],最大长度为:200,数据库类型:VARCHAR2
  122. ///</summary>
  123. [FieldBase("终止说明", "", "", false, false, "", 200, 0, "VARCHAR2")]
  124. public string ZZSM { get; set; }
  125. ///<summary>
  126. ///终止日期[可为空],最大长度为:7,数据库类型:DATE
  127. ///</summary>
  128. [FieldBase("终止日期", "", "", false, false, "", 7, 0, "DATE")]
  129. public DateTime? ZZRJ { get; set; }
  130. ///<summary>
  131. ///是否回退[可为空],最大长度为:1,数据库类型:NUMBER(0:正常,1:回退)
  132. ///</summary>
  133. [FieldBase("是否回退", "(0:正常,1:回退)", "", false, false, "", 1, 0, "NUMBER")]
  134. public int? SFHT { get; set; }
  135. ///<summary>
  136. ///回退说明[可为空],最大长度为:200,数据库类型:VARCHAR2
  137. ///</summary>
  138. [FieldBase("回退说明", "", "", false, false, "", 200, 0, "VARCHAR2")]
  139. public string HTSM { get; set; }
  140. ///<summary>
  141. ///是否解决[可为空],最大长度为:1,数据库类型:NUMBER(0:未解决,1:解决)
  142. ///</summary>
  143. [FieldBase("是否解决", "(0:未解决,1:解决)", "", false, false, "", 1, 0, "NUMBER")]
  144. public int? SFJJ { get; set; }
  145. ///<summary>
  146. ///解决方案[可为空],最大长度为:200,数据库类型:VARCHAR2
  147. ///</summary>
  148. [FieldBase("解决方案", "", "", false, false, "", 200, 0, "VARCHAR2")]
  149. public string JJFA { get; set; }
  150. ///<summary>
  151. ///解决版本[可为空],最大长度为:200,数据库类型:VARCHAR2
  152. ///</summary>
  153. [FieldBase("解决版本", "", "", false, false, "", 200, 0, "VARCHAR2")]
  154. public string JJBB { get; set; }
  155. ///<summary>
  156. ///BH版本[可为空],最大长度为:50,数据库类型:VARCHAR2
  157. ///</summary>
  158. [FieldBase("BH版本", "", "", false, false, "", 50, 0, "VARCHAR2")]
  159. public string BHBB { get; set; }
  160. ///<summary>
  161. ///BH编号[可为空],最大长度为:50,数据库类型:VARCHAR2
  162. ///</summary>
  163. [FieldBase("BH编号", "", "", false, false, "", 50, 0, "VARCHAR2")]
  164. public string BHBH { get; set; }
  165. ///<summary>
  166. ///关键字[可为空],最大长度为:200,数据库类型:VARCHAR2
  167. ///</summary>
  168. [FieldBase("关键字", "", "", false, false, "", 200, 0, "VARCHAR2")]
  169. public string GJZ { get; set; }
  170. ///<summary>
  171. ///常见问题[可为空],最大长度为:200,数据库类型:VARCHAR2
  172. ///</summary>
  173. [FieldBase("常见问题", "", "", false, false, "", 200, 0, "VARCHAR2")]
  174. public int? CJWT { get; set; }
  175. ///<summary>
  176. ///修改说明[可为空],最大长度为:200,数据库类型:VARCHAR2
  177. ///</summary>
  178. [FieldBase("修改说明", "", "", false, false, "", 200, 0, "VARCHAR2")]
  179. public string XGSM { get; set; }
  180. ///<summary>
  181. ///测试说明[可为空],最大长度为:200,数据库类型:VARCHAR2
  182. ///</summary>
  183. [FieldBase("测试说明", "", "", false, false, "", 200, 0, "VARCHAR2")]
  184. public string CSSM { get; set; }
  185. ///<summary>
  186. ///升级说明[可为空],最大长度为:200,数据库类型:VARCHAR2
  187. ///</summary>
  188. [FieldBase("升级说明", "", "", false, false, "", 200, 0, "VARCHAR2")]
  189. public string SJSM { get; set; }
  190. ///<summary>
  191. ///是否发布[可为空],最大长度为:1,数据库类型:NUMBER(0:未发布,1:已发布)
  192. ///</summary>
  193. [FieldBase("是否发布", "(0:未发布,1:已发布)", "", false, false, "", 1, 0, "NUMBER")]
  194. public int? SFFB { get; set; }
  195. ///<summary>
  196. ///需要培训[可为空],最大长度为:1,数据库类型:NUMBER(0:不需要,1:需要)
  197. ///</summary>
  198. [FieldBase("需要培训", "(0:不需要,1:需要)", "", false, false, "", 1, 0, "NUMBER")]
  199. public int? XYPX { get; set; }
  200. ///<summary>
  201. ///项目处理[可为空],最大长度为:1,数据库类型:NUMBER(0:否,1:是)
  202. ///</summary>
  203. [FieldBase("项目处理", "(0:否,1:是)", "", false, false, "", 1, 0, "NUMBER")]
  204. public int? XMCL { get; set; }
  205. ///<summary>
  206. ///技术支持[可为空],最大长度为:1,数据库类型:NUMBER(0:否,1:是)
  207. ///</summary>
  208. [FieldBase("技术支持", "(0:否,1:是)", "", false, false, "", 1, 0, "NUMBER")]
  209. public int? JSZC { get; set; }
  210. ///<summary>
  211. ///研发协助[可为空],最大长度为:1,数据库类型:NUMBER(0:否,1:是)
  212. ///</summary>
  213. [FieldBase("研发协助", "(0:否,1:是)", "", false, false, "", 1, 0, "NUMBER")]
  214. public int? YFXZ { get; set; }
  215. ///<summary>
  216. ///问题类型[可为空],最大长度为:1,数据库类型:NUMBER(1:项目问题,2:产品问题)
  217. ///</summary>
  218. [FieldBase("问题类型", "(1:项目问题,2:产品问题)", "", false, false, "", 1, 0, "NUMBER")]
  219. public int? WTLX { get; set; }
  220. ///<summary>
  221. ///流程ID[可为空],最大长度为:10,数据库类型:NUMBER(关联问题工作流程表)
  222. ///</summary>
  223. [FieldBase("流程ID", "(关联问题工作流程表)", "", false, false, "", 10, 0, "NUMBER")]
  224. public int? LCID { get; set; }
  225. ///<summary>
  226. ///是否受理[可为空],最大长度为:1,数据库类型:NUMBER(0:否,1:是)
  227. ///</summary>
  228. [FieldBase("是否受理", "(0:否,1:是)", "", false, false, "", 1, 0, "NUMBER")]
  229. public int? SFSL { get; set; }
  230. ///<summary>
  231. ///受理人[可为空],最大长度为:50,数据库类型:VARCHAR2(受理处理该问题的人员姓名)
  232. ///</summary>
  233. [FieldBase("受理人", "(受理处理该问题的人员姓名)", "", false, false, "", 50, 0, "VARCHAR2")]
  234. public string SLR { get; set; }
  235. ///<summary>
  236. ///受理人ID[可为空],最大长度为:36,数据库类型:VARCHAR2
  237. ///</summary>
  238. [FieldBase("受理人ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
  239. public string SLRID { get; set; }
  240. ///<summary>
  241. ///受理时间[可为空],最大长度为:7,数据库类型:DATE
  242. ///</summary>
  243. [FieldBase("受理时间", "", "", false, false, "", 7, 0, "DATE")]
  244. public DateTime? SLSJ { get; set; }
  245. ///<summary>
  246. ///指派人[可为空],最大长度为:50,数据库类型:VARCHAR2(指派具体的处理人员姓名)
  247. ///</summary>
  248. [FieldBase("指派人", "(指派具体的处理人员姓名)", "", false, false, "", 50, 0, "VARCHAR2")]
  249. public string ZPR { get; set; }
  250. ///<summary>
  251. ///指派人ID[可为空],最大长度为:36,数据库类型:VARCHAR2
  252. ///</summary>
  253. [FieldBase("指派人ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
  254. public string ZPRID { get; set; }
  255. ///<summary>
  256. ///指派时间[可为空],最大长度为:7,数据库类型:DATE
  257. ///</summary>
  258. [FieldBase("指派时间", "", "", false, false, "", 7, 0, "DATE")]
  259. public DateTime? ZPSJ { get; set; }
  260. ///<summary>
  261. ///机构ID[可为空],最大长度为:36,数据库类型:VARCHAR2
  262. ///</summary>
  263. [FieldBase("机构ID", "", "", false, false, "", 36, 0, "VARCHAR2")]
  264. public string JGID { get; set; }
  265. ///<summary>
  266. ///环节ID[可为空],最大长度为:10,数据库类型:NUMBER(关联问题流程环节表的ID)
  267. ///</summary>
  268. [FieldBase("环节ID", "(关联问题流程环节表的ID)", "", false, false, "", 10, 0, "NUMBER")]
  269. public int? HJID { get; set; }
  270. /// <summary>
  271. /// 仅查看我的问题复选框
  272. /// </summary>
  273. public bool satate { get; set; }
  274. /// <summary>
  275. /// 人员性质(用于数据权限)
  276. /// </summary>
  277. public int RYXZ { get; set; }
  278. }
  279. }