MedicalInsurance/Forms/MedInsuQuery.cs

using Newtonsoft.Json.Linq;
using System;
using System.IO;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using PTMedicalInsurance.Common;
using PTMedicalInsurance.Helper;
using PTMedicalInsurance.FormSetter;
using PTMedicalInsurance.Business;
using PTMedicalInsurance.Variables;



namespace PTMedicalInsurance.Forms
{
    public partial class MedInsuQuery : Form
    {
        DataTable dtExport;
        JObject joRtn10001 = new JObject();
        JObject joInput20002 = new JObject();
        public string patInfo = "", ReadCardOutParam = "", CertNo = "";
        public string presAdmLoc = "", presAdmDoc = "", presAdmID = "", presNo = "", hiRxno = "";
        public string DrCode = "", DrName = "", DrInsuCode = "", DrCertNo = "";
        public string IID;

       //1.声明自适应类实例
       AutoResizeForm asc = new AutoResizeForm();
        private InvokeHelper invoker = new InvokeHelper();
        private HisIrisServices hIS = new HisIrisServices();
        private MIIrisServices mIS = new MIIrisServices();
        HisMainBusiness hBus = new HisMainBusiness();
        CenterBusiness cBus = new CenterBusiness();
        private IrisServices IS = new IrisServices();

        public MedInsuQuery()
        {
            InitializeComponent();

            asc.controllInitializeSize(this);
            asc.controlAutoSize(this);
        }
        public MedInsuQuery(JObject jo)
        {
            InitializeComponent();
            Global.pat.certNO = JsonHelper.getDestValue(jo, "idNo");
             IID = JsonHelper.getDestValue(jo, "idNo");
            if (!string.IsNullOrEmpty(Global.pat.admID))
            {
                string hisPatBaseInfo = "";

                if (hIS.GetHisPatBaseInfo(out hisPatBaseInfo) != 0)
                {

                }
            }
            //jaVolaItems = JArray.Parse(JsonHelper.getDestValue(jo, "output.result"));
            //dtVolaItems = (DataTable)jo["output"]["result"].ToObject(typeof(DataTable));
            //dgvVolaItems.DataSource = dtVolaItems;
            //grdSetter.SetHeaderTextOfPAIPAVolaItem(dgvVolaItems);
            //tbJrID.Text = JsonHelper.getDestValue(jo, "output.result[0].jr_id");
            //tbRuleID.Text = JsonHelper.getDestValue(jo, "output.result[0].rule_id");
            //tbPatID.Text = JsonHelper.getDestValue(jo, "output.result[0].patn_id");
            //tbMdtrdID.Text = JsonHelper.getDestValue(jo, "output.result[0].mdtrt_id");
            //tbVolaAmt.Text = JsonHelper.getDestValue(jo, "output.result[0].vola_amt");
            //tbVolaAmtStas.Text = JsonHelper.getDestValue(jo, "output.result[0].vola_amt_stas");
            //tbSevDeg.Text = JsonHelper.getDestValue(jo, "output.result[0].sev_deg");
            //tbVolaBhvrType.Text = JsonHelper.getDestValue(jo, "output.result[0].vola_bhvr_type");
            //tbVolaEvid.Text = JsonHelper.getDestValue(jo, "output.result[0].vola_evid");
            //tbRuleName.Text = JsonHelper.getDestValue(jo, "output.result[0].rule_name");
            //rbtVolaContent.Text = JsonHelper.getDestValue(jo, "output.result[0].vola_cont");
        }

        public MedInsuQuery(int iPage)
        {
            InitializeComponent();

            asc.controllInitializeSize(this);
            asc.controlAutoSize(this);

            tbcMain.SelectedIndex = iPage;
        }

        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void MedInsuQuery_Load(object sender, EventArgs e)
        {
            //this.WindowState = FormWindowState.Maximized;

            tbcMain.SelectedIndex = 6;

            dpST.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
            dpED.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");

            dt_ST.Text = DateTime.Now.ToString("yyyy-MM-01 00:00:00");
            dt_ET.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");

            date_st.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
            date_et.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");

            dtp_st.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
            dtp_et.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");

            dpt_ST.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
            dpt_ET.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");

            dptST2.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
            dptET2.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");

            DT_ST1.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
            DT_ET1.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");

            dptST.Text = DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd 00:00:00");
            dptET.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");

            dtTHSJ.Text = DateTime.Now.ToString();

            // dgvSettlRecord.AutoGenerateColumns = false;
            cbbLevel.SelectedIndex = 0;
            cbbOverPrice.SelectedIndex = 0;

            GridViewSetter grdSetter = new GridViewSetter();
            grdSetter.SetHeaderTextOfMedInsuHosPerInfo(dgvSettlRecord);

            grdSetter.SetHeaderTextOfSettlList(dgvSettlRecord2);

            grdSetter.SetHeaderTextOfSettltMentFeelDetailInfo(dgvInsuFeeUpload);
            grdSetter.DatagridviewColumnWidthAdaptation(dgvInsuFeeUpload);

            grdSetter.SetHeaderTextOfMIPatCurrentInsuInfo(dgv_4001);
            grdSetter.SetHeaderTextOfSettlList(dgvSettleData);
            grdSetter.SetHeaderTextOfSettltMentFeelDetailInfo(dgvFeeInfo);
            grdSetter.SetHeaderTextOfHISRegister(dgv_HISRegInfo);
            grdSetter.SetHeaderTextOfHISPrescFee(dgv_PrescriptionInfo);
            grdSetter.SetHeaderTextOfBillInfo(dgv_BillInfo);
            grdSetter.SetHeaderTextOfBillDetailInfo(dgv_BillDetailInfo);
            grdSetter.SetHeaderTextOf5205DrugDetailInfo(dgv5205);

            grdSetter.DatagridviewColumnWidthAdaptation(dgv_HISRegInfo);
            grdSetter.DatagridviewColumnWidthAdaptation(dgv_PrescriptionInfo);
            grdSetter.DatagridviewColumnWidthAdaptation(dgv_BillInfo);
            grdSetter.DatagridviewColumnWidthAdaptation(dgv_BillDetailInfo);

            grdSetter.DatagridviewColumnWidthAdaptation(dgv5205);

            rbg_Type.SelectedIndex = 0;
            tbJGBM.Text = Global.inf.hospitalNO;
            dtTHSJ.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            rbg_BussnisType.SelectedIndex = 0;

            if (!string.IsNullOrEmpty(IID))
            {
                tbcMain.TabPages.Clear();
                tbcMain.TabPages.Add(tab5205);
            }
            
        }

        private void btnQuery_Click(object sender, EventArgs e)
        {
            btnPrint.Enabled = false;
            string sCZYXM = Global.user.name;

            string SqlHeard = " Adm_Dr,MdtrtID,Name as PatientName,Age,PsnCertNO,Gend,PsnType,EmpName,AdmInDepName,insuplcAdmdvs,sZYZT AS sZTSM, "
                            + " AdmBed,RegDate,MainDiagName,AttendDoctorNO,ChiefPhyDocName,'" + sCZYXM + "' as OpertName,'' as InHospNo,''Address ";

            string SqlStrMain = " SELECT a.*,b.*,a.PatientName AS Name,a.PsnType AS PsnTypeCode,'在院' sZYZT FROM BS_MIPatCurrentInsuInfo a LEFT JOIN BS_MedInsuRegisterInfo b "
                              + " ON a.MdtrtID=b.InsuRegID AND a.Interface_Dr=b.Interface_Dr AND a.Hospital_Dr=b.Hospital_Dr "
                              + " WHERE b.Type=1 AND b.ValidFlag=1 AND b.Hospital_Dr= " + Global.inf.hospitalDr + " AND b.Interface_Dr= " + Global.inf.interfaceDr
                              + " AND b.InsuRegID NOT IN (SELECT MdtrtID FROM BS_MedInsuSettlement WHERE MdtrtID=b.InsuRegID AND BillType=1 AND ValidFlag=1 AND AdmType=2) "
                              + " AND b.RegDate<='" + dpED.Text + "' AND b.RegDate>'" + dpST.Text + "' "  //
                              + " UNION ALL "
                              + " SELECT a.*,b.*,a.PatientName AS Name,a.PsnType AS PsnTypeCode,'已结算' AS sZYZT "
                              + " FROM BS_MIPatCurrentInsuInfo a LEFT JOIN BS_MedInsuRegisterInfo b "
                              + " ON a.MdtrtID=b.InsuRegID AND a.Interface_Dr=b.Interface_Dr AND a.Hospital_Dr=b.Hospital_Dr "
                              + " LEFT JOIN BS_MedInsuSettlement c ON a.MdtrtID=b.InsuRegID AND b.InsuRegID=c.MdtrtID AND a.Interface_Dr=b.Interface_Dr AND b.Interface_Dr=c.Interface_Dr "
                              + " WHERE b.Type=1 AND b.ValidFlag=1 AND c.BillType=1 AND b.Hospital_Dr= " + Global.inf.hospitalDr + " AND b.Interface_Dr= " + Global.inf.interfaceDr
                              + " AND c.AdmType=2 AND c.SettlementDateTime<='" + dpED.Text + "' AND c.SettlementDateTime>'" + dpST.Text + "' ";  //

            string sqlStr = " SELECT " + SqlHeard + " FROM (" + SqlStrMain + ") M ";

            //MessageBox.Show(sqlStr);

            JObject joSqlstr = new JObject();
            joSqlstr.Add("sqlStr", sqlStr);
            joSqlstr.Add("Type", "MedInsuHosPInfo");
            joSqlstr.Add("hospID", Global.inf.hisHospitalDr);
            JArray jaParam = new JArray();
            jaParam.Add(joSqlstr);
            JObject joSettlQuery = new JObject();
            joSettlQuery.Add("params", jaParam);
            joSettlQuery.Add("code", "09010059");

            InvokeHelper invoker = new InvokeHelper();
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");

            //MessageBox.Show(joRtn.ToString());

            if (joRtn["result"]["data"].ToString() == "[]")
            {
                MessageBox.Show("查询结果为空！");
                return;
            }

            DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
            dgvSettlRecord.DataSource = dt;

            if (dt.Rows.Count != 0)
            {
                btnPrint.Enabled = true;
                dtExport = dt;

                //从HIS获取患者的床号（分床前医保登记的病人床号没有写入医保平台登记表）
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string BedNo, BedDocName, InHospNo, Address;
                    JObject joTmp = new JObject();
                    joTmp.Add("admID", dt.Rows[i]["Adm_Dr"].ToString());
                    JObject joRtn2 = invoker.invokeHISService(JsonHelper.setIrisInpar("05110014", joTmp).ToString(), "获取患者就诊信息");
                    if (JsonHelper.parseIrisRtnValue(joRtn2, out string errMsg) == 0)
                    {
                        BedNo = JsonHelper.getDestValue(JObject.Parse(joRtn2.ToString()), "mdtrtinfo.adm_bed");
                        BedDocName = JsonHelper.getDestValue(JObject.Parse(joRtn2.ToString()), "mdtrtinfo.chfpdr_name");
                        InHospNo = JsonHelper.getDestValue(JObject.Parse(joRtn2.ToString()), "mdtrtinfo.medrcdno");
                        Address = JsonHelper.getDestValue(JObject.Parse(joRtn2.ToString()), "mdtrtinfo.Address");
                        dt.Rows[i]["AdmBed"] = BedNo;
                        dt.Rows[i]["AttendDoctorNO"] = BedDocName;
                        dt.Rows[i]["InHospNo"] = InHospNo;
                        dt.Rows[i]["Address"] = Address;
                    }
                    else
                    {
                        if (errMsg.IndexOf("请重新登录") > 0)
                        {
                            MessageBox.Show("获取患者信息失败，请重新登录系统！");
                            break;
                        }
                    }
                }
            }
        }

