12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640 |
- 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
- {
- DataTable dtExport;
- JObject joRtn10001 = new JObject();
- JObject joInput20002 = new JObject();
- public string patInfo = "", ReadCardOutParam = "", CertNo = "";
- public string presAdmLoc = "", presAdmDoc = "", presAdmID = "", presNo = "", hiRxno = "";
- public string DrCode = "", DrName = "", DrInsuCode = "", DrCertNo = "";
- public string IID;
- //1.声明自适应类实例
- AutoResizeForm asc = new AutoResizeForm();
- private InvokeHelper invoker = new InvokeHelper();
- private HisIrisServices hIS = new HisIrisServices();
- private MIIrisServices mIS = new MIIrisServices();
- HisMainBusiness hBus = new HisMainBusiness();
- public MedInsuQuery()
- {
- InitializeComponent();
- asc.controllInitializeSize(this);
- asc.controlAutoSize(this);
- }
- public MedInsuQuery(JObject jo)
- {
- InitializeComponent();
- Global.pat.certNO = JsonHelper.getDestValue(jo, "idNo");
- IID = JsonHelper.getDestValue(jo, "idNo");
- if (!string.IsNullOrEmpty(Global.pat.admID))
- {
- string hisPatBaseInfo = "";
- if (hIS.GetHisPatBaseInfo(out hisPatBaseInfo) != 0)
- {
- }
- }
- //jaVolaItems = JArray.Parse(JsonHelper.getDestValue(jo, "output.result"));
- //dtVolaItems = (DataTable)jo["output"]["result"].ToObject(typeof(DataTable));
- //dgvVolaItems.DataSource = dtVolaItems;
- //grdSetter.SetHeaderTextOfPAIPAVolaItem(dgvVolaItems);
- //tbJrID.Text = JsonHelper.getDestValue(jo, "output.result[0].jr_id");
- //tbRuleID.Text = JsonHelper.getDestValue(jo, "output.result[0].rule_id");
- //tbPatID.Text = JsonHelper.getDestValue(jo, "output.result[0].patn_id");
- //tbMdtrdID.Text = JsonHelper.getDestValue(jo, "output.result[0].mdtrt_id");
- //tbVolaAmt.Text = JsonHelper.getDestValue(jo, "output.result[0].vola_amt");
- //tbVolaAmtStas.Text = JsonHelper.getDestValue(jo, "output.result[0].vola_amt_stas");
- //tbSevDeg.Text = JsonHelper.getDestValue(jo, "output.result[0].sev_deg");
- //tbVolaBhvrType.Text = JsonHelper.getDestValue(jo, "output.result[0].vola_bhvr_type");
- //tbVolaEvid.Text = JsonHelper.getDestValue(jo, "output.result[0].vola_evid");
- //tbRuleName.Text = JsonHelper.getDestValue(jo, "output.result[0].rule_name");
- //rbtVolaContent.Text = JsonHelper.getDestValue(jo, "output.result[0].vola_cont");
- }
- public MedInsuQuery(int iPage)
- {
- InitializeComponent();
- asc.controllInitializeSize(this);
- asc.controlAutoSize(this);
- tbcMain.SelectedIndex = iPage;
- }
- private void btnClose_Click(object sender, EventArgs e)
- {
- this.Close();
- }
- private void MedInsuQuery_Load(object sender, EventArgs e)
- {
- //this.WindowState = FormWindowState.Maximized;
- tbcMain.SelectedIndex = 6;
- dpST.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
- dpED.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
- dt_ST.Text = DateTime.Now.ToString("yyyy-MM-01 00:00:00");
- dt_ET.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
- date_st.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
- date_et.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
- dtp_st.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
- dtp_et.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
- dpt_ST.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
- dpt_ET.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
- DT_ST1.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
- DT_ET1.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
- dptST.Text = DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd 00:00:00");
- dptET.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
- dtTHSJ.Text = DateTime.Now.ToString();
- // dgvSettlRecord.AutoGenerateColumns = false;
- cbbLevel.SelectedIndex = 0;
- cbbOverPrice.SelectedIndex = 0;
- GridViewSetter grdSetter = new GridViewSetter();
- grdSetter.SetHeaderTextOfMedInsuHosPerInfo(dgvSettlRecord);
- grdSetter.SetHeaderTextOfSettltMentFeelDetailInfo(dgvInsuFeeUpload);
- grdSetter.DatagridviewColumnWidthAdaptation(dgvInsuFeeUpload);
- grdSetter.SetHeaderTextOfMIPatCurrentInsuInfo(dgv_4001);
- grdSetter.SetHeaderTextOfSettlList(dgvSettleData);
- grdSetter.SetHeaderTextOfSettltMentFeelDetailInfo(dgvFeeInfo);
- grdSetter.SetHeaderTextOfHISRegister(dgv_HISRegInfo);
- grdSetter.SetHeaderTextOfHISPrescFee(dgv_PrescriptionInfo);
- grdSetter.SetHeaderTextOfBillInfo(dgv_BillInfo);
- grdSetter.SetHeaderTextOfBillDetailInfo(dgv_BillDetailInfo);
- grdSetter.SetHeaderTextOf5205DrugDetailInfo(dgv5205);
- grdSetter.DatagridviewColumnWidthAdaptation(dgv_HISRegInfo);
- grdSetter.DatagridviewColumnWidthAdaptation(dgv_PrescriptionInfo);
- grdSetter.DatagridviewColumnWidthAdaptation(dgv_BillInfo);
- grdSetter.DatagridviewColumnWidthAdaptation(dgv_BillDetailInfo);
- grdSetter.DatagridviewColumnWidthAdaptation(dgv5205);
- rbg_Type.SelectedIndex = 0;
- tbJGBM.Text = Global.inf.hospitalNO;
- dtTHSJ.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
- if (!string.IsNullOrEmpty(IID))
- {
- tbcMain.TabPages.Clear();
- tbcMain.TabPages.Add(tab5205);
- }
-
- }
- 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 btnOK_Click(object sender, EventArgs e)
- {
- string sqlStr;
- sqlStr = " SELECT a.Adm_Dr,c.Name, b.HISCode, b.MedInsuNO, b.Price,b.Sumamt,b.ChargeItemLevel,c.ChargeItemLevelName,b.SelfPayProp, ";
- sqlStr = sqlStr + " b.UpLimitAmount,b.OverLimitAmount,b.InScopeAmount,b.FullOwnPayAmount,b.PreSelfPayAmount,b.LimitUsedFlag ";
- sqlStr = sqlStr + " FROM BS_MedInsuSettlement a LEFT JOIN BS_MedInsuFeeUploadRecord b ";
- sqlStr = sqlStr + " ON a.Hospital_Dr=b.Hospital_Dr AND a.MdtrtID=b.MdtrtID AND a.PersonnelNO=b.PersonnelNO ";
- sqlStr = sqlStr + " LEFT JOIN HB_MedInsuDirectory c ON b.MedInsuNO=c.Code AND a.Interface_Dr=c.Interface_Dr AND a.Hospital_Dr=c.Hospital_Dr ";
- sqlStr = sqlStr + " WHERE b.MedInsuNO<>'' and a.ValidFlag=1 AND a.BillType=1 AND a.AdmType=2 ";
- sqlStr = sqlStr + " AND a.Interface_Dr=" + Global.inf.interfaceDr;
- sqlStr = sqlStr + " AND a.Hospital_Dr= " + Global.inf.hospitalDr;
- sqlStr = sqlStr + " AND a.OccurTime>'" + dt_ST.Text + "'";
- sqlStr = sqlStr + " AND a.OccurTime<'" + dt_ET.Text + "'";
- if (tb_InHospNo.Text != "")
- {
- sqlStr = sqlStr + " and a.BillID='" + tb_InHospNo.Text + "'";
- }
- if (tb_SettleID.Text != "")
- {
- sqlStr = sqlStr + " and a.SettlementID='" + tb_SettleID.Text + "'";
- }
- if (cbbOverPrice.Text == "是")
- {
- sqlStr = sqlStr + " AND b.OverLimitAmount>0 ";
- }
- else if (cbbOverPrice.Text == "否")
- {
- sqlStr = sqlStr + " AND b.OverLimitAmount<=0 ";
- }
- if (cbbLevel.Text == "甲类")
- {
- sqlStr = sqlStr + " AND b.ChargeItemLevel='01' ";
- }
- else if (cbbLevel.Text == "乙类")
- {
- sqlStr = sqlStr + " AND b.ChargeItemLevel='02' ";
- }
- else if (cbbLevel.Text == "丙类")
- {
- sqlStr = sqlStr + " AND b.ChargeItemLevel='03' ";
- }
- 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", "09010118");
- JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询医保结算费用信息");
- DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
- dgvInsuFeeUpload.DataSource = dt;
- }
- private void uiButton3_Click(object sender, EventArgs e)
- {
- //string sqlStr = " SELECT * FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
- //sqlStr = sqlStr + " and OccurTime>'" + DT_ST1.Text + "'";
- //sqlStr = sqlStr + " and OccurTime<'" + DT_ET1.Text + "'";
- //sqlStr = sqlStr + " and Interface_Dr=" + Global.inf.interfaceDr + "";
- //sqlStr = sqlStr + " and CertificateNO= " + tb_CertNo.Text;
- //sqlStr = sqlStr + " and BillType=1 and ValidFlag=1 ";
- string sqlstr = " SELECT distinct a.InsuranceAreaCode, b.PersonalNO,b.PsnCertType,b.PsnCertNO,b.PatientName , ";
- sqlstr = sqlstr + " b.Gend,b.Naty,b.Brdy,b.Age,b.Balc,b.Insutype,b.PsnType,b.PsnInsuStas,b.PsnInsuDate, ";
- sqlstr = sqlstr + " b.PausInsuDate,b.Cvlservflag,b.insuplcAdmdvs,b.EmpName ";
- sqlstr = sqlstr + " FROM BS_MedInsuSettlement a ";
- sqlstr = sqlstr + " RIGHT JOIN BS_MIPatCurrentInsuInfo b ";
- sqlstr = sqlstr + " ON a.PersonnelNO=b.PersonalNO AND a.Interface_Dr=b.Interface_Dr ";
- sqlstr = sqlstr + " AND a.PersonType=b.PsnType AND a.InsuranceType=b.Insutype ";
- sqlstr = sqlstr + " WHERE a.ValidFlag=1 AND a.BillType=1 ";
- sqlstr = sqlstr + " and a.OccurTime>'" + DT_ST1.Text + "'";
- sqlstr = sqlstr + " and a.OccurTime<'" + DT_ET1.Text + "'";
- sqlstr = sqlstr + " and a.Interface_Dr='" + Global.inf.interfaceDr + "'";
- if (tb_CertNo.Text != "")
- sqlstr = sqlstr + " and a.CertificateNO='" + tb_CertNo.Text + "'";
- JObject joSqlstr = new JObject();
- joSqlstr.Add("sqlStr", sqlstr);
- joSqlstr.Add("Type", "4001");
- JArray jaParam = new JArray();
- jaParam.Add(joSqlstr);
- JObject joSettlQuery = new JObject();
- joSettlQuery.Add("params", jaParam);
- joSettlQuery.Add("code", "09010059");
- JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");
- DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
- dgv_4001.DataSource = dt;
- }
- private void uiButton4_Click(object sender, EventArgs e)
- {
- string errorMsg = "";
- if (dgv_4001.CurrentRow == null)
- {
- MessageBox.Show("请查询患者参保信息");
- return;
- }
- int iCenter = dgv_4001.CurrentRow.Index;
- string psn_no = dgv_4001.Rows[iCenter].Cells["PersonalNO"].Value.ToString();
- string psn_cert_type = dgv_4001.Rows[iCenter].Cells["PsnCertType"].Value.ToString();
- string certno = dgv_4001.Rows[iCenter].Cells["PsnCertNO"].Value.ToString();
- string psn_name = dgv_4001.Rows[iCenter].Cells["PatientName"].Value.ToString();
- string gend = dgv_4001.Rows[iCenter].Cells["Gend"].Value.ToString();
- string naty = dgv_4001.Rows[iCenter].Cells["Naty"].Value.ToString();
- string brdy = dgv_4001.Rows[iCenter].Cells["Brdy"].Value.ToString();
- string age = dgv_4001.Rows[iCenter].Cells["Age"].Value.ToString();
- string balc = dgv_4001.Rows[iCenter].Cells["Balc"].Value.ToString();
- string insutype = dgv_4001.Rows[iCenter].Cells["Insutype"].Value.ToString();
- string psn_type = dgv_4001.Rows[iCenter].Cells["PsnType"].Value.ToString();
- string psn_insu_stas = dgv_4001.Rows[iCenter].Cells["PsnInsuStas"].Value.ToString();
- string psn_insu_date = dgv_4001.Rows[iCenter].Cells["PsnInsuDate"].Value.ToString();
- string paus_insu_date = dgv_4001.Rows[iCenter].Cells["PausInsuDate"].Value.ToString();
- string cvlserv_flag = dgv_4001.Rows[iCenter].Cells["Cvlservflag"].Value.ToString();
- string insuplc_admdvs = dgv_4001.Rows[iCenter].Cells["insuplcAdmdvs"].Value.ToString();
- string emp_name = dgv_4001.Rows[iCenter].Cells["EmpName"].Value.ToString();
- JObject joInput = new JObject();
- JObject joData = new JObject();
- joData.Add("psn_no", psn_no);
- joData.Add("psn_cert_type", psn_cert_type);
- joData.Add("certno", certno);
- joData.Add("psn_name", psn_name);
- joData.Add("gend", gend);
- joData.Add("naty", naty);
- joData.Add("brdy", brdy);
- joData.Add("age", age);
- joData.Add("balc", balc);
- joData.Add("insutype", insutype);
- joData.Add("psn_type", psn_type);
- joData.Add("psn_insu_stas", psn_insu_stas);
- joData.Add("psn_insu_date", psn_insu_date);
- joData.Add("paus_insu_date", paus_insu_date);
- joData.Add("cvlserv_flag", cvlserv_flag);
- joData.Add("insuplc_admdvs", insuplc_admdvs);
- joData.Add("emp_name", emp_name);
- joInput.Add("data", joData);
- JObject joRtn = invoker.invokeCenterServiceF("4001", JsonHelper.setCenterInparF("4001", joInput));
- if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
- {
- MessageBox.Show("患者信息上传失败:" + errorMsg);
- return;
- }
- MessageBox.Show("患者信息上传成功");
- }
- private void uiButton7_Click(object sender, EventArgs e)
- {
- string sqlStr = " SELECT * FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
- sqlStr = sqlStr + " and OccurTime>'" + dpt_ST.Text + "'";
- sqlStr = sqlStr + " and OccurTime<'" + dpt_ET.Text + "'";
- sqlStr = sqlStr + " and Interface_Dr=" + Global.inf.interfaceDr + "";
- sqlStr = sqlStr + " and BillType=1 and ValidFlag=1 and ReversalFlag<>1";
- if ((rbg_Type.SelectedIndex == 0) || (rbg_Type.SelectedIndex == 3))
- sqlStr = sqlStr + "and AdmType=1";
- else if ((rbg_Type.SelectedIndex == 1) || (rbg_Type.SelectedIndex == 2))
- sqlStr = sqlStr + "and AdmType=2";
- if (tb_CertNo2.Text != "")
- sqlStr = sqlStr + " and CertificateNO= " + tb_CertNo2.Text;
- 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");
- JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");
- DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
- dgvSettleData.DataSource = dt;
- }
- private void dgvSettleData_DoubleClick(object sender, EventArgs e)
- {
- uiButton5_Click(sender, e);
- }
- /// <summary>
- /// 上传费用明细
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void uiButton5_Click(object sender, EventArgs e)
- {
- string outParam = "成功", funNO = "";
- if (rbg_Type.SelectedIndex == 0)
- funNO = "4303";
- else if (rbg_Type.SelectedIndex == 1)
- funNO = "4403";
- else if (rbg_Type.SelectedIndex == 2)
- funNO = "4801";
- else if (rbg_Type.SelectedIndex == 3)
- funNO = "4802";
- if (dgvSettleData.CurrentRow == null)
- {
- MessageBox.Show("请先查询患者结算信息");
- return;
- }
- int iCenter = dgvSettleData.CurrentRow.Index;
- Global.pat.mdtrtID = dgvSettleData.Rows[iCenter].Cells["MdtrtID"].Value.ToString();
- Global.pat.medType = dgvSettleData.Rows[iCenter].Cells["MedicalType"].Value.ToString();
- Global.pat.psn_no = dgvSettleData.Rows[iCenter].Cells["PersonnelNO"].Value.ToString();
- Global.pat.adm_Dr = int.Parse(dgvSettleData.Rows[iCenter].Cells["AdmID"].Value.ToString());
- Global.pat.billID = dgvSettleData.Rows[iCenter].Cells["BillID"].Value.ToString();
- Global.pat.recordID = dgvSettleData.Rows[iCenter].Cells["RecordID"].Value.ToString();
- Global.pat.certNO = dgvSettleData.Rows[iCenter].Cells["CertificateNO"].Value.ToString();
- Global.pat.name = dgvSettleData.Rows[iCenter].Cells["PatientName"].Value.ToString();
- Global.pat.brdy = dgvSettleData.Rows[iCenter].Cells["BirthDay"].Value.ToString();
- Global.pat.gend = dgvSettleData.Rows[iCenter].Cells["Gender"].Value.ToString();
- //获取IS费用
- if (hIS.getHisFee(Global.pat, out outParam) != 0)
- {
- MessageBox.Show("获取HIS费用信息失败:" + outParam);
- return;
- }
- //调用医保平台转换HIS费用(转换医保编码等)
- JObject joHisFee = JObject.Parse(outParam);
- if (mIS.convertHisFeeWithInsuCodeHF(joHisFee, out outParam) != 0)
- {
- MessageBox.Show("调用医保平台转换HIS费用(转换医保编码等)失败:" + outParam);
- return;
- }
- JArray jaFeeDetail = JArray.Parse(JsonHelper.getDestValue(JObject.Parse(outParam), "data"));
- //按指定条数分割后上传
- if (uploadFeeToCenter(funNO, 300, jaFeeDetail, out outParam) != 0)
- {
- MessageBox.Show("按指定条数分割后上传失败:" + outParam);
- return;
- }
- else
- {
- MessageBox.Show("上传成功!" + outParam);
- return;
- }
- }
- public int uploadFeeToCenter(string funNO, int singleCount, JArray jaFeeDetail, out string outParam)
- {
- outParam = "";
- string errMsg, type = "feedetail";
- try
- {
- if (rbg_Type.SelectedIndex == 0)
- type = "outfeedetail";
- else if (rbg_Type.SelectedIndex == 1)
- type = "feedetail";
- else if (rbg_Type.SelectedIndex == 2)
- type = "feedetail";
- else if (rbg_Type.SelectedIndex == 3)
- type = "outfeedetail";
- JArray jaTmp = new JArray();
- for (int i = 0; i < jaFeeDetail.Count; i++)
- {
- jaFeeDetail[i]["chrg_bchno"] = Global.pat.adm_Dr.ToString();
- jaFeeDetail[i]["med_type"] = Global.pat.medType;
- jaFeeDetail[i]["bilg_dept_codg"] = "A10";
- jaFeeDetail[i]["certno"] = Global.pat.certNO;
- jaFeeDetail[i]["psn_name"] = Global.pat.name;
- jaFeeDetail[i]["gend"] = Global.pat.gend;
- jaFeeDetail[i]["brdy"] = Global.pat.brdy;
- jaFeeDetail[i]["mdtrt_sn"] = Global.pat.adm_Dr;
- if (jaFeeDetail[i]["validFlag"].ToString() == "N") continue;
- jaTmp.Add(jaFeeDetail[i]);
- if (((i + 1) % singleCount == 0) || ((i + 1) == jaFeeDetail.Count))
- {
- JObject joFeeDetail = new JObject();
- joFeeDetail.Add(type, jaTmp);
- JObject joRtn = invoker.invokeCenterServiceF(funNO, JsonHelper.setCenterInparF(funNO, joFeeDetail));
- //if (JsonHelper.parseCenterRtnValue(joRtn, out errMsg) != 0)
- //{
- // outParam = errMsg;
- // return -1;
- //}
- jaTmp = new JArray();
- }
- }
- return 0;
- }
- catch (Exception ex)
- {
- outParam = "uploadFee 异常:" + ex.Message;
- return -1;
- }
- }
- private void uiButton16_Click(object sender, EventArgs e)
- {
- string errorMsg;
- try
- {
- if (dgv_HISRegInfo.DataSource == null)
- return;
- if (dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["ID"].Value.ToString() == "")
- return;
- presNo = dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["prescNo"].Value.ToString();
- JObject joTmp = new JObject();
- joTmp.Add("startDate", dtp_st.Text);
- joTmp.Add("endDate", dtp_et.Text);
- joTmp.Add("hospCode", JsonHelper.getDestValue((JObject)Global.curEvt.jaSession[0], "hospCode"));
- joTmp.Add("prescNo", presNo); //处方号
- JObject joRtn = invoker.invokeHISService(JsonHelper.setIrisInpar("05110038", joTmp).ToString(), "获取门诊处方风险提示参数");
- if (JsonHelper.parseIrisRtnValue(joRtn, out errorMsg) != 0)
- {
- MessageBox.Show("获取门诊处方风险提示参数失败,请联系管理员!" + errorMsg);
- return;
- }
- else
- {
- if ((joRtn["result"].ToString() == "[]") || (joRtn["result"].ToString() == ""))
- {
- MessageBox.Show("调用HIS接口服务05110038获取处方号【" + presNo + "】门诊处方风险提示参数结果为空!");
- return;
- }
- //调用接口上传至中心
- JObject joInput = new JObject();
- joInput = JObject.Parse(joRtn["result"][0].ToString());
- //joInput["treatmentRecord"]["patientinfo"]["psn_no"] = Global.pat.mdtrtID;
- joInput["treatmentRecord"]["patientinfo"]["brdy"] = joInput["treatmentRecord"]["patientinfo"]["brdy"] + " 00:00:00";
- JObject joRtn10001 = invoker.invokeCenterServiceF("10001", JsonHelper.setCenterInparF("10001", joInput));
- if (JsonHelper.parseCenterRtnValue(joRtn10001, out errorMsg) != 0)
- {
- MessageBox.Show("门诊处方风险提示上传失败:" + errorMsg);
- return;
- }
- MessageBox.Show("门诊处方风险提示上传成功");
- }
- }
- catch (Exception ex)
- {
- MessageBox.Show("异常:" + ex.Message);
- return;
- }
- }
- /// <summary>
- /// 新华网人员类别与医保人员类别对照关系
- /// </summary>
- /// <param name="param"></param>
- /// <returns></returns>
- public string GetPsnType(string param)
- {
- if ((param == "11") || (param == "11021") || (param == "11031") ||
- (param == "1101") || (param == "1102") || (param == "1103") ||
- (param == "1111") || (param == "1113") || (param == "116006") ||
- (param == "116011") || (param == "116012") || (param == "116013") ||
- (param == "116014") || (param == "116015") || (param == "116017") ||
- (param == "136046") || (param == "136048") || (param == "136050") ||
- (param == "116018") || (param == "116019") || (param == "116020") ||
- (param == "116021") || (param == "136042") || (param == "136044") ||
- (param == "5005") || (param == "5007") || (param == "5010") ||
- (param == "5011") || (param == "5015") || (param == "5019") ||
- (param == "5022") || (param == "5028") || (param == "5029") ||
- (param == "5032") || (param == "5035") || (param == "5038") ||
- (param == "5041") || (param == "5044") || (param == "5048") ||
- (param == "5050") || (param == "1117") || (param == "1118") ||
- (param == "116041") || (param == "116042") || (param == "116043") ||
- (param == "116044") || (param == "116045") || (param == "116046") ||
- (param == "11032") || (param == "11033") || (param == "11034") ||
- (param == "116047") || (param == "116048") || (param == "116022") ||
- (param == "116031") || (param == "116032") || (param == "116033") ||
- (param == "5053") || (param == "5054") || (param == "5055") ||
- (param == "5059") || (param == "116090") || (param == "116050") ||
- (param == "116051") || (param == "995330"))
- return "1025100"; //在职
- else if ((param == "1105") || (param == "3601") || (param == "3602"))
- return "1025200"; //农民工
- else if ((param == "12") || (param == "1112") || (param == "1201") ||
- (param == "1202") || (param == "1114") || (param == "1203") ||
- (param == "12031") || (param == "136047") || (param == "1205") ||
- (param == "995311") || (param == "136049") || (param == "126001") ||
- (param == "136051") || (param == "126002") || (param == "136052") ||
- (param == "126003") || (param == "126004") || (param == "126009") ||
- (param == "995319") || (param == "126010") || (param == "995307") ||
- (param == "126013") || (param == "126015") || (param == "126016") ||
- (param == "126017") || (param == "126018") || (param == "126019") ||
- (param == "126022") || (param == "136055") || (param == "126023") ||
- (param == "126024") || (param == "126025") || (param == "126026") ||
- (param == "126027") || (param == "136035") || (param == "136039") ||
- (param == "136040") || (param == "136041") || (param == "136043") ||
- (param == "136045") || (param == "126031") || (param == "126032") ||
- (param == "126033") || (param == "5006") || (param == "5008") ||
- (param == "5012") || (param == "5013") || (param == "5016") ||
- (param == "5017") || (param == "5020") || (param == "5023") ||
- (param == "5030") || (param == "5033") || (param == "5036") ||
- (param == "5039") || (param == "5042") || (param == "5045") ||
- (param == "5049") || (param == "5051") || (param == "120701") ||
- (param == "120703") || (param == "120707") || (param == "120708") ||
- (param == "120711") || (param == "120712") || (param == "120715") ||
- (param == "120716") || (param == "120719") || (param == "120720") ||
- (param == "120723") || (param == "120724") || (param == "120727") ||
- (param == "120728") || (param == "120731") || (param == "120733") ||
- (param == "120735") || (param == "120737") || (param == "126041") ||
- (param == "126042") || (param == "126043") || (param == "126044") ||
- (param == "126045") || (param == "126046") || (param == "12032") ||
- (param == "12033") || (param == "12034") || (param == "12035") ||
- (param == "126047") || (param == "126048") || (param == "116088") ||
- (param == "126064") || (param == "126065") || (param == "126117") ||
- (param == "126216") || (param == "126037") || (param == "126067") ||
- (param == "126066") || (param == "126034") || (param == "5056") ||
- (param == "5057") || (param == "5058") || (param == "126316") ||
- (param == "126317") || (param == "5060") || (param == "126090") ||
- (param == "995331"))
- return "1025300"; //退休人员
- else
- if ((param == "13") || (param == "1300") || (param == "1300") ||
- (param == "995309") || (param == "136053") || (param == "136001") ||
- (param == "136002") || (param == "136004") || (param == "136005") ||
- (param == "136006") || (param == "136007") || (param == "136008") ||
- (param == "136009") || (param == "136010") || (param == "136011") ||
- (param == "136012") || (param == "136014") || (param == "136015") ||
- (param == "136016") || (param == "136017") || (param == "136018") ||
- (param == "136019") || (param == "136020") || (param == "136021") ||
- (param == "136022") || (param == "136023") || (param == "136024") ||
- (param == "136090") || (param == "13031") || (param == "136026") ||
- (param == "136029") || (param == "136030") || (param == "136031") ||
- (param == "5001") || (param == "5002") || (param == "5003") ||
- (param == "5004") || (param == "5009") || (param == "5018") ||
- (param == "5021") || (param == "5024") || (param == "5031") ||
- (param == "5034") || (param == "5037") || (param == "5040") ||
- (param == "5043") || (param == "5046") || (param == "5047") ||
- (param == "5052") || (param == "137001") || (param == "137002") ||
- (param == "137003") || (param == "136054") || (param == "130102") ||
- (param == "5088"))
- return "1025400"; //离休
- else
- if ((param == "14") || (param == "1405") || (param == "156006") || (param == "156007"))
- return "1025500"; //居民(未成年)
- else
- if ((param == "1401") || (param == "140101"))
- return "1025600"; //新生儿
- else
- if ((param == "1402"))
- return "1025700"; //学龄前儿童
- else
- if (param == "1403")
- return "1025800"; //中小学生
- else
- if ((param == "1404") || (param == "140890") || (param == "140891") ||
- (param == "156008") || (param == "140401") || (param == "140402") ||
- (param == "140403"))
- return "1025900"; //大学生
- else
- if ((param == "995301") || (param == "1405"))
- return "1025110"; //未成年(未入学)
- else
- if (param == "15")
- return "1025111"; //居民(成年)
- else
- if (param == "1501")
- return "1025112"; //普通居民(成年)
- else
- if ((param == "16") || (param == "160104") || (param == "140805") ||
- (param == "160100") || (param == "160101") || (param == "160102") ||
- (param == "160103"))
- return "1025113"; //居民(老年)
- else
- return "1025111"; //居民(成年)
- }
- /// <summary>
- /// 根据HIS就诊ID查询患者参保信息
- /// </summary>
- /// <param name="admID"></param>
- /// <param name="errorMsg"></param>
- /// <returns></returns>
- public int GetInsuPersonInfo(string admID, out JObject joRtn, out string errorMsg)
- {
- joRtn = null;
- string sqlstr = " SELECT TOP 1 * FROM BS_MIPatCurrentInsuInfo WHERE AdmID='" + admID + "'";
- sqlstr = sqlstr + " and Interface_Dr='" + Global.inf.interfaceDr + "' ORDER BY ID DESC";
- JObject joSqlstr = new JObject();
- joSqlstr.Add("sqlStr", sqlstr);
- JArray jaParam = new JArray();
- jaParam.Add(joSqlstr);
- JObject joQuery = new JObject();
- joQuery.Add("params", jaParam);
- joQuery.Add("code", "09010082");
- JObject joQueryRtn = invoker.invokeInsuService(joQuery.ToString(), "查询人员参保信息");
- if (JsonHelper.parseIrisRtnValue(joQueryRtn, out errorMsg) != 0)
- {
- MessageBox.Show("查询人员参保信息失败,请联系管理员!" + errorMsg);
- return -1;
- }
- joRtn = joQueryRtn;
- return 0;
- }
- public string GetInsuFeeInfo(string admID, string InsuCode)
- {
- string sqlStr;
- sqlStr = " SELECT admID as Adm_Dr,'' as Name,''as HISCode,MedInsuNO,Price,Sumamt, ";
- sqlStr = sqlStr + " ChargeItemLevel,SelfPayProp,UpLimitAmount,OverLimitAmount,InScopeAmount,";
- sqlStr = sqlStr + " FullOwnPayAmount,PreSelfPayAmount,LimitUsedFlag From BS_MedInsuFeeUploadRecord ";
- sqlStr = sqlStr + " WHERE Hospital_Dr= " + Global.inf.hospitalDr;
- sqlStr = sqlStr + " AND admID='" + admID + "'";
- sqlStr = sqlStr + " AND MedInsuNO='" + InsuCode + "'";
- 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", "09010118");
- JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询医保结算费用信息");
- decimal SelfPayProp = decimal.Parse(JsonHelper.getDestValue(joRtn, "result.data[0].SelfPayProp"));
- //1007100-医保个人,1007200-医保统筹,1007300-现金
- if (SelfPayProp == 0)
- return "1007200";
- else
- return "1007300";
- }
- private void uiButton13_Click(object sender, EventArgs e)
- {
- string errorMsg;
- string participateType = "1024200", personnelType;
- if ((dgv_BillInfo.DataSource == null) || (dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["billCode"].Value.ToString() == ""))
- {
- MessageBox.Show("请先查询单据信息!");
- return;
- }
- if ((dgv_BillDetailInfo.DataSource == null) || (dgv_BillDetailInfo.Rows[dgv_BillDetailInfo.CurrentRow.Index].Cells["billID"].Value.ToString() == ""))
- {
- MessageBox.Show("请先查询明细信息!");
- return;
- }
- try
- {
- string entId = dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["entId"].Value.ToString();
- string billCode = dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["billCode"].Value.ToString();
- string billTime = dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["billTime"].Value.ToString();
- string InsuredType = dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["participateType"].Value.ToString(); //险种类型
- string admID = dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["admID"].Value.ToString();
- if (InsuredType.Substring(0, 2) == "31")
- {
- participateType = "1024100"; //职工
- }
- else if (InsuredType.Substring(0, 2) == "39")
- {
- participateType = "1024200"; //居民
- }
- //人员类别
- if (GetInsuPersonInfo(admID, out JObject joQueryRtn, out errorMsg) != 0)
- {
- MessageBox.Show("查询参保人员信息失败!" + errorMsg);
- return;
- }
- personnelType = GetPsnType(JsonHelper.getDestValue(joQueryRtn, "result.rows[0].psnType").ToString());
- JObject joData = JObject.Parse(JsonHelper.getDestValue(joInput20002, "result[0]").ToString());
- joData["participateType"] = participateType;
- joData["personnelType"] = personnelType;
- JArray jaFeeDetail = JArray.Parse(JsonHelper.getDestValue(joInput20002, "result[0].detail"));
- //for (int i = 0; i < jaFeeDetail.Count; i++)
- //{
- // string InsuCode = jaFeeDetail[i]["medicalDrugId"].ToString();
- // if (InsuCode != "未对照")
- // {
- // string toPay = GetInsuFeeInfo(admID, InsuCode);
- // }
- //}
- JObject joInput = new JObject();
- joInput.Add("data", joData);
- JObject joRtn = invoker.invokeCenterServiceF("20002", JsonHelper.setCenterInparF("20002", joInput));
- if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
- {
- MessageBox.Show("事后单据鉴核信息提报失败,中心返回:" + errorMsg);
- return;
- }
- MessageBox.Show("事后单据鉴核信息提报成功!" + errorMsg);
- }
- catch (Exception ex)
- {
- MessageBox.Show("事后单据鉴核信息提报异常:" + ex.Message);
- return;
- }
- }
- private void dgv_BillInfo_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
- {
- }
- private void uiButton19_Click(object sender, EventArgs e)
- {
- string errorMsg = "";
- if (dgv_4001.CurrentRow == null)
- {
- MessageBox.Show("请查询患者参保信息");
- return;
- }
- for (int i = 0; i < dgv_4001.Rows.Count; i++)
- {
- //int iCenter = dgv_4001.CurrentRow.Index;
- string psn_no = dgv_4001.Rows[i].Cells["PersonalNO"].Value.ToString();
- string psn_cert_type = dgv_4001.Rows[i].Cells["PsnCertType"].Value.ToString();
- string certno = dgv_4001.Rows[i].Cells["PsnCertNO"].Value.ToString();
- string psn_name = dgv_4001.Rows[i].Cells["PatientName"].Value.ToString();
- string gend = dgv_4001.Rows[i].Cells["Gend"].Value.ToString();
- string naty = dgv_4001.Rows[i].Cells["Naty"].Value.ToString();
- string brdy = dgv_4001.Rows[i].Cells["Brdy"].Value.ToString();
- string age = dgv_4001.Rows[i].Cells["Age"].Value.ToString();
- string balc = dgv_4001.Rows[i].Cells["Balc"].Value.ToString();
- string insutype = dgv_4001.Rows[i].Cells["Insutype"].Value.ToString();
- string psn_type = dgv_4001.Rows[i].Cells["PsnType"].Value.ToString();
- string psn_insu_stas = dgv_4001.Rows[i].Cells["PsnInsuStas"].Value.ToString();
- string psn_insu_date = dgv_4001.Rows[i].Cells["PsnInsuDate"].Value.ToString();
- string paus_insu_date = dgv_4001.Rows[i].Cells["PausInsuDate"].Value.ToString();
- string cvlserv_flag = dgv_4001.Rows[i].Cells["Cvlservflag"].Value.ToString();
- string insuplc_admdvs = dgv_4001.Rows[i].Cells["insuplcAdmdvs"].Value.ToString();
- string emp_name = dgv_4001.Rows[i].Cells["EmpName"].Value.ToString();
- JObject joInput = new JObject();
- JObject joData = new JObject();
- joData.Add("psn_no", psn_no);
- joData.Add("psn_cert_type", psn_cert_type);
- joData.Add("certno", certno);
- joData.Add("psn_name", psn_name);
- joData.Add("gend", gend);
- joData.Add("naty", naty);
- joData.Add("brdy", brdy);
- joData.Add("age", age);
- joData.Add("balc", balc);
- joData.Add("insutype", insutype);
- joData.Add("psn_type", psn_type);
- joData.Add("psn_insu_stas", psn_insu_stas);
- joData.Add("psn_insu_date", psn_insu_date);
- joData.Add("paus_insu_date", paus_insu_date);
- joData.Add("cvlserv_flag", cvlserv_flag);
- joData.Add("insuplc_admdvs", insuplc_admdvs);
- joData.Add("emp_name", emp_name);
- joInput.Add("data", joData);
- JObject joRtn = invoker.invokeCenterServiceF("4001", JsonHelper.setCenterInparF("4001", joInput));
- if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
- {
- MessageBox.Show("患者信息上传失败:" + errorMsg);
- return;
- }
- }
- MessageBox.Show("患者信息上传成功");
- }
- private void dgvSettleData_CellClick(object sender, DataGridViewCellEventArgs e)
- {
- if (dgvSettleData.CurrentRow == null)
- {
- MessageBox.Show("请先查询医保结算信息");
- return;
- }
- int iCenter = dgvSettleData.CurrentRow.Index;
- string PersonnelNO = dgvSettleData.Rows[iCenter].Cells["PersonnelNO"].Value.ToString(); //MdtrtID
- string SettlementID = dgvSettleData.Rows[iCenter].Cells["SettlementID"].Value.ToString();
- string MdtrtID = dgvSettleData.Rows[iCenter].Cells["MdtrtID"].Value.ToString();
- string sqlStr;
- sqlStr = " SELECT a.Adm_Dr,c.Name, b.HISCode, b.MedInsuNO, b.Price,b.Sumamt,b.ChargeItemLevel,c.ChargeItemLevelName,b.SelfPayProp, ";
- sqlStr = sqlStr + " b.UpLimitAmount,b.OverLimitAmount,b.InScopeAmount,b.FullOwnPayAmount,b.PreSelfPayAmount,b.LimitUsedFlag ";
- sqlStr = sqlStr + " FROM BS_MedInsuSettlement a LEFT JOIN BS_MedInsuFeeUploadRecord b ";
- sqlStr = sqlStr + " ON a.Hospital_Dr=b.Hospital_Dr AND a.MdtrtID=b.MdtrtID AND a.PersonnelNO=b.PersonnelNO ";
- sqlStr = sqlStr + " LEFT JOIN HB_MedInsuDirectory c ON b.MedInsuNO=c.Code AND a.Interface_Dr=c.Interface_Dr AND a.Hospital_Dr=c.Hospital_Dr ";
- sqlStr = sqlStr + " WHERE b.MedInsuNO<>'' and a.ValidFlag=1 AND a.BillType=1 "; //AND a.AdmType=2
- sqlStr = sqlStr + " AND a.Interface_Dr=" + Global.inf.interfaceDr;
- sqlStr = sqlStr + " AND a.Hospital_Dr= " + Global.inf.hospitalDr;
- sqlStr = sqlStr + " AND a.OccurTime>'" + dpt_ST.Text + "'";
- sqlStr = sqlStr + " AND a.OccurTime<'" + dpt_ET.Text + "'";
- sqlStr = sqlStr + " AND a.PersonnelNO='" + PersonnelNO + "'";
- sqlStr = sqlStr + " AND a.SettlementID='" + SettlementID + "'";
- sqlStr = sqlStr + " AND a.MdtrtID='" + MdtrtID + "'";
- if (tb_CertNo2.Text != "")
- sqlStr = sqlStr + " And a.CertificateNO='" + tb_CertNo2.Text + "' ";
- 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", "09010118");
- JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询医保结算费用信息");
- DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
- dgvFeeInfo.DataSource = dt;
- }
- private void uiButton20_Click(object sender, EventArgs e)
- {
- string outParam = "成功", funNO = "";
- if (rbg_Type.SelectedIndex == 0)
- funNO = "4303";
- else if (rbg_Type.SelectedIndex == 1)
- funNO = "4403";
- else if (rbg_Type.SelectedIndex == 2)
- funNO = "4801";
- else if (rbg_Type.SelectedIndex == 3)
- funNO = "4802";
- if (dgvSettleData.CurrentRow == null)
- {
- MessageBox.Show("请先查询患者结算信息");
- return;
- }
- for (int i = 0; i < dgvSettleData.Rows.Count; i++)
- {
- int iCenter = dgvSettleData.CurrentRow.Index;
- Global.pat.mdtrtID = dgvSettleData.Rows[i].Cells["MdtrtID"].Value.ToString();
- Global.pat.medType = dgvSettleData.Rows[i].Cells["MedicalType"].Value.ToString();
- Global.pat.psn_no = dgvSettleData.Rows[i].Cells["PersonnelNO"].Value.ToString();
- Global.pat.adm_Dr = int.Parse(dgvSettleData.Rows[i].Cells["AdmID"].Value.ToString());
- Global.pat.billID = dgvSettleData.Rows[i].Cells["BillID"].Value.ToString();
- Global.pat.recordID = dgvSettleData.Rows[i].Cells["RecordID"].Value.ToString();
- Global.pat.certNO = dgvSettleData.Rows[i].Cells["CertificateNO"].Value.ToString();
- Global.pat.name = dgvSettleData.Rows[i].Cells["PatientName"].Value.ToString();
- Global.pat.brdy = dgvSettleData.Rows[i].Cells["BirthDay"].Value.ToString();
- Global.pat.gend = dgvSettleData.Rows[i].Cells["Gender"].Value.ToString();
- //获取IS费用
- if (hIS.getHisFee(Global.pat, out outParam) != 0)
- {
- MessageBox.Show("获取HIS费用信息失败:" + outParam);
- return;
- }
- //调用医保平台转换HIS费用(转换医保编码等)
- JObject joHisFee = JObject.Parse(outParam);
- if (mIS.convertHisFeeWithInsuCodeHF(joHisFee, out outParam) != 0)
- {
- MessageBox.Show("调用医保平台转换HIS费用(转换医保编码等)失败:" + outParam);
- return;
- }
- JArray jaFeeDetail = JArray.Parse(JsonHelper.getDestValue(JObject.Parse(outParam), "data"));
- //按指定条数分割后上传
- if (uploadFeeToCenter(funNO, 300, jaFeeDetail, out outParam) != 0)
- {
- //MessageBox.Show("按指定条数分割后上传失败:" + outParam);
- //return;
- }
- else
- continue;
- }
- MessageBox.Show("上传成功!" + outParam);
- }
- private void rbg_Type_ValueChanged(object sender, int index, string text)
- {
- dgvSettleData.DataSource = null;
- dgvFeeInfo.DataSource = null;
- }
- private void uiButton21_Click(object sender, EventArgs e)
- {
- string errorMsg;
- if (dgv_HISRegInfo.DataSource == null)
- return;
- if (dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["ID"].Value.ToString() == "")
- return;
- for (int i = 0; i < dgv_HISRegInfo.Rows.Count; i++)
- {
- presNo = dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["prescNo"].Value.ToString();
- JObject joTmp = new JObject();
- joTmp.Add("startDate", dtp_st.Text);
- joTmp.Add("endDate", dtp_et.Text);
- joTmp.Add("hospCode", JsonHelper.getDestValue((JObject)Global.curEvt.jaSession[0], "hospCode"));
- joTmp.Add("prescNo", presNo); //处方号
- JObject joRtn = invoker.invokeHISService(JsonHelper.setIrisInpar("05110038", joTmp).ToString(), "获取门诊处方风险提示参数");
- if (JsonHelper.parseIrisRtnValue(joRtn, out errorMsg) != 0)
- {
- MessageBox.Show("获取门诊处方风险提示参数失败,请联系管理员!" + errorMsg);
- return;
- }
- else
- {
- if ((joRtn["result"].ToString() == "[]") || (joRtn["result"].ToString() == ""))
- {
- MessageBox.Show("调用HIS接口服务05110038获取处方号【" + presNo + "】门诊处方风险提示参数结果为空!!");
- return;
- }
- //调用接口上传至中心
- JObject joInput = new JObject();
- joInput = JObject.Parse(joRtn["result"][0].ToString());
- //joInput["treatmentRecord"]["patientinfo"]["psn_no"] = Global.pat.mdtrtID;
- joInput["treatmentRecord"]["patientinfo"]["brdy"] = joInput["treatmentRecord"]["patientinfo"]["brdy"] + " 00:00:00";
- JObject joRtn10001 = invoker.invokeCenterServiceF("10001", JsonHelper.setCenterInparF("10001", joInput));
- if (JsonHelper.parseCenterRtnValue(joRtn10001, out errorMsg) != 0)
- {
- MessageBox.Show("门诊处方风险提示上传失败:" + errorMsg);
- return;
- }
- }
- }
- MessageBox.Show("门诊处方风险提示上传成功");
- }
- private void dgv_HISRegInfo_CellClick(object sender, DataGridViewCellEventArgs e)
- {
- if (dgv_HISRegInfo.DataSource == null)
- return;
- if (dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["ID"].Value.ToString() == "")
- return;
- string outParam = "";
- DataTable dt = null;
- presAdmDoc = dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["doc"].Value.ToString();
- presAdmLoc = dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["loc"].Value.ToString();
- presNo = dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["prescNo"].Value.ToString();
- presAdmID = dgv_HISRegInfo.Rows[dgv_HISRegInfo.CurrentRow.Index].Cells["admID"].Value.ToString();
- Global.pat.adm_Dr = int.Parse(presAdmID);
- if (presNo == "") return;
- //获取HIS处方明细信息
- if (GetHISPrescFeeInfo(presNo, ref outParam, ref dt) != 0)
- {
- MessageBox.Show(outParam);
- return;
- }
- dgv_PrescriptionInfo.DataSource = dt;
- }
- private void dgv_BillInfo_CellClick(object sender, DataGridViewCellEventArgs e)
- {
- string outParam = "";
- DataTable dt = null;
- string errMsg;
- if (dgv_BillInfo.DataSource == null)
- return;
- if (dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["billCode"].Value.ToString() == "")
- return;
- string billID = dgv_BillInfo.Rows[dgv_BillInfo.CurrentRow.Index].Cells["billCode"].Value.ToString();
- try
- {
- JObject joTmp = new JObject();
- joTmp.Add("startDate", date_st.Text.Substring(0, 10));
- joTmp.Add("endDate", date_et.Text.Substring(0, 10));
- joTmp.Add("hospCode", JsonHelper.getDestValue((JObject)Global.curEvt.jaSession[0], "hospCode"));
- joTmp.Add("billID", billID);
- JObject joRtn = invoker.invokeHISService(JsonHelper.setIrisInpar("05110039", joTmp).ToString(), "组织事后单据鉴核信息填报参数");
- if (JsonHelper.parseIrisRtnValue(joRtn, out errMsg) != 0)
- {
- MessageBox.Show("组织事后单据鉴核信息填报参数失败,请联系管理员!" + errMsg);
- return;
- }
- else
- {
- joInput20002 = joRtn;
- JObject detail = new JObject();
- string result = JsonHelper.getDestValue(joRtn, "result[0]").ToString();
- detail = JObject.Parse(result);
- dt = (DataTable)detail["detail"].ToObject(typeof(DataTable));
- dgv_BillDetailInfo.DataSource = dt;
- }
- }
- catch (Exception ex)
- {
- MessageBox.Show("组织事后单据鉴核信息填报参数异常:" + ex.Message);
- return;
- }
- }
- private void btnReadCard_Click(object sender, EventArgs e)
- {
- string outParam = "", errMsg = "";
- if (hBus.readCard(out outParam) != 0)
- {
- MessageBox.Show("读卡失败!" + outParam);
- return;
- }
- else
- {
- string patInfo = outParam;
- //展示患者信息界面
- if (hBus.showPatInfo(patInfo, out outParam) != 0)
- {
- MessageBox.Show("参保信息展示异常!" + outParam);
- return;
- }
- else
- {
- if (hBus.setGlobalPatAfaterShowPatInfo(outParam, out errMsg) != 0)
- {
- MessageBox.Show("setGlobalPatAfaterShowPatInfo全局变量赋值异常!" + errMsg);
- return;
- }
- }
- }
- }
- private void btn5205_Click(object sender, EventArgs e)
- {
- string outParam = "", errMsg = "";
- JObject joData = new JObject();
- JObject joInput = new JObject();
- JObject joRtn = new JObject();
- string errorMsg = "";
- if (string.IsNullOrEmpty(Global.pat.psn_no))
- {
- joData.Add("mdtrt_cert_type", "02");
- joData.Add("mdtrt_cert_no", Global.pat.certNO);
- joData.Add("card_sn","");
- joData.Add("begntime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
- joData.Add("psn_cert_type", "01");
- joData.Add("certno", Global.pat.certNO); //证件号码
- joData.Add("psn_name", Global.pat.name);
- joInput.Add("data", joData);
- joRtn = invoker.invokeCenterService("1101", JsonHelper.setCenterInpar("1101", joInput));
- if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
- {
- outParam = "获取病人参保信息失败:" + errorMsg;
- }
- else
- {
- //joRtn.Add("cardinfo",joCardInfo);
- outParam = joRtn.ToString();
- Global.pat.insuplc_admdvs = JsonHelper.getDestValue(JObject.Parse(outParam), "output.insuinfo.insuplc_admdvs"); //参保地
- Global.pat.psn_no = JsonHelper.getDestValue(JObject.Parse(outParam), "output.baseinfo.psn_no"); //人员编号
- }
- }
- if (string.IsNullOrEmpty(Global.pat.psn_no))
- {
- MessageBox.Show("未获取到该患者的医保个人编号,请确认患者建卡信息是否维护身份证号!");
- return;
- }
- JObject joInput1 = new JObject();
- JObject joData1 = new JObject();
- joData1.Add("psn_no", Global.pat.psn_no);
- //joData1.Add("psn_no", "34010000000005004087");//合肥
- //joData1.Add("psn_no", "34990010039324");//省医保
- joData1.Add("begntime", dptST.Text);
- joData1.Add("endtime", dptET.Text);
- joInput1.Add("data", joData1);
- JObject joRtn1 = invoker.invokeCenterService("5205", JsonHelper.setCenterInpar("5205", joInput1));
- if (JsonHelper.parseCenterRtnValue(joRtn, out errMsg) != 0)
- {
- MessageBox.Show("人员慢特病用药记录查询失败:" + errMsg);
- return;
- }
- else
- {
-
- }
- JObject joOutput = JObject.Parse(JsonHelper.getDestValue(joRtn1, "output"));
- JArray joIDInfo = JArray.Parse(JsonHelper.getDestValue(joOutput, "feedetail"));
- if (joIDInfo.Count > 0)
- {
- for (int i = 0; i < joIDInfo.Count; i++)
- {
- Utils.convertTimestamp((JObject)joIDInfo[i], "fee_ocur_time");
- }
- }
- //dgv5205.DataSource = (DataTable)joRtn["output"]["feedetail"].ToObject(typeof(DataTable));
- dgv5205.DataSource = (DataTable)joIDInfo.ToObject(typeof(DataTable));
- }
-
- public int queryHISDirectory(out string errMsg)
- {
- errMsg = "";
- string pageSize = "500";
- string flag = "Maped";
- JObject joHISRtn = new JObject();
- JObject joRtn = new JObject();
- JArray jaPagination = new JArray();
- JArray jaParams = new JArray();
- dynamic joParam = new JObject();
- joParam.alias = "";
- joParam.HospitalDr = Global.inf.hospitalDr;
- joParam.InterfaceDr = Global.inf.interfaceDr;
- joParam.hisType = "drugs";
- jaParams.Add(joParam);
- dynamic joPagination = new JObject();
- joPagination.pageSize = pageSize;
- joPagination.currentPage = "1";
- joPagination.sortColumn = "HisCode";
- joPagination.sortOrder = "asc";
- jaPagination.Add(joPagination);
- JObject joMIRtn = mIS.GetMappedHISDir(jaPagination, jaParams);
- if (JsonHelper.parseIrisRtnValue(joMIRtn, out errMsg) != 0)
- {
- return -1;
- }
- //传给HIS,进行匹配
- joParam = new JObject();
- joParam.TotalCount = joMIRtn["result"]["TotalCount"];
- joParam.type = "drugs";
- joParam.flag = flag;
- joParam.hospID = Global.inf.hisHospitalDr;
- joParam.interfaceDr = Global.inf.interfaceDr;
- joParam.alias = "";
- joParam.include = "Hosp";
- joParam.groupID = "324";
- joParam.specInput = "";//增加规格过滤
- joParam.compareArr = joMIRtn["result"]["Data"];
- jaParams = new JArray();
- jaParams.Add(joParam);
- if (hIS.getHISDir(jaPagination, jaParams, out joRtn, out errMsg) != 0)
- {
- return -1;
- }
- DataTable dt = (DataTable)joRtn["result"]["Data"].ToObject(typeof(DataTable));
- dtExport = dt;
- int totalCount = int.Parse(joRtn["result"]["TotalCount"].ToString());
- //pgHISDirect.TotalCount = totalCount;
- //pgHISDirect.PageSize = pageSize;
- dgvMedInsuMapRelation.DataSource = null;
- dgvMedInsuMapRelation.DataSource = dt;
- dgvMedInsuMapRelation.Columns[0].ReadOnly = true;
- GridViewSetter gridSetter = new GridViewSetter();
- gridSetter.SetHeaderTextOfMapping_HisDirectory(dgvMedInsuMapRelation);
- gridSetter.DatagridviewColumnWidthAdaptation(dgvMedInsuMapRelation);
- return 0;
- }
- private void uiButton9_Click(object sender, EventArgs e)
- {
- if (queryHISDirectory(out string errMsg) != 0)
- {
- MessageBox.Show(errMsg);
- return;
- }
- }
- private void uiButton10_Click(object sender, EventArgs e)
- {
- string errorMsg;
- if (dgvMedInsuMapRelation.CurrentRow == null)
- {
- MessageBox.Show("请先查询医保药品对照信息");
- return;
- }
- int iCenter = dgvMedInsuMapRelation.CurrentRow.Index;
- string insuCode = dgvMedInsuMapRelation.Rows[iCenter].Cells["insuCode"].Value.ToString(); //中心编码
- string insuName = dgvMedInsuMapRelation.Rows[iCenter].Cells["insuName"].Value.ToString(); //中心编码
- string itemCode = dgvMedInsuMapRelation.Rows[iCenter].Cells["itemCode"].Value.ToString(); //医院编码
- string itemDesc = dgvMedInsuMapRelation.Rows[iCenter].Cells["itemDesc"].Value.ToString(); //医院名称
- SaleBillInfo sbi = new SaleBillInfo(insuCode, insuName);
- try
- {
- if (sbi.ShowDialog() == DialogResult.OK)
- {
- JObject joInput = new JObject();
- JObject joData = new JObject();
- joData.Add("entId", sbi.entId);
- joData.Add("code", sbi.code);
- joData.Add("medicalDrugId", sbi.medicalDrugId);
- joData.Add("queryTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
- joData.Add("salePkg", sbi.salePkg);
- joData.Add("unpackCount", sbi.unpackCount);
- joData.Add("drugSalePrice", sbi.drugSalePrice);
- joData.Add("batchNo", sbi.batchNo);
- joInput.Add("data", joData);
- JObject joRtn = invoker.invokeCenterServiceF("20001", JsonHelper.setCenterInparFT("20001", joInput));
- if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
- {
- MessageBox.Show("医保药品鉴核数据采集事前鉴核服务上传失败:" + errorMsg);
- return;
- }
- else
- {
- DataTable dtData = (DataTable)joRtn["output"]["data"].ToObject(typeof(DataTable));
- DataTable dtVerifyResult = (DataTable)joRtn["output"]["verifyResult"].ToObject(typeof(DataTable));
- DataTable dtTraceCodeVo = (DataTable)joRtn["output"]["traceCodeVo"].ToObject(typeof(DataTable));
- DataTable dtMedDrugInfo = (DataTable)joRtn["output"]["medDrugInfo"].ToObject(typeof(DataTable));
- dgvData.DataSource = dtData;
- dgvVerifyResult.DataSource = dtVerifyResult;
- dgvTraceCodeVo.DataSource = dtTraceCodeVo;
- dgvMedDrugInfo.DataSource = dtMedDrugInfo;
- MessageBox.Show("医保药品鉴核数据采集事前鉴核服务上传成功");
- }
- }
- else
- {
- MessageBox.Show("操作员已取消!");
- return;
- }
- }
- catch (Exception ex)
- {
- MessageBox.Show("异常:" + ex.Message);
- return;
- }
- }
- private void uiButton11_Click(object sender, EventArgs e)
- {
- string errorMsg;
- JObject joInput = new JObject();
- JObject joData = new JObject();
- joData.Add("ent_id", tbJGBM.Text);
- joData.Add("bill_code", tbDJBH.Text);
- joData.Add("bill_time", dtTHSJ.Text);
- joInput.Add("data", joData);
- JObject joRtn = invoker.invokeCenterServiceF("20003", JsonHelper.setCenterInparF("20003", joInput));
- if (JsonHelper.parseCenterRtnValue(joRtn, out errorMsg) != 0)
- {
- MessageBox.Show("医保销售单据退货上传失败:" + errorMsg);
- return;
- }
- else
- {
- MessageBox.Show("医保销售单据退货上传成功!" + errorMsg);
- }
- }
- private void uiButton15_Click(object sender, EventArgs e)
- {
- string errMsg;
- dgv_BillInfo.DataSource = null;
- dgv_BillDetailInfo.DataSource = null;
- try
- {
- JObject joTmp = new JObject();
- joTmp.Add("startDate",date_st.Text.Substring(0,10));
- joTmp.Add("endDate", date_et.Text.Substring(0, 10));
- joTmp.Add("hospCode", JsonHelper.getDestValue((JObject)Global.curEvt.jaSession[0], "hospCode"));
- joTmp.Add("billID", "");
- JObject joRtn = invoker.invokeHISService(JsonHelper.setIrisInpar("05110039", joTmp).ToString(), "组织事后单据鉴核信息填报参数");
- if (JsonHelper.parseIrisRtnValue(joRtn, out errMsg) != 0)
- {
- MessageBox.Show("组织事后单据鉴核信息填报参数失败,请联系管理员!" + errMsg);
- return;
- }
- else
- {
- DataTable dt = (DataTable)joRtn["result"].ToObject(typeof(DataTable));
- dgv_BillInfo.DataSource = dt;
- }
- }
- catch (Exception ex)
- {
- MessageBox.Show("组织事后单据鉴核信息填报参数异常:" + ex.Message);
- return;
- }
- }
- /// <summary>
- /// 获取HIS就诊信息
- /// </summary>
- /// <param name="dtST"></param>
- /// <param name="dtED"></param>
- /// <param name="PatInfo"></param>
- /// <param name="errMsg"></param>
- /// <param name="DT"></param>
- /// <returns></returns>
- private int GetHISRegInfo(string dtST, string dtED, string PatInfo, ref string errMsg, ref DataTable DT)
- {
- dynamic joTmp = new JObject();
- joTmp.Add("stDate", dtST);
- joTmp.Add("endDate", dtED);
- joTmp.Add("patInfo", PatInfo);
- JObject joRtnHISRegInfo = hIS.GetHISRegInfo(joTmp);
- if (JsonHelper.parseIrisRtnValue(joRtnHISRegInfo, out errMsg) != 0)
- {
- errMsg = "获取HIS患者就诊信息失败,请联系管理员!" + errMsg;
- return -1;
- }
- else
- {
- if ((joRtnHISRegInfo["result"]["rows"].ToString() == "[]"))
- {
- errMsg = "查询HIS就诊信息结果为空!";
- return -1;
- }
- else
- {
- DT = (DataTable)joRtnHISRegInfo["result"]["rows"].ToObject(typeof(DataTable));
- return 0;
- }
- }
- }
- private void uiButton18_Click(object sender, EventArgs e)
- {
- string errMsg;
- //if (tb_SFZH.Text == "")
- //{
- // MessageBox.Show("请先输入患者身份证号进行查找患者未结算处方信息!");
- // return;
- //}
- //else
- //{
- // dgv_HISRegInfo.DataSource = null;
- // dgv_PrescriptionInfo.DataSource = null;
- // CertNo = tb_SFZH.Text;
- // Global.pat.certNO = tb_SFZH.Text;
- //}
- dgv_HISRegInfo.DataSource = null;
- dgv_PrescriptionInfo.DataSource = null;
- CertNo = tb_SFZH.Text;
- Global.pat.certNO = tb_SFZH.Text;
- #region【查询HIS就诊信息-用身份证号查询患者当日的就诊记录】
- string outParam = "";
- DataTable dt1 = null;
- if (GetHISRegInfo(dtp_st.Text, dtp_et.Text, Global.pat.certNO, ref outParam, ref dt1) != 0)
- {
- MessageBox.Show(outParam);
- return;
- }
- dgv_HISRegInfo.DataSource = dt1;
- #endregion
- #region【根据处方号查询处方明细信息】
- presAdmDoc = dgv_HISRegInfo.Rows[0].Cells["doc"].Value.ToString();
- presAdmLoc = dgv_HISRegInfo.Rows[0].Cells["loc"].Value.ToString();
- presNo = dgv_HISRegInfo.Rows[0].Cells["prescNo"].Value.ToString();
- presAdmID = dgv_HISRegInfo.Rows[0].Cells["admID"].Value.ToString();
- Global.pat.adm_Dr = int.Parse(presAdmID);
- if (presNo == "") return;
- DataTable dt2 = null;
- //获取HIS处方明细信息
- if (GetHISPrescFeeInfo(presNo, ref outParam, ref dt2) != 0)
- {
- MessageBox.Show(outParam);
- return;
- }
- dgv_PrescriptionInfo.DataSource = dt2;
- #endregion
- }
- /// <summary>
- /// 获取HIS费用明细信息
- /// </summary>
- /// <param name="PrescNo"></param>
- /// <param name="errMsg"></param>
- /// <param name="DT"></param>
- /// <returns></returns>
- private int GetHISPrescFeeInfo(string PrescNo, ref string errMsg, ref DataTable DT)
- {
- dynamic joTmp = new JObject();
- joTmp.Add("prescNo", PrescNo);
- JObject joRtnHISPrescFeeInfo = hIS.GetHISPrescFeeInfo(joTmp);
- if (JsonHelper.parseIrisRtnValue(joRtnHISPrescFeeInfo, out errMsg) != 0)
- {
- errMsg = "获取HIS患者处方信息失败,请联系管理员!" + errMsg;
- return -1;
- }
- else
- {
- if ((joRtnHISPrescFeeInfo["result"]["rows"].ToString() == "[]"))
- {
- errMsg = "查询HIS处方信息结果为空!";
- return -1;
- }
- else
- {
- DT = (DataTable)joRtnHISPrescFeeInfo["result"]["rows"].ToObject(typeof(DataTable));
- return 0;
- }
- }
- }
- private void dgv_HISRegInfo_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
- {
- uiButton16_Click(sender, e);
- }
- }
- }
|