MedicalInsurance/HuBeiMI/Forms/HandleException.cs

using Newtonsoft.Json.Linq;
using System;
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;
using FastReport;
using System.Security.Policy;
using FastReport.Editor;
using System.Collections;

namespace PTMedicalInsurance.Forms
{
    public partial class HandleException : Form
    {
        private int iLog = 0;
        private int iSettl = 0;
        private int iReg = 0;

        string ID, SettlementID, PersonnelNO, msgid, MdtrtID, PatientName, Sumamt, AdmType;

        //设置业务实例
        CenterBusiness cBus = new CenterBusiness();
        HisMainBusiness hBus = new HisMainBusiness();
        HisIrisServices hIS = new HisIrisServices();
        MIIrisServices mIS = new MIIrisServices();
        InvokeHelper invoker = new InvokeHelper();

        //1.声明自适应类实例
        AutoResizeForm asc = new AutoResizeForm();

        public HandleException()
        {
            InitializeComponent();

            //this.StartPosition = FormStartPosition.CenterParent;
            asc.controllInitializeSize(this);
            asc.controlAutoSize(this);
        }

        private void cbb_InterfaceDr_SelectedValueChanged(object sender, EventArgs e)
        {
            DataTable dtInteface = (DataTable)cbb_InterfaceDr.DataSource;
            int i = cbb_InterfaceDr.SelectedIndex;
            if (i != 2)
            {
                Global.pat.insuplc_admdvs = "";
            }
            else
            {
                Global.pat.insuplc_admdvs = "530199";
            }
            Global.inf.hospitalNO = dtInteface.Rows[i]["HospitalNO"].ToString();
            Global.inf.hospitalName = dtInteface.Rows[i]["HospitalName"].ToString();
            Global.inf.centerURL = dtInteface.Rows[i]["CenterURL"].ToString();
            Global.inf.areaCode = dtInteface.Rows[i]["AreaCode"].ToString();
            Global.user.name = "0";
            Global.user.ID = "0";
            Global.inf.operatoType = "3";
            Global.inf.version = "v1.0";
            Global.inf.recivedSystem = "SY";
            Global.inf.interfaceDr = int.Parse(dtInteface.Rows[i]["ID"].ToString());

            ComboxSetter cbxSetter = new ComboxSetter();
            cbxSetter.setCbxDictionaryDataSource(dtInteface.Rows[i]["ID"].ToString(), "insutype", cbb_InsuType);
            //cbxSetter.setCbxDictionaryDataSource(dtInteface.Rows[i]["ID"].ToString(), "clr_type", cbxClrType);
        }