        private void btnPrint_Click(object sender, EventArgs e)
        {
            string LSH = DateTime.Now.ToString("yyyy-MM-dd"); //DateTime.Now.ToString("MMddHHmmssffff");
            string sFliePathName = @"C:\Users\Administrator\Desktop\" + LSH + "医保在院患者登记或结算信息.xls";
            string ReturnFileName = ExportToExcel.DataTabletoExcel(dtExport, sFliePathName);
            if (ReturnFileName != "")
            {
                MessageBox.Show("导出成功,文件保存路径：【" + ReturnFileName + "】");
                System.Diagnostics.Process.Start(ReturnFileName); //打开excel文件                
            }
            else
            {
                MessageBox.Show("导出失败!");
            }
        }

        private void btnOK_Click(object sender, EventArgs e)
        {
            string sqlStr;
            sqlStr = " SELECT a.Adm_Dr,c.Name, b.HISCode, b.MedInsuNO, b.Price,b.Sumamt,b.ChargeItemLevel,c.ChargeItemLevelName,b.SelfPayProp, ";
            sqlStr = sqlStr + " b.UpLimitAmount,b.OverLimitAmount,b.InScopeAmount,b.FullOwnPayAmount,b.PreSelfPayAmount,b.LimitUsedFlag ";
            sqlStr = sqlStr + " FROM BS_MedInsuSettlement a LEFT JOIN BS_MedInsuFeeUploadRecord b ";
            sqlStr = sqlStr + " ON a.Hospital_Dr=b.Hospital_Dr AND a.MdtrtID=b.MdtrtID AND a.PersonnelNO=b.PersonnelNO ";
            sqlStr = sqlStr + " LEFT JOIN HB_MedInsuDirectory c ON b.MedInsuNO=c.Code AND a.Interface_Dr=c.Interface_Dr AND a.Hospital_Dr=c.Hospital_Dr ";
            sqlStr = sqlStr + " WHERE b.MedInsuNO<>'' and a.ValidFlag=1 AND a.BillType=1 AND a.AdmType=2 ";
            sqlStr = sqlStr + " AND a.Interface_Dr=" + Global.inf.interfaceDr;
            sqlStr = sqlStr + " AND a.Hospital_Dr= " + Global.inf.hospitalDr;
            sqlStr = sqlStr + " AND a.OccurTime>'" + dt_ST.Text + "'";
            sqlStr = sqlStr + " AND a.OccurTime<'" + dt_ET.Text + "'";

            if (tb_InHospNo.Text != "")
            {
                sqlStr = sqlStr + " and a.BillID='" + tb_InHospNo.Text + "'";
            }
            if (tb_SettleID.Text != "")
            {
                sqlStr = sqlStr + " and a.SettlementID='" + tb_SettleID.Text + "'";
            }

            if (cbbOverPrice.Text == "是")
            {
                sqlStr = sqlStr + " AND b.OverLimitAmount>0 ";
            }
            else if (cbbOverPrice.Text == "否")
            {
                sqlStr = sqlStr + " AND b.OverLimitAmount<=0 ";
            }

            if (cbbLevel.Text == "甲类")
            {
                sqlStr = sqlStr + " AND b.ChargeItemLevel='01' ";
            }
            else if (cbbLevel.Text == "乙类")
            {
                sqlStr = sqlStr + " AND b.ChargeItemLevel='02' ";
            }
            else if (cbbLevel.Text == "丙类")
            {
                sqlStr = sqlStr + " AND b.ChargeItemLevel='03' ";
            }

            JObject joSqlstr = new JObject();
            joSqlstr.Add("sqlStr", sqlStr);
            JArray jaParam = new JArray();
            jaParam.Add(joSqlstr);
            JObject joSettlQuery = new JObject();
            joSettlQuery.Add("params", jaParam);
            joSettlQuery.Add("code", "09010118");
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询医保结算费用信息");

            DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
            dgvInsuFeeUpload.DataSource = dt;
        }

        private void uiButton3_Click(object sender, EventArgs e)
        {
            //string sqlStr = " SELECT * FROM  BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
            //sqlStr = sqlStr + " and OccurTime>'" + DT_ST1.Text + "'";
            //sqlStr = sqlStr + " and OccurTime<'" + DT_ET1.Text + "'";
            //sqlStr = sqlStr + " and Interface_Dr=" + Global.inf.interfaceDr + "";
            //sqlStr = sqlStr + " and CertificateNO= " + tb_CertNo.Text;
            //sqlStr = sqlStr + " and BillType=1 and ValidFlag=1 ";

            string sqlstr = " SELECT distinct a.InsuranceAreaCode, b.PersonalNO,b.PsnCertType,b.PsnCertNO,b.PatientName , ";
            sqlstr = sqlstr + " b.Gend,b.Naty,b.Brdy,b.Age,b.Balc,b.Insutype,b.PsnType,b.PsnInsuStas,b.PsnInsuDate, ";
            sqlstr = sqlstr + " b.PausInsuDate,b.Cvlservflag,b.insuplcAdmdvs,b.EmpName ";
            sqlstr = sqlstr + " FROM BS_MedInsuSettlement a ";
            sqlstr = sqlstr + " RIGHT JOIN BS_MIPatCurrentInsuInfo b ";
            sqlstr = sqlstr + " ON a.PersonnelNO=b.PersonalNO AND a.Interface_Dr=b.Interface_Dr ";
            sqlstr = sqlstr + " AND a.PersonType=b.PsnType AND a.InsuranceType=b.Insutype ";
            sqlstr = sqlstr + " WHERE a.ValidFlag=1 AND a.BillType=1 ";
            sqlstr = sqlstr + " and a.OccurTime>'" + DT_ST1.Text + "'";
            sqlstr = sqlstr + " and a.OccurTime<'" + DT_ET1.Text + "'";
            sqlstr = sqlstr + " and a.Interface_Dr='" + Global.inf.interfaceDr + "'";

            if (tb_CertNo.Text != "")
                sqlstr = sqlstr + " and a.CertificateNO='" + tb_CertNo.Text + "'";

            JObject joSqlstr = new JObject();
            joSqlstr.Add("sqlStr", sqlstr);
            joSqlstr.Add("Type", "4001");
            JArray jaParam = new JArray();
            jaParam.Add(joSqlstr);
            JObject joSettlQuery = new JObject();
            joSettlQuery.Add("params", jaParam);
            joSettlQuery.Add("code", "09010059");
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");

            DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
            dgv_4001.DataSource = dt;
        }

        private void uiButton4_Click(object sender, EventArgs e)
        {
            string errorMsg = "";
            if (dgv_4001.CurrentRow == null)
            {
                MessageBox.Show("请查询患者参保信息");
                return;
            }

            int iCenter = dgv_4001.CurrentRow.Index;
            string psn_no = dgv_4001.Rows[iCenter].Cells["PersonalNO"].Value.ToString();
            string psn_cert_type = dgv_4001.Rows[iCenter].Cells["PsnCertType"].Value.ToString();
            string certno = dgv_4001.Rows[iCenter].Cells["PsnCertNO"].Value.ToString();
            string psn_name = dgv_4001.Rows[iCenter].Cells["PatientName"].Value.ToString();
            string gend = dgv_4001.Rows[iCenter].Cells["Gend"].Value.ToString();
            string naty = dgv_4001.Rows[iCenter].Cells["Naty"].Value.ToString();
            string brdy = dgv_4001.Rows[iCenter].Cells["Brdy"].Value.ToString();
            string age = dgv_4001.Rows[iCenter].Cells["Age"].Value.ToString();
            string balc = dgv_4001.Rows[iCenter].Cells["Balc"].Value.ToString();
            string insutype = dgv_4001.Rows[iCenter].Cells["Insutype"].Value.ToString();
            string psn_type = dgv_4001.Rows[iCenter].Cells["PsnType"].Value.ToString();
            string psn_insu_stas = dgv_4001.Rows[iCenter].Cells["PsnInsuStas"].Value.ToString();
            string psn_insu_date = dgv_4001.Rows[iCenter].Cells["PsnInsuDate"].Value.ToString();
            string paus_insu_date = dgv_4001.Rows[iCenter].Cells["PausInsuDate"].Value.ToString();
            string cvlserv_flag = dgv_4001.Rows[iCenter].Cells["Cvlservflag"].Value.ToString();
            string insuplc_admdvs = dgv_4001.Rows[iCenter].Cells["insuplcAdmdvs"].Value.ToString();
            string emp_name = dgv_4001.Rows[iCenter].Cells["EmpName"].Value.ToString();

            JObject joInput = new JObject();
            JObject joData = new JObject();
            joData.Add("psn_no", psn_no);
            joData.Add("psn_cert_type", psn_cert_type);
            joData.Add("certno", certno);
            joData.Add("psn_name", psn_name);
            joData.Add("gend", gend);
            joData.Add("naty", naty);
            joData.Add("brdy", brdy);
            joData.Add("age", age);
            joData.Add("balc", balc);
            joData.Add("insutype", insutype);
            joData.Add("psn_type", psn_type);
            joData.Add("psn_insu_stas", psn_insu_stas);
            joData.Add("psn_insu_date", psn_insu_date);
            joData.Add("paus_insu_date", paus_insu_date);
            joData.Add("cvlserv_flag", cvlserv_flag);
            joData.Add("insuplc_admdvs", insuplc_admdvs);
            joData.Add("emp_name", emp_name);

            joInput.Add("data", joData);

            JObject joRtn = invoker.invokeCenterServiceF("4001", JsonHelper.setCenterInparF("4001", joInput));
            if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
            {
                MessageBox.Show("患者信息上传失败：" + errorMsg);
                return;
            }

            MessageBox.Show("患者信息上传成功");

        }

        private void uiButton7_Click(object sender, EventArgs e)
        {
            string sqlStr = " SELECT * FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
            sqlStr = sqlStr + " and OccurTime>'" + dpt_ST.Text + "'";
            sqlStr = sqlStr + " and OccurTime<'" + dpt_ET.Text + "'";
            sqlStr = sqlStr + " and Interface_Dr=" + Global.inf.interfaceDr + "";
            sqlStr = sqlStr + " and BillType=1 and ValidFlag=1 and ReversalFlag<>1";

            if ((rbg_Type.SelectedIndex == 0) || (rbg_Type.SelectedIndex == 3))
                sqlStr = sqlStr + "and AdmType=1";
            else if ((rbg_Type.SelectedIndex == 1) || (rbg_Type.SelectedIndex == 2))
                sqlStr = sqlStr + "and AdmType=2";

            if (tb_CertNo2.Text != "")
                sqlStr = sqlStr + " and CertificateNO= " + tb_CertNo2.Text;

            JObject joSqlstr = new JObject();
            joSqlstr.Add("sqlStr", sqlStr);

            JArray jaParam = new JArray();
            jaParam.Add(joSqlstr);
            JObject joSettlQuery = new JObject();
            joSettlQuery.Add("params", jaParam);
            joSettlQuery.Add("code", "09010059");
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");

            DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
            dgvSettleData.DataSource = dt;
        }

