Clearing.cs 79 KB

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