        private void HandleException_Load(object sender, EventArgs e)
        {
            dpST_Log.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
            dpED_Log.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
            dpST_Settl.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
            dpED_Settl.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
            dpST_OutPatReg.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
            dpED_OutPatReg.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");

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

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

            dgvSettlRecord.AutoGenerateColumns = false;

            GridViewSetter grdSetter = new GridViewSetter();
            grdSetter.SetHeaderTextOfSettlList(dgvSettlRecord);
            grdSetter.SetHeaderTextOfCenterLog(dgvLog);
            grdSetter.SetHeaderTextOfRegister(dgvOutPatReg);
            grdSetter.SetHeaderTextOfSign(dgvSignQuery);
            grdSetter.SetHeaderTextOfSettlList(dgv_SettleData);

            ComboxSetter cbxSetter = new ComboxSetter();
            cbxSetter.setCbxInterfaceDataSource(cbb_InterfaceDr);
            cbxSetter.setCbxDictionaryDataSource(Global.inf.interfaceDr.ToString(), "med_type", cbb_MedType);    
            cbxSetter.setCbxDictionaryDataSource(Global.inf.interfaceDr.ToString(), "insutype", cbb_InsuType);

            cbb_InterfaceDr.SelectedValueChanged += new EventHandler(cbb_InterfaceDr_SelectedValueChanged);

            rbgAdmType.SelectedIndex = 0;
            rbgBillType.SelectedIndex = 1;
        }
        #region  结算异常
        private void btnQuerySettleRec_Click(object sender, EventArgs e)
        {
            if (tbName.Text == "")
            {
                MessageBox.Show("请输入患者姓名！");
                return;
            }
            string sqlStr = "SELECT * FROM  BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
            sqlStr = sqlStr + " and OccurTime>'" + dpST_Settl.Text + "'";
            sqlStr = sqlStr + " and OccurTime<'" + dpED_Settl.Text + "'";
            if (tbName.Text != "")
            {
                sqlStr = sqlStr + " and PatientName='" + tbName.Text + "'";
            }

            if (tbPatSettlID.Text != "")
            {
                sqlStr = sqlStr + " and SettlementID='" + tbPatSettlID.Text + "'";
            }

            if (tbHisNO.Text != "")
            {
                sqlStr = sqlStr + " and Adm_Dr='" + tbHisNO.Text + "'";
            }

            if (rbgAdmType.SelectedIndex == 1)
            {
                sqlStr = sqlStr + " and admType=1";
            }
            if (rbgAdmType.SelectedIndex == 2)
            {
                sqlStr = sqlStr + " and admType=2";
            }

            if (rbgBillType.SelectedIndex == 1)
            {
                sqlStr = sqlStr + " and BillType=1";
            }

            if (rbgBillType.SelectedIndex == 2)
            {
                sqlStr = sqlStr + " and BillType=-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");
            InvokeHelper invoker = new InvokeHelper();
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");

            MessageBox.Show(joRtn.ToString());
            MessageBox.Show(joRtn["result"]["data"].ToString());

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

            DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
            dgvSettlRecord.DataSource = dt;
        }
        private void btnReverseBySettl_Click(object sender, EventArgs e)
        {
            //InvokeHelper invoker = new InvokeHelper();

            DataTable dt = (DataTable)dgvSettlRecord.DataSource;
            string errorMessage = "";
            int a = dgvOutPatReg.CurrentRow.Index;
            //Global.inf.patientAreaCode = dt.Rows[a]["insuplc_admdvs"].ToString();
            Global.pat.insuplc_admdvs = dt.Rows[a]["insuplc_admdvs"].ToString();
            string mdtrt_id = dt.Rows[a]["MdtrtID"].ToString();
            string psn_no = dt.Rows[a]["PersonnelNO"].ToString();
            string adm_Dr = dt.Rows[a]["AdmID"].ToString();
            string setl_id = dt.Rows[a]["SettlementID"].ToString();
            JObject joInparam = new JObject();
            JObject joData = new JObject();
            joData.Add("omsgid", dt.Rows[a]["msgid"].ToString());
            joData.Add("psn_no", dt.Rows[a]["PersonnelNO"].ToString());
            string infno = "";
            if (dt.Rows[a]["infno"].ToString() == "1") infno = "2207";
            if (dt.Rows[a]["infno"].ToString() == "2") infno = "2304";
            joData.Add("oinfno", infno);
            joInparam.Add("data", joData);
            MessageBox.Show(joInparam.ToString());
            JObject joRtn = invoker.invokeCenterService("2601", JsonHelper.setCenterInpar("2601", joInparam.ToString()));
            //将中心返回的结果返回HIS 调用HIS服务进行保存
            if (JsonHelper.parseIrisRtnValue(joRtn, out errorMessage) != 0)
            {
                MessageBox.Show("冲正失败:" + errorMessage);
            }
            else
            {
                dynamic joTmp = new JObject();
                joTmp.admID = adm_Dr;
                joTmp.PersonalNO = psn_no;
                joTmp.mdtrt_id = mdtrt_id;
                joTmp.setl_id = setl_id;

                //JObject jo2305IrisRtn = mIS.cancleSettlement(joTmp);
                JObject jo2305IrisRtn = new JObject();
                if (JsonHelper.parseIrisRtnValue(jo2305IrisRtn, out errorMessage) != 0)
                {
                    errorMessage = "中心取消结算成功但云HIS平台取消失败，请联系管理员！" + errorMessage;
                    MessageBox.Show(errorMessage);
                }
            }
        }