        private void dgvSettleData_DoubleClick(object sender, EventArgs e)
        {
            uiButton5_Click(sender, e);
        }

        /// <summary>
        /// 上传费用明细
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void uiButton5_Click(object sender, EventArgs e)
        {
            string outParam = "成功", funNO = "";

            if (rbg_Type.SelectedIndex == 0)
                funNO = "4303";
            else if (rbg_Type.SelectedIndex == 1)
                funNO = "4403";
            else if (rbg_Type.SelectedIndex == 2)
                funNO = "4801";
            else if (rbg_Type.SelectedIndex == 3)
                funNO = "4802";

            if (dgvSettleData.CurrentRow == null)
            {
                MessageBox.Show("请先查询患者结算信息");
                return;
            }

            int iCenter = dgvSettleData.CurrentRow.Index;
            Global.pat.mdtrtID = dgvSettleData.Rows[iCenter].Cells["MdtrtID"].Value.ToString();
            Global.pat.medType = dgvSettleData.Rows[iCenter].Cells["MedicalType"].Value.ToString();
            Global.pat.psn_no = dgvSettleData.Rows[iCenter].Cells["PersonnelNO"].Value.ToString();
            Global.pat.adm_Dr = int.Parse(dgvSettleData.Rows[iCenter].Cells["AdmID"].Value.ToString());
            Global.pat.billID = dgvSettleData.Rows[iCenter].Cells["BillID"].Value.ToString();
            Global.pat.recordID = dgvSettleData.Rows[iCenter].Cells["RecordID"].Value.ToString();
            Global.pat.certNO = dgvSettleData.Rows[iCenter].Cells["CertificateNO"].Value.ToString();
            Global.pat.name = dgvSettleData.Rows[iCenter].Cells["PatientName"].Value.ToString();

            Global.pat.brdy = dgvSettleData.Rows[iCenter].Cells["BirthDay"].Value.ToString();
            Global.pat.gend = dgvSettleData.Rows[iCenter].Cells["Gender"].Value.ToString();

            //获取IS费用
            if (hIS.getHisFee(Global.pat, out outParam) != 0)
            {
                MessageBox.Show("获取HIS费用信息失败：" + outParam);
                return;
            }

            //调用医保平台转换HIS费用（转换医保编码等）
            JObject joHisFee = JObject.Parse(outParam);
            if (mIS.convertHisFeeWithInsuCodeHF(joHisFee, out outParam) != 0)
            {
                MessageBox.Show("调用医保平台转换HIS费用（转换医保编码等）失败：" + outParam);
                return;
            }

            JArray jaFeeDetail = JArray.Parse(JsonHelper.getDestValue(JObject.Parse(outParam), "data"));
            //按指定条数分割后上传
            if (uploadFeeToCenter(funNO, 300, jaFeeDetail, out outParam) != 0)
            {
                MessageBox.Show("按指定条数分割后上传失败：" + outParam);
                return;
            }
            else
            {
                MessageBox.Show("上传成功！" + outParam);
                return;
            }

        }

        public int uploadFeeToCenter(string funNO, int singleCount, JArray jaFeeDetail, out string outParam)
        {
            outParam = "";
            string errMsg, type = "feedetail";
            try
            {
                if (rbg_Type.SelectedIndex == 0)
                    type = "outfeedetail";
                else if (rbg_Type.SelectedIndex == 1)
                    type = "feedetail";
                else if (rbg_Type.SelectedIndex == 2)
                    type = "feedetail";
                else if (rbg_Type.SelectedIndex == 3)
                    type = "outfeedetail";

                JArray jaTmp = new JArray();
                for (int i = 0; i < jaFeeDetail.Count; i++)
                {
                    jaFeeDetail[i]["chrg_bchno"] = Global.pat.adm_Dr.ToString();
                    jaFeeDetail[i]["med_type"] = Global.pat.medType;
                    jaFeeDetail[i]["bilg_dept_codg"] = "A10";
                    jaFeeDetail[i]["certno"] = Global.pat.certNO;
                    jaFeeDetail[i]["psn_name"] = Global.pat.name;

                    jaFeeDetail[i]["gend"] = Global.pat.gend;
                    jaFeeDetail[i]["brdy"] = Global.pat.brdy;

                    jaFeeDetail[i]["mdtrt_sn"] = Global.pat.adm_Dr;

                    if (jaFeeDetail[i]["validFlag"].ToString() == "N") continue;
                    jaTmp.Add(jaFeeDetail[i]);
                    if (((i + 1) % singleCount == 0) || ((i + 1) == jaFeeDetail.Count))
                    {
                        JObject joFeeDetail = new JObject();
                        joFeeDetail.Add(type, jaTmp);
                        JObject joRtn = invoker.invokeCenterServiceF(funNO, JsonHelper.setCenterInparF(funNO, joFeeDetail));
                        //if (JsonHelper.parseCenterRtnValue(joRtn, out errMsg) != 0)
                        //{
                        //    outParam = errMsg;
                        //    return -1;
                        //}

                        jaTmp = new JArray();
                    }

                }

                return 0;
            }
            catch (Exception ex)
            {
                outParam = "uploadFee 异常：" + ex.Message;
                return -1;
            }
        }

