void SetLisValue(EntityAidsCheck vo) { #region //"3-II.艾滋病病毒感染孕产妇妊娠及所生婴儿登记卡" if (this.formId == 11 && vo != null) { if (vo.count == 2) { if (!string.IsNullOrEmpty(vo.YZ)) { Viewer.showPanelForm.SetFieldValue("A060", vo.YZ); } if (!string.IsNullOrEmpty(vo.BXBJS)) { Viewer.showPanelForm.SetFieldValue("A061", vo.BXBJS); } if (!string.IsNullOrEmpty(vo.ZLBXBJS)) { Viewer.showPanelForm.SetFieldValue("A062", vo.ZLBXBJS); } if (!string.IsNullOrEmpty(vo.XXBJS)) { Viewer.showPanelForm.SetFieldValue("A063", vo.XXBJS); } if (!string.IsNullOrEmpty(vo.XHDB)) { Viewer.showPanelForm.SetFieldValue("A064", vo.XHDB); } if (!string.IsNullOrEmpty(vo.XT)) { Viewer.showPanelForm.SetFieldValue("A065", vo.XT); } if (!string.IsNullOrEmpty(vo.GBZAM)) { Viewer.showPanelForm.SetFieldValue("A066", vo.GBZAM); } if (!string.IsNullOrEmpty(vo.GCZAM)) { Viewer.showPanelForm.SetFieldValue("A067", vo.GCZAM); } if (!string.IsNullOrEmpty(vo.ZDHS)) { Viewer.showPanelForm.SetFieldValue("A068", vo.ZDHS); } if (!string.IsNullOrEmpty(vo.XJG)) { Viewer.showPanelForm.SetFieldValue("A069", vo.XJG); } if (!string.IsNullOrEmpty(vo.XNST)) { Viewer.showPanelForm.SetFieldValue("A070", vo.XNST); } if (!string.IsNullOrEmpty(vo.CD4XBJS)) { Viewer.showPanelForm.SetFieldValue("A071", vo.CD4XBJS); } if (!string.IsNullOrEmpty(vo.CD8XBJS)) { Viewer.showPanelForm.SetFieldValue("A072", vo.CD8XBJS); } if (!string.IsNullOrEmpty(vo.BDZL)) { Viewer.showPanelForm.SetFieldValue("A073", vo.BDZL); } } else if (vo.count == 3) { if (!string.IsNullOrEmpty(vo.YZ)) { Viewer.showPanelForm.SetFieldValue("A080", vo.YZ); } if (!string.IsNullOrEmpty(vo.BXBJS)) { Viewer.showPanelForm.SetFieldValue("A081", vo.BXBJS); } if (!string.IsNullOrEmpty(vo.ZLBXBJS)) { Viewer.showPanelForm.SetFieldValue("A082", vo.ZLBXBJS); } if (!string.IsNullOrEmpty(vo.XXBJS)) { Viewer.showPanelForm.SetFieldValue("A083", vo.XXBJS); } if (!string.IsNullOrEmpty(vo.XHDB)) { Viewer.showPanelForm.SetFieldValue("A084", vo.XHDB); } if (!string.IsNullOrEmpty(vo.XT)) { Viewer.showPanelForm.SetFieldValue("A085", vo.XT); } if (!string.IsNullOrEmpty(vo.GBZAM)) { Viewer.showPanelForm.SetFieldValue("A086", vo.GBZAM); } if (!string.IsNullOrEmpty(vo.GCZAM)) { Viewer.showPanelForm.SetFieldValue("A087", vo.GCZAM); } if (!string.IsNullOrEmpty(vo.ZDHS)) { Viewer.showPanelForm.SetFieldValue("A088", vo.ZDHS); } if (!string.IsNullOrEmpty(vo.XJG)) { Viewer.showPanelForm.SetFieldValue("A089", vo.XJG); } if (!string.IsNullOrEmpty(vo.XNST)) { Viewer.showPanelForm.SetFieldValue("A090", vo.XNST); } if (!string.IsNullOrEmpty(vo.CD4XBJS)) { Viewer.showPanelForm.SetFieldValue("A091", vo.CD4XBJS); } if (!string.IsNullOrEmpty(vo.CD8XBJS)) { Viewer.showPanelForm.SetFieldValue("A092", vo.CD8XBJS); } if (!string.IsNullOrEmpty(vo.BDZL)) { Viewer.showPanelForm.SetFieldValue("A093", vo.BDZL); } } else if (vo.count == 4) { if (!string.IsNullOrEmpty(vo.YZ)) { Viewer.showPanelForm.SetFieldValue("A100", vo.YZ); } if (!string.IsNullOrEmpty(vo.BXBJS)) { Viewer.showPanelForm.SetFieldValue("A101", vo.BXBJS); } if (!string.IsNullOrEmpty(vo.ZLBXBJS)) { Viewer.showPanelForm.SetFieldValue("A102", vo.ZLBXBJS); } if (!string.IsNullOrEmpty(vo.XXBJS)) { Viewer.showPanelForm.SetFieldValue("A103", vo.XXBJS); } if (!string.IsNullOrEmpty(vo.XHDB)) { Viewer.showPanelForm.SetFieldValue("A104", vo.XHDB); } if (!string.IsNullOrEmpty(vo.XT)) { Viewer.showPanelForm.SetFieldValue("A105", vo.XT); } if (!string.IsNullOrEmpty(vo.GBZAM)) { Viewer.showPanelForm.SetFieldValue("A106", vo.GBZAM); } if (!string.IsNullOrEmpty(vo.GCZAM)) { Viewer.showPanelForm.SetFieldValue("A107", vo.GCZAM); } if (!string.IsNullOrEmpty(vo.ZDHS)) { Viewer.showPanelForm.SetFieldValue("A108", vo.ZDHS); } if (!string.IsNullOrEmpty(vo.XJG)) { Viewer.showPanelForm.SetFieldValue("A109", vo.XJG); } if (!string.IsNullOrEmpty(vo.XNST)) { Viewer.showPanelForm.SetFieldValue("A110", vo.XNST); } if (!string.IsNullOrEmpty(vo.CD4XBJS)) { Viewer.showPanelForm.SetFieldValue("A111", vo.CD4XBJS); } if (!string.IsNullOrEmpty(vo.CD8XBJS)) { Viewer.showPanelForm.SetFieldValue("A112", vo.CD8XBJS); } if (!string.IsNullOrEmpty(vo.BDZL)) { Viewer.showPanelForm.SetFieldValue("A113", vo.BDZL); } } //梅毒检测 if (!string.IsNullOrEmpty(vo.MD_TPPA_ELISA)) { Viewer.showPanelForm.SetFieldValue("X940", "1"); if (vo.MD_TPPA_ELISA.Contains("阳性")) { Viewer.showPanelForm.SetFieldValue("X945", "1"); } else if (vo.MD_TPPA_ELISA.Contains("阴性")) { Viewer.showPanelForm.SetFieldValue("X944", "1"); } } if (!string.IsNullOrEmpty(vo.MD_RPR_TRUST)) { Viewer.showPanelForm.SetFieldValue("X941", "1"); if (vo.MD_RPR_TRUST.Contains("阳性")) { Viewer.showPanelForm.SetFieldValue("X949", "1"); } else if (vo.MD_RPR_TRUST.Contains("阴性")) { Viewer.showPanelForm.SetFieldValue("X948", "1"); } } if (!string.IsNullOrEmpty(vo.HBsAg)) { Viewer.showPanelForm.SetFieldValue("X963", "1"); if (vo.HBsAg.Contains("阳性")) { Viewer.showPanelForm.SetFieldValue("X967", "1"); } else if (vo.HBsAg.Contains("阴性")) { Viewer.showPanelForm.SetFieldValue("X966", "1"); } } if (!string.IsNullOrEmpty(vo.HBeAg)) { Viewer.showPanelForm.SetFieldValue("X971", "1"); if (vo.HBeAg.Contains("阳性")) { Viewer.showPanelForm.SetFieldValue("X975", "1"); } else if (vo.HBeAg.Contains("阴性")) { Viewer.showPanelForm.SetFieldValue("X974", "1"); } } if (!string.IsNullOrEmpty(vo.HCV_IGG)) { Viewer.showPanelForm.SetFieldValue("X979", "1"); if (vo.HCV_IGG.Contains("阳性")) { Viewer.showPanelForm.SetFieldValue("X983", "1"); } else if (vo.HCV_IGG.Contains("阴性")) { Viewer.showPanelForm.SetFieldValue("X982", "1"); } } if (!string.IsNullOrEmpty(vo.HCV_IGM)) { Viewer.showPanelForm.SetFieldValue("X987", "1"); if (vo.HCV_IGM.Contains("阳性")) { Viewer.showPanelForm.SetFieldValue("X991", "1"); } else if (vo.HCV_IGM.Contains("阴性")) { Viewer.showPanelForm.SetFieldValue("X990", "1"); } } if (vo.iDD > 0 && vo.iDD <= 8) { Viewer.showPanelForm.SetFieldValue("X953", "1"); } else if (vo.iDD > 8 && vo.iDD < 64) { Viewer.showPanelForm.SetFieldValue("X954", "1"); } else if (vo.iDD >= 64 && vo.iDD < 128) { Viewer.showPanelForm.SetFieldValue("X955", "1"); } else if (vo.iDD >= 128 && vo.iDD < 256) { Viewer.showPanelForm.SetFieldValue("X956", "1"); } else if (vo.iDD >= 256) { Viewer.showPanelForm.SetFieldValue("X957", "1"); } } else { if (!string.IsNullOrEmpty(vo.YZ)) { Viewer.showPanelForm.SetFieldValue("A040", vo.YZ); } if (!string.IsNullOrEmpty(vo.BXBJS)) { Viewer.showPanelForm.SetFieldValue("A041", vo.BXBJS); } if (!string.IsNullOrEmpty(vo.ZLBXBJS)) { Viewer.showPanelForm.SetFieldValue("A042", vo.ZLBXBJS); } if (!string.IsNullOrEmpty(vo.XXBJS)) { Viewer.showPanelForm.SetFieldValue("A043", vo.XXBJS); } if (!string.IsNullOrEmpty(vo.XHDB)) { Viewer.showPanelForm.SetFieldValue("A044", vo.XHDB); } if (!string.IsNullOrEmpty(vo.XT)) { Viewer.showPanelForm.SetFieldValue("A045", vo.XT); } if (!string.IsNullOrEmpty(vo.GBZAM)) { Viewer.showPanelForm.SetFieldValue("A046", vo.GBZAM); } if (!string.IsNullOrEmpty(vo.GCZAM)) { Viewer.showPanelForm.SetFieldValue("A047", vo.GCZAM); } if (!string.IsNullOrEmpty(vo.ZDHS)) { Viewer.showPanelForm.SetFieldValue("A048", vo.ZDHS); } if (!string.IsNullOrEmpty(vo.XJG)) { Viewer.showPanelForm.SetFieldValue("A049", vo.XJG); } if (!string.IsNullOrEmpty(vo.XNST)) { Viewer.showPanelForm.SetFieldValue("A050", vo.XNST); } if (!string.IsNullOrEmpty(vo.CD4XBJS)) { Viewer.showPanelForm.SetFieldValue("A051", vo.CD4XBJS); } if (!string.IsNullOrEmpty(vo.CD8XBJS)) { Viewer.showPanelForm.SetFieldValue("A052", vo.CD8XBJS); } if (!string.IsNullOrEmpty(vo.BDZL)) { Viewer.showPanelForm.SetFieldValue("A053", vo.BDZL); } //梅毒检测 if (!string.IsNullOrEmpty(vo.MD_TPPA_ELISA)) { Viewer.showPanelForm.SetFieldValue("X940", "1"); if (vo.MD_TPPA_ELISA.Contains("阳性")) { Viewer.showPanelForm.SetFieldValue("X945", "1"); } else if (vo.MD_TPPA_ELISA.Contains("阴性")) { Viewer.showPanelForm.SetFieldValue("X944", "1"); } } if (!string.IsNullOrEmpty(vo.MD_RPR_TRUST)) { Viewer.showPanelForm.SetFieldValue("X941", "1"); if (vo.MD_RPR_TRUST.Contains("阳性")) { Viewer.showPanelForm.SetFieldValue("X949", "1"); } else if (vo.MD_RPR_TRUST.Contains("阴性")) { Viewer.showPanelForm.SetFieldValue("X948", "1"); } } if (!string.IsNullOrEmpty(vo.HBsAg)) { Viewer.showPanelForm.SetFieldValue("X963", "1"); if (vo.HBsAg.Contains("阳性")) { Viewer.showPanelForm.SetFieldValue("X967", "1"); } else if (vo.HBsAg.Contains("阴性")) { Viewer.showPanelForm.SetFieldValue("X966", "1"); } } if (!string.IsNullOrEmpty(vo.HBeAg)) { Viewer.showPanelForm.SetFieldValue("X971", "1"); if (vo.HBeAg.Contains("阳性")) { Viewer.showPanelForm.SetFieldValue("X975", "1"); } else if (vo.HBeAg.Contains("阴性")) { Viewer.showPanelForm.SetFieldValue("X974", "1"); } } if (!string.IsNullOrEmpty(vo.HCV_IGG)) { Viewer.showPanelForm.SetFieldValue("X979", "1"); if (vo.HCV_IGG.Contains("阳性")) { Viewer.showPanelForm.SetFieldValue("X983", "1"); } else if (vo.HCV_IGG.Contains("阴性")) { Viewer.showPanelForm.SetFieldValue("X982", "1"); } } if (!string.IsNullOrEmpty(vo.HCV_IGM)) { Viewer.showPanelForm.SetFieldValue("X987", "1"); if (vo.HCV_IGM.Contains("阳性")) { Viewer.showPanelForm.SetFieldValue("X991", "1"); } else if (vo.HCV_IGM.Contains("阴性")) { Viewer.showPanelForm.SetFieldValue("X990", "1"); } } if (vo.iDD > 0 && vo.iDD <= 8) { Viewer.showPanelForm.SetFieldValue("X953", "1"); } else if (vo.iDD > 8 && vo.iDD < 64) { Viewer.showPanelForm.SetFieldValue("X954", "1"); } else if (vo.iDD >= 64 && vo.iDD < 128) { Viewer.showPanelForm.SetFieldValue("X955", "1"); } else if (vo.iDD >= 128 && vo.iDD < 256) { Viewer.showPanelForm.SetFieldValue("X956", "1"); } else if (vo.iDD >= 256) { Viewer.showPanelForm.SetFieldValue("X957", "1"); } } #endregion #region //4-I梅毒感染孕产妇登记卡 if (this.formId == 15) { // 4——I //快速血浆反应素环状片试验(RPR)X133 //阴性X134 //阳性X135cxxs //检测时间X137 //甲苯胺红不加热血清试验(TRUST)X138 //阴性X139 //阳性X140 //检测时间X142 //梅毒螺旋体颗粒凝集试验(TPPA)X145 //阴性X146 //阳性X147 //检测时间X149 //酶联免疫吸附试验(ELISA)X150 //阴性X151 //阳性X152 //检测时间X154 //免疫层析法-快速体测(RT)X155 //阴性X156 //阳性X157 //检测时间X159 //梅毒螺旋体IgM抗体检测: //未检测X166 //检测阳性X167 //检测阴性X168 //检测时间X169 //暗视野显微镜梅毒螺旋体检测: //未检测X170 //检测X171 //(检测到梅毒螺旋体: //否X172 //是X173 //检测时间X174 } #endregion }
/// <summary> /// 查找病人 /// </summary> /// <param name="cardNo">1 门诊卡号; 2 住院号</param> /// <param name="flag">1 门诊; 2 住院</param> /// <returns></returns> internal List <EntityAidsCheck> GetPatLisInfo(string cardNo, int flag, decimal formId) { string Sql = string.Empty; string Sql2 = string.Empty; string reqNo = string.Empty; string yz = string.Empty; int count = 0; List <EntityAidsCheck> lstVo = new List <EntityAidsCheck>(); SqlHelper svc = null; SqlHelper svcOn = null; SqlHelper lisSvc = null; try { svc = new SqlHelper(EnumBiz.interfaceDB); svcOn = new SqlHelper(EnumBiz.onlineDB); lisSvc = new SqlHelper(EnumBiz.lisDB); IDataParameter[] parm = null; IDataParameter[] parm2 = null; IDataParameter[] parm3 = null; if (flag == 1) { Sql = @"select a.card_no, a.reques_no ,a.hiv1,a.hiv2,a.hiv3,a.yzs, a.zx_time from FRE_CKECK a where a.card_no = ? order by a.zx_time desc"; parm = svc.CreateParm(1); parm[0].Value = cardNo; } else if (flag == 2) { Sql = @"select a.card_no,a.yzs,a.hiv1,a.hiv2,a.hiv3, a.reques_no , a.zx_time from FRE_CKECK a left join IP_REGISTER b on a.pid = b.PID where b.IP_NO = ? order by a.zx_time desc"; parm = svc.CreateParm(1); parm[0].Value = cardNo; } DataTable dt = svc.GetDataTable(Sql, parm); if (dt != null && dt.Rows.Count > 0) { reqNo = dt.Rows[0]["reques_no"].ToString(); yz = dt.Rows[0]["yzs"].ToString(); foreach (DataRow dr in dt.Rows) { if (dr["hiv1"] != DBNull.Value || dr["hiv2"] != DBNull.Value || dr["hiv3"] != DBNull.Value) { count++; } } Sql2 = @"select reques_no from rptContagion where reques_no = ? and status = 1 "; parm2 = svcOn.CreateParm(1); parm2[0].Value = reqNo; DataTable dt2 = svcOn.GetDataTable(Sql2, parm2); if (dt2 != null && dt2.Rows.Count > 0) { return(null); } Sql = @"SELECT samp_name = '标本类型:' + DMB_BB.SAMP_NAME, NOTE = (CASE WHEN DMB_BBZT.NAME IS NULL THEN '' ELSE '标本状态:' + DMB_BBZT.NAME END)+ ' ' + ISNULL(SJB_BGD.NOTE,''), SJB_BGDMXB.ITEM_CODE , item_name = ' ' + DMB_XM.ITEM_NAME, DMB_XM.SEQ_NO1, DMB_XM.TYPE, isnull(DMB_XM.unit,'') as unit , isnull(SJB_BGDMXB.UPBOUND ,'') as UPBOUND , isnull(SJB_BGDMXB.DOWNBOUND ,'') as DOWNBOUND , SJB_BGDMXB.NORMAL , SJB_BGDMXB.RESULT FROM SJB_BGDMXB, SJB_BGD, DMB_XM , DMB_BB, DMB_BBZT WHERE (SJB_BGD.REP_NO = SJB_BGDMXB.REP_NO) AND (DMB_XM.ROOM_CODE = SJB_BGD.ROOM_CODE) AND (DMB_XM.ITEM_CODE = SJB_BGDMXB.ITEM_CODE) AND ( SJB_BGDMXB.REP_NO = ? ) AND ( ltrim(SJB_BGDMXB.result) <> '') AND ( DMB_XM.P_FLAG <> 'F' ) AND ( SJB_BGD.SAMP_CODE = DMB_BB.SAMP_CODE) AND ( SJB_BGD.SAMP_STATUS *= DMB_BBZT.STATUS)"; parm3 = lisSvc.CreateParm(1); parm3[0].Value = reqNo; dt = svcOn.GetDataTable(Sql, parm3); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { #region //"3-II.艾滋病病毒感染孕产妇妊娠及所生婴儿登记卡" if (formId == 11) { EntityAidsCheck vo = new EntityAidsCheck(); vo.REQNO = reqNo; //申请单号 vo.YZ = yz; //孕周 vo.count = count; //白细胞计数 if (dr["item_code"].ToString() == "1221" || dr["item_code"].ToString() == "1055" || dr["item_code"].ToString() == "1351") { vo.BXBJS = dr["result"].ToString(); } //总淋巴细胞计数 if (dr["item_code"].ToString() == "1068") { vo.ZLBXBJS = dr["result"].ToString(); } //血小板计数 if (dr["item_code"].ToString() == "1369") { vo.XXBJS = dr["result"].ToString(); } //血红蛋白 if (dr["item_code"].ToString() == "1363") { vo.XHDB = dr["result"].ToString(); } //血糖 if (dr["item_code"].ToString() == "2713") { vo.XT = dr["result"].ToString(); } //谷丙转氨酶 if (dr["item_code"].ToString() == "3045") { vo.GBZAM = dr["result"].ToString(); } //谷草转氨酶 if (dr["item_code"].ToString() == "2002") { vo.GCZAM = dr["result"].ToString(); } //总胆红素 if (dr["item_code"].ToString() == "2008") { vo.ZDHS = dr["result"].ToString(); } //肌酐 if (dr["item_code"].ToString() == "2021") { vo.XJG = dr["result"].ToString(); } //尿素氮 if (dr["item_code"].ToString() == "2020") { vo.XNST = dr["result"].ToString(); } //梅毒螺旋体抗原血清学实验(TPPA/ELISA) if (dr["item_code"].ToString() == "3012") { vo.MD_TPPA_ELISA = dr["result"].ToString(); } //非梅毒螺旋体抗原血清学实验(RPR、TRUST) if (dr["item_code"].ToString() == "2339") { vo.MD_RPR_TRUST = dr["result"].ToString(); } //梅毒滴度 vo.iDD = -1; if (dr["item_code"].ToString() == "3206") { string result = dr["result"].ToString().Trim(); if (result.Contains(":")) { vo.iDD = Function.Int(result.Split(':')[1]); } } //乙肝表面抗原(HBsAg) if (dr["item_code"].ToString() == "2401" || dr["item_code"].ToString() == "3001" || dr["item_code"].ToString() == "2721") { vo.HBsAg = dr["result"].ToString(); } //乙肝e抗原(HBeAg) if (dr["item_code"].ToString() == "2723" || dr["item_code"].ToString() == "3003") { vo.HBeAg = dr["result"].ToString(); } // 丙肝抗体检测(HCV)-IgG if (dr["item_code"].ToString() == "3008") { vo.HCV_IGG = dr["result"].ToString(); } lstVo.Add(vo); } else if (formId == 15) //4-I梅毒感染孕产妇登记卡 { EntityAidsCheck vo = new EntityAidsCheck(); vo.REQNO = reqNo; //申请单号 vo.YZ = yz; //孕周 #region 4-I // 4——I //快速血浆反应素环状片试验(RPR)X133 //阴性X134 //阳性X135 //检测时间X137 vo.I_RPR = ""; vo.I_RPRTIME = ""; //甲苯胺红不加热血清试验(TRUST)X138 //阴性X139 //阳性X140 //检测时间X142 if (dr["item_code"].ToString() == "2399") { vo.I_TRUST = dr["result"].ToString(); } vo.I_TRUSTTIME = ""; //梅毒螺旋体颗粒凝集试验(TPPA)X145 //阴性X146 //阳性X147 //检测时间X149 if (dr["item_code"].ToString() == "3012") { vo.I_TPPA = dr["result"].ToString(); } vo.I_TPPATIME = ""; //酶联免疫吸附试验(ELISA)X150 //阴性X151 //阳性X152 //检测时间X154 vo.I_ELISA = ""; vo.I_ELISATIME = ""; //免疫层析法-快速体测(RT)X155 //阴性X156 //阳性X157 //检测时间X159 vo.I_RT = ""; vo.I_RTTIME = ""; //梅毒螺旋体IgM抗体检测: //未检测X166 //检测阳性X167 //检测阴性X168 //检测时间X169 vo.I_IGM = ""; vo.I_IGMTIME = ""; //暗视野显微镜梅毒螺旋体检测: //未检测X170 //检测X171 //(检测到梅毒螺旋体: //否X172 //是X173 //检测时间X174 vo.I_MD = ""; vo.I_MDTIME = ""; #endregion } #endregion } } } } catch (Exception e) { ExceptionLog.OutPutException(e); } finally { svc = null; } return(lstVo); }