        private void btCancleSettl_Click(object sender, EventArgs e)
        {
            string outParam;
            DataTable dt = (DataTable)dgvSettlRecord.DataSource;
            string errorMessage = "";
            int a = dgvSettlRecord.CurrentRow.Index;
            //Global.inf.patientAreaCode = dt.Rows[a]["insuplc_admdvs"].ToString()
            MessageBox.Show("111");
            Global.pat.insuplc_admdvs = dt.Rows[a]["insuplc_admdvs"].ToString();
            MessageBox.Show(dt.Rows[a]["insuplc_admdvs"].ToString());
            MessageBox.Show(Global.pat.insuplc_admdvs);
            Global.pat.mdtrtID = dt.Rows[a]["MdtrtID"].ToString(); 
            Global.pat.psn_no = dt.Rows[a]["PersonnelNO"].ToString();
            Global.pat.settlID = dt.Rows[a]["SettlementID"].ToString();
            Global.pat.adm_Dr = int.Parse(dt.Rows[a]["AdmID"].ToString()); 
            //取消中心结算信息
            if (cBus.cancleSettlement("2305", out outParam) != 0)
            {
                MessageBox.Show( "取消中心结算信息失败！" + outParam);
                return;
            }
            else
            {
                //取消平台结算信息
                //if (mIS.cancleSettlement(out outParam) != 0)
                if (cBus.cancleSettlement("2305", out outParam) != 0)
                {
                    MessageBox.Show("中心结算取消成功，医保平台结算信息取消失败！" + outParam);
                    return ;
                }

                //取消出院登记
                if (cBus.cancleRegister("2405", out outParam) != 0)
                {
                    MessageBox.Show("中心，医保平台及HIS结算信息取消成功，取消出院登记失败！请手工取消出院登记！" +  outParam);
                    return ;
                }
            }
        }
        #endregion

        #region  日志异常

        private void btnQueryLog_Click(object sender, EventArgs e)
        {
            string errMsg;
            string sqlStr = "SELECT * FROM  BS_MedInsuTransactionLog WHERE Hospital_Dr=" + Global.inf.hospitalDr;
            sqlStr = sqlStr + " and InfDate>='" + dpST_Log.Value.ToString("yyyy-MM-dd") + "'";
            sqlStr = sqlStr + " and InfDate<='" + dpED_Log.Value.ToString("yyyy-MM-dd") + "'";
            if (tbPsnNO.Text != "")
            {
                sqlStr = sqlStr + " and PSNNO='" + tbPsnNO.Text + "'";
            }

            if (tbTransNO.Text != "")
            {
                sqlStr = sqlStr + " and Infno='" + tbTransNO.Text + "'";
            }

            JObject joSqlstr = new JObject();
            joSqlstr.Add("sqlStr", sqlStr);
            JObject joRtn = mIS.QueryTransactionLog(joSqlstr);
            //if (JsonHelper.parseIrisRtnValue(joRtn, out errMsg) != 0)
            //{
            //    MessageBox.Show(errMsg);
            //    return;
            //}

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

                DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
                dgvLog.DataSource = dt;
            }
            catch (Exception eX)
            {
                MessageBox.Show(eX.Message);
            }
        }
        private void btnReverseByLog_Click(object sender, EventArgs e)
        {

            InvokeHelper invoker = new InvokeHelper();
            DataTable dt = (DataTable)dgvLog.DataSource;
            JObject joInparam = new JObject();
            JObject joData = new JObject();
            int a = dgvLog.CurrentRow.Index;
            if (tbCBD_Log.Text != "")
            { Global.pat.insuplc_admdvs = tbCBD_Log.Text; }
            else
                Global.pat.insuplc_admdvs = dt.Rows[a]["insuplc_admdvs"].ToString();
            joData.Add("omsgid", dt.Rows[a]["msgid"].ToString());
            joData.Add("psn_no", dt.Rows[a]["psn_no"].ToString());
            joData.Add("oinfno", dt.Rows[a]["infno"].ToString());
            //joData.Add("oinfno", "2207");
            joInparam.Add("data", joData);
            JObject joRtn = invoker.invokeCenterService("2601", JsonHelper.setCenterInpar("2601", joInparam.ToString()));
            string errorMessage = "";
            if (JsonHelper.parseCenterRtnValue(joRtn, out errorMessage) != 0)
            {
                MessageBox.Show("冲正失败" + errorMessage);
            }
            else
            {
                MessageBox.Show("冲正成功");
            }
        }

        #endregion

