MedicalInsurance/ChengDu/ChengDuMedInsu2/OutpatientRegistration_old.cs

using Newtonsoft.Json;
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 MedicalInsurance.Helper;
namespace ChengDuMedInsu2
{
    public partial class OutpatientRegistration : Form
    {
        public OutpatientRegistration()
        {
            InitializeComponent();
        }

        private DataTable dtDisease;
        private DataTable dtDiseaseType;
        private DataTable dtInsuranceType;
        private DataTable dtMedicalType;
        private DataTable dtOperation;
        private DataTable dtSettelmentType;
        //险种
        public string  insuType { get; set; }
        public string insuTypeName { get; set; }
        //医疗类别
        public string med_type { get; set; }
        public string med_type_name { get; set; }
        //诊断
        public string diseCodg { get; set; }

        public string diseName{ get; set; }
        //手术
        public string oprn_oprt_code { get; set; }
        public string oprn_oprt_name{ get; set; }
        //病种
        public string dise_type_code { get; set; }

        public string dise_type_name { get; set; }
        //结算方式
        public string psn_setlway { get; set; }

        public string psn_setlway_name { get; set; }

        public DataTable DtDiagnose { get; set; }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private DataTable GetDBLKComboxTable(string sqlStr)
        {
            JObject jsonRtn = new JObject();
            string inParam = "";
            IrisServices iris = new IrisServices();
            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";
            inParam = joInparm.ToString();
            InvokeHelper helper = new InvokeHelper();
            jsonRtn =  helper.invokeIrisService(inParam, "GetDBLKComboxTable");
            DataTable dt = (DataTable)jsonRtn["result"].ToObject(typeof(DataTable));
            //dt.Columns[0].ColumnName = "编码";
            //dt.Columns[1].ColumnName = "名称";
            //dt.Columns[2].ColumnName = "拼音查找码";
            return dt;
           
        }
        private void SetDBLKCombox(ref  PTControl.DBLookupCombox dblcbx, string sqlStr)
        {
            dblcbx.sDisplayField = "Code,Name,SearchCode";
            dblcbx.sDisplayMember = "名称";
            dblcbx.sKeyWords = "SearchCode";
            DataTable dt = GetDBLKComboxTable(sqlStr);
            dblcbx.DataSource = dt;
            dblcbx.RowFilterVisible = true;
            dblcbx.TextBox.Width = 400;
            dblcbx.DataGridView.Width = 400;
            dblcbx.DataGridView.Columns[0].Name = "编码";
            dblcbx.DataGridView.Columns[1].Name = "名称";
            dblcbx.DataGridView.Columns[2].Name = "查找码";
            dblcbx.DataGridView.Columns[0].Width = 100;
            dblcbx.DataGridView.Columns[1].Width = 200;
        }
        private void OutpatientRegistration_Load(object sender, EventArgs e)
        {
            string sqlCondition = " and Interface_Dr = '" + GlobalVariables.interfaceDr.ToString() + "'";
            sqlCondition = sqlCondition + "and Hosp_Dr ='" + GlobalVariables.hospitalDr.ToString() + "'";
            string sqlStr = "select  Code,Name FROM CloudMedicalInsurancePlatform_Tables.Dictionary where Type = 'insutype'" + sqlCondition;
            SetDBLKCombox(ref dblkcbxInsuranceType, sqlStr);

            //sqlStr = "select Code, Name FROM CloudMedicalInsurancePlatform_Tables.Directory where HisType=4" + sqlCondition;
            //SetDBLKCombox(ref dblkcbxDisease, sqlStr);

            sqlStr = "select  Code,Name FROM CloudMedicalInsurancePlatform_Tables.Dictionary where Type = 'psn_setlway'" + sqlCondition;
            SetDBLKCombox(ref dblkcbxSettelmentWay, sqlStr);

            sqlStr = "select  Code,Name FROM CloudMedicalInsurancePlatform_Tables.Dictionary where Type = 'MED_TYPE'" + sqlCondition;
            SetDBLKCombox(ref dblkcbxMedicalType, sqlStr);

            //sqlStr = "select Code,Name FROM CloudMedicalInsurancePlatform_Tables.Directory where HisType=5" + sqlCondition;
            //SetDBLKCombox(ref dblkcbxOperation, sqlStr);

            dgvDiagnose.DataSource = DtDiagnose;
            //DataGridViewColumn column = new PTControl.DataGridViewDBLKBColumn();

            //(column as PTControl.DataGridViewDBLKBColumn).SDisplayField = "Code,Name,SearchCode";
            //(column as PTControl.DataGridViewDBLKBColumn).SDisplayMember = "Name";
            //(column as PTControl.DataGridViewDBLKBColumn).SKeyWords = "SearchCode";

            //column.DataGridView.Width = 400;
            //column.DataGridView.Columns[0].Name = "编码";
            //column.DataGridView.Columns[1].Name = "名称";
            //column.DataGridView.Columns[2].Name = "查找码";
            //column.DataGridView.Columns[0].Width = 100;
            //column.DataGridView.Columns[1].Width = 200;
            //sqlStr = "select sNO AS Code,Name FROM CloudMedicalInsurancePlatform_Tables.Dictionary where Type = 'psn_setlway'" + sqlCondition;
            //(column as PTControl.DataGridViewDBLKBColumn).DataSource = GetDBLKComboxTable(sqlStr);
            //dgvDiagnose.Columns.Add(column);
            //dgvDiagnose.Columns[10].Name = "测试";
            //dgvDiagnose.Columns[10].DisplayIndex = 0;
            //string diseaseTypeParam = string.Empty;
            //string diseaseTypeRtn = iris.Invoke(diseaseTypeParam);
            //dynamic diseaseTypeRtnRtnJson = JsonConvert.DeserializeObject(diseaseTypeRtn);
            //dtDiseaseType = (DataTable)diseaseTypeRtnRtnJson.ToObject(typeof(DataTable));

            //string insuranceTypeParam = string.Empty;
            //string insuranceTypeRtn = iris.Invoke(insuranceTypeParam);
            //dynamic insuranceTypeRtnRtnJson = JsonConvert.DeserializeObject(insuranceTypeRtn);
            //dtInsuranceType = (DataTable)insuranceTypeRtnRtnJson.ToObject(typeof(DataTable));
        }

