BasicData.cs 67 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712
  1. using Newtonsoft.Json;
  2. using Newtonsoft.Json.Linq;
  3. using PTMedicalInsurance.Business;
  4. using PTMedicalInsurance.Helper;
  5. using PTMedicalInsurance.Variables;
  6. using System;
  7. using System.Collections.Generic;
  8. using System.ComponentModel;
  9. using System.Data;
  10. using System.Drawing;
  11. using System.IO;
  12. using System.Linq;
  13. using System.Text;
  14. using System.Threading.Tasks;
  15. using System.Windows.Forms;
  16. using PTMedicalInsurance.FormSetter;
  17. using PTMedicalInsurance.Common;
  18. namespace PTMedicalInsurance.Forms
  19. {
  20. public partial class BasicData : Form
  21. {
  22. //设置实例
  23. CenterBusiness cBus = new CenterBusiness();
  24. HisMainBusiness hBus = new HisMainBusiness();
  25. HisIrisServices hIS = new HisIrisServices();
  26. MIIrisServices mIS = new MIIrisServices();
  27. InvokeHelper invoker = new InvokeHelper();
  28. InsuServices Iis = new InsuServices();
  29. DataImoport bus = new DataImoport();
  30. //1.声明自适应类实例
  31. AutoResizeForm asc = new AutoResizeForm();
  32. public JObject joSelectedInsuInfo;
  33. public int insuInfoIndex = 0;
  34. public int idInfoIndex = 0;
  35. DataTable dtExport;
  36. public BasicData()
  37. {
  38. InitializeComponent();
  39. rbgDirecType.SelectedIndex = 0;
  40. rbgDirecType_C.SelectedIndex = 0;
  41. rbSingleDown.Checked = true;
  42. this.rbgDirecType.ValueChanged += new Sunny.UI.UIRadioButtonGroup.OnValueChanged(this.rbgDirecType_ValueChanged);
  43. this.pgDownload.PageChanged += new Sunny.UI.UIPagination.OnPageChangeEventHandler(this.pgDownload_PageChanged);
  44. this.pgCenterDirect.PageChanged += new Sunny.UI.UIPagination.OnPageChangeEventHandler(this.pgCenterDirect_PageChanged);
  45. Font rowFont = new Font("UTF-8", 8);
  46. Font columnFont = new Font("UTF-8", 9);
  47. rbgDirecType.SelectedIndex = 8;
  48. rbAll.Checked = true;
  49. //tabControl1.SelectedIndex = 1;
  50. //this.StartPosition = FormStartPosition.CenterParent;
  51. asc.controllInitializeSize(this);
  52. asc.controlAutoSize(this);
  53. }
  54. #region 函数封装
  55. private void queryInsuDirectory(int currentPage, int pageSize, int directoryType, int interfaceDr, string code)
  56. {
  57. try
  58. {
  59. string dirCode = "";
  60. string dirName = "";
  61. string approvalNO = "";
  62. Sunny.UI.UIDataGridView dgv;
  63. Sunny.UI.UIPagination pg;
  64. if (tabControl1.SelectedIndex == 0)
  65. {
  66. dirCode = tbDirectoryCode.Text;
  67. dirName = tbDircetoryName.Text;
  68. approvalNO = "";
  69. dgv = dgvDirectoy;
  70. pg = pgDownload;
  71. }
  72. else
  73. {
  74. dirName = tbCenterDirectoryFilter.Text;
  75. dirCode = tbInsuCode.Text;
  76. dgv = dgvCenterDirectory;
  77. approvalNO = tbApprovalNO.Text;
  78. pg = pgCenterDirect;
  79. }
  80. JObject joInput = new JObject {
  81. { "currentPage" , currentPage },
  82. { "pageSize" , pageSize },
  83. { "serviceCode" , code },
  84. { "directoryType" , directoryType },
  85. { "directoryCode" , dirCode },
  86. { "directoryName" , dirName },
  87. { "approvalNO" , approvalNO },
  88. { "directoryDr" , interfaceDr }
  89. };
  90. JObject joRtn = mIS.getMIDirectoryByPagination(joInput);
  91. if (joRtn["errorCode"].ToString() != "0")
  92. {
  93. MessageBox.Show("IRIS数据返回错误:" + joRtn["errorMessage"].ToString());
  94. return;
  95. }
  96. if (joRtn["result"]["rows"] == null)
  97. {
  98. MessageBox.Show("该节点不存在");
  99. return;
  100. }
  101. if (joRtn["result"]["total"].ToString() == "0")
  102. {
  103. MessageBox.Show("未查询到数据");
  104. dgv.DataSource = null;
  105. return;
  106. }
  107. DataTable dt = (DataTable)joRtn["result"]["rows"].ToObject(typeof(DataTable));
  108. int totalCount = int.Parse(joRtn["result"]["total"].ToString());
  109. pg.TotalCount = totalCount;
  110. pg.PageSize = pageSize;
  111. dgv.DataSource = dt;
  112. dgv.Columns[0].ReadOnly = true;
  113. }
  114. catch (Exception ex)
  115. {
  116. MessageBox.Show("查询异常:" + ex.Message);
  117. }
  118. }
  119. private void setHeaderTxt(int directoryType, Sunny.UI.UIDataGridView dgv)
  120. {
  121. GridViewSetter gvdSetter = new GridViewSetter();
  122. switch (directoryType)
  123. {
  124. case 0://药品
  125. {
  126. gvdSetter.SetHeaderTextOfDrug(dgv);
  127. break;
  128. }
  129. case 1://诊疗
  130. {
  131. gvdSetter.SetHeaderTextOfMedicalService(dgv);
  132. break;
  133. }
  134. case 2://材料
  135. {
  136. gvdSetter.SetHeaderTextOfMaterials(dgv);
  137. break;
  138. }
  139. case 3://疾病诊断
  140. {
  141. gvdSetter.SetHeaderTextOfDiagnose(dgv);
  142. break;
  143. }
  144. case 4://手术
  145. {
  146. gvdSetter.SetHeaderTextOfDiagnose(dgv);
  147. break;
  148. }
  149. case 5://慢性病
  150. {
  151. gvdSetter.SetHeaderTextOfDiagnose(dgv);
  152. break;
  153. }
  154. case 6://DRGs
  155. {
  156. gvdSetter.SetHeaderTextOfDiagnose(dgv);
  157. break; ;
  158. }
  159. case 7://日间手术
  160. {
  161. gvdSetter.SetHeaderTextOfDiagnose(dgv);
  162. break; ;
  163. }
  164. case 8://字典表
  165. {
  166. gvdSetter.SetHeaderTextOfDictionary(dgv);
  167. break;
  168. }
  169. case 9://中药饮片下载
  170. {
  171. gvdSetter.SetHeaderTextOfChineseMedicine(dgv);
  172. break;
  173. }
  174. case 10://医药机构制剂目录下载
  175. {
  176. gvdSetter.SetHeaderTextOfPreparation(dgv);
  177. break;
  178. }
  179. case 11://肿瘤形态学下载
  180. {
  181. gvdSetter.SetHeaderTextOfTumorMorphology(dgv);
  182. break;
  183. }
  184. case 12://中医疾病下载
  185. {
  186. gvdSetter.GetChineseDiagnoseJsonByTxt(dgv);
  187. break;
  188. }
  189. case 13://中医证候下载
  190. {
  191. gvdSetter.GetTCMSyndromeJsonByTxt(dgv);
  192. break;
  193. }
  194. case 14://民族药品
  195. {
  196. gvdSetter.GetEthnicMedicineJsonByTxt(dgv);
  197. break;
  198. }
  199. case 15://目录信息查询
  200. {
  201. gvdSetter.GetMedInsuCatalogJsonByTxt(dgv);
  202. break;
  203. }
  204. case 16://医疗与医保目录匹配关系查询
  205. {
  206. gvdSetter.GetMedInsuCorrespondencJsonByTxt(dgv);
  207. break;
  208. }
  209. case 17://医药机构目录匹配查询
  210. {
  211. gvdSetter.GetMedInstCorrespondencJsonByTxt(dgv);
  212. break;
  213. }
  214. case 18://医保目录限价查询
  215. {
  216. gvdSetter.GetMedInsuFixedPriceJsonByTxt(dgv);
  217. break;
  218. }
  219. case 19://医保目录先自付比例下载
  220. {
  221. gvdSetter.GetMedInsuFirstPayProportionJsonByTxt(dgv);
  222. break;
  223. }
  224. case 20://医药机构信息
  225. {
  226. gvdSetter.GetMedicalInstitutionJsonByTxt(dgv);
  227. break;
  228. }
  229. }
  230. }
  231. private void queryHISInsuDirectory(int directoryType, int pageIndex, int count, Sunny.UI.UIDataGridView dgv, int interfaceDr)
  232. {
  233. string code = "09010042";
  234. if (tabControl1.SelectedIndex == 0)
  235. {
  236. if (rbgDirecType.SelectedIndex == 20)
  237. {
  238. code = "090100XX";
  239. }
  240. else if (rbgDirecType.SelectedIndex == 8)
  241. {
  242. code = "09010043";
  243. }
  244. else
  245. {
  246. code = "09010042";
  247. }
  248. if (rbgDirecType.SelectedIndex <= 13)
  249. {
  250. queryInsuDirectory(pageIndex, count, directoryType + 1, interfaceDr, code);
  251. setHeaderTxt(directoryType, dgv);
  252. }
  253. else //几个医保查询该部分数据不存数据库只是临时查询(除医疗机构信息查询外)
  254. {
  255. //生成DataView列
  256. //setHeaderTxt(directoryType, dgv);
  257. string pages, recordCounts, errorMessage, sOutpar;
  258. dynamic joData = GetInput(rbgDirecType.SelectedIndex, out string funNo);
  259. JObject joRtn = cBus.InvokeMedicalInsuranceInquiry(funNo, joData);
  260. if (joRtn["infcode"].ToString() == "0")
  261. {
  262. try
  263. {
  264. Sunny.UI.UIPagination pg;
  265. dgv = dgvDirectoy;
  266. pg = pgDownload;
  267. DataTable dt;
  268. if (rbgDirecType.SelectedIndex == 20)
  269. {
  270. dt = (DataTable)joRtn["output"]["medinsinfo"].ToObject(typeof(DataTable));
  271. if (joRtn["output"]["medinsinfo"].ToString() == "")
  272. {
  273. MessageBox.Show("查询成功,但返回结果集为空!");
  274. //return;
  275. }
  276. pg.TotalCount = 50;
  277. pg.PageSize = 50;
  278. }
  279. else
  280. {
  281. pages = joRtn["output"]["pages"].ToString(); //页数
  282. recordCounts = joRtn["output"]["recordCounts"].ToString(); //总记录条数
  283. dt = (DataTable)joRtn["output"]["data"].ToObject(typeof(DataTable));
  284. if (recordCounts == "0")
  285. {
  286. MessageBox.Show("查询成功,但返回结果集为空!");
  287. //return;
  288. }
  289. pg.TotalCount = int.Parse(recordCounts);
  290. pg.PageSize = int.Parse(TexBYSJL.Text); //int.Parse(pages);
  291. }
  292. dgv.DataSource = dt;
  293. dgv.Columns[0].ReadOnly = true;
  294. }
  295. catch (Exception ex)
  296. {
  297. MessageBox.Show("查询异常:" + ex.Message);
  298. }
  299. }
  300. else
  301. {
  302. errorMessage = "调用交易" + funNo + "出现错误,请查看日志!"; //joImportRtn["errorMessage"].ToString();
  303. MessageBox.Show(errorMessage);
  304. return;
  305. }
  306. }
  307. }
  308. else
  309. {
  310. queryInsuDirectory(pageIndex, count, directoryType + 1, interfaceDr, code);
  311. setHeaderTxt(directoryType, dgv);
  312. }
  313. }
  314. private int queryHISDirectory(int currentPage, int pageSize, out string errMsg)
  315. {
  316. errMsg = "";
  317. string directoryType = string.Empty;
  318. switch (rbgDirecType_C.SelectedIndex)
  319. {
  320. case 0:
  321. {
  322. directoryType = "drugs";
  323. break;
  324. }
  325. case 1:
  326. {
  327. directoryType = "diagnosi";
  328. break;
  329. }
  330. case 2:
  331. {
  332. directoryType = "consumables";
  333. break;
  334. }
  335. }
  336. JObject joHISRtn = new JObject();
  337. JObject joRtn = new JObject();
  338. InvokeHelper invoker = new InvokeHelper();
  339. string flag = "";
  340. //全部是先调HIS,然后再匹配医保平台的对照关系
  341. if (rbAll.Checked)
  342. {
  343. JArray jaPagination = new JArray();
  344. JArray jaParams = new JArray();
  345. flag = "All";
  346. dynamic joParam = new JObject();
  347. joParam.code = "";
  348. joParam.descripts = "";
  349. joParam.FindType = new JArray();
  350. joParam.TypeID = "";
  351. joParam.alias = tbHISDirectoryFilter.Text;
  352. joParam.include = "Hosp";
  353. joParam.groupID = "324";
  354. joParam.hospID = Global.inf.hisHospitalDr;
  355. joParam.interfaceDr = Global.inf.interfaceDr;
  356. joParam.type = directoryType;
  357. joParam.flag = flag;
  358. joParam.specInput = "";
  359. jaParams.Add(joParam);
  360. dynamic joPagination = new JObject();
  361. joPagination.pageSize = pageSize;
  362. //joPagination.pageSize = 2;
  363. joPagination.currentPage = currentPage;
  364. joPagination.sortColumn = "Code";
  365. joPagination.sortOrder = "asc";
  366. jaPagination.Add(joPagination);
  367. //该服务需要改写,需要跟(CloudMedicalInsurancePlatform.Tables.MapRelation)进行关联
  368. //joInParams.code = "09010038";
  369. if (hIS.getHISDir(jaPagination, jaParams, out joHISRtn, out errMsg) != 0)
  370. {
  371. return -1;
  372. }
  373. joRtn = mIS.ConvertHISDir(joHISRtn);
  374. if (JsonHelper.parseIrisRtnValue(joRtn, out errMsg) != 0)
  375. {
  376. return -1;
  377. }
  378. }
  379. //已对照是先调云医保,然后再匹配HIS
  380. if (rbMaped.Checked)
  381. {
  382. JArray jaPagination = new JArray();
  383. JArray jaParams = new JArray();
  384. dynamic joParam = new JObject();
  385. joParam.alias = tbHISDirectoryFilter.Text;
  386. joParam.HospitalDr = Global.inf.hospitalDr;
  387. joParam.InterfaceDr = Global.inf.interfaceDr;
  388. joParam.hisType = directoryType;
  389. joParam.MapedFlag = "Y";
  390. flag = "Maped";
  391. jaParams.Add(joParam);
  392. dynamic joPagination = new JObject();
  393. joPagination.pageSize = pageSize;
  394. joPagination.currentPage = currentPage;
  395. joPagination.sortColumn = "HisCode";
  396. joPagination.sortOrder = "asc";
  397. jaPagination.Add(joPagination);
  398. JObject joMIRtn = mIS.GetMappedHISDir(jaPagination, jaParams);
  399. if (JsonHelper.parseIrisRtnValue(joMIRtn, out errMsg) != 0)
  400. {
  401. return -1;
  402. }
  403. //传给HIS,进行匹配
  404. joParam = new JObject();
  405. joParam.TotalCount = joMIRtn["result"]["TotalCount"];
  406. joParam.type = directoryType;
  407. joParam.flag = flag;
  408. joParam.hospID = Global.inf.hisHospitalDr;
  409. joParam.interfaceDr = Global.inf.interfaceDr;
  410. joParam.alias = tbHISDirectoryFilter.Text;
  411. joParam.include = "Hosp";
  412. joParam.groupID = "324";
  413. joParam.compareArr = joMIRtn["result"]["Data"];
  414. jaParams = new JArray();
  415. jaParams.Add(joParam);
  416. if (hIS.getHISDir(jaPagination, jaParams, out joRtn, out errMsg) != 0)
  417. {
  418. return -1;
  419. }
  420. }
  421. if (rbNoMaped.Checked)
  422. {
  423. flag = "NoMaped";
  424. }
  425. DataTable dt = (DataTable)joRtn["result"]["Data"].ToObject(typeof(DataTable));
  426. dtExport = dt;
  427. int totalCount = int.Parse(joRtn["result"]["TotalCount"].ToString());
  428. pgHISDirect.TotalCount = totalCount;
  429. pgHISDirect.PageSize = 50;
  430. dgvHISDirectory.DataSource = null;
  431. dgvHISDirectory.DataSource = dt;
  432. dgvHISDirectory.Columns[0].ReadOnly = true;
  433. if (rbNoMaped.Checked)
  434. {
  435. // dt.DefaultView.RowFilter = string.Format(" flag LIKE '%{未对照}%'", "");
  436. (dgvHISDirectory.DataSource as DataTable).DefaultView.RowFilter = string.Format("insuCode = ''", "");
  437. }
  438. return 0;
  439. }
  440. private void queryCenterDirectory_09010012(int currentPage, int pageSize)
  441. {
  442. string directoryType = string.Empty;
  443. switch (rbgDirecType_C.SelectedIndex)
  444. {
  445. case 0:
  446. {
  447. directoryType = "drugs";
  448. break;
  449. }
  450. case 1:
  451. {
  452. directoryType = "diagnosi";
  453. break;
  454. }
  455. case 2:
  456. {
  457. directoryType = "consumables";
  458. break;
  459. }
  460. }
  461. dynamic joInParams = new JObject();
  462. joInParams.pagination = new JArray() as dynamic;
  463. joInParams.session = new JArray() as dynamic;
  464. JArray jaParams = new JArray();
  465. dynamic joParams = new JObject();
  466. joParams.code = "";
  467. joParams.descripts = "";
  468. joParams.FindType = new JArray();
  469. joParams.TypeID = "";
  470. joParams.alias = "";
  471. joParams.include = "Hosp";
  472. joParams.groupID = "324";
  473. joParams.hospID = "25";
  474. joParams.type = directoryType;
  475. joParams.specInput = "";
  476. jaParams.Add(joParams);
  477. joInParams.Add("params", JArray.FromObject(jaParams));
  478. dynamic joSession = new JObject();
  479. joSession.userID = "";
  480. joSession.locID = "";
  481. joSession.groupID = "";
  482. joSession.hospID = "";
  483. joSession.sessionID = "";
  484. joSession.hospCode = "";
  485. joSession.language = "";
  486. joSession.hostName = "";
  487. joSession.ipv4 = "";
  488. joSession.ipv6 = "";
  489. joSession.mac = "";
  490. joInParams.session.Add(joSession);
  491. dynamic joPagination = new JObject();
  492. joPagination.pageSize = pageSize;
  493. joPagination.currentPage = currentPage;
  494. joPagination.sortColumn = "Code";
  495. joPagination.sortOrder = "asc";
  496. joInParams.pagination.Add(joPagination);
  497. joInParams.code = "09010012";
  498. string sInput = joInParams.ToString();
  499. string sRtn = invoker.invokeInsuService(joInParams, "");
  500. JObject jsonRtn = JObject.Parse(sRtn);
  501. if (jsonRtn["result"]["Data"] == null)
  502. {
  503. MessageBox.Show("该节点不存在");
  504. return;
  505. }
  506. JObject joRtn = JObject.Parse(sRtn);
  507. DataTable dt = (DataTable)joRtn["result"]["Data"].ToObject(typeof(DataTable));
  508. int totalCount = int.Parse(joRtn["result"]["TotalCount"].ToString());
  509. pgCenterDirect.TotalCount = totalCount;
  510. pgCenterDirect.PageSize = 50;
  511. dgvCenterDirectory.DataSource = dt;
  512. }
  513. private void Mapping()
  514. {
  515. int iHis = dgvHISDirectory.CurrentRow.Index;
  516. if (dgvCenterDirectory.CurrentRow == null)
  517. {
  518. MessageBox.Show("请查询中心目录");
  519. return;
  520. }
  521. int iCenter = dgvCenterDirectory.CurrentRow.Index;
  522. DataTable dtHis = (DataTable)dgvHISDirectory.DataSource;
  523. DataTable dtCenter = (DataTable)dgvCenterDirectory.DataSource;
  524. dgvHISDirectory.Rows[iHis].Cells["insuCode"].Value = dgvCenterDirectory.Rows[iCenter].Cells["Code"].Value.ToString();
  525. dgvHISDirectory.Rows[iHis].Cells["insuName"].Value = dgvCenterDirectory.Rows[iCenter].Cells["Name"].Value.ToString();
  526. int hisType = rbgDirecType_C.SelectedIndex + 1;
  527. string hisTypeName = rbgDirecType_C.Items[hisType - 1].ToString();
  528. JArray jaParams = new JArray();
  529. dynamic jsonTemp = new JObject();
  530. jsonTemp.ID = dtHis.Rows[iHis]["MapID"];
  531. jsonTemp.HospitalDr = Global.inf.hospitalDr;
  532. jsonTemp.updateUserID = Global.user.ID;
  533. jsonTemp.InterfaceDr = Global.inf.interfaceDr;
  534. jsonTemp.HISCode = dgvHISDirectory.Rows[iHis].Cells["itemCode"].Value;
  535. jsonTemp.HISName = dgvHISDirectory.Rows[iHis].Cells["itemDesc"].Value;
  536. jsonTemp.ChargeItemDr = dtHis.Rows[iHis]["ID"];
  537. jsonTemp.DiretoryDr = dtCenter.Rows[iCenter]["medInsuDirectoryID"];
  538. //1.已对照 2.已对照但未上传 3 已对照且已上传
  539. jsonTemp.State = 1;
  540. jsonTemp.HisType = hisType;
  541. jsonTemp.HisTypeName = hisTypeName;
  542. jsonTemp.InsuCode = dgvCenterDirectory.Rows[dgvCenterDirectory.CurrentRow.Index].Cells["Code"].Value;
  543. jsonTemp.InsuName = dgvCenterDirectory.Rows[dgvCenterDirectory.CurrentRow.Index].Cells["Name"].Value;
  544. jsonTemp.UpdateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  545. jaParams.Add(jsonTemp);
  546. JObject joIn = new JObject();
  547. joIn.Add(new JProperty("params", jaParams));
  548. joIn.Add("code", "09010040");
  549. InvokeHelper invoker = new InvokeHelper();
  550. JObject joRtn = invoker.invokeInsuService(joIn.ToString(), "插入对照信息");
  551. //JObject joRtn = JObject.Parse(irisRtn);
  552. if ((int)joRtn["errorCode"] == 0)
  553. {
  554. dgvHISDirectory.Rows[iHis].Cells["flag"].Value = "已对照";
  555. }
  556. else
  557. {
  558. dgvHISDirectory.Rows[iHis].Cells["flag"].Value = "对照失败";
  559. }
  560. }
  561. private void CancleMapping()
  562. {
  563. int iHis = dgvHISDirectory.CurrentRow.Index;
  564. DataTable dtHis = (DataTable)dgvHISDirectory.DataSource;
  565. JArray jaParams = new JArray();
  566. dynamic jsonTemp = new JObject();
  567. jsonTemp.ID = dtHis.Rows[iHis]["MapID"];
  568. jsonTemp.HospitalDr = Global.inf.hospitalDr;
  569. jsonTemp.updateUserID = Global.user.ID;
  570. jsonTemp.InterfaceDr = Global.inf.interfaceDr;
  571. jsonTemp.HISCode = dgvHISDirectory.Rows[iHis].Cells["itemCode"].Value;
  572. jsonTemp.UpdateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  573. jaParams.Add(jsonTemp);
  574. JObject joIn = new JObject();
  575. joIn.Add(new JProperty("params", jaParams));
  576. joIn.Add("code", "09010041");
  577. InvokeHelper invoker = new InvokeHelper();
  578. JObject joRtn = invoker.invokeInsuService(joIn.ToString(), "取消对照");
  579. if ((int)joRtn["errorCode"] == 0)
  580. {
  581. dgvHISDirectory.Rows[iHis].Cells["insuCode"].Value = "";
  582. dgvHISDirectory.Rows[iHis].Cells["insuName"].Value = "";
  583. dgvHISDirectory.Rows[iHis].Cells["flag"].Value = "";
  584. }
  585. else
  586. {
  587. dgvHISDirectory.Rows[iHis].Cells["flag"].Value = "取消失败";
  588. }
  589. }
  590. /// <summary>
  591. /// 医保目录单个版本号的下载
  592. /// </summary>
  593. /// <param name="ver"></param>
  594. /// <param name="directoryType"></param>
  595. /// <param name="uiProcessBar"></param>
  596. /// <param name="errorMessage"></param>
  597. /// <returns></returns>
  598. public int SingleDownload(string ver, int directoryType, Sunny.UI.UIProcessBar uiProcessBar, out string errorMessage)
  599. {
  600. string txtPath = string.Empty;
  601. errorMessage = "";
  602. int iResult = -1;
  603. string funNo = "";
  604. switch (directoryType)
  605. {
  606. case 0://药品
  607. {
  608. funNo = "1301"; //"1301";
  609. break;
  610. }
  611. case 1://诊疗
  612. {
  613. funNo = "1305";
  614. break;
  615. }
  616. case 2://材料
  617. {
  618. funNo = "1306";
  619. break;
  620. }
  621. case 3://疾病诊断
  622. {
  623. funNo = "1307";
  624. break;
  625. }
  626. case 4://手术
  627. {
  628. funNo = "1308";
  629. break;
  630. }
  631. case 5://慢性病
  632. {
  633. funNo = "1309";
  634. break;
  635. }
  636. case 6://DRGs
  637. {
  638. funNo = "1310";
  639. break; ;
  640. }
  641. case 7://日间手术
  642. {
  643. funNo = "1311";
  644. break;
  645. }
  646. case 8://字典表
  647. {
  648. break;
  649. }
  650. case 9://中药饮片
  651. {
  652. funNo = "1302";
  653. break;
  654. }
  655. case 10://医药机构制剂
  656. {
  657. funNo = "1303";
  658. break;
  659. }
  660. }
  661. try
  662. {
  663. JObject joRtn = hBus.DownloadDirectory(funNo, ver);
  664. //MessageBox.Show("往IRIS插入数据准备:" + joRtn.ToString());
  665. //if (JsonHelper.parseCenterRtnValue(joRtn, out errorMessage) == 0)
  666. if (JsonHelper.parseIrisRtnValue(joRtn, out errorMessage) == 0)
  667. {
  668. txtPath = joRtn["filePath"].ToString();
  669. //MessageBox.Show("获取txt数据往IRIS插入文件路径:"+ txtPath);
  670. DataImoport bus = new DataImoport();
  671. JObject joImportRtn = bus.importDataToIrisByTxt(txtPath, 50, directoryType + 1, uiProcessBar);
  672. //MessageBox.Show("往IRIS插入数据:" + joImportRtn.ToString());
  673. //if (JsonHelper.parseCenterRtnValue(joImportRtn, out errorMessage) == 0)
  674. if (JsonHelper.parseIrisRtnValue(joImportRtn, out errorMessage) == 0)
  675. {
  676. iResult = 0;
  677. }
  678. else
  679. {
  680. Global.writeLog(joImportRtn.ToString());
  681. errorMessage = "导入数据出现错误,请查看日志!";//joImportRtn["errorMessage"].ToString();
  682. }
  683. }
  684. return iResult;
  685. }
  686. catch (Exception ex)
  687. {
  688. errorMessage = "SingleDownload提示:" + ex.Message;
  689. return -1;
  690. }
  691. }
  692. /// <summary>
  693. /// 医保目录单个版本号的下载
  694. /// </summary>
  695. /// <param name="ver"></param>
  696. /// <param name="directoryType"></param>
  697. /// <param name="uiProcessBar"></param>
  698. /// <param name="errorMessage"></param>
  699. /// <returns></returns>
  700. public int downloadDicionary(JObject joData, Sunny.UI.UIProcessBar uiProcessBar, out string errorMessage)
  701. {
  702. errorMessage = "";
  703. int iResult = -1;
  704. try
  705. {
  706. JObject joRtn = cBus.DownDictionay(joData);
  707. if (JsonHelper.parseCenterRtnValue(joRtn, out errorMessage) == 0)
  708. {
  709. DataImoport DI = new DataImoport();
  710. JArray jaList = JArray.Parse(JsonHelper.getDestValue(joRtn, "output.list"));
  711. JObject joImportRtn = DI.importDictionary(uiProcessBar, jaList, tbDicType.Text);
  712. if (JsonHelper.parseIrisRtnValue(joImportRtn, out errorMessage) == 0)
  713. {
  714. iResult = 0;
  715. }
  716. else
  717. {
  718. errorMessage = "导入数据出现错误,请查看日志!" + errorMessage;
  719. }
  720. }
  721. return iResult;
  722. }
  723. catch (Exception ex)
  724. {
  725. errorMessage = "downloadDicionary提示:" + ex.Message;
  726. return -1;
  727. }
  728. }
  729. /// <summary>
  730. /// 自动下载医保目录,直到最新版本(返回报错)
  731. /// </summary>
  732. /// <param name="directoryType"></param>
  733. /// <param name="uiProcessBar"></param>
  734. /// <param name="errorMessage"></param>
  735. /// <returns></returns>
  736. public int AutoDownload(int directoryType, Sunny.UI.UIProcessBar uiProcessBar, out string errorMessage)
  737. {
  738. int iResult = 0;
  739. errorMessage = "";
  740. try
  741. {
  742. while (iResult == 0)
  743. {
  744. JObject joMaxVerNO = mIS.getDirectoryMaxVersionNO(directoryType);
  745. string ver = joMaxVerNO["result"]["MaxVersionNO"].ToString();
  746. tbVer.Text = ver;
  747. iResult = JsonHelper.parseIrisRtnValue(joMaxVerNO, out errorMessage);
  748. iResult = SingleDownload(ver, directoryType, uiProcessBar, out errorMessage);
  749. }
  750. return iResult;
  751. }
  752. catch (Exception ex)
  753. {
  754. errorMessage = ex.Message;
  755. return -1;
  756. }
  757. }
  758. #endregion
  759. private void Form1_Load(object sender, EventArgs e)
  760. {
  761. this.WindowState = FormWindowState.Maximized;
  762. rbgDirecType.ValueChanged += new Sunny.UI.UIRadioButtonGroup.OnValueChanged(rbgDirecType_ValueChanged);
  763. LabExplain.Visible = false;
  764. }
  765. private void btnDownload_Click(object sender, EventArgs e)
  766. {
  767. string errorMessage = string.Empty;
  768. //医保字典数据下载
  769. if (rbgDirecType.SelectedIndex == 8)
  770. {
  771. if (tbDicDate.Text == "")
  772. {
  773. MessageBox.Show("请输入查询日期!");
  774. return;
  775. }
  776. dynamic joData = new JObject();
  777. joData.type = tbDicType.Text; //字典类型
  778. joData.parentValue = ""; //父字典键值
  779. joData.admdvs = Global.inf.areaCode; //行政区划 就医地
  780. joData.date = tbDicDate.Text; //查询日期
  781. joData.vali_flag = "1"; //有效标志
  782. if (downloadDicionary(joData, uiProcessBar1, out errorMessage) != 0)
  783. {
  784. MessageBox.Show("医保字典下载失败:" + errorMessage);
  785. return;
  786. }
  787. }
  788. else if (rbgDirecType.SelectedIndex <=10)
  789. {
  790. if (rbSingleDown.Checked)
  791. {
  792. string ver = tbVer.Text;
  793. if (tbVer.Text != "")
  794. {
  795. ver = tbVer.Text;
  796. }
  797. if (SingleDownload(ver, rbgDirecType.SelectedIndex, uiProcessBar1, out errorMessage) != 0)
  798. {
  799. MessageBox.Show("医保目录下载失败:" + errorMessage);
  800. return;
  801. }
  802. }
  803. if (rbAutoDown.Checked)
  804. {
  805. if (AutoDownload(rbgDirecType.SelectedIndex, uiProcessBar1, out errorMessage) != 0)
  806. {
  807. MessageBox.Show("医保目录下载失败:" + errorMessage);
  808. return;
  809. }
  810. }
  811. }
  812. btnQuery_Click(sender, e);
  813. }
  814. private void btnQuery_Click(object sender, EventArgs e)
  815. {
  816. #region 校验查询条件
  817. if ((rbgDirecType.SelectedIndex < 0) || (rbgDirecType.SelectedIndex > 20))
  818. {
  819. MessageBox.Show("请先选择查询类型!");
  820. return;
  821. }
  822. if (rbgDirecType.SelectedIndex > 13)
  823. {
  824. if (rbgDirecType.SelectedIndex != 20)
  825. {
  826. if ((TexDate.Text == "") || (TexDate.Text == "输入日期 2021-01-01"))
  827. {
  828. MessageBox.Show("查询条件-请输入查询日期!");
  829. return;
  830. }
  831. if ((TexDQYS.Text == "") || (TexDQYS.Text == "当前页数"))
  832. {
  833. MessageBox.Show("查询条件-请输入当前页数!");
  834. return;
  835. }
  836. if ((TexBYSJL.Text == "") || (TexBYSJL.Text == "本页数据量"))
  837. {
  838. MessageBox.Show("查询条件-请输入本页数据量!");
  839. return;
  840. }
  841. }
  842. else
  843. {
  844. if ((TexYYMC.Text == "") || (TexYYMC.Text == "输入医院名称模糊查找"))
  845. {
  846. MessageBox.Show("查询条件-请输入医院名称模糊查找!");
  847. return;
  848. }
  849. }
  850. }
  851. #endregion
  852. queryHISInsuDirectory(rbgDirecType.SelectedIndex, 1, 20, dgvDirectoy, Global.inf.interfaceDr);
  853. }
  854. private void btnQueryHISDirectory_Click(object sender, EventArgs e)
  855. {
  856. string errMsg;
  857. GridViewSetter gridSetter = new GridViewSetter();
  858. gridSetter.SetHeaderTextOfMapping_HisDirectory(dgvHISDirectory);
  859. if (queryHISDirectory(1, 50, out errMsg) != 0)
  860. {
  861. MessageBox.Show(errMsg);
  862. return;
  863. }
  864. }
  865. private void btnQueryCenterDirectory_Click(object sender, EventArgs e)
  866. {
  867. if ((tbCenterDirectoryFilter.Text == "") && (tbInsuCode.Text == "") && (tbApprovalNO.Text == ""))
  868. {
  869. return;
  870. }
  871. //查询区域通用目录
  872. JObject joRtn = mIS.getInterface_TY(Global.inf.interfaceDr.ToString(),"");
  873. string InsuCurrencyCataLogue = JsonHelper.getDestValue(joRtn, "InsuCurrencyCataLogue"); //通用目录编码 6
  874. string InterfaceName_TY = JsonHelper.getDestValue(joRtn, "InterfaceName_TY"); //通用目录名称
  875. string HospName = JsonHelper.getDestValue(joRtn, "HospitalName"); //目录名称
  876. if (InsuCurrencyCataLogue != "")
  877. {
  878. queryHISInsuDirectory(rbgDirecType_C.SelectedIndex, 1, 50, dgvCenterDirectory, int.Parse(InsuCurrencyCataLogue));
  879. LabExplain.Visible = true;
  880. LabExplain.Text = "当前接口已设置区域通用目录,数据源来自:" + InterfaceName_TY+" ,如果确认没有所查目录请联系数据源医院新增维护!";
  881. }
  882. else
  883. {
  884. queryHISInsuDirectory(rbgDirecType_C.SelectedIndex, 1, 50, dgvCenterDirectory, Global.inf.interfaceDr);
  885. LabExplain.Visible = true;
  886. LabExplain.Text = "当前接口未设置区域通用目录,数据源来自:" + HospName;
  887. }
  888. }
  889. private void pgDownload_PageChanged(object sender, object pagingSource, int pageIndex, int count)
  890. {
  891. queryHISInsuDirectory(rbgDirecType.SelectedIndex, pageIndex, count, dgvDirectoy, Global.inf.interfaceDr);
  892. }
  893. private void pgHISDirect_PageChanged(object sender, object pagingSource, int pageIndex, int count)
  894. {
  895. string errMsg;
  896. if (queryHISDirectory(pageIndex, 50, out errMsg) != 0)
  897. {
  898. MessageBox.Show(errMsg);
  899. return;
  900. }
  901. }
  902. private void pgCenterDirect_PageChanged(object sender, object pagingSource, int pageIndex, int count)
  903. {
  904. queryHISInsuDirectory(rbgDirecType_C.SelectedIndex, pageIndex, count, dgvCenterDirectory, Global.inf.interfaceDr);
  905. }
  906. private void rbgDirecType_ValueChanged(object sender, int index, string text)
  907. {
  908. //选定项不同调用的接口也不相同,Index值大于
  909. if (rbgDirecType.SelectedIndex > 13)
  910. {
  911. uiGroupBox1.Visible = false;
  912. uiGroupBox5.Visible = false;
  913. uiGroupBox2.Visible = true;
  914. //uiGroupBox3.Visible = true;
  915. uiProcessBar1.Visible = false;
  916. uiGroupBox2.Left = rbgDirecType.Width + rbgDirecType.Left + 5;
  917. uiGroupBox3.Left = uiGroupBox2.Width+rbgDirecType.Width + rbgDirecType.Left + 10;
  918. dgvDirectoy.DataSource = null;
  919. }
  920. else
  921. {
  922. uiGroupBox1.Visible = true;
  923. uiGroupBox5.Visible = true;
  924. uiGroupBox2.Visible = true;
  925. //uiGroupBox3.Visible = false;
  926. uiProcessBar1.Visible = true;
  927. uiGroupBox1.Left = rbgDirecType.Width + rbgDirecType.Left + 5;
  928. uiGroupBox5.Left = uiGroupBox1.Width + rbgDirecType.Width + rbgDirecType.Left + 10;
  929. uiGroupBox2.Left = uiGroupBox5.Width + uiGroupBox1.Width + rbgDirecType.Width + rbgDirecType.Left + 15;
  930. uiGroupBox3.Left = uiGroupBox2.Width + uiGroupBox5.Width + uiGroupBox1.Width + rbgDirecType.Width + rbgDirecType.Left + 20;
  931. uiProcessBar1.Left = rbgDirecType.Width + rbgDirecType.Left + 5;
  932. uiProcessBar1.Width = uiGroupBox1.Width + uiGroupBox5.Width + uiGroupBox2.Width + 10;
  933. }
  934. setHeaderTxt(rbgDirecType.SelectedIndex, dgvDirectoy);
  935. }
  936. private void toolStripMenuItem2_Click(object sender, EventArgs e)
  937. {
  938. CancleMapping();
  939. }
  940. private void tsmiMapping_Click(object sender, EventArgs e)
  941. {
  942. Mapping();
  943. }
  944. private void dgvHISDirectory_DoubleClick(object sender, EventArgs e)
  945. {
  946. int currentPage = pgHISDirect.ActivePage;
  947. string flag = dgvHISDirectory.Rows[dgvHISDirectory.CurrentRow.Index].Cells["flag"].Value.ToString();
  948. if (flag == "未对照")
  949. {
  950. Mapping();
  951. }
  952. else
  953. if (flag == "已对照")
  954. {
  955. CancleMapping();
  956. }
  957. if (rbAll.Checked)
  958. {
  959. string errMsg;
  960. if (queryHISDirectory(1, 50, out errMsg) != 0)
  961. {
  962. MessageBox.Show(errMsg);
  963. return;
  964. }
  965. }
  966. }
  967. private void dgvDirectoy_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
  968. {
  969. }
  970. private void dgvDirectoy_CellContentClick(object sender, DataGridViewCellEventArgs e)
  971. {
  972. }
  973. private void uiRadioButton1_CheckedChanged(object sender, EventArgs e)
  974. {
  975. }
  976. private void dgvDirectoy_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
  977. {
  978. //自动编号,与数据无关
  979. Rectangle rectangle = new Rectangle(e.RowBounds.Location.X,
  980. e.RowBounds.Location.Y,
  981. dgvDirectoy.RowHeadersWidth - 4,
  982. e.RowBounds.Height);
  983. TextRenderer.DrawText(e.Graphics,
  984. (e.RowIndex + 1).ToString(),
  985. dgvDirectoy.RowHeadersDefaultCellStyle.Font,
  986. rectangle,
  987. dgvDirectoy.RowHeadersDefaultCellStyle.ForeColor,
  988. TextFormatFlags.VerticalCenter | TextFormatFlags.Right);
  989. }
  990. private void rbAll_ValueChanged(object sender, bool value)
  991. {
  992. if (rbAll.Checked)
  993. {
  994. btnQueryHISDirectory_Click(null, new EventArgs());
  995. }
  996. }
  997. private void rbMaped_CheckedChanged(object sender, EventArgs e)
  998. {
  999. if (rbMaped.Checked)
  1000. {
  1001. string errMsg;
  1002. if (queryHISDirectory(1, 50, out errMsg) != 0)
  1003. {
  1004. MessageBox.Show(errMsg);
  1005. return;
  1006. }
  1007. }
  1008. }
  1009. private void btAddDir_Click(object sender, EventArgs e)
  1010. {
  1011. AddSingleDirectory addDirectory = new AddSingleDirectory(rbgDirecType.SelectedIndex);
  1012. if (addDirectory.ShowDialog() == DialogResult.OK)
  1013. {
  1014. JObject joRtn = mIS.UpdateDirectoryBySelf(addDirectory.joPamam);
  1015. string error = "";
  1016. if (JsonHelper.parseIrisRtnValue(joRtn, out error) != 0)
  1017. {
  1018. MessageBox.Show("新增失败:" + error);
  1019. }
  1020. else
  1021. {
  1022. MessageBox.Show("新增成功");
  1023. }
  1024. }
  1025. }
  1026. private void btEditDir_Click(object sender, EventArgs e)
  1027. {
  1028. DataTable dt = (DataTable)dgvDirectoy.DataSource;
  1029. if ((dt == null) || (dt.Rows.Count < 1))
  1030. {
  1031. MessageBox.Show("表中无数据,请检查!");
  1032. return;
  1033. }
  1034. DataRow dr = dt.Rows[dgvDirectoy.CurrentRow.Index];
  1035. AddSingleDirectory addDirectory = new AddSingleDirectory(rbgDirecType.SelectedIndex, dr);
  1036. if (addDirectory.ShowDialog() == DialogResult.OK)
  1037. {
  1038. JObject joRtn = mIS.UpdateDirectoryBySelf(addDirectory.joPamam);
  1039. string error = "";
  1040. if (JsonHelper.parseIrisRtnValue(joRtn, out error) != 0)
  1041. {
  1042. MessageBox.Show("修改失败:" + error);
  1043. }
  1044. else
  1045. {
  1046. MessageBox.Show("修改成功");
  1047. }
  1048. }
  1049. }
  1050. private void btnExit_Click(object sender, EventArgs e)
  1051. {
  1052. Close();
  1053. }
  1054. /// <summary>
  1055. /// 几个医保查询的交易组织入参
  1056. /// </summary>
  1057. /// <param name="Index"></param>
  1058. /// <param name="funNo"></param>
  1059. /// <returns></returns>
  1060. private JObject GetInput(int Index, out string funNo)
  1061. {
  1062. funNo = "";
  1063. dynamic joData = new JObject();
  1064. switch (Index)
  1065. {
  1066. case 14://民族药品目
  1067. {
  1068. funNo = "1304";
  1069. joData.med_list_codg = tbDirectoryCode.Text; //医疗目录编码
  1070. joData.genname_codg = ""; //通用名编号
  1071. joData.drug_genname = ""; //药品通用名
  1072. joData.drug_prodname = tbDircetoryName.Text; //药品商品名
  1073. joData.reg_name = ""; //注册名称
  1074. joData.tcmherb_name = ""; //中草药名称
  1075. joData.mlms_name = ""; //药材名称
  1076. joData.vali_flag = ""; //有效标志
  1077. joData.rid = ""; //唯一记录号
  1078. joData.ver = ""; //版本号
  1079. joData.ver_name = ""; //版本名称
  1080. joData.opt_begn_time = ""; //经办开始时间
  1081. joData.opt_end_time = ""; //经办结束时间
  1082. joData.updt_time = TexDate.Text; //更新时间
  1083. joData.page_num = TexDQYS.Text; //当前页数
  1084. joData.page_size = TexBYSJL.Text; //本页数据量
  1085. break;
  1086. }
  1087. case 15://目录信息查询
  1088. {
  1089. funNo = "1312";
  1090. joData.query_date = ""; //查询时间点
  1091. joData.hilist_code = tbDirectoryCode.Text; //医保目录编码
  1092. joData.insu_admdvs = ""; //参保机构医保区划
  1093. joData.begndate = ""; //开始日期
  1094. joData.hilist_name = tbDircetoryName.Text; //医保目录名称
  1095. joData.wubi = ""; //五笔助记码
  1096. joData.pinyin = ""; //拼音助记码
  1097. joData.med_chrgitm_type = ""; //医疗收费项目类别
  1098. joData.chrgitm_lv = ""; //收费项目等级
  1099. joData.lmt_used_flag = ""; //限制使用标志
  1100. joData.list_type = ""; //目录类别
  1101. joData.med_use_flag = ""; //医疗使用标志
  1102. joData.matn_used_flag = ""; //生育使用标志
  1103. joData.hilist_use_type = ""; //医保目录使用类别
  1104. joData.lmt_cpnd_type = ""; //限复方使用类型
  1105. joData.vali_flag = ""; //有效标志
  1106. joData.updt_time = TexDate.Text; //更新时间
  1107. joData.page_num = TexDQYS.Text; //当前页数
  1108. joData.page_size = TexBYSJL.Text; //本页数据量
  1109. break;
  1110. }
  1111. case 16://医疗与医保目录匹配
  1112. {
  1113. funNo = "1316";
  1114. joData.query_date = ""; //查询时间点
  1115. joData.medins_list_codg = ""; //定点医药机构目录编号
  1116. joData.hilist_code = tbDirectoryCode.Text; //医保目录编码
  1117. joData.list_type = ""; //目录类别
  1118. joData.insu_admdvs = ""; //参保机构医保区划
  1119. joData.begndate = ""; //开始日期
  1120. joData.vali_flag = ""; //有效标志
  1121. joData.updt_time = TexDate.Text; //更新时间
  1122. joData.page_num = TexDQYS.Text; //当前页数
  1123. joData.page_size = TexBYSJL.Text; //本页数据量
  1124. break;
  1125. }
  1126. case 17://医药机构目录匹配
  1127. {
  1128. funNo = "1317";
  1129. joData.query_date = ""; //查询时间点
  1130. joData.fixmedins_code = ""; //定点医药机构编号
  1131. joData.medins_list_codg = ""; //定点医药机构目录编号
  1132. joData.medins_list_name = ""; //定点医药机构目录名称
  1133. joData.insu_admdvs = ""; //参保机构医保区划
  1134. joData.list_type = ""; //目录类别
  1135. joData.med_list_codg = tbDirectoryCode.Text; //医疗目录编码
  1136. joData.begndate = ""; //开始日期
  1137. joData.vali_flag = ""; //有效标志
  1138. joData.updt_time = TexDate.Text; //更新时间
  1139. joData.page_num = TexDQYS.Text; //当前页数
  1140. joData.page_size = TexBYSJL.Text; //本页数据量
  1141. break;
  1142. }
  1143. case 18://医保目录限价
  1144. {
  1145. funNo = "1318";
  1146. joData.query_date = ""; //查询时间点
  1147. joData.hilist_code = tbDirectoryCode.Text; //医保目录编码
  1148. joData.hilist_lmtpric_type = ""; //医保目录限价类型
  1149. joData.overlmt_dspo_way = ""; //医保目录超限处理方式
  1150. joData.insu_admdvs = ""; //参保机构医保区划
  1151. joData.begndate = ""; //开始日期
  1152. joData.enddate = ""; //结束日期
  1153. joData.vali_flag = ""; //有效标志
  1154. joData.rid = ""; //唯一记录号
  1155. joData.tabname = ""; //表名
  1156. joData.poolarea_no = ""; //统筹区
  1157. joData.updt_time = TexDate.Text; //更新时间
  1158. joData.page_num = TexDQYS.Text; //当前页数
  1159. joData.page_size = TexBYSJL.Text; //本页数据量
  1160. break;
  1161. }
  1162. case 19://医保目录先自付比例
  1163. {
  1164. funNo = "1319";
  1165. joData.query_date = ""; //查询时间点
  1166. joData.hilist_code = tbDirectoryCode.Text; //医保目录编码
  1167. joData.selfpay_prop_psn_type = "";//医保目录自付比例人员类别
  1168. joData.selfpay_prop_type = ""; //目录自付比例类别
  1169. joData.insu_admdvs = ""; //参保机构医保区划
  1170. joData.begndate = ""; //开始日期
  1171. joData.enddate = ""; //结束日期
  1172. joData.vali_flag = ""; //有效标志
  1173. joData.rid = ""; //唯一记录号
  1174. joData.tabname = ""; //表名
  1175. joData.poolarea_no = ""; //统筹区
  1176. joData.updt_time = TexDate.Text; //更新时间
  1177. joData.page_num = TexDQYS.Text; //当前页数
  1178. joData.page_size = TexBYSJL.Text; //本页数据量
  1179. break;
  1180. }
  1181. case 20://医药机构信息
  1182. {
  1183. funNo = "1201";
  1184. joData.fixmedins_type = "1"; //定点医疗服务机构类型 1定点医疗机构,2定点零售药店,3工伤定点康复机构,4辅助器具配置机构,5计划生育服务机构
  1185. joData.fixmedins_name = TexYYMC.Text; //定点医药机构名称
  1186. joData.fixmedins_code = ""; //定点医药机构编号
  1187. break;
  1188. }
  1189. }
  1190. return joData;
  1191. }
  1192. private void chek_UporCancel_CheckedChanged(object sender, EventArgs e)
  1193. {
  1194. }
  1195. private void uiButton1_Click(object sender, EventArgs e)
  1196. {
  1197. Close();
  1198. }
  1199. private void btnUpShip_Click(object sender, EventArgs e)
  1200. {
  1201. AllUpLoad();
  1202. }
  1203. private void btnCancelUpShip_Click(object sender, EventArgs e)
  1204. {
  1205. AllCancelUpload();
  1206. }
  1207. /// <summary>
  1208. /// 单条上传目录对照关系
  1209. /// </summary>
  1210. private void SingleUpload()
  1211. {
  1212. if ((dgvHISDirectory.CurrentRow == null) || (rbMaped.Checked != true))
  1213. {
  1214. MessageBox.Show("请查询HIS目录对照关系");
  1215. return;
  1216. }
  1217. string errorMsg = "", sMLLX = "";
  1218. //单条目录对照关系上传
  1219. int iHis = dgvHISDirectory.CurrentRow.Index;
  1220. DataTable dtHis = (DataTable)dgvHISDirectory.DataSource;
  1221. int hisType = rbgDirecType_C.SelectedIndex + 1; //1药品 2诊疗 3材料
  1222. //string hisTypeName = rbgDirecType_C.Items[hisType - 1].ToString();
  1223. if (hisType == 1)
  1224. {
  1225. sMLLX = "101"; //101西药中成药 102中药饮片 103自制剂 104民族药 201医疗服务项目 301医用耗材 501长护服务项目 105其他
  1226. }
  1227. else if (hisType == 2)
  1228. {
  1229. sMLLX = "201";
  1230. }
  1231. else if (hisType == 3)
  1232. {
  1233. sMLLX = "301";
  1234. }
  1235. string InsuCode = dtHis.Rows[iHis]["InsuCode"].ToString();
  1236. string InsuName = dtHis.Rows[iHis]["InsuName"].ToString();
  1237. string HisCode = dtHis.Rows[iHis]["itemCode"].ToString();
  1238. string HisName = dtHis.Rows[iHis]["itemDesc"].ToString();
  1239. string UpdateDate = DateTime.Now.ToString("yyyy-MM-dd");
  1240. //调用3301目录对照上传
  1241. JObject joData = new JObject();
  1242. joData.Add("fixmedins_hilist_id", HisCode);
  1243. joData.Add("fixmedins_hilist_name", HisName);
  1244. joData.Add("list_type", sMLLX); //目录类别
  1245. joData.Add("med_list_codg", InsuCode); //医疗目录编码
  1246. joData.Add("begndate", "2022-10-01"); //开始日期
  1247. joData.Add("enddate", UpdateDate); //结束日期
  1248. joData.Add("aprvno", "");
  1249. joData.Add("dosform", "");
  1250. joData.Add("exct_cont", "");
  1251. joData.Add("item_cont", "");
  1252. joData.Add("prcunt", "");
  1253. joData.Add("spec", "");
  1254. joData.Add("pacspec", "");
  1255. joData.Add("memo", "");
  1256. JObject joInput = new JObject();
  1257. joInput.Add("data", joData);
  1258. InvokeHelper invoker = new InvokeHelper();
  1259. JObject joRtn = invoker.invokeCenterService("3301", JsonHelper.setCenterInpar("3301", joInput));
  1260. if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
  1261. {
  1262. MessageBox.Show("目录对照关系上传失败:" + errorMsg);
  1263. }
  1264. else
  1265. {
  1266. MessageBox.Show("目录对照关系上传成功!");
  1267. }
  1268. }
  1269. /// <summary>
  1270. /// 单条撤销目录对照关系上传
  1271. /// </summary>
  1272. private void SingleCancelUpload()
  1273. {
  1274. if ((dgvHISDirectory.CurrentRow == null) || (rbMaped.Checked != true))
  1275. {
  1276. MessageBox.Show("请查询HIS目录对照关系");
  1277. return;
  1278. }
  1279. string errorMsg = "", sMLLX = "";
  1280. //撤销目录对照关系
  1281. DataTable dtHis = (DataTable)dgvHISDirectory.DataSource;
  1282. int iHis = dgvHISDirectory.CurrentRow.Index;
  1283. string InsuCode = dtHis.Rows[iHis]["InsuCode"].ToString();
  1284. string HisCode = dtHis.Rows[iHis]["HisCode"].ToString();
  1285. int hisType = rbgDirecType_C.SelectedIndex + 1; //1药品 2诊疗 3材料
  1286. //string hisTypeName = rbgDirecType_C.Items[hisType - 1].ToString();
  1287. if (hisType == 1)
  1288. {
  1289. sMLLX = "101"; //101西药中成药 102中药饮片 103自制剂 104民族药 201医疗服务项目 301医用耗材 501长护服务项目 105其他
  1290. }
  1291. else if (hisType == 2)
  1292. {
  1293. sMLLX = "201";
  1294. }
  1295. else if (hisType == 3)
  1296. {
  1297. sMLLX = "301";
  1298. }
  1299. //调用3302目录对照撤销
  1300. JObject joData = new JObject();
  1301. joData.Add("fixmedins_code", Global.inf.hospitalNO);
  1302. joData.Add("fixmedins_hilist_id", HisCode);
  1303. joData.Add("list_type", sMLLX); //目录类别
  1304. joData.Add("med_list_codg", InsuCode); //医疗目录编码
  1305. JObject joInput = new JObject();
  1306. joInput.Add("data", joData);
  1307. InvokeHelper invoker = new InvokeHelper();
  1308. JObject joRtn = invoker.invokeCenterService("3302", JsonHelper.setCenterInpar("3302", joInput));
  1309. if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
  1310. {
  1311. MessageBox.Show("目录对照撤销失败:" + errorMsg);
  1312. }
  1313. else
  1314. {
  1315. MessageBox.Show("目录对照撤销成功!");
  1316. }
  1317. }
  1318. /// <summary>
  1319. /// 全部上传目录对照关系
  1320. /// </summary>
  1321. private void AllUpLoad()
  1322. {
  1323. if ((dgvHISDirectory.CurrentRow == null) || (rbMaped.Checked != true))
  1324. {
  1325. MessageBox.Show("请查询HIS目录对照关系");
  1326. return;
  1327. }
  1328. string sInputStr = "", sMLLX = "", errorMsg = "", Msg = "";
  1329. Boolean bOk = true;
  1330. JObject InputjoRtn = new JObject();
  1331. string UpdateDate = DateTime.Now.ToString("yyyy-MM-dd");
  1332. int hisType = rbgDirecType_C.SelectedIndex + 1; //1药品 2诊疗 3材料
  1333. if (hisType == 1)
  1334. {
  1335. sMLLX = "101"; //101西药中成药 102中药饮片 103自制剂 104民族药 201医疗服务项目 301医用耗材 501长护服务项目 105其他
  1336. }
  1337. else if (hisType == 2)
  1338. {
  1339. sMLLX = "201";
  1340. }
  1341. else if (hisType == 3)
  1342. {
  1343. sMLLX = "301";
  1344. }
  1345. DataTable dtHis = (DataTable)dgvHISDirectory.DataSource;
  1346. for (int i = 0; i < dtHis.Rows.Count; i++)
  1347. {
  1348. string InsuCode = dtHis.Rows[i]["InsuCode"].ToString(); //医保目录编码
  1349. string InsuName = dtHis.Rows[i]["InsuName"].ToString(); //医保目录名称
  1350. string HisCode = dtHis.Rows[i]["itemCode"].ToString(); //HIS目录编码
  1351. string HisName = dtHis.Rows[i]["itemDesc"].ToString(); //HIS目录名称
  1352. //调用3301目录对照上传
  1353. JObject joData = new JObject();
  1354. joData.Add("fixmedins_hilist_id", HisCode);
  1355. joData.Add("fixmedins_hilist_name", HisName);
  1356. joData.Add("list_type", sMLLX); //目录类别
  1357. joData.Add("med_list_codg", InsuCode); //医疗目录编码
  1358. joData.Add("begndate", "2022-10-01"); //开始日期
  1359. joData.Add("enddate", UpdateDate); //结束日期
  1360. joData.Add("aprvno", "");
  1361. joData.Add("dosform", "");
  1362. joData.Add("exct_cont", "");
  1363. joData.Add("item_cont", "");
  1364. joData.Add("prcunt", "");
  1365. joData.Add("spec", "");
  1366. joData.Add("pacspec", "");
  1367. joData.Add("memo", "");
  1368. JObject joInput = new JObject();
  1369. joInput.Add("data", joData);
  1370. InvokeHelper invoker = new InvokeHelper();
  1371. JObject joRtn = invoker.invokeCenterService("3301", JsonHelper.setCenterInpar("3301", joInput));
  1372. if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
  1373. {
  1374. bOk = false;
  1375. Msg = Msg + "<" + joInput.ToString() + ":" + errorMsg + ">";
  1376. }
  1377. }
  1378. if (bOk == false)
  1379. {
  1380. MessageBox.Show("全部目录对照关系上传成功,部分上传异常:" + Msg);
  1381. }
  1382. else
  1383. {
  1384. MessageBox.Show("全部目录对照关系上传成功!");
  1385. }
  1386. }
  1387. /// <summary>
  1388. /// 全部撤销目录对照关系上传
  1389. /// </summary>
  1390. private void AllCancelUpload()
  1391. {
  1392. if ((dgvHISDirectory.CurrentRow == null) || (rbMaped.Checked != true))
  1393. {
  1394. MessageBox.Show("请查询HIS目录对照关系");
  1395. return;
  1396. }
  1397. string sMLLX = "", errorMsg = "", Msg = "";
  1398. Boolean bOk = true;
  1399. string UpdateDate = DateTime.Now.ToString("yyyy-MM-dd");
  1400. int hisType = rbgDirecType_C.SelectedIndex + 1; //1药品 2诊疗 3材料
  1401. if (hisType == 1)
  1402. {
  1403. sMLLX = "101"; //101西药中成药 102中药饮片 103自制剂 104民族药 201医疗服务项目 301医用耗材 501长护服务项目 105其他
  1404. }
  1405. else if (hisType == 2)
  1406. {
  1407. sMLLX = "201";
  1408. }
  1409. else if (hisType == 3)
  1410. {
  1411. sMLLX = "301";
  1412. }
  1413. DataTable dtHis = (DataTable)dgvHISDirectory.DataSource;
  1414. for (int i = 0; i < dtHis.Rows.Count; i++)
  1415. {
  1416. string InsuCode = dtHis.Rows[i]["InsuCode"].ToString();
  1417. string HisCode = dtHis.Rows[i]["HisCode"].ToString();
  1418. //调用3302目录对照撤销
  1419. JObject joData = new JObject();
  1420. joData.Add("fixmedins_code", Global.inf.hospitalNO);
  1421. joData.Add("fixmedins_hilist_id", HisCode);
  1422. joData.Add("list_type", sMLLX); //目录类别
  1423. joData.Add("med_list_codg", InsuCode); //医疗目录编码
  1424. JObject joInput = new JObject();
  1425. joInput.Add("data", joData);
  1426. InvokeHelper invoker = new InvokeHelper();
  1427. JObject joRtn = invoker.invokeCenterService("3302", JsonHelper.setCenterInpar("3302", joInput));
  1428. if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
  1429. {
  1430. bOk = false;
  1431. Msg = Msg + "<" + joInput.ToString()+":" + errorMsg + ">";
  1432. }
  1433. }
  1434. if (bOk == false)
  1435. {
  1436. MessageBox.Show("全部撤销目录对照关系上传成功,部分撤销异常:" + Msg);
  1437. }
  1438. else
  1439. {
  1440. MessageBox.Show("全部撤销目录对照关系上传成功!");
  1441. }
  1442. }
  1443. private void ToolStripMenuItem_Upload_Click(object sender, EventArgs e)
  1444. {
  1445. SingleUpload();
  1446. }
  1447. private void ToolStripMenuItem_CancelUpload_Click(object sender, EventArgs e)
  1448. {
  1449. SingleCancelUpload();
  1450. }
  1451. private void rbgDirecType_C_ValueChanged(object sender, int index, string text)
  1452. {
  1453. tbHISDirectoryFilter.Text = "";
  1454. uiTextBox1.Text = "";
  1455. rbAll.Checked = true;
  1456. rbMaped.Checked = false;
  1457. rbNoMaped.Checked = false;
  1458. tbCenterDirectoryFilter.Text = "";
  1459. tbInsuCode.Text = "";
  1460. tbApprovalNO.Text = "";
  1461. }
  1462. private void rbNoMaped_CheckedChanged(object sender, EventArgs e)
  1463. {
  1464. if (rbNoMaped.Checked)
  1465. {
  1466. string errMsg;
  1467. GridViewSetter gridSetter = new GridViewSetter();
  1468. gridSetter.SetHeaderTextOfMapping_HisDirectory(dgvHISDirectory);
  1469. if (queryHISDirectory(1, 50, out errMsg) != 0)
  1470. {
  1471. MessageBox.Show(errMsg);
  1472. return;
  1473. }
  1474. }
  1475. }
  1476. private void btnExport_Click(object sender, EventArgs e)
  1477. {
  1478. if (queryHISDirectory(1, 5000, out string errMsg) != 0)
  1479. {
  1480. MessageBox.Show(errMsg);
  1481. return;
  1482. }
  1483. if (dtExport.Rows.Count > 0)
  1484. {
  1485. string directoryType = string.Empty;
  1486. switch (rbgDirecType_C.SelectedIndex)
  1487. {
  1488. case 0:
  1489. {
  1490. directoryType = "药品";
  1491. break;
  1492. }
  1493. case 1:
  1494. {
  1495. directoryType = "诊疗";
  1496. break;
  1497. }
  1498. case 2:
  1499. {
  1500. directoryType = "材料";
  1501. break;
  1502. }
  1503. }
  1504. string LSH = DateTime.Now.ToString("yyyy-MM-dd"); //DateTime.Now.ToString("MMddHHmmssffff");
  1505. string sFliePathName = @"C:\Users\Administrator\Desktop\" + LSH + "(" + directoryType + ")医保目录已对照信息.xls";
  1506. string ReturnFileName = ExportToExcel.DataTabletoExcel(dtExport, sFliePathName);
  1507. if (ReturnFileName != "")
  1508. {
  1509. MessageBox.Show("导出成功,文件保存路径:【" + ReturnFileName + "】");
  1510. System.Diagnostics.Process.Start(ReturnFileName); //打开excel文件
  1511. }
  1512. else
  1513. {
  1514. MessageBox.Show("导出失败!");
  1515. }
  1516. }
  1517. }
  1518. private void uiButton2_Click(object sender, EventArgs e)
  1519. {
  1520. string errorMessage;
  1521. string filePath = string.Empty;
  1522. filePath = Global.curEvt.path + @"\MLDR\KJJHC.txt";
  1523. if (File.Exists(filePath) != true)
  1524. {
  1525. MessageBox.Show("路径【" + filePath + "】,文件不存在!");
  1526. return;
  1527. }
  1528. DataTable dtHis = (DataTable)dgvHISDirectory.DataSource;
  1529. if (dtHis.Rows.Count <= 0)
  1530. return;
  1531. JObject joImportMapRalation = bus.ImportToMapRelationFromTxt(filePath, 2, ProcessBar);
  1532. if (JsonHelper.parseIrisRtnValue(joImportMapRalation, out errorMessage) != 0)
  1533. {
  1534. Global.writeLog(joImportMapRalation.ToString());
  1535. MessageBox.Show("插入医保对照表ImportToMapRelation出现错误,请查看日志!" + errorMessage);
  1536. }
  1537. }
  1538. }
  1539. }