Clearing.cs 78 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930
  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.Common;
  11. using PTMedicalInsurance.Helper;
  12. using Newtonsoft.Json.Linq;
  13. using PTMedicalInsurance.FormSetter;
  14. using System.IO;
  15. using System.IO.Compression;
  16. using PTMedicalInsurance.Business;
  17. using Sunny.UI;
  18. using Newtonsoft.Json;
  19. using System.Collections;
  20. using PTMedicalInsurance.Variables;
  21. namespace PTMedicalInsurance.Forms
  22. {
  23. public partial class Clearing : Form
  24. {
  25. private string txtPath;
  26. private string txtName;
  27. private string finalAchPath;
  28. private UIDataGridViewFooter dgvHisSettlRecFooter = new Sunny.UI.UIDataGridViewFooter();
  29. JObject jo9102Rtn = new JObject();
  30. public Clearing()
  31. {
  32. InitializeComponent();
  33. this.StartPosition = FormStartPosition.CenterParent;
  34. }
  35. private void Clearing_Load(object sender, EventArgs e)
  36. {
  37. ComboxSetter cbxSetter = new ComboxSetter();
  38. cbxSetter.setCbxInterfaceDataSource(cbxInterface);
  39. cbxSetter.setCbxInterfaceDataSource(cbInterface_2);
  40. cbxSetter.setCbxInterfaceDataSource(cbInterface_3);
  41. cbxSetter.setCbxDictionaryDataSource(Global.inf.interfaceDr.ToString(), "insutype", cbxInsuType);
  42. cbxSetter.setCbxDictionaryDataSource(Global.inf.interfaceDr.ToString(), "clr_type", cbxClrType);
  43. cbxSetter.setCbxDictionaryDataSource(Global.inf.interfaceDr.ToString(), "clr_type", cbClrType_2);
  44. cbxSetter.setCbxDictionaryDataSource(Global.inf.interfaceDr.ToString(), "clr_way", cbClrWay_2);
  45. cbxSetter.setCbxDictionaryDataSource("1", "clr_type", cbxClrType_O);
  46. cbxInterface.SelectedValueChanged += new EventHandler(cbxInterface_SelectedValueChanged);
  47. cbInterface_2.SelectedValueChanged += new EventHandler(cbInterface_2_SelectedValueChanged);
  48. cbInterface_3.SelectedValueChanged += new EventHandler(cbInterface_3_SelectedValueChanged);
  49. GridViewSetter grdSetter = new GridViewSetter();
  50. grdSetter.SetHeaderTextOfCheck(dgvSettlSummary);
  51. grdSetter.SetHeaderTextOfClearing(dgvClearingSum);
  52. grdSetter.SetHeaderTextOfClearingData(dgvClearingData);
  53. grdSetter.SetHeaderTextOfOthPlcCheck(dgvOthCheck);
  54. cbgGroupSet.SelectAll();
  55. cbgGroupSet.SetItemCheckState(4, false);
  56. cbxValid.SelectedIndex = 0;
  57. cbValid_2.SelectedIndex = 1;
  58. cbValid_3.SelectedIndex = 0;
  59. rbgTimeWay.SelectedIndex = 0;
  60. dpST.Text = DateTime.Now.ToString("yyyy-MM-01 00:00:00");
  61. dpED.Value = DateTime.Now.AddDays(1 - DateTime.Now.Day).AddMonths(1).AddDays(-1);
  62. dpST_2.Text = DateTime.Now.ToString("yyyy-MM-01 00:00:00");
  63. dpED_2.Value = DateTime.Now.AddDays(1 - DateTime.Now.Day).AddMonths(1).AddDays(-1);
  64. dpED_3.Value = DateTime.Now;
  65. WindowState = FormWindowState.Maximized;
  66. tbTmp.Text= Global.currentDirectory + "\\Download";
  67. }
  68. private void cbxInterface_SelectedValueChanged(object sender, EventArgs e)
  69. {
  70. DataTable dtInteface = (DataTable)cbxInterface.DataSource;
  71. int i = cbxInterface.SelectedIndex;
  72. if (i != 2)
  73. {
  74. Global.pat.insuplc_admdvs = "";
  75. }
  76. else
  77. {
  78. Global.pat.insuplc_admdvs = "530199";
  79. }
  80. Global.inf.hospitalNO = dtInteface.Rows[i]["HospitalNO"].ToString();
  81. Global.inf.hospitalName = dtInteface.Rows[i]["HospitalName"].ToString();
  82. Global.inf.centerURL = dtInteface.Rows[i]["CenterURL"].ToString();
  83. Global.inf.areaCode = dtInteface.Rows[i]["AreaCode"].ToString();
  84. Global.user.name = "0";
  85. Global.user.ID = "0";
  86. Global.inf.operatoType = "3";
  87. Global.inf.version = "v1.0";
  88. Global.inf.recivedSystem = "SY";
  89. Global.inf.interfaceDr = int.Parse(dtInteface.Rows[i]["ID"].ToString());
  90. ComboxSetter cbxSetter = new ComboxSetter();
  91. cbxSetter.setCbxDictionaryDataSource(dtInteface.Rows[i]["ID"].ToString(), "insutype", cbxInsuType);
  92. cbxSetter.setCbxDictionaryDataSource(dtInteface.Rows[i]["ID"].ToString(), "clr_type", cbxClrType);
  93. }
  94. private void cbInterface_2_SelectedValueChanged(object sender, EventArgs e)
  95. {
  96. DataTable dtInteface = (DataTable)cbInterface_2.DataSource;
  97. int i = cbInterface_2.SelectedIndex;
  98. if (i != 2)
  99. {
  100. Global.inf.areaCode = "";
  101. }
  102. else
  103. {
  104. Global.pat.insuplc_admdvs = "530100";
  105. }
  106. Global.inf.hospitalNO = dtInteface.Rows[i]["HospitalNO"].ToString();
  107. Global.inf.hospitalName = dtInteface.Rows[i]["HospitalName"].ToString();
  108. Global.inf.centerURL = dtInteface.Rows[i]["CenterURL"].ToString();
  109. Global.inf.areaCode = dtInteface.Rows[i]["AreaCode"].ToString();
  110. Global.user.name = "0";
  111. Global.user.ID = "0";
  112. Global.inf.operatoType = "3";
  113. Global.inf.version = "v1.0";
  114. Global.inf.recivedSystem = "SY";
  115. Global.inf.interfaceDr = int.Parse(dtInteface.Rows[i]["ID"].ToString());
  116. ComboxSetter cbxSetter = new ComboxSetter();
  117. cbxSetter.setCbxDictionaryDataSource(Global.inf.interfaceDr.ToString(), "clr_type", cbClrType_2);
  118. cbxSetter.setCbxDictionaryDataSource(Global.inf.interfaceDr.ToString(), "clr_way", cbClrWay_2);
  119. }
  120. private void cbInterface_3_SelectedValueChanged(object sender, EventArgs e)
  121. {
  122. DataTable dtInteface = (DataTable)cbInterface_2.DataSource;
  123. int i = cbInterface_2.SelectedIndex;
  124. if (i != 2)
  125. {
  126. Global.inf.areaCode = "";
  127. }
  128. else
  129. {
  130. Global.pat.insuplc_admdvs = "530100";
  131. }
  132. Global.inf.hospitalNO = dtInteface.Rows[i]["HospitalNO"].ToString();
  133. Global.inf.hospitalName = dtInteface.Rows[i]["HospitalName"].ToString();
  134. Global.inf.centerURL = dtInteface.Rows[i]["CenterURL"].ToString();
  135. Global.inf.areaCode = dtInteface.Rows[i]["AreaCode"].ToString();
  136. Global.user.name = "0";
  137. Global.user.ID = "0";
  138. Global.inf.operatoType = "3";
  139. Global.inf.version = "v1.0";
  140. Global.inf.recivedSystem = "SY";
  141. }
  142. /// <summary>
  143. /// 单条对总账事件
  144. /// </summary>
  145. /// <param name="sender"></param>
  146. /// <param name="e"></param>
  147. private void tsmCheck_Single_Click(object sender, EventArgs e)
  148. {
  149. string error = "";
  150. if (Check_Single(out error) != 0)
  151. {
  152. MessageBox.Show("对总账失败:" + error);
  153. }
  154. else
  155. {
  156. MessageBox.Show("对总账成功");
  157. }
  158. }
  159. /// <summary>
  160. /// 单条对总账【本地】
  161. /// </summary>
  162. /// <param name="error"></param>
  163. /// <returns></returns>
  164. private int Check_Single(out string error)
  165. {
  166. error = "";
  167. DataTable dt = (DataTable)dgvSettlSummary.DataSource;
  168. int i = dgvSettlSummary.CurrentRow.Index;
  169. dynamic joCheck = new JObject();
  170. joCheck.insutype = dt.Rows[i]["insutype"].ToString(); //险种类型
  171. joCheck.clr_type = dt.Rows[i]["clr_type"].ToString(); //清算类别
  172. if (tbSettlOption.Text != "")
  173. {
  174. joCheck.setl_optins = tbSettlOption.Text; //dt.Rows[i]["setl_optins"].ToString(); //结算经办机构
  175. }
  176. else
  177. {
  178. joCheck.setl_optins = dt.Rows[i]["setl_optins"].ToString(); //结算经办机构
  179. }
  180. joCheck.medfee_sumamt = dt.Rows[i]["medfee_sumamt"].ToString(); //医疗费总额
  181. joCheck.fund_pay_sumamt = dt.Rows[i]["fund_pay_sumamt"].ToString(); //基金支付总额
  182. joCheck.acct_pay = dt.Rows[i]["acct_pay"].ToString(); //个人账户支付金额
  183. if (tbCnt.Text!="")
  184. joCheck.fixmedins_setl_cnt = tbCnt.Text; //定点医药机构结算笔数
  185. else
  186. joCheck.fixmedins_setl_cnt = dt.Rows[i]["fixmedins_setl_cnt"].ToString(); //定点医药机构结算笔数
  187. joCheck.stmt_begndate = dpST.Value.ToString("yyyy-MM-dd HH:mm:ss"); //对账开始日期
  188. joCheck.stmt_enddate = dpED.Value.ToString("yyyy-MM-dd HH:mm:ss"); //对账结束日期
  189. JObject joData = new JObject();
  190. joData.Add("data", joCheck);
  191. //上传给中心
  192. //先签到
  193. CenterBusiness cBus = new CenterBusiness();
  194. JObject jo9001Rtn = new JObject();
  195. cBus.signIn(out jo9001Rtn);
  196. InvokeHelper invoker = new InvokeHelper();
  197. JObject joRtn = invoker.invokeCenterService("3201", JsonHelper.setCenterInpar("3201", joData.ToString()));
  198. if (JsonHelper.parseCenterReturnJson(joRtn, out error) != 0)
  199. {
  200. return -1;
  201. }
  202. else
  203. {
  204. if (JsonHelper.getDestValue(joRtn, "output.stmtinfo.stmt_rslt") != "0")
  205. {
  206. error = JsonHelper.getDestValue(joRtn, "output.stmtinfo.stmt_rslt_dscr");
  207. return -1;
  208. }
  209. else
  210. {
  211. return 0;
  212. }
  213. }
  214. }
  215. private int OthPlcCheck_Single(out string error)
  216. {
  217. error = "";
  218. DataTable dt = (DataTable)dgvOthCheck.DataSource;
  219. int i = dgvOthCheck.CurrentRow.Index;
  220. Global.inf.areaCode = dt.Rows[i]["insuplc_admdvs"].ToString();
  221. int billType = int.Parse(dt.Rows[i]["BillType"].ToString());
  222. dynamic joCheck = new JObject();
  223. joCheck.psn_no = dt.Rows[i]["PersonnelNO"].ToString();
  224. joCheck.medfee_sumamt = billType * Convert.ToDecimal(dt.Rows[i]["Sumamt"].ToString());
  225. joCheck.optins_pay_sumamt = billType * (Convert.ToDecimal(dt.Rows[i]["FundPaySumamt"].ToString()) + Convert.ToDecimal(dt.Rows[i]["AccountPaySumamt"].ToString()));
  226. joCheck.mdtrt_setl_time = Convert.ToDateTime(dt.Rows[i]["SettlementTime"].ToString()).ToString("yyyyMMddHHmmss");
  227. joCheck.trns_type = dt.Rows[i]["BillType"].ToString();
  228. joCheck.mdtrt_id = dt.Rows[i]["MdtrtID"].ToString();
  229. joCheck.setl_id = dt.Rows[i]["SettlementID"].ToString();
  230. JArray jaCheck = new JArray();
  231. jaCheck.Add(joCheck);
  232. JObject joData = new JObject();
  233. joData.Add("data", jaCheck);
  234. //上传给中心
  235. //先签到
  236. CenterBusiness cBus = new CenterBusiness();
  237. JObject jo9001Rtn = new JObject();
  238. cBus.signIn(out jo9001Rtn);
  239. InvokeHelper invoker = new InvokeHelper();
  240. JObject joRtn = invoker.invokeCenterService("S3501", joData.ToString());
  241. if (JsonHelper.parseCenterReturnJson(joRtn, out error) != 0)
  242. {
  243. return -1;
  244. }
  245. else
  246. {
  247. if (JsonHelper.getDestValue(joRtn, "output.result[0].succ_flag") != "0")
  248. {
  249. error = JsonHelper.getDestValue(joRtn, "output.result[0].prmmsg");
  250. return -1;
  251. }
  252. else
  253. return 0;
  254. }
  255. }
  256. private int Clearing_Single(out string error)
  257. {
  258. error = "";
  259. DataTable dt = (DataTable)dgvClearingSum.DataSource;
  260. int i = dgvClearingSum.CurrentRow.Index;
  261. dynamic joClearing = new JObject();
  262. joClearing.clr_type = dt.Rows[i]["clr_type"].ToString();
  263. joClearing.clr_way = dt.Rows[i]["clr_way"].ToString();
  264. joClearing.setlym = dpST_2.Value.ToString("yyyyMM");
  265. joClearing.med_sumfee = dt.Rows[i]["med_sumfee"].ToString();
  266. joClearing.medfee_sumamt = dt.Rows[i]["medfee_sumamt"].ToString();
  267. joClearing.fund_appy_sum = dt.Rows[i]["fund_appy_sum"].ToString();
  268. joClearing.acct_pay = dt.Rows[i]["acct_pay"].ToString();
  269. joClearing.cash_payamt = dt.Rows[i]["cash_payamt"].ToString();
  270. joClearing.psntime = dt.Rows[i]["psntime"].ToString();
  271. joClearing.begndate = dpST_2.Value.ToString("yyyy-MM-dd");
  272. joClearing.enddate = dpED_2.Value.ToString("yyyy-MM-dd");
  273. JObject joData = new JObject();
  274. joData.Add("data", joClearing);
  275. //上传给中心
  276. //先签到
  277. CenterBusiness cBus = new CenterBusiness();
  278. JObject jo9001Rtn = new JObject();
  279. cBus.signIn(out jo9001Rtn);
  280. InvokeHelper invoker = new InvokeHelper();
  281. JObject joRtn = invoker.invokeCenterService("3203", joData.ToString());
  282. if (JsonHelper.parseCenterReturnJson(joRtn, out error) != 0)
  283. {
  284. return -1;
  285. }
  286. else
  287. {
  288. //保存到医保平台
  289. JObject joTmp = new JObject();
  290. joTmp.Add("HospitalDr", Global.inf.hospitalDr);
  291. joTmp.Add("InterfaceDr", Global.inf.interfaceDr);
  292. joTmp.Add("ApplyID", JsonHelper.getDestValue(joRtn, "output.result.clr_appy_evt_id"));
  293. joTmp.Add("OccurTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
  294. joTmp.Add("ClrWay", dt.Rows[i]["clr_way"].ToString());
  295. joTmp.Add("ClrType", dt.Rows[i]["clr_type"].ToString());
  296. joTmp.Add("ClearYearMonth", dpST_2.Value.ToString("yyyyMM"));
  297. joTmp.Add("PersonTime", dt.Rows[i]["psntime"].ToString());
  298. joTmp.Add("Sumamt", dt.Rows[i]["med_sumfee"].ToString());
  299. joTmp.Add("MedAcceptSumamt", dt.Rows[i]["med_sumfee"].ToString());
  300. joTmp.Add("FundPay", dt.Rows[i]["fund_appy_sum"].ToString());
  301. joTmp.Add("CashPay", dt.Rows[i]["cash_payamt"].ToString());
  302. joTmp.Add("AccountPay", dt.Rows[i]["acct_pay"].ToString());
  303. joTmp.Add("Begndate", dpST_2.Value.ToString("yyyy-MM-dd 00:00:00"));
  304. joTmp.Add("Enddate", dpED_2.Value.ToString("yyyy-MM-dd 23:59:59"));
  305. joTmp.Add("OthPlcFlag", 0);
  306. joTmp.Add("ValidFlag", 1);
  307. joTmp.Add("Operator", "0");
  308. JArray jaParam = new JArray();
  309. jaParam.Add(joTmp);
  310. JObject joUpdate = new JObject();
  311. joUpdate.Add("params", jaParam);
  312. joUpdate.Add("updateUserID", "0");
  313. joUpdate.Add("HospitalDr", Global.inf.hospitalDr);
  314. joUpdate.Add("InterfaceDr", Global.inf.interfaceDr);
  315. joUpdate.Add("code", "09010067");
  316. invoker = new InvokeHelper();
  317. joRtn = invoker.invokeInsuService(joUpdate.ToString(), "插入清算记录");
  318. if (JsonHelper.parseIrisRtnValue(joRtn, out error) != 0)
  319. {
  320. return -1;
  321. }
  322. else
  323. return 0;
  324. }
  325. }
  326. private int OthPlcClearing_Single(out string error)
  327. {
  328. if (tbInsuPlc.Text != "")
  329. Global.inf.areaCode = tbInsuPlc.Text;
  330. error = "";
  331. DataTable dt = (DataTable)dgvClearingSum.DataSource;
  332. int i = dgvClearingSum.CurrentRow.Index;
  333. dynamic joClearing = new JObject();
  334. joClearing.clr_type = dt.Rows[i]["clr_type"].ToString();
  335. joClearing.mon_setl_cnt = dt.Rows[i]["psntime"].ToString();
  336. joClearing.optins_pay_sumamt = Convert.ToDecimal(dt.Rows[i]["fund_appy_sum"].ToString()) + Convert.ToDecimal(dt.Rows[i]["acct_pay"].ToString());
  337. joClearing.medfee_sumamt = dt.Rows[i]["medfee_sumamt"].ToString();
  338. joClearing.begndate = dpST_2.Value.ToString("yyyy-MM-dd");
  339. joClearing.enddate = dpED_2.Value.ToString("yyyy-MM-dd");
  340. JObject joData = new JObject();
  341. joData.Add("data", joClearing);
  342. //上传给中心
  343. //先签到
  344. CenterBusiness cBus = new CenterBusiness();
  345. JObject jo9001Rtn = new JObject();
  346. cBus.signIn(out jo9001Rtn);
  347. InvokeHelper invoker = new InvokeHelper();
  348. JObject joRtn = invoker.invokeCenterService("S3203", joData.ToString());
  349. if (JsonHelper.parseCenterReturnJson(joRtn, out error) != 0)
  350. {
  351. return -1;
  352. }
  353. else
  354. {
  355. //保存到医保平台
  356. JObject joTmp = new JObject();
  357. joTmp.Add("HospitalDr", Global.inf.hospitalDr);
  358. joTmp.Add("InterfaceDr", Global.inf.interfaceDr);
  359. joTmp.Add("ApplyID", JsonHelper.getDestValue(joRtn, "output.result.mon_setl_eid"));
  360. joTmp.Add("OccurTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
  361. joTmp.Add("ClrWay", dt.Rows[i]["clr_way"].ToString());
  362. joTmp.Add("ClrType", dt.Rows[i]["clr_type"].ToString());
  363. joTmp.Add("ClearYearMonth", JsonHelper.getDestValue(joRtn, "output.result.data_ym"));
  364. joTmp.Add("PersonTime", dt.Rows[i]["psntime"].ToString());
  365. joTmp.Add("Sumamt", dt.Rows[i]["med_sumfee"].ToString());
  366. joTmp.Add("MedAcceptSumamt", dt.Rows[i]["med_sumfee"].ToString());
  367. joTmp.Add("FundPay", dt.Rows[i]["fund_appy_sum"].ToString());
  368. joTmp.Add("CashPay", dt.Rows[i]["cash_payamt"].ToString());
  369. joTmp.Add("AccountPay", dt.Rows[i]["acct_pay"].ToString());
  370. joTmp.Add("Begndate", dpST_2.Value.ToString("yyyy-MM-dd 00:00:00"));
  371. joTmp.Add("Enddate", dpED_2.Value.ToString("yyyy-MM-dd 23:59:59"));
  372. joTmp.Add("OthPlcFlag", 1);
  373. joTmp.Add("ValidFlag", 1);
  374. joTmp.Add("Operator", "0");
  375. JArray jaParam = new JArray();
  376. jaParam.Add(joTmp);
  377. JObject joUpdate = new JObject();
  378. joUpdate.Add("params", jaParam);
  379. joUpdate.Add("updateUserID", "0");
  380. joUpdate.Add("HospitalDr", Global.inf.hospitalDr);
  381. joUpdate.Add("InterfaceDr", Global.inf.interfaceDr);
  382. joUpdate.Add("code", "09010067");
  383. invoker = new InvokeHelper();
  384. joRtn = invoker.invokeInsuService(joUpdate.ToString(), "插入清算记录");
  385. if (JsonHelper.parseIrisRtnValue(joRtn, out error) != 0)
  386. {
  387. return -1;
  388. }
  389. else
  390. return 0;
  391. }
  392. }
  393. private int CancleClearing_Single(out string error)
  394. {
  395. error = "";
  396. DataTable dt = (DataTable)dgvClearingData.DataSource;
  397. int i = dgvClearingData.CurrentRow.Index;
  398. dynamic joCancleClearing = new JObject();
  399. joCancleClearing.clr_appy_evt_id = dt.Rows[i]["ApplyID"].ToString();
  400. JObject joData = new JObject();
  401. joData.Add("data", joCancleClearing);
  402. //上传给中心
  403. //先签到
  404. CenterBusiness cBus = new CenterBusiness();
  405. JObject jo9001Rtn = new JObject();
  406. cBus.signIn(out jo9001Rtn);
  407. InvokeHelper invoker = new InvokeHelper();
  408. JObject joRtn = invoker.invokeCenterService("3204", joData.ToString());
  409. if (JsonHelper.parseCenterReturnJson(joRtn, out error) != 0)
  410. {
  411. return -1;
  412. }
  413. else
  414. {
  415. //保存到医保平台
  416. JObject joTmp = new JObject();
  417. joTmp.Add("HospitalDr", Global.inf.hospitalDr);
  418. joTmp.Add("InterfaceDr", Global.inf.interfaceDr);
  419. joTmp.Add("ApplyID", dt.Rows[i]["ApplyID"].ToString());
  420. //joTmp.Add("CancleOccurTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
  421. //joTmp.Add("ClrWay", dt.Rows[i]["clr_way"].ToString());
  422. joTmp.Add("ClrType", dt.Rows[i]["ClrType"].ToString());
  423. //joTmp.Add("ClearYearMonth", dpST_2.Value.ToString("yyyyMM"));
  424. //joTmp.Add("PersonTime", dt.Rows[i]["psntime"].ToString());
  425. //joTmp.Add("Sumamt", dt.Rows[i]["med_sumfee"].ToString());
  426. //joTmp.Add("MedAcceptSumamt", dt.Rows[i]["med_sumfee"].ToString());
  427. //joTmp.Add("FundPay", dt.Rows[i]["fund_appy_sum"].ToString());
  428. //joTmp.Add("CashPay", dt.Rows[i]["cash_payamt"].ToString());
  429. //joTmp.Add("AccountPay", dt.Rows[i]["acct_pay"].ToString());
  430. //joTmp.Add("Begndate", dpST_2.Value.ToString("yyyy-MM-dd 00:00:00"));
  431. //joTmp.Add("Enddate", dpED_2.Value.ToString("yyyy-MM-dd 23:59:59"));
  432. joTmp.Add("ValidFlag", -1);
  433. joTmp.Add("updateUserID", "0");
  434. //joTmp.Add("Operator", "0");
  435. JArray jaParam = new JArray();
  436. jaParam.Add(joTmp);
  437. JObject joUpdate = new JObject();
  438. joUpdate.Add("params", jaParam);
  439. joUpdate.Add("updateUserID", "0");
  440. joUpdate.Add("HospitalDr", Global.inf.hospitalDr);
  441. joUpdate.Add("InterfaceDr", Global.inf.interfaceDr);
  442. joUpdate.Add("code", "09010067");
  443. invoker = new InvokeHelper();
  444. joRtn = invoker.invokeInsuService(joUpdate.ToString(), "更新清算记录");
  445. if (JsonHelper.parseIrisRtnValue(joRtn, out error) != 0)
  446. {
  447. return -1;
  448. }
  449. else
  450. return 0;
  451. }
  452. }
  453. private int CancleOthPlcClearing_Single(out string error)
  454. {
  455. error = "";
  456. DataTable dt = (DataTable)dgvClearingData.DataSource;
  457. int i = dgvClearingData.CurrentRow.Index;
  458. dynamic joCancleClearing = new JObject();
  459. joCancleClearing.clr_appy_evt_id = dt.Rows[i]["ApplyID"].ToString();
  460. joCancleClearing.data_ym = dt.Rows[i]["ClearYearMonth"].ToString();
  461. JObject joData = new JObject();
  462. joData.Add("data", joCancleClearing);
  463. //上传给中心
  464. //先签到
  465. CenterBusiness cBus = new CenterBusiness();
  466. JObject jo9001Rtn = new JObject();
  467. cBus.signIn(out jo9001Rtn);
  468. InvokeHelper invoker = new InvokeHelper();
  469. JObject joRtn = invoker.invokeCenterService("S3204", joData.ToString());
  470. if (JsonHelper.parseCenterReturnJson(joRtn, out error) != 0)
  471. {
  472. return -1;
  473. }
  474. else
  475. {
  476. //保存到医保平台
  477. JObject joTmp = new JObject();
  478. joTmp.Add("HospitalDr", Global.inf.hospitalDr);
  479. joTmp.Add("InterfaceDr", Global.inf.interfaceDr);
  480. joTmp.Add("ApplyID", dt.Rows[i]["ApplyID"].ToString());
  481. //joTmp.Add("CancleOccurTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
  482. //joTmp.Add("ClrWay", dt.Rows[i]["clr_way"].ToString());
  483. joTmp.Add("ClrType", dt.Rows[i]["ClrType"].ToString());
  484. //joTmp.Add("ClearYearMonth", dpST_2.Value.ToString("yyyyMM"));
  485. //joTmp.Add("PersonTime", dt.Rows[i]["psntime"].ToString());
  486. //joTmp.Add("Sumamt", dt.Rows[i]["med_sumfee"].ToString());
  487. //joTmp.Add("MedAcceptSumamt", dt.Rows[i]["med_sumfee"].ToString());
  488. //joTmp.Add("FundPay", dt.Rows[i]["fund_appy_sum"].ToString());
  489. //joTmp.Add("CashPay", dt.Rows[i]["cash_payamt"].ToString());
  490. //joTmp.Add("AccountPay", dt.Rows[i]["acct_pay"].ToString());
  491. //joTmp.Add("Begndate", dpST_2.Value.ToString("yyyy-MM-dd 00:00:00"));
  492. //joTmp.Add("Enddate", dpED_2.Value.ToString("yyyy-MM-dd 23:59:59"));
  493. joTmp.Add("ValidFlag", -1);
  494. joTmp.Add("updateUserID", "0");
  495. //joTmp.Add("Operator", "0");
  496. JArray jaParam = new JArray();
  497. jaParam.Add(joTmp);
  498. JObject joUpdate = new JObject();
  499. joUpdate.Add("params", jaParam);
  500. joUpdate.Add("updateUserID", "0");
  501. joUpdate.Add("HospitalDr", Global.inf.hospitalDr);
  502. joUpdate.Add("InterfaceDr", Global.inf.interfaceDr);
  503. joUpdate.Add("code", "09010067");
  504. invoker = new InvokeHelper();
  505. joRtn = invoker.invokeInsuService(joUpdate.ToString(), "更新清算记录");
  506. if (JsonHelper.parseIrisRtnValue(joRtn, out error) != 0)
  507. {
  508. return -1;
  509. }
  510. else
  511. return 0;
  512. }
  513. }
  514. private int queryHisSettlementInfo(out string error)
  515. {
  516. GridViewSetter grdSetter = new GridViewSetter();
  517. grdSetter.SetHeaderTextOfHisSettlRec(dgvHisSettlRec);
  518. error = "";
  519. try
  520. {
  521. DataTable dtInteface = (DataTable)cbxInterface.DataSource;
  522. int i = cbxInterface.SelectedIndex;
  523. string sqlStr = "SELECT SUM(BillType*Sumamt) AS medfee_sumamt,count(*) AS fixmedins_setl_cnt, ";
  524. sqlStr = sqlStr + " SUM(BillType*AccountPaySumamt) AS acct_pay,SUM(BillType*HealthInsurancePay) AS fund_pay_sumamt ";
  525. //sqlStr = sqlStr + " Interface_dr,clearingWay AS clr_way,clearingType AS clr_type ";
  526. string conditionStr = " ";
  527. DataTable dtSettlSummary = (DataTable)dgvSettlSummary.DataSource;
  528. int iCurRow = dgvSettlSummary.CurrentRow.Index;
  529. //DataTable dtInteface = (DataTable)cbxInterface.DataSource;
  530. if (cbgGroupSet.GetItemCheckState(0))
  531. {
  532. conditionStr = conditionStr + " and Interface_Dr ='" + dtSettlSummary.Rows[iCurRow]["Interface_dr"].ToString() + "'";
  533. }
  534. if (cbgGroupSet.GetItemCheckState(1))
  535. {
  536. conditionStr = conditionStr + " and InsuranceType ='" + dtSettlSummary.Rows[iCurRow]["insutype"].ToString() + "'";
  537. }
  538. if (cbgGroupSet.GetItemCheckState(2))
  539. {
  540. conditionStr = conditionStr + " and ClearingType ='" + dtSettlSummary.Rows[iCurRow]["clr_type"].ToString() + "'";
  541. }
  542. if (cbgGroupSet.GetItemCheckState(3))
  543. {
  544. conditionStr = conditionStr + " and ClearingOrgan ='" + dtSettlSummary.Rows[iCurRow]["setl_optins"].ToString() + "'";
  545. }
  546. if (cbgGroupSet.GetItemCheckState(4))
  547. {
  548. sqlStr = sqlStr + ",BillType";
  549. conditionStr = conditionStr + " and BillType ='" + dtSettlSummary.Rows[iCurRow]["BillType"].ToString() + "'";
  550. }
  551. sqlStr = "select * FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + dtInteface.Rows[i]["HospitalDr"].ToString();
  552. sqlStr = sqlStr + " and OccurTime>'" + dpST.Text + "'";
  553. sqlStr = sqlStr + " and OccurTime<'" + dpED.Text + "'";
  554. //ValidFlag=1 and BillType=1 表示正常结算记录 ValidFlag=0 and BillType=-1 表示退费记录 ValidFlag=0表示无效记录
  555. if (cbxValid.SelectedIndex != 0)
  556. {
  557. if (cbxValid.SelectedIndex == 1)
  558. sqlStr = sqlStr + " and ValidFlag =1 and BillType=1";
  559. else
  560. sqlStr = sqlStr + " and ValidFlag =0 and BillType=-1";
  561. }
  562. //省医保和市医保对账一样,异地对账需要用到另外的对账交易
  563. if (Global.inf.interfaceDr == 1)
  564. {
  565. sqlStr = sqlStr + " and (InsuranceAreaCode='539900' or InsuranceAreaCode='530100')";
  566. }
  567. //conditionStr = conditionStr.Substring(0,conditionStr.Length -1 );
  568. //conditionStr = conditionStr.Remove(conditionStr.Length - 1, 1);
  569. sqlStr = sqlStr + conditionStr;
  570. JObject joSqlstr = new JObject();
  571. joSqlstr.Add("sqlStr", sqlStr);
  572. JArray jaParam = new JArray();
  573. jaParam.Add(joSqlstr);
  574. JObject joSettlQuery = new JObject();
  575. joSettlQuery.Add("params", jaParam);
  576. joSettlQuery.Add("code", "09010059");
  577. InvokeHelper invoker = new InvokeHelper();
  578. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");
  579. //DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  580. JArray ja = JArray.Parse(JsonHelper.getDestValue(joRtn, "result.data"));
  581. DataTable dt = (DataTable)JsonConvert.DeserializeObject(JsonHelper.getDestValue(joRtn, "result.data"), (typeof(DataTable)));
  582. dgvHisSettlRec.DataSource = dt;
  583. //dt.Columns[7].DataType = typeof(float);//不允许
  584. //dgvHisSettlRecFooter.DataGridView = dgvHisSettlRec;
  585. //dgvHisSettlRecFooter.Dock = System.Windows.Forms.DockStyle.Bottom;
  586. //dgvHisSettlRecFooter.Clear();
  587. //dgvHisSettlRecFooter["AdmID"] = "合计";
  588. //dgvHisSettlRecFooter["OverLimitAmount"] = "测试";
  589. return 0;
  590. }
  591. catch (Exception ex)
  592. {
  593. error = "queryHisSettlementInfo:" + ex.Message;
  594. return -1;
  595. }
  596. }
  597. private void tsmCheckDetail_Single_Click(object sender, EventArgs e)
  598. {
  599. //HIS明细
  600. string error;
  601. if (queryHisSettlementInfo(out error) != 0)
  602. {
  603. MessageBox.Show(error);
  604. }
  605. //中心明细
  606. if (CheckDetail_Single(out error) != 0)
  607. {
  608. MessageBox.Show(error);
  609. }
  610. }
  611. /// <summary>
  612. /// 查询HIS结算明细记录
  613. /// </summary>
  614. /// <param name="sender"></param>
  615. /// <param name="e"></param>
  616. private void tsmHisRecord_Click(object sender, EventArgs e)
  617. {
  618. string error;
  619. if (queryHisSettlementInfo(out error) != 0)
  620. {
  621. MessageBox.Show(error);
  622. }
  623. }
  624. public static void writeToTxt(string content, string filePath, string fileName)
  625. {
  626. //创建文件夹,文件夹名称与TXT同名
  627. string finalPath = filePath + "\\" + fileName;
  628. if (!Directory.Exists(finalPath))
  629. {
  630. DirectoryInfo dirInfo = Directory.CreateDirectory(finalPath);
  631. }
  632. //判断文件夹中是否存在txt
  633. string finalFileName = finalPath + "\\" + fileName + ".txt";
  634. if (!File.Exists(finalFileName))
  635. {
  636. FileStream fs1 = File.Create(finalFileName);
  637. fs1.Close();
  638. }
  639. FileStream fs = new FileStream(finalFileName, FileMode.Append, FileAccess.Write);
  640. StreamWriter sw = new StreamWriter(fs);
  641. sw.WriteLine(content);
  642. sw.Close();
  643. fs.Close();
  644. }
  645. /// <summary>
  646. /// 读文件到byte[]
  647. /// </summary>
  648. /// <param name="fileName">硬盘文件路径</param>
  649. /// <returns></returns>
  650. public static byte[] ReadFileToByte(string fileName)
  651. {
  652. FileStream pFileStream = null;
  653. byte[] pReadByte = new byte[0];
  654. try
  655. {
  656. pFileStream = new FileStream(fileName, FileMode.Open, FileAccess.Read);
  657. BinaryReader r = new BinaryReader(pFileStream);
  658. r.BaseStream.Seek(0, SeekOrigin.Begin); //将文件指针设置到文件开
  659. pReadByte = r.ReadBytes((int)r.BaseStream.Length);
  660. return pReadByte;
  661. }
  662. catch
  663. {
  664. return pReadByte;
  665. }
  666. finally
  667. {
  668. if (pFileStream != null)
  669. pFileStream.Close();
  670. }
  671. }
  672. /// <summary>
  673. ///单字节转有符号整数
  674. /// </summary>
  675. /// <param name="data"></param>
  676. /// <returns></returns>
  677. public string byteArrayToDecString(byte[] data)
  678. {
  679. StringBuilder builder = new StringBuilder();
  680. for (int i = 0; i < data.Length; i++)
  681. {
  682. builder.Append((sbyte)data[i] + ",");
  683. }
  684. return builder.ToString().Trim();
  685. }
  686. private int HISDetailDataExport(string filePath, string fileName)
  687. {
  688. try
  689. {
  690. DataTable dt = (DataTable)dgvHisSettlRec.DataSource;
  691. string content = "";
  692. for (int i = 0; i < dt.Rows.Count; i++)
  693. {
  694. string flag = "";
  695. if (dt.Rows[i]["ValidFlag"].ToString() == "-1")
  696. {
  697. flag = "1";
  698. }
  699. else
  700. {
  701. flag = "0";
  702. }
  703. content = "\r\n"
  704. + dt.Rows[i]["SettlementID"].ToString() + "\t"
  705. + dt.Rows[i]["MdtrtID"].ToString() + "\t"
  706. + dt.Rows[i]["PersonnelNO"].ToString() + "\t"
  707. + dt.Rows[i]["Sumamt"].ToString() + "\t"
  708. + dt.Rows[i]["FundPaySumamt"].ToString() + "\t"
  709. + dt.Rows[i]["AccountPaySumamt"].ToString() + "\t"
  710. + flag
  711. + content;
  712. }
  713. string finalContent = content.Remove(0, 2);
  714. writeToTxt(finalContent, filePath, fileName);
  715. return 0;
  716. }
  717. catch (Exception ex)
  718. {
  719. MessageBox.Show(ex.Message);
  720. return -1;
  721. }
  722. }
  723. private void tsmExport_Click(object sender, EventArgs e)
  724. {
  725. txtName = DateTime.Now.ToString("yyyyMMddHHmmssffff");
  726. txtPath = Global.currentDirectory + "\\Download";
  727. if (HISDetailDataExport(txtPath, txtName) != 0)
  728. {
  729. MessageBox.Show("导出TXT失败!");
  730. }
  731. else
  732. {
  733. MessageBox.Show("导出TXT成功!");
  734. }
  735. //System.IO.Compression.ZipFile.CreateFromDirectory(txtPath + "\\" + "2022ceshi", txtPath + "\\" + "111.zip");
  736. }
  737. private void tsmCompress_Click(object sender, EventArgs e)
  738. {
  739. string path = @"C:\ProgramData\prykNT\prBrowser\bin\service\plugins\INSUNew\DownLoad\111";
  740. string name = @"1121.zip";
  741. string finalDirPath = txtPath + "\\" + txtName;
  742. finalAchPath = finalDirPath + ".zip";
  743. System.IO.Compression.ZipFile.CreateFromDirectory(finalDirPath, finalAchPath);
  744. //System.IO.Compression.ZipFile.CreateFromDirectory(path, name);
  745. //System.IO.Compression.ZipFile.CreateFromDirectory(path, name, 0, true);
  746. MessageBox.Show("将TXT压缩为ZIP成功!");
  747. }
  748. private void tsmZIPToSDec_Click(object sender, EventArgs e)
  749. {
  750. byte[] bArray = ReadFileToByte(finalAchPath);
  751. string str = byteArrayToDecString(bArray);
  752. Global.writeLog(str);
  753. MessageBox.Show("ZIP转为有符号整数成功!");
  754. }
  755. private void tsmUploadZIP_Click(object sender, EventArgs e)
  756. {
  757. string outParam = "";
  758. byte[] bArray = ReadFileToByte(finalAchPath);
  759. string str = "[" + byteArrayToDecString(bArray) + "]";
  760. JObject joTmp = new JObject();
  761. joTmp.Add("in", JArray.Parse(str));
  762. joTmp.Add("filename", txtName + ".zip");
  763. Global.inf.fileName = txtName + ".zip";
  764. //joTmp.Add("filename", finalAchPath.Replace("\\",@"\"));
  765. joTmp.Add("fixmedins_code", Global.inf.hospitalNO);
  766. JObject joFsUploadIn = new JObject();
  767. joFsUploadIn.Add("fsUploadIn", joTmp);
  768. InvokeHelper invoker = new InvokeHelper();
  769. JObject jo9101Rtn= invoker.invokeCenterService("9101", JsonHelper.setCenterInpar("9101", joFsUploadIn.ToString()));
  770. if (JsonHelper.parseCenterRtnValue(jo9101Rtn, out outParam) != 0)
  771. {
  772. outParam = JsonHelper.setExceptionJson(-1, "【9101】文件上传失败", outParam).ToString();
  773. return;
  774. }
  775. else
  776. {
  777. MessageBox.Show("【9101】文件上传成功");
  778. }
  779. }
  780. private void tsm3202_Click(object sender, EventArgs e)
  781. {
  782. /*
  783. string outParam = "";
  784. DataTable dt = (DataTable)dgvSettlSummary.DataSource;
  785. int i = dgvSettlSummary.CurrentRow.Index;
  786. MessageBox.Show(dt.Rows[i]["clr_type"].ToString());
  787. dynamic joCheck = new JObject();
  788. joCheck.file_qury_no = JObject.Parse(tbTmp.Text);
  789. joCheck.clr_type = dt.Rows[i]["clr_type"].ToString();
  790. joCheck.setl_optins = dt.Rows[i]["setl_optins"].ToString();
  791. joCheck.stmt_begndate = dpST.Value.ToString("yyyy-MM-dd HH:mm:ss");
  792. joCheck.stmt_enddate = dpED.Value.ToString("yyyy-MM-dd HH:mm:ss");
  793. joCheck.medfee_sumamt = dt.Rows[i]["medfee_sumamt"].ToString();
  794. joCheck.fund_pay_sumamt = dt.Rows[i]["fund_pay_sumamt"].ToString();
  795. joCheck.cash_payamt = dt.Rows[i]["cash_payamt"].ToString();
  796. joCheck.fixmedins_setl_cnt = dt.Rows[i]["fixmedins_setl_cnt"].ToString();
  797. JObject joData = new JObject();
  798. joData.Add("data", joCheck);
  799. InvokeHelper invoker = new InvokeHelper();
  800. JObject jo3202Rtn= invoker.invokeCenterService("3202", JsonHelper.setCenterInpar("3202", joData.ToString()));
  801. if (JsonHelper.parseCenterRtnValue(jo3202Rtn, out outParam) != 0)
  802. {
  803. outParam = JsonHelper.setExceptionJson(-1, "【3202】医保明细对账失败", outParam).ToString();
  804. MessageBox.Show(outParam);
  805. return;
  806. }
  807. else
  808. {
  809. MessageBox.Show("【3202】医保明细对账成功");
  810. }
  811. */
  812. DataTable dt = (DataTable)dgvSettlSummary.DataSource;
  813. int i = dgvSettlSummary.CurrentRow.Index;
  814. dynamic joCheck = new JObject();
  815. joCheck.file_qury_no = tbTmp.Text;
  816. joCheck.clr_type = dt.Rows[i]["clr_type"].ToString();
  817. joCheck.setl_optins = dt.Rows[i]["setl_optins"].ToString();
  818. joCheck.stmt_begndate = dpST.Value.ToString("yyyy-MM-dd HH:mm:ss");
  819. joCheck.stmt_enddate = dpED.Value.ToString("yyyy-MM-dd HH:mm:ss");
  820. joCheck.medfee_sumamt = dt.Rows[i]["medfee_sumamt"].ToString();
  821. joCheck.fund_pay_sumamt = dt.Rows[i]["fund_pay_sumamt"].ToString();
  822. joCheck.cash_payamt = dt.Rows[i]["cash_payamt"].ToString();
  823. joCheck.fixmedins_setl_cnt = dt.Rows[i]["fixmedins_setl_cnt"].ToString();
  824. JObject joData = new JObject();
  825. joData.Add("data", joCheck);
  826. InvokeHelper invoker = new InvokeHelper();
  827. invoker.invokeCenterService("3202", JsonHelper.setCenterInpar("3202", joData.ToString()));
  828. }
  829. private void tsmDownload_Click(object sender, EventArgs e)
  830. {
  831. string outParam = "";
  832. JObject joTmp = new JObject();
  833. joTmp.Add("file_qury_no", JObject.Parse(tbTmp.Text.Replace(@"\\", @"\")));
  834. joTmp.Add("filename", txtName + ".zip");
  835. joTmp.Add("fixmedins_code", Global.inf.hospitalNO);
  836. JObject joFsDownloadIn = new JObject();
  837. joFsDownloadIn.Add("fsDownloadIn", joTmp);
  838. InvokeHelper invoker = new InvokeHelper();
  839. jo9102Rtn = invoker.invokeCenterService("9102", JsonHelper.setCenterInpar("9102", joFsDownloadIn).ToString());
  840. if (JsonHelper.parseCenterRtnValue(jo9102Rtn, out outParam) != 0)
  841. {
  842. outParam = JsonHelper.setExceptionJson(-1, "【9102】文件下载失败", outParam).ToString();
  843. MessageBox.Show(outParam);
  844. return;
  845. }
  846. else
  847. {
  848. MessageBox.Show("【9102】文件下载成功");
  849. }
  850. }
  851. private void tsmUnCompress_Click(object sender, EventArgs e)
  852. {
  853. //解压缩
  854. string zipFilePath = jo9102Rtn["filePath"].ToString();
  855. string txtFileDir = System.Environment.CurrentDirectory + "\\Download";
  856. //string txtFilePath = txtFileDir + "\\" + filename.Substring(0, filename.Length - 4);
  857. string txtFilePath = txtFileDir;
  858. if (File.Exists(txtFilePath))
  859. {
  860. File.Delete(txtFilePath);
  861. }
  862. ZipFile.ExtractToDirectory(zipFilePath, txtFileDir);
  863. }
  864. private void tsmImport_Click(object sender, EventArgs e)
  865. {
  866. GridViewSetter grd = new GridViewSetter();
  867. grd.SetHeaderTextOfDgvCenterSetlRec(dgvCenterSettlRec);
  868. string txtFileDir = tbTmp.Text;//E:\GHSF\SCYBDownLoad\result.txt
  869. string[] lines = System.IO.File.ReadAllLines(txtFileDir);
  870. Global.writeLog(lines.ToString());
  871. DataTable dt = new DataTable();
  872. dt.Columns.Add("sn", typeof(int));
  873. dt.Columns.Add("psn_no", typeof(string));
  874. dt.Columns.Add("mdtrt_id", typeof(string));
  875. dt.Columns.Add("setl_id", typeof(string));
  876. dt.Columns.Add("msgid", typeof(string));
  877. dt.Columns.Add("stmt_rslt", typeof(string));
  878. dt.Columns.Add("refd_setl_flag", typeof(string));
  879. dt.Columns.Add("memo", typeof(string));
  880. dt.Columns.Add("medfee_sumamt", typeof(string));
  881. dt.Columns.Add("fund_pay_sumamt", typeof(string));
  882. dt.Columns.Add("acct_pay", typeof(string));
  883. //foreach (string line in lines)
  884. for (int i = 0; i < lines.Length; i++)
  885. {
  886. string[] strs = (lines[i] + "\t").Split('\t');
  887. DataRow dr = dt.NewRow();
  888. //Global.inf.writeLog(lines[i].ToString());
  889. //Global.inf.writeLog(strs.Length.ToString());
  890. dr["sn"] = i;
  891. dr["psn_no"] = strs[0];
  892. dr["mdtrt_id"] = strs[1];
  893. dr["setl_id"] = strs[2];
  894. dr["msgid"] = strs[3];
  895. dr["stmt_rslt"] = strs[4];
  896. dr["refd_setl_flag"] = strs[5];
  897. dr["memo"] = strs[6];
  898. dr["medfee_sumamt"] = strs[7];
  899. dr["fund_pay_sumamt"] = strs[8];
  900. dr["acct_pay"] = strs[9];
  901. //dr["Field2"] = strs[2];
  902. dt.Rows.Add(dr);
  903. }
  904. dgvCenterSettlRec.DataSource = dt;
  905. }
  906. private int exportAndCompress(out string zipPath)
  907. {
  908. zipPath = "";
  909. try
  910. {
  911. //导出TXT
  912. string fileName = DateTime.Now.ToString("yyyyMMddHHmmssffff");
  913. string filePath = Global.currentDirectory + "\\Download";
  914. HISDetailDataExport(filePath, fileName);
  915. //压缩
  916. string finalDirPath = filePath + "\\" + fileName;//同名文件夹
  917. zipPath = finalDirPath + ".zip";
  918. System.IO.Compression.ZipFile.CreateFromDirectory(finalDirPath, zipPath);
  919. return 0;
  920. }
  921. catch (Exception ex)
  922. {
  923. zipPath = "exportAndCompress:" + ex.Message;
  924. return -1;
  925. }
  926. }
  927. /// <summary>
  928. /// 上传ZIP文件转字节流再转换为有符号10进制数组后上传
  929. /// </summary>
  930. /// <param name="zipPath"></param>
  931. /// <param name="file_qury_no"></param>
  932. /// <returns></returns>
  933. private int uploadFileToCenter(string zipPath, out string file_qury_no)
  934. {
  935. string outParam = "";
  936. try
  937. {
  938. byte[] bArray = ReadFileToByte(zipPath);
  939. string str = "[" + byteArrayToDecString(bArray) + "]";
  940. JObject joTmp = new JObject();
  941. joTmp.Add("in", JArray.Parse(str));
  942. joTmp.Add("filename", txtName + ".zip");
  943. joTmp.Add("fixmedins_code", Global.inf.hospitalNO);
  944. JObject joFsUploadIn = new JObject();
  945. joFsUploadIn.Add("fsUploadIn", joTmp);
  946. InvokeHelper invoker = new InvokeHelper();
  947. JObject jo9101Rtn = invoker.invokeCenterService("9101", JsonHelper.setCenterInpar("9101", joFsUploadIn.ToString()));
  948. if (JsonHelper.parseCenterReturnJson(jo9101Rtn, out outParam) != 0)
  949. {
  950. file_qury_no = outParam;
  951. return -1;
  952. }
  953. else
  954. {
  955. file_qury_no = JsonHelper.getDestValue(jo9101Rtn, "output.file_qury_no");
  956. return 0;
  957. }
  958. }
  959. catch (Exception ex)
  960. {
  961. file_qury_no = "uploadFileToCenter:" + ex.Message;
  962. return -1;
  963. }
  964. }
  965. private int checkDetail(string file_qury_no, out string outParam, out string fileName)
  966. {
  967. fileName = "";
  968. try
  969. {
  970. DataTable dt = (DataTable)dgvSettlSummary.DataSource;
  971. int i = dgvSettlSummary.CurrentRow.Index;
  972. Global.inf.areaCode = "";
  973. string setlOptins;
  974. setlOptins = dt.Rows[i]["setl_optins"].ToString();
  975. if ((setlOptins == "") && (tbSettlOption.Text != ""))
  976. setlOptins = tbSettlOption.Text;
  977. dynamic joCheck = new JObject();
  978. joCheck.file_qury_no = file_qury_no.Replace(@"\\", @"\"); //file_qury_no.Replace(@"\\", @"\")
  979. joCheck.clr_type = dt.Rows[i]["clr_type"].ToString();
  980. joCheck.setl_optins = setlOptins;
  981. joCheck.stmt_begndate = dpST.Value.ToString("yyyy-MM-dd HH:mm:ss");
  982. joCheck.stmt_enddate = dpED.Value.ToString("yyyy-MM-dd HH:mm:ss");
  983. joCheck.medfee_sumamt = dt.Rows[i]["medfee_sumamt"].ToString();
  984. joCheck.fund_pay_sumamt = dt.Rows[i]["fund_pay_sumamt"].ToString();
  985. joCheck.cash_payamt = dt.Rows[i]["cash_payamt"].ToString();
  986. joCheck.fixmedins_setl_cnt = dt.Rows[i]["fixmedins_setl_cnt"].ToString();
  987. JObject joData = new JObject();
  988. joData.Add("data", joCheck);
  989. InvokeHelper invoker = new InvokeHelper();
  990. JObject jo3202Rtn = invoker.invokeCenterService("3202", JsonHelper.setCenterInpar("3202", joData.ToString()));
  991. if (JsonHelper.parseCenterReturnJson(jo3202Rtn, out outParam) != 0)
  992. {
  993. return -1;
  994. }
  995. else
  996. {
  997. outParam = JsonHelper.getDestValue(jo3202Rtn, "output.fileinfo.file_qury_no");
  998. fileName = JsonHelper.getDestValue(jo3202Rtn, "output.fileinfo.filename");
  999. return 0;
  1000. }
  1001. }
  1002. catch (Exception ex)
  1003. {
  1004. outParam = "checkDetail:" + ex.Message;
  1005. return -1;
  1006. }
  1007. }
  1008. private int downloadZIP(string file_qury_no, string fileName, out string outParam)
  1009. {
  1010. outParam = "";
  1011. try
  1012. {
  1013. JObject joTmp = new JObject();
  1014. joTmp = new JObject();
  1015. joTmp.Add("file_qury_no", file_qury_no); //file_qury_no.Replace(@"\\", @"\")
  1016. joTmp.Add("filename", fileName); //
  1017. joTmp.Add("fixmedins_code", Global.inf.hospitalNO);
  1018. JObject joFsDownloadIn = new JObject();
  1019. joFsDownloadIn.Add("fsDownloadIn", joTmp);
  1020. InvokeHelper invoker = new InvokeHelper();
  1021. JObject jo9102Rtn= invoker.DownloadCenterFileByAPI(JsonHelper.setCenterInpar("9102", joFsDownloadIn.ToString()));
  1022. string error = "";
  1023. if (JsonHelper.parseIrisRtnValue(jo9102Rtn, out error) != 0)
  1024. {
  1025. outParam = error;
  1026. return -1;
  1027. }
  1028. else
  1029. {
  1030. outParam = JsonHelper.getDestValue(jo9102Rtn, "filePath");
  1031. return 0;
  1032. }
  1033. }
  1034. catch (Exception ex)
  1035. {
  1036. outParam = "downloadZIP:" + ex.Message;
  1037. return -1;
  1038. }
  1039. }
  1040. private int importToDgvCenterSetlRec(string fileName, string zipFilePath, out string outParam)
  1041. {
  1042. outParam = "";
  1043. try
  1044. {
  1045. string dir = fileName.Substring(1, fileName.Length - 4);
  1046. //解压缩
  1047. string txtFileDir = System.Environment.CurrentDirectory + "\\Download\\" + dir;
  1048. string txtFilePath = zipFilePath.Substring(0, zipFilePath.Length - 4);
  1049. if (File.Exists(txtFilePath))
  1050. {
  1051. File.Delete(txtFilePath);
  1052. }
  1053. if (!Directory.Exists(txtFileDir))
  1054. {
  1055. Directory.CreateDirectory(txtFileDir);
  1056. }
  1057. ZipFile.ExtractToDirectory(zipFilePath, txtFileDir);
  1058. //导入文件
  1059. GridViewSetter grd = new GridViewSetter();
  1060. grd.SetHeaderTextOfDgvCenterSetlRec(dgvCenterSettlRec);
  1061. //txtFileDir = txtFileDir;//E:\GHSF\SCYBDownLoad\result.txt
  1062. string[] lines = System.IO.File.ReadAllLines(txtFileDir + "\\result.txt");
  1063. DataTable dt = new DataTable();
  1064. dt.Columns.Add("sn", typeof(int));
  1065. dt.Columns.Add("psn_no", typeof(string));
  1066. dt.Columns.Add("mdtrt_id", typeof(string));
  1067. dt.Columns.Add("setl_id", typeof(string));
  1068. dt.Columns.Add("msgid", typeof(string));
  1069. dt.Columns.Add("stmt_rslt", typeof(string));
  1070. dt.Columns.Add("refd_setl_flag", typeof(string));
  1071. dt.Columns.Add("memo", typeof(string));
  1072. dt.Columns.Add("medfee_sumamt", typeof(string));
  1073. dt.Columns.Add("fund_pay_sumamt", typeof(string));
  1074. dt.Columns.Add("acct_pay", typeof(string));
  1075. //foreach (string line in lines)
  1076. for (int i = 0; i < lines.Length; i++)
  1077. {
  1078. string[] strs = (lines[i] + "\t").Split('\t');
  1079. DataRow dr = dt.NewRow();
  1080. //Global.inf.writeLog(lines[i].ToString());
  1081. //Global.inf.writeLog(strs.Length.ToString());
  1082. dr["sn"] = i + 1;
  1083. dr["psn_no"] = strs[0];
  1084. dr["mdtrt_id"] = strs[1];
  1085. dr["setl_id"] = strs[2];
  1086. dr["msgid"] = strs[3];
  1087. dr["stmt_rslt"] = strs[4];
  1088. dr["refd_setl_flag"] = strs[5];
  1089. dr["memo"] = strs[6];
  1090. dr["medfee_sumamt"] = strs[7];
  1091. dr["fund_pay_sumamt"] = strs[8];
  1092. dr["acct_pay"] = strs[9];
  1093. //dr["Field2"] = strs[2];
  1094. dt.Rows.Add(dr);
  1095. }
  1096. dgvCenterSettlRec.DataSource = dt;
  1097. return 0;
  1098. }
  1099. catch (Exception ex)
  1100. {
  1101. outParam = "importToDgvCenterSetlRec:" + ex.Message;
  1102. return -1;
  1103. }
  1104. }
  1105. private int CheckDetail_Single(out string outParam)
  1106. {
  1107. outParam = "";
  1108. //先签到
  1109. CenterBusiness cBus = new CenterBusiness();
  1110. JObject jo9001Rtn = new JObject();
  1111. cBus.signIn(out jo9001Rtn);
  1112. try
  1113. {
  1114. //导出并压缩
  1115. if (exportAndCompress(out outParam) != 0)
  1116. {
  1117. return -1;
  1118. }
  1119. string zipPath = outParam;
  1120. Global.writeLog("exportAndCompress:" + zipPath);
  1121. //上传给中心,
  1122. if (uploadFileToCenter(zipPath, out outParam) != 0)
  1123. {
  1124. return -1;
  1125. }
  1126. Global.writeLog("uploadFileToCenter:" + outParam);
  1127. string file_query_no = outParam;
  1128. string fileName = "";
  1129. //3202明细对账 输出查询号和文件名
  1130. if (checkDetail(file_query_no, out outParam, out fileName) != 0)
  1131. {
  1132. return -1;
  1133. }
  1134. file_query_no = outParam;
  1135. Global.writeLog("checkDetail:" + outParam + "///" + fileName);
  1136. //下载 获取 查询号和文件名后 下载
  1137. if (downloadZIP(file_query_no, fileName, out outParam) != 0)
  1138. {
  1139. return -1;
  1140. }
  1141. zipPath = outParam;
  1142. Global.writeLog("downloadZIP:" + outParam);
  1143. //导入DGV
  1144. if (importToDgvCenterSetlRec(fileName, zipPath, out outParam) != 0)
  1145. {
  1146. return -1;
  1147. }
  1148. Global.writeLog("importToDgvCenterSetlRec:" + outParam);
  1149. return 0;
  1150. }
  1151. catch (Exception ex)
  1152. {
  1153. outParam = "CheckDetail_Single:" + ex.Message;
  1154. return -1;
  1155. }
  1156. }
  1157. private void dgvRowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e)
  1158. {
  1159. DataGridView dgv = (DataGridView)sender;
  1160. dgv.RowHeadersWidth = 60;
  1161. if (dgv.Rows.Count > 1)
  1162. e.Row.HeaderCell.Value = string.Format("{0}", e.Row.Index + 1);
  1163. }
  1164. private void dgvSettlSummary_RowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e)
  1165. {
  1166. if (dgvSettlSummary.Rows.Count > 1)
  1167. e.Row.HeaderCell.Value = string.Format("{0}", e.Row.Index + 1);
  1168. }
  1169. private void dgvHisSettlRec_RowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e)
  1170. {
  1171. if (dgvHisSettlRec.Rows.Count > 1)
  1172. e.Row.HeaderCell.Value = string.Format("{0}", e.Row.Index + 1);
  1173. }
  1174. private int compareDataGridView(string value, string colName, Sunny.UI.UIDataGridView dgv)
  1175. {
  1176. try
  1177. {
  1178. for (int i = 0; i < dgv.RowCount; i++)
  1179. {
  1180. if (dgv.Rows[i].Cells[colName].Value.ToString() == value)
  1181. {
  1182. return 0;
  1183. }
  1184. }
  1185. return -1;
  1186. }
  1187. catch (Exception ex)
  1188. {
  1189. MessageBox.Show("compareDataGridView" + ex.Message);
  1190. return -1;
  1191. }
  1192. }
  1193. private void tsmAICheck_Click(object sender, EventArgs e)
  1194. {
  1195. for (int i = 0; i < dgvHisSettlRec.RowCount; i++)
  1196. {
  1197. string value = dgvHisSettlRec.Rows[i].Cells["SettlementID"].Value.ToString();
  1198. string colName = "setl_id";
  1199. if (compareDataGridView(value, colName, dgvCenterSettlRec) != 0)
  1200. {
  1201. dgvHisSettlRec.Rows[i].DefaultCellStyle.BackColor = Color.Red;
  1202. rtbCheckDetailLog.AppendText("HIS结算ID:" + value + "在中心明细中未找到数据!" + "\r\n");
  1203. }
  1204. }
  1205. for (int i = 0; i < dgvCenterSettlRec.RowCount; i++)
  1206. {
  1207. string value = dgvCenterSettlRec.Rows[i].Cells["setl_id"].Value.ToString();
  1208. string colName = "SettlementID";
  1209. if (compareDataGridView(value, colName, dgvHisSettlRec) != 0)
  1210. {
  1211. dgvCenterSettlRec.Rows[i].DefaultCellStyle.BackColor = Color.Red;
  1212. rtbCheckDetailLog.AppendText("中心结算ID:" + value + "在HIS明细中未找到数据!" + "\r\n");
  1213. }
  1214. }
  1215. }
  1216. private void tsmCheckDetail_Batch_Click(object sender, EventArgs e)
  1217. {
  1218. }
  1219. private void toolStripMenuItem1_Click(object sender, EventArgs e)
  1220. {
  1221. int i = dgvHisSettlRec.CurrentRow.Index;
  1222. DataTable dt = (DataTable)dgvHisSettlRec.DataSource;
  1223. MessageBox.Show(dt.Rows[i]["AccountPaySumamt"].ToString());
  1224. }
  1225. private void btnAddOneDay_Click(object sender, EventArgs e)
  1226. {
  1227. dpST.Value = dpST.Value.AddDays(1);
  1228. dpED.Value = dpED.Value.AddDays(1);
  1229. }
  1230. private void btnReduceOndDay_Click(object sender, EventArgs e)
  1231. {
  1232. dpST.Value = dpST.Value.AddDays(-1);
  1233. dpED.Value = dpED.Value.AddDays(-1);
  1234. }
  1235. private void Clearing1()
  1236. {
  1237. //组织入参,进行中心清算
  1238. int i = dgvSettlSummary.CurrentRow.Index;
  1239. DataTable dt = (DataTable)dgvSettlSummary.DataSource;
  1240. JObject joData = new JObject();
  1241. joData.Add("", dgvSettlSummary.CurrentRow.Cells[""].Value.ToString());
  1242. //存到医保平台
  1243. }
  1244. private void btnQueryClrSum_Click(object sender, EventArgs e)
  1245. {
  1246. DataTable dtInteface = (DataTable)cbInterface_2.DataSource;
  1247. int i = cbInterface_2.SelectedIndex;
  1248. //
  1249. string sqlStr = "SELECT SUM(Billtype*Sumamt) AS medfee_sumamt,SUM(Billtype*(0.00+FundPaySumamt+AccountPaySumamt+PersonCashPay)) AS med_sumfee, SUM(billtype*PersonCashPay) AS cash_payamt, ";
  1250. sqlStr = sqlStr + " count(*) AS psntime,";
  1251. sqlStr = sqlStr + " SUM(billtype*AccountPaySumamt) AS acct_pay,SUM(billtype*FundPaySumamt) AS fund_appy_sum, ";
  1252. sqlStr = sqlStr + " ClearingType as clr_type,ClearingWay as clr_way,Interface_Dr ";
  1253. sqlStr = sqlStr + " FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + dtInteface.Rows[i]["HospitalDr"].ToString();
  1254. sqlStr = sqlStr + " and OccurTime>'" + dpST_2.Text + "'";
  1255. sqlStr = sqlStr + " and OccurTime<'" + dpED_2.Text + "'";
  1256. if (cbInterface_2.Text != "")
  1257. {
  1258. sqlStr = sqlStr + " and Interface_dr =" + dtInteface.Rows[i]["ID"].ToString();
  1259. }
  1260. if (cbInsutype_2.Text != "")
  1261. {
  1262. sqlStr = sqlStr + " and InsuranceType ='" + cbInsutype_2.SelectedValue + "'";
  1263. }
  1264. if (cbClrType_2.Text != "")
  1265. {
  1266. sqlStr = sqlStr + " and ClearingType ='" + cbClrType_2.SelectedValue + "'";
  1267. }
  1268. if (tbSettlOption_2.Text != "")
  1269. {
  1270. sqlStr = sqlStr + " and ClearingOrgan ='" + tbSettlOption_2.Text + "'";
  1271. }
  1272. if (cbClrWay_2.Text != "")
  1273. {
  1274. sqlStr = sqlStr + " and ClearingWay ='" + cbClrWay_2.SelectedValue + "'";
  1275. }
  1276. if (cbValid_2.SelectedIndex != 0)
  1277. {
  1278. if (cbValid_2.SelectedIndex == 1)
  1279. { sqlStr = sqlStr + " and ValidFlag =1"; }
  1280. else
  1281. sqlStr = sqlStr + " and ValidFlag =-1";
  1282. }
  1283. //省医保本地
  1284. if ((Global.inf.interfaceDr == 1) && (cbOtherPlaceFlag.SelectedIndex == 2))
  1285. {
  1286. sqlStr = sqlStr + " and (InsuranceAreaCode='539900' or InsuranceAreaCode='530100')";
  1287. }
  1288. //省医保异地
  1289. if ((Global.inf.interfaceDr == 1) && (cbOtherPlaceFlag.SelectedIndex == 1))
  1290. {
  1291. sqlStr = sqlStr + " and (InsuranceAreaCode<>'539900' and InsuranceAreaCode<>'530100')";
  1292. }
  1293. sqlStr = sqlStr + " and ReversalFlag<>1 ";
  1294. sqlStr = sqlStr + " Group By Interface_Dr,ClearingType,ClearingWay";
  1295. JObject joSqlstr = new JObject();
  1296. joSqlstr.Add("sqlStr", sqlStr);
  1297. JArray jaParam = new JArray();
  1298. jaParam.Add(joSqlstr);
  1299. JObject joSettlQuery = new JObject();
  1300. joSettlQuery.Add("params", jaParam);
  1301. joSettlQuery.Add("code", "09010068");
  1302. InvokeHelper invoker = new InvokeHelper();
  1303. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询汇总结算信息(清算)");
  1304. DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  1305. dgvClearingSum.DataSource = dt;
  1306. }
  1307. private void tmsClearing_2_Click(object sender, EventArgs e)
  1308. {
  1309. string error = "";
  1310. if ((Global.inf.interfaceDr == 1) && (cbOtherPlaceFlag.SelectedIndex == 1))
  1311. {
  1312. if (OthPlcClearing_Single(out error) != 0)
  1313. {
  1314. MessageBox.Show("异地清算失败:" + error);
  1315. }
  1316. else
  1317. {
  1318. MessageBox.Show("异地清算成功");
  1319. }
  1320. }
  1321. else
  1322. {
  1323. if (Clearing_Single(out error) != 0)
  1324. {
  1325. MessageBox.Show("清算失败:" + error);
  1326. }
  1327. else
  1328. {
  1329. MessageBox.Show("清算成功");
  1330. }
  1331. }
  1332. }
  1333. private void btnClose_3_Click(object sender, EventArgs e)
  1334. {
  1335. Close();
  1336. }
  1337. private void btnQueryClearing_Click(object sender, EventArgs e)
  1338. {
  1339. DataTable dtInteface = (DataTable)cbInterface_3.DataSource;
  1340. int i = cbInterface_3.SelectedIndex;
  1341. //
  1342. string sqlStr = "SELECT * from MedInsu_Tables.ClearingRecord where Hosp_Dr=" + dtInteface.Rows[i]["HospitalDr"].ToString(); ;
  1343. sqlStr = sqlStr + " and interface_dr =" + dtInteface.Rows[i]["ID"].ToString();
  1344. if (rbgTimeWay.SelectedIndex == 0)
  1345. {
  1346. sqlStr = sqlStr + " and OccurTime>'" + dpST_3.Value.ToString("yyyy-MM-dd 00:00:00") + "'";
  1347. sqlStr = sqlStr + " and OccurTime<'" + dpED_3.Value.ToString("yyyy-MM-dd 23:59:59") + "'";
  1348. }
  1349. else
  1350. {
  1351. sqlStr = sqlStr + " and Begndate>='" + dpST_3.Value.ToString("yyyy-MM-dd 00:00:00") + "'";
  1352. sqlStr = sqlStr + " and Enddate<='" + dpED_3.Value.ToString("yyyy-MM-dd 23:59:59") + "'";
  1353. }
  1354. if (cbValid_3.SelectedIndex != 0)
  1355. {
  1356. if (cbValid_3.SelectedIndex == 1)
  1357. { sqlStr = sqlStr + " and ValidFlag =1"; }
  1358. else
  1359. sqlStr = sqlStr + " and ValidFlag =-1";
  1360. }
  1361. JObject joSqlstr = new JObject();
  1362. joSqlstr.Add("sqlStr", sqlStr);
  1363. JArray jaParam = new JArray();
  1364. jaParam.Add(joSqlstr);
  1365. JObject joSettlQuery = new JObject();
  1366. joSettlQuery.Add("params", jaParam);
  1367. joSettlQuery.Add("code", "09010069");
  1368. InvokeHelper invoker = new InvokeHelper();
  1369. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询清算信息");
  1370. DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  1371. dgvClearingData.DataSource = dt;
  1372. }
  1373. private void btnCancleClearing_Click(object sender, EventArgs e)
  1374. {
  1375. string error = "";
  1376. if (1 == 1)
  1377. {
  1378. if (CancleClearing_Single(out error) != 0)
  1379. {
  1380. MessageBox.Show("撤销清算失败:" + error);
  1381. }
  1382. else
  1383. {
  1384. MessageBox.Show("撤销清算成功");
  1385. }
  1386. }
  1387. else
  1388. {
  1389. if (CancleOthPlcClearing_Single(out error) != 0)
  1390. {
  1391. MessageBox.Show("异地撤销清算失败:" + error);
  1392. }
  1393. else
  1394. {
  1395. MessageBox.Show("异地撤销清算成功");
  1396. }
  1397. }
  1398. }
  1399. private void btnAddMonth_Click(object sender, EventArgs e)
  1400. {
  1401. dpST_2.Value = dpST_2.Value.AddMonths(1);
  1402. dpED_2.Value = dpST_2.Value.AddDays(1 - dpST_2.Value.Day).AddMonths(1).AddMinutes(-1);
  1403. }
  1404. private void btnReduceMonth_Click(object sender, EventArgs e)
  1405. {
  1406. dpST_2.Value = dpST_2.Value.AddMonths(-1);
  1407. dpED_2.Value = dpST_2.Value.AddDays(1 - dpST_2.Value.Day).AddMonths(1).AddMinutes(-1);
  1408. }
  1409. private void uiButton3_Click(object sender, EventArgs e)
  1410. {
  1411. string sqlStr = "SELECT * ";
  1412. sqlStr = sqlStr + " FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.interfaceDr;
  1413. sqlStr = sqlStr + " and OccurTime>'" + dpST_O.Text + "'";
  1414. sqlStr = sqlStr + " and OccurTime<'" + dpED_O.Text + "'";
  1415. sqlStr = sqlStr + " and Interface_dr =1";
  1416. sqlStr = sqlStr + " and (InsuranceAreaCode<>'539900' and InsuranceAreaCode<>'530100')";
  1417. //if (cbxInsuType.Text != "")
  1418. //{
  1419. // sqlStr = sqlStr + " and insutype ='" + cbxInsuType.SelectedValue + "'";
  1420. //}
  1421. if (cbxClrType_O.Text != "")
  1422. {
  1423. sqlStr = sqlStr + " and ClearingType ='" + cbxClrType_O.SelectedValue + "'";
  1424. }
  1425. //if (tbSettlOption.Text != "")
  1426. //{
  1427. // sqlStr = sqlStr + " and ClearingOrgan ='" + tbSettlOption.Text + "'";
  1428. //}
  1429. if (cbxValid_O.SelectedIndex != 0)
  1430. {
  1431. if (cbxValid_O.SelectedIndex == 1)
  1432. { sqlStr = sqlStr + " and ValidFlag =1"; }
  1433. else
  1434. sqlStr = sqlStr + " and ValidFlag =-1";
  1435. }
  1436. sqlStr = sqlStr + " and ReversalFlag<>1 ";
  1437. JObject joSqlstr = new JObject();
  1438. joSqlstr.Add("sqlStr", sqlStr);
  1439. JArray jaParam = new JArray();
  1440. jaParam.Add(joSqlstr);
  1441. JObject joSettlQuery = new JObject();
  1442. joSettlQuery.Add("params", jaParam);
  1443. joSettlQuery.Add("code", "09010059");
  1444. InvokeHelper invoker = new InvokeHelper();
  1445. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");
  1446. //DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  1447. DataTable dt = (DataTable)JsonConvert.DeserializeObject(joRtn["result"]["data"].ToString(), (typeof(DataTable)));
  1448. //DataTable dtResult = new DataTable();
  1449. ////克隆表结构
  1450. //dtResult = dt.Clone();
  1451. //foreach (DataColumn col in dtResult.Columns)
  1452. //{
  1453. // if (col.ColumnName == "BillID")
  1454. // {
  1455. // //修改列类型
  1456. // col.DataType = typeof(string);
  1457. // }
  1458. // if (col.ColumnName == "RecordID")
  1459. // {
  1460. // //修改列类型
  1461. // col.DataType = typeof(string);
  1462. // }
  1463. //}
  1464. //foreach (DataRow row in dt.Rows)
  1465. //{
  1466. // DataRow newDtRow = dtResult.NewRow();
  1467. // foreach (DataColumn column in dt.Columns)
  1468. // {
  1469. // if (column.ColumnName == "BillID")
  1470. // {
  1471. // MessageBox.Show("cs1:" + column.ColumnName + row[column.ColumnName].ToString());
  1472. // newDtRow[column.ColumnName] = Convert.ToString(row[column.ColumnName]);
  1473. // }
  1474. // else
  1475. // {
  1476. // newDtRow[column.ColumnName] = row[column.ColumnName];
  1477. // }
  1478. // }
  1479. // dtResult.Rows.Add(newDtRow);
  1480. //}
  1481. dgvOthCheck.DataSource = dt;
  1482. }
  1483. private void tsmOthPlcCheck_Click(object sender, EventArgs e)
  1484. {
  1485. string error = "";
  1486. if (OthPlcCheck_Single(out error) != 0)
  1487. {
  1488. MessageBox.Show("对账失败:" + error);
  1489. }
  1490. else
  1491. {
  1492. MessageBox.Show("对账成功");
  1493. }
  1494. }
  1495. private void uiSymbolButton2_Click(object sender, EventArgs e)
  1496. {
  1497. dpST_O.Value = dpST_O.Value.AddDays(1);
  1498. dpED_O.Value = dpED_O.Value.AddDays(1);
  1499. }
  1500. private ArrayList getIndexArray(String inputStr, String findStr)
  1501. {
  1502. ArrayList list = new ArrayList();
  1503. int start = 0;
  1504. while (start < inputStr.Length)
  1505. {
  1506. int index = inputStr.IndexOf(findStr, start);
  1507. if (index >= 0)
  1508. {
  1509. list.Add(index);
  1510. start = index + findStr.Length;
  1511. }
  1512. else
  1513. {
  1514. break;
  1515. }
  1516. }
  1517. return list;
  1518. }
  1519. private void uiButton2_Click(object sender, EventArgs e)
  1520. {
  1521. DataTable dt = (DataTable)dgvOthCheck.DataSource;
  1522. string error = "";
  1523. int failRows = 0;
  1524. for (int i = 0; i < dt.Rows.Count; i++)
  1525. {
  1526. //dgvOthCheck.Rows[i].Selected = true;
  1527. dgvOthCheck.CurrentCell = dgvOthCheck.Rows[i].Cells[0];
  1528. if (OthPlcCheck_Single(out error) != 0)
  1529. {
  1530. string str = "【当前人员】:";
  1531. //Graphics g = this.CreateGraphics();
  1532. //Font font = new Font("宋体", 14, FontStyle.Bold);
  1533. //SolidBrush brush = new SolidBrush(Color.Red);
  1534. //g.DrawString(str, font, brush, 20, 50);
  1535. string patInfo = str + dt.Rows[i]["PatientName"].ToString()
  1536. + ",结算编号:" + dt.Rows[i]["SettlementID"].ToString()
  1537. + ",清算类别:" + dt.Rows[i]["ClearingType"].ToString()
  1538. + ",就诊类别(1门诊2住院):" + dt.Rows[i]["admType"].ToString();
  1539. rtbOthCheckResultRecord.AppendText(patInfo + ";对账失败:" + error + "\r\n");
  1540. failRows++;
  1541. }
  1542. else
  1543. {
  1544. //rtbOthCheckResultRecord.AppendText("当前人员:" + dt.Rows[i]["PatientName"].ToString() + ";对账成功!" + "\r\n");
  1545. }
  1546. }
  1547. if (failRows == 0)
  1548. {
  1549. rtbOthCheckResultRecord.AppendText("当前所有人员对账成功!" + "\r\n");
  1550. }
  1551. else
  1552. {
  1553. string str = "【当前人员】";
  1554. ArrayList list = getIndexArray(rtbOthCheckResultRecord.Text, str);
  1555. for (int i = 0; i < list.Count; i++)
  1556. {
  1557. int index = (int)list[i];
  1558. rtbOthCheckResultRecord.Select(index, str.Length);
  1559. rtbOthCheckResultRecord.SelectionColor = Color.Red;
  1560. Font oldFont = rtbOthCheckResultRecord.SelectionFont;
  1561. Font font = new Font(oldFont, oldFont.Style | FontStyle.Bold);
  1562. rtbOthCheckResultRecord.SelectionFont = font;
  1563. }
  1564. }
  1565. }
  1566. private void tsmHandCheck_Click(object sender, EventArgs e)
  1567. {
  1568. JObject joData = JObject.Parse(rtbCheckDetailLog.Text);
  1569. InvokeHelper invoker = new InvokeHelper();
  1570. JObject joRtn = invoker.invokeCenterService("3201", JsonHelper.setCenterInpar("3202", joData.ToString()));
  1571. }
  1572. private void btnClose_Click(object sender, EventArgs e)
  1573. {
  1574. Close();
  1575. }
  1576. private void Btn_Query_Click(object sender, EventArgs e)
  1577. {
  1578. DataTable dtInteface = (DataTable)cbxInterface.DataSource;
  1579. int i = cbxInterface.SelectedIndex;
  1580. //乘以单据类型后,IRIS会返回整数,关键不知道SQL里咋转换为浮点数
  1581. //string sqlStr = "SELECT SUM(BillType*Sumamt) AS medfee_sumamt,count(*) AS fixmedins_setl_cnt,SUM(BillType*PersonCashPay) AS cash_payamt, ";
  1582. //sqlStr = sqlStr + " SUM(BillType*AccountPaySumamt) AS acct_pay,SUM(BillType*FundPaySumamt) AS fund_pay_sumamt ";
  1583. string sqlStr = "SELECT SUM(BillType*Sumamt) AS medfee_sumamt,sum(BillType) AS fixmedins_setl_cnt,SUM(BillType*PersonCashPay) AS cash_payamt, ";
  1584. sqlStr = sqlStr + " SUM(billType*AccountPaySumamt) AS acct_pay,SUM(BillType*FundPaySumamt) AS fund_pay_sumamt ";
  1585. //sqlStr = sqlStr + " Interface_dr,clearingWay AS clr_way,clearingType AS clr_type ";
  1586. string conditionStr = " Group By";
  1587. if (cbgGroupSet.GetItemCheckState(0))
  1588. {
  1589. sqlStr = sqlStr + ",Interface_Dr";
  1590. conditionStr = conditionStr + " Interface_Dr,";
  1591. }
  1592. if (cbgGroupSet.GetItemCheckState(1))
  1593. {
  1594. sqlStr = sqlStr + ",InsuranceType as insutype";
  1595. conditionStr = conditionStr + " InsuranceType,";
  1596. }
  1597. if (cbgGroupSet.GetItemCheckState(2))
  1598. {
  1599. sqlStr = sqlStr + ",ClearingType as clr_type";
  1600. conditionStr = conditionStr + " ClearingType,";
  1601. }
  1602. if (cbgGroupSet.GetItemCheckState(3))
  1603. {
  1604. sqlStr = sqlStr + ",ClearingOrgan as setl_optins";
  1605. conditionStr = conditionStr + " ClearingOrgan,";
  1606. }
  1607. if (cbgGroupSet.GetItemCheckState(4))
  1608. {
  1609. sqlStr = sqlStr + ",BillType";
  1610. conditionStr = conditionStr + " BillType,";
  1611. }
  1612. sqlStr = sqlStr + " FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + dtInteface.Rows[i]["HospitalDr"].ToString();
  1613. sqlStr = sqlStr + " and OccurTime>'" + dpST.Text + "'";
  1614. sqlStr = sqlStr + " and OccurTime<'" + dpED.Text + "'";
  1615. if (cbxInterface.Text != "")
  1616. {
  1617. sqlStr = sqlStr + " and Interface_Dr =" + dtInteface.Rows[i]["ID"].ToString();
  1618. }
  1619. if (cbxInsuType.Text != "")
  1620. {
  1621. sqlStr = sqlStr + " and InsuranceType ='" + cbxInsuType.SelectedValue + "'";
  1622. }
  1623. if (cbxClrType.Text != "")
  1624. {
  1625. sqlStr = sqlStr + " and ClearingType ='" + cbxClrType.SelectedValue + "'";
  1626. }
  1627. if (tbSettlOption.Text != "")
  1628. {
  1629. sqlStr = sqlStr + " and ClearingOrgan ='" + tbSettlOption.Text + "'";
  1630. }
  1631. //ValidFlag=1 and BillType=1 表示正常结算记录 ValidFlag=0 and BillType=-1 表示退费记录 ValidFlag=0表示无效记录
  1632. if (cbxValid.SelectedIndex != 0)
  1633. {
  1634. if (cbxValid.SelectedIndex == 1)
  1635. sqlStr = sqlStr + " and ValidFlag =1 and BillType=1";
  1636. else
  1637. sqlStr = sqlStr + " and ValidFlag =0 and BillType=-1";
  1638. }
  1639. else
  1640. {
  1641. sqlStr = sqlStr + " and BillType <> 9 ";
  1642. }
  1643. sqlStr = sqlStr + " and ReversalFlag<>1 ";
  1644. //if (Global.inf.interfaceDr == 11)
  1645. //{
  1646. // sqlStr = sqlStr + " and (LEFT(InsuranceAreaCode,4)='4599' or LEFT(InsuranceAreaCode,4)='4501')";
  1647. //}
  1648. //conditionStr = conditionStr.Substring(0,conditionStr.Length -1 );
  1649. conditionStr = conditionStr.Remove(conditionStr.Length - 1, 1);
  1650. sqlStr = sqlStr + conditionStr;
  1651. JObject joSqlstr = new JObject();
  1652. MessageBox.Show(sqlStr);
  1653. joSqlstr.Add("sqlStr", sqlStr);
  1654. JArray jaParam = new JArray();
  1655. jaParam.Add(joSqlstr);
  1656. JObject joSettlQuery = new JObject();
  1657. joSettlQuery.Add("params", jaParam);
  1658. joSettlQuery.Add("code", "09010061");
  1659. InvokeHelper invoker = new InvokeHelper();
  1660. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询汇总结算信息");
  1661. DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  1662. dgvSettlSummary.DataSource = dt;
  1663. //初始化HIS结算明细View数据
  1664. dgvHisSettlRec.DataSource = null;
  1665. }
  1666. private void uiButton1_Click_1(object sender, EventArgs e)
  1667. {
  1668. }
  1669. private void btnBatchCheck_Click(object sender, EventArgs e)
  1670. {
  1671. }
  1672. private void btnPatchClr_Click(object sender, EventArgs e)
  1673. {
  1674. }
  1675. private void cmsClearing_Opening(object sender, CancelEventArgs e)
  1676. {
  1677. }
  1678. private void dgvSettlSummary_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
  1679. {
  1680. string error;
  1681. if (queryHisSettlementInfo(out error) != 0)
  1682. {
  1683. MessageBox.Show(error);
  1684. }
  1685. }
  1686. }
  1687. }