using Newtonsoft.Json.Linq;
using System;
using System.IO;
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.FormSetter;
using PTMedicalInsurance.Business;
using PTMedicalInsurance.Variables;
namespace PTMedicalInsurance.Forms
{
public partial class MedInsuQuery : Form
{
InvokeHelper invoker = new InvokeHelper();
DataTable dtExport;
//1.声明自适应类实例
AutoResizeForm asc = new AutoResizeForm();
public MedInsuQuery()
{
InitializeComponent();
asc.controllInitializeSize(this);
asc.controlAutoSize(this);
}
private void btnClose_Click(object sender, EventArgs e)
{
Close();
}
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 GetCheckBoxGroupItem(string sqlStr,CheckedListBox checkedListBox1)
{
DataTable DT = GetDBLKComboxTable(sqlStr);
checkedListBox1.Items.Clear();
for (int i = 0; i < DT.Rows.Count; i++)
{
string Code = DT.Rows[i]["Code"].ToString();
string Name = DT.Rows[i]["Name"].ToString();
string Str = Code + "-" + Name;
checkedListBox1.Items.Add(Str);
}
}
private void MedInsuQuery_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");
dt_Begin.Text = DateTime.Now.ToString("yyyy-MM-01 00:00:00");
dt_End.Text = DateTime.Now.ToString("yyyy-MM-30 23:59:59");
edt_SetlNY.Text = DateTime.Now.ToString("yyyyMM");
// dgvSettlRecord.AutoGenerateColumns = false;
GridViewSetter grdSetter = new GridViewSetter();
grdSetter.SetHeaderTextOfMedInsuHosPerInfo(dgvSettlRecord);
//医保查询页
rb_query1.Visible = true;
rb_query2.Visible = false;
cb_MedQueryType.SelectedIndex = 0;
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 = 'Med_Type' and A.Interface_Dr = '" + Global.inf.interfaceDr.ToString() + "'";
GetCheckBoxGroupItem(sqlStr, chklst_MedTypeList);
}
private void btnQuery_Click(object sender, EventArgs e)
{
btnPrint.Enabled = false;
string sCZYXM = Global.user.name;
string SqlHeard = " Adm_Dr,MdtrtID,Name as PatientName,Age,PsnCertNO,Gend,PsnType,EmpName,AdmInDepName,insuplcAdmdvs,sZYZT AS sZTSM, "
+ " AdmBed,RegDate,MainDiagName,AttendDoctorNO,ChiefPhyDocName,'"+ sCZYXM+ "' as OpertName,'' as InHospNo,''Address ";
string SqlStrMain = " SELECT a.*,b.*,a.PatientName AS Name,a.PsnType AS PsnTypeCode,'在院' sZYZT FROM BS_MIPatCurrentInsuInfo a LEFT JOIN BS_MedInsuRegisterInfo b "
+ " ON a.MdtrtID=b.InsuRegID AND a.Interface_Dr=b.Interface_Dr AND a.Hospital_Dr=b.Hospital_Dr "
+ " WHERE b.Type=1 AND b.ValidFlag=1 AND b.Hospital_Dr= " + Global.inf.hospitalDr + " AND b.Interface_Dr= " + Global.inf.interfaceDr
+ " AND b.InsuRegID NOT IN (SELECT MdtrtID FROM BS_MedInsuSettlement WHERE MdtrtID=b.InsuRegID AND BillType=1 AND ValidFlag=1 AND AdmType=2) "
+ " AND b.RegDate<='" + dpED.Text + "' AND b.RegDate>'" + dpST.Text + "' " //
+ " UNION ALL "
+ " SELECT a.*,b.*,a.PatientName AS Name,a.PsnType AS PsnTypeCode,'已结算' AS sZYZT "
+ " FROM BS_MIPatCurrentInsuInfo a LEFT JOIN BS_MedInsuRegisterInfo b "
+ " ON a.MdtrtID=b.InsuRegID AND a.Interface_Dr=b.Interface_Dr AND a.Hospital_Dr=b.Hospital_Dr "
+ " LEFT JOIN BS_MedInsuSettlement c ON a.MdtrtID=b.InsuRegID AND b.InsuRegID=c.MdtrtID AND a.Interface_Dr=b.Interface_Dr AND b.Interface_Dr=c.Interface_Dr "
+ " WHERE b.Type=1 AND b.ValidFlag=1 AND c.BillType=1 AND b.Hospital_Dr= " + Global.inf.hospitalDr + " AND b.Interface_Dr= " + Global.inf.interfaceDr
+ " AND c.AdmType=2 AND c.SettlementDateTime<='" + dpED.Text + "' AND c.SettlementDateTime>'" + dpST.Text + "' "; //
string sqlStr = " SELECT "+ SqlHeard + " FROM ("+ SqlStrMain +") M ";
//MessageBox.Show(sqlStr);
JObject joSqlstr = new JObject();
joSqlstr.Add("sqlStr", sqlStr);
joSqlstr.Add("Type", "MedInsuHosPInfo");
joSqlstr.Add("hospID", Global.inf.hisHospitalDr);
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(), "查询结算信息");
//MessageBox.Show(joRtn.ToString());
if (joRtn["result"]["data"].ToString() == "[]")
{
MessageBox.Show("查询结果为空！");
return;
}
DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
dgvSettlRecord.DataSource = dt;
if (dt.Rows.Count != 0)
{
btnPrint.Enabled = true;
dtExport = dt;
//从HIS获取患者的床号（分床前医保登记的病人床号没有写入医保平台登记表）
for (int i = 0; i < dt.Rows.Count; i++)
{
string BedNo, BedDocName, InHospNo, Address;
JObject joTmp = new JObject();
joTmp.Add("admID", dt.Rows[i]["Adm_Dr"].ToString());
JObject joRtn2 = invoker.invokeHISService(JsonHelper.setIrisInpar("05110014", joTmp).ToString(), "获取患者就诊信息");
if (JsonHelper.parseIrisRtnValue(joRtn2, out string errMsg) == 0)
{
BedNo = JsonHelper.getDestValue(JObject.Parse(joRtn2.ToString()), "mdtrtinfo.adm_bed");
BedDocName = JsonHelper.getDestValue(JObject.Parse(joRtn2.ToString()), "mdtrtinfo.chfpdr_name");
InHospNo = JsonHelper.getDestValue(JObject.Parse(joRtn2.ToString()), "mdtrtinfo.medrcdno");
Address = JsonHelper.getDestValue(JObject.Parse(joRtn2.ToString()), "mdtrtinfo.Address");
dt.Rows[i]["AdmBed"] = BedNo;
dt.Rows[i]["AttendDoctorNO"] = BedDocName;
dt.Rows[i]["InHospNo"] = InHospNo;
dt.Rows[i]["Address"] = Address;
}
else
{
if (errMsg.IndexOf("请重新登录") > 0)
{
MessageBox.Show("获取患者信息失败，请重新登录系统！");
break;
}
}
}
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
string LSH = DateTime.Now.ToString("yyyy-MM-dd"); //DateTime.Now.ToString("MMddHHmmssffff");
string sFliePathName = @"C:\Users\Administrator\Desktop\" + LSH + "医保在院患者登记或结算信息.xls";
string ReturnFileName = ExportToExcel.DataTabletoExcel(dtExport, sFliePathName);
if (ReturnFileName != "")
{
MessageBox.Show("导出成功,文件保存路径：【" + ReturnFileName + "】");
System.Diagnostics.Process.Start(ReturnFileName); //打开excel文件
}
else
{
MessageBox.Show("导出失败!");
}
}
private void cb_MedQueryType_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewSetter gvdSetter = new GridViewSetter();
if (cb_MedQueryType.SelectedIndex < 3)
{
rb_query1.Visible = true;
rb_query2.Visible = false;
switch (cb_MedQueryType.SelectedIndex)
{
case 0://【3605】DRG 分组结果查询
{
gvdSetter.SetHeaderTextOfDRGGroupResultQuery(dgv_MainData);
break;
}
case 1://【3606】DIP 分组结果查询
{
gvdSetter.SetHeaderTextOfDIPGroupResultQuery(dgv_MainData);
break;
}
case 2://【3607】结算清单质控结果查询
{
gvdSetter.SetHeaderTextOfSetlBillQualityResultQuery(dgv_MainData);
break;
}
}
}
else if (cb_MedQueryType.SelectedIndex == 3)
{
rb_query1.Visible = false;
rb_query2.Visible = true;
//【4105】医疗保障基金结算清单数量统计查询
gvdSetter.SetHeaderTextOfSetlBillCountQuery(dgv_MainData);
}
}
private void btnMedQuery_Click(object sender, EventArgs e)
{
string errorMsg;
string sBussiesID;
DataTable dt;
JObject joData = new JObject();
JObject joInput = new JObject();
sBussiesID = cb_MedQueryType.Text.Substring(0, 4);
if (cb_MedQueryType.SelectedIndex < 3)
{
joData.Add("setl_ym", edt_SetlNY.Text);
joData.Add("page_num", edt_Page.Text);
joData.Add("page_size", edt_PageCount.Text);
joData.Add("setl_id", edt_SetID.Text);
joInput.Add("data", joData);
}
else
{
//医疗类别获取选中项
JArray ja = new JArray();
string selectedOptions = string.Empty;
foreach (var item in chklst_MedTypeList.CheckedItems)
{
string sItem = item.ToString();
string[] sArry = sItem.Split('-');
string medType = sArry[0]; //截取分隔符-前的字符串
//selectedOptions += item.ToString() + Environment.NewLine + selectedOptions;
ja.Add(medType);
}
string stt_flag="0", refdset_flag="false";
if (chk_returnFlag.Checked)
stt_flag = "1";
if (chk_TotleFlag.Checked)
refdset_flag = "true";
joData.Add("fixmedins_code", Global.inf.hospitalNO);
joData.Add("medtype_list", ja);
joData.Add("stt_begntime", dt_Begin.Text);
joData.Add("stt_endtime", dt_End.Text);
joData.Add("stt_flag", stt_flag);
joData.Add("refdset_flag", refdset_flag);
joInput.Add("data", joData);
}
JObject joRtn = invoker.invokeCenterService(sBussiesID, JsonHelper.setCenterInpar(sBussiesID, joInput));
if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
{
MessageBox.Show(cb_MedQueryType.Text + " 查询失败：" + errorMsg);
return;
}
else
{
if ((cb_MedQueryType.SelectedIndex == 0) || (cb_MedQueryType.SelectedIndex == 1))
{
dt = (DataTable)joRtn["output"]["data"].ToObject(typeof(DataTable));
}
else
if (cb_MedQueryType.SelectedIndex == 3)
{
dt = (DataTable)joRtn["output"].ToObject(typeof(DataTable));
}
else
{
//dt = (DataTable)joRtn["output"]["data"].ToObject(typeof(DataTable));
JArray RtnjaArray = JArray.Parse(JsonHelper.getDestValue(joRtn, "output.data").ToString());
JArray ja = new JArray();
foreach (JObject obj in RtnjaArray)
{
string qltctrl_chk_rslt = "";
//取值重新组织
string cert_no = (string)obj["cert_no"].ToString();
string grp_stas = (string)obj["grp_stas"].ToString();
string qltctrl_rslt = (string)obj["qltctrl_rslt"].ToString();
string setl_id = (string)obj["setl_id"].ToString();
string psn_name = (string)obj["psn_name"].ToString();
string err_lv = (string)obj["err_lv"].ToString();
string setl_ym = (string)obj["setl_ym"].ToString();
string fixmedins_code = (string)obj["fixmedins_code"].ToString();
string psn_no = (string)obj["psn_no"].ToString();
string qltctrl_ver = (string)obj["qltctrl_ver"].ToString();
string detl_list = (string)obj["detl_list"].ToString();
string fixmedins_name = (string)obj["fixmedins_name"].ToString();
string psn_cert_type = (string)obj["psn_cert_type"].ToString();
string retn_flag = (string)obj["retn_flag"].ToString();
//int age = (int)obj["age"];
if (err_lv == "3")
{
JArray jaDetList = JArray.Parse(obj["detl_list"].ToString());
foreach (JObject obj1 in jaDetList)
{
//string qltctrl_chk_rslt = (string)obj1["qltctrl_chk_rslt"].ToString();
qltctrl_chk_rslt = (string)obj1["qltctrl_chk_rslt"].ToString() + ";" + qltctrl_chk_rslt;
}
}
JObject jo = new JObject();
jo.Add("cert_no", cert_no);
jo.Add("grp_stas", grp_stas);
jo.Add("qltctrl_rslt", qltctrl_rslt);
jo.Add("setl_id", setl_id);
jo.Add("psn_name", psn_name);
jo.Add("err_lv", err_lv);
jo.Add("fixmedins_code", fixmedins_code);
jo.Add("psn_no", psn_no);
jo.Add("qltctrl_ver", qltctrl_ver);
jo.Add("detl_list", qltctrl_chk_rslt);
jo.Add("fixmedins_name", fixmedins_name);
jo.Add("psn_cert_type", psn_cert_type);
jo.Add("retn_flag", retn_flag);
ja.Add(jo);
}
dt = (DataTable)ja.ToObject(typeof(DataTable));
}
dgv_MainData.DataSource = dt;
if (dt.Rows.Count > 0)
{
btnImport.Enabled = true;
dtExport = dt;
}
}
}
private void btnImport_Click(object sender, EventArgs e)
{
string sBussiesID = cb_MedQueryType.Text;
string LSH = DateTime.Now.ToString("yyyyMMdd"); //DateTime.Now.ToString("MMddHHmmssffff");
string sFliePathName = @"C:\Users\Administrator\Desktop\" + LSH + sBussiesID + "信息.xls";
string ReturnFileName = ExportToExcel.DataTabletoExcel(dtExport, sFliePathName);
if (ReturnFileName != "")
{
MessageBox.Show("导出成功,文件保存路径：【" + ReturnFileName + "】");
System.Diagnostics.Process.Start(ReturnFileName); //打开excel文件
}
else
{
MessageBox.Show("导出失败!");
}
}
}
}