        private void uiButton16_Click(object sender, EventArgs e)
        {
            string errorMsg;

            try
            {
                if (dgv_HISRegInfo.DataSource == null)
                    return;

                if (dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["ID"].Value.ToString() == "")
                    return;

                presNo = dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["prescNo"].Value.ToString();

                JObject joTmp = new JObject();
                joTmp.Add("startDate", dtp_st.Text);
                joTmp.Add("endDate", dtp_et.Text);
                joTmp.Add("hospCode", JsonHelper.getDestValue((JObject)Global.curEvt.jaSession[0], "hospCode"));
                joTmp.Add("prescNo", presNo); //处方号

                JObject joRtn = invoker.invokeHISService(JsonHelper.setIrisInpar("05110038", joTmp).ToString(), "获取门诊处方风险提示参数");
                if (JsonHelper.parseIrisRtnValue(joRtn, out errorMsg) != 0)
                {
                    MessageBox.Show("获取门诊处方风险提示参数失败，请联系管理员！" + errorMsg);
                    return;
                }
                else
                {
                    if ((joRtn["result"].ToString() == "[]") || (joRtn["result"].ToString() == ""))
                    {
                        MessageBox.Show("调用HIS接口服务05110038获取处方号【" + presNo + "】门诊处方风险提示参数结果为空！");
                        return;
                    }

                    //调用接口上传至中心
                    JObject joInput = new JObject();
                    joInput = JObject.Parse(joRtn["result"][0].ToString());
                    //joInput["treatmentRecord"]["patientinfo"]["psn_no"] = Global.pat.mdtrtID;
                    joInput["treatmentRecord"]["patientinfo"]["brdy"] = joInput["treatmentRecord"]["patientinfo"]["brdy"] + " 00:00:00";

                    JObject joRtn10001 = invoker.invokeCenterServiceF("10001", JsonHelper.setCenterInparF("10001", joInput));
                    if (JsonHelper.parseCenterRtnValue(joRtn10001, out errorMsg) != 0)
                    {
                        MessageBox.Show("门诊处方风险提示上传失败：" + errorMsg);
                        return;
                    }

                    MessageBox.Show("门诊处方风险提示上传成功");
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show("异常：" + ex.Message);
                return;
            }
        }

        /// <summary>
        /// 新华网人员类别与医保人员类别对照关系
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public string GetPsnType(string param)
        {
            if ((param == "11") || (param == "11021") || (param == "11031") ||
                (param == "1101") || (param == "1102") || (param == "1103") ||
                (param == "1111") || (param == "1113") || (param == "116006") ||
                (param == "116011") || (param == "116012") || (param == "116013") ||
                (param == "116014") || (param == "116015") || (param == "116017") ||
                (param == "136046") || (param == "136048") || (param == "136050") ||
                (param == "116018") || (param == "116019") || (param == "116020") ||
                (param == "116021") || (param == "136042") || (param == "136044") ||
                (param == "5005") || (param == "5007") || (param == "5010") ||
                (param == "5011") || (param == "5015") || (param == "5019") ||
                (param == "5022") || (param == "5028") || (param == "5029") ||
                (param == "5032") || (param == "5035") || (param == "5038") ||
                (param == "5041") || (param == "5044") || (param == "5048") ||
                (param == "5050") || (param == "1117") || (param == "1118") ||
                (param == "116041") || (param == "116042") || (param == "116043") ||
                (param == "116044") || (param == "116045") || (param == "116046") ||
                (param == "11032") || (param == "11033") || (param == "11034") ||
                (param == "116047") || (param == "116048") || (param == "116022") ||
                (param == "116031") || (param == "116032") || (param == "116033") ||
                (param == "5053") || (param == "5054") || (param == "5055") ||
                (param == "5059") || (param == "116090") || (param == "116050") ||
                (param == "116051") || (param == "995330"))
                return "1025100"; //在职
            else if ((param == "1105") || (param == "3601") || (param == "3602"))
                return "1025200"; //农民工
            else if ((param == "12") || (param == "1112") || (param == "1201") ||
                (param == "1202") || (param == "1114") || (param == "1203") ||
                (param == "12031") || (param == "136047") || (param == "1205") ||
                (param == "995311") || (param == "136049") || (param == "126001") ||
                (param == "136051") || (param == "126002") || (param == "136052") ||
                (param == "126003") || (param == "126004") || (param == "126009") ||
                (param == "995319") || (param == "126010") || (param == "995307") ||
                (param == "126013") || (param == "126015") || (param == "126016") ||
                (param == "126017") || (param == "126018") || (param == "126019") ||
                (param == "126022") || (param == "136055") || (param == "126023") ||
                (param == "126024") || (param == "126025") || (param == "126026") ||
                (param == "126027") || (param == "136035") || (param == "136039") ||
                (param == "136040") || (param == "136041") || (param == "136043") ||
                (param == "136045") || (param == "126031") || (param == "126032") ||
                (param == "126033") || (param == "5006") || (param == "5008") ||
                (param == "5012") || (param == "5013") || (param == "5016") ||
                (param == "5017") || (param == "5020") || (param == "5023") ||
                (param == "5030") || (param == "5033") || (param == "5036") ||
                (param == "5039") || (param == "5042") || (param == "5045") ||
                (param == "5049") || (param == "5051") || (param == "120701") ||
                (param == "120703") || (param == "120707") || (param == "120708") ||
                (param == "120711") || (param == "120712") || (param == "120715") ||
                (param == "120716") || (param == "120719") || (param == "120720") ||
                (param == "120723") || (param == "120724") || (param == "120727") ||
                (param == "120728") || (param == "120731") || (param == "120733") ||
                (param == "120735") || (param == "120737") || (param == "126041") ||
                (param == "126042") || (param == "126043") || (param == "126044") ||
                (param == "126045") || (param == "126046") || (param == "12032") ||
                (param == "12033") || (param == "12034") || (param == "12035") ||
                (param == "126047") || (param == "126048") || (param == "116088") ||
                (param == "126064") || (param == "126065") || (param == "126117") ||
                (param == "126216") || (param == "126037") || (param == "126067") ||
                (param == "126066") || (param == "126034") || (param == "5056") ||
                (param == "5057") || (param == "5058") || (param == "126316") ||
                (param == "126317") || (param == "5060") || (param == "126090") ||
                (param == "995331"))
                return "1025300"; //退休人员
            else
            if ((param == "13") || (param == "1300") || (param == "1300") ||
                (param == "995309") || (param == "136053") || (param == "136001") ||
                (param == "136002") || (param == "136004") || (param == "136005") ||
                (param == "136006") || (param == "136007") || (param == "136008") ||
                (param == "136009") || (param == "136010") || (param == "136011") ||
                (param == "136012") || (param == "136014") || (param == "136015") ||

                (param == "136016") || (param == "136017") || (param == "136018") ||
                (param == "136019") || (param == "136020") || (param == "136021") ||
                (param == "136022") || (param == "136023") || (param == "136024") ||
                (param == "136090") || (param == "13031") || (param == "136026") ||
                (param == "136029") || (param == "136030") || (param == "136031") ||
                (param == "5001") || (param == "5002") || (param == "5003") ||
                (param == "5004") || (param == "5009") || (param == "5018") ||
                (param == "5021") || (param == "5024") || (param == "5031") ||
                (param == "5034") || (param == "5037") || (param == "5040") ||
                (param == "5043") || (param == "5046") || (param == "5047") ||
                (param == "5052") || (param == "137001") || (param == "137002") ||
                (param == "137003") || (param == "136054") || (param == "130102") ||
                (param == "5088"))
                return "1025400"; //离休
            else
            if ((param == "14") || (param == "1405") || (param == "156006") || (param == "156007"))
                return "1025500"; //居民（未成年）
            else
            if ((param == "1401") || (param == "140101"))
                return "1025600"; //新生儿
            else
            if ((param == "1402"))
                return "1025700"; //学龄前儿童
            else
            if (param == "1403")
                return "1025800"; //中小学生
            else
            if ((param == "1404") || (param == "140890") || (param == "140891") ||
                (param == "156008") || (param == "140401") || (param == "140402") ||
                (param == "140403"))
                return "1025900"; //大学生
            else
            if ((param == "995301") || (param == "1405"))
                return "1025110"; //未成年（未入学）
            else
            if (param == "15")
                return "1025111"; //居民（成年）
            else
            if (param == "1501")
                return "1025112"; //普通居民（成年）
            else
            if ((param == "16") || (param == "160104") || (param == "140805") ||
                (param == "160100") || (param == "160101") || (param == "160102") ||
                (param == "160103"))
                return "1025113"; //居民（老年）          
            else
                return "1025111"; //居民（成年）
        }

        /// <summary>
        /// 根据HIS就诊ID查询患者参保信息
        /// </summary>
        /// <param name="admID"></param>
        /// <param name="errorMsg"></param>
        /// <returns></returns>
        public int GetInsuPersonInfo(string admID, out JObject joRtn, out string errorMsg)
        {
            joRtn = null;
            string sqlstr = " SELECT TOP 1 * FROM BS_MIPatCurrentInsuInfo WHERE AdmID='" + admID + "'";
            sqlstr = sqlstr + " and Interface_Dr='" + Global.inf.interfaceDr + "' ORDER BY ID DESC";
            JObject joSqlstr = new JObject();
            joSqlstr.Add("sqlStr", sqlstr);
            JArray jaParam = new JArray();
            jaParam.Add(joSqlstr);
            JObject joQuery = new JObject();
            joQuery.Add("params", jaParam);
            joQuery.Add("code", "09010082");
            JObject joQueryRtn = invoker.invokeInsuService(joQuery.ToString(), "查询人员参保信息");
            if (JsonHelper.parseIrisRtnValue(joQueryRtn, out errorMsg) != 0)
            {
                MessageBox.Show("查询人员参保信息失败，请联系管理员！" + errorMsg);
                return -1;
            }

            joRtn = joQueryRtn;
            return 0;
        }

        public string GetInsuFeeInfo(string admID, string InsuCode)
        {
            string sqlStr;
            sqlStr = " SELECT admID as Adm_Dr,'' as Name,''as HISCode,MedInsuNO,Price,Sumamt, ";
            sqlStr = sqlStr + " ChargeItemLevel,SelfPayProp,UpLimitAmount,OverLimitAmount,InScopeAmount,";
            sqlStr = sqlStr + " FullOwnPayAmount,PreSelfPayAmount,LimitUsedFlag From BS_MedInsuFeeUploadRecord ";
            sqlStr = sqlStr + " WHERE Hospital_Dr= " + Global.inf.hospitalDr;
            sqlStr = sqlStr + " AND admID='" + admID + "'";
            sqlStr = sqlStr + " AND MedInsuNO='" + InsuCode + "'";

            JObject joSqlstr = new JObject();
            joSqlstr.Add("sqlStr", sqlStr);
            JArray jaParam = new JArray();
            jaParam.Add(joSqlstr);
            JObject joSettlQuery = new JObject();
            joSettlQuery.Add("params", jaParam);
            joSettlQuery.Add("code", "09010118");
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询医保结算费用信息");

            decimal SelfPayProp = decimal.Parse(JsonHelper.getDestValue(joRtn, "result.data[0].SelfPayProp"));

            //1007100-医保个人，1007200-医保统筹，1007300-现金
            if (SelfPayProp == 0)
                return "1007200";
            else
                return "1007300";
        }

        private void uiButton13_Click(object sender, EventArgs e)
        {
            string errorMsg;
            string participateType = "1024200", personnelType;

            if ((dgv_BillInfo.DataSource == null) || (dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["billCode"].Value.ToString() == ""))
            {
                MessageBox.Show("请先查询单据信息!");
                return;
            }

            if ((dgv_BillDetailInfo.DataSource == null) || (dgv_BillDetailInfo.Rows[dgv_BillDetailInfo.CurrentRow.Index].Cells["billID"].Value.ToString() == ""))
            {
                MessageBox.Show("请先查询明细信息!");
                return;
            }

            try
            {
                string entId = dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["entId"].Value.ToString();
                string billCode = dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["billCode"].Value.ToString();
                string billTime = dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["billTime"].Value.ToString();
                string InsuredType = dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["participateType"].Value.ToString(); //险种类型
                string admID = dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["admID"].Value.ToString();

                if (InsuredType.Substring(0, 2) == "31")
                {
                    participateType = "1024100"; //职工
                }
                else if (InsuredType.Substring(0, 2) == "39")
                {
                    participateType = "1024200"; //居民
                }

                //人员类别   
                if (GetInsuPersonInfo(admID, out JObject joQueryRtn, out errorMsg) != 0)
                {
                    MessageBox.Show("查询参保人员信息失败！" + errorMsg);
                    return;
                }

                personnelType = GetPsnType(JsonHelper.getDestValue(joQueryRtn, "result.rows[0].psnType").ToString());

                JObject joData = JObject.Parse(JsonHelper.getDestValue(joInput20002, "result[0]").ToString());
                joData["participateType"] = participateType;
                joData["personnelType"] = personnelType;

                JArray jaFeeDetail = JArray.Parse(JsonHelper.getDestValue(joInput20002, "result[0].detail"));

                //for (int i = 0; i < jaFeeDetail.Count; i++)
                //{
                //    string InsuCode = jaFeeDetail[i]["medicalDrugId"].ToString();                    
                //    if (InsuCode != "未对照")
                //    {
                //        string toPay = GetInsuFeeInfo(admID, InsuCode);
                //    }                    
                //}

                JObject joInput = new JObject();
                joInput.Add("data", joData);

                JObject joRtn = invoker.invokeCenterServiceF("20002", JsonHelper.setCenterInparF("20002", joInput));
                if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
                {
                    MessageBox.Show("事后单据鉴核信息提报失败，中心返回：" + errorMsg);
                    return;
                }

                MessageBox.Show("事后单据鉴核信息提报成功！" + errorMsg);
            }
            catch (Exception ex)
            {
                MessageBox.Show("事后单据鉴核信息提报异常：" + ex.Message);
                return;
            }
        }

        private void dgv_BillInfo_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void uiButton19_Click(object sender, EventArgs e)
        {
            string errorMsg = "";
            if (dgv_4001.CurrentRow == null)
            {
                MessageBox.Show("请查询患者参保信息");
                return;
            }

            for (int i = 0; i < dgv_4001.Rows.Count; i++)
            {
                //int iCenter = dgv_4001.CurrentRow.Index;
                string psn_no = dgv_4001.Rows[i].Cells["PersonalNO"].Value.ToString();
                string psn_cert_type = dgv_4001.Rows[i].Cells["PsnCertType"].Value.ToString();
                string certno = dgv_4001.Rows[i].Cells["PsnCertNO"].Value.ToString();
                string psn_name = dgv_4001.Rows[i].Cells["PatientName"].Value.ToString();
                string gend = dgv_4001.Rows[i].Cells["Gend"].Value.ToString();
                string naty = dgv_4001.Rows[i].Cells["Naty"].Value.ToString();
                string brdy = dgv_4001.Rows[i].Cells["Brdy"].Value.ToString();
                string age = dgv_4001.Rows[i].Cells["Age"].Value.ToString();
                string balc = dgv_4001.Rows[i].Cells["Balc"].Value.ToString();
                string insutype = dgv_4001.Rows[i].Cells["Insutype"].Value.ToString();
                string psn_type = dgv_4001.Rows[i].Cells["PsnType"].Value.ToString();
                string psn_insu_stas = dgv_4001.Rows[i].Cells["PsnInsuStas"].Value.ToString();
                string psn_insu_date = dgv_4001.Rows[i].Cells["PsnInsuDate"].Value.ToString();
                string paus_insu_date = dgv_4001.Rows[i].Cells["PausInsuDate"].Value.ToString();
                string cvlserv_flag = dgv_4001.Rows[i].Cells["Cvlservflag"].Value.ToString();
                string insuplc_admdvs = dgv_4001.Rows[i].Cells["insuplcAdmdvs"].Value.ToString();
                string emp_name = dgv_4001.Rows[i].Cells["EmpName"].Value.ToString();

                JObject joInput = new JObject();
                JObject joData = new JObject();
                joData.Add("psn_no", psn_no);
                joData.Add("psn_cert_type", psn_cert_type);
                joData.Add("certno", certno);
                joData.Add("psn_name", psn_name);
                joData.Add("gend", gend);
                joData.Add("naty", naty);
                joData.Add("brdy", brdy);
                joData.Add("age", age);
                joData.Add("balc", balc);
                joData.Add("insutype", insutype);
                joData.Add("psn_type", psn_type);
                joData.Add("psn_insu_stas", psn_insu_stas);
                joData.Add("psn_insu_date", psn_insu_date);
                joData.Add("paus_insu_date", paus_insu_date);
                joData.Add("cvlserv_flag", cvlserv_flag);
                joData.Add("insuplc_admdvs", insuplc_admdvs);
                joData.Add("emp_name", emp_name);

                joInput.Add("data", joData);

                JObject joRtn = invoker.invokeCenterServiceF("4001", JsonHelper.setCenterInparF("4001", joInput));
                if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
                {
                    MessageBox.Show("患者信息上传失败：" + errorMsg);
                    return;
                }


            }

            MessageBox.Show("患者信息上传成功");
        }

        private void dgvSettleData_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (dgvSettleData.CurrentRow == null)
            {
                MessageBox.Show("请先查询医保结算信息");
                return;
            }

            int iCenter = dgvSettleData.CurrentRow.Index;
            string PersonnelNO = dgvSettleData.Rows[iCenter].Cells["PersonnelNO"].Value.ToString();  //MdtrtID
            string SettlementID = dgvSettleData.Rows[iCenter].Cells["SettlementID"].Value.ToString();
            string MdtrtID = dgvSettleData.Rows[iCenter].Cells["MdtrtID"].Value.ToString();

            string sqlStr;
            sqlStr = " SELECT a.Adm_Dr,c.Name, b.HISCode, b.MedInsuNO, b.Price,b.Sumamt,b.ChargeItemLevel,c.ChargeItemLevelName,b.SelfPayProp, ";
            sqlStr = sqlStr + " b.UpLimitAmount,b.OverLimitAmount,b.InScopeAmount,b.FullOwnPayAmount,b.PreSelfPayAmount,b.LimitUsedFlag ";
            sqlStr = sqlStr + " FROM BS_MedInsuSettlement a LEFT JOIN BS_MedInsuFeeUploadRecord b ";
            sqlStr = sqlStr + " ON a.Hospital_Dr=b.Hospital_Dr AND a.MdtrtID=b.MdtrtID AND a.PersonnelNO=b.PersonnelNO ";
            sqlStr = sqlStr + " LEFT JOIN HB_MedInsuDirectory c ON b.MedInsuNO=c.Code AND a.Interface_Dr=c.Interface_Dr AND a.Hospital_Dr=c.Hospital_Dr ";
            sqlStr = sqlStr + " WHERE b.MedInsuNO<>'' and a.ValidFlag=1 AND a.BillType=1  "; //AND a.AdmType=2
            sqlStr = sqlStr + " AND a.Interface_Dr=" + Global.inf.interfaceDr;
            sqlStr = sqlStr + " AND a.Hospital_Dr= " + Global.inf.hospitalDr;
            sqlStr = sqlStr + " AND a.OccurTime>'" + dpt_ST.Text + "'";
            sqlStr = sqlStr + " AND a.OccurTime<'" + dpt_ET.Text + "'";
            sqlStr = sqlStr + " AND a.PersonnelNO='" + PersonnelNO + "'";
            sqlStr = sqlStr + " AND a.SettlementID='" + SettlementID + "'";
            sqlStr = sqlStr + " AND a.MdtrtID='" + MdtrtID + "'";

            if (tb_CertNo2.Text != "")
                sqlStr = sqlStr + " And a.CertificateNO='" + tb_CertNo2.Text + "' ";

            JObject joSqlstr = new JObject();
            joSqlstr.Add("sqlStr", sqlStr);
            JArray jaParam = new JArray();
            jaParam.Add(joSqlstr);
            JObject joSettlQuery = new JObject();
            joSettlQuery.Add("params", jaParam);
            joSettlQuery.Add("code", "09010118");
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询医保结算费用信息");

            DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
            dgvFeeInfo.DataSource = dt;
        }

