WTJLBusiness.cs 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266
  1. using PMS.DBService.Product;
  2. using PMS.Interface.Product;
  3. using QWPlatform.IService;
  4. using QWPlatform.SystemLibrary.Utils;
  5. using System;
  6. using System.Collections.Generic;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Threading.Tasks;
  10. using PMS.EntityModels.Product;
  11. using System.Data;
  12. using QWPlatform.SystemLibrary;
  13. namespace PMS.BusinessService.Product
  14. {
  15. public class WTJLBusiness : IWTJLModel
  16. {
  17. private WTJLService db_WtjlInfo = DataServiceBase.Instance<WTJLService>();
  18. /// <summary>
  19. /// 获取紧急代码信息
  20. /// </summary>
  21. /// <returns></returns>
  22. public string GETJJCDinfo()
  23. {
  24. string s = Strings.ObjectToJson(db_WtjlInfo.GETJJCDinfo(), true);
  25. return s;
  26. }
  27. /// <summary>
  28. /// 获取渠道信息
  29. /// </summary>
  30. /// <param name="personProp">人员性质(当前人员)</param>
  31. /// <returns>返回josn信息</returns>
  32. public string GetChanels(int personProp, string companyid)
  33. {
  34. DataTable dt = db_WtjlInfo.GetChanels(personProp, companyid);
  35. return Strings.ObjectToJson(dt, true);
  36. }
  37. /// <summary>
  38. /// 获取渠道信息
  39. /// </summary>
  40. /// <param name="channel"></param>
  41. /// <returns></returns>
  42. public string GETQDinfo(string channel)
  43. {
  44. string s = Strings.ObjectToJson(db_WtjlInfo.GETQDinfo(channel), true);
  45. return s;
  46. }
  47. /// <summary>
  48. /// 获取性质信息
  49. /// </summary>
  50. /// <returns></returns>
  51. public string GETXZinfo()
  52. {
  53. string s = Strings.ObjectToJson(db_WtjlInfo.GETXZinfo(), true);
  54. return s;
  55. }
  56. /// <summary>
  57. /// 获取流程环节信息
  58. /// </summary>
  59. /// <returns></returns>
  60. public string LCHJ()
  61. {
  62. DataTable dt = db_WtjlInfo.LCHJ();
  63. dt.Rows.RemoveAt(0);
  64. string s = Strings.ObjectToJson(dt, true);
  65. return s;
  66. }
  67. /// <summary>
  68. /// 自定义方案查询
  69. /// </summary>
  70. /// <param name="model"></param>
  71. /// <returns></returns>
  72. public string ProjectZdyCxInfo(WTJLModel model, int page, int rows)
  73. {
  74. int total = 0;
  75. DataTable dt = db_WtjlInfo.ProjectZdyCxInfoSqlBulder(model, page, rows, out total);
  76. return dt.ToEasyUIGridJson(total);
  77. }
  78. /// <summary>
  79. /// 快速查询
  80. /// </summary>
  81. /// <returns></returns>
  82. public string KsSelect(string KsCx, int page, int rows, int total)
  83. {
  84. int StartNumbers = StartNumber(page, rows, 20);
  85. int Endnumbers = Endnumber(page, rows, 20);
  86. DataTable dt = db_WtjlInfo.KsSelect(KsCx, StartNumbers, Endnumbers, out total);
  87. if (dt != null)
  88. {
  89. return dt.ToEasyUIGridJson(total);
  90. }
  91. return string.Empty;
  92. }
  93. /// <summary>
  94. /// 客户人员(自己登记的问题)
  95. /// </summary>
  96. /// <param name="DJRID"></param>
  97. /// <param name="page"></param>
  98. /// <param name="rows"></param>
  99. /// <returns></returns>
  100. public string ProjectZdyCxInfoKh(string DJRID, int page, int rows)
  101. {
  102. int total = 0;
  103. DataTable dt = db_WtjlInfo.ProjectZdyCxInfoKh(DJRID, page, rows, out total);
  104. return dt.ToEasyUIGridJson(total);
  105. }
  106. /// <summary>
  107. /// 卫计委,本部,渠道人员根据渠道id查询数据权限
  108. /// </summary>
  109. /// <param name="model"></param>
  110. /// <param name="channel"></param>
  111. /// <param name="page"></param>
  112. /// <param name="rows"></param>
  113. public string ProjectZdyCxInfoQKW(string channel, int page, int rows)
  114. {
  115. int total = 0;
  116. DataTable dt = db_WtjlInfo.ProjectZdyCxInfoQKW(channel, page, rows, out total);
  117. return dt.ToEasyUIGridJson(total);
  118. }
  119. /// <summary>
  120. /// 4医院管理员 自己机构(站点信息)的数据
  121. /// </summary>
  122. /// <param name="model"></param>
  123. /// <param name="page"></param>
  124. /// <param name="rows"></param>
  125. public string ProjectZdyCxZd(string DJRID, int page, int rows)
  126. {
  127. int total = 0;
  128. DataTable dt = db_WtjlInfo.ProjectZdyCxZd(DJRID, page, rows, out total);
  129. return dt.ToEasyUIGridJson(total);
  130. }
  131. /// <summary>
  132. /// 根据渠道id查询下面得项目信息
  133. /// </summary>
  134. /// <param name="qdID"></param>
  135. /// <returns></returns>
  136. public string QdXm(string qdID)
  137. {
  138. string s = Strings.ObjectToJson(db_WtjlInfo.QdXm(qdID), true);
  139. return s;
  140. }
  141. /// <summary>
  142. /// 获取项目产品
  143. /// </summary>
  144. /// <param name="cpID"></param>
  145. /// <returns></returns>
  146. public string XmCp(string XmID)
  147. {
  148. string s = Strings.ObjectToJson(db_WtjlInfo.XmCp(XmID), true);
  149. return s;
  150. }
  151. /// <summary>
  152. /// 获取项目机构
  153. /// </summary>
  154. /// <param name="jgID"></param>
  155. /// <returns></returns>
  156. public string XmJgs(string jgID)
  157. {
  158. string s = Strings.ObjectToJson(db_WtjlInfo.XmJgs(jgID), true);
  159. return s;
  160. }
  161. #region 开始行结束行
  162. /// <summary>
  163. /// 开始行
  164. /// </summary>
  165. /// <param name="page">页码</param>
  166. /// <param name="rows">行数</param>
  167. /// <param name="defaultpage">默认行数</param>
  168. /// <returns></returns>
  169. private int StartNumber(int page, int rows, int defaultpage)
  170. {
  171. try
  172. {
  173. int _pageNum = page == 0 ? 1 : page;
  174. int _pagerows = rows == 0 ? defaultpage : rows;
  175. return ((_pageNum - 1) * _pagerows + 1);
  176. }
  177. catch (Exception)
  178. {
  179. return 0;
  180. }
  181. }
  182. /// <summary>
  183. /// 结束行
  184. /// </summary>
  185. /// <param name="page">页码</param>
  186. /// <param name="rows">行数</param>
  187. /// <param name="defaultpage">默认页码</param>
  188. /// <returns></returns>
  189. private int Endnumber(int page, int rows, int defaultpage)
  190. {
  191. try
  192. {
  193. int _pageNum = page == 0 ? 1 : page;
  194. int _pagerows = rows == 0 ? defaultpage : rows;
  195. return (_pageNum * _pagerows);
  196. }
  197. catch (Exception)
  198. {
  199. return 0;
  200. }
  201. }
  202. #endregion
  203. /// <summary>
  204. /// 问题处理状态
  205. /// </summary>
  206. /// <param name="wTid"></param>
  207. /// <param name="v"></param>
  208. /// <returns></returns>
  209. public string DealProblem(string wTid, string v)
  210. {
  211. string result = db_WtjlInfo.DealProblem(wTid, v);
  212. // 判断该问题是否已经处理过
  213. //(是 判断处理是否完成
  214. //是 提示用户该问题已处理
  215. //否 提示用户该问题处于挂起状态是否继续处理
  216. //是 分配人员做事情
  217. //是否解决
  218. //(是 问题记录 是否解决 ),
  219. //否 是否终止
  220. //(是 问题记录 是否终止 终止原因 )
  221. //否 问题记录过程 状态 处理中6
  222. //问题记录
  223. //否 关闭弹窗)
  224. //否 分配人员做事情
  225. //)
  226. //0:未解决,1:解决//0:正常,1:回退//0:正常,1:终止
  227. //状态//环节//*/是否解决//是否回退//是否终止*///当前环节和人员性质是否相等
  228. // Result_out:= State || Resourceid || deal || roleback || stop||Xzs;
  229. //1.登记,2.回退,3.终止,4.分配,5.提交, 6.处理,7.完成 (对应基础编码【问题过记录程状态】)
  230. //1、本部 2、渠道 3、客户 4、医院 5、卫计委
  231. string[] results = result.Split(',');
  232. string end = "该问题不再属于当前环节处理";
  233. if (results[2] == "1")
  234. {
  235. end = "问题已解决";
  236. }
  237. else if (results[4] == "1")
  238. {
  239. end = "问题已终止";
  240. }
  241. else if (results[5] == "true")
  242. {
  243. if (results[0] == "6")
  244. {
  245. end = "当前问题处于挂起状态是否继续处理";
  246. }
  247. else
  248. {
  249. end = "1";
  250. }
  251. }
  252. return end;
  253. }
  254. }
  255. }