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 Newtonsoft.Json.Linq; using PTMedicalInsurance.Helper; using PTMedicalInsurance.Variables; using PTMedicalInsurance.Business; using PTMedicalInsurance.Common; using PTMedicalInsurance.Forms.Setters.PatientInsuInfos; namespace PTMedicalInsurance.Forms { public partial class PatientInsuInfo : Form { public DataTable dtInsuInfo; public DataTable dtIDInfo; public JObject joSelectedInsuInfo; public int insuInfoIndex = 0; public int idInfoIndex = 0; InvokeHelper invoker = new InvokeHelper(); private MIIrisServices mIS = new MIIrisServices(); private DataTable dtFundPayType; private Form mainForm; //1.声明自适应类实例 AutoResizeForm asc = new AutoResizeForm(); public PatientInsuInfo() { InitializeComponent(); this.StartPosition = FormStartPosition.CenterParent; asc.controllInitializeSize(this); asc.controlAutoSize(this); } public PatientInsuInfo(JObject jo, Form frm) { InitializeComponent(); InitForm(jo, frm); } private void InitForm(JObject jo) { dtInsuInfo = (DataTable)jo["insuinfo"].ToObject(typeof(DataTable)); dtIDInfo = (DataTable)jo["idetinfo"].ToObject(typeof(DataTable)); JObject joBaseInfo = JObject.FromObject(jo["baseinfo"]); this.tbName.Text = joBaseInfo["psn_name"].ToString(); this.tbPsnNO.Text = joBaseInfo["psn_no"].ToString(); this.tbGend.Text = joBaseInfo["gend"].ToString(); this.tbBirthDay.Text = joBaseInfo["brdy"].ToString(); this.tbNaty.Text = joBaseInfo["naty"].ToString(); this.tbCertType.Text = joBaseInfo["psn_cert_type"].ToString(); this.tbCertNO.Text = joBaseInfo["certno"].ToString(); this.tbAge.Text = joBaseInfo["age"].ToString(); string expContent = joBaseInfo["exp_content"].ToString(); //字段扩展 只有居民返回 //JObject joInsuInfo = JObject.FromObject(jo["insuinfo"]); //Global.pat.insuType= joInsuInfo["insutypeNo"].ToString(); setDgvIDInfo(); setDgvInsuInfo(); setDgvTreatement(dgvTreatment); dgvInsuInfo.DataSource = dtInsuInfo; dgvIDInfo.DataSource = dtIDInfo; //获取通用目录 string sTYML = mIS.GetCommonInterface_Dr(Global.inf.interfaceDr.ToString(), ""); if (sTYML == "") Global.inf.interfaceDr_TY = Global.inf.interfaceDr; else Global.inf.interfaceDr_TY = int.Parse(sTYML); string sqlCondition = " and A.Interface_Dr = '" + Global.inf.interfaceDr_TY.ToString() + "'"; 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 = 'fund_pay_type'" + sqlCondition; dtFundPayType = GetDBLKComboxTable(sqlStr); } private void InitForm(JObject jo, Form frm) { InitForm(jo); mainForm = frm; CheckForIllegalCrossThreadCalls = false; // 禁用关闭按钮 this.FormBorderStyle = FormBorderStyle.None; // 隐藏标题栏 this.ControlBox = false; // 其他可能需要的配置 if (mainForm != this) { this.TopLevel = false; this.Dock = DockStyle.Fill; // 根据需要设置 Dock 属性 } else { this.WindowState = FormWindowState.Maximized; } // //grdSetter.setHisRegInfo(dgvHisRegInfo); //grdSetter.setCenterApplyInfo(dgvCenterApplyInfo); } public PatientInsuInfo(JObject jo) { InitializeComponent(); dtInsuInfo = (DataTable)jo["insuinfo"].ToObject(typeof(DataTable)); dtIDInfo = (DataTable)jo["idetinfo"].ToObject(typeof(DataTable)); JObject joBaseInfo = JObject.FromObject(jo["baseinfo"]); this.tbName.Text = joBaseInfo["psn_name"].ToString(); this.tbPsnNO.Text = joBaseInfo["psn_no"].ToString(); this.tbGend.Text = joBaseInfo["gend"].ToString(); this.tbBirthDay.Text = joBaseInfo["brdy"].ToString(); this.tbNaty.Text = joBaseInfo["naty"].ToString(); this.tbCertType.Text = joBaseInfo["psn_cert_type"].ToString(); this.tbCertNO.Text = joBaseInfo["certno"]+""; this.tbAge.Text = joBaseInfo["age"] + ""; //JObject joInsuInfo = JObject.FromObject(jo["insuinfo"]); //Global.pat.insuType= joInsuInfo["insutypeNo"].ToString(); GridViewSetter grdSetter = new GridViewSetter(); grdSetter.setDgvIDInfo(dgvIDInfo); grdSetter.setDgvInsuInfo(dgvInsuInfo); grdSetter.setDgvAccumutual(dgvAccumulativeInfo); grdSetter.setDgvPaymentDetail(dgvPaymentDetail); grdSetter.setDgvTreatement(dgvTreatment); //grdSetter.setDgvTurnToOtherHosp(dgvTurnToOtherHospInfo); dgvInsuInfo.DataSource = dtInsuInfo; dgvIDInfo.DataSource = dtIDInfo; JObject joRtn = QueryPaymentDetail(); if (JsonHelper.parseCenterRtnValue(joRtn, out string errorMsg) == 0) { //处理字典数据-缴费档次 【clctstd_crtf_rule_codg】 JArray jaTradearray = JArray.Parse(JsonHelper.getDestValue(joRtn, "output")); for (int i = 0; i < JArray.Parse(JsonHelper.getDestValue(joRtn, "output")).Count; i++) { if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "A31001") jaTradearray[i]["clctstd_crtf_rule_codg"] = "一档医疗在职"; if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "A31002") jaTradearray[i]["clctstd_crtf_rule_codg"] = "二档医疗在职"; if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "A31003") jaTradearray[i]["clctstd_crtf_rule_codg"] = "三档医疗"; if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "A31004") jaTradearray[i]["clctstd_crtf_rule_codg"] = "少儿二档"; if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "A31007") jaTradearray[i]["clctstd_crtf_rule_codg"] = "特殊保健"; if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "A32001") jaTradearray[i]["clctstd_crtf_rule_codg"] = "在职公务员"; if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "A32002") jaTradearray[i]["clctstd_crtf_rule_codg"] = "在职驻深公务员"; if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "A39301") jaTradearray[i]["clctstd_crtf_rule_codg"] = "家属统筹医疗"; if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "A51001") jaTradearray[i]["clctstd_crtf_rule_codg"] = "生育在职"; if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "A52001") jaTradearray[i]["clctstd_crtf_rule_codg"] = "生育医疗一档"; if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "A52002") jaTradearray[i]["clctstd_crtf_rule_codg"] = "生育医疗二档"; if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "C31001") jaTradearray[i]["clctstd_crtf_rule_codg"] = "一档医疗退休"; if (jaTradearray[i]["clctstd_crtf_rule_codg"].ToString() == "C31002") jaTradearray[i]["clctstd_crtf_rule_codg"] = "二档医疗退休"; } dgvPaymentDetail.DataSource = (DataTable)jaTradearray.ToObject(typeof(DataTable)); } //dgvPaymentDetail.DataSource = (DataTable)joRtn["output"].ToObject(typeof(DataTable)); } private void AddDGVColumn(DataGridView dgv, string headerText, string dataPropertyName, int width = 120) { DataGridViewColumn newColumn = new DataGridViewTextBoxColumn(); newColumn.HeaderText = headerText; newColumn.Width = width; newColumn.DataPropertyName = dataPropertyName; newColumn.Name = dataPropertyName; dgv.Columns.Add(newColumn); } 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; } public void setDgvTreatement(DataGridView dgv) { dgv.AutoGenerateColumns = false; dgv.Columns.Clear(); AddDGVColumn(dgv, "人员编号", "psn_no", 300); AddDGVColumn(dgv, "待遇检查类型", "trt_chk_type", 140); AddDGVColumn(dgv, "基金支付类型", "fund_pay_type", 300); AddDGVColumn(dgv, "基金款项待遇享受标志", "trt_enjymnt_flag", 140); AddDGVColumn(dgv, "开始日期", "begndate", 200); AddDGVColumn(dgv, "结束日期", "enddate", 200); AddDGVColumn(dgv, "待遇检查结果", "trt_chk_rslt", 140); AddDGVColumn(dgv, "字段扩展", "exp_content", 140); dgv.ColumnHeadersDefaultCellStyle.Font = new Font("宋体", 9, FontStyle.Bold); dgv.ColumnHeadersHeight = 30; } private void setDgvInsuInfo() { AddDGVColumn(dgvInsuInfo, "余额", "balc", 80); AddDGVColumn(dgvInsuInfo, "险种类型", "insutype", 200); AddDGVColumn(dgvInsuInfo, "人员类别", "psn_type"); AddDGVColumn(dgvInsuInfo, "人员参保状态", "psn_insu_stas"); AddDGVColumn(dgvInsuInfo, "个人参保日期", "psn_insu_date", 170); AddDGVColumn(dgvInsuInfo, "暂停参保日期", "paus_insu_date"); AddDGVColumn(dgvInsuInfo, "公务员标志", "cvlserv_flag", 95); AddDGVColumn(dgvInsuInfo, "参保区划", "insuplc_admdvs", 85); AddDGVColumn(dgvInsuInfo, "单位名称", "emp_name", 300); AddDGVColumn(dgvInsuInfo, "险种类型编码", "insutypeNo"); dgvInsuInfo.ColumnHeadersDefaultCellStyle.Font = new Font("宋体", 9, FontStyle.Bold); dgvInsuInfo.ColumnHeadersHeight = 40; //341124199210252617 } private void setDgvIDInfo() { AddDGVColumn(dgvIDInfo, "人员身份类别", "psn_idet_type", 140); AddDGVColumn(dgvIDInfo, "人员类别等级", "psn_type_lv", 140); AddDGVColumn(dgvIDInfo, "备注", "memo", 150); AddDGVColumn(dgvIDInfo, "开始时间", "begntime", 200); AddDGVColumn(dgvIDInfo, "结束时间", "endtime", 200); dgvIDInfo.ColumnHeadersDefaultCellStyle.Font = new Font("宋体", 9, FontStyle.Bold); dgvIDInfo.ColumnHeadersHeight = 40; } private void uiButton1_Click(object sender, EventArgs e) { insuInfoIndex = dgvInsuInfo.CurrentRow.Index; if (dtIDInfo.Rows.Count != 0 ) idInfoIndex = dgvIDInfo.CurrentRow.Index; joSelectedInsuInfo = new JObject(); for (int i = 0; i < dtInsuInfo.Columns.Count; i++) { string key = dtInsuInfo.Columns[i].ColumnName; string value = dgvInsuInfo.CurrentRow.Cells[key].Value.ToString(); joSelectedInsuInfo.Add(key, value); } DialogResult = DialogResult.OK; } private void uiButton2_Click(object sender, EventArgs e) { DialogResult = DialogResult.Cancel; } private JObject QueryPaymentDetail() { var joData = new { data = new { psn_no = this.tbPsnNO.Text } }; return invoker.invokeCenterService(TradeEnum.QueryPaymentDetail,JObject.FromObject(joData)); } private void btnRYDY2001_Click(object sender, EventArgs e) { string sInput = "", errorMsg = ""; int iHis = dgvInsuInfo.CurrentRow.Index; if (dgvInsuInfo.CurrentRow == null) { MessageBox.Show("请选择参保信息再查询!"); return; } string insutype = dgvInsuInfo.Rows[iHis].Cells["insutypeNo"].Value.ToString(); string beginDate = DateTime.Now.AddYears(-1).ToString("yyyy-MM-dd HH:mm:ss"); JObject joData = new JObject(); joData.Add("psn_no", this.tbPsnNO.Text); joData.Add("insutype", insutype); joData.Add("fixmedins_code", Global.inf.hospitalNO); joData.Add("med_type", "11"); joData.Add("begntime", beginDate); joData.Add("endtime", ""); joData.Add("dise_codg", ""); joData.Add("dise_name", ""); joData.Add("oprn_oprt_code", ""); joData.Add("oprn_oprt_name", ""); joData.Add("matn_type", ""); joData.Add("birctrl_type", ""); JObject joInput = new JObject(); joInput.Add("data", joData); JObject joRtn = invoker.invokeCenterService(TradeEnum.BenefitCheck, joInput); if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0) { MessageBox.Show("人员待遇享受检查失败:" + errorMsg); } else { string treatInfo = JsonHelper.getDestValue(joRtn, "output.trtinfo"); if (!string.IsNullOrEmpty(treatInfo)) { JArray jarray = JArray.Parse(treatInfo); StringBuilder sb = new StringBuilder(); foreach (JObject obj in jarray) { string flag = JsonHelper.getDestValue(obj, "trt_enjymnt_flag"); if ("0".Equals(flag)) { string fundType = JsonHelper.getDestValue(obj, "fund_pay_type"); string msg = JsonHelper.getDestValue(obj, "trt_chk_rslt"); sb.Append("基金类型:【" + fundType + "】" + msg); } } if (sb.Length > 0) { MessageBox.Show("人员待遇享受检查结果:" + sb.ToString()); return; } } MessageBox.Show("人员待遇享受检查结果:【正常】!"); } } private void dgvInsuInfo_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { uiButton1_Click(sender,e); } private JObject QueryAccumutualInfo() { var joData = new { data = new { psn_no = this.tbPsnNO.Text , year = tbYear_PaymentDetail.Text} }; return invoker.invokeCenterService(TradeEnum.QueryAccumutualInfoLocal, JObject.FromObject(joData)); } private void btAccumulate_Click(object sender, EventArgs e) { JObject joRtn = QueryAccumutualInfo(); string err; if (JsonHelper.parseCenterRtnValue(joRtn, out err) != 0) { MessageBox.Show(err); return; } dgvAccumulativeInfo.DataSource = (DataTable)joRtn["output"]["result"]["mutualAidSetlInfoDTOS"].ToObject(typeof(DataTable)); } private JObject QueryTurnToOtherHospInfo() { var joData = new { data = new { psn_no = this.tbPsnNO.Text, refl_fil_type = tools.getDestPosStrBySpliter(cbTurnType.Text,1,".") , begntime = tbBeginDate.Text,endtime = tbEndDate.Text} }; return invoker.invokeCenterService(TradeEnum.QueryTransferInfo, JObject.FromObject(joData)); } private void btTurnToOtherHosp_Click(object sender, EventArgs e) { JObject joRtn = QueryTurnToOtherHospInfo(); string err; if (JsonHelper.parseCenterRtnValue(joRtn, out err) != 0) { MessageBox.Show(err); return; } dgvTurnToOtherHospInfo.DataSource = (DataTable)joRtn["output"]["result"].ToObject(typeof(DataTable)); } private JObject QueryTreamentInfo() { int i = dgvInsuInfo.SelectedIndex; string insutype = dgvInsuInfo.Rows[i].Cells["insutypeNo"].Value.ToString() ; var joData = new { data = new { psn_no = this.tbPsnNO.Text, insutype =insutype, med_type = tools.getDestPosStrBySpliter(cbxMedicalType.Text, 1, "."), begntime = tbBeginDate_treatment.Text, endtime = tbEndDate_treatment.Text, fixmedins_code = Global.inf.hospitalNO} }; return invoker.invokeCenterService(TradeEnum.BenefitCheck, JObject.FromObject(joData)); } private void btTreatment_Click(object sender, EventArgs e) { JObject joRtn = QueryTreamentInfo(); string err; if (JsonHelper.parseCenterRtnValue(joRtn, out err) != 0) { MessageBox.Show(err); return; } dgvTreatment.DataSource = (DataTable)joRtn["output"]["result"]["mutualAidSetlInfoDTOS"].ToObject(typeof(DataTable)); MessageBox.Show("接口【2001-人员享受待遇查询】因为各地市待遇享受条件不一致,最终查询结果以【90100-缴费查询接口】查询缴费情况为准!"); } } }