        private void uiButton20_Click(object sender, EventArgs e)
        {
            string outParam = "成功", funNO = "";

            if (rbg_Type.SelectedIndex == 0)
                funNO = "4303";
            else if (rbg_Type.SelectedIndex == 1)
                funNO = "4403";
            else if (rbg_Type.SelectedIndex == 2)
                funNO = "4801";
            else if (rbg_Type.SelectedIndex == 3)
                funNO = "4802";

            if (dgvSettleData.CurrentRow == null)
            {
                MessageBox.Show("请先查询患者结算信息");
                return;
            }

            for (int i = 0; i < dgvSettleData.Rows.Count; i++)
            {
                int iCenter = dgvSettleData.CurrentRow.Index;
                Global.pat.mdtrtID = dgvSettleData.Rows[i].Cells["MdtrtID"].Value.ToString();
                Global.pat.medType = dgvSettleData.Rows[i].Cells["MedicalType"].Value.ToString();
                Global.pat.psn_no = dgvSettleData.Rows[i].Cells["PersonnelNO"].Value.ToString();
                Global.pat.adm_Dr = int.Parse(dgvSettleData.Rows[i].Cells["AdmID"].Value.ToString());
                Global.pat.billID = dgvSettleData.Rows[i].Cells["BillID"].Value.ToString();
                Global.pat.recordID = dgvSettleData.Rows[i].Cells["RecordID"].Value.ToString();

                Global.pat.certNO = dgvSettleData.Rows[i].Cells["CertificateNO"].Value.ToString();
                Global.pat.name = dgvSettleData.Rows[i].Cells["PatientName"].Value.ToString();

                Global.pat.brdy = dgvSettleData.Rows[i].Cells["BirthDay"].Value.ToString();
                Global.pat.gend = dgvSettleData.Rows[i].Cells["Gender"].Value.ToString();

                //获取IS费用
                if (hIS.getHisFee(Global.pat, out outParam) != 0)
                {
                    MessageBox.Show("获取HIS费用信息失败：" + outParam);
                    return;
                }

                //调用医保平台转换HIS费用（转换医保编码等）
                JObject joHisFee = JObject.Parse(outParam);
                if (mIS.convertHisFeeWithInsuCodeHF(joHisFee, out outParam) != 0)
                {
                    MessageBox.Show("调用医保平台转换HIS费用（转换医保编码等）失败：" + outParam);
                    return;
                }

                JArray jaFeeDetail = JArray.Parse(JsonHelper.getDestValue(JObject.Parse(outParam), "data"));
                //按指定条数分割后上传
                if (uploadFeeToCenter(funNO, 300, jaFeeDetail, out outParam) != 0)
                {
                    //MessageBox.Show("按指定条数分割后上传失败：" + outParam);
                    //return;
                }
                else
                    continue;
            }

            MessageBox.Show("上传成功！" + outParam);

        }

        private void rbg_Type_ValueChanged(object sender, int index, string text)
        {
            dgvSettleData.DataSource = null;
            dgvFeeInfo.DataSource = null;
        }

        private void uiButton21_Click(object sender, EventArgs e)
        {
            string errorMsg;

            if (dgv_HISRegInfo.DataSource == null)
                return;

            if (dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["ID"].Value.ToString() == "")
                return;

            for (int i = 0; i < dgv_HISRegInfo.Rows.Count; i++)
            {
                presNo = dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["prescNo"].Value.ToString();

                JObject joTmp = new JObject();
                joTmp.Add("startDate", dtp_st.Text);
                joTmp.Add("endDate", dtp_et.Text);
                joTmp.Add("hospCode", JsonHelper.getDestValue((JObject)Global.curEvt.jaSession[0], "hospCode"));
                joTmp.Add("prescNo", presNo); //处方号

                JObject joRtn = invoker.invokeHISService(JsonHelper.setIrisInpar("05110038", joTmp).ToString(), "获取门诊处方风险提示参数");
                if (JsonHelper.parseIrisRtnValue(joRtn, out errorMsg) != 0)
                {
                    MessageBox.Show("获取门诊处方风险提示参数失败，请联系管理员！" + errorMsg);
                    return;
                }
                else
                {
                    if ((joRtn["result"].ToString() == "[]") || (joRtn["result"].ToString() == ""))
                    {
                        MessageBox.Show("调用HIS接口服务05110038获取处方号【" + presNo + "】门诊处方风险提示参数结果为空！！");
                        return;
                    }

                    //调用接口上传至中心
                    JObject joInput = new JObject();
                    joInput = JObject.Parse(joRtn["result"][0].ToString());
                    //joInput["treatmentRecord"]["patientinfo"]["psn_no"] = Global.pat.mdtrtID;
                    joInput["treatmentRecord"]["patientinfo"]["brdy"] = joInput["treatmentRecord"]["patientinfo"]["brdy"] + " 00:00:00";

                    JObject joRtn10001 = invoker.invokeCenterServiceF("10001", JsonHelper.setCenterInparF("10001", joInput));
                    if (JsonHelper.parseCenterRtnValue(joRtn10001, out errorMsg) != 0)
                    {
                        MessageBox.Show("门诊处方风险提示上传失败：" + errorMsg);
                        return;
                    }
                }
            }

            MessageBox.Show("门诊处方风险提示上传成功");
        }

        private void dgv_HISRegInfo_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (dgv_HISRegInfo.DataSource == null)
                return;

            if (dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["ID"].Value.ToString() == "")
                return;

            string outParam = "";
            DataTable dt = null;
            presAdmDoc = dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["doc"].Value.ToString();
            presAdmLoc = dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["loc"].Value.ToString();
            presNo = dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["prescNo"].Value.ToString();
            presAdmID = dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["admID"].Value.ToString();
            Global.pat.adm_Dr = int.Parse(presAdmID);

            if (presNo == "") return;

            //获取HIS处方明细信息
            if (GetHISPrescFeeInfo(presNo, ref outParam, ref dt) != 0)
            {
                MessageBox.Show(outParam);
                return;
            }