        #region  手工
        private void btPatInfo_ex_Click(object sender, EventArgs e)
        {
            rtbInparam.Text = @"{""data"":{""omsgid"":""H51010604235202205280848088230"",""psn_no"":""1530541881"",""oinfno"":""2201""}}";
            JObject joTmp = JObject.Parse(rtbInparam.Text);
            rtbInparam.Text = joTmp.ToString();
        }

        private void btnPatInfoShow_Click(object sender, EventArgs e)
        {
            string errorMsg = "";            
            JObject joRtn = new JObject();
            Global.pat.insuplc_admdvs = tbCBD_Hand.Text;
            
            if (Chk_DealNo.Checked)
            {
                //joRtn = invoker.invokeCenterService(tb_DealNo.Text, JsonHelper.setCenterInpar(tb_DealNo.Text, rtbInparam.Text));
                string[] strArr = { "3501", "3502", "3503", "3504", "3505", "3506", "3507" };
                bool exists = ((IList)strArr).Contains(tb_DealNo.Text);
                if (exists)
                {
                    joRtn = invoker.invokeCenterServiceJXC(tb_DealNo.Text, JObject.Parse(JsonHelper.setCenterInpar(tb_DealNo.Text, rtbInparam.Text)));

                }
                else
                {
                    joRtn = invoker.invokeCenterService(tb_DealNo.Text, JsonHelper.setCenterInpar(tb_DealNo.Text, rtbInparam.Text));
                }
            }
            else
            {
                joRtn = invoker.invokeCenterService("2601", JsonHelper.setCenterInpar("2601", rtbInparam.Text));
            }

            if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
            {
                MessageBox.Show("调用失败：" + errorMsg);
            }
            else
            {
                rtbOutparam.Text = joRtn.ToString();
                MessageBox.Show("调用成功！：");
                
            }

        }

        #endregion

        #region  门诊登记
        private void btnQueryOutPatReg_Click(object sender, EventArgs e)
        {
            
            string sqlStr = "SELECT * FROM  BS_MedInsuRegisterInfo WHERE Type=3 and Hospital_Dr=" + Global.inf.hospitalDr;
            sqlStr = sqlStr + " and OccurTime>'" + dpST_OutPatReg.Text + "'";
            sqlStr = sqlStr + " and OccurTime<'" + dpED_OutPatReg.Text + "'";
            if (tbOutPatName.Text != "")
            {
                sqlStr = sqlStr + " and Pat_Name='" + tbOutPatName.Text + "'";
            }

            if (tbOutPatRegID.Text != "")
            {
                sqlStr = sqlStr + " and InsuRegID='" + tbOutPatRegID.Text + "'";
            }

            if (tbOutPatPsnNO.Text != "")
            {
                sqlStr = sqlStr + " and PersonalNO='" + tbOutPatPsnNO.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", "09010062");
            InvokeHelper invoker = new InvokeHelper();
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询门诊挂号");

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

                DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
                dgvOutPatReg.DataSource = dt;
            }
            catch (Exception eX)
            {
                MessageBox.Show(eX.Message);
            }
        }



        private void btnCancleOutPatReg_Click(object sender, EventArgs e)
        {
            InvokeHelper invoker = new InvokeHelper();
            DataTable dt = (DataTable)dgvOutPatReg.DataSource;
            string errorMessage = "";
            int a = dgvOutPatReg.CurrentRow.Index;
            //组织挂号入参
            JObject joCancleRegInpar = new JObject();
            Global.pat.insuplc_admdvs = dt.Rows[a]["insuplc_admdvs"].ToString();
            joCancleRegInpar.Add("psn_no", dt.Rows[a]["PersonalNO"].ToString());
            joCancleRegInpar.Add("mdtrt_id", dt.Rows[a]["InsuRegID"].ToString());
            joCancleRegInpar.Add("ipt_otp_no", dt.Rows[a]["AdmID"].ToString());

            JObject joRegInput = new JObject();
            joRegInput.Add("data", joCancleRegInpar);
            //取消挂号信息
            JObject jo2202Rtn = invoker.invokeCenterService("2202", JsonHelper.setCenterInpar("2202", joRegInput.ToString()));
            if (JsonHelper.parseCenterRtnValue(jo2202Rtn, out errorMessage) != 0)
            {
                MessageBox.Show("取消挂号失败" + errorMessage);
            }
            else
            {
                dynamic joTmp = new JObject();
                joTmp.admID = dt.Rows[a]["AdmID"].ToString();
                joTmp.PersonalNO = dt.Rows[a]["PersonalNO"].ToString();
                joTmp.InsuRegID = dt.Rows[a]["InsuRegID"].ToString();
                joTmp.Add("billID", "");
                joTmp.Type = 3;
                joTmp.CancleRegDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                JObject jo2404IrisRtn = hIS.cancleRegister(joTmp);
                if (JsonHelper.parseIrisRtnValue(jo2404IrisRtn, out errorMessage) != 0)
                {
                    MessageBox.Show(errorMessage);
                }
                else
                {
                    MessageBox.Show("取消挂号成功");
                }
            }
        }