        private void button1_Click(object sender, EventArgs e)
        {

        }

        private void button1_Click_1(object sender, EventArgs e)
        {
            this.DialogResult = DialogResult.OK;
        }

        private void dblkcbxInsuranceType_AfterSelector(object sender, PTControl.AfterSelectorEventArgs e)
        {
            DataGridViewRow row = e.Value as DataGridViewRow;
            DataRowView dataRow = row.DataBoundItem as DataRowView;

            insuType = dataRow["Code"].ToString().Trim();
            insuTypeName = dataRow["Name"].ToString().Trim();
        }

        private void dblkcbxMedicalType_AfterSelector(object sender, PTControl.AfterSelectorEventArgs e)
        {
            DataGridViewRow row = e.Value as DataGridViewRow;
            DataRowView dataRow = row.DataBoundItem as DataRowView;

            med_type = dataRow["Code"].ToString().Trim();
            med_type_name = dataRow["Name"].ToString().Trim();
        }

        private void dblkcbxDisease_AfterSelector(object sender, PTControl.AfterSelectorEventArgs e)
        {
            DataGridViewRow row = e.Value as DataGridViewRow;
            DataRowView dataRow = row.DataBoundItem as DataRowView;

            diseCodg = dataRow["Code"].ToString().Trim();
            diseName = dataRow["Name"].ToString().Trim();
        }

        private void dblkcbxOperation_AfterSelector(object sender, PTControl.AfterSelectorEventArgs e)
        {
            DataGridViewRow row = e.Value as DataGridViewRow;
            DataRowView dataRow = row.DataBoundItem as DataRowView;

            oprn_oprt_code = dataRow["Code"].ToString().Trim();
            oprn_oprt_name = dataRow["Name"].ToString().Trim();
        }

        private void dblkcbxSettelmentWay_AfterSelector(object sender, PTControl.AfterSelectorEventArgs e)
        {
            DataGridViewRow row = e.Value as DataGridViewRow;
            DataRowView dataRow = row.DataBoundItem as DataRowView;

            psn_setlway = dataRow["Code"].ToString().Trim();
            psn_setlway_name = dataRow["Name"].ToString().Trim();
        }

        private void dblkcbxDiseaseType_AfterSelector(object sender, PTControl.AfterSelectorEventArgs e)
        {
            DataGridViewRow row = e.Value as DataGridViewRow;
            DataRowView dataRow = row.DataBoundItem as DataRowView;

            dise_type_code = dataRow["Code"].ToString().Trim();
            dise_type_name = dataRow["Name"].ToString().Trim();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.DialogResult = DialogResult.Cancel;
        }
    }
}