Clearing.cs 79 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926
  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. //省医保和市医保对账一样,异地对账需要用到另外的对账交易
  552. //if (Global.inf.interfaceDr == 1)
  553. //{
  554. // sqlStr = sqlStr + " and (InsuranceAreaCode='539900' or InsuranceAreaCode='530100')";
  555. //}
  556. //conditionStr = conditionStr.Substring(0,conditionStr.Length -1 );
  557. //conditionStr = conditionStr.Remove(conditionStr.Length - 1, 1);
  558. sqlStr = sqlStr + conditionStr;
  559. JObject joSqlstr = new JObject();
  560. joSqlstr.Add("sqlStr", sqlStr);
  561. JArray jaParam = new JArray();
  562. jaParam.Add(joSqlstr);
  563. JObject joSettlQuery = new JObject();
  564. joSettlQuery.Add("params", jaParam);
  565. joSettlQuery.Add("code", "09010059");
  566. InvokeHelper invoker = new InvokeHelper();
  567. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");
  568. //DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  569. JArray ja = JArray.Parse(JsonHelper.getDestValue(joRtn, "result.data"));
  570. DataTable dt = (DataTable)JsonConvert.DeserializeObject(JsonHelper.getDestValue(joRtn, "result.data"), (typeof(DataTable)));
  571. dgvHisSettlRec.DataSource = dt;
  572. //dt.Columns[7].DataType = typeof(float);//不允许
  573. //dgvHisSettlRecFooter.DataGridView = dgvHisSettlRec;
  574. //dgvHisSettlRecFooter.Dock = System.Windows.Forms.DockStyle.Bottom;
  575. //dgvHisSettlRecFooter.Clear();
  576. //dgvHisSettlRecFooter["AdmID"] = "合计";
  577. //dgvHisSettlRecFooter["OverLimitAmount"] = "测试";
  578. return 0;
  579. }
  580. catch (Exception ex)
  581. {
  582. error = "queryHisSettlementInfo:" + ex.Message;
  583. return -1;
  584. }
  585. }
  586. private void tsmCheckDetail_Single_Click(object sender, EventArgs e)
  587. {
  588. //HIS明细
  589. string error;
  590. if (queryHisSettlementInfo(out error) != 0)
  591. {
  592. MessageBox.Show(error);
  593. }
  594. //中心明细
  595. if (CheckDetail_Single(out error) != 0)
  596. {
  597. MessageBox.Show(error);
  598. }
  599. }
  600. /// <summary>
  601. /// 查询HIS结算明细记录
  602. /// </summary>
  603. /// <param name="sender"></param>
  604. /// <param name="e"></param>
  605. private void tsmHisRecord_Click(object sender, EventArgs e)
  606. {
  607. string error;
  608. if (queryHisSettlementInfo(out error) != 0)
  609. {
  610. MessageBox.Show(error);
  611. }
  612. }
  613. public static void writeToTxt(string content, string filePath, string fileName)
  614. {
  615. //创建文件夹,文件夹名称与TXT同名
  616. string finalPath = filePath + "\\" + fileName;
  617. if (!Directory.Exists(finalPath))
  618. {
  619. DirectoryInfo dirInfo = Directory.CreateDirectory(finalPath);
  620. }
  621. //判断文件夹中是否存在txt
  622. string finalFileName = finalPath + "\\" + fileName + ".txt";
  623. if (!File.Exists(finalFileName))
  624. {
  625. FileStream fs1 = File.Create(finalFileName);
  626. fs1.Close();
  627. }
  628. FileStream fs = new FileStream(finalFileName, FileMode.Append, FileAccess.Write);
  629. StreamWriter sw = new StreamWriter(fs);
  630. sw.WriteLine(content);
  631. sw.Close();
  632. fs.Close();
  633. }
  634. /// <summary>
  635. /// 读文件到byte[]
  636. /// </summary>
  637. /// <param name="fileName">硬盘文件路径</param>
  638. /// <returns></returns>
  639. public static byte[] ReadFileToByte(string fileName)
  640. {
  641. FileStream pFileStream = null;
  642. byte[] pReadByte = new byte[0];
  643. try
  644. {
  645. pFileStream = new FileStream(fileName, FileMode.Open, FileAccess.Read);
  646. BinaryReader r = new BinaryReader(pFileStream);
  647. r.BaseStream.Seek(0, SeekOrigin.Begin); //将文件指针设置到文件开
  648. pReadByte = r.ReadBytes((int)r.BaseStream.Length);
  649. return pReadByte;
  650. }
  651. catch
  652. {
  653. return pReadByte;
  654. }
  655. finally
  656. {
  657. if (pFileStream != null)
  658. pFileStream.Close();
  659. }
  660. }
  661. /// <summary>
  662. ///单字节转有符号整数
  663. /// </summary>
  664. /// <param name="data"></param>
  665. /// <returns></returns>
  666. public string byteArrayToDecString(byte[] data)
  667. {
  668. StringBuilder builder = new StringBuilder();
  669. for (int i = 0; i < data.Length; i++)
  670. {
  671. builder.Append((sbyte)data[i] + ",");
  672. }
  673. return builder.ToString().Trim();
  674. }
  675. private int HISDetailDataExport(string filePath, string fileName)
  676. {
  677. try
  678. {
  679. DataTable dt = (DataTable)dgvHisSettlRec.DataSource;
  680. string content = "";
  681. for (int i = 0; i < dt.Rows.Count; i++)
  682. {
  683. string flag = "";
  684. if (dt.Rows[i]["ValidFlag"].ToString() == "-1")
  685. {
  686. flag = "1";
  687. }
  688. else
  689. {
  690. flag = "0";
  691. }
  692. content = "\r\n"
  693. + dt.Rows[i]["SettlementID"].ToString() + "\t"
  694. + dt.Rows[i]["MdtrtID"].ToString() + "\t"
  695. + dt.Rows[i]["PersonnelNO"].ToString() + "\t"
  696. + dt.Rows[i]["Sumamt"].ToString() + "\t"
  697. + dt.Rows[i]["FundPaySumamt"].ToString() + "\t"
  698. + dt.Rows[i]["AccountPaySumamt"].ToString() + "\t"
  699. + flag
  700. + content;
  701. }
  702. string finalContent = content.Remove(0, 2);
  703. writeToTxt(finalContent, filePath, fileName);
  704. return 0;
  705. }
  706. catch (Exception ex)
  707. {
  708. MessageBox.Show(ex.Message);
  709. return -1;
  710. }
  711. }
  712. private void tsmExport_Click(object sender, EventArgs e)
  713. {
  714. txtName = DateTime.Now.ToString("yyyyMMddHHmmssffff");
  715. txtPath = Global.currentDirectory + "\\Download";
  716. if (HISDetailDataExport(txtPath, txtName) != 0)
  717. {
  718. MessageBox.Show("导出TXT失败!");
  719. }
  720. else
  721. {
  722. MessageBox.Show("导出TXT成功!");
  723. }
  724. //System.IO.Compression.ZipFile.CreateFromDirectory(txtPath + "\\" + "2022ceshi", txtPath + "\\" + "111.zip");
  725. }
  726. private void tsmCompress_Click(object sender, EventArgs e)
  727. {
  728. string path = @"C:\ProgramData\prykNT\prBrowser\bin\service\plugins\INSUNew\DownLoad\111";
  729. string name = @"1121.zip";
  730. string finalDirPath = txtPath + "\\" + txtName;
  731. finalAchPath = finalDirPath + ".zip";
  732. System.IO.Compression.ZipFile.CreateFromDirectory(finalDirPath, finalAchPath);
  733. //System.IO.Compression.ZipFile.CreateFromDirectory(path, name);
  734. //System.IO.Compression.ZipFile.CreateFromDirectory(path, name, 0, true);
  735. MessageBox.Show("将TXT压缩为ZIP成功!");
  736. }
  737. private void tsmZIPToSDec_Click(object sender, EventArgs e)
  738. {
  739. byte[] bArray = ReadFileToByte(finalAchPath);
  740. string str = byteArrayToDecString(bArray);
  741. Global.writeLog(str);
  742. MessageBox.Show("ZIP转为有符号整数成功!");
  743. }
  744. private void tsmUploadZIP_Click(object sender, EventArgs e)
  745. {
  746. string outParam = "";
  747. byte[] bArray = ReadFileToByte(finalAchPath);
  748. string str = "[" + byteArrayToDecString(bArray) + "]";
  749. JObject joTmp = new JObject();
  750. joTmp.Add("in", JArray.Parse(str));
  751. joTmp.Add("filename", txtName + ".zip");
  752. Global.inf.fileName = txtName + ".zip";
  753. //joTmp.Add("filename", finalAchPath.Replace("\\",@"\"));
  754. joTmp.Add("fixmedins_code", Global.inf.hospitalNO);
  755. JObject joFsUploadIn = new JObject();
  756. joFsUploadIn.Add("fsUploadIn", joTmp);
  757. InvokeHelper invoker = new InvokeHelper();
  758. JObject jo9101Rtn= invoker.invokeCenterService(TradeEnum.FileUpload, joFsUploadIn);
  759. if (JsonHelper.parseCenterRtnValue(jo9101Rtn, out outParam) != 0)
  760. {
  761. outParam = JsonHelper.setExceptionJson(-1, "【9101】文件上传失败", outParam).ToString();
  762. return;
  763. }
  764. else
  765. {
  766. MessageBox.Show("【9101】文件上传成功");
  767. }
  768. }
  769. private void tsm3202_Click(object sender, EventArgs e)
  770. {
  771. if (string.IsNullOrEmpty(Global.inf.areaCode))
  772. {
  773. MessageBox.Show("请先签到!","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
  774. return;
  775. }
  776. string outParam = "";
  777. DataTable dt = (DataTable)dgvSettlSummary.DataSource;
  778. int i = dgvSettlSummary.CurrentRow.Index;
  779. dynamic joCheck = new JObject();
  780. joCheck.file_qury_no = JObject.Parse(tbTmp.Text);
  781. joCheck.clr_type = dt.Rows[i]["clr_type"].ToString();
  782. joCheck.setl_optins = dt.Rows[i]["setl_optins"].ToString();
  783. joCheck.stmt_begndate = dpST.Value.ToString("yyyy-MM-dd HH:mm:ss");
  784. joCheck.stmt_enddate = dpED.Value.ToString("yyyy-MM-dd HH:mm:ss");
  785. joCheck.medfee_sumamt = dt.Rows[i]["medfee_sumamt"].ToString();
  786. joCheck.fund_pay_sumamt = dt.Rows[i]["fund_pay_sumamt"].ToString();
  787. joCheck.cash_payamt = dt.Rows[i]["cash_payamt"].ToString();
  788. joCheck.fixmedins_setl_cnt = dt.Rows[i]["fixmedins_setl_cnt"].ToString();
  789. JObject joData = new JObject();
  790. joData.Add("data", joCheck);
  791. InvokeHelper invoker = new InvokeHelper();
  792. JObject jo3202Rtn= invoker.invokeCenterService(TradeEnum.FeeDetailCheck, joData);
  793. if (JsonHelper.parseCenterRtnValue(jo3202Rtn, out outParam) != 0)
  794. {
  795. outParam = JsonHelper.setExceptionJson(-1, "【3202】医保明细对账失败", outParam).ToString();
  796. MessageBox.Show(outParam);
  797. return;
  798. }
  799. else
  800. {
  801. MessageBox.Show("【3202】医保明细对账成功");
  802. }
  803. }
  804. private void tsmDownload_Click(object sender, EventArgs e)
  805. {
  806. string outParam = "";
  807. JObject joTmp = new JObject();
  808. joTmp.Add("file_qury_no", JObject.Parse(tbTmp.Text.Replace(@"\\", @"\")));
  809. joTmp.Add("filename", txtName + ".zip");
  810. joTmp.Add("fixmedins_code", Global.inf.hospitalNO);
  811. JObject joFsDownloadIn = new JObject();
  812. joFsDownloadIn.Add("fsDownloadIn", joTmp);
  813. InvokeHelper invoker = new InvokeHelper();
  814. jo9102Rtn = invoker.invokeCenterService(TradeEnum.FileDownload, joFsDownloadIn);
  815. if (JsonHelper.parseCenterRtnValue(jo9102Rtn, out outParam) != 0)
  816. {
  817. outParam = JsonHelper.setExceptionJson(-1, "【9102】文件下载失败", outParam).ToString();
  818. MessageBox.Show(outParam);
  819. return;
  820. }
  821. else
  822. {
  823. MessageBox.Show("【9102】文件下载成功");
  824. }
  825. }
  826. private void tsmUnCompress_Click(object sender, EventArgs e)
  827. {
  828. //解压缩
  829. string zipFilePath = jo9102Rtn["filePath"].ToString();
  830. string txtFileDir = System.Environment.CurrentDirectory + "\\Download";
  831. //string txtFilePath = txtFileDir + "\\" + filename.Substring(0, filename.Length - 4);
  832. string txtFilePath = txtFileDir;
  833. if (File.Exists(txtFilePath))
  834. {
  835. File.Delete(txtFilePath);
  836. }
  837. ZipFile.ExtractToDirectory(zipFilePath, txtFileDir);
  838. }
  839. private void tsmImport_Click(object sender, EventArgs e)
  840. {
  841. GridViewSetter grd = new GridViewSetter();
  842. grd.SetHeaderTextOfDgvCenterSetlRec(dgvCenterSettlRec);
  843. string txtFileDir = tbTmp.Text;//E:\GHSF\SCYBDownLoad\result.txt
  844. string[] lines = System.IO.File.ReadAllLines(txtFileDir);
  845. Global.writeLog(lines.ToString());
  846. DataTable dt = new DataTable();
  847. dt.Columns.Add("sn", typeof(int));
  848. dt.Columns.Add("psn_no", typeof(string));
  849. dt.Columns.Add("mdtrt_id", typeof(string));
  850. dt.Columns.Add("setl_id", typeof(string));
  851. dt.Columns.Add("msgid", typeof(string));
  852. dt.Columns.Add("stmt_rslt", typeof(string));
  853. dt.Columns.Add("refd_setl_flag", typeof(string));
  854. dt.Columns.Add("memo", typeof(string));
  855. dt.Columns.Add("medfee_sumamt", typeof(string));
  856. dt.Columns.Add("fund_pay_sumamt", typeof(string));
  857. dt.Columns.Add("acct_pay", typeof(string));
  858. //foreach (string line in lines)
  859. for (int i = 0; i < lines.Length; i++)
  860. {
  861. string[] strs = (lines[i] + "\t").Split('\t');
  862. DataRow dr = dt.NewRow();
  863. //Global.inf.writeLog(lines[i].ToString());
  864. //Global.inf.writeLog(strs.Length.ToString());
  865. dr["sn"] = i;
  866. dr["psn_no"] = strs[0];
  867. dr["mdtrt_id"] = strs[1];
  868. dr["setl_id"] = strs[2];
  869. dr["msgid"] = strs[3];
  870. dr["stmt_rslt"] = strs[4];
  871. dr["refd_setl_flag"] = strs[5];
  872. dr["memo"] = strs[6];
  873. dr["medfee_sumamt"] = strs[7];
  874. dr["fund_pay_sumamt"] = strs[8];
  875. dr["acct_pay"] = strs[9];
  876. //dr["Field2"] = strs[2];
  877. dt.Rows.Add(dr);
  878. }
  879. dgvCenterSettlRec.DataSource = dt;
  880. }
  881. private int exportAndCompress(out string zipPath)
  882. {
  883. zipPath = "";
  884. try
  885. {
  886. //导出TXT
  887. string fileName = DateTime.Now.ToString("yyyyMMddHHmmssffff");
  888. string filePath = Global.currentDirectory + "\\Download";
  889. HISDetailDataExport(filePath, fileName);
  890. //压缩
  891. string finalDirPath = filePath + "\\" + fileName;//同名文件夹
  892. zipPath = finalDirPath + ".zip";
  893. System.IO.Compression.ZipFile.CreateFromDirectory(finalDirPath, zipPath);
  894. return 0;
  895. }
  896. catch (Exception ex)
  897. {
  898. zipPath = "exportAndCompress:" + ex.Message;
  899. return -1;
  900. }
  901. }
  902. /// <summary>
  903. /// 上传ZIP文件转字节流再转换为有符号10进制数组后上传
  904. /// </summary>
  905. /// <param name="zipPath"></param>
  906. /// <param name="file_qury_no"></param>
  907. /// <returns></returns>
  908. private int uploadFileToCenter(string zipPath, out string file_qury_no)
  909. {
  910. string outParam = "";
  911. try
  912. {
  913. byte[] bArray = ReadFileToByte(zipPath);
  914. string str = "[" + byteArrayToDecString(bArray) + "]";
  915. JObject joTmp = new JObject();
  916. joTmp.Add("in", JArray.Parse(str));
  917. joTmp.Add("filename", txtName + ".zip");
  918. joTmp.Add("fixmedins_code", Global.inf.hospitalNO);
  919. JObject joFsUploadIn = new JObject();
  920. joFsUploadIn.Add("fsUploadIn", joTmp);
  921. InvokeHelper invoker = new InvokeHelper();
  922. JObject jo9101Rtn = invoker.invokeCenterService(TradeEnum.FileUpload, joFsUploadIn);
  923. if (JsonHelper.parseCenterReturnJson(jo9101Rtn, out outParam) != 0)
  924. {
  925. file_qury_no = outParam;
  926. return -1;
  927. }
  928. else
  929. {
  930. file_qury_no = JsonHelper.getDestValue(jo9101Rtn, "output.file_qury_no");
  931. return 0;
  932. }
  933. }
  934. catch (Exception ex)
  935. {
  936. file_qury_no = "uploadFileToCenter:" + ex.Message;
  937. return -1;
  938. }
  939. }
  940. private int checkDetail(string file_qury_no, out string outParam, out string fileName)
  941. {
  942. fileName = "";
  943. try
  944. {
  945. DataTable dt = (DataTable)dgvSettlSummary.DataSource;
  946. int i = dgvSettlSummary.CurrentRow.Index;
  947. dynamic joCheck = new JObject();
  948. joCheck.file_qury_no = file_qury_no.Replace(@"\\", @"\");
  949. joCheck.clr_type = dt.Rows[i]["clr_type"].ToString();
  950. joCheck.setl_optins = dt.Rows[i]["setl_optins"].ToString();
  951. joCheck.stmt_begndate = dpST.Value.ToString("yyyy-MM-dd HH:mm:ss");
  952. joCheck.stmt_enddate = dpED.Value.ToString("yyyy-MM-dd HH:mm:ss");
  953. joCheck.medfee_sumamt = dt.Rows[i]["medfee_sumamt"].ToString();
  954. joCheck.fund_pay_sumamt = dt.Rows[i]["fund_pay_sumamt"].ToString();
  955. joCheck.cash_payamt = dt.Rows[i]["cash_payamt"].ToString();
  956. joCheck.fixmedins_setl_cnt = dt.Rows[i]["fixmedins_setl_cnt"].ToString();
  957. JObject joData = new JObject();
  958. joData.Add("data", joCheck);
  959. InvokeHelper invoker = new InvokeHelper();
  960. JObject jo3202Rtn = invoker.invokeCenterService(TradeEnum.FeeDetailCheck, joData);
  961. if (JsonHelper.parseCenterReturnJson(jo3202Rtn, out outParam) != 0)
  962. {
  963. return -1;
  964. }
  965. else
  966. {
  967. outParam = JsonHelper.getDestValue(jo3202Rtn, "output.fileinfo.file_qury_no");
  968. fileName = JsonHelper.getDestValue(jo3202Rtn, "output.fileinfo.filename");
  969. return 0;
  970. }
  971. }
  972. catch (Exception ex)
  973. {
  974. outParam = "checkDetail:" + ex.Message;
  975. return -1;
  976. }
  977. }
  978. private int downloadZIP(string file_qury_no, string fileName, out string outParam)
  979. {
  980. outParam = "";
  981. try
  982. {
  983. JObject joTmp = new JObject();
  984. joTmp = new JObject();
  985. joTmp.Add("file_qury_no", file_qury_no.Replace(@"\\", @"\"));
  986. joTmp.Add("filename", fileName);
  987. joTmp.Add("fixmedins_code", Global.inf.hospitalNO);
  988. JObject joFsDownloadIn = new JObject();
  989. joFsDownloadIn.Add("fsDownloadIn", joTmp);
  990. InvokeHelper invoker = new InvokeHelper();
  991. JObject jo9102Rtn = invoker.DownloadCenterFile(JsonHelper.setCenterInpar("9102", joFsDownloadIn).ToString());
  992. string error = "";
  993. if (JsonHelper.parseIrisRtnValue(jo9102Rtn, out error) != 0)
  994. {
  995. outParam = error;
  996. return -1;
  997. }
  998. else
  999. {
  1000. outParam = JsonHelper.getDestValue(jo9102Rtn, "filePath");
  1001. return 0;
  1002. }
  1003. }
  1004. catch (Exception ex)
  1005. {
  1006. outParam = "downloadZIP:" + ex.Message;
  1007. return -1;
  1008. }
  1009. }
  1010. private int importToDgvCenterSetlRec(string fileName, string zipFilePath, out string outParam)
  1011. {
  1012. outParam = "";
  1013. try
  1014. {
  1015. string dir = fileName.Substring(1, fileName.Length - 4);
  1016. //解压缩
  1017. string txtFileDir = System.Environment.CurrentDirectory + "\\Download\\" + dir;
  1018. string txtFilePath = zipFilePath.Substring(0, zipFilePath.Length - 4);
  1019. if (File.Exists(txtFilePath))
  1020. {
  1021. File.Delete(txtFilePath);
  1022. }
  1023. if (!Directory.Exists(txtFileDir))
  1024. {
  1025. Directory.CreateDirectory(txtFileDir);
  1026. }
  1027. ZipFile.ExtractToDirectory(zipFilePath, txtFileDir);
  1028. //导入文件
  1029. GridViewSetter grd = new GridViewSetter();
  1030. grd.SetHeaderTextOfDgvCenterSetlRec(dgvCenterSettlRec);
  1031. //txtFileDir = txtFileDir;//E:\GHSF\SCYBDownLoad\result.txt
  1032. string[] lines = System.IO.File.ReadAllLines(txtFileDir + "\\result.txt");
  1033. DataTable dt = new DataTable();
  1034. dt.Columns.Add("sn", typeof(int));
  1035. dt.Columns.Add("psn_no", typeof(string));
  1036. dt.Columns.Add("mdtrt_id", typeof(string));
  1037. dt.Columns.Add("setl_id", typeof(string));
  1038. dt.Columns.Add("msgid", typeof(string));
  1039. dt.Columns.Add("stmt_rslt", typeof(string));
  1040. dt.Columns.Add("refd_setl_flag", typeof(string));
  1041. dt.Columns.Add("memo", typeof(string));
  1042. dt.Columns.Add("medfee_sumamt", typeof(string));
  1043. dt.Columns.Add("fund_pay_sumamt", typeof(string));
  1044. dt.Columns.Add("acct_pay", typeof(string));
  1045. //foreach (string line in lines)
  1046. for (int i = 0; i < lines.Length; i++)
  1047. {
  1048. string[] strs = (lines[i] + "\t").Split('\t');
  1049. DataRow dr = dt.NewRow();
  1050. //Global.inf.writeLog(lines[i].ToString());
  1051. //Global.inf.writeLog(strs.Length.ToString());
  1052. dr["sn"] = i + 1;
  1053. dr["psn_no"] = strs[0];
  1054. dr["mdtrt_id"] = strs[1];
  1055. dr["setl_id"] = strs[2];
  1056. dr["msgid"] = strs[3];
  1057. dr["stmt_rslt"] = strs[4];
  1058. dr["refd_setl_flag"] = strs[5];
  1059. dr["memo"] = strs[6];
  1060. dr["medfee_sumamt"] = strs[7];
  1061. dr["fund_pay_sumamt"] = strs[8];
  1062. dr["acct_pay"] = strs[9];
  1063. //dr["Field2"] = strs[2];
  1064. dt.Rows.Add(dr);
  1065. }
  1066. dgvCenterSettlRec.DataSource = dt;
  1067. return 0;
  1068. }
  1069. catch (Exception ex)
  1070. {
  1071. outParam = "importToDgvCenterSetlRec:" + ex.Message;
  1072. return -1;
  1073. }
  1074. }
  1075. private int CheckDetail_Single(out string outParam)
  1076. {
  1077. outParam = "";
  1078. //先签到
  1079. CenterBusiness cBus = new CenterBusiness();
  1080. JObject jo9001Rtn = new JObject();
  1081. cBus.signIn(out jo9001Rtn);
  1082. try
  1083. {
  1084. //导出并压缩
  1085. if (exportAndCompress(out outParam) != 0)
  1086. {
  1087. return -1;
  1088. }
  1089. string zipPath = outParam;
  1090. Global.writeLog("exportAndCompress:" + zipPath);
  1091. //上传给中心,
  1092. if (uploadFileToCenter(zipPath, out outParam) != 0)
  1093. {
  1094. return -1;
  1095. }
  1096. Global.writeLog("uploadFileToCenter:" + outParam);
  1097. string file_query_no = outParam;
  1098. string fileName = "";
  1099. //3202明细对账 输出查询号和文件名
  1100. if (checkDetail(file_query_no, out outParam, out fileName) != 0)
  1101. {
  1102. return -1;
  1103. }
  1104. file_query_no = outParam;
  1105. Global.writeLog("checkDetail:" + outParam + "///" + fileName);
  1106. //下载 获取 查询号和文件名后 下载
  1107. if (downloadZIP(file_query_no, fileName, out outParam) != 0)
  1108. {
  1109. return -1;
  1110. }
  1111. zipPath = outParam;
  1112. Global.writeLog("downloadZIP:" + outParam);
  1113. //导入DGV
  1114. if (importToDgvCenterSetlRec(fileName, zipPath, out outParam) != 0)
  1115. {
  1116. return -1;
  1117. }
  1118. Global.writeLog("importToDgvCenterSetlRec:" + outParam);
  1119. return 0;
  1120. }
  1121. catch (Exception ex)
  1122. {
  1123. outParam = "CheckDetail_Single:" + ex.Message;
  1124. return -1;
  1125. }
  1126. }
  1127. private void dgvRowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e)
  1128. {
  1129. DataGridView dgv = (DataGridView)sender;
  1130. dgv.RowHeadersWidth = 60;
  1131. if (dgv.Rows.Count > 1)
  1132. e.Row.HeaderCell.Value = string.Format("{0}", e.Row.Index + 1);
  1133. }
  1134. private void dgvSettlSummary_RowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e)
  1135. {
  1136. if (dgvSettlSummary.Rows.Count > 1)
  1137. e.Row.HeaderCell.Value = string.Format("{0}", e.Row.Index + 1);
  1138. }
  1139. private void dgvHisSettlRec_RowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e)
  1140. {
  1141. if (dgvHisSettlRec.Rows.Count > 1)
  1142. e.Row.HeaderCell.Value = string.Format("{0}", e.Row.Index + 1);
  1143. }
  1144. private int compareDataGridView(string value, string colName, Sunny.UI.UIDataGridView dgv)
  1145. {
  1146. try
  1147. {
  1148. for (int i = 0; i < dgv.RowCount; i++)
  1149. {
  1150. if (dgv.Rows[i].Cells[colName].Value.ToString() == value)
  1151. {
  1152. return 0;
  1153. }
  1154. }
  1155. return -1;
  1156. }
  1157. catch (Exception ex)
  1158. {
  1159. MessageBox.Show("compareDataGridView" + ex.Message);
  1160. return -1;
  1161. }
  1162. }
  1163. private void tsmAICheck_Click(object sender, EventArgs e)
  1164. {
  1165. for (int i = 0; i < dgvHisSettlRec.RowCount; i++)
  1166. {
  1167. string value = dgvHisSettlRec.Rows[i].Cells["SettlementID"].Value.ToString();
  1168. string colName = "setl_id";
  1169. if (compareDataGridView(value, colName, dgvCenterSettlRec) != 0)
  1170. {
  1171. dgvHisSettlRec.Rows[i].DefaultCellStyle.BackColor = Color.Red;
  1172. rtbCheckDetailLog.AppendText("HIS结算ID:" + value + "在中心明细中未找到数据!" + "\r\n");
  1173. }
  1174. }
  1175. for (int i = 0; i < dgvCenterSettlRec.RowCount; i++)
  1176. {
  1177. string value = dgvCenterSettlRec.Rows[i].Cells["setl_id"].Value.ToString();
  1178. string colName = "SettlementID";
  1179. if (compareDataGridView(value, colName, dgvHisSettlRec) != 0)
  1180. {
  1181. dgvCenterSettlRec.Rows[i].DefaultCellStyle.BackColor = Color.Red;
  1182. rtbCheckDetailLog.AppendText("中心结算ID:" + value + "在HIS明细中未找到数据!" + "\r\n");
  1183. }
  1184. }
  1185. }
  1186. private void btnAddOneDay_Click(object sender, EventArgs e)
  1187. {
  1188. dpST.Value = dpST.Value.AddDays(1);
  1189. dpED.Value = dpED.Value.AddDays(1);
  1190. }
  1191. private void btnReduceOndDay_Click(object sender, EventArgs e)
  1192. {
  1193. dpST.Value = dpST.Value.AddDays(-1);
  1194. dpED.Value = dpED.Value.AddDays(-1);
  1195. }
  1196. private void Clearing1()
  1197. {
  1198. //组织入参,进行中心清算
  1199. int i = dgvSettlSummary.CurrentRow.Index;
  1200. DataTable dt = (DataTable)dgvSettlSummary.DataSource;
  1201. JObject joData = new JObject();
  1202. joData.Add("", dgvSettlSummary.CurrentRow.Cells[""].Value.ToString());
  1203. //存到医保平台
  1204. }
  1205. private void btnQueryClrSum_Click(object sender, EventArgs e)
  1206. {
  1207. DataTable dtInteface = (DataTable)cbInterface_2.DataSource;
  1208. int i = cbInterface_2.SelectedIndex;
  1209. string sqlStr = " SELECT SUM(Billtype*Sumamt) AS medfee_sumamt,SUM(Billtype*(0.00+FundPaySumamt+AccountPaySumamt+PersonCashPay)) AS med_sumfee, "
  1210. + " SUM(billtype*PersonCashPay) AS cash_payamt,count(*) AS psntime, ";
  1211. sqlStr = sqlStr + " SUM(billtype*AccountPaySumamt) AS acct_pay,SUM(Billtype*(0.00+FundPaySumamt+AccountPaySumamt)) AS fund_appy_sum, ";
  1212. sqlStr = sqlStr + " ClearingType as clr_type,ClearingWay as clr_way,Interface_Dr,ClearingOrgan as clr_optins ";
  1213. sqlStr = sqlStr + " FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + dtInteface.Rows[i]["HospitalDr"].ToString();
  1214. sqlStr = sqlStr + " and OccurTime>'" + dpST_2.Text + "'";
  1215. sqlStr = sqlStr + " and OccurTime<'" + dpED_2.Text + "'";
  1216. if (cbInterface_2.Text != "")
  1217. {
  1218. sqlStr = sqlStr + " and Interface_dr =" + dtInteface.Rows[i]["ID"].ToString();
  1219. }
  1220. if (cbInsutype_2.Text != "")
  1221. {
  1222. sqlStr = sqlStr + " and InsuranceType ='" + cbInsutype_2.SelectedValue + "'";
  1223. }
  1224. if (cbClrType_2.Text != "")
  1225. {
  1226. sqlStr = sqlStr + " and ClearingType ='" + cbClrType_2.SelectedValue + "'";
  1227. }
  1228. if (tbSettlOption_2.Text != "")
  1229. {
  1230. sqlStr = sqlStr + " and ClearingOrgan ='" + tbSettlOption_2.Text + "'";
  1231. }
  1232. if (cbClrWay_2.Text != "")
  1233. {
  1234. sqlStr = sqlStr + " and ClearingWay ='" + cbClrWay_2.SelectedValue + "'";
  1235. }
  1236. if (cbValid_2.SelectedIndex != 0)
  1237. {
  1238. if (cbValid_2.SelectedIndex == 1)
  1239. { sqlStr = sqlStr + " and ValidFlag =1"; }
  1240. else
  1241. sqlStr = sqlStr + " and ValidFlag =-1";
  1242. }
  1243. //省医保本地
  1244. //if ((Global.inf.interfaceDr == 10) && (cbOtherPlaceFlag.SelectedIndex == 2))
  1245. //{
  1246. // sqlStr = sqlStr + " and (left(InsuranceAreaCode,4)='4101' or left(InsuranceAreaCode,4)='4199')";
  1247. //}
  1248. ////省医保异地
  1249. //if ((Global.inf.interfaceDr == 10) && (cbOtherPlaceFlag.SelectedIndex == 1))
  1250. //{
  1251. // sqlStr = sqlStr + " and (left(InsuranceAreaCode,4)<>'4199' and left(InsuranceAreaCode,4)<>'4101')";
  1252. //}
  1253. sqlStr = sqlStr + " Group By Interface_Dr,ClearingType,ClearingWay,ClearingOrgan";
  1254. JObject joSqlstr = new JObject();
  1255. joSqlstr.Add("sqlStr", sqlStr);
  1256. JArray jaParam = new JArray();
  1257. jaParam.Add(joSqlstr);
  1258. JObject joSettlQuery = new JObject();
  1259. joSettlQuery.Add("params", jaParam);
  1260. joSettlQuery.Add("code", "09010068");
  1261. InvokeHelper invoker = new InvokeHelper();
  1262. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询汇总结算信息(清算)");
  1263. DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  1264. dgvClearingSum.DataSource = dt;
  1265. }
  1266. private void tmsClearing_2_Click(object sender, EventArgs e)
  1267. {
  1268. string error = "";
  1269. if ((Global.inf.interfaceDr == 38) && (cbOtherPlaceFlag.SelectedIndex == 1))
  1270. {
  1271. if (OthPlcClearing_Single(out error) != 0)
  1272. {
  1273. MessageBox.Show("异地清算失败:" + error);
  1274. }
  1275. else
  1276. {
  1277. MessageBox.Show("异地清算成功");
  1278. }
  1279. }
  1280. else
  1281. {
  1282. if (Clearing_Single(out error) != 0)
  1283. {
  1284. MessageBox.Show("清算失败:" + error);
  1285. }
  1286. else
  1287. {
  1288. MessageBox.Show("清算成功");
  1289. }
  1290. }
  1291. }
  1292. private void btnClose_3_Click(object sender, EventArgs e)
  1293. {
  1294. }
  1295. private void btnQueryClearing_Click(object sender, EventArgs e)
  1296. {
  1297. DataTable dtInteface = (DataTable)cbInterface_3.DataSource;
  1298. int i = cbInterface_3.SelectedIndex;
  1299. string sqlStr = "SELECT * from BS_MedInsuClearingRecord where Hosp_Dr=" + dtInteface.Rows[i]["HospitalDr"].ToString(); ;
  1300. sqlStr = sqlStr + " and interface_Dr =" + dtInteface.Rows[i]["ID"].ToString();
  1301. if (rbgTimeWay.SelectedIndex == 0)
  1302. {
  1303. sqlStr = sqlStr + " and OccurTime>'" + dpST_3.Value.ToString("yyyy-MM-dd 00:00:00") + "'";
  1304. sqlStr = sqlStr + " and OccurTime<'" + dpED_3.Value.ToString("yyyy-MM-dd 23:59:59") + "'";
  1305. }
  1306. else
  1307. {
  1308. sqlStr = sqlStr + " and Begndate>='" + dpST_3.Value.ToString("yyyy-MM-dd 00:00:00") + "'";
  1309. sqlStr = sqlStr + " and Enddate<='" + dpED_3.Value.ToString("yyyy-MM-dd 23:59:59") + "'";
  1310. }
  1311. if (cbValid_3.SelectedIndex != 0)
  1312. {
  1313. if (cbValid_3.SelectedIndex == 1)
  1314. { sqlStr = sqlStr + " and ValidFlag =1"; }
  1315. else
  1316. sqlStr = sqlStr + " and ValidFlag =-1";
  1317. }
  1318. JObject joSqlstr = new JObject();
  1319. joSqlstr.Add("sqlStr", sqlStr);
  1320. JArray jaParam = new JArray();
  1321. jaParam.Add(joSqlstr);
  1322. JObject joSettlQuery = new JObject();
  1323. joSettlQuery.Add("params", jaParam);
  1324. joSettlQuery.Add("code", "09010069");
  1325. InvokeHelper invoker = new InvokeHelper();
  1326. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询清算信息");
  1327. DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  1328. dgvClearingData.DataSource = dt;
  1329. }
  1330. private void btnCancleClearing_Click(object sender, EventArgs e)
  1331. {
  1332. string error = "";
  1333. if ((Global.inf.interfaceDr == 38) && (cbOtherPlaceFlag.SelectedIndex == 1))
  1334. {
  1335. if (CancleOthPlcClearing_Single(out error) != 0)
  1336. {
  1337. MessageBox.Show("异地撤销清算失败:" + error);
  1338. }
  1339. else
  1340. {
  1341. MessageBox.Show("异地撤销清算成功");
  1342. }
  1343. }
  1344. else
  1345. {
  1346. if (CancleClearing_Single(out error) != 0)
  1347. {
  1348. MessageBox.Show("撤销清算失败:" + error);
  1349. }
  1350. else
  1351. {
  1352. MessageBox.Show("撤销清算成功");
  1353. }
  1354. }
  1355. }
  1356. private void btnAddMonth_Click(object sender, EventArgs e)
  1357. {
  1358. dpST_2.Value = dpST_2.Value.AddMonths(1);
  1359. dpED_2.Value = dpST_2.Value.AddDays(1 - dpST_2.Value.Day).AddMonths(1).AddMinutes(-1);
  1360. }
  1361. private void btnReduceMonth_Click(object sender, EventArgs e)
  1362. {
  1363. dpST_2.Value = dpST_2.Value.AddMonths(-1);
  1364. dpED_2.Value = dpST_2.Value.AddDays(1 - dpST_2.Value.Day).AddMonths(1).AddMinutes(-1);
  1365. }
  1366. private void uiButton3_Click(object sender, EventArgs e)
  1367. {
  1368. string sqlStr = "SELECT * ";
  1369. sqlStr = sqlStr + " FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
  1370. sqlStr = sqlStr + " and OccurTime>'" + dpST_O.Text + "'";
  1371. sqlStr = sqlStr + " and OccurTime<'" + dpED_O.Text + "'";
  1372. sqlStr = sqlStr + " and Interface_dr =" + +Global.inf.interfaceDr;
  1373. sqlStr = sqlStr + " and (left(InsuranceAreaCode,2)<>'50')";
  1374. //if (cbxInsuType.Text != "")
  1375. //{
  1376. // sqlStr = sqlStr + " and insutype ='" + cbxInsuType.SelectedValue + "'";
  1377. //}
  1378. if (cbxClrType_O.Text != "")
  1379. {
  1380. sqlStr = sqlStr + " and ClearingType ='" + cbxClrType_O.SelectedValue + "'";
  1381. }
  1382. //if (tbSettlOption.Text != "")
  1383. //{
  1384. // sqlStr = sqlStr + " and ClearingOrgan ='" + tbSettlOption.Text + "'";
  1385. //}
  1386. if (cbxValid_O.SelectedIndex != 0)
  1387. {
  1388. if (cbxValid_O.SelectedIndex == 1)
  1389. { sqlStr = sqlStr + " and ValidFlag =1"; }
  1390. else
  1391. sqlStr = sqlStr + " and ValidFlag =-1";
  1392. }
  1393. JObject joSqlstr = new JObject();
  1394. joSqlstr.Add("sqlStr", sqlStr);
  1395. JArray jaParam = new JArray();
  1396. jaParam.Add(joSqlstr);
  1397. JObject joSettlQuery = new JObject();
  1398. joSettlQuery.Add("params", jaParam);
  1399. joSettlQuery.Add("code", "09010059");
  1400. InvokeHelper invoker = new InvokeHelper();
  1401. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");
  1402. //DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  1403. DataTable dt = (DataTable)JsonConvert.DeserializeObject(joRtn["result"]["data"].ToString(), (typeof(DataTable)));
  1404. //DataTable dtResult = new DataTable();
  1405. ////克隆表结构
  1406. //dtResult = dt.Clone();
  1407. //foreach (DataColumn col in dtResult.Columns)
  1408. //{
  1409. // if (col.ColumnName == "BillID")
  1410. // {
  1411. // //修改列类型
  1412. // col.DataType = typeof(string);
  1413. // }
  1414. // if (col.ColumnName == "RecordID")
  1415. // {
  1416. // //修改列类型
  1417. // col.DataType = typeof(string);
  1418. // }
  1419. //}
  1420. //foreach (DataRow row in dt.Rows)
  1421. //{
  1422. // DataRow newDtRow = dtResult.NewRow();
  1423. // foreach (DataColumn column in dt.Columns)
  1424. // {
  1425. // if (column.ColumnName == "BillID")
  1426. // {
  1427. // MessageBox.Show("cs1:" + column.ColumnName + row[column.ColumnName].ToString());
  1428. // newDtRow[column.ColumnName] = Convert.ToString(row[column.ColumnName]);
  1429. // }
  1430. // else
  1431. // {
  1432. // newDtRow[column.ColumnName] = row[column.ColumnName];
  1433. // }
  1434. // }
  1435. // dtResult.Rows.Add(newDtRow);
  1436. //}
  1437. dgvOthCheck.DataSource = dt;
  1438. }
  1439. private void tsmOthPlcCheck_Click(object sender, EventArgs e)
  1440. {
  1441. string error = "";
  1442. if (OthPlcCheck_Single(out error) != 0)
  1443. {
  1444. MessageBox.Show("对账失败:" + error);
  1445. }
  1446. else
  1447. {
  1448. MessageBox.Show("对账成功");
  1449. }
  1450. }
  1451. private void uiSymbolButton2_Click(object sender, EventArgs e)
  1452. {
  1453. dpST_O.Value = dpST_O.Value.AddDays(1);
  1454. dpED_O.Value = dpED_O.Value.AddDays(1);
  1455. }
  1456. private ArrayList getIndexArray(String inputStr, String findStr)
  1457. {
  1458. ArrayList list = new ArrayList();
  1459. int start = 0;
  1460. while (start < inputStr.Length)
  1461. {
  1462. int index = inputStr.IndexOf(findStr, start);
  1463. if (index >= 0)
  1464. {
  1465. list.Add(index);
  1466. start = index + findStr.Length;
  1467. }
  1468. else
  1469. {
  1470. break;
  1471. }
  1472. }
  1473. return list;
  1474. }
  1475. private void uiButton2_Click(object sender, EventArgs e)
  1476. {
  1477. DataTable dt = (DataTable)dgvOthCheck.DataSource;
  1478. string error = "";
  1479. int failRows = 0;
  1480. for (int i = 0; i < dt.Rows.Count; i++)
  1481. {
  1482. //dgvOthCheck.Rows[i].Selected = true;
  1483. dgvOthCheck.CurrentCell = dgvOthCheck.Rows[i].Cells[0];
  1484. if (OthPlcCheck_Single(out error) != 0)
  1485. {
  1486. string str = "【当前人员】:";
  1487. //Graphics g = this.CreateGraphics();
  1488. //Font font = new Font("宋体", 14, FontStyle.Bold);
  1489. //SolidBrush brush = new SolidBrush(Color.Red);
  1490. //g.DrawString(str, font, brush, 20, 50);
  1491. string patInfo = str + dt.Rows[i]["PatientName"].ToString()
  1492. + ",结算编号:" + dt.Rows[i]["SettlementID"].ToString()
  1493. + ",清算类别:" + dt.Rows[i]["ClearingType"].ToString()
  1494. + ",就诊类别(1门诊2住院):" + dt.Rows[i]["admType"].ToString();
  1495. rtbOthCheckResultRecord.AppendText(patInfo + ";对账失败:" + error + "\r\n");
  1496. failRows++;
  1497. }
  1498. else
  1499. {
  1500. //rtbOthCheckResultRecord.AppendText("当前人员:" + dt.Rows[i]["PatientName"].ToString() + ";对账成功!" + "\r\n");
  1501. }
  1502. }
  1503. if (failRows == 0)
  1504. {
  1505. rtbOthCheckResultRecord.AppendText("当前所有人员对账成功!" + "\r\n");
  1506. }
  1507. else
  1508. {
  1509. string str = "【当前人员】";
  1510. ArrayList list = getIndexArray(rtbOthCheckResultRecord.Text, str);
  1511. for (int i = 0; i < list.Count; i++)
  1512. {
  1513. int index = (int)list[i];
  1514. rtbOthCheckResultRecord.Select(index, str.Length);
  1515. rtbOthCheckResultRecord.SelectionColor = Color.Red;
  1516. Font oldFont = rtbOthCheckResultRecord.SelectionFont;
  1517. Font font = new Font(oldFont, oldFont.Style | FontStyle.Bold);
  1518. rtbOthCheckResultRecord.SelectionFont = font;
  1519. }
  1520. }
  1521. }
  1522. private void tsmHandCheck_Click(object sender, EventArgs e)
  1523. {
  1524. JObject joData = JObject.Parse(rtbCheckDetailLog.Text);
  1525. InvokeHelper invoker = new InvokeHelper();
  1526. JObject joRtn = invoker.invokeCenterService(TradeEnum.FeeSummaryCheck, joData);
  1527. }
  1528. private void btnClose_Click(object sender, EventArgs e)
  1529. {
  1530. Close();
  1531. }
  1532. private void Btn_Query_Click(object sender, EventArgs e)
  1533. {
  1534. DataTable dtInteface = (DataTable)cbxInterface.DataSource;
  1535. int i = cbxInterface.SelectedIndex;
  1536. //乘以单据类型后,IRIS会返回整数,关键不知道SQL里咋转换为浮点数
  1537. //string sqlStr = "SELECT SUM(BillType*Sumamt) AS medfee_sumamt,count(*) AS fixmedins_setl_cnt,SUM(BillType*PersonCashPay) AS cash_payamt, ";
  1538. //sqlStr = sqlStr + " SUM(BillType*AccountPaySumamt) AS acct_pay,SUM(BillType*FundPaySumamt) AS fund_pay_sumamt ";
  1539. //对账时个人账户=个人账户+共济账户
  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+AccountMutualAidAmount)) AS acct_pay,SUM(BillType*FundPaySumamt) AS fund_pay_sumamt ";
  1542. //sqlStr = sqlStr + " Interface_dr,clearingWay AS clr_way,clearingType AS clr_type ";
  1543. // 增加先行自付金额、医疗救助基金、公务员医疗补助、个人账户共济支付、企业补充、职工大额
  1544. 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 ";
  1545. string conditionStr = " Group By";
  1546. if (cbgGroupSet.GetItemCheckState(0))
  1547. {
  1548. sqlStr = sqlStr + ",Interface_Dr";
  1549. conditionStr = conditionStr + " Interface_Dr,";
  1550. }
  1551. if (cbgGroupSet.GetItemCheckState(1))
  1552. {
  1553. sqlStr = sqlStr + ",InsuranceType as insutype";
  1554. conditionStr = conditionStr + " InsuranceType,";
  1555. }
  1556. if (cbgGroupSet.GetItemCheckState(2))
  1557. {
  1558. sqlStr = sqlStr + ",ClearingType as clr_type";
  1559. conditionStr = conditionStr + " ClearingType,";
  1560. }
  1561. if (cbgGroupSet.GetItemCheckState(3))
  1562. {
  1563. sqlStr = sqlStr + ",ClearingOrgan as setl_optins";
  1564. conditionStr = conditionStr + " ClearingOrgan,";
  1565. }
  1566. if (cbgGroupSet.GetItemCheckState(4))
  1567. {
  1568. sqlStr = sqlStr + ",BillType";
  1569. conditionStr = conditionStr + " BillType,";
  1570. }
  1571. sqlStr = sqlStr + " FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
  1572. sqlStr = sqlStr + " and OccurTime>'" + dpST.Text + " 00:00:00'";
  1573. sqlStr = sqlStr + " and OccurTime<'" + dpED.Text + " 23:59:59'";
  1574. if (cbxInterface.Text != "")
  1575. {
  1576. sqlStr = sqlStr + " and Interface_Dr =" + dtInteface.Rows[i]["ID"].ToString();
  1577. }
  1578. if (cbxInsuType.Text != "")
  1579. {
  1580. sqlStr = sqlStr + " and InsuranceType ='" + cbxInsuType.SelectedValue + "'";
  1581. }
  1582. if (cbxClrType.Text != "")
  1583. {
  1584. sqlStr = sqlStr + " and ClearingType ='" + cbxClrType.SelectedValue + "'";
  1585. }
  1586. if (tbSettlOption.Text != "")
  1587. {
  1588. sqlStr = sqlStr + " and ClearingOrgan ='" + tbSettlOption.Text + "'";
  1589. }
  1590. //ValidFlag=1 and BillType=1 表示正常结算记录 ValidFlag=0 and BillType=-1 表示退费记录 ValidFlag=0表示无效记录
  1591. if (cbxValid.SelectedIndex != 0)
  1592. {
  1593. if (cbxValid.SelectedIndex == 1)
  1594. sqlStr = sqlStr + " and ValidFlag =1 and BillType=1";
  1595. else
  1596. sqlStr = sqlStr + " and ValidFlag =0 and BillType=-1";
  1597. }
  1598. //if (Global.inf.interfaceDr == 1)
  1599. //{
  1600. // sqlStr = sqlStr + " and (left(InsuranceAreaCode,4)='6201' or left(InsuranceAreaCode,4)='6299')";
  1601. //}
  1602. //conditionStr = conditionStr.Substring(0,conditionStr.Length -1 );
  1603. conditionStr = conditionStr.Remove(conditionStr.Length - 1, 1);
  1604. sqlStr = sqlStr + conditionStr;
  1605. JObject joSqlstr = new JObject();
  1606. //MessageBox.Show(sqlStr);
  1607. joSqlstr.Add("sqlStr", sqlStr);
  1608. JArray jaParam = new JArray();
  1609. jaParam.Add(joSqlstr);
  1610. JObject joSettlQuery = new JObject();
  1611. joSettlQuery.Add("params", jaParam);
  1612. joSettlQuery.Add("code", "09010061");
  1613. InvokeHelper invoker = new InvokeHelper();
  1614. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询汇总结算信息");
  1615. DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  1616. dgvSettlSummary.DataSource = dt;
  1617. //初始化HIS结算明细View数据
  1618. dgvHisSettlRec.DataSource = null;
  1619. }
  1620. private void btnBatchCheck_Click(object sender, EventArgs e)
  1621. {
  1622. }
  1623. private void cmsClearing_Opening(object sender, CancelEventArgs e)
  1624. {
  1625. }
  1626. private void dgvSettlSummary_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
  1627. {
  1628. string error;
  1629. if (queryHisSettlementInfo(out error) != 0)
  1630. {
  1631. MessageBox.Show(error);
  1632. }
  1633. }
  1634. private void tsmCheck_Batch_Click(object sender, EventArgs e)
  1635. {
  1636. uiButton5_Click(sender, e);
  1637. }
  1638. /// <summary>
  1639. /// 批量对总账
  1640. /// </summary>
  1641. /// <param name="sender"></param>
  1642. /// <param name="e"></param>
  1643. private void uiButton5_Click(object sender, EventArgs e)
  1644. {
  1645. string errMsg = "";
  1646. bool success = true;
  1647. for (int i = 0; i < dgvSettlSummary.RowCount; i++)
  1648. {
  1649. dgvSettlSummary.CurrentCell = dgvSettlSummary.Rows[i].Cells[0];
  1650. if (Check_Single(out errMsg) != 0)
  1651. {
  1652. dgvSettlSummary.Rows[i].DefaultCellStyle.BackColor = Color.Red;
  1653. rtbCheckLog.AppendText("第" + (i + 1).ToString() + "条对账失败!" + errMsg + "\r\n");
  1654. success = false;
  1655. }
  1656. }
  1657. if (success)
  1658. {
  1659. MessageBox.Show("批量对账全部成功!");
  1660. }
  1661. else
  1662. {
  1663. MessageBox.Show("部分对账失败,请查看对账结果!");
  1664. }
  1665. }
  1666. private void toolStripMenuItem2_Click(object sender, EventArgs e)
  1667. {
  1668. string error = "";
  1669. if ((Global.inf.interfaceDr == 38) && (cbOtherPlaceFlag.SelectedIndex == 1))
  1670. {
  1671. if (OthPlcClearing_Single(out error) != 0)
  1672. {
  1673. MessageBox.Show("异地清算失败:" + error);
  1674. }
  1675. else
  1676. {
  1677. MessageBox.Show("异地清算成功");
  1678. }
  1679. }
  1680. else
  1681. {
  1682. if (Clearing_Single(out error) != 0)
  1683. {
  1684. MessageBox.Show("清算失败:" + error);
  1685. }
  1686. else
  1687. {
  1688. MessageBox.Show("清算成功");
  1689. }
  1690. }
  1691. }
  1692. private void tmsHisSettlRecord_2_Click(object sender, EventArgs e)
  1693. {
  1694. }
  1695. private void btnPatchClr_Click(object sender, EventArgs e)
  1696. {
  1697. }
  1698. }
  1699. }