MedicalInsurance/GuiYang_YinHai/GuiYangMI/Forms/SettlementChecklist.cs

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.Helper;
using PTMedicalInsurance.Common;
using Newtonsoft.Json.Linq;
using PTMedicalInsurance.FormSetter;
using PTMedicalInsurance.Variables;
using FastReport;
using Newtonsoft.Json;
using System.Threading;
using PTMedicalInsurance.Business;
using System.Xml.Linq;
using System.Diagnostics;
using System.Management;

namespace PTMedicalInsurance.Forms
{

    public partial class SettlementChecklist : Form
    {
        private int hospitalDr;
        private int interfaceDr;
        private string hospitalNO;
        private string interfaceNO;
        private string hospitalName;
        private string hospitalAreaCode;

        private bool disposed = false;

        Thread thread_test;

        private InvokeHelper invoker = new InvokeHelper();
        public SettlementChecklist()
        {
            InitializeComponent();
            hospitalDr = Global.inf.hospitalDr;
            hospitalNO = Global.inf.hospitalNO;
            hospitalName = Global.inf.hospitalName;
            hospitalAreaCode = Global.inf.areaCode;
            interfaceDr = Global.inf.interfaceDr;
        }
        public SettlementChecklist(JObject joParam)
        {
            InitializeComponent();
            hospitalDr = Global.inf.hospitalDr;
            hospitalNO = Global.inf.hospitalNO;
            hospitalName = Global.inf.hospitalName;
            hospitalAreaCode = Global.inf.areaCode;

            if (joParam == null) return;
            string setl_id = JsonHelper.getDestValue(joParam, "setl_id");
            if (setl_id == "")
            {
                MessageBox.Show("根据传入的结算编号为查询到相关信息，请手动输入查询！");
                return;
            }
            string sqlStr = "SELECT * FROM  bs_medinsusettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
            sqlStr = sqlStr + " and SettlementID='" + setl_id + "'";


            JObject joSqlStr = new JObject();
            joSqlStr.Add("sqlStr", sqlStr);
            MIIrisServices mIS = new MIIrisServices();
            JObject joRtn = mIS.QuerySettlementInfo(joSqlStr);
            DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
            dgvSettlRecord.DataSource = dt;
        }


        public void Dispose()
        {
            Dispose1(true);
            GC.SuppressFinalize(this);
        }

        protected virtual void Dispose1(bool disposing)
        {
            if (thread_test == null) return;
            if (disposed == false)
            {
                if (disposing == true)
                {
                    Thread.Sleep(100);
                    Global.writeLog("Main - aborting my thread.");
                    thread_test.Abort();//终止线程myThread
                    thread_test.Join();//等待线程myThread结束
                    Global.writeLog("Main - ending.");



                }
                //
                //释放托管资源的代码
            }
            disposed = true;
        }



        private void btnQuery_Click_1(object sender, EventArgs e)
        {
            string sqlStr = "SELECT * FROM  BS_MedInsuSettlement WHERE Hospital_Dr=" + hospitalDr + " AND Interface_Dr=" + Global.inf.interfaceDr;
            sqlStr = sqlStr + " and OccurTime>'" + dpST.Text + "'";
            sqlStr = sqlStr + " and OccurTime<'" + dpED.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);
            MIIrisServices mIS = new MIIrisServices();
            JObject joRtn = mIS.QuerySettlementInfo(joSqlStr);

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



        private void SettlementChecklist_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");

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

            rbgAdmType.SelectedIndex = 0;
            rbgBillType.SelectedIndex = 1;
        }

        private JObject getPatCheckList()
        {
            try
            {
                int i = dgvSettlRecord.CurrentRow.Index;
                DataTable dt = (DataTable)dgvSettlRecord.DataSource;
                JObject joSettel = new JObject();
                joSettel.Add("HospitalDr", Global.inf.hospitalDr);
                joSettel.Add("interfaceDr", Global.inf.interfaceDr);
                joSettel.Add("admID", dt.Rows[i]["AdmID"].ToString());
                joSettel.Add("SettlementID", dt.Rows[i]["SettlementID"].ToString());
                joSettel.Add("ValidFlag", dt.Rows[i]["ValidFlag"].ToString());

                JObject joRtn = invoker.invokeInsuService(JsonHelper.setIrisInpar("09010066", joSettel).ToString(), "获取结算单信息");
                return joRtn;
            }
            catch (Exception ex)
            {
                JObject joRtn = new JObject();
                joRtn.Add("errorCode", -1);
                joRtn.Add("errorMessage", ex.Message);
                return joRtn;

            }
        }