            dgv_PrescriptionInfo.DataSource = dt;
        }

        private void dgv_BillInfo_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            string outParam = "";
            DataTable dt = null;
            string errMsg;

            if (dgv_BillInfo.DataSource == null)
                return;

            if (dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["billCode"].Value.ToString() == "")
                return;

            string billID = dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["billCode"].Value.ToString();

            try
            {
                JObject joTmp = new JObject();
                joTmp.Add("startDate", date_st.Text.Substring(0, 10));
                joTmp.Add("endDate", date_et.Text.Substring(0, 10));
                joTmp.Add("hospCode", JsonHelper.getDestValue((JObject)Global.curEvt.jaSession[0], "hospCode"));
                joTmp.Add("billID", billID);

                JObject joRtn = invoker.invokeHISService(JsonHelper.setIrisInpar("05110039", joTmp).ToString(), "组织事后单据鉴核信息填报参数");
                if (JsonHelper.parseIrisRtnValue(joRtn, out errMsg) != 0)
                {
                    MessageBox.Show("组织事后单据鉴核信息填报参数失败，请联系管理员！" + errMsg);
                    return;
                }
                else
                {
                    joInput20002 = joRtn;
                    JObject detail = new JObject();
                    string result = JsonHelper.getDestValue(joRtn, "result[0]").ToString();
                    detail = JObject.Parse(result);
                    dt = (DataTable)detail["detail"].ToObject(typeof(DataTable));
                    dgv_BillDetailInfo.DataSource = dt;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("组织事后单据鉴核信息填报参数异常：" + ex.Message);
                return;
            }
        }

        private void btnReadCard_Click(object sender, EventArgs e)
        {
            string outParam = "", errMsg = "";

            if (hBus.readCard(out outParam) != 0)
            {
                MessageBox.Show("读卡失败！" + outParam);
                return;
            }
            else
            {
                string patInfo = outParam;

                //展示患者信息界面
                if (hBus.showPatInfo(patInfo, out outParam) != 0)
                {
                    MessageBox.Show("参保信息展示异常！" + outParam);
                    return;
                }
                else
                {
                    if (hBus.setGlobalPatAfaterShowPatInfo(outParam, out errMsg) != 0)
                    {
                        MessageBox.Show("setGlobalPatAfaterShowPatInfo全局变量赋值异常！" + errMsg);
                        return;
                    }
                }
            }
        }

        private void btn5205_Click(object sender, EventArgs e)
        {
            string outParam = "", errMsg = "";
            JObject joData = new JObject();
            JObject joInput = new JObject();
            JObject joRtn = new JObject();
            string errorMsg = "";
            
                joData.Add("mdtrt_cert_type", "02");
                joData.Add("mdtrt_cert_no", Global.pat.certNO);
                joData.Add("card_sn","");
                joData.Add("begntime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                joData.Add("psn_cert_type", "01");
                joData.Add("certno", Global.pat.certNO); //证件号码
                joData.Add("psn_name", Global.pat.name);

                joInput.Add("data", joData);

            if (Global.inf.areaCode == "340100")
            {
                Global.inf.interfaceDr = 17;
                Global.inf.areaCode = "340100";
                Global.inf.centerURL = "http://10.67.240.74:8086/1.0.0/hsa-fsi-";
            }else
            {
                Global.inf.interfaceDr = 15;
                Global.inf.areaCode = "349900";
                Global.inf.centerURL = "http://10.66.155.173:8086/1.0.0/hsa-fsi-";
            }
                

                joRtn = invoker.invokeCenterService("1101", JsonHelper.setCenterInpar("1101", joInput));
                if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) == 0)
                {
                    outParam = joRtn.ToString();
                    Global.pat.insuplc_admdvs = JsonHelper.getDestValue(JObject.Parse(outParam), "output.insuinfo.insuplc_admdvs"); //参保地
                    Global.pat.psn_no = JsonHelper.getDestValue(JObject.Parse(outParam), "output.baseinfo.psn_no"); //人员编号
                }
                else
                {
                //joRtn.Add("cardinfo",joCardInfo);


                    if (Global.inf.areaCode == "349900")
                    {
                    Global.inf.interfaceDr = 17;
                    Global.pat.insuplc_admdvs = "340100";
                    Global.inf.areaCode = "340100";
                    Global.inf.centerURL = "http://10.67.240.74:8086/1.0.0/hsa-fsi-";
                    }
                     else
                   {
                    Global.inf.areaCode = "349900";
                    Global.pat.insuplc_admdvs = "349900";
                    Global.inf.centerURL = "http://10.66.155.173:8086/1.0.0/hsa-fsi-";
                    Global.inf.interfaceDr = 15;
                     }


        
                //签到
                if (cBus.signIn(out joRtn) != 0)
                {
                    MessageBox.Show("医保签到异常，请检查医保环境！");
                }
                else
                {
                    Global.curEvt.signno = JsonHelper.getDestValue(joRtn, "output.signinoutb.sign_no");

                    //插入签到表
                    if (mIS.saveSignRecord(Global.curEvt.signno, out errMsg) != 0)
                    {
                        //MessageBox.Show("中心签到成功但插入签到表失败！");
                    }
                    else
                    {
                      //签到成功
                    }
                }




                joRtn = invoker.invokeCenterService("1101", JsonHelper.setCenterInpar("1101", joInput));


                    outParam = joRtn.ToString();
                    Global.pat.insuplc_admdvs = JsonHelper.getDestValue(JObject.Parse(outParam), "output.insuinfo.insuplc_admdvs"); //参保地
                    Global.pat.psn_no = JsonHelper.getDestValue(JObject.Parse(outParam), "output.baseinfo.psn_no"); //人员编号


                }
            

            //if (string.IsNullOrEmpty(Global.pat.psn_no))
            //{
            //    MessageBox.Show("未获取到该患者的医保个人编号，请确认患者建卡信息是否维护身份证号！");
            //    return;
            //}

            JObject joInput1 = new JObject();
            JObject joData1 = new JObject();
            joData1.Add("psn_no", Global.pat.psn_no);
            //joData1.Add("psn_no", "34010000000005004087");//合肥
            //joData1.Add("psn_no", "34990010039324");//省医保
            joData1.Add("begntime", dptST.Text);
            joData1.Add("endtime", dptET.Text);
            joInput1.Add("data", joData1);

            JObject joRtn1 = invoker.invokeCenterService("5205", JsonHelper.setCenterInpar("5205", joInput1));
            if (JsonHelper.parseCenterRtnValue(joRtn, out errMsg) != 0)
            {
                MessageBox.Show("人员慢特病用药记录查询失败：" + errMsg);
                return;
            }
            else
            {
                
            }
            JObject joOutput = JObject.Parse(JsonHelper.getDestValue(joRtn1, "output"));
            JArray joIDInfo = JArray.Parse(JsonHelper.getDestValue(joOutput, "feedetail"));

            if (joIDInfo.Count > 0)
            {
                for (int i = 0; i < joIDInfo.Count; i++)
                {
                    Utils.convertTimestamp((JObject)joIDInfo[i], "fee_ocur_time");
                }
            }
            //dgv5205.DataSource = (DataTable)joRtn["output"]["feedetail"].ToObject(typeof(DataTable));
            dgv5205.DataSource = (DataTable)joIDInfo.ToObject(typeof(DataTable));
        }

        private void btnTotle_Click(object sender, EventArgs e)
        {
            string sqlStr = " SELECT * FROM  BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
            sqlStr = sqlStr + " and AdmType=2 and BillType=1 and ValidFlag=1  ";  //and ValidFlag=1 
            sqlStr = sqlStr + " and OccurTime>'" + dptST2.Text + "'";
            sqlStr = sqlStr + " and OccurTime<'" + dptET2.Text + "'";
            if (tbName.Text != "")
            {
                sqlStr = sqlStr + " and PatientName='" + tbName.Text + "'";
            }
            if (tbPatSettlID.Text != "")
            {
                sqlStr = sqlStr + " and SettlementID='" + tbPatSettlID.Text + "'";
            }
            if (tbCertNo.Text != "")
            {
                sqlStr = sqlStr + " and CertificateNO='" + tbCertNo.Text + "'";
            }
            if (tb_AdmDr.Text != "")
            {
                sqlStr = sqlStr + "and Adm_Dr='" + tb_AdmDr.Text + "'";
            }

            sqlStr = sqlStr + " AND ReversalFlag<>1 ";

            JObject joSqlstr = new JObject();
            joSqlstr.Add("sqlStr", sqlStr);
            JArray jaParam = new JArray();
            jaParam.Add(joSqlstr);
            JObject joSettlQuery = new JObject();
            joSettlQuery.Add("params", jaParam);
            joSettlQuery.Add("code", "09010059");
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");

            DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
            dgvSettlRecord2.DataSource = dt;
        }

        private void uiButton23_Click(object sender, EventArgs e)
        {
            string errorMsg = "";
            if (dgvSettlRecord2.RowCount <= 0)
            {
                MessageBox.Show("请先查询结算数据!");
                return;
            }

            int i = dgvSettlRecord2.CurrentRow.Index;
            DataTable dt = (DataTable)dgvSettlRecord2.DataSource;
            string MdtrtID = dt.Rows[i]["MdtrtID"].ToString();
            string AdmID = dt.Rows[i]["AdmID"].ToString();

            //4101-医疗保障及金额结算清单信息上传
            if (rbg_BussnisType.SelectedIndex == 0)
            {
                if (upLoadSetlBillInfo(MdtrtID, AdmID, out errorMsg) != 0)
                {
                    MessageBox.Show("上传失败！" + errorMsg);
                    return;
                }
            }
            //4401-住院病案首页信息
            else if (rbg_BussnisType.SelectedIndex == 1)
            {
                if (upLoadMedRecordInfo(AdmID, out errorMsg) != 0)
                {
                    MessageBox.Show("上传失败！" + errorMsg);
                    return;
                }
            }
            //4701-电子病历上传
            else if (rbg_BussnisType.SelectedIndex == 2)
            {
                if (upLoadElectronicMedicalInfo(AdmID, out errorMsg) != 0)
                {
                    MessageBox.Show("上传失败！" + errorMsg);
                    return;
                }
            }
            //4402-医嘱信息上传
            else
            {
                if (upLoadDoctorAdviceInfo(AdmID, out errorMsg) != 0)
                {
                    MessageBox.Show("上传失败！" + errorMsg);
                    return;
                }
            }

            MessageBox.Show("上传成功！");
        }

        private void uiButton22_Click(object sender, EventArgs e)
        {
            if (dgvSettlRecord.RowCount <= 0)
            {
                MessageBox.Show("请先查询结算数据!");
                return;
            }

            if (rbg_BussnisType.SelectedIndex == 0)
            {
                for (int i = 0; i < dgvSettlRecord.Rows.Count; i++)
                {
                    int iCenter = dgvSettlRecord.CurrentRow.Index;
                    string MdtrtID = dgvSettlRecord.Rows[i].Cells["MdtrtID"].Value.ToString();
                    string AdmID = dgvSettlRecord.Rows[i].Cells["AdmID"].Value.ToString();

                    upLoadSetlBillInfo(MdtrtID, AdmID, out string errorMsg);
                }
            }
            else if (rbg_BussnisType.SelectedIndex == 1)
            {
                for (int i = 0; i < dgvSettlRecord.Rows.Count; i++)
                {
                    int iCenter = dgvSettlRecord.CurrentRow.Index;
                    string AdmID = dgvSettlRecord.Rows[i].Cells["AdmID"].Value.ToString();

                    upLoadMedRecordInfo(AdmID, out string errorMsg);
                }
            }
            else if (rbg_BussnisType.SelectedIndex == 2)
            {
                for (int i = 0; i < dgvSettlRecord.Rows.Count; i++)
                {
                    int iCenter = dgvSettlRecord.CurrentRow.Index;
                    string AdmID = dgvSettlRecord.Rows[i].Cells["AdmID"].Value.ToString();

                    upLoadElectronicMedicalInfo(AdmID, out string errorMsg);
                }
            }
            else
            {
                for (int i = 0; i < dgvSettlRecord.Rows.Count; i++)
                {
                    int iCenter = dgvSettlRecord.CurrentRow.Index;
                    string AdmID = dgvSettlRecord.Rows[i].Cells["AdmID"].Value.ToString();

                    upLoadDoctorAdviceInfo(AdmID, out string errorMsg);
                }
            }

            MessageBox.Show("全部上传完成！");
        }

        public int upLoadSetlBillInfo(string MdtrtID, string AdmID, out string OutMsg)
        {
            if (GetSettltBillParam(MdtrtID, out JObject joHisRtn, out OutMsg) != 0)
            {
                OutMsg = "从HIS获取医保结算清单入参信息失败" + OutMsg;
                return -1;
            }

            // 解析为 JObject
            JObject jsonObject = joHisRtn;

            // 获取 iteminfo 数组
            JArray itemInfoArray = (JArray)joHisRtn["result"]["iteminfo"];

            // 遍历数组并修改 med_chrgitm
            foreach (var item in itemInfoArray)
            {
                if (item["med_chrgitm"] != null && item["med_chrgitm"].Value<int>() == 0)
                {
                    item["med_chrgitm"] = 14;
                }
            }

            // 转换回 JSON 字符串
            joHisRtn = jsonObject;

            //MessageBox.Show(JsonHelper.getDestValue(joHisRtn, "result"));   
            string insutype = JsonHelper.getDestValue(joHisRtn, "result.setlinfo.hi_type");

            if (insutype == "1") //企业保险办法
                insutype = "310"; //职工基本医疗保险
            else if (insutype == "2") //机关事业保险办法
                insutype = "999"; //其他医疗保险 医疗保障类型（mdcs_type）
            else if (insutype == "3") //居民医疗保险办法
                insutype = "390"; //城乡居民基本医疗保险
            else if (insutype == "4") //离休老干
                insutype = "340"; //离休人员医疗保障

            joHisRtn["result"]["setlinfo"]["hi_type"] = insutype;

            joHisRtn["result"]["setlinfo"]["mdtrt_sn"] = AdmID;

            //MessageBox.Show(joHisRtn.ToString());

            JObject joInput = JObject.Parse(JsonHelper.getDestValue(joHisRtn, "result"));
            JObject joRtn = invoker.invokeCenterServiceF("4101", JsonHelper.setCenterInparF("4101", joInput));
            //JObject joRtn = invoker.invokeCenterServiceF("4101", JsonHelper.getDestValue(joHisRtn, "result"));
            if (JsonHelper.parseCenterRtnValue(joRtn, out OutMsg) != 0)
            {
                OutMsg = "医保结算清单信息上传失败：" + OutMsg;
                return -1;
            }

            return 0;
        }

        public int upLoadMedRecordInfo(string AdmID, out string OutMsg)
        {
            if (GetMedicalRecordParam(AdmID, out JObject joHisRtn, out OutMsg) != 0)
            {
                OutMsg = "从HIS获取医保病案首页入参信息失败" + OutMsg;
                return -1;
            }

            //MessageBox.Show(JsonHelper.getDestValue(joHisRtn, "result.baseinfo"));

            string prfs = JsonHelper.getDestValue(joHisRtn, "result.baseinfo.prfs");
            string rh_code = JsonHelper.getDestValue(joHisRtn, "result.baseinfo.rh_code"); //血型
            string dscg_way = JsonHelper.getDestValue(joHisRtn, "result.baseinfo.dscg_way"); //离院方式

            if ((prfs == "/") || (prfs == "") || (prfs == "-") || (prfs == "无"))
                prfs = "90";

            if (prfs.Contains("11,13,17,21,24,27,31,37,51,54,70,80,90") == false)
                prfs = "90";

            if ((rh_code == "/") || (rh_code == "") || (rh_code == "-") || (rh_code == "无"))
                rh_code = "3";

            if ((dscg_way == "/") || (dscg_way == "") || (dscg_way == "-") || (dscg_way == "无"))
                dscg_way = "9";

            joHisRtn["result"]["baseinfo"]["prfs"] = prfs;
            joHisRtn["result"]["baseinfo"]["abo_code"] = "9";
            joHisRtn["result"]["baseinfo"]["medfee_paymtd_code"] = "99";
            joHisRtn["result"]["baseinfo"]["rh_code"] = rh_code;
            joHisRtn["result"]["baseinfo"]["dscg_way"] = dscg_way;

            JObject joInput = JObject.Parse(JsonHelper.getDestValue(joHisRtn, "result"));
            JObject joRtn = invoker.invokeCenterServiceF("4401", JsonHelper.setCenterInparF("4401", joInput));
            //JObject joRtn = invoker.invokeCenterServiceF("4401", JsonHelper.getDestValue(joHisRtn, "result"));
            if (JsonHelper.parseCenterRtnValue(joRtn, out OutMsg) != 0)
            {
                OutMsg = "医保结算清单信息上传失败：" + OutMsg;
                return -1;
            }

            return 0;
        }

        /// <summary>
        /// 电子病历上传
        /// </summary>
        /// <param name="AdmID"></param>
        /// <param name="OutMsg"></param>
        /// <returns></returns>
        public int upLoadElectronicMedicalInfo(string AdmID, out string OutMsg)
        {
            if (GetElectronicMedicalRecordParam(AdmID, out JObject joHisRtn, out OutMsg) != 0)
            {
                OutMsg = "从HIS获取电子病历入参信息失败" + OutMsg;
                return -1;
            }

            //MessageBox.Show(joHisRtn.ToString());
            JObject joInput = JObject.Parse(JsonHelper.getDestValue(joHisRtn, "result"));
            JObject joRtn = invoker.invokeCenterServiceF("4701", JsonHelper.setCenterInparF("4701", joInput));

            //JObject joRtn = invoker.invokeCenterServiceF("4701", JsonHelper.getDestValue(joHisRtn, "result"));
            if (JsonHelper.parseCenterRtnValue(joRtn, out OutMsg) != 0)
            {
                OutMsg = "电子病历信息上传失败：" + OutMsg;
                return -1;
            }

            return 0;
        }

        /// <summary>
        /// 住院医嘱信息上传
        /// </summary>
        /// <param name="AdmID"></param>
        /// <param name="OutMsg"></param>
        /// <returns></returns>
        public int upLoadDoctorAdviceInfo(string AdmID, out string OutMsg)
        {
            if (GetDoctorAdviceParam(AdmID, out JObject joHisRtn, out OutMsg) != 0)
            {
                OutMsg = "从HIS获取住院医嘱信息失败" + OutMsg;
                return -1;
            }

            JArray ja = JArray.Parse(JsonHelper.getDestValue(joHisRtn, "result"));

            JObject joInput = new JObject();
            joInput.Add("data", ja);

            JObject joRtn = invoker.invokeCenterServiceF("4402", JsonHelper.setCenterInparF("4402", joInput));
            if (JsonHelper.parseCenterRtnValue(joRtn, out OutMsg) != 0)
            {
                OutMsg = "住院医嘱信息上传失败：" + OutMsg;
                return -1;
            }

            return 0;
        }

        /// <summary>
        /// 获取HIS医保结算清单入参
        /// </summary>
        /// <param name="MdtrtID"></param>
        /// <param name="joSetlBill"></param>
        /// <returns></returns>
        public int GetSettltBillParam(string MdtrtID, out JObject joSetlBill, out string outMsg)
        {
            JObject jo = new JObject();
            jo.Add("insuAdmNo", MdtrtID);
            jo.Add("funNo", "4101");
            jo.Add("type", "InsuRiskManagement");
            joSetlBill = IS.GetHISSettleBillParam(jo);

            if (JsonHelper.parseIrisRtnValue(joSetlBill, out outMsg) != 0)
            {
                outMsg = "获取HIS医保结算清单入参失败，请联系管理员！" + outMsg;
                return -1;
            }

            if (JsonHelper.getDestValue(joSetlBill, "result.setlinfo") == "")
            {
                return -1;
            }

            return 0;
        }

        /// <summary>
        /// 获取HIS医保结算清单入参
        /// </summary>
        /// <param name="MdtrtID"></param>
        /// <param name="joSetlBill"></param>
        /// <returns></returns>
        public int GetMedicalRecordParam(string AdmID, out JObject joMedRecord, out string outMsg)
        {
            JObject jo = new JObject();
            jo.Add("admID", AdmID);
            jo.Add("interfaceID", Global.inf.interfaceDr);
            //jo.Add("funNo", "4401");
            //jo.Add("type", "InsuRiskManagement");
            joMedRecord = IS.GetHISMedicalRecordParam(jo);

            if (JsonHelper.parseIrisRtnValue(joMedRecord, out outMsg) != 0)
            {
                outMsg = "获取HIS医保病案首页入参失败，请联系管理员！" + outMsg;
                return -1;
            }

            if (JsonHelper.getDestValue(joMedRecord, "result.baseinfo") == "")
            {
                return -1;
            }

            return 0;
        }

        /// <summary>
        /// 获取HIS电子病历入参
        /// </summary>
        /// <param name="AdmID"></param>
        /// <param name="joSetlBill"></param>
        /// <returns></returns>
        public int GetElectronicMedicalRecordParam(string AdmID, out JObject joMedRecord, out string outMsg)
        {
            JObject jo = new JObject();
            jo.Add("admID", AdmID);
            jo.Add("interfaceID", Global.inf.interfaceDr);
            //jo.Add("funNo", "4701");
            //jo.Add("type", "InsuRiskManagement");
            joMedRecord = IS.GetHISElectronicMedicalRecordParam(jo);

            if (JsonHelper.parseIrisRtnValue(joMedRecord, out outMsg) != 0)
            {
                outMsg = "获取HIS电子病历入参失败，请联系管理员！" + outMsg;
                return -1;
            }

            if (JsonHelper.getDestValue(joMedRecord, "result") == "")
            {
                return -1;
            }

            return 0;
        }

        /// <summary>
        /// 获取HIS住院医嘱信息入参
        /// </summary>
        /// <param name="AdmID"></param>
        /// <param name="joSetlBill"></param>
        /// <returns></returns>
        public int GetDoctorAdviceParam(string AdmID, out JObject joMedRecord, out string outMsg)
        {
            JObject jo = new JObject();
            jo.Add("admID", AdmID);
            jo.Add("interfaceID", Global.inf.interfaceDr);
            //jo.Add("funNo", "4701");
            //jo.Add("type", "InsuRiskManagement");
            joMedRecord = IS.GetDoctorAdviceParam(jo);

            JArray ja = JArray.Parse(JsonHelper.getDestValue(joMedRecord, "result"));

            if (JsonHelper.parseIrisRtnValue(joMedRecord, out outMsg) != 0)
            {
                outMsg = "获取HIS住院医嘱信息入参失败，请联系管理员！" + outMsg;
                return -1;
            }

            if (ja.Count <= 0)
            {
                return -1;
            }

            return 0;
        }

        private void uiButton25_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        public int queryHISDirectory(out string errMsg)        
        {
            errMsg = "";
            string pageSize = "500";
            string flag = "Maped";
            JObject joHISRtn = new JObject();
            JObject joRtn = new JObject();
            JArray jaPagination = new JArray();
            JArray jaParams = new JArray();
            dynamic joParam = new JObject();
            joParam.alias = "";
            joParam.HospitalDr = Global.inf.hospitalDr;
            joParam.InterfaceDr = Global.inf.interfaceDr;
            joParam.hisType = "drugs";
            jaParams.Add(joParam);
            dynamic joPagination = new JObject();
            joPagination.pageSize = pageSize;
            joPagination.currentPage = "1";
            joPagination.sortColumn = "HisCode";
            joPagination.sortOrder = "asc";
            jaPagination.Add(joPagination);

            JObject joMIRtn = mIS.GetMappedHISDir(jaPagination, jaParams);

            if (JsonHelper.parseIrisRtnValue(joMIRtn, out errMsg) != 0)
            {
                return -1;
            }

            //传给HIS，进行匹配
            joParam = new JObject();
            joParam.TotalCount = joMIRtn["result"]["TotalCount"];
            joParam.type = "drugs";
            joParam.flag = flag;
            joParam.hospID = Global.inf.hisHospitalDr;
            joParam.interfaceDr = Global.inf.interfaceDr;
            joParam.alias = "";
            joParam.include = "Hosp";
            joParam.groupID = "324";
            joParam.specInput = "";//增加规格过滤
            joParam.compareArr = joMIRtn["result"]["Data"];
            jaParams = new JArray();
            jaParams.Add(joParam);
            if (hIS.getHISDir(jaPagination, jaParams, out joRtn, out errMsg) != 0)
            {
                return -1;
            }

            DataTable dt = (DataTable)joRtn["result"]["Data"].ToObject(typeof(DataTable));
            dtExport = dt;
            int totalCount = int.Parse(joRtn["result"]["TotalCount"].ToString());
            //pgHISDirect.TotalCount = totalCount;

            //pgHISDirect.PageSize = pageSize;
            dgvMedInsuMapRelation.DataSource = null;
            dgvMedInsuMapRelation.DataSource = dt;
            dgvMedInsuMapRelation.Columns[0].ReadOnly = true;

            GridViewSetter gridSetter = new GridViewSetter();
            gridSetter.SetHeaderTextOfMapping_HisDirectory(dgvMedInsuMapRelation);
            gridSetter.DatagridviewColumnWidthAdaptation(dgvMedInsuMapRelation);

            return 0;
        }

        private void uiButton9_Click(object sender, EventArgs e)
        {            
            if (queryHISDirectory(out string errMsg) != 0)            
            {
                MessageBox.Show(errMsg);
                return;
            }
        }

        private void uiButton10_Click(object sender, EventArgs e)
        {
            string errorMsg;
            if (dgvMedInsuMapRelation.CurrentRow == null)
            {
                MessageBox.Show("请先查询医保药品对照信息");
                return;
            }

            int iCenter = dgvMedInsuMapRelation.CurrentRow.Index;
            string insuCode = dgvMedInsuMapRelation.Rows[iCenter].Cells["insuCode"].Value.ToString();  //中心编码
            string insuName = dgvMedInsuMapRelation.Rows[iCenter].Cells["insuName"].Value.ToString();  //中心编码
            string itemCode = dgvMedInsuMapRelation.Rows[iCenter].Cells["itemCode"].Value.ToString();  //医院编码
            string itemDesc = dgvMedInsuMapRelation.Rows[iCenter].Cells["itemDesc"].Value.ToString();  //医院名称

            SaleBillInfo sbi = new SaleBillInfo(insuCode, insuName);
            try
            {
                if (sbi.ShowDialog() == DialogResult.OK)
                {            
                    JObject joInput = new JObject();
                    JObject joData = new JObject();
                    joData.Add("entId", sbi.entId);
                    joData.Add("code", sbi.code);
                    joData.Add("medicalDrugId", sbi.medicalDrugId);
                    joData.Add("queryTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                    joData.Add("salePkg", sbi.salePkg);
                    joData.Add("unpackCount", sbi.unpackCount);
                    joData.Add("drugSalePrice", sbi.drugSalePrice);
                    joData.Add("batchNo", sbi.batchNo);

                    joInput.Add("data", joData);

                    JObject joRtn = invoker.invokeCenterServiceF("20001", JsonHelper.setCenterInparFT("20001", joInput));
                    if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
                    {
                        MessageBox.Show("医保药品鉴核数据采集事前鉴核服务上传失败：" + errorMsg);
                        return;
                    }
                    else
                    {
                        DataTable dtData = (DataTable)joRtn["output"]["data"].ToObject(typeof(DataTable));
                        DataTable dtVerifyResult = (DataTable)joRtn["output"]["verifyResult"].ToObject(typeof(DataTable));
                        DataTable dtTraceCodeVo = (DataTable)joRtn["output"]["traceCodeVo"].ToObject(typeof(DataTable));
                        DataTable dtMedDrugInfo = (DataTable)joRtn["output"]["medDrugInfo"].ToObject(typeof(DataTable));

                        dgvData.DataSource = dtData;
                        dgvVerifyResult.DataSource = dtVerifyResult;
                        dgvTraceCodeVo.DataSource = dtTraceCodeVo;
                        dgvMedDrugInfo.DataSource = dtMedDrugInfo;

                        MessageBox.Show("医保药品鉴核数据采集事前鉴核服务上传成功");
                    }                    
                }
                else
                {
                    MessageBox.Show("操作员已取消！");
                    return;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("异常：" + ex.Message);
                return;
            }
        }

        private void uiButton11_Click(object sender, EventArgs e)
        {
            string errorMsg;
            JObject joInput = new JObject();
            JObject joData = new JObject();
            joData.Add("ent_id", tbJGBM.Text);
            joData.Add("bill_code", tbDJBH.Text);            
            joData.Add("bill_time", dtTHSJ.Text);

            joInput.Add("data", joData);

            JObject joRtn = invoker.invokeCenterServiceF("20003", JsonHelper.setCenterInparF("20003", joInput));
            if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
            {
                MessageBox.Show("医保销售单据退货上传失败：" + errorMsg);
                return;
            }
            else
            {
                MessageBox.Show("医保销售单据退货上传成功！" + errorMsg);
            }
        }

        private void uiButton15_Click(object sender, EventArgs e)
        {
            string errMsg;
            dgv_BillInfo.DataSource = null;
            dgv_BillDetailInfo.DataSource = null;

            try
            {
                JObject joTmp = new JObject();
                joTmp.Add("startDate",date_st.Text.Substring(0,10));
                joTmp.Add("endDate", date_et.Text.Substring(0, 10));
                joTmp.Add("hospCode", JsonHelper.getDestValue((JObject)Global.curEvt.jaSession[0], "hospCode"));
                joTmp.Add("billID", "");

                JObject joRtn = invoker.invokeHISService(JsonHelper.setIrisInpar("05110039", joTmp).ToString(), "组织事后单据鉴核信息填报参数");
                if (JsonHelper.parseIrisRtnValue(joRtn, out errMsg) != 0)
                {
                    MessageBox.Show("组织事后单据鉴核信息填报参数失败，请联系管理员！" + errMsg);
                    return;
                }
                else
                {
                    DataTable dt = (DataTable)joRtn["result"].ToObject(typeof(DataTable));
                    dgv_BillInfo.DataSource = dt;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("组织事后单据鉴核信息填报参数异常：" + ex.Message);
                return;
            }
        }

        /// <summary>
        /// 获取HIS就诊信息
        /// </summary>
        /// <param name="dtST"></param>
        /// <param name="dtED"></param>
        /// <param name="PatInfo"></param>
        /// <param name="errMsg"></param>
        /// <param name="DT"></param>
        /// <returns></returns>
        private int GetHISRegInfo(string dtST, string dtED, string PatInfo, ref string errMsg, ref DataTable DT)
        {
            dynamic joTmp = new JObject();
            joTmp.Add("stDate", dtST);
            joTmp.Add("endDate", dtED);
            joTmp.Add("patInfo", PatInfo);

            JObject joRtnHISRegInfo = hIS.GetHISRegInfo(joTmp);

            if (JsonHelper.parseIrisRtnValue(joRtnHISRegInfo, out errMsg) != 0)
            {
                errMsg = "获取HIS患者就诊信息失败，请联系管理员！" + errMsg;
                return -1;
            }
            else
            {
                if ((joRtnHISRegInfo["result"]["rows"].ToString() == "[]"))
                {
                    errMsg = "查询HIS就诊信息结果为空！";
                    return -1;
                }
                else
                {
                    DT = (DataTable)joRtnHISRegInfo["result"]["rows"].ToObject(typeof(DataTable));
                    return 0;
                }
            }
        }

        private void uiButton18_Click(object sender, EventArgs e)
        {            
            string errMsg;

            //if (tb_SFZH.Text == "")
            //{
            //    MessageBox.Show("请先输入患者身份证号进行查找患者未结算处方信息！");
            //    return;
            //}
            //else
            //{
            //    dgv_HISRegInfo.DataSource = null;
            //    dgv_PrescriptionInfo.DataSource = null;

            //    CertNo = tb_SFZH.Text;
            //    Global.pat.certNO = tb_SFZH.Text;
            //}

            dgv_HISRegInfo.DataSource = null;
            dgv_PrescriptionInfo.DataSource = null;

            CertNo = tb_SFZH.Text;
            Global.pat.certNO = tb_SFZH.Text;

            #region【查询HIS就诊信息-用身份证号查询患者当日的就诊记录】
            string outParam = "";
            DataTable dt1 = null;
            if (GetHISRegInfo(dtp_st.Text, dtp_et.Text, Global.pat.certNO, ref outParam, ref dt1) != 0)
            {
                MessageBox.Show(outParam);
                return;
            }

            dgv_HISRegInfo.DataSource = dt1;
            #endregion

            #region【根据处方号查询处方明细信息】
            presAdmDoc = dgv_HISRegInfo.Rows[0].Cells["doc"].Value.ToString();
            presAdmLoc = dgv_HISRegInfo.Rows[0].Cells["loc"].Value.ToString();
            presNo = dgv_HISRegInfo.Rows[0].Cells["prescNo"].Value.ToString();
            presAdmID = dgv_HISRegInfo.Rows[0].Cells["admID"].Value.ToString();
            Global.pat.adm_Dr = int.Parse(presAdmID);

            if (presNo == "") return;
            DataTable dt2 = null;
            //获取HIS处方明细信息
            if (GetHISPrescFeeInfo(presNo, ref outParam, ref dt2) != 0)
            {
                MessageBox.Show(outParam);
                return;
            }

            dgv_PrescriptionInfo.DataSource = dt2;
            #endregion
        }

        /// <summary>
        /// 获取HIS费用明细信息
        /// </summary>
        /// <param name="PrescNo"></param>
        /// <param name="errMsg"></param>
        /// <param name="DT"></param>
        /// <returns></returns>
        private int GetHISPrescFeeInfo(string PrescNo, ref string errMsg, ref DataTable DT)
        {
            dynamic joTmp = new JObject();
            joTmp.Add("prescNo", PrescNo);

            JObject joRtnHISPrescFeeInfo = hIS.GetHISPrescFeeInfo(joTmp);

            if (JsonHelper.parseIrisRtnValue(joRtnHISPrescFeeInfo, out errMsg) != 0)
            {
                errMsg = "获取HIS患者处方信息失败，请联系管理员！" + errMsg;
                return -1;
            }
            else
            {
                if ((joRtnHISPrescFeeInfo["result"]["rows"].ToString() == "[]"))
                {
                    errMsg = "查询HIS处方信息结果为空！";
                    return -1;
                }
                else
                {
                    DT = (DataTable)joRtnHISPrescFeeInfo["result"]["rows"].ToObject(typeof(DataTable));
                    return 0;
                }
            }
        }

        private void dgv_HISRegInfo_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            uiButton16_Click(sender, e);
        }
    }
}