HandleException.cs 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603
  1. using Newtonsoft.Json.Linq;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.ComponentModel;
  5. using System.Data;
  6. using System.Drawing;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Threading.Tasks;
  10. using System.Windows.Forms;
  11. using PTMedicalInsurance.Common;
  12. using PTMedicalInsurance.Helper;
  13. using PTMedicalInsurance.FormSetter;
  14. using PTMedicalInsurance.Business;
  15. using PTMedicalInsurance.Variables;
  16. using FastReport;
  17. namespace PTMedicalInsurance.Forms
  18. {
  19. public partial class HandleException : Form
  20. {
  21. private int iLog = 0;
  22. private int iSettl = 0;
  23. private int iReg = 0;
  24. //设置业务实例
  25. CenterBusiness cBus = new CenterBusiness();
  26. HisMainBusiness hBus = new HisMainBusiness();
  27. HisIrisServices hIS = new HisIrisServices();
  28. MIIrisServices mIS = new MIIrisServices();
  29. InvokeHelper invoker = new InvokeHelper();
  30. //1.声明自适应类实例
  31. AutoResizeForm asc = new AutoResizeForm();
  32. public HandleException()
  33. {
  34. InitializeComponent();
  35. //this.StartPosition = FormStartPosition.CenterParent;
  36. asc.controllInitializeSize(this);
  37. asc.controlAutoSize(this);
  38. }
  39. private void HandleException_Load(object sender, EventArgs e)
  40. {
  41. dpST_Log.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
  42. dpED_Log.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
  43. dpST_Settl.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
  44. dpED_Settl.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
  45. dpST_OutPatReg.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
  46. dpED_OutPatReg.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
  47. dtSignBegin.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
  48. dtSignEnd.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
  49. dgvSettlRecord.AutoGenerateColumns = false;
  50. GridViewSetter grdSetter = new GridViewSetter();
  51. grdSetter.SetHeaderTextOfSettlList(dgvSettlRecord);
  52. grdSetter.SetHeaderTextOfCenterLog(dgvLog);
  53. grdSetter.SetHeaderTextOfRegister(dgvOutPatReg);
  54. grdSetter.SetHeaderTextOfSign(dgvSignQuery);
  55. rbgAdmType.SelectedIndex = 0;
  56. rbgBillType.SelectedIndex = 1;
  57. }
  58. #region 结算异常
  59. private void btnQuerySettleRec_Click(object sender, EventArgs e)
  60. {
  61. if (tbName.Text == "")
  62. {
  63. MessageBox.Show("请输入患者姓名!");
  64. return;
  65. }
  66. string sqlStr = "SELECT * FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
  67. sqlStr = sqlStr + " and OccurTime>'" + dpST_Settl.Text + "'";
  68. sqlStr = sqlStr + " and OccurTime<'" + dpED_Settl.Text + "'";
  69. if (tbName.Text != "")
  70. {
  71. sqlStr = sqlStr + " and PatientName='" + tbName.Text + "'";
  72. }
  73. if (tbPatSettlID.Text != "")
  74. {
  75. sqlStr = sqlStr + " and SettlementID='" + tbPatSettlID.Text + "'";
  76. }
  77. if (tbHisNO.Text != "")
  78. {
  79. sqlStr = sqlStr + " and Adm_Dr='" + tbHisNO.Text + "'";
  80. }
  81. if (rbgAdmType.SelectedIndex == 1)
  82. {
  83. sqlStr = sqlStr + " and admType=1";
  84. }
  85. if (rbgAdmType.SelectedIndex == 2)
  86. {
  87. sqlStr = sqlStr + " and admType=2";
  88. }
  89. if (rbgBillType.SelectedIndex == 1)
  90. {
  91. sqlStr = sqlStr + " and BillType=1";
  92. }
  93. if (rbgBillType.SelectedIndex == 2)
  94. {
  95. sqlStr = sqlStr + " and BillType=-1";
  96. }
  97. JObject joSqlstr = new JObject();
  98. joSqlstr.Add("sqlStr", sqlStr);
  99. JArray jaParam = new JArray();
  100. jaParam.Add(joSqlstr);
  101. JObject joSettlQuery = new JObject();
  102. joSettlQuery.Add("params", jaParam);
  103. joSettlQuery.Add("code", "09010059");
  104. InvokeHelper invoker = new InvokeHelper();
  105. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");
  106. MessageBox.Show(joRtn.ToString());
  107. MessageBox.Show(joRtn["result"]["data"].ToString());
  108. if (joRtn["result"]["data"].ToString() == "[]")
  109. {
  110. MessageBox.Show("查询结果为空!");
  111. return;
  112. }
  113. DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  114. dgvSettlRecord.DataSource = dt;
  115. }
  116. private void btnReverseBySettl_Click(object sender, EventArgs e)
  117. {
  118. //InvokeHelper invoker = new InvokeHelper();
  119. DataTable dt = (DataTable)dgvSettlRecord.DataSource;
  120. string errorMessage = "";
  121. int a = dgvOutPatReg.CurrentRow.Index;
  122. //Global.inf.patientAreaCode = dt.Rows[a]["insuplc_admdvs"].ToString();
  123. Global.pat.insuplc_admdvs = dt.Rows[a]["insuplc_admdvs"].ToString();
  124. string mdtrt_id = dt.Rows[a]["MdtrtID"].ToString();
  125. string psn_no = dt.Rows[a]["PersonnelNO"].ToString();
  126. string adm_Dr = dt.Rows[a]["AdmID"].ToString();
  127. string setl_id = dt.Rows[a]["SettlementID"].ToString();
  128. JObject joInparam = new JObject();
  129. JObject joData = new JObject();
  130. joData.Add("omsgid", dt.Rows[a]["msgid"].ToString());
  131. joData.Add("psn_no", dt.Rows[a]["PersonnelNO"].ToString());
  132. string infno = "";
  133. if (dt.Rows[a]["infno"].ToString() == "1") infno = "2207";
  134. if (dt.Rows[a]["infno"].ToString() == "2") infno = "2304";
  135. joData.Add("oinfno", infno);
  136. joInparam.Add("data", joData);
  137. MessageBox.Show(joInparam.ToString());
  138. JObject joRtn = invoker.invokeCenterService("2601", JsonHelper.setCenterInpar("2601", joInparam.ToString()));
  139. //将中心返回的结果返回HIS 调用HIS服务进行保存
  140. if (JsonHelper.parseIrisRtnValue(joRtn, out errorMessage) != 0)
  141. {
  142. MessageBox.Show("冲正失败:" + errorMessage);
  143. }
  144. else
  145. {
  146. dynamic joTmp = new JObject();
  147. joTmp.admID = adm_Dr;
  148. joTmp.PersonalNO = psn_no;
  149. joTmp.mdtrt_id = mdtrt_id;
  150. joTmp.setl_id = setl_id;
  151. //JObject jo2305IrisRtn = mIS.cancleSettlement(joTmp);
  152. JObject jo2305IrisRtn = new JObject();
  153. if (JsonHelper.parseIrisRtnValue(jo2305IrisRtn, out errorMessage) != 0)
  154. {
  155. errorMessage = "中心取消结算成功但云HIS平台取消失败,请联系管理员!" + errorMessage;
  156. MessageBox.Show(errorMessage);
  157. }
  158. }
  159. }
  160. private void btCancleSettl_Click(object sender, EventArgs e)
  161. {
  162. string outParam;
  163. DataTable dt = (DataTable)dgvSettlRecord.DataSource;
  164. string errorMessage = "";
  165. int a = dgvSettlRecord.CurrentRow.Index;
  166. //Global.inf.patientAreaCode = dt.Rows[a]["insuplc_admdvs"].ToString()
  167. MessageBox.Show("111");
  168. Global.pat.insuplc_admdvs = dt.Rows[a]["insuplc_admdvs"].ToString();
  169. MessageBox.Show(dt.Rows[a]["insuplc_admdvs"].ToString());
  170. MessageBox.Show(Global.pat.insuplc_admdvs);
  171. Global.pat.mdtrtID = dt.Rows[a]["MdtrtID"].ToString();
  172. Global.pat.psn_no = dt.Rows[a]["PersonnelNO"].ToString();
  173. Global.pat.settlID = dt.Rows[a]["SettlementID"].ToString();
  174. Global.pat.adm_Dr = int.Parse(dt.Rows[a]["AdmID"].ToString());
  175. //取消中心结算信息
  176. if (cBus.cancleSettlement("2305", out outParam) != 0)
  177. {
  178. MessageBox.Show( "取消中心结算信息失败!" + outParam);
  179. return;
  180. }
  181. else
  182. {
  183. //取消平台结算信息
  184. //if (mIS.cancleSettlement(out outParam) != 0)
  185. if (cBus.cancleSettlement("2305", out outParam) != 0)
  186. {
  187. MessageBox.Show("中心结算取消成功,医保平台结算信息取消失败!" + outParam);
  188. return ;
  189. }
  190. //取消出院登记
  191. if (cBus.cancleRegister("2405", out outParam) != 0)
  192. {
  193. MessageBox.Show("中心,医保平台及HIS结算信息取消成功,取消出院登记失败!请手工取消出院登记!" + outParam);
  194. return ;
  195. }
  196. }
  197. }
  198. #endregion
  199. #region 日志异常
  200. private void btnQueryLog_Click(object sender, EventArgs e)
  201. {
  202. string errMsg;
  203. string sqlStr = "SELECT * FROM BS_MedInsuTransactionLog WHERE Hospital_Dr=" + Global.inf.hospitalDr;
  204. sqlStr = sqlStr + " and InfDate>='" + dpST_Log.Value.ToString("yyyy-MM-dd") + "'";
  205. sqlStr = sqlStr + " and InfDate<='" + dpED_Log.Value.ToString("yyyy-MM-dd") + "'";
  206. if (tbPsnNO.Text != "")
  207. {
  208. sqlStr = sqlStr + " and PSNNO='" + tbPsnNO.Text + "'";
  209. }
  210. if (tbTransNO.Text != "")
  211. {
  212. sqlStr = sqlStr + " and Infno='" + tbTransNO.Text + "'";
  213. }
  214. JObject joSqlstr = new JObject();
  215. joSqlstr.Add("sqlStr", sqlStr);
  216. JObject joRtn = mIS.QueryTransactionLog(joSqlstr);
  217. //if (JsonHelper.parseIrisRtnValue(joRtn, out errMsg) != 0)
  218. //{
  219. // MessageBox.Show(errMsg);
  220. // return;
  221. //}
  222. try
  223. {
  224. if (joRtn["result"]["data"].ToString() == "[]")
  225. {
  226. MessageBox.Show("查询结果为空!");
  227. return;
  228. }
  229. DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  230. dgvLog.DataSource = dt;
  231. }
  232. catch (Exception eX)
  233. {
  234. MessageBox.Show(eX.Message);
  235. }
  236. }
  237. private void btnReverseByLog_Click(object sender, EventArgs e)
  238. {
  239. InvokeHelper invoker = new InvokeHelper();
  240. DataTable dt = (DataTable)dgvLog.DataSource;
  241. JObject joInparam = new JObject();
  242. JObject joData = new JObject();
  243. int a = dgvLog.CurrentRow.Index;
  244. if (tbCBD_Log.Text != "")
  245. { Global.pat.insuplc_admdvs = tbCBD_Log.Text; }
  246. else
  247. Global.pat.insuplc_admdvs = dt.Rows[a]["insuplc_admdvs"].ToString();
  248. joData.Add("omsgid", dt.Rows[a]["msgid"].ToString());
  249. joData.Add("psn_no", dt.Rows[a]["psn_no"].ToString());
  250. joData.Add("oinfno", dt.Rows[a]["infno"].ToString());
  251. //joData.Add("oinfno", "2207");
  252. joInparam.Add("data", joData);
  253. JObject joRtn = invoker.invokeCenterService("2601", JsonHelper.setCenterInpar("2601", joInparam.ToString()));
  254. string errorMessage = "";
  255. if (JsonHelper.parseCenterRtnValue(joRtn, out errorMessage) != 0)
  256. {
  257. MessageBox.Show("冲正失败" + errorMessage);
  258. }
  259. else
  260. {
  261. MessageBox.Show("冲正成功");
  262. }
  263. }
  264. #endregion
  265. #region 手工
  266. private void btPatInfo_ex_Click(object sender, EventArgs e)
  267. {
  268. rtbInparam.Text = @"{""data"":{""omsgid"":""H51010604235202205280848088230"",""psn_no"":""1530541881"",""oinfno"":""2201""}}";
  269. JObject joTmp = JObject.Parse(rtbInparam.Text);
  270. rtbInparam.Text = joTmp.ToString();
  271. }
  272. private void btnPatInfoShow_Click(object sender, EventArgs e)
  273. {
  274. string errorMsg = "";
  275. JObject joRtn = new JObject();
  276. Global.pat.insuplc_admdvs = tbCBD_Hand.Text;
  277. if (tb_DealNo.Text == "6203")
  278. {
  279. //JObject joInpar = new JObject();
  280. //joInpar.Add("payOrdId", "ORD610100202503041842380000145");//支付订单号
  281. //joInpar.Add("appRefdSn", MPat.recordID);//应用退款流水号
  282. //joInpar.Add("appRefdTime", DateTime.Now.ToString("yyyyMMddHHmmss"));//应用退费时间
  283. //joInpar.Add("totlRefdAmt", JsonHelper.getDestValue(joSettl, "Sumamt"));//总退费金额
  284. //joInpar.Add("psnAcctRefdAmt", JsonHelper.getDestValue(joSettl, "AccountPaySumamt"));//医保个人账户支付
  285. //joInpar.Add("fundRefdAmt", JsonHelper.getDestValue(joSettl, "FundPaySumamt"));//基金支付
  286. //joInpar.Add("cashRefdAmt", JsonHelper.getDestValue(joSettl, "PersonCashPay"));//现金退费金额
  287. //joInpar.Add("ecToken", MPat.token);//电子凭证授权Token 前端传入
  288. //joInpar.Add("refdType", "HI");//退费类型 前端传入
  289. //joInpar.Add("expContent", "");//扩展数据 前端传入
  290. //joInpar.Add("payAuthNo", MPat.payAuthNo);//支付授权码 前端传入
  291. JObject jo6203Rtn = invoker.invokeMPService("6203", rtbInparam.Text);
  292. //YH6202
  293. if (JsonHelper.parseMPRtnValue(jo6203Rtn, out errorMsg) != 0)
  294. {
  295. MessageBox.Show(errorMsg);
  296. return;
  297. }
  298. }
  299. else
  300. {
  301. if (Chk_DealNo.Checked)
  302. {
  303. joRtn = invoker.invokeCenterService(tb_DealNo.Text, JsonHelper.setCenterInpar(tb_DealNo.Text, rtbInparam.Text));
  304. }
  305. else
  306. {
  307. joRtn = invoker.invokeCenterService("2601", JsonHelper.setCenterInpar("2601", rtbInparam.Text));
  308. }
  309. if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
  310. {
  311. MessageBox.Show("调用失败:" + errorMsg);
  312. }
  313. else
  314. {
  315. MessageBox.Show("调用成功!:");
  316. rtbOutparam.Text = joRtn.ToString();
  317. }
  318. }
  319. }
  320. #endregion
  321. #region 门诊登记
  322. private void btnQueryOutPatReg_Click(object sender, EventArgs e)
  323. {
  324. string sqlStr = "SELECT * FROM BS_MedInsuRegisterInfo WHERE Type=3 and Hospital_Dr=" + Global.inf.hospitalDr;
  325. sqlStr = sqlStr + " and OccurTime>'" + dpST_OutPatReg.Text + "'";
  326. sqlStr = sqlStr + " and OccurTime<'" + dpED_OutPatReg.Text + "'";
  327. if (tbOutPatName.Text != "")
  328. {
  329. sqlStr = sqlStr + " and Pat_Name='" + tbOutPatName.Text + "'";
  330. }
  331. if (tbOutPatRegID.Text != "")
  332. {
  333. sqlStr = sqlStr + " and InsuRegID='" + tbOutPatRegID.Text + "'";
  334. }
  335. if (tbOutPatPsnNO.Text != "")
  336. {
  337. sqlStr = sqlStr + " and PersonalNO='" + tbOutPatPsnNO.Text + "'";
  338. }
  339. JObject joSqlstr = new JObject();
  340. joSqlstr.Add("sqlStr", sqlStr);
  341. JArray jaParam = new JArray();
  342. jaParam.Add(joSqlstr);
  343. JObject joSettlQuery = new JObject();
  344. joSettlQuery.Add("params", jaParam);
  345. joSettlQuery.Add("code", "09010062");
  346. InvokeHelper invoker = new InvokeHelper();
  347. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询门诊挂号");
  348. try
  349. {
  350. if (joRtn["result"]["data"].ToString() == "[]")
  351. {
  352. MessageBox.Show("查询结果为空!");
  353. return;
  354. }
  355. DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  356. dgvOutPatReg.DataSource = dt;
  357. }
  358. catch (Exception eX)
  359. {
  360. MessageBox.Show(eX.Message);
  361. }
  362. }
  363. private void btnCancleOutPatReg_Click(object sender, EventArgs e)
  364. {
  365. InvokeHelper invoker = new InvokeHelper();
  366. DataTable dt = (DataTable)dgvOutPatReg.DataSource;
  367. string errorMessage = "";
  368. int a = dgvOutPatReg.CurrentRow.Index;
  369. //组织挂号入参
  370. JObject joCancleRegInpar = new JObject();
  371. Global.pat.insuplc_admdvs = dt.Rows[a]["insuplc_admdvs"].ToString();
  372. joCancleRegInpar.Add("psn_no", dt.Rows[a]["PersonalNO"].ToString());
  373. joCancleRegInpar.Add("mdtrt_id", dt.Rows[a]["InsuRegID"].ToString());
  374. joCancleRegInpar.Add("ipt_otp_no", dt.Rows[a]["AdmID"].ToString());
  375. JObject joRegInput = new JObject();
  376. joRegInput.Add("data", joCancleRegInpar);
  377. //取消挂号信息
  378. JObject jo2202Rtn = invoker.invokeCenterService("2202", JsonHelper.setCenterInpar("2202", joRegInput.ToString()));
  379. if (JsonHelper.parseCenterRtnValue(jo2202Rtn, out errorMessage) != 0)
  380. {
  381. MessageBox.Show("取消挂号失败" + errorMessage);
  382. }
  383. else
  384. {
  385. dynamic joTmp = new JObject();
  386. joTmp.admID = dt.Rows[a]["AdmID"].ToString();
  387. joTmp.PersonalNO = dt.Rows[a]["PersonalNO"].ToString();
  388. joTmp.InsuRegID = dt.Rows[a]["InsuRegID"].ToString();
  389. joTmp.Add("billID", "");
  390. joTmp.Type = 3;
  391. joTmp.CancleRegDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  392. JObject jo2404IrisRtn = hIS.cancleRegister(joTmp);
  393. if (JsonHelper.parseIrisRtnValue(jo2404IrisRtn, out errorMessage) != 0)
  394. {
  395. MessageBox.Show(errorMessage);
  396. }
  397. else
  398. {
  399. MessageBox.Show("取消挂号成功");
  400. }
  401. }
  402. }
  403. private void btnCancleOutPatFee_Click(object sender, EventArgs e)
  404. {
  405. InvokeHelper invoker = new InvokeHelper();
  406. DataTable dt = (DataTable)dgvOutPatReg.DataSource;
  407. string errorMessage = "";
  408. int a = dgvOutPatReg.CurrentRow.Index;
  409. Global.pat.insuplc_admdvs = dt.Rows[a]["insuplc_admdvs"].ToString();
  410. string mdtrt_id = dt.Rows[a]["InsuRegID"].ToString();
  411. string psn_no = dt.Rows[a]["PersonalNO"].ToString();
  412. string adm_Dr = dt.Rows[a]["AdmID"].ToString();
  413. //组织入参
  414. dynamic joTmp = new JObject();
  415. joTmp.chrg_bchno = "0000";
  416. joTmp.mdtrt_id = mdtrt_id;
  417. joTmp.psn_no = psn_no;
  418. JObject joData = new JObject();
  419. joData.Add("data", joTmp);
  420. //组织好后上传给中心
  421. JObject joCenterRtn = invoker.invokeCenterService("2205", JsonHelper.setCenterInpar("2205", joData.ToString()));
  422. if (joCenterRtn["infcode"].ToString() == "0")
  423. {
  424. //删除医保传送表的数据
  425. joTmp = new JObject();
  426. joTmp.code = "09010048";
  427. joTmp.HospitalDr = Global.inf.hospitalDr;
  428. joTmp.admID = adm_Dr;
  429. joTmp.mdtrt_id = mdtrt_id;
  430. joTmp.updateUserID = Global.user.ID;
  431. JObject joIris2301DeleteRtn = invoker.invokeInsuService(joTmp.ToString(), "删除门诊明细");
  432. if (JsonHelper.parseCenterRtnValue(joIris2301DeleteRtn, out errorMessage) != 0)
  433. {
  434. MessageBox.Show("取消门诊费用失败" + errorMessage);
  435. }
  436. else
  437. {
  438. MessageBox.Show("取消门诊费用成功");
  439. }
  440. }
  441. else
  442. {
  443. MessageBox.Show("取消门诊费用失败");
  444. }
  445. }
  446. #endregion
  447. private void btnExit_Click(object sender, EventArgs e)
  448. {
  449. Close();
  450. }
  451. private void btnSignQuery_Click(object sender, EventArgs e)
  452. {
  453. string sqlStr = "SELECT Top 50 * FROM HB_MedInsuSignRecord WHERE Hospital_Dr=" + Global.inf.hospitalDr;
  454. sqlStr = sqlStr + " and Interface_Dr=" + Global.inf.interfaceDr;
  455. sqlStr = sqlStr + " and CreateTime>'" + dtSignBegin.Text + "'";
  456. sqlStr = sqlStr + " and CreateTime<'" + dtSignEnd.Text + "'";
  457. if (edtSignNo.Text != "")
  458. {
  459. sqlStr = sqlStr + " and SignNo='" + edtSignNo.Text + "'";
  460. }
  461. if (edtSignOpterNo.Text != "")
  462. {
  463. sqlStr = sqlStr + " and OperatorNO='" + edtSignOpterNo.Text + "'";
  464. }
  465. if (edtOpterName.Text != "")
  466. {
  467. sqlStr = sqlStr + " and OperatorName='" + edtOpterName.Text + "'";
  468. }
  469. sqlStr = sqlStr + " Order By CreateTime DESC ";
  470. JObject joSqlstr = new JObject();
  471. joSqlstr.Add("sqlStr", sqlStr);
  472. JArray jaParam = new JArray();
  473. jaParam.Add(joSqlstr);
  474. JObject joSettlQuery = new JObject();
  475. joSettlQuery.Add("params", jaParam);
  476. joSettlQuery.Add("code", "09010064");
  477. joSettlQuery.Add("queryType", "All");
  478. InvokeHelper invoker = new InvokeHelper();
  479. JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询签到信息");
  480. try
  481. {
  482. if (joRtn["result"]["data"].ToString() == "[]")
  483. {
  484. MessageBox.Show("查询结果为空!");
  485. return;
  486. }
  487. DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
  488. dgvSignQuery.DataSource = dt;
  489. }
  490. catch (Exception eX)
  491. {
  492. MessageBox.Show(eX.Message);
  493. }
  494. }
  495. private void btnCancelSign_Click(object sender, EventArgs e)
  496. {
  497. InvokeHelper invoker = new InvokeHelper();
  498. DataTable dt = (DataTable)dgvSignQuery.DataSource;
  499. string errorMessage = "";
  500. int a = dgvSignQuery.CurrentRow.Index;
  501. if (a <0)
  502. {
  503. MessageBox.Show("请先选中需要签退的签到记录信息!");
  504. return;
  505. }
  506. //组织签退入参
  507. JObject joCancleRegInpar = new JObject();
  508. joCancleRegInpar.Add("sign_no", dt.Rows[a]["SignNo"].ToString());
  509. joCancleRegInpar.Add("opter_no", dt.Rows[a]["OperatorNO"].ToString());
  510. JObject joRegInput = new JObject();
  511. joRegInput.Add("signOut", joCancleRegInpar);
  512. //取消挂号信息
  513. JObject jo9002Rtn = invoker.invokeCenterService("9002", JsonHelper.setCenterInpar("9002", joRegInput.ToString()));
  514. if (JsonHelper.parseCenterRtnValue(jo9002Rtn, out errorMessage) != 0)
  515. {
  516. MessageBox.Show("医保签退失败" + errorMessage);
  517. }
  518. else
  519. {
  520. MessageBox.Show("医保签退成功");
  521. }
  522. }
  523. private void Chk_DealNo_ValueChanged(object sender, bool value)
  524. {
  525. if (Chk_DealNo.Checked)
  526. tb_DealNo.Visible = true;
  527. else
  528. tb_DealNo.Visible = false;
  529. }
  530. }
  531. }