        private void uiPanel1_Click(object sender, EventArgs e)
        {

        }
        [STAThread]
        public void design()
        {
            try
            {
                string chineseSimpleFrl = Global.curEvt.path + @"\Chinese (Simplified).frl";
                FastReport.Utils.Res.LoadLocale(chineseSimpleFrl);

                JObject joSettleCheckList = getPatCheckList();
                string errMsg;
                if (JsonHelper.parseIrisRtnValue(joSettleCheckList, out errMsg) != 0)
                {
                    MessageBox.Show("查询结算信息异常：" + errMsg);
                    return;
                }
                Report report = new Report();
                try
                {
                    var json = JsonConvert.DeserializeObject<Root>(getPatCheckList().ToString());
                    report.RegisterData(json.result.data.classification, "classification");
                    report.RegisterData(json.result.data.settlement, "settlement");
                    report.RegisterData(json.result.data.reginfo, "reginfo");
                    report.RegisterData(json.result.data.patinsuinfo, "patinsuinfo");
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    return;
                }
                report.Load(Global.curEvt.path + "\\frx\\黑龙江结算单.frx");
                PrintDesign pf = new PrintDesign();
                pf.designerControl1.Report = report;

                report.Design();
                pf.WindowState = FormWindowState.Maximized;
                pf.ShowDialog();

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }


        }
        [STAThread]
        private void print()
        {
            string chineseSimpleFrl = Global.curEvt.path + @"\Chinese (Simplified).frl";
            FastReport.Utils.Res.LoadLocale(chineseSimpleFrl);

            JObject joSettleCheckList = getPatCheckList();
            string errMsg;
            if (JsonHelper.parseIrisRtnValue(joSettleCheckList, out errMsg) != 0)
            {
                MessageBox.Show("查询结算信息异常：" + errMsg);
                return;
            }
            Report report = new Report();
            try
            {
                var json = JsonConvert.DeserializeObject<Root>(getPatCheckList().ToString());
                report.RegisterData(json.result.data.classification, "classification");
                report.RegisterData(json.result.data.settlement, "settlement");
                report.RegisterData(json.result.data.reginfo, "reginfo");
                report.RegisterData(json.result.data.patinsuinfo, "patinsuinfo");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
            //report.Design();
            report.Load(Global.curEvt.path + "\\frx\\黑龙江结算单.frx");
            this.ShowInTaskbar = true;
            PrintPreview pf = new PrintPreview();
            report.Preview = pf.previewControl1;

            report.Show();
            pf.WindowState = FormWindowState.Maximized;
            pf.ShowDialog();

        }

        [STAThread]
        private void print_yh(object o)
        {
            string outParam = "", errMsg = "";
            try
            {
                int i = dgvSettlRecord.CurrentRow.Index;
                DataTable dt = (DataTable)dgvSettlRecord.DataSource;

                Global.pat.insuplc_admdvs = dt.Rows[i]["insuplc_admdvs"].ToString();//
                Global.pat.insuType = dt.Rows[i]["InsuranceType"].ToString();//JsonHelper.getDestValue(joSettlInfo, "result.data[0].InsuranceType");
                Global.pat.medType = dt.Rows[i]["MedicalType"].ToString();//JsonHelper.getDestValue(joSettlInfo, "result.data[0].MedicalType");
                Global.pat.psn_type = dt.Rows[i]["PersonType"].ToString();//JsonHelper.getDestValue(joSettlInfo, "result.data[0].PersonType");
                dynamic joTmp = new JObject();
                joTmp.prm_akc190 = Global.pat.mdtrtID;
                joTmp.prm_yab003 = Global.pat.insuplc_admdvs;
                joTmp.prm_aka130 = Global.pat.medType;
                joTmp.prm_akc021 = Global.pat.psn_type;
                joTmp.prm_yka103 = Global.pat.settlID;
                joTmp.prm_ykb065 = Global.pat.insuType;
                joTmp.prm_yabtch = Global.pat.insuplc_admdvs;


                YinHaiCom yhcom = new YinHaiCom();
                yhcom.Init(out errMsg);
                string jylsh = "", jyyzm = "", jysc = "", appmsg = string.Empty;
                JObject joInput = new JObject();
                joInput.Add("input", joTmp);
                XmlHelper xmler = new XmlHelper();
                string input = xmler.ToXML(joInput.ToString());
                XElement xe = XElement.Parse(input);
                string jysr = xmler.setInput(xe);
                int appcode = -1;
                yhcom.Call("44", jysr, ref jylsh, ref jyyzm, ref jysc, ref appcode, ref appmsg);
                KillChildProcessByName("conhost");
                if (appcode > 0)
                {
                    outParam = jysc;
                }
                else
                {
                    outParam = appmsg;
                    CallBack(outParam);
                }
                //if (invoker.invokeYHCom("44", joTmp, out errMsg) != 0)
                //{
                //    outParam = JsonHelper.setIrisReturnValue(-1, errMsg, null).ToString();
                //}
                //else
                //{
                //    outParam = JsonHelper.setIrisReturnValue(0, "", null).ToString();
                //}
                

            }
            catch (Exception ex)
            {
                CallBack(ex.Message);
            }

        }


        private void print_exe()
        {
            string outParam = "", errMsg = "";
            try
            {
                int i = dgvSettlRecord.CurrentRow.Index;
                DataTable dt = (DataTable)dgvSettlRecord.DataSource;

                Global.pat.insuplc_admdvs = dt.Rows[i]["insuplc_admdvs"].ToString();//
                Global.pat.insuType = dt.Rows[i]["InsuranceType"].ToString();//JsonHelper.getDestValue(joSettlInfo, "result.data[0].InsuranceType");
                Global.pat.medType = dt.Rows[i]["MedicalType"].ToString();//JsonHelper.getDestValue(joSettlInfo, "result.data[0].MedicalType");
                Global.pat.psn_type = dt.Rows[i]["PersonType"].ToString();//JsonHelper.getDestValue(joSettlInfo, "result.data[0].PersonType");
                dynamic joTmp = new JObject();
                joTmp.prm_akc190 = Global.pat.mdtrtID;
                joTmp.prm_yab003 = Global.pat.insuplc_admdvs;
                joTmp.prm_aka130 = Global.pat.medType;
                joTmp.prm_akc021 = Global.pat.psn_type;
                joTmp.prm_yka103 = Global.pat.settlID;
                joTmp.prm_ykb065 = Global.pat.insuType;
                joTmp.prm_yabtch = Global.pat.insuplc_admdvs;

                JObject joInput = new JObject();
                joInput.Add("input", joTmp);


                string inpar = joInput.ToString();
                inpar =inpar.Replace(@"""", @"""""""");
                //inpar = @"""" + inpar + @"""";
                inpar = "\"" + inpar + "\"";
                MessageBox.Show(inpar);
                Process p = new Process();
                p.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;     //把窗口隐藏，使其在后台运行
                p.StartInfo.FileName = Global.curEvt.path + "\\SettlList.exe ";
                p.StartInfo.Arguments = inpar;

                p.Start();
                //Process p = Process.Start(Global.curEvt.path + "\\SettlList.exe " ,inpar);

            }
            catch (Exception ex)
            {
                
            }
        }

        [STAThread]
        private void preview()
        {
            //JObject joCheckList = getPatCheckList();
            Report report = new Report();
            try
            {
                var json = JsonConvert.DeserializeObject<Root>(getPatCheckList().ToString());
                report.RegisterData(json.result.data.classification, "classification");
                report.RegisterData(json.result.data.settlement, "settlement");
                report.RegisterData(json.result.data.reginfo, "reginfo");
                report.RegisterData(json.result.data.patinsuinfo, "patinsuinfo");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
            //report.Design();
            report.Load(Global.curEvt.path + "\\frx\\黑龙江结算单.frx");
            //report.Show();
            PrintPreview preview1 = new PrintPreview();
            preview1.Show();
            report.Preview = preview1.previewControl1;

            report.Prepare(); //准备
            report.ShowPrepared(); //显示
            preview1.Show();
        }

        private void uiButton2_Click(object sender, EventArgs e)
        {
            KillChildProcessByName("conhost");
            Close();
        }

        public void btnPrint_Click(object sender, EventArgs e)
        {
            try
            {
                Thread thread = new Thread(new ThreadStart(print));
                thread.SetApartmentState(ApartmentState.STA); //重点
                thread.Start();
                thread.Join();
            }
            catch (Exception ex)
            {
                Global.writeLog("结算单打印异常:" + ex.Message);
                MessageBox.Show("打印异常:" + ex.Message);
            }

        }

        private void btnDesign_Click(object sender, EventArgs e)
        {
            thread_test = new Thread(new ThreadStart(design));
            thread_test.SetApartmentState(ApartmentState.STA); //重点
            thread_test.Start();
        }

        private void SettlementChecklist_FormClosed(object sender, FormClosedEventArgs e)
        {
            Dispose();
        }

        public void KillChildProcessByName(string processName)
        {
            try
            {
                Process p = Process.GetCurrentProcess();
                ManagementObjectSearcher searcher = new ManagementObjectSearcher("Select * From Win32_Process Where ParentProcessID=" + p.Id);
                ManagementObjectCollection moc = searcher.Get();
                foreach (ManagementObject mo in moc)
                {
                    //MessageBox.Show(mo["ProcessID"].ToString());
                    Process p1 = Process.GetProcessById(Convert.ToInt32(mo["ProcessID"]));
                    if (p1.ProcessName == processName)
                    {
                        //MessageBox.Show(p1.ProcessName + ":" + p1.Id.ToString());
                        p1.Kill();
                        p1.WaitForExit(); // possibly with a timeout
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("KillChildProcessByName:" + ex.Message);

            }
        }

        public void CallBack(string errMsg)
        {
            MessageBox.Show(errMsg);
        }
        public delegate void callBack(string errMsg);
        private void btPrintYH_Click(object sender, EventArgs e)
        {
            //Thread thread = new Thread(print_yh);
            //callBack cb = new callBack(CallBack);
            //thread.SetApartmentState(ApartmentState.STA); //重点
            //thread.IsBackground = true;
            //thread.Start(cb);

            //thread.Join();
            print_exe();



        }
    }

    // Root myDeserializedClass = JsonConvert.DeserializeObject<Root>(myJsonResponse);
    public class Classification
    {
        public string cwfSummat { get; set; }
        public string cwfInScope { get; set; }
        public string cwfPreSelfPay { get; set; }
        public string cwfOverLimit { get; set; }
        public string cwfFullOwnPay { get; set; }
        public string zcfSummat { get; set; }
        public string zcfInScope { get; set; }
        public string zcfPreSelfPay { get; set; }
        public string zcfOverLimit { get; set; }
        public string zcfFullOwnPay { get; set; }
        public string jcfSummat { get; set; }
        public string jcfInScope { get; set; }
        public string jcfPreSelfPay { get; set; }
        public string jcfOverLimit { get; set; }
        public string jcfFullOwnPay { get; set; }
        public string hyfSummat { get; set; }
        public string hyfInScope { get; set; }
        public string hyfPreSelfPay { get; set; }
        public string hyfOverLimit { get; set; }
        public string hyfFullOwnPay { get; set; }
        public string zlfSummat { get; set; }
        public string zlfInScope { get; set; }
        public string zlfPreSelfPay { get; set; }
        public string zlfOverLimit { get; set; }
        public string zlfFullOwnPay { get; set; }
        public string ssfSummat { get; set; }
        public string ssfInScope { get; set; }
        public string ssfPreSelfPay { get; set; }
        public string ssfOverLimit { get; set; }
        public string ssfFullOwnPay { get; set; }
        public string hlfSummat { get; set; }
        public string hlfInScope { get; set; }
        public string hlfPreSelfPay { get; set; }
        public string hlfOverLimit { get; set; }
        public string hlfFullOwnPay { get; set; }
        public string wsclfSummat { get; set; }
        public string wsclfInScope { get; set; }
        public string wsclfPreSelfPay { get; set; }
        public string wsclfOverLimit { get; set; }
        public string wsclfFullOwnPay { get; set; }
        public string xyfSummat { get; set; }
        public string xyfInScope { get; set; }
        public string xyfPreSelfPay { get; set; }
        public string xyfOverLimit { get; set; }
        public string xyfFullOwnPay { get; set; }
        public string zyypfSummat { get; set; }
        public string zyypfInScope { get; set; }
        public string zyypfPreSelfPay { get; set; }
        public string zyypfOverLimit { get; set; }
        public string zyypfFullOwnPay { get; set; }
        public string zcyfSummat { get; set; }
        public string zcyfInScope { get; set; }
        public string zcyfPreSelfPay { get; set; }
        public string zcyfOverLimit { get; set; }
        public string zcyfFullOwnPay { get; set; }
        public string ybzlfSummat { get; set; }
        public string ybzlfInScope { get; set; }
        public string ybzlfPreSelfPay { get; set; }
        public string ybzlfOverLimit { get; set; }
        public string ybzlfFullOwnPay { get; set; }
        public string ghfSummat { get; set; }
        public string ghfInScope { get; set; }
        public string ghfPreSelfPay { get; set; }
        public string ghfOverLimit { get; set; }
        public string ghfFullOwnPay { get; set; }
        public string qtSummat { get; set; }
        public string qtInScope { get; set; }
        public string qtPreSelfPay { get; set; }
        public string qtOverLimit { get; set; }
        public string qtFullOwnPay { get; set; }
        public string totalSummat { get; set; }
        public string totalInScope { get; set; }
        public string totalPreSelfPay { get; set; }
        public string totalOverLimit { get; set; }
        public string totalFullOwnPay { get; set; }
    }

    public class Data
    {
        public List<Classification> classification { get; set; }
        public List<Settlement> settlement { get; set; }
        public List<Reginfo> reginfo { get; set; }
        public List<Patinsuinfo> patinsuinfo { get; set; }
    }

    public class Patinsuinfo
    {
        public string PsnCertType { get; set; }
        public string PsnCertNO { get; set; }
        public string Gend { get; set; }
        public string Naty { get; set; }
        public string Brdy { get; set; }
        public string Age { get; set; }
        public string Balc { get; set; }
        public string PsnType { get; set; }
        public string Cvlservflag { get; set; }
        public string insuplcAdmdvs { get; set; }
        public string EmpName { get; set; }
        public string PsnIdettype { get; set; }
        public string PsnTypeLv { get; set; }
    }

    public class Reginfo
    {
        public string OccurTime { get; set; }
        public string InsuranceAreaCode { get; set; }
        public string AttendDoctorNO { get; set; }
        public string ChiefPhyDocName { get; set; }
        public string AdmitDepartmentCode { get; set; }
        public string AdmitDepartmentName { get; set; }
        public string AdmBed { get; set; }
        public string MainDiagCode { get; set; }
        public string MainDiagName { get; set; }
        public string RegDate { get; set; }
        public string ConerName { get; set; }
        public string Tel { get; set; }
    }

    public class Result
    {
        public Data data { get; set; }
    }

    public class Root
    {
        public Result result { get; set; }
        public int errorCode { get; set; }
        public string errorMessage { get; set; }
    }

    public class Settlement
    {
        public string AdmID { get; set; }
        public string MdtrtID { get; set; }
        public string SettlementID { get; set; }
        public string PersonnelNO { get; set; }
        public string PatientName { get; set; }
        public string birth { get; set; }
        public string CertificateNO { get; set; }
        public string Gender { get; set; }
        public string InsuranceType { get; set; }
        public string PersonType { get; set; }
        public string CivilserviceFlag { get; set; }
        public string SettlementTime { get; set; }
        public string MedicalType { get; set; }
        public string Sumamt { get; set; }
        public string OwnPayAmount { get; set; }
        public string OverLimitAmount { get; set; }
        public string PreSelfPayAmount { get; set; }
        public string InPolicyRangeAmount { get; set; }
        public double ActualPayDeductible { get; set; }
        public string HealthInsurancePay { get; set; }
        public string HealthInsuranceRatio { get; set; }
        public double CivilserviceAllowancePay { get; set; }
        public string EnterpriseSupplementPay { get; set; }
        public string SeriousIllnessPay { get; set; }
        public string LargeExpensesSupplementPay { get; set; }
        public string MedicalAssistPay { get; set; }
        public string HospitalPartAmount { get; set; }
        public string OtherPay { get; set; }
        public string FundPaySumamt { get; set; }
        public string PersonPaySumamt { get; set; }
        public string AccountPaySumamt { get; set; }
        public string PersonCashPay { get; set; }
        public string Balance { get; set; }
        public string AccountMutualAidAmount { get; set; }
        public string OrganSettlementID { get; set; }
        public string ClearingOrgan { get; set; }
        public string ClearingWay { get; set; }
        public string ClearingType { get; set; }
        public string ValidFlag { get; set; }
        public string msgid { get; set; }
        public string HospitalizationsTimes { get; set; }
        public string HospitalizationsDays { get; set; }
        public string HISAdmTime { get; set; }
        public string HISDischargeTime { get; set; }
        public int BillType { get; set; }
        public string BillID { get; set; }
        public string admType { get; set; }
        public string RecordID { get; set; }
        public string insuplc_admdvs { get; set; }
    }


}