        private void btnCancleOutPatFee_Click(object sender, EventArgs e)
        {

            InvokeHelper invoker = new InvokeHelper();
            DataTable dt = (DataTable)dgvOutPatReg.DataSource;
            string errorMessage = "";
            int a = dgvOutPatReg.CurrentRow.Index;
            Global.pat.insuplc_admdvs = dt.Rows[a]["insuplc_admdvs"].ToString();
            string mdtrt_id = dt.Rows[a]["InsuRegID"].ToString();
            string psn_no = dt.Rows[a]["PersonalNO"].ToString();
            string adm_Dr = dt.Rows[a]["AdmID"].ToString();
            //组织入参
            dynamic joTmp = new JObject();
            joTmp.chrg_bchno = "0000";
            joTmp.mdtrt_id = mdtrt_id;
            joTmp.psn_no = psn_no;
            JObject joData = new JObject();
            joData.Add("data", joTmp);

            //组织好后上传给中心
            JObject joCenterRtn = invoker.invokeCenterService("2205", JsonHelper.setCenterInpar("2205", joData.ToString()));
            if (joCenterRtn["infcode"].ToString() == "0")
            {

                //删除医保传送表的数据
                joTmp = new JObject();
                joTmp.code = "09010048";
                joTmp.HospitalDr = Global.inf.hospitalDr;
                joTmp.admID = adm_Dr;
                joTmp.mdtrt_id = mdtrt_id;
                joTmp.updateUserID = Global.user.ID;
                JObject joIris2301DeleteRtn = invoker.invokeInsuService(joTmp.ToString(), "删除门诊明细");
                if (JsonHelper.parseCenterRtnValue(joIris2301DeleteRtn, out errorMessage) != 0)
                {
                    MessageBox.Show("取消门诊费用失败" + errorMessage);
                }
                else
                {
                    MessageBox.Show("取消门诊费用成功");
                }
            }
            else
            {
                MessageBox.Show("取消门诊费用失败");
            }
        }


        #endregion

        private void btnExit_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void uiButton8_Click(object sender, EventArgs e)
        {
            if (dgv_SettleData.DataSource == null)
            {
                MessageBox.Show("请先查询结算表信息！");
                return;
            }

            if (string.IsNullOrEmpty(dgv_SettleData.Rows[dgv_SettleData.CurrentRow.Index].Cells["ID"].Value.ToString()))
            {
                MessageBox.Show("医保结算记录ID不能为空！");
                return;
            }

            if (string.IsNullOrEmpty(tb_SettlementID.Text))
            {
                MessageBox.Show("医保结算ID不能为空！");
                return;
            }

            AdmType = dgv_SettleData.Rows[dgv_SettleData.CurrentRow.Index].Cells["AdmType"].Value.ToString();

            string errMsg = "";
            string infno;
            JObject joData = new JObject();
            JObject joInparam = new JObject();
            joData.Add("omsgid", tb_MsgID.Text);
            joData.Add("psn_no", tb_PersonnelNO.Text);
         
            if (AdmType == "1")
                infno = "2207";
            else
                infno = "2304";

            joData.Add("oinfno", infno);
            joInparam.Add("data", joData);
     
            JObject joRtn = invoker.invokeCenterService("2601", JsonHelper.setCenterInpar("2601", joInparam.ToString()));
            //将中心返回的结果返回HIS 调用HIS服务进行保存
            if (JsonHelper.parseIrisRtnValue(joRtn, out errMsg) != 0)
            {
                MessageBox.Show("冲正失败:" + errMsg);
                return;
            }
            else
            {
                dynamic joTmp = new JObject();
                joTmp.admID = tb_RecordID.Text;
                joTmp.PersonalNO = tb_PersonnelNO.Text;
                joTmp.mdtrt_id = tb_MdtrtID.Text;
                joTmp.setl_id = tb_SettlementID.Text;

                if (mIS.NullifySettlement(ID, tb_SettlementID.Text, out errMsg) != 0)
                {
                    errMsg = "中心取消结算成功但作废云HIS平台医保结算表信息失败，请联系管理员！" + errMsg;
                    MessageBox.Show(errMsg);
                    return;
                }
                else
                {
                    MessageBox.Show("冲正成功！");
                }
            }
        }

