QueryModel.cs 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. namespace PMS.BusinessModels.Problem
  7. {
  8. /// <summary>
  9. /// 查询参数的model
  10. /// </summary>
  11. public class QueryModel
  12. {
  13. /// <summary>
  14. /// 渠道ID
  15. /// </summary>
  16. public string companyId { get; set; }
  17. /// <summary>
  18. /// 项目ID
  19. /// </summary>
  20. public string projectId { get; set; }
  21. /// <summary>
  22. ///机构ID
  23. /// </summary>
  24. public string orgId { get; set; }
  25. /// <summary>
  26. /// 产品ID
  27. /// </summary>
  28. public string productId { get; set; }
  29. /// <summary>
  30. /// 模块ID
  31. /// </summary>
  32. public string productModuleId { get; set; }
  33. /// <summary>
  34. /// 问题性质(bug, 需求,优化)
  35. /// </summary>
  36. public int property { get; set; }
  37. /// <summary>
  38. /// 优先级(低中高紧急)
  39. /// </summary>
  40. public int priority { get; set; }
  41. /// <summary>
  42. /// 工作节点内容
  43. /// </summary>
  44. public string workflowNode { get; set; }
  45. /// <summary>
  46. /// 关键字
  47. /// </summary>
  48. public string keyword { get; set; }
  49. /// <summary>
  50. /// 登记问题的开始时间
  51. /// </summary>
  52. public DateTime startDate { get; set; }
  53. /// <summary>
  54. /// 登记问题查询结束时间
  55. /// </summary>
  56. public DateTime endDate { get; set; }
  57. /// <summary>
  58. /// 解决/终止问题的开始时间
  59. /// </summary>
  60. public DateTime zzstartDate { get; set; }
  61. /// <summary>
  62. /// 解决/终止问题查询结束时间
  63. /// </summary>
  64. public DateTime zzendDate { get; set; }
  65. /// <summary>
  66. /// 查询文本(问题编号或标题)
  67. /// </summary>
  68. public string queryText { get; set; }
  69. /// <summary>
  70. /// 快速检索是否包含查询条件
  71. /// </summary>
  72. public bool IncludeSearchContent { get; set; } = true;
  73. /// <summary>
  74. /// 查询方案名称
  75. /// </summary>
  76. public string querySchemeName { get; set; }
  77. /// <summary>
  78. /// 我的问题(主要是受理问题与被指派的问题)
  79. /// </summary>
  80. public bool myProblem { get; set; }
  81. /// <summary>
  82. /// 我登记/指派/提交的问题,【,】分割
  83. /// </summary>
  84. public string myProblemCombox { get; set; }
  85. /// <summary>
  86. /// 我登记问题
  87. /// </summary>
  88. public bool myRegister { get; set; }
  89. /// <summary>
  90. /// 我指派的问题
  91. /// </summary>
  92. public bool myAssign { get; set; }
  93. /// <summary>
  94. /// 我提交的问题
  95. /// </summary>
  96. public bool mySubmit { get; set; }
  97. /// <summary>
  98. /// 显示已终止与关闭的问题
  99. /// </summary>
  100. public bool showCloseProblem { get; set; }
  101. /// <summary>
  102. /// 只看终止问题
  103. /// </summary>
  104. public bool showTerminIssues { get; set; }
  105. /// <summary>
  106. /// 只显示已被受理的问题(在该环节)
  107. /// </summary>
  108. public bool showReceiveProblem { get; set; }
  109. /// <summary>
  110. /// 当前用户ID
  111. /// </summary>
  112. public string currentUserID { get; set; }
  113. /// <summary>
  114. /// 当前人员性质(1-中联;2-中联渠道;3-客户;4-医院管理员;5-卫计委管理员)
  115. /// </summary>
  116. public int currentUserProperty { get; set; }
  117. /// <summary>
  118. /// 受理人
  119. /// </summary>
  120. public string DealPerson { get; set; }
  121. /// <summary>
  122. /// 登记人
  123. /// </summary>
  124. public string RegistPerson { get; set; }
  125. /// <summary>
  126. /// 指派人
  127. /// </summary>
  128. public string DistributePerson { get; set; }
  129. /// <summary>
  130. /// 是否为内部产品问题
  131. /// </summary>
  132. public bool insideProblem { get; set; }
  133. /// <summary>
  134. /// 指定字段
  135. /// </summary>
  136. public string text { get; set; }
  137. /// <summary>
  138. /// 是否解决
  139. /// </summary>
  140. public bool isend { get; set; }
  141. /// <summary>
  142. /// 类型
  143. /// </summary>
  144. public int type { get; set; }
  145. /// <summary>
  146. /// 迭代任务
  147. /// </summary>
  148. public string lteration { get; set; }
  149. /// <summary>
  150. /// 产品版本
  151. /// </summary>
  152. public string version { get; set; }
  153. /// <summary>
  154. /// 解决版本
  155. /// </summary>
  156. public string solutionversion
  157. {
  158. get;
  159. set;
  160. }
  161. /// <summary>
  162. /// 研发处理人id
  163. /// </summary>
  164. public string YFCLRID
  165. {
  166. get;
  167. set;
  168. }
  169. /// <summary>
  170. /// 测试处理人id
  171. /// </summary>
  172. public string CSCLRID
  173. {
  174. get;
  175. set;
  176. }
  177. /// <summary>
  178. /// 受理人id
  179. /// </summary>
  180. public string SLRID
  181. {
  182. get;
  183. set;
  184. }
  185. /// <summary>
  186. /// 解决版本状态
  187. /// </summary>
  188. public string JJBBZT
  189. {
  190. get;
  191. set;
  192. }
  193. /// <summary>
  194. /// 是否指定解决版本
  195. /// </summary>
  196. public int whether
  197. {
  198. get;
  199. set;
  200. } = 2;
  201. public int page { get; set; }
  202. public int rows { get; set; }
  203. public string sort { get; set; }
  204. public string order { get; set; }
  205. public string oderBy
  206. {
  207. get
  208. {
  209. var orders = sort + order;
  210. switch (orders)
  211. {
  212. case "编号asc": return " order by 编号 asc";
  213. case "编号desc": return " order by 编号 desc";
  214. case "登记日期asc": return " order by 登记日期 asc";
  215. case "登记日期desc": return " order by 登记日期 desc";
  216. case "当前环节asc": return " order by 当前环节 asc";
  217. case "当前环节desc": return " order by 当前环节 desc";
  218. case "要求时间asc": return " order by 要求时间 asc";
  219. case "要求时间desc": return " order by 要求时间 desc";
  220. case "受理时间asc": return " order by 受理时间 asc";
  221. case "受理时间desc": return " order by 受理时间 desc";
  222. case "指派时间asc": return " order by 指派时间 asc";
  223. case "指派时间desc": return " order by 指派时间 desc";
  224. case "总耗时asc": return " order by 总耗时 asc";
  225. case "总耗时desc": return " order by 总耗时 desc";
  226. case "滞留时间asc": return " order by 滞留时间 asc";
  227. case "滞留时间desc": return " order by 滞留时间 desc";
  228. case "受理人asc": return " order by 受理人 asc";
  229. case "受理人desc": return " order by 受理人 desc";
  230. case "指派人asc": return " order by 指派人 asc";
  231. case "指派人desc": return " order by 指派人 desc";
  232. case "是否验证asc": return " order by 是否验证 asc";
  233. case "是否验证desc": return " order by 是否验证 desc";
  234. case "解决版本状态asc": return " order by 解决版本状态 asc";
  235. case "解决版本状态desc": return " order by 解决版本状态 desc";
  236. case "测试处理人asc": return " order by 测试处理人 asc";
  237. case "测试处理人desc": return " order by 测试处理人 desc";
  238. case "研发处理人asc": return " order by 研发处理人 asc";
  239. case "研发处理人desc": return " order by 研发处理人 desc";
  240. default: return " order by 编号 desc ";
  241. }
  242. }
  243. }
  244. }
  245. }