protected void btnSave_Click(object sender, EventArgs e) { if (txtNewPWD.Text.Trim() != txtConfirmNewPWD.Text.Trim()) { LiteralMsg.Text = "修改密码和确认密码不一致!"; LiteralMsg.DataBind(); return; } else { XTHospital.BLL.BLL_Employee bll = new XTHospital.BLL.BLL_Employee(); XTHospital.Model.Employee model = new XTHospital.Model.Employee(); model.UPDATER_ID = Session["LoginUserID"].ToString(); model.TERMINAL_CD=""; model.EmployeePWD = txtOldPWD.Text.Trim(); model.EmployeeNewPWD=txtConfirmNewPWD.Text.Trim(); model.EmployeeEmail=txtMail.Text.Trim(); model.EmployeePhone=txtEmployeePhone.Text.Trim(); model.EmployeeID = Session["EmployeeID"].ToString(); XTHospital.COM.ReturnValue resoult = bll.ChangePassWord(model); if (!resoult.ErrorFlag) { LiteralMsg.Text = resoult.ErrorID; LiteralMsg.DataBind(); return; } else { LiteralMsg.Text = "修改成功!"; Session["EmployeeMail"] = txtMail.Text.Trim(); ; Session["EmployeePhone"] = txtEmployeePhone.Text.Trim(); LiteralMsg.DataBind(); return; } } }
private void ShowData(string LoginUserID, string YearMonth) { XTHospital.BLL.BLL_Employee bll = new XTHospital.BLL.BLL_Employee(); XTHospital.COM.ReturnValue resoult = bll.SearchMyInfo(LoginUserID, YearMonth); if (resoult.ErrorFlag) { if (resoult.Count > 0) { #region **********概要信息***************** strName = resoult.ResultDataSet.Tables[0].Rows[0]["Emp_EmployeeName"].ToString();//姓名 strEmployeeGZID = resoult.ResultDataSet.Tables[0].Rows[0]["Emp_EmployeeGZID"].ToString(); ;//工资编号 strEmployeeID = resoult.ResultDataSet.Tables[0].Rows[0]["Emp_EmployeeID"].ToString();//员工身份证 string strSexTemp = resoult.ResultDataSet.Tables[0].Rows[0]["Emp_EmployeeSex"].ToString();//性别 if (strSexTemp == "0") { strSex = "男"; } else if (strSexTemp == "1") { strSex = "女"; } else { strSex = ""; } string strBirthdayTemp = resoult.ResultDataSet.Tables[0].Rows[0]["Emp_EmployeeBirthday"].ToString();//出生年月 if (strBirthdayTemp.Length > 0) { strBirthday = strBirthdayTemp.Substring(0, 4) + "-" + strBirthdayTemp.Substring(4, 2) + "-" + strBirthdayTemp.Substring(6, 2); } strAge = GetAge(DateTime.Parse(strBirthday)).ToString(); strEmployeeWHCD = resoult.ResultDataSet.Tables[0].Rows[0]["Emp_EmployeeWHCD"].ToString();//文化程度 string strHFTemp = resoult.ResultDataSet.Tables[0].Rows[0]["Emp_EmployeeHF"].ToString();//婚否 if (strHFTemp == "0") { strHF = "未婚"; } else if (strHFTemp == "1") { strHF = "已婚"; } else if (strHFTemp == "2") { strHF = "离异"; } else { strHF = ""; } strJG = resoult.ResultDataSet.Tables[0].Rows[0]["Emp_EmployeeJG"].ToString();//籍贯 strXJD = resoult.ResultDataSet.Tables[0].Rows[0]["Emp_EmployeeXJD"].ToString();//现住地 strBM = resoult.ResultDataSet.Tables[0].Rows[0]["Emp_EmployeeBM"].ToString();//部门 strDW = resoult.ResultDataSet.Tables[0].Rows[0]["Emp_EmployeeDW"].ToString();//单位 strJWBS = resoult.ResultDataSet.Tables[0].Rows[0]["Emp_EmployeeJWBS"].ToString();//既往病史 strEmail = resoult.ResultDataSet.Tables[0].Rows[0]["EmployeeEmail"].ToString();//Email strEmployeePhone = resoult.ResultDataSet.Tables[0].Rows[0]["EmployeePhone"].ToString();//联系电话 #endregion #region **********生化检验单***************** strHY_No = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYNo"].ToString();//化验号 strHY_Dr = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYDr"].ToString();//医师 strHY_TC = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYTC"].ToString();//总胆固醇(TC) strHY_TG = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYTG"].ToString();//甘油三脂(TG) strHY_HDL_C = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYHDLC"].ToString();//高密度脂蛋白胆固醇(HDL-C) strHY_TBIL = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYTBIL"].ToString();//总胆红素(TBIL) strHY_DBIL = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYDBIL"].ToString();//直接胆红素(DBIL) strHY_TP = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYTP"].ToString();//总蛋白(TP) strHY_ALB = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYALB"].ToString();//白蛋白(ALB) strHY_ALT = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYALT"].ToString();//谷丙转氨酶(ALT) strGLU = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HY_GLU"].ToString();//血糖 strUREA = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HY_UREA"].ToString();//尿素 strCR = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HY_CR"].ToString();//肌酐 strAFP = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HY_AFP"].ToString();//甲胎蛋白 strCEA = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HY_CEA"].ToString();//癌胚抗原 strHYLDLC = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYLDLC"].ToString();//低密度脂蛋白胆固醇(LDL-C) strHYAPOAI = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYAPOAI"].ToString();//载脂蛋白AI(APOAI) strHYAPOB = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYAPOB"].ToString();//载脂蛋白B(APOB) strHYAST = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYAST"].ToString();//天门冬氨酸氨基转移酶(AST) strHYGT = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYGT"].ToString();//γ-谷胺酰转肽酶(γ-GT) strHYALP = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYALP"].ToString();//碱性磷酸酶(ALP) strHYUA = resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYUA"].ToString();//尿酸(UA) if (resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYHBsAg"].ToString() == "0")//HBsAg { strHBsAg = "-"; } else if (resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYHBsAg"].ToString() == "1")//HBsAg { strHBsAg = "+"; } else { strHBsAg = ""; } if (resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYHBsAb"].ToString() == "0")//HBsAb { strHBsAb = "-"; } else if (resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYHBsAb"].ToString() == "1")//HBsAb { strHBsAb = "+"; } else { strHBsAb = ""; } if (resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYHBeAg"].ToString() == "0")//HBeAg { strHBeAg = "-"; } else if (resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYHBeAg"].ToString() == "1")//HBeAg { strHBeAg = "+"; } else { strHBeAg = ""; } if (resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYHBeAb"].ToString() == "0")//HBeAb { strHBeAb = "-"; } else if (resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYHBeAb"].ToString() == "1")//HBeAb { strHBeAb = "+"; } else { strHBeAb = ""; } if (resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYHBcAb"].ToString() == "0")//HBcAb { strHBcAb = "-"; } else if (resoult.ResultDataSet.Tables[0].Rows[0]["Bio_HYHBcAb"].ToString() == "1")//HBcAb { strHBcAb = "+"; } else { strHBcAb = ""; } #endregion #region **********体格检查(五官)***************** strLeftEye = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_LeftEye"].ToString();//视力左 strRightEye = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_RightEye"].ToString();//视力右 strCorrectedLeft = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_CorrectedLeft"].ToString();//矫正视力左 strCorrectedRight = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_CorrectedRight"].ToString();//矫正视力右 strColorVisionForce = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_ColorVisionForce"].ToString();//辨色力 strTrachomaLeft = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_TrachomaLeft"].ToString();//沙眼左 strTrachomaRight = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_TrachomaRight"].ToString();//沙眼右 strOtherEye = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_OtherEye"].ToString();//眼其他 strListeningLeft = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_ListeningLeft"].ToString();//听力左 strListeningRight = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_ListeningRight"].ToString();//听力右 strEar = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_Ear"].ToString();//耳疾 strOlfactory = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_Olfactory"].ToString();//嗅觉 strNoseParanasalSinusDisease = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_NoseParanasalSinusDisease"].ToString();//鼻及鼻窦疾病 strThroat = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_Throat"].ToString();//咽喉 strLipPalate = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_LipPalate"].ToString();//唇腭 strStuttering = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_Stuttering"].ToString();//口吃 strCaries = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_Caries"].ToString();//龋齿 strMissingTeeth = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_MissingTeeth"].ToString();//缺齿 strPeriodontalDisease = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_PeriodontalDisease"].ToString();//牙周病 strFeaturesOther = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_Other"].ToString();//其他 strMedicalAdvice = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_MedicalAdvice"].ToString();//医生意见 strFeaturesPhysicians = resoult.ResultDataSet.Tables[0].Rows[0]["Fea_Physicians"].ToString();//医师 #endregion #region **********体格检查(外科)***************** strLength = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Length"].ToString();//身长 strBust = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Bust"].ToString();//胸围 strWeight = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Weight"].ToString();//体重 strBadBreath = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_BadBreath"].ToString();//呼吸差 strSkin = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Skin"].ToString();//皮肤 strLymphoid = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Lymphoid"].ToString();//淋巴 strThyroid = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Thyroid"].ToString();//甲状腺 strSpine = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Spine"].ToString();//脊柱 strLimbs = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Limbs"].ToString();//四肢 strJoint = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Joint"].ToString();//关节 strFlatfoot = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Flatfoot"].ToString();//扁平足 strGenitourinary = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Genitourinary"].ToString();//泌尿生殖器 strAnal = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Anal"].ToString();//肛门 strHernia = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Hernia"].ToString();//疝 strSurgeryOther = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Other"].ToString();//其他 strSurgeryMedicalAdvice = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_MedicalAdvice"].ToString();//医生意见 strSurgeryPhysicians = resoult.ResultDataSet.Tables[0].Rows[0]["Sur_Physicians"].ToString();//医师 #endregion #region **********体格检查(内科)***************** strBloodPressure = resoult.ResultDataSet.Tables[0].Rows[0]["Int_BloodPressure"].ToString();//血压 strBloodPressure1 = resoult.ResultDataSet.Tables[0].Rows[0]["Int_BloodPressure1"].ToString();//血压 strDevelopmentStatus = resoult.ResultDataSet.Tables[0].Rows[0]["Int_DevelopmentStatus"].ToString();//发育及营养状况 strNeurological = resoult.ResultDataSet.Tables[0].Rows[0]["Int_Neurological"].ToString();//神经及精神 strLung = resoult.ResultDataSet.Tables[0].Rows[0]["Int_Lung"].ToString();//肺及呼吸道 strHeartBlood = resoult.ResultDataSet.Tables[0].Rows[0]["Int_HeartBlood"].ToString();//心脏及血管 strAbdominalOrgans = resoult.ResultDataSet.Tables[0].Rows[0]["Int_AbdominalOrgans"].ToString();//腹部器官 strLiver = resoult.ResultDataSet.Tables[0].Rows[0]["Int_Liver"].ToString();//肝 strSpleen = resoult.ResultDataSet.Tables[0].Rows[0]["Int_Spleen"].ToString();//脾 strInternalMedicineOther = resoult.ResultDataSet.Tables[0].Rows[0]["Int_Other"].ToString();//其他 strInternalMedicineMedicalAdvice = resoult.ResultDataSet.Tables[0].Rows[0]["Int_MedicalAdvice"].ToString();//医生意见 strInternalMedicinePhysicians = resoult.ResultDataSet.Tables[0].Rows[0]["Int_Physicians"].ToString();//医师 #endregion #region **********心电图检查***************** strECGNo = resoult.ResultDataSet.Tables[0].Rows[0]["ECT_No"].ToString();//心电图号 strClinicalDiagnosis = resoult.ResultDataSet.Tables[0].Rows[0]["ECT_ClinicalDiagnosis"].ToString();//临床诊断 strUsedDrugs = resoult.ResultDataSet.Tables[0].Rows[0]["ECT_UsedDrugs"].ToString();//曾用药物 strSummaryHistory = resoult.ResultDataSet.Tables[0].Rows[0]["ECT_SummaryHistory"].ToString();//病史概要 strSummaryBody = resoult.ResultDataSet.Tables[0].Rows[0]["ECT_SummaryBody"].ToString();//查体概要 strPatientSituation = resoult.ResultDataSet.Tables[0].Rows[0]["ECT_PatientSituation"].ToString();//病人状况 if (strPatientSituation == "1") { strPatientSituation = "卧床"; } else if (strPatientSituation == "2") { strPatientSituation = "能走"; } else { strPatientSituation = ""; } txtECGMedicalAdvice = resoult.ResultDataSet.Tables[0].Rows[0]["ECT_MedicalAdvice"].ToString();//诊断意见 //if (resoult.ResultDataSet.Tables[0].Rows[0]["ECT_Image"] != DBNull.Value) //{ // MemoryStream msECG = new MemoryStream((byte[])resoult.ResultDataSet.Tables[0].Rows[0]["ECT_Image"]); // Image imageECG = Image.FromStream(msECG, true); // this.picECG.Image = imageECG; //} //else //{ // this.picECG.Image = null; //} strECGPhysicians = resoult.ResultDataSet.Tables[0].Rows[0]["ECT_Physicians"].ToString();//医师 #endregion #region **********X线检查***************** strPhotoNo = resoult.ResultDataSet.Tables[0].Rows[0]["Xray_PhotoNo"].ToString();//摄影号 strSymptoms = resoult.ResultDataSet.Tables[0].Rows[0]["Xray_Symptoms"].ToString();//主要症状 strLaboratory = resoult.ResultDataSet.Tables[0].Rows[0]["Xray_Laboratory"].ToString();//体征及化验检查 strDiagnosis = resoult.ResultDataSet.Tables[0].Rows[0]["Xray_Diagnosis"].ToString();//临床预诊 strPerspective = resoult.ResultDataSet.Tables[0].Rows[0]["Xray_Perspective"].ToString();//透视部位及目的 strCamera = resoult.ResultDataSet.Tables[0].Rows[0]["Xray_Camera"].ToString();//照相部位及目的 strXRayResults = resoult.ResultDataSet.Tables[0].Rows[0]["Xray_Results"].ToString();//透视检查结果 //if (resoult.ResultDataSet.Tables[0].Rows[0]["Xray_XImage"] != DBNull.Value) //{ // MemoryStream msXray = new MemoryStream((byte[])resoult.ResultDataSet.Tables[0].Rows[0]["Xray_XImage"]); // Image imageXray = Image.FromStream(msXray, true); // this.picXImage.Image = imageXray; //} //else //{ // this.picXImage.Image = null; //} strXRayPhysicians = resoult.ResultDataSet.Tables[0].Rows[0]["Xray_Physicians"].ToString();//医师 #endregion #region **********B超检查***************** strBID = resoult.ResultDataSet.Tables[0].Rows[0]["Bex_BID"].ToString();//B超编号 strHistorySigns = resoult.ResultDataSet.Tables[0].Rows[0]["Bex_HistorySigns"].ToString();//病史及体征 strLaboratoryExamination = resoult.ResultDataSet.Tables[0].Rows[0]["Bex_LaboratoryExamination"].ToString();//化验检查 strBDiagnosis = resoult.ResultDataSet.Tables[0].Rows[0]["Bex_Diagnosis"].ToString();//临床预诊 strPurpose = resoult.ResultDataSet.Tables[0].Rows[0]["Bex_Purpose"].ToString();//检查目的和部位 strBResults = resoult.ResultDataSet.Tables[0].Rows[0]["Bex_Results"].ToString();//检查结果 //if (resoult.ResultDataSet.Tables[0].Rows[0]["Bex_BImage"] != DBNull.Value) //{ // MemoryStream msBex = new MemoryStream((byte[])resoult.ResultDataSet.Tables[0].Rows[0]["Bex_BImage"]); // Image imageBex = Image.FromStream(msBex, true); // this.picBImage.Image = imageBex; //} //else //{ // this.picBImage.Image = null; //} strBPhysicians = resoult.ResultDataSet.Tables[0].Rows[0]["Bex_Physicians"].ToString();//医师 #endregion #region **********妇科检查***************** if (strSexTemp == "1") { E006.Visible = true; strFeme_Menarche = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_Menarche"].ToString();//月经初潮 strFeme_MenopauseAge = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_MenopauseAge"].ToString();//绝经年龄 string strMenstrualCycleTemp = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_MenstrualCycle"].ToString();//周期 MenstrualCycle if (strMenstrualCycleTemp.Trim() == "0") { strFeme_MenstrualCycle = "规律"; } else if (strMenstrualCycleTemp.Trim() == "1") { strFeme_MenstrualCycle = "不规律"; } else { strFeme_MenstrualCycle = ""; } string strMenstrualVolumeTemp = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_MenstrualVolume"].ToString();//量 MenstrualVolume if (strMenstrualVolumeTemp.Trim() == "0") { strFeme_MenstrualVolume = "多"; } else if (strMenstrualVolumeTemp.Trim() == "1") { strFeme_MenstrualVolume = "中"; } else if (strMenstrualVolumeTemp.Trim() == "2") { strFeme_MenstrualVolume = "少"; } else { strFeme_MenstrualVolume = ""; } string strDysmenorrheaTemp = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_Dysmenorrhea"].ToString();//痛经 Dysmenorrhea if (strDysmenorrheaTemp.Trim() == "0") { strFeme_Dysmenorrhea = "无"; } else if (strDysmenorrheaTemp.Trim() == "1") { strFeme_Dysmenorrhea = "轻"; } else if (strDysmenorrheaTemp.Trim() == "2") { strFeme_Dysmenorrhea = "重"; } else { strFeme_Dysmenorrhea = ""; } strFeme_DiseaseHistory = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_DiseaseHistory"].ToString();//病史 DiseaseHistory string strFamilyTumorTistoryTemp = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_FamilyTumorTistory"].ToString();//病史家庭肿瘤史 FamilyTumorTistory if (strFamilyTumorTistoryTemp.Trim() == "0") { strFeme_FamilyTumorTistory = "无"; } else if (strFamilyTumorTistoryTemp.Trim() == "1") { strFeme_FamilyTumorTistory = "有"; } else { strFeme_FamilyTumorTistory = ""; } strFeme_DiseaseHistoryOther = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_DiseaseHistoryOther"].ToString();//病史其他 string strAndrogenUsedTemp = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_AndrogenUsed"].ToString();//曾用雄性激素 AndrogenUsed if (strAndrogenUsedTemp.Trim() == "0") { strFeme_AndrogenUsed = "无"; } else if (strAndrogenUsedTemp.Trim() == "1") { strFeme_AndrogenUsed = "短期"; } else if (strAndrogenUsedTemp.Trim() == "2") { strFeme_AndrogenUsed = "长期"; } else { strFeme_AndrogenUsed = ""; } string strEstrogenUsedTemp = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_EstrogenUsed"].ToString();//曾用雌性激素 EstrogenUsed if (strEstrogenUsedTemp.Trim() == "0") { strFeme_EstrogenUsed = "无"; } else if (strEstrogenUsedTemp.Trim() == "1") { strFeme_EstrogenUsed = "短期"; } else if (strEstrogenUsedTemp.Trim() == "2") { strFeme_EstrogenUsed = "长期"; } else { strFeme_EstrogenUsed = ""; } strFeme_Cervical = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_Cervical"].ToString();//宫颈 Cervical strFeme_Uterine = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_Uterine"].ToString();//子宫 Uterine strFeme_Genital = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_Genital"].ToString();//外阴 Genital strFeme_Leucorrhea = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_Leucorrhea"].ToString();//白带 Leucorrhea strFeme_Vaginal = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_Vaginal"].ToString();//阴道 Vaginal strFeme_AnnexLeft = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_AnnexLeft"].ToString();//附件左 AnnexLeft strFeme_AnnexRight = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_AnnexRight"].ToString();//附件右 AnnexRight strFeme_CheckCases = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_CheckCases"].ToString();//病例检查 strFeme_InfraredScanBreast = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_InfraredScanBreast"].ToString();//乳腺红外线扫描 strFeme_Conclusion = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_Conclusion"].ToString();//结论 strFeme_Physicians = resoult.ResultDataSet.Tables[0].Rows[0]["Feme_Physicians"].ToString();//医师 } else { E006.Visible = false; } #endregion #region //**********体成分***************** string FatType = resoult.ResultDataSet.Tables[0].Rows[0]["BodyComposi_FatType"].ToString(); string FatEvaluate = resoult.ResultDataSet.Tables[0].Rows[0]["BodyComposi_FatEvaluate"].ToString(); //1:皮下型 2:内脏型 switch (FatType) { case "1": strFatType = "皮下型"; break; case "2": strFatType = "内脏型"; break; } //1:很瘦 2:偏瘦 3:标准 4:低脂肪肌肉型 5:超重 6:肌肉型 7:脂肪过多型 8:肥胖 9:严重肥胖 switch (FatEvaluate) { case "1": strFatEvaluate = "很瘦"; break; case "2": strFatEvaluate = "偏瘦"; break; case "3": strFatEvaluate = "标准"; break; case "4": strFatEvaluate = "低脂肪肌肉型"; break; case "5": strFatEvaluate = "超重"; break; case "6": strFatEvaluate = "肌肉型"; break; case "7": strFatEvaluate = "脂肪过多型"; break; case "8": strFatEvaluate = "肥胖"; break; case "9": strFatEvaluate = "严重肥胖"; break; } strFatTarget = resoult.ResultDataSet.Tables[0].Rows[0]["BodyComposi_FatTarget"].ToString(); strMuscleTarget = resoult.ResultDataSet.Tables[0].Rows[0]["BodyComposi_MuscleTarget"].ToString(); strBodyWeightTarget = resoult.ResultDataSet.Tables[0].Rows[0]["BodyComposi_BodyWeightTarget"].ToString(); strCompositionPhysicians = resoult.ResultDataSet.Tables[0].Rows[0]["BodyComposi_Physicians"].ToString(); #endregion #region **********报告***************** strChestPerspective = resoult.ResultDataSet.Tables[0].Rows[0]["ChestPerspective"].ToString();//(胸部透视)体检结论 //strReportLaboratory = resoult.ResultDataSet.Tables[0].Rows[0]["Laboratory"].ToString();//化验(肝功、乙肝系列) strReview = resoult.ResultDataSet.Tables[0].Rows[0]["Review"].ToString();//(审查单位意见)建议 strRemarks = resoult.ResultDataSet.Tables[0].Rows[0]["Remarks"].ToString();//备注 #endregion XTHospital.BLL.BLL_Log.AddLog("查询用户[" + strName + "]进行了体检信息的查询.", "1", Page.Request.UserHostAddress);//添加日志 } } }
private void ShowBioTData() { XTHospital.BLL.BLL_Employee bll = new XTHospital.BLL.BLL_Employee(); XTHospital.COM.ReturnValue resoult = bll.SearchBioTInfo(); if (resoult.ErrorFlag) { if (resoult.Count > 0) { //参考值 T_HY_TC = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYTC"].ToString();//总胆固醇(TC) T_HY_TG = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYTG"].ToString();//甘油三脂(TG) T_HY_HDL_C = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYHDLC"].ToString();//高密度脂蛋白胆固醇(HDL-C) T_HY_TBIL = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYTBIL"].ToString();//总胆红素(TBIL) T_HY_DBIL = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYDBIL"].ToString();//直接胆红素(DBIL) T_HY_TP = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYTP"].ToString();//总蛋白(TP) T_HY_ALB = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYALB"].ToString();//白蛋白(ALB) T_HY_ALT = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYALT"].ToString();//谷丙转氨酶(ALT) T_GLU = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HY_GLU"].ToString();//血糖 T_UREA = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HY_UREA"].ToString();//尿素 T_CR = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HY_CR"].ToString();//肌酐 T_AFP = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HY_AFP"].ToString();//甲胎蛋白 T_CEA = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HY_CEA"].ToString();//癌胚抗原 T_HYLDLC = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYLDLC"].ToString();//低密度脂蛋白胆固醇(LDL-C) T_HYAPOAI = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYAPOAI"].ToString();//载脂蛋白AI(APOAI) T_HYAPOB = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYAPOB"].ToString();//载脂蛋白B(APOB) T_HYAST = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYAST"].ToString();//天门冬氨酸氨基转移酶(AST) T_HYGT = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYGT"].ToString();//γ-谷胺酰转肽酶(γ-GT) T_HYALP = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYALP"].ToString();//碱性磷酸酶(ALP) T_HYUA = resoult.ResultDataSet.Tables[0].Rows[0]["_Bio_HYUA"].ToString();//尿酸(UA) } } }
public ReturnValue SearchMyInfo(string EmployeeGZID, string YearMonth) { BLL_Employee bll = new BLL_Employee(); return bll.SearchMyInfo(EmployeeGZID, YearMonth); }
public ReturnValue SearchEmployeeAllInfo(string EmployeeID, string YearMoth) { BLL_Employee bll = new BLL_Employee(); return bll.SearchAllInfo(EmployeeID, YearMoth); }
public ReturnValue AddEmployee(Employee model) { BLL_Employee bll = new BLL_Employee(); return bll.AddUpdate(model); }
public ReturnValue GetListEmployee(string strWhere) { BLL_Employee bll = new BLL_Employee(); return bll.GetList(strWhere); }
public ReturnValue GetEmployeeInfo(string EmployeeID) { BLL_Employee bll = new BLL_Employee(); return bll.GetEmployeeInfo(EmployeeID); }
public ReturnValue GetCheckEmployeeNum(string YearMonth, string EmployeeName, string EmployeeBM) { BLL_Employee bll = new BLL_Employee(); return bll.GetCheckEmployeeNum(YearMonth, EmployeeName, EmployeeBM); }
public ReturnValue GetBioTInfo() { BLL_Employee bll = new BLL_Employee(); return bll.SearchBioTInfo(); }
public ReturnValue ChangePassWord(Employee model) { BLL_Employee bll = new BLL_Employee(); return bll.ChangePassWord(model); }