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
    {
        InvokeHelper invoker = new InvokeHelper();
        DataTable dtExport;

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

        public MedInsuQuery()
        {
            InitializeComponent();

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

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

        private DataTable GetDBLKComboxTable(string sqlStr)
        {
            InvokeHelper invoker = new InvokeHelper();
            dynamic joInparm = new JObject();

            dynamic joTmp = new JObject();
            joTmp.sqlStr = sqlStr;
            JArray jaParams = new JArray();
            jaParams.Add(joTmp);
            joInparm.Add("params", JArray.FromObject(jaParams));
            joInparm.code = "09010014";
            string inParam = joInparm.ToString();
            JObject joRtn = invoker.invokeInsuService(inParam, "获取下拉框消息");
            //dynamic jsonRtn = JsonConvert.DeserializeObject(strRtn);
            DataTable dt = (DataTable)joRtn["result"].ToObject(typeof(DataTable));
            //dt.Columns[0].ColumnName = "编码";
            //dt.Columns[1].ColumnName = "名称";
            //dt.Columns[2].ColumnName = "拼音查找码";
            return dt;
        }

        private void GetCheckBoxGroupItem(string sqlStr,CheckedListBox checkedListBox1)
        {
            DataTable DT = GetDBLKComboxTable(sqlStr);
            checkedListBox1.Items.Clear();
            for (int i = 0; i < DT.Rows.Count; i++)
            {
                string Code = DT.Rows[i]["Code"].ToString();
                string Name = DT.Rows[i]["Name"].ToString();
                string Str = Code + "-" + Name;
                checkedListBox1.Items.Add(Str);
            }
        }

        private void MedInsuQuery_Load(object sender, EventArgs e)
        {
            dpST.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
            dpED.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");

            edt_SetlNY.Text = DateTime.Now.ToString("yyyyMM");

            rbg_exit_type.SelectedIndex = 1;

            // dgvSettlRecord.AutoGenerateColumns = false;
            GridViewSetter grdSetter = new GridViewSetter();
            grdSetter.SetHeaderTextOfMedInsuHosPerInfo(dgvSettlRecord);            
            grdSetter.SetHeaderTextOfSettlList(dgv_SettleRecord);
            grdSetter.SetHeaderTextOfSettlList(dgv_Settle3602);
        }

        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 btnMedQuery_Click(object sender, EventArgs e)
        {
            string errorMsg;
            string sBussiesID = "3605";
            DataTable dt;
            JObject joData = new JObject();
            JObject joInput = new JObject();

            joData.Add("setl_ym", edt_SetlNY.Text);
            joData.Add("page_num", edt_Page.Text);
            joData.Add("page_size", edt_PageCount.Text);
            joData.Add("setl_id", edt_SetID.Text);
            joInput.Add("data", joData);
             
            JObject joRtn = invoker.invokeCenterService(sBussiesID, JsonHelper.setCenterInpar(sBussiesID, joInput));
            if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
            {
                MessageBox.Show(" 查询失败：" + errorMsg);
                return;
            }
            else
            {
                dt = (DataTable)joRtn["output"]["data"].ToObject(typeof(DataTable));
                dgv_MainData.DataSource = dt;

                if (dt.Rows.Count > 0)
                {
                    btnImport.Enabled = true;
                    dtExport = dt;
                }
            }
        }

        private void btnImport_Click(object sender, EventArgs e)
        {
            string sBussiesID = "【3605】DRG分组结果查询";
            string LSH = DateTime.Now.ToString("yyyyMMdd"); //DateTime.Now.ToString("MMddHHmmssffff");
            string sFliePathName = @"C:\Users\Administrator\Desktop\" + LSH + sBussiesID + "信息.xls";
            string ReturnFileName = ExportToExcel.DataTabletoExcel(dtExport, sFliePathName);
            if (ReturnFileName != "")
            {
                MessageBox.Show("导出成功,文件保存路径：【" + ReturnFileName + "】");
                System.Diagnostics.Process.Start(ReturnFileName); //打开excel文件                
            }
            else
            {
                MessageBox.Show("导出失败!");
            }
        }

        private void btnQuerySet_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 + "";
            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=2";
            }
            if (rbgAdmType.SelectedIndex == 2)
            {
                sqlStr = sqlStr + " and AdmType=1";
            }
            if (rbgBillType.SelectedIndex == 1)
            {
                sqlStr = sqlStr + " and BillType=1 and ValidFlag=1 ";
            }
            if (rbgBillType.SelectedIndex == 2)
            {
                sqlStr = sqlStr + " and BillType=-1 and ValidFlag=0 ";
            }

            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));
            dgv_SettleRecord.DataSource = dt;
        }

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

            if (dgv_SettleRecord.DataSource == null)
            {
                MessageBox.Show("请先查询HIS医保结算信息");
                return;
            }

            if (dgv_SettleRecord.Rows[dgv_SettleRecord.CurrentRow.Index].Cells["SettlementID"].Value.ToString() == "")
            {
                MessageBox.Show("请先查询HIS医保结算信息");
                return;
            }

            string settleID= dgv_SettleRecord.Rows[dgv_SettleRecord.CurrentRow.Index].Cells["SettlementID"].Value.ToString();
            string psnNo = dgv_SettleRecord.Rows[dgv_SettleRecord.CurrentRow.Index].Cells["PersonnelNO"].Value.ToString();

            try
            {
                dynamic joTmp = new JObject();
                joTmp.appy_exit_type = "";
                joTmp.setl_id = settleID;
                joTmp.psn_no = psnNo;
                joTmp.vali_flag = "";
                joTmp.fixmedins_code = "H45010302052";
                JObject joData = new JObject();
                joData.Add("data", joTmp);

                JObject joRtn = invoker.invokeCenterService("3601", JsonHelper.setCenterInpar("3601", joData).ToString());
                if (JsonHelper.parseCenterRtnValue(joRtn, out errMsg) != 0)
                {
                    MessageBox.Show("【3601】DRG申请退出列表查询失败：" + errMsg);
                    return;
                }
                else
                {
                    DataTable dt = (DataTable)joRtn["output"]["data"].ToObject(typeof(DataTable));
                    dgv_3601.DataSource = dt;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("【3601】DRG申请退出列表查询异常:" + ex.Message);
                return;
            }
        }

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

        private void btn_Query3602_Click(object sender, EventArgs e)
        {
            string sqlStr = " SELECT top 50 * FROM  BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
            sqlStr = sqlStr + " and OccurTime>'" + dpt_Begin.Text + "'";
            sqlStr = sqlStr + " and OccurTime<'" + dpt_End.Text + "'";
            sqlStr = sqlStr + " and Interface_Dr=" + Global.inf.interfaceDr + "";
            if (tb_Name.Text != "")
            {
                sqlStr = sqlStr + " and PatientName='" + tb_Name.Text + "'";
            }
            if (tb_SeltID.Text != "")
            {
                sqlStr = sqlStr + " and SettlementID='" + tb_SeltID.Text + "'";
            }
            if (tb_CardNo.Text != "")
            {
                sqlStr = sqlStr + " and Adm_Dr='" + tb_CardNo.Text + "'";
            }
            if (rbg_AdmType.SelectedIndex == 1)
            {
                sqlStr = sqlStr + " and AdmType=2";
            }
            if (rbg_AdmType.SelectedIndex == 2)
            {
                sqlStr = sqlStr + " and AdmType=1";
            }
            if (rbg_BillType.SelectedIndex == 1)
            {
                sqlStr = sqlStr + " and BillType=1 and ValidFlag=1 ";
            }
            if (rbg_BillType.SelectedIndex == 2)
            {
                sqlStr = sqlStr + " and BillType=-1 and ValidFlag=0 ";
            }

            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));
            dgv_Settle3602.DataSource = dt;
        }

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

            if (dgv_Settle3602.DataSource == null)
            {
                MessageBox.Show("请先查询HIS医保结算信息");
                return;
            }

            if (dgv_Settle3602.Rows[dgv_Settle3602.CurrentRow.Index].Cells["SettlementID"].Value.ToString() == "")
            {
                MessageBox.Show("请先查询HIS医保结算信息");
                return;
            }

            string ExitType = rbg_exit_type.SelectedIndex.ToString();

            try
            {
                dynamic joTmp = new JObject();
                joTmp.exit_rea = tb_exit_rea.Text;
                joTmp.fund_cap = tb_fund_cap.Text;
                joTmp.drg_admdvs = tb_drg_name.Text;
                joTmp.setl_id = tb_setl_id.Text;
                joTmp.psn_no = tb_psn_no.Text;
                joTmp.psn_name = tb_psn_name.Text;
                joTmp.psn_cert_type = "01";
                joTmp.certno = "";
                joTmp.insutype = dgv_Settle3602.Rows[dgv_Settle3602.CurrentRow.Index].Cells["InsuranceType"].Value.ToString(); ;
                joTmp.fixmedins_code = Global.inf.hospitalNO;
                joTmp.fixmedins_name = Global.inf.hospitalName;
                joTmp.adm_time = "";
                joTmp.dscg_time = "";
                joTmp.appy_exit_type = rbg_exit_type.SelectedIndex.ToString();
                joTmp.medcasno = "";
                joTmp.rx_drord_no = tb_rx_drord_no.Text;
                joTmp.drg_codg = "";
                joTmp.drg_name = "";
                joTmp.pay_std_amt = "";
                joTmp.setl_listsn = "";
                joTmp.mdtrt_id = "";
                joTmp.exit_fund_payamt = "";
                joTmp.drg_fund_payamt = "";
                joTmp.exit_type = rbg_exit_type.SelectedIndex.ToString();

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

                JObject joRtn = invoker.invokeCenterService("3602", JsonHelper.setCenterInpar("3602", joData).ToString());
                if (JsonHelper.parseCenterRtnValue(joRtn, out errMsg) != 0)
                {
                    MessageBox.Show("【3602】DRG申请退出保存失败：" + errMsg);
                    return;
                }
                else
                {
                    MessageBox.Show(joRtn.ToString());
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("【3602】DRG申请退出保存异常:" + ex.Message);
                return;
            }
        }

        private void dgv_Settle3602_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (dgv_Settle3602.DataSource == null)
            {
                return;
            }

            if (dgv_Settle3602.Rows[dgv_Settle3602.CurrentRow.Index].Cells["SettlementID"].Value.ToString() == "")
            {
                return;
            }

            tb_setl_id.Text = dgv_Settle3602.Rows[dgv_Settle3602.CurrentRow.Index].Cells["SettlementID"].Value.ToString();
            tb_psn_no.Text = dgv_Settle3602.Rows[dgv_Settle3602.CurrentRow.Index].Cells["PersonnelNO"].Value.ToString();
            tb_psn_name.Text= dgv_Settle3602.Rows[dgv_Settle3602.CurrentRow.Index].Cells["PersonnelNO"].Value.ToString();


        }
    }
}