MedicalInsurance/ChengDu/ChengDuMedInsu2/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 MedicalInsurance.Helper;
using MedicalInsurance.Common;
using Newtonsoft.Json.Linq;
using MedicalInsurance.FormSetter;

namespace MedicalInsurance.Forms
{
    public partial class SettlementChecklist : Form
    {
        private int hospitalDr;
        private int interfaceDr;
        private string hospitalNO;
        private string interfaceNO;
        private string hospitalName;
        private string hospitalAreaCode;
        public SettlementChecklist()
        {
            InitializeComponent();
            hospitalDr = GlobalVariables.hospitalDr;
            hospitalNO = GlobalVariables.hospitalNO;
            hospitalName = GlobalVariables.hospitalName;
            hospitalAreaCode = GlobalVariables.hospitalAreaCode;
        }
        public SettlementChecklist(JObject joParam)
        {
            InitializeComponent();
            hospitalDr = GlobalVariables.hospitalDr;
            hospitalNO = GlobalVariables.hospitalNO;
            hospitalName = GlobalVariables.hospitalName;
            hospitalAreaCode = GlobalVariables.hospitalAreaCode;

            if (joParam == null) return;

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

            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(), "查询结算信息");

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

        private void rbgDirecType_ValueChanged(object sender, int index, string text)
        {

        }

        private void btnQuery_Click(object sender, EventArgs e)
        {

        }

        private void btnQuery_Click_1(object sender, EventArgs e)
        {
            string sqlStr = "SELECT * FROM  MedInsu_Tables.Settlement WHERE Hosp_Dr=" + hospitalDr ;
            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 (cbxInterface.Text !="")
            //{
            //    sqlStr = sqlStr + " and Interface_Dr=" + GlobalVariables.interfaceDr + "";
            //}

            //if (rbgAdmType.SelectedIndex == 1)
            //{
            //    sqlStr = sqlStr + " and Adm_Dr=1" ;
            //}
            //if (rbgAdmType.SelectedIndex == 2)
            //{
            //    sqlStr = sqlStr + " and Adm_Dr=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(),"查询结算信息");

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

        private void btnDownload_Click(object sender, EventArgs e)
        {
            InvokeHelper invoker = new InvokeHelper();
            DataTable dt =(DataTable)dgvSettlRecord.DataSource  ;



            string printRtn = "";
            JObject joInparam = new JObject();
            int a = dgvSettlRecord.CurrentRow.Index;
            joInparam.Add("setl_id", dt.Rows[a]["SettlementID"].ToString());
            joInparam.Add("psn_no", dt.Rows[a]["PersonnelNO"].ToString());
            joInparam.Add("mdtrt_id", dt.Rows[a]["MdtrtID"].ToString());
            joInparam.Add("med_type", dt.Rows[a]["MedicalType"].ToString());
            joInparam.Add("mdtrtarea_admvs", hospitalAreaCode);//结算单需要存字段
            joInparam.Add("fixmedins_code", hospitalNO);
            joInparam.Add("fixmedins_name", hospitalName);
            invoker.printYHCom(joInparam.ToString(), out printRtn);

            JObject joRtn = JObject.Parse(printRtn);
            if (JsonHelper.getJsonValue(joRtn, "code") != "1")
            {
                MessageBox.Show(JsonHelper.getJsonValue(joRtn, "message"));
            }

        }

        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");

            ComboxSetter cbxSetter = new ComboxSetter();
            cbxSetter.setCbxInterfaceDataSource(cbxInterface);

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

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


            cbxInterface.SelectedValueChanged += new EventHandler(cbxInterface_SelectedValueChanged);
        }

        private void cbxInterface_SelectedValueChanged(object sender, EventArgs e)
        {
            DataTable dt = (DataTable)cbxInterface.DataSource;
            int i = cbxInterface.SelectedIndex;

            //赋值
            hospitalNO = dt.Rows[i]["HospitalNO"].ToString();
            //MessageBox.Show(dt.Rows[i]["HospitalDr"].ToString());
            //MessageBox.Show(dt.Rows[i]["HospitalDr"].ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly);
            hospitalDr = int.Parse(dt.Rows[i]["HospitalDr"].ToString());
            interfaceNO = dt.Rows[i]["InterfaceNO"].ToString();
            interfaceDr = int.Parse(dt.Rows[i]["ID"].ToString());
            hospitalAreaCode = dt.Rows[i]["AreaCode"].ToString();
            //GlobalVariables.centerURL = dt.Rows[i]["CenterURL"].ToString();
            //GlobalVariables.businessDllName = dt.Rows[i]["DLLName"].ToString();
            //GlobalVariables.patientAreaCode = dt.Rows[i]["AreaCode"].ToString();
        }

        private void uiPanel1_Click(object sender, EventArgs e)
        {

        }
    }
}