| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051 | using Newtonsoft.Json.Linq;using PTMedicalInsurance.Helper;using PTMedicalInsurance.Variables;using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace PTMedicalInsurance.Business{    class IPQuerySettlementProcess : AbstractProcess    {        public override CallResult Process(JObject input)        {            //查询结算表            string sqlStr = "SELECT * FROM  BS_MedInsuSettlement WHERE billType = 1 and Hospital_Dr=" + Global.inf.hospitalDr                          + " and Adm_Dr='" + Global.pat.adm_Dr + "'"                          + " and MdtrtID='" + Global.pat.mdtrtID + "'"                          + " Order By ID DESC ";            JObject joSql = new JObject();            joSql.Add("sqlStr", sqlStr);            JObject joSettlInfo = mIS.QuerySettlementInfo(joSql);            //if (JsonHelper.parseIrisRtnValue(joSettlInfo, out errMsg) != 0)            //{            //    rtnResult = JsonHelper.setExceptionJson(-1, "查询结算信息失败!", errMsg).ToString();            //    return rtnResult;            //}            //MessageBox.Show(joSettlInfo.ToString());            Global.pat.insuplc_admdvs = JsonHelper.getDestValue(joSettlInfo, "result.data[0].insuplc_admdvs");            Global.pat.SettID_YBJSB = JsonHelper.getDestValue(joSettlInfo, "result.data[0].SettlementID");            //if (Global.pat.settlID != Global.pat.SettID_YBJSB)            //{            //    rtnResult = JsonHelper.setExceptionJson(-1, "Settlement 交易", "通过09010059服务获取到的SettlementID<" + Global.pat.settlID + ">与DLL通过SQL语句" +            //joSql + ",获取到的SettlementID<" + Global.pat.SettID_YBJSB + ">不同,可能存在HIS单边账,请联系医保开发人员处理该笔结算记录!").ToString();            //return rtnResult;            //}            if (!string.IsNullOrEmpty(Global.pat.SettID_YBJSB))            {                Global.pat.settlID = Global.pat.SettID_YBJSB;            }            return Success();        }    }}
 |