SettlementChecklist.cs 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10. using PTMedicalInsurance.Helper;
  11. using PTMedicalInsurance.Common;
  12. using Newtonsoft.Json.Linq;
  13. using PTMedicalInsurance.FormSetter;
  14. using PTMedicalInsurance.Variables;
  15. using FastReport;
  16. using Newtonsoft.Json;
  17. using System.Threading;
  18. using PTMedicalInsurance.Business;
  19. using AnHuiMI.Common;
  20. namespace PTMedicalInsurance.Forms
  21. {
  22. public partial class SettlementChecklist : Form
  23. {
  24. private int hospitalDr;
  25. private int interfaceDr;
  26. private string hospitalNO;
  27. private string interfaceNO;
  28. private string hospitalName;
  29. private string hospitalAreaCode;
  30. private string reportTemplate = Global.curEvt.path + "\\frx\\settlement.frx";
  31. private bool disposed = false;
  32. Thread thread_test;
  33. private InvokeHelper invoker = new InvokeHelper();
  34. public SettlementChecklist()
  35. {
  36. InitializeComponent();
  37. hospitalDr = Global.inf.hospitalDr;
  38. hospitalNO = Global.inf.hospitalNO;
  39. hospitalName = Global.inf.hospitalName;
  40. hospitalAreaCode = Global.inf.areaCode;
  41. interfaceDr = Global.inf.interfaceDr;
  42. }
  43. public SettlementChecklist(JObject joParam)
  44. {
  45. InitializeComponent();
  46. hospitalDr = Global.inf.hospitalDr;
  47. hospitalNO = Global.inf.hospitalNO;
  48. hospitalName = Global.inf.hospitalName;
  49. hospitalAreaCode = Global.inf.areaCode;
  50. if (joParam == null) return;
  51. string setl_id = JsonHelper.getDestValue(joParam, "setl_id");
  52. if (setl_id == "")
  53. {
  54. MessageBox.Show("根据传入的结算编号为查询到相关信息,请手动输入查询!");
  55. return;
  56. }
  57. string sqlStr = "SELECT * FROM SQLUser.BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
  58. sqlStr = sqlStr + " and SettlementID='" + setl_id + "'";
  59. JObject joSqlStr = new JObject();
  60. joSqlStr.Add("sqlStr", sqlStr);
  61. MIIrisServices mIS = new MIIrisServices();
  62. JObject joRtn = mIS.QuerySettlementInfo(joSqlStr);
  63. DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  64. dgvSettlRecord.DataSource = dt;
  65. FastReportFunction.Register();
  66. }
  67. public void Dispose()
  68. {
  69. Dispose1(true);
  70. GC.SuppressFinalize(this);
  71. }
  72. protected virtual void Dispose1(bool disposing)
  73. {
  74. if (thread_test == null) return;
  75. if (disposed == false)
  76. {
  77. if (disposing == true)
  78. {
  79. Thread.Sleep(100);
  80. Global.writeLog("Main - aborting my thread.");
  81. thread_test.Abort();//终止线程myThread
  82. thread_test.Join();//等待线程myThread结束
  83. Global.writeLog("Main - ending.");
  84. }
  85. //释放托管资源的代码
  86. }
  87. disposed = true;
  88. }
  89. private void rbgDirecType_ValueChanged(object sender, int index, string text)
  90. {
  91. }
  92. private void btnQuery_Click(object sender, EventArgs e)
  93. {
  94. }
  95. private void btnQuery_Click_1(object sender, EventArgs e)
  96. {
  97. string sqlStr = " SELECT * FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + hospitalDr;
  98. sqlStr = sqlStr + " and OccurTime>'" + dpST.Text + "'";
  99. sqlStr = sqlStr + " and OccurTime<'" + dpED.Text + "'";
  100. if (tbName.Text != "")
  101. {
  102. sqlStr = sqlStr + " and PatientName='" + tbName.Text + "'";
  103. }
  104. if (tbPatSettlID.Text != "")
  105. {
  106. sqlStr = sqlStr + " and SettlementID='" + tbPatSettlID.Text + "'";
  107. }
  108. if (tbHisNO.Text != "")
  109. {
  110. sqlStr = sqlStr + " and Adm_Dr='" + tbHisNO.Text + "'";
  111. }
  112. if (cbxInterface.Text != "")
  113. {
  114. sqlStr = sqlStr + " and Interface_Dr=" + Global.inf.interfaceDr + "";
  115. }
  116. if (rbgAdmType.SelectedIndex == 1)
  117. {
  118. sqlStr = sqlStr + " and AdmType=2";
  119. }
  120. if (rbgAdmType.SelectedIndex == 2)
  121. {
  122. sqlStr = sqlStr + " and AdmType=1";
  123. }
  124. if (rbgBillType.SelectedIndex == 1)
  125. {
  126. sqlStr = sqlStr + " and BillType=1 and ValidFlag=1 ";
  127. }
  128. if (rbgBillType.SelectedIndex == 2)
  129. {
  130. sqlStr = sqlStr + " and BillType=-1 and ValidFlag=0 ";
  131. }
  132. JObject joSqlStr = new JObject();
  133. joSqlStr.Add("sqlStr", sqlStr);
  134. MIIrisServices mIS = new MIIrisServices();
  135. JObject joRtn = mIS.QuerySettlementInfo(joSqlStr);
  136. DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  137. dgvSettlRecord.DataSource = dt;
  138. }
  139. private void SettlementChecklist_Load(object sender, EventArgs e)
  140. {
  141. dpST.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
  142. dpED.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
  143. ComboxSetter cbxSetter = new ComboxSetter();
  144. cbxSetter.setCbxInterfaceDataSource(cbxInterface);
  145. GridViewSetter grdSetter = new GridViewSetter();
  146. grdSetter.SetHeaderTextOfSettlList(dgvSettlRecord);
  147. rbgAdmType.SelectedIndex = 0;
  148. rbgBillType.SelectedIndex = 1;
  149. cbxInterface.SelectedValueChanged += new EventHandler(cbxInterface_SelectedValueChanged);
  150. }
  151. private void cbxInterface_SelectedValueChanged(object sender, EventArgs e)
  152. {
  153. DataTable dt = (DataTable)cbxInterface.DataSource;
  154. int i = cbxInterface.SelectedIndex;
  155. //赋值
  156. hospitalNO = dt.Rows[i]["HospitalNO"].ToString();
  157. //MessageBox.Show(dt.Rows[i]["HospitalDr"].ToString());
  158. //MessageBox.Show(dt.Rows[i]["HospitalDr"].ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly);
  159. hospitalDr = int.Parse(dt.Rows[i]["HospitalDr"].ToString());
  160. interfaceNO = dt.Rows[i]["InterfaceNO"].ToString();
  161. interfaceDr = int.Parse(dt.Rows[i]["ID"].ToString());
  162. hospitalAreaCode = dt.Rows[i]["AreaCode"].ToString();
  163. //Global.inf.centerURL = dt.Rows[i]["CenterURL"].ToString();
  164. //Global.inf.businessDllName = dt.Rows[i]["DLLName"].ToString();
  165. //Global.inf.patientAreaCode = dt.Rows[i]["AreaCode"].ToString();
  166. }
  167. private JObject getPatCheckList()
  168. {
  169. try
  170. {
  171. if (dgvSettlRecord.CurrentRow == null)
  172. {
  173. // mock data
  174. var root = new Root();
  175. root.result = new Result();
  176. root.result.data = new Data();
  177. root.result.data.classification = new List<Classification>() { new Classification() };
  178. root.result.data.settlement = new List<Settlement>() { new Settlement() };
  179. root.result.data.reginfo = new List<Reginfo>() { new Reginfo() };
  180. root.result.data.patinsuinfo = new List<Patinsuinfo>() { new Patinsuinfo() };
  181. return JObject.Parse(JsonHelper.toJsonString(root));
  182. }
  183. int i = dgvSettlRecord.CurrentRow.Index;
  184. DataTable dt = (DataTable)dgvSettlRecord.DataSource;
  185. JObject joSettel = new JObject();
  186. joSettel.Add("HospitalDr", Global.inf.hospitalDr);
  187. joSettel.Add("interfaceDr", Global.inf.interfaceDr);
  188. joSettel.Add("admID", dt.Rows[i]["AdmID"].ToString());
  189. joSettel.Add("SettlementID", dt.Rows[i]["SettlementID"].ToString());
  190. joSettel.Add("ValidFlag", dt.Rows[i]["ValidFlag"].ToString());
  191. JObject joRtn = invoker.invokeInsuService(JsonHelper.setIrisInpar("09010066", joSettel).ToString(), "获取结算单信息");
  192. return joRtn;
  193. }
  194. catch (Exception ex)
  195. {
  196. JObject joRtn = new JObject();
  197. joRtn.Add("errorCode", -1);
  198. joRtn.Add("errorMessage", ex.Message);
  199. return joRtn;
  200. }
  201. }
  202. private void uiPanel1_Click(object sender, EventArgs e)
  203. {
  204. }
  205. [STAThread]
  206. public void design()
  207. {
  208. try
  209. {
  210. string chineseSimpleFrl = Global.curEvt.path + @"\Chinese (Simplified).frl";
  211. FastReport.Utils.Res.LoadLocale(chineseSimpleFrl);
  212. //string errMsg;
  213. //if (JsonHelper.parseIrisRtnValue(joSettleCheckList, out errMsg) != 0)
  214. //{
  215. // MessageBox.Show("查询结算信息异常:" + errMsg);
  216. // return;
  217. //}
  218. Report report = new Report();
  219. try
  220. {
  221. var json = JsonConvert.DeserializeObject<Root>(getPatCheckList().ToString());
  222. report.RegisterData(json.result.data.classification, "classification");
  223. report.RegisterData(json.result.data.settlement, "settlement");
  224. report.RegisterData(json.result.data.reginfo, "reginfo");
  225. report.RegisterData(json.result.data.patinsuinfo, "patinsuinfo");
  226. }
  227. catch (Exception ex)
  228. {
  229. MessageBox.Show(ex.Message);
  230. return;
  231. }
  232. report.Load(reportTemplate);
  233. PrintDesign pf = new PrintDesign();
  234. pf.designerControl1.Report = report;
  235. report.Design();
  236. pf.WindowState = FormWindowState.Maximized;
  237. pf.ShowDialog();
  238. }
  239. catch (Exception ex)
  240. {
  241. MessageBox.Show(ex.Message);
  242. }
  243. }
  244. [STAThread]
  245. private void print()
  246. {
  247. try
  248. {
  249. FastReportFunction.Register();
  250. string chineseSimpleFrl = Global.curEvt.path + @"\Chinese (Simplified).frl";
  251. FastReport.Utils.Res.LoadLocale(chineseSimpleFrl);
  252. JObject joSettleCheckList = getPatCheckList();
  253. string errMsg;
  254. if (JsonHelper.parseIrisRtnValue(joSettleCheckList, out errMsg) != 0)
  255. {
  256. MessageBox.Show("查询结算信息异常:" + errMsg);
  257. return;
  258. }
  259. Report report = new Report();
  260. var json = JsonConvert.DeserializeObject<Root>(getPatCheckList().ToString());
  261. report.RegisterData(json.result.data.classification, "classification");
  262. report.RegisterData(json.result.data.settlement, "settlement");
  263. report.RegisterData(json.result.data.reginfo, "reginfo");
  264. report.RegisterData(json.result.data.patinsuinfo, "patinsuinfo");
  265. report.Load(reportTemplate);
  266. this.ShowInTaskbar = true;
  267. PrintPreview pf = new PrintPreview();
  268. report.Preview = pf.previewControl1;
  269. report.Show();
  270. pf.WindowState = FormWindowState.Maximized;
  271. pf.ShowDialog();
  272. }
  273. catch (Exception ex)
  274. {
  275. MessageBox.Show(ex.Message);
  276. return;
  277. }
  278. }
  279. [STAThread]
  280. private void preview()
  281. {
  282. Report report = new Report();
  283. try
  284. {
  285. var json = JsonConvert.DeserializeObject<Root>(getPatCheckList().ToString());
  286. report.RegisterData(json.result.data.classification, "classification");
  287. report.RegisterData(json.result.data.settlement, "settlement");
  288. report.RegisterData(json.result.data.reginfo, "reginfo");
  289. report.RegisterData(json.result.data.patinsuinfo, "patinsuinfo");
  290. }
  291. catch (Exception ex)
  292. {
  293. MessageBox.Show(ex.Message);
  294. return;
  295. }
  296. //report.Design();
  297. report.Load(reportTemplate);
  298. //report.Show();
  299. PrintPreview preview1 = new PrintPreview();
  300. preview1.Show();
  301. report.Preview = preview1.previewControl1;
  302. report.Prepare(); //准备
  303. report.ShowPrepared(); //显示
  304. preview1.Show();
  305. }
  306. private void uiButton2_Click(object sender, EventArgs e)
  307. {
  308. Close();
  309. }
  310. public void btnPrint_Click(object sender, EventArgs e)
  311. {
  312. try
  313. {
  314. Thread thread = new Thread(new ThreadStart(print));
  315. thread.SetApartmentState(ApartmentState.STA); //重点
  316. thread.Start();
  317. thread.Join();
  318. }
  319. catch (Exception ex)
  320. {
  321. Global.writeLog("结算单打印异常:" + ex.Message);
  322. MessageBox.Show("打印异常:" + ex.Message);
  323. }
  324. //CardReader CardRead = new CardReader();
  325. //string sOutPar;
  326. //CardRead.FastReportPrint(out sOutPar);
  327. //if (JsonHelper.getDestValue(JObject.Parse(sOutPar), "code") != "0")
  328. //{
  329. // MessageBox.Show("调用FastReportDLL失败:" + sOutPar);
  330. // return;
  331. //}
  332. }
  333. private void btnDesign_Click(object sender, EventArgs e)
  334. {
  335. thread_test = new Thread(new ThreadStart(design));
  336. thread_test.SetApartmentState(ApartmentState.STA); //重点
  337. thread_test.Start();
  338. }
  339. private void SettlementChecklist_FormClosed(object sender, FormClosedEventArgs e)
  340. {
  341. Dispose();
  342. }
  343. }
  344. // Root myDeserializedClass = JsonConvert.DeserializeObject<Root>(myJsonResponse);
  345. public class Classification
  346. {
  347. public string cwfSummat { get; set; }
  348. public string cwfInScope { get; set; }
  349. public string cwfPreSelfPay { get; set; }
  350. public string cwfOverLimit { get; set; }
  351. public string cwfFullOwnPay { get; set; }
  352. public string zcfSummat { get; set; }
  353. public string zcfInScope { get; set; }
  354. public string zcfPreSelfPay { get; set; }
  355. public string zcfOverLimit { get; set; }
  356. public string zcfFullOwnPay { get; set; }
  357. public string jcfSummat { get; set; }
  358. public string jcfInScope { get; set; }
  359. public string jcfPreSelfPay { get; set; }
  360. public string jcfOverLimit { get; set; }
  361. public string jcfFullOwnPay { get; set; }
  362. public string hyfSummat { get; set; }
  363. public string hyfInScope { get; set; }
  364. public string hyfPreSelfPay { get; set; }
  365. public string hyfOverLimit { get; set; }
  366. public string hyfFullOwnPay { get; set; }
  367. public string zlfSummat { get; set; }
  368. public string zlfInScope { get; set; }
  369. public string zlfPreSelfPay { get; set; }
  370. public string zlfOverLimit { get; set; }
  371. public string zlfFullOwnPay { get; set; }
  372. public string ssfSummat { get; set; }
  373. public string ssfInScope { get; set; }
  374. public string ssfPreSelfPay { get; set; }
  375. public string ssfOverLimit { get; set; }
  376. public string ssfFullOwnPay { get; set; }
  377. public string hlfSummat { get; set; }
  378. public string hlfInScope { get; set; }
  379. public string hlfPreSelfPay { get; set; }
  380. public string hlfOverLimit { get; set; }
  381. public string hlfFullOwnPay { get; set; }
  382. public string wsclfSummat { get; set; }
  383. public string wsclfInScope { get; set; }
  384. public string wsclfPreSelfPay { get; set; }
  385. public string wsclfOverLimit { get; set; }
  386. public string wsclfFullOwnPay { get; set; }
  387. public string xyfSummat { get; set; }
  388. public string xyfInScope { get; set; }
  389. public string xyfPreSelfPay { get; set; }
  390. public string xyfOverLimit { get; set; }
  391. public string xyfFullOwnPay { get; set; }
  392. public string zyypfSummat { get; set; }
  393. public string zyypfInScope { get; set; }
  394. public string zyypfPreSelfPay { get; set; }
  395. public string zyypfOverLimit { get; set; }
  396. public string zyypfFullOwnPay { get; set; }
  397. public string zcyfSummat { get; set; }
  398. public string zcyfInScope { get; set; }
  399. public string zcyfPreSelfPay { get; set; }
  400. public string zcyfOverLimit { get; set; }
  401. public string zcyfFullOwnPay { get; set; }
  402. public string ybzlfSummat { get; set; }
  403. public string ybzlfInScope { get; set; }
  404. public string ybzlfPreSelfPay { get; set; }
  405. public string ybzlfOverLimit { get; set; }
  406. public string ybzlfFullOwnPay { get; set; }
  407. public string ghfSummat { get; set; }
  408. public string ghfInScope { get; set; }
  409. public string ghfPreSelfPay { get; set; }
  410. public string ghfOverLimit { get; set; }
  411. public string ghfFullOwnPay { get; set; }
  412. public string qtSummat { get; set; }
  413. public string qtInScope { get; set; }
  414. public string qtPreSelfPay { get; set; }
  415. public string qtOverLimit { get; set; }
  416. public string qtFullOwnPay { get; set; }
  417. public string totalSummat { get; set; }
  418. public string totalInScope { get; set; }
  419. public string totalPreSelfPay { get; set; }
  420. public string totalOverLimit { get; set; }
  421. public string totalFullOwnPay { get; set; }
  422. }
  423. public class Data
  424. {
  425. public List<Classification> classification { get; set; }
  426. public List<Settlement> settlement { get; set; }
  427. public List<Reginfo> reginfo { get; set; }
  428. public List<Patinsuinfo> patinsuinfo { get; set; }
  429. }
  430. public class Patinsuinfo
  431. {
  432. public string PsnCertType { get; set; }
  433. public string PsnCertNO { get; set; }
  434. public string Gend { get; set; }
  435. public string Naty { get; set; }
  436. public string Brdy { get; set; }
  437. public string Age { get; set; }
  438. public string Balc { get; set; }
  439. public string PsnType { get; set; }
  440. public string Cvlservflag { get; set; }
  441. public string insuplcAdmdvs { get; set; }
  442. public string EmpName { get; set; }
  443. public string PsnIdettype { get; set; }
  444. public string PsnTypeLv { get; set; }
  445. }
  446. public class Reginfo
  447. {
  448. public string AttendDoctorNO { get; set; }
  449. public string ChiefPhyDocName { get; set; }
  450. public string AdmitDepartmentCode { get; set; }
  451. public string AdmitDepartmentName { get; set; }
  452. public string AdmBed { get; set; }
  453. public string AdmNo { get; set; }
  454. public string MainDiagCode { get; set; }
  455. public string MainDiagName { get; set; }
  456. public string RegDate { get; set; }
  457. public string ConerName { get; set; }
  458. public string Tel { get; set; }
  459. }
  460. public class Result
  461. {
  462. public Data data { get; set; }
  463. }
  464. public class Root
  465. {
  466. public Result result { get; set; }
  467. public int errorCode { get; set; }
  468. public string errorMessage { get; set; }
  469. }
  470. public class Settlement
  471. {
  472. public string AdmID { get; set; }
  473. public string MdtrtID { get; set; }
  474. public string SettlementID { get; set; }
  475. public string PersonnelNO { get; set; }
  476. public string PatientName { get; set; }
  477. public string birth { get; set; }
  478. public string CertificateNO { get; set; }
  479. public string Gender { get; set; }
  480. public string InsuranceType { get; set; }
  481. public string PersonType { get; set; }
  482. public string CivilserviceFlag { get; set; }
  483. public string SettlementTime { get; set; }
  484. public string MedicalType { get; set; }
  485. public string Sumamt { get; set; }
  486. public string OwnPayAmount { get; set; }
  487. public string OverLimitAmount { get; set; }
  488. public string PreSelfPayAmount { get; set; }
  489. public string InPolicyRangeAmount { get; set; }
  490. public double ActualPayDeductible { get; set; }
  491. public string HealthInsurancePay { get; set; }
  492. public string HealthInsuranceRatio { get; set; }
  493. public double CivilserviceAllowancePay { get; set; }
  494. public string EnterpriseSupplementPay { get; set; }
  495. public string SeriousIllnessPay { get; set; }
  496. public string LargeExpensesSupplementPay { get; set; }
  497. public string MedicalAssistPay { get; set; }
  498. public string HospitalPartAmount { get; set; }
  499. public string OtherPay { get; set; }
  500. public string FundPaySumamt { get; set; }
  501. public string PersonPaySumamt { get; set; }
  502. public string AccountPaySumamt { get; set; }
  503. public string PersonCashPay { get; set; }
  504. public string Balance { get; set; }
  505. public string AccountMutualAidAmount { get; set; }
  506. public string OrganSettlementID { get; set; }
  507. public string ClearingOrgan { get; set; }
  508. public string ClearingWay { get; set; }
  509. public string ClearingType { get; set; }
  510. public string ValidFlag { get; set; }
  511. public string msgid { get; set; }
  512. public string HospitalizationsTimes { get; set; }
  513. public string HospitalizationsDays { get; set; }
  514. public string HISAdmTime { get; set; }
  515. public string HISDischargeTime { get; set; }
  516. public int BillType { get; set; }
  517. public string BillID { get; set; }
  518. public string admType { get; set; }
  519. public string RecordID { get; set; }
  520. public string insuplc_admdvs { get; set; }
  521. }
  522. }