OPQuerySettlementProcess.cs 1.4 KB

12345678910111213141516171819202122232425262728293031323334
  1. using Newtonsoft.Json.Linq;
  2. using PTMedicalInsurance.Helper;
  3. using PTMedicalInsurance.Variables;
  4. using System;
  5. using System.Collections.Generic;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. namespace PTMedicalInsurance.Business
  10. {
  11. class OPQuerySettlementProcess : AbstractProcess
  12. {
  13. public override CallResult Process(JObject input)
  14. {
  15. //查询HIS医保结算记录表获取该病人的参保地
  16. string sqlStr = "SELECT * FROM BS_MedInsuSettlement WHERE billType = 1 and ValidFlag = 1 ";
  17. sqlStr = sqlStr + " AND Hospital_Dr=" + Global.inf.hospitalDr + " AND Interface_Dr=" + Global.inf.interfaceDr;
  18. sqlStr = sqlStr + " AND SettlementID ='" + Global.pat.settlID + "'";
  19. JObject joSql = new JObject();
  20. joSql.Add("sqlStr", sqlStr);
  21. JObject joSettlInfo = mIS.QuerySettlementInfo(joSql);
  22. //if (JsonHelper.parseIrisRtnValue(joSettlInfo, out errMsg) != 0)
  23. //{
  24. // rtnResult = JsonHelper.setExceptionJson(-1, "查询结算信息失败!", errMsg).ToString();
  25. // return rtnResult;
  26. //}
  27. Global.pat.insuplc_admdvs = JsonHelper.getDestValue(joSettlInfo, "result.data[0].insuplc_admdvs");
  28. outParam = JsonHelper.toJsonString(joSettlInfo);
  29. return Success();
  30. }
  31. }
  32. }