        private void btnSignQuery_Click(object sender, EventArgs e)
        {
            string sqlStr = "SELECT Top 50 * FROM  HB_MedInsuSignRecord WHERE Hospital_Dr=" + Global.inf.hospitalDr;
            sqlStr = sqlStr + " and Interface_Dr=" + Global.inf.interfaceDr;
            sqlStr = sqlStr + " and CreateTime>'" + dtSignBegin.Text + "'";
            sqlStr = sqlStr + " and CreateTime<'" + dtSignEnd.Text + "'";
            if (edtSignNo.Text != "")
            {
                sqlStr = sqlStr + " and SignNo='" + edtSignNo.Text + "'";
            }

            if (edtSignOpterNo.Text != "")
            {
                sqlStr = sqlStr + " and OperatorNO='" + edtSignOpterNo.Text + "'";
            }

            if (edtOpterName.Text != "")
            {
                sqlStr = sqlStr + " and OperatorName='" + edtOpterName.Text + "'";
            }

            sqlStr = sqlStr + " Order By CreateTime DESC ";

            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", "09010064");
            joSettlQuery.Add("queryType", "All");
            InvokeHelper invoker = new InvokeHelper();
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询签到信息");

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

                DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
                dgvSignQuery.DataSource = dt;
            }
            catch (Exception eX)
            {
                MessageBox.Show(eX.Message);
            }
        }

        private void btnCancelSign_Click(object sender, EventArgs e)
        {
            InvokeHelper invoker = new InvokeHelper();
            DataTable dt = (DataTable)dgvSignQuery.DataSource;
            string errorMessage = "";
            int a = dgvSignQuery.CurrentRow.Index;

            if (a <0)
            {
                MessageBox.Show("请先选中需要签退的签到记录信息！");
                return;            
            }

            //组织签退入参
            JObject joCancleRegInpar = new JObject();
            joCancleRegInpar.Add("sign_no", dt.Rows[a]["SignNo"].ToString());
            joCancleRegInpar.Add("opter_no", dt.Rows[a]["OperatorNO"].ToString());

            JObject joRegInput = new JObject();
            joRegInput.Add("signOut", joCancleRegInpar);
            //取消挂号信息
            JObject jo9002Rtn = invoker.invokeCenterService("9002", JsonHelper.setCenterInpar("9002", joRegInput.ToString()));
            if (JsonHelper.parseCenterRtnValue(jo9002Rtn, out errorMessage) != 0)
            {
                MessageBox.Show("医保签退失败" + errorMessage);
            }
            else
            {
                MessageBox.Show("医保签退成功");
            }
        }

        private void Chk_DealNo_CheckedChanged(object sender, EventArgs e)
        {
            if (Chk_DealNo.Checked)
            {
                tb_DealNo.Visible = true;
            }
            else
            {
                tb_DealNo.Visible = false;
            }
        }

        private void btn_Query_Click(object sender, EventArgs e)
        {
            DataTable dtInteface = (DataTable)cbb_InterfaceDr.DataSource;
            int i = cbb_InterfaceDr.SelectedIndex;
            GridViewSetter grdSetter = new GridViewSetter();

            string sqlStr = " SELECT *  FROM BS_MedInsuSettlement WHERE Hospital_Dr='" + Global.inf.hospitalDr + "'";
            sqlStr = sqlStr + " AND ValidFlag='1' And BillType='1'";
            sqlStr = sqlStr + " AND Interface_Dr= '" + Global.inf.interfaceDr + "'";
            sqlStr = sqlStr + " AND MedicalType='" + cbb_MedType.SelectedValue + "'";
            sqlStr = sqlStr + " AND SettlementDateTime>='" + dt_ST.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'";
            sqlStr = sqlStr + " AND SettlementDateTime<='" + dt_ET.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'";

            if (cbb_InterfaceDr.Text != "")
            {
                sqlStr = sqlStr + " And Interface_dr =" + dtInteface.Rows[i]["ID"].ToString();
            }

            if (cbb_InsuType.Text != "")
            {
                sqlStr = sqlStr + " And InsuranceType ='" + cbb_InsuType.SelectedValue + "'";
            }

            if (cbb_MedType.Text != "")
            {
                sqlStr = sqlStr + " And MedicalType =" + cbb_MedType.SelectedValue;
            }

            if (tb_Certno.Text != "")
            {
                sqlStr = sqlStr + " And CertificateNO =" + tb_Certno.Text;
            }

            if (tb_PsnNo.Text != "")
            {
                sqlStr = sqlStr + " And PersonnelNO =" + tb_PsnNo.Text;
            }

            if (tb_SettleID.Text != "")
            {
                sqlStr = sqlStr + " And SettlementID =" + tb_SettleID.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");
            InvokeHelper invoker = new InvokeHelper();
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");

            //MessageBox.Show(joRtn.ToString());
            //MessageBox.Show(joRtn["result"]["data"].ToString());

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

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

        private void dgv_SettleData_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (dgv_SettleData.DataSource == null)
            {
                MessageBox.Show("请先查询结算表信息！");
                return;
            }

            if (string.IsNullOrEmpty(dgv_SettleData.Rows[dgv_SettleData.CurrentRow.Index].Cells["ID"].Value.ToString()))
            {
                MessageBox.Show("医保结算记录ID不能为空！");
                return;
            }

            AdmType = dgv_SettleData.Rows[dgv_SettleData.CurrentRow.Index].Cells["AdmType"].Value.ToString();
            MdtrtID = tb_MdtrtID.Text = dgv_SettleData.Rows[dgv_SettleData.CurrentRow.Index].Cells["MdtrtID"].Value.ToString();
            ID = tb_RecordID.Text = dgv_SettleData.Rows[dgv_SettleData.CurrentRow.Index].Cells["ID"].Value.ToString();
            SettlementID = tb_SettlementID.Text = dgv_SettleData.Rows[dgv_SettleData.CurrentRow.Index].Cells["SettlementID"].Value.ToString();
            PersonnelNO = tb_PersonnelNO.Text = dgv_SettleData.Rows[dgv_SettleData.CurrentRow.Index].Cells["PersonnelNO"].Value.ToString();
            msgid = tb_MsgID.Text = dgv_SettleData.Rows[dgv_SettleData.CurrentRow.Index].Cells["msgid"].Value.ToString();
            PatientName = tb_PatientName.Text = dgv_SettleData.Rows[dgv_SettleData.CurrentRow.Index].Cells["PatientName"].Value.ToString();
            Sumamt = tb_Sumamt.Text = dgv_SettleData.Rows[dgv_SettleData.CurrentRow.Index].Cells["Sumamt"].Value.ToString();           
        }

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

            if (dgv_SettleData.DataSource == null)
            {
                MessageBox.Show("请先查询结算表信息！");
                return;
            }

            if (string.IsNullOrEmpty(dgv_SettleData.Rows[dgv_SettleData.CurrentRow.Index].Cells["ID"].Value.ToString()))
            {
                MessageBox.Show("医保结算记录ID不能为空！");
                return;
            }

            if (string.IsNullOrEmpty(tb_SettlementID.Text))
            {
                MessageBox.Show("医保结算ID不能为空！");
                return;
            }

            if (mIS.NullifySettlement(ID, tb_SettlementID.Text, out errMsg) != 0)            
            {
                errMsg = "中心取消结算成功但作废云HIS平台医保结算表信息失败，请联系管理员！" + errMsg;
                MessageBox.Show(errMsg);
                return;
            }
            else
            {
                MessageBox.Show("冲正成功！");
            }
        }
    }
}