BasicData.cs 75 KB

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