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 PTMedicalInsurance.Common; using PTMedicalInsurance.Helper; using PTMedicalInsurance.Variables; namespace PTMedicalInsurance.Forms { public partial class OutpatientRegistration : Form { public OutpatientRegistration() { InitializeComponent(); this.StartPosition = FormStartPosition.CenterParent; /* string sqlCondition = " and Interface_ID = '" + Global.inf.InterfaceID + "'"; string sqlStr = "select sNO AS Code,Name FROM CloudMedicalInsurancePlatform_Tables.Dictionary where Type = 'insutype'" + sqlCondition; //SetDBLKCombox(ref dblkcbxInsuranceType, sqlStr); string sqlStr2 = "select Code,Name FROM CloudMedicalInsurancePlatform_Tables.Dictionary where Type='insutype' and Interface_Dr = '7'and Hosp_Dr ='63'"; SetDBLKCombox(ref dblkcbxInsuranceType, sqlStr2); sqlStr = "select Code,SectionName AS Name FROM CloudMedicalInsurancePlatform_Tables.Diagnose where Type='Diagnose'" + sqlCondition; SetDBLKCombox(ref dblkcbxDisease, sqlStr2); sqlStr = "select sNO AS Code,Name FROM CloudMedicalInsurancePlatform_Tables.Dictionary where Type = 'psn_setlway'" + sqlCondition; SetDBLKCombox(ref dblkcbxSettelmentWay, sqlStr); sqlStr = "select sNO AS Code,Name FROM CloudMedicalInsurancePlatform_Tables.Dictionary where Type = 'MED_TYPE'" + sqlCondition; SetDBLKCombox(ref dblkcbxMedicalType, sqlStr); sqlStr = "select Code,Name FROM CloudMedicalInsurancePlatform_Tables.Diagnose where Type='Operation'" + sqlCondition; SetDBLKCombox(ref dblkcbxOperation, sqlStr); */ string sqlCondition = " and A.Interface_Dr = '" + Global.inf.interfaceDr.ToString() + "'"; if (Global.pat.RYorCY == "2") { string sqlStr = " SELECT B.Code,B.Descripts AS Name FROM HB_Dictionary A JOIN HB_DictionaryDataDetail B ON A.ID = B.HBDictionary_Dr " + " WHERE B.Code='" + Global.pat.insuType + "' and A.InsuCode = 'BAE059'" + sqlCondition; SetDBLKCombox(ref dblkcbxInsuranceType, sqlStr); sqlStr = " SELECT B.Code,B.Descripts AS Name FROM HB_Dictionary A JOIN HB_DictionaryDataDetail B ON A.ID = B.HBDictionary_Dr" + " WHERE B.Code='" + Global.pat.medType + "' and A.InsuCode = 'AKA130'" + sqlCondition; SetDBLKCombox(ref dblkcbxMedicalType, sqlStr); } else { string sqlStr = " SELECT B.Code,B.Descripts AS Name FROM HB_Dictionary A JOIN HB_DictionaryDataDetail B ON A.ID = B.HBDictionary_Dr " + " WHERE A.InsuCode = 'BAE059'" + sqlCondition; SetDBLKCombox(ref dblkcbxInsuranceType, sqlStr); sqlStr = " SELECT B.Code,B.Descripts AS Name FROM HB_Dictionary A JOIN HB_DictionaryDataDetail B ON A.ID = B.HBDictionary_Dr " + " WHERE A.InsuCode = 'AKA130'" + sqlCondition; SetDBLKCombox(ref dblkcbxMedicalType, sqlStr); } cbxAccountPay.Checked = true; personAccountUsedFlag = "1"; } public Boolean b2001 = false; 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; } public string personAccountUsedFlag = "0"; //public string sYBDJLSH; 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 SetDBLKCombox(ref PTControl.DBLookupCombox dblcbx, string sqlStr) { dblcbx.sDisplayField = "Code,Name,SearchCode"; dblcbx.sDisplayMember = "名称"; dblcbx.sKeyWords = "Code,SearchCode"; dblcbx.DataSource = GetDBLKComboxTable(sqlStr); 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) { dgvDiagnose.AutoGenerateColumns = false; dgvDiagnose.DataSource = DtDiagnose; //DtDiagnose.AcceptChanges(); dgvDiagnose.ReadOnly = true; } 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(); Global.pat.insuType = insuType; } 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(); Global.pat.medType = med_type; Global.pat.medTypeName = med_type_name; } private void cbxAccountPay_ValueChanged(object sender, bool value) { if (cbxAccountPay.Checked) { personAccountUsedFlag = "1"; } else { personAccountUsedFlag = "0"; } } private void btnOK_Click(object sender, EventArgs e) { //Global.pat.mdtrtID = sYBDJLSH; if (cbxAccountPay.Checked) Global.pat.personAccountUsedFlag = 1; else Global.pat.personAccountUsedFlag = 0; if (chk_SJDSFBZ.Checked) Global.pat.relttpflag = 1; else Global.pat.relttpflag = 0; if (chk_WSBZ.Checked) Global.pat.trumflag = 1; else Global.pat.trumflag = 0; if (cbb_JZRQLX.SelectedIndex >= 0) Global.pat.mdtrtgrptype = cbb_JZRQLX.Text.Trim().Substring(0, 1); this.DialogResult = DialogResult.OK; } private void btnCancel_Click(object sender, EventArgs e) { this.DialogResult = DialogResult.Cancel; } } }