DirectroyQueryService.cs 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476
  1. using Newtonsoft.Json;
  2. using Newtonsoft.Json.Linq;
  3. using PTMedicalInsurance.Business;
  4. using PTMedicalInsurance.Forms.BasicDatas.services;
  5. using PTMedicalInsurance.Helper;
  6. using PTMedicalInsurance.Variables;
  7. using System;
  8. using System.Collections.Generic;
  9. using System.Data;
  10. using System.Linq;
  11. using System.Text;
  12. using System.Threading.Tasks;
  13. using System.Windows.Forms;
  14. namespace PTMedicalInsurance.Forms.BasicDatas
  15. {
  16. class DirectroyQueryService
  17. {
  18. //设置实例
  19. CenterBusiness cBus = new CenterBusiness();
  20. HisMainBusiness hBus = new HisMainBusiness();
  21. HisIrisServices hIS = new HisIrisServices();
  22. MIIrisServices mIS = new MIIrisServices();
  23. InvokeHelper invoker = new InvokeHelper();
  24. private GridViewSetter gvdSetter = new GridViewSetter();
  25. private Func<JObject, OutParamWrapper, int> action;
  26. #region 查询
  27. //药品
  28. //诊疗
  29. //材料
  30. //疾病诊断
  31. //手术
  32. //门诊慢特病种
  33. //按病种付费
  34. //日间手术
  35. //字典表
  36. //中药饮片
  37. //医疗机构制剂
  38. //肿瘤形态学
  39. //中医疾病下载
  40. //中医证候下载
  41. //民族药品
  42. //目录信息查询
  43. //医疗与医保目录匹配
  44. //医药机构目录匹配
  45. //医保目录限价
  46. //医保目录自付比例
  47. //医药机构信息
  48. #endregion
  49. /// <summary>
  50. /// 查询分页信息
  51. /// </summary>
  52. /// <param name="input"></param>
  53. /// <param name="errmsg"></param>
  54. /// <returns></returns>
  55. public int QueryMIDirectoryPaginationInfo(JObject input,out string errmsg)
  56. {
  57. JObject joRtn = mIS.getMIDirectoryByPagination(input);
  58. if (joRtn["errorCode"].ToString() != "0")
  59. {
  60. errmsg ="IRIS数据返回错误:" + joRtn["errorMessage"].ToString();
  61. return -1;
  62. }
  63. if (joRtn["result"]["rows"] == null)
  64. {
  65. errmsg = "rows节点不存在";
  66. return -1;
  67. }
  68. if (joRtn["result"]["total"].ToString() == "0")
  69. {
  70. errmsg ="未查询到数据";
  71. return -1;
  72. }
  73. errmsg = joRtn.ToString();
  74. return 0;
  75. }
  76. /// <summary>
  77. /// 查询分页信息
  78. /// </summary>
  79. /// <param name="input"></param>
  80. /// <param name="errmsg"></param>
  81. /// <param name="dt"></param>
  82. /// <returns></returns>
  83. public int QueryMIDirectoryPaginationInfo(JObject input, out string errmsg, out DataTable dt)
  84. {
  85. int iResult = QueryMIDirectoryPaginationInfo(input,out errmsg);
  86. dt = null;
  87. if (iResult == 0)
  88. {
  89. JObject joRtn = JObject.Parse(errmsg);
  90. dt = (DataTable)joRtn["result"]["rows"].ToObject(typeof(DataTable));
  91. }
  92. return iResult;
  93. }
  94. /// <summary>
  95. /// 设置DataGridView标题
  96. /// </summary>
  97. public void SetDgvDirectoryHeader(int directoryType,DataGridView dgv)
  98. {
  99. switch (directoryType)
  100. {
  101. case 1://药品
  102. {
  103. gvdSetter.SetHeaderTextOfDrug(dgv);
  104. break;
  105. }
  106. case 2://诊疗
  107. {
  108. gvdSetter.SetHeaderTextOfMedicalService(dgv);
  109. break;
  110. }
  111. case 3://材料
  112. {
  113. gvdSetter.SetHeaderTextOfMaterials(dgv);
  114. break;
  115. }
  116. case 4://疾病诊断
  117. {
  118. gvdSetter.SetHeaderTextOfDiagnose(dgv);
  119. break;
  120. }
  121. case 5://手术
  122. {
  123. gvdSetter.SetHeaderTextOfDiagnose(dgv);
  124. break;
  125. }
  126. case 6://慢性病
  127. {
  128. gvdSetter.SetHeaderTextOfDiagnose(dgv);
  129. break;
  130. }
  131. case 7://DRGs
  132. {
  133. gvdSetter.SetHeaderTextOfDiagnose(dgv);
  134. break; ;
  135. }
  136. case 8://日间手术
  137. {
  138. gvdSetter.SetHeaderTextOfDiagnose(dgv);
  139. break; ;
  140. }
  141. case 9://字典表
  142. {
  143. gvdSetter.SetHeaderTextOfDictionary(dgv);
  144. break;
  145. }
  146. case 10://中药饮片下载
  147. {
  148. gvdSetter.SetHeaderTextOfChineseMedicine(dgv);
  149. break;
  150. }
  151. case 11://医药机构制剂目录下载
  152. {
  153. gvdSetter.SetHeaderTextOfPreparation(dgv);
  154. break;
  155. }
  156. case 12://肿瘤形态学下载
  157. {
  158. gvdSetter.SetHeaderTextOfTumorMorphology(dgv);
  159. break;
  160. }
  161. case 13:
  162. {
  163. //中医疾病下载
  164. gvdSetter.GetChineseDiagnoseJsonByTxt(dgv);
  165. // ICPC3
  166. //gvdSetter.SetICPCAdmReasonHeader(dgv);
  167. break;
  168. }
  169. case 14:
  170. {
  171. //中医证候下载
  172. gvdSetter.GetTCMSyndromeJsonByTxt(dgv);
  173. // ICPC3
  174. //gvdSetter.SetICPCTreatmentHeader(dgv);
  175. break;
  176. }
  177. case 15://民族药品
  178. {
  179. gvdSetter.GetEthnicMedicineJsonByTxt(dgv);
  180. break;
  181. }
  182. case 16://目录信息查询
  183. {
  184. gvdSetter.GetMedInsuCatalogJsonByTxt(dgv);
  185. break;
  186. }
  187. case 17://医疗与医保目录匹配关系查询
  188. {
  189. gvdSetter.GetMedInsuCorrespondencJsonByTxt(dgv);
  190. break;
  191. }
  192. case 18://医药机构目录匹配查询
  193. {
  194. gvdSetter.GetMedInstCorrespondencJsonByTxt(dgv);
  195. break;
  196. }
  197. case 19://医保目录限价查询
  198. {
  199. gvdSetter.GetMedInsuFixedPriceJsonByTxt(dgv);
  200. break;
  201. }
  202. case 20://医保目录先自付比例下载
  203. {
  204. gvdSetter.GetMedInsuFirstPayProportionJsonByTxt(dgv);
  205. break;
  206. }
  207. case 21://医药机构信息
  208. {
  209. gvdSetter.GetMedicalInstitutionJsonByTxt(dgv);
  210. break;
  211. }
  212. }
  213. }
  214. /// <summary>
  215. /// 处理返回的数据格式,否则可能会报各种错误
  216. /// </summary>
  217. /// <param name="dt"></param>
  218. public void HandleDatatable(int directoryType, JArray ja)
  219. {
  220. Global.writeLog($"directoryType:{directoryType}");
  221. switch (directoryType)
  222. {
  223. case 1://药品
  224. {
  225. foreach (JObject item in ja)
  226. {
  227. var value = item["cumulativeNegativeBurdenFlag"].ToString();
  228. if (value == null || Convert.IsDBNull(value) || string.IsNullOrEmpty(value.ToString()))
  229. {
  230. item["cumulativeNegativeBurdenFlag"] = 0;
  231. }
  232. else
  233. {
  234. // 如果是整数类型,比如 0/1 转换为 false/true
  235. int flagValue = 0;
  236. if (int.TryParse(value.ToString(), out flagValue))
  237. {
  238. item["cumulativeNegativeBurdenFlag"] = flagValue == 1;
  239. }
  240. else
  241. {
  242. item["cumulativeNegativeBurdenFlag"] = 0;
  243. }
  244. }
  245. }
  246. break;
  247. }
  248. case 2://诊疗
  249. {
  250. break;
  251. }
  252. case 3://材料
  253. {
  254. break;
  255. }
  256. case 4://疾病诊断
  257. {
  258. break;
  259. }
  260. case 5://手术
  261. {
  262. break;
  263. }
  264. case 6://慢性病
  265. {
  266. break;
  267. }
  268. case 7://DRGs
  269. {
  270. break; ;
  271. }
  272. case 8://日间手术
  273. {
  274. break; ;
  275. }
  276. case 9://字典表
  277. {
  278. break;
  279. }
  280. case 10://中药饮片下载
  281. {
  282. break;
  283. }
  284. case 11://医药机构制剂目录下载
  285. {
  286. break;
  287. }
  288. case 12://肿瘤形态学下载
  289. {
  290. break;
  291. }
  292. case 13:
  293. {
  294. break;
  295. }
  296. case 14:
  297. {
  298. break;
  299. }
  300. case 15://民族药品
  301. {
  302. break;
  303. }
  304. case 16://目录信息查询
  305. {
  306. break;
  307. }
  308. case 17://医疗与医保目录匹配关系查询
  309. {
  310. break;
  311. }
  312. case 18://医药机构目录匹配查询
  313. {
  314. break;
  315. }
  316. case 19://医保目录限价查询
  317. {
  318. break;
  319. }
  320. case 20://医保目录先自付比例下载
  321. {
  322. break;
  323. }
  324. case 21://医药机构信息
  325. {
  326. break;
  327. }
  328. }
  329. }
  330. #region 更新
  331. private int updateAllInsuInfo(DataLoaderContext context, out string errMsg)
  332. {
  333. int iFalse = 0;
  334. int iCount = 0;
  335. List<string> errList = new List<string>();
  336. object[] args = context.args;
  337. //查询总条数
  338. int currentPage = 1;
  339. int pageSize = 1000;
  340. JObject joInput = new JObject {
  341. { "currentPage" , currentPage },
  342. { "pageSize" , pageSize },
  343. { "serviceCode" , "09010042" },
  344. { "directoryType" , (int)args[1] },
  345. { "directoryCode" , "" },
  346. { "directoryName" , "" },
  347. { "approvalNO" , "" },
  348. { "dosageForm" , "" },
  349. { "specifications" , "" },
  350. { "manufacturers" , "" },
  351. { "directoryDr" , Global.inf.interfaceDr }
  352. };
  353. JObject joRtn = mIS.getMIDirectoryByPagination(joInput);
  354. if (JsonHelper.parseIrisRtnValue(joRtn, out errMsg) != 0)
  355. {
  356. return -1;
  357. }
  358. int iTotalCount = int.Parse(joRtn["result"]["total"].ToString());
  359. int iTotalPages = (int)(iTotalCount / pageSize) + 1;
  360. string headerText = $"正在下载数据,当前页数【{currentPage}】/总页数【{iTotalPages}】";
  361. context.setProgressHeaderText(ProgressBarStyle.Marquee,headerText,50);
  362. for (int i = 0; i < iTotalPages; i++)
  363. {
  364. JObject joRtnData = new JObject();
  365. if (currentPage == 1)
  366. {
  367. joRtnData = (JObject)joRtn.DeepClone();
  368. }
  369. else
  370. {
  371. headerText = $"正在下载数据,当前页数【{currentPage}】/总页数【{iTotalPages}】";
  372. context.setProgressHeaderText(ProgressBarStyle.Marquee, headerText, 50);
  373. joInput["currentPage"] = currentPage;
  374. joRtnData = mIS.getMIDirectoryByPagination(joInput);
  375. if (JsonHelper.parseIrisRtnValue(joRtn, out errMsg) != 0)
  376. {
  377. return -1;
  378. }
  379. }
  380. DataTable dt = JsonConvert.DeserializeObject<DataTable>(joRtnData["result"]["rows"].ToString());
  381. if (context.setProgressMaximum != null)
  382. {
  383. context.setProgressMaximum(dt.Rows.Count);
  384. }
  385. foreach (DataRow dr in dt.Rows)
  386. {
  387. JObject jo = new JObject();
  388. jo.Add("code", dr["InsuCode"].ToString());
  389. jo.Add("HisType", dr["HisType"].ToString());
  390. OutParamWrapper outParWarp = new OutParamWrapper();
  391. if (action(jo, outParWarp) != 0)
  392. {
  393. iFalse++;
  394. errList.Add(outParWarp.Value);
  395. Global.writeLog(outParWarp.Value);
  396. }
  397. iCount++;
  398. // 检查是否应取消操作
  399. if (context.Worker.CancellationPending)
  400. {
  401. errMsg = "操作取消!";
  402. return -1; // 或者其他表示取消的返回值
  403. }
  404. if (context.reportProgress != null)
  405. {
  406. context.reportProgress(iCount);
  407. }
  408. }
  409. if (iFalse != 0)
  410. {
  411. errMsg = ($"总共{iCount}条数据更新完成,但有{iFalse}条更新发生错误!");
  412. Global.writeLog($"{errMsg}\r\n{errList}");
  413. return iFalse;
  414. }
  415. else
  416. {
  417. errMsg = ($"全部数据({iCount}条)更新完成");
  418. }
  419. currentPage++;
  420. }
  421. return 0;
  422. }
  423. #endregion
  424. }
  425. }